填挖平衡计算报表.xls

Sheet2 Sheet1 工程名称: 工程土石方汇总表 方格标识号 设计 标高 自然 施工 高度 挖方面积 填方面积 挖方公式 挖方过程 挖方 填方公式 填方过程 填方 第一点 第二点 第三点 第四点 s*(h1+h2+h3)/3 23.8974*(6.03+4.77+5.73)/3 (a^2/4)*(h1+h2+h3+h4) (10*10/4.0)*(2.31+3.27+5.73+4.77) (b*c*h3)/6 (6.86441*5.29412*0.81)/6 (a^2-b*c/2)*((h1+h2+h4)/5) (10*10-6.86441*5.29412/2)*((1.61+0.37+0.72)/5) (a/8)*(2*a-(b+c))*(h2+h3) 10*(2*10-(4.70588+0.736842))*(0.81+1.76)/8 (a/8)*(b+c)*(h1+h4) 10*(4.70588+0.736842)*(0.72+0.14)/8 (a^2-b*c/2)*((h2+h3+h4)/5) (10*10-0.736842*3.5/2)*((1.76+2.24+0.26)/5) (b*c*h1)/6 (0.736842*3.5*0.14)/6 (10*10/4.0)*(0.26+2.24+1.71+0.21) s*(h1+h2+h3)/3+s*(h1+h2+h3)/3+s*(h1+h2+h3)/3 0.33177*(0.21+0.21+1.71)/3+50*(0.21+1.71+0.89)/3+18.7105*(0.21+0.89+0.41)/3 11.3085*(0.89+0.3+0.41)/3 s*(h1+h2+h3)/3+s*(h1+h2+h3)/3 47.7948*(6.49+3.57+4.77)/3+23.8974*(6.49+4.77+6.03)/3 (10*10/4.0)*(4.77+3.57+0.79+2.31) (6.4574*7.9558*1.44)/6 (10*10-6.4574*7.9558/2)*((2.31+0.79+0.37)/5) (10*10-2.0442*3.13559/2)*((1.44+3.04+0.81)/5) (2.0442*3.13559*0.37)/6 (10*10/4.0)*(0.81+3.04+4.5+1.76) (10*10/4.0)*(1.76+4.5+4.65+2.24) (10*10/4.0)*(2.24+4.65+3.36+1.71) (10*10/4.0)*(1.71+3.36+2.03+0.89) s*(h1+h2+h3)/3+s*(h1+h2+h3)/3+((s挖+s填)/3)*(h1+h2-h3)+(h3*s填)/3 30.019*(0.3+0.89+2.03)/3+50*(0.3+2.03+0.46)/3+((14.9606+0.0102752)/3)*(0.3+0.46-0.01)+(0.01*0.0102752)/3 (h3*s填)/3 (0.01*0.0102752)/3 (h3*s填)/3+ (0.46*11.6319)/3+ ((s挖+s填)/3)*(h1+h2-h3)+(h3*s填)/3+s*(h1+h2+h3)/3 ((25.831+11.6319)/3)*(0.99+0.01-0.46)+(0.46*11.6319)/3+6.09022*(0.01+0.99+1.05)/3 1.18227*(0.99+1.26+1.05)/3 19.6906*(6.77+5.4+6.57)/3 45.3862*(6.57+5.4+2.21)/3+50*(6.57+2.21+3.57)/3+4.41034*(6.57+3.57+6.49)/3 (3.48083*5.98985*1.18)/6 (10*10-3.48083*5.98985/2)*((3.57+2.21+0.79)/5) (10*10-4.01015*3.5426/2)*((1.18+3.8+1.44)/5) (4.01015*3.5426*0.79)/6 (10*10/4.0)*(1.44+3.8+5.89+3.04) (10*10/4.0)*(3.04+5.89+6.83+4.5) (10*10/4.0)*(4.5+6.83+6.12+4.65) (10*10/4.0)*(4.65+6.12+4.31+3.36) (10*10/4.0)*(3.36+4.31+2.13+2.03) (10*10-0.657895*2.45902/2)*((2.03+2.13+0.46)/5) (0.657895*2.45902*0.15)/6 (7.54098*3.17241*0.