
MatchStatsCalculator v1.2
MatchStatsCalculator v1.2Well, 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. ^^
FeaturesThis 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.
ConsistencyThe 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)
DownloadsDownload
MatchStatsCalculator v1.2ChangesHere 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- ...