Menu:

Continuous Beam Analysis Spreadsheet
 

Description:
User friendly spreadsheet for analysing continuous beams. In an easy to read form the spreadsheet presents moment / shear / deflection diagrams as well as gives critical values for each span. This spreadsheet can also be used for analysing single spans.
Spreadsheet Origin:
This is the spreadsheet that gave birth to this website. There were few main aims when designing this spreadsheet, listed below, and all were successfully achieved:

   1)   A reliable way to analyse continuous beams and save time on input of data;
   2)   A clear and easy to read output of results including graphs and tables;
   3)   Input data, graphs and numerical results on a single page;
   4)   A single, presentable page that can be printed and attached to your calculations;
   5)   Option to calculate singly supported, fixed and cantilevered beams.

The need for the above become present when I was using other software available on the market - both for 3d and 2d. These programs are of high quality but the approach, and hence the output, is too complex for a quick solution of continuous beam problems. The input takes too long and the results are usually on few pages which makes the solution hard to appreciate at a glance.

As a result a practical and easy to use and understand spreadsheet was produced.
Features:
- A clear and easy to read output (all on single page);
- Input up to 5 spans;
- Change support conditions (pinned, fixed or cantilever);
- Loading options: UDL, Partial UDL, 2x Point Load;
- 'Live' Loading diagram;
- Change between bending moment, shear and deflection diagram (or use combination);
- Change between deflection for Dead Load + Imposed Load or Imposed Load only;
- Changeable safety factors;
- Show diagrams under factored or unfactored loading;
- Option to change between SI units (metres, Newtons)  and US units (feet, pounds);
- Compatible with older versions of Excel, like Excel 2000.

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
What People Say:

Title
/
Company

  • 1
  • 2
  • 3
  • 4
  • 5
Yet another superb design tool from a practical engineer who understands the requirements of working professionals.​

Richard Davis
wrdstructural.co.uk

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
Spreadsheet on beam analysis was very useful to me as I train younger engineer on the subject of structural analysis.

Anji-Sob Erekosima
Anedian Group Co. Ltd

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
The spreadsheet of continuous beam analysis is really superb and very user friendly! Thanks.

Vince P.

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
I bought a single user license and followed with a company license so that all my engineers can use continuous beam spreadsheet. It is easy to use, fast and efficient. Thanks for that and please keep me updated on any development of the site.

Mark

/

  • 1
  • 2
  • 3
  • 4
  • 5

/

  • 1
  • 2
  • 3
  • 4
  • 5
A great service, got my spreadsheet up and running in no time and saved me valuable time. Money well spent. Thanks.

Stephen W.

/

  • 1
  • 2
  • 3
  • 4
  • 5
  • 0
  • 1
  • 2
  • 3
  • 4
Provide testimonial or feedback
System Requirements:
To run the Single-User Licensed version you require:
- Microsoft Windows Excel version 2007 and above;
(Note: the Single-User spreadsheet will not run on Mac due to unsupported activation procedure)

To run the Company Licensed version you require either:
- Microsoft Windows Excel version 2007 and above;
- Microsoft Mac Excel version 2004 and above.
Download Section:
FREE Lite version: Continuous beam analysis (2.1).

It allows you to modify and analyse maximum to 3 span continuous beams. However the loading has been limited to UDL on 1 and 3 span and a fully working loading conditions on 2nd span. That allows to understand and appreciate the spreadsheet. Another restriction is that you can not change the company name nor the logo (shown in top left corner) - currently set to a made up company.

 


FULL version: Continuous Beam Analysis (2.1).

Single-User or Company License, which one is the best for me?

Fully working version where you can input up to 5 spans, load them as desired. It also allows you to change the company information and logo in the top left corner.

By purchasing this spreadsheet you agree to the disclaimer and terms & conditions. Two types of licenses are available for this spreadsheet. The single-user license is offered for a nominal price of £20 - a great product that you can have for a great value.

After purchase fill in this Activation Key Request Form.


 
 


For other currencies click here: € (EUR), £ (GBP) or $ (USD).