Apolyton Archive  |  Preserved copy of the Apolyton Civilization Site and its forums as they stood in September 2005. Read-only; nothing here can be posted to or replied to.  |  Forum index |  About this archive |  The 1998–2001 UBB forums
Today on Apolyton WARDELL INTERVIEW PROMO A.C.S. HISTORY CHAPTER 4 GET CIV4 /w FREE PLUS! A.C.S. PHOTO GALLERY GET A.O.M. V1.1
Apolyton Civilization Forums
main| civ2| civ3| civ4| smac| ctp2| ron| moo3| galciv| galciv2| alt| about|
ApolytonPLUS | register | search | faq | new posts | pm (-/-) | upload | members
hall of fame new! | civgroups | civgroups news | interviews | the column | radio | chat | directory | news | store | PLUS
Apolyton Civilization Forums : Powered by vBulletin version 2.0.3 Apolyton Civilization Forums > Civilization III > Civ3-Files > INFO: CivStats - Excel file with summaries of Civ III data
Show a Printable Version | Email This Page to Someone! | Receive updates to this thread | Report this to Apolyton news!
16.Sep: 7 NEW FILES
15.Sep: TRIAL + NO SLEEP = ONE GAME
13.Sep: PATCH THE PREVIOUSLY UNPATCHABLE

bottom of page
   - CIV3 CONQUESTS $29.99 - CIV3 from $9.99
Author
Thread   
Pages (2): [ 1   2   ]
< Last Thread     Next Thread > Post New Thread     Post A Reply
Nero Would is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 15-11-2001 00:11
Edit/Delete Message Reply w/Quote
#1 Report this post to a moderator
CivStats - Excel file with summaries of Civ III data - Version 1.21 Support Apolyton, pre-order Civilization IV

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.

Last edited by Nero Would on 05-05-2002 at 23:59

ElitePersian is offline ElitePersian
Prince
Vancouver, BC
Nov 2000
time: 05:16
  Old Post 15-11-2001 17:06
Edit/Delete Message Reply w/Quote
#2 Report this post to a moderator
Support Apolyton or Terrorists Win

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 is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 15-11-2001 17:49
Edit/Delete Message Reply w/Quote
#3 Report this post to a moderator
Tired of ads?

quote:
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 is offline ElitePersian
Prince
Vancouver, BC
Nov 2000
time: 05:16
  Old Post 15-11-2001 17:54
Edit/Delete Message Reply w/Quote
#4 Report this post to a moderator
Support Apolyton

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

DaveV is offline DaveV
King
USA - EDT (GMT-5)
Jan 1970
time: 00:16
  Old Post 15-11-2001 18:36
Edit/Delete Message Reply w/Quote
#5 Report this post to a moderator
Support Apolyton, buy Civilization: The Boardgame

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 is offline DeadDireWolf
Settler

Nov 2001
time: 00:16
  Old Post 15-11-2001 18:38
Edit/Delete Message Reply w/Quote
#6 Report this post to a moderator
Support Apolyton, buy Civilization 2

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 is offline DeadDireWolf
Settler

Nov 2001
time: 00:16
  Old Post 15-11-2001 18:44
Edit/Delete Message Reply w/Quote
#7 Report this post to a moderator
Support Apolyton or Terrorists Win

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 is offline Jeannette
Chieftain
Canadia
Sep 2001
time: 00:16
  Old Post 15-11-2001 19:23
Edit/Delete Message Reply w/Quote
#8 Report this post to a moderator
Re: CivStats - Excel file with summaries of Civ III data Support Apolyton buy from Amazon

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 is offline WarKing
Settler
East Coast, USA
Nov 2001
time: 00:16
  Old Post 15-11-2001 20:18
Edit/Delete Message Reply w/Quote
#9 Report this post to a moderator
Increase Your PM Length

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 is offline Jayis Solis
Settler
Washington, DC
Nov 2001
time: 05:16
  Old Post 16-11-2001 01:34
Edit/Delete Message Reply w/Quote
#10 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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

Kestrel is offline Kestrel
Warlord
Melbourne, Victoria, Australia
Jul 1999
time: 05:16
  Old Post 16-11-2001 05:46 Visit Kestrel's homepage!
Edit/Delete Message Reply w/Quote
#11 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations: Deluxe Edition

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 is offline Zanzin
Prince
Sydney, Australia
Mar 2001
time: 15:16
  Old Post 16-11-2001 06:41
Edit/Delete Message Reply w/Quote
#12 Report this post to a moderator
Remove this text

This is great work. Thanks mate!

Printing now

Nero Would is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 16-11-2001 10:22
Edit/Delete Message Reply w/Quote
#13 Report this post to a moderator
Browse Apolyton AD-FREE

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

quote:
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 is offline darkangel
Chieftain
Multimedia Developer - Tokyo, Japan
Nov 2001
time: 14:16
  Old Post 17-11-2001 17:44 Visit darkangel's homepage!
Edit/Delete Message Reply w/Quote
#14 Report this post to a moderator
Support Apolyton, buy Galactic Civilizations: Deluxe Edition

Great job and great help Nero!

RobC is offline RobC
Warlord

Aug 2001
time: 21:16
  Old Post 22-11-2001 02:03 Visit RobC's homepage!
Edit/Delete Message Reply w/Quote
#15 Report this post to a moderator
Enter the AD-FREE zone

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.

kokomo is offline kokomo
Settler
Buenos Aires
Nov 2001
time: 02:16
  Old Post 22-11-2001 18:24
Edit/Delete Message Reply w/Quote
#16 Report this post to a moderator
Inflate your Upload Space

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

Crom is offline Crom
Chieftain
England
Nov 2001
time: 05:16
  Old Post 22-11-2001 19:41
Edit/Delete Message Reply w/Quote
#17 Report this post to a moderator
Support Apolyton, buy Call to Power 2

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

Nero Would is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 08-12-2001 22:12
Edit/Delete Message Reply w/Quote
#18 Report this post to a moderator
New version - 1.16 Support Apolyton, pre-order Civilization IV

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 is offline macaday
Settler
Itinerant Wanderer
Dec 2001
time: 00:16
  Old Post 20-12-2001 15:40
Edit/Delete Message Reply w/Quote
#19 Report this post to a moderator
Tired of ads?

Thanks. Good job, I appreciate it.

--mac

Hurry is offline Hurry
Chieftain

Nov 2001
time: 07:16
  Old Post 20-12-2001 16:19
Edit/Delete Message Reply w/Quote
#20 Report this post to a moderator
Lose 30 kilos (of popups)

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.

Last edited by Hurry on 20-12-2001 at 16:29

Nero Would is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 20-12-2001 19:38
Edit/Delete Message Reply w/Quote
#21 Report this post to a moderator
Got spare money?

quote:
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.

quote:
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 is offline Zorkk
Chieftain
Great Underground Empire
Nov 2001
time: 22:16
  Old Post 09-01-2002 00:11 Visit Zorkk's homepage!
Edit/Delete Message Reply w/Quote
#22 Report this post to a moderator
Nice job... here's a suggestion Put an end to popups!

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 is offline bassman
Chieftain
near Seattle
Dec 2001
time: 21:16
  Old Post 10-01-2002 04:48
Edit/Delete Message Reply w/Quote
#23 Report this post to a moderator
Support Apolyton or Terrorists Win

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 is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 10-01-2002 17:38
Edit/Delete Message Reply w/Quote
#24 Report this post to a moderator
Browse Apolyton AD-FREE

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 is offline The_Aussie_Lurker
Prince
Adelaide, South Australia, Australia
May 2001
time: 05:16
  Old Post 14-01-2002 09:27
Edit/Delete Message Reply w/Quote
#25 Report this post to a moderator
Support Apolyton, pre-order Civilization IV

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 is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 15-01-2002 00:23
Edit/Delete Message Reply w/Quote
#26 Report this post to a moderator
Support Apolyton

OK. It's on its way.

Optimizer is offline Optimizer
Prince
Stockholm
Feb 2001
time: 06:16
  Old Post 14-02-2002 01:37
Edit/Delete Message Reply w/Quote
#27 Report this post to a moderator
Get a bigger avatar today!

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

(This post is an excuse for bumping.)

Nero Would is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 14-02-2002 04:35
Edit/Delete Message Reply w/Quote
#28 Report this post to a moderator
Support Apolyton buy from Amazon

quote:
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 is offline Nero Would
Chieftain

Nov 2001
time: 00:16
  Old Post 17-02-2002 17:35
Edit/Delete Message Reply w/Quote
#29 Report this post to a moderator
Updated version for 1.17 patch Full PM-box? Change here!

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

Last edited by Nero Would on 05-05-2002 at 21:23

Jac de Molay is offline Jac de Molay
Prince
Detroit
Sep 2001
time: 05:16
  Old Post 18-02-2002 01:44
Edit/Delete Message Reply w/Quote
#30 Report this post to a moderator
Support Apolyton or Terrorists Win

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

 
Pages (2): [ 1   2   ]
< Last Thread     Next Thread > Post New Thread     Post A Reply
All times are GMT. The time now is 05:16.
Apolyton Time is 00:16.
    top of page
Rate This Thread:
Forum Jump:
Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is ON
vB code is ON
Smilies are ON
[IMG] code is ON
 




Contact Us - Apolyton Civilization Site - Support Us!

Building a better Apolyton through better information. Click here and take our poll!
Non-US visitors, click here!

Powered by: vBulletin Version 2.0.3
Copyright ©2000, 2001, Jelsoft Enterprises Limited.

Page generated in 0.0522 seconds (91.77% PHP - 8.23% MySQL) with 30 queries
Page Loading Time:

Support Apolyton: Amazon USA | Amazon UK | Amazon DE | Amazon FR |
Support Apolyton and get FREE PLUS, Buy from Chips&Bits: Galactic Civilizations | Galactic Civilizations: Deluxe Edition | Call to Power 2 | Civilization: The Boardgame | GURPS/ Alpha Centauri | Alpha Centauri | Civilization IV | Civilization III: Complete |


Front Page | Civilization IV | Civilization III | Civilization II | Call to Power II | Alpha Centauri | Master of Orion III
Rise of Nations | Galactic Civilizations | Galactic Civilizations II | Misc
Alt.Civs | Civ I | C:CtP I | About | News | Directory | Apolyton Store | Forums | Chat | Columns | Interviews | Newsletter
Scenario League | CSC | Clash of Civs | Spanish Site | CtP Maps | Cradle of Civ | WesW's Ctp1/2 Site | Civ3 Haven

apolyton.net | apolyton.com | civilization2.net | civilization3.net | civilization4.net | civilizationiv.info | calltopower.net | galciv.net | galciv2.net | moo3.net