水輪機選型計算excel程序

1、Hmax(m =91.0Nf (kW =5000H i (m =f(% =0.94He(m =115.0Ns (kW =5319Hmin(m =89.0電站高程255取算單位流量m 3/s 取算水輪機效率最優(yōu)單位轉(zhuǎn)速r/min 模型最高效率模型轉(zhuǎn)輪直徑m 工藝和部件修正轉(zhuǎn)輪效率修正轉(zhuǎn)輪直徑m 取算轉(zhuǎn)輪直徑m 計算轉(zhuǎn)速r/min 同步轉(zhuǎn)速r/min 單位轉(zhuǎn)速r/min 實際水輪機效率水輪機流量m 3/s 單位流量m 3/s 空蝕系數(shù)吸出高度m 單位轉(zhuǎn)速r/min 水輪機流量m 3/s 單位流量m 3/s 單位轉(zhuǎn)速r/min 單位流量m 3/s 單位轉(zhuǎn)速r/min Q'1's n&

2、#39;10M maxD 1M 1-2D'1D1njs ne n'1s Qe Q'1Hs n'1Qe Q'1n'1Q'1n'190/D540.250.90062.00.9170.400.020-0.002 1.40 1.4047550065.30.898 5.250.250.028 5.4773.4 6.790.3674.20.29#DIV/0!A1790.230.88562.00.9130.400.0200.0001.47 1.4745242958.80.885 5.330.230.030 5.1966.1 6.890.3366

3、.80.27#DIV/0!A5420.270.88062.00.9250.500.020-0.006 1.36 1.3648950063.40.874 5.390.270.030 5.2471.3 6.980.4072.10.32#DIV/0!160/D460.620.90067.50.9160.400.020-0.0080.890.8981375062.20.892 5.290.620.043 3.8370.0 6.830.9070.80.73#DIV/0!A2530.750.90063.00.9210.460.020-0.0120.810.8183475056.60.888 5.310.7

4、50.0552.3563.7 6.86 1.1064.40.88#DIV/0!180/A1940.720.91070.00.9260.350.020-0.0080.820.82915100076.50.9025.230.730.0700.4586.0 6.76 1.0586.90.85#DIV/0!180/D06A 0.800.88569.00.9150.400.020-0.0090.790.79937100073.70.876 5.380.800.056 2.2482.8 6.96 1.1783.70.94#DIV/0!A6780.780.90071.50.9360.370.020-0.01

5、10.790.79971100073.70.889 5.300.790.0651.1082.86.86 1.1583.70.93#DIV/0!220/A153 1.050.90071.00.9150.460.020-0.0140.680.681120100063.40.886 5.32 1.070.080-0.7471.3 6.88 1.5672.1 1.26#DIV/0!240/D41 1.080.89077.00.9200.350.020-0.0100.680.681214100063.40.880 5.36 1.080.105-3.9171.3 6.93 1.5772.11.27#DIV

6、/0!260/D741.220.90579.00.9270.350.020-0.0120.630.631345150088.10.893 5.28 1.240.140-8.3199.16.831.80100.2 1.45#DIV/0!說明在模型曲線上初步取值電站水輪機轉(zhuǎn)輪直徑、轉(zhuǎn)速及工作范圍計算取算水輪機效率's -取算選用的Q'1值與模型最優(yōu)單位轉(zhuǎn)速值n'1交點處的模型效率。取算單位轉(zhuǎn)速n'1-取最優(yōu)單位轉(zhuǎn)速n'1。實際水輪機效率s -根據(jù)計算的n'2值與模型出力限制線交點稍左處的模型效率-。效率修正H i 時計算值Hmax 時計算值Hmin

7、時計算值額定水頭(He 下計算值xxx 取算單位流量Q'1-在模型曲線上初選,最優(yōu)單位轉(zhuǎn)速n'1與出力限制線的交點稍左處。轉(zhuǎn)輪型號出力限制線Hmin 時He 時Hmax 時n '1Q'1Hmax 時Hi He 時Hi 時工作范圍轉(zhuǎn)輪260/A244 1.250.87080.00.9170.350.020-0.0110.640.641340150089.50.859 5.49 1.250.150-9.58100.67.10 1.82101.8 1.46#DIV/0! A551 1.300.90080.20.9350.350.020-0.0130.610.61141

8、0150085.30.887 5.32 1.330.110-4.5095.9 6.87 1.9497.0 1.56#DIV/0! A6900.880.92072.50.9370.360.020-0.0120.740.741051100069.00.908 5.190.880.0700.4977.6 6.71 1.2878.4 1.03#DIV/0! A575c0.550.91566.10.9350.500.020-0.0120.930.9376275065.00.903 5.220.560.060 1.6673.1 6.750.8273.90.66#DIV/0!注釋:比轉(zhuǎn)速:ns=7n(Ns0

9、.5/6H1.25Hs=10.0-kH-?/900-D1/2k=1.051.30單位轉(zhuǎn)速n'1=n*D1/H0.5單位流量Q'1=Q/(D12*H0.5Q=Nf/(9.81*f*s*H轉(zhuǎn)速計算:n=n'10*H0.5/D1計算:水輪機最高效率T max=1-(1-M max*(D1M/D10.2-1-2 =Tmax-M max D1計算:D1=(Ns/(9.81*Q'1*s*H1.50.5單位流量m 3/s轉(zhuǎn)輪最優(yōu)工況下的值m.kW 本站條件下的計算值m.kW Q'1ns ns'n'1R nR Hsy#DIV/0!84.0113.098.

10、6671.8230-400#DIV/0!89.796.998.8641.2400#DIV/0!97.6113.098.3689.5400#DIV/0!150.0169.5122.31310.9#DIV/0!166.5169.5115.31357.9140#DIV/0!170.0225.9127.81486.7110-180#DIV/0!172.0225.9128.61552.9110-150#DIV/0!189.9225.9130.91580.6180#DIV/0!218.0225.9136.61916.390-150#DIV/0!225.0225.9146.72058.070-105#DIV

11、/0!247.0338.9150.42277.350-80其它相關(guān)參數(shù)單位飛逸轉(zhuǎn)速r/min 單位轉(zhuǎn)速r/min 使用水頭m比轉(zhuǎn)速 m.kW's -取算選用的Q'1值與模型最優(yōu)單位轉(zhuǎn)速值n'1交點處的模型效率。n'1-取最優(yōu)單位轉(zhuǎn)速n'1。s -根據(jù)計算的n'2值與模型出力限制線交點稍左處的模型效率-。注:表中紅色字體的單元格是可修改的。輸入電站參數(shù)后,看某個轉(zhuǎn)輪在本站設計工況下的單位轉(zhuǎn)速與模型最優(yōu)單位轉(zhuǎn)速相近,單位流量適當即可。真誠歡迎各位同行提出中肯的意見。QQ48257550時計算值Q'1-在模型曲線上初選,最優(yōu)單位轉(zhuǎn)速n'1與出力限制線的交點