Automated Excel Spreadsheet for AAP40 Banking


  • I’ve attached an Excel 2007 Macro-enabled spreadsheet that I use for banking in AAP40. It keeps track of income, bonuses, purchases, turn order etc – basically anything the banker would otherwise have to write down. This forum won’t let me attach a .XLSM spreadsheet, so I renamed it .XLS, you’ll have to add the ‘M’ to the end once you save it to your computer.

    I don’t know if you guys will use it, but it helps with calculating purchase costs, remember numbers, and settling the “I had 2 left over!” kinds of arguments that seem to pop up in the later stages of the game.

    There’s two steps to using it:

    1. Enter the number of each type of unit you’re purchasing in Column K
    2. Hit Ctrl-P to ring the purchase through (if you make a mistake, you can void purchases by entering a negative number in Column K and hitting Ctrl-P)
    3. When the turn is over, adjust the incomes/bonus of each country up and down.
    4. Hit Ctrl-T to advance the turn.
    6. Remember to subtract convoy damage from your bank after hitting Ctrl-T
    AAP40_Bank.xls


  • Since when is 6=2?


  • @calvinhobbesliker:

    Since when is 6=2?

    See? This is exactly why I need to use a calculator…


  • Yeah. You said 2 steps and you put 6


  • Yea I made a banking program for my ti-83 graphing calc. All I need to do is enter the numbers for spent Ipcs and collected ipcs. It will even keep track of the total ipcs spent and recieved. If I had a USB to calc cable I would post here but I don’t.

1 / 1

Suggested Topics

  • Compare AAP40 and AAP

    Dec 21, 2011, 2:42 AM
    2
  • Practical use of AAs in AAP40 ?

    Nov 21, 2011, 8:00 AM
    18
  • Is AAP40 broken?

    Jun 30, 2010, 3:33 AM
    37
  • 75
  • AAP40 map for Abattlemap?

    Feb 21, 2010, 5:25 AM
    5
  • AAP40 In Stores Now!

    Dec 15, 2009, 5:41 AM
    20
  • Scale of plastic pieces in AAP40

    Dec 14, 2009, 5:35 PM
    4
  • Rules for subs in AAP40

    Oct 31, 2009, 7:07 PM
    21
Axis & Allies Boardgaming Custom Painted Miniatures

59

Online

17.7k

Users

40.3k

Topics

1.8m

Posts