Excel流量孔板计算软件

已知条件,,,,,,,,

流量,QNmax：,6000,m3/h,,,,,

,QNcom：,5000,m3/h,,,,,

,QNmin：,3000,m3/h,,,,,

工作温度,t1,2,OC,,,,,

工作压力,P1,5,Kpa,,,,,

压力损失,<=,1,Kpa,,,,,

管道内径,D20,357,mm,,,,,

管材线胀系数,,1.1160E-05,mm/mmOC,,,,,

辅助计算,,,,,,,,

流量标尺上限,Q20,6300,m3/h,,,,,

本地大气压,Pa,97.99,Kpa,,,,,

管道内径,D,356.9283,mm,,,,,

气体压缩系数,Z,1,,,,,,

绝对温度,T1,275.15,K,,,,,

绝对压力,P1,102.99,Kpa,,,,,

标况密度,,1.091,kg/m3,,,,,

工况密度,,1.1815,kg/m3,,,,,

标况粘度,,0.0094,cp,,,,,

粘度系数,,1,,,,,,

工况粘度,,0.0094,cp,,,,,

等熵指数,,1.24,,,,,,

管道粗糙度,K,0.1000,,,,,,

,D/K,3569,,,,,,

工况流量,Qmax：,"5,817.2843",m3/h,,,,,

,Qcom：,"4,616.8923",m3/h,,,,,

,Qmin：,"2,770.1354",m3/h,,,,,

,ReDmin,345334.8813,,,,,,

,ReDcom,575558.1356,,,,,,

,,,,,,,,,

确定差压上限,P,2,Kpa,,E,K,,

圆整,P,2,Kpa,,,1.2,1.24,1.3

,P2/P1,0.9806,0.75,B^4,0.1,0.9912,,0.9919

,Pcom,1.2598,Kpa,,0.1765,0.99066424,0.991130907,0.99136424

,(a0B2)1,0.2775,0.28002,,0.2,0.9905,,0.9912

0.6458,B1,0.6482,,,,,,

,r0,1,,,,,,

,rRe,1,,,E,0.9911,,

,(a0B2)2,0.2800,0.28002,0.2815,,,,

,B2,0.6482,,,,,,

,d,231.3609,,,,,,

,Qcom：,4616.9350,"4,616.8923",,,,,

,Dq,0.0009,%,,,,,

确定差压上限,P,2,Kpa,,,,,

孔板开孔直径,d20:,231.41,mm,,,,,

加工公差,,0.23,mm,,,,,

最大压力损失,,1125,Pa,,,,,

通常压力损失,,709,Pa,,,,,

上游最小直管段,,5712,mm,,,,,

下游最小直管段,,1250,mm,,,,,

管道内径,D20,357,mm,,,,,

孔板开孔直径比,,0.6482,,,,,,

,,,,,,,,,

,a0,0.666452806,,,,,,

0.039077668,0.633609620,0.596051300,0.521308800,0.006722261,1.766438000,0.046911440,0.004375047,

0.648200000,0.029817299,8.882100000,0.454066400,0.219507300,19.979260000,1.031439