1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. Photobucket has changed its policy concerning hotlinking images and now requires an account with a $399.00 annual fee to allow hotlink. More information is available at: this link.
    Dismiss Notice
  3. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  4. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  5. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  6. Dismiss Notice
  7. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

The Reference Guide

Discussion in 'Civ4 - Utility Programs' started by TheDS, Jun 6, 2009.

?

Was this helpful?

  1. Best thing I ever saw (since the last thing)

    20 vote(s)
    57.1%
  2. Worst thing I ever saw (since the last thing)

    3 vote(s)
    8.6%
  3. I don't feel like voting

    9 vote(s)
    25.7%
  4. Head... exploding... can't... understand... notes!

    3 vote(s)
    8.6%
  1. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    Hello, all!

    Last year, when I was very much into Civ4BTS, I came across a set of reference sheets. Long ago (pre-BTS), I had made my own set, but never got them finished, and seeing these were so much better, I started using and then modifying them to my own purposes.

    Originally started by Kroym, then Michelangelo started keeping them updated for a while. I made my own from his, and then life interupted and I've been out of the scene for a while.

    I got a message from DanQ the other day, which has brought me back (for a little while, at least), and I figured that, with no updates from anyone else, and this file languishing on my hard drive, it would be a good idea to go ahead and let everyone have it since I don't think there have been any updates for a while.


    IMPORTANT NOTES:

    1. I removed all non-BTS information. If you're not playing BTS, these sheets aren't for you.
    2. I corrected a lot of errors that are in Michelangelo's sheets. I told him what many of them were as I found them, but I slacked off and lost track of them.
    3. I reorganized some things so they looked better to me. I also tried to make the sheets look prettier.
    4. I added a LOT of information and charts. Some of this I consider to be "notes to self" to help me understand what I'm looking at, some of it I find fascinating illustration of some of the cool features and synergies of the game.
    5. I put the title page in the MIDDLE of the other tabs, so that, as long as your screen is wide enough, you should be able to click back to the title page no matter which tab you're on. I renamed many of the tabs in the hopes they'd all fit on your screen.
    6. Many charts have been duplicated on the same sheet and then reordered. Sometimes you want to look up by name, sometimes you want to look up by type. DO NOT TRY RESORTING CHARTS!!! You will damage things. In every case, I put the second chart below the first chart. Typically, I have the alphabetical listing first and the organizational sheet second. (Or was it the other way around?)
    7. I removed the macros or whatever they were that were added to filter out certain items. They just got in my way. If you liked them, you'll have to learn to do without.
    8. I decided not to bother to remove two pages of notes-to-self. You can see what other things I was considering adding, and I'm going to use those incomplete ideas as the reasons why I never released this sooner. :p
    9. Since this is incomplete, and I haven't used it in many months, there could still be oddities. I did what I could to make it all look pretty, and I glanced through it again a minute ago, but no promises. As far as I know, the only "problem" was that I still had those pages of ideas to add that never got completed.
    10. As I'm extremely busy lately, and not likely to be playing again for quite some time, I'm not very likely to be able to update this sheet if errors are found, nor will I be able to complete it. If someone wants to take it upon themselves to keep it updated or if they want to work on the incomplete ideas and can figure out what I was getting ready to do, be my guest. (If you can't figure it all out, PM me and I'll try to explain, but ONLY if I receive a PROMISE that you will make a sincere effort to try to finish the work. I don't have time to explain things to 50 people who are merely curious.)
    11. Lastly, I did most of the work before 3.17 came out. I tried updating to 3.17, but there may be omissions, especially in the more graphically intense pages. Otherwise, it's updated to 3.17 standards.
    12. Even more lastly, the spreadsheet may tell you it has macros. It doesn't. I can't fix this erroneous error.

    Not responsible if any of the above rambling didn't make any sense. :lol:

    I hope this helps you.

    And just because I like polls, there's one here too. :D

    EDIT: (added 6/11/09)
    Ah, well, nice of them to go and release 3.19 right after I release this sheet. One of the charts in my sheet tells what the differences are between a vanilla unit and its unique units, plus the charts that tell what exactly each unit does. It looks to me like this is the only relevant change to the sheet:

    Conquistador ignores walls, to be consistent with Cuirassier

    So I'll let you guys use that information as you see fit.


    EDIT/UPDATE:

    Today (3/14/10) I had some spare time and went through and checked my sheet. A few errors had been found in Michelangelo's, and a couple of those were still in mine, plus there were a couple others I found. I also wanted to check that 3.19 change that needed to be made, and as it turns out, I didn't notice that Conquistadors couldn't ignore walls, so that wasn't a problem after all.

    Here's the new file for 3.19. The old one for 3.17 was downloaded 580 times.
     

    Attached Files:

  2. The_J

    The_J Say No 2 Net Validations Retired Moderator Supporter

    Joined:
    Oct 22, 2008
    Messages:
    29,944
    Location:
    Germany / Netherlands
    Good collection :goodjob:.
    Would maybe more readable as a pdf.
     
  3. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    Thank you, kind sir! If you would like to make a PDF version, I'll add it to the original post.
     
  4. Capt Buttkick

    Capt Buttkick Chieftain

    Joined:
    Mar 6, 2003
    Messages:
    1,775
    Location:
    Feet on t ground Head in t clouds
    Thanks :goodjob:
     
  5. Michelangelo

    Michelangelo Chieftain

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

    Good thing you did what you did. I'm also still finishing my ref-sheets, but RL doesn't allow. But I can help you, methinks atleast, with the macros. Only fair, as I put them there in the first place ;).

    When you go to the visual basic editor, you must remove the now empty modules. That will also remove the macro-warning.

    See ya,

    M.
     
  6. MorbiusInCT

    MorbiusInCT Chieftain

    Joined:
    Feb 6, 2003
    Messages:
    5
    Location:
    CT
    very nice ss. looks like it was a lot of work and a lot of fun.
     
  7. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    dang double posts!
     
  8. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    Aw, dude, I was just in the process of uploading the new file when you posted! Sorry about that. Thanks for the pat on the back!

    I've made some minor updates because someone found some errors, and while I had it open, I found a couple more. Anyway, I've attached the new file to the original post. Enjoy!
     
  9. MorbiusInCT

    MorbiusInCT Chieftain

    Joined:
    Feb 6, 2003
    Messages:
    5
    Location:
    CT
    you are welcome. it's good to be up to date. fyi... about 7%-10% of males are red/green color blind so i assume the wordless blobs on the title page actually say something like the tab title they go to when clicked. be kind. don't combine red and green. and yes... traffic lights can be a problem for me when there is no yellow (orange?) one in between and they are on their side. anyway... thanks for the fix. ya done a good thing... again.
     
  10. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    You're welcome!

    On my screen, it's yellow (golden) text on white background to go with the color scheme of the Civ4 graphic. It's possible your monitor is screwed up (or mine is). But yes, they are links. Feel free to change them to a more useful color. It's just text with hyperlinks, you can select the whole lot and change the text color or the background color if you like. Let me know how it all goes, if you care to.
     
  11. TheDS

    TheDS Regular Riot

    Joined:
    Jan 18, 2002
    Messages:
    1,454
    Location:
    Daytona Beach
    Well, this is embarrassing... I found another couple of minor errors. Heh, I go and correct the sheet and then come to notice I missed something innocuous. It had to do with the cross-indices; two of the corrections centered around what the starting techs for civs were, and the cross-indices tells you this information too, but I forgot to update it. But it's updated now! Sorry. Two people downloaded that before I caught it.
     
  12. feelotraveller

    feelotraveller Chieftain

    Joined:
    Apr 30, 2010
    Messages:
    67
    Thanks a lot - this is brilliant. Just had a quick glance but I'm sure I'll learn lots when I get a chance to spend some time. Noticed that the unit costs for marathon speed are 3/2 of what they should be. Units only cost double on marathon.

    Real good just the same. :D
     

Share This Page