方格网土方自动计算表

1、方格网标高输入表工程名称：方格长度:2020方方格格网网编编号号方方格格网网标标高高h1h2h3h41#7.016.056.298.242#5.880.27-4.14-0.313#0-0.150.73-0.914#0.810.750.73-0.155#0.810.480.290.756#0.480.610.290.037#0.61-0.33-0.520.038#0-0.12-1.450.949#0.120.911.451.9310#-0.910.73-1.46-1.9311#0.730.750.96-1.4612#0.750.290.960.5413#0.290.030.540.4614#0.

2、03-0.52-0.760.4615#0.94-1.45-1.11.0316#-0.77-1.460.960.9917#0.46-0.76-0.910.1818#1.03-1.1-2.750.6219#-1.1-2.11.29-2.7520#-2.1-0.772.451.2921#-0.770.993.082.4522#0.18-0.91-1.030.2723#0.140.15-0.070.0324#0.150.05-0.08-0.0725#0.050.620.77-0.0826#0.62-2.75-1.860.7727#-2.751.292.93-1.8628#0.70.27-0.670.7

3、729#0.27-1.03-1.16-0.6730#0.270.03-0.09031#0.03-0.07-0.18-0.0932#-0.080.770.34-0.6533#0.77-1.86-2.230.3434#-1.862.933.69-2.2335#0.77-0.67-0.80.8936#-0.650.341.12-0.4237#0.34-2.23-2.611.1238#-2.233.691.99-2.6139#0.89-0.8-0.280.440#-0.421.120.42-1.0341#1.12-2.61-2.820.4242#-2.611.991.72-2.8243#4.820.4

4、-0.051.2844#0.4-0.28-0.47-0.0545#-0.38-0.470.560.62自动计算表手动计算表方方格格网网土土方方计计算算表表工工程程名名称称：方方格格长长度度: :20方方格格网网编编号号计计算算形形式式方方格格网网标标高高土土方方量量h1h2h3h41#四方棱柱体7.016.056.298.242759.002#三角型椎体-4.14-0.315.88#VALUE!#VALUE!-4.14-0.315.88#VALUE!3#三角型椎体0.73-0.910-0.1517.97五边棱柱体0.73-0.910-0.15-69.144#三角型椎体-0.150.810.75

5、0.73-0.27五边棱柱体-0.150.810.750.73180.765#四方棱柱体0.810.480.290.75233.006#四方棱柱体0.480.610.290.03141.007#梯形棱柱体-0.33-0.520.030.61-55.10梯形棱柱体-0.33-0.520.030.6122.518#三角型椎体0.940-0.12-1.4524.65梯形棱柱体0.940-0.12-1.45-126.139#四方棱柱体0.120.911.451.93441.0010#三角型椎体0.73-1.46-1.93-0.917.22五边棱柱体0.73-1.46-1.93-0.91-318.481

6、1#三角型椎体-1.460.730.750.96-39.15五边棱柱体-1.460.730.750.96155.9412#四方棱柱体0.750.290.960.54254.0013#四方棱柱体0.290.030.540.46132.0014#梯形棱柱体-0.52-0.760.460.03-100.38梯形棱柱体-0.52-0.760.460.0310.5715#梯形棱柱体-1.45-1.11.030.94-143.20梯形棱柱体-1.45-1.11.030.9486.3716#梯形棱柱体-0.77-1.460.960.99-116.05梯形棱柱体-0.77-1.460.960.9993.521

7、7#梯形棱柱体-0.76-0.910.180.46-121.73梯形棱柱体-0.76-0.910.180.4617.3518#梯形棱柱体-1.1-2.750.621.03-256.50梯形棱柱体-1.1-2.750.621.0355.0719#三角型椎体1.29-2.75-1.1-2.110.45五边棱柱体1.29-2.75-1.1-2.1-447.0820#梯形棱柱体-2.1-0.772.451.29-123.21梯形棱柱体-2.1-0.772.451.29213.4421#三角型椎体-0.770.993.082.45-5.37五边棱柱体-0.770.993.082.45494.3222#梯

8、形棱柱体-0.91-1.030.270.18-157.84梯形棱柱体-0.91-1.030.270.188.3923#三角型椎体-0.070.030.140.15-1.04五边棱柱体-0.070.030.140.1522.7524#梯形棱柱体-0.08-0.070.150.05-7.00梯形棱柱体-0.08-0.070.150.0510.6625#三角型椎体-0.080.050.620.77-0.31五边棱柱体-0.080.050.620.77111.8626#梯形棱柱体-2.75-1.860.770.62-351.11梯形棱柱体-2.75-1.860.770.6233.1327#梯形棱柱体-

9、1.86-2.751.292.93-246.40梯形棱柱体-1.86-2.751.292.93196.4428#三角型椎体-0.670.770.70.27-14.81五边棱柱体-0.670.770.70.27116.1229#三角型椎体0.27-1.03-1.16-0.671.07五边棱柱体0.27-1.03-1.16-0.67-221.9830#三角型椎体-0.0900.270.03-4.50梯形棱柱体-0.0900.270.0318.7531#三角型椎体0.03-0.07-0.18-0.090.15五边棱柱体0.03-0.07-0.18-0.09-26.1832#梯形棱柱体-0.65-0.

10、080.770.34-27.40梯形棱柱体-0.65-0.080.770.3469.3433#梯形棱柱体-1.86-2.230.340.77-322.07梯形棱柱体-1.86-2.230.340.7723.5934#梯形棱柱体-2.23-1.862.933.69-156.44梯形棱柱体-2.23-1.862.933.69408.7935#梯形棱柱体-0.67-0.80.890.77-68.99梯形棱柱体-0.67-0.80.890.7788.0936#梯形棱柱体-0.42-0.650.341.12-49.72梯形棱柱体-0.42-0.650.341.1278.1637#梯形棱柱体-2.23-2

11、.611.120.34-379.32梯形棱柱体-2.23-2.611.120.3431.5838#梯形棱柱体-2.61-2.233.691.99-228.47梯形棱柱体-2.61-2.233.691.99299.8839#梯形棱柱体-0.8-0.280.40.89-47.80梯形棱柱体-0.8-0.280.40.8971.9140#梯形棱柱体-1.03-0.421.120.42-71.27梯形棱柱体-1.03-0.421.120.4278.3041#梯形棱柱体-2.61-2.820.421.12-426.28梯形棱柱体-2.61-2.820.421.1233.1042#梯形棱柱体-2.82-2

12、.611.991.72-322.69梯形棱柱体-2.82-2.611.991.72150.5343#三角型椎体-0.051.284.820.4-0.01五边棱柱体-0.051.284.820.4518.9144#三角型椎体0.4-0.28-0.47-0.0513.94五边棱柱体0.4-0.28-0.47-0.05-47.2745#梯形棱柱体-0.38-0.470.560.62-35.54梯形棱柱体-0.38-0.470.560.6268.66挖挖土土方方量量78047804填填土土方方量量51365136挖填方重叠266835#使使用用说说明明图图 例例bc20.0020.0018.61#VA

13、LUE!8.9016.5911.103.413.133.4116.8816.5920.0020.0020.0020.007.0218.9112.981.0920.007.8712.1320.0020.0020.006.678.9013.3311.1013.3312.076.677.9320.0020.0020.0020.0018.9112.461.097.5412.1310.337.879.678.7512.0711.257.93选用公式三角形椎体=1/6*b*c*h梯形截面棱柱体=1/8*a*(b+c)*(h1+h2)五边形截面棱柱体=1/5*S*(h2+h3+h4)四方棱柱体=1/4*a2

14、*(h1+h2+h3+h4)ah1h2h3h4abch1h2h3h4梯形截面棱柱体()五边形截面棱柱体bch1h2h3h4bc三角形椎体梯形截面棱柱体()h1h2h3h4bc零线h1h2h3h4四方棱柱体三角形椎体特例h1()12.4616.707.543.3010.3316.329.673.686.397.6113.6112.3912.394.787.6115.228.754.7811.2515.2216.7015.853.304.1514.006.366.0013.6412.316.367.6913.6412.311.887.6918.1216.3214.143.685.867.7713.

15、6112.236.399.3114.2610.695.744.155.7415.8514.2620.0015.005.0020.006.005.0014.0015.0013.131.886.8718.1214.1417.355.862.657.537.7712.4712.239.319.4710.6910.535.4513.1314.556.8717.3513.992.656.0111.357.538.6512.479.478.2410.5311.7614.215.455.7914.5513.9917.416.012.5912.4211.357.588.650.752.2219.2517.78

16、11.7617.788.242.227.609.1312.4010.87使用说明一、本计算表为全自动计算程序，只需在“标高输入表”输入方格网的全部标高，自动计算表“即可计算出每个方格的挖、填土方量并汇总。方便、快捷、准确，甚至不需要专业人员操作。二、输入说明：首先输入“方格长度”的数据，然后每行输入一个土方方格的数据。1.“方格网编号”下输入自定义的方格名称，如“1”、“2”；“”“”等。2.把土方方格网里一个方格的四个角的标高按顺时针顺序依次输入到h1:h4（需全部输入，不可空格，“0”也要输入）。3.上述1.2即完成了一个土方方格标高的输入，只需继续依次把所有方格的信息分行输入即可。三、每

17、完成一行信息的输入（即一个土方方格的信息），本表即自动选择每个方格的一对计算形式（如果是“四方棱柱体”的时候只有一个计算形式）、对标高进行重新排列、计算结果。四、其他说明：1、方格网标高（包括正负号）必须正确输入!2、b、c列是为了审核显视，如不需要，可删除该两列。3.本表理论基础：每个土方方格的地面为一平面，只有一条零线（“四方棱柱体”无零线）。对于基本满足该理论（标高值不成比例，但正、负号未错）的方格，可以进行计算。但但完完全全违违背背此此理理论论的的方方格格，请请另另行行在在本本工工作作薄薄的的“手手动动选选型型”工工作作表表里里输输入入标标高高，需需手手动动选选择择计计算算类类型型。五

18、、注意：本表已经本人对某小区公园的土方的计算进行了测试，全部正确无误。新用本表的朋友需全面验证本表各种计算形式的计算结果正确后，才可进行正式工程的计算！责任重于泰山，恕本人不敢承担，见谅。六、 郑重声明：本表最终解释权归作者本人所有。如有对本人佩服得五体投地的男士和佩服得四体投地的女士，欢迎来电来函（女士允许附艺术照与近照）。标高输入方方格格网网土土方方手手动动选选形形计计算算表表工工程程名名称称：方格长度：20方方格格网网编编号号计计算算形形式式方方格格网网标标高高土土方方量量h1h2h3h4标准三角形组五边形三角型椎体-0.170.50.020.18-1.40五边棱柱体-0.170.50.020.1852.55特例三角形组梯形三角型椎体-0.1700.020.18-5.50梯形棱柱体-0.1700.020.1815.14梯形组合梯形棱柱体-3-421-495.83梯形棱柱体-3-42187.50梯形组合梯形棱柱体-0.18-0.330.6