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@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
_______________________________________________
CQ-Contest mailing list
CQ-Contest@contesting.com
http://lists.contesting.com/mailman/listinfo/cq-contest
|