With ETF2L's 23rd season over, I've started to look at the results from all the games in an attempt to analyse the 5cp map system* and identify any areas for potential improvement. The hardest and dullest part of that was creating a spreadsheet containing the results from every match this season (excluding playoffs). Since some of you probably know more about statistical analysis than I do, and most of you know know more about TF2 than I do, I thought I'd share the raw data for anyone to grab and have a look through, should they wish to.
You can find the spreadsheet here:
https://docs.google.com/spreadsheets/d/1raVJMm-uAE-aW8hkj1U0lzkdKtWYP_XQviKg4yrgp38/edit?usp=sharing
At a quick glance, there are a few interesting facts to glean, such as:
- A total of 968 5cp maps were played this season
- 34% of maps were ended by the windifference 5 rule
- 9.5% of maps went to a golden cap
Looking closer there are more specific insights, such as:
- Half of all golden caps in Prem were on cp_sunshine
- Of all divisions, Prem had the highest percentage of golden caps, and the lowest percentage of windifference wins
I'm sure one could infer many things from the data here, but I wanted to provide it in an unbiased manner for this thread. It does have its limitations, but it could still be useful.
If you have any suggestions on how to use the data, or improve its presentation, or any questions regarding the data, or if you spot any mistakes** please let me know!
Enjoy!
*I do include the koth_product data in the spreadsheet, but I chose to exclude it from larger analysis because of its different ruleset.
**Since this is taken from the results page, it relies on the results being submitted correctly, which in many cases they were not, though I think I spotted them all. Also there's about a 1% chance of a mistake in data entry but again I've hopefully found those.