Today is Sunday, 2019-05-26
File → Download As…
Datacontains all the actual information.
LiveLogSheetis the “search / login” page.
The Data tab contains all the information about each ham operator and a few formulas to flag important dates. This sheet is NOT the sheet you'll be using during the net, it's a “database”:
'JAN 1. Note the apostrophe (') at the beginning to force the proper formatting.
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.
Today?in Column N.
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 is really the meat of this spreadsheet.
Not Foundif 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.
Prefix?if there are multiple callsigns with the same suffix.
When the net is done, simply delete what you typed in column A and B (NOT what appeared in the other columns)
To add a new name to the Data sheet, 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 line that's newly created.
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 301, 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.
To delete a name, do not Delete Row. Instead delete the blue 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.