After a bit of work, I’ve managed to make my spreadsheet more presentable. It is largely the same as that described in the Scottish Forecast, the main difference being that it now contains two extra sheets. The first “overview” contains the key parameters.
If you click on the first box (country) it will display a list of counties and will automatically populate, the population, starting date, and a few other parameters from the list as shown in “parameters”.