/1/. ( 2 . ) ( 3 . ).
<>=<>* < . >+<>*< >.
D3=B3*2+C3*3, ( ) . D4=4*2+4*3, D5=B5*2+C5*3 .. - .
A | B | C | D | D | ||
. | . | |||||
1 | =3*2+3*3 | |||||
2 | =4*2+4*3 | |||||
3 | =5*2+5*3 | |||||
4 | =6*2+6*3 | |||||
=(D3:D6) |
- . , ( ), , . . 2 D2, (2 . 3 .) . , () $ (D5=B5*B$2+C5*D$2). 2 $2 D$
A | B | C | D | D | ||
/: | 2,0/ | : | 3,0/ | 3,0/ | ||
. | . | |||||
1 | 172,0 | =5*$2+5*D$3 | ||||
2 | 129,0 | =6*$2+6*D$3 | ||||
3 | 235,0 | =7*$2+7*D$3 | ||||
4 | 264,0 | =8*$2+8*D$3 | ||||
800,0 | =(D5:D8) |
, ܻ , , , . , . . 23.
. 23
л . , . , . , , (.24) (). . , 3 7, . 25
. 24
. 25
л , , , , . , , <100 >7, (.26). , . , . , (. 27). .28
<100 | |
>7 |
. 26 . 27
. 28