48221: Engineering Computations - Basic Programming - IT Assignment Help

Assignment Task:

STAGE 2: VISUAL BASIC (BASIC PROGRAMMING) (40 marks)

Congratulations to you and your group for successfully completing Stage 1 of the group project. However, your client soon came to realise that they want to continue the development work to create a powerful and sophisticated Excel spreadsheet utilising VBA programing and Userforms to accommodate the spreadsheet’s complicated and flexible configurations, allowing them to calculate the deflection and bending moment of a simply supported beam and a cantilever beam.

As 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 WorksheetFunction in VBA.

STAGE 2 – PART 1 

As a group of engineers with basic Visual Basic skills, you are asked to provide your client with a user-friendly macro-enabled Excel spreadsheet that can be used to calculate the deflection and bending moment of a simply supported beam and a cantilever beam. The spreadsheet will provide a user-friendly interface to allow the client to: 

1. define the type of beam (i.e. a simply supported beam or a cantilever beam);

2. define cross sectional properties of a given beam structure;

3. define structural parameters and materials. e.g. a main page will allow for a user friendly interface that lists all the individual regular shapes that form a complex shape with options to add more regular shapes to the composition via a button etc. This could lead to another interface that will allow the client to define the parameters of each individual shape (preferably in another sheet). Once the parameters are entered the client will be returned to the main sheet where the details of the newly defined shape will automatically be added to the list of shapes.

Once the entire cross-section has been defined, the Excel spreadsheet will calculate the overall second moment of inertia via a button.

Challenges (Optional):

• 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.

STAGE 2 – PART 2 (Maximum Bending Moment and Deflection) 

Similar to Stage 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 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, Excel will automatically compute and present the results of the beam’s deflection and bending moment.

This 48221: IT Assignment has been solved by our IT Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.