Hey Guys,

Since this is the second time I thought: "Wouldn't it be handy if.." I
am now asking the pro's. :)

For stress analysis of a tube frame, Excel is handy because after the
initial sin/cos/tan type formulas, you can see the forces and peaks
change with different dimensions of the frame. However, if this frame
is a 'mechanic' that changes position, for example the tipping
mechanism of a truck, there is an added variable: the angle of the
tipping.

If I want to make this graphic in Excel, and want to accurately see how
the forces react from 0degs to 90degs tipping, I have to copy/paste the
(very complex and big) calculation cells 90 times, each time changing
the angle variable +1. It works, but is very tedious.

I just want one calculation that calculates an initial position, with
Excel being able to make a graph of the outcome with the initial
position +1 on the horizontal scale.

Would this be possible?

Thanks!
Niels Heusinkveld


--
niels007
------------------------------------------------------------------------
niels007's Profile: http://www.excelforum.com/member.php...fo&userid=4451
View this thread: http://www.excelforum.com/showthread...hreadid=384647