Cantilever spreadsheet for dummies


by Dingomack
Tags: cantilever, dummies, spreadsheet
Dingomack
Dingomack is offline
#1
Jan30-14, 04:38 PM
P: 3
Any (ideal) beam of length L, bent with a deflection of δ will have the same parabolic curve.

If that underlying assumption is wrong I am in trouble...

(Lots of views on the other thread, but no posts...so I'll try and boil it down to its essence)

Imagine:
Cantilever beam of length L with a concentrated load at the free end producing a curve. Draw a chord on the curve and you have an aerofoil with a width that varies along it's length - narrow at the ends and fatter near the middle. Lets call the widest point the maximum camber (Cmax).

I need to produce an excel spreadsheet where I can input a desired Cmax and a beam length L and output the required deflection of the beam, all in millimeters.

To help me get there I think I need equations for the following:

Q1. Calculate Cmax as a percentage of the chord length,
Q2. At what distance from the fixed end of the beam does the Cmax occur? If my first assumtion is correct - this should be a constant.
Q3. For a given Cmax and beam length L what is the deflection required.

I am not ignoring specific E (modulus of elasticity). The beam that is used will be made of all sorts of different materials, but if my assumption holds, then it is irrelevant.

A background of why I want to do this can be found on the:
Making an aerofoil with a cantilever thread.

Thanks in advance
Phys.Org News Partner Engineering news on Phys.org
Lifting the brakes on fuel efficiency
PsiKick's batteryless sensors poised for coming 'Internet of things'
Researcher launches successful tech start-up to help the blind
SteamKing
SteamKing is offline
#2
Feb2-14, 04:21 PM
HW Helper
Thanks
P: 5,542
I don't understand all of what you desire from the OP, but this table gives formulas to calculate the deflection of a cantilever beam under different types of loading:

http://www.advancepipeliner.com/Reso...n_Formulae.pdf
nvn
nvn is offline
#3
Feb7-14, 11:08 AM
Sci Advisor
HW Helper
P: 2,110
Quote Quote by Dingomack View Post
Any (ideal) [prismatic cantilever] beam of length L, bent with a deflection of delta, will have the same parabolic [cubic] curve.
Dingomack: True, only if the type of applied loading is the same; i.e., in your case, only if there is a concentrated load (P) at the cantilever free end.

Quote Quote by Dingomack View Post
Q2. At what distance from the fixed end of the beam does the Cmax occur? If my first assumption is correct, this should be a constant.
My following answer applies if the cantilever deflection at the free end (y1max) does not exceed 10 % of the cantilever length (L). Cmax occurs at 42.265 % of L, measured from the fixed end; i.e., Cmax occurs at x = 0.42265*L.

If y1max exceeds 10 % of L, Cmax might still occur at 42.265 % of L, but I currently do not know if it does or not, because I have not checked that case.

Quote Quote by Dingomack View Post
Q3. For a given Cmax and beam length L, what is the deflection required?
What do you mean by "required"? Did you instead mean, "What is the deflection"? Which deflection? Deflection where, at what point?

Quote Quote by Dingomack View Post
I need to produce an excel spreadsheet where I can input a desired Cmax and a beam length L, and output the required deflection of the beam, all in millimeters.
What do you mean by "required deflection"?


Register to reply

Related Discussions
Spreadsheet Software Math & Science Software 1
Need help with OO Spreadsheet Computers 2
Making a spreadsheet Introductory Physics Homework 8
Help with 3D matrix, 3D spreadsheet. Programming & Computer Science 4
Spreadsheet and HP 50g Calculators 1