M2:TW Kill Sheet

[Lambretta]

Hi chaps,

I like to keep track of how many people I've killed and captured on games like this. Now this is easy enough to tally up but I decided I wanted a more specific kill sheet. After unsuccessfully scouring the web for one that suited my purposes I decided to make my own.

It adds up how many soldiers you've killed for each faction and in total, how many you've captured for each faction and in total, and how many men you've defeated (killed and captured) for each faction and in total.

So as you progress into the late game you will start to see some interesting figures. Here is a screenie:



All you need to do is update each faction after every battle and it will automatically update everything. It does require some basic addition but that's what a calculator is for!

There are two versions contained in the download. One for OpenOffice and another for Excel.

I have converted it to Excel (made in ODS) but I cannot test it, so if someone could test it in Excel to make sure the formulas work that would be great, cheers.

Feel free to share this as long as credit is given.

VER 1.1: Added a ratio of losses to kills. This shows how well you are doing against your enemies. I will be adding a losses to kills column for all factions in future updates.

[Vissewalde rex de Gerzika]

I bet Ledend of total war can contribute to your sheets, he has statistics shown after each of his blitz campaign videos, so i imagine he keeps track of such things as well.

[Lambretta]

Might call him up on that, there are a few things I could add to these.

[Edward Stark]

Hi chaps,

I like to keep track of how many people I've killed and captured on games like this. Now this is easy enough to tally up but I decided I wanted a more specific kill sheet. After unsuccessfully scouring the web for one that suited my purposes I decided to make my own.

It adds up how many soldiers you've killed for each faction and in total, how many you've captured for each faction and in total, and how many men you've defeated (killed and captured) for each faction and in total.

So as you progress into the late game you will start to see some interesting figures. Here is a screenie:



All you need to do is update each faction after every battle and it will automatically update everything. It does require some basic addition but that's what a calculator is for!

There are two versions contained in the download. One for OpenOffice and another for Excel.

I have converted it to Excel (made in ODS) but I cannot test it, so if someone could test it in Excel to make sure the formulas work that would be great, cheers.

Feel free to share this as long as credit is given.

It will save your kills after every game? Or did i read it wrong?
Could you eleborate some more. I
My english is bad

[Lambretta]

It will save your kills after every game? Or did i read it wrong?
Could you eleborate some more. I
My english is bad

Hi mate,

It tracks your kills and losses in a campaign. You have to type in the numbers yourself, but this will work out the numbers so that you can get some detailed stats of how many losses there have been for your own faction and other factions.

So for example, if I fight a battle against France, and kill 100 soldiers, I'd add 100 to the France column under men killed. The spreadsheet will then automatically update itself.

[Edward Stark]

Hi mate,

It tracks your kills and losses in a campaign. You have to type in the numbers yourself, but this will work out the numbers so that you can get some detailed stats of how many losses there have been for your own faction and other factions.

So for example, if I fight a battle against France, and kill 100 soldiers, I'd add 100 to the France column under men killed. The spreadsheet will then automatically update itself.

Okay i understand now. It gives a nice twist to the game except that you have to do it manually.
If you could automate it of some sort it would be totally awesome!

This gives a fun perspective to the game and even more replay value!
Thanks.

[Lambretta]

Ahh yes, but unfortunately there's no way to do it automatically. I find this is the simplest way to do it,

[Edward Stark]

Ahh yes, but unfortunately there's no way to do it automatically. I find this is the simplst way to do it.

Okay thanks for this great document!
I will use it from now to record my own stats.
Sadly you can't really track the other faction their stats in a campaign.

Many thanks again very nicely done.

[Lambretta]

Okay thanks for this great document!
I will use it from now to record my own stats.
Sadly you can't really track the other faction their stats in a campaign.

Many thanks again very nicely done.

Glad that you like it! I will be updating this regularly with more detailed stats so make sure you check back! Cheers +rep

[Lambretta]

Ver 1.1 is up, this includes a ratio to show how well you are doing in your battles. If your ratio is below 1, maybe you should figure out some new battle tactics!

I should note that this will also work for every mod, it's a simple case of inserting new cells and copying the formula in the men defeated column to it, as well as renaming the factions.

[Incredible Bulk]

Nice gave you some rep

[Highlander of Scotland]

how about adding a win to loss ratio and enemies killed to friends killed, also how about adding civilians killed and cities conquered.

[Lambretta]

Nice gave you some rep

Cheers!

how about adding a win to loss ratio and enemies killed to friends killed, also how about adding civilians killed and cities conquered.

Win to loss ratio is a little bit inaccurate on this game because it counts withdrawal from battles as a loss. I can add that though if you like.

Enemies killed to friends killed is already in there.

Will add civilians killed.

Regions conquered is a bit pointless, because it shows you that in game. Same with turn numbers etc. The point of these kill sheets is to track figures that the game doesn't track for you, mainly kills and how well you're performing against each faction.