Scribd Logo
Upload

Welcome to Scribd!

  • 381 views

    Slab Design Excel Sheet

    Uploaded by

    Rajat Garg
    The document describes the design of a one-way and two-way slab. For the one-way slab, the aspect ratio Ly/Lx is greater than 2, so it is designed as a one-way slab. Key parameters like effective depth, reinforcement diameter, grade of concrete and steel are specified. The loads, moment calculation, and required steel area are presented. The two-way slab has an aspect ratio less than 2, so it is designed as a two-way slab. Moment coefficients used for design are listed for different edge conditions. Design checks for deflection are also described for both slab types.

    Copyright:

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

    Slab Design Excel Sheet

    Uploaded by

    Rajat Garg
    381 views8 pages
    The document describes the design of a one-way and two-way slab. For the one-way slab, the aspect ratio Ly/Lx is greater than 2, so it is designed as a one-way slab. Key parameters like effective depth, reinforcement diameter, grade of concrete and steel are specified. The loads, moment calculation, and required steel area are presented. The two-way slab has an aspect ratio less than 2, so it is designed as a two-way slab. Moment coefficients used for design are listed for different edge conditions. Design checks for deflection are also described for both slab types.

    Original Description:

    This is excel sheet for one way slab & two way slab design through indian standard

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document describes the design of a one-way and two-way slab. For the one-way slab, the aspect ratio Ly/Lx is greater than 2, so it is designed as a one-way slab. Key parameters like effective depth, reinforcement diameter, grade of concrete and steel are specified. The loads, moment calculation, and required steel area are presented. The two-way slab has an aspect ratio less than 2, so it is designed as a two-way slab. Moment coefficients used for design are listed for different edge conditions. Design checks for deflection are also described for both slab types.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    381 views8 pages

    Slab Design Excel Sheet

    Uploaded by

    Rajat Garg
    The document describes the design of a one-way and two-way slab. For the one-way slab, the aspect ratio Ly/Lx is greater than 2, so it is designed as a one-way slab. Key parameters like effective depth, reinforcement diameter, grade of concrete and steel are specified. The loads, moment calculation, and required steel area are presented. The two-way slab has an aspect ratio less than 2, so it is designed as a two-way slab. Moment coefficients used for design are listed for different edge conditions. Design checks for deflection are also described for both slab types.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 8

    Design of one way Slab over Platfrom

    Here the aspect ratio Ly/Lx is greater than 2 hence slab is designed as a one way slab
    OneShort or Both ShortEdgesDisContinuous: yes
    Basic dimensions of slab = Lx
    4.97
    Basic Ly/Lx ratio = 3.018
    Hence designed as an one way sl
    Clear cover to reinforcement d' =
    Provided overall depth D =
    Effective depth d =
    Diameter of bar =

    Select Grade of Concrete fck =


    Select Grade of Steel fy =

    Load calculation :

    Dead load of the slab DL =


    Floor finish(Roof finish) FF =
    Live load LL =

    Total load TL =
    Partial Safety factor for Load =

    Moment and Area of Steel calculations:

    Mu Mu/bd Pt Ast reqd Min Ast Dia of bar


    kN.m N/mm2 % mm mm mm
    50.95 1.6635 41.07% 718.77 210 10

    Check for Deflection

    The effective depth provided 175.00 mm


    basic values of span to effective depth ratio as per IS-456 20.000
    Modification factor(due to steel in tension) 1.50 ok
    Required depth under deflection consideration 165.78 mm
    SAFE
    15 4 250 3
    20 415
    25 500
    30
    Ly
    15
    >2
    Hence designed as an one way slab
    20 mm
    200.00 mm
    175.00 mm
    10 mm

    30 N/mm
    500 N/mm

    5.000 kN/m
    1 kN/m
    5 kN/m

    11.000 kN/m
    1.5

    Spacing Ast pro fs


    mm mm mm
    80 981.75 212.32 safe
    Design of two way Slab

    Here the aspect ratio Ly/Lx is less than 2 hence the slab is designed as a two way slab

    Basic dimensions of slab = Lx


    4.2
    Basic Ly/Lx ratio = 1.190
    Hence designed as two way
    Clear cover to reinforcement d' =
    Provided overall depth D =
    Effective depth d =
    Diameter of bar =

    Select Grade of Concrete fck =


    Select Grade of Steel fy =

    Load calculation :

    Dead load of the slab DL =


    Floor finish(Roof finish) FF =
    Live load LL =

    Total load TL =
    Partial Safety factor for Load =

    Moment and Area of Steel calculations:

    Span Moment Mu Mu/bd Pt Ast reqd Min Ast Dia of ba


    Coefficient kN.m N/mm2 % mm mm mm
    shorter x neg 0.0516 10.58 0.7348 17.40% 208.86 144 8
    x pos 0.0383 7.85 0.5454 12.82% 153.80 144 8
    longer y neg 0.0370 7.59 0.5269 12.37% 148.49 144 8
    y pos 0.0280 5.74 0.3987 9.32% 111.79 144 8

    Check for Deflection

    The effective depth provided


    120.000 mm
    basic values of span to effective depth ratio as per IS-456 20.000
    Modification factor 1.90 ok
    Required depth under deflection consideration 110.55 mm
    SAFE
    Equations used for the coeffients of moments as per IS-456 where x=ly/lx:
    x neg= (22367.96438)+(-154705.60435)*x+(478601.00515)*x^2+(-872204.92338)*x^3+(1037054.83924)*x^4+(-840710.22
    x pos= (-21990.92829)+(153380.33726)*x+(-478464.38992)*x^2+(879154.71853)*x^3+(-1053831.43198)*x^4+(861162.12
    15 4 250 3 Interior Panels
    20 415 One ShortEdge Discontinuous
    25 500 One LongEdge Discontinuous
    30 TwoAdjacentEdgesDisContinuous:
    Two ShortEdge Discontinuous
    Two LongEdge Discontinuous
    ThreeEdge Discontinuous(One LongEdge Continuous)
    ThreeEdge Discontinuous(One ShortEdge Continuous)
    FourEdges Discontinuous
    Interior Panels
    x neg =(22886.70646) + (-159082.39664)*x + (494573.40228)*x^2 + (-905702.46575)*x^3 + (1082019.99337)*x^4 + (-88
    x pos =(-63.93699) + (352.91736)*x + (-843.18116)*x^2 + (1139.21304)*x^3 + (-952.22031)*x^4 + (504.44431)*x^5+ (-165

    One ShortEdge Discontinuous


    x neg =(27131.67909) + (-188551.05381)*x + (586067.75442)*x^2 + (-1073040.31929)*x^3 + (1281706.33003)*x^4 + (-1
    x pos =(-22343.83133) + (156270.58175)*x + (-488819.24866)*x^2 + (900624.46506)*x^3 + (-1082453.82526)*x^4 + (88

    One LongEdge Discontinuous


    x neg =(22367.96438) + (-154705.60435)*x + (478601.00515)*x^2 + (-872204.92338)*x^3 + (1037054.83924)*x^4 + (-84
    x pos =(-21990.92829) + (153380.33726)*x + (-478464.38992)*x^2 + (879154.71853)*x^3 + (-1053831.43198)*x^4 + (86

    TwoAdjacentEdgesDisContinuous:
    x neg =(20926.03809) + (-145207.55868)*x + (450767.93314)*x^2 + (-824460.49501)*x^3 + (984017.64816)*x^4 + (-800
    x pos =(6655.85501) + (-45988.83401)*x + (142111.46438)*x^2 + (-258656.61143)*x^3 + (307113.37598)*x^4 + (-248588

    Two ShortEdge Discontinuous


    x neg =(17539.03462) + (-123182.17449)*x + (386858.2405)*x^2 + (-715456.89634)*x^3 + (862947.64818)*x^4 + (-7093
    x pos =(-3337.75952) + (22461.05744)*x + (-67512.63378)*x^2 + (119389.05755)*x^3 + (-137590.41213)*x^4 + (108004.

    Two LongEdge Discontinuous


    x neg =0
    x pos =(6667.77103) + (-45680.14152)*x + (139930.97634)*x^2 + (-252427.35875)*x^3 + (297004.88413)*x^4 + (-23819

    ThreeEdge Discontinuous(One LongEdge Continuous)


    x neg =(-12249.95581) + (86129.1813)*x + (-270814.31919)*x^2 + (501495.23042)*x^3 + (-605727.79846)*x^4 + (49866
    x pos =(-27933.55415) + (195573.69765)*x + (-612433.08247)*x^2 + (1129643.38702)*x^3 + (-1359257.78726)*x^4 + (11

    ThreeEdge Discontinuous(One ShortEdge Continuous)


    x neg =0
    x pos =(4095.20864) + (-27676.16755)*x + (83584.78359)*x^2 + (-148574.70986)*x^3 + (172162.20486)*x^4 + (-135908

    FourEdges Discontinuous
    x neg =0
    x pos =(13888.78711) + (-96794.43404)*x + (301681.03744)*x^2 + (-553768.99493)*x^3 + (663037.82538)*x^4 + (-54111
    Ly
    5

    Hence designed as two way slab


    25 mm
    150.00 mm
    120.00 mm
    10 mm

    30 N/mm
    500 N/mm

    3.750 kN/m
    2.5 kN/m
    1.5 kN/m

    7.750 kN/m
    1.5

    Spacing Ast pro fs


    mm mm mm
    200 251.33 241.00 safe
    200 251.33 177.47 safe
    200 251.33 171.34 safe
    200 251.33 128.99 safe

    037054.83924)*x^4+(-840710.22947)*x^5+(470649.20583)*x^6+(-179685.11132)*x^7+(44778.45028)*x^8+(-6578.20941)*x^9+(432.65003)*
    1053831.43198)*x^4+(861162.12518)*x^5+(-485899.74783)*x^6+(186942.94788)*x^7+(-46940.32179)*x^8+(6946.92632)*x^9+(-460.20735
    3 0.0516 0.0000
    0.0383 0.0000
    0.0714
    3 + (1082019.99337)*x^4 + (-881235.95905)*x^5+ (495554.82779)*x^6 + (-190012.87371)*x^7 + (47548.62255)*x^8 + (-7012.78838)*x^9 +
    31)*x^4 + (504.44431)*x^5+ (-165.48603)*x^6 + (30.75394)*x^7 + (-2.48015)*x^8 + (0)*x^9 + (0)*x^10)

    x^3 + (1281706.33003)*x^4 + (-1043717.86571)*x^5+ (586867.45702)*x^6 + (-225015.54361)*x^7 + (56308.71062)*x^8 + (-8305.50256)*x^


    3 + (-1082453.82526)*x^4 + (886860.54729)*x^5+ (-501666.52603)*x^6 + (193480.03519)*x^7 + (-48695.44764)*x^8 + (7222.77511)*x^9 +

    3 + (1037054.83924)*x^4 + (-840710.22947)*x^5+ (470649.20583)*x^6 + (-179685.11132)*x^7 + (44778.45028)*x^8 + (-6578.20941)*x^9 +


    3 + (-1053831.43198)*x^4 + (861162.12518)*x^5+ (-485899.74783)*x^6 + (186942.94788)*x^7 + (-46940.32179)*x^8 + (6946.92632)*x^9 +

    3 + (984017.64816)*x^4 + (-800898.00627)*x^5+ (450234.86907)*x^6 + (-172642.01947)*x^7 + (43219.25631)*x^8 + (-6379.24543)*x^9 +


    + (307113.37598)*x^4 + (-248588.21831)*x^5+ (138936.96369)*x^6 + (-52950.8062)*x^7 + (13171.29963)*x^8 + (-1931.21745)*x^9 + (126.7

    + (862947.64818)*x^4 + (-709353.35103)*x^5+ (402486.45246)*x^6 + (-155668.00593)*x^7 + (39280.76277)*x^8 + (-5840.22404)*x^9 + (3


    (-137590.41213)*x^4 + (108004.58227)*x^5+ (-58497.26668)*x^6 + (21591.7887)*x^7 + (-5199.24108)*x^8 + (737.70969)*x^9 + (-46.84746

    + (297004.88413)*x^4 + (-238191.55575)*x^5+ (131879.92697)*x^6 + (-49783.84202)*x^7 + (12264.38827)*x^8 + (-1780.75449)*x^9 + (115

    + (-605727.79846)*x^4 + (498667.09458)*x^5+ (-283398.41245)*x^6 + (109795.09562)*x^7 + (-27754.63572)*x^8 + (4134.14998)*x^9 + (-2


    x^3 + (-1359257.78726)*x^4 + (1114929.63342)*x^5+ (-631406.53972)*x^6 + (243798.76245)*x^7 + (-61430.23875)*x^8 + (9122.02598)*x^9

    (172162.20486)*x^4 + (-135908.79041)*x^5+ (74035.35485)*x^6 + (-27484.76307)*x^7 + (6655.92137)*x^8 + (-949.62554)*x^9 + (60.6261

    + (663037.82538)*x^4 + (-541113.1564)*x^5+ (304869.48572)*x^6 + (-117102.80404)*x^7 + (29351.03212)*x^8 + (-4335.31855)*x^9 + (28


    20941)*x^9+(432.65003)*x^10
    92632)*x^9+(-460.20735)*x^10
    x^8 + (-7012.78838)*x^9 + (462.96308)*x^10

    )*x^8 + (-8305.50256)*x^9 + (548.3908)*x^10


    x^8 + (7222.77511)*x^9 + (-479.49747)*x^10)

    ^8 + (-6578.20941)*x^9 + (432.65003)*x^10
    x^8 + (6946.92632)*x^9 + (-460.20735)*x^10)

    8 + (-6379.24543)*x^9 + (421.62709)*x^10
    1931.21745)*x^9 + (126.7637)*x^10)

    + (-5840.22404)*x^9 + (388.55829)*x^10)
    .70969)*x^9 + (-46.84746)*x^10)

    (-1780.75449)*x^9 + (115.74077)*x^10)

    + (4134.14998)*x^9 + (-275.57325)*x^10
    5)*x^8 + (9122.02598)*x^9 + (-606.26117)*x^10)

    49.62554)*x^9 + (60.62612)*x^10)

    (-4335.31855)*x^9 + (286.59619)*x^10)

    You might also like