Differences

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

--- howto:netspreadsheet [2020/09/22 07:58] – va7fi
+++ howto:netspreadsheet [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Net Logging Spreadsheet ======
-<WRAP center round alert>
-The spreadsheet cannot be used directly from the browser anymore. To use it, download the Excel or LibreOffice version for offline use.
-</WRAP>
-===== Downloading The File =====
-Currently, the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
-Once you have the link, you can download it as a Microsoft Excel file or as an OpenDocument File:
-{{  :howto:download.png  }}
-A few things to keep in mind:
-  * If you notice an error or omission, please email [[va7fi@rbox.me |Patrick, VA7FI]].  That way, other users will benefit from your updates.
-  * Discard and download a fresh copy every time you need it so as to always have the latest database.
-===== Basic Idea =====
-  * The spreadsheet has a few tabs that can be selected at the bottom of the page: {{ :howto:tabs.png }}
-    * ''Data'' contains the actual information about a few hundreds of hams.
-    * ''LiveLogSheet'' is the "search / log" page used during the net.
-    * ''LiveLogSheet (lite)'' is a lighter version of the previous tab (for slower machines) that doesn't use ISED information.
-    * ''Instructions'' links to this page and lists a few changes I've made.
-    * ''ISED'' is a hidden tab that contains over 80,000 entries from the [[http://www.ic.gc.ca/eic/site/025.nsf/eng/h_00004.html |ISED]] website.  The last update uses data from Sept 6, 2020.
-<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>.
-</WRAP>
-===== The Data Tab =====
-{{  :howto:datatab.png  }}
-The ''Data'' tab contains information about each ham operator and a few formulas to flag important dates.  This sheet is <fc #ff0000>NOT</fc> the sheet you'll be using during the net, it's a sort of "database":
-|<100% 11em >|
-^Column(s)          ^Edit ^Details ^
-|Column A           |<fc #ff0000>✘</fc> |Is hidden and contains formulas that the other tab needs. |
-|Columns B -- M     |✔ |Contains information about ham operators. |
-|Columns E, G, I, K |✔ |Are dates that should be entered as so '' 'JAN 1''.((Dates must be formatted with three letters and be preceded by an apostrophe (') to force the proper formatting.)) |
-|Columns N -- P     |<fc #ff0000>✘</fc> |Contains formulas and should NOT be edited. |
-{{  :howto:sheetfilter.png}}
-To add a new entry, see the [[#adding_names |Adding Names]] section below.
-==== Birthdays and Anniversaries ====
-To see who is having a birthday or anniversary, filter column N or O (but not both at the same time):
-  * Click on the upside-down triangle on the right of ''Today?'' in Column N or ''This Week?'' in Column O.
-  * Remove the check mark on the left of ''(empty)''. \\ Under Microsoft Excel, it's called ''(Blanks)''.
-  * Press ''OK''
-This will show only the lines of people that have a birthday or anniversary on the day or week. Note the names and callsign of these people to acknowledge them during the preamble.
-Once you've got that information, you can re-check the ''(empty)'' lines to unhide them.
-===== The LiveLogSheet Tab =====
-{{  :howto:livelogsheet.png  }}
-The ''LiveLogSheet'' tab is really the meat of this spreadsheet.  During the net, all you need to do is type the suffix in Column A (**not** case sensitive).
-  * Column B can be left blank unless there are two callsigns with the same suffix (ex. VA7JH and VE7JH), or if the suffix is not in the ''Data'' tab at all (ex. "AAA").  If that's the case, Column C will ask you to add the prefix in Column B.
-  * Once Column C has the full callsign, it'll look up the information in the ''Data'' tab, and if not found there, it'll look in the ''ISED'' tab.
-  * Information from the ''ISED'' tab will have "(ISED)" written in the cells (ex. VE7AAA)
-  * If the callsign doesn't exist (ex. VE7WEK), the cells will be left blank.
-  * The cells in orange <fc #ff0000>should NOT be edited or deleted.</fc>
-  * Cell D1 shows the total number of checkins.
-  * The top shows the number of Birthdays and Anniversaries.
-When the net is done, simply delete what you typed in column A and B (<fc #ff0000>NOT what appeared in the other columns</fc>)
-Note that I made up Richard's (VA7AA) birthday for the sake of illustration.
-===== 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>
-{{:howto:mobile_01.jpg?300}} {{:howto: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>
-{{:howto:mobile_03.jpg?300}} {{:howto:mobile_04.jpg?300}}
-</WRAP>
-  * You are now using your copy, which you can edit.
-  * At the bottom, select ''LiveLogSheet (lite)'', 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>
-{{:howto:mobile_05.jpg?300}} {{:howto: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 [[va7fi@rbox.me |Patrick, VA7FI]] the information that needs to be added / edited in the online version.
-====== Notes for Admins ======
-<hidden>
-===== Adding Names =====
-To add a new name to the ''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>
-{{ :howto: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'':
-{{ :howto:filter.png  }}
-All the entries are now sorted by callsign suffix:
-{{  :howto: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.
-</hidden>