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

[Jerry Flanders]

I see at least one other miscalculation:  W4BQF 
has a similar space error. Didn't look for more.

Jerry W4UK


At 15:52 10/1/2006, Robert Chudek - KØRC wrote:
>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
>
>
>
>_______________________________________________
>RTTY mailing list
>RTTY at contesting.com
>http://lists.contesting.com/mailman/listinfo/rtty