Crack Width Calculation Spreadsheet

Crack width is a complex and tough topic. Most people still use 20 years old method defined in ACI 318-95. The situation becomes more complex if axial tension force and moment is combined to calculate crack width. One of the examples is large water tanks above ground. This tutorial aims at explaining details and methods in different ACI documents. View RCC14BSI-ACI-350 Crack Width-01.xls from CIVIL ENGI CE304 at National University of Sciences & Technology, Islamabad. Crack Width Calculations Based on. Likely to crack by comparing calculated stresses with the expected concrete strength. The 95 percentile, f 5, should be used to obtain conservative values for restraint forces that might occur before the concrete cracks. These restraint forces are used to calculate the amount of reinforcement needed for crack width control. Causes of Cracking. The originator does not guarantee the accuracy of the output or any other information on this spreadsheet. The users take all responsiblity for the use of this spreadsheet, modifications and output. Should you experience any problems or like to see more features added to this spreadsheet please contact: Disclaimer Crack width d 47.40 164.60 30. (permissible crack width) Layer Bar Dia. Spacing Thickness Width @ X Operating Instructions Reinforcement Details Red messages indicate failure Enter the Data in Blue Cells (underlined) Only x (EARLY THERMAL CRACKING oc CALCULATIONS DOCUMENT No.(Project / Doc) SHEET No. SUBJECT REF OUTPUT DATE: PREPARED BY: ( B Use B eth Cement Content Kg/m3.

Eurocode 2 part 1-1: Design of concrete structures 7.3 Crack control

The crack width, wk, may be calculated as follows:

wk = sr,max⋅(εsm - εcm) (7.8)

where:

sr,max
is the maximum crack spacing
εsm
is the mean strain in the reinforcement under the relevant combination of loads, including the effect of imposed deformations and taking into account the effects of tension stiffening
εcm
is the mean strain in the concrete between cracks.
(7.9)
Width

where:

σs
is the stress in the tension reinforcement assuming a cracked section,
see application for a rectangular section or application for a T-section
Es
is the design value of the modulus of elasticity of the reinforcing steel, see § 3.2.7 (4)
αe
is the ratio Es/Ecm

with

Ecm
the secant modulus of elasticity of concrete
fct,eff
is the mean value of the tensile strength of the concrete effective at the time when the cracks may first be expected to occur:
fct,eff = fctm or lower, (fctm(t)), if cracking is expected earlier than 28 days
ρp,eff
= (As + ξ1A'p)/Ac,eff(7.10)

with

As
the cross sectional area of reinforcement
A'p
the area of pre or post-tensioned tendons within Ac,eff
Ac,eff
the effective area of concrete in tension surrounding the reinforcement or prestressing tendons of depth, hc,ef, where hc,ef is the lesser of 2,5(h - d), (h - x)/3 or h/2 (see Figure 7.1)
ξ1
the adjusted ratio of bond strength taking into account the different diameters of prestressing and reinforcing steel:
ξ1 = (7.5)

with

ξ
the ratio of bond strength of prestressing and reinforcing steel, according to Table 6.2
ΦS
the largest bar diameter of the reinforcing steel
ΦP
the diameter or equivalent diameter of prestressing steel:
Φp = 1,6⋅√AP for bundles, where AP is the area of a prestressing steel,
Φp = 1,75⋅Φwire for single 7 wire strands,
Φp = 1,20⋅Φwire for single 3 wire strands, where Φwire is the wire diameter.
kt
is a factor dependent on the duration of the load:
kt = 0,6 for short term loading,
kt = 0,4 for long term loading.

• Where the bonded reinforcenlent is fixed at reasonably close centres within the tension zone (spacing ≤ 5(c + Φ/2), cf. Figure 7.2), the maximum crack spacing sr,max may be calculated as follows:

sr,max = k3c + k1k2k4Φ / ρp,eff(7.11)

where:

Crack width calculation spreadsheet example
Φ
is the bar diameter. Where a mixture of bar diameters is used in a section, an equivalent diameter, Φeq, should be used.
c
is the cover to the longitudinal reinforcement
ρp,eff
see the difference of the mean strains above
k1
is a coefficient which takes account of the bond properties of the bonded reinforcement:
k1 = 0,8 for high bond bars,
k1 = 1,6 for bars with an effectively plain surface (e.g. prestressing tendons).
k2
is a coefficient which takes account of the distribution of strain:
k2 = 0,5 for bending,
k2 = 1,0 for pure tension.
Intermediate values of k2 should be used for cases of eccentric tension or for local areas:
k2 = (ε1 + ε2)/(2ε1) (7.13)

where ε1 is the greater and ε2 is the lesser tensile strain at the boundaries of the section considered, assessed on the basis of a cracked section.

k3
is a Nationally Determined Parameter, see § 7.3.4 (3)
k4
is a Nationally Determined Parameter, see § 7.3.4 (3).

• Where the spacing of the bonded reinforcement exceeds 5(c + Φ/2) (cf. Figure 7.2), or where there is no bonded reinforcement within the tension zone, the maximum crack spacing sr,max may be calculated as follows:

sr,max = 1,3(h - x) (7.14)

where:

h
is the overall depth of the section (see Figure 7.1)
x
is the neutral axis depth of the section (see Figure 7.1).

This application calculates the crack width wk from your inputs. Intermediate results will also be given.

First, change the following option if necessary:

Crack Width Calculation Spreadsheet Free


Output
(7.5)
(7.10)
(7.9)
mm(7.11)
mm(7.8)
×

Warning

0 11
This area is the only area of the Repository open to subscribers to our free XLC Trial plan. All other areas of the repository are open to paid subscribers and site contributors only.

Files

Order By :

Benchmark Calculation

Calculation of coordinate using total station from benchmark
06 May 2021
22
0

column capacity

08 Jun 2021
16
1

Crack Width of Slabs and Walls In Accordance with BS 8007

Crack Width Calculation Spreadsheet Pdf

Spreadsheet to establish crack widths of structural walls and slabs, in accordance with BS 8007, under serviceability conditions. SLS loading as we...
12 Feb 2021
37
Spreadsheet
1

Doppler Effect

20 Feb 2021
361
0

Free Fall Calculation


09 Feb 2015
600
4

IS 456-2000

04 Jul 2021
0
0

Laminate Calc.xls

15 Aug 2020
83
0

P M interaction curve for RCC column

16 Sep 2020
148
2

Quadratic Equations.xls

Find the roots of a quadratic equation. Related Calculations at ExcelCalcs
20 Feb 2021
1595
19

Crack Width Calculation Spreadsheet 2020

Slenderness Check

Spreadsheet to check the slenderness
18 Jun 2021
6
0

UDL on simply supported beam.xls

Calculate bending moments, shear, slope and deflection of a simply supported beam at any point along its length when it is subject to a UDL ...
20 Feb 2021
2485

Crack Width Calculation Spreadsheet Sample

Crack Width Calculation Spreadsheet
20