In the past, many studies have been conducted on the optimization of reinforced concrete (RC) structures. These studies have demonstrated the effectiveness of different optimization techniques to obtain an economical design. However, the use of optimization techniques to an obtain economical design is not so practical due to the difficulty in applying most of the optimization techniques to achieve an optimal solution. The RC beam is one of the most common structural elements encountered by a practising design engineer. The current study is designed to highlight the potential of the Solver tool in MS Excel as an easy-to-use option for optimizing the design of simply supported RC beams. A user-friendly interface was developed in a spreadsheet in which beam design parameters from a typical design can be entered and an economical design can be obtained using the Evolutionary Algorithm available in the MS Excel Solver tool. To demonstrate the effectiveness of the developed optimization tool, three examples obtained from the literature have been optimized. The results showed that up to 24% economical solution can be obtained by keeping the same material strengths that were assumed in the original design. However, if material strength is also considered as a variable, up to 44% of the economical solution can be obtained. A parametric study was also conducted to investigate the effect of different design variables on the economical design of simply supported RC beams and to derive useful rules of thumb for their design and proportioning, with the objective of cost minimization. The results of the parametric study suggest that the grade of the reinforcing steel is one of the most influential factors that affect the cost of simply supported RC beams. Practicing engineers can use the trends derived from this research to further refine their optimal designs.
Keywords: Evolutionary Algorithm; optimization techniques; optimization tool; optimum design; reinforced concrete beam; spreadsheet optimization.