An empirical study of spreadsheet error-finding performance

Galletta, Dennis F.; Abraham, Dolphy M.; Louadi, Mohamed El; Lekse, William J.; Pollalis, Yannis A.; Sampler, Jeffrey L.

doi:10.1016/0959-8022(93)90001-m

Cited by 52 publications

(22 citation statements)

References 32 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Further, most of the subjects in these experiments have exhibited a great deal of confidence in their spreadsheets's validity, implying that spreadsheet design errors are not only prevalent, but also elusive. These results corroborate the observation that spreadsheet models suffer from weak accountability and face-validity [9].…”

supporting

confidence: 81%

Toward a logical/physical theory of spreadsheet modeling

Isakowitz

Schocken

Lucas

1995

ACM Trans. Inf. Syst.

View full text Add to dashboard Cite

In spite of the increasing sophistication and power of commercial spreadsheet packages, we still lack a formal theory or a methodology to support the construction and maintenance of spreadsheet models. Using a dual logical/physical perspective, we identify four principal components that characterize any spreadsheet model: schema, data, editorial, and binding. We present a factoring algorithm for identifying and extracting these components from conventional spreadsheets with minimal user intervention, and a synthesis algorithm that assists users in the construction of executable spreadsheets from reusable model components. This approach opens new possibilities for applying object-oriented and model management techniques to support the construction, sharing, and reuse, of spreadsheet models in organizations. Importantly, our approach to model management and the Windows-based prototype that we have developed are designed to coexist with. rather than replace, traditional spreadsheet programs. In other words, the users are not required to learn a new modeling language; instead, their logical models and data sets are extracted from their spreadsheets transparently, as a side-effect of using standard spreadsheet programs.

show abstract

supporting

confidence: 81%

Toward a logical/physical theory of spreadsheet modeling

Isakowitz

Schocken

Lucas

1995

ACM Trans. Inf. Syst.

View full text Add to dashboard Cite

show abstract

“…Galletta et al [9] devised an experiment with six simple spreadsheets and concluded that subjects with accounting expertise found more errors than others and that subjects with spreadsheet expertise found errors faster. Galletta et al [10] studied the effect of presentation style and found that subjects who had access to the spreadsheet formulae did not perform better than those who saw only the resulting numbers.…”

Section: Laboratory Auditsmentioning

confidence: 98%

An auditing protocol for spreadsheet models

Powell

Baker

Lawson

2008

Information & Management

View full text Add to dashboard Cite

“…We can confirm previous findings, showing that even the most motivated researchers with substantial training and background expertise will inevitably err when transferring information in complicated scenarios where many complex details could go awry (see also (L esgold et al . 1988; G alletta et al . 1993; G alletta et al .…”

Section: Human Error Analyses: Approaches Challenges Efficienciesmentioning

confidence: 99%

FlyClockbase: Importance of Biological Model Curation for Analyzing Variability in the Circadian Clock of Drosophila melanogaster by Integrating Time Series from 25 Years of Research

Scheuer

Hanlon

Dresel

et al. 2017

Preprint

View full text Add to dashboard Cite

General Article SummarySubstantial biological model curation was essential for identifying differences in peak 23 time variance of the clock-proteins 'PERIOD' and 'TIMELESS', which probably stem 24 from differences in phosphorylation-network complexity. 25 We repeatedly encountered systemic limitations of contemporary data analysis 26 strategies in our work on circadian clocks. Thus, we used it as an opportunity for 27 composing a panoramic view of the broader challenges in biological model curation, 28 which are likely to increase as biologists aim to integrate all existing expertise in order to 29 address diverse grand challenges. We developed and tested a trans-disciplinary 30 research workflow, which enables biologists and compiler-architects to define biology-31 friendly compilers for efficiently constructing and maintaining Versioned Biological 32 Information Resources (VBIRs). We report insights gleaned from our practical clock 33 research that are essential for defining a VBIRs infrastructure, which improves the 34 efficiency of biological model curation to the point where it can be democratized. . CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It is made available under a was not peer-reviewed) is the author/funder, who has granted bioRxiv a license to display the preprint in perpetuity.The copyright holder for this preprint (which . http://dx.doi.org/10.1101/099192 doi: bioRxiv preprint first posted online Jan. 9, 2017;. CC-BY 4.0 International license It ...

show abstract

An empirical study of spreadsheet error-finding performance

Cited by 52 publications

References 32 publications

Toward a logical/physical theory of spreadsheet modeling

Toward a logical/physical theory of spreadsheet modeling

An auditing protocol for spreadsheet models

FlyClockbase: Importance of Biological Model Curation for Analyzing Variability in the Circadian Clock of Drosophila melanogaster by Integrating Time Series from 25 Years of Research

Contact Info

Product

Resources

About