[3830] 2006 JARTS RTTY Contest Excel spreadsheet online

Robert Chudek - KØRC k0rc at pclink.com
Mon Oct 23 22:08:08 EDT 2006


I have made the first pass with the JARTS RTTY scores and posted Rev 0 to the server. I am reorganizing the directory structure so you have this new TINYURL to use.

New link to Excel databases:  http://tinyurl.com/yd7ksr

You will also find a new version of the 2006 CQWW RTTY claimed scores (Rev 5).

My spreadsheets provide a basic level of error checking and will highlight an entry with YELLOW when the claimed score and the recalculated scores do not match. The problem may be a simple transposition of digits when you entered your data into the webform (it does not check the math, Excel does).

Also, if you report estimated operating hours, I capture this information and calculate a "48-hour-B-I-C" score, assuming you could maintain your average QSO and Multiplier rates. This calculation is done "just for fun". But maybe this will be your motivator if you discover you would move up to Top-10 or even First Place in your category. Scores submitted without operating hours have magenta colored cells. You can enter the number of hours of your effort, the colors will turn off, and your statistics will appear.

Send any spreadsheet score corrections direct to my email and I will include them in the next update. I will continue to pick up the 3830 scores as they are submitted, so there's no need to send your initial submission to me.

Please remember I am creating these spreadsheets to bolster my personal Excel skills and I am doing them as time permits. In the long run, I expect new technology for reporting scores in real-time and post contest processing will supersede my manual efforts.

And don't forget, you can take any one of these spreadsheets and use it as a temple to track the results of your own favorite radiosport events.

73 de Bob - KØRC in MN


More information about the 3830 mailing list