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

管道内径 (mm) 管道基 础类型 管壁厚 (mm) 管道基 础突出 宽度a管基宽度b 管底以下 砼厚度c1 管底以上 砼厚度c2 基础混凝 土量m3/m 模板面积 m2 150120258036080500.0410.26 200120278041480630.050.286 250120338047680790.060.318 300120408054080950.0720.35 3501204590620901100.0940.4 400120471006941001230.1180.446 450120501007501001370.1320.474 500120551108301101520.1610.524 600120651309901301820.2280.624 7001207010510501052100.2220.63 8001208012012001202400.290.72 9001209013513501352700.3680.81 100012010015015001503000.4540.9 110012011016516501653300.5490.99 120012012018018001803600.6541.08 135012013520320262034050.8271.216 150012015022522502254501.0211.35 165012016524824762484951.2371.486 180012018027027002705401.4711.62 200012020030030003006001.8161.8 220012022033033003306602.1971.98 240012023034535503457152.5072.12 260012023535337763537682.7832.242 280012025538340763838283.2512.422 300012027541343764138883.7552.602 浆浆砌砌块块石石明明渠渠经经济济指指标标计计算算表表格格 宽度 高度 长度 埋深 墙身参数渠底参数墙基参数 墙基碎 石垫层 压顶参数 实际 挖深 开挖方式 放坡 系数 挖方回填 挡土板,槽 钢,拉森桩 碎石 墙基 砼 墙顶 宽度 墙底 宽度 墙身 坡度 底厚 与墙基 距离 短底高 长底高 宽度 突出 宽度 厚度宽度 高度 墙基 钢筋 渠底 块石 块石 侧墙 压顶 砼 小木桩综合单价 52.55040.45 1.835 0.15 0.30.20.30.94.185 0.350.10.50.255.5不设支撑直挖0.75 30171227042251267175257137496518450 桂海路 渠渠箱箱经经济济指指标标计计算算表表格格 井号1 井号2 孔数 宽度 高度 长度 埋深1 埋深2 墙厚 垫层 厚度 换填 厚度 路面 厚度 实际 挖深 开挖方式 放坡 系数 挖方 50cm以 上回填 50cm以 下回填 挡土板, 槽钢,拉 森桩 垫层 碎石底板 顶板 侧墙 钢筋 底模 侧模顶模支架小木桩 搅拌桩 单价-小 木桩 单价-搅 拌桩 14314.54.50.50.10.55.6 12miii型拉森 钢板桩支护 0.75444164133331112412102312317122413 132783.63.60.350.10.54.55 放坡开挖0.75295065312960301911011011095155624234468576418001019079978889 1321593.63.60.350.10.54.55 挡土板支护0.7547027751887144762390206206223105111127247795411751366919075861825662 1323403.63.60.350.10.54.55 6m20a槽钢支 护 0.75100561658403646213383344044047622423827201020204025127784643132844138100 132603.63.60.350.10.54.55 9miii型拉森 钢板桩支护 0.75177529371216723147787884404248018036044341385860916830001 132783.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.7523073809262903019110110110951556242344685764180011846951144505 1321593.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.754702775188759162390206206223105111127247795411751366924149542333030 1323403.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.751005616584036126513383344044047622423827201020204025127784651640534988869 132603.63.60.350.10.54.55 不设支撑直挖 0.751775293712023147787884404248018036044341385709754678839 132783.63.60.350.10.54.55 放坡开挖0.75295065312960301911011011095155624234468576418001019079978889 1321593.63.60.350.10.54.55 挡土板支护0.7547027751887144762390206206223105111127247795411751366919075861825662 1323403.63.60.350.10.54.55 6m20a槽钢支 护 0.75100561658403646213383344044047622423827201020204025127784643132844138100 132603.63.60.350.10.54.55 9miii型拉森 钢板桩支护 0.75177529371216723147787884404248018036044341385860916830001 132783.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.7523073809262903019110110110951556242344685764180011846951144505 1321593.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.754702775188759162390206206223105111127247795411751366924149542333030 1323403.63.60.350.10.54.55 12miii型拉森 钢板桩支护 0.751005616584036126513383344044047622423827201020204025127784651640534988869 76.88 排水管道挖填计算表格 井段每个季度更新一次右侧单价数据 挖运填河砂填中粗砂档土板槽钢拉森桩挖方 27.90129.39179.718.48632.22903.434.09 井号1井号2直径 管长 (m) 管道类型埋深1 埋深2 平均设 计埋深 基础加 深 换填 厚度 路面 厚度 平均实 际挖深 放坡系数 1:i(高:宽) 开挖方式挖土方管道体积 基础体积换填体积填河砂填中砂 挡土板、 槽钢、拉 森钢板桩 基础模 板 污北20 污北19500587混凝土管道 3.223.183.200.1103.3650.75不设支撑直挖2832.52171.4694.510.001805.57760.980.00307.59 污北19 污北18600498混凝土管道 3.183.123.150.1303.3450.33放坡开挖4760.64208.33113.540.003268.721170.04 0.00310.75 污北18 污北17800129混凝土管道 3.123.13.110.1203.3100.33挡土板支护975.2593.3337.410.00509.72334.79853.9892.88 污北18 污北171000160混凝土管道 3.123.13.110.1503.3600.33挡土板支护1356.90180.8672.640.00609.80493.601075.20144.00 污北17 污北1640026混凝土管道 3.13.283.190.1003.3370.336m20a槽钢支护140.384.983.070.0094.3637.9735.3111.60 污北16 污北1540030混凝土管道 3.283.313.300.1003.4420.336miii型拉森钢板桩支护167.075.753.540.00113.9743.8255.8013.38 污北15 污北1440030混凝土管道 3.313.363.340.1003.4820.339miii型拉森钢板桩支护169.025.753.540.00115.9143.8283.7013.38 污北14 污北1340040混凝土管道 3.363.443.400.1003.5470.3312miii型拉森钢板桩支护 229.567.664.720.00158.7658.42148.8017.84 污北13 污北1240040混凝土管道 3.443.523.480.1003.6270.339miv型拉森钢板桩支护234.747.664.720.00163.9458.42133.2017.84 污北12 污北1140035塑料管道3.523.583.550.3003.8500.3312miv型拉森钢板桩支护202.134.4015.750.00139.1342.85155.400.00 污北11 污北1040015塑料管道3.583.613.600.3003.8950.33不设支撑直挖70.111.885.400.0048.5114.320.000.00 污北10 污北940030塑料管道3.613.663.640.3003.9350.33不设支撑直挖141.663.7710.800.0098.4628.630.000.00 污北9污北840040塑料管道3.663.623.640.3003.9400.33不设支撑直挖189.125.0214.400.00131.5238.180.000.00 污北8污北740040塑料管道3.623.453.540.3003.8350.33不设支撑直挖184.085.0214.400.00126.4838.180.000.00 污北7污北640040塑料管道3.453.143.300.3003.5950.33不设支撑直挖172.565.0214.400.00114.9638.180.000.00 污北6污北540040塑料管道3.142.82.970.3003.2700.33不设支撑直挖156.965.0214.400.0099.3638.180.000.00 污北5污北440040塑料管道2.82.462.630.3002.9300.33不设支撑直挖140.645.0214.400.0083.0438.180.000.00 污北4污北340040塑料管道2.462.162.310.3002.6100.33不设支撑直挖125.285.0214.400.0067.6838.180.000.00 污北3污北240040塑料管道2.161.992.080.3002.3750.33不设支撑直挖114.005.0214.400.0056.4038.180.000.00 污北2污北140040塑料管道1.991.931.960.3002.2600.33不设支撑直挖108.485.0214.400.0050.8838.180.000.00 污南17 污南1640029塑料管道3.253.563.410.3003.7050.33不设支撑直挖128.933.6410.440.0087.1727.680.000.00 污南16 污南1540040塑料管道3.563.543.550.3003.8500.33不设支撑直挖184.805.0214.400.00127.2038.180.000.00 污南15 污南1440040塑料管道3.543.573.560.3003.8550.33不设支撑直挖185.045.0214.400.00127.4438.180.000.00 污南14 污南1340040塑料管道3.573.663.620.3003.9150.33不设支撑直挖187.925.0214.400.00130.3238.180.000.00 污南13 污南1240040塑料管道3.663.763.710.3004.0100.33不设支撑直挖192.485.0214.400.00134.8838.180.000.00 污南12 污南1140040塑料管道3.763.863.810.3004.1100.33不设支撑直挖197.285.0214.400.00139.6838.180.000.00 污南11 污南1040040塑料管道3.863.963.910.3004.2100.33不设支撑直挖202.085.0214.400.00144.4838.180.000.00 污南10 污南940040塑料管道3.964.054.010.3004.3050.33放坡开挖451.285.0215.590.00374.6756.000.000.00 污南9污南840040塑料管道4.0544.030.3004.3250.33挡土板支护259.505.0218.000.00187.5048.98346.000.00 污南8污南740040塑料管道43.833.920.3004.2150.336m20a槽钢支护252.905.0218.000.00180.9048.9854.320.00 污南7污南640040塑料管道3.833.553.690.3003.9900.336miii型拉森钢板桩支护239.405.0218.000.00167.4048.9874.400.00 污南6污南540040塑料管道3.553.253.400.3003.7000.339miii型拉森钢板桩支护222.005.0218.000.00150.0048.98111.600.00 污南5污南440040塑料管道3.252.953.100.3003.4000.3312miii型拉森钢板桩支护 204.005.0218.000.00132.0048.98148.800.00 污南4污南340040塑料管道2.952.672.810.3003.1100.339miv型拉森钢板桩支护186.605.0218.000.00114.6048.98133.200.00 污南3污南240040塑料管道2.672.52.590.3002.8850.3312miv型拉森钢板桩支护173.105.0218.000.00101.1048.98177.600.00 排水管道挖填计算表格 井段每个季度更新一次右侧单价数据 挖运填河砂填中粗砂档土板槽钢拉森桩挖方 27.90129.39179.718.48632.22903.434.09 井号1井号2直径 管长 (m) 管道类型埋深1 埋深2 平均设 计埋深 基础加 深 换填 厚度 路面 厚度 平均实 际挖深 放坡系数 1:i(高:宽) 开挖方式挖土方管道体积 基础体积换填体积填河砂填中砂 挡土板、 槽钢、拉 森钢板桩 基础模 板 污南2污南140040塑料管道2.52.462.480.3002.7800.33不设支撑直挖133.445.0214.400.0075.8438.180.000.00 雨北14 雨北13 120048混凝土管道 2.482.422.450.1802.7500.33不设支撑直挖351.6578.1331.390.0080.56161.560.0051.84 雨北13 雨北12 120020混凝土管道 2.422.422.420.1802.7200.33不设支撑直挖144.9232.5613.080.0031.9767.320.0021.60 雨北12 雨北11 100025塑料管道2.222.42.310.3002.6100.33不设支撑直挖130.5019.6315.000.0040.5055.380.000.00 雨北11 雨北10 100030塑料管道2.42.422.410.3002.7100.33不设支撑直挖162.6023.5518.000.0054.6066.450.000.00 雨北10 雨北9100025塑料管道2.422.462.440.3002.7400.33不设支撑直挖137.0019.6315.000.0047.0055.380.000.00 雨北9雨北8100025塑料管道2.462.512.490.3002.7850.33不设支撑直挖139.2519.6315.000.0049.2555.380.000.00 雨北8雨北780025塑料管道2.312.362.340.3002.6350.33不设支撑直挖118.5812.5613.500.0046.5845.940.000.00 雨北7雨北680025塑料管道2.362.412.390.3002.6850.33不设支撑直挖120.8312.5613.500.0048.8345.940.000.00 雨北6雨北580025塑料管道2.412.462.440.3002.7350.33不设支撑直挖123.0812.5613.500.0051.0845.940.000.00 雨北5雨北480027塑料管道2.462.512.490.3002.7850.33不设支撑直挖135.3513.5614.580.0057.5949.620.000.00 雨北4雨北360024塑料管道2.312.342.330.3002.6250.33不设支撑直挖100.806.7811.520.0047.0435.460.000.00 雨北3雨北260026塑料管道2.342.342.340.3002.6400.33不设支撑直挖109.827.3512.480.0051.5838.410.000.00 雨北2雨北160025塑料管道2.342.282.310.3002.6100.33不设支撑直挖104.407.0712.000.0048.4036.940.000.00 雨北15 雨北16 50025塑料管道2.222.192.210.3002.5050.33不设支撑直挖81.414.919.750.0039.1627.590.000.00 雨北16 雨北17 50025塑料管道2.192.12.150.3002.4450.33不设支撑直挖79.464.919.750.0037.2127.590.000.00 雨北17 雨北18 50024塑料管道2.122.050.3002.3500.33不设支撑直挖73.324.719.360.0032.7626.490.000.00 雨北18 雨北19 50024塑料管道21.911.960.3002.2550.33不设支撑直挖70.364.719.360.0029.8026.490.000.00 雨北19 雨北20 50024塑料管道1.911.841.880.3002.1750.33不设支撑直挖67.864.719.360.0027.3026.490.000.00 雨北20 雨北21 50024塑料管道1.841.751.800.3002.0950.33不设支撑直挖65.364.719.360.0024.8026.490.000.00 雨北21 雨北22 80025塑料管道2.051.962.010.3002.3050.33不设支撑直挖103.7312.5613.500.0031.7345.940.000.00 雨北22 雨北23 80025塑料管道1.961.911.940.3002.2350.33不设支撑直挖100.5812.5613.500.0028.5845.940.000.00 雨北23 雨北24 80025塑料管道1.911.911.910.3002.2100.33不设支撑直挖99.4512.5613.500.0027.4545.940.000.00 雨北24 雨北25 80026塑料管道1.911.961.940.3002.2350.33不设支撑直挖104.6013.0614.040.0029.7247.780.000.00 雨北25 雨北26 100016塑料管道2.162.212.190.3002.4850.33不设支撑直挖79.5212.569.600.0021.9235.440.000.00 雨南22 15004混凝土管道 2.742.732.740.2253.1100.33不设支撑直挖37.6210.174.080.007.0816.280.005.40 雨南22 雨南21 150012混凝土管道 2.732.92.820.2253.1900.33不设支撑直挖115.7630.5212.250.0024.1348.850.0016.20 雨南21 雨南20 150020混凝土管道 2.92.752.830.2253.2000.33不设支撑直挖193.5450.8720.420.0040.8281.420.0027.00 雨南20 雨南19 150030混凝土管道 2.752.792.770.2253.1450.33不设支撑直挖285.3176.3030.630.0056.25122.140.0040.50 雨南19 雨南18 150030混凝土管道 2.792.722.760.2253.1300.33不设支撑直挖283.9576.3030.630.0054.89122.140.0040.50 雨南18 雨南17 150038混凝土管道 2.722.912.820.2253.1900.33不设支撑直挖362.7195.6338.390.0075.61153.080.0050.76 雨南17 雨南16 150014混凝土管道 2.912.642.780.2253.1500.33不设支撑直挖133.3635.6114.290.0026.4657.000.0018.90 雨南16 雨南15 150045混凝土管道 2.642.872.760.2253.1300.33不设支撑直挖425.93114.4545.950.0082.33183.200.0060.75 雨南15 雨南14 150031混凝土管道 2.872.842.860.2253.2300.33不设支撑直挖302.7978.8531.650.0066.09126.210.0041.85 雨南14 雨南13 150027混凝土管道 2.842.832.840.2253.2100.33不设支撑直挖262.0968.6727.570.0055.93109.920.0036.45 雨南13 雨南12 150025混凝土管道 2.832.822.830.2253.2000.33不设支撑直挖241.9263.5925.530.0051.03101.780.0033.75 雨南12 雨南11 150025混凝土管道 2.822.852.840.2253.2100.33不设支撑直挖242.6863.5925.530.0051.79101.780.0033.75 排水管道挖填计算表格 井段每个季度更新一次右侧单价数据 挖运填河砂填中粗砂档土板槽钢拉森桩挖方 27.90129.39179.718.48632.22903.434.09 井号1井号2直径 管长 (m) 管道类型埋深1 埋深2 平均设 计埋深 基础加 深 换填 厚度 路面 厚度 平均实 际挖深 放坡系数 1:i(高:宽) 开挖方式挖土方管道体积 基础体积换填体积填河砂填中砂 挡土板、 槽钢、拉 森钢板桩 基础模 板 雨南11 雨南10 100025塑料管道2.352.362.360.3002.6550.33不设支撑直挖132.7519.6315.000.0042.7555.380.000.00 雨南10 雨南9100025塑料管道2.362.42.380.3002.6800.33不设支撑直挖134.0019.6315.000.0044.0055.380.000.00 雨南9雨南8100025塑料管道2.42.452.430.3002.7250.33不设支撑直挖136.2519.6315.000.0046.2555.380.000.00 雨南8雨南780025塑料管道2.252.32.280.3002.5750.33不设支撑直挖115.8812.5613.500.0043.8845.940.000.00 雨南7雨南680025塑料管道2.32.352.330.3002.6250.33不设支撑直挖118.1312.5613.500.0046.1345.940.000.00 雨南6雨南580025塑料管道2.352.42.380.3002.6750.33不设支撑直挖120.3812.5613.500.0048.3845.940.000.00 雨南5雨南480025塑料管道2.42.452.430.3002.7250.33不设支撑直挖122.6312.5613.500.0050.6345.940.000.00 雨南4雨南350025塑料管道2.152.182.170.3002.4650.33不设支撑直挖80.114.919.750.0037.8627.590.000.00 雨南3雨南250025塑料管道2.182.182.180.3002.4800.33不设支撑直挖80.604.919.750.0038.3527.590.000.00 雨南2雨南150025塑料管道2.182.132.160.3002.4550.33不设支撑直挖79.794.919.750.0037.5427.590.000.00 雨南23 雨南24 50026塑料管道2.632.52.570.3002.8650.33不设支撑直挖96.845.1010.140.0052.9028.700.000.00 雨南24 雨南25 50026塑料管道2.192.12.150.3002.4450.33不设支撑直挖82.645.1010.140.0038.7028.700.000.00 雨南25 雨南26 60026塑料管道2.22.132.170.3002.4650.33不设支撑直挖102.547.3512.480.0044.3038.410.000.00 雨南26 雨南27 60026塑料管道2.132.042.090.3002.3850.33不设支撑直挖99.227.3512.480.0040.9838.410.000.00 雨南27 雨南28 60026塑料管道2.041.972.010.3002.3050.33不设支撑直挖95.897.3512.480.0037.6538.410.000.00 雨南28 雨南29 80025塑料管道1.971.891.930.3002.2300.33不设支撑直挖100.3512.5613.500.0028.3545.940.000.00 雨南29 雨南30 80026塑料管道2.0922.050.3002.3450.33不设支撑直挖109.7513.0614.040.0034.8747.780.000.00 雨南30 雨南31 80025塑料管道21.951.980.3002.2750.33不设支撑直挖102.3812.5613.500.0030.3845.940.000.00 雨南31 雨南32 80025塑料管道1.951.951.950.3002.2500.33不设支撑直挖101.2512.5613.500.0029.2545.940.000.00 雨南32 雨南33 80024塑料管道1.9521.980.3002.2750.33不设支撑直挖98.2812.0612.960.0029.1644.100.000.00 雨南33 雨南34 100015塑料管道2.22.252.230.3002.5250.33不设支撑直挖75.7511.789.000.0021.7533.230.000.00 26001混凝土管道 7.57.57.500.3538.0880.33不设支撑直挖37.977.402.780.0019.558.230.002.24 28001混凝土管道 7.57.57.500.3838.1380.33不设支撑直挖40.158.603.250.0019.468.840.002.42 30001混凝土管道 7.57.57.500.4138.1880.339miv型拉森钢板桩支护44.829.893.760.0020.3910.783.332.60 说明：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采用20a槽钢支护， 3.5m-5.0m采用9米iii型拉森钢板桩，5.0m以上采用12米iii型拉森钢板桩，开挖方式通过自动筛选功能按照平均实际挖深批量选择修改开挖方式，适应不同的开挖方式。 5、挡土板、槽钢、拉森钢板桩的工程量自动统计，但要通过自动筛选功能按照开挖方式确认挡土板、槽钢、拉森钢板桩各自的量。 7、综合单价根据选择的开挖方式自动计算，不用另外调整，只要确定开挖方式就行了。 8、表格“混凝土管道数据（不能删）”作为数据源不能改动或删除，土方计算表中要对这些数据引用，删除将影响土方及相关数据的计算。 9、绿色部分为需要手工输入内容的部分，黄色部分只是在塑料管道基础厚度不是30cm时才将公式中的0.3改为相应的数值。 排水管道挖填计算表格 井段每个季度更新一次右侧单价数据 挖运填河砂填中粗砂档土板槽钢拉森桩挖方 27.90129.39179.718.48632.22903.434.09 井号1井号2直径 管长 (m) 管道类型埋深1 埋深2 平均设 计埋深 基础加 深 换填 厚度 路面 厚度 平均实 际挖深 放坡系数 1:i(高:宽) 开挖方式挖土方管道体积 基础体积换填体积填河砂填中砂 挡土板、 槽钢、拉 森钢板桩 基础模 板 排水管道挖填计算表格 井段每个季度更新一次右侧单价数据 挖运填河砂填中粗砂档土板槽钢拉森桩挖方 27.90129.39179.718.48632.22903.434.09 井号1井号2直径 管长 (m) 管道类型埋深1 埋深2 平均设 计埋深 基础加 深 换填 厚度 路面 厚度 平均实 际挖深 放坡系数 1:i(高:宽) 开挖方式挖土方管道体积 基础体积换填体积填河砂填中砂 挡土板、 槽钢、拉 森钢板桩 基础模 板 排水管道挖填计算表格 原土回填借土回填 5.4343.44 新建单价拆除单价 449397.3835974.38 766018.2656216.90 169105.1929496.22 225329.0141380.75 45271.9623931.20 77693.2952316.17 103204.3877540.34 171875.12137034.75 158596.00122990.51 171734.56142999.69 10805.36914.21 21837.221842.11 29154.052458.44 28361.312410.48 26549.332300.87 24095.602152.43 21528.631997.15 19112.651851.00 17338.421743.67 16470.181691.15 19850.371704.55 28474.562417.33 28512.302419.61 28965.302447.02 29682.542490.41 30437.532536.08 31192.532581.75 71131.364993.15 46695.749644.31 73605.7437529.62 104355.3370274.17 135226.08103716.21 166002.45137152.53 149172.10122893.46 187160.97162877.30 排水管道挖填计算表格 原土回填借土回填 5.4343.44 新建单价拆除单价 20396.141928.64 49267.507061.57 20276.712927.11 18832.132416.36 23542.302956.72 19854.522478.21 20208.422499.62 17590.002012.33 17943.902033.74 18297.802055.14 20143.842242.68 15270.561580.02 16641.251717.63 15812.461640.15 12297.241271.85 11990.531253.30 11044.701174.96 10578.491146.76 10185.891123.01 9793.301099.26 15254.241871.03 14758.781841.06 14581.831830.35 15349.131914.70 11423.401508.41 4891.52841.63 15131.182552.51 25313.764259.94 37185.836342.43 36971.796329.49 47411.037997.87 17386.682961.82 55457.699494.23 39678.686629.67 34302.015758.69 31642.215324.93 31761.125332.12 排水管道挖填计算表格 原土回填借土回填 5.4343.44 新建单价拆除单价 19186.042437.77 19382.652449.66 19736.552471.07 17165.321986.64 17519.222008.04 17873.122029.45 18227.022050.86 12092.761259.48 12169.441264.12 12041.651256.39 14703.041438.51 12470.151303.43 15496.181648.36 14972.721616.69 14449.261585.03 14723.391838.92 16158.861963.68 15041.901858.18 14864.951847.48 14440.231783.86 10898.191425.55 5068.34706.65 5226.75784.12 8834.893897.90 3、根据实际输入基础加深、换填厚度、路面厚度，其中基础加深如果为混凝土则自动计算，如为塑料管、金属管则默认为0.3m，如果实际不是0.3m,则可将公式中的0.3m改为相应值 4、开挖方式因每次设计的原则不尽相同，一般第一种为3.5m以下埋深不作建议，3.5m-5.0m采用9米iii型拉森钢板桩，5.0m以上采用12米iii型拉森钢板桩。第二种为2.5m-3.5m采用20a槽钢支护， 3.5m-5.0m采用9米iii型拉森钢板桩，5.0m以上采用12米iii型拉森钢板桩，开挖方式通过自动筛选功能按照平均实际挖深批量选择修改开挖方式，适应不同的开挖方式。 5、挡土板、槽钢、拉森钢板桩的工程量自动统计，但要通过自动筛选功能按照开挖方式确认挡土板、槽钢、拉森钢板桩各自的量。 7、综合单价根据选择的开挖方式自动计算，不用另外调整，只要确定开挖方式就行了。 8、表格“混凝土管道数据（不能删）”作为数据源不能改动或删除，土方计算表中要对这些数据引用，删除将影响土方及相关数据的计算。 9、绿色部分为需要手工输入内容的部分，黄色部分只是在塑料管道基础厚度不是30cm时才将公式中的0.3改为相应的数值。 双管埋设两管平均值 横断面参数管径1管径2 井号1井号2管径1管径2管道长度管中间距工作位 沟槽底 宽 起点深 度 止点深 度 起点深 度 止点深 度 平均埋 深 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 24001500100.003.000.505.953.713.714.584.584.58 垫层厚 度 换填厚 度 路面厚 度 实际挖深 放坡系 数 开挖方式挖土方基础体积换填体积填河砂填中砂 0.300.500.704.680.756m20a槽钢支护2784.60178.50297.5065.561614.26 0.300.500.704.680.756m20a槽钢支护2784.60178.50297.5065.561614.26 0.300.500.704.680.756m20a槽钢支护2784.60178.50297.5065.561614.26 0.300.500.704.680.756m20a槽钢支护2784.60178.50297.5065.561614.26 0.300.500.704.680.75