Spring Tournament 2017 Data Spreadsheet

User avatar
Poland pecelot
Retired Contributor
Donator 03
Posts: 10459
Joined: Mar 25, 2015
ESO: Pezet

Spring Tournament 2017 Data Spreadsheet

  • Quote

Post by pecelot »

Well, this was supposed to be uploaded some time ago by the alleged authorities known for such actions, but I haven't noticed it anywhere, despite I clearly sent them the finalised version :!:

I gathered all the data from the bracket stage of the Spring Tournament 2017 (played on the ESOC Patch v. 3.1.1.0), including: players, civs used, winner civs, maps, rounds etc. The proof is entirely in the file, but the best highlights are presented in the graphs below:

Image

Image

Image

Image

Image


I highly encourage you to familiarise yourself with this piece of data, with the perspective of being used in further balance discussions I'm unfortunately not up-to-date with (yet...!), tournament settings, map pools and so on. :flowers:
Attachments
Spring Tournament 2017 Data Spreadsheet by pecelot.xlsx
(37.61 KiB) Downloaded 110 times
No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Spring Tournament 2017 Data Spreadsheet

Post by deleted_user »

looks even

edit: russia's win % has been cut nearly in half since last tourney lol
User avatar
Holy See Imperial Noob
Lancer
Posts: 958
Joined: Feb 29, 2016
Location: Well hello DEre

Re: Spring Tournament 2017 Data Spreadsheet

  • Quote

Post by Imperial Noob »

What if this data hasn't been published earlier due to staunch lobbyist activity withing the ESOC Team by Dutch bankers and Otto lamers? :ohmy:
@pecelot = Snowden?
User avatar
New Zealand JakeyBoyTH
Howdah
Posts: 1744
Joined: Oct 15, 2016
ESO: Ex-Contributor
Location: New Zealand

Re: Spring Tournament 2017 Data Spreadsheet

Post by JakeyBoyTH »

Nice to see this here. I already saw and was impressed by the data Ryan gathered as well.
Advanced Wonders suck

- Aizamk

Ugh Advanced Wonders suck

- Aizamk
User avatar
Austria KINGofOsmane
Pro Player
Posts: 3096
Joined: Feb 24, 2015
ESO: KINGofOsmane
Location: Walling Town

Re: Spring Tournament 2017 Data Spreadsheet

  • Quote

Post by KINGofOsmane »

cascade range insta veto haha
"Losing to Callen was the worst night of my life" Gibthedurrty 2019
"If hazza can get pr42 with team i can get pr50 with 1v1" Gibthedurrty 2018
Lecastete wrote: Dude i hate this game. I am bad and i also dont have luck
Tete cs:go experience
User avatar
United States of America _H2O
ESOC Business Team
Donator 06
Posts: 3409
Joined: Aug 20, 2016
ESO: _H2O

Re: Spring Tournament 2017 Data Spreadsheet

  • Quote

Post by _H2O »

See the attached PDF. Thank you for collecting the data. I did use it for analysis. There were a few items misentered that I corrected prior to making the analysis. It also looks at multiple events.
Attachments
ESOC_Tournament_Analytics.pdf
(1.48 MiB) Downloaded 509 times
User avatar
India rsy
Jaeger
Donator 01
Posts: 2202
Joined: Feb 27, 2015
Location: Lashka

Re: Spring Tournament 2017 Data Spreadsheet

Post by rsy »

_H2O wrote:See the attached PDF. Thank you for collecting the data. I did use it for analysis. There were a few items misentered that I corrected prior to making the analysis. It also looks at multiple events.

Great analysis!! I always expected that the percentage of mirrors was much higher in later rounds compared to earlier rounds :hmm:
No Flag deleted_user0
Ninja
Posts: 13004
Joined: Apr 28, 2020

Re: Spring Tournament 2017 Data Spreadsheet

Post by deleted_user0 »

Why stats only for those players? H2o wasnt even in tournament. Funny that raphas and ryans winrate are almost same but mirrored
User avatar
No Flag Jaeger
Jaeger
Posts: 4492
Joined: Feb 28, 2015

Re: Spring Tournament 2017 Data Spreadsheet

Post by Jaeger »

_H2O wrote:See the attached PDF. Thank you for collecting the data. I did use it for analysis. There were a few items misentered that I corrected prior to making the analysis. It also looks at multiple events.

Woah did you make this? It's pretty awesome
last time i cryed was because i stood on Lego
User avatar
New Zealand JakeyBoyTH
Howdah
Posts: 1744
Joined: Oct 15, 2016
ESO: Ex-Contributor
Location: New Zealand

Re: Spring Tournament 2017 Data Spreadsheet

Post by JakeyBoyTH »

umeu wrote:Why stats only for those players? H2o wasnt even in tournament. Funny that raphas and ryans winrate are almost same but mirrored

You're right volunteer work isnt good enough! Why didn't Ryan just do all the players ever for every tournament.
Advanced Wonders suck

- Aizamk

Ugh Advanced Wonders suck

- Aizamk
No Flag deleted_user0
Ninja
Posts: 13004
Joined: Apr 28, 2020

Re: Spring Tournament 2017 Data Spreadsheet

Post by deleted_user0 »

Dont get your knickers in a twist
Germany lordraphael
Pro Player
EWTNWC LAN SilverAdvanced Division WinnerDonator 01
Posts: 2549
Joined: Jun 28, 2015

Re: Spring Tournament 2017 Data Spreadsheet

Post by lordraphael »

nice work @H2O_
breeze wrote: they cant even guess how much f***ing piece of stupid retarded they look they are trying to give lesson to people who are over pr35 and know the best mu. im pretty sure that we need a page that only pr30+ post and then we could have a nice discussins.
User avatar
Bavaria Gichtenlord
Howdah
Donator 03
Posts: 1437
Joined: Nov 15, 2015

Re: Spring Tournament 2017 Data Spreadsheet

Post by Gichtenlord »

JakeyBoyTH wrote:
umeu wrote:Why stats only for those players? H2o wasnt even in tournament. Funny that raphas and ryans winrate are almost same but mirrored

You're right volunteer work isnt good enough! Why didn't Ryan just do all the players ever for every tournament.

I think umeu was just curious. No need to overreact
r]
User avatar
United States of America _H2O
ESOC Business Team
Donator 06
Posts: 3409
Joined: Aug 20, 2016
ESO: _H2O

Re: Spring Tournament 2017 Data Spreadsheet

Post by _H2O »

I just did a handful of players that I was interested in and that had a large sampling of games in events. The large sample of games is an important one. Yes, my win rates were much better prior to that last finals! Thanks raphael!
User avatar
European Union Asateo
Dragoon
Posts: 426
Joined: Jun 14, 2017
ESO: Asateo
Location: Belgium

Re: Spring Tournament 2017 Data Spreadsheet

Post by Asateo »

Imperial Noob wrote:What if this data hasn't been published earlier due to staunch lobbyist activity withing the ESOC Team by Dutch bankers and Otto lamers? :ohmy:
@pecelot = Snowden?


It is indeed a bit sad to see that even on the esoc patch Otto still seems to be encouraged :dry:
A decend nerf would do imo. (yes there is some frustration here from being beaten by otto on RE :mad: )
To see a world in a grain of saind, A heaven in a wild flower
Hold infinity in the palm of you hand, And eternity in an hour
- William Blake, Auguries of Innocence
User avatar
United States of America _H2O
ESOC Business Team
Donator 06
Posts: 3409
Joined: Aug 20, 2016
ESO: _H2O

Re: Spring Tournament 2017 Data Spreadsheet

Post by _H2O »

I would be interested to hear what thoughts the PDF analysis I posted above stirs.
User avatar
Tuvalu gibson
Ninja
ECL Reigning Champs
Posts: 13597
Joined: May 4, 2015
Location: USA

Re: Spring Tournament 2017 Data Spreadsheet

Post by gibson »

Dutch very clearly needs to be buffed
User avatar
Italy Garja
Retired Contributor
Donator 02
Posts: 9729
Joined: Feb 11, 2015
ESO: Garja

Re: Spring Tournament 2017 Data Spreadsheet

Post by Garja »

_H2O wrote:I would be interested to hear what thoughts the PDF analysis I posted above stirs.


ESOC patch is working. Perceived balance improved overall.

Civ and mirrors: I think one cause is that top 3 mirrored civs are seen as clear dominants on some maps. So there is a strong drive to mirror those civs in those cases. Otherwise, the mirror rate isn't that different among most civs. Top 3 mirrored civs are also rather popular and relatively easy to play (in mirror at least).

Civ win rates are not very telling. I cannot see a clear pattern atleast.
Image Image Image
User avatar
Netherlands Mr_Bramboy
Retired Contributor
Donator 01
Posts: 8219
Joined: Feb 26, 2015
ESO: [VOC] Bram
Location: Amsterdam

Re: Spring Tournament 2017 Data Spreadsheet

Post by Mr_Bramboy »

_H2O wrote:See the attached PDF. Thank you for collecting the data. I did use it for analysis. There were a few items misentered that I corrected prior to making the analysis. It also looks at multiple events.

Great read and well written. It seems the EP is doing good work to improve civilization variety while maintaining the competitiveness.
User avatar
Poland pecelot
Retired Contributor
Donator 03
Posts: 10459
Joined: Mar 25, 2015
ESO: Pezet

Re: Spring Tournament 2017 Data Spreadsheet

Post by pecelot »

The last graphs showing Civilisation Win Rates include mirrors, from what I observed, which shouldn't take place :!:
Other than that, looks fantastic, I'm happy my work somewhat helped with this amazing piece of work :smile:
No Flag deleted_user
Ninja
Posts: 14364
Joined: Mar 26, 2015

Re: Spring Tournament 2017 Data Spreadsheet

Post by deleted_user »

Ryan is some sort of data wizard methinks.
User avatar
United States of America _H2O
ESOC Business Team
Donator 06
Posts: 3409
Joined: Aug 20, 2016
ESO: _H2O

Re: Spring Tournament 2017 Data Spreadsheet

Post by _H2O »

pecelot wrote:The last graphs showing Civilisation Win Rates include mirrors, from what I observed, which shouldn't take place :!:
Other than that, looks fantastic, I'm happy my work somewhat helped with this amazing piece of work :smile:


I'll check on that. I feel like I excluded that (I built a view of the data for this purpose that excluded mirrors). And thank you! Between mitoe and yourself we wouldn't have any of these analytics!
User avatar
Poland pecelot
Retired Contributor
Donator 03
Posts: 10459
Joined: Mar 25, 2015
ESO: Pezet

Re: Spring Tournament 2017 Data Spreadsheet

Post by pecelot »

The formula was broken, please, familiarise yourself with new, correct piece of data:

Image

Image
User avatar
United States of America _H2O
ESOC Business Team
Donator 06
Posts: 3409
Joined: Aug 20, 2016
ESO: _H2O

Re: Spring Tournament 2017 Data Spreadsheet

Post by _H2O »

These now match the numbers in the end of my report nice! :)
No Flag deleted_user0
Ninja
Posts: 13004
Joined: Apr 28, 2020

Re: Spring Tournament 2017 Data Spreadsheet

Post by deleted_user0 »

Good, so now we can see its time to undo the silly nerfs to china and france.

Who is online

Users browsing this forum: No registered users and 16 guests

Which top 10 players do you wish to see listed?

All-time

Active last two weeks

Active last month

Supremacy

Treaty

Official

ESOC Patch

Treaty Patch

1v1 Elo

2v2 Elo

3v3 Elo

Power Rating

Which streams do you wish to see listed?

Twitch

Age of Empires III

Age of Empires IV