Differences

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

--- howto:contestspreadsheets [2021/07/01 17:21] – va7fi
+++ howto:contestspreadsheets [2024/01/06 15:45] (current) – [Winter Field Day Contest] va7fi
@@ Line 1: / Line 1: @@
 ====== 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 ways, but they are different to account for the different rules and ways to calculate the points.
+^ 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             |
-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 =====
-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.
@@ Line 26: / Line 29: @@
   * Exchange (Two letter province code for Canadian Stations, or the serial number for other stations).
-At the end of the contest, logs must be [[https://www.rac.ca/new-rac-contest-log-submission-system/ |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):
@@ 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.
-  * 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 }}
@@ Line 244: / Line 247: @@
 ===== 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 ====
 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)
-  * Mode (''CW'', ''DI'', or ''PH'')
-  * Date and Time in UTC (for example 2021-01-30 and 1901)
   * 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 291: / Line 291: @@
   * Attribute the work to me by linking to [[https://scarcs.ca/howto/contestspreadsheets]]
   * Distribute any derivative work under the same license.