Excel限流孔板计算软件

1、限流孔板1序号12342编号F246002/7F246003F246009F2460103孔板材质-PTFEPTFEPTFEPTFE4材质许用应力Mpa101010105流体相态-liquidliquidliquidliquid6流体温度t60.0060.0060.0060.007体积流量vm3/h1.004.000.050.058质量流量wkg/s0.28331.130.010.019绝热指数kCp/Cv1.001.001.001.0010密度rkg/m31020.001020.001020.001020.0011粘度mPa.s1.0001.0001.0001.00012管道公称直径DN40

2、DN25DN2513管道外径Dmm32.0050.0032.0032.0014管道壁厚mm3.505.003.503.5015管道内衬mm0.000.000.000.001620管道内径Dmm25.0040.0025.0025.0017大气压P0Paa101325.00100000.00100000.00100000.0018雷诺数ReD14437.3736093.42721.87721.8719孔板前表压P1MPag0.430.430.450.4520孔板后表压PnMPag0.02500.280.3500.05021孔板前绝压P1Paa531325.00530000.00550000.005

3、50000.0022孔板后绝压PnPaa126325.00380000.00450000.00150000.0023孔板个数n111124第一块孔板前压力P1Paa531325.00530000.00550000.00550000.0025第一块孔板后压力P1Paa126325.00380000.00450000.00150000.0026第二块孔板后压力P2PaaNANANANA27第三块孔板后压力P3PaaNANANANA28第四块孔板后压力P4PaaNANANANA29第五块孔板后压力P5PaaNANANANA30第六块孔板后压力P6PaaNANANANA31末级孔板后压力P4Paa12

4、6325.00380000.00450000.00150000.0034孔口厚度mm0.0175 0.070.025 0.10.0175 0.070.0175 0.073536第第一一块块孔孔板板孔孔径径d(假设)mm4.629511.63871.60111.1794370.18520.29100.06400.047238C=0.6110470.6058600.6263260.62632639左等式0.0200910.0515830.0020220.00101140右等式0.0209660.0514790.0025690.00139441goal seek=0迭代-0.0875%0.0105%

5、-0.0547%-0.0383%4243孔板前滞止压力Mpa1.1200.8890.5790.57944挠度系数0.5510.4860.6060.61145孔板计算厚度2mmE5.4457.7633.9163.91646孔板圆整厚度2mmE5.0008.0004.0004.0004748第第二二块块孔孔板板孔孔径径d(假设)mm2.11363.11364.11365.1136490.0845440.0778400.1645440.20454450C=0.61110.60600.63180.635951左等式#VALUE!#VALUE!#VALUE!#VALUE!52右等式0.0043680.0

6、036720.0171120.02662753goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!5455孔板前滞止压力Mpa0.7150.7390.4790.17956挠度系数0.5990.6010.5620.54057孔板计算厚度2mmE4.3507.0783.5622.17958孔板圆整厚度2mmE4.0008.0004.0003.0005960第第三三块块孔孔板板孔孔径径d(假设)mm1.55002.55003.55004.5500610.0620000.0637500.1420000.18200062C=0.61120.60610.62960.63356

7、3左等式#VALUE!#VALUE!#VALUE!#VALUE!64右等式0.0023500.0024630.0126990.02099765goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!6667孔板前滞止压力Mpa#VALUE!#VALUE!#VALUE!#VALUE!68挠度系数0.6070.6060.5730.55269孔板计算厚度2mmE4.0086.4103.8963.82470孔板圆整厚度2mmE4.0007.0004.0004.0007172第第四四块块孔孔板板孔孔径径d(假设)mm2.11363.11364.11365.1136730.084

8、5440.0778400.1645440.20454474C=0.61110.60600.63180.635975左等式#VALUE!#VALUE!#VALUE!#VALUE!76右等式0.0043680.0036720.0171120.02662777goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!7879孔板前滞止压力Mpa#VALUE!#VALUE!#VALUE!#VALUE!80挠度系数0.5990.6010.5620.54081孔板计算厚度2mmE3.9826.3843.8563.77982孔板圆整厚度2mmE4.0007.0004.0004.000

9、8384第第五五块块孔孔板板孔孔径径d(假设)mm2.11363.11364.11365.1136850.0845440.0778400.1645440.20454486C=0.61110.60600.63180.635987左等式#VALUE!#VALUE!#VALUE!#VALUE!88右等式0.0043680.0036720.0171120.02662789goal seek=0迭代#VALUE!#VALUE!#VALUE!#VALUE!9091孔板前滞止压力Mpa#VALUE!#VALUE!#VALUE!#VALUE!92挠度系数0.5990.6010.5620.54093孔板计算厚度

10、2mmE3.9826.3843.8563.77994孔板圆整厚度2mmE4.0007.0004.0004.00095体积流量Qm3/h质量流量wkg/s密度rkg/m30.014583853管道内径Dmm孔板前压力P1Pa0.014588235孔板后压力P4Pa雷诺数ReD粘度mPa.s流速m/s假设C孔板孔径dmd/DX1A1=44444F246012F245001F245001F245001F245001PTFEPTFEPTFE304304101010137137liquidgasgasliquidgas60.0030.0040.0040.0057.006.00214.00327.0010

11、0.0082.831.700.070.670.200.967058.03636482.831964151.001.001.001.001.4041.843751020.001.207.377.3741.841.0001.0001.0001.0000.013DN50DN80DN80DN80DN4059.0088.9088.9088.9088.904.503.204.454.454.450.000.000.000.000.0050.0082.5080.0080.0038.10100000.00100000.00100000.00100000.00100000.0043312.101101.4610

12、655.563258.582475932.790.440.000.5012.0010.300.0800.0000.3000.3001.900540000.00101300.00600000.0012100000.0010400000.00180000.00100000.00400000.00400000.002000000.0011153540000.00101300.00600000.0012100000.0010400000.00180000.00100000.00400000.009760000.006002961.50NANANA7420000.003464956.42NANANA50

13、80000.002000000.00NANANA2740000.00NANANANA400000.00NANANANANANA180000.00100000.00400000.00400000.002000000.000.0225 0.090.016 0.0640.02225 0.0890.02225 0.0890.02225 0.08911.607149.989131.09808.615611.91450.23210.60590.38870.10770.31270.6029430.6090360.5987260.6021440.6053110.0319650.2390220.0775910.

14、0069370.0616590.0325400.2387340.0774010.0069840.061930-0.0575%0.0288%0.0190%-0.0047%-0.0272%0.7610.1030.61312.10410.7710.5230.2610.420-1393135.554-1393135.5548.9755.43712.89315.4756.9529.0006.00013.00016.0007.0006.11367.11368.11369.113614.51650.1222720.0862250.1014200.1139200.3810110.60290.60710.598

15、60.60240.6044#VALUE!#VALUE!#VALUE!0.0069370.1068220.009015#VALUE!#VALUE!0.0078190.106877#VALUE!#VALUE!#VALUE!-0.0882%-0.0054%0.4010.1010.4139.7646.3740.5830.5980.5920.2640.2646.5145.40210.58413.8995.3487.0006.00011.00014.0006.0005.55006.55007.55008.550016.58100.1110000.0793940.0943750.1068750.435196

16、0.60290.60650.59850.60210.6050#VALUE!#VALUE!#VALUE!0.0069370.1406030.007429#VALUE!#VALUE!0.0068780.139879#VALUE!#VALUE!#VALUE!0.0059%0.0725%#VALUE!#VALUE!#VALUE!7.4243.8360.5880.6010.5950.2640.2647.89013.16112.7002.2861.0888.00014.00013.0003.0002.0006.11367.11368.11369.11369.11360.1222720.0862250.10

17、14200.1139200.2392020.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.0842.3710.5830.5980.5920.2640.2647.85613.13312.6692.2871.0898.00014.00013.0003.0002.0006.11367.11368.11369.11369.11360.1222720.0862250.1014