Completed

Excel VBA, deflection and bending moment of a fixed-fixed beam.

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

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.

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

Skills: Excel VBA, Civil Engineering

See more: excel vba create menubar, create xml excel vba, create xml file excel vba, create multiuser excel vba, excel vba xml create xml document, create graph save file excel vba, excel vba create data file, create data files excel vba, excel vba create expense report, create domain class excel vba code, forms create excel vba, excel vba create classes dynamically, excel vba create reference

About the Employer:
( 0 reviews ) South Granville, Australia

Project ID: #30107560

Awarded to:

(0 Reviews)
0.0

9 freelancers are bidding on average $241 for this job

(6 Reviews)
3.6
Sulaiman94

Hi I am a structural engineer and I am skilled in designing buildings and houses. I am also skilled in Excel and VBA marcos. I can prepare the beam analysis excel sheet through VBA as you require. If you are interested More

$250 AUD in 10 days
(5 Reviews)
3.5
(2 Reviews)
2.5
borispetrovfrl

Hello, Sir. Expert of Excel VBA is here. I already have been doing the similar this project. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such a More

$200 AUD in 3 days
(3 Reviews)
2.2
tomjeniffer56

MASTERS IN Civil Engineering EXPERT IN Excel VBA Hi Employer? I have pursued the directions distinctly and perceived your details for the undertaking. I have vast insight in this field as my field of specialization. My More

$250 AUD in 1 day
(0 Reviews)
0.0
kuriaevans17

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

$300 AUD in 7 days
(0 Reviews)
0.0
utkarshkhadka

Experienced civil engineer. Structural Analysis is field of my study. Accuracy, Speed and Diligence is my quality. Don't worry. Mission accomplished!

$99 AUD in 7 days
(0 Reviews)
0.0
darung

Hello. I have just read your job description carefully and I understood your requirement fully. I am working in this field for 7+ [login to view URL] I've made good success and many good companies. I can start immediately and wil More

$150 AUD in 2 days
(0 Reviews)
0.0