The principle of operation is easy. First, the user builds an arbitrary model by means of Microsoft Excel — i.e. put formulae into spreadsheet cells that show the dependencies between parameters and resulting values, writes data into certain “input” cells and reads results from certain “output” cells. It is a sealed calculation model. With this approach it is necessary to reenter parameter values every time a different model should be simulated. But how to force Microsoft Excel to calculate the model iteratively for different sets of input parameters without boring manual data input? It is quite easy!...

Run the ExcelExt! and select an appropriate XLS file. Define criteria to specify input/resulting cells. For example, such cells may be named, emphasized by italic or bold type, underlined, coloured, etc. The program analyzes the workbook and forms two lists of “candidate” cells: input parameters containing numerical constant values and results containing formula, i.e. computable cells. Then you may choose parameters of interest and assign their variation ranges (“from-to-step” triads); choose the resulting cells and — that is all. The program is ready to start the model simulation, i.e. vary the parameters, poke the values at the corresponding cells, activate the workbook calculation, peek the resulting cells.

After tens, hundreds, thousands cycles (calculated automatically without any keystroke) it becomes possible to visualize the dependence between the resulting values and parameters. Moreover, one may export the tabular data for optimization analysis to text files or Excel workbooks.

Download: coming soon...