Differences

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

--- howto:contestspreadsheets [2023/01/14 13:02] – [Winter Field Day Contest] va7fi
+++ howto:contestspreadsheets [2024/01/06 15:43] – [Contest Spreadsheets] 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_v20230114.ods |Winter Field Day}} (Last updated on <wrap hi>Jan 14, 2023</wrap>)
+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 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 245: / Line 248: @@
-The {{winter_fieldday_v20230114.ods |Logging Spreadsheet}} was last updated on Jan 14, 2023 for the Winter Field Day on Jan 28-29, 2023.
+The {{winter_fieldday_v20230128.ods |Logging Spreadsheet}} was last updated on Jan 28, 2023 for the Winter Field Day on Jan 28-29, 2023.
-Everything you need to know about the Winter Field Day contest is on the [[https://www.winterfieldday.com]].
+Everything you need to know about the Winter Field Day contest is here: [[https://www.winterfieldday.com]]
 ==== Logs ====
 During the contest, the following information must be logged for each station:
-  * Date and Time in UTC (for example 2021-01-30 and 1901)
+  * 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)
   * Callsign
   * 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 submitted online at www.winterfieldday.com
+At the end of the contest, the Cabrillo file must be submitted online at www.winterfieldday.com
@@ Line 291: / Line 294: @@
   * Attribute the work to me by linking to [[https://scarcs.ca/howto/contestspreadsheets]]
   * Distribute any derivative work under the same license.