I have modified my spreadsheet (copy attached), and it is now much more stable, working with a wide range of relative beam lengths and beam EI values. The procedure used is now:
Assuming two beams, the top one shorter than the bottom, arranged symmetrically about mid-span, with the top beam subject to a UDL of its full length.
- Check if the beams contact at mid-span. If they do not, or if it is a point contact, find the moments in both beams from statics. If they do contact over a finite length:
- Find the total moment at mid-span from statics
- Distribute this moment in proportion to the beams EI values.
- Assume some contact length, symmetrical about mid-span.
= Starting from the mid-span moments, find the moments in both beams at the start of the contact length
- Calculate the point force transfer at the start of the upper beam required for static equilibrium with the calculated moments.
- Find the point force transfer at the start of the contact length required for overall static equilibrium.
- Apply these loads to both beams assuming point contact of the ends of the upper beam on the lower beam. Calculate the difference in deflection at mid span, relative to the ends of the upper beam.
- Adjust the contact length until the difference in deflection is zero.
I have set up the spreadsheet to use the solver, but if you don't have that activated you can also use the goal-seek function. You need to make cell L13 equal to zero by adjusting cell L2.
The spreadsheet works on the assumptions listed above, but it will work with any UDL, any ratio of beam lengths up to 1:1, and any finite ratio of EI values.
Using this spreadsheet with a range of values supports what I have said previously; assuming both beams have finite EI, and the top beam is shorter than the bottom:
- If the top beam has an EI greater than some limiting value then it will span between contact points at its ends, with no other contact.
- For any non-zero EI lower than this value there will also be contact over some length, symmetrical about the mid-point of the beams.
- The contact zone will increase in length as the upper beam EI reduces, but it will never extend over the full length.
- The pressure distribution over the contact length will be a fixed proportion of the applied UDL, such that the shear force in the beams is in the same ratio as their EI values.
- In addition there will be a point force transfer at the ends of the contact zone to maintain static equilibrium.
The graphs below show deflections and factored bending moments for a 10 m lower beam, 5 m upper beam, with a range of relative EI values (lower/upper = 5, 50, and 500).
Doug Jenkins
Interactive Design Services