Announcing: A hopefully helpful resource!
I loaded all the troop/unit data from the Campaigns and Battles tables into a single Excel spreadsheet, for ease of use. Then I added a nice front-end template that can be used for printing out “unit cards” four at a time, to hand out to prospective players during playtesting. I wish I could fit some nifty graphics onto the cards, too…
There are four cells that you need to enter.
In the “Number” cell, enter the number of troops in the unit.
In the “Scale” cell, enter the scale at which the unit is being represented. Note that quantities will be calculated relative to the chosen scale. For example, a Platoon of 30 infantry is at full strength, but a Company of 30 infantry is seriously understrength.
In the “Race/Exp” cell, enter either “Veteran” for veteran troops, or the race of any non-human troops (“Elven” or “Gnoll”). If the race is an exotic type with only one troop type, then enter the name as a plural (“Hill Giants”).
In the “Type” cell, enter any troop type available to that race (“Light Infantry A”).
Everything else should work automatically. The quantities that are scaled proportionally based on size are the BR, any wages/costs, the uhp, and the number of attacks. If you enter a size above the maximum allowed for that scale, the unit will be flagged as “oversized”.