Everything about Corruption: C3C edition

[Solomwi]

Okay, that wasn't as hard as I had thought it might be. See how you like it now.

• Inserted formula to calculate rank - It's up to you to get your cities in the right order, but that can easily be done by sorting them by distance to the palace and founding date
• Added columns for x and y with respect to the FP
• Added column so that distance to palace and distance to FP are side by side
• Fixed da formula to take lesser of dp and df, unless df is zero - Obviously, putting in data with respect to the palace is mandatory, but you can leave off the FP data for cities you know are closer to the palace without a problem.

[Solomwi]

Doh. Guess it helps if I attach the file.

[Solomwi]

The above file has the dropdown problems again, but I now know what causes it. This one, hopefully, should have everything fixed.

[SirOsis]

This is great thanks. I'm having one final problem with figuring things out. How do I enter in the data for the city with the FP? Unless I mark Ni=1 corruption and waste do not match what I see in game. Is distance corruption 0 in the city where the FP is built?

[Aqualung71]

Yes

[SirOsis]

Hmmmm... Then something isn't right. I cannot get the FP city to come out with the correct corruption and waste.

How do you fill out the sheet for a city with the FP?

[Aqualung71]

The FP city still suffers normal rank corruption, but overall corruption and waste is limited to a maximum of 20%.....reduced to 10% if a Courthouse is also present.

Though I am quoting all this from memory, and I haven't read alexman's original treatise lately

[Solomwi]

The column labeled N_wc is for Corruption Wonders in the city. Mark it 1 for the FP city, and everything else should take care of itself.

The distance corruption is still going to show the distance as if it were measured from the palace (because I don't want to put one more if statement in the formula for just one city), but the overall corruption should be correct, because of the corruption ceiling of 0.9-(0.7*N_wc+0.1*N_i).

[Solomwi]

For the case where your FP is close enough to the palace for the ceiling not to come into play just yet, you can always force d_p to zero by just entering zero for x_p and y_p, too.

[Solomwi]

Okay, I got a little industrious last night and added a few bells and whistles to this thing. There's now a page to calculate the beaker cost of a tech, based on map size, base cost, difficulty, number of civs you know that have the tech and number of civs in the game.

There's also a city site planner that I don't think has been in the other versions. All the terrain types and values are already in there, so all you have to do is tell it what's there and your government, and it'll give you the 21-tile potential of the city (or less, if you leave some "tiles" blank).

As usual, I'm pretty lazy on double checking any potential bugs, so let me know if you find any, and hope this is helpful to you.

[vmxa1]

I did not see Sid on the tech chart selection, it had Demi and Deity.

[Solomwi]

You're right. I noticed that today, and plan on fixing it either tonight or tomorrow.

Guess since I was making it originally for my own use, I didn't see the need for Sid.

Edit: Now that I see it was in the corruption formulae and listed on the tech page, looks like just an oversight on my part. Thanks for the heads up.

[Solomwi]

And Sid is added.

[Geronimo]

If I'm reading this correctly, rank corruption is uneffected by use of a communal form of government? In that case would the communal corruption advantage disappear once a civ was so far above the OCN that the vast majority of the cities would be up against the max 90 percent corruption ceiling through rank corruption alone?

in other words on a huge map once you have conquered a few rival continents and are getting near the 40 percent of total land area level it's not really going to matter much whether you are communal or capitol-centered because rank corruption will totally mask any changes in distance corruption.

right?

[Solomwi]

Thanks for that post, Geronimo. I'll try to play with some numbers and answer your question, but it made me revisit communal rank corruption and discover an error I needed to fix in my spreadsheet.

Changes:
Altered formula for city rank (R) to count number of cities, divide by 2 and round down if government is communal. For any other government, everything remains unchanged.

This thing's turning into a beautiful example of "good enough" design, sorry, folks.