Saturday, April 11, 2015


There has been some talk on the Lardie Forum of late about automating the CoCulator via Excel spreadsheet. Since I spend a lot of my days dealing with Excel spreadsheets (and apparently I have this kinda time), I gave it a go and came up with a basic sheet that calculates Force Ratings for infantry platoons. The data included (in the aptly but unimaginatively-named data worksheet) is mainly for early war lists but most of the data lists are editable and have room for extra entries (and thus show up in the appropriate pick-lists).

The worksheets are protected but not with a password. If you want to look at the formulae, unlock the worksheet and unhide all columns. It's nothing elegant but seems to work well enough: link

1 comment:

  1. Thanks for sharing this. In fact it was perfect for updating the HG list.