Building planner for Rome

[SusaVile]

Hello there. When Rome 2 was out, I realized that the buildings and provinces need to be planned out from the very beggining. I usually write a few notes so I can keep track of my decisions, but then I tried to put them on an Excel spread sheet. So far, so good, it helps out quite a bit to predict the outcome of a province, and specially to avoid most unhappiness problems and shortages of food. I wanted to share it, so that it may help you guys as well.

I only made it for the Roman faction for now, but I can do it for other factions if you'd like me too. It mainly takes into account Public order, food, growth, research, wealth and % wealth factors, and I reserved spots for the difficulty bonuses, faction bonuses, tax rate and tech influence. All of those can be changed and the formulas will apply. There is also a row that you can manually change with the edicts, since the effects are so varied that only going into macros could I make those automatic.

To add a building into the province:
-Simply select the entire row of the building on it's sheet;
-Copy it;
-Paste it on the province "building" slot;

Notes: You have to know which goods are produced in which settlements, as well as which ones have a port or not. Also, don't change the colours or you will have to change them on all the sheets Hope it helps, any questions, message me here. If you find any bugs, well, it's only natural, right?
Cheers
SusaVile
Total War Youtuber

http://rapidshare.com/share/C916AE4A...8F1B0D77F9B5EC