Menu:

R.C. Element Design Spreadsheet Package to BS 8110-1: 1997
 
 
Description:
This is an R.C. Spreadsheet Power Pack. It contains five spreadsheets for designing R.C. elements like columns, beams and slabs. It also includes column chart generator. In essence this package covers all main elements in a reinforced concrete structure, making this a very powerful tool - hence the Power Pack name.
Features:
- R.C. Spreadsheet Power Pack;
- A very powerful package for designing all main reinforced concrete elements;
- For very quick checks and easy use thanks to a minimum user input;
- Each spreadsheet has a clear and easy to read output (all on a single page);
- Design is based on British Standard (BS 8110-1 1997);
- This package contains five spreadsheets:
    1) Column subject to compression and biaxial bending design spreadsheet:
  • This spreadsheet is for designing braced columns subject to compression and biaxial bending from a minimum moment (calculated automatically). This is a typically approach when designing reinforced concrete buildings with stair/lift cores and/or shear walls providing lateral stability. Then slabs are designed as with pinned supports and do not impose any moments in columns which can be design with minimum moments due to imperfections etc.;
  • Calculates required column reinforcement;
  • For short and slender columns;
  • Spreadsheet calculates minimum moment and in case of slender columns: additional moment;
  • Automatically calculates K value;
  • Supports can be: pinned, semi-rigid and rigid - for slenderness calculations;
  • Design up to two columns per page. Each design case may have up to six loadcases;
  • Gives column cross-section diagrams for easier appreciations.
  • Calculations are based on user defined design compression load and moment.
    2) Column chart generator spreadsheet:
  • Generates N-M Interaction Chart for R.C. columns bent about one axis. Charts are a very convenient and well used method for selecting column reinforcement depending on applied vertical load and moment. This spreadsheet simplifies this process by plotting the chart and giving required rebar based on applied forces;
  • Automatically calculates minimum moment;
  • Option to change column type between vertically and horizontally (like precast column) cast;
  • Gives 'N uz' and 'N bal' per reinforcement area;
  • Gives minimum link diameter per reinforcement area;
  • Up to six loadcases;
  • Gives column cross-section diagram for easier appreciations;
  • Calculations are based on user defined design compression load and moment.
    3) Beam design spreadsheet:
  • For rectangular beams;
  • Calculates required beam reinforcement;
  • Covered beam types: simply supported, continuous, cantilever, section over support;
  • Checks deflection based on span to effective depth ratio. Automatically increases reinforcement area to satisfy deflection check. Tension and Compression Modification Factors are automatically calculated;
  • Option to input redistribution;
  • Option to manually increase number of compression reinforcement - affects deflection check;
  • Option to limit maximum allowable increase of tension reinforcement for deflection check;
  • Calculations are based on user defined design moment.
    4) Slab design
  • For rectangular slabs;
  • Calculates required slab reinforcement;
  • Covered slab types: simply supported, continuous, cantilever, section over support;
  • Checks deflection based on span to effective depth ratio.
  • Tension and Compression Modification Factors are automatically calculated;
  • Option to input redistribution;
  • Option to specify compression reinforcement which affects deflection check; 
  • Option to specify standard reinforcement mat in which case required reinforcement will be calculated in a form of additionals, e.g.: H10@200mm crs PLUS H12@200mm crs ADD'L;
  • Option to limit maximum allowable increase of reinforcement area for deflection check;
  • Calculations are based on user defined design moment.
    5) Shear check spreadsheet:
  • For beams and slabs;
  • Calculates link spacing for a given link diameter;
  • Nominal links are provided in beams as a minimum;
  • It is seldom that shear will govern slab design - therefore the spreadsheet first checks slab as with no shear reinforcement.
  • Calculations are based on user defined design shear.

(Note: macros must be enabled for proper working of the spreadsheet. Follow instructions in this video)
What People Say:
"Holy cow! Your spreadsheets are on steroids!" James from Spreadsheet Wonders

"I will certainly be recommending this package, a few clicks and job is done. Great value btw!!" George
​ 
Provide testimonial or feedback
System Requirements:
To run the Single-User or the Company Licensed version of this spreadsheet you require:
- Microsoft Windows Excel version 2007 and above;

Contact me if you want to use this spreadsheet on MAC.
Download Section:
FREE Lite version: R.C. Element Design to BS (1.1).

The restriction in this free lite version is that you cannot change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also a few other cells were disabled. For details see relevant spreadsheet.


(file in .zip format)


FULL version: R.C. Element Design to BS (1.1).

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

Fully working version where you change the company information and company logo. And also input point loads.

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

After purchase fill in this Activation Key Request Form.


 
 


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