There you go guys
Please post any recommended improvements however in this current state is our preffered way to use it
Can’t wait – We really like your program!
I did not quite understand what you meant re accounting for liberartion
(do you just increase next turns Start IPC entry ? or does that screw later formulas ?)
and do you just change France’s next turn Start IPC to 0 ?
It would be easy enough to just give Germany 19 paper IPCs as plunder and allow them to spend it as well as the amount calculated without accounting for liberation – but I like the accounting to be captured by the spread sheet to keep the war room chart accurate.
Also Occupied Countries keep showing a starting income each turn based on their remaining land – what is the best way to account for that ( we have been earasing it by entering an equal amount of convoy loss each turn - is there a better way ??)
Thanks mate. I really appreciate your input and I am happy that you like it.
That is the best way to do it. Go to next round and do exactly what you said. You will have to keep changing France starting credits to 0 each round that it is not liberated. You should also change Frances ‘TOTAL IPCs carried forward (WITH bonuses / Convoy Dis.)’ to 0 each round that it is not liberated. That way it is easy and the graphs are spot on.
Doing this WILL NOT ruin the formulas in future graphs.
Please find attached a link to my simple yet detailed excel sheet which keeps track of your IPCs from round to round.
There is a war room on sheet 16 which can be entered any time to see the war trends over the game.
Please select the free download option down the bottom (they try to get you to pay).