howto:netspreadsheet
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
howto:netspreadsheet [2020/09/07 15:35] – va7fi | howto:netspreadsheet [2021/04/06 08:50] – [Notes for Admins] va7fi | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | + | ====== Net Roll Call Spreadsheet ====== | |
- | + | ||
- | ====== Net Logging | + | |
<WRAP center round alert> | <WRAP center round alert> | ||
- | The spreadsheet cannot | + | The Google Spreadsheet can only be edited by the owners. |
</ | </ | ||
+ | |||
+ | ===== LibreOffice or Excel ===== | ||
+ | If you don't have LibreOffice or Excel on your computer, you'll want to install [[https:// | ||
Line 11: | Line 12: | ||
Currently, the file is not public, contact [[va7fi@rbox.me |Patrick, VA7FI]] if you'd like access. | 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 the last time the spreadsheet was updated. |
- | * If you notice an error or omission, please email [[va7fi@rbox.me |Patrick, VA7FI]]. | + | |
- | * Discard and download a fresh copy every time you need it so as to always have the latest database. | + | |
Line 22: | 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: {{ : |
- | * '' | + | |
- | * '' | + | |<100% 200px - >| |
- | * '' | + | ^Local |
- | * ''ISED'' | + | ^LogSheet (Local + ISED) |is the " |
+ | ^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. | ||
+ | ^Instructions | ||
+ | ^What's New |lists the recent updates to the spreadsheet (excluding edits to the "Local Data" sheet). | | ||
+ | ^ISED Data |is a hidden tab that contains over 80,000 entries from the [[http:// | ||
<WRAP center round important 80%> | <WRAP center round important 80%> | ||
- | The most important thing is that <fc # | + | The most important thing to know is that <fc # |
</ | </ | ||
- | ===== The Data Tab ===== | + | ===== 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 60: | Line 66: | ||
- | ===== 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 from 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 # | ||
+ | |||
+ | 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. | ||
+ | {{ : | ||
- | When the net is done, simply delete what you typed in column A and B (<fc # | ||
- | Note that I made up Richard' | + | ** Note that I made up Richard' |
Line 87: | Line 115: | ||
<WRAP centeralign> | <WRAP centeralign> | ||
- | {{: | + | {{: |
</ | </ | ||
+ | * Click on '' | ||
+ | * Add the word " | ||
<WRAP centeralign> | <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> | <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 117: | 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 text file from zip file and change extension from: \\ '' | ||
+ | * In Google Sheets, unhide and select the '' | ||
+ | * Go to '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
+ | |||
+ | </ | ||
+ | |||
- | */ |
howto/netspreadsheet.txt · Last modified: 2021/08/09 09:28 by va7fi