@Skin Rip,
Oh no I only get 119 on my sheet
@markr,
I have the same scores as markr.
Count those as official for Day 3...
So, when is the host country (Great Britain) going to step up, and start garnering some medals here? They'd better start raking in the Sailing, Equestrian and Fencing medals soon...
@wheel158,
If they don't they'll be smashing a rule that's held in place for my entire sporting memory. But if anyone can snatch defeat from the jaws of victory its the Poms. Gawd love em.
@wheel158,
Yeah, picking the UK is what I agonized over the most. I saw some predictions for 62 and 67 medals. I'm counting on them living up to the hype and beating the Chinese women, but they're off to a slow start...
Thanks to markr's sage advice, I've managed to nearly automate my Excel scoring sheet (Excel can auto-import data from websites too).
I setup the automation last night, and my automated scoring matched the manual scoring. But since I was using Yahoo! for the automatic medal count, I had to change Chinese Taipei to Taiwan.
I went through Yahoo's country listing, and made sure the chosen country names matched, so the automatic scoring would work. The only other difference I noticed was that tabormom chose Algiers (the city) instead of Algeria. I've fixed on my spreadsheet, but wanted other scorers to know.
@wheel158,
I've found the error and fixed it. There may have been an error in the NBC medal table, since I did a cross check before posting, or I may have just missed my mistake when doing so. Anyway, the corrected version from markr should be official, and now matches my scoring.
@wheel158,
If your waiting for Fencing your going to be waiting a long time ....we suck
Standings after Day 4:
1 tsartepan 200
2 George 196
3 shuho 184
4 Iautah 168
5 jetabor 167
6 tabormom 164
7 Skin Rip 161
8 mitso23 159
9 ehBeth 156
10 Ticomaya 150
11 ossobuco 148
12 realjohnboy 147
13 fbaezer 147
14 Ecartmill 140
15 Unsullied 137
16 hingehead 137
17 Jahiegel 137
18 sdelong 134
19 melis9701 129
20 McGentrix 127
21 markr 124
22 wheel158 124
23 tgordon92 121
24 lmur 120
25 Rhys 105
26 em19usa 96
27 wheel Son#2 89
28 Eagleye43 83
29 wheel Son#1 81
Congrats to our new leader, tsartepan!
I've double checked with the medal table, and I think all the bugs have been worked out of my spreadsheet programming, so this should be accurate, but I'm sure someone will let me know if there are any errors.
@tgordon92,
Double woot for lil ole me!
@tgordon92,
These scores match mine, but for some reason, I only have 149 for Ticomaya. I'm not sure if my score is wrong or what, but here's what I have for Ticomaya:
Germany 20
United States-Men 35
Canada 4
Japan 25
South Korea 24
Brazil 9
Czech Republic 0
Jamaica 0
Poland 3
Romania 13
Greece 0
Israel 0
Liechtenstein 0
Mexico 6
South Africa 10
149
@wheel158,
I also have 149 for Ticomaya.
@markr,
You're right; it should be 149. I had the formula for Ticomaya's score for Greece pointing to India's score. It's fixed now.
Results after Day 5:
1 tsartepan 257
2 George 240
3 shuho 235
4 tabormom 221
5 Iautah 219
6 Ticomaya 212
7 mitso23 208
8 Skin Rip 204
9 jetabor 204
10 realjohnboy 198
11 ossobuco 196
12 fbaezer 196
13 ehBeth 195
14 hingehead 194
15 Ecartmill 189
16 melis9701 186
17 Unsullied 180
18 McGentrix 179
19 Jahiegel 179
20 tgordon92 178
21 sdelong 172
22 wheel158 167
23 markr 165
24 Rhys 157
25 lmur 155
26 em19usa 145
27 wheel Son#2 120
28 wheel Son#1 119
29 Eagleye43 119
Tsartepan extends the lead over George, but less than a quarter of the medals have been awarded so far, so the contest is still wide open.
@tgordon92,
Day 2 = #22 ... Day 5 = #6!
Woo hoo!
Look out, George!
