ChaosHunter Runtime Excel Add-In FireModel Function
|Top Previous Next|
Prior to using the ChaosHunter Runtime FireModel function in Microsoft Excel, you need to load the Add-In into Excel.
Next, open the spreadsheet which contains the input values in Excel. Click on a blank cell beside the input values and call the FireModel macro function as described below.
Microsoft Excel Spreadsheet Syntax:
= ChoasHunter_Runtime.XLA!FireModel(range, [modelpath], [SkipMissingInputValuesFlag])
The FireModel macro function syntax includes the following parts:
The FireModel function use just one row of data at a time to generate the formula output. It does not use column labels to identify cells to be picked up as formula inputs. Therefore, the selected range must represent a contiguous set of cells that represent all the inputs in the formula in the order they appeared during optimization.
For example, when optimizing a formula in ChaosHunter, you have selected 5 potential inputs in the data file:
After ChaosHunter optimization has finished, the resulting formula looks like:
Predicted = (Input2 + Input5) * 0.25
Thus, the formula uses only two inputs, Input2 and Input5. The FireModel formula in this case expects a 2-cell contiguous range, for example:
where cell B2 contains Input2 value, and cell C2 contains Input5 value.