[3830] [RTTY] 2006 CQWW RTTY Contest Excel analysis...

[Robert Chudek - KØRC]

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 at comcast.net>
To: "Robert Chudek - KØRC" <k0rc at pclink.com>; <rtty at 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