Excel流量孔板計算軟件

已知條件,,,,,,,,

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

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

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

工作溫度,t1,2,OC,,,,,

工作壓力,P1,5,Kpa,,,,,

壓力損失,<=,1,Kpa,,,,,

管道內(nèi)徑,D20,357,mm,,,,,

管材線脹系數(shù),,1.1160E-05,mm/mmOC,,,,,

輔助計算,,,,,,,,

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

本地大氣壓,Pa,97.99,Kpa,,,,,

管道內(nèi)徑,D,356.9283,mm,,,,,

氣體壓縮系數(shù),Z,1,,,,,,

絕對溫度,T1,275.15,K,,,,,

絕對壓力,P1,102.99,Kpa,,,,,

標況密度,,1.091,kg/m3,,,,,

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

標況粘度,,0.0094,cp,,,,,

粘度系數(shù),,1,,,,,,

工況粘度,,0.0094,cp,,,,,

等熵指數(shù),,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,,,,,

管道內(nèi)徑,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