INFO: CivStats - Excel file with summaries of Civ III data

[kokomo]

Hey... really useful and handy... nice work!

[Crom]

Nice work, you've made my life a lot easier. Thanks.

[Nero Would]

New version - 1.16

I edited the first post to include version 1.16 of the file. It matches the 1.16 patch and adds some new tables.

[macaday]

Thanks. Good job, I appreciate it.

--mac

[Hurry]

Some questions. In the file (Rules-sheet), you write:

"Each content face makes 1 unhappy citizen content."

???

City is in Civil Disorder if there are more unhappy citizens than happy ones. For each turn in Civil Disorder, there is a 20% chance of riots.

Shouldn´t this read ...For each turn after the first of Civil Disorder...

Also, you could make the rule about retreats a bit more complete by adding that a fast unit with 1 HP left will not retreat if the defender also has only 1 HP.

[Nero Would]

Originally posted by Hurry
Some questions. In the file (Rules-sheet), you write:

"Each content face makes 1 unhappy citizen content."

???

I'm note sure exactly what you're questioning, so I'll try a general explanation of what I meant. If I've missed the point, please let me know.

Buildings with a happiness effect, and military police give "content faces" (the things that look like happy faces, but are orange and without the big smile) to your city. The effect of a "content face" is to change one unhappy citizen into a content citizen. If there are no unhappy citizens, there is no benefit.

Originally posted by Hurry
City is in Civil Disorder if there are more unhappy citizens than happy ones. For each turn in Civil Disorder, there is a 20% chance of riots.

Shouldn´t this read ...For each turn after the first of Civil Disorder...

Also, you could make the rule about retreats a bit more complete by adding that a fast unit with 1 HP left will not retreat if the defender also has only 1 HP.

I wasn't aware of either of these rules Thanks for pointing them out, I'll include them in the next update. Is your "no riots in the first turn of civil disorder" rule based on observation, or has Firaxis said that it works that way (or did I miss it in the manual)?

[Zorkk]

Nice job... here's a suggestion

Hey Nero

These sheets are great! wonderful job!!

I was curious tho, do you think you could add in all the hotkeys as well?? that's be a major bonus!!!

Thanks,

Z

[bassman]

I found the original file very useful, but I can't seem to open the patch file version

WINZIP claims it's not formatted correctly. Any ideas?

[Nero Would]

Zorkk: Thanks. I'll try to include a list of hotkeys next time I update the file.

bassman: I can't find a problem with the file, I just downloaded it and unziped it (with WinZip 8.0) without a problem. Have you tried downloading it again in case the download got corrupted?

[The_Aussie_Lurker]

Hi Nero,

First of all I'd like to say that your first CivStats file was absolutely indispensible, as it allowed me to more easily put together an edited copy including all my mod suggestions (especially the tech tree).

I am, however, having the exact same problem as bassman in trying to download your new version. Could you please send an unzipped copy to my e-mail address which is marcus.hicks@adl.clw.csiro.au. Thankyou.

Yours,
The_Aussie_Lurker

[Nero Would]

OK. It's on its way.

[Optimizer]

I'm already waiting for a possible upgrade to 1.17.

(This post is an excuse for bumping.)

[Nero Would]

Originally posted by Optimizer
I'm already waiting for a possible upgrade to 1.17.

Thanks. I hope to update the file for 1.17 this weekend.

[Nero Would]

Updated version for 1.17 patch

Here is the latest version of CivStats.

New version 1.17.2 adds:

• Updated to match the 2nd patch (Civ 3 version 1.17f)
• List of hotkeys
• "Rules" section now includes a table of years per turn

[Jac de Molay]

Great job, and a welcome addition....thanks