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/07/01 17:17] – [Contest Spreadsheets] va7fihowto:contestspreadsheets [2024/01/06 15:45] (current) – [Winter Field Day Contest] va7fi
Line 1: Line 1:
 ====== Contest Spreadsheets ====== ====== Contest Spreadsheets ======
  
-Here are three LibreOffice spreadsheets for different contests: +Here are some [[https://www.libreoffice.org/|LibreOffice]] spreadsheets for different contests: 
-  * {{rac_contests_v20210701.ods |RAC Canada Day / Winter}} (Last updated on July 1, 2021) +<WRAP center round important 80%> 
-  {{winter_fieldday_v20210131.ods |Winter Field Day}} (Last updated on Jan 31, 2021) +These spreadsheets do **not** work with Excel See below for more information on how to use them. 
-  {{fieldday_v20210701.ods |Field Day}} (Last updated on July 1, 2021) +</WRAP>
  
-All three spreadsheets are used in very similar waysbut they are different to account for the different rules and ways to calculate the points.+^ Contest             ^ Date                                  ^ File                               ^ Lasted Updated on        ^ 
 +| Winter Field Day    | 1900ZJan 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             |
  
-Most of the introduction below uses RAC's contest as an example but the same ideas apply to the other contests.+  * 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 26: 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 63: 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 77: 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 246: Line 247:
 ===== Winter Field Day Contest ===== ===== Winter Field Day Contest =====
  
-The spreadsheet was last updated on Jan 29, 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]] +At the end of the contest, the Cabrillo file must be submitted online at www.winterfieldday.com
-  * with subject line ''WFD 2021 Log YourCallsign''.+
  
  
Line 293: Line 291:
   * Attribute the work to me by linking to [[https://scarcs.ca/howto/contestspreadsheets]]   * 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.1625185028.txt.gz · Last modified: 2021/07/01 17:17 by va7fi