Excel限流孔板计算软件
640.0023500.0024630.0126990.02099765goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!6667孔板前滞止压力Mpa #VALUE!#VALUE!#VALUE!#VALUE!68挠度系数φ0.6070.6060.5730.55269孔板计算厚度2mm E 4.008 6.410 3.896 3.82470孔板圆整厚度2mm E 4.0007.000 4.000 4.0007172第四块孔板孔径d(假设)mm 2.1136 3.1136 4.1136 5.113673β0.0845440.0778400.1645440.20454474C=0.61110.60600.63180.635975#VALUE!#VALUE!#VALUE!#VALUE!760.0043680.0036720.0171120.02662777goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!7879孔板前滞止压力Mpa #VALUE!#VALUE!#VALUE!#VALUE!80挠度系数φ0.5990.6010.5620.54081孔板计算厚度2mm E 3.982 6.384 3.856 3.77982孔板圆整厚度2mm E 4.0007.000 4.000 4.0008384第五块孔板孔径d(假设)mm 2.1136 3.1136 4.1136 5.113685β0.0845440.0778400.1645440.20454486C=0.61110.60600.63180.635987#VALUE!#VALUE!#VALUE!#VALUE!880.0043680.0036720.0171120.02662789goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!9091孔板前滞止压力Mpa #VALUE!#VALUE!#VALUE!#VALUE!92挠度系数φ0.5990.6010.5620.54093孔板计算厚度2mm E 3.982 6.384 3.856 3.77994孔板圆整厚度2mm E
4.0007.000 4.000 4.00095体积流量Q m3/h 质量流量w kg/s 密度r kg/m30.014583853管道内径D mm 孔板前压力P1Pa 0.014588235孔板后压力P4Pa 雷诺数ReD 粘度mPa.s 流速m/s 假设C 孔板孔径d m
d/D X1
A1=左等式右等式左等式右等式右等式
44444
F246012F245001F245001F245001F245001
PTFE PTFE PTFE304304
101010137137
liquid gas gas liquid gas
60.0030.0040.0040.0057.00
6.00214.0032
7.00100.0082.83
1.700.070.670.200.967058.0363648
2.83196415
1.00 1.00 1.00 1.00 1.4041.84375 1020.00 1.207.377.3741.84
1.000 1.000 1.000 1.0000.013
DN50DN80DN80DN80DN40
59.0088.9088.9088.9088.90
4.50 3.20 4.45 4.45 4.45
0.000.000.000.000.00
50.0082.5080.0080.0038.10
100000.00100000.00100000.00100000.00100000.00
43312.101101.4610655.563258.582475932.79
0.440.000.5012.0010.30
0.0800.0000.3000.300 1.900
540000.00101300.00600000.0012100000.0010400000.00
180000.00100000.00400000.00400000.002000000.00
11153
540000.00101300.00600000.0012100000.0010400000.00
180000.00100000.00400000.009760000.006002961.50
NA NA NA7420000.003464956.42
NA NA NA5080000.002000000.00
NA NA NA2740000.00NA
NA NA NA400000.00NA
NA NA NA NA NA
180000.00100000.00400000.00400000.002000000.00
0.0225 ~ 0.090.016 ~ 0.0640.02225 ~ 0.0890.02225 ~ 0.0890.02225 ~ 0.089
11.607149.989131.09808.615611.9145
0.23210.60590.38870.10770.3127
0.6029430.6090360.5987260.6021440.605311
0.0319650.2390220.0775910.0069370.061659
0.0325400.2387340.0774010.0069840.061930
-0.0575%0.0288%0.0190%-0.0047%-0.0272%
0.7610.1030.61312.10410.771
0.5230.2610.420-1393135.554-1393135.554
8.975 5.43712.89315.475 6.952
9.000 6.00013.00016.0007.000
6.1136
7.1136
8.1136
9.113614.5165
0.1222720.0862250.1014200.1139200.381011
0.60290.60710.59860.60240.6044
#VALUE!#VALUE!#VALUE!0.0069370.106822
0.009015#VALUE!#VALUE!0.0078190.106877
#VALUE!#VALUE!#VALUE!-0.0882%-0.0054%
0.4010.1010.4139.764 6.374
0.5830.5980.5920.2640.264
6.514 5.40210.58413.899 5.348
7.000 6.00011.00014.000 6.000
5.5500
6.5500
7.5500
8.550016.5810
0.1110000.0793940.0943750.1068750.435196
0.60290.60650.59850.60210.6050
#VALUE!#VALUE!#VALUE!0.0069370.140603
0.007429#VALUE!#VALUE!0.0068780.139879 #VALUE!#VALUE!#VALUE!0.0059%0.0725% #VALUE!#VALUE!#VALUE!7.424 3.836 0.5880.6010.5950.2640.264
7.89013.16112.700 2.286 1.088
8.00014.00013.000 3.000 2.000 6.11367.11368.11369.11369.1136 0.1222720.0862250.1014200.1139200.239202 0.60290.60710.59860.60240.6042 #VALUE!#VALUE!#VALUE!0.006937#VALUE!
0.009015#VALUE!#VALUE!0.007819#VALUE! #VALUE!#VALUE!#VALUE!-0.0882%#VALUE! #VALUE!#VALUE!#VALUE! 5.084 2.371 0.5830.5980.5920.2640.264
7.85613.13312.669 2.287 1.089
8.00014.00013.000 3.000 2.000 6.11367.11368.11369.11369.1136 0.1222720.0862250.1014200.1139200.239202 0.60290.60710.59860.60240.6042 #VALUE!#VALUE!#VALUE!0.006937#VALUE!
0.009015#VALUE!#VALUE!0.007819#VALUE! #VALUE!#VALUE!#VALUE!-0.0882%#VALUE! #VALUE!#VALUE!#VALUE! 2.744#VALUE!
0.5830.5980.5920.2640.264
7.85613.13312.669 2.286 1.088
8.00014.00013.000 3.000 2.000