New Killsheet : Release

[makeshift52]

Secretly, I have been working on another killsheet for about a month now. Now, most of you will ask what benefits my one brings, ad why bother downloading it? The answer is in the readme, please use this thread for downloading and posting CONSTRUCTIVE CRITICISM. If you say it is "just crap" or another derogiratory term with no reason, I will disregard it completely, that said, straight on to the Readme!

Version 1.0 Killsheet Readme

You must have Microsoft Excel! My killsheet will tell you the exact ratio of kills, unlike the before released ones. For Example:

If I have lost 15,000 Romans overall, and have killed 1000 Macedons overall, then the ratio currently will be 1:15.

However, I am writing it so that it will take into account the number of Romans dying in the same fight which Macedons are involved in.

For Example:

If I have lost 15,000 Romans overall, and have killed 1000 Macedons overall, my killsheet will then take into account the number of Romans killed trying to kill Macedons, say only 2000 Romans have died to Macedon. Therefore, the correct ratio should be 2:1.

It will also tell you how many battles you have won, lost or drawn.

This is done through VisualBasic coding (or VB for short). To calculate these ratios just click on the relevant button. It is an excel spreadsheet. It contains running formuas. To get it to work you must enable Macro. If it doesn't give you this option on startup then go to tools/options/security/macrosecurity/medium/ok. You must save it and then restart it. If it gives you an option of whether or enable or disable macros at the start then choose to enable them.

The chart is on a seperate sheet.

Good luck and happy downloading!

[lt1956]

Nobody needs to worry about a Virus with this Killsheet, I was sent it to test and its ok. Please let him have feedback as he put alot of work to make SPQR kill counting more fun. :-)

Lt

[NorthHammer]

I cleaned up a few cells and hid the "divide by zero" error message. I could probably throw in some complicated calcs too if there is anything specific you want to have.

[Freddie]

I cleaned up a few cells and hid the "divide by zero" error message. I could probably throw in some complicated calcs too if there is anything specific you want to have.

Thanks for file but Excel is saying something the macros and my security level being to high. This is despite the fact I have security down to low.

[makeshift52]

Thats the thing, I have run out of possible functions, I can write in VB however, which is probably quicker than Excel because it has to loop "C", then "C" again, for about 6 times before actually doing it, whilst mine loops straight into VB.

Any other posible functions anybody?

[NorthHammer]

Well it depends on what kind of statistics you want to produce.

We could brainstorm some new stats.

[makeshift52]

That would be a good idea - but apart from the ones I have already done I have run out of ideas. Any other ideas any one?

[makeshift52]

Anyone?

[Faenaris]

I like the killsheet, but is it possible to have a graphic? I love seeing some bars rising.

Also, when I tested it, I entered a "mock" battle (more a test than a real battle). I had 200 romans dead, 750 Gauls dead. I typed in the values, hit calc ratios button... and I see an extra line of "ratio's" appear. This is on R17. Is this supposed to happen?

And in the first column, where you enter "won" ... I love to add who my general was and who his adversary was. But then i cannot use the "numbers of battles won" option. Is there anyway around this?

[makeshift52]

There is a chart inbetween each worksheet!

Which version do you have - Northammers or mine?
The difference is mine works - not Northammer's fault, but I can't seem to fix his. If you download the original, and merge the cells(to make it neater) then it will work.
Follow the instructions above.

Sorry to cause any inconvenience - I didn't know until now

ANNOUNCEMENT - ANY ONE WHO HAS DOWNLOADED NORTHHAMMER'S UPDATED VERSION PLEASE DOWNLOAD THE OTHER ONE (THE FIRST ONE) IT AS NORTHHAMMER'S WILL NOT WORK - UNFORSEEN ERROR. I HOPE TO FIX IT SOON BUT IT WILL REQUIRE ANOTHER DOWNLOAD.

[makeshift52]

Freddie did you follow the instructions -

"To get it to work you must enable Macro. If it doesn't give you this option on startup then go to tools/options/security/macrosecurity/medium/ok. You must save it and then restart it. If it gives you an option of whether or enable or disable macros at the start then choose to enable them."

[NorthHammer]

I think my default is disabled for macros. That's probably the cause. I can delete my attachement if you want.

[makeshift52]

It would probably help, unless you can think of a way around it. Any function requests anyone?

[NorthHammer]

its removed.

how about throwing in average people killed per battle, averge man lost per battle. (taking into account all battles)

throw in some stats about percantage wins, lossses, men lost in battles lost. i don't know, i'm just spitting out ideas

[makeshift52]

I'll try - hell I can call it version 2.0!

[Maethius]

Damn practical thing this killsheet!!

[Flanus]

I like the sheet. Thanks for it.
What about some stats for every single leader of your armies ?

Btw. On one computer I have no problem with settings of macros, I see the buttons on the right side of the graph, but on the other comp. I had to change the settings the way you say...and now I see strange numbers. Strange counts, no buttons, and fields on the right side of the graph with no linked stats show only "DIV....something".
I see the way of counting up in the bar in these cases, so I do not care much about this thing, but what I do not understand are the numbers shown for nations I have already fought with. Ratio 0,6 : 1 with Gauls ??? Wait a minute...the reality is different :-)

[makeshift52]

Sorry, is there a problem. Lol, I sound like the badguy in any film!

[spiers]

Never used the original spreadsheet and wont use this one currently, just asking if it would be possible to make it auto-calculate? What i mean is after each battle a box will come up and aslong as we have the spreadsheet open it will move the data to whatever cell it needs to be in? Probably just a glorified copy and paste feature i think, could make it understand which factions have just thought couldnt we? including the name of the battle such as seige at Sparta, is it just programming it to copy and paste or is it much harder than that?
Thanks.

[makeshift52]

From what research I have done into it, it is much,much harder than that. If anyone could give me some instructions then I will do it. I can programme but I don't know about that.