Formula Modeler (FML) is an Excel add-in tool for building and running mathematical models entirely in Excel VBA. FML is open-source and written entirely in VBA.
On 2-dimensional spreadsheets, it's hard to maintain the integrity of complex numerical models such as actuarial models, as those models get cluttered with lots of formulas. By writing your model in Excel VBA using FML, you can build beautifully structured, multi-level, multi-dimensional data models with high transparency. Not only simple batch processing or loop calculations, but also flexible control of dynamic calculations can be achieved. Formula Modeler especially suites actuarial applications, and is accompanied by the standard life insurance library, by which you can quickly calculate insurance premium and reserving rates and build complete actuarial projection models.
To develop a model using Formula Modeler, you can write Formulas in Excel VBA by following simple rules. A Formula here means a set of variables and associated code that operates on the variables, such as mathematical expressions.
To run a model, you create a model by writing a VBA macro and register Formulas to the model . The results can be output to a text file or Excel sheets.
Variables of Formula Modeler can have a multi-dimensional and multi-level hierarchy structure. For a complex model, multiple Formulas can be created, and combined into a model.
Since a model is composed of separable Formulas, one Formula can be shared by multiple models for different purposes, allowing efficient modeling and proper management of the models.
Microsoft Windows XP/Vista/7/8/8.1/10
Microsoft Excel 2000/2003/2007/2010/2013
BSD
Fumito Hamamura