Hello Jerry,
It looks like you found a mistake in my spreadsheet. Some of the numbers
imported into Excel came along with "spaces" trailing behind them. This
causes Excel to ignore that field when calculating. In your case, the number
56 was 56 space. When I corrected that, your submitted score and the
spreadsheet agree.
So it looks like I have one "busted entry" that's been detected so far. If
anyone finds others, please let me know via email. I had to do a lot of
manual fixing so there's a change for a few more busted entries.
You can fix this on your copy by selecting the cell G45 and typing 56. I
have made the correction to the spreadsheet and will upload Rev 1 later
today.
73 de Bob - KØRC in MN
----- Original Message -----
From: "Jerry Flanders" <jeflanders@comcast.net>
To: "Robert Chudek - KØRC" <k0rc@pclink.com>; <rtty@contesting.com>
Sent: Sunday, October 01, 2006 8:53 AM
Subject: Re: [RTTY] 2006 CQWW RTTY Contest Excel analysis...
At 07:03 10/1/2006, Robert Chudek - KØRC wrote:
>Well I spent the better part of today importing and massaging the data from
>the 2006 CQWW RTTY Scores Summary. You can get a copy of the spreadsheet
>here: http://tinyurl.com/qvnfg
>
>The spreadsheet recalculates scores from the explicit Q's and multipliers.
>There are 18 entries that don't jive.
...
>73 de Bob - KØRC in MN
Thanks for doing this, Bob. Curious that my
scores don't match up well. I claimed 318032 but you calculated 255760.
My 318032 comes directly from my Writelog
V10.60G screen, and it still calculates that
value when I call it up today. I don't know about
the date/version of the contest module that
actually does the calculation, but I presume it is the latest one.
It might be useful if others with similar
discrepancies would report how their scores were
calculated - might reveal a flaw in a program or contest module.
Jerry W4UK
_______________________________________________
RTTY mailing list
RTTY@contesting.com
http://lists.contesting.com/mailman/listinfo/rtty
|