aka what i did to get from nothing to done.
note: these are designed to be primarily a re-install guide for myself (writing things down helps me memorize the knowledge), as such don't take any of this on blind faith - some areas are well tested and the docs are very robust, some items, less so). YMMV
| # after the virtual disk has already been expanded (e.g. in proxmox) | |
| apk add --no-cache cfdisk e2fsprogs-extra | |
| # choose partition then "Resize" > "Write" (to finalize) | |
| cfdisk | |
| # replace * with partition you are resizing | |
| resize2fs /dev/* |
| // 1) open the shared spreadsheed, make a copy of it, open tools|script editor, update the settings below, save | |
| // https://docs.google.com/spreadsheets/d/15bTn9_Cv9IBVkvepINPlBRcK8oty74e6FlAieNbiQMg/edit?usp=sharing | |
| // for script updates, simply copy this script into your spreadsheet using the script editor, i.e. select all, copy, paste, save | |
| // 2) set the script's timezone (File|Project properties) | |
| // 3) on the menu bar click Current Project's Triggers | |
| // click add new trigger | |
| // for Run select the function nestDataCollection, Events: time-driven, and select the rate per your preference (I do every 5 minutes) | |
| // click add new trigger | |
| // for Run select the function rollUpAllSheets, Events: time-driven, and select once a month | |
| // 4) in the spreadsheet, set the spreadsheet's timezone to your timezone (File|Spreadsheet settings...) |