Everything about Corruption: C3C edition - Page 4

Solomwi · January 18, 2005, 18:13

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 · January 18, 2005, 19:00

Doh. Guess it helps if I attach the file.

Solomwi · January 18, 2005, 21:19

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

SirOsis · January 19, 2005, 19:41

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 · January 19, 2005, 21:05

Yes

SirOsis · January 19, 2005, 21:30

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 · January 19, 2005, 21:32

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 · January 20, 2005, 01:16

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 · January 20, 2005, 01:32

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 · January 23, 2005, 00:29

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 · January 23, 2005, 01:42

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

Solomwi · January 23, 2005, 02:05

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 · January 23, 2005, 02:11

And Sid is added.

Geronimo · February 4, 2005, 03:08

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 · February 5, 2005, 13:21

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.

Solomwi · February 5, 2005, 13:34

Okay, a question for alexman, or anybody else who knows. Does the Palace count as a corruption-reducing improvement, corruption-reducing wonder, or none of the above?

Obviously, under a non-communal government, this isn't much of an issue, and I'm almost positive that it doesn't count as a corruption-reducing wonder. Under communism, however, this will come into play.

joncnunn · February 5, 2005, 15:05

Palace counts as a corruption-reudcing wonder as I recall from the commie players.

Solomwi · February 6, 2005, 02:23

I don't think so. I just ran my current game over to communism, and my capitol kept zero corruption, even though all it has is a police station and the palace, which should give it 10% corruption. Also, my core cities were at 50% corruption, which fits with only one corruption-reducing wonder in the empire (FP).

I'm inclined to believe that the palace still functions as "Center of Empire" when it comes to the capital itself, but doesn't do anything to affect corruption in the other cities.

alexman · February 7, 2005, 14:14

Quote:

I'm inclined to believe that the palace still functions as "Center of Empire" when it comes to the capital itself, but doesn't do anything to affect corruption in the other cities.

It affects distance corruption in other cities, just like a FP, of course, and it obviously affects rank corruption because all ranks are based on the distance from the Palace. I'm sure you knew that already, just making it clear because it contradicts your post above.

You are right that the empire does not get an extra OCN bonus because of the Palace, since it does not count as a corruption-reducing improvement or Wonder. When in doubt, look in the editor. The Palace doesn't have a check in the boxes like a courthouse and a FP.

Very cool spreadsheet, by the way.

joncnunn · February 7, 2005, 16:08

That is max allowed corruption. If the corruption formula results in a lower number than max allowed, you get that lower number.

Quote:

Originally posted by Solomwi
I don't think so. I just ran my current game over to communism, and my capitol kept zero corruption, even though all it has is a police station and the palace, which should give it 10% corruption. Also, my core cities were at 50% corruption, which fits with only one corruption-reducing wonder in the empire (FP).

I'm inclined to believe that the palace still functions as "Center of Empire" when it comes to the capital itself, but doesn't do anything to affect corruption in the other cities.

Solomwi · February 7, 2005, 21:18

Quote:

Originally posted by alexman

It affects distance corruption in other cities, just like a FP, of course, and it obviously affects rank corruption because all ranks are based on the distance from the Palace. I'm sure you knew that already, just making it clear because it contradicts your post above.

Is it still based off the palace under communism? I thought distance was based strictly of map size and rank strictly off number of cities under communal governments. Sorry if the context wasn't clear, but communal is all I was curious about. I'm up on how it works under non-communal.

Quote:

You are right that the empire does not get an extra OCN bonus because of the Palace, since it does not count as a corruption-reducing improvement or Wonder. When in doubt, look in the editor. The Palace doesn't have a check in the boxes like a courthouse and a FP.

Thanks, that's what I was looking for. The only problem with looking in the editor (which I did

) is that it didn't answer the question of whether or not the effects of corruption-reducing wonder/improvement are also written into the "Center of Empire" checkbox.

Quote:

Very cool spreadsheet, by the way.

Excellent, glad to know it's helpful to more than just me.

Quote:

That is max allowed corruption. If the corruption formula results in a lower number than max allowed, you get that lower number.

Naturally. What I was saying is the 10% should apply if the palace were a corruption-reducing wonder, as in this case, corruption in the capital under a communal government works out to over 50% through the formula. With one CRI and one CRW, corruption in the city should be 10%. It's zero, leading me to believe, as alexman has since clarified, that the palace doesn't count as a CRW, either for the capital or the empire as a whole.

E_T · June 24, 2005, 01:24

I can't get the attachments to download

E_T