Continuous Beam 1.0
Hey Guys, How have you been? Its been while since I last posted.
So, Here's my new Excel Tool for the analysis of a Continuous Beam.
I hope you find it useful.
For this Excel Tool I had to use some VBA codes so you will have to enable macros to proceed.
How to enable macros in Excel?
Goto File>Options>Trust Center>Trust Center Settings
This is what a Trust Center Settings looks like:
Select the option that says Enable all macros. This will enable the macros.
Now that we've enabled the macros in Excel, lets proceed to the Excel Tool.
How to use Excel tool?
Its pretty much similar to the previous tools.
Here's the Input Panel:
How to input data?
1. Length: Just enter the length of the beam in meters.
2. UDL: Enter the Uniformly distributed Load in KN/m from starting point of the UDL to its ending point.
3. UVL: Enter the starting and ending point of the UVL with their values at those points.
4. Point Load: Enter the magnitude of point loads in KN and its position.
5. Section Properties: Enter the Elasticity of the Beam Material and its Moment Of Inertia (MOI).
6. Support Condition: Select support condition (Fixed or Pinned). Enter the values for allowed deflection and rotation in mm and radian.
7. Intermediate Supports: Enter the point where you would like to put an intermediate support. you can enter upto 3 such supports. 0 (zero) means no intermediate support.
After Entering the input data Click on "Solve Continuous Beam" Button. Now have some patience, wait for a while. The result will be displayed in few seconds depending on your computer memory and processor speed.
Here's the result panel:
The graphs for Loading curve, Deflection, Shear Force and Moment will be displayed.
The Reactions, Max.& Min. Values for Shear, Moment and Deflection are also displayed as Output.
Click Here To Download Continuous Beam 1.0
Thanks for reading the post. I hope you liked it. If you did please share.
Suggestions to improve the tools and the blog itself are Welcome.
See you soon in another post.
HAPPY ENGINEERING...!!!
So, Here's my new Excel Tool for the analysis of a Continuous Beam.
I hope you find it useful.
For this Excel Tool I had to use some VBA codes so you will have to enable macros to proceed.
How to enable macros in Excel?
Goto File>Options>Trust Center>Trust Center Settings
This is what a Trust Center Settings looks like:
Select the option that says Enable all macros. This will enable the macros.
Now that we've enabled the macros in Excel, lets proceed to the Excel Tool.
How to use Excel tool?
Its pretty much similar to the previous tools.
Here's the Input Panel:
How to input data?
1. Length: Just enter the length of the beam in meters.
2. UDL: Enter the Uniformly distributed Load in KN/m from starting point of the UDL to its ending point.
3. UVL: Enter the starting and ending point of the UVL with their values at those points.
4. Point Load: Enter the magnitude of point loads in KN and its position.
5. Section Properties: Enter the Elasticity of the Beam Material and its Moment Of Inertia (MOI).
6. Support Condition: Select support condition (Fixed or Pinned). Enter the values for allowed deflection and rotation in mm and radian.
7. Intermediate Supports: Enter the point where you would like to put an intermediate support. you can enter upto 3 such supports. 0 (zero) means no intermediate support.
After Entering the input data Click on "Solve Continuous Beam" Button. Now have some patience, wait for a while. The result will be displayed in few seconds depending on your computer memory and processor speed.
Here's the result panel:
The graphs for Loading curve, Deflection, Shear Force and Moment will be displayed.
The Reactions, Max.& Min. Values for Shear, Moment and Deflection are also displayed as Output.
Click Here To Download Continuous Beam 1.0
Thanks for reading the post. I hope you liked it. If you did please share.
Suggestions to improve the tools and the blog itself are Welcome.
See you soon in another post.
HAPPY ENGINEERING...!!!
Comments
Post a Comment