Reducing Spreadsheet Risk with FormulaDataSleuth

Reducing the Risk of Spreadsheet Usage - a Case Study

The frequency with which spreadsheets are used and the associated risk is well known. Many tools and techniques have been developed which help reduce risks associate with creating and maintaining spreadsheet. However, little consideration has been given to reducing the risks of routine usage by the "consumers" - for example when entering and editing data. EASA's solution, available commercially, ensures that any routine process involving spreadsheets can be executed rapidly and without errors by the end-users, often with a significant reduction in manual effort. Specifically, the technology en…

减少电子表格开发中的过度自信

Reducing Overconfidence in Spreadsheet Development

本文通过两个实验验证电子表格开发人员存在过度自信，并测试一种干预方法以减少过度自信和错误，结果表明该方向具有前景。

Some Spreadsheet Poka-Yoke

Whilst not all spreadsheet defects are structural in nature, poor layout choices can compromise spreadsheet quality. These defects may be avoided at the development stage by some simple mistake prevention and detection devices. Poka-Yoke (Japanese for Mistake Proofing), which owes its genesis to the Toyota Production System (the standard for manufacturing excellence throughout the world) offers some principles that may be applied to reducing spreadsheet defects. In this paper we examine spreadsheet structure and how it can lead to defects and illustrate some basic spreadsheet Poka-Yokes to red…

思考是有害的：人类错误研究对电子表格研究与实践的启示

Thinking is Bad: Implications of Human Error Research for Spreadsheet Research and Practice

本文指出电子表格错误研究长期忽视人类错误研究成果，并基于该领域结论提出“思考有害”、电子表格并非错误根源以及减少错误极其困难等观点，为后续实证检验提供方向。