|Title||Spreadsheet risk: How and why to build a better spreadsheet|
|Authors||Judith A. Ross|
|Publication||Harvard Business Review|
|Series||Volume 74, Number 5, Sep/Oct, pages 10-12|
The article discusses the findings of a study on spreadsheet error and presents five steps that ensures that managers can make spreadsheets more accurate.
The research suggests that spreadsheet developers usually err when they make an inputting error, when they use incorrect logic in one of the spreadsheet's formulas and when they simply leave out a piece of information. To avoid these pitfalls the research suggests conducting a random audit of the spreadsheets that are critical to a business organization's function.
Companies should institute protection computer programs that guard against error. Authorship and responsibility for spreadsheets should be clear and the sheets themselves and the information in them should be self-explanatory. Results should be checked by hand. Managers should construct a detailed spreadsheet design plan before beginning construction of one.
|Full version||Not available|
Managers can make spreadsheets safer by taking five relatively easy steps: