Differences

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

--- links:netspreadsheet [2024/11/24 13:20] – va7fi
+++ links:netspreadsheet [2026/08/27 14:51] (current) – [How to Setup] va7fi
@@ Line 1: / Line 1: @@
+====== Net Roll Call Spreadsheet ======
+===== How to Setup =====
+Here's an overview of how to download and setup your local copy the first time:
+  - Download the Google Sheet: ''File -> Download -> OpenDocument (.ods)''.  It might take 30-45 seconds to prepare the download; this is normal.  Note that the file is not public, contact [[[email protected] |Patrick, VA7FI]] if you'd like access.
+  - Make sure you have [[https://www.libreoffice.org |LibreOffice]] installed on your computer.
+  - Open the downloaded file, freeze the headers, and save the file.
+===== How to Use  =====
+Here's an overview of how to use the sheet for a net:
+  - Open the file you saved.
+  - Type the suffix in column A, and the prefix in column B if needed.
+  - <wrap important> Don't type or delete anything in the orange cells as they contain formulas.</wrap>
+  - When you're done, close the file but do **not** save it.  That way all the callsigns you typed won't be there next time you use it.
+  - Again, <wrap important> Don't type or delete anything in the orange cells.</wrap>
+  - If you break the sheet by deleting formulas, you can simply download a fresh copy and start from scratch.
+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.
+===== Demo =====
+{{ youtube>h5_Yo0A2iGw }}
+----
+====== Optional Information: ======
+===== Android Tablets/Phones =====
+The spreadsheet was made to be used offline on computers, but some people might still want to use it on their tablets.  Here as some instructions on how to do that for Android devices.
+The first steps are to open the spreadsheet and make a copy of it to your "Sheets" app.  You will need a Google Account to do this:
+  * Open the link in the mobile browser.
+  * Click on ''USE THE APP'' (you need "Sheets" installed).
+  * Click on the three dots on the top right corner.
+<WRAP centeralign>
+{{:links:mobile_01.jpg?300}} {{:links:mobile_02.jpg?300}}
+</WRAP>
+  * Click on ''Make a copy''.
+  * Add the word "Copy" to the end of the name to distinguish it from the original.
+<WRAP centeralign>
+{{:links:mobile_03.jpg?300}} {{:links:mobile_04.jpg?300}}
+</WRAP>
+  * You are now using your copy, which you can edit.
+  * At the bottom, select ''LogSheet (Local)'', which doesn't query the ''ISED'' tab and is quicker for mobile devices.
+  * In your Sheets app, you should now see two versions:
+    * The one on the left with the little shared symbol is the original which you can't edit.
+    * The one on the right is your own personal copy.
+<WRAP centeralign>
+{{:links:mobile_05.jpg?300}} {{:links:mobile_06.jpg?300}}
+</WRAP>
+  * 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 [[[email protected] |Patrick, VA7FI]] the information that needs to be added / edited in the online version.
+====== Notes for Admins ======
+<WRAP prewrap>
+===== Adding Names =====
+To add a new name to the ''Local Data'' sheet:
+  - Edit the Google spreadsheet directly in the browser (<fc #ff0000>not your downloaded copy</fc>).  That way everyone will benefit from your updates next time they download a fresh copy.
+  - Scroll down and use one of the empty lines below the current list.  It doesn't have to be the very next line.  For example, as of this writing, the last entry is in line 462, but you could use line 479.  It really doesn't matter.  All these empty lines at the bottom of the list have the formulas in Column A and N already pre-fielded.
+<WRAP center round alert 90%>
+Do not Insert a line somewhere in the middle of the sheet to keep names sorted by callsigns.  The problem with doing this is that Column A (which is hidden) and Column N contain important formulas and inserting a line leaves those cells blank for the new line.
+</WRAP>
+{{ :links:unsorted.png  }}
+Now to sort, click on the upside-down triangle sign on the right of ''Suffix'' to see the filter menu for that column, and select ''Sort A -> Z'':
+{{ :links:filter.png  }}
+All the entries are now sorted by callsign suffix:
+{{  :links:sorted.png  }}
+\\
+===== Deleting Names =====
+To delete a name, do <fc #ff0000>not Delete</fc> Row.  Instead delete the green cells containing the information. Careful not to delete anything in the red cells in columns A and N which contain the formulas.  Then resort the list to send the empty line back to the bottom.
+\\
+===== Updating the "ISED Data" Tab =====
+{{ :links: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)]].((Instead of manually downloading the file from the ISED website, and unzipping it, I use this short BASH script:<code BASH>
+#!/bin/bash
+DIR="/home/ptruchon/Desktop"
+wget --report-speed=bits http://apc-cap.ic.gc.ca/datafiles/amateur_delim.zip -P $DIR
+cd $DIR
+unzip amateur_delim.zip
+mv amateur_delim.txt amateur_delim.csv
+chmod 644 amateur_delim.csv
+rm amateur_delim.zip lisezmoi_amat_delim.txt readme_amat_delim.txt
+</code>))
+  * Extract ''amateur_delim.txt''
+  * In Google Sheets, unhide and select the ''ISED Data'' tab.
+  * Go to ''File'' > ''Import'' > ''Upload'':
+    * ''Replace Current Sheet''
+    * ''Custom''
+    * '';''