寻找定性电子表格错误的分类法
In Search of a Taxonomy for Classifying Qualitative Spreadsheet Errors
摘要:
大多数组织使用大型复杂的电子表格,这些电子表格嵌入其关键任务流程中,并用于决策目的。因此,识别这些电子表格中可能存在的各种类型的错误是组织可以用来管理其电子表格的重要控制措施。在本文中,我们提出了一个分类的电子表格模型中的定性错误,提供了一个框架,用于评估准备的电子表格模型之前,它被释放供其他人使用的组织。分类是根据文献中确定的定性错误类型和最终用户在为Panko(1996年)的“墙问题”开发电子表格模型时犯下的错误制定的。仔细检查的错误揭示了四个逻辑分组的错误创建四类定性错误。的可用性和局限性的建议分类和未来扩展的领域进行了讨论。
英文摘要:
Most organizations use large and complex spreadsheets that are embedded in their mission-critical processes and are used for decision-making purposes. Identification of the various types of errors that can be present in these spreadsheets is, therefore, an important control that organizations can use to govern their spreadsheets. In this paper, we propose a taxonomy for categorizing qualitative errors in spreadsheet models that offers a framework for evaluating the readiness of a spreadsheet model before it is released for use by others in the organization. The classification was developed based on types of qualitative errors identified in the literature and errors committed by end-users in developing a spreadsheet model for Panko's (1996) "Wall problem". Closer inspection of the errors reveals four logical groupings of the errors creating four categories of qualitative errors. The usability and limitations of the proposed taxonomy and areas for future extension are discussed.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。