三桩承台计算公式.xls

Sheet1 钢筋量 工程量 _ AA BB cc ee Evaluate ZZ 结果 序号 计算式 总数量 结果 规格 定额编号 部位 详图 长度 数量 结果（螺纹钢） （圆钢） 搭接 圆钢 Evaluate =IF(ISERROR(X),,X) 3*3 A6 A8 A10 B6 B8 B10 C6 C8 C10 A12 B12 C12 A14 B14 C14 A16 B16 C16 A18 B18 C18 A20 B20 C20 A22 B22 C22 A25 B25 C25 级钢 KL1 三桩承台面积 0.5*（H1+2*H2)*(H2*1.155+B)-H2*H2*1.155*3/2 三桩承台垫层面积（只需基础大小参数） 0.5*（H1+0.1+2*(H2+0.1))*((H2+0.1)*1.155+B+0.231)-(H2+0.1)*(H2+0.1)*1.155*3/2 三桩承台土方不放坡（加工作边0.4） （0.5*（H1+0.4+2*(H2+0.4))*((H2+0.4)*1.155+B+0.924)-(H2+0.4)*(H2+0.4)*1.155*3/2)*H3 三桩承台土方（放坡，加工作边0.4） （0.5*（H1+0.4+2*(H2+0.4))*((H2+0.4)*1.155+B+0.924)-(H2+0.4)*(H2+0.4)*1.155*3/2)*H3+(B+0.924)*3/2*K*H3*H3+1.155*K*K*H3*H3*H3
C 稏fN,8^膲;
C Times New Rom 1.00 6.00 6.00 2.00 25.00 46.27 6.17E-03 2.00 .30 8.00 .30 .95 9.55 3.00 20.00 70.72 6.17E-03 3.00 3.00 .30 3.30 2.00 20.00 16.29 4.00 .00 .00 5.00 .00 .00 6.00 .00 .00 7.00 .00 .00 8.00 .00 .00 9.00 .00 .00 10.00 .00 .00 11.00 .00 .00 12.00 .00 .00 13.00 .00 .00 14.00 .00 .00 15.00 .00 .00 16.00 .00 .00 17.00 .00 .00 18.00 .00 .00 19.00 .00 20.00 .00 21.00 .00 22.00 .00 23.00 .00 24.00 .00 25.00 .00 26.00 .00 27.00 .00 28.00 29.00 30.00 31.00 32.00 33.00 34.00 35.00 36.00 37.00 38.00 39.00 40.00 41.00 42.00 43.00 44.00 45.00 46.00 47.00 48.00 49.00 50.00 51.00 52.00 53.00 54.00 55.00 56.00 57.00 58.00 59.00 60.00 61.00 62.00 63.00 64.00 65.00 66.00 67.00 68.00 69.00 70.00 71.00 72.00 73.00 74.00 75.00 76.00 77.00 78.00 79.00 80.00 81.00 82.00 83.00 84.00 85.00 86.00 87.00 88.00 89.00 90.00 91.00 92.00 93.00 94.00 95.00 96.00 97.00 98.00 99.00 100.00 101.00 102.00 103.00 104.00 105.00 106.00 107.00 108.00 109.00 110.00 111.00 112.00 113.00 114.00 115.00 116.00 117.00 118.00 119.00 120.00 121.00 122.00 123.00 124.00 125.00 126.00 127.00 128.00 129.00 130.00 131.00 132.00 133.00 134.00 135.00 136.00 137.00 138.00 139.00 140.00 141.00 142.00 143.00 144.00 145.00 146.00 147.00 148.00 149.00 150.00 151.00 152.00 153.00 154.00 155.00 156.00 157.00 158.00 159.00 160.00 161.00 162.00 163.00 164