9 replies to this topic

[Wintersdark]

UPDATED JUNE 16!

Lots of added stats and more useful calculations, support for 50 mechs, and what's more, it's got context sensitive formatting! Generally speaking, what I've done is calculated your average stats overall, then compared each individual mech's stats with the average - if it's better, it gets colored green, if worse it gets colored red.

Usage is a little different, but neater. Now, there are two sheets - the first sheet, where you view and sort the data, and the second sheet where you just paste your mech data in A1. This way, pasting in mech data doesn't screw with formatting and whatnot.

The new sheet can be downloaded here: https://dl.dropboxus...01/NewStats.xls
It has no data in it, to avoid situations where people with fewer mechs pasting in their data end up with a mix of theirs and mine. You can see the sheet with my data here, if you're unsure where to paste your stuff: https://dl.dropboxus...xampleStats.xls

I'm really not into making new how to pics up right now, but it's really simple. As I said above, just select and copy all your mech data as shown below, then paste it to the second sheet in cell A1 (the top left). You can then sort the viewing page as before by selecting the column title you want to sort by and pressing one of the sort buttons.

Don't paste on the first "VIEW DATA HERE" sheet!

-------------------------------------------- Original Post --------------------------------------------

Ok, I made this for my own use, because the web page stats are not terrible helpful. I wanted to see my average kills, deaths, and XP per battle, and all see what my kills/deaths/xp/wins/losses/etc per hour were like. Also, to sort that list, and see which mechs I did better with a little more organically.

This isn't very pretty, but it's functional and gets the job done. If someone wants to make one a little more user-friendly, they're more than welcome to, but I've very limited time and wanted something that users could just paste their stats directly into.

How to? It's simple:

Step #1:


Copy your profile>stats mech data, then paste it into the spreadsheet - this one here: https://dl.dropboxus...16101/Stats.xls it's in XL95 format, but was made in OpenOffice so should work just fine there.

Paste in cell A2, as below:


And Bob's your uncle.

Feel free to flame me for my stats all you like - particularly with my shameful Spider stats. I'm *not* a light pilot.

*Not shown in the second screen shot, line 31 now has totals per hour of the cumulative stats (kills, deaths, damage, xp) for ****'s and giggles.

Edited by Wintersdark, 16 June 2013 - 09:31 AM.

[Wintersdark]

Ok, I made this for my own use, because the web page stats are not terrible helpful. I wanted to see my average kills, deaths, and XP per battle, and all see what my kills/deaths/xp/wins/losses/etc per hour were like. Also, to sort that list, and see which mechs I did better with a little more organically.

This isn't very pretty, but it's functional and gets the job done. If someone wants to make one a little more user-friendly, they're more than welcome to, but I've very limited time and wanted something that users could just paste their stats directly into.

How to? It's simple:

Step #1:


Copy your profile>stats mech data, then paste it into the spreadsheet - this one here: https://dl.dropboxus...16101/Stats.xls it's in XL95 format, but was made in OpenOffice so should work just fine there.

Paste in cell A2, as below:


And Bob's your uncle. Currently sorted by XP per Battle, but can be easily changed by (as the screenshot says) selecting the column title you'd like to sort by, then clicking the relevant sort button.

Feel free to flame me for my stats all you like - particularly with my shameful Spider stats. I'm *not* a light pilot.

*Not shown in the second screen shot, line 31 now has totals per hour of the cumulative stats (kills, deaths, damage, xp) for ****'s and giggles.





Edit: If you've got more than 28 mechs, you'll need to employ a bit of spreadsheet stretch-fu to add more rows, but it's not hard to do. I was too lazy to set it up to allow for lots more while keeping the totals on screen.

Edited by Wintersdark, 15 June 2013 - 02:44 PM.

[MavRCK]

Thank you! <3 <3 <3

[scJazz]

TYVM you saved me the tedium of doing the first step in something else I've wanted to do...

The Stat Freeze SS basically ignore the last 6 weeks while I was learning and just count stats from today onward

[Wintersdark]

scJazz, on 15 June 2013 - 07:06 PM, said:

TYVM you saved me the tedium of doing the first step in something else I've wanted to do...

The Stat Freeze SS basically ignore the last 6 weeks while I was learning and just count stats from today onward

I wish we could have a reset button on our stats. It's not so bad for me personally, as I started well before these stats were counted, but I'd like to be able to look at stats over a fixed time frame.

I really hope the day arrives where we can get an API to retrieve specific stats over a given time frame, and more detailed info.



Does anyone know a way in Open Office to protect cell formatting? I've not figured out a way to paste my data in from the web page without it clearing the cell formatting. I don't care much about anything but the time, as the default time formatting is useless - need to change it to [HH]:MM:SS to get a quantity instead of all those silly AM/PM times.

[Wintersdark]

Original post has been updated with a much improved version.

[Wintersdark]

MavRCK, on 15 June 2013 - 04:26 PM, said:

Thank you! <3 <3 <3

Strangely, this thread was double-posted; I've greatly modified the spreadsheet to be easier to use and more rugged, provide a lot more data and show context sensitive formatting - mech stats better than your average stats are green, worse are red, so you can find where you need to improve!

Changes are in the other thread, here: http://mwomercs.com/...ost__p__2455150

[CmdrPoopyPants]

I would like to know if there's an API we can access (like in Eve) to pull in data. That would be very useful, and would allow you to poll the server once a minute (or 3 or 5) to get "new data", then you could actually build a picture of each battle and keep a record of it all.. data mining that would be quite useful as opposed to the detached stats.. you'd know which mech, with say, medium lasers you're best at.. instead of just a generic "hit rate for medium lasers".

Though, given -all- that data is updated each match, just on different "pages", one could query all the stat pages and build that data on the fly.. been tempted to see about undertaking that myself. Put a webpage control on the form, log in with it, query the pages, and compare all the rows to the last data set.. boom, you know what mech you were in, what weapons were fired during the match (but not full loadout since if you didn't fire something, that stat won't have changed), what your hit/misses were, damage, win/loss, k/d, etc etc.

I just don't know that I'm good enoug with parsing the returned unrendered page to pull all the data out. But putting it in a free MySQL database, maybe embeded in the app, would be quite useful.

[Wintersdark]

No. There's no API yet. It's planned, but it'll be a good long time before there is one.

I could make an automated version just ripping the data from the web page, but it's a lot of work for little gain when I can just copy and paste into this, and you'd run into the issue of needed username and password, so that's opening a whole can of worms when you want to share it with others. I've very, very little free time too, so such an undertaking is just way too much work. I made the spreadsheet above in about half an hour =)

I miss being a young lad with lots of free time to devote to silly ultimately pointless projects like the above!

[CmdrPoopyPants]

Wintersdark, on 16 June 2013 - 11:19 AM, said:

No. There's no API yet. It's planned, but it'll be a good long time before there is one.

I could make an automated version just ripping the data from the web page, but it's a lot of work for little gain when I can just copy and paste into this, and you'd run into the issue of needed username and password, so that's opening a whole can of worms when you want to share it with others. I've very, very little free time too, so such an undertaking is just way too much work. I made the spreadsheet above in about half an hour =)

I miss being a young lad with lots of free time to devote to silly ultimately pointless projects like the above!

Well, I've got time (if I don't play ).. I'm just not sure of how to parse the table out of the html effectively.

Your way "works", but you have to manually load all the stats pages and copy/paste, and even at that the spreadsheet doesn't rebuild entire matches. It's an excellent enhancement to what they give, but not the kind of toy I'm looking for..

You bring up a good point about the passwords though.. no real way to let people trust this then.. UNLESS, of course, PGI decided to let us see "everyone's stats".. then you would only need a user to poll, no security risks at all. I can't think of a really good reason all player's stats aren't visible.. perhaps PGI could tell us if it's more than just not having pilot name in the links and pulling data based on that?

In any event, I've decided that I -want- my per match info, and more meaningful associations of data. I think I'll build my tool and offer up the source so people can build it themselves if they want. I doubt I'll host any binaries though, since there is that security risk for users.