1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Scenario Creation Excel Sheet

Discussion in 'Civ2 - Scenario League' started by JPetroski, Aug 9, 2017.

  1. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    Hi all,

    I used to plan all of my scenarios in an excel sheet that had essentially all of the rules text. I can't remember where I found it and I've been poking around looking for it at the main sites without success. Does anyone have a copy of something that they use to create scenarios that they could send to me please, or post here for all to enjoy?

    Thanks,
     
  2. tootall_2012

    tootall_2012 Prince

    Joined:
    Feb 11, 2012
    Messages:
    561
    Hi John,

    I’m not entirely certain which reference files you are looking for exactly so I prepared a sort of compendium of resources files for you (see the attached “CIV II REFERENCES.zip)”. The zip files include:
    • Sid Meier’s Reference: a series of excel files related to city improvements, advances, wonders along with the base icon grid.
    • Macro language: the text file on the macro language code to use for the event file
    • NotePad++ for Civ: a utility that is very useful when building you event file (it requires the installation of the freeware NotePad++ program to use (essentially just a fancy version of the basic Notepad program))
    • TOTPP: a pdf file that elaborates all the features include in TNO's Test of Time Project
    • A House Divided Excel Files: a series of excel files I always use as a base for designing my scenarios (the samples provided are from my A House Divided scenario).
    I've attached a compendium of resources related to TNO's Lua project, which includes:
    • The civ.lua, functions.lua and init.lua files
    • Migrating events to lua.txt
    • SciFi scenario lua example
    • Lua Reference Library PDF
    In addition, I’ve included some links you may find useful:

    Civilization II Test of Time manual: https://forums.civfanatics.com/resources/civilization-ii-test-of-time-manual.3777/

    Scenario League : http://sleague.civfanatics.com/index.php?title=Category:Tips
    Catfish's Cave: http://users.tpg.com.au/jpwbeest/index.htm
    The Cradle of Civilization : http://sleague.civfanatics.com/COC/
    The CIVILINIC Books: http://www.sethos.gmxhome.de/

    You can find the great work of TheNamelessOne and his The Test Of Time Patch Project here: http://forums.civfanatics.com/showthread.php?t=517282

    Furthermore, with regards creating events file, you should also review the following links from the Scenario League site, which teach you how to use flags and masks:
    An Introduction to Flags
    Flags and Masks for ToT

    and if you require here is another link on Map Transport Relationships: http://sleague.civfanatics.com/index.php?title=Map_Transport_Relationships

    I hope you will find this useful.

    Tootall

    P.S.: your Over the Reich scenario served in part as a source of inspiration for my own facet of the air war for my Vietnam scenario. Thanks!
     

    Attached Files:

    Last edited: Apr 11, 2020
    Jack J and Konig15 like this.
  3. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    This is beyond what I was looking for - THANK YOU VERY MUCH :)

    As an aside I plan on trying out your Vietnam scenario very soon as I want to see what TOTPP can do!
     
  4. McMonkey

    McMonkey ----Evertonian---- SLeague Staff

    Joined:
    May 9, 2005
    Messages:
    2,875
    Location:
    Cardiff
    John,
    I couldn't recommend Tootall's Vietnam scenario highly enough. The original version was great fun and the final version is near perfect in my humble opinion.
     
  5. tootall_2012

    tootall_2012 Prince

    Joined:
    Feb 11, 2012
    Messages:
    561
    Hi John,

    I'm glad I could be able to help. I think you will find that TOTPP opens up a whole new series of features that make designing scenarios a lot more interesting (and the PDF reference guide I sent you is a great tool for locating and implementing them).

    By all means feel free to poke around in my Vietnam scenario as I've taken advantage of a great many of TNO's functionality (though beware of the Attacks per turn feature which only appears to work correctly for the first 81 units of the icon grid).
     
  6. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    Thanks! I'm not sure if I'll need to incorporate the attacks feature or not. I just did some testing to see if it would allow multiple attacks for aircraft that have (2) or more turns of movement, but unfortunately it does not override this. I was hoping that I could better differentiate units such as the 262 by letting them attack a few times.

    While that sadly won't work, I can use the feature to at least balance aircraft like the Me163 that are only going to have (1) turn of movement to make sure that they don't become overpowered.

    Thanks for all your help,
     
  7. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    I don't suppose anyone has a copy of Kobayashi's Battle Outcome Simulator? The link is broken.
     
  8. Konig15

    Konig15 Warlord

    Joined:
    Nov 4, 2007
    Messages:
    152
    Sorry to bump, cause while I've seen a LOT of good stuff here, there's a few gaps I can't seem to find.

    One is a good guide to using Goody huts (some of the unit spawns are covered in the Barbarian paper, but that doesn't account for multiple maps, unit restrictions on such a map nor the chances for settlers, gold amounts, or if there's a way in practice to restrict the scrolls of ancient wisdom to certain technologies but not others)

    A guide to airport and starport interception chances and design AI so that interception becomes a real threat to the player.

    If there is any effect of multilevel worlds on trade payout or bribe costs?

    Best practices for using multiple maps and them not being mostly a waste of space. This especially is important for getting the AI to colonize new spaces.

    How to get the AI to best develop their cities, both in infrastructure and in improvements.

    A guide on house rules so you an tell you, players, not to do certain exploits that will cripple the AI to be any kind of challenge. Instead of restricting unit access, let the player know what the exploits are and thus to avoid them to keep balance.

    And though not a scenario creation thing, if there's a way to start a new game with multiple maps where one is pre-existing map and the others are randomly generated.
     
  9. committed hero

    committed hero Chieftain

    Joined:
    Jan 17, 2010
    Messages:
    90
    Location:
    RTP,NC
    Does anyone have a spreadsheet that calculates win/loss percentages between units? I think Kobayashi made one at some point.
     
  10. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    I have that. I can get it to you after work
     
  11. tootall_2012

    tootall_2012 Prince

    Joined:
    Feb 11, 2012
    Messages:
    561
    Hi commited_hero,

    I'm not certain. Is the first tab, Civ2 Combat Probability Calc, of the attached excel file what you were looking for?
     

    Attached Files:

  12. JPetroski

    JPetroski Deity

    Joined:
    Jan 24, 2011
    Messages:
    2,493
    Here is Kobayashi's Battle Outcome Simulator.
     

    Attached Files:

  13. committed hero

    committed hero Chieftain

    Joined:
    Jan 17, 2010
    Messages:
    90
    Location:
    RTP,NC
    Thanks gents!
     

Share This Page