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

[Nero Would]

I like to have key information on paper rather than have to go to various screens to look it up. CivStats is a Microsoft Excel 2000/Excel 97 file containing data taken from the rules file (civ3mod.bic). Version 1.0 contains:

• Enhanced tech tree
• Terrain and resource data
• Unit stats
• Improvement/Wonder stats

Version 1.00 was downloaded 1937 times.

New version 1.16 adds:

• Updated to match the 1st patch (Civ 3 version 1.16f)
• Unit Tree - Unit stats in Tech Tree format
• Civ and Government stats
• Information on how the game calculates various things

Version 1.16 was downloaded 970 times.

New version 1.17 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

Version 1.17 was downloaded 126 times.

New version 1.17.2 adds:

• Changed to match the updated version of the 1.17f patch that Firaxis released on 15 Feb. The only difference from the 14 Feb version of the patch is that Barbarians are restricted to Warriers, Horsemen and Galleys (the 14 Feb version allowed all units to barbarians, which resulted in advanced units being found in goody huts.
• Added arrows to Unit Tree to show upgrade patch to civ unique units.

Version 1.17.2 was downloaded 277 times.

New version 1.21 adds:

• Changed to match the 3rd patch (Civ 3 version 1.21f)
• Moved some units in the Unit Tree to better show their place in the tech tree.
• Corrected calculation of City Centre Tile production.

(The forum won't let me attach the updated file here. I've attached it to a reply I posted to this thread. Please use this link to download the new version.

[ElitePersian]

the whole thing is great good job.

just one small thing - the borders and gridlines for the terrain section are messed up when i print it, even though it looks fine on the screen, anyone else experiencing this?

[Nero Would]

Originally posted by ElitePersian
just one small thing - the borders and gridlines for the terrain section are messed up when i print it, even though it looks fine on the screen, anyone else experiencing this?

That section uses the "Fit to page" option in File|Page Setup in order to get the whole table on one page. I sometimes have problems using that option with lots of gridlines on the page (although this one prints OK for me). You might try making the three columns on the left narrower (width 4.00 - 29 pixels does it for me) and change File|Print Setup to say "Adjust to 100% of normal size". See if that fixes it.

[ElitePersian]

Yup, that did the trick!
thanks.
great work with the stats.

[DaveV]

Thanks a lot for sharing the results of what had to be a lot of work. I had started on making some of my own charts, but nothing this extensive.

Very nice layout; these pages will find a permanent home in my Civ III folder.

[DeadDireWolf]

I hope I'm not missing the blatantly obvious but on the units tabin the "Cost" column there are subcategories of Shld/Pop. Pop means how many population points is deducted from the city upon completion but I can't figure out what the Shld (shield) sub-column means. I can't figure out what the correlation is. Anyone?

[DeadDireWolf]

I hope I'm not missing the blatantly obvious but on the units tabin the "Cost" column there are subcategories of Shld/Pop. Pop means how many population points is deducted from the city upon completion but I can't figure out what the Shld (shield) sub-column means. I can't figure out what the correlation is. Anyone?

[Jeannette]

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

This is version 1.0 - any corrections or suggestion are welcome. [/QUOTE]

Just to say thank you, Nero, for a VERY helpful job, VERY well done.

[WarKing]

I too was creating my own data sheet, your's is more than enough! Awesome job! I've also compiled a list of hotkeys and other tid-bits from the manual. You can't live with out those hotkeys!

[Jayis Solis]

Great work. This is the perfect cut and dry, no frills, need the information NOW guidesheet.

[Kestrel]

Well Done.

As an excellent base level description of the Civ III rules and weightings.

And because there is no Rules.txt that we can use this could become a great intermediate descriptor / documentation aid for Modpacks (what changes made where , which extra techs, units added where etc.)

I'll certainly be using it (with due credits of course).

[Zanzin]

This is great work. Thanks mate!

Printing now

[Nero Would]

Thanks everybody. I'm glad you find the tables useful.

Originally posted by DeadDireWolf
I hope I'm not missing the blatantly obvious but on the units tabin the "Cost" column there are subcategories of Shld/Pop. Pop means how many population points is deducted from the city upon completion but I can't figure out what the Shld (shield) sub-column means. I can't figure out what the correlation is. Anyone?

The number in the "Cost|Shld" column is a measure of the shields required to produce the unit, but you have to multiply by 10 to get the actual number of shields. I realise that is rather misleading, but that is the number used in the BIC file.

[darkangel]

Great job and great help Nero!

[RobC]

Great job, nero! One question: what does 'turn to attack' mean in the unit stats? Does this just mean that the unit turns during the attack animation (e.g. caravel turning to fire its cannons broadside)? Just wondering why this is important.