View unanswered posts | View active topics It is currently 2017-06-24 Sat 10:31:44



Reply to topic  [ 19 posts ] 
 MatchStatsCalculator v1.2 
Author Message
Statistical Boss

Posts: 3712
Post MatchStatsCalculator v1.2
MatchStatsCalculator v1.2

Well, as most of you know, I like detailed and statistical matchreports, and together with Lolomax, I'm about the only one who makes them. However, that can be changed, since lately I've been figuring out how to work with Excel (I only knew how to work with SPSS so far ^^ ), and I managed to design an easy-to-use datasheet where all statistical matchstats you'd want to have are fully automatically calculated: please welcome MatchStatsCalculator. ^^

Features
This tool is (still) nothing more than an Excel sheet for 3v3 UL-style matches, but it is one where you only have to fill in the times all people drove. The following stats are then automatically created in version 1.2.
- Points per round.
- Personal records.
- Average times.
- Standard Deviation (used to calculate consistency).
- Consistency (a formula I made up myself).
- Total points.
- Average finishing position.
- Amount of rounds won.

Manual
- Only enter the times in the sheet like this: "m:ss,00".
- The first driver (rowB) should have finished all rounds.
- Points for equal times in one round will be highlighted for the user to be fixed manually.
- Sorting is impossible in this version.

Consistency
The consistency is calculated through a formula I made up. The first part of this formula is the personal standard deviation of the driver multiplied by a penalty factor when not having finished every round. The second part is the bonus or malus factor, based on the difference between the fastest time driven that match and the personal average time driven. It also depends on the length of the track (based on the fastest time driven). This result X is then transformed into Y by the following formula: 0,25/X, so the consistency is generally a number between 0 and 1, where the ratings closest to 1 are the most consistent ones. The formula is as follows:

C = 0,25/(sqrt(t1^2+t2^2+...+tn^2/n)*(n/f)*((5+tm+Tb)/(5+Tb*d^-1))^2)

C = Consistency
t = Personal time driven
T = Overall time driven
n = Amount of rounds
f = Amount of finishes
m = Average time driven
b = Best time driven
d = Penalty (standard 60)

Downloads
Download MatchStatsCalculator v1.2

Changes
Here follows a list with all changes regarding older versions.

v1.2
- Added no-finish penalty at the consistency.
- Added no-finish penalty at the average times.

v1.1
- Fixed colorscales.
- Fixed consistency formula.

v1.0
- Added amount of rounds won.
- Added colorscales at the timetable.

List of Planned Fixes
- Overall colorscales.

List of Planned Additions
- ...


Last edited by JumperJack on 2010-03-09 Tue 19:47:31, edited 4 times in total.


2009-05-06 Wed 21:57:49
Profile
ThingKing
User avatar

Posts: 2266
Post Re: MatchStatsCalculator v1.1
n1 JJ. 8)

You could automate extracting the times from dedi or FAST logs, which would save some typing and avoid mistakes. Is importing a CSV file into part of an Excel sheet easy? How about for OpenOffice Calc? I don't have any of the MS Office suite...

_________________
"A snappy saying is no substitute for thinking" - MixD 2009

2009-05-06 Wed 23:01:45
Profile WWW
Statistical Boss

Posts: 3712
Post Re: MatchStatsCalculator v1.1
well mix, i have thought about that, but only a week ago i didn't have a single bit of knowledge about excel. however, i have looked a bit at automatic entering of the times as well. still no clue about it, though, that's going to cost some proper research.

i'll save that for v2.0 though, at first i'll make a v1.2 tomorrow with the latest fixes, and i'll release it on tmx. if anyone has got any knowledge about importing csv files in excel, i'm one listening ear. :p

i'll keep you posted.

2009-05-07 Thu 11:16:54
Profile
Glorious

Posts: 2280
Post Re: MatchStatsCalculator v1.1
nice, releasing a matchexcelsheet on tmx.
shouldnt you release it on ET? :p

also, how about implementing a graph figure like meister did in his stats normally

2009-05-07 Thu 11:26:02
Profile WWW
ThingKing
User avatar

Posts: 2266
Post Re: MatchStatsCalculator v1.1
Yep, a pie chart would be awesome. :D

_________________
"A snappy saying is no substitute for thinking" - MixD 2009

2009-05-07 Thu 11:49:22
Profile WWW
Glorious

Posts: 2280
Post Re: MatchStatsCalculator v1.1
hmm, cant find an example of meisters stats. Per did it as well once..

just a graph with 6 lines which connect the times driven.

2009-05-07 Thu 11:52:57
Profile WWW
Statistical Boss

Posts: 3712
Post Re: MatchStatsCalculator v1.1
nice one mix. ^^

anyway quik, at first this is not tmx. :p

second, v1.1 is more like a beta version. v1.2 which i will finish tomorrow will be released on tmx. ;)

i'll think about the chart, but i guessed the temporary layout feature would be enough telling...

2009-05-07 Thu 11:58:32
Profile
Glorious

Posts: 2280
Post Re: MatchStatsCalculator v1.1
but all the colours were pretty in those graphs :<

then i ask again, why release it on tmx? :P

2009-05-07 Thu 12:02:31
Profile WWW
Never Gonna Let You Down

Posts: 3120
Post Re: MatchStatsCalculator v1.1
I thought about coding this in C++, but I can't be bothered to learn how to make it nice in windows ;)

_________________
:bram:

2009-05-07 Thu 13:02:00
Profile
Statistical Boss

Posts: 3712
Post Re: MatchStatsCalculator v1.1
ah well, i found a solution to my colors-problem, so i'm sure it's fixable for tomorrow. :)

quik: lol ok, i just noticed my own typo. :') i mean ET of course...

bramble: c++?! ^^ loool, don't even think i would do that, i had some classes about it, and i simply hate it. don't understand a thing of it... o.O i even failed for my whole course due to it... -.-'

2009-05-07 Thu 14:12:42
Profile
Never Gonna Let You Down

Posts: 3120
Post Re: MatchStatsCalculator v1.1
The software for the experiment I work on is all C++.

It all runs in Linux though, and I assume people would run a mile if I made the program in windows using a command line prompt ;)

_________________
:bram:

2009-05-07 Thu 14:26:34
Profile
ThingKing
User avatar

Posts: 2266
Post Re: MatchStatsCalculator v1.1
Not me.

I'd probably choose bash as the language if I wanted to code something like this up quickly. :geek:

_________________
"A snappy saying is no substitute for thinking" - MixD 2009

2009-05-07 Thu 15:23:31
Profile WWW
Glorious

Posts: 2280
Post Re: MatchStatsCalculator v1.1
O,O

2009-05-07 Thu 15:33:09
Profile WWW
Like a Canyon Boss

Posts: 1470
Post Re: MatchStatsCalculator v1.1
*could code in C#*

2009-05-08 Fri 00:56:04
Profile
Never Gonna Let You Down

Posts: 3120
Post Re: MatchStatsCalculator v1.1
O,O

_________________
:bram:

2009-05-08 Fri 08:37:49
Profile
Clan Clown

Posts: 1574
Post Re: MatchStatsCalculator v1.1
Nice work JJ!! :cmc:

_________________
*nudge**nudge**wink**wink*

2009-05-08 Fri 11:55:20
Profile
Statistical Boss

Posts: 3712
Post Re: MatchStatsCalculator v1.2
updated to version 1.2. i'll release this one on ET as well.

still a problem with the coloring of the times, but i've opened a help topic on an excel forum for that already...

2009-05-08 Fri 16:38:21
Profile

Posts: 192
Post Re: MatchStatsCalculator v1.2
maybe add some FET stuff also? average laptime comes to mind mainly

_________________
Image

2009-05-11 Mon 18:39:48
Profile ICQ YIM
Statistical Boss

Posts: 3712
Post Re: MatchStatsCalculator v1.2
well, i already have made a sheet for FET, but that's one hell of a job to fill in... o.O

and that's even without laptimes... such a sheet would be nearly impossible without automatic importing of laptimes through matchlogs. though, that still miles away from my current programming skills...

2009-05-11 Mon 18:45:46
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 19 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.