[Excel] Starting Drop Spreadsheet

[cairnswk]

tnb, can you put a divisor drop list in this or is it already there and i am just not reading it properly?
Also in the lastest version you've added the compoment function - what does that do please?
sorry to be so dumb.

[thenobodies80]

What do you mean with divisor drop list?

The components are the number of territories for each starting positions. You certainly know that you can have, for example, 3 starting positions, each one with more than a single region into it.
Unfortunately, for now you can use the spreadsheet only if you have the same amount for all starting positions. So if you have 2 with 2 components and 1 with 3 components, you need to do your math manually.
I'll develop a better version in future, as soon as i have a bit of free time. So don't be afraid to ask if something is not clear or if you would like to have additional options/features into it.

Nobodies

[cairnswk]

What do you mean with divisor drop list?
....
Nobodies

The divisior....normally you get +1 for every 3 territories you hold...that is with the divisor at 3.
But some maps now are having a divisior of 4...meaning if they hold 18 terrtories, they get +4, not +6.
This is to do with min/max reinforcement.

[thenobodies80]

Oh, now i understand. Yes it can be added something like that...it is a simple thing.

But this tool doesn't count the number of troops you start with, but the number of regions.