-市政管道沟槽土方计算表(EXCEL表格)

1、管道沟槽开挖土方计算井号路面标高 管内底标高管径 增量H 挖土深 基槽底宽 边坡 断面积 平均断面积管长挖土方Y15.6182.57310000.3622.7072.3750.338.858.5930257.75Y25.5242.60310000.3622.5832.3750.338.348.4840339.12Y35.6332.64310000.3622.6522.3750.338.628.7740350.92Y45.7472.68310000.3622.7262.3750.338.938.1600.00Y45.7472.8838000.3422.5062.1250.337.407.1445

2、321.30Y55.6542.9288000.3422.3682.1250.336.886.4145288.56Y65.4382.9738000.3422.1072.1250.335.944.1200.00Y65.4383.3734000.1651.5310.332.302.104084.14Y75.3133.4534000.1651.32510.331.903.6100.00Y95.5823.1456000.3252.0621.90.335.325.4641.5226.76Y105.5653.0416000.3252.1491.90.335.615.5640222.43Y115.4372.9

3、416000.3252.1211.90.335.515.4940219.79Y125.3252.8416000.3252.1091.90.335.476.8300.00Y125.3252.44110000.3622.5462.3750.338.198.6445388.89Y135.4832.37810000.3622.7672.3750.339.109.8045441.22Y145.7482.31510000.3623.0952.3750.3310.5111.4042478.92Y156.0822.25710000.3623.4872.3750.3312.2914.0100.00Y156.08

4、21.55710000.3624.1872.3750.3315.7313.6212163.46出水口一5.21.54410000.3623.3182.3750.3311.5112.6300.00出水口二5.21.3112000.3983.5882.650.3313.7616.4912197.92Y16-26.2281.31612000.3984.612.650.3319.2316.8000.00Y16-26.2282.21612000.3983.712.650.3314.3714.5121.3309.05Y16-16.3022.23712000.3983.7632.650.3314.6413.

5、5600.00Y16-16.3022.43710000.3623.5272.3750.3312.4812.1230363.57Y166.1912.48210000.3623.3712.3750.3311.7611.1238422.50Y175.9652.53910000.3623.0882.3750.3310.489.6840387.23Y185.6522.59910000.3622.7152.3750.338.888.2340329.39Y195.3742.63910000.3622.3972.3750.337.597.5431.3235.93Y205.3792.6710000.3622.3

6、712.3750.337.496.7900.00Y205.3792.878000.3422.1512.1250.336.106.2543.7273.18Y215.5092.9148000.3422.2372.1250.336.416.2145279.48Y225.4452.9598000.3422.1282.1250.336.024.1800.00Y225.4453.3594000.1651.55110.332.342.113573.77Y235.2713.4294000.1651.30710.331.871.7100.00Y235.2713.5293000.1581.20.90.331.56

7、1.403041.87Y245.1653.6193000.1581.0040.90.331.241.0700.00Y255.4484.1213000.1580.7850.90.330.911.743052.28Y265.4324.0318000.3421.0432.1250.332.583.8100.00Y265.4323.2318000.3421.8432.1250.335.044.8745.65222.47Y275.2873.1858000.3421.7442.1250.334.714.6050230.12Y285.1713.1358000.3421.6782.1250.334.495.1

8、345230.75Y295.4583.0458000.3422.0552.1250.335.766.6244.2292.47Y305.8412.9578000.3422.5262.1250.337.477.8329.8233.21Y30-15.9642.8978000.3422.7092.1250.338.188.9800.00Y30-15.9642.69710000.3622.9292.3750.339.7910.6340425.19Y30-26.2962.64910000.3623.3092.3750.3311.4714.1800.00Y30-26.2961.54910000.3624.4

9、092.3750.3316.8914.219127.9213.5600.00出水口三5.21.53810000.3623.3242.3750.3311.5411.6300.00出水口四5.21.510000.3623.3622.3750.3311.7114.3211157.51Y316.2711.51710000.3624.4162.3750.3316.9215.4000.00Y316.2712.11710000.3623.8162.3750.3313.8712.6543543.84Y325.8192.18210000.3623.2992.3750.3311.4310.3150515.65Y3

10、35.3852.25610000.3622.7912.3750.339.208.4200.00Y335.3852.4568000.3422.5712.1250.337.646.9448333.32Y345.0922.5428000.3422.1922.1250.336.244.6645209.67Y355.1983.6238000.3421.2172.1250.333.072.3200.00Y355.1983.5234000.1651.1410.331.571.603047.86Y365.2883.5834000.1651.1710.331.62合计10319.40支管沟槽土方量另计，F列中的

11、0.7值表示为路面结构层厚度。不同的路面结构需进行调整。14.219127.92管管道道沟沟槽槽开开挖挖土土方方计计算算井号路面标高管内底标高管径 增量H 挖土深基槽底宽回填厚度边坡 断面积平均断面积管长挖土方回填部分WJ15.555-0.0574000.281.61.2垫层底层中层 顶层0.252.56垫层底层中层顶层0.30.50.20.22.4623.658.099.0317.417.798.26WJ25.441-0.014000.281.51.20.252.361.180.000.000.000.000.00WJ30.000.000.000.000.000.000.00WJ40.000

12、.000.000.000.000.000.00WJ50.000.000.000.000.000.000.00WJ60.000.000.000.000.000.000.00WJ70.000.000.000.000.000.000.00WJ80.000.000.000.000.000.000.00WJ90.000.000.000.000.000.000.00WJ100.000.000.000.000.000.000.00WJ110.000.000.000.000.000.000.00WJ120.000.000.000.000.000.000.00WJ130.000.000.000.000.000.

13、000.00WJ140.000.000.000.000.000.000.00WJ150.000.000.000.000.000.000.00WJ160.000.000.000.000.000.000.00WJ170.000.000.000.000.000.000.00WJ180.000.000.000.000.000.000.00WJ190.000.000.000.000.000.000.00WJ200.000.000.000.000.000.000.00WJ210.000.000.000.000.000.000.00WJ220.000.000.000.000.000.000.00WJ230.

14、000.000.000.000.000.000.00WJ240.000.000.000.000.000.000.00WJ250.000.000.000.000.000.000.00WJ260.000.000.000.000.000.000.00WJ270.000.000.000.000.000.000.00WJ280.000.000.000.000.000.000.00WJ290.000.000.000.000.000.000.00WJ300.000.000.000.000.000.000.00WJ310.000.000.000.000.000.000.00WJ320.000.000.000.

15、000.000.000.00WJ330.000.000.000.000.000.000.00WJ340.000.000.000.000.000.000.00WJ350.000.000.000.000.000.000.00WJ170.00WJ360.000.000.000.000.000.000.00WJ370.000.000.000.000.000.000.00WJ380.000.000.000.000.000.000.00WJ390.000.000.000.000.000.000.00WJ400.000.000.000.000.000.000.00WJ410.000.0000.000.000.000.00WJ420.000.000.000.000.000.000.00WJ430.000.000.000.000.000.000.00WJ440.000.000.000.000.000.000.0