Go Back   LPGA Golf Forum > General LPGA Message Boards > LPGA Tournaments > Member Contests

Reply
 
LinkBack Thread Tools Display Modes
Old 07-22-2008, 12:09 PM   #121
Contest Statistician
 
xman5's Avatar
 
Join Date: May 2006
Location: NYC
Posts: 7,713
I just computed MPfans round 2 by 2 different methods and each time it was 1033.

1. Erica Blasberg 66
2. Julieta Granada 66
3. Sherri Turner 66
4. Vicky Hurst 70
5. Sandra Gal 68
6. Karine Icher 71
7. Yani Tseng 66
8. Hee-Won Han 71
9. Angela Park 68
10. Christina Kim 68
11. Stacy Prammanasudh 66
12. Jimin Jeong 68
13. Danielle Ammaccapane 76
14. Jee Young Lee 70
15. Kelli Kuehne 73

1033

Last edited by xman5; 07-22-2008 at 12:11 PM.
xman5 is offline   Reply With Quote
Old 07-22-2008, 12:32 PM   #122
Contest Statistician
 
xman5's Avatar
 
Join Date: May 2006
Location: NYC
Posts: 7,713
To me it seems that my program works. I think any errors are due to keypunch errors or not hitting save or doing things out of order.

If you just want to keep your score here is an easy way. Instead of putting in all 3 players in the grouping, just put in your pick. The will save you time. When you go to the screen to select your picks, that will be the only one in the drop down.

Here is another trick for those that are using a spreadsheet. Go to the tournament page on the LPGA site and highlight the whole scoring grid from top to bottom.

Past that onto a blank worksheet. it will fill up the columns just like the grid on the LPGA site. Delete the columns that you don't want, so you just have the name and the score for the round in columns. There will be 2 rows that are black (they had ads). Delete those 2 rows. Sort those 2 columns by name. Adjust column height.

This 1 min trick will give you a name sorted scoring list for the round (with links to the score card as a bonus).

I then cut and past your 15 picks form the post where you made your picks to the right of the scoring list. Then drop in the score from the list on the left and some the 15 and you have your score. It should take you less then 5 mins to do that.

Thats how I did MPFANS score above. Doing it your self that might be faster then the program, but of course you don't get those fancy screens.
xman5 is offline   Reply With Quote
Old 07-22-2008, 02:20 PM   #123
Forum Moderator
 
Join Date: Mar 2006
Posts: 10,053
Originally Posted by xman5 View Post
I just computed MPfans round 2 by 2 different methods and each time it was 1033.

1. Erica Blasberg 66
2. Julieta Granada 66
3. Sherri Turner 66
4. Vicky Hurst 70
5. Sandra Gal 68
6. Karine Icher 71
7. Yani Tseng 66
8. Hee-Won Han 71
9. Angela Park 68
10. Christina Kim 68
11. Stacy Prammanasudh 66
12. Jimin Jeong 68
13. Danielle Ammaccapane 76
14. Jee Young Lee 70
15. Kelli Kuehne 73

1033
That's correct.

Two scores were calculated incorrectly by the spreadsheet for MPfan. Sherri Turner's 66 was recorded as a 70 and Hee-Won Han's 71 was recorded as a 68.

You can see the error here:
http://bp2.blogger.com/_VEe3iEbncUE/...orecard_r2.png

This was not an error in the spreadsheet formula. It was an error in the data entry person's fingers, that would be me.

MPfan told me about the Sherri Turner problem but not the Hee-Won Han problem.

The result is a net gain of one point. it did not change the overall placement for her or anyone else in the contest.

Sorry about that.
Blue is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On




All times are GMT -5. The time now is 06:08 PM.
Powered by vBulletin® Version 3.8.0
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2 PL2

Valid XHTML 1.0 Transitional Valid CSS!