filler

It is hard to find the time to play this game, not to mention finding enough people to play. When I and a few friends manage to get a game going, we often find that the calculation of credits for the purpose of purchasing civilisation cards take too much time. That's why I decided to make a spread sheet to facilitate these calculations.

An analysis
of the first
eight turns
I made this table just for fun, to see how a civilisation would develop during the first few turns under ideal circumstances. I'm not sure the values are entirely correct, but they are close. Have a look.

Accal140.zip
Aciv Calculator ver. 1.40

The Aciv calculator is an Excel spread sheet made with the aim of simplifying the calculation of credits and purchasing of civilisation cards in the game of Advanced Civilization by Avalon Hill.

Functions offered by the spread sheet

• Enter the number of trade cards in hand (or however many you want to spend that round) and the total value of your trade cards will be computed. You may also enter the number of tokens in treasury and that number will be added to your purchasing total.
• The civilisation cards that have a cost (including credits) equal to or lower than your purchasing total will be marked as "affordable", thus you don't have to consider buying cards that you can't afford anyway.
• Mark the civilisation cards that you hold with a "1" and the net price of all the civilisation cards will change to reflect the credits available from those cards. The cards marked as held will not be marked "affordable", obviously.
• The sum of civilisation cards marked as held will be displayed.
• If Mining is marked as held, one of the commodities listed under "Mining yield" may be marked by a "1", if one or more of the corresponding trade cards are held, the total value of those cards will be calculated as if another card of the same type was held, limited to the max value listed on the card.
• The formulae used in this spread sheet should conform fully to the rules of Advanced Civilization.
• If illegal values are entered, such as indicating that eight ochres are held (there are only seven ochres available in the stack), or marking two kinds of mining yields, an error will be indicated.
• The entire sheet, excluding the input cells, C5:C22, D26, H5:H28 and M5:M9, has been protected to prevent accidentally altering the formulae. The formulae can be altered after unprotecting the sheet using the password "aciv".
• The cells K5:K28 and M11 contain temporary results necessary for the correct operation of some of the formulae.

Miscellaneous