Results 1 to 6 of 6

Thread: Medieval II: Total Casualties of War

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1

    Icon10 Medieval II: Total Casualties of War

    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.


  2. #2

    Default Re: Medieval II: Total Casualties of War

    Okay, nevermind. I guess i can't upload an Excel file. Well, you can delete this thread I guess.


  3. #3
    Eastern.Europe's Avatar Foederatus
    Join Date
    Nov 2011
    Location
    Des Moines state of Iowa United States
    Posts
    32

    Default Re: Medieval II: Total Casualties of War

    Could you provide the macros for your spreadsheet? I too am crazy when it comes to the extranious things that M2TW can provide. I each turn look at the screen for what amounts I have traded and how the harvest went. This way I can determine if a city will still be a city, what its main design is, ie trading captial, rich farmland.

    You could also set your excel as a webpage so we could go out there and at least look at it

    Thank you for sharing I for one think it is a very awesome idea!

  4. #4

    Default Re: Medieval II: Total Casualties of War

    Quote Originally Posted by FritzRKS View Post
    Okay, nevermind. I guess i can't upload an Excel file. Well, you can delete this thread I guess.

    Pull up your Excel file, hit the print screen button (to the right of F12), and then right click and paste to paint.
    After you save it to paint I believe you should be able to upload it on here as an... .JPEG file or something?

  5. #5

    Default Re: Medieval II: Total Casualties of War

    Here's the screen shots at least. If anyone knows how I can easily share the Excel file I'm all ears.


  6. #6
    Mhaedros's Avatar Brave Heart Tegan
    Content Emeritus

    Join Date
    Feb 2011
    Location
    Finland
    Posts
    8,764
    Blog Entries
    2

    Default Re: Medieval II: Total Casualties of War

    Upload them at Gamefront It's easy and free
    Under the patronage of Finlander. Once patron to someone, no longer.
    Content's well good, innit.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •