Guidelines on Testing a Spreadsheet

C

Colin Cherry

Does anyone have information or guidelines on how to
verify and validate a spreadsheet. I am looking to provide
guidelines to those who develop/use spreadsheets for
financial modelling and decision making.
 
B

BrianB

Having to do this sort of thing all the time.

The best method is the simplest - make various subtotals of numbers an
summarise these into a single cell somewhere that shows an overal
total of the numbers in the sheet. This can be checked with number
elsewhere - if it is correct, no need to waste further time. If it doe
not agree then it should be possible to "drill-down" to check th
various subtotals to find the one(s) that do not match, then drill dow
further to the individual items.

Keeping raw data in a single table instead of multiple worksheets t
allow the use of pivot tables/filters etc. can vastly simplify th
process
 
Top