arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 0802.3895cs.SE
收藏

单页模型的复杂性分析

Complexity Metrics for Spreadsheet Models

Andrej Bregar

摘要:

描述了与电子表格模型的逻辑结构、数据结构和大小有关的复杂性度量。它们主要集中在单元格引用和单元格路径的分散上。大多数度量是新定义的,而有些则是从传统的软件工程改编而来的。其目的是识别容易出错的细胞。此外,它们还可用于估计相关过程度量的值,如开发持续时间和工作量,特别是根据每个单元格的内容调整单元格出错率,以准确评估模型的可靠性。最后,讨论了两个概念结构-参考分支条件单元和条件块,旨在提高逻辑测试的可靠性,可修改性,可扩展性和可理解性。

英文摘要:

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, and especially to adjust the cell error rate in accordance with the contents of each individual cell, in order to accurately asses the reliability of a model. Finally, two conceptual constructs - the reference branching condition cell and the condition block - are discussed, aiming at improving the reliability, modifiability, auditability and comprehensibility of logical tests.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑