Steel Gable Frame Optimization with Excel Solver

Modeling 16 prismatic sections and Optimizing a steel gable frame using Excel Solver involves creating a model that minimizes or maximizes an objective function, such as weight or cost, while satisfying various constraints like stress limits, deflection limits, and geometric constraints.
Here's a general outline of the process:
Define the Objective Function: This could be the total weight of the frame, which you want to minimize.
Set Up Constraints: These include:
Stress constraints to ensure the frame can handle the loads without yielding.
Deflection constraints to ensure the frame does not deflect excessively.
Geometric constraints to maintain the structural integrity and design requirements.
Input Data: This includes material properties, load conditions, and initial dimensions of the frame members.
Solver Setup: Use Excel Solver to define the objective function, decision variables (e.g., dimensions of the frame members), and constraints.
Run Solver: Let Solver find the optimal solution that minimizes the objective function while satisfying all constraints.

#civilengineering
#structuralengineering
#finiteelement
#steelframe
#optimization
#Excelslover
#excel
#ghashghaei
#qashqai
#industrialshed
#industrialstructure
#steelframe
#قشقایی

بهینه یابی مقطع سازه سوله فلزی در اکسل

Download Content Link:
https://github.com/salardelavar/SALAR...
https://www.dropbox.com/s/ceezuj58oby...


Personal Web Site:
http://salardqashqai.blogfa.com/