Differences

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

--- howto:netspreadsheet [2019/04/10 10:27] – [The LiveLogSheet Tab] ve7hzf
+++ howto:netspreadsheet [Unknown date] (current) – removed - external edit (Unknown date) 127.0.0.1
@@ Line 1: / Line 1: @@
-~~NOTOC~~
-====== Net Logging Spreadsheet ======
-===== Basic Idea =====
-  * This is a spreadsheet that can be used directly in the browser or downloaded as an Excel or OpenOffice file for offline use:  ''File -> Download As...''
-  * The sheet has two tabs that can be selected at the bottom of the page: {{ :howto:tabs.png }}
-    * ''Data'' contains all the actual information.
-    * ''LiveLogSheet'' is the "search / login" page.
-===== 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.
-  * Columns B -- M can be edited directly (that's why they're <fc #008000>highlighted in green</fc>)
-  * 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 '' 'JAN 1 ''.  Note the apostrophe (') at the beginning to force the proper formatting.
-  * Column N contains a formula that extracts dates from any of the data entered and columns B -- M.  This column <fc #ff0000>should NOT be edited</fc>.
-To add a new entry, simply write as much of this information as possible at the end of the list.  It's very easy to re-sort it later.
-==== 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.
-  * Column A is used to type in the suffix (UPPER or lower case doesn't make a difference).
-  * 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 to enter the prefix.
-  * Column C will either give you:
-    * The callsign if it found a match
-    * 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.
-    * The message ''Prefix?'' if there are multiple 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>)