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

During WW2 The Dutch Islands were defended. They actually put up a strong defense so they should have a army. Their pieces would be purple. This would be a mini nation people could play as, the person playing the U.S. would also play as the Dutch.

Dutch Setup

Java - 1 Infantry, 1 Fighter, Naval Base, Air Base

Sumatra - 1 Infantry

Sea Zone 42 - Transport, 1 Submarine, 1 Destroyer

Sea Zone 41 - 1 Submarine

@Panther

I came up with this before I used TripleA. TripleA is still vastly superior, but I wanted to share this anyway. It’s still somewhat useful for playing house rules that you cannot otherwise edit easily on TripleA.

As I said, you send the emails to yourself to keep track of it.

As for why do I not do Google Docs instead, I just didn’t do it and didn’t think of it.

I only used the Notes app on the Ipad, which doesn’t really work, and emails.

So perhaps Microsoft Word might be better.

It is very complicated. I do not recommend playing Global 1940 using this. Anything less complicated is manageable, but best to stick with the more simple side.

Thanks for moving it.

I have found it on eBay at decent prices…the WW1 1914 on the other hand is a little pricey($275)

Dear Sirs and Madams,

I’d like to introduce you my Microsoft Excel based IPC calculator/tracker for Axis & Allies Global 1940 2nd. My A&A hommies and I always forget to adjust the territory at any time during the game so I developed this Excel table.

It serves several functions :

track and calculate IPCs with territories and national objectives (few have to be adjusted manual (SZ125, Med, …) [sheet: IPC track]
ipcTracker.PNG

calculate Purchases per 1 round [sheet: purchase round]
purchase1.PNG

calculate all rounds [sheet: purchase chart])
purchaseAll.PNG

calculate land and sea battles (my dice colors are 1:=beige, 2:= blue, 3:= red, 4:= yellow, therefore the dice colors)
land.PNG sea.PNG

And here is:
AxisAndAllies_GLOBAL_1940_2nd_Initial_20200228.xls

Please don’t hesitate to ask if there are some questions.
Thanks for your feedback!

Tabletop Simulator has a lot of different boardgames and variants on it these days. You can virtually recreate any boardgame on it. So it has the boardgame feel of rolling dice and moving physical models around, though in congested areas like Europe this can get a bit tricky and you often select more than what you’re looking for.

Is it possible to play games here on a Mac?  I have been playing since the 80s.  Currently play Global FTF but am wanting to try some online games.

My 87 year old Dad, a WW2 veteran still plays using the OOB rules(corrected).  He would very much enjoy an OOB rules version of Triple A for when we all can’t get together for a f-t-f game.  And to practice, too I presume.

“Tall Paul”

You should wait a bit. Don’t rush, because Mr. Harris said that he want make a new update (maybe the final version) in like 4-6 weeks. From I can understand, alpha 3 is even more provisional than latter versions. No much point updating the module

About the charts, the other time I simply copy pasted the letters from the old files  :-) And when I do the module for the last version, I’ll have not much to change. The list would be:

Unit costs as you pointed Some NO boxes here and there (I still prefer the NO boxes near to the zone they are related, good old AA50 style) Setup in fact is the thing I hate more. One has to redo the whole setup to prevent glitches. Not difficult, be requires much work, and double check I’ll check the optionals chart, just in case some of them are obsolete (probably the NAP and the merry mongolians)

As for the mongolians, not much work to do. If they stay as they are, simply I should delete the NAP box (the mongolians substitute the pact), and when they are activated, Japan’s simply must put an ‘allied friendly’ marker.