Civ IV Reference Charts

Discussion in 'Civ4 Strategy Articles' started by kroym, Nov 30, 2005.

  1. LordSpace

    LordSpace Chieftain

    Joined:
    Jan 4, 2006
    Messages:
    1
    Thanks for these great charts, they helped me save a lot of time looking through the civiliopedia. Very usefull. Thanks for the effort, it's highly appreciated.
     
  2. sketchy_c

    sketchy_c Chieftain

    Joined:
    Jan 10, 2006
    Messages:
    1
    First post. w00t! :)

    These charts are incredible if for the technology base cost reference alone. Great work!
     
  3. alluraprime

    alluraprime Chieftain

    Joined:
    Jan 6, 2006
    Messages:
    15
    :sad: :sad: I was so upset when I read that your spreadsheets were in microsoft excel. I constantly make spreadsheets using microsoft spreadsheets and I know how much work and effort goes into a simple one.

    However I have good news, for those of you who don't have excel you can do a google search for .xls and it will give you a link to an excel reader! You can't make your own spreadsheets but you can look at the wonderful work that Kroym has done on his. You can even print them out!

    Here is the link if you can't find it, you will probably have to cut and paste it to get it to work.

    http://www.microsoft.com/downloads/...f4-996c-4569-b547-75edbd03aaf0&displaylang=EN
     
  4. mother superior

    mother superior Chieftain

    Joined:
    Nov 21, 2005
    Messages:
    19
    Awesome work - helps a heap!!
     
  5. Michelangelo

    Michelangelo Prince

    Joined:
    Jun 25, 2001
    Messages:
    571
    Location:
    Netherlands
    Hi,

    As Kroym seems to be out of town, i've changed the upkeep for environmentalism in this intermediate version.
    I've also added the functionality of always having the correct formatting when sorting. It requires a small custum VBA-function, so it requires enabling macro's at startup. I hope this won't be a problem.
    Please take a look.

    Civ_IV_Reference_Charts_v1.41.zip

    and the PDF-version
     

    Attached Files:

  6. RobO

    RobO King

    Joined:
    Jan 3, 2001
    Messages:
    836
    Location:
    Slangerup, Denmark
    Great work!

    Check out the spreadsheet here, it shows the differences btw. the difficulty levels (as presented in CIV4HandicapInfo.xml). It may or may not be useful to include in the reference charts, though it will require some formatting first. Feel free to do so.
     
  7. fightcancer

    fightcancer Warlord

    Joined:
    Oct 28, 2005
    Messages:
    142
    Location:
    Wichita, KS (US)
    On the "Civilization Characteristics" sheet, for ease of viewing, I move the "Trait 1" and "Trait 2" columns to columns H and I, respectively.

    Also, the Space Elevator wonder does not mention the requirement to build within certain latitudes.
     
  8. Cosine

    Cosine Chieftain

    Joined:
    Dec 4, 2001
    Messages:
    36
    Location:
    Boston MA
    Great work folks. This chart is invaluable. I have it on a laptop sitting on a chair next to my desk while I play!:goodjob:
     
  9. chewtoy

    chewtoy Chieftain

    Joined:
    Jan 18, 2006
    Messages:
    2
    Greetings, all.

    I've made some minor updates to Michaelangelo's v1.41 of the Reference Charts, and with kroym's blessing I'm posting them here.

    The updates are pretty minor (all formatting, no content changes), but they should fix some issues with printing the charts to a hardcopy, if you're into that sort of thing.

    Changes in v1.42:
    • Fixed pagination & zooming for better offline viewing
    • Rotated a couple sheets to landscape view
    • Added sheet title to page header on each page
    • Rearranged a couple diagrams for better page layout

    The new XLS file is attached to this message. Enjoy!
     

    Attached Files:

  10. ColonelSanders

    ColonelSanders Chieftain

    Joined:
    Jan 6, 2006
    Messages:
    31
    Location:
    UK
    Several people have commented about the fact they don't have Excel so can't use these sheets.

    OpenOffice appears to read them just fine (though I've always disabled the macros). I say "appears to" because I don't have excel to compare the difference. If someone has both OpenOffice and Microsoft Office installed, I'd be interested to know if I'm missing anything.

    OpenOffice is free and runs on most platforms (Windows, Solaris and Linux - which I assume means it can work on a recent Mac too).

    Version 2 was released toward end of last year and seems very solid.

    Main features include a database, word processor, spread sheet and presentation app. All but the database are able to read their Microsoft counterparts.

    http://www.openoffice.org/

    The Excel equivelant in OpenOffice is Calc

    Andy

    PS. Just to prove the point, I've used OpenOffice to prepare a PDF of the keyboard shortcuts from v1.4 of kroyms Excel spread sheet. ;)
     
  11. Beamup

    Beamup Higgs boson

    Joined:
    Jun 8, 2001
    Messages:
    1,318
    Location:
    Boston
    Another nice addition, IMO, would be a listing of the output from specialists and super-specialists.
     
  12. Velvet-Glove

    Velvet-Glove Prince

    Joined:
    Oct 17, 2005
    Messages:
    324
    Location:
    England
    I've only just come across this file - great work, kroym, thanks. :goodjob:

    I do have a suggestion for the Resource Yield by Improvement page, though - building a railroad on a tile with a mine or lumbermill adds one extra hammer to production. I think this improvement bonus should be added to your table.

    Hope this suggestion helps.
     
  13. GonzoWCS

    GonzoWCS Chieftain

    Joined:
    Jan 17, 2006
    Messages:
    1
    Awesome Work

    Thanks!
     
  14. Harpua7859

    Harpua7859 Chieftain

    Joined:
    Jan 17, 2006
    Messages:
    6
    These charts are awesome!

    the only thing I'd request is a "printable version". But that's just because I'm lazy. Maybe I should open my notebook and have that next to my gaming PC. haha that'd be a great idea.

    ok. no cons from me.

    Awesome work
     
  15. Michelangelo

    Michelangelo Prince

    Joined:
    Jun 25, 2001
    Messages:
    571
    Location:
    Netherlands
    You can find a PDF version (a couple of posts up, post from me) and a printer friendly Xcel version from chewtoy.
     
  16. jaseclimb7

    jaseclimb7 Chieftain

    Joined:
    Jan 6, 2006
    Messages:
    9
    Location:
    Wheaton, IL
    thanks for the charts its good stuff
    i might print it out even (might cuz i don't appreciate wasting paper or else i definitely would)
     
  17. punchandpie

    punchandpie Warlord

    Joined:
    Jan 12, 2006
    Messages:
    111
    Location:
    Clinton, Massachusetts
    Pretty good stuff in there, very useful. :goodjob:
     
  18. carazariah

    carazariah Chieftain

    Joined:
    Feb 1, 2006
    Messages:
    3
    Wow on a helpfulness to new player's scale these charts rate a 25 on a 10 point scale!
    Great job and many many thanks for the great work on making these :goodjob:

    thank you thank you thank you. . .

    ;)
    C

    Civ IV Newbie,

    Played Civ II for a really long long long time. . .
     
  19. blah23

    blah23 Chieftain

    Joined:
    Feb 12, 2006
    Messages:
    1
    30/10 from me.:goodjob: Also do you think there could be a some sorting on the civics list? I manedged (sp?) to get them all in 1 list all next to each other but I can't get excel to do multiple colum sorts, only one at a time. thanks. Heres the version that I was working on: (yes i know that it was made from v1.41 and not v1.42 but I tried it and it didn't work for me so sorry)
     

    Attached Files:

  20. Acknoo

    Acknoo Chieftain

    Joined:
    Feb 21, 2006
    Messages:
    2
    /cries for happiness
     

Share This Page