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

一种度量电子表格复杂性的概念模型

A Conceptual Model for Measuring the Complexity of Spreadsheets

Thomas Reschenhofer, Bernhard Waltl, Klym Shumaiev, Florian Matthes

摘要:

电子表格广泛应用于工业,甚至用于关键业务流程。这意味着需要在电子表格中进行适当的风险评估,以评估电子表格结果的可靠性和有效性。相关研究表明,电子表格错误的风险与电子表格的复杂性密切相关。因此,电子表格的研究人员提出了各种指标量化电子表格的不同方面,以评估其复杂性。然而,到目前为止,对于电子表格的潜在复杂性驱动因素还没有共同的理解。目前的工作解决了这一研究差距,提出了一个概念模型,整合了相关文献中确定的潜在驱动程序的电子表格的复杂性的各个方面。从这个意义上说,这个模型形成了复杂性度量的结构化定义的基础,从而提高了其结果的可重复性。与此同时,它为从其他科学领域确定进一步适用的复杂性度量奠定了基础。

英文摘要:

Spreadsheets are widely used in industry, even for critical business processes. This implies the need for proper risk assessment in spreadsheets to evaluate the reliability and validity of the spreadsheet's outcome. As related research has shown, the risk of spreadsheet errors is strongly related to the spreadsheet's complexity. Therefore, spreadsheet researchers proposed various metrics for quantifying different aspects of a spreadsheet in order to assess its complexity. However, until now there is no shared understanding of potential complexity drivers for spreadsheets. The present work addresses this research gap by proposing a conceptual model integrating all aspects which are identified by related literature as potential drivers to spreadsheet complexity. In this sense, this model forms the foundation for a structured definition of complexity metrics, and thus enhances the reproducibility of their results. At the same time, it forms the foundation for identifying further applicable complexity metrics from other scientific domains.

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

↑