Hi,

I have an array of variables that is time based (temperature, pressure, %opening etc.). I have a spreadsheet that calculates a result (flow rate) based on these input variables. However, the spreadsheet can only calculate the result based on one set of input variables (for instance, it will calculate the flow based on temperature, pressures etc. at a given time). I want to use the same single spreadsheet to take in sets of variables (one set at a time), calculate the result and paste it against the input variables.

So, if I have a table of time, temperature, pressure and %valve travel, the spreadsheet would calculate the flow and paste it against each set if inputs. The spreadsheet has lengthy calculations and I don't want to repeat them against each set of inputs. See the attached image.

Can anyone help me with this please?

Excel Help.png