AU2007.1 Spreadsheet Instructions

Sheet Start-up From Scratch

1. Open your turn .txt file. Note the .pdf file will not work.
1. Select All by pressing Ctrl-A.
2. Copy All by pressing Ctrl-C.

2. Open your AU spreadsheet and select “Enable Macro’s” when asked.
3. Go to “Front” sheet and select your Nation and the Month in the top left hand corner.

4. Go to “Paste Here” sheet and select column “A” at the top.
1. Hit “Delete” to clear all the cells in column A.
2. Select Cell “A1” so that only one cell is highlighted.
3. Paste your turn by pressing Ctrl-V.
5. Hit the “Austerlitz” button to generate your turn.

6. Go to “Army” sheet.
1. Update Commander ratings and add Commanders as required.
2. Delete any troop builds, repairs, training.
3. Press the “Calculate Troop Build Costs” button. This should zero all build costs.

7. Go to “Navy” sheet.
1. Delete all ship/baggage builds and repairs.

8. Go to “Trade” sheet.
1. Delete all sales and purchases.
2. Press “Calculate Trade” button to zero cells

9. Go to “Front” sheet.
1. Zero all Production site builds in Europe and Colonies (column B)
2. Zero all Population increases in Europe and Colonies (column L)
3. Zero all Inter-Warehouse Louisdore transfers.
4. Manually set all European barrack political spheres, ie H, PS or F. To be done every turn.

Sheet Explanations

Front Sheet

1. The sheet is split into 3 sections to represent the 3 warehouses, Europe, Caribbean and India.

2. Each warehouse’s LD and stock is shown horizontally across the top of each section.

3. The number of Production sites per warehouse are shown in column G (in black). These are automatically generated when the “Austerlitz” button was pressed.

4. To build a production site simply add the quantity required in column H (in blue). A maximum of 10 sites can be built and the sum of all builds is shown in cell H25.

5. Recommended production sites are shown in column I.

6. Maintenance and approximate citizen costs are shown for your information.

7. Fortresses can be built in cells G22:24.

8. All goods for builds are extracted from the relevant warehouses.

9. Goods generated by production sites are shown in Black and goods used by production sites are shown in Red.

10. Population increases are carried out by putting the quantity required in cells L25:33, L69:77 and L116:124. A maximum of 7 population increases are permitted and the sum of all increases are shown in cell J28.

11. Production site maintenance is split between the relevant warehouse as per the rulebook.

12. Army and Navy maintenance and all LD build costs are shown in column AB.

13. The LD costs for direct Trading are also removed from LD available in column AB.

14. Two cells per warehouse are available in column AB for transferring LD between warehouses.

15. LD Income from Taxes, Mints and Direct selling is shown in cells V22:W25 for Europe, cells AB62:64 for Caribbean and AB109:111 for India, together with a prospective LD total for next month.

16. A graph is provided to show a 12-month Food forecast. This is only updated when the “Generate Finances” button is pressed. NOTE : this is an estimated production based on “home” nation averages, ie counts ALL prime and normal estates but uses the climate factors on page 23 of the rules.

17. The barracks are shown in columns AE:AM. The LD and goods are generated automatically when the turn is generated.

18. The LD and goods that need to be transferred into the relevant barracks are shown in columns AN:AS. NOTE: Changes in the Army and Navy sheets will NOT be reflected in the transfers until the “Generate Finances” button is pressed.

19. A box is shown next to the Generate Finances button to show the ratio of Total Income vs Outgoings. The closer to 100% the closer the economy is to using it’s cash reserves. Over 100% and it is using it reserves, ie in the red.

20. Goods Balance Available is shown in Red if there is a negative balance and you need more raw materials. The recommended builds will also reflect the deficit.

21. Nation and turn month are shown in the top left hand corner.

Trade Sheet

1. Trade only covers Direct Selling or Buying within a players own Trade Cities. This is because the funds can be utilised for more trading or for next turn. When purchasing the program assumes that the trade city is being emptied of that particular item. (this is the most cost effective method of trade)

2. The trade is split into European, Caribbean and Indian trade.

3. 4 Trade Cities are allotted for Direct Buying in columns C:F.

4. Change the Trade City rates to the respective values (blue text).

5. Enter the amount of goods you wish to purchase.

6. The program calculates the cost and removes the LD from the respective warehouse.

7. Money made from selling is shown in the next month’s projected income.

8. 6 Trade Cities are alloted for Direct Selling in columns L:AI.

9. Change the Trade City rates to the respective values (blue text).

10. Enter the quantities you wish to buy under “Qty” and next to the goods you wish to buy.

11. Enter the multiples you wish to buy under “n”. 36 is the maximum per turn.

12. Enter the stock which is held within the Trade City (before trade) under “Stock”.

13. Press the “Calculate Trade” button to generate the costs of Direct Selling. The LD will be removed from the actual LD available in the respective warehouse.

Army Sheet

1. The entire army is listed in federation order in columns AL:BJ.

2. Brigade weights are shown in column BL.

3. Army Federations are shown in columns A:R.

4. You can name you federations next to Corps Name.

5. Commanders and their ratings are manually placed under their respective federations.

6. A complete breakdown of each Fedration is given including numbers of brigades, battalions, weight, men, average EF, maintenance and troop breakdown.

7. An overview of the entire army is shown in the grey cells in columns Q and R.

8. Elite troops are those that have maximum allowable EF. They are highlighted yellow in the army lists.

9. Over EF troops are 1 EF over their normal EF and are highlighted in orange.

10. Troops that require training are highlighted green.

11. Troops are built by putting the barracks and then the troop type, not number, in the cells provided under Troop Building. NOTE: This is CASE SENSITIVE and must be as per the rulebook, ie grenadiers for France are “Gr” but all other countries are “GR”. The program determines the difference between Be for GB and Turkey.

12. Only brigades in barracks can have additional battalions added to them. Again, this is case sensitive. If the brigade is being trained as well the training costs for the Additional Battalion will be added. The barracks number will be entered automatically.

13. Brigades or entire Feds can have their headcount increased. The barracks is entered automatically. NOTE that the program doesn’t calculate if the EF is reduced from excessive headcount increase. If this is going to be the case then manually adjust the EF and HC of the battalions in the army list before hitting the calculation button.

14. Brigades or entire Feds can be trained by adding the numbers in the allocated cells. The barracks number is generated automatically.

15. Once all builds, increases and training has been entered press the “Calculate Troop Build Costs” button to generate the costs. NOTE: This doesn’t automatically update the Front Sheet. See Front Sheet instructions.

16. Always press the “Calculate Troop Build Costs” button if changes are made to the sheet.

Navy Sheet

1. The entire Navy is shown in numerical order on the left hand side of the sheet.

2. The maintenance and repair costs are shown against each ship.

3. The Fleet listing is shown in columns U:AE. This shows the Fleet number, location, loading capacity and gives a breakdown of the type of ships in the Fleet. Types 21, 23 and 25 are considered to be Men-of-War (MOW), all other warships are Frigates.

4. A breakdown of the entire Navy is given in cells AG:AK, together with Maintenance, Wine required and total loading capacity.

5. To build a Ship you simply put the type and barracks number in the cells provided. The Front Sheet is NOT automatically updated for builds until the “Generate Finances” button is pressed.

6. To repair a Ship you simply put the ship number in cells AG. The barracks and Front Sheet is NOT automatically updated for repairs until the “Generate Finances” button is pressed.

7. To repair a Fleet you simply put the Fleet number in cells AH. The barracks and Front Sheet is NOT automatically updated for repairs until the “Generate Finances” button is pressed.

8. To build a Baggage Train you simply put the barracks number in the cells provided. The Front Sheet is NOT automatically updated for builds until the “Generate Finances” button is pressed.

Map Sheets

1. The map sheets have icons supplied to help map unit movements. Double clicking the text on the icon will allow the text to be modified.

2. The European map shows an approximate population comparison in cells CK:CN. This is generated from the co-ordinates owned by a nation and the average population figures in the rulebook.

3. Each map lists the production sites that have the minimum population for each nation. The European map totals all the production sites for all the maps for comparison.

4. HINT: If a fleet is spotted it appears on the map. Right clicking the cell where it appears allows “Insert Comment” to be selected. If you add or modify a comment each time a fleet appears on can plot shipping lanes that a potential enemy might use. Comments can also be added to remind you to avoid the

co-ordinate if dead nation’s fleets are there.

Terrain and Data1 Sheets

Please do not change any information held in the sheets.

The Terrain maps can be printed to help plan your move.