Differences

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

--- howto:contestspreadsheets [2023/01/28 19:01] – [Contest Spreadsheets] 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_v20230128.ods |Winter Field Day}} (Last updated on <wrap hi>Jan 28, 2023</wrap>)
+These spreadsheets do **not** work with Excel.  See below for more information on how to use them.
-  * {{fieldday_v20230128.ods |Field Day}} (Last updated on <wrap hi>Jan 28, 2023</wrap>)
+</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 243: / Line 246: @@
 ===== Winter Field Day Contest =====
-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 here: [[https://www.winterfieldday.com]]