Scribd Logo
Upload

Welcome to Scribd!

  • 177 views

    Crackwidth Calculation Spreadsheet (Restricted Version)

    Uploaded by

    Nicholas Thompson
    The document provides calculations for structural design elements including reinforcement requirements to prevent early cracking, crack width due to thermal effects, flexural design of slabs, and crack width due to flexure. The calculations are performed by Structville Integrated Services for an unnamed project located in an unspecified location. Input parameters and code references are provided, calculations are shown, and output results are highlighted in blue cells for verification.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Crackwidth Calculation Spreadsheet (Restricted Version)

    Uploaded by

    Nicholas Thompson
    177 views11 pages
    The document provides calculations for structural design elements including reinforcement requirements to prevent early cracking, crack width due to thermal effects, flexural design of slabs, and crack width due to flexure. The calculations are performed by Structville Integrated Services for an unnamed project located in an unspecified location. Input parameters and code references are provided, calculations are shown, and output results are highlighted in blue cells for verification.

    Original Title

    CRACKWIDTH CALCULATION SPREADSHEET (RESTRICTED VERSION)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides calculations for structural design elements including reinforcement requirements to prevent early cracking, crack width due to thermal effects, flexural design of slabs, and crack width due to flexure. The calculations are performed by Structville Integrated Services for an unnamed project located in an unspecified location. Input parameters and code references are provided, calculations are shown, and output results are highlighted in blue cells for verification.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    177 views11 pages

    Crackwidth Calculation Spreadsheet (Restricted Version)

    Uploaded by

    Nicholas Thompson
    The document provides calculations for structural design elements including reinforcement requirements to prevent early cracking, crack width due to thermal effects, flexural design of slabs, and crack width due to flexure. The calculations are performed by Structville Integrated Services for an unnamed project located in an unspecified location. Input parameters and code references are provided, calculations are shown, and output results are highlighted in blue cells for verification.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 11
    At a glance
    Powered by AI
    The document contains structural engineering calculations for reinforcement design of slabs and crack width analysis.

    The project involves calculating the reinforcement requirements and crack width for structural slabs.

    The calculations cover flexural design of slabs, minimum reinforcement requirements, and crack width analysis due to bending according to EC2 standards.

    STRUCTVILLE INTEGRATED SERVICES LIMITED

    PROJECT: LOCATION:

    PREPARED BY: UBANI O.U DATE: NOV. 2018 SHEET NO:

    ELEMENT: CHECKED BY:

    REF CALCULATION OUTPUT


    EARLY THERMAL CRACKING
    Clause 7.3.4 EN Minimum Area of Reinforcement Required for Early Cracking
    1992-1-1:2004
    Cement class = N 0.25
    Fck = 30 Mpa
    Fyk = 500 Mpa

    Layer Bar Dia (mm) Spacing (mm) Asprov (mm2)


    1 10 100 785 Total Asprov =
    2 10 100 785 1571 mm2

    Thickness of member (h) 400 mm 0.93 Act =


    Width of member (w) 1000 mm 400000 mm2
    Act = 400000 mm2

    Exp (7.1) EN
    1992-1-1:2004

    Table 3.1 and fct,eff (28 days) = 2.8964682 Mpa


    Exp (3.4) EN fct,eff (3 days) = 1.7327842
    1992-1-1:2004
    kc = 1 (coefficient for stress distribution)
    k= 0.93 (coefficient for non-uniform equilibrating
    stresses)
    AS,min =
    AS,min = 554491 mm 2
    Not Ok. Increase Area of Steel! 554491 mm2
    INSTRUCTIONS/DISCALIMER
    (1) Enter your values in cells highlighted in blue only
    (2) You can edit company name and project information

    (3) You are ENTIRELY responsible for the use of this spreadsheet

    (4) Kindly verify all outputs from this spreadsheet before putting it to any use.

    https://structville.com/2019/02/how-to-calculate-crackwidth-due-to-bending-accordi
    e-to-bending-according-to-ec2-download-excel-spreadsheet.html
    STRUCTVILLE INTEGRATED SERVICES LIMITED
    PROJECT: LOCATION:
    PREPARED BY: UBANI O.U. DATE: NOV. 2018 SHEET NO:
    ELEMENT: CHECKED BY:
    REF CALCULATION OUTPUT
    EARLY AND LONG TERM THERMAL CRACKING

    Design crack width = 0.2 mm


    Exp (7.8 ) Crack width = Sr,max εcr
    EN 1992-1-1
    Maximum Crack Spacing Sr,max
    Sr,max = 3.4c + 0.425(k1k2ϕ/ρp,eff)

    c = 70 mm (Cnom - nominal concrete cover)


    h= 450 mm (thckness of section)
    b= 1000 mm (width of section - 1000 mm for slabs)
    As1 = 1340 mm2 (Area of reinforcement in one face)
    ϕ= 16 mm (diameter of reinforcement provided)
    k1 = 1.14
    K2 = 1

    ρp,eff = 0.006871794872 Sr,max = 1366.09


    Sr,max = 1366.089552 mm mm

    (1) Early Age Crack Inducing Strain


    Equ (3.1 and 3.2)
    CIRIA C660
    k= 1 allowance for creep)
    αc = 1.00E-05 /°C (coefficient of concrete expansion)
    T1 = 28 °C (Peak Temperature Rise)
    R= 0.76 (restraint factor)
    εctu = 7.60E-05 (short term value)
    εca = 1.50E-05 (short term value)
    εcr = 2.77E-04

    Wks = 9.00E-02 mm (Short term crack width) Ok

    (2) Long Term Cracking

    R1 = 5.00E-01 R2 = 5.00E-01 R3 = 5.00E-01


    εca = 5.00E-05 (long term value)
    T2 = 3.50E+01 °C (Annual Temperature change)
    εcd = 1.50E-04
    εctu = 1.08E-04 (long term value)
    εcr = 4.21E-04

    WkL = 1.37E-01 mm (Long term crack width) Ok


    INSTRUCTIONS/DISCALIMER
    (1) Enter your values in cells highlighted in blue only
    (2) You can edit company name and project information
    (3) You are ENTIRELY responsible for the use of this spreadsheet
    (4) Kindly verify all outputs from this spreadsheet before putting it to any use.

    (1) CALCULATE VALUE OF EDGE RESTRAINT FACTOR


    Thickness of new pour of concrete = 450 mm
    Thickness of existing base = 75 mm
    Is the new pour cast at the edge of the old concrete? NO
    Restraint Factor R = 0.29

    (2) TYPICAL VALUES OF RESTRAINT FACTORS

    (3) TYPICAL VALUES OF T1


    STRUCTVILLE INTEGRATED SERVICES LIMITED
    PROJECT: LOCATION:
    PREPARED BY: DATE: SHEET NO:
    ELEMENT: CHECKED BY:
    REF CALCULATION OUTPUT
    FLEXURAL DESIGN OF SLABS

    Thickness of slab (h) = 200 mm h= 200


    Width of slab (b) = 1000 mm mm
    Diameter of bar (ϕ) = 14 mm
    Concrete Cover (c) = 25 mm
    fck = 30 Mpa
    fyk = 280 Mpa

    Design Moment MEd = 25 kNm/m MEd = 25


    kNm/m
    Effective Depth (d) = 168 mm
    Clause 3.1.7 EN k = MEd/fckbd2 = 0.029526 k= 0.02953
    1992-1-1:2004
    Since k < 0.167, no compression reinforcement required

    z/d = 0.973242 Use 0.95

    As1 = MEd/(0.87fykz) = 643 mm2 Asreq = 643


    mm 2

    Bar dia (mm) Spacing (mm) Asprov (mm2)


    14 143 1077 Asprov = 1077
    Ok mm2
    Asmin = 451.849 mm2 Ok
    As' = 1078 mm2 (Area of compression steel provided
    if any)

    Clause 7.4.2 EN Check For Deflection


    1992-1-1:2004 Critical Span Length L = 5000 mm
    K =1 (based on type of slab)

    ρ = 0.00641 ρ0 = 0.00548
    ρ' = 0.00642

    Exp 7.16 EN 1992 L/d = -5504.2 Modfication Factor = 2.98984


    1-1:2004 Use MF = 2
    Deflection
    Allowable L/d = 0 Actual L/d = 29.7619 Fail
    INSTRUCTIONS/DISCALIMER
    (1) Enter your values in cells highlighted in blue only
    (2) You can edit company name and project information
    (3) You are ENTIRELY responsible for the use of this spreadsheet
    (4) Kindly verify all outputs from this spreadsheet before putting it to any use.
    STRUCTVILLE INTEGRATED SERVICES LIMITED
    PROJECT: LOCATION:
    PREPARED BY: DATE: SHEET NO:
    ELEMENT: CHECKED BY:
    REF CALCULATION OUTPUT
    Clause 7.3.4 CRACKWIDTH DUE TO FLEXURE
    EN 1992-1-1:
    2004 Layer Bar Dia (mm) Spacing (mm) Asprov (mm2)
    1 12 200 565
    2 12 200 566

    h= 200 mm (thickness of slab) h = 200


    Cc = 25 mm (Concrete Cover) mm
    ϕ= 12 mm (Diameter of main bars)
    AS1 = 565 mm2 (Area of steel in tension)
    AS2 = 566 mm2 (Area of steel in comp.)
    d = 169 mm (effective depth)
    d1 = 31 mm
    αe = 7 (Modular ratio)
    b = 1000 mm (width of slab)

    x1 = -7351.65
    x2 = 40029.2196
    x = 32.6775696 mm (depth to neutral axis) x = 32.6776
    mm
    Service Bending Moment MSLS = 15
    Allowable Crack Width wk = 0.3 mm

    Compressive stress in concrete = 5.79187629 Mpa fc = 5.79188


    Tensile stress in steel = 169.135546 Mpa fs = 169.136

    heff = 55.7741435 mm ρp,eff = 0.01014


    Ac,eff = 55774.1435 mm2
    Exp 7.9 EN 1992
    1-1:2004

    kt = 0.4 Es = 200000 Mpa


    fck = 30 Mpa fct,eff = 2.89646815 Mpa

    εsm - εcm = 2.338E-04 Take εsm - εcm = 0.00050741 εsm - εcm =


    0.00051
    Maximum Crack Spacing Sr,max k1 = 0.8
    Exp 7.11 EN 1992 Sr,max = 3.4c + 0.425(k1k2ϕ/ρp,eff) k2 = 0.5
    1-1:2004
    Sr,max = 286.212 mm Sr,max = 286.212

    Crack width wk = 0.15 mm wk = 0.15


    mm
    Crack width is ok
    INSTRUCTIONS/DISCALIMER
    (1) Enter your values in cells highlighted in blue only
    (2) You can edit company name and project information
    (3) You are ENTIRELY responsible for the use of this spreadsheet
    (4) Kindly verify all outputs from this spreadsheet before putting it to any use.

    You might also like