I have updated the Army List spreadsheet so that you can choose an army, then the troops can be selected from a drop down for that army, and the troop stats are populated.
https://docs.google.com/spreadsheets/d/ ... sp=sharing
How to use it:
1) Open the link above
2) File -> Make a copy
3) In your own copy, right click on TEMPLATE 200 pts sheet at the bottom and click Duplicate. This takes a few seconds for some reason.
4) On the new sheet, click the small arrow to the right of the CHOOSE LIST FROM DROPDOWN TO START and select one of the armies from the drop down list.
Once you have done that, each troop name in the division boxes will have its own drop down where you can select the troop type, any selection will fill out the troop stats on the line, just fill in the number of units as usual.
At the moment, only the French armies are supported because it is quite tedious to fill in the stats and this is my only army at the moment!
To add a new Army, create a new sheet in the format of FrenchRepublic and name it after the list e.g. Wuttemburg and not the army/theatre e.g. Wuttemburg 1809. Then under ARMYLISTS sheet, add a line for the Army name and which list it uses in the next column.
It sounds more complicated than it is
