8 research outputs found
Structured Spreadsheet Modeling and Implementation
Developing an error-free spreadsheet has been a problem since the beginning
of end-user computing. In this paper, we present a methodology that separates
the modeling from the implementation. Using proven techniques from Information
Systems and Software Engineering, we present strict, but simple, rules
governing the implementation from the model. The resulting spreadsheet should
be easier to understand, audit and maintain.Comment: In Proceedings of the 2nd Workshop on Software Engineering Methods in
Spreadsheet
Heuristics for the automatic identification of irregularities in spreadsheets
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