搜索
数量井深井壁厚度管内底至井垫层底厚度设计管内底标高设计窨井面标高（设计路面标高）自然地面标高中心距离管径D壁厚基础度数管道截面面积基础净距工作面沟槽底宽度坡度管外底至管垫层底厚度座（m）（m）（m）（m）（m）（m）（m）(mm)(mm)度(m2)mmmm%mmAB（非管道面）C（管道面）D=F-ERJEFHLMNDUP=PI()*(M/2+N)*(M/2+N)/1000/1000Q=L-（B1/1000+B2/1000）/2-R1-R2WW=IF(M500,300,200)根据具体判断W=（M+N*2+WW*2）/1000T==IF(K1.5,0,25%)CA6.7006.5007.2007.2007.2007.5007.5007.8007.6007.800窨井大小内净长(mm)*宽（mm)井号接口BY1BY2BY3BY40.5500.5500.5500.5500.550井备注落底式雨水井苏S01-2004-145落底式雨水井苏S01-2004-146落底式雨水井苏S01-2004-147落底式雨水井苏S01-2004-148落底式雨水井苏S01-2004-14801111100080080080080010008008008008002.7002.3002.1001.9001.8000.3700.2400.2400.2400.2409.2009.5009.3009.4009.4008.9009.0009.0008.0008.00015.00020.00020.00010.00060040060040039253925180度120度240度360度0.3610.1590.3610.15913.49018.72018.7208.7203002003002001.2780.8501.2780.85025%25%0%0%90808080管顶至砂面的厚度（360度情况下）砂垫层厚度每米砂石含量回填砂石数量挖土深度开挖土方(清单量）开挖土方（定额量）路面结构厚度或回填面至窨井面高度回填面至管垫层底深度回填扣窨井体积回填土方（清单量）回填土方（定额量）mmmmm3/mm3（m）m3m3（m）（m）m3m3m3CBCC=IF(DU360,(M/2+N)*(1-COS(PI()/180*DU/2))+CA,(M+N*2)+CA+CB)U=(W+CC/1000*T)*CC/1000-(P*DU/360-SIN(PI()/180*DU)*(M/2+N)/1000*(M/2+N)/1000/2)V=U*QK=（H1+H2-（E3+E3））/2+CA/1000+N/1000X=K*W*LZ=K*（W+K*T）*1.025*LSG=（F1-E1+F2-E2）/2+CA/1000+N/1000AF=（B/1000+R*2)*（C/1000+R*2)*（D+J-S)SP=G*W*L-(U+P)*Q-AFZA=G*（W+G*T）*1.025*L-(U+P)*Q-AF100100100100429.0192.5588.5630.00.4140.1420.4620.3765.5822.6548.6423.2832.2291.9051.1190.40542.73032.38528.6023.44362.89651.79329.3173.5290.5000.5000.5000.5002.1291.8051.4691.3056.0883.6863.3593.11324.27321.36718.7883.31042.71638.83119.7273.587数量井深井壁厚度管内底至井垫层底厚度设计管内底标高设计窨井面标高（设计路面标高）自然地面标高中心距离管径D壁厚基础度数管道截面面积基础净距工作面沟槽底宽度坡度管外底至管垫层底厚度座（m）（m）（m）（m）（m）（m）（m）(mm)(mm)度(m2)mmmm%mmAB（非管道面）C（管道面）D=F-ERJEFHLMNDUP=PI()*(M/2+N)*(M/2+N)/1000/1000Q=L-（B1/1000+B2/1000）/2-R1-R2WW=IF(M500,300,200)根据具体判断W=（M+N*2+WW*2）/1000T==IF(K1.5,0,25%)CA6.7006.5007.2007.2007.5007.5007.6007.8007.6007.800窨井大小内净长(mm)*宽（mm)井号接口BY1BY2BY3BY40.2890.2890.2750.2890.275井备注01111100080080080080010008008008008002.7002.3001.8001.8001.8000.3700.2400.2400.2400.2409.2009.5009.3009.4009.4008.9009.0009.0008.0008.00015.00020.00020.00010.00060040060040039253925180度120度240度360度0.3610.1590.3610.15913.49018.72018.7208.7203002003002001.2780.8501.2780.85025%25%0%0%90808080管顶至砂面的厚度（360度情况下）砂垫层厚度每米砂石含量回填砂石数量挖土深度开挖土方(清单量）开挖土方（定额量）路面结构厚度或回填面至窨井面高度回填面至管垫层底深度回填扣窨井体积回填土方（清单量）回填土方（定额量）mmmmm3/mm3（m）m3m3（m）（m）m3m3m3CBCC=IF(DU360,(M/2+N)*(1-COS(PI()/180*DU/2))+CA,(M+N*2)+CA+CB)U=(W+CC/1000*T)*CC/1000-(P*DU/360-SIN(PI()/180*DU)*(M/2+N)/1000*(M/2+N)/1000/2)V=U*QK=（H1+H2-（E3+E3））/2+CA/1000+N/1000X=K*W*LZ=K*（W+K*T）*1.025*LSG=（F1-E1+F2-E2）/2+CA/1000+N/1000AF=（B/1000+R*2)*（C/1000+R*2)*（D+J-S)SP=G*W*L-(U+P)*Q-AFZA=G*（W+G*T）*1.025*L-(U+P)*Q-AF100100100100429.0192.5588.5630.00.4140.1420.4620.3765.5822.6548.6423.2832.2291.7551.0690.40542.73029.83527.3243.44362.89646.36628.0073.5290.5000.5000.5000.5002.1291.6551.4191.3055.4793.0022.5922.59224.88219.50218.2773.83143.32534.24319.1844.108数量井深井壁厚度管内底至井垫层底厚度设计管内底标高设计窨井面标高（设计路面标高）自然地面标高中心距离管径D壁厚基础度数管道截面面积基础净距砼基础宽度垫层宽度垫层厚度工作面座（m）（m）（m）（m）（m）（m）（m）(mm)(mm)度(m2)mmmmmmmmmAB（非管道面）C（管道面）D=F-ERJEFHLMNDUP=PI()*(M/2+N)*(M/2+N)/1000/1000Q=L-（B1/1000+B2/1000）/2-R1-R2BBBD=BB+100*2CRWW=IF(BB500,IF(BB1000,600,500),400)5.0005.0005.0005.0006.1006.4007.6007.800窨井大小内净长(mm)*宽（mm)井号接口BY1BY2BY30.5500.5500.5500.550井备注落底式雨水井苏S01-2004-145落底式雨水井苏S01-2004-145落底式雨水井苏S01-2004-145落底式雨水井苏S01-2004-145011110001000800800100010008008003.0003.0003.4001.7000.3700.3700.3700.2408.0008.0009.5009.3007.0007.0009.0008.00010.00020.00010.000600500400504035120度120度120度0.3850.2640.1738.26018.3608.59015005755751700775775100100100600500500沟槽底宽度坡度管外底至管基础底厚度管顶至砼基础面的厚度（360度情况下）砼基础厚度每米垫层含量每米砼基础含量砼基础量砼基础模板垫层量砼垫层模板挖土深度开挖土方(清单量）开挖土方（定额量）路面结构厚度或回填面至窨井面高度回填面至管垫层底深度回填扣窨井体积回填土方（清单量）m%mmmmmmm3/mm3/mm3m2m3m2（m）m3m3（m）（m）m3m3W=（BB+WW*2）/1000T==IF(K1.5,0,25%)CACBCC=IF(DU360,(M/2+N)*(1-COS(PI()/180*DU/2))+CA,(M+N*2)+CA+CB)UD=BD/1000*CR/1000U=BB/1000*CC/1000-(P*DU/360-sin(PI()/180*DU)*(M/2+N)/1000*(M/2+N)/1000/2)V=U*QCC/1000*Q*2VA=UD*QCR/1000*Q*2K=（H1+H2-（E3+E3））/2+CA/1000+N/1000+CR/1000X=BD/1000*K*LZ=K*（W+K*T）*1.025*LSG=（F1-E1+F2-E2）/2+CA/1000+CR/1000+N/1000AF=（B/1000+R*2)*（C/1000+R*2)*（D+J-S)SP=G*BD/1000*L-(U+P+UD)*Q-AF2.7001.5751.57525%25%25%100100100100100100275.0245.0217.50.1700.0780.0780.3370.0890.0912.7861.6380.7834.5438.9963.7371.4041.4230.6661.6523.6721.7182.2502.6901.73538.25041.69513.44675.241123.93835.7231.5001.5001.5001.7501.9401.1356.2076.0093.52016.17516.1502.338回填土方（定额量）m3ZA=G*（W+G*T）*1.025*L-(U+P+UD)*Q-AF42.70468.00615.166分类统计函数样本SUMIF(F1:F3,=500,G1:G3)SUMIF($F$1:$F$3,500,$G$1:$G$3)