SuperSeries Winners and statistics

AlanY · Apr 15, 2015

in red ....

Fan123 said:
Thank you for this [MENTION=30877]AlanY[/MENTION]
The long absence of this file compelled me to sign up and after we won two at IOSS, I had no option but to sign up.
So Saina is still T4th at 9 behind the big 3.
And KS is T10-12 with 2.
A few questions:--

1. How can I help you in making this list better. Would love to contribute.

any suggestions?

2.Do you have something similar for GPs?

afraid not.

3. Going forward, how frequently will this list be updated? As a statslut, I would love the answer to be aftervevery 1/bunch

I'll try to keep it up to date as much as I can

4. How do you incorporate the country flags in Excel? I wish my excel skills were a tenth as good as yours.

it's just normal jpg objects, directly from the BWF site.
as for excel, very kind of you to say so. I'm just learning it as it goes along

Fan123 · Apr 16, 2015

AlanY said:
in red ....

maybe by filling in the blank spaces. BTW in WS aren't TR and TB the same athlete?

AlanY · Sep 21, 2015

datebase updated to incl japan and korea open

https://drive.google.com/file/d/0B1h-Y2fdTl08RlJkaHZpSmpvS1k/view?usp=sharing

pcll99 · Sep 21, 2015

AlanY said:
here are more statistics/tables to track the 500 titles by Countries/Member Associations;

the first 24 SuperSeries
[TABLE="class: grid, width: 500"]
[TR]
[TD]

MS
China
Indonesia
Malaysia
SouthKorea
Denmark
HongKong
Indonesia/USA
Thailand
England
Germany
India
Japan
Poland
Singapore
Spain
Taiwan
Total

[TD="width: 64"]WS[/TD]
[TD="width: 64"]MD[/TD]
[TD="width: 64"]WD[/TD]
[TD="width: 64"]XD[/TD]
[TD="width: 64"]Total[/TD]

[TD="align: right"]11[/TD]
[TD="align: right"]15[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]65[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]17[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]13[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]120[/TD]

[/TD]
[/TR]
[/TABLE]

the first 48 SuperSeries
[TABLE="class: grid, width: 500"]
[TR]
[TD]

MS
China
Malaysia
Indonesia
Denmark
SouthKorea
HongKong
India
Thailand
Taiwan
Poland
Indonesia/USA
England
Japan
Singapore
Germany
Spain
Total

[TD="width: 64"]WS[/TD]
[TD="width: 64"]MD[/TD]
[TD="width: 64"]WD[/TD]
[TD="width: 64"]XD[/TD]
[TD="width: 64"]Total[/TD]

[TD="align: right"]20[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]121[/TD]

[TD="align: right"]15[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]27[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]8[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]24[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]23[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]13[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]23[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]48[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]240[/TD]

[/TD]
[/TR]
[/TABLE]

the first 72 SuperSeries
[TABLE="class: grid, width: 500"]
[TR]
[TD]

MS
China
Malaysia
SouthKorea
Indonesia
Denmark
Thailand
Taiwan
HongKong
India
Japan
Poland
Indonesia/USA
England
Germany
Singapore
Spain
Total

[TD="width: 64"]WS[/TD]
[TD="width: 64"]MD[/TD]
[TD="width: 64"]WD[/TD]
[TD="width: 64"]XD[/TD]
[TD="width: 64"]Total[/TD]

[TD="align: right"]31[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]57[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]192[/TD]

[TD="align: right"]25[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]38[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]22[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]34[/TD]

[TD="align: right"]7[/TD]

[TD="align: right"]9[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]30[/TD]

[TD="align: right"]5[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]29[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]7[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]72[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]360[/TD]

[/TD]
[/TR]
[/TABLE]

the first 100 SuperSeries
[TABLE="class: grid, width: 500"]
[TR]
[TD]

MS
China
Malaysia
Indonesia
SouthKorea
Denmark
India
Taiwan
Japan
Thailand
HongKong
England
Poland
Spain
Indonesia/USA
Germany
Singapore
Total

[TD="width: 64"]WS[/TD]
[TD="width: 64"]MD[/TD]
[TD="width: 64"]WD[/TD]
[TD="width: 64"]XD[/TD]
[TD="width: 64"]Total[/TD]

[TD="align: right"]40[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]82[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]264[/TD]

[TD="align: right"]35[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]49[/TD]

[TD="align: right"]9[/TD]

[TD="align: right"]18[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]48[/TD]

[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]39[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]9[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]10[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5[/TD]

[TD="align: right"]9[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]9[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]500[/TD]

[/TD]
[/TR]
[/TABLE]

nice table..

AlanY · Sep 21, 2015

Korea has finally overtook Indonesia and Malaysia as the second most titles nation;

AlanY · Sep 21, 2015

titles won by the top 3 are fairly consistent among the 5 discipencies about 40% with the exception of MS due to the exceptional record of LCW in the SuperSeries

AlanY · Sep 21, 2015

so, what do you think the table below represented?
no cheating by going thro' the database.

[TABLE="class: grid, width: 500"]
[TR]
[TD]MS[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]WS[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]MD[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]WD[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]XD[/TD]
[TD]10[/TD]
[/TR]
[/TABLE]

Nine Tailed Fox · Sep 21, 2015

Lin Dan has won only 18 Superseries in his career ???

AlanY · Sep 21, 2015

Nine Tailed Fox said:
Lin Dan has won only 18 Superseries in his career ???

yes, but remember SS only started in 2007, before that they were still the same t'ments but not called as SuperSeries

Justin L · Sep 21, 2015

Great work, Alan Y, just as valuable as whyau's tournament video sharing, can't thank both of you enough.

racketman123 · Sep 21, 2015

AlanY said:
yes, but remember SS only started in 2007, before that they were still the same t'ments but not called as SuperSeries

Also Lin Dan wasn't really the week in week out performer in the superseries. That was all Chong Wei.

Fan123 · Sep 22, 2015

Thanks Alan

RuSSy · Sep 22, 2015

IS this mistake?
"Winners" tap -> 170row

BWF World Championships 2014 CL CM LYD/YYS MJ/TYT LCH/CHW
-----------------------------------

result of 2014 WC is KO/Shin , TQ/ZYL , ZN/ZYL

AlanY · Sep 23, 2015

yes, will check and correct them.
thanks

AlanY · Sep 23, 2015

RuSSy said:
IS this mistake?
"Winners" tap -> 170row

BWF World Championships 2014 CL CM LYD/YYS MJ/TYT LCH/CHW
-----------------------------------

result of 2014 WC is KO/Shin , TQ/ZYL , ZN/ZYL

thanks, that was the results of 2015 Aust Open.
will correct them

RuSSy · Sep 30, 2015

I have Q.
GC said at KOREA OPEN XD F ( 28:12~ )" she (ZYL) will win 39th SS tiles equal with LCW "

but your EXCEL shows that, LCW win just 34
and ZYL wins 35 (with CS 4, ZQX 1, TQ 9, ZN 21)

which is correct?

And Q2 who is the most winner of SS (all Disp.) LCW 34, ZYL 35 LYD 35 ??

AlanY · Oct 1, 2015

I guess GC has included the SSF in her total titles that the spreadsheet doesn't because;

1) SSF is not a open t'ment and for invitations only; and more importantly
2) it's not guaranteed for every year, some years has none and some has 2 within a year that will mess up the spreadsheet format.

for your Q2, based on the spreadsheet, i.e excl the SSF

the top3 are

1) Yu Yang 37
2) Lee Yong Dae 36
3) Zhao YunLei 35

RuSSy · Oct 1, 2015

AlanY said:
I guess GC has included the SSF in her total titles that the spreadsheet doesn't because;

1) SSF is not a open t'ment and for invitations only; and more importantly
2) it's not guaranteed for every year, some years has none and some has 2 within a year that will mess up the spreadsheet format.

for your Q2, based on the spreadsheet, i.e excl the SSF

the top3 are

1) Yu Yang 37
2) Lee Yong Dae 36
3) Zhao YunLei 35

Thank you very much!!!

AlanY · Oct 1, 2015

you're welcome

AlanY · Oct 26, 2015

updated to include DEN and French Opens

https://drive.google.com/file/d/0B1h-Y2fdTl08YXNhVE9iTldQU2c/view?usp=sharing

	MS
China
Indonesia
Malaysia
SouthKorea
Denmark
HongKong
Indonesia/USA
Thailand
England
Germany
India
Japan
Poland
Singapore
Spain
Taiwan
Total

SuperSeries Winners and statistics

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member

Regular Member