Civ IV Culture Calculator Spreadsheet

Discussion in 'Civ4 - Utility Programs' started by O.H.Dog, Nov 18, 2005.

  1. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    For you cultural victory enthusiasts, here is an Excel spreadsheet to help figure out when your cities might achieve cultural victory. It allows four cities to be calculated, and gives you latest date of the fastest three.

    Once I got going I got on a roll. I added a few little extras. I hope you like it.

    Since each patch seems to change game speed values, I have made the spreadsheet more flexible. Version 1.4 now lets you choose which patch level you have 0.0, 1.09, 1.52, or 1.61.

    I also added an option for custom CIV4GameSpeedInfo.xml files.

    If I am slow off the mark for the next patch, you can enter the values yourself from that file.

    Thanks to ori we have an updated version which includes Beyond The Sword 3.13

    It is available in the download forums here: Civ4 Culture Calculator1.5
     

    Attached Files:

  2. ToastyAlbus

    ToastyAlbus Chieftain

    Joined:
    Mar 28, 2004
    Messages:
    62
    :O I live in Walla Walla!
     
  3. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    Yes, I figure a city with a cool name like "Walla Walla" deserves 30,000 culture points.

    BTW. Thanks for your reply. It told me that you were able to download and open my spreadsheet.
     
  4. ToastyAlbus

    ToastyAlbus Chieftain

    Joined:
    Mar 28, 2004
    Messages:
    62
    :) I do my best!
     
  5. Nishdog

    Nishdog Isolationist Bastard

    Joined:
    Nov 2, 2001
    Messages:
    285
    Location:
    in isolation
    This is great. Thanks. I've been working with a crude spreadsheet I wrote myself to do the same thing, but this one's much nicer and allows for some "what-ifs" that mine didn't.

    Is there any way to integrate this into the game so that I don't have to toggle between the game and Excel? That transition from the game and back seems to take too long for me and I have to go back and forth to fill out the values for each city. Either that or write down the data needed and then transfer it to Excel, and that's too much work.
     
  6. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    I was just thinking of that. I don't know how to do it. I'm sure something must be possible. It might require writing a program rather than using a spreadsheet. The algorithms would be the same. We might have to wait for the SDK before we can get something like that working.
     
  7. sociotard

    sociotard Chieftain

    Joined:
    Nov 27, 2005
    Messages:
    4
    Stupid question: Where do I see the current culture level for a city? I can find the current culture output, but not the current level.
     
  8. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    There's no such thing as a stupid question. Wait a minute. Yes there is. It's the one you don't ask.

    I'm sorry I took so long getting back to you.

    In map view (the normal view) you have to mouse over the star or dot below the city. Then look to the lower left for the stats.

    In the city screen, you have to mouse over the culture bar at the lower left.

    You will see something like: 19/turn and 282/500 (Developing)
    which means your culture is growing at 19 per turn and you have reached 282 of the 500 you need for the next level.
     
  9. LeSphinx

    LeSphinx Bachogwa

    Joined:
    Sep 21, 2001
    Messages:
    662
    Location:
    Paris, France
    Well it's usefull. Thanks
    LeSphinx
     
  10. Junuxx

    Junuxx Emperor

    Joined:
    Sep 6, 2005
    Messages:
    1,153
  11. vyapti

    vyapti Prince

    Joined:
    Mar 14, 2002
    Messages:
    339
    Location:
    Eugene, Oregon
    There is no such thing as a stupid question, but there are plenty of inquisitive idiots.
    --demotivators.com

    P.S. Not referenced to any posts!
     
  12. Faerwon

    Faerwon Chieftain

    Joined:
    Feb 22, 2006
    Messages:
    13
    Location:
    Finland
    Cool little tool and would be nice to see it integrated.

    In the meantime, making a 1.3 (add marathon speed and any other 1.52 changes)?
     
  13. davelisowski

    davelisowski Spartan

    Joined:
    Mar 10, 2006
    Messages:
    353
    A version for marathon speed would be much appreciated.
     
  14. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    Sorry. I wasn't paying attention. I've been busy with other stuff (my machine now multiboots eight operating systems.)

    I'll work on a Marathon + 1.52 patch version. It should not take long now.
     
  15. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    I was right. It turns out that it didn't take long at all. I must be good at this. (I thought it would take a couple of days.)

    Of course, it did take me a long time to get around to it. That I am bad at.

    I did manage to get the 1.4 version for patch 1.61 out in a reasonable time. That did take a couple of days, but only because 45 MB takes me about two and a half hours to download so I did it overnight.
     
  16. godotnut

    godotnut Inverted Unicycle

    Joined:
    Oct 26, 2005
    Messages:
    479
    Gender:
    Male
    Location:
    Brooklyn, NY
    Thanks! This is great. I'll be using it from now on. It's certainly worth the Alt+Tab to the spreadsheet mid-game, when compared with the esoteric calculations I've been making in my head in the past.
     
  17. ori

    ori Repair Guy Retired Moderator

    Joined:
    Dec 17, 2005
    Messages:
    16,561
    Location:
    Baden-Württemberg, Germany
    :bump:
    I added the new gamespeeds for Beyond the Sword and uploaded the whole file as V 1.5 to the Download Database. I hope you don't mind me adopting your excellent work.

    Note: BtS changed the turn count from years to months so the spreadsheet now looks a bit awkward and now gives years like 1991.25 I added a table to readout the month from these values to the sheet.
     
  18. O.H.Dog

    O.H.Dog Chieftain

    Joined:
    Nov 17, 2005
    Messages:
    43
    Location:
    Ottawa, in The Great White North.
    I don't know how to integrate a spreadsheet into Civ4, however, I found a way that works great on my system. I have three or four monitors attached. These days many video cards have two outputs. Also a second PCI or PCI-E video card can be added cheaply.

    Have two (or more) monitors attached.
    Run Civ4 in a window (clear Full-screen Mode in Graphics options, use a Screen Resolution smaller than your monitor's resolution.).
    Run excel on the second screen.
     
  19. ori

    ori Repair Guy Retired Moderator

    Joined:
    Dec 17, 2005
    Messages:
    16,561
    Location:
    Baden-Württemberg, Germany
    I just noticed that I made some mistakes in porting the whole thing to BtS - I'll need to figure out a way to solve this, at the moment the spreadsheet does not properly work in BtS :(
     
  20. ori

    ori Repair Guy Retired Moderator

    Joined:
    Dec 17, 2005
    Messages:
    16,561
    Location:
    Baden-Württemberg, Germany
    thanks to O.H.Dog the file now works for BtS :goodjob:
    sorry for confusing people who already downloaded it :)

    uploaded new version 1.5a
     

Share This Page