SoloQ Spreadsheet (EU)

SoloQ Spreadsheet (EU)

in PvP

Posted by: XanoNymOuS.5407

XanoNymOuS.5407

Hello all, me and a friend have made a soloQ spreadsheet just for curiosity before the patch, and decided to share our results. Spreadsheet can be found here:

https://docs.google.com/spreadsheets/d/1ZYKxUyy0k13Q64Q6F2fq-cNwNayqK4dKH3NtPhQFy5M/edit?usp=sharing (click this for full details, not everything is included in the summary)

Currently 92 matches in the spreadsheet, if you want to contribute for greater accuracy feel free to PM me with the parameters in the spreadsheet.

To summarize it, we got following results:

Map

[18] 19,57% Spirit Watch
[18] 19,57% Battle of Kyhlo
[17] 18,48% Skyhammer
[16] 17,39% Temple of the Silent Storm
[14] 15,28% Legacy of the Foefire (3 lord kills)
[09] 9,78% Forest of Niflhel

Additional: If we had more matches, this statistic would probably get balanced out full, and I kinda thinks it debunks "skyhammer pops 50% of the time" :P. But what we did notice is that maps tends to have ’streaks’, especially at the end of the spreadsheet where we got 8 kyhlos from 12 matches, or 6 skyhammers from 8, but maybe this was just a coincidence.

Match Duration and queue pop

Average match duration: 606,kitten or 10:06
Average queue pop wait: 139,30s or 2:19

Additional: 1 match ended 500-500 and 1 match ended 501-0 (5v5) One match ended by timer.

5 matches (5,43%) ended 5xx-0xx.

Best queue time for best matches was ~17:00 CET and ~21:00 CET imo.

Pops were pretty random, sometimes you could wait 5 minutes and the next day at the same hour, you could get instapops.

Matches

Blue team wins: [45] 48,913%
Red team wins : [47] 51,087%

Average score blue team: 400,087pts
Average score red team : 405,674pts

Additional: We saw the same patherns in wins as in maps, where one team would get a ’streak’ of wins, and then it would switch, which happened on our spreadsheet but this is probably a coincidence aswell.

Xv5’s

4v5s: [10] 10,87%
4v5s*: [14] 15,22%

*The second 4v5 section is including matches where a player or more went AFK to early in the game, more details in spreadsheet. The first 4v5 is matches with 50% player absence or more.

Professions

[159] 19,70% Engineer
[130] 16,11% Elementalist
[114] 14,13% Warrior
[099] 12,27% Thief
[087] 10,78% Guardian
[076] 9,42% Mesmer
[071] 8,80% Necromancer
[071] 8,80% Ranger

Amount of 3 stacked teams: 34
Amount of 4 stacked teams: 4

Bonus: The triple engi teams won 60% (9/15) of the matches. (Not counting triple engi vs triple engi matches).

Those numbers are NOT including us, so this is the distribution of classes for the other 9 players in the match.

--

There may still be added more matches to the spreadsheet over the coming days to increase accuracy. I will also maybe make one for soloQ’ing in the new system after the patch for comparison.

I know that this spreadsheet has one constant factor: us. Which makes it unable to reflect the 100% reality.

Edit: Disable Textile seems to do nothing >_>

XyrosFrø

(edited by XanoNymOuS.5407)

SoloQ Spreadsheet (EU)

in PvP

Posted by: KrisHQ.4719

KrisHQ.4719

Interesting data, nice work!
What is actually pretty fun to see, is that Engineer and Elementalist is obviously the top used professions atm.
Why is that obvious? Because they are easily the strongest professions right now.

Lysis Kawahara – D/D Elementalist
Zaphiel Faires – DPS Guardian

SoloQ Spreadsheet (EU)

in PvP

Posted by: Furesy.6935

Furesy.6935

I’m a bit surprised at Ranger being the least played profession in your data.

From personal experience I’d say I see Thief and Rangers the most in PvP, followed by Engi’s, Ele’s and Guardians.

SoloQ Spreadsheet (EU)

in PvP

Posted by: Frenk.5917

Frenk.5917

Just to know: OP, what’s your leaderboard rank?

Knowing your rank can help us understand the data better and could let us infer more about players preferences at high-medium-low rank.

Frenk – EU
All is vain

SoloQ Spreadsheet (EU)

in PvP

Posted by: witcher.3197

witcher.3197

I’m a bit surprised at Ranger being the least played profession in your data.

From personal experience I’d say I see Thief and Rangers the most in PvP, followed by Engi’s, Ele’s and Guardians.

Class popularity depends on leaderboard placement too.

SoloQ Spreadsheet (EU)

in PvP

Posted by: XanoNymOuS.5407

XanoNymOuS.5407

Just to know: OP, what’s your leaderboard rank?

Knowing your rank can help us understand the data better and could let us infer more about players preferences at high-medium-low rank.

Fluctating ~50 most of the time with occasional drops on lose streaks.

XyrosFrø

SoloQ Spreadsheet (EU)

in PvP

Posted by: Seiishizo.7162

Seiishizo.7162

what would be most interesting data is the winrate per class to see which class is ‘best’

interesting data tho ArenaNet should make an API for data like this so developers like me can make more of this

Owner and creator of http://www.gw2score.com
Btw: It’s Sey-Shi-zo ^.^

SoloQ Spreadsheet (EU)

in PvP

Posted by: Harbinger.8637

Harbinger.8637

That pretty much mirrors my experience on NA.

Guardian WvW Guide!
Heavens Rage

SoloQ Spreadsheet (EU)

in PvP

Posted by: Saiyan.1704

Saiyan.1704

what would be most interesting data is the winrate per class to see which class is ‘best’

interesting data tho ArenaNet should make an API for data like this so developers like me can make more of this

Very interesting but i’m curious if viewing win rates for a certain class necessarily mean that is a ‘superior’ class, per se.
Much like a two sided coin. A spread sheet can show the statistics for X amount of coin tosses. One side can be higher even though it’s suppose to be 50% for either side to come up.

Unless we measure the win rate for every single class in the top 1000 ranks would there be a realistic ‘odds’ for that class…. this game has never been measured on individual skill. Because mmr is calculated on game wins, I’m not even sure if you can successfully measuring a classes ‘odds of winning’.

Different competition, such kitten engi’s on a team vs 5 rangers would greatly change the odds. This game is very balances but not nearly balanced enough for this to be near 50%. I imagine there’d be a very high standard deviation in team oriented games.
Teams are vastly different from each other, from classes to strategies to skill level. The standard deviation will always be high.

I’m sure Anet is already viewing these statistics for every single person. If it was released people would misinterpret the data and think that class X would be the right way to go.
Then again, the data could be so skewed that a certain team comp’s odds of winning’ really is high because of an imbalance issue.

If that makes sense…

aka FalseLights
Rank: Top 250 since Season 2
#5 best gerdien in wurld

SoloQ Spreadsheet (EU)

in PvP

Posted by: infantrydiv.1620

infantrydiv.1620

This data looks pretty normal to me, definitely see more Engies than any other profession in Solo queue. I’d assume that it’s because of the extreme intricacy and difficulty of Engineer gameplay that draws so many Solo queue players to this class.

Ranger//Necro

SoloQ Spreadsheet (EU)

in PvP

Posted by: KrisHQ.4719

KrisHQ.4719

This data looks pretty normal to me, definitely see more Engies than any other profession in Solo queue. I’d assume that it’s because of the extreme intricacy and difficulty of Engineer gameplay that draws so many Solo queue players to this class.

lol. I see what you did there!

Lysis Kawahara – D/D Elementalist
Zaphiel Faires – DPS Guardian

SoloQ Spreadsheet (EU)

in PvP

Posted by: Ouroboros.5076

Ouroboros.5076

Evan mentioned they will have more statistics when the ‘rewrite’ will go live. I hope they will be able to produce similar reports in the future, it would be interesting.

SoloQ Spreadsheet (EU)

in PvP

Posted by: HeadCrowned.6834

HeadCrowned.6834

Interesting data. Especially the divide between professions, Ele’s and Engi’s seem indeed the strongest.

SoloQ Spreadsheet (EU)

in PvP

Posted by: Seiishizo.7162

Seiishizo.7162

Based on this list:

Class Winrate
G 50.63 %
W 51.67 %
E 48.15 %
M 51.43 %
N 50 %
En 48.97 %
T 48.08 %
R 58.06 %
Winrate of the Engi might be low cus the one that made this list plays engi

Owner and creator of http://www.gw2score.com
Btw: It’s Sey-Shi-zo ^.^

SoloQ Spreadsheet (EU)

in PvP

Posted by: XanoNymOuS.5407

XanoNymOuS.5407

^I’m curious about how you calculated that. If there is a match with 2 wars vs 3 wars and the 2 wars win did you then put the win % for warrior 40%?

I put the classes we queued up with in the spreadsheet aswell btw.
45 engi, 20 war, 26 thief, 1 guard.

Also

ArenaNet should make an API for data like this so developers like me can make more of this

Please let this happen Anet.

XyrosFrø

SoloQ Spreadsheet (EU)

in PvP

Posted by: Seiishizo.7162

Seiishizo.7162

(Wins/NumOfGames)*100

so ya if 1 game would have 2warriors other side 3 warriors and the 2 warriors would have won it would be

(2/5)*100 = 40%

(and i made a little script that could get that from the text so i don’t have to analyze the data myself)

Owner and creator of http://www.gw2score.com
Btw: It’s Sey-Shi-zo ^.^

SoloQ Spreadsheet (EU)

in PvP

Posted by: egan.2751

egan.2751

game 9 additionel info =1 ragequit (“this team sucks”)
hahaha made my day

80 ele/80 mes/80 guar/80 war/80 sin/80 ranger,22 necro
piken square