Finding Errors in the Enron Spreadsheet Corpus — Thomas Schmitz

Yeah, more people working on my things! After the VEnron paper at this year’s ICSE, there is now someone that dived into real errors in the dataset. We all know the problems, spreadsheets are error-prone (at least as error prone as other forms of software) but how to test errors. The state of the art is Read more about Finding Errors in the Enron Spreadsheet Corpus — Thomas Schmitz[…]

VEnron: A Versioned Spreadsheet Corpus and Related Evolution Analysis — Wensheng Dou

Spreadsheets at ICSE. Woo! If you have used spreadsheets, you know that it is a common scenario to have multiple versions of the same file, for different months, projects or clients. But, spreadsheets aren’t commonly under version control, while spreadsheets stay alive for 5 years and are used then by 13 users. We all know Read more about VEnron: A Versioned Spreadsheet Corpus and Related Evolution Analysis — Wensheng Dou[…]

Expector 1.0.0.7 released

We just released a new version of Expector, with a number of bug fixes (thanks for all the reports!) but also a few new features: Test quality Clicking this button helps you determine how well your spreadsheet is tested. Expector calculates what percentage of non-empty cells in your spreadsheet that are covered (refered to) by at least Read more about Expector 1.0.0.7 released[…]

What We Don’t Know About Spreadsheet Errors Today – Ray Panko

Jimmy Doolittle, says Ray, introduced the idea of trusting your instruments instead of relying on your intuition. We need to do this for spreadsheets too. Experiences are deceiving: Ray says people often cite him saying “spreadsheets are error-prone”, but he never said that! Humans are error-prone. We think we view the real world, but the Read more about What We Don’t Know About Spreadsheet Errors Today – Ray Panko[…]