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/05/09 17:42] – [Net Logging Spreadsheet] va7fi | howto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] va7fi | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~NOTOC~~ | + | ====== Net Roll Call Spreadsheet ====== |
- | ====== Net Logging Spreadsheet ====== | + | <WRAP center round alert> |
- | + | The Google Spreadsheet can only be edited by the owners. | |
- | <WRAP center round alert 60%> | + | |
- | Do not use the online version if someone is already using it. | + | |
</ | </ | ||
+ | |||
+ | ===== LibreOffice or Excel ===== | ||
+ | If you don't have LibreOffice or Excel on your computer, you'll want to install [[https:// | ||
+ | |||
+ | ===== Quick Demo ===== | ||
+ | For those who don't like to read instructions... | ||
+ | {{ netrollcall.gif | ||
+ | ===== Downloading The File ===== | ||
+ | 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 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 '' | ||
+ | |<100% 11em >| | ||
+ | ^Column(s) | ||
+ | |Column A | ||
+ | |Columns B -- M |✔ |Contains information about ham operators. | | ||
+ | |Columns E, G, I, K |✔ |Are dates that should be entered as so '' | ||
+ | |Columns N -- P | ||
- | The Data tab contains all the information about each ham operator and a few formulas to flag important dates. | + | {{ :howto:sheetfilter.png}} |
- | * Column A is hidden and contains formulas that the other tab needs. | + | |
- | * <wrap todo> | + | |
- | * Note that in Columns F, we've also added the callsign' | + | |
- | * Columns E, G, I, and K are dates that should be entered as so '' | + | |
- | * <wrap important> | + | |
To add a new entry, see the [[# | To add a new entry, see the [[# | ||
Line 31: | Line 58: | ||
==== Birthdays and Anniversaries ==== | ==== Birthdays and Anniversaries ==== | ||
- | + | To see who is having a birthday | |
- | One quick way of seeing if there are any birthdays | + | * 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 that have a date of " | + | This will show only the lines of people |
- | 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 '' |
- | * During | + | * When '' |
- | * 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 '' | + | |
- | * The message | + | |
- | * The message | + | |
- | * The other columns search for the callsign | + | |
- | * Cell P1 shows the total number of checkins | + | |
- | 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 73: | 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 # | ||
+ | \\ | ||
- | ===== Finding The File ===== | + | ===== Updating the "ISED Data" Tab ===== |
- | Currently, the file is not public. | + | {{ : |
+ | * Download | ||
+ | * Extract '' | ||
+ | * In Google Sheets, unhide and select the ''ISED Data'' | ||
+ | * Go to '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
- | + | </WRAP> | |
- | ===== Offline Use ===== | + | |
- | 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. | + | |
howto/netspreadsheet.1589071333.txt.gz · Last modified: 2020/05/09 17:42 by va7fi