Create a data table by varying inputs

[umtemplt]

I'm using a spreadsheet with multiple inputs and multiple outputs. I would like to vary one of the inputs ( i.e. overall length) with a range of values and tabulate a single output (i.e. pressure drop, or heat transfered) into a data table so I can create a graph to identify trends. The output may be connected to many cells, which may contain formulas as well.

I haven't set up my spreadsheet so I can just fill values down. Any ideas?

[ron2k_1]

Dude you presented no guidance at all to give you any functions or data re-arrangement as you did not included any sample of your data and desired output.

Welcome to the forum, please take some time and give us a dummy sheet explaining clearly your situation and showing us one or two samples of your desired result.

Enjoy the forum

[umtemplt]

Dude you presented no guidance at all to give you any functions or data re-arrangement as you did not included any sample of your data and desired output.

Welcome to the forum, please take some time and give us a dummy sheet explaining clearly your situation and showing us one or two samples of your desired result.

Enjoy the forum

I see your point.

I have a list of about 90 variables for a design I'm working on. Some are directly inputed, some are calculated based on inputs, some use lookup functions to linearly interpolate values from data tables on other sheets.

I have been using "goal seek" in the "what if analysis" to change some of my input values to get a desired output value. I'm wondering if I can do something similar but log all the values it iterates so I can graph it, in order to spot trends. I tried the "data tables" but from my understanding you can only have one or two inputs and my spreadsheet uses much more.

In the end I would like to have a column of input values put into a cell in my spread sheet and have it place the corresponding output values from a different cell and place them in the adjacent column.

Is this enough information? Clear as mud?