Differences

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

--- howto:netspreadsheet [2021/01/10 14:00] – [The LogSheet Tabs] 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 136: / 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 165: / 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>