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
Bookmarks