Formulae for Beam Deflection Calculations - Management Assignment Help

Assignment Task:

Task:

STAGE 1: EXCEL (30 marks)

You are required to create an Excel sheet that will allow a user to calculate the deflection of a simply supported beam based on the inputs given by the user. Formulae for beam deflection calculations can be found online, no prior knowledge of mechanics of solid required.

For Stage 1 is an individual submission for all students.

STAGE 1 – PART 1

The initial part will require your Excel sheet to calculate of the cross sectional properties (i.e. Centroid, 2^nd moment of area) of a beam based its sectional information (dimensions and shapes) and inputs from a user. The user interface will allow the user to choose a type of cross sectional shape from a cell (it has a drop down menu). Cross sectional shapes must include circle, rectangle, and tube. In addition, I-section beam, T-section beam and more can be considered.

Once all the parameters of the cross section properties are entered, Excel will automatically calculate all cross sectional properties including Centroid and 2^nd moment of area, which will be used for the 2^nd part of this assignment.

STAGE 1 – PART 2

This part will require your Excel sheet to assign material attribute to the beam. The user interface will allow the user to choose a type of material from a cell (it also has a drop down menu). Examples should include steel and concrete. Other user defined materials can be considered as well. The material properties include density of material, modulus of elasticity, etc.

STAGE 1 – PART 3

This part of the assignment builds on the information obtained from part 1 and part 2. The user will be given the option to choose the load configuration including:

• Uniformly distributed load
• Point load at any given location

The user will also be able to define the length of the beam and loading position through Excel. Once all this information is entered, Excel will automatically compute the deflection along the simply supported beam and present the results of the beam’s deflection.

Hint: Formulae for beam deflection is available online http://home.eng.iastate.edu/~shermanp/STAT447/STAT%20Articles/Beam_Deflection_Formulae.pdf. 

Marking Criteria

This Management Assignment has been solved by our Management 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.