實用管道壓降計算程序EXCEL版

輸入結(jié)束輸入數(shù)據(jù):項目單位GGGGGGFG-ngFGFG-ngPG1管線號-7001001700100270010027001007700100770010037001001介質(zhì)HCl1氣體流量kg/h63106744064063078329605102683902氣體密度kg/m31.6396.136.133.23756.1317.513.23758.113氣體粘度cp0.014260.011570.011570.011460.011570.011570.011460.0144氣體Cp/Cv-1.3341.32641.32641.31731.32641.191.31731.1565初始壓力kPa(a)808008004508008004504506kPa/100最大允許壓力降m2020202020202020管道1管道長度m1001001001001001001001002初選管徑mm401505050250200150503絕對粗糙度mm0.20.20.20.20.20.20.20.2管件Le/D145度彎頭15290度彎頭353180度彎頭754三通（分流）405三通（合流）606閘閥（全開）77截止閥（全開）3008蝶閥（全開）209止回閥（全開）13510容器入管口20其它管件輸出數(shù)據(jù)1最終計算管徑mm3002005080250200200502管道內(nèi)截面積m20.070650.03140.001960.005020.0490630.03140.03140.0019623介質(zhì)流速m/s20.577915.4049.374616.9336928.431414.9570828.057186.8066224雷諾數(shù)-41938581632928248443156767376739245290281585895197228.65-完全湍完全湍過渡湍過渡湍流動狀態(tài)流流流流完全湍流完全湍流完全湍流過渡湍流6摩擦系數(shù)-0.017830.019640.028870.025840.0186110.0196350.0196350.028987管件當(dāng)量長度m00000000管道壓降1100m管道壓降kPa9.894167.1224215.51212.5407418.3979519.1812912.6461711.006832直管段壓降kPa9.894167.1224215.51212.5407418.3979519.1812912.6461711.006833局部阻力降kPa000000004總壓降kPa9.894167.1224215.51212.5407418.3979519.1812912.6461711.006835壓降%%0.899470.89031.939010.564612.2997442.3976612.810262.4459616末端馬赫數(shù)0.048020.037190.022750.016250.0691350.0649290.066510.02721流量核算流量百米壓降(kPa)40%1.581.142.440.392.943.072.021.7350%2.471.783.820.614.604.803.162.7060%3.562.565.500.886.626.914.553.8970%4.853.497.481.209.019.406.205.2980%6.334.569.771.5711.7712.288.096.9190%8.015.7712.371.9814.9015.5410.248.74100%9.897.1215.272.4518.4019.1812.6510.79110%11.978.6218.482.9622.2623.2115.3013.06120%14.2510.2621.993.5226.4927.6218.2115.54130%16.7212.0425.814.1331.0932.4221.3718.24140%19.3913.9629.934.7936.0637.6024.7921.15制苯管線表計算\1130552083.xls\Gas_Pipe1of82020/3/313:16150% 22.26 16.03 34.36 5.50 41.40 43.16 28.45 24.28制苯 管線表計算\1130552083.xls\Gas_Pipe 2of8 2020/3/313:16輸入結(jié)束輸入數(shù)據(jù):項目單位PG-ng1管線號-7001001PS-ngPSSM-ngSMAN-ngANMMA-ng介質(zhì)1氣體流量kg/h406491473456439610258681152氣體密度kg/m33.23753.23758.113.23758.113.23758.113.23753氣體粘度cp0.011460.011460.0140.011460.0140.011460.0140.011464氣體Cp/Cv-1.31731.31731.1561.31731.1561.31731.1561.31735初始壓力kPa(a)4504504504504504504504506kPa/1002020202020202020最大允許壓力降m管道1管道長度m1001001001001001001001002初選管徑mm5025252525150100253絕對粗糙度mm0.20.20.20.20.20.20.20.2管件Le/D145度彎頭15290度彎頭353180度彎頭754三通（分流）405三通（合流）606閘閥（全開）77截止閥（全開）3008蝶閥（全開）209止回閥（全開）13510容器入管口20其它管件輸出數(shù)據(jù)1最終計算管徑mm8080508050200150402管道內(nèi)截面積m20.0050240.0050240.0019620.0050240.0019620.03140.0176620.0012563介質(zhì)流速m/s6.9336858.3853198.2552117.7875887.66181316.6736411.379287.85594雷諾數(shù)-156767189587.7239202.8176073.3222008.6942455.5989177.188808.915流動狀態(tài)-過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流6摩擦系數(shù)-0.0258380.0256790.0288830.0257380.0289180.0199620.0213390.0314197管件當(dāng)量長度m00000000管道壓降1100m管道壓降kPa2.5407373.69308116.136133.19261513.916714.5403097.5505167.9320092直管段壓降kPa2.5407373.69308116.136133.19261513.916714.5403097.5505167.9320093局部阻力降kPa000000004總壓降kPa2.5407373.69308116.136133.19261513.916714.5403097.5505167.9320095壓降%%0.5646080.8206853.5858060.709473.0926031.0089581.6778931.7626696末端馬赫數(shù)0.016250.0196770.0331960.0182640.0307310.0391640.0453120.018523流量核算流量百米壓降(kPa)40%0.390.572.540.492.190.711.191.2350%0.610.893.970.773.421.121.871.9260%0.881.295.711.114.921.612.692.7670%1.201.757.781.516.702.193.663.7680%1.572.2910.161.978.752.864.784.9190%1.982.9012.862.5011.083.626.046.21100%2.453.5815.873.0913.674.477.467.67110%2.964.3319.213.7316.555.409.039.28120%3.525.1522.864.4419.696.4310.7411.04130%4.136.0526.835.2123.117.5512.6112.96140%4.797.0131.116.0526.808.7514.6215.03制苯管線表計算\1130552083.xls\Gas_Pipe3of82020/3/313:16150% 5.50 8.05 35.72 6.94 30.77 10.05 16.79 17.25制苯 管線表計算\1130552083.xls\Gas_Pipe 4of8 2020/3/313:16輸入結(jié)束輸入數(shù)據(jù):項目單位FG-CH4LSLSLS1管線號-MMASAR-ngSAR70010017001002700100170010027001003介質(zhì)1氣體流量kg/h1001533147579699864612821081002氣體密度kg/m38.113.23758.112.278.112.372.372.373氣體粘度cp0.0140.011460.0140.01180.0140.0140.0140.0144氣體Cp/Cv-1.1561.31731.1561.32471.1561.34771.34771.34775初始壓力kPa(a)4504504504504504504504506kPa/1002020201220202020最大允許壓力降m管道1管道長度m1001001001001001001001002初選管徑mm25805020025150100253絕對粗糙度mm0.20.20.20.20.20.20.20.2管件Le/D145度彎頭15290度彎頭353180度彎頭754三通（分流）405三通（合流）606閘閥（全開）77截止閥（全開）3008蝶閥（全開）209止回閥（全開）13510容器入管口20其它管件輸出數(shù)據(jù)1最終計算管徑mm4010080200200200150402管道內(nèi)截面積m20.0012560.007850.0050240.03140.03140.03140.0176620.0012563介質(zhì)流速m/s2.72701216.7556110.0558631.0560210.759722.873813.988399.3316744雷諾數(shù)-63214.29473544.5466205.311953501247091774754.3355348.663214.295流動狀態(tài)-過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流過渡湍流6摩擦系數(shù)-0.0318190.0238090.0252110.0198940.0198840.020030.0217660.0318197管件當(dāng)量長度m00000000管道壓降1100m管道壓降kPa2.42477710.9373713.0619910.873984.7177526.2765393.4010378.2974422直管段壓降kPa2.42477710.9373713.0619910.873984.7177526.2765393.4010378.2974433局部阻力降kPa000000004總壓降kPa2.42477710.9373713.0619910.873984.7177526.2765393.4010378.2974435壓降%%0.5388392.4305272.9026642.416441.0483891.3947860.7557861.8438766末端馬赫數(shù)0.0107970.0396420.0402940.0613490.0427080.0455360.0277580.01862流量核算流量百米壓降(kPa)40%0.371.722.061.720.750.980.531.2750%0.582.693.222.681.161.540.821.9860%0.833.874.643.861.682.221.192.8570%1.135.276.315.262.283.011.613.8880%1.486.898.256.872.983.942.115.0790%1.878.7110.448.693.774.982.676.41100%2.3110.7612.8910.734.666.153.297.92110%2.8013.0215.5912.995.647.453.999.58120%3.3315.4918.5615.466.718.864.7411.40130%3.9118.1821.7818.147.8710.405.5713.38140%4.5421.0925.2621.049.1312.066.4615.52制苯管線表計算\1130552083.xls\Gas_Pipe5of82020/3/313:16150% 5.21 24.21 29.00 24.15 10.48 13.84 7.41 17.82制苯 管線表計算\1130552083.xls\Gas_Pipe 6of8 2020/3/313:16輸入結(jié)束輸入數(shù)據(jù):項目單位LSLSMS1管線號-700100470010051101介質(zhì)HCl1氣體流量kg/h20861003915632氣體密度kg/m32.372.372.371.6393氣體粘度cp0.0140.0140.0140.014264氣體Cp/Cv-1.34771.34771.34771.3345初始壓力kPa(a)450450450806kPa/10020202020最大允許壓力降m管道1管道長度m1001002001002初選管徑mm10025100403絕對粗糙度mm0.20.20.20.2管件Le/D145度彎頭15290度彎頭353180度彎頭754三通（分流）405三通（合流）606閘閥（全開）77截止閥（全開）3008蝶閥（全開）209止回閥（全開）13510容器入管口20其它管件輸出數(shù)據(jù)1最終計算