Backwards Logic
Emperor Palpatine
Alright, I've gone ahead and updated the spreadsheets and optimized them as best I could. Things aren't too bad and shortly after the war starts we'll have a sizable military to stifle Gandhi. I've also figured out that Novgorod should go worker first and improve the iron first. This seems to get the city online faster and by turn 47 it was producing units at a considerable rate. I've also squeezed in another settler by turn 44 and due to some savvy worker management am able to get the seafood site (aka green site) settled the same turn and having a work boat chopped out the same turn. While this isn't reflected in the spreadsheet just know that it is possible.
Moscow sheet:
St. Pete sheet:
Novgorod sheet:
Worker Moves sheet:
There's only one major micromanagement issue here to make note of. On turn 32 to get St. Pete to grow a turn faster I switched out a grassland hill mine for a grassland plains forest. Other than that once the cities start working a tile they continue to work the tile.
Please look over and comment and if there's any questions do not hesitate to ask. There is one error in the worker move sheet I should point out. It says to move "1 SE, 1 S." This is incorrect, it should read "1 SW, 1 S. The grassland hill is the tile 1 E of St. Pete and where the mine should be built.
Attached is a test save for you to practice with before you take on the real thing. That way, if you think something should be done differently you can stop and post it instead of what happened earlier. Plus it will help get you familiarized with working to a spreadsheet and hopefully we'll avert any future problems. There's one minor difference which I don't think will impact anything, but in Moscow there's one extra hammer in the bin most likely due to a rounding issue. The food bin is correct and St. Pete's numbers are correct as well.
Moscow sheet:
St. Pete sheet:
Novgorod sheet:
Worker Moves sheet:
There's only one major micromanagement issue here to make note of. On turn 32 to get St. Pete to grow a turn faster I switched out a grassland hill mine for a grassland plains forest. Other than that once the cities start working a tile they continue to work the tile.
Please look over and comment and if there's any questions do not hesitate to ask. There is one error in the worker move sheet I should point out. It says to move "1 SE, 1 S." This is incorrect, it should read "1 SW, 1 S. The grassland hill is the tile 1 E of St. Pete and where the mine should be built.
Attached is a test save for you to practice with before you take on the real thing. That way, if you think something should be done differently you can stop and post it instead of what happened earlier. Plus it will help get you familiarized with working to a spreadsheet and hopefully we'll avert any future problems. There's one minor difference which I don't think will impact anything, but in Moscow there's one extra hammer in the bin most likely due to a rounding issue. The food bin is correct and St. Pete's numbers are correct as well.