University of Limerick Institutional Repository

Heuristics for the automatic identification of irregularities in spreadsheets

DSpace/Manakin Repository

Show simple item record

dc.contributor.author Clermont, Markus
dc.date.accessioned 2009-05-13T08:36:14Z
dc.date.available 2009-05-13T08:36:14Z
dc.date.issued 2005
dc.identifier.citation Clermont, M., "Heuristics for the Automatic identification of Irregularities in Spreadsheets", Proceedings of the First Workshop on End-User Software Engineering (WEUSE 2005) in conjunction with ICSE, St. Louis, Missouri - USA, May 21st, 2005, IEEE Computer Society. en
dc.identifier.uri http://hdl.handle.net/10344/153
dc.description non-peer-reviewed
dc.description.abstract Spreadsheet programs turned out to be the most popular end-user programming environment that has ever been released. Important decisions are based on the results of spreadsheet programs and the list of known errors with large impact is growing daily- although it surely is only the top of an iceberg. One way out of the crisis might be the introduction of software engineering techniques into spreadsheet development. Suggestions for the improvement of spreadsheet development range back as far as into the late eighties, but none has been successful yet. We argue this is either because not enough effort is put into the roll-out of the technique to the users and, mainly, because they neglect the fact that spreadsheet programmers are end-users, not willing or not able to spend any time on learning software engineering methods. We found out that most end users are willing to verify their spreadsheets, but only view have the time and skills to do really systematic testing of spreadsheets. We developed an approach to generate two orthogonal abstract representations of spreadsheet programs that are then displayed to the user by different visualisation techniques to support the auditing process. Usually, irregularities in the visualisation point out hot-spots on the spreadsheet with a high likelihood of erroneous formulas. In this paper we present new heuristics for identifying hot spots that are very efficient for large spreadsheet programs. en
dc.language.iso eng en
dc.publisher IEEE Computer Society. en
dc.relation.ispartofseries Proceedings of the First Workshop on End-User Software Engineering (WEUSE 2005) in conjunction with ICSE;
dc.subject program analysis en
dc.subject spreadsheet visualization en
dc.subject end user programming en
dc.title Heuristics for the automatic identification of irregularities in spreadsheets en
dc.type Conference item en
dc.type.supercollection all_ul_research en
dc.type.restriction none en
dc.identifier.local 09SQRL1023
dc.contributor.sponsor SFI

Files in this item

This item appears in the following Collection(s)

Show simple item record

Related Items

Search DSpace


Advanced Search

Browse

My Account