The Great Big A2K Fantasy Olympics Game For 2012!

Standings - End of Day 1

1 shuho 64
2 George 62
3 tsartepan 54
4 Skin Rip 53
5 ossobuco 49
6 fbaezer 48
7 Unsullied 44
8 Jahiegel 44
9 markr 42
10 ehBeth 41
11 wheel158 41
12 Ticomaya 40
13 Iautah 40
14 mitso23 39
15 jetabor 33
16 McGentrix 32
17 hingehead 32
18 melis9701 32
19 lmur 31
20 tgordon92 30
21 Rhys 29
22 Ecartmill 28
23 Eagleye43 27
24 sdelong 25
25 tabormom 23
26 em19usa 22
27 realjohnboy 19
28 wheel Son#2 16
29 wheel Son#1 14

George almost holds on to his after-one-event lead. He and Shuho are the only competitors with the leading combination of China women and Italy.

I have the same scores, except:

George 63

and

realjohnboy 35

For George, I think you're missing a bronze medal for Serbia.

For realjohnboy, I think you're missing Japan + South Korea OR United States-Men + Japan (from his list).

By the way, I found this site to be the best at listing Men and Women medal counts separately (use the tabs above the medal table):

http://www.nbcolympics.com/medals/index.html

I agree with wheel158.

Thanks, Wheel! I've made the corrections in my spreadsheet, and they'll be reflected in tonight's standings.

Should have used my sheet all u enter is the results & bingo updates automatically

wheel158:

Here's something you might try with your Google Docs spreadsheet:

=ImportHtml("http://sports.yahoo.com/olympics/medals.html"; "table";2)

Unfortunately, it doesn't work with the NBC site, and Yahoo doesn't break it down by gender. However, it will automatically give you all but the four half teams when you refresh (F5) the page. It also uses different names for some countries (e.g. North Korea).

Results after Day 2:

1 shuho 118
2 George 109
3 tsartepan 97
4 Skin Rip 97
5 fbaezer 87
6 Iautah 84
7 ossobuco 82
8 Unsullied 79
9 Jahiegel 79
10 ehBeth 76
11 jetabor 75
12 mitso23 74
13 markr 72
14 wheel158 71
15 hingehead 66
16 realjohnboy 65
17 melis9701 63
18 tgordon92 62
19 tabormom 61
20 sdelong 59
21 McGentrix 58
22 Ticomaya 56
23 Rhys 56
24 Ecartmill 56
25 Eagleye43 51
26 wheel Son#2 47
27 lmur 47
28 em19usa 43
29 wheel Son#1 41

No change in the top four from yesterday.

Thanks for all the data corrections. I think I've fixed the bugs in my spreadsheet, but I'm sure that you all will let me know if that's not the case.

Thanks for the timely updates. Well done.

Hi, I should only be on 95 points

George & Shuho are both wrong as well 111 & 116 I've not check any of the others....

Here's what I've got (multiple differences):

shuho 116
George 111
tsarstepan 99
Skin Rip 95
fbaezer 85
Iautah 82
ossobuco 80
ehBeth 78
Jahiegel 77
Unsullied 77
jetabor 77
mitso23 74
markr 70
wheel158 69
hingehead 66
realjohnboy 65
melis9701 63
sdelong 61
tabormom 61
tgordon92 60
Ticomaya 58
Ecartmill 58
McGentrix 56
Rhys 56
son2 49
Eagleye43 48
lmur 47
em19usa 43
son1 41


based on:

People's Republic of China – men 1 1 0
People's Republic of China – women 5 3 2
United States of America – men 1 2 2
United States of America – women 2 3 1
Italy 2 3 2
Republic of Korea 2 1 2
France 2 1 1
Democratic People's Republic of Korea 2 0 1
Kazakhstan 2 0 0
Australia 1 1 1
Brazil 1 1 1
Hungary 1 1 1
Netherlands 1 1 0
Russian Federation 1 0 3
Georgia 1 0 0
South Africa 1 0 0
Japan 0 2 3
Great Britain 0 1 1
Colombia 0 1 0
Cuba 0 1 0
Poland 0 1 0
Romania 0 1 0
Taipei (Chinese Taipei) 0 1 0
Azerbaijan 0 0 1
Belgium 0 0 1
Canada 0 0 1
Republic of Moldova 0 0 1
Norway 0 0 1
Serbia 0 0 1
Slovakia 0 0 1
Ukraine 0 0 1
Uzbekistan 0 0 1

Thanks again to everyone for their corrections. This was a data entry problem, not a problem with the spreadsheet. I was keeping score as medals accumulated during the day and didn't cross check with the end-of-day totals, which I will do going forward. Markr's tabulation should be considered official for today.

I have the same exact scores except for Eagleye43:

Eagleye43 51

You had her listed at 48...

Her scoring on my sheet is:

Eagleye43

Australia 9
Great Britain 4
Belarus 0
Cuba 3
Netherlands 8
Brazil 9
Kazakhstan 10
Norway 1
Romania 3
Turkey 0
Belgium 1
Croatia 0
Chinese Taipei 3
Mexico 0
Zimbabwe 0
51


One of the bolded countries is likely the difference...

Interesting -- this would make scoring a snap! I'll have to give it a try.

Offhand, what are the 2nd and 3rd arguments/parameters? I see they are 'table' and '2', but just wondering if you can explain. If not, I'll do some research.

Thanks!

Never mind, I figured it out -- it pulls the second table from the page. I'll have to try this out -- pretty cool! The only thing is, it'll pull the entire table in (including China and USA), but as long as they're name differently, it's not a deal-breaker.

Also, instead of using the NBC link I posted, try these links instead:

All: http://www.nbcolympics.com/medals/library/2012-standings/tabs/medals/_overall.html

Men: http://www.nbcolympics.com/medals/library/2012-standings/tabs/medals/_men.html

Women: http://www.nbcolympics.com/medals/library/2012-standings/tabs/medals/_women.html

You got it - you can do lists too - here's the documentation:
https://support.google.com/docs/bin/answer.py?hl=en&answer=155182

And, as you probably already know, it works on the three sites you posted!

It was Taipei. I had a mismatch in the name (Taipei vs. Taipei (Chinese Taipei)).

I've been thinking about how to import just the China-Men, China-Women, USA-Men and USA-Women, and I'm wondering if this would do the trick:

ImportXML(URL, query)

Example: =importXml("http://www.toysrus.com"; "//a/@href"). This returns all of the href attributes (the link URLs) in all the <a> tags on http://www.toysrus.com homepage.

https://support.google.com/docs/bin/answer.py?hl=en&answer=155184

If that doesn't work, I guess I could import the Men standings and Women standings in their entirety, and specifically point to just the fields I need.

I was thinking along the lines of the latter.

Standings after Day 3:

1 George 150
2 tsartepan 146
3 shuho 141
4 Iautah 128
5 Skin Rip 120
6 ehBeth 115
7 jetabor 115
8 mitso23 113
9 ossobuco 112
10 fbaezer 109
11 Unsullied 107
12 Jahiegel 107
13 tabormom 105
14 realjohnboy 104
15 Ecartmill 103
16 melis9701 101
17 markr 100
18 wheel158 99
19 Ticomaya 98
20 hingehead 98
21 sdelong 96
22 tgordon92 90
23 McGentrix 88
24 lmur 85
25 Rhys 75
26 wheel Son#2 66
27 Eagleye43 66
28 em19usa 58
29 wheel Son#1 56

How are my calculations this time? Hopefully better than my picks.