So, after playing my first couple campaigns, I thought it would be fun to see the historical body count over time. So, I started playing around with a couple pie graphs tied to a spreadsheet. After tweaking it over a few short-lived campaigns here and there, I finally perfected it (I think) and thought some of you might enjoy the end result too! Personally, I use a second tab to keep track of my overall strategy. Yes, I know it's weird. As for the spreadsheet:
1) From the battle results window, enter casualty values on page three (executed prisoners go into the 'Killed' tally after returning to the strategy map; ransomed prisoners don't). I always use the 'Enemies Killed (Captured)' and the 'Men Lost' values due to healed casualties, and if I lose the battle, then I just italicize the 'Captured' value as a reminder. I leave all of that there until the next save point (that and multiple battles in a turn are the reason for the multiple rows).
2) Add the respective values to the current 'Killed' and 'Dead' values (white & gray rows, respectively) on page one in your current Faction Leader's rows. The spreadsheet will total everything by faction, faction leader, and grand totals.
3) Enjoy the awesome looking pie graphs on pages two and four!!!
Feel free to mod this however you'd like! This has just the vanilla factions, but it will work for as many as you need as long as the formulas include all the applicable cells and the graph legends are updated.
![]()




Reply With Quote







