Homoiconic spreadsheets: What, How & Why
summary
Claims that recent additions — lambdas in Excel & Google Sheets — push spreadsheets from formulas to first-class functions and that homoiconicity is achievable by treating grid text as literal code. Demonstrates a San Juan Children’s Research Hospital dashboard, builds custom sheet functions to implement a live Game of Life in a sheet, shows quoting and programmatic modification of cell-range text to mutate code-as-data, and cites Microsoft’s gridlets idea; proposes this combo moves spreadsheets from level 3 toward level 4.
AI-written summary · about
chapters (12)
- 0:00Intro
- 0:35What
- 4:02Gordon Brander
- 5:35List Circles
- 7:19The Value Room
- 10:18Time vs Space
- 11:41Deep Tech
- 12:36Literal Representation
- 17:06Bar charts
- 21:53Cellular automata
- 25:16Moment of Truth
- 26:50Spreadsheets
related talks
06m#ProjectLincoln
24mHow to build a spreadsheet with Python
19mUsing and Exploring Hierarchical Data in Spreadsheets
39mCreating Beautiful Spreadsheets With Data and Templates
51m30 Ways Google Sheets Can Help Your Company Uncover and Share Data Insights
26mDataEngBytes 2023 - BRI-T1-05 - Larene Le Gassick
39mPython & Spreadsheets: 2017 Edition
25mUnlocking key metrics and patterns using Grafana