This is an old revision of the document!
Table of Contents
Net Roll Call Spreadsheet
The Google Spreadsheet can only be edited by the owners, everyone else needs to download the Excel or LibreOffice version for offline use.
LibreOffice or Excel
If you don't have LibreOffice or Excel on your computer, you'll want to install LibreOffice first, which is a free and open source office suite.
Downloading The File
Currently, the file is not public, contact Patrick, VA7FI if you'd like access.
Once you have the link, you can download it as a Microsoft Excel file or OpenDocument File. Download the latter format if you use LibreOffice.
A few things to keep in mind:
- If you notice anything that needs to be updated, please email Patrick, VA7FI. That way, other users will benefit from your report.
- Download a fresh copy periodically 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:
Local Data
contains the actual information about a few hundred hams in the Vancouver Island area.LogSheet (Local + ISED)
is the “search / log” page used during the net.LogSheet (Local)
is a lighter version of the previous tab (for slower machines) that doesn't use ISED database.LogSheet (ISED)
is a version that only searches the ISED database. This could be useful for cross Canada nets.Instructions
links to this page.ISED Data
is a hidden tab that contains over 80,000 entries from the ISED website. The last update uses data from Sept 21, 2020.
Local Data | contains the actual information about a few hundred hams in the Vancouver Island area. |
---|---|
LogSheet (Local + ISED) | is the “search / log” page used during the net. |
LogSheet (Local) | is a lighter version of the previous tab (for slower machines) that doesn't use ISED database. |
LogSheet (ISED) | is a version that only searches the ISED database. This could be useful for cross Canada nets. |
Instructions | links to this page. |
ISED Data | is a hidden tab that contains over 80,000 entries from the ISED website. The last update uses data from Sept 21, 2020. |
The most important thing is that you can type in and delete cells in green, but you should not edit or delete cells in orange.
The Local Data Tab
The Local Data
tab contains 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 sort of “database”:
Column(s) | Edit | Details |
---|---|---|
Column A | ✘ | 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 .1) |
Columns N ‒ P | ✘ | Contains formulas and should NOT be edited. |
To add a new entry, see the 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 orThis 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 LogSheet Tabs
The three LogSheet (x)
tabs are different ways of searching / logging checkins. The main differences between them are:
Logsheet (Local + ISED)
:- This is the tab that most people will use for nets in the Vancouver Island area.
- It searches both the
Local Data
and theISED Data
. - It requires only the suffix of the callsign if the entry in the
Local Data
tab is unique.
Logsheet (Local)
:- It's very similar to the previous tab except it only searches the
Local Data
so it's faster for slower computers or mobile devices.
Logsheet (ISED)
:- Searches only the
ISED Data
. - Useful for trans Canada wide nets.
- The full callsign must be used.
Using Logsheet (Local + ISED)
as an example, during the net, all you need to do is type the suffix in Column A (not case sensitive).
- In the first example
aa
was entered twice successfully. The second entry was flagged as a duplicate and was not counted in the total checkins at the top in cell E1. - When
jh
was entered in the suffix, the callsign asked for aPrefix?
because two callsigns have the same suffix. Once the prefix is entered, the spreadsheet is able to fill in the rest of the information from theLocal Data
. - When
aaa
is entered, it's not found in theLocal Data
so it asks for thePrefix
to look it up in theISED Data
. - When
wek
is entered, it's not found in either databases so it returnsNot Found
. If you know that this is a valid callsign (maybe a new ham), please email Patrick so he can update theLocal Data
.
Here are a few more details:
- The cells in orange should NOT be edited or deleted.
- Information from the
ISED
tab will have “(ISED)” written in the cells (ex. VE7AAA) - Cell E1 shows the total number of unique checkins.
- The top shows the number of Birthdays and Anniversaries, which are also flagged in column O.
When the net is done, simply delete what you typed in column A and B (NOT what appeared in the other columns)
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.
- Click on
Make a copy
. - Add the word “Copy” to the end of the name to distinguish it from the original.
- You are now using your copy, which you can edit.
- At the bottom, select
LogSheet (Local)
, which doesn't query theISED
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.
- 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 Patrick, VA7FI the information that needs to be added / edited in the online version.