[Pacific 1940] teaching 7rd old son (and learning self) -how do I use Excel Macro from fasthard Bm4 to play boardgame pacific only


  • Re: Help learning the game

    hello all, I bought the 1940 2nd edition, PAcific version of the board game to get my 7 year old son away from computers haha!

    however now he wants to play it and I am really baffled about how to keep score. i only have about 1-2 hours per week, and barely know how to start.

    the IPC tracking etc are hard to keep track of when you only play every other Saturday for 2 hours!

    Fasthard @fasthard kindly gave me the BM4_XvsL_GER1_20241001-v1 download with macros, and it is mind blowing!

    i am in Australia, East Coast. is there anyone I could ask if I can call or video call or whatsapp to get some tips so I don’t keep disappointing my son? :)

    basic questions to get going. eg what does BM4 mean.
    how to use an excel tracker, are there instructions?
    thanks!

  • PantherP Panther moved this topic from Axis & Allies Pacific 1940 on

  • @allister i adapted the excel to Pac, not totally perfect but ready for your game!

    https://www.dropbox.com/scl/fi/t6ke3kuzrdzkoa9f3fetb/Pac_XvsL_GER1_20241103.xlsm?rlkey=6qc6026314vfmbf46noth8wqr&st=8l2a197o&dl=0

    You can change the terr owner via drop down below the territory (European forces will be removed in further versions ;-)).
    National objectives will be counted also (just check the checkboxes if the political situation changes). In best case correctly, didn’t found time to check them.
    You can also add or subtract in the convoy and capture/rest column. (+convoy will be subtracted)

    On the buttom left side there are the calculations (please only edit political situation checkbox and convoy/rest), on button right there you can “store” the IPCs and round.

    Have fun and please contact me if you have any questions.


  • @fasthard

    thanks heaps! . I am extremely impressed! Didn’t expect it so quickly!

    I have never used any of this type of tracking workbook, but I guess in this community it is a regular thing. Is there an instruction form or loom video of a basic usage?

    Example instructions

    • when playing a new game, adjust tab 1 etc etc

    • when Japan has its turn, first it will use the purchase Japan tab z etc etc.

    I am guessing there is something somewhere but hoping for a "keyword"5 to search for to find it?

    Thank!!!


  • @allister I don’t think that anybody here uses this excel. I created it because i was fed up with recounting territories and ipcs. In the “IPC track” tab there is everything you need to count IPCs.
    There is also a tab “purchase” where you can calculate your purchases (not yet adapted for pacific).

Suggested Topics

Axis & Allies Boardgaming Custom Painted Miniatures

40

Online

17.4k

Users

39.9k

Topics

1.7m

Posts