As a group of engineers with basic Visual Basic skills, you areasked to provide your client with a user-friendly macro-enabledExcel spreadsheet that can be used to calculate the deflection andbending moment of a simply supported beam and a cantilever beam.The spreadsheet will provide a user-friendly interface to allow theclient to: i) define the type of beam (i.e. a simply supported beamor a cantilever beam); ii) define cross sectional properties of agiven beam structure; iii) define structural parameters andmaterials. e.g. a main page will allow for a user friendlyinterface that lists all the individual regular shapes that form acomplex shape with options to add more regular shapes to thecomposition via a button etc. This could lead to another interfacethat will allow the client to define the parameters of eachindividual shape (preferably in another sheet). Once the parametersare entered the client will be returned to the main sheet where thedetails of the newly defined shape will automatically be added tothe list of shapes. Once the entire cross-section has been defined,the Excel spreadsheet will calculate the overall second moment ofinertia via a button. Challenges (Optional): • An image willautomatically be produced when the various shapes are added. • Morethan one material can be added to the shape in this Excel sheet.STAGE 2 – PART 2 (Maximum Bending Moment and Deflection) Similar toStage 1 of the group project, this part builds on the informationobtained from part 1. Your clients are bridge engineers who want tocalculate the deflection and bending moment of their beams. Abutton on the main page will allow the users to open a newinterface to define the load and properties of the beam so thatthey can calculate the deflection and bending moment of the beam.The user will be given the option to choose any of the followingload configurations on the beam. • Concentrated point load •Uniformly distributed load • Uniformly varying load Once all thisinformation is entered, Excel will automatically compute andpresent the results of the beam’s deflection and bending moment.Hint: Formulae for simply supported beam and cantilever beam can befound online. Challenge (Optional): Plot the shear force diagramand the bending moment diagram. STAGE 2 – PART 3 (Report) Once thecross section and the maximum bending moment and deflection of beamhave been defined, the user will be given the choice to press abutton to automatically generate an A4 printable report based onthe input and calculations produced in this Excel sheet. Thisreport will summarise the parameters that the user has put intoExcel and display the results in a way that is simple for theclient to interpret.