Page 1 of 1

Keeping Records?

Posted: Wed Dec 07, 2005 7:19 pm
by spedius01
Ave

I have been recording my games in speadsheets using Microsoft Excel, below is an example:

Image

Image

Vale

M. Spedius Corbulo

Posted: Wed Dec 07, 2005 8:12 pm
by sacredzero
Is that Level then New Level at the end of the battle?

Posted: Wed Dec 07, 2005 8:21 pm
by spedius01
sacredzero wrote:Is that Level then New Level at the end of the battle?
Ave sacredzero

Yes, if you scroll over to the right and check out the end column under the heading "Promotions" all the Ps indicate those units who got promoted.

Vale

M. Spedius Corbulo

Posted: Wed Dec 07, 2005 11:57 pm
by venividivici
Good grief :shock: You have far too much time on your hands Spedius :)
I just take screenshots if I want to record stats but your method is certainly more comprehensive. How long does it take to compile and enter that data ?

Posted: Thu Dec 08, 2005 12:11 am
by pipfromslitherine
How many people would be interested in some way to dump out a record of your armies in a human-readable format? Would it be something a lot of people would use?

If so we could potentially add it to the patch/expansion list.

Cheers

Pip

Posted: Thu Dec 08, 2005 2:23 am
by sacredzero
It would be useful, especially for comparing armies at various parts of the campaign.

Posted: Thu Dec 08, 2005 8:50 am
by spedius01
venividivici wrote:Good grief :shock: You have far too much time on your hands Spedius :)
I just take screenshots if I want to record stats but your method is certainly more comprehensive. How long does it take to compile and enter that data ?
Ave venividvici,

I've found if you're repeating something, in this case recording my battles during the Roman campaign, a spreadsheet is, ultimately, a major time-saving device. Much of the data is uniform (constant) and therefore you only have to think about it once and, if you've covered all the elements needed, you need not think about it again. Plus excel is so user-friendly for someone as talentless as me that, as an aid in clarifying my thoughts, it's of inestimable value. Something to ponder on, I only need create a "master" and copy it as many times as necessary. You can group all your speadsheets, of identical content, so that an alteration to one is an alteration to all. If you have repetitive work on spreadsheets you can write simple "macros"! The example above is one of seventy in that "book". I have other analysis sheets in the "book", ie. kills to losses ratios, losses of fame, xp needed for promotions, recruitment sequences etc. My maths has improved in leaps and bounds since I've been using spreadsheeets. They've helped me too when trying to get my one-cell brain around some abstract concept, like, how many Romans does it take to change a light-bulb? Answer: just one the rest are out conquering Europe! What have the Romans done for us anyway? Surely the subject of yet another topic!!!???

Finally, I will be refighting these battles many times, so it makes sense to record all relevent information on the first visit. The first time through I wrote everything down, a massive time-consuming exercise. On subsequent visits I had my spreadsheets, much more efficient and simpler. I would like to think that my tactics and results will improve with each run-through.

Vale

M. Spedius Corbulo

Posted: Thu Dec 08, 2005 9:14 am
by duncan
Ave Spedius!!!

Ever heard of openoffice????

http://www.openoffice.org/

They've got a free spreadsheet (and many more things...for free) and they update regularly :wink:

You're a very meticulous person, indeed :) . I enjoy the game a completely different way (more arcade, if you want), i'm not that statistic freak :wink: You should try Football Manager 2006, if you like stats, BTW (well, don't try if you don't like football).

One question, though. How do you take the in-game data to the .xls file?

Duncan te saluta

Posted: Thu Dec 08, 2005 10:21 am
by spedius01
duncan wrote:Ave Spedius!!!

Ever heard of openoffice????

http://www.openoffice.org/

They've got a free spreadsheet (and many more things...for free) and they update regularly :wink:

You're a very meticulous person, indeed :) . I enjoy the game a completely different way (more arcade, if you want), i'm not that statistic freak :wink: You should try Football Manager 2006, if you like stats, BTW (well, don't try if you don't like football).

One question, though. How do you take the in-game data to the .xls file?

Duncan te saluta
Ave Duncan,

I wish you well too (te saluta), I'd forgotten that Spanish is a Latin based language, as is English!

Thanx for the info and compliment, I'll certainly check out your, thoughtfully incuded, link.

"How do you take the in-game data to the .xls file?" Nothing too clever unfortunately, I simply type it in!

Vale

M. Spedius Corbulo

Posted: Thu Dec 08, 2005 10:41 am
by duncan
"How do you take the in-game data to the .xls file?" Nothing too clever unfortunately, I simply type it in!
In one word...Wow :shock: , you're truly devoted to arena. Thanks I haven't got internet at home, I wouldn't like to fight online battles against you...
I'd forgotten that Spanish is a Latin based language, as is English!
:roll:
:wink:

Bye everybody

Posted: Thu Dec 08, 2005 10:44 am
by duncan
pipfromslitherine wrote:How many people would be interested in some way to dump out a record of your armies in a human-readable format? Would it be something a lot of people would use?

If so we could potentially add it to the patch/expansion list.

Cheers

Pip
I would love to. Legion Arena design is so competitive that I would be oh so nice to have lots of statistics to improve next game. Adiction guaranteed.

Posted: Thu Dec 08, 2005 8:04 pm
by venividivici
If it saves me taking loads of screens of my stats and saving them into individual battle/game level files I would definately be interested in a running log of stats that I can easily print out. If the logger can produce stats as detailed as those presented above by Spedius that would be even better!