13.0 Discussion (Spreadsheet Errors, Checkers, Auditors)
Description
This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.
13.0 Discussion (Spreadsheet Errors, Checkers, Auditors)
Raymond Panko's Spreadsheet Research
http://panko.cba.hawaii.edu/ssr/
Jocelyn Paine
Model Master (spreadsheet front-end; fewer errors; easier to read+maintain)
http://www.ifs.org.uk/~popx/
New Scientist articles
http://www.newscientist.com/ns/970816/nspreadsheet.html
http://www.newscientist.com/ns/980912/nsoftware.html
Frontline Systems Hints for Building Readable, Manageable Models
http://www.frontsys.com/readable.htm
Spreadsheet Style - including readability tips, auditing help
http://www.spreadsheetstyle.com/
13.1 Minimal (Spreadsheet Errors, Checkers, Auditors)
There should be 2 trivial checks any spreadsheet should be able to
make on its formulas:
1. no formula refers to an empty cell
- except as part of a larger SUM() perhaps
2. no nonempty cell is unreferenced
- except those that are intended as final results or displays
13.2 The Excel Auditor
http://www.bygsoftware.com/auditor/auditor.htm
13.3 Spreadsheet Detective
http://www.uq.net.au/detective/
13.4 Professional's Guide to Robust Spreadsheets
http://www.manning.com/Richardson/
ISBN 0-13262320-X
13.5 The Campgridge Spreadsheet Analyst
from 1986 (Version 2.0)
The Cambridge Software Collaborative
identifies a variety of suspicious references
one web site claims it is now owned by Intex; one claims Symantec.
13.99 Can't find them (Spreadsheet Errors, Checkers, Auditors)
Spreadsheet Auditor, by Consumers Software (or Consumer Software?)
Cellmate
Continue to:
My Books
