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

### Like this:

Like Loading...

*Related*

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

EB

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.

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.

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

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

I think Dinah should be careful about getting other people to do her school homework.

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.

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

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)

Jon – I have set up the buckling analysis at:

http://interactiveds.com.au/software/Frame4buckle-Jon.xlsb

(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.

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

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.

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