Model errors are pervasive and can be catastrophic. We can reduce model errors and time to market by applying Component-Based Software Engineering (CBSE) concepts to Excel models. CBSE assembles solutions from pre-built, pre-tested components rather than written from formulas. This is made possible by the introduction of LAMBDA. LAMBDA is an Excel function that creates functions from Excel's formulas. CBSE-compliant LAMBDA functions can be reused in any project just like any Excel function. They also look exactly like Excel's native functions such as SUM(). This makes it possible for even junior modelers to leverage CBSE-compliant LAMBDAs to develop models quicker with fewer errors.

翻译：模型错误普遍存在且可能造成灾难性后果。通过将基于组件的软件工程（CBSE）概念应用于Excel模型，我们可以减少模型错误并缩短上市时间。CBSE通过预构建、预测试的组件来组装解决方案，而非通过公式从头编写。这一方法的实现得益于LAMBDA的引入——LAMBDA是一个能从Excel公式创建函数的Excel函数。符合CBSE标准的LAMBDA函数可像任何Excel内置函数（如SUM()）一样，在所有项目中重复使用，且其外观与Excel原生函数完全一致。这使得即使是初级建模者也能利用符合CBSE标准的LAMBDA函数，更快、更少错误地开发模型。