howto:netspreadsheet
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
howto:netspreadsheet [2019/04/07 18:41] – [Basic Idea] ve7hzf | howto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] va7fi | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ~~NOTOC~~ | + | ====== Net Roll Call Spreadsheet ====== |
+ | |||
+ | <WRAP center round alert> | ||
+ | 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:// | ||
+ | |||
+ | ===== 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. | ||
- | ====== Net Logging Spreadsheet ====== | ||
===== Basic Idea ===== | ===== Basic Idea ===== | ||
- | * This is a spreadsheet that can be used directly in the browser or downloaded as an Excel or OpenOffice file for offline use: '' | + | 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 '' |
- | * Columns | + | |<100% 11em >| |
- | * Note that in Columns | + | ^Column(s) |
- | | + | |Column |
- | * Column M contains a formula that extracts dates from any of the data entered and columns A -- L. This column | + | |Columns |
+ | |Columns | ||
+ | |Columns N -- P |<fc #ff0000>✘</ | ||
- | To add a new entry, simply write as much of this information as possible at the end of the list. It's very easy to re-sort it later. | + | {{ : |
- | ==== Birthdays and Anniversaries ==== | + | To add a new entry, see the [[# |
- | One quick way of seeing if there are any birthdays or anniversaries before starting the net is to filter column | + | |
- | * Click on the <fc #4682b4>upside-down triangle</ | + | ==== Birthdays and Anniversaries ==== |
- | * Remove the check mark on the left of '' | + | To see who is having a birthday or anniversary, |
+ | * Click on the upside-down triangle on the right 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 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 '' | ||
+ | {{ : | ||
+ | |||
+ | * In the first example '' | ||
+ | * When '' | ||
+ | * When '' | ||
+ | * When '' | ||
+ | |||
+ | 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 ===== | ||
+ | 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 a line somewhere in the middle of the sheet to keep names sorted by callsigns. | ||
+ | </ | ||
+ | |||
+ | {{ : | ||
+ | |||
+ | Now to sort, click on the upside-down triangle sign on the right of '' | ||
+ | {{ : | ||
+ | |||
+ | All the entries are now sorted by callsign suffix: | ||
+ | {{ : | ||
\\ | \\ | ||
- | \\ | + | |
- | \\ | + | ===== Deleting Names ===== |
- | \\ | + | To delete a name, do <fc # |
- | \\ | + | |
\\ | \\ | ||
- | ===== The LiveLogSheet | + | ===== Updating the "ISED Data" |
- | {{ :howto:livelogsheet.png }} | + | {{ :howto:ised_import.png?350}} |
+ | * Download [[http:// | ||
+ | * Extract '' | ||
+ | * In Google Sheets, unhide and select the '' | ||
+ | * Go to '' | ||
+ | * '' | ||
+ | * '' | ||
+ | * '';'' | ||
- | The LiveLogSheet tab is really the meat of this spreadsheet. | + | </WRAP> |
- | * Column A is used to type in the suffix (UPPER or lower case doesn' | + | |
- | * The other columns search for this suffix and fill in the rest of the information. | + | |
- | * Cell O1 shows the total number of checkins | + | |
- | When the net is done, simply delete what you typed in column A (<fc # | ||
howto/netspreadsheet.1554687668.txt.gz · Last modified: 2019/04/07 18:41 by ve7hzf