市政给排水土方量计算表格(含公式)

27.90129.39179.718.48632.22

井号1井号2直径管长

(m)

管道类型埋深1埋深2

平均设

计埋深

基础加

深

换填

厚度

路面

厚度

平均实

际挖深

放坡系数

1:i(高:宽)

开挖方式挖土方管道体积基础体积换填体积填河砂填中砂

雨北14雨北13120048混凝土管道 2.48 2.42 2.450.180 2.7500.33不设支撑直挖351.6578.1331.390.0080.56161.56雨北13雨北12120020混凝土管道 2.42 2.42 2.420.180 2.7200.33不设支撑直挖144.9232.5613.080.0031.9767.32雨北12雨北11100025塑料管道 2.22 2.4 2.310.300 2.6100.33不设支撑直挖130.5019.6315.000.0040.5055.38雨北11雨北10100030塑料管道 2.4 2.42 2.410.300 2.7100.33不设支撑直挖162.6023.5518.000.0054.6066.45雨北10雨北9100025塑料管道 2.42 2.46 2.440.300 2.7400.33不设支撑直挖137.0019.6315.000.0047.0055.38雨北9雨北8100025塑料管道 2.46 2.51 2.490.300 2.7850.33不设支撑直挖139.2519.6315.000.0049.2555.38雨北8雨北780025塑料管道 2.31 2.36 2.340.300 2.6350.33不设支撑直挖118.5812.5613.500.0046.5845.94雨北7雨北680025塑料管道 2.36 2.41 2.390.300 2.6850.33不设支撑直挖120.8312.5613.500.0048.8345.94雨北6雨北580025塑料管道 2.41 2.46 2.440.300 2.7350.33不设支撑直挖123.0812.5613.500.0051.0845.94雨北5雨北480027塑料管道 2.46 2.51 2.490.300 2.7850.33不设支撑直挖135.3513.5614.580.0057.5949.62雨北4雨北360024塑料管道 2.31 2.34 2.330.300 2.6250.33不设支撑直挖100.80 6.7811.520.0047.0435.46雨北3雨北260026塑料管道 2.34 2.34 2.340.300 2.6400.33不设支撑直挖109.827.3512.480.0051.5838.41雨北2雨北160025塑料管道 2.34 2.28 2.310.300 2.6100.33不设支撑直挖104.407.0712.000.0048.4036.94雨北15雨北1650025塑料管道 2.22 2.19 2.210.300 2.5050.33不设支撑直挖81.41 4.919.750.0039.1627.59雨北16雨北1750025塑料管道 2.19 2.1 2.150.300 2.4450.33不设支撑直挖79.46 4.919.750.0037.2127.59雨北17雨北1850024塑料管道 2.12 2.050.300 2.3500.33不设支撑直挖73.32 4.719.360.0032.7626.49雨北18雨北1950024塑料管道2 1.91 1.960.300 2.2550.33不设支撑直挖70.36 4.719.360.0029.8026.49雨北19雨北2050024塑料管道 1.91 1.84 1.880.300 2.1750.33不设支撑直挖67.86 4.719.360.0027.3026.49雨北20雨北2150024塑料管道 1.84 1.75 1.800.300 2.0950.33不设支撑直挖65.36 4.719.360.0024.8026.49雨北21雨北2280025塑料管道 2.05 1.96 2.010.300 2.3050.33不设支撑直挖103.7312.5613.500.0031.7345.94雨北22雨北2380025塑料管道 1.96 1.91 1.940.300 2.2350.33不设支撑直挖100.5812.5613.500.0028.5845.94雨北23雨北2480025塑料管道 1.91 1.91 1.910.300 2.2100.33不设支撑直挖99.4512.5613.500.0027.4545.94雨北24雨北2580026塑料管道 1.91 1.96 1.940.300 2.2350.33不设支撑直挖104.6013.0614.040.0029.7247.78雨北25雨北26100016塑料管道 2.16 2.21 2.190.300 2.4850.33不设支撑直挖79.5212.569.600.0021.9235.44雨南2215004混凝土管道 2.74 2.73 2.740.225 3.1100.33不设支撑直挖37.6210.17 4.080.007.0816.28雨南22雨南21150012混凝土管道 2.73 2.9 2.820.225 3.1900.33不设支撑直挖115.7630.5212.250.0024.1348.85雨南21雨南20150020混凝土管道 2.9 2.75 2.830.225 3.2000.33不设支撑直挖193.5450.8720.420.0040.8281.42雨南20雨南19150030混凝土管道 2.75 2.79 2.770.225 3.1450.33不设支撑直挖285.3176.3030.630.0056.25122.14雨南19雨南18150030混凝土管道 2.79 2.72 2.760.225 3.1300.33不设支撑直挖283.9576.3030.630.0054.89122.14雨南18雨南17150038混凝土管道 2.72 2.91 2.820.225 3.1900.33不设支撑直挖362.7195.6338.390.0075.61153.08雨南17雨南16150014混凝土管道 2.91 2.64 2.780.225 3.1500.33不设支撑直挖133.3635.6114.290.0026.4657.00雨南16雨南15150045混凝土管道 2.64 2.87 2.760.225 3.1300.33不设支撑直挖425.93114.4545.950.0082.33183.20雨南15雨南14150031混凝土管道 2.87 2.84 2.860.225 3.2300.33不设支撑直挖302.7978.8531.650.0066.09126.21雨南14雨南13150027混凝土管道 2.84 2.83 2.840.225 3.2100.33不设支撑直挖262.0968.6727.570.0055.93109.92雨南13雨南12150025混凝土管道 2.83 2.82 2.830.225 3.2000.33不设支撑直挖241.9263.5925.530.0051.03101.78雨南12雨南11150025混凝土管道 2.82 2.85 2.840.225 3.2100.33不设支撑直挖242.6863.5925.530.0051.79101.78雨南11雨南10100025塑料管道 2.35 2.36 2.360.300 2.6550.33不设支撑直挖132.7519.6315.000.0042.7555.38雨南10雨南9100025塑料管道 2.36 2.4 2.380.300 2.6800.33不设支撑直挖134.0019.6315.000.0044.0055.38雨南9雨南8100025塑料管道 2.4 2.45 2.430.300 2.7250.33不设支撑直挖136.2519.6315.000.0046.2555.38

27.90

129.39

179.7

18.48

632.22

井号1井号2直径管长

(m)管道类型埋深1埋深2平均设计埋深基础加深换填厚度路面厚度平均实际挖深放坡系数

1:i(高:宽)开挖方式

挖土方管道体积基础体积换填体积填河砂填中砂雨南8雨南780025塑料管道 2.25 2.3 2.280.300 2.5750.33不设支撑直挖115.8812.5613.500.0043.8845.94雨南7雨南680025塑料管道 2.3 2.35 2.330.300 2.6250.33不设支撑直挖118.1312.5613.500.0046.1345.94雨南6雨南580025塑料管道 2.35 2.4 2.380.300 2.6750.33不设支撑直挖120.3812.5613.500.0048.3845.94雨南5雨南480025塑料管道 2.4 2.45 2.430.300 2.7250.33不设支撑直挖122.6312.5613.500.0050.6345.94雨南4雨南350025塑料管道 2.15 2.18 2.170.300 2.4650.33不设支撑直挖80.11 4.919.750.0037.8627.59雨南3雨南250025塑料管道 2.18 2.18 2.180.300 2.4800.33不设支撑直挖80.60 4.919.750.0038.3527.59雨南2雨南150025塑料管道 2.18 2.13 2.160.300 2.4550.33不设支撑直挖79.79 4.919.750.0037.5427.59雨南23雨南2450026塑料管道 2.63 2.5 2.570.300 2.8650.33不设支撑直挖96.84 5.1010.140.0052.9028.70雨南24雨南2550026塑料管道 2.19 2.1 2.150.300 2.4450.33不设支撑直挖82.64 5.1010.140.0038.7028.70雨南25雨南2660026塑料管道 2.2 2.13 2.170.300 2.4650.33不设支撑直挖102.547.3512.480.0044.3038.41雨南26雨南2760026塑料管道 2.13 2.04 2.090.300 2.3850.33不设支撑直挖99.227.3512.480.0040.9838.41雨南27雨南2860026塑料管道 2.04 1.97 2.010.300 2.3050.33不设支撑直挖95.897.3512.480.0037.6538.41雨南28雨南2980025塑料管道 1.97 1.89 1.930.300 2.2300.33不设支撑直挖100.3512.5613.500.0028.3545.94雨南29雨南3080026塑料管道 2.092 2.050.300 2.3450.33不设支撑直挖109.7513.0614.040.0034.8747.78雨南30雨南3180025塑料管道2 1.95 1.980.300 2.2750.33不设支撑直挖102.3812.5613.500.0030.3845.94雨南31雨南3280025塑料管道 1.95 1.95 1.950.300 2.2500.33不设支撑直挖101.2512.5613.500.0029.2545.94雨南32雨南3380024塑料管道 1.952 1.980.300 2.2750.33不设支撑直挖98.2812.0612.960.0029.1644.10雨南33

雨南34

100015塑料管道 2.2 2.25 2.230.300 2.5250.33不设支撑直挖75.7511.789.000.0021.7533.2326001混凝土管道7.57.57.500.3538.0880.33不设支撑直挖37.977.40 2.780.0019.558.2328001混凝土管道7.57.57.500.3838.1380.33不设支撑直挖

40.158.60 3.250.0019.468.843000

1

混凝土管道

7.5

7.5

7.50

0.413

8.188

0.33

9mIV型拉森钢板桩支护

44.82

9.89

3.76

0.00

20.39

10.78

7、综合单价根据选择的开挖方式自动计算，不用另外调整，只要确定开挖方式就行了。

8、表格“混凝土管道数据（不能删）”作为数据源不能改动或删除，土方计算表中要对这些数据引用，删除将影响土方及相关数据的计算。 9、绿色部分为需要手工输入内容的部分，黄色部分只是在塑料管道基础厚度不是30cm时才将公式中的0.3改为相应的数值。

说明：1、注意选择管材类型，否则将影响工作位的选择以及基础体积，模板，模板是混凝土管道才有，基础体积对于混凝土管道只要知道管径也是确定的 2、根据图纸输入设计标高、管底标高得出设计埋深

3、根据实际输入基础加深、换填厚度、路面厚度，其中基础加深如果为混凝土则自动计算，如为塑料管、金属管则默认为0.3m，如果实际不是0.3m,则可将公式中的0.3m改为相应值

4、开挖方式因每次设计的原则不尽相同，一般第一种为3.5m以下埋深不作建议，3.5m-5.0m采用9米III型拉森钢板桩，5.0m以上采用12米III型拉森钢板桩。第二种为2.5m-3.5m

3.5m-5.0m采用9米III型拉森钢板桩，5.0m以上采用12米III型拉森钢板桩，开挖方式通过自动筛选功能按照平均实际挖深批量选择修改开挖方式，适应不同的开挖方式。 5、挡土板、槽钢、拉森钢板桩的工程量自动统计，但要通过自动筛选功能按照开挖方式确认挡土板、槽钢、拉森钢板桩各自的量。

27.90129.39179.718.48632.22

井号1井号2直径管长

(m)

管道类型埋深1埋深2

平均设

计埋深

基础加

深

换填

厚度

路面

厚度

平均实

际挖深

放坡系数

1:i(高:宽)

开挖方式挖土方管道体积基础体积换填体积填河砂填中砂

903.43 4.09 5.4343.44

挡土板、槽钢、拉森钢板桩基础模

板

新建单价拆除单价

0.00######449397.3835974.38 0.00######766018.2656216.90 853.9892.88169105.1929496.22 1075.20######225329.0141380.75 35.3111.6045271.9623931.20 55.8013.3877693.2952316.17 83.7013.38103204.3877540.34 148.8017.84171875.12137034.75 133.2017.84158596.00122990.51 155.400.00171734.56142999.69 0.000.0010805.36914.21 0.000.0021837.221842.11 0.000.0029154.052458.44 0.000.0028361.312410.48 0.000.0026549.332300.87 0.000.0024095.602152.43 0.000.0021528.631997.15 0.000.0019112.651851.00 0.000.0017338.421743.67 0.000.0016470.181691.15 0.000.0019850.371704.55 0.000.0028474.562417.33 0.000.0028512.302419.61 0.000.0028965.302447.02 0.000.0029682.542490.41 0.000.0030437.532536.08 0.000.0031192.532581.75 0.000.0071131.364993.15 346.000.0046695.749644.31 54.320.0073605.7437529.62 74.400.00104355.3370274.17 111.600.00135226.08103716.21 148.800.00166002.45137152.53 133.200.00149172.10122893.46 177.600.00187160.97162877.30 0.000.0020396.141928.64

903.43 4.09 5.4343.44

挡土板、槽钢、拉森钢板桩基础模

板

新建单价拆除单价

0.0051.8449267.507061.57 0.0021.6020276.712927.11 0.000.0018832.132416.36 0.000.0023542.302956.72 0.000.0019854.522478.21 0.000.0020208.422499.62 0.000.0017590.002012.33 0.000.0017943.902033.74 0.000.0018297.802055.14 0.000.0020143.842242.68 0.000.0015270.561580.02 0.000.0016641.251717.63 0.000.0015812.461640.15 0.000.0012297.241271.85 0.000.0011990.531253.30 0.000.0011044.701174.96 0.000.0010578.491146.76 0.000.0010185.891123.01 0.000.009793.301099.26 0.000.0015254.241871.03 0.000.0014758.781841.06 0.000.0014581.831830.35 0.000.0015349.131914.70 0.000.0011423.401508.41 0.00 5.404891.52841.63 0.0016.2015131.182552.51 0.0027.0025313.764259.94 0.0040.5037185.836342.43 0.0040.5036971.796329.49 0.0050.7647411.037997.87 0.0018.9017386.682961.82 0.0060.7555457.699494.23 0.0041.8539678.686629.67 0.0036.4534302.015758.69 0.0033.7531642.215324.93 0.0033.7531761.125332.12 0.000.0019186.042437.77 0.000.0019382.652449.66 0.000.0019736.552471.07

903.43 4.09 5.4343.44

挡土板、槽钢、拉森钢板桩基础模

板

新建单价拆除单价

0.000.0017165.321986.64

0.000.0017519.222008.04

0.000.0017873.122029.45

0.000.0018227.022050.86

0.000.0012092.761259.48

0.000.0012169.441264.12

0.000.0012041.651256.39

0.000.0014703.041438.51

0.000.0012470.151303.43

0.000.0015496.181648.36

0.000.0014972.721616.69

0.000.0014449.261585.03

0.000.0014723.391838.92

0.000.0016158.861963.68

0.000.0015041.901858.18

0.000.0014864.951847.48

0.000.0014440.231783.86

0.000.0010898.191425.55

0.00 2.245068.34706.65

0.00 2.425226.75784.12

3.33 2.60883

4.893897.90 -3.5m采用[20a槽钢支护，

903.43 4.09 5.4343.44

挡土板、槽钢、拉森钢板桩基础模

板

新建单价拆除单价