砖混结构条形基础手算电子表格xls.xls

F、G单元条基补充计算楼1.地基承载力计算（按北京地规计算）：地基计算数据：fka(kN/mm2)±0.00(m)室内外高差(m)室外绝对标高(m)基底绝对标高(m)基底相对标高(m)基础埋置深度d(m)地下水标高(m)140.0034.600.4534.1532.502.101.65基底土质ηbηdγ(kN/mm3)γ0(kN/mm3)地质剖面号地坪现状(m)地勘报告要求换填第四纪一般沉积层粘质粉土、粉质粘土0.501.7519.0020.0046、4730.36~31.63√地基承载力计算公式：fa=fka+ηb*γ*(b-3)+ηd*γ0*(d-1.5)2.条基宽度计算(取单位长计算)：N取用JCCAD数值D+L（标准值）D值取用(m)γ(kN/mm3)基础底面积计算公式(取单位长度)B=N/(fa-γD)内墙(m)外墙(m)2.101.8820.00实际布置时考虑角部、交叉部重叠影响，实际取所计算基础宽度*1.15N(标准值)kN/mN(设计值)kN/mfa(kPa)B计算(m)B实际(m)内N1296.00399.60145.252.873.30内墙内N2301.00406.35145.252.923.40内墙内N3279.00376.65145.252.703.10内墙内N4319.00430.65145.913.073.50内墙内N5250.00337.50145.252.422.80内墙内N6226.00305.10145.252.192.50内墙外N1260.00351.00145.252.412.80外墙外N2220.00297.00145.252.042.30外墙外N3270.00364.50145.252.512.90外墙外N4140.00189.00145.251.301.50外墙外N5190.00256.50145.251.762.00外墙外N682.00110.70145.250.760.90外墙N双墙10.0013.500.100.10双墙，(伸缩缝)3.基础计算3.1底板抗弯计算砼标号ft(N/mm2)fc(N/mm2)基础高H(mm)as(mm)h0(mm)b(mm)墙厚(mm)fy235(N/mm2)fy335(N/mm2)301.4314.30350.0060.00290.001000.00200.00210.00300.00B(m)Pj(kN/m)设计值L0(m)M(kN-m)αsζAs335(mm)As235(mm)μminAmin(mm)内N13.30121.091.55145.460.120.131787.532553.620.0021622.05内墙内N23.40119.511.60152.980.130.141887.202696.000.0021622.05内墙内N33.10121.501.45127.730.110.111555.662222.370.0021622.05内墙内N43.50123.041.65167.490.140.152081.982974.260.0021622.05内墙内N52.80120.541.30101.850.080.091225.001750.000.0021622.05内墙内N62.50122.041.1580.700.070.07960.981372.820.0021622.05内墙外N12.80125.361.30105.930.090.091276.491823.550.0021622.05外墙外N22.30129.131.0571.180.060.06843.961205.660.0021622.05外墙外N32.90125.691.35114.530.100.101385.971979.960.0021622.05外墙外N41.50126.000.6526.620.020.02309.41442.020.0021622.05外墙外N52.00128.250.9051.940.040.04610.51872.150.0021622.05外墙外N60.90123.000.357.530.010.0186.87124.100.0021622.05外墙N双墙0.10135.00-0.050.170.000.001.942.770.0021622.05伸缩缝3.2底板抗冲切计算冲切外力（kN）冲切抗力(kN)内N1170.1290.3满足!内墙地基承载力计算公式：fa=fka+ηb*γ*(b-3)+ηd*γ0*(d-1.5)内N2173.9290.3满足!内墙基础底面积计算公式(取单位长度)B=N/(fa-γD)内N3158.6290.3满足!内墙地基净反力设计值Pj=N/B内N4185.2290.3满足!内墙M=Pj*L02/2内N51