An experimental study of people creating spreadsheets
ACM Transactions on Information Systems (TOIS)
Journal of Accountancy
Spreadsheet analysis and design
Communications of the ACM
Structured development techniques for user-developed systems
Information and Management
An investigation of the relative presentation efficiency of computer-displayed graphs
Information and Management
What we know about spreadsheet errors
Journal of End User Computing - End User Development
Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model
Decision Support Systems
Using a structured design approach to reduce risks in end user spreadsheet development
Information and Management
Decision Support Systems and Intelligent Systems
Decision Support Systems and Intelligent Systems
Spreadsheets on Trial: A Survey of Research on Spreadsheet Risks
HICSS '96 Proceedings of the 29th Hawaii International Conference on System Sciences Volume 2: Decision Support and Knowledge-Based Systems
Two Corpuses of Spreadsheet Errors
HICSS '00 Proceedings of the 33rd Hawaii International Conference on System Sciences-Volume 4 - Volume 4
Computerized financial planning: discovering cognitive difficulties in model building
Computerized financial planning: discovering cognitive difficulties in model building
Spreadsheet presentation and error detection: an experimental study
Journal of Management Information Systems - Special issue: Information technology and its organizational impact
Hi-index | 0.00 |
Spreadsheet programs are deceptively simple tools that are widely used by end user developers in organizations. However, recent studies have shown that spreadsheets often contain significant, decision-affecting errors. One study that addressed "linking errors," i.e., incorrect references to spreadsheet cell values on separate work areas, found these errors to be a major error source in complex spreadsheets that use distinct work areas spread across multiple worksheets. This paper describes a code inspection approach that visually represents the structure of a linked spreadsheet and graphically identifies linked cells and their sources. We tested this approach in an experimental study where subjects created a complex spreadsheet. Results indicate that subjects who used the approach made significantly fewer errors and experienced no decrease in speed of spreadsheet production or satisfaction with the production process.