The design of single span fixed-feet portal frames was optimized using MSExcel solver, a multi-disciplinary optimizing ad-in in MSExcel spreadsheet formulated using Generalised Reduced Gradient (GRG2) method of optimization. Portal frames of different geometries with two sets of different loading arrangements were designed using structural design software - PROKON (version W2.0.11) and the resulting design sections were mass-optimized based on the area of member cross section, using Excel solver. In the optimization exercise, the objective function (area of cross section) was minimized subject to the satisfaction of the constraints in accordance with the relevant British Standard. After the optimization process, the portal frame structural members (two vertical members and one horizontal member) for the first set of loading were 21.86%, 19.65% and 27.22% lighter than their initial sections thereby giving an average of 22.91% lighter section, and the second set of loading results show that the optimized sections were 30.31%, 31.27% and 30.29% lighter than their initial sections giving an average of 30.62% lighter section. Keywords : optimization, excel solver, generalised reduced gradient, portal frame.
[1]
Luis Simões,et al.
Optimization of frames with semi-rigid connections
,
1996
.
[2]
Philip E. Gill,et al.
Practical optimization
,
1981
.
[3]
Leon S. Lasdon,et al.
Design and Use of the Microsoft Excel Solver
,
1998,
Interfaces.
[4]
Chinwuba Arum,et al.
Design Optimization of Plate Girder Using Generalized Reduced Gradient and Constrained Artificial Bee Colony Algorithms
,
2012
.
[5]
S. O. Degertekin,et al.
Minimum cost design of steel frames with semi-rigid connections and column bases via genetic optimization
,
2005
.
[6]
K. Deb,et al.
Design of truss-structures for minimum weight using genetic algorithms
,
2001
.
[7]
R. Haftka,et al.
Elements of Structural Optimization
,
1984
.