excel做的建筑实用程序-基础.xls

钢钢筋筋混混凝凝土土柱柱基基础础设设计计条条件件:1地面以下:d=2m2 柱脚:1000X1000混凝土:C203荷载:N=1847.40kNMX=777.43kN.MVX=113.39kN4基础埋深:d+h=3.00m5地基承载力标准值:fk=300kPa6基底保护层:50mm有有关关参参数数:h1=0h2=0 g1=18kN/m3 g2=20kN/m3ft=1.1N/mm2fc=10N/mm2一级钢筋 fy=210N/mm2二级钢筋 fy=310N/mm2基基础础设设计计:a=1000mmb=1000mmh=1000a1=600mmb1=600mmh1=400a2=500mmb2=500mmh2=300a3=400mmb3=400mmh3=300L=4000mmB=4000mm A=L*B=16m2Wx=L*B2/6 =10.667m3Mx=V*h+M=113.4+777.4=890.8kN.mf=fk +h1*g1 (B-3)+h2*g2 (d-0.5)=300.0+0+0=300.0kPa 1.1fk=330kPa则：f=330.0kPa基基底底压压力力验验算算:G=g2*A*(d+h)=960.00kNe=Mx/(N+G)=317mm B/6=667mm且:B-3(B/2-e)=0mm B/4=1000mmOK!Ps=(N+G)/A=175.46kPa f=330kPaPsmax=(N+G)/A+Mx/Wx =258.98kPa 1.2 f=396Psmin=(N+G)/A-Mx/Wx =91.95kPaOK!冲冲切切验验算算:H01=h01=350mmAL1=(b1-H01)*b1+H01+(a+2a2+2a3)=0.9375m2FL1=Psmax*AL1 =242.8kNam1=a+a2+a3+H01=2250mmFL1/(0.6 ft*am1)=163mm H01OK!H02=h01+h2=650mmAL2=(b1+b2)-H02*(b1+b2)+H02+(a+2a3)=1.5975m2FL2=Psmax*AL2 =413.7kNam2=a+a3+H02=2050mmFL2/(0.6 ft*am2)=306mm H02OK!H03=h0=950mmAL3=(b1+b2+b3)-H03*(b1+b2+b3)+H03+a =1.8975m2FL2=Psmax*AL3 =491.4kNam3=a+h03=1950mmFL3/(0.6 ft*am3)=382mm H03OK!剪剪切切验验算算:V=(Pnmax+Ps1)*(b1-h01)*b/2=246.45kN0.07fcbh01=980 kNV 0.07fcbh01OK!板板底底配配筋筋:X:Ps1=233.92kPaPs2=213.04kPaPs3=196.34kPaM1-1=(Psmax+Ps1-2G/A)/2 *b12*(3L-2a1)/6=186.45*0.360*1.800=120.82kN.mM2-2=(Psmax+Ps2-2G/A)/2 *(b1+b2)2*3L-2(a1+a2)/6=176.01*1.210*1.633=347.86kN.mM3-3=(Psmax+Ps3-2G/A)/2 *(b1+b2+b3)2*3L-2(a1+a2+a3)/6=167.66*2.250*1.500=565.85kN.mAs1-1=M1-1/(0.9h01*fy)=1826mm2 (一级钢筋)or1237mm2 (二级钢筋)As2-2=M2-2/(0.9h02*fy)=2832mm21918mm2As3-3=M3-3/(0.9h03*fy)=3151mm22135mm2Asmax=788mm2/m534mm2/mAs实际=565mm2/m二二级级钢钢筋筋 1220012200mmmmmmmmkPamm2 (二级钢筋)