Skip to main content
D
dm-31-Visitor
1-Visitor
May 7, 2012
Solved

Using Functions

  • May 7, 2012
  • 1 reply
  • 2244 views

Hi,

I have a calculation sheet and the requirement is we need to know, when we input 3(positive) variables, how we can provide the auto loop in the calculation to check for different possible load cases, for example, we have three loads acts in positive direction and which results some reaction load at its support points and with this there will be eight possible cases of loading with deferent direction. Our requirement is to determine worst possible reaction load out of this eight cases with providing input variables in one case i.e Fx=+100kN Fy=50kN and Fz=150kN. I have attached an Example file for your start up

--

Dhinesh

Best answer by StuartBruff

Dhinesh wrote:

Stuart,

Yes its similar to what you did but I have 8 combinations like mentioned below.

Fx Fy Fz

150 50 150

150 50 -150

150 -50 -150

-150 -50 -150

-150 -50 150

-150 50 150

150 -50 150

-150 50 150

Just set F.x to 150 kN and change the step sizes (dx,dy,dz) to twice the given values.

Stuart

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
May 7, 2012
I have a calculation sheet and the requirement is we need to know, when we input 3(positive) variables, how we can provide the auto loop in the calculation to check for different possible load cases, for example, we have three loads acts in positive direction and which results some reaction load at its support points and with this there will be eight possible cases of loading with deferent direction. Our requirement is to determine worst possible reaction load out of this eight cases with providing input variables in one case i.e Fx=+100kN Fy=50kN and Fz=150kN. I have attached an Example file for your start up

Do you mean something like the attached?

Stuart

D
dm-31-VisitorAuthor
1-Visitor
May 7, 2012

Stuart,

Yes its similar to what you did but I have 8 combinations like mentioned below.

Fx Fy Fz

150 50 150

150 50 -150

150 -50 -150

-150 -50 -150

-150 -50 150

-150 50 150

150 -50 150

-150 50 150

S
StuartBruff23-Emerald VAnswer
23-Emerald V
May 7, 2012

Dhinesh wrote:

Stuart,

Yes its similar to what you did but I have 8 combinations like mentioned below.

Fx Fy Fz

150 50 150

150 50 -150

150 -50 -150

-150 -50 -150

-150 -50 150

-150 50 150

150 -50 150

-150 50 150

Just set F.x to 150 kN and change the step sizes (dx,dy,dz) to twice the given values.

Stuart

Terms & ConditionsAccessibility statement