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/11/11 08:51] – va7fi | howto:netspreadsheet [2021/08/09 09:28] (current) – [LibreOffice or Excel] va7fi | ||
---|---|---|---|
Line 2: | Line 2: | ||
<WRAP center round alert> | <WRAP center round alert> | ||
- | The Google Spreadsheet can only be edited by the owners, everyone | + | The Google Spreadsheet can only be edited by the owners. Everyone |
</ | </ | ||
Line 8: | Line 8: | ||
If you don't have LibreOffice or Excel on your computer, you'll want to install [[https:// | 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 ===== | ===== Downloading The File ===== | ||
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. | ||
Line 15: | Line 17: | ||
{{ : | {{ : | ||
- | 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 anything that needs to be updated, please email [[va7fi@rbox.me |Patrick, VA7FI]]. | + | |
- | * Download | + | |
Line 32: | Line 32: | ||
^Instructions |links to this page.| | ^Instructions |links to this page.| | ||
^What' | ^What' | ||
- | ^ISED Data |is a hidden tab that contains over 80,000 entries from the [[http:// | + | ^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 # |
</ | </ | ||
Line 49: | Line 49: | ||
|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 89: | Line 89: | ||
* When '' | * When '' | ||
* When '' | * When '' | ||
- | * When '' | + | * When '' |
Here are a few more details: | Here are a few more details: | ||
Line 138: | Line 138: | ||
* 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. | * 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. | * 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 ====== | ====== Notes for Admins ====== | ||
- | < | ||
<WRAP prewrap> | <WRAP prewrap> | ||
Line 167: | Line 175: | ||
===== Updating the "ISED Data" Tab ===== | ===== Updating the "ISED Data" Tab ===== | ||
- | {{ : | + | {{ : |
* Download [[http:// | * Download [[http:// | ||
- | * Extract | + | * Extract '' |
* In Google Sheets, unhide and select the '' | * In Google Sheets, unhide and select the '' | ||
* Go to '' | * Go to '' | ||
* '' | * '' | ||
- | * '' | + | * '' |
+ | * '' | ||
</ | </ | ||
- | </ | + | |
howto/netspreadsheet.1605113478.txt.gz · Last modified: 2020/11/11 08:51 by va7fi