Skip to main content
L
ldante11-Garnet
11-Garnet
May 15, 2017
Solved

satisfying all conditions

  • May 15, 2017
  • 4 replies
  • 2583 views

Hi,

May I ask some help to improve my spreadsheet that will satisfy all conditions. Sometime the  utilization  of the bending moment is greater than 1 from  my initial profile selections. I need to have a profile that are adequate  in the design from the selections of the profile I attached .  Here is the Mathcad file  and read Exel file for your reference . Thank you..

Best answer by Werner_E

If you want to loop through a worksheet until a certain condition is met you will have to turn the whole worksheet (the calculation of the bending force) into a function - manually.

Otherwise a worksheet is linear - top down and finished.

4 replies

W
Werner_E25-Diamond I
25-Diamond I
May 15, 2017

Its not clear to me what you want Mathcad to do when one of those values is greater than 1.

L
ldante11-GarnetAuthor
11-Garnet
May 15, 2017

1st  condition I selected a profiles from the deflection criteria of L/175,L/240+6.4 and L/240.

2nd condition  I  checked  the capacity of the bending  moment using the selected profile.

Sometimes the selected profile are not sufficient  . I need another  condition that will increase the profile to satisfy  the 2nd condition

W
Werner_E25-Diamond IAnswer
25-Diamond I
May 15, 2017

If you want to loop through a worksheet until a certain condition is met you will have to turn the whole worksheet (the calculation of the bending force) into a function - manually.

Otherwise a worksheet is linear - top down and finished.

Terms & ConditionsAccessibility statement