风管阻力计算 excel计算表 收藏版 免费下载

动压风速外径内径风量比摩阻雷诺数摩擦阻力系数Pam/smmmmm3/hPa/mRe=vd/v1/λ^(1/2)λ7.803.60200199.004030.92147569.72111553796.5230.0237.803.6160159.002571.21938007.968127496.3440.0258.243.7180179.003351.10643977.42363877826.4520.0248.693.8200199.004251.01850212.48339973446.5500.0239.163.9220218.505260.95156583.66533864546.6380.0239.634250248.506980.85066002.65604249676.7540.02210.124.1280278.508990.77275820.05312084996.8580.02110.624.2320318.5012050.68588824.70119521916.9790.02111.134.3360358.5015630.618102360.5577689247.0860.02011.654.4400398.5019760.567116427.6228419657.1820.019说明：空气参数大气压力P=101325Pa，温度T=20，密度=1.204kg/m3,运动粘度v=15.06*10E-6m2/s;风道内表面平均绝对粗糙度，钢板取K=0.15mm输入风速，外径，拖动其他格即可。EXCEL要设置迭代计算，在OFFICE按钮里，最下边有一个EXCEL选项，打开，选择，在对话框里选择启用迭代计算，确定即可。这个表格还可以计算水管阻力，和其他管径计算，而且每一项都很清楚，比其他的一些计算软件好多了动压风速风管外宽风管内宽风管外高风管内高流速当量直径风量比摩阻雷诺数摩擦阻力系数Pam/smmmmmmmmmmm3/hPa/mRe=vd/v1/λ^(1/2)λ6.0883.18320317.50250247.50278.169000.48458735.76490498186.7270.0227.8023.6500498.50200199.00284.4512860.59167995.71606048926.8100.0228.6933.8400398.50250248.50306.1113550.59777239.42971031896.8970.0219.6324320318.50320318.50318.5014610.62584594.95351925636.9540.02112.1914.5400398.50320318.50354.0420560.684105787.9361216227.0980.02015.05051000998.00400398.50569.5771590.466189100.6210270517.5340.01818.2115.51000998.00630628.00770.90124100.386281538.2177726167.8260.01623.1416.212501247.50400398.50604.04110960.649248677.0818709777.6810.017说明：空气参数大气压力P=101325Pa，温度T=20，密度=1.204kg/m3,运动粘度v=15.06*10E-6m2/s;风道内表面平均绝对粗糙度，钢板取K=0.15mm输入风速，外高，外宽，拖动其他单元格即可。管段编号风量风管外宽风管内宽风管外高风管内高流速当量直径风速动压管长比摩阻雷诺数摩擦阻力系数摩阻局阻总阻力累计总阻力不平衡率m3/hmmmmmmmmmmm/sPamPa/mRe=vd/v1/λ^(1/2)λPaPaPaPa1-2900320317.50250247.50278.163.186.093.600.48458762.00213893696.7280.0221.7425.2276.976.97false2-31800400398.50250248.50306.115.0515.353.601.013102629.1536584217.0340.0203.64810.94414.5921.56false3-42700500498.50250248.50331.676.0522.077.21.291133335.4667008017.1800.0199.29227.87737.1758.73false4-55400800798.00320318.50455.295.9020.973.60.835178417.5434402117.4280.0183.0059.01612.0270.75false5-681001000998.00320318.50482.897.0830.163.61.095226969.0701682457.5530.0183.94211.82515.7786.52false6-71260012501247.50320318.50507.448.8146.7141.561296811.9009699817.6800.0176.24418.73124.97111.49false说明：空气参数大气压力P=101325Pa，温度T=20，密度=1.204kg/m3,运动粘度v=15.06*10E-6m2/s;风道内表面平均绝对粗糙度，钢板取K=0.15mm,局部阻力取管路阻力的3倍，详细计算应逐个管件计算；输入风量，外高，外宽，管段编号，管长，拖动其他单元格即可。1通径内径流量动压流速比摩阻雷诺数摩擦阻力系数2mmmmm3/hPam/sPa/mRe=vd/v1/(λ^(1/2))λ320212.49420002.00368541832.66932270925.0840.039425275.35933802.60442369920.31872509965.3200.0355323510.39145003.004170104581.6733067735.5530.0326404113.30839202.802960114342.6294820725.6840.0317505319.85631252.501697131972.1115537855.8940.0298656316.83311251.5049894123.50597609565.9870.0289807822.3638451.30287100996.0159362556.1470.0261010010244.12511251.50270152390.4382470126.3960.02411125128125.07736452.70643344223.1075697216.6560.023说明：按SCH40计算管径，大气压力P=101325Pa，温度T=20，水的运动粘滞系数v=1.004*10E-6m2/s;管内表面当量绝对粗糙度，取K=0.2mm输入流速，管径，拖动其他单元格即可。