工艺计算常用公式与数据Excel模板.xls

名称数据单位名称数据单位管径流速:3.1415926:3.1415926输入u:60m/s输入d:100mm输入Vs:60000m3/h输入Vs:40m3/h计算d=594.7mm计算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：计算管长m V=：管道线胀系数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已知X出(w/w):70.0%蒸发量:15.00T/hX进(w/w):35.0%泵轴功率计算输入:Q:50m3/hH:50m:1150kg/m3:0.710112XXXFW101XXFW101XXWFWFFXX22101023600 QHNeNe=11.19kwNe22K=1.2522Ne55K=1.1555NeK=1.00输入K:1.25P=13.98kwKNPe显热法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加热溶解 搪玻璃普鲁卡因粗品水蒸汽冷凝240加热精制 搪玻璃溴化钾溶液水蒸汽冷凝352沸腾蒸发 搪玻璃溴化钾溶液水蒸汽冷凝170沸腾蒸发 搪玻璃溴化钾溶液水蒸汽冷凝298沸腾蒸发 铸铁二溴乙烷水蒸汽冷凝523沸腾蒸发 钢二乙胺水蒸汽冷凝233加热精制 钢粗硝基甲酸,5%NaOH水蒸汽冷凝1454加热中和 钢硝基甲酸,钾盐,水水蒸汽冷凝93加热反应 钢二溴乙烷,硝基甲酸水蒸汽冷凝442加热缩合 钢二溴乙烷,双脂水蒸汽冷凝159加热还原 钢盐酸,销基卡因,铁粉,水水蒸汽冷凝1256空气冷却器的总传热系数K推荐值(以光管为基准)冷凝K液体冷却K气体冷却操作压力压降KW/(m2)W/(m2)kPa(g)W/(m2)氨625 机器夹套水710 空气或烟道气345 0.73.557氟利昂-12400 柴油14069013.8110汽油460 轻瓦斯油37069034170轻碳氢化合物510 轻碳氢化合物480 碳氢化合物气体2417200轻石脑油430 轻石脑油40086221200重石脑油370 重整炉液流400690034460重整反应器废汽400 残油85 氨反应器流体-480低压蒸汽770 焦油40塔顶蒸汽370壳程管程液体液体介质稀释沥青水乙醇胺（单乙醇胺或二乙醇胺）10%25%水或二乙醇胺或单乙醇胺软化水水燃料油水燃料油油汽油水重油重油富氢重整油富氢重整油煤油或瓦斯油水煤油或瓦斯油油煤油或喷气发动机燃料三氯乙烯夹套水水润滑油(低粘度)水润滑油(高粘度)水润滑油油石脑油水石脑油油有机溶剂水有机溶剂盐水有机溶剂有机溶剂妥尔油衍生物,植物油水水烧碱溶液10%30%水水蜡馏出液水蜡馏出液油冷凝蒸汽液体介质酒精蒸汽水沥清(232)导热姆蒸汽导热姆蒸汽妥尔油及其衍生物导热姆蒸汽导热姆液煤气厂焦油水蒸汽高沸点烃类(真空)水低沸点烃类(大气压)水烃类蒸汽(分凝器)油冷凝蒸汽液体介质有机蒸汽水不凝性气体含量高的有机蒸汽(大气压)水或盐水不凝性气体含量低的有机蒸汽(真空)水或盐水煤油水煤油油石脑油水石脑油油稳压器的回流蒸汽水水蒸汽饮用水水蒸汽6#燃料油水蒸汽2#燃料油二氧化硫水妥尔油衍生物,植物油(蒸汽)水芳香族蒸汽共沸物气体液体介质空气,N2等(压缩)水或压缩空气,N2等(大气压)水或压缩水或压缩空气,N2等(压缩)水或压缩空气,N2等(大气压)水含天然气混合物的氢气汽化器无水氧水蒸汽冷凝氯气水蒸汽冷凝氯气传热用轻油丙烷,丁烷等水蒸汽冷凝水水蒸汽冷凝总传热系数范围包括在K中的总污垢热阻W/(m2)(m2)/W571100.0018080011000.00054170028000.00018851400.0012057850.001403405700.00054572300.000705108800.000351402800.000881102000.000882302800.00026130017000.000351402800.000352304600.00054601100.001102804000.000881402000.000882808500.000542005100.000541103400.000351102800.0007057014500.00054110014200.00054851400.00088741300.0008857011000.000352303400.001103404600.000704606800.000262302800.000971102800.0005446011000.000541402300.0007057011000.000541103400.000542806800.000541703400.000701101700.000882804300.000881101700.000884606800.00054230057000.00088851400.000973405100.0004485011000.000541102800.000702304600.000882304600.00088572800.000881102300.00088301100.000884607100.0005485017000.0002685017000.000262303400.00026110017000.00026142023000.00026水的饱和蒸汽压温度压力温度压力温度压力PammHgPammHgPammHg-20103.00.772212487.418.656221846.9163.80-19113.40.850222644.819.836322860.5171.40-18124.70.935232810.221.076423914.2179.30-17137.01.027242984.922.386525007.9187.50-16150.41.128253169.023.766626154.9196.10-15165.11.238263362.425.216727341.9205.00-14181.01.357273566.526.746828542.3214.00-13198.21.486283781.228.356929836.0223.70-12217.01.627294006.630.047031169.8233.70-11237.41.780304244.031.827132530.2243.90-10259.51.946314494.733.77233957.3254.60-9283.42.125324756.235.667335437.8265.70-8309.62.321335032.237.737436971.6277.20-7337.72.532345321.739.97538558.8289.10-6368.22.761355625.842.187640199.3301.40-5401.23.008365943.244.567741893.2314.10-4436.93.276376278.047.077843653.7327.30-3475.63.566386622.149.657945480.9341.00-2517.03.876396994.252.448047361.5355.10-1562.34.216407378.355.328149255.5369.300610.74.579417781.158.348251336.1384.901657.54.930428202.661.58353430.1400.602705.65.290438642.764.88455590.8416.803758.95.690449104.268.268557831.5433.604813.66.100459587.071.888660138.9450.905872.36.5404610089.875.658762166.2466.106935.07.0104710616.779.68864967.1487.1071001.67.5104811164.883.718967501.2506.1081073.78.0504911763.788.29070128.7525.8091148.48.6105012338.592.519172836.2546.10101228.49.2105112964.197.29275623.7567.00111312.49.8405213617.6102.19378504.6588.60121403.110.5205314297.8107.29481478.9610.90131497.811.2305415004.7 112.509584546.5633.90141599.211.9905515738.3 118.009687707.5657.60151705.912.7905616511.8 123.809790975.2682.10161817.913.6305717312.1 129.809894336.3707.30171937.914.5305818152.4 136.109997790.7733.20182064.615.4805919019.3 142.60100101365.2760.00192198.016.4806019926.3 149.40202339.417.5406120859.9 156.40空气的重要物理性质温度密度定压比热 导热系数粘度运动粘度kg/m3kJ/kgW/mK10-3cP10-6m2/s-501.5481.0130.020414.69.23-401.5151.0130.021215.210.04-301.4531.0130.022015.710.80-201.3951.0090.022816.212.79-101.3421.0090.023616.712.4301.2931.0050.024417.213.28101.2471.0050.025117.714.16201.2051.0050.025918.115.06301.1651.0050.026718.616.00401.1281.0050.027619.116.96501.0931.0050.028319.617.95601.0601.0050.029020.118.97701.0291.0090.029720.620.02801.0001.0090.030521.121.09900.9721.0090.031321.522.101000.9461.0090.032121.923.131200.8981.0090.033422.925.451400.8541.0130.034923.727.801600.8151.0170.036424.530.091800.7791.0220.037825.332.492000.7461.0260.039326.034.852500.6741.0380.042927.440.613000.6151.0480.046129.748.333500.5661.0580.049131.455.464000.5241.0680.052133.063.095000.4561.0930.057536.279.386000.4041.1140.062239.196.897000.3621.1350.067141.8115.408000.3291.1560.071844.3134.809000.3011.1720.076346.7155.1010000.2771.1850.080449.0177.10管道自然补偿 1、概述 热力管道布置时应充分利用管道本身自然弯曲来补偿管道的热伸长。当弯管转角小 150时，能用作自然补偿；反之不可。自然补偿的管道臂长不应超过 2025m，弯曲应力不应超过bw=80MPa。动力管道设计中自然补偿常用的为 形直角弯、Z 字形折角弯及空间立体弯三类自然补偿。2、平面自然补偿管段短臂长度的计算 1）形直角弯；l=1.1300LD m D为管道外径 2）Z 形折角弯自然补偿 l=2132.11106KbwtED m E管道材料的弹性模量，MPa D管道外径 K等于 L1/L2 bw弯曲许用应力，MPa 3）3、L L l L1 l L2