{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["钢混柱基"],"not_rendered":{"images":2,"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"钢混柱基","index":0,"n_rows":88,"n_cols":10,"rows_kept":88,"flags":["formulas_cached_only"]}
[{"$nulls":4},"钢筋混凝土柱基础设计"]
[]
["条件:",1,"地面以下:","d=",2,"m"]
[null,2,"  柱脚:","1000X1000"]
[null,null,"混凝土:","C20"]
[null,3,"荷载:","N=",{"v":1847.4,"d":"1847.40"},"kN"]
[{"$nulls":3},"MX=",777.43,"kN.M"]
[{"$nulls":3},"VX=",113.39,"kN"]
[null,4,"基础埋深:","d+h=",{"v":3,"d":"3.00"},"m"]
[null,5,"地基承载力标准值:fk=",null,300,"kPa"]
[null,6,"基底保护层:",null,50,"mm"]
[]
["有关参数:","h1=",0,null,"h2=",0]
[null," g1=",18,"kN/m3"," g2=",20,"kN/m3"]
[null,"ft=",1.1,"N/mm2","fc=",10,"N/mm2"]
[null,"一级钢筋 fy=",210,"N/mm2"]
[null,"二级钢筋 fy=",310,"N/mm2"]
[]
["基础设计:","a=",1000,"mm","b=",1000,"mm","h=",1000,"mm"]
[null,"a1=",600,"mm","b1=",600,"mm","h1=",400,"mm"]
[null,"a2=",500,"mm","b2=",500,"mm","h2=",300,"mm"]
[null,"a3=",400,"mm","b3=",400,"mm","h3=",300,"mm"]
[null,"L=",4000,"mm","B=",4000,"mm "]
[]
[null,"A=","L * B =",16,"m2"]
[null,"Wx=","       L * B2 / 6    =",null,{"v":10.666666666666666,"d":"10.667"},"m3"]
[null,"Mx=","V * h","+","M"]
[null,"=",{"v":113.39,"d":"113.4"},"+",{"v":777.43,"d":"777.4"}]
[null,"=",{"v":890.8199999999999,"d":"890.8"},"kN.m"]
[null,"f=","fk  +","h1 * g1   (","B - 3 ) + ","h2 * g2   (","d - 0.5 )"]
[null,"=",{"v":300,"d":"300.0"},"+",0,"+",0]
[null,"=",{"v":300,"d":"300.0"},"kPa <","1.1fk=",330,"kPa"]
[null,"则：  f=",{"v":330,"d":"330.0"},"kPa"]
[]
["基底压力验算:"]
[null,"G=","g2 * A * ","(d +h)  =",{"v":960,"d":"960.00"},"kN"]
[null,"e=","  Mx / ( N +G )   =",null,{"v":317.3113913229322,"d":"317"},"mm  <","B / 6 =",{"v":666.6666666666666,"d":"667"},"mm"]
[null,"且:","  B - 3( B/2 - e )  =",null,0,"mm  <","B / 4 =",1000,"mm"]
[{"$nulls":8},"OK!"]
[null,"Ps=","(N+G) / A","=",{"v":175.4625,"d":"175.46"},"kPa  <","f=",330,"kPa"]
[null,"Psmax=","  (N+G) / A + Mx / Wx    =",null,null,{"v":258.976875,"d":"258.98"},"kPa  <","1.2 f =",396,"kPa"]
[null,"Psmin=","  (N+G) / A - Mx / Wx    =",null,null,{"v":91.948125,"d":"91.95"},"kPa",null,"OK!"]
[]
["冲切验算:"]
[null,"H01=","h01=",350,"mm"]
[null,"AL1=","  (b1 - H01) * [b1 + H01 +(a+2a2+2a3)] "]
[null,"=",0.9375,"m2"]
[null,"FL1=","    Psmax * AL1   =",null,{"v":242.79082031250002,"d":"242.8"},"kN"]
[null,"am1=","  a + a2 + a3 + H01 =",null,2250,"mm"]
[null,null,"FL1 / ( 0.6 ft * am1 ) =",{"v":163.49550189393938,"d":"163"},"mm  <","H01","OK!"]
[]
[null,"H02=","h01 + h2=",650,"mm"]
[null,"AL2=","  [(b1+b2) - H02] * [(b1+b2) + H02 +(a+2a3) ] "]
[null,"=",1.5975,"m2"]
[null,"FL2=","    Psmax * AL2   =",null,{"v":413.7155578125,"d":"413.7"},"kN"]
[null,"am2=","     a + a3 + H02 =",null,2050,"mm"]
[null,null,"FL2 / ( 0.6 ft * am2 ) =",{"v":305.7764654933481,"d":"306"},"mm  <","H02","OK!"]
[]
[null,"H03=","h0=",950,"mm"]
[null,"AL3=","  [(b1+b2+b3) - H03] * [(b1+b2+b3) + H03 +a ] "]
[null,"=",1.8975,"m2"]
[null,"FL2=","    Psmax * AL3   =",null,{"v":491.4086203125,"d":"491.4"},"kN"]
[null,"am3=","a + h03 =",1950,"mm"]
[null,null,"FL3 / ( 0.6 ft * am3 ) =",{"v":381.8248798076923,"d":"382"},"mm  <","H03","OK!"]
[]
["剪切验算:"]
[null,"V=","(Pnmax+Ps1)*(b1-h01)*b/2=",null,null,{"v":246.44971875,"d":"246.45"},"kN"]
[null,null,"0.07fcbh01=",980.0000000000001,"kN"]
[null,"V<","0.07fcbh01","OK!"]
[]
["板底配筋:"]
["X:","  Ps1=",{"v":233.9225625,"d":"233.92"},"kPa"]
[null,"Ps2=",{"v":213.04396875,"d":"213.04"},"kPa"]
[null,"Ps3=",{"v":196.34109375,"d":"196.34"},"kPa"]
[null,"M1-1=","[( Psmax + Ps1 - 2G/A ) / 2]    *",null,null,"b12 ","*","(3L - 2a1) / 6 "]
[null,"=",{"v":186.44971875,"d":"186.45"},"*",{"v":0.36,"d":"0.360"},"*",{"v":1.8,"d":"1.800"}]
[null,"=",{"v":120.81941775,"d":"120.82"},"kN.m"]
[null,"M2-2=","[( Psmax + Ps2 - 2G/A ) / 2]    *",null,null,"(b1+b2)2 ","*","[3L - 2(a1+a2)] / 6 "]
[null,"=",{"v":176.01042187500002,"d":"176.01"},"*",{"v":1.21,"d":"1.210"},"*",{"v":1.6333333333333333,"d":"1.633"}]
[null,"=",{"v":347.855263765625,"d":"347.86"},"kN.m"]
[null,"M3-3=","[( Psmax + Ps3 - 2G/A ) / 2]    *",null,null," (b1+b2+b3)2 ","*","[3L - 2(a1+a2+a3)] / 6 "]
[null,"=",{"v":167.658984375,"d":"167.66"},"*",{"v":2.25,"d":"2.250"},"*",{"v":1.5,"d":"1.500"}]
[null,"=",{"v":565.849072265625,"d":"565.85"},"kN.m"]
[null,"As1-1=","M1-1 / ( 0.9h01 * fy )  =",null,{"v":1826.446224489796,"d":"1826"},"mm2  (一级钢筋)  or",null,{"v":1237.2700230414746,"d":"1237"},"mm2  (二级钢筋)"]
[null,"As2-2=","M2-2 / ( 0.9h02 * fy )  =",null,{"v":2831.544678596866,"d":"2832"},"mm2",null,{"v":1918.1431693720706,"d":"1918"},"mm2"]
[null,"As3-3=","M3-3 / ( 0.9h03 * fy )  =",null,{"v":3151.4846687030076,"d":"3151"},"mm2",null,{"v":2134.876711056876,"d":"2135"},"mm2"]
[null,null,"Asmax","=",{"v":787.8711671757519,"d":"788"},"mm2/m",null,{"v":533.719177764219,"d":"534"},"mm2/m"]
[null,null,"As实际","=","565","mm2/m","二级钢筋 12@200"]