[CQ-Contest] 2010 IARU Pre-checking your log...

Wed Jul 14 04:42:56 PDT 2010

Methinks more high point CW players and "easier" to catch multipliers versus phone, because of power. 

It will be a good question to ask the guys who will be giving talks at events like SEDCO later this year...

Julius Fazekas
N2WN

Tennessee Contest Group
http://www.k4ro.net/tcg/index.html
http://groups.google.com/group/tcg1?hl=en

Tennessee QSO Party
http://www.tnqp.org/

Elecraft K2     #4455
Elecraft K3/100 #366
Elecraft K3/100 #1875

--- On Tue, 7/13/10, Jorge Diez - CX6VM <cx6vm.jorge at adinet.com.uy> wrote:

> From: Jorge Diez - CX6VM <cx6vm.jorge at adinet.com.uy>
> Subject: Re: [CQ-Contest] 2010 IARU Pre-checking your log...
> To: cq-contest at contesting.com
> Date: Tuesday, July 13, 2010, 4:07 PM
> Nice worksheet Bob,
> 
> Took my attention the % of CW and SSB QSO´s.
> 
> The stations in 1st and 3th place have a big % difference
> between the SSB
> and CW QSO´s, while the station in 2nd place have near the
> half in CW and
> the half in SSB.
> 
> Maybe this strategy was bad for the Estonia Team?
> 
> And why do you think the top stations prioritized the CW
> QSO´s? Because of
> the low power used?
> 
> 73,
> Jorge
> CX6VM/CW5W
> 
> -----Mensaje original-----
> De: cq-contest-bounces at contesting.com
> [mailto:cq-contest-bounces at contesting.com]
> En nombre de Robert Chudek - K0RC
> Enviado el: Martes, 13 de Julio de 2010 12:37 p.m.
> Para: Minnesota Wireless Association; cq-contest at contesting.com;
> N1MMLogger at yahoogroups.com
> Asunto: Re: [CQ-Contest] 2010 IARU Pre-checking your
> log...
> 
> 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:
> http://ru.wrtc2010.ru/index.php?id=51&idp=46
> 
> 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" <k0rc at citlink.net>
> To: "Minnesota Wireless Association" <mwa at w0aa.org>; 
> <cq-contest at contesting.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" <k0rc at citlink.net>
> > To: <N1MMLogger at yahoogroups.com>;
> <cq-contest at contesting.com>;
> "Minnesota 
> > Wireless Association" <mwa at w0aa.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 
> > others.
> >
> > 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 
> > log.
> >
> > 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 at 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
> CQ-Contest at contesting.com
> http://lists.contesting.com/mailman/listinfo/cq-contest
> 
> _______________________________________________
> CQ-Contest mailing list
> CQ-Contest at contesting.com
> http://lists.contesting.com/mailman/listinfo/cq-contest
> 