Once again, I'm back with a new version of the calculator. Since in fact it doing quite a lot more than just calculating credits, I decided to change the name to 'Civ Administrator'. That may be a rather cheesy name, but since it is exactly what it's doing and I don't mind 'camp' at all, it sounds good to me
In relation to the previous version, the following changes have been made:
• The worksheet 'AST' is promoted to control center of the file. It contains all buttons that start the macros that make it work.
• The sheets 'Tables' can easily be hidden, since it is not actively used by players during the game (though it fuels many background processes).
• The sheets 'Overview' and 'VP Chart' can also be hidden, since player groups may prefer not to know the exact score of each player during the game.
• The sheets of Civs that are played, are automatically renamed to the player names.
• The sheets of Civs that are not played, are automatically hidden from view.
• Astronomy is renamed to Astronavigation.
• The costs of Monotheism, Politics, Provincial Empire, and Trade Empire are changed according to version 2.10.
• 'Regression' is improved: it takes the primary victims (possible) possession of Fundamentalism and/or Library into account.
• An extra button 'Corrections' is added, for correction of either the city amount, AST position, or Civ Advance purchases of a player. Mistakes can now be corrected by everybody that did not create this file
One last thing: I did deliberately not implement the effects of Library (science cards for free) and Anatomy (extra credits in the same turn), since they are quite tough to program. Anyone buying one of these cards can take these effects into account 'manually', which is in fact infinitely easier...
I put two different versions on-line: the normal 18 player Expansion version, and a version for players that play the Expansion on the old 9 player map. For the latter, the AST of Advanced Civilization is used.
The 'manual' has been updated too.
http://www.kjbwaarland.com/Civilization ... layers.xls
http://www.kjbwaarland.com/Civilization ... layers.xls
http://www.kjbwaarland.com/Civilization ... Manual.doc
Gerart