Create a powerful and sophisticated Excel spreadsheet utilising VBA programming and Userforms to accommodate the spreadsheet’s complicated and flexible configurations, allowing them to calculate the deflection and bending moment of a fixed-fixed [login to view URL] the client now wants more features from the spreadsheet, in addition, to enhance the user interface, you must use both VBA and Userforms (You cannot do calculations on the spreadsheets, i.e. Calculations done within cells). Note, you can use Worksheet Function in VBA.
user-friendly macro-enabled Excel spreadsheet that can be used to calculate the deflection and bending moment of a fixed-fixed beam. The spreadsheet will provide a user-friendly interface to allow the client to:
i)define the type of beam: fixed-fixed beam. Other types of beam structures such as cantilever and simply supported beams will be added under the innovation criterion.
ii)define cross-sectional properties of a given beam structure: for example, rectangular, triangle, round hollow tube, circular, I-section, T-section, triangle, et al
iii)define a complex cross-sectional shape. e.g. combining multiple standard cross-section shapes in part ii) to create new cross-section with the corresponding second moment of inertia and centroid.
iv)Select from standard material parameters or define their own material parameters (modulus of elasticity, density, Poisson’s ratio)Once the entire cross-section has been defined, the Excel spreadsheet will calculate the overall second moment of inertia via a button
•An image will automatically be produced when the various shapes are added.
•More than one material can be added to the shape in this Excel sheet.
PART 2 (Maximum Bending Moment and Deflection)
Similar to part 1 of the group project, this part builds on the information obtained from part 1. Your clients are bridge engineers who want to calculate the maximum deflection and bending moment of their beams. A button on the main page will allow the users to open a new interface to define the load and properties of the beam so that they can calculate the deflection and bending moment of the beam. The user will be given the option to choose any of the following load configurations on the beam.
•Concentrated point load
•Uniformly distributed load
•Uniformly varying load
Once all this information is entered, the Userform program will automatically compute and present the results of the beam’s deflection and bending moment.
Hint: Formulae for fixed-fixed beam and cantilever beam can be found online.
Project 2 – PART 3 (Generate Report)
Once the cross-section and the maximum bending moment and deflection of the beam have been defined, the user will be given a choice to press a button to automatically generate and save an A4 printable report (PDF) based on the input and calculations produced in this Excel sheet. This report will summarise the parameters that the user has put into Excel and display the results in a simple way for the client to interpret
9 freelancers are bidding on average $241 for this job
Experienced in Civil Engineering Expert in Excel VBA Hi employer? I have read your instructions keenly and fit to deliver. Kindly chat with me to discuss further details. Thank-you