Civ IV Reference Charts

Unfortunately, not only does PDF not float my boat ("hate it" wouldn't be too strong of a complaint), but I can't edit it for my own purposes (not all the information is presented the way I want it to be), or update it as new information or patches are released that change things (which happens a lot in some games).

So: are there plans to update the spreadsheet to BtS?
 
TheDS,

I've included a PDF version for people who don't have Excel and to assure it is printed the way it is intended. There is also an Excel-version which allows setting some game-options that influence costs so the sheets are correct for all settings.

I'm currently working on the BTS additions. Basically only need to update the unit charts, the rest is finished. However RL has taken over last week, but I expect to be able to finish them soon. I've allready included the 1.74 and 2.13 patches as I couldn't find changes in them ;)

So please have a bit more patience, if you would like to see information presented differently, please let me know, and I'll see if I can include it in the charts.

See you
 
@Michelangelo – I just wanted to say that I'm thrilled to hear that you're working on updating your charts.

The one anion produced is beautiful… but not nearly as useful for quick reference as the format you have used in the Vanilla and Warlords charts.

Can't wait to see your update for BtS!

And thank you, thank you, thank you! :beer:

EDIT: and thanks to kroYM also, of course!
 
There's another spreadsheet somewhere around here (yours?) for Civ4 and Warlords that I liked a lot, matched up well with the one I made before Warlords came out. When I saw someone was doing a better job of it, I stopped updating mine.

Of course, not everything was exactly how I liked it, but with Excel being an editable format, I was able to make whatever changes I wanted, and add in a few bits from my own sheet.

Asking you to conform the whole document to my needs would be rather unreasonable of me to ask, especially since my needs change, but I didn't think an Excel file would be a big request, since there was already most of the work done, and Excel can do anything you've already done in that PDF, plus be able to edit it or adjust the lists' order on the fly, or rapidly reach any list with a single click. PDFs can be made out of other file formats, but the reverse is not always true.

I don't like PDF because it's too unwieldy to use, can't be edited without spending obscene amounts of money (most computers come with a spreadsheet program, none come with PDF-editing), they're a PITA to edit (and not on the fly either), and suck up entirely too much memory. They're not especially fast to use either. I like my screen real estate to be used for information; I can display about 4 times as much useful information, and scroll through it faster if it leads off the screen, by using Excel instead of PDF.

With all those advantages, I can't see why the average person would want to use PDF at all. But there are plenty of people whose computers don't come with a free spreadsheet, and it's much easier to find a free PDF reader than a free Excel reader, but that's more a vocal minority and Adobe shoving it down people's throats.

I'm not trying to rag on you and your fine work - the PDF is beautiful and looks very complete - I couldn't think of anything it was missing. However, referencing it is slow, both because the information is presented in a space-wasting manner and because PDFs are by nature slow to use. If I were to have it open while playing the game, it would take up too much precious RAM and slow down things even more, and if I were to print it out (with I'm anethema to do anyway) it would cost a small fortune for a game I don't even get to play that much.
 
There's another spreadsheet somewhere around here (yours?) for Civ4 and Warlords that I liked a lot

If it's mine, it's the same as the PDF. I've made an Excel version and for people without Excel or Excel-viewer also made a PDF from it (as I mentioned 3 posts above ;) ) So it could be mine.

I agree that the "Live" excel version offers more functionality than the static PDF version, but that one is just meant for printing as Excel tends to screw up with printing on different computers.

Didn't find time this weekend to work a bit more on finishing the sheets for BtS as we got very nice weather (for a change) and I just couldn't stay inside behind my computer.:D
I'll keep you updated.
 
:bump: Any word on this?

No nagging from me - I greatly appreciate those that donate time to help all of us out - just looking for an update!

Thanks! :salute:
 
Thanks for the chart and keep up the good work!

Please be aware that the Arabs, Aztecs and Egypt have the trait "Spirtual" instead of "Spiritual" in the "Civilizations Civ4"-tab.

Similar error are found in the "Civilization Warlords"-tab (Celts, Egypts, Arabs, Aztecs).

I'm using this chart a lot, and I've customized it in a way I find very useful. In the "Technology Tree Flow Chart", I've linked the cost from the previous tab, so that the cost is shown adjacent to each gray tech box. It took me a bit rearranging to look nice, but it helps me to provide a quick grasp of the cost. I've also added a small icon to each tech that founds a religion to make it more clear.
 
What?! Whadaya mean, no promises? I want promises!!! I'm holding my breath 'til this comes out! :blush: Get back to work. If you're anything like me, you'd better devote every spare waking hour and get it done in the next couple days, or you'll never get it done. Come on, everybody, let the man know how important this work is. :goodjob:

(Oh, and I hope you're accounting for the changes made in 3.13.) :mischief:
 
:agree: I also demand that you work night-and-day without pay on a project for my personal benefit! :D


Seriously – I’m excited to see this when you get done. I know it’s a lot of work, so – THANK YOU – in advance! :salute:
 
Here are the relevant gameplay updates:

Spoiler :

GAMEPLAY

Cristo Redentor allows 1 turn between civics changes, not zero turns.
Attack Sub: 30 strength, 7 moves, 180 cost
Destroyers also upgrade to Missile Cruisers
Customs House and Feitoria give +100% Foreign trade route income
Reduced inflation and better normalized it with game speed
Inflation no longer increases after the game time limit has been reached
Adjusted corporation maintenance for inflation
Corporation Headquarters give 4 gold per corporation city to balance corporation immunity to inflation
Spies downgrade towns, hamlets, and villages instead of completely destroying them
Military Science moved to Renaissance
Can't vote on a winner if one team already has all the votes necessary to win
Updated Apostolic Palace civilopedia text to show that all members receive the religious building production bonus, unless they defy a resolution.
Revised liberation formula
- Fixes exploit of infinite unit generation through city liberation

Liberation no longer provides free units to non-vassals
Cities no longer auto-liberate on conquest except from a vassal to a master
Colonies no longer can be the same civ as an existing one
Colony gets all of prior owner's culture on the entire continent
Can no longer make a colony on a continent with an existing colony. Liberate cities instead.
Great Works brings city out of revolt, as before BTS
Unlimited Corporation Executives now allowed
Invisible units no longer get bumped when an enemy occupies the same tile.
Can no longer build forts in rival territory
Can no longer blockade from within your own cultural borders
Spread culture espionage mission increases your culture by 5% of the total culture in the city
Vassals can no longer use spies against their master (active missions)
Espionage Poison Water and Unhappiness amounts no longer incorrectly scale with game speed
Added minimal conscription ability to all gunpowder and melee units that didn't previously have it
- Prevents situation where you can't draft when you can build SAM Infantry but not Infantry

Rival spies no longer count as friendly units for nuke attacks
Blockading consumes all remaining movement
Blockade is canceled when unit does something other than blockade
Blitz promotion available to ships
Frigate, Ship of the Line, and East Indiaman bombardment ignores walls and Castles
Colony maintenance capped at twice the distance maintenence
All teams get espionage points against a newly formed Colony.
Fighters no longer get experience points for shooting down units that cannot defend (paratroopers)
Paratroopers have 25% evasion chance


Full changelog is here: http://forums.civfanatics.com/showthread.php?t=245912

Thanks Michelangelo!
:salute:
 
I'm a huge fan and heavy user of your spreadsheet. :goodjob: I don't have BTS but I'd just like to point out that the latest Warlords patch could have changed "favorite civics" for some of the leaders. In a diplo game (Warlords) I was playing yesterday I noticed:
. Peter of Russia having Bureaucracy as fav civic (XLS says Police State)
. Asoka of India having Free Religion as fav civic (XLS says Univ Suffrage)

I didn't check the other leaders but I think it is worth reviewing that column.
 
Count me in the "desperately looking forward to this" camp! Let me know if there's any way I can help, perhaps by updating whichever pages you've yet to complete?
 
:bump: Can we get an update on any progress?

Thanks Michelangelo! :beer:
 
I'm really glad to see that this forum is still active! I recently got BTS as a B-day gift but haven't installed it yet. Besides trying to finish the GOTM first, I don't want to give up this reference guide! I've been using it since I started playing CIV4 and refer to it so much that my wife is convinced it came with the game! I love the fact that all the relavent information for a topic is contained on one page. Please let me know if there is anything I came do to help on this effort. I don't have a lot of free time, but I consider this guide indespensable, so would love to help.
 
I'm really glad to see that this forum is still active! I recently got BTS as a B-day gift but haven't installed it yet. Besides trying to finish the GOTM first, I don't want to give up this reference guide! I've been using it since I started playing CIV4 and refer to it so much that my wife is convinced it came with the game! I love the fact that all the relavent information for a topic is contained on one page. Please let me know if there is anything I came do to help on this effort. I don't have a lot of free time, but I consider this guide indespensable, so would love to help.

For BtS you should have a look at

http://forums.civfanatics.com/showthread.php?t=236346

It is really nice (and your wife will consider it being part of the box)
 
Back
Top Bottom