Rome 2TW: Excel Campaign/Battle Tracker - WIP
DOWNLOAD VERSION 1 HERE
Instructions
Unfortunately, I never made any instructions. However, the entire thing operates through information you type into the INPUT SCREEN tab of the file.
In the download above, it contains the campaign I played and used in the images below. I left it there to show you how it will look. To remove my stuff:
1) Go to the Tab called "Battle History" and delete cells A2 through R106. To do this, left click on cell A2. Scroll down until you see the last of my entries on row 106. Now hold down the shift key and left click cell R106. This will highlight everything. Hit Delete on your keyboard.
2) Do the same thing for cells A2 through F16 on the tab called "WAR PHASES"
Hi everybody,
This is not a in game mod, but I have seen a few posts from people wanting to know if something like this exists or not. To my knowledge the only excel type workbook associated with Total War is for helping oversee towns and growth.
What this spreadsheet does is allows you to input your data from your battles you have while playing Rome 2 and it spits out charts and statistics showing you a range of interesting aspects of your play through. Theoretically, all you will need to do when it is completed is to simply jot down on a piece of paper as you play all your battle statistics (what legion(s) fought, who they fought, what year and casualties...along with some other information that is not important unless you just like to be detailed).
The main areas it will detail out in the first release will only be for the following:
VER 1 Release will Have:
- Total Casualties of your Faction vs your Enemies
- Total Casualties each year (so you can see when the deadliest years where and which all factions lost soldiers to fighting) (helps find deadliest year on record)
- Total Casualties per "Theater of War" - This is what I need a geography helper for
- Total Casualties inflicted on each faction by you (helps quickly see who you* up the most during your campaign)
- Total Casualties sustained from each faction (to see who gave you the toughest fight)
- Longest unstopped war(s) during your campaign
And if I decide to make a VER 2 Release
Army Charts -> Chart for each of your Armies
- Total battles fought
- Total battles lead
- Total battles assisted in
- Total Armies crushed
- Total Casualties inflicted
- Total Casualties sustained
- Most active Theaters (tracks total battles in each theater)
- Deadliest Theater (tracks where you killed and lost the most men in each theater)
What I need help with is the "Theater of War" parts. I do not need any help in terms of the excel file itself, just for someone knowledgeable enough in geography to map out what zones would be say for example: Northern Italy, Germania, Gaul, British Isles, North Africa, Spain, Scythia, Mesopotania, etc etc etc.
Here are some screen shots of what I have so far.
This first image illustrates the total amount of casualties each year. RED is me (Rome). The other factions list are color coded to the color shown in the legend. The legend is the time duration of the war I had with them. The 0 with a hash tag through it (will replace that image with a skull and bones later represents that faction was destroyed. Ill add that little dove thing to show a peace treaty was signed.
The next shows how the data is added. Note that their is a lot of data that wont be used in any charts or calculations in the first release. But like I said earlier, its for those of us who are very organized simply for the fun of it.
What I need help with
As I stated earlier, I was a horrible student in school and I need help from someone who has a very basic grasp of geography. What I need is for someone to do is to take this image below and put it in photoshop or Microsoft paint and simply draw out the outlines of what they would consider to be a realistic "Theater". A theater would be something like Northern/Southern Italy, Germania, Scythia, Balkans, Mesopotania, North Africa etc etc. Then be sure to name them. Please keep them each to at least 5 provinces and not gigantic like "Africa" and "Middle East". However, for some like the British Isels, I know there is not much you can do there except only use the three territories for that one.
Why I need this information. As you see in the image above I have location on there. Basically I am going to hardcode all of the regions in Rome 2 to represent a specific theater of war. So if the battle was fought in say Mediolanum, it would automatically distinguish that the battle occurred in Northern Italy. This is then recorded in a illustration chart yet to be seen that will show the "Deadliest Theaters of War" for the entire campaign you fought.
UPDATE ON IF I MAKE A VERSION 2 LATER DOWN THE ROAD
- Once I finish Version 1 which will have or deal only with casualties of war, year and location. I MAY also make one for the individual Armies/Legions themselves that track how many battles they fought, how many men they lost and killed over the campaign, what theater was the worst for them, wins/defeats, etc. However, this is a big IF. Rome 2 is....well.....I have not played it in a year because I am still not really impressed. I have made drastic changes to get the graphics and lag improved, but it is still tough. DeI is making it much better.....but anyway, I just dont want to get anyones hopes up for a Version 2 of this is what I am saying. I am not a great coder in Excel and I know that for the legion part anyway it will require VBA more than likely. I am still very new to that area.
IF YOU PLAN ON DOING THIS, PLEASE REPLY BELOW SO THAT YOU DO NOT WASTE SOME OTHER GOOD SAMARITANS TIME. AND THANKS IN ADVANCE FOR THE HELP!
Reply With Quote
