化工工艺设计计算EXCEL表.xls

1、名称数据单位名称数据单位管径流速:3.1415926:3.1415926输入u:15m/s输入d:100mm输入Vs:1000m3/h输入Vs:40m3/h计算d=153.6mm计算u=1.41m/s流量管道材料重量PI3.1415926外径：600mm输入u:60m/s壁厚：8mm输入d:300mm长度：2000m计算Vs：15268.14m3/h密度：7.94t/m3重量：239.465TCS密度：7.85t/m3SS密度：7.94t/m3热量计算:工况条件:输入数据输出数据冷介质Ws1:10.00Kg/hQ冷=1604KJ/ht1:50.00Q冷=90KJ/hC冷:4.01 KJ/KgQ

2、冷=1504KJ/ht2:10.00Ws1=10Kg/hh1:10.00J/KgWs1=10Kg/hh2:1.00J/KgWs1=Kg/hr冷:10.00J/Kg热介质Ws2:11.10Kg/sQ热=1395.27KJ/hT1:100.00Q热=222KJ/hC热:4.19 KJ/KgQ热=1384.17KJ/hT2:70.00Ws2=11.1Kg/hH1:1.00J/KgWs2=11.1Kg/hH2:21.00J/KgWs2=Kg/hr热:1.00J/Kg关风机排量计算管道热伸长量计算G=0.06VnYrKL=L(t2-t1)cm输入：L：计算管长m V=：管道线胀系数cm/(m)n=t2：

3、管内介质温度Y=t1：管道安装温度r=输入：K=t1=0G=0.06VnYrKt2=240G=0t/h=13.18V：关风机容积，升/转L=100n：关风机转速，转/分计算结果：Y：关风机容积效率L=31.632cm颗粒状物料，Y=0.8粉状物料，Y=0.50.6r：物料密度，t/m3K：修正系数，0.70.8蒸发量计算进料量:10.00T/h已知X进(w/w):40.0%X出(w/w):70.0%蒸发量4.29T/h出料量:5.71T/h蒸发量:10.00T/h已知X进(w/w):40.0%X出(w/w):70.0%进料量23.33T/h出料量:13.33T/h出料量:15.00T/h已知X

4、进(w/w):35.0%X出(w/w):70.0%蒸发量:15.00T/h进料量:30.00T/h出料量:15.00T/h已知10112XXXFW101XXFW101XXWFWFFXX2210X出(w/w):70.0%蒸发量:15.00T/hX进(w/w):35.0%泵轴功率计算输入:Q:50m3/hH:50m:1150kg/m3:0.7Ne=11.19kwNe22K=1.2522Ne55K=1.1555NeK=1.00输入K:1.25P=13.98kw1023600 QHNeKNPe已知WFFXX2210显热法Ws*C*(t2-t1)无相变焓差法Ws*(h2-h1)无要求潜热法Ws*C*(t

5、2-t1)+W*r有相变显热法焓差法潜热法显热法Ws*C*(t2-t1)无相变焓差法Ws*(h2-h1)无要求潜热法Ws*C*(t2-t1)+W*r有相变显热法焓差法潜热法线胀系数:10-4cm/(m)TQ235A20#10012.2011.1615012.6011.6415812.6611.7220013.0012.1222013.0912.2523013.1412.3224013.1812.3825013.2312.4526013.2712.5227013.3212.5928013.3612.6529013.4112.7230013.4512.7831012.8932012.9933013

6、.1034013.2035013.31饱和水蒸汽表(按温度排列)温度绝对压力蒸汽比容蒸汽密度液体焓蒸汽焓汽化热kPam3/kgkg/m3kJ/kgkJ/kgkJ/kg00.61206.50.00480.002491.32491.350.87147.10.006820.942500.92480.0101.23106.40.009441.872510.52468.6151.7177.90.012862.812520.62457.8202.3357.80.017283.742530.12446.3253.1743.40.0230104.682538.62433.9304.2532.930.03041

7、25.602549.52423.7355.6225.250.0396146.552559.12412.6407.3719.550.0511167.472568.72401.1459.5815.280.0654188.422577.92389.55014.9812.0540.0830209.342587.62378.15515.749.5890.1043230.292596.82366.56019.927.6870.1301251.212606.32355.16525.016.2090.1611272.162615.62343.47031.165.0520.1979293.082624.4233

8、1.27538.504.1390.2416314.032629.72315.78047.403.4140.2929334.942642.42307.38557.902.8320.3531355.902651.22295.39070.102.3650.4229376.812660.02283.19584.501.9850.5039397.772668.82271.0100101.301.6750.5970418.682677.22258.4105120.801.4210.7036439.642685.12245.5110143.301.2120.8254460.972693.52232.4115

9、170.001.0380.9635481.512702.52221.0120198.600.8931.1199503.672708.92205.2125232.100.77151.2960523.382716.52193.1130270.200.66931.4940546.382723.92177.6135313.000.58311.7150565.252731.22166.0140361.400.50961.9620589.082737.82148.7145415.600.44692.2380607.122744.62137.5150476.100.39332.5430632.212750.

10、72118.5160618.100.30753.2520675.752762.92087.1170792.400.24314.1130719.292773.32054.01801003.000.19445.1450763.252782.62019.31901255.000.15686.3780807.632790.11982.52001554.000.12767.8400852.012795.51943.52101917.000.10459.5690897.232799.31902.12202320.000.086211.6000942.452801.01858.52302797.000.07

11、15513.9800988.502800.11811.62403347.000.0596716.76001034.562796.81762.22503976.000.0499820.01001081.452790.11708.62604693.000.0419923.82001128.762780.91652.12705503.000.0353828.27001176.912760.31591.42806220.000.0298833.47001225.482752.01526.52907442.000.0252539.60001274.462732.31457.83008591.000.02

12、13146.93001325.542708.01382.53109876.000.0179955.59001378.712680.01301.3320 11300.000.0151665.95001436.072648.21212.1330 12880.000.0127378.53001446.782610.51113.7340 14510.000.0106493.98001562.932568.61005.7350 16530.000.00884113.20001632.202516.7880.5饱和水蒸汽表(按温度排列)温度绝对压力蒸汽比容蒸汽密度液体焓蒸汽焓汽化热kPam3/kgkg/m

13、3kJ/kgkJ/kgkJ/kg饱和水蒸汽表(按压力排列，SI单位)绝对压力温度蒸汽比容蒸汽密度液体焓蒸汽焓汽化热kPam3/kgkg/m3kJ/kgkJ/kgkJ/kg1.0E+006.3129.370000.0077326.482503.12476.81.5E+0012.588.260000.0113352.262515.32463.02.0E+0017.067.290000.0148671.212524.22452.92.5E+0020.954.470000.0183687.452531.82444.33.0E+0023.545.520000.0217998.382536.82438.4

14、3.5E+0026.139.450000.02523109.302541.82432.54.0E+0028.734.880000.02867120.232546.82426.64.5E+0030.833.060000.03205129.002550.92421.95.0E+0032.428.270000.03537135.692554.02418.36.0E+0035.623.810000.04200149.062560.12411.07.0E+0038.820.560000.04864162.442566.32403.88.0E+0041.318.130000.05514172.732571

15、.02398.29.0E+0043.316.240000.06156181.162574.82393.61.0E+0145.314.710000.06798189.592578.52388.91.5E+0153.510.040000.09956224.032594.02370.02.0E+0160.17.650000.13068251.512606.42354.93.0E+0166.55.240000.19093288.772622.42333.74.0E+0175.04.000000.24975315.932634.12312.25.0E+0181.23.250000.30799339.80

16、2644.32304.56.0E+0185.62.740000.36514358.212652.12393.97.0E+0189.92.370000.42229376.612659.82234.48.0E+0193.22.090000.47807390.082665.32275.39.0E+0196.41.870000.53384403.492670.82267.41.0E+0299.61.700000.58961416.902670.32259.51.2E+02104.51.430000.69869437.512684.32246.81.4E+02109.21.240000.80758457

17、.672692.12234.41.6E+02113.01.210000.82981473.882698.12224.21.8E+02116.60.988001.02090489.322703.72214.32.0E+02120.20.887001.12730493.712709.22204.62.5E+02127.20.719001.39040534.392719.72185.43.0E+02133.30.606001.65010560.382728.52168.13.5E+02138.80.524001.90740583.762736.12152.34.0E+02143.40.463002.

18、16180603.612742.12138.54.5E+02147.70.414002.41520622.422747.82125.45.0E+02151.70.375002.66730639.592752.82113.26.0E+02158.70.316003.16860670.222761.42091.17.0E+02164.70.273003.66570696.272767.82071.58.0E+02170.40.240004.16140720.962773.72052.79.0E+02175.10.215004.65260741.822778.12036.21.0E+03179.90

19、.194005.14320762.682782.52019.71.1E+03180.20.177005.63390780.342785.52005.11.2E+03187.80.166006.12410797.922788.51990.61.3E+03191.50.151006.61410814.252790.91976.71.4E+03194.80.141007.10380829.062792.41963.71.5E+03198.20.132007.59350843.862794.51950.71.6E+03201.30.124008.08140857.772796.01938.21.7E+

20、03204.10.117008.56740870.582797.11926.51.8E+03206.90.110009.05330883.392798.11914.81.9E+03209.80.105009.53920896.212799.21903.02.0E+03212.20.0997010.03380907.322799.71892.43.0E+03233.70.0666015.007501005.402798.91793.54.0E+03250.30.0498020.096901082.902789.81706.85.0E+03263.80.0394025.366301145.9027

21、76.21629.26.0E+03275.40.0324030.849401203.202759.51556.37.0E+03285.70.0273036.574401263.202740.81487.68.0E+03294.80.0235042.576801299.202720.51403.79.0E+03303.20.0205048.894501343.502699.11356.61.0E+04310.90.0180055.540701384.002677.11293.11.2E+04324.50.0142070.307501463.402631.21167.71.4E+04336.50.

22、0115087.302001567.902583.21043.41.6E+04347.20.00927107.801001615.802531.1915.41.8E+04356.90.00744134.481301699.802466.0766.12.0E+04365.60.00566176.596101817.802364.2544.9饱和水蒸汽表(按压力排列，SI单位)绝对压力温度蒸汽比容蒸汽密度液体焓蒸汽焓汽化热kPam3/kgkg/m3kJ/kgkJ/kgkJ/kg流体名称流速（m/s)流体名称流速（m/s)饱和蒸汽（主管）3040 水及粘度相似液体(0.100.29,glass)0.

23、52.0饱和蒸汽（支管）2030 水及粘度相似液体(0.98MPa,glass)0.53.0低压蒸汽（3.0高压乏气80100 蒸汽冷凝水0.51.5氧气(00.05MPa,glass)510 冷凝水(自流)0.20.5氧气(0.050.59MPa,glass)78 过热水2氧气(0.59098MPa,glass)46 海水,微碱水(0.59MPa,glass)1.52.5氧气(0.981.96MPa,glass)45 油及粘度大的液体0.52.0氧气(1.962.94MPa,glass)34粘度50mPas液体(管道25以下)0.50.9氮气(4.99.8MPa,abs)25粘度50mPas

24、液体(管道2550)0.71.0氢气8.0粘度50mPas液体(管道50100)1.01.6压缩空气(0.100.20MPa,glass)1015粘度100mPas液体(管道25以下)0.30.6压缩气体(真空)510粘度100mPas液体(管道2550)0.50.7压缩气体(0.10.2MPa,glass)812粘度100mPas液体(管道50100)0.71.0压缩气体(0.10.59MPa,glass)1020粘度1000mPas液体(管道25以下)0.10.2压缩气体(0.590.98MPa,glass)1015粘度1000mPas液体(管道2550)0.160.25压缩气体(0.98

25、1.96MPa,glass)810粘度1000mPas液体(管道50100)0.250.35压缩气体(1.962.94MPa,glass)36粘度1000mPas液体(管道100200)0.350.55压缩气体(2.9424.5MPa,glass)0.53.0 离心泵(吸入口)1.02.0煤气810 离心泵(排出口)1.52.5半水煤气(0.100.15MPa)1015 往复式真空泵(吸入口)1316烟道气(烟道内)3.06.0 油封式真空泵(吸入口)1013烟道气(管道内)3.04.0 空气压缩机(吸入口)1015工业烟囱(自然通风)2.08.0 空气压缩机(排出口)1520车间通风换气(主

26、管)4.515 通风机(吸入口)1015车间通风换气(支管)2.08.0 通风机(排出口)1520风管距风机(最远处)1.04.0 齿轮泵(吸入口)1.0风管距风机(最近处)812 齿轮泵(排出口)1.02.0废气(低压)2030 往复泵(水类液体)吸入口0.71.0废气(高压)80100 往复泵(水类液体)排出口1.02.0化工设备排气管2025 旋风分离器(入气)1525自来水(主管,0.29MPa,glass)1.53.5 旋风分离器(出气)4.015自来水(支管,0.29MPa,glass)1.01.5 工业供水(0.78MPa,glass)1.53.5易燃易爆液体1水的重要物理性质温

27、度外压密度焓比热导热系数粘度运动粘度V膨胀系数表面张力kPakg/m3kJ/kgkJ/kgW/mKcP10-5m2/s10-3/mN/m01.013999.90.004.2120.5511.7890.1789-0.06375.60101.013999.742.044.1910.5751.3050.13060.07074.10201.013998.283.904.1830.5991.0050.10060.18272.70301.013995.7125.804.1740.6180.8010.08050.32171.20401.013992.2167.504.1740.6340.6530.06590

28、.38769.60501.013988.1209.304.1740.6480.5490.05560.44967.70601.013983.2251.104.1780.6590.4700.04780.51166.20701.013977.8293.004.1870.6680.4060.04150.57064.30801.013971.8334.904.1950.6750.3550.03650.63262.60901.013965.3377.004.2080.6800.3150.03260.69560.701001.013958.4419.104.2200.6830.2830.02950.7525

29、8.801101.433951.0461.304.2230.6850.2590.02720.80856.901201.986943.1503.704.2500.6860.2370.02520.64154.801302.702934.8546.404.2660.6860.2180.02330.91952.801403.624926.1589.104.2870.6850.2010.02170.97250.701504.761917.0632.204.3120.6840.1860.02031.03048.601606.181907.4675.304.3460.6830.1730.01911.0704

30、6.601707.924897.3719.304.3860.6790.1630.01811.13045.3018010.030886.9763.304.4170.6750.1530.01731.19042.3019012.550876.0807.604.4590.6700.1440.01651.26040.0020015.540863.0852.404.5050.6630.1360.01581.33037.7021019.070852.8897.604.5550.6550.1300.01531.41035.4022023.200840.3943.704.6140.6450.1240.01481

31、.48033.1023027.980827.3990.204.6810.6370.1200.01451.59031.0024033.470813.61038.004.7560.6280.1150.01411.68028.5025039.770799.01086.004.8440.6180.1100.13701.81026.2026046.930784.01135.004.9490.6040.1060.01351.97023.8027055.030767.91185.005.0700.5900.1020.01332.16021.5028064.160750.71237.005.2290.5750

32、.0980.01312.37019.1029074.420732.31290.005.4850.5580.0940.01292.62016.9030085.810712.51345.005.7360.5400.0910.01282.92014.4031098.760691.11402.006.0710.5230.0880.01283.29012.10320 113.000667.11462.006.5730.5060.0850.01283.8209.81330 128.700640.21526.007.2700.4840.0810.01274.3307.67340 149.100610.115

33、95.008.1600.4570.0770.01275.3405.67350 165.300574.41671.009.5000.4300.0730.01266.6803.81水的重要物理性质温度外压密度焓比热导热系数粘度运动粘度V膨胀系数表面张力kPakg/m3kJ/kgkJ/kgW/mKcP10-5m2/s10-3/mN/m一些搅拌锅夹套传热系数(实测值)过程材料物料载热体K(W/m2K)冷却精制 钢粗硝基甲酸,5%NaOH冷却水326冷却结晶 钢硝基甲酸,钾盐,水冷却水164冷却还原 钢盐酸,销基卡因,铁粉,水 冷却水151冷却缩合 钢二溴乙烷,双腈冷却水163冷却反应 搪玻璃对硝基甲苯,硫酸,水冷却水187冷却盐析 搪玻璃普鲁卡因NaCl冷却水135冷却盐析 搪玻璃普鲁卡因NaCl盐水171冷却结晶 搪玻璃溴化钾溶液盐水199加热反应 搪玻璃对硝基甲苯,硫酸,水水蒸汽冷凝249加热