Spreadsheets

Workshop materials (2021-05) for building a simple R-based ETL / data pipeline with GitLab CI/CD and Google Spreadsheets

Minimal R-based ETL / GitLab CI/CD pipeline, hooked to a private Google Spreadsheet with {googlesheets4} and the {poorman} package.

Desktop app to enter, calculate and display spreadsheet-like values organized along two or more category axes by individual category values. Rearrange categories along different axes to obtain different insights. Apply formulas to one or more whole categories or to individual category values. Inspired by the flexible nature of apps like Lotus Improv and Quantrix Modeler.

Puzzle solving tools for Google Sheets, forked from https://github.com/marie-cd/googledoc-puzzle-tools