Inspired by the Pharaoh Housing and Culture Worksheet, I decided to take a stab at designing a similar tool for Caesar III. I've tried to mimic the Pharaoh worksheet's look and layout as far as possible since Nero Would and VitruviusAIA did such a great job in the first place.
I would now like to request the community to try out the tool and check for errors in calculation or assumptions. Once we have some confidence in its accuracy, I would be happy to upload it to the Downloads section but for now I've made it publicly available viaDropbox.
Notes:
Fish production is not calculated by the worksheet since it depends on the distance from the wharf to the fishing grounds as detailedhere. If there is a reasonable way to estimate this, we could consider building it in.
The default percentages of 15% and 10% for school and academy going people respectively were arrived at based on sample data from three missions. I'd be happy to alter these if someone has done a more comprehensive study.
As for enhancements, I'm thinking of adding a section for calculating industry requirements for exports (user input will be number of shields traded by the city). This would calculate the number of raw material and finished goods buildings that are required to meet the demand.
I would now like to request the community to try out the tool and check for errors in calculation or assumptions. Once we have some confidence in its accuracy, I would be happy to upload it to the Downloads section but for now I've made it publicly available via
Fish production is not calculated by the worksheet since it depends on the distance from the wharf to the fishing grounds as detailed
The default percentages of 15% and 10% for school and academy going people respectively were arrived at based on sample data from three missions. I'd be happy to alter these if someone has done a more comprehensive study.
Mission | Population | School age | % | Academy age | % |
---|---|---|---|---|---|
Capua | 1593 | 264 | 16.6% | 153 | 9.6% |
Tarraco | 2996 | 457 | 15.3% | 257 | 8.6% |
Mediolanum | 5148 | 880 | 17.1% | 399 | 7.8% |
As for enhancements, I'm thinking of adding a section for calculating industry requirements for exports (user input will be number of shields traded by the city). This would calculate the number of raw material and finished goods buildings that are required to meet the demand.