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/29 07:45] – [Downloading The File] 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 -- P | |Columns N -- P | ||
Line 48: | Line 58: | ||
To see who is having a birthday or anniversary, | To see who is having a birthday or anniversary, | ||
* Click on the upside-down triangle on the right of '' | * Click on the upside-down triangle on the right of '' | ||
- | * Remove the check mark on the left of '' | + | * Remove the check mark on the left of '' |
* Press '' | * Press '' | ||
Line 55: | Line 65: | ||
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 '' | + | * In the first example |
- | * Column B can be left blank unless there are two callsigns | + | * When '' |
- | * Once Column C has the full callsign, it'll look up the information | + | * When '' |
- | * Information for the '' | + | * When '' |
- | * If the callsign doesn't exist (ex. VE7WEK), the cells will be left blank. | + | |
+ | Here are a few more details: | ||
* The cells in orange <fc # | * The cells in orange <fc # | ||
- | * Cell D1 shows the total number of checkins. | + | |
- | * The top shows the number of Birthdays and Anniversaries. | + | |
+ | * 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 (<fc # | + | When the net is done, simply delete what you typed in column A and B (<fc # |
- | Note that I made up Richard' | + | 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 # | - Edit the Google spreadsheet directly in the browser (<fc # | ||
- Scroll down and use one of the empty lines below the current list. It doesn' | - Scroll down and use one of the empty lines below the current list. It doesn' | ||
Line 87: | 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