Bas Jansen

Code smells in spreadsheet formulas revisited on an industrial dataset
Detecting and predicting evolution in spreadsheets: A case study in an energy network company
The effect of delocalized plans on spreadsheet comprehension - A controlled experiment
The use of charts, pivot tables, and array formulas in two popular spreadsheet corpora

Essential reading

Pitfalls of Excel's NPV function

Incorrect use of Excel's NPV function is a common source of spreadsheet errors. We show several pitfalls and ways to avoid them.

Latest articles