For those people interested in slicing and dicing the WRTC team
performances, I have added a Scores worksheet to this Excel
workbook. The data was downloaded from the WRTC website:
You can sort the columns to analyze the different statistics. For
example, it was interesting to see the score reduction rates of
the various teams and how this compared to their standing. Score
reductions ranged from less than 3% to nearly 9%
Revision 1.0.2 can be downloaded from: http://tinyurl.com/267ordj
73 de Bob - KØRC in MN
----- Original Message -----
From: "Robert Chudek - K0RC" <firstname.lastname@example.org>
To: "Minnesota Wireless Association" <email@example.com>;
Sent: Monday, July 12, 2010 9:03 PM
Subject: Re: 2010 IARU Pre-checking your log...
> Rev 1.0.1 has been uploaded and adds some functionality. The workbook will
> now count the special AC, R1, R2, and R3 QSOs too. An error counter has
> been added to the ZoneCheck worksheet so you don't have the scroll the
> page to discover there were no errors detected.
> There is an issue where some Entities use the same IARU code. These QSOs
> are now summed and listed under the first name. Additional locations are
> still on the list but grayed out. They are no longer double counted. The
> workbook will not determine the individual Entity name, only the number of
> times the IARU Code was logged.
> Download the update here: http://tinyurl.com/267ordj
> 73 de Bob - KØRC in MN
> ----- Original Message -----
> From: "Robert Chudek - K0RC" <firstname.lastname@example.org>
> To: <N1MMLogger@yahoogroups.com>; <email@example.com>; "Minnesota
> Wireless Association" <firstname.lastname@example.org>
> Sent: Monday, July 12, 2010 12:38 PM
> Subject: [MWA] 2010 IARU Pre-checking your log...
> I created a new Excel workbook for IARU contest logs. This tool will
> identify inconsistencies in logging IARU zone numbers.
> You can download the tool from here: http://tinyurl.com/267ordj
> This workbook is pre-populated with a dummy log in the Log1 worksheet to
> illustrate how this tool can identify inconsistencies in logging. View the
> ZoneCheck work sheet and scroll down to lines 226 and 371. You will see a
> red cell to draw your attention to a problem. In one case, a typo reverses
> two letters in a HQ identifier. In the second case, a station was worked
> multiple times but in one instance the zone number does not match the
> Limitations: This tool will not identify a wrong zone from a single
> (unique) QSO. It will also not identify a wrong zone if the zone number
> was consistently logged wrong. This workbook will only process logs of
> 10,000 QSOs or less.
> HOW TO CHECK YOUR LOG:
> Clear the existing data from the Log1 worksheet by clicking the "Select
> All" cell (above row 1, to the left of column A). Clicking this cell will
> highlight the entire worksheet. Press the delete key. The worksheet will
> be cleared and is now ready for your log.
> Use Notepad to copy and paste your Cabrillo file into the Log1 worksheet.
> Use the standard Windows routine to copy and paste all the lines that
> start with QSO: in your Cabrillo file.
> Next, use the menu DATA > TEXT TO COLUMNS selections to populate the
> columns on the worksheet. When the conversion window pops up, select the
> "Fixed width" button and then click the "Finish" button. Excel will make
> the conversion and populate columns A through K with the fields from your
> Cabrillo import.
> Next, go to the ZoneCheck worksheet and click the "Check Zones" button in
> the upper left corner. Excel will analyze your Log1 data and populate
> columns E through H. It will also analyze the callsigns and zones and
> populate columns J through L. Scroll down this worksheet to see if there
> are any cells in column L highlighted in red.
> The Reports worksheet also provides some rudimentary statistics from your
> Email me if you have any questions or difficulties.
> 73 de Bob - KØRC in MN
> Minnesota Wireless Association mailing list
> To post a message: MWA@w0aa.org
> List Help: http://mail.w0aa.org/mailman/listinfo/mwa_w0aa.org
> MWA Official Web Site: http://www.w0aa.org
CQ-Contest mailing list