Beams may kiss, but do not hug …

… not full length anyway.

This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a load to the top beam.  How do the beams deflect, and how is the load shared between the beams, or does the top beam make no difference, since all of the load must go through the lower beam, before it reaches the support?

To keep things (relatively) simple, I will consider here a 10 metre long beam with a shorter beam placed symmetrically about the centre line, with a uniform distributed load over the full length of the upper beam.  If the upper beam is sufficiently stiff it will simply span across the centre of the lower beam, transferring the applied loads as point loads at its ends.  More interesting is what happens if the top beam stiffness is reduced so that it touches the lower beam in the middle, as well as both ends.

I have analysed this situation using the SSSPanU function from the ConBeamU spreadsheet.  A modified version of ConBeamU including the analysis described here can be downloaded from ConBeamU-2Beams.zip.

The procedure used in the analysis is:

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.

The spreadsheet allows this procedure to be carried out quickly, using the Excel Solver.

The beam lengths, EI of the lower beam, and relative stiffness factor of the two beams (EI Lower / EI Upper) are entered:

Stacked Beams2-0-1
The spreadsheet calculates the point load transfer at the ends of the upper beam, and the ends of the contact zone, specified in cell L2:
Stacked Beams2-0-2
These values are transferred to the input data for two copies of the SSSPanU  function:
Stacked Beams2-0-3
The functions calculate the moments, shears, slope and deflection along both beams.  The Excel solver can be used to automatically adjust the start of the contact zone dimension so that the gap between the two beams at mid span is zero:
Stacked Beams2-0-4
Typical results are shown below, plotted from the left support of the lower beam to mid-span.  The green line in the left hand graph is the gap between the two beams (right hand scale).  Note that the gap is zero over the contact zone, increases to a maximum, then returns to zero for a point contact at the end of the upper beam.  In the moment diagram the upper beam moments (red line) are factored by the beam stiffness ratio.  Note that the factored moments of the two beams are exactly equal over the contact zone, because the curvatures of the two beams are equal over this length.
Stacked Beams2-1
Reducing the stiffness of the top beam increases the contact length, but the moments and gaps follow the same form.
Stacked Beams2-2
Even reducing the top beam EI to 1/500 that of the lower beam, the contact length does not extend to the top of the upper beam.
Stacked Beams2-3
These graphs show a comparison of the spreadsheet results with a finite element analysis using Strand7, with the beams connected by short contact elements with zero friction and zero tensile strength.  The FEA results agree very closely with the spreadsheet analysis.
Stacked Beams2-4

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA | Tagged , , , , , , , | Leave a comment

Links on Lists, and other things.

Daily Dose of Excel recently had a post on interacting with List Objects from VBA.  Since I make very little use of Lists (or Tables as they are now known in Excel, but not VBA), I thought I’d have a search for more information.  There doesn’t seem to be a huge amount of information available, but a good starting point would be:

Working with Tables in Excel 2013, 2010 and 2007 (VBA) from Jan-Karel Pieterse.

See also the first comment below from Winston Snyder, with 6 more List related links.

Other useful links gleaned from DDoE:

EXCELXOR is a relatively new Excel blog with excellent content:

If you’re looking for articles relating to advanced, formula-based Excel solutions then you’ve come to the right place.

Please visit my blog to see a whole host of innovative techniques developed using worksheet formulas alone. These techniques – accompanied by detailed and instructive explanations of their workings – are not only of theoretical interest to the reader wishing to explore the possibilities of what can be achieved in this field, but also offer practical solutions to a plethora of everyday issues which the average Excel user may encounter.

Excellerando has been going for some time.  Not a huge turnover, but over the years it has built up an excellent library of VBA code advice and examples.

Finally another Alfred Vachris link:

VBA Projects by Mark Kubiszyn

Welcome to my blog. This is all about imparting knowledge. I want to share some of the insight and learnings from six years of developing in VBA for Excel. I also want to cover off some innovative techniques, coding best practices and share some of my development Tools & Reports.

Please feel free to download and share my work – you can use the Code and techniques to develop your own VBA Projects. To send me a message, you can contact me on my Homepage

Posted in Computing - general, Excel, VBA | Tagged , , , , | 2 Comments

Simpson’s Donkey

Simpson and his Donkey.

John Simpson Kirkpatrick

Posted in Bach | Tagged , , , | 2 Comments

Smart Indenter and Excel 2013

I have recently installed Office 365 on a new computer running Windows 8.1 (actually the third one in just over a month, but that’s another story).  Office 2013 has several annoying features, but for me the most annoying was that the VBA smart indenter add-in from Office Automation did not work.  The web-site only mentions Excel versions up to 2003, but it was working with no problems with Office 365 and Excel 2013 on my last Windows 7 computer, and a search suggests that it should work with Windows 8 and 32 bit versions of Office 2013, but on my machine it doesn’t.

My solution to this problem was to install the alternative smart indenter from Andrew Engwirda.  This works on my system with no problems (after reading the installation instructions, you need to enable “Trust access to the VBA project object model” ), and will also work with 64 bit versions of Office.

If anyone else has had a problem with the original code indenter and 32 bit Office, I’d be glad to hear from you, especially if you found a way to make it work, but in the meantime Andrew’s alternative code works just fine.

Posted in Computing - general, Excel, VBA | Tagged , , , , , | 26 Comments

Finding Excel Version Information

The information below was buried in an old post, but I had trouble finding it when I wanted it, so here it is in its own post:

Finding the version information in Office used to be easy; it was always under Help-About, but Microsoft has apparently decided that this information might frighten the uninformed, so they have decided to hide it:

  • In Excel 2010 it is under File-Help
  • In Excel 2013 it is under File-Account-About Excel
Posted in Computing - general, Excel | Tagged , , | 1 Comment