Spreadsheets offer a supremely successful and intuitive means of processing and exchanging numerical content. Its intuitive ad-hoc nature makes it hugely popular for use in diverse areas including business and engineering, yet these very same characteristics make it extraordinarily error-prone; many would question whether it is suitable for serious analysis or modelling tasks. A previous EuSpRIG paper examined the role of Names in increasing solution transparency and providing a readable notation to forge links with the problem domain. Extensive use was made of CSE array formulas, but it is acknowledged that their use makes spreadsheet development a distinctly cumbersome task. Since that time, the new dynamic arrays have been introduced and array calculation is now the default mode of operation for Excel. This paper examines the thesis that their adoption within a more professional development environment could replace traditional techniques where solution integrity is important. A major advantage of fully dynamic models is that they require less manual intervention to keep them updated and so have the potential to reduce the attendant errors and risk.

中文翻译：

---

动态数组最终会改变模型的构建方式吗？

电子表格提供了一种非常成功且直观的处理和交换数字内容的方法。其直观的即席性质使其在包括商业和工程在内的各个领域非常受欢迎，但这些非常相同的特性使其非常容易出错；许多人会质疑它是否适合严肃的分析或建模任务。之前的 EuSpRIG 论文研究了名称在提高解决方案透明度和提供可读符号以与问题域建立链接方面的作用。CSE 数组公式被广泛使用，但人们承认，它们的使用使电子表格开发成为一项明显繁琐的任务。从那时起，引入了新的动态数组，数组计算现在是 Excel 的默认操作模式。本文考察了在更专业的开发环境中采用它们可以取代解决方案完整性很重要的传统技术的论点。全动态模型的一个主要优点是它们需要较少的人工干预来保持更新，因此有可能减少随之而来的错误和风险。