Computer Science – Human-Computer Interaction
Scientific paper
2008-07-20
Proc. European Spreadsheet Risks Int. Grp. (EuSpRIG) 2003 81-90 ISBN 1 86166 199 1
Computer Science
Human-Computer Interaction
10 pages, 3 figures
Scientific paper
Because spreadsheets have a large and growing importance in real-world work, their contents need to be controlled and validated. Generally spreadsheets have been difficult to verify, since data and executable information are stored together. Spreadsheet applications with multiple authors are especially difficult to verify, since controls over access are difficult to enforce. Facing similar problems, traditional software engineering has developed numerous tools and methodologies to control, verify and audit large applications with multiple developers. We present some tools we have developed to enable 1) the audit of selected, filtered, or all changes in a spreadsheet, that is, when a cell was changed, its original and new contents and who made the change, and 2) control of access to the spreadsheet file(s) so that auditing is trustworthy. Our tools apply to OpenOffice.org calc spreadsheets, which can generally be exchanged with Microsoft Excel.
Adler Andy
Nash John C.
Smith Neil
No associations
LandOfFree
Audit and Change Analysis of Spreadsheets does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Audit and Change Analysis of Spreadsheets, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Audit and Change Analysis of Spreadsheets will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-420190