• Corpus ID: 18834443

Complexity Metrics for Spreadsheet Models

@article{Bregar2008ComplexityMF,
  title={Complexity Metrics for Spreadsheet Models},
  author={Andrej Bregar},
  journal={ArXiv},
  year={2008},
  volume={abs/0802.3895}
}
Several complexity metrics are described which are related to logic structure, data structure and size of spreadsheet models. They primarily concentrate on the dispersion of cell references and cell paths. Most metrics are newly defined, while some are adapted from traditional software engineering. Their purpose is the identification of cells which are liable to errors. In addition, they can be used to estimate the values of dependent process metrics, such as the development duration and effort… 
View PDF on arXiv
35 Citations
Highly Influential Citations
5
Background Citations
17
Methods Citations
7
Results Citations
1

35 Citations

Citation Type

Citation Type

A Conceptual Model for Measuring the Complexity of Spreadsheets
TLDR
A conceptual model integrating all aspects which are identified by related literature as potential drivers to spreadsheet complexity is proposed, which forms the foundation for a structured definition of complexity metrics, and thus enhances the reproducibility of their results.
Requirements for Automated Assessment of Spreadsheet Maintainability
TLDR
This position paper argues for the need to create a model to estimate the maintainability of a spreadsheet based on (automated) measurement and proposes the creation of a curated, community-contributed repository of spreadsheets.
Analyzing and Visualizing Spreadsheets
TLDR
This dissertation aims at developing methods to support spreadsheet users to understand, update and improve spreadsheets and found that methods from software engineering can be applied to spreadsheets very well, and that these methods support end-users in working with spreadsheets.
A Maintainability Checklist for Spreadsheets
TLDR
This paper presents a checklist aimed at measuring the maintainability of a spreadsheet, and demonstrates the applicability of this approach on 11 spreadsheets from the EUSES corpus.
On the empirical evaluation of similarity coefficients for spreadsheets fault localization
TLDR
This paper studies the impact of different similarity coefficients on the accuracy of spectrum-based fault localization applied to the spreadsheet domain and shows that three of the 42 studied coefficients require less effort by the user while inspecting the diagnostic report, and can be used interchangeably without a loss of accuracy.
A Quality Model for Spreadsheets
TLDR
This paper proposes a set of spreadsheet specific metrics to assess the quality of a spreadsheet in each of the software characteristics defined in the ISO/IEC 9126 standard that defines a generic quality model for software.
Metrics-Based Spreadsheet Visualization: Support for Focused Maintenance
TLDR
This paper proposes to use (complexity) measures as indicators for proper visualization, and proposes different visualization and representation methods that may ease spreadsheet comprehension but should not be applied with all kind of spreadsheet programs.
Measuring Spreadsheet Formula Understandability
TLDR
A set of spreadsheet understandability metrics are established by conducting a series of experiments in which professional spreadsheet users performed a number of short maintenance tasks on a set of spreadsheets from the EUSES spreadsheet corpus.
Investigating Effects of Common Spreadsheet Design Practices on Correctness and Maintainability
TLDR
Analysis of the obtained spreadsheets indicates that the correctness of "bottom-line" results is not affected by the observance of the three Best Practices, however, initially correct spreadsheets with high observances of these Best Practices tend to be the ones whose later modifications yield the most correct results.
Evaluating refactorings for spreadsheet models
...
...

References

SHOWING 1-10 OF 14 REFERENCES
Finding high-level structures in spreadsheet programs
TLDR
An approach to help maintainers understand the structure of large spreadsheets as well as to zoom into certain parts of the spreadsheet to cope with large sheets is introduced.
Auditing Large Spreadsheet Programs
TLDR
This paper presents an approach that enables auditors to understand the structure of large spreadsheets by aggregating cells with related properties and it will be shown, how different auditing strategies can be supported by this approach.
Using a structured design approach to reduce risks in end user spreadsheet development
What we know about spreadsheet errors
TLDR
Although spreadsheet programs are used for small "scratchpad" applications, they are also used to develop many large applications, and error rates are in line with those in programming and other human cognitive domains.
Spreadsheet Auditing Software
TLDR
This paper documents and tests office software tools designed to assist in the audit of spreadsheets to identify the success of software tools in detecting different types of errors, to identify how the software tools assist the auditor and to determine the usefulness of the tools.
Modeling Optimization Problems in the Unstructured World of Spreadsheets
Hitting the wall: errors in developing and code inspecting a 'simple' spreadsheet model
Spreadsheet analysis and design
TLDR
Several different contexts for the development of spreadsheet models are discussed and structured design techniques for these models are presented.
Applications development by end-users: can quality be improved?
Effects of error factors and prior incremental practice on spreadsheet error detection: an experimental study
...
...