{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","Design criteria","MAIN","Weight","Notes"],"not_rendered":{"charts":3,"images":11,"macros":1,"external_links":1,"defined_names":14,"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":"Cover","index":0,"n_rows":22,"n_cols":30,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,16,16,17],[13,3,13,5],[8,16,8,17],[9,16,9,17],[12,16,12,17],[13,16,13,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"วิธีใช้",null,null,null,null,null,null,null,null,null,null,null,null,"SR24",2400]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ป้อนค่าเฉพาะเซล สีน้ำเงิน",null,null,null,null,null,null,null,null,null,null,null,null,"SD30",3000]
[null,null,null,null,"Concrete Cantilever Retaining Wall",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD40",4000]
[]
[null,null,"Project : ","RC. Cantilever Retaining Wall L "]
[]
[null,null,"Owner : ","Advisory Group"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Design criteria"]
[null,null,"Location : ","Chiang Rai"]
[]
[null,null,"Engineer : ","Neung Civil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main"]
[null,null,"Date : ","2021-01-12"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"วสท",{"$f":"J20*K17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"พรบ 65 ksc",65]

{"sheet":"Design criteria","index":1,"n_rows":40,"n_cols":30,"rows_kept":40,"cut":false,"hidden":false,"merged":[[13,16,13,17],[8,16,8,17],[12,16,12,17],[7,2,7,11],[1,9,1,11],[3,9,4,9],[3,10,4,10],[3,11,4,12],[6,2,6,11],[9,16,9,17]]}
[]
[null,null,"Project",{"$f":"Cover!D6","v":"RC. Cantilever Retaining Wall L "},null,null,null,null,null,"Cantilever Retaining Wall",null,null,null,null,null,"วิธีใช้",null,null,null,null,null,null,null,null,null,null,null,null,"SR24",2400]
[null,null,"Owner",{"$f":"Cover!D8","v":"Advisory Group"},null,null,null,null,null,"Engineer","Wall No.","Date",null,null,null,"ป้อนค่าเฉพาะเซล สีน้ำเงิน",null,null,null,null,null,null,null,null,null,null,null,null,"SD30",3000]
[null,null,"Location",{"$f":"Cover!D10","v":"Chiang Rai"},null,null,null,null,null,{"$f":"Cover!D12","v":"Neung Civil"},"RW02",{"$f":"Cover!D14","v":"2021-01-12"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SD40",4000]
[]
[]
[null,null,"ข้อกำหนดในการออกแบบโครงสร้าง"]
[null,null,"( DESIGN  CRITERIA )"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main"]
[null,null,"กฏข้อบังคับ"]
[null,null,":  กฏกระทรวงฉบับที่ 6 พ.ศ. 2527  ออกตามความใน พ.ร.บ. ควบคุมอาคาร พ.ศ. 2522 และ พ.ศ. 2535"]
[null,null,":  มาตราฐานสำหรับอาคารคอนกรีตเสริมเหล็ก  วิศวกรรมสถานแห่งประเทศไทย พ.ศ. 2562"]
[null,null,":  American Institue of Steel Construction ( AISC.) ,1977",null,null,null,null,null,null,null,null,null,null,null,null,null,"Weight"]
[null,null,"คอนกรีต"]
[null,null,":  คอนกรีตที่ใช้อัตราส่วนผสมโดยปริมาตร ซีเมนต์ : ทราย : หิน  1 : 2 : 4  หรือ Mixed Design โดยอัตรา"]
[null,null,"ส่วนผสมน้ำต่อซีเมนต์ ( Water Ratio ) อยู่ระหว่าง 0.50 - 0.60   เพื่อให้กำลังอัดประลัยของแท่งคอนกรีต "]
[null,null,"ที่อายุ  28 วัน  ค่ากำลังอัดประลัย fc' ไม่น้อยกว่า",null,null,null,350,null,"ksc","factor =",0.45]
[]
[null,null,"Reinforced Concrete Design"]
[null,null,":  Compressive Stress of Concrete",null,null,"fc'  =",null,null,null,{"$f":"G17","v":350},"ksc."]
[null,null,":  Allowable Stress of Concrete",null,null,"fc  =",{"$f":"K17&\" f'c  \"","v":"0.45 f'c  "},null,"=",{"$f":"IF(L21=\"วสท\",Y21,Y22)","v":157.5},"ksc.","วสท",null,null,null,null,null,null,null,null,null,null,null,"วสท",{"$f":"J20*K17","v":157.5}]
[null,null,":  Elastic Modulus of Concrete ",null,null,"Ec =","15,100 Sqrt (f'c) =",null,null,{"$f":"15100*SQRT(J20)","v":282495.13270143257},"ksc.",null,null,null,null,null,null,null,null,null,null,null,null,"พรบ 65 ksc",65]
[null,null,":  Elastic Modulus of Reinforced Conc.",null,null,"Es =",null,null,null,2040000,"ksc."]
[]
[null,null,null,null,null,"Main bar :","SD40",null,"Other bar :","SD40"]
[null,null,":  Yeild Stress of Reinforced Concrete",null,null,"fy",{"$f":"VLOOKUP(G25,$AC$2:$AD$4,2,FALSE)","v":4000},null,null,{"$f":"VLOOKUP(J25,$AC$2:$AD$4,2,FALSE)","v":4000},"ksc"]
[null,null,":  Allowable Stress of Steel",null,null,"fs",{"$f":"MIN(G26/2,1700)","v":1700},null,null,{"$f":"MIN(J26/2,1700)","v":1700},"ksc"]
[null,null,"Design Parameters :"]
[null,null,"n = Es / Ec",null,null,null,{"$f":"MAX(J23/J22,6)","v":7.2213633576337184},null,null,{"$f":"G29","v":7.2213633576337184}]
[null,null,"k = 1 / ( 1+fs / n /fc )",null,null,null,{"$f":"1/(1+(G27/G29/J21))","v":0.4008524943134068},null,null,{"$f":"1/(1+(J27/J29/J21))","v":0.4008524943134068}]
[null,null,"j = 1- ( k / 3 )",null,null,null,{"$f":"1-(G30/3)","v":0.86638250189553112},null,null,{"$f":"1-(J30/3)","v":0.86638250189553112}]
[null,null,"R = (0.5 * fc * k * j )",null,null,null,{"$f":"0.5*J21*G30*G31","v":27.349212469502195},null,null,{"$f":"0.5*J21*J30*J31","v":27.349212469502195},"ksc"]
[null,null,null,null,null,null,{"$f":"2.29*SQRT(G17)","v":42.841977078561634}]
[]
[]
[null,null,"Steel Design"]
[null,null,":  Yeild Stress of Steel  ASTM A-36 or TISI 1227  SS400",null,null,null,null,null,"Fy =",2350,"ksc"]
[null,null,":  Allowable Shear Stress ",null,null,"Fv","=0.4 Fy",null,null,{"$f":"0.4*$J$37","v":940},"ksc"]
[null,null,":  Allowable Tensile Stress ",null,null,"Ft ","=0.6 Fy",null,null,{"$f":"0.6*$J$37","v":1410},"ksc"]
[null,null,":  Allowable Bending Stress ",null,null,"Fb","=0.6 Fy",null,null,{"$f":"0.6*$J$37","v":1410},"ksc"]

{"sheet":"MAIN","index":2,"n_rows":156,"n_cols":122,"rows_kept":156,"cut":false,"hidden":false,"merged":[[37,5,37,6],[93,5,93,6],[94,5,94,6],[51,5,51,6],[52,5,52,6],[89,5,89,6],[90,5,90,6],[91,5,91,6],[92,5,92,6],[130,5,130,6],[131,5,131,6],[125,5,125,6],[126,5,126,6],[127,5,127,6],[128,5,128,6],[129,5,129,6],[0,26,0,29],[3,9,4,9],[3,10,4,10],[3,11,4,12],[35,5,35,6],[3,8,4,8],[1,8,1,12],[37,42,37,43],[32,5,32,6],[33,5,33,6],[34,5,34,6],[50,5,50,6],[38,5,38,6],[39,5,39,6],[40,5,40,6],[41,5,41,6],[42,5,42,6],[43,5,43,6],[46,5,46,6],[47,5,47,6],[48,5,48,6],[49,5,49,6],[36,5,36,6],[122,5,122,6],[118,5,118,6],[119,5,119,6],[120,5,120,6],[114,5,114,6],[115,5,115,6],[117,5,117,6],[121,5,121,6],[116,5,116,6]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bars per ",null," mm",null,null,"DIAGRAM"]
[null,null,"Project",{"$f":"'Design criteria'!D2","v":"RC. Cantilever Retaining Wall L "},null,null,null,null,"Cantilever Retaining Wall",null,null,null,null,null,null,"วิธีใช้",null,null,null,null,null,null,2,9,null,null,75,50,null,null,null,null,null,null,"หินแข็ง (Sound rock)",0.6]
[null,null,"Owner",{"$f":"'Design criteria'!D3","v":"Advisory Group"},null,null,null,null,"RW No.","Engineer","Date","Page",null,null,null,"ป้อนค่าเฉพาะเซล สีน้ำเงิน",null,null,null,null,null,null,3,10,null,null,{"$f":"AA2","v":75},{"$f":"D16+AB2","v":80},null,null,null,{"$f":"(AA7+AA8)/2","v":162.5},null,null,"ทรายเม็ดป่น (Silt)",0.35,null,null,"Steel Reinforcement",null,"SECTION"]
[null,null,"Location",{"$f":"'Design criteria'!D4","v":"Chiang Rai"},null,null,null,null,{"$f":"'Design criteria'!K4","v":"RW02"},{"$f":"'Design criteria'!J4","v":"Neung Civil"},{"$f":"'Design criteria'!L4","v":"2021-01-12"},null,null,null,null,null,null,null,null,null,null,null,4,12,null,null,{"$f":"D17+AA2","v":75},{"$f":"AB3","v":80},null,null,null,null,null,null,"ดินเม็ดหยาบปนทรายเม็ดป่น",0.45,null,null,"Stem Backfill V","x",{"$f":"AA6-cover-7.5","v":87.5},{"$f":"AA6-cover","v":95},{"$f":"AP4","v":95},{"$f":"AQ4+CEILING(12*I98/10,5)","v":110},null,{"$f":"AC9","v":75},{"$f":"MIN(AB2:AB10)","v":50},{"$f":"0.8*MAX(AB2:AB10)","v":224},{"$f":"MAX(AA2:AA10)","v":225}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,16,null,null,{"$f":"AA4+D14-D13","v":80},{"$f":"D11+AB2","v":280},null,null,"Water",{"$f":"IF(E12=\"yes\",1,0)","v":0},{"$f":"AF5*D12","v":0},null,"ดินเม็ดหยาบปราศจากทรายเม็ดป่น",0.4,null,null,null,"y",{"$f":"AB6-cover","v":275},{"$f":"AB6-cover","v":275},{"$f":"AB2+coverb+7.5","v":62.5},{"$f":"AQ5","v":62.5},null,{"$f":"0.8*AC10","v":224},{"$f":"AU4+AC10","v":330}]
[null,null,"Materials & Design parametars (ksc)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,20,null,null,{"$f":"AA5+D13","v":100},{"$f":"AB5","v":280},{"$f":"AA6","v":100},{"$f":"AB6","v":280},{"$f":"IF(E12=\"yes\",(AC11+AC12)/2-35,AA2)","v":75},{"$f":"IF(E12=\"yes\",AD11-11,AB2)","v":50},null,null,null,0.7,null,null,"Stem Backfill H","x",{"$f":"AP4-2","v":93},{"$f":"AO6","v":93},{"$f":"AP6","v":93},93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,93,{"$f":"DB6","v":93},93,93,93,93,93,93,93,93,93,93,93,93,93,93,93]
[null,null,"Main bar, fy =",{"$f":"'Design criteria'!G26","v":4000},"fc =",{"$f":"D8*D9","v":157.5},"n = Es/Ec =",{"$f":"'Design criteria'!G29","v":7.2213633576337184},null,"k = 1/(1+fs/n/fc) =",{"$f":"'Design criteria'!G30","v":0.4008524943134068},null,null,null,null,null,null,null,null,null,null,null,7,25,null,null,{"$f":"AA6","v":100},{"$f":"AB3","v":80},{"$f":"AA8","v":225},{"$f":"AD6+D18*TAN(RADIANS(Slope))","v":280},{"$f":"IF(E12=\"yes\",(AC11+AC12)/2+35,AA2)","v":75},{"$f":"AF6","v":50},null,null,"x","y",null,{"$f":"100*AI91","v":42.500000000000007},{"$f":"AO7-AL7*FLOOR((AO7-AB3)/AL7,1)","v":102.99999999999997},"y",{"$f":"AP5-2","v":273},{"$f":"MAX($AM$7,AO7-$AL$7)","v":230.5},{"$f":"MAX($AM$7,AP7-$AL$7)","v":188},{"$f":"MAX($AM$7,AQ7-$AL$7)","v":145.5},103,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,{"$f":"MAX($AM$7,DC7-$AL$7)","v":102.99999999999997},102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997,102.99999999999997]
[null,null,"fc' =",{"$f":"'Design criteria'!G17","v":350},"Ec =",{"$f":"'Design criteria'!J22","v":282495.13270143257},"j = 1-(k/3) =",{"$f":"'Design criteria'!G31","v":0.86638250189553112},null,"R = fc∙k∙j /2 =",{"$f":"'Design criteria'!G32","v":27.349212469502195},null,null,null,null,null,null,null,null,null,null,null,8,28,null,null,{"$f":"D15+AA2","v":225},{"$f":"AB7","v":80},null,null,null,null,null,"Uni",{"$f":"AA6","v":100},{"$f":"AB6","v":280},null,{"$f":"$AD$90","v":true},"Stem Front V","x",{"$f":"AA5+cover","v":85},{"$f":"AO8-(AO9-AP9)*($AA$5-$AA$4)/($AB$5-$AB$4)","v":84.75},{"$f":"AA4+cover","v":80},{"$f":"AQ8-(AQ9-AR9)*($AA$5-$AA$4)/($AB$5-$AB$4)","v":79.5625},{"$f":"AR8+CEILING(12*D99/10,5)","v":94.5625}]
[null,null,"factor =",{"$f":"'Design criteria'!K17","v":0.45},"Es =",{"$f":"'Design criteria'!J23","v":2040000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,32,null,null,{"$f":"AA8","v":225},{"$f":"AB2","v":50},{"$f":"AA2","v":75},{"$f":"MIN(AB2:AB18)","v":20},{"$f":"IF(E12=\"yes\",AE6+15,AA2)","v":75},{"$f":"IF(E12=\"yes\",AF6-8,AB2)","v":50},null,null,{"$f":"AI8","v":100},{"$f":"AJ8+IF(q>=5,50,IF(q>0,MAX(10*q,20),10*q))","v":300},null,null,null,"y",{"$f":"AB5","v":280},{"$f":"AO9-(cover+5)","v":270},{"$f":"AB3","v":80},{"$f":"AQ5","v":62.5},{"$f":"AR9","v":62.5}]
[null,null,"Dimensions (cm)",null,"Hint",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,{"$f":"AA2","v":75},{"$f":"AB9","v":50},{"$f":"MAX(AA8,AB5)","v":280},{"$f":"AD9+AC10","v":300},{"$f":"IF(E12=\"yes\",AE7-15,AA2)","v":75},{"$f":"AF9","v":50},null,null,{"$f":"$AI$8+($AI$22-$AI$8)/5","v":125},{"$f":"AJ9+($AJ$23-$AJ$8)/5","v":300},null,{"$f":"AP10-AL11*FLOOR((AP11-AB3)/AL11,1)*($AA$5-$AA$4)/($AB$5-$AB$4)","v":82.25},"Stem Front H","x",{"$f":"AO8+2","v":87},{"$f":"AP8+2","v":86.75},{"$f":"MAX(AP10-$AL$11*($AA$5-$AA$4)/($AB$5-$AB$4),$AL$10)","v":85.625},{"$f":"MAX(AQ10-$AL$11*($AA$5-$AA$4)/($AB$5-$AB$4),$AL$10)","v":84.5},{"$f":"MAX(AR10-$AL$11*($AA$5-$AA$4)/($AB$5-$AB$4),$AL$10)","v":83.375},82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25]
[null,null,"High, H =",230,"<= 750",null,null,null,null,null,null,null,null,null,null,"Criteria",null,"Weight",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E12=\"yes\",AC6,AA2)","v":75},{"$f":"D12+AB2","v":50},null,null,null,"Uni",{"$f":"AI10","v":125},{"$f":"AJ10-AJ9+AJ8","v":280},null,{"$f":"100*AI90","v":45},{"$f":"AP11-AL11*FLOOR((AP11-AB3)/AL11,1)","v":90},"y",{"$f":"AO9","v":280},{"$f":"AP9","v":270},{"$f":"MAX($AM$11,AP11-$AL$11)","v":225},{"$f":"MAX($AM$11,AQ11-$AL$11)","v":180},{"$f":"MAX($AM$11,AR11-$AL$11)","v":135},{"$f":"MAX($AM$11,AS11-$AL$11)","v":90},{"$f":"MAX($AM$11,AT11-$AL$11)","v":90},{"$f":"MAX($AM$11,AU11-$AL$11)","v":90},90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
[null,null,"Water Height , Hw =",0,"No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTLINE","OUTLINE",null,"q all",{"$f":"AA2","v":75},{"$f":"AB2-2.5*D30","v":20},{"$f":"IF(E12=\"yes\",AC7,AA2)","v":75},{"$f":"AD11","v":50},{"$f":"IF(E12=\"yes\",AE9+10,AA2)","v":75},{"$f":"IF(E12=\"yes\",AF9-6,AB2)","v":50},null,null,{"$f":"AI11","v":125},{"$f":"AJ10","v":300},null,"Plot ","Stem Front V","x",{"$f":"IF($AD$90,AO8,$AO$4)","v":85},{"$f":"IF($AD$90,AP8,$AO$4)","v":84.75},80,79.5625,94.5625,{"$f":"IF($AD$89,AT8,$AO$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($AD$89,DD8,$AO$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Stem thk. Top ,ts1 =",20,"20-30",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA8","v":225},{"$f":"AB12","v":20},null,null,{"$f":"IF(E12=\"yes\",AE10-10,AA2)","v":75},{"$f":"AF12","v":50},null,null,{"$f":"$AI$8+($AI$22-$AI$8)/5*2","v":150},{"$f":"AJ12+($AJ$23-$AJ$8)/5","v":300},null,null,null,"y",{"$f":"IF($AD$90,AO9,$AO$5)","v":280},{"$f":"IF($AD$90,AP9,$AO$5)","v":270},80,62.5,62.5]
[null,null,"Stem thk. Bot ,ts2 =",25,{"$f":"\">= \"&FIXED(AA27,0)","v":">= 20"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes",null,"qs",{"$f":"AA2","v":75},{"$f":"AB2","v":50},null,null,null,null,null,null,{"$f":"AI13","v":150},{"$f":"AJ13-AJ12+AJ11","v":280},null,null,"Stem Front H","x",{"$f":"IF($AD$90,AO10,$AO$6)","v":87},{"$f":"IF($AD$90,AP10,$AO$6)","v":86.75},{"$f":"IF($AD$90,AQ10,$AO$6)","v":85.625},{"$f":"IF($AD$90,AR10,$AO$6)","v":84.5},83.375,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,82.25,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($AD$90,DD10,$AO$6)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Base length, B =",150,{"$f":"FIXED(AA28,0)&\"-\"&FIXED(AB28,0)","v":"115-161"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No",null,"qs",{"$f":"AA14","v":75},{"$f":"AB14-2.5*F75","v":26.336129629629625},null,null,{"$f":"IF(E12=\"yes\",(AC11+AC12)/2,AA2)","v":75},{"$f":"IF(E12=\"yes\",AD11,AB2)","v":50},null,null,{"$f":"AI14","v":150},{"$f":"AJ13","v":300},null,null,null,"y",{"$f":"IF($AD$90,AO11,$AO$7)","v":280},{"$f":"IF($AD$90,AP11,$AO$7)","v":270},{"$f":"IF($AD$90,AQ11,$AO$7)","v":225},{"$f":"IF($AD$90,AR11,$AO$7)","v":180},135,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($AD$90,DD11,$AO$7)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Base thk., tb =",30,{"$f":"FIXED(AB29,0)","v":"23"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qs",{"$f":"IF(AND(AG52>=AH52,AG52<=AI52),D15,300*AG52)+AA2","v":225},{"$f":"AB14-2.5*F76","v":48.963870370370373},null,null,{"$f":"IF(E12=\"yes\",AE15+20,AA2)","v":75},{"$f":"IF(E12=\"yes\",AF15+22,AB2)","v":50},null,null,{"$f":"$AI$8+($AI$22-$AI$8)/5*3","v":175},{"$f":"AJ15+($AJ$23-$AJ$8)/5","v":300},null,null,"Footing Top","x",{"$f":"AA3+cover","v":80},{"$f":"AA8-cover","v":220}]
[null,null,"Toe length, bt =",0,{"$f":"FIXED(AA30,0)&\"-\"&FIXED(AB30,0)","v":"23-50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"qs",{"$f":"AA16","v":225},{"$f":"AB14","v":50},null,null,{"$f":"IF(E12=\"yes\",AE15-10,AA2)","v":75},{"$f":"IF(E12=\"yes\",AF15+20,AB2)","v":50},null,null,{"$f":"AI16","v":175},{"$f":"AJ16-AJ15+AJ14","v":280},null,null,null,"y",{"$f":"AB3-cover","v":75},{"$f":"AO17","v":75}]
[null,null,"Heel length, bh =",{"$f":"D15-D17-D14","v":125},null,null,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":"AE15","v":75},{"$f":"AF15","v":50},null,null,{"$f":"AI17","v":175},{"$f":"AJ16","v":300},null,null,"Footing Bot","x",{"$f":"AO16","v":80},{"$f":"AP16","v":220},null,{"$f":"(AO20+AP20)/2","v":99.375}]
[null,null,"Soil Cover @Toe, hs =",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"300","v":300},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AI$8+($AI$22-$AI$8)/5*4","v":200},{"$f":"AJ18+($AJ$23-$AJ$8)/5","v":300},null,null,null,"y",{"$f":"AB2+cover","v":55},{"$f":"AO19","v":55}]
[null,null,"Backfill Slope , b1 =",0,"deg.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,null,null,null,null,null,null,{"$f":"AA2","v":75},{"$f":"AB3+D19","v":80},null,null,null,null,{"$f":"AI19","v":200},{"$f":"AJ19-AJ18+AJ17","v":280},null,{"$f":"(D15-2*cover-5)/CEILING((D15-2*cover-5)/(100*AI127),1)","v":33.75},"Footing dot","x",{"$f":"AO16+2.5","v":82.5},{"$f":"MIN($AP$16-2.5,AO20+$AL$20)","v":116.25},{"$f":"MIN($AP$16-2.5,AP20+$AL$20)","v":150},{"$f":"MIN($AP$16-2.5,AQ20+$AL$20)","v":183.75},217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5,217.5]
[null,null,"Cover Stem =",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V19-V20","v":226},null,null,null,null,{"$f":"MAX(AB2:AB18)-MIN(AB2:AB18)","v":260},{"$f":"MAX(AA2:AA18)","v":225},{"$f":"AA4+D19/(D11-D16)*(D14-D13)","v":75},{"$f":"AD20","v":80},null,null,null,null,{"$f":"AI20","v":200},{"$f":"AJ19","v":300},null,null,"top","y",{"$f":"AO17-2.5","v":72.5},{"$f":"AO21","v":72.5},{"$f":"AP21","v":72.5},72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5,72.5]
[null,null,"Cover Base =",5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"(AB5+AB4)/2","v":180},null,{"$f":"AC7","v":225},{"$f":"AJ21+($AJ$23-$AJ$8)/5","v":300},null,null,"bot","y",{"$f":"AO19+2.5","v":57.5},{"$f":"AO22","v":57.5},{"$f":"AP22","v":57.5},57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5,57.5]
[null,null,"Loading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V21/V22","v":75.333333333333329},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI22","v":225},{"$f":"AD7","v":280},null,null,null,{"$f":"AA6","v":100},{"$f":"IF(AO20<=$AN$23,$CD$20,AO20)-$AN$23","v":117.5},16.25,50,83.75,117.5,117.5,117.5,117.5,117.5,117.5,{"$f":"IF(AY20<=$AN$23,$CD$20,AY20)-$AN$23","v":117.5},117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,117.5,{"$f":"MIN(AO23:CD23)","v":16.25}]
[null,null,"Surcharge,  qs =",0.5,"T/m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V20+V23","v":149.33333333333331},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footing dot Name","x",{"$f":"AA6+CE23","v":116.25},{"$f":"AO24","v":116.25},{"$f":"AP24","v":116.25},{"$f":"AQ24+15","v":131.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100*(V24-AQ25)","v":11433.333333333332},null,null,null,null,null,null,null,null,null,"Height fir stability, Hs=",{"$f":"(D11+D18*TAN(RADIANS(Slope)))/100","v":2.2999999999999998},null,null,null,null,null,"top","y",{"$f":"AO21-2","v":70.5},{"$f":"AO22-2","v":55.5},{"$f":"AB2-15","v":35},{"$f":"AQ25","v":35}]
[null,null,"Soil Properties",null,null,"Ka, Kp Options :","Rankine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hint",null,null,null,null,null,"Active pressure pa = ka g =",{"$f":"G27*D27","v":0.61666666666666692},"T/m2/m","Pa",null,{"$f":"\"Rh =\"&FIXED(AG46,2)","v":"Rh =2.01"}]
[null,null,"Moist Density, gs =",1.85,"T/m³","Ka =",{"$f":"IF($G$26=\"Rankine\",AA36,Y36)","v":0.33333333333333343},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stem thk. ,ts =",{"$f":"(D11-D16)/10","v":20},{"$f":"(D11-D16)/12","v":16.666666666666668},null,null,null,"For stability analysis",null,null,{"$f":"AA8","v":225},{"$f":"AI27","v":225},{"$f":"AI30","v":149.92240215924426},{"$f":"AK36","v":162.98177387914228},null,null,"ELEVATION",null,{"$f":"\"Ø \"&I98&$AG$86","v":"Ø 12 @ 0.200 m."},null,{"$f":"\"Ø \"&I100&$AJ$91","v":"Ø 12 @ 0.425 m."}]
[null,null,"Sat. Density, gsat =",2,"T/m³","Kp =",{"$f":"IF($G$26=\"Rankine\",AB36,Z36)","v":2.9999999999999996},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base length, B =",{"$f":"0.5*D11","v":115},{"$f":"0.7*D11","v":161},null,null,null,"Active force Pa = ka g Hs2/2 =",{"$f":"G27*D27*AG25^2/2","v":1.6310833333333337},"T/m",{"$f":"AB8","v":80},{"$f":"AD7","v":280},{"$f":"100*AG47+AB2","v":133.96130669203933},{"$f":"AK28","v":133.96130669203933},"Outline","x",{"$f":"AA9+MIN(60,D11/4)","v":282.5},{"$f":"AO28","v":282.5},{"$f":"AP28","v":282.5},{"$f":"AQ28","v":282.5},{"$f":"AR28+200","v":482.5},{"$f":"AS28","v":482.5},{"$f":"AT28","v":482.5},{"$f":"AU28","v":482.5},{"$f":"AO28","v":282.5},{"$f":"AO28","v":282.5},{"$f":"AS28","v":482.5},null,"Cutoff from Base",{"$f":"CEILING((1-SQRT(2)/2)*(D11-D16)+4*I98,5)","v":110},{"$f":"FIXED(BB28/100,2)","v":"1.10"},null,"CutOff Dim Line",{"$f":"AS28+15","v":497.5},{"$f":"BF28","v":497.5},null,{"$f":"BF28-10","v":487.5},{"$f":"BF28+5","v":502.5},null,{"$f":"BI28","v":487.5},{"$f":"BJ28","v":502.5},null,"CutOff Dim Name",{"$f":"BF28","v":497.5}]
[null,null,"Friction Angle (Ø) =",30,"deg.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base thk., tb =",{"$f":"D11/12","v":19.166666666666668},{"$f":"D11/10","v":23},null,null,null,"Pah = Pa cos B =",{"$f":"$AG$28*COS(RADIANS(Slope))","v":1.6310833333333337},"T/m",{"$f":"\"Rv = \"&FIXED(AK50,2)","v":"Rv = 7.41"},null,null,null,null,"y",{"$f":"AP29-5","v":45},{"$f":"AB9","v":50},{"$f":"AB5+5","v":285},{"$f":"AB5","v":280},{"$f":"AR29","v":280},{"$f":"AQ29","v":285},{"$f":"AO29","v":45},{"$f":"AP29","v":50},{"$f":"AV29","v":50},{"$f":"AB3","v":80},{"$f":"AX29","v":80},null,"Cutoff from top",{"$f":"(D11-D16)-BB28","v":90},null,null,null,{"$f":"AY29-5","v":75},{"$f":"BA31+5","v":280},null,{"$f":"BA31","v":275},{"$f":"BI29","v":275},null,{"$f":"AY29","v":80},{"$f":"BL29","v":80},null,null,{"$f":"(BF29+BG29)/2","v":177.5}]
[null,null,"Soil bearing , q all =",12,"T/m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toe length, bt =",{"$f":"AB29","v":23},{"$f":"D15/3","v":50},null,null,null,"Pav = Pa sin B =",{"$f":"$AG$28*SIN(RADIANS(Slope))","v":0},null,{"$f":"100*AG48+AA2","v":149.92240215924426},{"$f":"AI30","v":149.92240215924426},null,null,"Steel","x",{"$f":"(AS28+AO28)/2","v":382.5},{"$f":"AO30","v":382.5},{"$f":"AP30+10","v":392.5},null,{"$f":"AO28+(AS28-AO28)/6","v":315.83333333333331},{"$f":"AS30","v":315.83333333333331},{"$f":"AT30+10","v":325.83333333333331},null,{"$f":"AO28+5*(AS28-AO28)/6","v":449.16666666666663},{"$f":"AW30","v":449.16666666666663},{"$f":"AX30+10","v":459.16666666666663},null,{"$f":"AO28+(AS28-AO28)/3","v":349.16666666666669},{"$f":"BA30","v":349.16666666666669},{"$f":"BB30+10","v":359.16666666666669},null,{"$f":"AO28+2*(AS28-AO28)/3","v":415.83333333333337},{"$f":"BE30","v":415.83333333333337},{"$f":"BF30+10","v":425.83333333333337}]
[null,null,"Friction μs =",0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water force Pw =","(ka*(gs-gw-g)+gw)*Water^2/2",null,{"$f":"AK28","v":133.96130669203933},{"$f":"AK37","v":182},null,null,null,"y",{"$f":"AO5","v":275},{"$f":"AQ5","v":62.5},{"$f":"AP31","v":62.5},null,{"$f":"AO31","v":275},{"$f":"AP31","v":62.5},{"$f":"AT31","v":62.5},null,{"$f":"AS31","v":275},{"$f":"AT31","v":62.5},{"$f":"AX31","v":62.5},null,{"$f":"AW31","v":275},{"$f":"AX31","v":62.5},{"$f":"BB31","v":62.5},null,{"$f":"BA31","v":275},{"$f":"BB31","v":62.5},{"$f":"BF31","v":62.5}]
[null,null,"Resisting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D11","v":230},{"$f":"AA32","v":230},null,null,null,null,{"$f":"IF(D12<=0,0,(G27*(D28-1-D27)+1)*(D12/100)^2/2)","v":0},"T/m","CL",null,null,null,"Steel position","x",{"$f":"(AA6+AO28)/2","v":191.25},{"$f":"AP4","v":95},{"$f":"(AA6+AO28)/2","v":191.25},{"$f":"AS30","v":315.83333333333331},null,{"$f":"AP32","v":95},{"$f":"(AP32+AQ32)/2","v":143.125},null,{"$f":"(FLOOR((AA8-AA7)/AL20/2,1)+0.5)*AL20+AO24","v":166.875},{"$f":"AW32","v":166.875},{"$f":"AX32+15","v":181.875},{"$f":"(AO20+AP20)/2","v":99.375},{"$f":"AZ32","v":99.375},{"$f":"BA32+15","v":114.375}]
[null,null,null,"Force","Lever arm","Moment about toe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.4*AA32","v":92},{"$f":"0.7*AB32","v":161},null,null,null,"For stem design",null,null,{"$f":"(AA2+AA8)/2","v":150},{"$f":"AI33","v":150},null,null,null,"y",{"$f":"AP7","v":230.5},{"$f":"AQ33-AL7/2","v":209.25},{"$f":"AP7","v":230.5},{"$f":"AP33","v":209.25},null,{"$f":"AS7","v":103},{"$f":"AT33+AL7/4","v":113.625},null,{"$f":"AO17","v":75},{"$f":"AB3+20","v":100},{"$f":"AX33","v":100},{"$f":"AO19","v":55},{"$f":"AB2-30","v":20},{"$f":"BA33","v":20}]
[null,null,null," W, (T/m)","L, (m)","(T-m/m)",null,null,null,"Wall Geometry",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Active force Pa = ka g Hstem2/2 =",{"$f":"G27*D27*((D11-D16)/100)^2/2","v":1.2333333333333338},null,{"$f":"AB2-5","v":45},{"$f":"0.8*AB5","v":224}]
[null,null,"Stem Wall ",{"$f":"AK41","v":1.08},{"$f":"AL41","v":0.13703703703703704},{"$f":"D35*E35","v":0.14800000000000002},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CKa","CKp","RKa","RKp",null,null,null,"Pah = Pa cos B =",{"$f":"$AG$34*COS(RADIANS(Slope))","v":1.2333333333333338},"T/m","R",null,null,null,null,null,{"$f":"D11/4","v":57.5}]
[null,null,"Footing Weight ",{"$f":"AK42","v":1.08},{"$f":"AL42","v":0.75},{"$f":"D36*E36","v":0.81},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COS(RADIANS(s_phi))^2/(COS(RADIANS(s_phi/2))*(1+SQRT(SIN(RADIANS(s_phi+s_phi/2))*SIN(RADIANS(s_phi-Slope))/(COS(RADIANS(s_phi/2))*COS(RADIANS(-Slope)))))^2)","v":0.30141664480394886},{"$f":"COS(RADIANS(s_phi))^2/(COS(RADIANS(s_phi/2))*(1-SQRT(SIN(RADIANS(s_phi+s_phi/2))*SIN(RADIANS(s_phi+Slope))/(COS(RADIANS(s_phi/2))*COS(RADIANS(Slope)))))^2)","v":4.9765002227254191},{"$f":"COS(RADIANS(Slope))*(COS(RADIANS(Slope))-SQRT(COS(RADIANS(Slope))^2-COS(RADIANS(s_phi))^2))/(COS(RADIANS(Slope))+SQRT(COS(RADIANS(Slope))^2-COS(RADIANS(s_phi))^2))","v":0.33333333333333343},{"$f":"COS(RADIANS(Slope))*(COS(RADIANS(Slope))+SQRT(COS(RADIANS(Slope))^2-COS(RADIANS(s_phi))^2))/(COS(RADIANS(Slope))-SQRT(COS(RADIANS(Slope))^2-COS(RADIANS(s_phi))^2))","v":2.9999999999999996},null,null,null,"Pav = Pa sin B =",{"$f":"$AG$34*SIN(RADIANS(Slope))","v":0},"T/m",{"$f":"AA2+100*AG52","v":127.09742840005998},{"$f":"AI30","v":149.92240215924426},{"$f":"AJ36+(AK37-AJ37)*AI38","v":162.98177387914228},null,{"$f":"(AA8-AA7)/AL20/2","v":1.8518518518518519},{"$f":"(FLOOR((AA8-AA7)/AL20/2,1)+0.5)*AL20+AO24","v":166.875}]
[null,null,"Soil Cover @ Toe ",0,0,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,"Water force Pw =","(ka*(gs-gw-g)+gw)*(Water-tb)^2/2",null,{"$f":"AB2","v":50},{"$f":"AI31","v":133.96130669203933},{"$f":"0.65*AB5","v":182},null,{"$f":"FLOOR(AM36,1)","v":1},{"$f":"FLOOR(AN36,1)","v":166},null,null,null,null,null,null,null,null,null,"@ Cutoff","t = ",{"$f":"D13+BB29/(D11-D16)*(D14-D13)","v":22.25},"d=",{"$f":"AZ37-cover-I98/20","v":16.649999999999999}]
[null,null,"Backfill Weight ",4.625,0.875,4.046875,null,null,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":"(G27*(D28-1-D27)+1)*(MAX(0,(D12-D16))/100)^2/2","v":0},"T/m",{"$f":"(AJ36-AI36)/(AJ37-AI37)","v":0.27185110211425989},null,null,null,null,null,null,null,"USEAGE",null,null,null,null,null,null,null,{"$f":"\"As min.= \"&IF($D$7=4000,BB38,IF($D$7=3000,BB39,BB40))","v":"As min.= 0.0018·b·d = "},{"$f":"IF($D$7=4000,BC38,IF($D$7=3000,BC39,BC40))*100*BB37","v":2.9969999999999994},"cm2/m","0.0018·b·d = ",1.8E-3,1.8E-3]
[null,null,"Backfill Slope ",0,1.0833333333333335,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,"Overturning Forces",null,null,null,null,"Resisting",null,null,null,null,null," overturning",{"$f":"L48","v":0.60929636801208831},{"$f":"IF(AR39>1,1,0)","v":0},{"$f":"IF(AS39=0,\"\",AQ39)","v":""},0.91353085175662685,null,null,null,"As min.= 14/fy bd =",{"$f":"14/$D$7*100*BB37","v":5.8274999999999997},"cm2/m","0.0020·b·d = ",2E-3,2E-3]
[null,null,"Water Weight ",0,0.875,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,"Force, T/m","Arm, m","Moment, T-m/m",null,"Force, T/m","Arm, m","Moment, T-m/m",null,null,null," sliding",{"$f":"L67","v":0.64348080711281497},0,"",0.43079377398182034,null,null,null,"As min.=",{"$f":"MIN(MAX(AZ38:AZ39),1.34*AG78/2)","v":2.7096007814035001},"cm2/m","0.0025·b·d = ",2.5000000000000001E-3,2.5000000000000001E-3]
[null,null,"Backfill Pav ",0,1.5,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,"Backfill =",{"$f":"AG29","v":1.6310833333333337},{"$f":"AG25/3","v":0.76666666666666661},{"$f":"AG41*AH41","v":1.2504972222222224},"Stem Wall",{"$f":"2.4*0.5*(D13+D14)/100*(D11-D16)/100","v":1.08},{"$f":"(D17+(2*D13*D14-D13^2+2*D14^2)/(3*(D13+D14)))/100","v":0.13703703703703704},{"$f":"AK41*AL41","v":0.14800000000000002},null,null,null," bearing",{"$f":"F78","v":0.78879567901234582},0,"",0.59096572829652838,null,null,null,null,null,null,2.5000000000000001E-3]
[null,null,"Surcharge Vertical ",{"$f":"AK48","v":0.625},0.875,0.546875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Table =",{"$f":"AG32","v":0},{"$f":"D12/100/3","v":0},{"$f":"AG42*AH42","v":0},"Base",{"$f":"2.4*(D15*D16)/10000","v":1.08},{"$f":"D15/100/2","v":0.75},0.81]
[null,null,"Water Buoyancy ",{"$f":"AK49","v":0},0.75,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,"Surcharge =",{"$f":"G27*D24*AG25","v":0.38333333333333341},{"$f":"AG25/2","v":1.1499999999999999},{"$f":"AG43*AH43","v":0.44083333333333341},"Soil Cover @Toe",{"$f":"(D17*D19)*D27/10000","v":0},{"$f":"D17/200","v":0},0]
[null,null,"Rv = ",{"$f":"SUM(D35:D43)","v":7.41},"RM = ",{"$f":"SUM(F35:F43)","v":5.5517500000000002},null,null,null,null,"Arm of Hor. Resultant = OTM / Rh = ",{"$f":"AG47","v":0.83961306692039328},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Backfill W",{"$f":"D18*(D11-D16)*D27/10000","v":4.625},{"$f":"(D15-D18/2)/100","v":0.875},4.046875]
[null,null,null,null,null,null,null,null,null,null,"Arm of Ver. Resultant = RM / Rv = ",{"$f":"AG48","v":0.74922402159244261},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passive =",0,{"$f":"(D16+D19)/3/100","v":0.1},{"$f":"AG45*AH45","v":0},"Backfill Slope W",{"$f":"0.5*D18*D18*TAN(RADIANS(Slope))*D27/10000","v":0},{"$f":"(D15-D18/3)/100","v":1.0833333333333335},0]
[null,null," Overturning about toe (T-m.)",null,null,null,null,null,null,null,"Overturning Ratio = RM / OTM = ",{"$f":"AG49","v":3.2824748431133277},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sum Rh ",{"$f":"SUM(AG41:AG45)","v":2.014416666666667},null,{"$f":"SUM(AI41:AI45)","v":1.6913305555555558},"Water W",{"$f":"D18*MAX((D12-D16),0)*(D28-D27)/10000","v":0},{"$f":"AL44","v":0.875},0]
[null,null,null,"Force","Lever arm","Moment about toe",null,null,null,null,null,{"$f":"IF(L46>=2,\">= 2.0 OK\",\"<2.0 N.G\")","v":">= 2.0 OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arm of Horizont Resultant =",{"$f":"AI46/AG46","v":0.83961306692039328},"m",null,"Pav",{"$f":"AG30","v":0},{"$f":"D15/100","v":1.5},0]
[null,null,null," W, (T/m)","L, (m)","(T-m/m)",null,null,null,null,null,{"$f":"2/L46","v":0.60929636801208831},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arm of Vertical Resultant =",{"$f":"AM50/AK50","v":0.74922402159244261},"m",null,"Surcharge Ver =",{"$f":"D18*D24/100","v":0.625},{"$f":"(D15-D18/2)/100","v":0.875},0.546875]
[null,null,"Backfill ",{"$f":"AG41","v":1.6310833333333337},{"$f":"AH41","v":0.76666666666666661},{"$f":"D49*E49","v":1.2504972222222224},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overturning Ratio =",{"$f":"AM50/AI46","v":3.2824748431133277},{"$f":"IF(AG49>=2,\"> 2.0 OK\",\"<2.0 N.G\")","v":"> 2.0 OK"},null,"Water Buoyancy",{"$f":"-D12*D15/10000","v":0},{"$f":"D15/200","v":0.75},0]
[null,null,"Water ",{"$f":"AG42","v":0},{"$f":"AH42","v":0},{"$f":"D50*E50","v":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,"Rv =",{"$f":"SUM(AK41:AK49)","v":7.41},"RM =",{"$f":"SUM(AM41:AM49)","v":5.5517500000000002}]
[null,null,"Surcharge ",{"$f":"AG43","v":0.38333333333333341},1.1499999999999999,0.44083333333333341,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Soil Bearing Pressure",null,null,"l/3","2l/3"]
[null,null,"Passive ",{"$f":"AG45","v":0},{"$f":"AH45","v":0.1},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,"Resultant from toe, a =",{"$f":"(AM50-AI46)/AK50","v":0.52097428400059975},{"$f":"D15/100/3","v":0.5},{"$f":"2*AH52","v":1},"∑R =",{"$f":"SQRT(AK50^2+AG46^2)","v":7.6789305575024214}]
[null,null,"Rh = ",{"$f":"SUM(D49:D52)","v":2.014416666666667},"OTM = ",{"$f":"SUM(F49:F52)","v":1.6913305555555558},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eccentric =",{"$f":"D15/200-(AM50-AI46)/AK50","v":0.22902571599940025},"m",{"$f":"IF(AND(AG52>AH52,AG52<AI52),\"Case (a)\",IF(OR(AG52=AH52,AG52=AI52),\"Case (b)\",\"Case (c)\"))","v":"Case (a)"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing length =",{"$f":"MIN(D15/100,3*(D15/200-AG53))","v":1.5},"m"]
[null,null,"Rankine Theory",null,null,null,null,"The Coulomb Theory",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toe bearing =",{"$f":"AK50/(D15/100)+6*AK50*AG53/(D15/100)^2","v":9.4655481481481498},"T/m2",{"$f":"IF(MAX(AG55:AG56)<=D30,\"< \"&FIXED(D30,1)&\" T/m OK.\",\"> \"&FIXED(D30,1)&\" T/m NG.\")","v":"< 12.0 T/m OK."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heel bearing =",{"$f":"AK50/(D15/100)-6*AK50*AG53/(D15/100)^2","v":0.41445185185185096},"T/m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heel bearing =",{"$f":"MAX(AG56,0)","v":0.41445185185185096},"T/m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sliding"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction μs =",{"$f":"D31","v":0.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Friction Force =",{"$f":"D31*D44","v":4.4459999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passive Depth =",{"$f":"(D19+D16)/100","v":0.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,"Passive pressure top =",0,"T/m2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passive pressure bot =",{"$f":"G28*D27*AG61","v":1.6649999999999998},"T/m2",{"$f":"0.5*(AG62+AG63)*AG61","v":0.24974999999999997}]
[null,null," Sliding (T.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Passive pressure Force =",{"$f":"0.5*(AG62+AG63)*AG61","v":0.24974999999999997},"T/m",{"$f":"0.5*AG63*AG61","v":0.24974999999999997}]
[null,null,null,null,"Friction μs =",{"$f":"D31","v":0.6},"T/m",null,null,null,"Sliding Safety Factor = Resisting / Sliding =",{"$f":"F68/F69","v":2.3310718570305706},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sliding Ratio(Pp+Friction) /Rh =",{"$f":"(AG64+AG60)/AG46","v":2.3310718570305706},"T/m",{"$f":"IF(AG65>=1.5,\"> 1.50 OK.\",\"< 1.50 NG.\")","v":"> 1.50 OK."}]
[null,null,null,null,"Friction Force, μs x Rv =",{"$f":"D31*D44","v":4.4459999999999997},"T/m",null,null,null,null,{"$f":"IF(L65>=1.5,\"> 1.5 OK\",\"<1.5 N.G\")","v":"> 1.5 OK"}]
[null,null,null,null,"Passive pres. Force =",{"$f":"AG64","v":0.24974999999999997},"T/m2",null,null,null,null,{"$f":"1.5/L65","v":0.64348080711281497},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wall Stem Design"]
[null,null,null,null,"Horiz. Resisting Force =",{"$f":"F66+F67","v":4.6957499999999994},"T/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Force, T/m","Arm, m","Moment, T-m/m"]
[null,null,null,null,"Horiz. Sliding Force =",{"$f":"D53","v":2.014416666666667},"T/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Backfill = Pah =",{"$f":"AG35","v":1.2333333333333338},{"$f":"(D11-D16)/100/3","v":0.66666666666666663},{"$f":"AG69*AH69","v":0.82222222222222252}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water table =",{"$f":"AG38","v":0},{"$f":"MAX(0,(D12-D16))/100/3","v":0},{"$f":"AG70*AH70","v":0}]
[null,null," Bearing  (T/m2.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surcharge =",{"$f":"G27*D24*(D11-D16)/100","v":0.33333333333333343},{"$f":"(D11-D16)/100/2","v":1},{"$f":"AG71*AH71","v":0.33333333333333343}]
[null,null,null,null,"Rv = ",{"$f":"D44","v":7.41},"Ton.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14/fy bd",null,null,null,null,"Max shear =",{"$f":"SUM(AG69:AG71)","v":1.5666666666666673},null,{"$f":"SUM(AI69:AI71)","v":1.1555555555555559}]
[null,null,null,null,"Resultant from toe, a =",{"$f":"AG52","v":0.52097428400059975},"m.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,null,null,null,null,"d =",{"$f":"D14-cover-I98/20","v":19.399999999999999},"cm"]
[null,null,null,null,"Eccentricity =",{"$f":"AG53","v":0.22902571599940025},"m.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4000,null,null,null,null,"Shear at critacal section =",{"$f":"(D11-D16-AG73)/(D11-D16)*AG72","v":1.4147000000000007}]
[null,null,null,null,"Toe Bearing q1 =",{"$f":"AG55","v":9.4655481481481498},"T/m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA73/AA74","v":3.5000000000000001E-3},null,null,null,null,"Max Moment =",{"$f":"AI72","v":1.1555555555555559}]
[null,null,null,null,"Heel Bearing q2 =",{"$f":"AG57","v":0.41445185185185096},"T/m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA75*100*42","v":14.700000000000001},null,null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"0.29*SQRT('Design criteria'!$G$17)*100*AG73/1000","v":10.525282228995094},"T",{"$f":"IF(AG76>=AG74,\" OK\",\" N.G\")","v":" OK"},4000]
[null,null,null,null,"Soil bearing , q all =",{"$f":"D30","v":12},"T/m²",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr = Rbd²  = ",{"$f":"$K$8*100*AG73^2/100/1000","v":10.293149605021846},"T-m",{"$f":"IF(AG77>=AG75,\" OK\",\" N.G\")","v":" OK"},1.8E-3]
[null,null,{"$f":"AI53","v":"Case (a)"},null,"q max / q all =",{"$f":"MAX(F75:F76)/D30","v":0.78879567901234582},{"$f":"IF(F78<=1,\" OK\",\" N.G\")","v":" OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.33 as req",null,null,null,null,"Ast Req =  M/(fs j d) = ",{"$f":"100000*AI72/('Design criteria'!$G$27*MAIN!$H$8*AG73)","v":4.0441802707514922},"cm2/m",{"$f":"AG78*1.34","v":5.4192015628070003},{"$f":"AJ76*AJ77","v":7.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,1.33,null,null,{"$f":"IF(AND(I98<=16,D7=4000),0.0012,0.0015)","v":1.1999999999999999E-3},null,{"$f":"\"As min.= \"&AD79&\"b.t\"","v":"As min.= 0.0012b.t"},{"$f":"AD79*100*D14","v":3},"cm2/m","0.0018·b·t = ",1.8E-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,7.8,null,null,null,null,"As min.= 14/fy bd =",{"$f":"14/$D$7*100*AG73","v":6.79},"cm2/m","0.0020·b·t = ",2E-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,{"$f":"AA79*AA80","v":10.374000000000001},null,null,null,null,"As min1.=",{"$f":"MIN(MAX(AG79:AG80),1.34*AG78)","v":5.4192015628070003},"cm2/m","0.0025·b·t = ",2.5000000000000001E-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,12.2,null,null,null,null,"Use Ø vertical =",{"$f":"I98","v":12},"mm",null,{"$f":"MIN(2.29*SQRT($D$8)/(AG82/10),25)","v":25},{"$f":"1000*AG72/(AI85*H8*AG73)","v":4.9449789210278068},{"$f":"IF(AK82<=AJ82,\"OK\",\"NG\")","v":"OK"}]
[null,null,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":"AA82/AA79","v":9.1729323308270665},null,null,null,null,"As1",{"$f":"3.14159*$AG$82^2/400","v":1.1309724000000001}]
[null,null,null,null,null,null,null,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 req =",{"$f":"MAX(AG78,AG81)","v":5.4192015628070003},null,"∑O = Lo/@","Ld at footing = Base thk - cover","Hook 12Db","Ld = db fs/(4u)"]
[null,null,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":"PI()/4","v":0.78539816339744828},null,null,null,null,"@ Min(3t,45,As min) =",{"$f":"MIN(AG83/AG84,3*D14/100,0.45)","v":0.20869723830943593},{"$f":"FLOOR(1.025*$AG85,0.025)","v":0.2},{"$f":"3.14159*AG82/10/AH85","v":18.849539999999998},{"$f":"D16-cover","v":25},{"$f":"12*AG82/10","v":14.4},{"$f":"AG82/10*'Design criteria'!G27/(4*AJ82)","v":20.399999999999999},{"$f":"IF(AL85<(AJ85+AK85),\"OK\",\"NG\")","v":"OK"}]
[null,null,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":"2*AA85","v":1.5707963267948966},null,null,null,"Ver","Use",{"$f":"\" @ \"&FIXED(FLOOR(1.025*$AG$85,0.025),3)&\" m.\"","v":" @ 0.200 m."},{"$f":"AG83/AH85","v":5.6548620000000005}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Ø Transv. =",{"$f":"I100","v":12},"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,"d",0.5,{"$f":"PI()*Z88^2/4","v":0.19634954084936207},null,null,null,"Transv.","As1",{"$f":"3.14159*$AG87^2/400","v":1.1309724000000001}]
[null,null," Wall Stem Design",null,null,null,null,null,null,"d =",{"$f":"AG73","v":19.399999999999999},"cm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12/15","v":0.8},null,null,{"$f":"IF(AND(I100<=16,D7=4000),0.002,0.0025)","v":2E-3},null,{"$f":"\"As min.= \"&AD89&\"b.t\"","v":"As min.= 0.002b.t"},{"$f":"AD89*100*(D13+D14)/2","v":4.5},"cm2/m","@"]
[null,null,null,"Force","Lever arm","Moment",null,null,null,"Shear at critacal section, V =",{"$f":"AG74","v":1.4147000000000007},"T/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA88*AA89","v":0.15707963267948966},null,null,true,null,"As min2 FrontSide = ",{"$f":"AD90*0.4*AG89","v":1.8},{"$f":"MIN($AG88/($AG90+0.01),3*$D$14/100,0.45)","v":0.45},{"$f":"FLOOR(1.025*$AH$90,0.025)","v":0.45},{"$f":"\" @\"&FIXED(AI90,3)&\" m.\"","v":" @0.450 m."},{"$f":"$AG$88/AI90","v":2.5132720000000002},{"$f":"\"Ø \"&I100&$AJ$90&\" (\"&FIXED(AK90,2)&\"  cm2 )\"","v":"Ø 12 @0.450 m. (2.51  cm2 )"}]
[null,null,null," W, (T/m)","L, (m)","(T-m/m)",null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"AG76","v":10.525282228995094},{"$f":"\"T/m \"&AI76","v":"T/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12/7.5","v":1.6},null,null,null,null,"As min1 Backfill = ",{"$f":"AG89-AG90","v":2.7},{"$f":"MIN($AG$88/$AG$91,3*$D$14/100,0.45)","v":0.41887866666666668},{"$f":"FLOOR(1.025*$AH$91,0.025)","v":0.42500000000000004},{"$f":"\" @ \"&FIXED(AI91,3)&\" m.\"","v":" @ 0.425 m."},{"$f":"$AG$88/AI91","v":2.6611115294117647},{"$f":"$AJ$91&\" (\"&FIXED(AK91,2)&\"  cm2 )\"","v":" @ 0.425 m. (2.66  cm2 )"}]
[null,null,"Backfill ",{"$f":"AG69","v":1.2333333333333338},{"$f":"AH69","v":0.66666666666666663},{"$f":"AI69","v":0.82222222222222252},null,null,null,"MR = Rbd2 =",{"$f":"AG77","v":10.293149605021846},{"$f":"\"T-m/m \"&AI77","v":"T-m/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA88*AA91","v":0.31415926535897931},null,null,null,"Ver","As3",{"$f":"D99","v":12},"mm"]
[null,null,"Water table",{"$f":"AG70","v":0},0,0,null,null,null,"As req = M/jsjd =",{"$f":"AG78","v":4.0441802707514922},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As3",{"$f":"3.14159*$AG$92^2/400","v":1.1309724000000001},null,"@"]
[null,null,"Surcharge ",{"$f":"AG71","v":0.33333333333333343},1,0.33333333333333343,null,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 min.= 2/3* 0.0015·b·t = ",{"$f":"2/3*AD79*100*(D13+D14)/2","v":1.7999999999999998},{"$f":"MIN($AG$93/($AG$94+0.01),3*$D$14/100,0.45)","v":0.45},{"$f":"FLOOR(1.025*$AH$94,0.025)","v":0.45},{"$f":"\"@\"&FIXED(AI94,3)&\" m.\"","v":"@0.450 m."},{"$f":"$AG$93/AI94","v":2.5132720000000002},{"$f":"$AJ$94&\" (\"&FIXED(AK94,2)&\"  cm2)\"","v":"@0.450 m. (2.51  cm2)"}]
[null,null,"V max = ",{"$f":"SUM(D92:D94)","v":1.5666666666666673},"M max = ",{"$f":"SUM(F92:F94)","v":1.1555555555555559},null,null,null,"Asv min. =",{"$f":"AG81","v":5.4192015628070003},"cm2/m"]
[null,null,null,null,null,null,null,null,null,"As =",{"$f":"AG84","v":5.4192015628070003},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Heel Design",null,"Bearing length, Lo","Heel length, Lh"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing 2",{"$f":"F75","v":9.4655481481481498},{"$f":"AG54","v":1.5},{"$f":"AG54-(D17+D14)/100","v":1.25}]
[null,null,null,null,null,{"$f":"IF($AD$90,\"Vert. Bars, As3      .\",\"\")","v":"Vert. Bars, As3      ."},null,"Vert. Bars, As1",12,{"$f":"$AG$86&\" (\"&FIXED(AH86,2)&\"  cm2 )\"","v":" @ 0.200 m. (5.65  cm2 )"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing min",{"$f":"F76","v":0.41445185185185096}]
[null,null,null,12,{"$f":"IF($AD$90,AL94,\"\")","v":"@0.450 m. (2.51  cm2)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing 1 @Heel =",{"$f":"AI97/AH97*(AG97-AG98)+AG98","v":7.9570320987654339}]
[null,null,null,null,null,{"$f":"IF($AD$90,\"Tranv. Bars, As4        .\",\"\")","v":"Tranv. Bars, As4        ."},null,"Tranv. Bars, As2",12,{"$f":"$AJ$91&\" (\"&FIXED(AK91,2)&\"  cm2 )\"","v":" @ 0.425 m. (2.66  cm2 )"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing Force = (B1+B2)/2*Lh =",{"$f":"(AG98+AG99)*AI97/2","v":5.2321774691358041}]
[null,null,null,null,{"$f":"IF($AD$90,AL90,\"\")","v":"Ø 12 @0.450 m. (2.51  cm2 )"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arm = B1*Lh^2/2+(B2-B1)*Lh^2/3 =",{"$f":"(AG99*AI97^2/2+(AG98-AG99)*AI97^2/3)/AG100","v":0.43729482203596692}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Force, T/m","Arm, m","Moment, T-m/m"]
[null,null,null,null,"Front Side",null,null,"Backfill Side",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,"Upward Pressure =",{"$f":"-AG100*IF(AD103,0,1)","v":-5.2321774691358041},{"$f":"AG101","v":0.43729482203596692},{"$f":"AG103*AH103","v":-2.2880041152263373}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Concrete Weight =",{"$f":"2.4*(D16*D18)/10000","v":0.9},{"$f":"D18/200","v":0.625},{"$f":"AG104*AH104","v":0.5625}]
[null,null," Heel & Toe Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Backfill Weight =",{"$f":"D27*((D11-D16)*D18)/10000","v":4.625},{"$f":"AH104","v":0.625},{"$f":"AG105*AH105","v":2.890625}]
[null,null," Heel Bars",12,{"$f":"$AG$123&\" (\"&FIXED(AH123,2)&\"  cm2 )\"","v":" @ 0.175 (6.46  cm2 )"},null,null,null,null,null,null,{"$f":"AL128","v":"Ø 12 @ 0.400"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Backfill Slope =",{"$f":"D27*D18^2*TAN(RADIANS(Slope))/20000","v":0},{"$f":"2*D18/300","v":0.83333333333333337},{"$f":"AG106*AH106","v":0}]
[null,null,"Toe Bars",12,{"$f":"$AG$156&\" (\"&FIXED(AH156,2)&\"  cm2 )\"","v":" @ 0.200 (5.65  cm2 )"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Weight =",{"$f":"D18*MAX(0,(D12-D16))*(D28-D27)/10000","v":0},{"$f":"AH104","v":0.625},{"$f":"AG107*AH107","v":0}]
[null,null," Transv. Bars",12,{"$f":"AM127","v":" @ 0.400 (5.65  cm2 )"},null,null,null,null,null,null,{"$f":"\"Ø\"&D106&$AG$123","v":"Ø12 @ 0.175"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surcharge load =",{"$f":"q*D18/100","v":0.625},{"$f":"AH104","v":0.625},0.390625]
[null,null,null,null," ( 2 layers )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V =",{"$f":"SUM(AG103:AG108)","v":0.9178225308641963},"M =",{"$f":"SUM(AI103:AI108)","v":1.5557458847736627}]
[null,null,null,null,null,null,null,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":"D16-coverb-D106/20","v":24.4},"cm"]
[null,null,null,null,null,null,{"$f":"\"Ø\"&$D$107&$AG$156","v":"Ø12 @ 0.200"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Shear =",{"$f":"AG109","v":0.9178225308641963}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Moment =",{"$f":"AI109","v":1.5557458847736627}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"0.29*SQRT('Design criteria'!$G$17)*100*AG110/1000","v":13.237983834406203},"T",{"$f":"IF(AG113>=AG111,\" OK\",\" N.G\")","v":" OK"}]
[null,null," Heel Design",null,"Neglect bearing pressure *",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr = Rbd²  = ",{"$f":"$K$8*100*AG110^2/100/1000","v":16.282627135842823},"T-m",{"$f":"IF(AG114>=AG112,\" OK\",\" N.G\")","v":" OK"}]
[null,null,null,"Force","Lever arm","Moment",null,null,null,"d =",{"$f":"AG110","v":24.4},"cm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ast Req =  M/(fs j d) = ",{"$f":"100000*AI109/('Design criteria'!$G$27*MAIN!$H$8*AG110)","v":4.3290264645250645},"cm2/m"]
[null,null,null," W, (T/m)","L, (m)","(T-m/m)",null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"AG113","v":13.237983834406203},{"$f":"\"T/m \"&AI113","v":"T/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($D$7=4000,0.0018,0.002)","v":1.8E-3},null,{"$f":"\"As S&T.= \"&FIXED(AD116,4)&\" b.t =\"","v":"As S&T.= 0.0018 b.t ="},{"$f":"AD116*100*D16","v":5.3999999999999995},"cm2/m","0.0018·b·t = ",1.8E-3]
[null,null,"Upward Pressure",{"$f":"AG103","v":-5.2321774691358041},0.43729482203596692,-2.2880041152263373,null,null,null,"MR = Rbd2 =",{"$f":"AG114","v":16.282627135842823},{"$f":"\"T-m/m \"&AI114","v":"T-m/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As min.= 14/fy bd =",{"$f":"14/$D$7*100*AG110","v":8.5400000000000009},"cm2/m","0.0020·b·t = ",2E-3]
[null,null,"Concrete Weight",0.9,0.625,0.5625,null,null,null,"As req = M/(js j d) =",{"$f":"AG115","v":4.3290264645250645},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As min.=",{"$f":"MIN(AG117,1.34*AG115)","v":5.8008954624635871},"cm2/m","0.0025·b·t = ",2.5000000000000001E-3]
[null,null,"Backfill Weight",{"$f":"AG105","v":4.625},0.625,2.890625,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Main Ø =",{"$f":"D106","v":12},"mm"]
[null,null,"Backfill Slope",{"$f":"AG106","v":0},{"$f":"AH106","v":0.83333333333333337},{"$f":"AI106","v":0},null,null,null,"As min. =",{"$f":"AG118","v":5.8008954624635871},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As1",{"$f":"3.14159*$AG$119^2/400","v":1.1309724000000001}]
[null,null,"Water Weight",{"$f":"AG107","v":0},{"$f":"AH107","v":0.625},0,null,null,null,{"$f":"AF116","v":"As S&T.= 0.0018 b.t ="},{"$f":"AG116","v":5.3999999999999995},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As req =",{"$f":"MAX(AG115,AG116,AG118)","v":5.8008954624635871}]
[null,null,"Surcharge load",{"$f":"AG108","v":0.625},0.625,0.390625,null,null,null,"As =",{"$f":"AG121","v":5.8008954624635871},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@ Min(3t,45,As min) =",{"$f":"MIN(AG120/AG121,3*D16/100,0.45)","v":0.19496514069565501},{"$f":"FLOOR(1.025*$AG122,0.025)","v":0.17500000000000002}]
[null,null,"V max = ",{"$f":"SUM(D117:D122)","v":0.9178225308641963},"M max = ",{"$f":"SUM(F117:F122)","v":1.5557458847736627},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use",{"$f":"\" @ \"&FIXED(FLOOR(1.025*$AG$122,0.025),3)","v":" @ 0.175"},{"$f":"AG120/AH122","v":6.4626994285714288}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use Ø Transv. =",{"$f":"D108","v":12},"mm"]
[null,null," Toe Design",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transv.","As1",{"$f":"3.14159*$AG124^2/400","v":1.1309724000000001}]
[null,null,null,"Force","Lever arm","Moment",null,null,null,"d =",{"$f":"AG143","v":24.4},"cm",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AF116","v":"As S&T.= 0.0018 b.t ="},{"$f":"AG116","v":5.3999999999999995},"cm2/m"]
[null,null,null," W, (T/m)","L, (m)","(T-m/m)",null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"AG146","v":13.237983834406203},{"$f":"\"T/m \"&AI146","v":"T/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"As min2 layers = ",{"$f":"AG126/2","v":2.6999999999999997},{"$f":"MIN($AG125/($AG127+0.01),3*$D$14/100,0.45)","v":0.4173329889298894},{"$f":"FLOOR(1.025*AH127,0.05)","v":0.4},{"$f":"\" @ \"&FIXED(AI127,3)","v":" @ 0.400"},{"$f":"2*AG125/AI127","v":5.6548620000000005},{"$f":"\"Ø \"&D108&$AJ$127&\" (\"&FIXED(AK127,2)&\"  cm2 )\"","v":"Ø 12 @ 0.400 (5.65  cm2 )"},{"$f":"$AJ$127&\" (\"&FIXED(AK127,2)&\"  cm2 )\"","v":" @ 0.400 (5.65  cm2 )"}]
[null,null,"Upward Pressure",{"$f":"AG138","v":9.4655451311160509E-6},{"$f":"AH138","v":5.0000005312305585E-7},{"$f":"AI138","v":4.7327730683967084E-12},null,null,null,"MR = Rbd2 =",{"$f":"AG147","v":16.282627135842823},{"$f":"\"T-m/m \"&AI147","v":"T-m/m  OK"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Straight Ld = Max(30,fy/3.5/fc^0.5",null,null,null,null,null,{"$f":"\"Ø \"&D108&$AJ$127","v":"Ø 12 @ 0.400"}]
[null,null,"Water Buoyancy",{"$f":"AG139","v":0},0,0,null,null,null,"As req = M/(js j d) =",{"$f":"AG148","v":1.3169438572329295E-11},"cm2/m"]
[null,null,"Concrete Weight",{"$f":"AG140","v":0},0,0]
[null,null,"Soil Cover @ Toe ",{"$f":"AG141","v":0},0,0,null,null,null,"As min. =",{"$f":"AG151","v":1.7647047686921257E-11},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Toe Design",null,"Bearing length, Lo","Toe length, Lt"]
[null,null,"V max = ",{"$f":"SUM(D128:D131)","v":9.4655451311160509E-6},"M max = ",{"$f":"SUM(F128:F131)","v":4.7327730683967084E-12},null,null,null,{"$f":"AF149","v":"As S&T.= 0.0018 b.t ="},{"$f":"AG149","v":5.3999999999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing 2",{"$f":"F75","v":9.4655481481481498},{"$f":"AG54","v":1.5},{"$f":"IF(D17=0,0.0001,D17)/100","v":9.9999999999999995E-7}]
[null,null,null,null,null,null,null,null,null,"As =",{"$f":"AG154","v":5.3999999999999995},"cm2/m",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing min",{"$f":"F76","v":0.41445185185185096}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing 1 @Toe =",{"$f":"(AH132-AI132)/AH132*(AG132-AG133)+AG133","v":9.4655421140839522}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bearing Force = (B1+B2)/2*Lt =",{"$f":"(AG132+AG134)*AI132/2","v":9.4655451311160509E-6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arm = B1*Toe^2/2+(B2-B1)*Toe^2/3 =",{"$f":"(AG134*AI132^2/2+(AG132-AG134)*AI132^2/3)/AG135","v":5.0000005312305585E-7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Force, T/m","Arm, m","Moment, T-m/m"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upward Pressure =",{"$f":"AG135","v":9.4655451311160509E-6},{"$f":"AG136","v":5.0000005312305585E-7},{"$f":"AG138*AH138","v":4.7327730683967084E-12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water Buoyancy =",{"$f":"(D12*D17)/10000","v":0},{"$f":"D17/200","v":0},{"$f":"AG139*AH139","v":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,"Concrete Weight =",{"$f":"-2.4*(D16*D17)/10000","v":0},{"$f":"AH139","v":0},{"$f":"AG140*AH140","v":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,"Soil Cover @ Toe =",{"$f":"-D27*(D17*D19)/10000","v":0},{"$f":"AH140","v":0},{"$f":"AG141*AH141","v":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,"V =",{"$f":"SUM(AG138:AG141)","v":9.4655451311160509E-6},"M =",{"$f":"SUM(AI138:AI141)","v":4.7327730683967084E-12}]
[null,null,null,null,null,null,null,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":"D16-coverb-D107/20","v":24.4},"cm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Shear =",{"$f":"AG142","v":9.4655451311160509E-6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Moment =",{"$f":"AI142","v":4.7327730683967084E-12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vc = 0.29*√f'c*bd =",{"$f":"0.29*SQRT('Design criteria'!$G$17)*100*AG143/1000","v":13.237983834406203},"T",{"$f":"IF(AG146>=AG144,\" OK\",\" N.G\")","v":" OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mr = Rbd²  = ",{"$f":"$K$8*100*AG143^2/100/1000","v":16.282627135842823},"T-m",{"$f":"IF(AG147>=AG145,\" OK\",\" N.G\")","v":" OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ast Req =  M/(fs j d) = ",{"$f":"100000*AI142/('Design criteria'!$G$27*MAIN!$H$8*AG143)","v":1.3169438572329295E-11},"cm2/m"]
[null,null,null,null,null,null,null,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":"AF116","v":"As S&T.= 0.0018 b.t ="},{"$f":"IF($D$7=4000,AJ149,IF($D$7=3000,AJ150,AJ151))*100*D16","v":5.3999999999999995},"cm2/m","0.0018·b·t = ",1.8E-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,10.06,null,null,null,"As min.= 14/fy bd =",{"$f":"14/$D$7*100*AG143","v":8.5400000000000009},"cm2/m","0.0020·b·t = ",2E-3]
[null,null,null,"SECTION",null,null,null,null,null,"ELEVATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.4600000000000009,null,null,null,"As min.=",{"$f":"MIN(AG150,1.34*AG148)","v":1.7647047686921257E-11},"cm2/m","0.0025·b·t = ",2.5000000000000001E-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,{"$f":"AB150/AB151","v":1.1891252955082741},null,null,null,"Use Main Ø =",{"$f":"D107","v":12},"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,"As1",{"$f":"3.14159*$AG$152^2/400","v":1.1309724000000001}]
[null,null,null,null,null,null,null,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 req =",{"$f":"MAX(AG148,AG149,AG151)","v":5.3999999999999995}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"@ Min(3t,45,As min) =",{"$f":"MIN(AG153/AG154,3*D16/100,0.45)","v":0.20943933333333337},{"$f":"FLOOR(1.025*$AG155,0.05)","v":0.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,"Use",{"$f":"\" @ \"&FIXED(FLOOR(1.025*$AG$155,0.05),3)","v":" @ 0.200"},{"$f":"AG153/AH155","v":5.6548620000000005}]

{"sheet":"Weight","index":3,"n_rows":23,"n_cols":29,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,9,1,11],[3,9,4,9],[3,10,4,10],[3,11,4,12]]}
[]
[null,null,"Project",{"$f":"'Design criteria'!D2","v":"RC. Cantilever Retaining Wall L "},null,null,null,null,null,"Cantilever Retaining Wall",null,null,null,null,null,"วิธีใช้"]
[null,null,"Owner",{"$f":"'Design criteria'!D3","v":"Advisory Group"},null,null,null,null,null,"Engineer","Wall No.","Date",null,null,null,"ป้อนค่าเฉพาะเซล สีน้ำเงิน"]
[null,null,"Location",{"$f":"'Design criteria'!D4","v":"Chiang Rai"},null,null,null,null,null,{"$f":"'Design criteria'!J4","v":"Neung Civil"},{"$f":"MAIN!I4","v":"RW02"},{"$f":"'Design criteria'!L4","v":"2021-01-12"}]
[]
[]
[null,null," APPROXIMATE WEIGHT OF REINFORCEMENT / 1 m."]
[]
[null,null,null,null,null,null,"No.","Dia","Length","Unit Wt ","Weight"]
[null,null,null,null,null,null,null,"mm.","m.","kg/m","kg"]
[null,null,null,"`",null,null,null,null,null,null,null,null,null,null,null,"Criteria",null,"Main"]
[null,null,"STEM","VERTICAL - Front Side",null,null,{"$f":"X12","v":2.2222222222222223},{"$f":"MAIN!D99","v":12},{"$f":"Z12","v":2.35},{"$f":"(3.14159*H12^2/4)*0.00785","v":0.88781333399999995},{"$f":"G12*I12*J12","v":4.6363585220000001},null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAIN!$AD$90","v":true},{"$f":"W12*(1/MAIN!AI94)","v":2.2222222222222223},{"$f":"(MAIN!D11-2*cover+12*H12/10)/100","v":2.3439999999999999},{"$f":"CEILING(Y12,0.05)","v":2.35}]
[null,null,null,"VERTICAL - Backfill Side",null,null,{"$f":"X13","v":5},{"$f":"MAIN!I98","v":12},{"$f":"Z13","v":2.35},{"$f":"(PI()*H13^2/4)*0.00785","v":0.88781408390447547},{"$f":"G13*I13*J13","v":10.431815485877587},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/MAIN!AH85","v":5},{"$f":"(MAIN!D11-2*cover+12*H13/10)/100","v":2.3439999999999999},{"$f":"CEILING(Y13,0.05)","v":2.35},null,null,{"$f":"MAIN!AI90","v":0.45}]
[null,null,null,"TRANSVERSE (Ext & Int)",null,null,{"$f":"X14","v":9.1503267973856204},{"$f":"MAIN!I100","v":12},{"$f":"Z14","v":1},{"$f":"(3.14159*H14^2/4)*0.00785","v":0.88781333399999995},{"$f":"G14*I14*J14","v":8.1237821411764699},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC15","v":9.1503267973856204},1,{"$f":"CEILING(Y14,0.05)","v":1},null,null,{"$f":"MAIN!AI91","v":0.42500000000000004}]
[null,null,null,null,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":"(MAIN!D11-MAIN!D16)/100/AC14+W12*((MAIN!D11-MAIN!D16)/100/AC13)","v":9.1503267973856204}]
[null,null," BASE","TOP (Heel)",null,null,{"$f":"X16","v":5.7142857142857135},{"$f":"MAIN!D106","v":12},{"$f":"Z16","v":1.5},{"$f":"(PI()*H16^2/4)*0.00785","v":0.88781408390447547},{"$f":"G16*I16*J16","v":7.6098350048955021},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/MAIN!AH122","v":5.7142857142857135},{"$f":"MAIN!D15/100","v":1.5},{"$f":"CEILING(Y16,0.05)","v":1.5}]
[null,null,null,"BOTTOM (Toe)",null,null,5,{"$f":"MAIN!D107","v":12},1.5,0.88781408390447547,{"$f":"G17*I17*J17","v":6.6586056292835663},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"1/MAIN!AH155","v":5},{"$f":"Y16","v":1.5},{"$f":"CEILING(Y17,0.05)","v":1.5}]
[null,null,null,"TRANSVERSE ( T & B )",null,null,7.5,{"$f":"MAIN!D108","v":12},1,0.88781408390447547,{"$f":"G18*I18*J18","v":6.6586056292835663},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*(MAIN!D15/100)/MAIN!$AI$127","v":7.5},1,{"$f":"CEILING(Y18,0.05)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"Unit price"]
[null,null," SUMMARY",null,null,null,null,null,null,"Approx total reinforcement per metre length of wall (kg)",{"$f":"SUM(K12:K14,K16:K18)","v":44.119002412516686},22.24]
[null,null,null,null,null,null,null,null,null,"Approx total concrete per metre length of wall (m3)",{"$f":"(MAIN!D35+MAIN!D36)/2.4","v":0.90000000000000013},1800]
[]
[null,null,null,null,null,null,null,null,null,"Price",{"$f":"K20*L20+K21*L21","v":2601.2066136543713},"B/m"]

{"sheet":"Notes","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"RC. Cantilever Retaining Wall Design",null,null,"By NeungCivil"]
[null,"Working Stress Design (WSD)",null,null,"9civil@gmail.com"]
[null,"Revision history  RETWALL_WSD.xlsm",null,null,"https://www.facebook.com/thanom.roj"]
[]
[null,"Date","Version","Action","Size (kB)"]
[]
[null,"2020-04-16","v.1.03","แก้ไข กรณี กำแพงรูปตัว L",596]
[null,"2020-04-15","v.1.02","ออกแบบ หน้าปกใหม่",596]
[null,"2020-04-14","v.1.01","ปรับปรุง Moment ส่วน Heel และ กราฟ R",427]
[null,"2020-04-13","v.1.0","ออกแบบ RC. Cantilever Wall Design",389]