spreadsheets.md

Spreadsheets

TODO:

• Excel: LAMBDA function
  • New feature!

XLOOKUP (looking in row+col) VSTACK (combine multiple workbooks into single array) UNIQUE TEXTSPLIT SORT TOCOL TOROW Combine bultiple rows/cols into one

Visicalc on apple 2 changed the world

Functional programming for the mass's

• [python-excel]

• Ditching Excel for Python – Lessons Learned from a Legacy Industry

  • modern trend to move towards scripting languages

• Spreadsheet is a software development paradigm

  • Advantages of spreadsheets
    • Intuitive and easy to use
    • A transparent and static state is easy to debug
    • Reactive and declarative computations
    • Standardized user interface
  • Disadvantages of spreadsheets
    • Weakly typed and semi-structured data model
    • High code duplication
    • Bad scalability
    • Lack of interface interactivity

• [functional] - Spreadsheets: Functional Programming for the Masses

• Podcast Advancing Excel as a programming language with Andy Gordon and Simon Peyton Jones

• The “Spreadsheet Mentality” sucks, and kills the efficacy of jobs

  • TODO

• I made an entire DAW in Excel

  • AMAZING!

• Using Google Sheets as an API

  • https://www.zerosheets.com/
  • https://github.com/calaldees/barcampCanterbury/blob/6a44a92c55afa4805fad96f2015a07bab9301ebb/barcampcanterbury.com/data/googleSheets.js