Project
Spreadsheets to BS 8110etc                                          REINFORCED CONCRETE COUNCIL
      Client     Advisory Group                                                      Made by   Date                Page
      Location   Grid line 1                                                             RC      16-Feb-2017           33
                 Crack Width Calculations to BS8110: 1997/ BS8007:1987               Checked   Revision            Job No
                    Originated from RCC14.xls v 2.1on CD    1999-2003 BCA for RCC       chg              -            R68
      CRACK WIDTH CALCULATIONS - FLEXURE                                             -
      INPUT
                                                                                fcu=     40      N/mm2
                                                                                 fy=     460     N/mm2
                                                      Area of reinforcement " As " =     251     mm2
                                                                                 b=     1000     mm
                                                                                 h=      170     mm
                                                                                 d=      91      mm
                                   Minimum cover to tension reinforcement " CO " =       75      mm
                                                        Maxmum bar spacing " S " =       200     mm
                                                                    Bar dia " DIA " =     8      mm
" acr " =(((S/2)^2+(CO+DIA/2)^2)^(1/2)-DIA/2) as default or enter other value = 123.44 mm
                "acr " is distance from the point considered to the surface of the nearest longitudinal bar
                                                    Applied service moment " Ms "=       4.5     KNm
      CALCULATIONS
                  moduli of elasticity of concrete " Ec" = (1/2)*(20+0.2*fcu) =                   14.0        KN/mm2
                                            moduli of elasticity of steel " Es " =               200.0        KN/mm2
                                                 Modular ratio "  " = (Es/Ec) =                 14.29
                                                                 " " = As/bd =                 0.003
                     depth to neutral axis, "x" = (- +(()2 + 2.)0.5.d =                   22         mm
                                                                          " Z " = d-(x/3) =     84
                                              Reinforcement stress " fs " = Ms/(As*Z) =        213   N/mm2
                                             Concrete stress " fc " = (fs*As)/(0.5*b*x) =      4.81  N/mm2
                   Strain at soffit of concrete beam/slab "" = (fs/Es)*(h-x)/(d-x) = 0.002288
                   Strain due to stiffening effect of concrete between cracks " 2 " =
                                 2 = b.(h-x)2/(3.Es.As.(d-x)) for crack widths of 0.2 mm     Used
                            2 = 1.5.b.(h-x)2/(3.Es.As.(d-x)) for crack widths of 0.1 mm       n/a
                                                                                       2 = 0.002108
                          Average strain for calculation of crack width "  m "=  1- 2 = 0.000180
                             Calculated crack width, " w " = 3.acr.m/(1+2.(acr-c)/(h-x))
                                                             CALCULATED CRACK WIDTH, 'w' =       0.04         mm
Disclaimer
All advice or information from the British Cement Association and/or Reinforced Concrete Counc
intended for those who will evaluate the significance and limitations of its contents and t
responsibility for its use and application. No liability (including that for negligence) for any
resulting from such advice or information is accepted by the BCA, RCC or their subcontract
suppliers or advisors. Users should note that all BCA software and publications are subjec
revision from time to time and should therefore ensure that they are in possession of the la
version.
This spreadsheet should be used in compliance with the accompanying publication 'Spreadshe
for concrete design to BS 8110 and EC2' available from British Cement Association, Telford Aven
Crowthorne, Berkshire RG45 6YS.
Status of spreadsheet
Public release version.
Revision history RCC14 Crack Width.xls
  Date       Version
21-Jan-03    RCC14 v2.1
11-Oct-02    RCC14 v2.0
4-Aug-99     RCC14 v1.1
formation from the British Cement Association and/or Reinforced Concrete Council is
hose who will evaluate the significance and limitations of its contents and take
or its use and application. No liability (including that for negligence) for any loss
 such advice or information is accepted by the BCA, RCC or their subcontractors,
 visors. Users should note that all BCA software and publications are subject to
 me to time and should therefore ensure that they are in possession of the latest
et should be used in compliance with the accompanying publication 'Spreadsheets
sign to BS 8110 and EC2' available from British Cement Association, Telford Avenue,
rkshire RG45 6YS.
           This spreadsheet is shareware. It may be distributed freely, but may not be
           used for commercial purposes until the user has registered with the RCC.
ry RCC14 Crack Width.xls
                                      Action                               Size (kB)
                            DETR logo replaced by DTI.                         156
                              Version 2 enhancements                           172
                                     Renamed                                   81