Please actually read before you dig yourself any deeper into this pit. I left the qualifiers in because I knew it would be a tripping point for trolls like you. Surprise! I was right!
Terran vs Terran: 0.494624 (837)
Terran so IMBA that he actually has the advantage against HIMSELF.
lel
Ah yes, the 0.005 rounding error.
It was funny, you should keep it.
It is possible to have a non 50/50 winrate in TvT in the Korean/Foreigner tabs.
That makes perfect sense, especially the difference of the skillgap anyway.
Uhhh what? So you intentiionally left the qualifiers in just to allow me to point out that your data is full of games that arent actually premier tournament games but many games involving lower tier players? Great job? I dont get your goal other than trying to mislead people.
So, in reality, you put in the qualifier data to troll me and the rest of the forum. It worked so⌠congratulations?
Leave it to toss players to want to dismiss qualifier. well it shows that they win there so why not. And of course they want to, you know. leave out all rounds outside of quarter/semi finals, you know, becuase they win there too.
Thy just want to include the championship games because. they just cant get the job done. despite the signficant help they received and they do what ever they can to discredit it.
It is impossible for the inclusion of qualifiers to âmisleadâ people when the result is the same with and without the qualifiers. You are a Grade-F troll.
I double checked the data. Found out you filled it full of games with players that I dont even recognize. Listened to an outlandish claim that âit is the same without the qualifiersâ which, in addition to making no sense whatsoever, has not been proven by you whatsoever. You can believe whatever the **** you want but none of the people who actually know what they are talking about on this forum would agree with the following statements:
-
Players who nobody recognizes who couldnt even make it past the qualifiers represent the highest level of SC2 players competing in Premier SC2 tournaments.
-
Baseless assertions with no proof that the data from the qualifiers will have zero effect on the final win percentages.
Love the ad hominem attacks though. Especially when ironically combined with calling me a troll. Classy.
Which isnât a valid reason for excluding them.
Will read your posts without shaking their heads.
LOL
I provided you with a list of every game played in every premier event in a nice spreadsheet. I included the qualifiers in case you wanted them. If you didnât want them, itâs easy enough to shift-click remove them from the spreadsheet. But now you are saying things like âbaseless assertionâ and âno proofâ which are literally the polar opposite of reality. The way you are acting is extremely childish. How old are you? 10, max? You must be at least 18 years old if you want to be in my threads, kiddo. If you donât know how to work basic spreadsheet software, this thread IS NOT for you!
Yeah⌠âeasy enoughâ when there are literally 4326 rows of data which is not organized in any fashion. Nor does it have formulas to aggregate data and calculate win rates. I would have to generate that all from scratch. If I was better at visual basic and cared enough, I would write a macro and clean up your spreadsheet for you but frankly it isnât worth my time and I already showed the data for premier tournament results in my previous topic.
And ultimately, it wont change your mind. You are convinced Protoss is over powered. No amount of data or logic is going to convince you otherwise.
https://i.imgur.com/MtaUOT5.png
Lying isnât an argument, kiddo. This is literally the most comprehensive, organized compilation of premier games ever compiled by a very large margin.
=SUMIF(G:G,âZâ,E:E)+SUMIF(H:H,âZâ,F:F)
Will count the number of Zerg victories.
=SUMIFS(E:E,G:G,âZâ,H:H,âTâ)+SUMIFS(F:F,H:H,âZâ,G:G,âTâ)
Will count the number of ZvT victories.
Etc, etc.
You are right, because I havenât made an error here. The win-rates are correct. The only thing youâd be doing is proving yourself wrong, and I do suspect that you would find that to be a waste of time - you arenât interested in the truth, you are interested in pushing your agenda which the facts simply donât support.
If itâs so easy why donât you remove the qualifier data, add the formulas, and repost?
https://i.imgur.com/tHFYZyk.png
â> https://i.imgur.com/Kfx6rpB.png
Thatâs how easy it is.
Okay great. Can you repost your spreadsheet with qualifiers removed
And Batz, as biased as I think you are, I will admit you are intelligent. I havenât programmed since college. I am sure you can program circles around me in VB. What would take you 5 minutes would probably take me hours.
http://www.sharecsv.com/s/b57dc0826955904b45cf005404a8e03c/MatchList.csv
Okay it took me a minute because I couldnt do it with a single formula. What I did was make logic statements in two colums. Either P1 is Z AND P2 is P OR P2 is P and P1 is Z. Then sorted by True in each column to count Zerg and Protoss wins in ZvP or PvZ.
Final tallies are 626 Zerg wins to 540 Toss wins. Total is 53.69% win rate ZvP.
Less than I found of ~55% when I did it about a month earlier but still slightly Z favored.
h ttp://www.sharecsv.com/s/36117a4093a6e92c0a0a687a64441914/MatchList%20sorted%20P1%20and%20P2%20Zerg%20and%20Toss%20wins.csv
0.536878 * 100 = 53.6878
But within Blizzardâs tolerance for âbalancedâ. The analysis you did was as good as it could be, given that it used Liquipedia which is not the most reliable source for statistics, and given it was done by hand. Computer scripts are much better at managing large amounts of data like this. They are faster and less error prone.
Oh ok⌠sorry I didnt realize you had already crunched the data without qualifiers.
So what do you think about the PvT stat then? Almost 50/50
Even when you look at the Korean vs Korean numbers 51.3% is much better than the ~58% without qualifiers.
I think the numbers show the game is pretty damn balanced at the highest level. Slightly Toss favored PvT and slightly Zerg favored ZvP.
Sorry for misunderstand your earlier post. I thought you were just reposting your original numbers.