Computational Optimisation and Comparative Structural Analysis of Cantilever Retaining Walls: A Dual-Code Approach Integrating IS 456:2000 and Eurocode 2

Computational Optimisation and Comparative Structural Analysis of Cantilever Retaining Walls: A Dual-Code Approach Integrating IS 456:2000 and Eurocode 2

Mahima Chandrawat

M.E Scholar, Department of Civil Engineering Ujjain Engineering College, Ujjain (M.P.), India

Dr. Umesh Pendharkar

Principal, Ujjain Engineering College Ujjain Engineering College, Ujjain (M.P.), India

Abstract – Traditional methods of designing cantilever retaining walls often involve tedious manual calculations and repetitive drafting, which increase the risk of human error and design inefficiency. This research focuses on a comparative analysis between the Indian Standard (IS 456:2000) and Eurocode 2 (EC2) to evaluate their impact on structural safety and material economy.

To streamline this process, an integrated design tool was developed using an automated Excel spreadsheet linked with AutoCAD. The tool allows for simultaneous calculation of stability factors (overturning, sliding) and reinforcement requirements for both codes based on a single set of input parameters. The study demonstrates a significant reduction in design-to-drafting time by over 93%, with a concurrent 812% optimisation in material consumption when using the Eurocode framework. The findings suggest that while IS 456 follows a more conservative approach with global factors of safety, Eurocodes use of partial safety factors often results in a more optimised and material-efficient design.

Furthermore, the integration of Excel data with AutoCAD through dynamic “Data Linking” ensures that technical reports and schedules are updated in real-time, significantly reducing drafting hours. This study concludes that the synergy between automated spreadsheets and CAD environments not only enhances design productivity but also provides a more reliable framework for comparative structural research in civil engineering.

Keywords IS 456:2000; Eurocode 2; Cantilever Retaining Wall; Spreadsheet Automation; Structural Optimisation; AutoCAD Datalink

1. INTRODUCTION

   Retaining walls are fundamental components in civil engineering, designed to resist the lateral pressure of soil or other materials. Among various types, the Cantilever Retaining Wall is most widely used due to its economic viability for heights up to 67 meters. The stability of these walls is critical, as any failure can lead to significant structural damage and loss of safety.

   In India, structural design is predominantly governed by the IS 456:2000 code. However, with the globalisation of

   engineering practices, Eurocode 2 (EC2) has gained immense importance due to its sophisticated approach toward safety factors and limit state design. Understanding the variations in reinforcement requirements and stability checks between these two codes is essential for optimising construction costs without compromising safety.

   The traditional design process involves complex iterations, especially when checking for sliding, overturning, and bearing capacity. Performing these calculations manually for multiple scenarios is not only time-consuming but also prone to mathematical errors. Furthermore, updating the technical drawings in AutoCAD every time a design parameter changes adds to the projects lead time.

   This research aims to bridge the gap between theoretical design and digital automation. By developing an automated spreadsheet, the study facilitates a side-by-side comparison of IS Code and Eurocode results. The integration of this data with AutoCAD ensures a seamless flow of information, allowing engineers to visualise design changes instantly. The goal is to create a reliable, fast, and accurate system for the modern structural engineer, transitioning from static drafting to dynamic responsive modelling.

2. LITERATURE REVIEW

   The design and stability analysis of cantilever retaining walls have been subjects of extensive research for decades. With the advancement of computational tools, the focus has shifted from manual estimation to automated optimisation and comparative studies between different international design codes. This section reviews the existing literature related to code-based comparisons and the integration of digital tools in structural engineering.

   Comparative studies between Indian Standards (IS) and Eurocodes (EC) have highlighted significant differences in safety philosophy. Sharma and Kumar (2018) [17] conducted a study comparing IS 456:2000 and Eurocode 2 for RCC

   structures, concluding that Eurocodes limit state approach provides a more granular control over material safety compared to the global factors used in Indian standards. Similarly, Patel et al. (2020) [11] analysed retaining walls under both codes and found that Eurocode 2 (Geotechnical design) often results in a more economical base width due to its refined partial safety factors for soil-structure interaction.

   The use of spreadsheets for engineering calculations has been recognised as a highly efficient method for reducing manual errors. Gupta (2019) [07] demonstrated that Excel-based automated tools could reduce design time by up to 70% while maintaining high accuracy in reinforcement detailing. Research by Lee and Smith (2021) [10] further explored the integration of spreadsheets with CAD software, emphasising that “Data Linking” ensures consistency between numerical analysis and final construction drawings, which is often a bottleneck in large-scale projects.

   Optimisation is not just about safety but also material economy. Reddy (2022) [14] focused on the cost-optimisation of cantilever retaining walls and observed that reinforcement percentage varies significantly when transitioning from working stress methods to limit state methods across different codes. The study suggested that automated tools allow for ‘What-if’ analysis, enabling engineers to find the most cost-effective height-to-base ratio quickly.

   While many researchers have compared IS codes with Eurocodes, and others have developed stand-alone calculation sheets, there is limited literature on a unified automated platform that performs simultaneous dual-code analysis and updates AutoCAD drawings in real-time. This research aims to fill this gap by developing an integrated Excel-AutoCAD framework for comparative design and optimisation, maintaining the Integrity of the Specifications

   The template is used to format your paper and style the text. All margins, column widths, line spaces, and text fonts are prescribed; please do not alter them. You may note peculiarities. For example, the head margin in this template measures proportionately more than is customary. This measurement and others are deliberate, using specifications that anticipate your paper as one part of the entire proceedings, and not as an independent document. Please do not revise any of the current designations.

3. METHODOLOGY

   1. Workflow Analysis and Procedural Frameork

      The proposed methodology is structured into a logical sequence of engineering operations, ensuring that the transition from theoretical computation to automated drafting is seamless and validated.

      The workflow (Figure 1) illustrates a closed-loop system where initial design inputs are processed through dual-code engines (IS 456:2000 and Eurocode 2). The workflow depicted outlines the transition from preliminary research to a fully synchronised design environment. It highlights the decision-making loops for manual validation and the automated data-

      exchangeprotocols established between the computational spreadsheet (Brain) and the parametric CAD model (Body).

      This systematic approach minimises human intervention by establishing a direct communication link between numerical spreadsheets and parametric CAD entities, thereby ensuring high fidelity in structural detailing and synchronisation.

      Figure 1 Sequential workflow illustrating the transition from comparative manual analysis to real time digital

      automation

   2. Identification Of Research Gap

      Use The methodology initiated with an extensive review of existing literature and research papers. It was observed that w while many researchers have compared IS codes with Eurocodes, there is a limited unified platform that performs simultaneous dual-code analysis and updates AutoCAD drawings in real-time. This research fills that gap.

      Most designers perform calculations and drafting as two separate, isolated tasks. This identified “Gap” led to the objective of creating a unified, responsive system that links structural analysis directly with CAD environments

   3. Manual Validation and Benchmarking

      Before transitioning to automation, a manual design was performed for a standard cantilever retaining wall of about 4.0m height (Exact 3.6 m).

      • IS 456:2000: Calculations were performed using global factors of safety for overturning (1.55) and sliding (1.5).

      • Eurocode 2: The design was re-evaluated using the Limit State of Equilibrium (EQU) and partial safety factors for soil and concrete.

        Figure 2 Manual calculation as per IS 456:2000

        Figure 3 Manual Calculation as per Eurocode 2

   4. Development of Automated Spreadsheet

      Developing the Excel-based engine was the most complex phase. Each cell was programmed with nested logical functions to ensure accurate results.

      • Logical Framework: The Formulas for the Active Earth Pressure Coefficient (Ka) were integrated using = (1-SIN(RAD))/(1+SIN(RAD)) to handle dynamic angle changes.

      • Structural Optimisation: For reinforcement, the quadratic formula for Ast was converted into an Excel syntax = 0.5 * fck/fy * (1-SQRT (1-(4.6 * Mu) / (fck * b * d^2))) * b * d.

      • Cross code computation: The sheet was designed to trigger two different sets of formulas (IS and EC) simultaneously from a single “Unified Input” dashboard.

        Figure 4 Centralised Input Dashboard in MS Excel, designed for user-friendly interaction and real-time data entry of wall geometry and soil parameters

        Figure 5 Computation engine showing the integration of complex structural formulas within the Excel formula bar for automated stability analysis.

   5. Creating the AutomatedParametric Drawing in AutoCAD

      To transform a static drawing into a responsive model,

      Parametric Constraints were applied.

      • Geometric Constraints: Commands like Auto-Constrain and Fix were used to ensure the wall maintains its shape regardless of dimension changes.

      • Dimensional Parameters: Specific variables such as h, df, B, and T were assigned to the drawing elements. This turned the drawing into an “automated” entity that responds to numerical inputs rather than manual stretching.

        Figure 6 AutoCAD parameters manager interface displaying the synchronisation of dimensional variables with external excel data links for parametric control.

   6. Integration and Real – Time Synchronisation

      The final stage involved linking the Excel “Brain” with the AutoCAD “Body”.

      • Data Link Establishment: Using the DATALINK command, a live bridge was created between the Excel cell ranges and the AutoCAD environment.

      • Dynamic Response: When a user modifies the ‘Wall Height’ or ‘Soil Density’ in the Excel dashboard, the formulas update the output values instantly. Through the FIELD command and PARAMETERS Manager, these values are

   pushed to AutoCAD, causing the drawing to automatically scale or shrink (lengthening/shortening of the wall) in real-time.

   Figure 7 Visualisation of the responsive drawing model

   Figure 8 Comparative visualisation of the responsive drawing model; (Above) Initial wall height at 48.00, (Below) Automatic scaling to 78.00 triggered by real-time Excel input updates.

4. RESULT AND DISCUSSION

   1. Comparative Performance Of Design Codes

      The primary objective of this research was to evaluate the structural outcomes of a cantilever retaining wall under two distinct regulatory frameworks: IS 456:2000 and Eurocode 2. Upon testing a standard about 4.0m (Exact 3.6 m) wall height, the following observations were recorded:

      • Material Economy: The results indicate that Eurocode 2 leads to a more optimised design. For the given case study, the reinforcement requirement (Ast) calculated via Eurocode 2 was approximately 8-12% more economical than the IS 456:2000 results, without compromising structural integrity.

      • Factor of Safety (FOS): It was observed that IS 456:2000 follows a “Global Safety Factor” approach, which is more rigid. In contrast, Eurocodes “Partial Safety Factor” method allows for a more nuanced analysis of loads and material strengths.

      • Stability Parameters: While both codes ensured safety against overturning and sliding, IS 456:2000 provided a higher margin of safety, which, although safer, increases the overall project cost.

   2. Efficiency Gains Through Automation

      The integration of an automated Excel engine significantly transformed the design workflow.

      • Time Reduction: Manual design of a retaining wall, including stability checks and reinforcement detailing for two different codes, typically takes 45 hours for an experienced engineer. The transition to an automated engine yielded a 93.7% reduction in time. Manual design took ~240 minutes, while the automated framework completed it in 15 minutes.

      • Error Mitigation: By automating the nested logical formulas in Excel, the risk of computational slipscommon in manual iterationswas virtually eliminated. The “Unified Input Dashboard” ensured that a single change in soil density or wall height was instantly reflected across both design codes.

   3. Impact of CAD Excel Synchronisations

      The “Robotic” drawing eliminated manual stretching and re-drafting. The technical accuracy was 100% consistent with the calculated values:

      • Dynamic Visualisation: Unlike traditional static drafting, the parametric model responded instantly to numerical changes. This eliminated the need for manual stretching or re-drafting of the wall geometry.

      • Technical Accuracy: The direct link between Excel cells and AutoCAD ‘Fields’ ensured that the dimensions displayed on the drawing were 100% consistent with the calculated values. This “Single Source of Truth” approach prevents the common site error where drawings don’t match the final design calculations.

   4. Discussion: The Future Of Integrated Design

   The results of this study highlight a significant shift from “Drafting” to “Modelling.” The ability of the system to perform a side-by-side comparison of international codes allows engineers to make informed decisionsregarding material choice and cost optimisation. The synergy between the Excel ‘Brain’ and AutoCAD ‘Body’ demonstrates that digital automation is not just about speed, but about enhancing the reliability & efficiency of structural engineering practices.

   Figure 9 Integrated Design Dashboard; showcasing the computational Excel Interface (above) and the resulting comparative performance summary (Below).

   Figure 10 Comparative design summary and stability indicators

   As shown in the table, the transition to Eurocode 2 using the automated tool not only optimised the material consumption but also provided a paradigm shift in design

   productivity. The reduction in calculation time by over 90% highlights the potential of integrated digital workflows in modern structural engineering

   The transition from numerical datasets to graphical visualisation provides a comprehensive understanding of the behavioural differences between IS 456:2000 and Eurocode 2 (EC2). The comparative graphs (Graph 1 to 6) illustrate the impact of varying safety factors and structural philosophies on the stability of the cantilever retaining wall. It is observed that while Eurocode 2 yields a higher effective earth pressure (Ka) and maximum pressure at the toe due to its refined partial safety factors, it simultaneously offers a significant reduction in design and bending moments. This reduction, as highlighted in Graph 3 and 4, suggests a more optimised approach towards material consumption without compromising the core structural integrity.

   Furthermore, the stability analysis regarding the Factor of Safety (FOS) against overturning and sliding demonstrates that both codes maintain a safe design envelope, although IS 456:2000 tends to be more conservative. The graphical representation clearly validates that the automated spreadsheet effectively computes these complex variations, allowing for an immediate visual assessment of code-specific performance. These trends confirm that the integrated digital workflow can accurately predict structural responses, facilitating an informed decision-making process for engineers choosing between international standards.

   The collective evidence from the computational dashboards, comparative tables, and graphical distributions confirms that the integration of digital automation into structural engineering is no longer a luxury, but a necessity for precision. While the study highlights that Eurocode 2 offers a more refined and material-efficient outputspecifically reducing reinforcement requirementsthe IS 456:2000 framework continues to provide a more conservative safety buffer.

   The real success of this methodology, however, lies in the 93.7% reduction in processing time and the total elimination of drafting discrepancies. By bridging the gap between the Excel ‘Brain’ and the AutoCAD ‘Body,’ this project demonstrates a robust, error-free workflow that allows engineers to focus on optimisation rather than repetitive manual tasks. Ultimately, this synchronised approach ensures that every millimetre of the structural drawing is backed by rigorous, code-compliant mathematical validation.

5. CONCLUSION AND SUMMARY

   1. Dual Code Structural Evaluation

      The research successfully executed a comparative analysis between IS 456:2000 and Eurocode 2. It was concluded that while IS 456 provides a more conservative safety margin, Eurocode 2 offers a superior material – optimised design. The study recorded an average 8-10% reduction in reinforcement steel when utilising the Eurocode framework, proving its efficiency in modern structural applications.

   2. Spreadsheet Based Computational Logic

      The development of an automated Excel engine transformed complex structural formulas into a responsive digital dashboard. This eliminated the need for repetitive manual calculations and ensured that nested logical functions (like Active Pressure Coefficient Ka and Ast calculation) are executed with 100% mathematical precision for both codes simultaneously.

   3. Parametric AutoCAD Integration

      By transitioning from static drafting to Parametric CAD Modelling, the project bridged the gap between calculation and visualization. The use of geometric constraints and DATALINK protocols allowed the drawing to function as a “Robotic Entity,” where any change in the Excel ‘Brain’ resulted in an instant, error-free update of the AutoCAD ‘Body.’

   4. Identification of Research Gap and Achievement

      This project addressed a critical Gap in the industrythe isolation of structural design from the drafting process. By achieving a 93.7% gain in engineering productivity, this study proves that manual design cycles of 4-5 hours can be compressed into mere minutes, effectively neutralising the risk of human-induced drafting errors.

   5. Future Scope Of Research

      The framework established in this study provides a foundation for further expansion. Future work can include:

      1. Seismic Integration: Adding earthquake loading parameters as per IS 1893/Eurocode 8.

      2. Multi-Structure Automation: Applying the same parametric logic to counter fort walls, bridge abutments, and pile-foundations.

      3. BIM Transition: Exporting the parametric data into 3D BIM environments for full-scale construction management.

6. ACKNOWLEDGMENT

   The completion of this research work is the result of collective support and technical guidance from several individuals.

   The author expresses profound gratitude to Dr. Umesh Pendharkar for his invaluable mentorship and constant encouragement. His profound expertise in Civil Engineering and rigorous academic critiques was instrumental in shaping the methodology and ensuring the technical depth of this study.

   Special thanks are extended to Er. Hitesh Pathak (M.Tech in Civil Engineering) for his professional insights. His extensive experience in environmental consultancy specifically in the design and implementation of Effluent and Sewage Treatment Plants (ETP/STP) provided a vital practical dimension to the discussions during the development of this framework. His technical perspective and consistent motivation served as a significant pillar of support.

   Lastly, the author acknowledges the patient support and encouragement received from family and colleagues, whose belief in this work was essential through the various stages of this research.

7. REFERENCES

   1. Basheer, A. (2017). Evaluation of safety factors in structural design: A comparison between Indian standards and Eurocodes. Journal of Structural Engineering, 44(2), 112-120.

   2. Bhattacharjee, A., & Mittal, S. (2025). “Comparative Study of IS and Eurocodes for Earth Retaining Structures”, International Journal of Civil Engineering.

   3. Bond, A. J., & Harris, A. J. (2008). Decoding Eurocode 7. London: Taylor & Francis.

   4. Bureau of Indian Standards. (2000). IS 456: Indian standard plain and reinforced concrete – Code of practice. New Delhi, India.

   5. Dhayaratnam, P. (2018). Design of reinforced concrete structures (3rd ed.). Oxford & IBH Publishing Company.

   6. European Committee for Standardization. (2004). EN 1992-1-1 (Eurocode 2): Design of concrete structures. Brussels, Belgium.

   7. Gupta, P. (2019). Excel-Based Automation in Structural Detailing.

      Engineering Digital Tools Report.

   8. Hossain, M. A., & Ahmed, S. (2020). Economic feasibility of retaining walls: A comparative stud of ACI and Eurocode standards. International Journal of Civil and Structural Engineering, 11(4), 45-56.

   9. Kumar, P., & Yadav, B. (2022). Comparative study of design of cantilever retaining wall as per ACI 318 & IS 456. Research Square Preprints.

   10. Lee, J., & Smith, T. (2021). Integration of Parametric CAD and Computational Spreadsheets. CAD/CAM Research Journal.

   11. Patel, S. et al. (2020). Analysis of Retaining Walls under Global and Partial Safety Factors. Journal of Structural Optimization.

   12. Patel, S., & Solanki, H. (2019). Comparative analysis of cantilever retaining wall design using IS code and Eurocode. International Journal of Engineering Research & Technology (IJERT), 8(06), 1024-1030.

   13. Punmia, B. C., Jain, A. K., & Jain, A. K. (2015). Reinforced concrete structures (Vol. 1 & 2). Laxmi Publications.

   14. Reddy, V. (2022). Cost-Optimisation of Cantilever Retaining Walls.

       Structural Engineering Review.

   15. Reddy, V., & Rao, G. V. (2018). Parametric study of cantilever retaining walls under different soil conditions as per IS 456. Journal of Emerging Technologies and Innovative Research (JETIR), 5(8), 211-218.

   16. Reynolds, C. E., & Steedman, J. C. (2007). Reinforced concrete designer’s handbook. CRC Press.

   17. Sharma, A., & Kumar, R. (2018). Comparative Study of IS 456 and Eurocode 2 for Reinforced Concrete Structures. International Journal of Civil Engineering.

   18. Smith, J. (2024). “Parametric Drafting and Automation in Structural Detailing”, Journal of Digital Engineering.

   19. Tiwari, R., & Gupta, M. (2021). Optimization of cantilever retaining wall using genetic algorithm. Structural Engineering Review, 15(2), 88-95.

   20. Vazirani, V. N., & Ratwani, M. M. (2016). Analysis of structures (Vol. 1). Khanna Publishers.

   21. Wight, J. K., & MacGregor, J. G. (2012). Reinforced concrete: Mechanics and design. Pearson Education.

8. BIOGRAPHIES

Mahima Chandrawat is a dedicated civil engineering researcher and professional specializing in structural optimization and digital engineering automation. Her research focuses on the comparative analysis of international design standards and the integration of parametric drafting methodologies to enhance construction efficiency. By bridging the gap between industry practices and academic innovation, she aims to develop streamlined workflows for modern structural design.