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/08/11 09:21] – [Basic Idea] 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 | |
- | <WRAP center round alert 65%> | + | |
- | Please do not use the spreadsheet directly from the browser since only one person can do this at the same time and it increases the risk of breaking the spreadsheet for everybody. | + | |
- | </WRAP> | + | |
+ | ===== Quick Demo ===== | ||
+ | For those who don't like to read instructions... | ||
+ | {{ netrollcall.gif | ||
===== 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 23: | ||
===== 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 53: | Line 60: | ||
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 60: | Line 67: | ||
Once you've got that information, | Once you've got that information, | ||
- | f===== 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 # | ||
+ | |||
+ | 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: | ||
+ | {{ : | ||
- | When the net is done, simply delete what you typed in column A and B (<fc # | ||
- | Note that I made up Richard' | + | ====== 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 92: | 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 '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
+ | |||
+ | </ | ||
howto/netspreadsheet.1597162879.txt.gz · Last modified: 2020/08/11 09:21 by va7fi