this is the array formula in excel to sum up the top 10 highest points {=SUM(LARGE(F3:AK3,ROW(INDIRECT("1:"&MIN(10,COUNTA(F3:AK3))))))} sorry, not much experience in open office
Hey guys Sorry, for this mistake. It was a problem with the newly implemented database... Now it is fully fixed. Next point, GBR has in minimum 2 quota places, what doesn't mean that GBR has 2 extra places. (That's how I understand the qualifying rules: "The host NOC (Great Britain) is entitled to enter a minimum of two players") And finally there are 3 male and 3 female quota place which can fully determinend by the comitee, that's the reason why I used only 35 single quota places, 15 double places and 14 mixed places. (I don't expect that they use the Triparite quota places only for Mixed: would be 13...)
^^^^ demolidor, you're forgetting the 7800 points that are about to come falling off the total of Robertson/Wallwork coupled with the 4000+ points that chris/IMO are going to be picking up in denmark CA/IB #1 RB/GW #2
Yeah, don't know why it both translated and modified the formula. Will try it later ... It is a bit vague for sure (probably you are right) "HOST COUNTRY REPRESENTATION The host NOC (Great Britain) is entitled to enter a minimum of two players. If additional players qualify under the regulations, they may also be entered. "If two or more players from the host NOC (Great Britain) are not placed in qualifying positions from the BWF ranking list of 3 May 2012 then the entitlement of two players shall be completed by the qualification of an additional player or players from the BWF ranking list(s) nominated by the British Olympic Association. The player(s) qualifying for the host NOC will be the highest ranked player(s)/pair in the nominated BWF ranking list(s) of 3 May 2012, or if there is no host NOC players/pair in the nominated BWF ranking list, the NOC will decide the entries latest by 10 May 2012. " Since when does GBR1 = NR/JW??
Updated with INA GP Gold. in: http://www.mediafire.com/?mf3pzz2rt9p31 snapshot at the top. not much changed at the top apart from Taufik Hidayat back to the top 10 and his MD teammates also gaining points. Code: [FONT=Courier New] [/FONT][TABLE] [TR] [TD][TABLE="class: grid"] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Men's Singles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Ave/ t'ment[/TD] [/TR] [TR] [TD]1[/TD] [TD]MAS[/TD] [TD]Lee Chong Wei[/TD] [TD]45647[/TD] [TD]5[/TD] [TD]9129[/TD] [/TR] [TR] [TD]2[/TD] [TD]JPN[/TD] [TD]Sho Sasaki[/TD] [TD]45626[/TD] [TD]9[/TD] [TD]5070[/TD] [/TR] [TR] [TD]3[/TD] [TD]CHN[/TD] [TD]Lin Dan[/TD] [TD]44836[/TD] [TD]6[/TD] [TD]7473[/TD] [/TR] [TR] [TD]4[/TD] [TD]DEN[/TD] [TD]Peter Hoeg Gade[/TD] [TD]44613[/TD] [TD]6[/TD] [TD]7435[/TD] [/TR] [TR] [TD]5[/TD] [TD]CHN[/TD] [TD]Chen Jin[/TD] [TD]44110[/TD] [TD]7[/TD] [TD]6301[/TD] [/TR] [TR] [TD]6[/TD] [TD]VIE[/TD] [TD]Tien Minh Nguyen[/TD] [TD]43559[/TD] [TD]9[/TD] [TD]4840[/TD] [/TR] [TR] [TD]7[/TD] [TD]CHN[/TD] [TD]Chen Long[/TD] [TD]37900[/TD] [TD]6[/TD] [TD]6317[/TD] [/TR] [TR] [TD]8[/TD] [TD]KOR[/TD] [TD]Lee Hyun Il[/TD] [TD]35710[/TD] [TD]9[/TD] [TD]3968[/TD] [/TR] [TR] [TD]9[/TD] [TD]GER[/TD] [TD]Marc Zwiebler[/TD] [TD]28806[/TD] [TD]9[/TD] [TD]3201[/TD] [/TR] [TR] [TD]10[/TD] [TD]INA[/TD] [TD]Taufik Hidayat[/TD] [TD]27870[/TD] [TD]7[/TD] [TD]3981[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Women's Singles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Ave/ t'ment[/TD] [/TR] [TR] [TD]1[/TD] [TD]TPE[/TD] [TD]Cheng Shao Chieh[/TD] [TD]50087[/TD] [TD]10[/TD] [TD]5009[/TD] [/TR] [TR] [TD]2[/TD] [TD]IND[/TD] [TD]Saina Nehwal[/TD] [TD]48137[/TD] [TD]8[/TD] [TD]6017[/TD] [/TR] [TR] [TD]3[/TD] [TD]CHN[/TD] [TD]Wang Xin[/TD] [TD]44594[/TD] [TD]7[/TD] [TD]6371[/TD] [/TR] [TR] [TD]4[/TD] [TD]CHN[/TD] [TD]Wang Yihan[/TD] [TD]43660[/TD] [TD]5[/TD] [TD]8732[/TD] [/TR] [TR] [TD]5[/TD] [TD]GER[/TD] [TD]Juliane Schenk[/TD] [TD]42114[/TD] [TD]7[/TD] [TD]6016[/TD] [/TR] [TR] [TD]6[/TD] [TD]TPE[/TD] [TD]Tai Tzu Ying[/TD] [TD]41597[/TD] [TD]11[/TD] [TD]3782[/TD] [/TR] [TR] [TD]7[/TD] [TD]CHN[/TD] [TD]Wang Shixian[/TD] [TD]40147[/TD] [TD]6[/TD] [TD]6691[/TD] [/TR] [TR] [TD]8[/TD] [TD]JPN[/TD] [TD]Sayaka Sato[/TD] [TD]39400[/TD] [TD]11[/TD] [TD]3582[/TD] [/TR] [TR] [TD]9[/TD] [TD]DEN[/TD] [TD]Tine Baun[/TD] [TD]38627[/TD] [TD]7[/TD] [TD]5518[/TD] [/TR] [TR] [TD]10[/TD] [TD]THA[/TD] [TD]Inthanon Ratchanok[/TD] [TD]37903[/TD] [TD]10[/TD] [TD]3790[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Men's Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Ave/ t'ment[/TD] [/TR] [TR] [TD]1[/TD] [TD]CHN[/TD] [TD]Cai Yun / Fu Haifeng[/TD] [TD]57111[/TD] [TD]6[/TD] [TD]9519[/TD] [/TR] [TR] [TD]2[/TD] [TD]KOR[/TD] [TD]Jung Jae Sung / Lee Yong Dae[/TD] [TD]49501[/TD] [TD]7[/TD] [TD]7072[/TD] [/TR] [TR] [TD]3[/TD] [TD]INA[/TD] [TD]Mohammad Ahsan / Bona Septano[/TD] [TD]49042[/TD] [TD]8[/TD] [TD]6130[/TD] [/TR] [TR] [TD]4[/TD] [TD]KOR[/TD] [TD]Ko Sung Hyun / Yoo Yeon Seong[/TD] [TD]43815[/TD] [TD]7[/TD] [TD]6259[/TD] [/TR] [TR] [TD]5[/TD] [TD]INA[/TD] [TD]Alvent Yulianto Chandra / Hendra Aprida Gunawan[/TD] [TD]43170[/TD] [TD]9[/TD] [TD]4797[/TD] [/TR] [TR] [TD]6[/TD] [TD]TPE[/TD] [TD]Fang Chieh Min / Lee Sheng Mu[/TD] [TD]40359[/TD] [TD]11[/TD] [TD]3669[/TD] [/TR] [TR] [TD]7[/TD] [TD]JPN[/TD] [TD]Hirokatsu Hashimoto / Noriyasu Hirata[/TD] [TD]39423[/TD] [TD]10[/TD] [TD]3942[/TD] [/TR] [TR] [TD]8[/TD] [TD]MAS[/TD] [TD]Kien Keat Koo / Boon Heong Tan[/TD] [TD]38381[/TD] [TD]6[/TD] [TD]6397[/TD] [/TR] [TR] [TD]9[/TD] [TD]JPN[/TD] [TD]Naoki Kawamae / Shoji Sato[/TD] [TD]36224[/TD] [TD]10[/TD] [TD]3622[/TD] [/TR] [TR] [TD]10[/TD] [TD]JPN[/TD] [TD]Hiroyuki Endo / Kenichi Hayakawa[/TD] [TD]36220[/TD] [TD]9[/TD] [TD]4024[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Women's Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Ave/ t'ment[/TD] [/TR] [TR] [TD]1[/TD] [TD]JPN[/TD] [TD]Shizuka Matsuo / Mami Naito[/TD] [TD]45285[/TD] [TD]9[/TD] [TD]5032[/TD] [/TR] [TR] [TD]2[/TD] [TD]CHN[/TD] [TD]Tian Qing / Zhao Yunlei[/TD] [TD]44448[/TD] [TD]6[/TD] [TD]7408[/TD] [/TR] [TR] [TD]3[/TD] [TD]KOR[/TD] [TD]Ha Jung Eun / Kim Min Jung[/TD] [TD]44052[/TD] [TD]8[/TD] [TD]5507[/TD] [/TR] [TR] [TD]4[/TD] [TD]CHN[/TD] [TD]Wang Xiaoli / Yu Yang (F)[/TD] [TD]39955[/TD] [TD]4[/TD] [TD]9989[/TD] [/TR] [TR] [TD]5[/TD] [TD]TPE[/TD] [TD]Cheng Wen Hsing / Chien Yu Chin[/TD] [TD]39950[/TD] [TD]8[/TD] [TD]4994[/TD] [/TR] [TR] [TD]6[/TD] [TD]JPN[/TD] [TD]Miyuki Maeda / Satoko Suetsuna[/TD] [TD]39565[/TD] [TD]8[/TD] [TD]4946[/TD] [/TR] [TR] [TD]7[/TD] [TD]JPN[/TD] [TD]Mizuki Fujii / Reika Kakiiwa[/TD] [TD]39000[/TD] [TD]7[/TD] [TD]5571[/TD] [/TR] [TR] [TD]8[/TD] [TD]INA[/TD] [TD]Vita Marissa / Nadya Melati[/TD] [TD]38900[/TD] [TD]9[/TD] [TD]4322[/TD] [/TR] [TR] [TD]9[/TD] [TD]INA[/TD] [TD]Greysia Polii / Meiliana Jauhari[/TD] [TD]38123[/TD] [TD]7[/TD] [TD]5446[/TD] [/TR] [TR] [TD]10[/TD] [TD]KOR[/TD] [TD]Jung Kyung Eun / Kim Ha Na[/TD] [TD]35980[/TD] [TD]9[/TD] [TD]3998[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Mixed Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Ave/ t'ment[/TD] [/TR] [TR] [TD]1[/TD] [TD]TPE[/TD] [TD]Chen Hung Ling / Cheng Wen Hsing[/TD] [TD]52922[/TD] [TD]9[/TD] [TD]5880[/TD] [/TR] [TR] [TD]2[/TD] [TD]CHN[/TD] [TD]Xu Chen / Ma Jin[/TD] [TD]45936[/TD] [TD]8[/TD] [TD]5742[/TD] [/TR] [TR] [TD]3[/TD] [TD]CHN[/TD] [TD]Zhang Nan / Zhao Yunlei[/TD] [TD]40880[/TD] [TD]5[/TD] [TD]8176[/TD] [/TR] [TR] [TD]4[/TD] [TD]INA[/TD] [TD]Tantowi Ahmad / Liliyana Natsir[/TD] [TD]39900[/TD] [TD]5[/TD] [TD]7980[/TD] [/TR] [TR] [TD]5[/TD] [TD]TPE[/TD] [TD]Lee Sheng Mu / Chien Yu Chin[/TD] [TD]39146[/TD] [TD]10[/TD] [TD]3915[/TD] [/TR] [TR] [TD]6[/TD] [TD]JPN[/TD] [TD]Shintaro Ikeda / Reiko Shiota[/TD] [TD]38520[/TD] [TD]10[/TD] [TD]3852[/TD] [/TR] [TR] [TD]7[/TD] [TD]THA[/TD] [TD]Sudket Prapakamol / Saralee Thoungthongkam[/TD] [TD]35074[/TD] [TD]8[/TD] [TD]4384[/TD] [/TR] [TR] [TD]8[/TD] [TD]DEN[/TD] [TD]Joachim Fischer Nielsen / Christinna Pedersen[/TD] [TD]33826[/TD] [TD]6[/TD] [TD]5638[/TD] [/TR] [TR] [TD]9[/TD] [TD]KOR[/TD] [TD]Lee Yong Dae / Ha Jung Eun[/TD] [TD]33061[/TD] [TD]9[/TD] [TD]3673[/TD] [/TR] [TR] [TD]10[/TD] [TD]GER[/TD] [TD]Michael Fuchs / Birgit Michels[/TD] [TD]32444[/TD] [TD]9[/TD] [TD]3605[/TD] [/TR] [TR] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [/TABLE] [/TD] [/TR] [/TABLE] [FONT=Courier New] [/FONT]
Congratulations to Sho Sasaki . Sho Sasaki is only just next to Lee Chong Wei? Congratulations to Sho Sasaki. .
. If you look at the Top 10 Mens Singles player, these are the number of tournaments that they have played in the last 12 months; 19 tournaments * Boonsak PONSANA 17 tournaments * Tien Minh NGUYEN * Sho SASAKI 15 tournaments * Taufik HIDAYAT * CHEN Jin 14 tournaments * CHEN Long * DU Pengyu 13 tournaments * LIN Dan 11 tournaments * LEE Chong Wei * Peter Hoeg GADE Source (BWF Ranking as at 06-Oct-2011); http://bwfbadminton.org/page.aspx?id=14955 .
I've finally completed all tournaments from 2 May 2011 that included the minor ones as well. As expected not much changes at the top except in MS Tommy Sugiarto (9) replaced Taufik Hidayat (11) as INA's No 1. And Juliane Schenk moved up a few places to No 3. With the minor t'ments included a clearer pictures emerged for the other end of the spectrum for the free places; snapshot below shown the front runners. Currently Canada has 3 places - WS, WD and XD. USA has 1 place - MD Guatemala has 1 place - MS Australia has 4 places - MS, MD, WD and XD. New Zealand has 1 place - WS. South Africa has all the 5 places! Probably the only country apart from China has representives in all 5 events. Code: [FONT=Courier New] [/FONT][TABLE] [TR] [TD][TABLE="class: grid"] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Men's Singles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Confederation[/TD] [/TR] [TR] [TD]22[/TD] [TD]GUA[/TD] [TD]Kevin Cordon[/TD] [TD]22810[/TD] [TD]8[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]44[/TD] [TD]CAN[/TD] [TD]Stefan Wojcikiewicz[/TD] [TD]16928[/TD] [TD]12[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]88[/TD] [TD]RSA[/TD] [TD]Jacob Malieka[/TD] [TD]8075[/TD] [TD]8[/TD] [TD]Africa[/TD] [/TR] [TR] [TD]106[/TD] [TD]UGA[/TD] [TD]Edwin Ekiring[/TD] [TD]6170[/TD] [TD]6[/TD] [TD]Africa[/TD] [/TR] [TR] [TD]132[/TD] [TD]AUS[/TD] [TD]Wesley Caulkett[/TD] [TD]4580[/TD] [TD]5[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]142[/TD] [TD]NZL[/TD] [TD]Michael Fowke[/TD] [TD]4040[/TD] [TD]4[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD].[/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Women's Singles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Confederation[/TD] [/TR] [TR] [TD]20[/TD] [TD]CAN[/TD] [TD]Li Michelle[/TD] [TD]22553[/TD] [TD]9[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]36[/TD] [TD]CAN[/TD] [TD]Nicole Grether[/TD] [TD]17700[/TD] [TD]10[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]66[/TD] [TD]NZL[/TD] [TD]Michelle Chan Ky[/TD] [TD]11180[/TD] [TD]7[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]69[/TD] [TD]RSA[/TD] [TD]Kerry-Lee Harrington[/TD] [TD]10629[/TD] [TD]8[/TD] [TD]Africa[/TD] [/TR] [TR] [TD]81[/TD] [TD]AUS[/TD] [TD]Victoria Na[/TD] [TD]8222[/TD] [TD]6[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]82[/TD] [TD]EGY[/TD] [TD]Hadia Hosny[/TD] [TD]8010[/TD] [TD]9[/TD] [TD]Africa[/TD] [/TR] [TR] [TD].[/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Men's Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Confederation[/TD] [/TR] [TR] [TD]20[/TD] [TD]USA[/TD] [TD]Howard Bach / Tony Gunawan[/TD] [TD]23731[/TD] [TD]7[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]21[/TD] [TD]CAN[/TD] [TD]Adrian Liu / Derrick Ng[/TD] [TD]22851[/TD] [TD]10[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]29[/TD] [TD]AUS[/TD] [TD]Ross Smith / Glenn Warfe[/TD] [TD]19210[/TD] [TD]7[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]39[/TD] [TD]RSA[/TD] [TD]Dorian Lance James / Willem Viljoen[/TD] [TD]14963[/TD] [TD]7[/TD] [TD]Africa[/TD] [/TR] [TR] [TD].[/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Women's Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Confederation[/TD] [/TR] [TR] [TD]17[/TD] [TD]AUS[/TD] [TD]Leanne Choo / Renuga Veeran[/TD] [TD]27519[/TD] [TD]11[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]19[/TD] [TD]CAN[/TD] [TD]Nicole Grether / Charmaine Reid[/TD] [TD]26230[/TD] [TD]10[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]20[/TD] [TD]USA[/TD] [TD]Iris Wang / Rena Wang[/TD] [TD]24960[/TD] [TD]10[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]39[/TD] [TD]RSA[/TD] [TD]Michelle Claire Edwards / Annari Viljoen[/TD] [TD]12495[/TD] [TD]6[/TD] [TD]Africa[/TD] [/TR] [TR] [TD]54[/TD] [TD]MRI[/TD] [TD]Kate Foo Kune / Karen Foo Kune[/TD] [TD]8700[/TD] [TD]7[/TD] [TD]Africa[/TD] [/TR] [TR] [TD].[/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [TR] [TD]Rank[/TD] [TD][/TD] [TD]Mixed Doubles[/TD] [TD]Points[/TD] [TD]No of t'ments[/TD] [TD]Confederation[/TD] [/TR] [TR] [TD]16[/TD] [TD]CAN[/TD] [TD]Toby Ng / Grace Gao[/TD] [TD]26900[/TD] [TD]10[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]29[/TD] [TD]CAN[/TD] [TD]Adrian Liu / Joycelyn Ko[/TD] [TD]17609[/TD] [TD]9[/TD] [TD]Pan America[/TD] [/TR] [TR] [TD]45[/TD] [TD]RSA[/TD] [TD]Dorian Lance James / Michelle Claire Edwards[/TD] [TD]11894[/TD] [TD]6[/TD] [TD]Africa[/TD] [/TR] [TR] [TD]52[/TD] [TD]AUS[/TD] [TD]Glenn Warfe / Leanne Choo[/TD] [TD]10680[/TD] [TD]5[/TD] [TD]Oceania[/TD] [/TR] [TR] [TD]69[/TD] [TD]EGY[/TD] [TD]Abderahmane Kaskal / Hadia Hosny[/TD] [TD]7190[/TD] [TD]5[/TD] [TD]Africa[/TD] [/TR] [TR] [TD].[/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [TD][/TD] [/TR] [/TABLE] [/TD] [/TR] [/TABLE] The full file is in: http://www.mediafire.com/?mf3pzz2rt9p31
Another radical change outside of the top 10 is POL, RUS and CAN MD1. Prety ridiculous a $15,000 Challenge tournament is worth 4000 points compared to 5000 for a $50,000 GP event (yet a 1500 point difference between an Int. Challenge and $5,000 Int. Series tournament @ 2500 points). The gap in prize money (relatively) between GP and GP Gold is also bigger than between GPG and SS yet the point differential between GPG and SS is bigger ... GP and GPG should get a points upgrade to maybe 6000 and 8000 .
those ranking points never made senses at all, just the way the players have to work on. only when i complied the results i realised that the 'Challenge' tournaments started with 256 MS and 8 rounds to win. well, they dont called it Challenge for nothing!
Only if you include the qualifying rounds (must say I hadn't really noticed the main was only R32 but was aware you need to win 3 to reach the main). Plus it's two days shorter overall only starting on the Thursdays ...
Australia has 4 places - MS, MD, WD and XD . This quite a pleasant surprise; Usually, New Zealand is a slight level higher than Australia. .
AUS's XD is at No 52 currently that they need to move up 2 places to secure qualification. watch this place.
some bad news guys. apparently, according to BWF ; "no more than two players/pairs from any one NOC can qualify through the Continental representation system".
. Good, I like it. Why? With so many walkovers given lately, I think BWF wants to prevent as many "No Matches" as possible. .
