Spreadsheets for Developers
summary
Claims spreadsheets are Turing complete and proves it by implementing a Turing machine and a selection sort entirely with Excel formulas. Demonstrates quick algorithm prototyping (Pascal’s triangle, Project Euler puzzles) and builds two concrete tools: Bumblebee refactoring to detect and rewrite smelly formulas and Expecto to extract and run in-sheet tests and show coverage. Tools target Excel on Windows, are downloadable, and Expecto already has over 1,000 installs, showing the approaches work in practice.
AI-written summary · about
chapters (17)
- 0:00Intro
- 8:20Selection Sort
- 14:20Offset Function
- 18:45Name Ranges
- 19:32Song Name Ranges
- 20:30Little Bit More Magic
- 23:04Previous Row
- 24:16Selection
- 25:25Programming in Excel
- 27:54What is my real job
- 28:30Bumblebee
- 35:36Research
- 36:56Summary
- 38:25Questions
- 42:01Highorder functions
- 43:26Excel is code
- 45:29Excel vs Python
related talks
39mSpreadsheets for developers
44mSpreadsheets are Code
48mSmart Spreadsheets
16mEXCELsioR!
17mFive signs your spreadsheet might smell (and what you can do about it)
22mExceLint - Automatically Finding Spreadsheet Formula Errors
14mStrata Conference in London 2013: Felienne Hermans
01h 04mThe Art of Prototyping Analytics