{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["tension controls","compression controls","Breslers Eq"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"tension controls","index":0,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[[52,0,52,1],[5,1,5,2],[45,5,45,6],[4,1,4,2],[3,1,3,2],[37,2,37,3],[40,2,40,3]]}
[]
[]
[]
["PROJECT:",null,null,"PAGE:"]
["CLIENT:",null,null,"DESIGN BY:"]
["JOB: ","COLUMN 1 ",null,"REVIEW BY:"]
["DATE:",{"$f":"TODAY()","v":"2015-07-01"},null,"www.samotech.net"]
[]
["ECCCENTRICALLY LOADED COLUMNS (TENSION CONTROLS)"]
["w (mm)",300,"fc' (Mpa)",20.7]
["h (mm)",300,"fy (Mpa)",275]
["d' (mm)",75,"e (mm)",{"$f":"ROUND(D14/D13*1000,2)","v":1000}]
["no of bars at d' ",10,"Pu actual",12,"KN"]
["bar dia (mm)",16,"Mu actual",12,"KN-m"]
["no of bars at s",{"$f":"B13","v":10}]
["bar dia (mm)",{"$f":"B14","v":16}]
["no of bars at NA",0,"Lat tie dia",10,"mm"]
["For a balanced condition"]
["fs'=fy",null,null,"ΣMA=0"]
["C1=0.85fc'(h)a",{"$f":"CONCATENATE(0.85*D10*B11,\" a\")","v":"5278.5 a"},null,"Pb(x) = C1 (d-a/2)+ C2(d-d')"]
["d = w- d'",{"$f":"B10-B12","v":225},{"$f":"IF(B21<0,\"increase value of w\",\"\")","v":""},"x=",{"$f":"(((B24*(B21-(B23/2)))+(B25*(B21-B12))))/B28","v":279.24010648236981}]
["cb=600d/600+fy",{"$f":"B21*600/(600+D11)","v":154.28571428571428},null,"eb = x- d-(w/2)",{"$f":"E21-(B21-(B10/2))","v":204.24010648236981}]
["a= 0.85 Cb",{"$f":"B22*0.85","v":131.14285714285714},null,"REMARKS",{"$f":"IF(E22<D12,\"Tension Controls\",\"Compression Controls\")","v":"Tension Controls"}]
["C1=0.85fc'(h)a",{"$f":"0.85*D10*B11*B23","v":692237.57142857136},"N"]
["C2=As'fs'",{"$f":"B13*PI()*(B14^2)*D11/4","v":552920.30703180353},"N"]
["T = AsFy",{"$f":"B15*PI()*B16^2*D11/4","v":552920.30703180353},"N"]
["ΣFv=0","T + Pb = C1 +C2"]
["Pb = C1+C2-T",{"$f":"B24+B25-B26","v":692237.57142857136},"N"]
[]
[]
["Assume fs' =fy"]
["ΣFv=0","T + Pn = C1 +C2",null,null,null,null,{"$f":"B10","v":300}]
["Pn=C1+C2-T",{"$f":"CONCATENATE((0.85*D10*B11)+B25-B26,\" a\")","v":"5278.5 a"},"N"]
["ΣMA=0"]
["moment arm of Pn",{"$f":"B21-(B10/2)+D12","v":1075},"mm"]
[{"$f":"CONCATENATE(((0.85*D10*B11)+B25-B26)*B35,\" a=\")","v":"5674387.5 a="},{"$f":"CONCATENATE(((0.85*D10*B11)+B25-B26)*(B21), \"a\")","v":"1187662.5a"},{"$f":"CONCATENATE(((0.85*D10*B11)+B25-B26)*-0.5, \"a^2\")","v":"-2639.25a^2"},{"$f":"B25*(B21-B12)","v":82938046.054770529},null,{"$f":"B11","v":300}]
[{"$f":"((0.85*D10*B11)+B25-B26)*B35","v":5674387.5},{"$f":"((0.85*D10*B11)+B25-B26)*(B21)","v":1187662.5},{"$f":"((0.85*D10*B11)+B25-B26)*-0.5","v":-2639.25},{"$f":"B25*(B21-B12)","v":82938046.054770529}]
[{"$f":"-C37","v":2639.25},{"$f":"A37-B37","v":4486725},{"$f":"-D37","v":-82938046.054770529}]
[{"$f":"A38/A38","v":1},{"$f":"B38/A38","v":1700},{"$f":"C38/A38","v":-31424.854051253398}]
["BY QUADRATIC EQUATION",null,null,null,"z"]
["a=",{"$f":"((-B39)+(SQRT((B39^2)-(4*A39*C39))))/(2*A39)","v":18.288462465817474},{"$f":"((-B39)-(SQRT((B39^2)-(4*A39*C39))))/(2*A39)","v":-1718.2884624658175}]
["use a = ",{"$f":"MAX(B41:D41)","v":18.288462465817474}]
[null,null,null,null,null,"Main Reinforcements"]
["Pn =",{"$f":"((0.85*D10*B11)+B25-B26)*B42/1000","v":96.535649125817542},"KN",null,null,{"$f":"CONCATENATE(B17+B15+B13,\"-\")","v":"20-"},{"$f":"CONCATENATE(B14, \" mm diameter main bars\")","v":"16 mm diameter main bars"}]
["Pu = φ Pn",{"$f":"ROUND(B44*0.7,2)","v":67.569999999999993},"KN",null,null,"Lateral Tie Reinforcement"]
["REMARKS",{"$f":"IF(E22<D12,CONCATENATE(\"SAFE LOAD IT COULD CARRY IS \",B45,\" KN\"),\"Design Inadequate-Compression Controls\")","v":"SAFE LOAD IT COULD CARRY IS 67.57 KN"},null,null,null,{"$f":"CONCATENATE(D17,\" mm dia spaced at\")","v":"10 mm dia spaced at"},null,{"$f":"CONCATENATE(B64,\" mm O.C.\")","v":"256 mm O.C."}]
["Mu = Pu e",{"$f":"ROUND(B45*D12/1000,2)","v":67.569999999999993},"KN-m"]
["REMARKS",{"$f":"IF(E22<D12,CONCATENATE(\"SAFE MOMENT IT COULD CARRY IS \",B47,\" KN-m\"),\"Design Inadequate-Compression Controls\")","v":"SAFE MOMENT IT COULD CARRY IS 67.57 KN-m"}]
[]
["Check "]
["Cb =a/0.85",{"$f":"ROUND(B42/0.85,2)","v":21.52}]
["Cb-d'",{"$f":"ROUND(B51-B12,2)","v":-53.48}]
[{"$f":"CONCATENATE(\"Es'/\",B52,\"=0.003/\",B51)","v":"Es'/-53.48=0.003/21.52"}]
["Es'=",{"$f":"B52*0.003/B51","v":-7.4553903345724905E-3}]
["Es'=fs'/Es"]
["fs' = Es'*Es",{"$f":"ROUND(B54*200000,0)","v":-1491},"MPA"]
["REMARKS",{"$f":"IF(OR(D11+1=B56,D11-1=B56),\"Satisfactory\", \"Assumption  that fs'=fy is not satisfied\")","v":"Assumption  that fs'=fy is not satisfied"}]
["LATERAL TIE DESIGN"]
[]
["Main bar * 16 =",{"$f":"16*B14","v":256}]
["Tie bar * 48 =",{"$f":"48*D17","v":480}]
["Least dimension =",{"$f":"MIN(B10,B11)","v":300}]
[]
["Governing spacing =",{"$f":"MIN(B60,B61,B62)","v":256}]

{"sheet":"compression controls","index":1,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,4,2],[5,1,5,2],[28,0,28,1],[68,5,68,6],[38,0,38,1],[39,0,39,1],[42,0,42,1],[45,1,45,2]]}
[]
[]
[]
["PROJECT:",null,null,"PAGE:"]
["CLIENT:",null,null,"DESIGN BY:"]
["JOB: ",null,null,"REVIEW BY:"]
["DATE:",{"$f":"TODAY()","v":"2015-07-01"},null,"www.samotech.net"]
[]
["ECCCENTRICALLY LOADED COLUMNS (COMPRESSION CONTROLS)"]
[]
["w (mm)",250,"fc' (Mpa)",20.7]
["h (mm)",250,"fy (Mpa)",275]
["d' (mm)",58,"e (mm)",{"$f":"ROUND(D15/D14*1000,2)","v":95.89}]
["no of bars at d' ",2,"Pu actual",73,"KN"]
["bar dia (mm)",16,"Mu actual",7,"KN-m"]
["no of bars at s",{"$f":"B14","v":2}]
["bar dia (mm)",{"$f":"B15","v":16}]
["no of bars at NA",2,"Lat tie dia",10,"mm"]
["For a balanced condition"]
["fs'=fy",null,null,"ΣMA=0"]
["C1=0.85fc'(h)a",{"$f":"CONCATENATE(0.85*D11*B12,\" a\")","v":"4398.75 a"},null,"Pb(x) = C1 (d-a/2)+ C2(d-d')"]
["d = w- d'",{"$f":"B11-B13","v":192},{"$f":"IF(B22<0,\"increase value of w\",\"\")","v":""},"x=",{"$f":"(((B32*(B22-(B31/2)))+(B23*(B22-B13))))/B32","v":166.14836246798114}]
["C2=As'fs'",{"$f":"B14*PI()*(B15^2)*D12/4","v":110584.06140636072},"N","eb = x- d-(w/2)",{"$f":"E22-(B22-(B11/2))","v":99.148362467981144}]
["T = AsFy",{"$f":"B16*PI()*B17^2*D12/4","v":110584.06140636072},"N","REMARKS",{"$f":"IF(E23<D13,\"Tension Controls\",\"Compression Controls\")","v":"Compression Controls"}]
["ΣFv=0","T + Pb = C1 +C2"]
[{"$f":"B24","v":110584.06140636072},"+ Pb =",{"$f":"CONCATENATE(B21,\" +\")","v":"4398.75 a +"},{"$f":"B23","v":110584.06140636072}]
["Pb=",{"$f":"B21","v":"4398.75 a"}]
["By ratio and proportion"]
["Ey+0.003/d = Ec/Cb"]
["Cb=600d/600+fy",{"$f":"600*B22/(600+D12)","v":131.65714285714284},"mm"]
["a=0.85Cb",{"$f":"0.85*B30","v":111.90857142857142},"mm"]
["Pb=",{"$f":"0.85*D11*B12*B31","v":492257.82857142854},"N"]
[]
[]
["fs = fy"]
["C2= As'fy",{"$f":"B14*PI()*(B15^2)*D12/4","v":110584.06140636072}]
["C1=0.85fc' *a*b",{"$f":"CONCATENATE(\"= \",0.85*D11*0.85*B12,\" C\")","v":"= 3738.9375 C"}]
["Es/d-C = εc/C"]
["εs = 0.003 (d-C)/C",null,"fs=εs Es"]
["εs = (0.003 (d-C)/C)200000",null,"=600(d-C)/C"]
["T=Asfs",{"$f":"ROUND(PI()*B17^2*3*600/4,2)","v":361911.47},"(d-C)/C"]
["ΣFv=0","T+Pn=C1+C2"]
[{"$f":"CONCATENATE(B41,C41)","v":"361911.47(d-C)/C"},null,"+ Pn ",{"$f":"CONCATENATE(B37,\" +\")","v":"= 3738.9375 C +"},{"$f":"B36","v":110584.06140636072},"Equation 1"]
["ΣMA=0"]
["moment arm of Pn",{"$f":"B22-(B11/2)+D13","v":162.88999999999999},"mm"]
[{"$f":"CONCATENATE(B45,\" Pn \")","v":"162.89 Pn "},{"$f":"CONCATENATE(B37,\"(\",B22,\"-0.425C) +\")","v":"= 3738.9375 C(192-0.425C) +"},null,{"$f":"B36*(B22-B13)","v":14818264.228452336}]
["Pn =",{"$f":"ROUND(0.85*D11*0.85*B12/B45,2)","v":22.95},{"$f":"CONCATENATE(\"C(\",B22,\"-0.425C) +\")","v":"C(192-0.425C) +"},{"$f":"D46/B45","v":90970.987957838646},null,"Equation 2"]
["Combining Eq 1 and 2"]
[{"$f":"B41*B22","v":69487002.239999995},{"$f":"-B41","v":-361911.47},{"$f":"CONCATENATE(B47*B22,\"C\")","v":"4406.4C"},{"$f":"CONCATENATE(-B47*0.425,\" C^2\")","v":"-9.75375 C^2"},{"$f":"ROUND(D47,2)","v":90970.99},{"$f":"CONCATENATE(-0.85*D11*0.85*B12,\" C\")","v":"-3738.9375 C"},{"$f":"ROUND(-E43,2)","v":-110584.06},"=0"]
["C"]
[{"$f":"A49","v":69487002.239999995},{"$f":"CONCATENATE(B49,\"C\")","v":"-361911.47C"},{"$f":"CONCATENATE(B47*B22,\"C^2\")","v":"4406.4C^2"},{"$f":"CONCATENATE(-B47*0.425,\" C^3\")","v":"-9.75375 C^3"},{"$f":"CONCATENATE(E49,\"C\")","v":"90970.99C"},{"$f":"CONCATENATE(-0.85*D11*0.85*B12,\" C^2\")","v":"-3738.9375 C^2"},{"$f":"CONCATENATE(G49,\" C\")","v":"-110584.06 C"},"=0"]
[{"$f":"A49","v":69487002.239999995},{"$f":"B49","v":-361911.47},{"$f":"B47*B22","v":4406.3999999999996},{"$f":"-B47*0.425","v":-9.7537500000000001},{"$f":"E49","v":90970.99},{"$f":"-0.85*D11*0.85*B12","v":-3738.9374999999995},{"$f":"G49","v":-110584.06}]
[{"$f":"D52","v":-9.7537500000000001},{"$f":"C52","v":4406.3999999999996},{"$f":"F52","v":-3738.9374999999995},{"$f":"B52","v":-361911.47},{"$f":"E52","v":90970.99},{"$f":"G52","v":-110584.06},{"$f":"A51","v":69487002.239999995}]
[{"$f":"A53/A53","v":1},{"$f":"ROUND((B53+C53)/A53,2)","v":-68.430000000000007},{"$f":"ROUND((D53+E53+F53)/A53,2)","v":39115.68},{"$f":"ROUND(G53/A53,2)","v":-7124131.9699999997}]
["c^3",{"$f":"CONCATENATE(B54,\"C^2\")","v":"-68.43C^2"},{"$f":"CONCATENATE(C54,\"C\")","v":"39115.68C"},{"$f":"D54","v":-7124131.9699999997},"=0"]
["Using Newtons Law of Approximation:"]
["y=",{"$f":"(B59^3)+(B54*B59^2)+(C54*B59)+D54","v":61.749187649227679}]
["y'=",{"$f":"(3*B59^2)+(B54*2*B59)+C54","v":80943.133759608259},null,null,null,null,{"$f":"B11","v":250}]
["C1",143.07130169982398]
["C= C1 - y/y'",{"$f":"B59-(B57/B58)","v":143.07053882859844}]
[null,{"$f":"B57/B58","v":7.6287122552748724E-4}]
[{"$f":"B41*(B22-B60)/B60","v":123772.04534096693},"+Pn =",{"$f":"0.85*D11*0.85*B12*B60","v":534931.8027714527},{"$f":"E43","v":110584.06140636072},null,{"$f":"B12","v":250}]
["Pn =",{"$f":"C62+D62-A62","v":521743.81883684651},"N"]
["Pn =",{"$f":"ROUND(B63/1000,2)","v":521.74},"KN"]
["Pu = φ Pn",{"$f":"ROUND(B64*0.7,2)","v":365.22},"KN"]
["REMARKS",{"$f":"IF(E23<D13,\"Design Inadequate-Tension Controls\",CONCATENATE(\"SAFE LOAD IT COULD CARRY IS \",B65,\" KN\"))","v":"SAFE LOAD IT COULD CARRY IS 365.22 KN"},null,null,null,"Main Reinforcements"]
["Mu=Pu e",{"$f":"ROUND(B65*D13/1000,2)","v":35.020000000000003},"KN-m",null,null,{"$f":"CONCATENATE(B14+B16+B18, \" -\")","v":"6 -"},{"$f":"CONCATENATE(B15, \" mm diameter main bars\")","v":"16 mm diameter main bars"}]
["REMARKS",{"$f":"IF(E23<D1,\"Design Inadequate-Compression Controls\",CONCATENATE(\"SAFE MOMENT IT COULD CARRY IS \",B67,\" KN-m\"))","v":"SAFE MOMENT IT COULD CARRY IS 35.02 KN-m"},null,null,null,"Lateral Tie Reinforcement"]
["Check",null,null,null,null,{"$f":"CONCATENATE(D18,\" mm dia spaced at\")","v":"10 mm dia spaced at"},null,{"$f":"CONCATENATE(B79,\" mm O.C.\")","v":"250 mm O.C."}]
["εs'/C-d' = 0.003/C",null,"εs'=",{"$f":"0.003*(B60-B13)/B60","v":1.7838167003169274E-3}]
[null,null,"εy= fy/Es",{"$f":"D12/200000","v":1.3749999999999999E-3}]
["REMARKS",{"$f":"IF(D71<D70,\"Satisfactory-Compression Steel Yields\",\"Design Error-Compression steel did not yield\")","v":"Satisfactory-Compression Steel Yields"}]
["LATERAL TIE DESIGN"]
[]
["Main bar * 16 =",{"$f":"16*B15","v":256}]
["Tie bar * 48 =",{"$f":"48*D18","v":480}]
["Least dimension =",{"$f":"MIN(B11,B12)","v":250}]
[]
["Governing spacing =",{"$f":"MIN(B75,B76,B77)","v":250}]

{"sheet":"Breslers Eq","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,1,2],[2,1,2,2],[33,0,33,4],[34,0,34,4]]}
["PROJECT:",null,null,"PAGE:"]
["CLIENT:",null,null,"DESIGN BY:"]
["JOB: ",null,null,"REVIEW BY:"]
["DATE:",null,null,"www.samotech.net"]
[]
["COLUMNS SUBJECTED TO BENDING ON BOTH AXES"]
["BRESLER'S EQUATION"]
[]
[]
[]
["w (mm)",300,"fc' (Mpa)",20.7]
["h (mm)",300,"fy (Mpa)",275]
["d' (mm)",38,"Pu actual =",187]
["no of bars at d' ",3]
["bar dia (mm)",16]
["no of bars at s",{"$f":"B14","v":3}]
["bar dia (mm)",{"$f":"B15","v":16}]
["no of bars at NA",0,"Lat tie dia",10,"mm"]
[]
["Pnx =",419,"theoretical axial capacity if bending occurs about x-axis only"]
["Pny =",1457,"theoretical axial capacity if bending occurs about y-axis only"]
[]
[]
["Ag",{"$f":"B11*B12","v":90000},"mm2"]
["Ast",{"$f":"PI()*B15*B15*(B14+B16+B18)/4","v":1206.3715789784806},"mm2"]
["Po",{"$f":"((B25*D12)+((B24-B25)*(0.85*D11)))/1000","v":1894.0760762869556},"KN"]
[]
["1/Pnx",{"$f":"1/B20","v":2.3866348448687352E-3}]
["1/Pny",{"$f":"1/B21","v":6.863417982155113E-4}]
["1/Po",{"$f":"1/B26","v":5.2796189789818047E-4}]
["1/Pn",{"$f":"B28+B29-B30","v":2.5450147451860656E-3}]
["Pn=",{"$f":"1/B31","v":392.92503192428074}]
["Pu=",{"$f":"0.7*B32","v":275.04752234699652}]
[{"$f":"IF(B32>=0.1*B26,\"BRESLER EQUATION IS APPLICABLE\",\"BRESLER'S EQUATION IS NOT APPLICABLE\")","v":"BRESLER EQUATION IS APPLICABLE"}]
[{"$f":"IF(B33>=D13,\"SATISFACTORY\",\"INADEQUATE\")","v":"SATISFACTORY"}]