{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Main","Sheet2","Revision Log"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Main","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[39,9,39,11],[40,9,40,11],[30,9,30,11],[31,9,31,11],[32,9,32,11],[33,9,33,11],[34,9,34,11],[35,9,35,11],[36,9,36,11],[22,9,22,11],[23,9,23,11],[24,9,24,11],[37,9,37,11],[38,9,38,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[28,9,28,11],[29,9,29,11],[20,1,20,3],[20,4,20,6],[12,9,12,11],[20,9,20,11],[21,9,21,11]]}
[{"$f":"IF(Sheet2!S1=1,Sheet2!Q1,Sheet2!Q2)","v":"Slab Flexural Strength"}]
[]
["Material Properties"]
["fc'=",{"$f":"Sheet2!F3","v":28},"N/mm2",null,null,"b=",{"$f":"LOOKUP(B4,Sheet2!A2:A50,Sheet2!B2:B50)","v":0.85},null,null,null,null,null,null,"ACI 318M-08 10.2.7.3 "]
["Fy=",{"$f":"Sheet2!J3","v":420},"N/mm2"]
[]
["Cross Section Properties",null,null,null,null,null,null," "]
["b=",1000,"mm"]
["t=",500,"mm"]
["Cover=",50,"mm",null,null,"Effective depth (d)=",{"$f":"B9-B10","v":450},"mm","(Depth to the center of reinforcing steel)"]
[]
["Reinforcement Data"]
[5,"T",16,null,"Area Steel Used=",{"$f":"A13*PI()*C13*C13/4","v":1005.3096491487338},"mm2,","r=",{"$f":"IF(Sheet2!S1=1,F13/B8/G10,Main!F13/Main!B8/Main!B9)","v":2.0106192982974678E-3},{"$f":"IF(I13>I14,\"Exceeds max. value\",IF(I13<I15,\"Less than min.\",\"\"))","v":""},null,null,"w=",{"$f":"I13*B5/B4","v":3.0159289474462021E-2}]
[null,null,null,null,null,null,null,"rmax=",{"$f":"0.85*G4*B4/B5*(1-B5/(600+B5))*0.75","v":2.1249999999999998E-2},null,null,null,null,"ACI 318M-08 10.3.5"]
[null,null,null,null,null,null,null,"rmin=",{"$f":"IF(Sheet2!S1=1,MIN(1.3*F13,MAX(0.25*B4^0.5/B5,1.4/B5)),0.0018*420/Main!B5)","v":1.8E-3},null,null,null,null,"ACI 318M-08 10.5.1"]
["Section Flexural Strength",null,null,null,null,null,null,"Flexural reduction factor f=",0.9,null,null,null,null,"ACI 318M-08 9.3.2.1"]
["a=",{"$f":"I13*G10*B5/G4/B4","v":15.966682662950481},"mm"]
["fMn=",{"$f":"I16*B4*B8*G10*G10*N13*(1-0.59*N13)/1000000","v":151.16430975723944},"KN.m",null,null,null,null,null,null,null,null,null,null,"ACI 318M-08 10.2"]
[]
["More Reinforcement Options and Relevant Flexural Capacities:"]
["s/n","Main Reinforcement",null,null,"Additional Reinforcement",null,null,"As used","Flexural Strength","% As Check"]
[1,6.6666999999999996,"T",32,6.6666999999999996,"T",32,{"$f":"PI()*D22*D22/4*B22+PI()*G22*G22*E22/4","v":10723.356540767782},2455.2126272579071,""]
[2,0,"T",20,0,"T",10,{"$f":"PI()*D23*D23/4*B23+PI()*G23*G23*E23/4","v":0},0,"Less than min."]
[3,0,"T",25,0,"T",10,0,0,"Less than min."]
[4,0,"T",25,0,"T",25,0,0,"Less than min."]
[5,0,"T",25,0,"T",25,0,0,"Less than min."]
[6,0,"T",25,0,"T",25,0,0,"Less than min."]
[7,0,"T",32,0,"T",16,0,0,"Less than min."]
[8,0,"T",32,0,"T",25,0,0,"Less than min."]
[9,0,"T",32,0,"T",25,0,0,"Less than min."]
[10,0,"T",32,0,"T",25,0,0,"Less than min."]
[11,0,"T",32,0,"T",32,0,0,"Less than min."]
[12,0,"T",32,0,"T",32,0,0,"Less than min."]
[13,0,"T",32,0,"T",32,0,0,"Less than min."]
[14,0,"T",32,0,"T",32,0,0,"Less than min."]
[15,0,"T",10,0,"T",10,0,0,"Less than min."]
[16,0,"T",10,0,"T",10,0,0,"Less than min."]
[17,0,"T",10,0,"T",10,0,0,"Less than min."]
[18,0,"T",10,0,"T",10,0,0,"Less than min."]
[19,0,"T",10,0,"T",10,0,0,"Less than min."]
[20,0,"T",32,0,"T",10,0,0,"Less than min."]
[]
["Beam Shear Strength"]
[]
[null,"Shear reduction factor f=",null,null,0.75]
[null,"Stirrups used",null,0,"@",150,null,"No. of branches =",null,2]
[null,"Vc =",{"$f":"0.17*B8*G10*B4^0.5/1000","v":404.7999505928824},"KN"]
[null,"Vs =",{"$f":"PI()*D46^2/4*J46*B5*G10/F46/1000","v":0},"KN",null,"Vsmax =",{"$f":"0.66*B8*G10*B4^0.5/1000","v":1571.576278772367},"KN"]
[null,"fVn =",{"$f":"E45*(C47+MIN(C48,G48))","v":303.5999629446618},"KN"]
[null,"Vu =",609,"KN",{"$f":"IF(C50<=C49,\"< Vn ---- SAFE\",\"> Vn ---- UNSAFE\")","v":"> Vn ---- UNSAFE"}]

{"sheet":"Sheet2","index":1,"n_rows":50,"n_cols":19,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["fc'","b",null,null,"fc'",null,null,null,"fy",null,null,null,"Bar Diameter",null,null,null,"Beam Flexural Strength","BEAM",2]
[17,0.85,null,1,24,2,null,1,360,2,null,1,8,2,null,{"$f":"PI()*Main!C13*Main!C13/4*Main!A13","v":1005.3096491487338},"Slab Flexural Strength","SLAB / FOOTING"]
[18,0.85,null,2,28,{"$f":"LOOKUP(F2,D2:D10,E2:E10)","v":28},null,2,420,{"$f":"LOOKUP(J2,H2:H4,I2:I4)","v":420},null,2,10,{"$f":"LOOKUP(N2,L2:L12,M2:M12)","v":10}]
[19,0.85,null,3,32,null,null,3,460,null,null,3,12]
[20,0.85,null,4,36,null,null,null,null,null,null,4,14]
[21,0.85,null,5,40,null,null,null,null,null,null,5,16]
[22,0.85,null,6,45,null,null,null,null,null,null,6,18]
[23,0.85,null,7,50,null,null,null,null,null,null,7,20]
[24,0.85,null,8,55,null,null,null,null,null,null,8,22]
[25,0.85,null,9,60,null,null,null,null,null,null,9,25]
[26,0.85,null,null,null,null,null,null,null,null,null,10,28]
[27,0.85,null,null,null,null,null,null,null,null,null,11,32]
[28,0.85]
[29,{"$f":"B13-(A14-A13)/7*0.05","v":0.84285714285714286}]
[30,{"$f":"B14-(A15-A14)/7*0.05","v":0.83571428571428574}]
[31,0.82857142857142863]
[32,0.82142857142857151]
[33,0.81428571428571439]
[34,0.80714285714285727]
[35,0.80000000000000016]
[36,0.79285714285714304]
[37,0.78571428571428592]
[38,0.7785714285714288]
[39,0.77142857142857169]
[40,0.76428571428571457]
[41,0.75714285714285745]
[42,0.75000000000000033]
[43,0.74285714285714322]
[44,0.7357142857142861]
[45,0.72857142857142898]
[46,0.72142857142857186]
[47,0.71428571428571475]
[48,0.70714285714285763]
[49,0.70000000000000051]
[50,0.69285714285714339]
[51,0.68571428571428628]
[52,0.67857142857142916]
[53,0.67142857142857204]
[54,0.66428571428571492]
[55,0.65714285714285781]
[56,0.65000000000000069]
[57,0.65]
[58,0.65]
[59,0.65]
[60,0.65]
[61,0.65]
[62,0.65]
[63,0.65]
[64,0.65]
[65,0.65]

{"sheet":"Revision Log","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Revisions Log"]
[]
["RevisionNo.","Date","Description"]
["00","2008-12-31","First release."]
["01","2009-01-04","File saved as xlsm (Macros enabled) and ACI refernce for min. persentage of steel added."]
["02","2009-02-16","Macro has been ammended to correctly copy the results from the solver."]
["03","2009-05-05","Differentiate between Beam and slab in the title and min. percentage of steel"]
[4,2012,"Shear reinforcement calculations added"]
[5,"2009-10-09","As min updated with the value of 1.3 As req & shrinkage reinf. To be w.r.t. concrete gross area"]