Ashraf,
sounds very interesting, wanna play with that.
I don't find the macro, shouldn't it be a .xlsm file instead of .xlsx ?
Marco HB9CAT
-----Messaggio originale-----
Da: CQ-Contest [mailto:cq-contest-bounces@contesting.com] Per conto di Ashraf
Chaabane
Inviato: giovedì 8 dicembre 2016 14:10
A: cq-contest <cq-contest@contesting.com>
Oggetto: [CQ-Contest] 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
73
--
Ash ~ 3V8SS/KF5EYY
http://www.kf5eyy.info/
Phone/SMS
/Whatsapp
: (+216) 22670026 <+216%2022%20670%20026>
Skype: kf5eyy
_______________________________________________
CQ-Contest mailing list
CQ-Contest@contesting.com
http://lists.contesting.com/mailman/listinfo/cq-contest
_______________________________________________
CQ-Contest mailing list
CQ-Contest@contesting.com
http://lists.contesting.com/mailman/listinfo/cq-contest
|