Differences

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

--- howto:netspreadsheet [2021/01/10 13:50] – [Net Roll Call Spreadsheet] va7fi
+++ howto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] va7fi
@@ Line 8: / Line 8: @@
 If you don't have LibreOffice or Excel on your computer, you'll want to install [[https://libreoffice.org/ |LibreOffice]] first, which is a free and open source office suite.
+===== Quick Demo =====
+For those who don't like to read instructions...
+{{  netrollcall.gif  }}
 ===== Downloading The File =====
 Currently, the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
@@ Line 15: / Line 17: @@
 {{  :howto:download.png  }}
-A few things to keep in mind:
+The date in the title of the file represents the last time the spreadsheet was updated.  You'll want to download a fresh copy from time to time to take advantage of new entries that are added periodically.
-  * If you notice anything that needs to be updated, please email [[va7fi@rbox.me |Patrick, VA7FI]].  That way, other users will benefit from your report.
-  * Download a fresh copy periodically so as to always have the latest database.
@@ Line 36: / Line 36: @@
 <WRAP center round important 80%>
-The most important thing is that <fc #008000>you can type in and delete cells in green</fc>, but you should <fc #ff0000>not edit or delete cells in orange</fc>.
+The most important thing to know is that <fc #008000>you can type in and delete cells in green</fc>, but you should <fc #ff0000>not edit or delete cells in orange</fc>.
 </WRAP>
@@ Line 89: / Line 89: @@
   * When ''jh'' was entered in the suffix, the callsign asked for a ''Prefix?'' because two callsigns have the same suffix.  Once the prefix is entered, the spreadsheet is able to fill in the rest of the information from the ''Local Data''.
   * When ''aaa'' is entered, it's not found in the ''Local Data'' so it asks for the ''Prefix'' to look it up in the ''ISED Data''.
-  * When ''wek'' is entered, it's not found in either databases so it returns ''Not Found''.  If you know that this is a valid callsign (maybe a new ham), please email [[va7fi@rbox.me |Patrick]] so he can update the ''Local Data''.
+  * When ''wek'' is entered, it's not found in either databases so it returns ''Not Found''.
 Here are a few more details:
@@ Line 138: / Line 138: @@
   * Every so often, you should delete your personal copy (or make a backup) and download a fresh copy so that you can have the latest database.
   * Please do NOT edit the database in your personal copy since no-one else will benefit from your edits.  Instead, email [[va7fi@rbox.me |Patrick, VA7FI]] the information that needs to be added / edited in the online version.
+====== Submit Updates ======
+To submit an update to the main online spreadsheet, use the [[https://docs.google.com/forms/d/e/1FAIpQLSc3Taz4Tvr-pABqXBsCBMtnhkxlly2jgiiDyzPxGa2qurb5Hw/viewform |Net Roll Call New Entry Submission Form]], which has a link in the spreadsheet:
+{{ :howto:submitlink.png }}
+Which will take you to the form:
+{{ :howto:submitform.png }}
 ====== Notes for Admins ======
-<hidden>
 <WRAP prewrap>
@@ Line 167: / Line 175: @@
 ===== Updating the "ISED Data" Tab =====
-{{ :howto:ised_import.png}}
+{{ :howto:ised_import.png?350}}
   * Download [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |Amateur call sign list (delimited TXT format)]].
-  * Extract text file from zip file and change extension from: \\ ''.txt'' to ''.csv''
+  * Extract ''amateur_delim.txt''
   * In Google Sheets, unhide and select the ''ISED Data'' tab.
   * Go to ''File'' > ''Import'' > ''Upload'':
     * ''Replace Current Sheet''
-    * ''Custom:  ;''
+    * ''Custom''
+    * '';''
 </WRAP>
-</hidden>