howto:netspreadsheet
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
howto:netspreadsheet [2020/07/27 16:18] – [Net Logging Spreadsheet] va7fi | howto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] 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%> | + | ===== Quick Demo ===== |
- | Please do not use the spreadsheet directly from the browser since only one person can do this at the same time. | + | For those who don't like to read instructions... |
- | </ | + | {{ netrollcall.gif |
+ | ===== Downloading The File ===== | ||
+ | Currently, the file is not public, contact | ||
+ | |||
+ | 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. | ||
+ | {{ : | ||
+ | |||
+ | The date in the title of the file represents the last time the spreadsheet was updated. | ||
Line 11: | Line 23: | ||
===== Basic Idea ===== | ===== Basic Idea ===== | ||
- | * This is a Google | + | The spreadsheet |
- | * The sheet has two tabs that can be selected at the bottom of the page: {{ : | + | |<100% 200px - >| |
- | * '' | + | ^Local |
- | * '' | + | ^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:// | ||
- | ===== The Data Tab ===== | + | |
+ | <WRAP center round important 80%> | ||
+ | The most important thing to know is that <fc # | ||
+ | </ | ||
+ | |||
+ | |||
+ | ===== The Local Data Tab ===== | ||
{{ : | {{ : | ||
+ | {{: | ||
- | The Data tab contains | + | 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. | | ||
- | |Column F |✔ |Contains the callsign' | + | |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 -- P |<fc # |
- | |Columns N -- O |<fc # | + | |
+ | {{ : | ||
To add a new entry, see the [[# | To add a new entry, see the [[# | ||
Line 33: | Line 58: | ||
==== 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 | + | Here are a few more details: |
- | * The other columns search for the callsign in Column C and fill in the rest of the information. These columns | + | |
- | * Cell P1 shows the total number of checkins | + | * The cells in orange <fc # |
- | * The top shows the number of Birthdays and Anniversaries | + | * 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> | ||
+ | {{: | ||
+ | </ | ||
+ | |||
+ | | ||
+ | * Add the word " | ||
+ | |||
+ | <WRAP centeralign> | ||
+ | {{: | ||
+ | </ | ||
+ | |||
+ | * You are now using your copy, which you can edit. | ||
+ | * At the bottom, select '' | ||
+ | | ||
+ | | ||
+ | * The one on the right is your own personal copy. | ||
+ | <WRAP centeralign> | ||
+ | {{: | ||
+ | </WRAP> | ||
+ | |||
+ | * 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 | ||
+ | |||
+ | |||
+ | ====== Submit Updates ====== | ||
+ | To submit an update to the main online spreadsheet, | ||
+ | {{ : | ||
+ | |||
+ | Which will take you to the form: | ||
+ | {{ : | ||
- | When the net is done, simply delete what you typed in column A and B (<fc # | ||
+ | ====== 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 70: | Line 168: | ||
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 '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
- | ===== Offline Use ===== | + | </WRAP> |
- | This tool is gaining popularity amongst different clubs in the area, as such, we now recommend that you use the file offline if you can to avoid two people trying to use the online version at the same time. You can download it as a Microsoft Excel file or as an OpenDocument File: | + | |
- | {{ : | + | |
- | + | ||
- | A few things to keep in mind: | + | |
- | * I haven' | + | |
- | * If you need to update the Data sheet, please update the **Online** version, not your local offline version. | + | |
- | * 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. | + | |
- | + | ||
- | + | ||
- | ===== Finding The File ===== | + | |
- | Currently, the file is not public. | + | |
howto/netspreadsheet.1595891939.txt.gz · Last modified: 2020/07/27 16:18 by va7fi