Hello,

I have set up a mathematical model of a mechanism in Excel. As I
change an initial angle variable the model changes the coordinate
position of the linkage nodes which then excel graphs.

Is there any way that Excel can simultaneously show the results for a
range of the angle variable without me having to copy all the model for
each required instance?

eg Say that the formula y=2x is set up.Could Excel provide
simultaneous results for
x={1,2,3,4,5,6} from one cell of the formula?


hope this makes sense.

Thanks Steve

Steve -

Perhaps a "one variable data table" would be useful.

Search Excel's Help for more info.

- Mike
http://www.mikemiddleton.com

wrote in message
oups.com...
Hello,

I have set up a mathematical model of a mechanism in Excel. As I
change an initial angle variable the model changes the coordinate
position of the linkage nodes which then excel graphs.

Is there any way that Excel can simultaneously show the results for a
range of the angle variable without me having to copy all the model for
each required instance?

eg Say that the formula y=2x is set up.Could Excel provide
simultaneous results for
x={1,2,3,4,5,6} from one cell of the formula?


hope this makes sense.

Thanks Steve

scorsi,
u made a big sense. I do also like to advance more models yet it is so
laborious using the availed built-in functions......I am trying to gather UDF
by VBE from our noble forum mostly from MVP's and medallist. They are so
helpful, mostly!
Try to taste it in excel programming - but you have to be cautious and slow
when you are writing in english, so you can receive the final result, at
least.
happy holidays
4pinoy

" wrote:

Hello,

I have set up a mathematical model of a mechanism in Excel. As I
change an initial angle variable the model changes the coordinate
position of the linkage nodes which then excel graphs.

Is there any way that Excel can simultaneously show the results for a
range of the angle variable without me having to copy all the model for
each required instance?

eg Say that the formula y=2x is set up.Could Excel provide
simultaneous results for
x={1,2,3,4,5,6} from one cell of the formula?


hope this makes sense.

Thanks Steve