AfterCiv - Quick System Update
After some tinkering and plugging away at formulas, the Excel rule calculator now runs the game's resource calculations with very little input. I just need to do the following:
Add the number of each unit that is currently at play.
Add if/which tile types are being 'worked' by which unit.
This gives me a turn by turn calculation of resource production, upkeep and total population numbers. It is really simple and rudimentary, however it actually lets me start thinking about much larger playing fields so that I don't need to keep track of individual values.
On a separate sheet, I have entered every tile type and relevant values for bonuses when worked by a unit. Because I wanted to keep a running iteration/tweaking of values, everything is dependent on a base values or rules.