User Tools

Site Tools


howto:contestspreadsheets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
howto:contestspreadsheets [2021/01/23 19:08] va7fihowto:contestspreadsheets [2024/01/06 15:45] (current) – [Winter Field Day Contest] va7fi
Line 1: Line 1:
 ====== Contest Spreadsheets ====== ====== Contest Spreadsheets ======
  
-Here are LibreOffice spreadsheets for three contests: +Here are some [[https://www.libreoffice.org/|LibreOffice]] spreadsheets for different contests: 
-  The {{rac_contests_v20201129.ods |RAC Canada Day / Winter Contests spreadsheet}}. +<WRAP center round important 80%> 
-  * The Winter Field Day Contest spreadsheet. <- FIXME+These spreadsheets do **not*work with Excel.  See below for more information on how to use them. 
 +</WRAP>
  
-Below are some details about each contests.+^ Contest             ^ Date                                  ^ File                               ^ Lasted Updated on        ^ 
 +| Winter Field Day    | 1900Z, Jan 27 to 1900Z, Jan 28, 2023  | {{winter_fieldday_v20240106.ods}}  | <wrap hi>Jan 6, 2024</wrap> 
 +| ARRL Field Day      | 1800Z, Jun 24 to 2100Z, Jun 25, 2023  | {{fieldday_v20230128.ods}}         | Jan 28, 2023             | 
 +| RAC Canada Day      | 0000Z to 2359Z, July 1st, 2023        | {{rac_contests_v20230128.ods}}     | Jan 28, 2023             | 
 +| RAC Winter Contest  | 0000Z to 2359Z, Dec 30, 2023          | {{rac_contests_v20230128.ods}}     | Jan 28, 2023             |
  
 +  * All spreadsheets are used in very similar ways, but they are different to account for the different rules and ways to calculate the points.
 +  * Most of the introduction below uses RAC's contest as an example but the same ideas apply to the other contests.
  
 ===== RAC Canada Day / Winter Contests ===== ===== RAC Canada Day / Winter Contests =====
- 
-The spreadsheet was last updated on November 29, 2020 to [[https://www.rac.ca/wp-content/uploads/2020/11/RAC-Cabrillo-V3.2.pdf |Cabrillo V3.2]] for the contest on Dec 18-19 2020. 
  
 Everything you need to know about the RAC Canada Day or Winter Day contest is located on the [[https://www.rac.ca/contesting-results/ |RAC website]].  It can be a bit overwhelming to digest for first-time contesters, so here's an overview. Everything you need to know about the RAC Canada Day or Winter Day contest is located on the [[https://www.rac.ca/contesting-results/ |RAC website]].  It can be a bit overwhelming to digest for first-time contesters, so here's an overview.
Line 24: Line 29:
   * Exchange (Two letter province code for Canadian Stations, or the serial number for other stations).   * Exchange (Two letter province code for Canadian Stations, or the serial number for other stations).
  
-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 //Cabrillo// format.+At the end of the contest, logs must be [[https://contest.rac.ca/ |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 //Cabrillo// format.
  
 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 (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 (with only a few entries as example):
Line 61: Line 66:
 </hidden> </hidden>
 <pagebreak> <pagebreak>
- 
-RAC does NOT want this information emailed to them in the body of the email.  Instead, this should be saved in as plain text file named (in my case): ''VA7FI.LOG'' and attached to the email. 
  
 Regular contesters use logging programs which can generate these files while providing features that facilitate the logging process during the contest.  Many people have recommended [[https://n1mmwp.hamdocs.com/ |N1MM]] as being the best one.  RAC also has its own Microsoft Windows {{https://www.rac.ca/wp-content/uploads/files/contests/files/RAC%20Contest%20Software.ZIP |contest program}} for its own contests.  This is what the spreadsheet looks like: Regular contesters use logging programs which can generate these files while providing features that facilitate the logging process during the contest.  Many people have recommended [[https://n1mmwp.hamdocs.com/ |N1MM]] as being the best one.  RAC also has its own Microsoft Windows {{https://www.rac.ca/wp-content/uploads/files/contests/files/RAC%20Contest%20Software.ZIP |contest program}} for its own contests.  This is what the spreadsheet looks like:
Line 75: Line 78:
 Here are a few introductory videos I made to explain how to use the spreadsheet, which should also work with the RAC Winter Contest in December. Here are a few introductory videos I made to explain how to use the spreadsheet, which should also work with the RAC Winter Contest in December.
  
-  * The first video shows where to download [[https://www.libreoffice.org/ |LibreOffice]], and how to set the Security settings to allow LibreOffice to run macros: ''Tools'' -> ''Options...'' -> ''LibreOffice'' -> ''Security'' -> ''Macro Security'' -> ''Medium''+  * The first video shows where to download [[https://www.libreoffice.org/ |LibreOffice]], and how to set the Security settings to allow LibreOffice to run macros: \\ ''Tools'' -> ''Options...'' -> ''LibreOffice'' -> ''Security'' -> ''Macro Security'' -> ''Medium''
 {{ youtube>7L_FxG2cJds }} {{ youtube>7L_FxG2cJds }}
  
Line 234: Line 237:
 ' '
 ' Provided that you: ' Provided that you:
-  * Attribute the work to me by linking to <https://scarcs.ca/howto/raccontests>+  * Attribute the work to me by linking to <https://scarcs.ca/howto/contestspreadsheets>
   * Distribute any derivative work under the same license.   * Distribute any derivative work under the same license.
  
Line 244: Line 247:
 ===== Winter Field Day Contest ===== ===== Winter Field Day Contest =====
  
-The spreadsheet was last updated on Jan 23, 2021 for the Winter Field Day on Jan 30-31, 2021. +Everything you need to know about the Winter Field Day contest is here: [[https://www.winterfieldday.com]]
- +
-Everything you need to know about the Winter Field Day contest is on the [[https://www.winterfieldday.com]].+
  
 ==== 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:
 +  * Date and Time in UTC (for example 2023-01-28 and 1901)
   * Frequency in kHz (for example, 14.125 MHz should be entered as 14125)   * Frequency in kHz (for example, 14.125 MHz should be entered as 14125)
-  * Mode (CW, DI, or PH) 
-  * Date and Time in UTC (for example 2021-01-30 and 1901) 
   * Callsign   * Callsign
-  * Class (ex. ''1H'': 1 operator at home, ''2O'': 2 operators outside, ''3I'': 3 operators inside) +  * Class (ex. ''1H'': 1 operator at home, ''2O'': 2 operators outside, ''3I'': 3 operators inside, ''4M'': 4 operators mobile
-  * ARRL Location (ex. BC, AB, SF, ...)+  * ARRL Location (ex. ''BC''''AB''''SF'', ...
 +  * Mode (''CW'', ''DG'', or ''PH'')
  
-At the end of the contest, the cabrillo file must be emailed to [[wfda@winterfieldday.com]] with subject line ''WFD 2021 Log YourCallsign''.+ 
 +At the end of the contest, the Cabrillo file must be submitted online at www.winterfieldday.com
  
  
Line 287: Line 289:
  
 Provided that you: Provided that you:
-  * Attribute the work to me by linking to [[https://scarcs.ca/howto/raccontests]]+  * Attribute the work to me by linking to [[https://scarcs.ca/howto/contestspreadsheets]]
   * Distribute any derivative work under the same license.   * Distribute any derivative work under the same license.
 +
  
  
  
howto/contestspreadsheets.1611457723.txt.gz · Last modified: 2021/01/23 19:08 by va7fi