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!

You think you can- don’t chance it though- BattleCalc it baby!!! :-)

You know what I am talking about obviously!  Funny how a misplaced ; can seem so deadly yet 100 of lines of code ready to roll back database transactions in case somebody kicks the power cord in the middle of a batch update never get noticed by the higher ups.  Well until a fortune 500 company sues you because their database is corrupt

Knowing how much you will the battle with determines if the enemy can successfully counterattack you or not or even if its financially worth it.  So you either go into a battle thinking “go so big I cannot be counter attacked” or you end up ‘dead zoning’ a territory then you only want to use just enough to take it. So if you are using 4-5 air units combined with 2-3 land units to clear out 2-3 enemy land units you want to win and have only 1 land unit left while your air units fly away.  Winning a battle like that at the cost of a few airplanes is not success.  In many battles you know the enemy can only counter attack you with a small land force, so you want to the battle 80% of the time with just enough forces that the enemy is 80% likely to take a larger IPC cost to counter attack your surviving force.  I don’t mind winning the battle with 4 tanks and 3 infantry left knowing s/he is 72% likely to win a counterattack.  The enemies 2 infantry and 6 fighters can no doubt counter attack me and win.  I lose 29 IPC most of the time, but s/he loses 26 or 36 or 46 pretty much equally and a great chance of losing even more IPC to win the battle.

The other bar chart of value in AACalc is the IPC differential.  Again, winning battles where the enemy loses 10 infantry and you win losing 4 tanks, 4 fighters and 2 bombers is going to lose you a war.  It’s nice to enter a battle and determine not only the odds of success, and the distribution of likely outcomes vis-a-vis number of units remaining and lost but also the distribution of IPC differentials in various battle outcomes.

Again, using AACalc as an example running 1000 iterations of the battle of 20 tanks versus 14.  There is a bottom section titled “Defender IPC losses in excess of Attacker IPC losses:”

This bar chart shows likely outcomes of the difference in IPC lost in the distribution of likely outcomes.

Maybe a new window or set of tabs where one one tab/window could contain the summery of the battle, what units started, where, other labels maybe, a second tab with a chart of likely outcomes as far as what units are lost and remaining, and a third tab with the distribution of IPC outcomes in the battle.  That would capture the functionality of AACalc but in a much more modern GUI.  Being able to resize the window and chart dynamically is great.  Once you do it once you will re-use that code for every project.  Being able to launch 2 or 200 windows is really no different in complexity but is really impressive having unlimited windows of information.

Check out iTunes

Actually fixed order of loss is pretty reasonable assumption for odds calculator…. We have to assume some type of standard order of loss.  It doesn’t have to be strictly decreasing…  For example, if attacker wants to capture at all costs, we can lose fighters and bombers before tanks.  Or if attacker wants to capture with at least 10 ground units, that’s also possible.

AA guns can be handled by constructing separate tables corresponding to number of AA gun hits.

So if attacker has 2i, 2a, 2f, and we’re facing AA gun, we need to solve
F(f, f, a, a, i, i)  ;; 0 AA hits
F(f, a, a, i, i)  ;; 1 AA hit
F(a, a, i, i)  ;; 2 AA hits

Subs only hitting ships can be handled in similar approach…
Suppose the defending force is 2 fighters, 1 carrier, 1 battleship

If the attacking force has some subs, then we may need to remove units out of order.  So we need to compute:
F(B, C, f, f)    ;; 0 naval hits
F(B, f, f) ;; 1 naval hit
F(f, f) ;; 2 naval hits

hrm, so I guess I would have to readjust the values and run it through the formula, and that would be…

Attacking units:
Soldiers: 16.6% / 10= .166 x 2 Soldiers = .332
Tanks: 50% / 10= .5 x 1 tank = .5
Fighters: 50% * 83.3% = 41.6% / 10 = .416 x 3 Fighters =  1.248
Total Attack Value (TAV)= 4.16

Defending Units:
AA’s = Already Formulated inside the Attacker’s Planes
Soldiers: 33.3% / 10= .333 x 1 soldier = .333
Tanks: 50% / 10 = .5 x 3 tanks = 1.5
Fighters: 66.6% / 10 = .666 x 1 fighter= .666
Total Defense Value (TDV)= 2.499

4.16/6.659= .624*10= 62.4%

So then the attacker would have a 62.4% chance and the defender would have a 37.6% chance?  I guess that sounds about right then.  Hrm, I was so sure I had it but that does look like it would be correct.  Thanks for the heads up ;)

Very nice.