JavaScript must be enabled in order to use this site.

The CivilWeb Crack Width Calculation Excel Sheet is a handy tool for the calculation of crack widths in concrete beams in accordance with BS 8110. This spreadsheet completes all the calculations instantly and allows the designer to optimise the design of the proposed concrete beam to suit a particular maximum crack width in minutes. Crack Width Calculation Spreadsheet Download Subframe Analysis Spreadsheet Download Concrete Creep, Shrinkage Factors and Tensile Strength Calculation. Spreadsheet Calculation for Design of Steel-I Section to BS5950 Download Seismic Response of Liquid Storage Tank Download.

Crack Width Calculation Spreadsheet - energyfasr Crack-width-check Disclaimer Check Schedule As m Crack width BS 5400 pt 4 C.L. 5.8.8.2 Cnom is the required nominal cover dc is the depth of the concrete in compression (if dc is 0 use BS5400 Pt 4 Eq. Reinforced Concrete Design Spreadsheets - Including Concrete Beam, Slab and Stair Design.

Please enable JavaScript in your browser and refresh the page.

Indian or British Codes

IS 456 - 2000 Annex F and BS 8110 Part II, Clause 3.8 include the same method for determining the nominal crack width for design. This procedure is based on work by Andrew Beeby. The crack width determined by this method represents a best-fit for experimental data where the stress in the tension steel is limited to 0.8x F_y.

The following assumptions are made for this method:

Crack Width Calculation Spreadsheet Free

• S_m = 1.5 a_cr
• W_mean is a funciton of S_m and ε_m
• W_max = 2x W_mean

The following procedure is then used by the program to evaluate the crack width for design:

Crack Width Calculation Spreadsheet Pdf

1. Calculate the modular ration, m as:

   m = E_c/E_s

   Where:

   Es = 20,000 N/mm² (IS 456 - 2000, Annex F)

   Ec = 5,000·√(f_c) (Cl. 6.2.3.1 of IS 456 - 2000)

2. Calculate the depth of the neutral axis, x, per the limit state method (IS 456 - 2000 Annex G and BS 8110 Part I Cl. 3.4.4.4)

3. Calculate the moment of inertia of the equivalent section, I_eff.

4. Calculate the effective modulus of elasticity of concrete, E_eff.

   Where:

   c = safety factor taken as 1.0.

5. Calculate the average steel strain at the depth considered (e.g., the centerline of rebar), ε₁, based on the absolute value of the critical bending moment.

6. Calculate the average strain, ε_m, at the point of interest as:

7. Calculate Crack Width W_cr from IS 456 -20000 BS 8110 Part II

   Where:

   a_cr = distance from the point of interest to the surface of the nearest longitudinal bar

   h = total depth of the section

   C_min = clear cover to longitudinal steel

8. Check whether the crack width value is safe or not depending upon the maximum allowed range defined by codes (IS 456 2000 & BS 8110 Part II)