[CQ-Contest] CW Contesting Efficiency Calculator

Sat Dec 10 07:29:43 EST 2016

Hi All,

Some people wrote me and asked for more clarifications on how to use the spreadsheet and macro. Sorry for sending it at “raw” state. I did improve it to make it easier to use.

The audio log has been extracted from CW Skimmer. Since CW Skimmer cannot generate a log of the stations “copied”, I launched Aggregator 4.0 used for RBN network. Once connected to CW Skimmer, Aggregator will take callsigns heard by CW Skimmer. If you want to receive all the stations that appear in the audio recording, you have to up-tick “Do not send sports without CQ” in CW Skimmer.

In order for Aggregator to generate a log, you have to tick “Should Aggregator record Skimmer telnet traffic in AggregatorLog.txt?”. This file will appear in the same folder where the exe file is.

The raw format of Aggregator log will have to be manually modified (until I include feature to do that automatically). The log will include events done by CW Skimmer (change of frequency, copied call, etc.). Only lines starting by “0DX” should be kept in the file. These lines represents the copied callsigns (and this is what we’re looking for”. 

Once the AggregatorLog is cleaned out, simply import it to “Skimmed_Log” Spreadsheet of the excel file.

Say for example the audio recording is from 1300z to 1400z. “Focus_Log” spreadsheet should contain the part of your Cabrillo contest log from 1300z to 1400z.

In my example, all QSOs in the selected period are on 20m. So I imported my entire Cabrillo contest log into “All_Log” Spreadsheet then removed all QSOs but the 20m ones (after a automatic sort out operation).

Now the data should be ready for calculation. You simply should run the macro by pressing Alt+Maj+G and clicking the play button. A form will appear. Press “Calculate” then wait for a minute.

The macro will cross check the “Skimmed_Log” spreadsheet calls against the selected-period log and the 20m entire log as described below.

Please re-download the file from the link below and let me know your thoughts.

http://www.kf5eyy.info/Audio%20vs%20log_WW%20CW%202016.xlsm

vy73

--

Ash KF5EYY

Op. 3V8SS, 3V8BB

 <http://www.kf5eyy.info/> www.kf5eyy.info

De : Ashraf Chaabane [mailto:ash.kf5eyy at gmail.com] 
Envoyé : jeudi 8 décembre 2016 14:10
À : cq-contest
Objet : CW Contesting Efficiency Calculator

Hi All,

I have developped a tool on VBA that enables CW Contesters to check their CW copying performance after the contest finishes.

You can download the excel file in the link below.

The file had 3 spreadsheets:

- "AllLog" is the contest log for all 20m QSOs (from Contest Cabrillo File).

- "20m" contains the extract of from log for the period of time where I want to examine performance.

- "Audio" contains the logged Callsigns by the CW Skimmer after I played back the contest audio recording for the same period of time (here limited to about 20 minutes operation just for trial).

When running the macro and clicking "Calculate", it will take each callsign from the "Skimmed log" and check in the "20m" spreadsheet if that call was copied by me or not during the contest. If yes, the callsign will trun green. If not, the macro will go and check if that station came back and call me on that band (returning station). If yes, the callsign will turn yellow. If not, it will turn red (The skimmer copied it but I didn't. The station didn't come back to me on that band).

The macro form will give numbers of:

- Total Callsigns Skimmed by CW Skimmer on that period.

- Callsigns that both Skimmer and I copied

- Percentage of callsigns both Skimmer and I copied against total stations that called me.

In summary, the macro will give idea on how many calls I copied during the contest versus all the station who called me on my frequency, I could hear them, but they left the frequency when they didn't get my answer in timely manner, etc.

The non-returned stations percentage will give idea on the missed points that could've been earned if I was more efficient copying callsigns.

You can change the spreadsheet content and calculate your performance. The macro will know number of lines, etc.

The tool is just very basic now. If someone is interested to develop it further, let's discuss.

Link:  <https://drive.google.com/file/d/0B9AtNpPfAOUMaDE2S1NlNUhQczg/view?usp=sharing> https://drive.google.com/file/d/0B9AtNpPfAOUMaDE2S1NlNUhQczg/view?usp=sharing

73

-- 

Ash ~ 3V8SS/KF5EYY

 <http://www.kf5eyy.info/> http://www.kf5eyy.info/

Phone/SMS

/Whatsapp

: (+216) 22670026 <tel:+216%2022%20670%20026> 

Skype: kf5eyy