, , . , , ζ , . , . ,
, | (36) |
. | (37) |
, , . .
; | (38) |
; | (39) |
. | (40) |
, , . .
; ; | (41) |
; | (42) |
; ; | (43) |
; | (44) |
; . | (45) |
, MS Excel. Q H . 2.4.
2.4
Q H
H, m | 0,05 | 0,10 | 0,15 | 0,20 | 0,25 |
Q, m3/s | 0,7810-3 | 4,510-3 | 1210-3 | 2610-3 | 4410-3 |
³, Q H (35), (36) . α ( ) M.
MS Excel . 2.4 B1:F2, . 2.7. 3 = LN(B1), 4 - =LN(B2). 3:4 3:F4.
A3:F4 | . , . 2.8.
, , , . 2.7. . . | | OK. . | | OK. .
3 , 4 - . : 6 - =I3, I7 =EXP(I4), B5 - =B4-$I3*B3-$I4 {(43)} B5:F5, K1 - = (B5:F5), K2 - =(B3:F3) {(40)}, B6 - =B3-$K2 B6:F6, K5 - = (B6:F6) {(41)}, K3 - =(K1/(5-2)/K5) {(44)}, K4 - ((1/5+K2*K2/K5)*K1/(5-2)) {(44)}, K6 - K3*(1-0,9;5-1)/(5) {(8), (9)}, K7 - =I7*K4* (1-0,9;5-1)/(5) {(8), (9); , }, M6 - =K6/I6, N7 - =K7/I7 {(15)}. MS Excel . 2.9.
|
|
I6 7 , K6 K7 - , M6 M7 - .
. 2.7. ˳ MS Excel. |
. 2.8. MS Excel. |
. 2.9. MS Excel. |