howto:netspreadsheet
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
howto:netspreadsheet [2020/07/27 16:43] – va7fi | howto:netspreadsheet [2021/06/27 08:53] – [Notes for Admins] va7fi | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Net Roll Call Spreadsheet ====== | ||
+ | <WRAP center round alert> | ||
+ | The Google Spreadsheet can only be edited by the owners. | ||
+ | </ | ||
- | ====== Net Logging Spreadsheet ====== | + | ===== LibreOffice or Excel ===== |
+ | If you don't have LibreOffice or Excel on your computer, you'll want to install [[https:// | ||
- | <WRAP center round alert 60%> | ||
- | Please do not use the spreadsheet directly from the browser since only one person can do this at the same time. Instead, download the Excel or LibreOffice version for offline use instead. | ||
- | </ | ||
===== Downloading The File ===== | ===== Downloading The File ===== | ||
- | Currently, the file is not public. Members can access it from the [[memberscorner: | + | 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: | + | 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: | + | The date in the title of the file represents |
- | * I haven' | + | |
- | * If you need to update | + | |
- | * Discard and download a fresh copy every time you need it so as to always have the latest database. | + | |
- | * Please feel free to [[va7fi@rbox.me |contact me]] if you have any questions or comments. | + | |
Line 23: | Line 21: | ||
===== Basic Idea ===== | ===== Basic Idea ===== | ||
- | * The spreadsheet has a few tabs that can be selected at the bottom of the page: {{ : | + | The spreadsheet has a few tabs that can be selected at the bottom of the page: {{ : |
- | * '' | + | |
- | * '' | + | |
- | * '' | + | |
- | * '' | + | |
- | ===== The Data Tab ===== | + | |<100% 200px - >| |
+ | ^Local Data |contains the actual information about a few hundred hams in the Vancouver Island area.| | ||
+ | ^LogSheet (Local + ISED) |is the " | ||
+ | ^LogSheet (Local) |is a lighter version of the previous tab (for slower machines) that doesn' | ||
+ | ^LogSheet (ISED) |is a version that only searches the ISED database. | ||
+ | ^Instructions |links to this page.| | ||
+ | ^What' | ||
+ | ^ISED Data |is a hidden tab that contains over 80,000 entries from the [[http:// | ||
+ | |||
+ | |||
+ | <WRAP center round important 80%> | ||
+ | The most important thing to know is that <fc # | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== The Local Data Tab ===== | ||
{{ : | {{ : | ||
+ | {{: | ||
- | The '' | + | The '' |
|<100% 11em >| | |<100% 11em >| | ||
^Column(s) | ^Column(s) | ||
|Column A | |Column A | ||
|Columns B -- M |✔ |Contains information about ham operators. | | |Columns B -- M |✔ |Contains information about ham operators. | | ||
- | |Columns E, G, I, K |✔ |Are dates that should be entered as so '' | + | |Columns E, G, I, K |✔ |Are dates that should be entered as so '' |
- | |Columns N -- O |<fc # | + | |Columns N -- P |<fc # |
+ | |||
+ | {{ : | ||
To add a new entry, see the [[# | To add a new entry, see the [[# | ||
Line 44: | Line 56: | ||
==== Birthdays and Anniversaries ==== | ==== Birthdays and Anniversaries ==== | ||
- | {{ : | + | To see who is having a birthday or anniversary, |
- | One quick way of seeing if there are any birthdays or anniversaries before starting the net is to filter column N or O (but not both at the same time): | + | * Click on the upside-down triangle on the right of '' |
- | * Click on the upside-down triangle on the right '' | + | * Remove the check mark on the left of '' |
- | * Remove the check mark on the left of '' | + | |
* Press '' | * Press '' | ||
- | What this will do is only show the lines of people that have a birthday or anniversary on the day or week. All you have to do is note the names and callsign of these people to acknowledge them during the preamble. | + | 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, | + | Once you've got that information, |
- | ===== The LiveLogSheet Tab ===== | + | |
+ | ===== The LogSheet Tabs ===== | ||
+ | {{: | ||
+ | |||
+ | The three '' | ||
+ | * '' | ||
+ | * This is the tab that most people will use for nets in the Vancouver Island area. | ||
+ | * It searches both the '' | ||
+ | * It requires only the suffix of the callsign if the entry in the '' | ||
+ | * '' | ||
+ | * It's very similar to the previous tab except it only searches the '' | ||
+ | * '' | ||
+ | * Searches only the '' | ||
+ | * Useful for trans Canada wide nets. | ||
+ | * The full callsign must be used. | ||
+ | |||
+ | Using '' | ||
{{ : | {{ : | ||
- | The LiveLogSheet tab is really | + | * In the first example '' |
- | * Column B can be left blank unless there are two callsigns | + | * When '' |
- | * Column C will either give you: | + | * When '' |
- | * The callsign if a match is found in the '' | + | * When '' |
- | * The message | + | |
- | * The message | + | |
- | * The other columns search for the callsign | + | |
- | * Cell P1 shows the total number of checkins | + | |
- | * The top shows the number of Birthdays and Anniversaries in blue for reference. | + | |
- | When the net is done, simply delete what you typed in column A and B (<fc # | + | Here are a few more details: |
+ | * The cells in orange <fc # | ||
+ | * Information from the '' | ||
+ | * Cell E1 shows the total number of unique 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 # | ||
+ | |||
+ | A useful trick in LibreOffice is to freeze the first two rows so that as you go down the list, the header is always visible. | ||
+ | {{ : | ||
+ | |||
+ | |||
+ | ** Note that I made up Richard' | ||
+ | |||
+ | |||
+ | ===== Android Tablets/ | ||
+ | The spreadsheet was made to be used offline on computers, but some people might still want to use it on their tablets. | ||
+ | |||
+ | The first steps are to open the spreadsheet and make a copy of it to your " | ||
+ | |||
+ | * Open the link in the mobile browser. | ||
+ | * Click on '' | ||
+ | * Click on the three dots on the top right corner. | ||
+ | |||
+ | <WRAP centeralign> | ||
+ | {{: | ||
+ | </ | ||
+ | |||
+ | * Click on '' | ||
+ | * Add the word " | ||
+ | |||
+ | <WRAP centeralign> | ||
+ | {{: | ||
+ | </ | ||
+ | |||
+ | * You are now using your copy, which you can edit. | ||
+ | * At the bottom, select '' | ||
+ | * 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> | ||
+ | {{: | ||
+ | </ | ||
+ | |||
+ | * 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. | ||
+ | |||
+ | |||
+ | ====== Submit Updates ====== | ||
+ | To submit an update to the main online spreadsheet, | ||
+ | {{ : | ||
+ | |||
+ | Which will take you to the form: | ||
+ | {{ : | ||
+ | |||
+ | |||
+ | |||
+ | ====== Notes for Admins ====== | ||
+ | <WRAP prewrap> | ||
===== Adding Names ===== | ===== Adding Names ===== | ||
- | To add a new name to the '' | + | To add a new name to the '' |
+ | - Edit the Google spreadsheet directly in the browser (<fc # | ||
+ | - Scroll down and use one of the empty lines below the current list. It doesn' | ||
+ | |||
+ | <WRAP center round alert 90%> | ||
+ | Do not Insert | ||
+ | </ | ||
- | Instead, scroll down and use one of the empty lines below the current list. It doesn' | ||
{{ : | {{ : | ||
Line 81: | Line 166: | ||
All the entries are now sorted by callsign suffix: | All the entries are now sorted by callsign suffix: | ||
{{ : | {{ : | ||
+ | \\ | ||
===== Deleting Names ===== | ===== Deleting Names ===== | ||
To delete a name, do <fc # | To delete a name, do <fc # | ||
+ | \\ | ||
+ | ===== Updating the "ISED Data" Tab ===== | ||
+ | {{ : | ||
+ | * Download [[http:// | ||
+ | * Extract '' | ||
+ | * In Google Sheets, unhide and select the '' | ||
+ | * Go to '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
+ | |||
+ | </ | ||
howto/netspreadsheet.txt · Last modified: 2021/08/09 09:28 by va7fi