R.C. Shear Walls Design Spreadsheet to BS 8110-1: 1997

If you spend hours calculating (and then recalculating) wall stiffnesses, ∑(kr2), direct and torsional rotation component of force to then calculate reinforcement and concrete stresses for each wall in turn - then this spreadsheet will reduce your design time to as little as several minutes.

Make sure to look at this Worked Example with comments on how the spreadsheet works and how to use it efficiently and correctly.(Note: at present this spreadsheet is not compatible with older version of Excel, like Excel 2003 and older, as these do not recognize 'iferror' function.)

(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

I love it. Thanks for great support.

Markus A.

/

1

2

3

4

5

/

1

2

3

4

5

I used to do spend a lot of time calculating centre of gravity of stair+lift cores to calculate wall stresses. Then I found this spreadsheet and it simplified my life! Calculations are now a breeze! Thanks for that.

Mona V.

/

To run the Single-User or the Company Licensed version of this spreadsheet you require:- Microsoft Windows Excel version 2007 to 2016;

Contact me if you want to use this spreadsheet on MAC.

Download Section:

FREE Lite version: Shear Walls Design Spreadsheet to BS (1.4).

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 you cannot change superstructure height nor value of wind loads.

Fully working version where you 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.