~/talk

Spreadsheets for developers

on YouTube 39m
Talkat Strange Loop 2014 · 2014-09-17..09-19· [developer-experience]

speaker

name:Felienne Hermans
bluesky:felienne.bsky.social

resources

video:https://youtu.be/0CKru5d4GPk
slides:none on file

summary

Argues spreadsheets are real code by implementing a Turing complete machine and a working selection sort purely with formulas, using OFFSET/INDIRECT, conditional formatting and dynamic named ranges to drive iteration and visibility. Demonstrates live refactorings (auto-rewrite sum/count to AVERAGE) and test extraction from embedded assertions, and ships two Excel 2010 plugins, Bumblebee (refactoring) and Expector (test discovery), both shown running on real sheets so the techniques actually work end to end.

AI-written summary · about

chapters (4)

  1. 0:00Start
  2. 0:49Used for similar problems
  3. 2:30Formulas are Turing complete
  4. 2:40They suffer from the same problems

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.