My writings about spreadsheets, and an idiosyncratic guide to spreadsheets on the web.
Ray Panko's overview paper describes what we know about spreadsheet errors and presents a taxonomy for thinking about them.
- In Excel, Cell Names Spell Speed, Safety (2003) My article in the Journal of Accountancy about the use of range names in Excel. It was heavily edited; the original paper contained much more advice.
- Let CellMaps and TrafficLights Guide Your Spreadsheet Inspections (2004) Two tools that assist in spreadsheet auditing. CellMaps provides a graphical high-level view of the captions, inputs, formula copies and dependency relationships in a spreadsheet. TrafficLights provides a convenient interface for cell-by-cell inspection of a spreadsheet.
- Finance Lessons From A Roadside Lemonade Stand (2005) I never really finished this paper, which has an associated Excel spreadsheet, though I have used it twice in training classes for co-workers. But it discusses time-value-of-money calculations and provides brief introductions to array formulas and writing VBA functions for people unfamiliar with them.
- How Do You Know Your Spreadsheet Is Right? (2005) My guide to suggested best-practices for spreadsheet development.
- Spreadsheet Layout (2006) The original "How Do You Know Your Spreadsheet Is Right?" paper ducked the question of how to layout a spreadsheet to reduce errors; this paper suggests a set of guidelines that should help.
- The European Spreadsheet Risks Interest Group is the leading organization dedicated to reducing spreadsheet errors. They have an annual conference, a web site, and a discussion group.
- Researchers: Paine, Panko, Raffensperger (personal, commercial), Sysmod.
- Excel sites: Bullen, Pearson, Walkenbach.
- Web-based spreadsheets: Google, iRows, Numbler, NumSum, ThinkFree, WikiCalc
- Google Scholar topic searches: auditing, errors, structure, style, testing
- Google Scholar author searches: Burnett, Clermont, Paine, Panko, Rajalingham, Rothermel, Sajaniemi
- Google web searches: auditing, errors, structure, style, testing