从良好的实践到有效的政策，以防止电子表格中的错误
From Good Practices to Effective Policies for Preventing Errors in Spreadsheets
摘要：
由于它们提供的巨大灵活性，电子表格被许多最终用户认为是无价的祝福。然而，许多电子表格包含在某些情况下可能导致严重后果的错误。为了管理这些风险，公司的质量管理人员经常被要求制定适当的政策来防止电子表格错误。良好的政策应具体规定以“已知良好”做法为基础的规则。虽然在从业人员和研究人员撰写的文献中有许多关于这种做法的建议，但它们往往彼此不一致。因此，尚未达成普遍协议，也没有公布基于科学的“黄金法则”。本文提出了一种基于专家的，回顾性的方法来确定电子表格的良好做法。它基于一个评估循环，该循环根据半自动电子表格工作台中实施的规则交叉验证人类领域专家的发现，同时考虑到电子表格的使用环境。
英文摘要：
Thanks to the enormous flexibility they provide, spreadsheets are considered a priceless blessing by many end-users. Many spreadsheets, however, contain errors which can lead to severe consequences in some cases. To manage these risks, quality managers in companies are often asked to develop appropriate policies for preventing spreadsheet errors. Good policies should specify rules which are based on "known-good" practices. While there are many proposals for such practices in literature written by practitioners and researchers, they are often not consistent with each other. Therefore no general agreement has been reached yet and no science-based "golden rules" have been published. This paper proposes an expert-based, retrospective approach to the identification of good practices for spreadsheets. It is based on an evaluation loop that cross-validates the findings of human domain experts against rules implemented in a semi-automated spreadsheet workbench, taking into account the context in which the spreadsheets are used.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
