{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Loadings","bar Size","Reinf","Geometry","Constants","Sheet1","beam","graph"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"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":"Loadings","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"bar Size","index":1,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[null,2.0,2.0,3.0,7.0,null,1.0,3.0,1.0,4.0,null,1.0,3.0,3.0,3.0]
[null,10.0,null,10.0,null,null,10.0,null,10.0,null,null,10.0,null,10.0]
[null,12.0,10.0,12.0,10.0,null,12.0,10.0,12.0,10.0,null,12.0,10.0,12.0,10.0]
[null,16.0,12.0,16.0,12.0,null,16.0,12.0,16.0,12.0,null,16.0,12.0,16.0,12.0]
[null,20.0,16.0,20.0,16.0,null,20.0,16.0,20.0,16.0,null,20.0,16.0,20.0,16.0]
[null,25.0,20.0,25.0,20.0,null,25.0,20.0,25.0,20.0,null,25.0,20.0,25.0,20.0]
[null,32.0,25.0,32.0,25.0,null,32.0,25.0,32.0,25.0,null,32.0,25.0,32.0,25.0]
[null,40.0,32.0,40.0,32.0,null,40.0,32.0,40.0,32.0,null,40.0,32.0,40.0,32.0]
[null,null,40.0,null,40.0,null,null,40.0,null,40.0,null,null,40.0,null,40.0]
[]
[null,{"$f":"IF(B1=1,B2,IF(B1=2,B3,IF(B1=3,B4,IF(B1=4,B5,IF(B1=5,B6,IF(B1=6,B7,B8))))))","v":12},10,16,32,null,{"$f":"IF(G1=1,G2,IF(G1=2,G3,IF(G1=3,G4,IF(G1=4,G5,IF(G1=5,G6,IF(G1=6,G7,G8))))))","v":10},12,10,16,null,{"$f":"IF(L1=1,L2,IF(L1=2,L3,IF(L1=3,L4,IF(L1=4,L5,IF(L1=5,L6,IF(L1=6,L7,L8))))))","v":10},12,16,12]

{"sheet":"Reinf","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Geometry","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Constants","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet1","index":5,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":true,"merged":[[5,16,5,17],[6,1,6,17],[1,9,1,10],[2,9,2,10],[3,9,3,10],[4,9,4,10],[4,14,4,15],[5,9,5,10],[5,14,5,15],[18,5,18,9]]}
[]
[null,null,null,null,null,null,null,null,null,"Project:",null,"Project"]
[null,null,null,null,null,null,null,null,null,"Location:",null,"Location"]
[null,null,null,null,null,null,null,null,null,"Client:",null,"Client"]
[null,null,null,null,null,null,null,null,null,"Designed by:",null,"RCF",null,null,"Checked by:",null,"RCF"]
[null,null,null,null,null,null,null,null,null,"Subject:",null,"@ Grid A-1",null,null,"Date:",null,"2011-03-26"]
[null,"DESIGN OF RC BEAM AS PER ACI 318-08"]
[null,"Input Data:"]
[]
[null,"Geometry:",null,null,null,null,null,null,null,null,null,null,null,"Material Properties:"]
[null,null,null,null,"Beam Length, L =",10.0,"m",null,null,"Concrete cover, Cc =",50.0,"mm",null,null,null,null,"Concrete Strength, f'c =",20.7,"Mpa"]
[null,null,null,null,"Beam Width, B =",250.0,"mm",null,null,"Start Face, SF =",100.0,"mm",null,null,null,null,"Reinf. Yeild Strength, Fy =",415.0,"Mpa"]
[null,null,null,null,"Beam Depth, H =",500.0,"mm",null,null,"End Face, EF =",100.0,"mm"]
[]
[null,"Loadings:"]
[null,null,null,null,null,"Mu",null,null,"Vu",null,null,"Mu",null,null,null,null,null,"Mu",null,null,"Vu"]
[null,null,null,null,null,null,"kN-m",null,null,"kN",null,null,"kN-m",null,null,null,null,null,"kN-m",null,null,"kN"]
[]
[null,null,null,null,null,"     Left Support",null,null,null,null,null,null,null,"Midspan",null,null,null,null,"       Right Support"]
[]
[]
[]
[null,"Top Reinf."]
[null,null,"Reinf. (Strength)",null,null,51.66953789912609,"mm2",null,0.020382460709714435,null,null,0.0,"mm2",null,0.0,null,null,12.454155770459739,"mm2",null,0.004912881960733624]
[null,null,"Reinf. (Critical)",null,null,51.66953789912609,"mm2",null,0.020382460709714435,null,null,0.0,"mm2",null,0.0,null,null,12.454155770459739,"mm2",null,0.004912881960733624]
[]
[null,null,"Trials",null,null,"Dia 1","Nos.",null,"Dia 2","Nos.",null,"Dia 1","Nos.",null,"Dia 2","Nos.",null,"Dia 1","Nos.",null,"Dia 2","Nos."]
[null,null,"Same dia bars",null,null,25.0,11.0,null,null,null,null,10.0,0.0,null,null,null,null,20.0,4.0]
[]
[null,null,"Mixed dia bars",null,null,28.0,9.0,"+",20.0,-1.0,null,null,null,"+",null,"",null,null,null,"+",null,""]
[]
[]
[null,"Bottom Reinf."]
[null,null,"Reinf. (Strength)",null,null,51.66953789912609,"mm2",null,0.020382460709714435,null,null,0.0,"mm2",null,0.0,null,null,12.454155770459739,"mm2",null,0.004912881960733624]
[null,null,"Reinf. (Critical)",null,null,51.66953789912609,"mm2",null,0.020382460709714435,null,null,0.0,"mm2",null,0.0,null,null,12.454155770459739,"mm2",null,0.004912881960733624]
[]
[null,null,"Trials",null,null,"Dia 1","Nos.",null,"Dia 2","Nos.",null,"Dia 1","Nos.",null,"Dia 2","Nos.",null,"Dia 1","Nos.",null,"Dia 2","Nos."]
[null,null,"Same dia bars",null,null,25.0,11.0,null,null,null,null,10.0,0.0,null,null,null,null,20.0,4.0]
[]
[null,null,"Mixed dia bars",null,null,28.0,9.0,"+",20.0,-1.0,null,null,null,"+",null,"",null,null,null,"+",null,""]

{"sheet":"beam","index":6,"n_rows":167,"n_cols":73,"rows_kept":167,"cut":false,"hidden":false,"merged":[[101,36,101,37],[102,36,102,37],[103,15,103,20],[103,36,103,37],[104,36,104,37],[105,36,105,37],[106,36,106,37],[107,36,107,37],[108,36,108,37],[111,36,111,37],[112,36,112,37],[116,36,116,37],[117,36,117,37],[118,36,118,37],[129,36,129,37],[130,36,130,37],[133,36,133,37],[134,36,134,37],[135,36,135,37],[136,36,136,37],[137,36,137,37],[138,36,138,37],[119,36,119,37],[120,36,120,37],[121,36,121,37],[125,36,125,37],[126,36,126,37],[127,36,127,37],[128,36,128,37],[49,35,49,36],[50,35,50,36],[52,6,52,7],[53,6,53,7],[54,6,54,7],[55,6,55,7],[56,6,56,7],[55,36,55,37],[56,36,56,37],[58,36,58,37],[59,36,59,37],[60,36,60,37],[61,36,61,37],[62,36,62,37],[57,6,57,7],[58,6,58,7],[59,6,59,7],[60,6,60,7],[61,6,61,7],[62,6,62,7],[63,6,63,7],[63,36,63,37],[64,36,64,37],[65,36,65,37],[70,36,70,37],[71,36,71,37],[73,36,73,37],[74,36,74,37],[80,6,80,7],[81,6,81,7],[82,6,82,7],[83,6,83,7],[83,15,83,20],[84,6,84,7],[85,6,85,7],[75,36,75,37],[76,36,76,37],[77,36,77,37],[78,36,78,37],[79,36,79,37],[80,36,80,37],[85,36,85,37],[133,6,133,7],[134,6,134,7],[135,6,135,7],[136,6,136,7],[139,8,139,9],[140,8,140,9],[143,6,143,7],[144,6,144,7],[145,6,145,7],[148,6,148,7],[149,6,149,7],[150,6,150,7],[151,6,151,7],[152,6,152,7],[164,6,164,7],[165,6,165,7],[166,6,166,7],[155,6,155,7],[156,6,156,7],[157,6,157,7],[158,6,158,7],[159,6,159,7],[162,6,162,7],[163,6,163,7],[64,6,64,7],[65,6,65,7],[66,6,66,7],[67,6,67,7],[68,6,68,7],[69,6,69,7],[72,6,72,7],[73,6,73,7],[74,6,74,7],[75,6,75,7],[76,6,76,7],[77,6,77,7],[78,6,78,7],[79,6,79,7],[86,6,86,7],[87,6,87,7],[88,6,88,7],[89,6,89,7],[92,6,92,7],[93,6,93,7],[94,6,94,7],[95,6,95,7],[96,6,96,7],[97,6,97,7],[98,6,98,7],[99,6,99,7],[100,6,100,7],[101,6,101,7],[102,6,102,7],[103,6,103,7],[104,6,104,7],[105,6,105,7],[106,6,106,7],[107,6,107,7],[108,6,108,7],[109,6,109,7],[115,6,115,7],[119,6,119,7],[120,6,120,7],[121,6,121,7],[122,6,122,7],[123,6,123,7],[124,6,124,7],[125,6,125,7],[126,6,126,7],[129,6,129,7],[130,6,130,7],[131,6,131,7],[132,6,132,7],[18,68,18,69],[19,68,19,69],[25,68,25,69],[5,68,5,69],[7,68,7,69],[8,68,8,69],[10,68,10,69],[11,68,11,69],[15,68,15,69],[16,68,16,69],[20,58,20,59],[21,58,21,59],[16,50,16,51],[16,58,16,59],[17,50,17,51],[17,58,17,59],[20,50,20,51],[20,68,20,69],[22,68,22,69],[4,23,4,25],[4,26,4,27],[4,68,4,69],[1,10,1,12],[2,10,2,12],[3,10,3,12],[4,10,4,12],[4,13,4,16],[4,17,4,19],[4,20,4,22],[5,10,5,12],[5,13,5,16],[5,17,5,19],[5,20,5,22],[5,23,5,25],[5,26,5,27],[6,1,6,27],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[16,43,16,44],[17,43,17,44],[21,50,21,51],[23,50,23,51],[23,58,23,59],[23,68,23,69],[24,50,24,51],[24,58,24,59],[24,68,24,69],[23,35,23,36],[24,35,24,36],[16,35,16,36],[17,35,17,36],[20,35,20,36],[20,43,20,44],[21,35,21,36],[21,43,21,44],[23,43,23,44],[24,43,24,44],[27,5,27,7],[28,6,28,7],[29,6,29,7],[29,8,29,9],[27,8,28,9],[27,11,27,13],[27,14,27,16],[27,17,28,18],[27,20,27,22],[27,23,27,25],[27,26,28,27],[17,4,17,5],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[27,2,27,4],[29,43,29,44],[30,43,30,44],[33,43,33,44],[34,43,34,44],[28,21,28,22],[28,24,28,25],[29,21,29,22],[29,24,29,25],[29,26,29,27],[29,35,29,36],[30,35,30,36],[32,14,32,16],[32,20,32,22],[32,23,32,25],[32,26,33,27],[33,21,33,22],[33,24,33,25],[33,35,33,36],[34,35,34,36],[33,3,33,4],[33,6,33,7],[28,12,28,13],[28,15,28,16],[29,12,29,13],[29,15,29,16],[29,17,29,18],[33,12,33,13],[33,15,33,16],[28,3,28,4],[29,3,29,4],[32,2,32,4],[32,5,32,7],[32,8,33,9],[32,11,32,13],[32,17,33,18],[34,24,34,25],[34,26,34,27],[36,20,36,27],[36,35,36,36],[36,43,36,44],[34,3,34,4],[34,6,34,7],[34,8,34,9],[34,12,34,13],[34,15,34,16],[34,17,34,18],[34,21,34,22],[37,22,37,23],[37,24,37,25],[37,35,37,36],[37,43,37,44],[38,22,38,23],[38,24,38,25],[37,2,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[37,11,37,12],[37,13,37,14],[37,15,37,16],[38,2,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[38,11,38,12],[38,13,38,14],[38,15,38,16],[42,14,42,15],[43,14,43,15],[44,5,44,6],[44,23,44,24],[45,5,45,6],[45,23,45,24],[46,5,46,6],[46,23,46,24],[42,5,42,6],[42,23,42,24],[42,43,42,44],[42,58,42,59],[43,5,43,6],[43,23,43,24],[43,43,43,44],[43,58,43,59],[42,35,42,36],[43,35,43,36],[46,35,46,36],[46,43,46,44],[47,35,47,36],[47,43,47,44],[49,43,49,44],[50,43,50,44],[49,50,49,51],[50,50,50,51],[42,50,42,51],[43,50,43,51],[46,50,46,51],[46,58,46,59],[47,50,47,51],[47,58,47,59],[49,58,49,59],[50,58,50,59],[99,36,99,37],[100,36,100,37],[92,36,92,37],[93,36,93,37],[94,36,94,37],[95,36,95,37],[96,36,96,37],[97,36,97,37],[98,36,98,37]]}
[]
[null,null,null,null,null,null,null,null,null,null,"Project:",null,null,"Project",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Checks:"]
[null,null,null,null,null,null,null,null,null,null,"Location:",null,null,"Location",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Moment Capacity and Crack Control Checks"]
[null,null,null,null,null,null,null,null,null,null,"Client:",null,null,"Client",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Left Support:"]
[null,null,null,null,null,null,null,null,null,null,"Job No.:",null,null,1.0,null,null,null,"Calc. by:",null,null,null,null,null,"Checked by:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fMn",null,"=",{"$f":"G70","v":266.8216537},null,"kN-m",null,{"$f":"K70","v":"> Mu = 200 kN-m, O.K."}]
[null,null,null,null,null,null,null,null,null,null,"Subject:",null,null,"Beam",null,null,null,"Date:",null,null,"2011-03-26",null,null,"Revision:",null,null,"-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacing",null,"=",{"$f":"G153","v":33.33333333},null,"mm",null,{"$f":"K153","v":"s(min) <= s(act) <= s(max), O.K.!"}]
[null,"ANALYSIS & DESIGN OF RC BEAM AS PER ACI 318-08",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Midspan:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fMn",null,"=",{"$f":"G90","v":199.4789112},null,"kN-m",null,{"$f":"K90","v":"> Mu = 150 kN-m, O.K."}]
[null,"INPUT DATA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacing",null,"=",{"$f":"G160","v":33.33333333},null,"mm",null,{"$f":"K160","v":"s(min) <= s(act) <= s(max), O.K.!"}]
[null,"MATERIAL PROPERTIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Right Support:"]
[null,null,"fc'","=",41.0,null,"Mpa",null,"CONCRETE STRENGTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fMn",null,"=",{"$f":"G110","v":236.1992823},null,"kN-m",null,{"$f":"K110","v":"> Mu = 159 kN-m, O.K."}]
[null,null,"fy","=",414.0,null,"Mpa",null,"REBAR YIELD STRESS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"COLUMN SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SIMPLY SUPPORTED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacing",null,"=",{"$f":"G167","v":50},null,"mm",null,{"$f":"K167","v":"s(min) <= s(act) <= s(max), O.K.!"}]
[null,null,"fys","=",414.0,null,"Mpa",null,"LINKS YIELD STRESS"]
[null,null,"Es","=",200000.0,null,"Mpa",null,"Steel Modulus of Elasticity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION of d and d'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION of d and d'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shear Capacity and Torsional Capacity Checks"]
[null,null,"Ec","=",{"$f":"4700*(E11)^0.5","v":30094.68392},null,"Mpa",null,"Ec = 4700*SQRT(f'c)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Spacing of hoops for seismic provisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,null,"S(max)",null,"=",{"$f":"G116","v":80.20833333},null,"mm.o.c.",null,{"$f":"G117","v":"< 85mm, N.G."}]
[null,"DIMENSIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF($C$30=0,0,$E$20-$E$21-($D$30/2))","v":347.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($C$35=0,0,$E$22+($D$35/2))","v":52.5},null,"mm",null,null,null,"d =",{"$f":"IF($C$35=0,0,$E$20-$E$22-($D$35/2))","v":347.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($C$30=0,0,$E$21+($D$30/2))","v":52.5},null,"mm",null,null,null,null,"@2H",null,"=",{"$f":"2*E20","v":800},null,"mm",null,{"$f":"IF(BQ17<=G39*I39,\"<= \"&G39*I39&\"mm hoops are beyond 2H, O.K.\",\"> \"&G39*I39&\"mm hoops must be provided @\")","v":"<= 935mm hoops are beyond 2H, O.K."}]
[null,null,"L","=",3.15,null,"m",null,"BEAM LENGTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$D$30^2*0.25*$C$30","v":1472.621556},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$D$35^2*0.25*$C$35","v":981.7477042},null,"mm^2",null,null,null,"As =",{"$f":"PI()*$D$35^2*0.25*$C$35","v":981.7477042},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$D$30^2*0.25*$C$30","v":1472.621556},null,"mm^2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BQ17<=G39*I39,\"\",\"distance 2H from face of support.\")","v":""}]
[null,null,"B","=",200.0,null,"mm",null,"BEAM WIDTH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVn",null,"=",{"$f":"G122","v":97.09435062},null,"kN",null,{"$f":"K122","v":"<Vu =150 kN, not O.K."}]
[null,null,"H","=",400.0,null,"mm",null,"BEAM HEIGHT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Layer 2",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,"Layer 2",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,null,"Av(min)",null,"=",{"$f":"G126","v":67.12453911},null,"mm2",null,{"$f":"K126","v":"<= Av(prov) = 157.08 mm^2, O.K."}]
[null,null,"Ct","=",40.0,null,"mm",null,"COVER TO TOP REINFORCEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF($F$30=0,0,$E$20-$E$21-$D$30-$I$30-($G$30/2))","v":300},null,"mm",null,null,null,null,"d =",{"$f":"IF($F$35=0,0,$E$22+$D$35+$I$35+($G$35/2))","v":102.5},null,"mm",null,null,null,"d =",{"$f":"IF($F$35=0,0,$E$20-$E$22-$D$35-$I$35-($G$35/2))","v":297.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($F$30=0,0,$E$21+$D$30+$I$30+($G$30/2))","v":100},null,"mm",null,null,null,null,"s(max)",null,"=",160.4166667,null,"mm.o.c.",null,"< s = 350 mm, N.G."]
[null,null,"Cc","=",40.0,null,"mm",null,"COVER TO BOTTOM REINFORCEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$G$30^2*0.25*$F$30","v":1884.955592},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$G$35^2*$F$35*0.25","v":981.7477042},null,"mm^2",null,null,null,"As =",{"$f":"PI()*$G$35^2*0.25*$F$35","v":981.7477042},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$G$30^2*$F$30*0.25","v":1884.955592},null,"mm^2"]
[null,null,"Cs","=",40.0,null,"mm",null,"COVER TO SIDE BARS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tumax",null,"=",{"$f":"G131","v":"N.A."},null,"kN-m",null,{"$f":"K131","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"$AJ$18+$AJ$22","v":3357.577149},null,"mm^2",null,null,null,null,"A's =",{"$f":"AR18+AR22","v":1963.495408},null,"mm^2",null,null,null,"As =",{"$f":"$AY$18+$AY$22","v":1963.495408},null,"mm^2",null,null,null,null,"A's =",{"$f":"$BG$18+$BG$22","v":3357.577149},null,"mm^2",null,null,null,null,"Atreq'd",null,"=",{"$f":"G133","v":"N.A."},null,"mm2",null,{"$f":"K133","v":""}]
[null,"STEEL REINFORCEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF($AJ$24=0,0,($AJ$17*$AJ$18+$AJ$21*$AJ$22)/$AJ$24)","v":320.8333333},null,"mm",null,null,null,null,"d' =",{"$f":"IF(AR24=0,0,(AR17*AR18+AR21*AR22)/(AR24))","v":77.5},null,"mm",null,null,null,"d =",{"$f":"IF($AY$24=0,0,($AY$17*$AY$18+$AY$21*$AY$22)/$AY$24)","v":322.5},null,"mm",null,null,null,null,"d' =",{"$f":"IF($BG$24=0,0,($BG$17*$BG$18+$BG$21*$BG$22)/($BG$24))","v":79.16666667},null,"mm",null,null,null,null,"Atmin",null,"=","N.A.",null,"mm2",null,""]
[null,null,"LEFT SUPPORT",null,null,null,null,null,null,null,null,"MIDSPAN",null,null,null,null,null,null,null,null,"RIGHT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alprov",null,"=",{"$f":"G137","v":1963.495408},null,"mm2",null,{"$f":"K137","v":"add'l web bars are not required!"}]
[null,null,"TOP REINFORCEMENT",null,null,null,null,null,null,null,null,"TOP REINFORCEMENT",null,null,null,null,null,null,null,null,"TOP REINFORCEMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION of d and d'"]
[null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,null,null,null,null,null,"MIDSPAN"]
[null,null,"no.","mm",null,"no.","mm",null,null,null,null,"no.","mm",null,"no.","mm",null,null,null,null,"no.","mm",null,"no.","mm",null,null,null,null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,"Layer 1"]
[null,null,3.0,25.0,null,6.0,20.0,null,25.0,null,null,2.0,25.0,null,3.0,25.0,null,25.0,null,null,2.0,25.0,null,3.0,25.0,null,25.0,null,null,null,null,null,null,null,"d =",{"$f":"IF($L$35=0,0,$E$20-$E$22-($M$35/2))","v":347.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($L$30=0,0,$E$21+($M$30/2))","v":52.5},null,"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$M$35^2*0.25*$L$35","v":1472.621556},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$M$30^2*0.25*$L$30","v":981.7477042},null,"mm^2"]
[null,null,"BOTTOM REINFORCEMENT",null,null,null,null,null,null,null,null,"BOTTOM REINFORCEMENT",null,null,null,null,null,null,null,null,"BOTTOM REINFORCEMENT"]
[null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,"layer 1",null,null,"layer 2",null,null,"layer space",null,null,null,null,null,null,null,"Layer 2",null,null,null,null,null,null,"Layer 1"]
[null,null,"no.","mm",null,"no.","mm",null,null,null,null,"no.","mm",null,"no.","mm",null,null,null,null,"no.","mm",null,"no.","mm",null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF($O$35=0,0,$E$20-$E$22-$M$35-$R$35-($P$35/2))","v":302},null,"mm",null,null,null,null,"d =",{"$f":"IF($O$30=0,0,$E$21+$M$30+$R$30+($P$30/2))","v":102.5},null,"mm"]
[null,null,2.0,25.0,null,2.0,25.0,null,25.0,null,null,3.0,25.0,null,2.0,16.0,null,25.0,null,null,2.0,25.0,null,3.0,25.0,null,25.0,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$P$35^2*0.25*$O$35","v":402.1238597},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$P$30^2*$O$30*0.25","v":1472.621556},null,"mm^2"]
[]
[null,null,"HOOPS",null,null,null,null,null,null,null,null,"STIRRUPS",null,null,null,null,null,null,null,null,"ADDITIONAL LONGITUDINAL BARS",null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"AJ31+AJ35","v":1874.745416},null,"mm^2",null,null,null,null,"A's =",{"$f":"AR31+AR35","v":2454.369261},null,"mm^2"]
[null,null,"no.",null,"spacing",null,"no.",null,"spacing",null,null,"legs",null,"mm",null,"spacing",null,null,null,null,null,null,"no.",null,"mm",null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF(AJ37=0,0,(AJ30*AJ31+AJ34*AJ35)/AJ37)","v":337.7404692},null,"mm",null,null,null,null,"d' =",{"$f":"IF(AR37=0,0,(AR30*AR31+AR34*AR35)/(AR37))","v":82.5},null,"mm"]
[null,null,1.0,null,50.0,null,11.0,null,85.0,null,null,2.0,null,10.0,null,350.0,null,null,null,null,null,null,4.0,null,10.0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION of d and d'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CALCULATION of d and d'"]
[null,null,"APPLIED FORCES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT SUPPORT"]
[null,null,null,"LEFT SUPPORT",null,null,null,null,null,null,null,null,"MIDSPAN",null,null,null,null,null,null,null,null,"RIGHT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,"Layer 1"]
[null,null,null,"Mu","=",200.0,null,"kN-m",null,null,null,null,"Mu","=",150.0,null,"kN-m",null,null,null,null,"Mu","=",159.0,null,"kN-m",null,null,null,null,null,null,null,null,"d =",{"$f":"IF($U$30=0,0,$E$20-$E$21-($V$30/2))","v":347.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($U$35=0,0,$E$22+($V$35/2))","v":52.5},null,"mm",null,null,null,"d =",{"$f":"IF($U$35=0,0,$E$20-$E$22-($V$35/2))","v":347.5},null,"mm",null,null,null,null,"d =",{"$f":"IF($U$30=0,0,$E$21+($V$30/2))","v":52.5},null,"mm"]
[null,null,null,"Ma","=",50.0,null,"kN-m",null,null,null,null,"Ma","=",25.0,null,"kN-m",null,null,null,null,"Ma","=",43.0,null,"kN-m",null,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$V$30^2*0.25*$U$30","v":981.7477042},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$V$35^2*0.25*$U$35","v":981.7477042},null,"mm^2",null,null,null,"As =",{"$f":"PI()*$V$35^2*0.25*$U$35","v":981.7477042},null,"mm^2",null,null,null,null,"As =",{"$f":"PI()*$V$30^2*0.25*$U$30","v":981.7477042},null,"mm^2"]
[null,null,null,"Vu","=",150.0,null,"kN",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vu","=",76.0,null,"kN"]
[null,null,null,"Tu","=",null,null,"kN-m",null,null,null,null,null,null,null,null,null,null,null,null,null,"Tu","=",null,null,"kN-m",null,null,null,null,null,null,null,null,"Layer 2",null,null,null,null,null,null,"Layer 1",null,null,null,null,null,null,null,"Layer 2",null,null,null,null,null,null,"Layer 1"]
[null,null,null,"Pu","=",null,null,"kN-m",null,null,null,null,null,null,null,null,null,null,null,null,null,"Pu","=",null,null,"kN-m",null,null,null,null,null,null,null,null,"d =",{"$f":"IF($X$30=0,0,$E$20-$E$21-$V$30-$AA$30-($Y$30/2))","v":297.5},null,null,null,"mm",null,null,"d =",{"$f":"IF($X$35=0,0,$E$22+$V$35+$AA$35+($Y$35/2))","v":102.5},null,"mm",null,null,null,"d =",{"$f":"IF($X$35=0,0,$E$20-$E$22-$V$35-$AA$35-($Y$35/2))","v":297.5},null,null,null,"mm",null,null,"d =",{"$f":"IF($X$30=0,0,$E$21+$V$30+$AA$30+($Y$30/2))","v":102.5},null,"mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"PI()*$Y$30^2*0.25*$X$30","v":1472.621556},null,null,null,"mm^2",null,null,"As =",{"$f":"PI()*$Y$35^2*$X$35*0.25","v":1472.621556},null,"mm^2",null,null,null,"As =",{"$f":"PI()*$Y$35^2*0.25*$X$35","v":1472.621556},null,null,null,"mm^2",null,null,"As =",{"$f":"PI()*$Y$30^2*$X$30*0.25","v":1472.621556},null,"mm^2"]
[]
[null,null,"OUTPUT RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As =",{"$f":"AJ44+AJ48","v":2454.369261},null,null,null,"mm^2",null,null,"A's =",{"$f":"AR44+AR48","v":2454.369261},null,"mm^2",null,null,null,"As =",{"$f":"$AY$44+$AY$48","v":2454.369261},null,null,null,"mm^2",null,null,"A's =",{"$f":"$BG$44+$BG$48","v":2454.369261},null,"mm^2"]
[null,null,"FLEXURAL CAPACITY CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d =",{"$f":"IF(AJ50=0,0,(AJ43*AJ44+AJ47*AJ48)/AJ50)","v":317.5},null,null,null,"mm",null,null,"d' =",{"$f":"IF(AR50=0,0,(AR43*AR44+AR47*AR48)/(AR50))","v":82.5},null,"mm",null,null,null,"d =",{"$f":"IF($AY$50=0,0,($AY$43*$AY$44+$AY$47*$AY$48)/$AY$50)","v":317.5},null,null,null,"mm",null,null,"d' =",{"$f":"IF($BG$50=0,0,($BG$43*$BG$44+$BG$47*$BG$48)/($BG$50))","v":82.5},null,"mm"]
[null,null,null,"LEFT SUPPORT"]
[null,null,null,"b1",null,"=",{"$f":"IF($E$11>28,MAX(0.85-(0.05*($E$11-28)/7),0.65),0.85)","v":0.7571428571},null,null,null,"b1 = max. of: 0.85-(0.05*(f'c-28)/7) and 0.65"]
[null,null,null,"c",null,"=",{"$f":"(-((IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*$G$63*$E$14)-(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12))+SQRT((((IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*$G$63*$E$14)-(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12))^2)-((4*0.85*$E$11*$G$53*$E$19)*(-(IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*$G$63*$E$14*IF(($C$30+$F$30)>($C$35+$F$35),$AR$25,$BG$25))))))/(2*0.85*$E$11*$G$53*$E$19)","v":153.137734},null,"mm",null,"Solve for \"c\" in: As*fy = 0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHEAR CAPACITY CHECKS"]
[null,null,null,"a",null,"=",{"$f":"$G$53*$G$54","v":115.9471414},null,"mm",null,"a = b1*c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT SUPPORT"]
[null,null,null,"r",null,"=",{"$f":"IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)/($E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))","v":0.05232587764},null,null,null,"r = As/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f =",0.75,null,null,null,"f = capacity reduction factor for shear"]
[null,null,null,"r(min)",null,"=",{"$f":"MAX(0.25*SQRT($E$11)/$E$12,1.4/$E$12)","v":0.003866620916},null,null,null,"r(min) >= 0.25*SQRT(f'c)/fy >= 1.4/fy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVc =",{"$f":"$AK$56*0.17*SQRT($E$11)*$E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)/1000","v":52.38556017},null,"kN",null,"fVc = 0.17*l*SQRT(f'c)bd"]
[null,null,null,"rb",null,"=",{"$f":"0.85*$G$73*$E$11/$E$12*(600/(600+$E$12))","v":0.03771321581},null,null,null,"rb = 0.85*b1*f'c/fy*(600/(600+fy)"]
[null,null,null,"rg",null,"=",{"$f":"(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)+IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24))/($E$19*$E$20)","v":0.06651340696},null,null,null,"rg = (As+A's)/(b*h)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs =",{"$f":"($AK$56*$E$13*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)*(PI()*0.25*$N$39^2*$L$39)/$P$39)/1000","v":44.70879045},null,"kN",null,"fVs = f*fy*d*Av(stirrup)/s >= 0"]
[null,null,null,"r(max)",null,"=",{"$f":"IF($G$84>=0.005,$G$82/($E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)),\"N.A.\")","v":"N.A."},null,null,null,"r(max) = As(max)/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs(req'd) =",{"$f":"MAX($F$45-$AK$57,0)","v":97.61443983},null,"kN",null,"fVs(req'd) = (Vu-fVc) >= 0"]
[null,null,null,"As(min)",null,"=",{"$f":"$G$57*$E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)","v":248.1081755},null,"mm2",null,"As(min) = r(min)*b*d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVn =",{"$f":"$AK$57+$AK$59","v":97.09435062},null,"kN",null,"fVn = fVc+fVs"]
[null,null,null,"As(max)",null,"=",{"$f":"((0.85*$E$11*$G$73*(($G$83*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))/($G$83+0.005))*$E$19)+(IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*(((($G$83*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))/($G$83+0.005))-IF(($C$30+$F$30)>($C$35+$F$35),$AR$25,$BG$25))/(($G$83*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))/($G$83+0.005)))*$G$83*$E$14))/$E$12","v":2546.237819},null,"mm2",null,"As(max) = (0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es)/fy  for c = ec*d/(ec+0.005)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs(max) =",{"$f":"(0.66*$AK$56*SQRT($E$11)*$E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))/1000","v":203.3792336},null,"kN",null,"fVs(max) = 0.66*f*SQRT(f'c)*b*d"]
[null,null,null,"ec",null,"=",0.003,null,null,null,"ec = 0.003 (assumed concrete strain)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(prov) =",{"$f":"PI()*0.25*$N$39^2*$L$39","v":157.0796327},null,"mm2",null,"Av(prov) = Av(stirrup)"]
[null,null,null,"e's",null,"=",{"$f":"$G$83*($G$54-IF(($C$30+$F$30)>($C$35+$F$35),$AR$25,$BG$25))/$G$54","v":0.001481758911},null,null,null,"e's = ec*(c-d')/c",null,null,null,null,{"$f":"IF($G$64>=$E$12/$E$14,\">= fy/Es, f's yields\",\"< fy/Es, f's does not yield\")","v":"< fy/Es, f's does not yield"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(min) =",{"$f":"IF($F$45>($AK$57/2),MAX(0.062*SQRT($E$11)*$E$19*$P$39/$E$13,0.35*$E$19*$P$39/$E$13),0)","v":67.12453911},null,"mm2",null,"Av(min) = for  Vu > fVc/2  then max. of  0.062*sqrt(f'c)*b*s/fy  or  0.35*b*s/fy"]
[null,null,null,"f's",null,"=",{"$f":"IF($G$64*$E$14>=$E$12,$E$12,$G$64*$E$14)","v":296.3517822},null,"Mpa",null,"f's = e's*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(req'd) =",{"$f":"MAX(($F$45*1000)-($AK$56*$AK$57*1000),0)*$P$39/($AK$56*$E$13*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))","v":388.9708559},null,"mm2",null,"Av(req'd) = (Vu-fVc)*s/(f*fy*d)"]
[null,null,null,"As2",null,"=",{"$f":"IF($G$65>0,IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*$G$65/$E$12,\"N.A.\")","v":1405.520202},null,"mm2",null,"As2 = A's*f's/fy  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) =",{"$f":"IF($AK$59<=$AK$56*0.33*SQRT($E$11)*$E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25),IF($F$45>$AK$57/2,MIN(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)/2,600),\"N.A.\"),MIN(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)/4,600/2))","v":160.4166667},null,"mm2",null,"s(max) = for  fVs<= f*0.33*SQRT(f'c)*b*d  and  Vu > fVc/2  then min. of:  d/2  or  600mm"]
[null,null,null,"As1",null,"=",{"$f":"IF($G$65>0,IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)-$G$66,\"N.A.\")","v":1952.056946},null,"mm2",null,"As1 = As-As2  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) = for  fVs<= f*0.33*SQRT(f'c)*b*d  and  Vu <= fVc/2  then N.A."]
[null,null,null,"et",null,"=",{"$f":"IF($G$54>=IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25),0,$G$63*((IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)-IF($G$65>=0,$G$54,((IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12)/(0.85*$E$11*$E$19)/$G$53)))/IF($G$65>=0,$G$54,((IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12)/(0.85*$E$11*$E$19)/$G$53))))","v":0.003285191605},null,null,null,"et = ec*(d-c)/c = (fy/Es+ec)/(r/rb)-ec",null,null,null,null,null,null,null,null,null,{"$f":"IF($G$68>=0.005,\">= 0.005, Tension-controlled\",IF(AND($G$68>$E$12/$E$14,$G$68<0.005),\"Transition section\",IF($G$68<=$E$12/$E$14,\"<= fy/Es, Compression-controlled\")))","v":"Transition section"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) = for  fVs > f*0.33*SQRT(f'c)*b*d  then min. of:  d/4  or  300mm"]
[null,null,null,"f",null,"=",{"$f":"IF($G$68>=0.005,0.9,IF(AND($G$68>$E$12/$E$14,$G$68<0.005),0.65+0.25*($G$68-$E$12/$E$14)/(0.005-$E$12/$E$14),IF($G$68<=$E$12/$E$14,0.65)))","v":0.7536852905},null,null,null,"f = 0.65+0.25*(et-fy/Es)/(0.005-fy/Es) <= 0.90"]
[null,null,null,"fMn",null,"=",{"$f":"IF($G$65<=0,$G$69*(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12*(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)-(0.5*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$24,$AY$24)*$E$12/(0.85*$E$11*$E$19))))/1000000,$G$69*((($G$67*$E$12)*(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)-($G$55/2)))+(IF(($C$30+$F$30)>($C$35+$F$35),$AR$24,$BG$24)*$G$65*(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)-IF(($C$30+$F$30)>($C$35+$F$35),$AR$25,$BG$25))))/1000000)","v":266.8216537},null,"kN-m",null,{"$f":"IF($G$70>$F$43,\"> Mu = \"&$F$43&\" kN-m, O.K.\",\"< Mu = \"&$F$43&\" kN-m, Failed!\")","v":"> Mu = 200 kN-m, O.K."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT SUPPORT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f =",0.75,null,null,null,"f = capacity reduction factor for shear"]
[null,null,null,"MIDSPAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVc =",{"$f":"$AK$71*0.17*SQRT($E$11)*$E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)/1000","v":51.84129461},null,"kN",null,"fVc = 0.17*l*SQRT(f'c)bd"]
[null,null,null,"b1",null,"=",{"$f":"IF($E$11>28,MAX(0.85-(0.05*($E$11-28)/7),0.65),0.85)","v":0.7571428571},null,null,null,"b1 = max. of: 0.85-(0.05*(f'c-28)/7) and 0.65"]
[null,null,null,"c",null,"=",{"$f":"(-(($AR$37*$G$83*$E$14)-($AJ$37*$E$12))+SQRT(((($AR$37*$G$83*$E$14)-($AJ$37*$E$12))^2)-((4*0.85*$E$11*$G$73*$E$19)*(-($AR$37*$G$83*$E$14*$AR$38)))))/(2*0.85*$E$11*$G$73*$E$19)","v":99.46872219},null,"mm",null,"Solve for \"c\" in: As*fy = 0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs =",{"$f":"($AK$71*$E$13*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)*(PI()*0.25*$N$39^2*$L$39)/$P$39)/1000","v":44.24428354},null,"kN",null,"fVs = f*fy*d*Av(stirrup)/s >= 0"]
[null,null,null,"a",null,"=",{"$f":"$G$73*$G$74","v":75.31203252},null,"mm",null,"a = b1*c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs(req'd) =",{"$f":"MAX($X$45-$AK$72,0)","v":24.15870539},null,"kN",null,"fVs(req'd) = (Vu-fVc) >= 0"]
[null,null,null,"r",null,"=",{"$f":"$AJ$37/($E$19*$AJ$38)","v":0.02775423124},null,null,null,"r = As/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVn =",{"$f":"$AK$72+$AK$74","v":96.08557814},null,"kN",null,"fVn = fVc+fVs"]
[null,null,null,"r(min)",null,"=",{"$f":"MAX(0.25*SQRT($E$11)/$E$12,1.4/$E$12)","v":0.003866620916},null,null,null,"r(min) >= 0.25*SQRT(f'c)/fy >= 1.4/fy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fVs(max) =",{"$f":"(0.66*$AK$71*SQRT($E$11)*$E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))/1000","v":201.2662026},null,"kN",null,"fVs(max) = 0.66*f*SQRT(f'c)*b*d"]
[null,null,null,"rb",null,"=",{"$f":"0.85*$G$73*$E$11/$E$12*(600/(600+$E$12))","v":0.03771321581},null,null,null,"rb = 0.85*b1*f'c/fy*(600/(600+fy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(prov) =",{"$f":"PI()*0.25*$N$39^2*$L$39","v":157.0796327},null,"mm2",null,"Av(prov) = Av(stirrup)"]
[null,null,null,"rg",null,"=",{"$f":"($AJ$37+$AR$37)/($E$19*$E$20)","v":0.05411393346},null,null,null,"rg = (As+A's)/(b*h)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(min) =",{"$f":"IF($X$45>($AK$72/2),MAX(0.062*SQRT($E$11)*$E$19*$P$39/$E$13,0.35*$E$19*$P$39/$E$13),0)","v":67.12453911},null,"mm2",null,"Av(min) = for  Vu > fVc/2  then max. of  0.062*sqrt(f'c)*b*s/fy  or  0.35*b*s/fy"]
[null,null,null,"r(max)",null,"=",{"$f":"IF($G$84>=0.005,$G$82/($E$19*$AJ$38),\"N.A.\")","v":"N.A."},null,null,null,"r(max) = As(max)/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av(req'd) =",{"$f":"MAX(($X$45*1000)-($AK$71*$AK$72*1000),0)*$P$39/($AK$71*$E$13*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))","v":130.4138043},null,"mm2",null,"Av(req'd) = (Vu-fVc)*s/(f*fy*d)"]
[null,null,null,"As(min)",null,"=",{"$f":"$G$77*$E$19*$AJ$38","v":261.1828725},null,"mm2",null,"As(min) = r(min)*b*d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) =",{"$f":"IF($AK$74<=$AK$71*0.33*SQRT($E$11)*$E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51),IF($X$45>$AK$72/2,MIN(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)/2,600),\"N.A.\"),MIN(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)/4,600/2))","v":158.75},null,"mm2",null,"s(max) = for  fVs<= f*0.33*SQRT(f'c)*b*d  and  Vu > fVc/2  then min. of:  d/2  or  600mm"]
[null,null,null,"As(max)",null,"=",{"$f":"((0.85*$E$11*$G$73*(($G$83*$AJ$38)/($G$83+0.005))*$E$19)+($AR$37*(((($G$83*$AJ$38)/($G$83+0.005))-$AR$38)/(($G$83*$AJ$38)/($G$83+0.005)))*$G$83*$E$14))/$E$12","v":2854.483793},null,"mm2",null,"As(max) = (0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es)/fy  for c = ec*d/(ec+0.005)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) = for  fVs<= f*0.33*SQRT(f'c)*b*d  and  Vu <= fVc/2  then N.A."]
[null,null,null,"ec",null,"=",0.003,null,null,null,"ec = 0.003 (assumed concrete strain)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) = for  fVs > f*0.33*SQRT(f'c)*b*d  then min. of:  d/4  or  300mm"]
[null,null,null,"e's",null,"=",{"$f":"$G$83*($G$74-$AR$38)/$G$74","v":0.0005117806428},null,null,null,"e's = ec*(c-d')/c",null,null,null,null,{"$f":"IF($G$84>=$E$12/$E$14,\">= fy/Es, f's yields\",\"< fy/Es, f's does not yield\")","v":"< fy/Es, f's does not yield"}]
[null,null,null,"f's",null,"=",{"$f":"IF($G$84*$E$14>=$E$12,$E$12,$G$84*$E$14)","v":102.3561286},null,"Mpa",null,"f's = e's*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Seismic Provision for Transverse Reinforcements"]
[null,null,null,"As2",null,"=",{"$f":"IF($G$85>0,$AR$37*$G$85/$E$12,\"N.A.\")","v":606.8109555},null,"mm2",null,"As2 = A's*f's/fy  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S(max)=",{"$f":"MIN(IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)/4,8*MIN($D$30,$G$30,$D$35,$G$35,$M$30,$P$30,$M$35,$P$35,$V$30,$Y$30,$V$35,$Y$35),24*$E$39,300)","v":80.20833333},null,"mm.o.c.",null,"S(max) = d/4"]
[null,null,null,"As1",null,"=",{"$f":"IF($G$85>0,$AJ$37-$G$86,\"N.A.\")","v":1267.934461},null,"mm2",null,"As1 = As-As2  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S(max) = 8db (smallest longitudinal bar)"]
[null,null,null,"et",null,"=",{"$f":"IF($G$74>=$AJ$38,0,$G$83*(($AJ$38-IF($G$85>=0,$G$74,(($AJ$37*$E$12)/(0.85*$E$11*$E$19)/$G$73)))/IF($G$85>=0,$G$74,(($AJ$37*$E$12)/(0.85*$E$11*$E$19)/$G$73))))","v":0.007186331796},null,null,null,"et = ec*(d-c)/c = (fy/Es+ec)/(r/rb)-ec",null,null,null,null,null,null,null,null,null,{"$f":"IF($G$88>=0.005,\">= 0.005, Tension-controlled\",IF(AND($G$88>$E$12/$E$14,$G$88<0.005),\"Transition section\",IF($G$88<=$E$12/$E$14,\"<= fy/Es, Compression-controlled\")))","v":">= 0.005, Tension-controlled"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S(max) = 24db (diameter of hoop bar)"]
[null,null,null,"f",null,"=",{"$f":"IF($G$88>=0.005,0.9,IF(AND($G$88>$E$12/$E$14,$G$88<0.005),0.65+0.25*($G$88-$E$12/$E$14)/(0.005-$E$12/$E$14),IF($G$88<=$E$12/$E$14,0.65)))","v":0.9},null,null,null,"f = 0.65+0.25*(et-fy/Es)/(0.005-fy/Es) <= 0.90",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S(max) = 300mm"]
[null,null,null,"fMn",null,"=",{"$f":"IF($G$85<=0,$G$89*($AJ$37*$E$12*($AJ$38-(0.5*$AJ$37*$E$12/(0.85*$E$11*$E$19))))/1000000,$G$89*((($G$87*$E$12)*($AJ$38-($G$75/2)))+($AR$37*$G$85*($AJ$38-$AR$38)))/1000000)","v":199.4789112},null,"kN-m",null,{"$f":"IF($G$90>$O$43,\"> Mu = \"&$O$43&\" kN-m, O.K.\",\"< Mu = \"&$O$43&\" kN-m, Failed!\")","v":"> Mu = 150 kN-m, O.K."}]
[]
[null,null,null,"RIGHT SUPPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FOR TORSION:"]
[null,null,null,"b1",null,"=",{"$f":"IF($E$11>28,MAX(0.85-(0.05*($E$11-28)/7),0.65),0.85)","v":0.7571428571},null,null,null,"b1 = max. of: 0.85-(0.05*(f'c-28)/7) and 0.65",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f =",0.75,null,null,null,"f = capacity reduction factor for torsion"]
[null,null,null,"c",null,"=",{"$f":"(-((IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*$G$103*$E$14)-(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12))+SQRT((((IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*$G$103*$E$14)-(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12))^2)-((4*0.85*$E$11*$G$93*$E$19)*(-(IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*$G$103*$E$14*IF(($U$30+$X$30)>($U$35+$X$35),$AR$51,$BG$51))))))/(2*0.85*$E$11*$G$93*$E$19)","v":114.5204437},null,"mm",null,"Solve for \"c\" in: As*fy = 0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xo =",{"$f":"E19-(2*E23)","v":120},null,"mm",null,"xo = b-2*Cs"]
[null,null,null,"a",null,"=",{"$f":"$G$93*$G$94","v":86.70833596},null,"mm",null,"a = b1*c",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"yo =",{"$f":"E20-(E22+E21)","v":320},null,"mm",null,"yo = h-(Ct+Cc)"]
[null,null,null,"r",null,"=",{"$f":"IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)/($E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))","v":0.03865148442},null,null,null,"r = As/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Acp =",{"$f":"E19*E20","v":80000},null,"mm2",null,"Acp = b*h"]
[null,null,null,"r(min)",null,"=",{"$f":"MAX(0.25*SQRT($E$11)/$E$12,1.4/$E$12)","v":0.003866620916},null,null,null,"r(min) >= 0.25*SQRT(f'c)/fy >= 1.4/fy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ag =",{"$f":"E19*E20","v":80000},null,"mm2",null,"Ag = b*h"]
[null,null,null,"rb",null,"=",{"$f":"0.85*$G$73*$E$11/$E$12*(600/(600+$E$12))","v":0.03771321581},null,null,null,"rb = 0.85*b1*f'c/fy*(600/(600+fy)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pcp =",{"$f":"2*(E19+E20)","v":1200},null,"mm",null,"Pcp = 2*(b+h)"]
[null,null,null,"rg",null,"=",{"$f":"(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)+IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50))/($E$19*$E$20)","v":0.06135923152},null,null,null,"rg = (As+A's)/(b*h)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ph =",{"$f":"(AK94+AK95)","v":440},null,"mm",null,"Ph = 2*(xo+yo)"]
[null,null,null,"r(max)",null,"=",{"$f":"IF($G$84>=0.005,$G$82/($E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)),\"N.A.\")","v":"N.A."},null,null,null,"r(max) = As(max)/(b*d)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aoh =",{"$f":"AK94*AK95","v":38400},null,"mm2",null,"Aoh = xo*yo"]
[null,null,null,"As(min)",null,"=",{"$f":"$G$97*$E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)","v":245.5304282},null,"mm2",null,"As(min) = r(min)*b*d",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ao =",{"$f":"0.85*AK100","v":32640},null,"mm2",null,"Ao = 0.85*Aoh"]
[null,null,null,"As(max)",null,"=",{"$f":"((0.85*$E$11*$G$93*(($G$103*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))/($G$103+0.005))*$E$19)+(IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*(((($G$103*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))/($G$103+0.005))-IF(($U$30+$X$30)>($U$35+$X$35),$AR$51,$BG$51))/(($G$103*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))/($G$103+0.005)))*$G$103*$E$14))/$E$12","v":2610.022218},null,"mm2",null,"As(max) = (0.85*f'c*b1*c*b+A's*(c-d')/c*ec*Es)/fy  for c = ec*d/(ec+0.005)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tcr =",{"$f":"0.33*(SQRT(E11))*(AK96^2/AK98)/1000000","v":11.26949866},null,"kN-m",null,"Tcr = 0.33sqrt(f'c)*(Acp^2/Pcp)"]
[null,null,null,"ec",null,"=",0.003,null,null,null,"ec = 0.003 (assumed concrete strain)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tu(limit) =",{"$f":"AK93*0.083*SQRT(E11)*(AK96^2/AK98)*SQRT(1+((MAX(F47,X47)*1000)/(0.33*AK97*SQRT(E11))))/1000000","v":2.125837247},null,"kN-m",null,"Tu(limit) = f0.083*sqrt(f'c)*(Acp^2/Pcp)*sqrt(1+(Pu/(0.33Ag*sqrt(f'c)))"]
[null,null,null,"e's",null,"=",{"$f":"$G$103*($G$94-IF(($U$30+$X$30)>($U$35+$X$35),$AR$51,$BG$51))/$G$94","v":0.0008388138225},null,null,null,"e's = ec*(c-d')/c",null,null,null,null,{"$f":"IF($G$104>=$E$12/$E$14,\">= fy/Es, f's yields\",\"< fy/Es, f's does not yield\")","v":"< fy/Es, f's does not yield"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tu(max) =",{"$f":"SQRT(((((AK93*AK57*1000)/(E19*AJ38))^2)+((AK93*0.66*SQRT(E11))^2)+(2*AK93*AK57*AK93*0.66*SQRT(E11)*1000/(E19*AJ38))-((MAX(F45,X45)*1000/(E19*AJ38))^2))*((1.7^2*AK100^4)/(AK99^2)))/1000000","v":17.22411268},null,"kN-m",null,"Tu(max) = sqrt(((fVc/bd)^2+(f0.66sqrt(f'c))^2+(2fVc/bd)*f0.66sqrt(f'c)-(Vu/bd)^2)*(1.7^2*Aoh^4/Ph^2))"]
[null,null,null,"f's",null,"=",{"$f":"IF($G$104*$E$14>=$E$12,$E$12,$G$104*$E$14)","v":167.7627645},null,"Mpa",null,"f's = e's*Es",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At(prov) =",{"$f":"MAX((AK78-MAX(AK65,AK80))/2,0)","v":0},null,"mm2",null,"At(prov) = (Av+t(used)-Av(req'd))/2"]
[null,null,null,"As2",null,"=",{"$f":"IF($G$105>0,IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*$G$105/$E$12,\"N.A.\")","v":994.5694982},null,"mm2",null,"As2 = A's*f's/fy  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At(req'd) =",{"$f":"IF(MAX(F46,X46)>=AK103,(MAX(F46,X46)*1000*P39)/(AK93*2*AK101*E13),0)","v":0},null,"mm2",null,"At(req'd) = for  Tu >= Tu(limit)  then  Tu*s/(f*2*Ao*fy)"]
[null,null,null,"As1",null,"=",{"$f":"IF($G$105>0,IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)-$G$106,\"N.A.\")","v":1459.799762},null,"mm2",null,"As1 = As-As2  for f's > 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"At(min) =",{"$f":"IF(MAX(F46,X46)>=AK103,MAX((((0.35*E19*P39)/E13)-G125)/2,(((0.062*SQRT(E11)*E19*P39)/E13)-G125)/2,0),0)","v":0},null,"mm2",null,"At(min) = for Tu >= Tu(limit)  then  max. of:  ((0.35*b*s/(fy)-Av(req'd))/2  or  0"]
[null,null,null,"et",null,"=",{"$f":"IF($G$94>=IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51),0,$G$103*((IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)-IF($G$105>=0,$G$94,((IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12)/(0.85*$E$11*$E$19)/$G$93)))/IF($G$105>=0,$G$94,((IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12)/(0.85*$E$11*$E$19)/$G$93))))","v":0.005317292259},null,null,null,"et = ec*(d-c)/c = (fy/Es+ec)/(r/rb)-ec",null,null,null,null,null,null,null,null,null,{"$f":"IF($G$108>=0.005,\">= 0.005, Tension-controlled\",IF(AND($G$108>$E$12/$E$14,$G$108<0.005),\"Transition section\",IF($G$108<=$E$12/$E$14,\"<= fy/Es, Compression-controlled\")))","v":">= 0.005, Tension-controlled"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Al(req'd) =",{"$f":"IF(MAX(F46,X46)>=AK103,(AK106/P39)*AK99*(E13/E12),0)","v":0},null,"mm2",null,"Al(req'd) = for  Tu >= Tu(limit)  then  At(req'd)/s*Ph*(fys/fy)"]
[null,null,null,"f",null,"=",{"$f":"IF($G$108>=0.005,0.9,IF(AND($G$108>$E$12/$E$14,$G$108<0.005),0.65+0.25*($G$108-$E$12/$E$14)/(0.005-$E$12/$E$14),IF($G$108<=$E$12/$E$14,0.65)))","v":0.9},null,null,null,"f = 0.65+0.25*(et-fy/Es)/(0.005-fy/Es) <= 0.90",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Al(min) =",{"$f":"IF(MAX(F46,X46)>=AK103,((0.42*SQRT(E11)*AK96)/E12)-(MAX((AK106/P39),((0.175*E19)/E13))*AK99*(E13/E12)),0)","v":0},null,"mm2",null,"Al(min) = for  Tu >= Tu(limit)  then  0.42*SQRT*(f'c)*Acp/(fy) - (max. of: 0.175*b/(fys)  or  At(req'd)) /s)*Ph"]
[null,null,null,"fMn",null,"=",{"$f":"IF($G$105<=0,$G$109*(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12*(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)-(0.5*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$50,$AY$50)*$E$12/(0.85*$E$11*$E$19))))/1000000,$G$109*((($G$107*$E$12)*(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)-($G$95/2)))+(IF(($U$30+$X$30)>($U$35+$X$35),$AR$50,$BG$50)*$G$105*(IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)-IF(($U$30+$X$30)>($U$35+$X$35),$AR$51,$BG$51))))/1000000)","v":236.1992823},null,"kN-m",null,{"$f":"IF($G$110>$X$43,\"> Mu = \"&$X$43&\" kN-m, O.K.\",\"< Mu = \"&$X$43&\" kN-m, Failed!\")","v":"> Mu = 159 kN-m, O.K."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(MAX(F45,X45)>0,MAX(F46,X46)>0),\"For Combined Shear and Torsion:\",\"\")","v":""}]
[null,null,"SHEAR CAPACITY CHECKS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$14>0,$D$15>0),\"Total (Av+t) =\",\"\")","v":"Total (Av+t) ="},{"$f":"IF(AND(MAX(F45,X45)>0,MAX(F46,X46)>0),G125+(2*AK106),\"\")","v":""},null,"mm2",null,"Total (Av+t) = Av(req'd)+2*At(req'd)"]
[null,null,null,"@ 2H for Seismic Provision for transverse Reinforcements per Sec.21.5.3.2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($D$14>0,$D$15>0),\"Total (Av+t)(min) =\",\"\")","v":"Total (Av+t)(min) ="},{"$f":"IF(AND(MAX(F45,X45)>0,MAX(F46,X46)>0),MAX(0.062*SQRT(E11)*E19*P39/E13,0.35*E19*P39/E13),\"\")","v":""},null,"mm2",null,"Total (Av+2t)(min) = 0.35*b*s/fy or 0.062sqrt(f'c)*b*s/fy"]
[null,null,null,"S(max)= smallest of ==>",null,null,null,null,null,null,"S(max) = d/4"]
[null,null,null,null,null,null,null,null,null,null,"S(max) = 8db (smallest longitudinal bar)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CRACK CONTROL"]
[null,null,null,"S(max)",null,"=",{"$f":"AK86","v":80.20833333},null,"mm.o.c.",null,"S(max) = 24db (diameter of hoop bar)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LEFT SUPPORT"]
[null,null,null,null,null,null,{"$f":"IF($G$116>$I$39,\"> \"&$I$39&\"mm, O.K.\",\"< \"&$I$39&\"mm, N.G.\")","v":"< 85mm, N.G."},null,null,null,"S(max) = 300mm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es =",{"$f":"$E$14","v":200000},null,null,null,"Es = modulus of elasticity for steel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ec =",{"$f":"$E$15","v":30094.68392},null,null,null,"Ec = 57*SQRT(f'c*1000)"]
[null,null,null,"For Shear Reinforcements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n =",{"$f":"$AK$117/$AK$118","v":6.645691995},null,null,null,"n = Es/Ec"]
[null,null,null,"fVc",null,"=",{"$f":"MAX($AK$57,$AK$72)","v":52.38556017},null,"kN",null,"fVc = 0.17*l*SQRT(f'c)bd",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs =",{"$f":"$F$44*1000000/(IF(($C$30+$F$30)>($C$35+$F$35),$G$67,$G$67)*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25)*(1-SQRT(2*IF(($C$30+$F$30)>($C$35+$F$35),$G$67,$G$67)/($E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))*$AK$119+(IF(($C$30+$F$30)>($C$35+$F$35),$G$67,$G$67)/($E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))*$AK$119)^2)-IF(($C$30+$F$30)>($C$35+$F$35),$G$67,$G$67)/($E$19*IF(($C$30+$F$30)>($C$35+$F$35),$AJ$25,$AY$25))*$AK$119)/3)","v":1834.198253},null,null,null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,"fVs",null,"=",{"$f":"MAX($AK$59,AK74)","v":44.70879045},null,"kN",null,"fVs = f*fy*d*Av(stirrup)/s >= 0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs(used) =",{"$f":"MIN($AK$120,(2/3)*$E$12)","v":276},null,null,null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,"fVn",null,"=",{"$f":"MAX($AK$61,$AK$76)","v":97.09435062},null,"kN",null,{"$f":"IF($G$122>=$F$45,\">=Vu = \"&FIXED($F$45,2, )&\" kN, O.K.\",\"<Vu =\"&$F$45&\" kN, not O.K.\")","v":"<Vu =150 kN, not O.K."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) =",{"$f":"MIN((380*280/$AK$121)-(2.5*($E$21+$N$39)),300*280/$AK$121)","v":260.5072464},null,null,null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"fVs(max)",null,"=",{"$f":"MAX($AK$62,$AK$77)","v":203.3792336},null,"kN",null,{"$f":"IF($F$45-$G$120<=$G$123,\">= Vu-(phi)Vc = \"&ROUND(MAX($F$45-$G$120,0),2)&\" kN, O.K.\",\"< Vu-(phi)Vc = \"&ROUND(MAX($F$45-$G$120,0),2)&\" kN, not O.K.\")","v":">= Vu-(phi)Vc = 97.61 kN, O.K."}]
[null,null,null,"Av(prov)",null,"=",{"$f":"$AK$63","v":157.0796327},null,"mm2"]
[null,null,null,"Av(req'd)",null,"=",{"$f":"MAX($AK$65,$AK$80)","v":388.9708559},null,"mm2",null,{"$f":"IF($G$125>$G$124,\"> Av(prov) = \"&FIXED($G$124,2, )&\" , N.G.\",\"<= Av(prov) = \"&FIXED($G$124,2, )&\" mm^2, O.K.\")","v":"> Av(prov) = 157.08 , N.G."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIDSPAN"]
[null,null,null,"Av(min)",null,"=",{"$f":"MAX($AK$64,$AK$79)","v":67.12453911},null,"mm2",null,{"$f":"IF($G$126>$G$124,\"> Av(prov) = \"&FIXED($G$124,2, )&\" mm^2, N.G.\",\"<= Av(prov) = \"&FIXED($G$124,2, )&\" mm^2, O.K.\")","v":"<= Av(prov) = 157.08 mm^2, O.K."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es =",{"$f":"$E$14","v":200000},null,null,null,"Es = modulus of elasticity for steel"]
[null,null,null,"s(max)",null,"=",{"$f":"MAX($AK$66,$AK$81)","v":160.4166667},null,"mm",null,{"$f":"IF($F$45>$AK$57/2,IF($P$39<=$G$127,\">= s = \"&$P$39&\" mm, O.K.\",\"< s = \"&$P$39&\" mm, N.G.\"),\"mm\")","v":"< s = 350 mm, N.G."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ec =",{"$f":"$E$15","v":30094.68392},null,null,null,"Ec = 57*SQRT(f'c*1000)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n =",{"$f":"$AK$126/$AK$127","v":6.645691995},null,null,null,"n = Es/Ec"]
[null,null,null,"For Torsion Reinforcements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs =",{"$f":"$O$44*1000000/($AJ$37*$AJ$38*(1-SQRT(2*$AJ$37/($E$19*$AJ$38)*$AK$128+($AJ$37/($E$19*$AJ$38)*$AK$128)^2)-$AJ$37/($E$19*$AJ$38)*$AK$128)/3)","v":655.1448618},null,null,null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,"Tc",null,"=",{"$f":"AK103","v":2.125837247},null,"kN-m",null,{"$f":"IF($G$130<MAX($F$46,$X$46),\"< \"&FIXED(MAX($F$46,$X$46),2)&\" kN-m, must consider torsion!\",\"< \"&FIXED(MAX($F$46,$X$46),2)&\" kN-m, torsion need not to be considered!\")","v":"< 0.00 kN-m, torsion need not to be considered!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs(used) =",{"$f":"MIN($AK$129,(2/3)*$E$12)","v":276},null,null,null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,"Tumax",null,"=",{"$f":"IF(MAX($F$46,$X$46)<$AK$103,\"N.A.\",AK104)","v":"N.A."},null,"kN-m",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(MAX(F46,X46)=0,\"\",IF(G131<MAX(F46,X46),\"< Tu = \"&MAX(F46,X46)&\" kN-m, increase section!\",\">= Tu = \"&MAX(F46,X46)&\" kN-m, O.K.\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) =",{"$f":"MIN((380*280/$AK$130)-(2.5*($E$22+$N$39)),300*280/$AK$130)","v":260.5072464},null,null,null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"Atprov",null,"=","N.A.",null,"mm2",null,"(Av+t(used)-Av(req'd))/2"]
[null,null,null,"Atreq'd",null,"=","N.A.",null,"mm2",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(G133>(G124-G125)/2,\"> At(prov) = \"&MAX(ROUND((G124-G125)/2,2),0)&\" mm^2, N.G.\",\"<= At(prov) = \"&MAX(ROUND((G124-G125)/2,2),0)&\" mm^2, O.K.\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RIGHT SUPPORT"]
[null,null,null,"Atmin",null,"=","N.A.",null,"mm2",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(G134>(G124-G125)/2,\"> At(prov) = \"&ROUND((G124-G125)/2,2)&\" mm^2, N.G.\",\"<= At(prov) = \"&ROUND((G124-G125)/2,2)&\" mm^2, O.K.\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Es =",{"$f":"$E$14","v":200000},null,null,null,"Es = modulus of elasticity for steel"]
[null,null,null,"Alreq'd",null,"=","N.A.",null,"mm2",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(G135<G136,\"< Al(min) = \"&ROUND(G136,2)&\" mm^2, thus use Al(min)\",\">= Al(min) = \"&ROUND(G136,2)&\" mm^2, thus use Al(req'd)\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ec =",{"$f":"$E$15","v":30094.68392},null,null,null,"Ec = 57*SQRT(f'c*1000)"]
[null,null,null,"Almin",null,"=","N.A.",null,"mm2",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(G136>=G135,\">= Al(req'd) = \"&ROUND(G135,2)&\" mm^2, thus use Al(min)\",\"< Al(req'd) = \"&ROUND(G135,2)&\" mm^2, thus use Al(req'd)\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"n =",{"$f":"$AK$134/$AK$135","v":6.645691995},null,null,null,"n = Es/Ec"]
[null,null,null,"Alprov",null,"=",{"$f":"(2*PI()*0.25*M30^2)+(2*PI()*0.25*M35^2)","v":1963.495408},null,"mm2",null,{"$f":"IF(MAX(F46,X46)>=G130,IF(G137>=MAX(G135,G136),\"add'l web bars are not required!\",\"provide add'l \"&ROUND(MAX(G135,G136)-G137,2)&\" mm^2 web bars!\"),\"add'l web bars are not required!\")","v":"add'l web bars are not required!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs =",{"$f":"$X$44*1000000/(IF(($U$30+$X$30)>($U$35+$X$35),$G$107,$G$107)*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51)*(1-SQRT(2*IF(($U$30+$X$30)>($U$35+$X$35),$G$107,$G$107)/($E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))*$AK$136+(IF(($U$30+$X$30)>($U$35+$X$35),$G$107,$G$107)/($E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))*$AK$136)^2)-IF(($U$30+$X$30)>($U$35+$X$35),$G$107,$G$107)/($E$19*IF(($U$30+$X$30)>($U$35+$X$35),$AJ$51,$AY$51))*$AK$136)/3)","v":1016.796698},null,null,null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fs(used) =",{"$f":"MIN($AK$137,(2/3)*$E$12)","v":276},null,null,null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,{"$f":"IF(AND(MAX(F46,X46)>0,MAX(F45,X45)>0),\"For Combined Shear and Torsion:\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s(max) =",{"$f":"MIN((380*280/$AK$138)-(2.5*($E$21+$N$39)),300*280/$AK$138)","v":260.5072464},null,null,null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"Total (Av+t)",null,null,null,"=",{"$f":"IF(AND($F$46>0,$X$46>0,$F$45>0,$X$45>0),$AK$112,\"N.A.\")","v":"N.A."},null,"mm2",null,{"$f":"IF(AND(MAX(F46,X46)>0,MAX(F45,X45)>0),IF(I140>G124,\"> Av+t(prov) = \"&FIXED(G124,2)&\" mm^2, N.G.\",\"<= Av+t(prov) = \"&FIXED(G124,2)&\" mm^2, O.K.\"),\"\")","v":""}]
[null,null,null,"Total (Av+t)min",null,null,null,"=",{"$f":"IF(AND($F$46>0,$X$46>0,$F$45>0,$X$45>0),$AK$113,\"N.A.\")","v":"N.A."},null,"mm2",null,{"$f":"IF(AND(MAX(F45,X45)>0,MAX(F46,X46)>0),IF(I141>G124,\"> Av+t(prov) = \"&FIXED(G124,2)&\" mm^2, N.G.\",\"<= Av+t(prov) = \"&FIXED(G124,2)&\" mm^2, O.K.\"),\"\")","v":""}]
[]
[null,null,"CRACK CONTROL"]
[null,null,null,"Es",null,"=",{"$f":"E14","v":200000},null,"MPa",null,"Steel Modulus of Elasticity"]
[null,null,null,"Ec",null,"=",30094.68392,null,"MPa",null,"Ec = 4700*SQRT(f'c)"]
[null,null,null,"n",null,"=",{"$f":"G144/G145","v":6.645691995},null,null,null,"n = Es/Ec"]
[]
[null,null,null,"LEFT SUPPORT"]
[null,null,null,"fs",null,"=",{"$f":"$AK$120","v":1834.198253},null,"MPa",null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,"fs(used)",null,"=",{"$f":"$AK$121","v":276},null,"MPa",null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,"s(max)",null,"=",{"$f":"$AK$122","v":260.5072464},null,"mm",null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"s(min)",null,"=",25.0,null,"mm"]
[null,null,null,"s(act)",null,"=",{"$f":"($E$19-(2*$E$23)-(2*$N$39))/$C$30","v":33.33333333},null,"mm",null,{"$f":"IF(AND(G153>=G152,G153<=G151),\"s(min) <= s(act) <= s(max), O.K.!\",IF(AND(G153<G152,G153<G151),\"s(min) > s(act) < s(max), not O.K.!\",IF(AND(G153<G152,G153>G151),\"s(min) > s(act) > s(max), not O.K.!\",\"s(min) < s(act) > s(max), not O.K.!\")))","v":"s(min) <= s(act) <= s(max), O.K.!"}]
[]
[null,null,null,"MIDSPAN"]
[null,null,null,"fs",null,"=",{"$f":"$AK$129","v":655.1448618},null,"MPa",null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,"fs(used)",null,"=",{"$f":"$AK$130","v":276},null,"MPa",null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,"s(max)",null,"=",{"$f":"$AK$131","v":260.5072464},null,"mm",null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"s(min)",null,"=",25.0,null,"mm"]
[null,null,null,"s(act)",null,"=",{"$f":"($E$19-(2*$E$23)-(2*$N$39))/$L$35","v":33.33333333},null,"mm",null,{"$f":"IF(AND(G160>=G159,G160<=G158),\"s(min) <= s(act) <= s(max), O.K.!\",IF(AND(G160<G159,G160<G158),\"s(min) > s(act) < s(max), not O.K.!\",IF(AND(G160<G159,G160>G158),\"s(min) > s(act) > s(max), not O.K.!\",\"s(min) < s(act) > s(max), not O.K.!\")))","v":"s(min) <= s(act) <= s(max), O.K.!"}]
[]
[null,null,null,"RIGHT SUPPORT"]
[null,null,null,"fs",null,"=",{"$f":"$AK$137","v":1016.796698},null,"MPa",null,"fs = Ma/(As*d*(1-(SQRT(2*As/(b*d)*n+(As/(b*d)*n)^2)-As/(b*d)*n)/3))"]
[null,null,null,"fs(used)",null,"=",{"$f":"$AK$138","v":276},null,"MPa",null,"fs(used) = minimum of: fs and 2/3*fy"]
[null,null,null,"s(max)",null,"=",{"$f":"$AK$139","v":260.5072464},null,"mm",null,"s(max) = minimum of: 380*280/fs(used)-2.5*Cc  and  300*280/fs(used)"]
[null,null,null,"s(min)",null,"=",25.0,null,"mm"]
[null,null,null,"s(act)",null,"=",{"$f":"($E$19-(2*$E$23)-(2*$N$39))/$U$30","v":50},null,"mm",null,{"$f":"IF(AND(G167>=G166,G167<=G165),\"s(min) <= s(act) <= s(max), O.K.!\",IF(AND(G167<G166,G167<G165),\"s(min) > s(act) < s(max), not O.K.!\",IF(AND(G167<G166,G167>G165),\"s(min) > s(act) > s(max), not O.K.!\",\"s(min) < s(act) > s(max), not O.K.!\")))","v":"s(min) <= s(act) <= s(max), O.K.!"}]

{"sheet":"graph","index":7,"n_rows":47,"n_cols":18,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["For Graph"]
["Space",{"$f":"(B29-B10)/(beam!$L$30-1)","v":90},{"$f":"(B29-B10)/(beam!$L$35-1)","v":45},{"$f":"IF(beam!$O$30<1,0,(B29-B10)/(beam!$O$30-1))","v":45},{"$f":"IF(beam!$O$35<1,0,(B29-B10)/(beam!$O$35-1))","v":90},null,null,null,null,null,null,"Space",{"$f":"(M29-M10)/(beam!C30-1)","v":45},{"$f":"(M29-M10)/(beam!C35-1)","v":90},{"$f":"IF(beam!F30<1,0,(M29-M10)/(beam!$F$30-1))","v":18},{"$f":"IF(beam!F35<1,0,(M29-M10)/(beam!$F$35-1))","v":90}]
[null,0.0,null,null,null,null,null,null,null,null,null,null,0.0]
[null,0.0,null,null,null,null,null,null,null,null,null,null,0.0]
["Section-x",{"$f":"B3-beam!$E$19/2","v":-100},{"$f":"B3+beam!$E$19/2","v":100},{"$f":"B3+beam!$E$19/2","v":100},{"$f":"B3-beam!$E$19/2","v":-100},{"$f":"B3-beam!E$19/2","v":-100},null,null,null,null,null,"Section-x",{"$f":"M3-beam!$E$19/2","v":-100},{"$f":"M3+beam!$E$19/2","v":100},{"$f":"M3+beam!$E$19/2","v":100},{"$f":"M3-beam!$E$19/2","v":-100},{"$f":"M3-beam!P$19/2","v":0}]
["Section-y",{"$f":"B4+beam!$E$20/2","v":200},{"$f":"B4+beam!$E$20/2","v":200},{"$f":"B4-beam!$E$20/2","v":-200},{"$f":"B4-beam!$E$20/2","v":-200},{"$f":"B4+beam!$E$20/2","v":200},null,null,null,null,null,"Section-y",{"$f":"M4+beam!$E$20/2","v":200},{"$f":"M4+beam!$E$20/2","v":200},{"$f":"M4-beam!$E$20/2","v":-200},{"$f":"M4-beam!$E$20/2","v":-200},{"$f":"M4+beam!$E$20/2","v":200}]
["Link-x",{"$f":"B5+beam!$E$23","v":-60},{"$f":"C5-beam!$E$23","v":60},{"$f":"D5-beam!$E$23","v":60},{"$f":"E5+beam!$E$23","v":-60},{"$f":"B7","v":-60},null,null,null,null,null,"Link-x",{"$f":"M5+beam!$E$23","v":-60},{"$f":"N5-beam!$E$23","v":60},{"$f":"O5-beam!$E$23","v":60},{"$f":"P5+beam!$E$23","v":-60},{"$f":"M7","v":-60}]
["Link-y",{"$f":"B6-beam!$E$21","v":160},{"$f":"C6-beam!$E$21","v":160},{"$f":"D6+beam!$E$21","v":-160},{"$f":"E6+beam!$E$21","v":-160},160,null,null,null,null,null,"Link-y",{"$f":"M6-beam!$E$21","v":160},{"$f":"N6-beam!$E$21","v":160},{"$f":"O6+beam!$E$21","v":-160},{"$f":"P6+beam!$E$21","v":-160},160]
["Bars","x","y","x","y","x","y",null,null,null,null,"Bars","x","y","x","y","x","y"]
[null,{"$f":"B7+15","v":-45},{"$f":"C8-15","v":145},{"$f":"IF(beam!$O$30<1,B10,B7+15)","v":-45},{"$f":"IF(beam!$O$30<1,C10,C8-30-beam!$R$30)","v":105},{"$f":"IF(beam!$O$35<2,\"\",D10)","v":-45},0.0,null,null,null,null,null,{"$f":"M7+15","v":-45},{"$f":"N8-15","v":145},{"$f":"IF(beam!$F$30<1,M10,M7+15)","v":-45},{"$f":"IF(beam!$F$30<1,N10,N8-30-beam!$I$30)","v":105},{"$f":"IF(beam!$F$35<2,\"\",O10)","v":-45},0.0]
[null,{"$f":"MIN($B$29,$B10+$B$2)","v":45},{"$f":"C10","v":145},{"$f":"MIN($D$29,$D10+$D$2)","v":0},{"$f":"E10","v":105},{"$f":"D11","v":0},{"$f":"G10","v":0},null,null,null,null,null,{"$f":"MIN($B$29,$M10+$M$2)","v":0},{"$f":"N10","v":145},{"$f":"MIN($D$29,$O10+$O$2)","v":-27},{"$f":"P10","v":105},{"$f":"O11","v":-27},{"$f":"R10","v":0}]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,-9,105,-9,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,9,105,9,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,27,105,27,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,45,145,45,105,45,0,null,null,null,null,null,45,145,45,105,45,0]
[null,{"$f":"$C$7-15","v":45},{"$f":"15-$C$8","v":-145},{"$f":"IF(beam!O35<1,B29,$C$7-15)","v":45},{"$f":"IF(beam!O35<1,C29,beam!R35+30-$C$8)","v":-105},45,0.0,null,null,null,null,null,{"$f":"$N$7-15","v":45},{"$f":"15-$N$8","v":-145},{"$f":"IF(beam!Z35<1,M29,$C$7-15)","v":45},{"$f":"IF(beam!Z35<1,N29,beam!AC35+30-$C$8)","v":-145},45,0.0]
[null,{"$f":"MAX($B$10,$B29-$C$2)","v":0},{"$f":"C29","v":-145},{"$f":"MAX($D$10,$D29-$E$2)","v":-45},{"$f":"E29","v":-105},-45,{"$f":"G29","v":0},null,null,null,null,null,{"$f":"MAX($M$10,$M29-$N$2)","v":-45},{"$f":"N29","v":-145},{"$f":"MAX($D$10,$D29-$E$2)","v":-45},{"$f":"P29","v":-145},-45,{"$f":"R29","v":0}]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]
[null,-45,-145,-45,-105,-45,0,null,null,null,null,null,-45,-145,-45,-145,-45,0]