arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 0809.3613cs.SEcs.HC
收藏

重新审视电子表格错误的Panko-Halverson分类法

Revisiting the Panko-Halverson Taxonomy of Spreadsheet Errors

Raymond R. Panko

摘要:

本文的目的是重新审视Panko-Halverson电子表格错误分类法,并提出修订建议。这样做有几个原因:第一,分类法已被广泛使用。因此,它应该有审查;第二,分类没有广泛提供其原始形式,大多数用户参考二手资料。因此,他们往往等同于在特定的实验或现场研究中使用的简化提取的分类法;第三,也许是因此,大多数用户只使用分类法的一小部分。特别是,他们往往不使用分类法的生命周期维度;第四,分类法已经过测试,对电子表格的实验和电子表格的业务使用。现在是时候回顾一下它在这些测试中的表现了;第五,分类法是基于作者在20世纪90年代中期所知道的电子表格错误的类型。后来的经验表明,分类法需要扩展到超出这些原始经验的情况;第六,分类法中的遗漏类别被证明过于狭窄。虽然本文将重点放在Panko-Halverson分类,这并不意味着它是唯一可能的错误分类,甚至是最好的错误分类。

英文摘要:

The purpose of this paper is to revisit the Panko-Halverson taxonomy of spreadsheet errors and suggest revisions. There are several reasons for doing so: First, the taxonomy has been widely used. Therefore, it should have scrutiny; Second, the taxonomy has not been widely available in its original form and most users refer to secondary sources. Consequently, they often equate the taxonomy with the simplified extracts used in particular experiments or field studies; Third, perhaps as a consequence, most users use only a fraction of the taxonomy. In particular, they tend not to use the taxonomy's life-cycle dimension; Fourth, the taxonomy has been tested against spreadsheets in experiments and spreadsheets in operational use. It is time to review how it has fared in these tests; Fifth, the taxonomy was based on the types of spreadsheet errors that were known to the authors in the mid-1990s. Subsequent experience has shown that the taxonomy needs to be extended for situations beyond those original experiences; Sixth, the omission category in the taxonomy has proven to be too narrow. Although this paper will focus on the Panko-Halverson taxonomy, this does not mean that that it is the only possible error taxonomy or even the best error taxonomy.

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

↑