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

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

《化工工艺设计计算EXCEL表.xls》由会员分享，可在线阅读，更多相关《化工工艺设计计算EXCEL表.xls（21页珍藏版）》请在冰点文库上搜索。

名称数据单位名称数据单位管径流速:

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.01KJ/KgQ冷=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.19KJ/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：

计算管长mV=：

管道线胀系数cm/（m）n=t2：

管内介质温度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进（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.98kw1023600QHNeKNPe已知WFFXX2210显热法Ws*C*（t2-t1）无相变焓差法Ws*（h2-h1）无要求潜热法Ws*C*（t2-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.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.0304125.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.42331.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.4115170.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.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.0715513.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.0213146.93001325.542708.01382.53109876.000.0179955.59001378.712680.01301.332011300.000.0151665.95001436.072648.21212.133012880.000.0127378.53001446.782610.51113.734014510.000.0106493.98001562.932568.61005.735016530.000.00884113.20001632.202516.7880.5饱和水蒸汽表（按温度排列）温度绝对压力蒸汽比容蒸汽密度液体焓蒸汽焓汽化热kPam3/kgkg/m3kJ/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.43.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.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.802644.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.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.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.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+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.902776.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.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.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液体（管道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.981.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车间通风换气（主管）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水的重要物理性质温度外压密度焓比热导热系数粘度运动粘度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.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.75258.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.07046.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.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.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.10320113.000667.11462.006.5730.5060.0850.01283.8209.81330128.700640.21526.007.2700.4840.0810.01274.3307.67340149.100610.11595.008.1600.4570.0770.01275.3405.67350165.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加热