Detecting bad smells in spreadsheets Public Deposited

http://ir.library.oregonstate.edu/concern/graduate_thesis_or_dissertations/m613n1906

Descriptions

Attribute NameValues
Creator
Abstract or Summary
  • Spreadsheets are a widely used end-user programming tool. Field audits have found that 80-90% of spreadsheets created by end users contain textual and formula errors in spreadsheets. Such errors may have severe negative consequences for users in terms of productivity, credibility, or profits. To solve the problem of spreadsheet errors, researchers have presented manual and automatic error detection. Manual error detection is both tedious and time-consuming, while automatic error detection is limited to only finding some formula error categories such as formula reference errors. Both approaches do not provide the optimum result in error detection. We have tested a new error detection approach by detecting bad smells in spreadsheets, which is an indication that an error might be present. Originally developed for object-oriented programming, examples include the large class, and the lazy class. We have adapted the concept of bad smells to spreadsheets. Each bad smell detector might indicate an issue in the spreadsheet, but the indication is not definitive, since the user must examine the spreadsheet and make a final judgment about whether an error is actually present. We evaluated 11 bad smell detectors by analyzing the true positives against the false positives. The result shows that six detectors can highlight some error categories, such as categorical errors and typographical errors.
Resource Type
Date Available
Date Copyright
Date Issued
Degree Level
Degree Name
Degree Field
Degree Grantor
Commencement Year
Advisor
Committee Member
Academic Affiliation
Non-Academic Affiliation
Keyword
Subject
Rights Statement
Peer Reviewed
Language
Replaces
Additional Information
  • description.provenance : Approved for entry into archive by Julie Kurtz(julie.kurtz@oregonstate.edu) on 2012-07-05T21:24:43Z (GMT) No. of bitstreams: 3 license_rdf: 22765 bytes, checksum: 56265f5776a16a05899187d30899c530 (MD5) license_text: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) AsavamethaAtipol2013.pdf: 1600209 bytes, checksum: 84c8d9d98f343f76b61b70145a55e067 (MD5)
  • description.provenance : Submitted by Atipol Asavametha (asavamea@onid.orst.edu) on 2012-07-05T10:49:54Z No. of bitstreams: 3 license_rdf: 22765 bytes, checksum: 56265f5776a16a05899187d30899c530 (MD5) license_text: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) AsavamethaAtipol2013.pdf: 1600209 bytes, checksum: 84c8d9d98f343f76b61b70145a55e067 (MD5)
  • description.provenance : Made available in DSpace on 2012-07-06T15:15:37Z (GMT). No. of bitstreams: 3 license_rdf: 22765 bytes, checksum: 56265f5776a16a05899187d30899c530 (MD5) license_text: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) AsavamethaAtipol2013.pdf: 1600209 bytes, checksum: 84c8d9d98f343f76b61b70145a55e067 (MD5) Previous issue date: 2012-06-15
  • description.provenance : Approved for entry into archive by Laura Wilson(laura.wilson@oregonstate.edu) on 2012-07-06T15:15:36Z (GMT) No. of bitstreams: 3 license_rdf: 22765 bytes, checksum: 56265f5776a16a05899187d30899c530 (MD5) license_text: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) AsavamethaAtipol2013.pdf: 1600209 bytes, checksum: 84c8d9d98f343f76b61b70145a55e067 (MD5)

Relationships

In Administrative Set:
Last modified: 08/20/2017

Downloadable Content

Download PDF
Citations:

EndNote | Zotero | Mendeley

Items