Buckling of columns with varying cross section

Following a post in the Eng-Tips Forum about finding the buckling load of a stepped strut I have modified the Frame4 spreadsheet to carry out a buckling analysis of any straight member subject to axial load, including stepped or tapered cross sections.  The spreadsheet, including full open source code, may be downloaded from: Frame4Buckle.zip 

The buckling load is found using the method of Vianello, described in a paper from the University of Ljubljana. This is an iterative method using successive approximations of the deflected shape: 

  • Assume an approximation of the deflected shape.  In the spreadsheet a linear approximation is used from the fixed point(s) to the point of maximum deflection, which is assumed to be at the top of the column if the top is unrestrained in the X direction, or at mid height if the top is restrained.
  • Find the bending moments due to a unit axial load applied at the top in a column with this shape .
  • Find the deflections of a column subject to this bending moment distribution.
  • Normalise the deflections based on the maximum absolute deflection.
  • Update the column shape using the normalised deflections, and repeat the analysis.
  • Repeat until the difference in maximum deflection between successive iterations is negligible.
  • The buckling load is the inverse of the maximum deflection from the last iteration (before normalisation).

The Frame4 spreadsheet has been modified to generate the required input data and carry out the analysis simply and quickly for a straight member with axial load applied at one end.  The input required is: 

  • End conditions: either 1 (fixed) or 0 (free) for base rotation, top X deflection and top rotation.  X and Y deflection at the base must be fixed, and Y deflection at the top must be free.
  • Cross section details: for a member of constant cross section specify the cross section area, second moment of area, and E (Young’s Modulus), and member length and number of sections in the analysis.  For a varying cross section enter the section details for every cross section, with the height to the top of the section.
  • If the number of sections is entered in the constant cross section data the constant cross section is used.  If this cell is blank or zero the varying cross section data table is used.

 Typical input and results are shown in the screen shot below: 

Frame4Buckle Input and Output, click image for full size view

The buckling shape may be plotted to a chosen scaled deflection: 

Buckled shape

Calculated deflections and normalised deflections are listed on the “Output” sheet: 

Analysis Output Details

About these ads
This entry was posted in Beam Bending, Excel, Frame Analysis, Newton, VBA and tagged , , , , , , , . Bookmark the permalink.

13 Responses to Buckling of columns with varying cross section

  1. Elizabeth B says:

    Dear Sir/Madam,
    I have seen the buckling analysis spreadsheet and it is very useful resource. What is the reason for the end condition limitation? The spreadsheet is developed for end condition fixed or free can this be used for pinned conditions?

    With Regards

  2. dougaj4 says:

    Elizabeth – for stability the column must be fixed in the x and y directions at at least one end, and for buckling to occur it must be free in the y direction at one end (and fixed at the other). For simplicity I have fixed the base in the x and y directions and specified the top should be free in the y direction, but this doesn’t prevent pinned conditions. For pinned both ends enter a 1 under X top, and make sure that rotation top and bottom are blank. It should be possible to model any stable support conditions, although it may be necessary to invert the strut if it is tapered and the base is free in the x direction.

  3. dougaj4 says:

    although it may be necessary to invert the strut if it is tapered and the base is free in the x direction.

    Forget that bit!

    Movement is relative, so a column restrained against horizontal movement at the base and free at the top will have the same buckling load as an identical column restrained horizontally at the top and free at the base.

    Restraint against rotation must be applied at the correct end (for a tapered column) though.

  4. Pingback: Buckling of rings and arches | Newton Excel Bach, not (just) an Excel Blog

  5. dinah mathew says:

    what is the best cross section for a column?and why?

  6. dougaj4 says:

    Dinah – it depends on the loading and materials, amongst other things, but for a column with increasing vertical load from top to bottom, and hrizontal loads from any direction “tree shaped” is pretty good; i.e. a tapering circular section.

  7. Pingback: Daily Download 1: Buckling of columns, rings and arches | Newton Excel Bach, not (just) an Excel Blog

  8. Jon says:

    Can someone please help me setup a buckling analysis with this…

    Member is fixed/free axial loaded

    7″L of 1.5″ diameter

    Then quick taper down to
    286″ L of .875″ diameter

    The taper back up to:
    7″L of 1.5″ diameter.

    Steel. Very long and thin piece of steel rod (clearly)

  9. dougaj4 says:

    Jon – I have set up the buckling analysis at:
    (I have converted units to metres and kNewtons, sorry)
    Also I have set up both ends as fixed against rotation, but just delete any restraints you don’t want.
    Note that the stiffer end segments only increases the calculated buckling load from 1.64 kN to 1.79 kN.

    The Euler buckling load, using the thinner section over the complete length, is 1.63 kN.

  10. did anybody already entered the real weight of the beams into the analisys?

    • dougaj4 says:

      Marco – this analysis assumes all the load is concentrated at the top, it would not be applicable to a situation where the column self-weight was significant.

      It would be conservative to simply deduct the column weight from the buckling load, or for a more accurate estimate it would probably be simplest to do an incremental load analysis in a frame analysis program, including 2nd order effects.

  11. Pingback: Using Frame4Buckle with the Alglib solver | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s