图纸可维护性自动评估的要求
Requirements for Automated Assessment of Spreadsheet Maintainability
摘要:
电子表格的使用非常广泛。无论是在商业,金融,工程还是其他领域,电子表格都是为了它们的灵活性和轻松性而创建的,可以快速建模问题。它们经常从简单的原型发展到关键业务逻辑的实现。在组织中发挥关键作用的电子表格自然会有很长的寿命,并由几个人维护和发展。因此,重要的是不仅要看它们的可靠性,即,预期功能的实现情况如何,以及它们的可维护性,即,诊断电子表格的缺陷并在不降低其质量的情况下对其进行修改是多么容易。在这份立场文件中,我们认为需要创建一个模型来估计(自动)测量的基础上的电子表格的可维护性。我们建议这样做,通过应用结构化的方法,已经显示出其价值的软件产品的可维护性的估计。我们还主张创建一个精心策划的,社区贡献的电子表格存储库。
英文摘要:
The use of spreadsheets is widespread. Be it in business, finance, engineering or other areas, spreadsheets are created for their flexibility and ease to quickly model a problem. Very often they evolve from simple prototypes to implementations of crucial business logic. Spreadsheets that play a crucial role in an organization will naturally have a long lifespan and will be maintained and evolved by several people. Therefore, it is important not only to look at their reliability, i.e., how well is the intended functionality implemented, but also at their maintainability, i.e., how easy it is to diagnose a spreadsheet for deficiencies and modify it without degrading its quality. In this position paper we argue for the need to create a model to estimate the maintainability of a spreadsheet based on (automated) measurement. We propose to do so by applying a structured methodology that has already shown its value in the estimation of maintainability of software products. We also argue for the creation of a curated, community-contributed repository of spreadsheets.
机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。