literature

[jennybc]

What We Don't Know About Spreadsheet Errors Today: The Facts, Why We Don't Believe Them, and What We Need to Do
Ray Panko
http://arxiv.org/abs/1602.02601

[richfitz]

Enron versus EUSES: A Comparison of Two Spreadsheet Corpora
Bas Jansen
http://arxiv.org/pdf/1503.04055v1.pdf

[jennybc]

Enron's Spreadsheets and Related Emails: A Dataset and Analysis
Felienne Hermans and Emerson Murphy-Hill
https://figshare.com/articles/Enron_s_Spreadsheets_and_Related_Emails_A_Dataset_and_Analysis/1222882
http://www.felienne.com/archives/3634

[jennybc]

the TableToLongForm package:

https://cran.r-project.org/web/packages/TableToLongForm/index.html
https://www.stat.auckland.ac.nz/~joh024/Research/TableToLongForm/
https://journal.r-project.org/archive/2014-2/oh.pdf

[jennybc]

Analyzing and Visualizing Spreadsheets
Felienne Hermans' PhD thesis
http://repository.tudelft.nl/view/ir/uuid%3A3a3ea534-68df-44a5-8a2d-411826d0335a/

[jennybc]

Spreadsheet Implementation Technology: Basic and Extensions
Peter Sestoft
https://mitpress.mit.edu/books/spreadsheet-implementation-technology

This is turning out to be very useful for, e.g. rethinking cellranger. Even though we have no ambitions on the calculation side, the treatment of data structures and classes here is super useful. And by definition we know they are the ones that support the actual reactive nature of spreadsheets, which is appealing.