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的默认运算模式。本文旨在论证：在更专业的开发环境中采用动态数组，有望在注重解决方案完整性的场景中取代传统技术。完全动态模型的主要优势在于减少人工维护更新的需求，从而具备降低相关错误与风险的潜力。