| Project Name | Description | Link | Docs |
|---|---|---|---|
| gsSQL | Query Google Sheet data using standard SQL SELECT syntax | gsSQL Notes | JSDoc |
| cachefinance | Google Sheet custom function and/or event trigger for enhanced stock/etf data lookup | cachefinance Notes | |
| Select 2 Query | Convert SQL Select statement to Google Sheets QUERY | Select2Query | |
| CanadianTaxes | Project future gross incomes from net incomes taking Canadian Taxes into account | CanadianTaxes |
Latest Articles
- Finding a good estimation of future RRSP withdrawals December 10, 2024
- Using gsSQL Library February 15, 2024
- How to Find Duplicates in Google Sheets [using gsSQL custom function] February 15, 2024
- Google Sheets Query function: The Most Powerful Function in Google Sheets February 12, 2024
- Generate Google Sheets QUERY from Standard SQL April 18, 2023
- Using a calculation to evaluate JOIN condition. April 1, 2023
- Custom Function Triggered on Data Changes March 8, 2023
- GROUP BY in gsSQL February 27, 2023
- Bind Variables in gsSQL January 21, 2023
- Select where EXISTS using correlated Sub Query December 28, 2022
- Correlated Sub Query December 23, 2022
- Theme Update - jekyll-theme-leap-day December 22, 2022
- Welcome to First Post! December 18, 2022