| O | P | Q | |
| 8 | .. | + | |
| 9 | Hgeom= | =P8-1!J5+1!B14 | |
| 10 | Htot= | =(M2:M21) | |
| 11 | Hm1= | =P6*(P5*3,6)^2 | <=5 |
| 12 | Hm2= | =P3*(P2*3,6)^2 | <=5 |
| 13 | Hf= | + | |
| 14 | H= | =(P9:P13) |
8 ( ).
9 1.
10 .
11 12 .
13 . 2 [1].
14 , .
.
.
4.1.
| A | B | C | D | |
| 1 | . | N, | q(0 tot) | Ptot |
| 2 | . K1-1 | + | =1!B$9 | =(1!B$7*1!B$6/C2/1!B$8/3600;4) |
| 3 | ... | + | ... | ... |
4.1
| E | F | G | H | |
| 1 | N*Ptot | a(tot) | q(o s) | q(s) |
| 2 | =(B2*D2;3) | + | + | =(5*C2*F2+G2;2) |
| 3 | ... | + | + | ... |
.
.
qotot .
, Ptot 
, PN Ptot ( ), a(tot) . 1 .
G , / ( . 2 [1]). . (qos=1,6 /).
, . 8 [1] Excel.
.
4.2.
| A | B | C | D | |
| 11 | . | N, | q(0 tot) | Ptot |
| 12 | . K1-1 | + | =1!B$9 | =(1!B$7*1!B$6/C12/1!B$8/3600;4) |
| 13 | ... | + | ... | ... |
4.2
| E | F | G | H | |
| 11 | N*Ptot | a(tot) | q(o s) | q(s) |
| 12 | =(B12*D12;3) | + | + | =(5*C12*F12+G12;2) |
| 13 | ... | + | + | ... |
4.2. 4.1. C, D, E, H . 4.2. . 4.1.
, J b (. 2), , . 4.3. , , .
|
|
|
4.3. .
| J | K | L | M | N | ||
| 11 | b () | w, 2 | R, | n | ||
| 12 | + | =()*S21^2/4*J21/180-S21^2/8*SIN (J21/90*3,1416) | =K21/(()*S21*J21/180)/1000 | + | b | =((V12<0,7;T12>0,6);"";(T12<0,3;"";(S12*2=(S12*2;2);" ";""))) |
| 13 | + | ... | ... | ... | ... | ... |
. 2. 1.
K , 
, 2;
L , 
, .
.
: b b ( 0,3), , ( 0,6, 0,7 /) b . , 0,005, , b . N, O . , 4.4. .
4.4. .
4.4.
| Q | R | S | T | U | V | |
| 11 | q(s) | d | i | h/d | K | V |
| 12 | =H12 | 110 | =((V12/L12^(1/6)*M12)^2/L12;3) | =((1-COS (J12/180*()))/2;2) | 0,5 | =(1000*H12/K12;2) |
| 13 | ... | ... | ... | ... | ... | ... |
( R) 110 , =0,5 ( U). d=100 , =0,6.
:
S: 
, 
, 
;
T: 
;
V: 
.
