howto:raccontests
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
howto:raccontests [2020/11/24 18:58] – va7fi | howto:raccontests [2020/12/04 22:41] – va7fi | ||
---|---|---|---|
Line 2: | Line 2: | ||
====== RAC Contests Log ====== | ====== RAC Contests Log ====== | ||
- | This year was my first time participating in the RAC Canada Day contest on my own. It was a lot of fun and also very instructive. | + | <WRAP center round info 85%> |
+ | I just updated the spreadsheet from Cabrillo V3.0 to [[https:// | ||
+ | </ | ||
+ | |||
+ | |||
+ | Last summer | ||
- | First, everything you need to know about the RAC Canada Day or Winter Day contest is located on the [[https:// | + | First, everything you need to know about the RAC Canada Day or Winter Day contest is located on the [[https:// |
===== Logs ===== | ===== Logs ===== | ||
During the contest, the following information must be logged for each station: | During the contest, the following information must be logged for each station: | ||
- | * Frequency in kHz (for example, 14.125 should be entered as 14125) | + | * Frequency in kHz (for example, 14.125 |
* Mode (CW or PH) | * Mode (CW or PH) | ||
* Date and Time in UTC (for example 2020-07-01 and 0135) | * Date and Time in UTC (for example 2020-07-01 and 0135) | ||
Line 18: | Line 23: | ||
At the end of the contest, logs must be submitted to RAC. They will accept paper logs for submissions with less than 100 entries, but they really prefer electronic logs, which must be submitted in the // | At the end of the contest, logs must be submitted to RAC. They will accept paper logs for submissions with less than 100 entries, but they really prefer electronic logs, which must be submitted in the // | ||
- | A Cabrillo file is really just plain text file formatted in a very specific way. For example, here's a copy of my Cabrillo file (with only a few entries as example): | + | A Cabrillo file is really just plain text file formatted in a very specific way. For example, here's a copy of my Cabrillo file from last summer |
<hidden onHidden=" | <hidden onHidden=" | ||
< | < | ||
Line 50: | Line 55: | ||
END-OF-LOG: | END-OF-LOG: | ||
</ | </ | ||
- | The first 21 lines give RAC all the information they need about the operator. | + | The first 21 lines give RAC all the information they need about the operator. |
</ | </ | ||
< | < | ||
Line 58: | Line 63: | ||
But since I'm not a regular contester and I didn't have time to familiarize myself with a logging program that would run under GNU/Linux, I simply used a spreadsheet to log my entries and tweaked it as the day went on to add my points and check for duplicate stations. | But since I'm not a regular contester and I didn't have time to familiarize myself with a logging program that would run under GNU/Linux, I simply used a spreadsheet to log my entries and tweaked it as the day went on to add my points and check for duplicate stations. | ||
- | |||
{{ : | {{ : | ||
Here are a few introductory videos I made to explain how to use the spreadsheet, | Here are a few introductory videos I made to explain how to use the spreadsheet, | ||
+ | * The first video shows where to download [[https:// | ||
{{ youtube> | {{ youtube> | ||
- | <WRAP center prewrap 90%> | ||
- | The first video shows where to download [[https:// | ||
- | </ | ||
+ | * The second video shows how to use the spreadsheet during the contest, and how to export the Cabrillo file after. | ||
{{ youtube> | {{ youtube> | ||
- | <WRAP center prewrap 90%> | ||
- | The second video shows how to use the spreadsheet during the contest, and how to export the Cabrillo file after. | ||
- | </ | ||
+ | * The third video shows a bit of the hidden formulas and the script that generates the Cabrillo file. It's like looking under the hood of the car: it's not needed to drive it, and it doesn' | ||
{{ youtube> | {{ youtube> | ||
- | <WRAP center prewrap 90%> | ||
- | The third video shows a bit of the hidden formulas and the script that generates the Cabrillo file. It's like looking under the hood of the car: it's not needed to drive it, and it doesn' | ||
- | </ | ||
- | Here is the link to {{:howto:rac_contests.ods |download it}}. It is: | + | Here is the link to {{ :howto:rac_contests_v20201129.ods |download it}}. It is: |
<WRAP indent> | <WRAP indent> | ||
<WRAP round box 80%> | <WRAP round box 80%> | ||
Line 101: | Line 99: | ||
sub cabrillo | sub cabrillo | ||
+ | |||
'Get directory path from spreadsheet location. This will be used to create | 'Get directory path from spreadsheet location. This will be used to create | ||
Dim path as String | Dim path as String | ||
Line 109: | Line 108: | ||
dim Doc as object | dim Doc as object | ||
Doc = ThisComponent | Doc = ThisComponent | ||
- | | + | |
- | | + | |
- | + | 'General | |
- | ' | + | |
' | ' | ||
- | | + | |
+ | if MyCallsign = "" | ||
+ | MyCallsign = " | ||
+ | endif | ||
| | ||
Line 124: | Line 125: | ||
'Read " | 'Read " | ||
- | for i = 0 to 18 ' read first 19 rows as is. | + | for i = 0 to 1 ' read first 2 rows as is. |
- | print #num, Sheet2.getCellByPosition(0, | + | print #num, Sheet1.getCellByPosition(0, |
next | next | ||
- | ' Row 20 needs " | + | |
- | print #num, Sheet2.getCellByPosition(0, | + | |
+ | print #num, Sheet1.getCellByPosition(0, | ||
+ | |||
+ | for i = 3 to 19 ' | ||
+ | print #num, Sheet1.getCellByPosition(0, | ||
+ | | ||
+ | |||
+ | ' | ||
+ | print #num, Sheet1.getCellByPosition(0, | ||
- | | + | |
if Len(Soapbox) > 70 then | if Len(Soapbox) > 70 then | ||
truncated = " | truncated = " | ||
Line 137: | Line 146: | ||
endif | endif | ||
- | print #num, Sheet2.getCellByPosition(0, | + | print #num, Sheet1.getCellByPosition(0, |
' | ' | ||
Line 154: | Line 163: | ||
| | ||
- | | + | |
| | ||
- | | + | |
'read " | 'read " | ||
Line 163: | Line 172: | ||
UTC = " | UTC = " | ||
while UTC <> "" | while UTC <> "" | ||
- | Freq = Sheet1.getCellByPosition(0, | + | Freq = Sheet2.getCellByPosition(0, |
Freq = Format(Freq, | Freq = Format(Freq, | ||
Freq = space(6 - Len(Freq)) & Freq ' | Freq = space(6 - Len(Freq)) & Freq ' | ||
- | UTC = Sheet1.getCellByPosition(1, | + | UTC = Sheet2.getCellByPosition(1, |
- | Callsign = Sheet1.getCellByPosition(2, | + | Callsign = Sheet2.getCellByPosition(2, |
Callsign = Callsign & space(13 - Len(Callsign)) | Callsign = Callsign & space(13 - Len(Callsign)) | ||
- | RST = Sheet1.getCellByPosition(3, | + | RST = Sheet2.getCellByPosition(3, |
RST = space(3 - Len(RST)) & RST 'pad RST to 3 digits | RST = space(3 - Len(RST)) & RST 'pad RST to 3 digits | ||
- | Exch = Sheet1.getCellByPosition(4, | + | Exch = Sheet2.getCellByPosition(4, |
- | RSTGiven = Sheet1.getCellByPosition(5, | + | RSTGiven = Sheet2.getCellByPosition(5, |
RSTGiven = space(3 - Len(RSTGiven)) & RSTGiven | RSTGiven = space(3 - Len(RSTGiven)) & RSTGiven | ||
- | Mode = Sheet1.getCellByPosition(6, | + | Mode = Sheet2.getCellByPosition(6, |
' | ' | ||
Line 199: | Line 208: | ||
logline = logline & Exch | logline = logline & Exch | ||
- | print #num, logline | + | print #num, Ucase(logline) 'print logline to text file |
i = i + 1 ' | i = i + 1 ' | ||
- | UTC = Sheet1.getCellByPosition(1, | + | UTC = Sheet2.getCellByPosition(1, |
' | ' |