filler

Advanced Civilization

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.

The spread sheet is made using MS Excel and protected by the password "aciv".

Credit sheet Personally, I have ready access to quality laser printers, and not so ready access to photocopiers. So I made an Adobe readable reproduction of the credit calculation sheet on the back of the AH rule book. It looks all right and is a good alternative if you don't have access to a photocopier.
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.

Advanced Civilization

Download
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

The zip archive, Accal140.zip, may be freely distributed. Please do not distribute either the readme file or the spread sheet file, Accal140.xls separately. Change the spread sheet to suit your particular needs, but please retain the original attributions.

Comments are welcome.

Christian Kringstad Kielland <christkk@ifi.uio.no>, 8. Dec 1999.

This spread sheet is not able to control if a player actually possesses the entered number of cards, it is merely intended to help perform the (often time consuming) game calculations, and it works well for that purpose.

The creator of this spread sheet is not to be held accountable for errors in the spread sheet or problems that may arise from use of the spread sheet.

Certain words in this document are trade marks of certain companies.

Back to Index
Feriehus
This page is normally not updated. In the unlikely case that an update should take place, it will have been done by Christian K. Kielland.
Last modified 11. april 2000 View
   Christian Kringstad Kielland's profile on LinkedIn