John Pendley

Essential reading

The cascading structure of typical spreadsheet formulae means that just about every spreadsheet is almost certainly wrong.
This early spreadsheet, a Babylonian clay tablet c.1800 BC, contains several errors. How many errors do your spreadsheets have?
Do you document your spreadsheets? We use the FizzBuzz word game to illustrate the importance of documenting your spreadsheets.
Errors in the data, formulas, or manipulation of spreadsheets could be costly, even devastating.
Our spreadsheet methodology has criteria for designing, building, and validating spreadsheets to ensure that they work correctly.
The twenty principles for good spreadsheet practice aims to reduce the amount of time wasted and the number of errors.
"Oh My God" my formulas are not working! This article covers most of the reasons for Excel formulas not working. And how to fix them.
Spreadsheet errors are reduced by using good design. Our students do three assignments to acquire good spreadsheet design skills.