HI kennethofborg,

1. The zero value territories are necessary if you want to calculate some of the additional National Objectives.
   e.g. the Soviet Union gains 3 extra IPCs if they occupy an original axis/pro axis territory even if it’s worth zero IPC: Sardinia, Sicily, Italien Somaliland;
   or the United Kingdom Europe gains 5 IPCs if it controls all of they original territories: Alexandria is worth nothing but UKE won’t get the NO’s 5IPCs if they don’t control it.
   But if you only want to calculate the territories IPCs you can delete (or comment for futher versions ;-)) these rows.

2./3. “n” means “neutral”: There are neutral, neutral pro axis and neutral pro allies territories in Global40.

For the insignias: Mr @Tjoek has created some roundels:
https://www.axisandallies.org/forums/topic/31982/tjoek-s-custom-roundels-and-tokens?lang=de&page=1

Best regards

Hi kennethofborg,
you’re welcome.

I’ve done a global IPC tracker with MS Excel (https://www.dropbox.com/scl/fi/qj1ukd81mhwvhwu9ajbo3/AxisAndAllies_GLOBAL_1940_2nd_Initial_20200312.xlsm?dl=0&rlkey=ndesbxts7ih1pcqknz2vriu6l), therefore I’ve got some preparation lists I can easily adjust:
BasicCountryListGlobal.txt
There’re all IPCs relevant territories included (also the NO ones without IPC value).

Here are some maps files:
https://www.dropbox.com/s/ona2aexfo66pxhw/Map.bmp?dl=0
https://www.dropbox.com/s/yi80qacpzzmcfj9/MapnoTerrain.bmp?dl=0

Loooking forward testing the calculator

Best regards

Great work! Is there also an IPC calculator for Global
One think: If a capital is captured the allied forces can’t gain IPCs for liberating territories which belong to that capital’s force. E.g. UK or US liberates Karelia after Germany/Japan occupied Russia

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]
  

• calculate Purchases per 1 round [sheet: purchase round]
  

• calculate all rounds [sheet: purchase chart])
  

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

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!

@Tjoek Thanks for the roundles. They look great! Just printed them on label paper, laminated them with matt sheet and used 2 Euro cent coins to stick them on.
Printed and sticked oranged roundels on the back for combat marker.
Just my 2 cents.