Model Output into a Table

[nhbcai]

I have created a two input variable/one output variable model in an Excel Spreadsheet.

What I would like to do is use this model to output a table of data using a range of input values for each of the two inputs.

Is there some way I can automate the creation of such a table?

 

[Ruddles]

Are you asking (a) how to create the table of input values or (b) how to process them through the model?

If (a) then I think we need more information about what the permissible values are and how they should be combined.

If (b) then you need to use VBA to place the values into your model one set at a time, wait for the model to finish calculating the output for that set of inputs, then copy the output into a table of outputs. The code would be dependent on where the input and output tables are and where the model's input and output cells are.

One other thing which you might consider if you've not already thought of it is: rather than build model in the worksheet using Excel formulae and drive the generation of the output table using VBA, you could code the model in VBA as a UDF (user-defined function) and then call it from your worksheet as the third column of your table (the other two columns being your input values).