satisfying all conditions

[ldante]

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..

[Werner_E]

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

[ldante]

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

[Werner_E · Accepted solution]

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.

[ldante]

Hi,

This works , thanks