Register to reply 
Cantilever spreadsheet for dummies 
Share this thread: 
#1
Jan3014, 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 


#2
Feb214, 04:21 PM

Emeritus
Sci Advisor
HW Helper
Thanks
PF Gold
P: 6,331

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 


#3
Feb714, 11:08 AM

Sci Advisor
HW Helper
P: 2,122

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. 


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 