Differences

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

--- howto:netspreadsheet [2020/04/25 13:45] – [Basic Idea] va7fi
+++ howto:netspreadsheet [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-~~NOTOC~~
-====== Net Logging Spreadsheet ======
-<WRAP center round alert 60%>
-Do not use the online version is someone if already using it.  You'll be interfering with them. Download the Excel or LibreOffice version for [[#offline_use |offline use]] instead.
-</WRAP>
-===== Basic Idea =====
-  * This is a Google spreadsheet that can be used directly in the browser or downloaded as an Excel or LibreOffice file for offline use.
-  * The sheet has two 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.
-===== The Data Tab =====
-{{  :howto:datatab.png  }}
-The Data tab contains all the 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 "database":
-  * Column A is hidden and contains formulas that the other tab needs.
-  * <wrap todo>Columns B -- M can be edited directly</wrap> (that's why the cells are in green).
-  * Note that in Columns F, we've also added the callsign's suffix when a spouse is also a ham operator (ex.: "Jaqueline **JET**").  This makes logging spouses easier.
-  * Columns E, G, I, and K are dates that should be entered as so '' <wrap mark hi>'</wrap>JAN 1''.  <wrap tip>Note the apostrophe (') at the beginning to force the proper formatting.</wrap>
-  * <wrap important>Column N contains a formulas and should NOT be edited</wrap>.
-To add a new entry, see the [[#adding_names |Adding Names]] section below.
-==== Birthdays and Anniversaries ====
-One quick way of seeing if there are any birthdays or anniversaries before starting the net is to filter column N: {{  :howto:sheetfilter.png?200}}
-  * Click on the upside-down triangle on the right ''Today?'' in Column N.
-  * Remove the check mark on the left of ''(blank)''
-  * Press ''OK''
-What this will do is only show the lines that have a date of "today" written anywhere in the data sheet.  All you have to do is 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 ''(blank)'' 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. VA7DUO and VE7DUO).  If that's the case, Column C will ask you to add the prefix in Column B.  Most of the time, the prefix is not needed.
-  * Column C will either give you:
-    * The callsign if a match is found in the ''Data'' tab.
-    * The message ''Not Found'' if the suffix was not found in the ''Data'' tab.  If that's the case, ask the operator to give you their information, make a note, and enter it in the ''Data'' tab at the end of the net for next time.
-    * The message ''Prefix?'' if there are multiple callsigns with the same suffix.  So far, VA7DUO and VE7DUO are the only two callsigns with the same suffix.
-  * The other columns search for the callsign in Column C and fill in the rest of the information.  These columns <fc #ff0000>should NOT be edited.</fc>
-  * Cell P1 shows the total number of checkins
-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>)
-===== Adding Names =====
-To add a new name to the ''Data'' sheet, do <fc #ff0000>not Insert</fc> 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.
-Instead, 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 397, 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.
-{{ :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 <wrap warning>not Delete Row<wrap>.  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.
-===== Finding The File =====
-Currently, the file is not public.  Members can access it from the [[memberscorner:home#google_drive|Member's section]], otherwise, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access.
-===== Offline Use =====
-To use offline, you can download as a Microsoft Excel file or as an OpenDocument File:
-{{  :howto:download.png  }}
-I haven't tested the Excel version as I don't have Microsoft Office, but using the Free and Open Source office suite [[https://www.libreoffice.org/ |LibreOffice]] works.  The only thing that doesn't (I'm not sure why) is checking for [[#birthdays_and_anniversaries |birthdays]].  So I do that on the online version before starting the net.