This spreadsheet will generate a random (British) platoon for Troops, Weapons and Tactics/Platoon Forward. Of course it can be used for any other platoon level wargame (NUTS etc) though you will have course have to tweak the stats. For reference TI is Tactical initiative, and runs from 1 (plodder) to 4 (heroic). The Big Man Bonus is the extra added when a leader is directing fire (Typically 3d6-3 for rifles up to 4d6+4 for MG42, the results table maxing at 36). Making the Big Man drop down YES shows the values for that man (TW&T is not normally interested in non leaders). I have defaulted the Lance Corporals, who lead the Bren gun group to BM, as they may well be called on to replace a killed section leader during a battle.
I suggest that you put ‘Workbook Calculation’ (found under Options/Formulas) to Manual, otherwise everything changes each time you change a cell. F9 is the manual update. Use Copy then “Paste Special –>; Values” to put the results you want to keep onto a fresh spreadsheet (this pastes results, rather then the formulae, so won’t keep getting updated).
Note – this is a Excel 2007 spreadsheet, so has the extension .xlsx (see below for a possible earlier version)
This is the version saved as compatable with Excel 1997-2003. I can not guarantee which bits (if any) will work. If anybody wants to do a rewrite I’d be happy to work with them on it.
Rights/IP stuff. I’m providing this free for personal non-commercial use, the basic work remains mine. I haven’t put anything malicious into it, but I can provide no warrenty etc etc yadda yadda yadda. Feel free to edit the names/platoon layout for other nations – I’ll happily upload it here or provide a link to where ever you host it: My Gmail address is (unsurprisingly) Last.Hussar@…