: - .
: - Microsoft Office Excel.
(, , ..) , , , , .
, , .
, .
; .
.
, .
() , .
, .
() , .
, .
, (, , ..) , , , .
3. -
, , , , , . - , , , . , . . .
|
|
, . , . .
, , , , , , , , . , , .
: . , 201111. . 101113, 101111 101112. , , .
4.
, , . , 1. , 1 3 , 4 , 5 . .
1
-
5.
5.1 Microsoft Office Excel.
5.2 (, 601), ...
5.3 , 1.
1
5.4 :
Ø . : , . , ( ) .
|
|
Ø . . . . .
Ø . , . , F40 4. D6 3. . :
) F40 4. =;
) D6 3. :
) Enter; , F40 4. D6 3. , :
='3. 'D6.
Ø , , .. , $, ; .
, :
F | |
=D12/'4. '!$$29 | |
=D13/'4. '!$$29 | |
=D14/'4. '!$$29 | |
=D15/'4. '!$$29 |
F12 : =D43/'4. '!$$29, ( F12) F13:F15.
Ø . , . 2.
2
='2. '!F15 | |
='2. '!F16 | |
='2. '!B10 | |
='2. '!D10 | |
='2. '!D11 | |
='2. !D11 | |
=A9-A10 |
1
1.1 .
, .
, .
, , .
.
( ).
.
- .
(, ) .
.
|
|
1.3.
- 1000 ., ( 4 ) 4000 .
- , . . : , , . , . , , , , .
, . - , . 25 30% . , , , . , .
. - 2.
2. | 3. | 4. | 5. | ||
101113 | |||||
6. | 7. | 4. | 5. | ||
2
-
3.
, 1 , :
2
;
3
;
|
|
4 ;
5
;
8 ;
9 - .
Ļ | Ļ | |||||||||
|
3 1
1.5.1. 1. .
1.5.2. 1.1 1.4 .
1.1 201111
, . | |||
1.2
C | D | ||||
, . | , . | ||||
1.3
D | ||||
, % | , . | , . | ||
201111 | 25,00% | |||
201111 | 30,00% | |||
101113 | 25,00% | |||
101113 | 30,00% |
1.4 -
D | F | G | |||||
, . | , . | , . | , . | ||||
1.5.3. :
, . = , . ´ , .
1.5.4. 1.2.
1.2
=D10*4 |
1.5.5.
:
{), . = , . (), % /100.
.
1.5.6. 1.3.
1.3
=(D10*B15;0) | |
=(D23*16;0) | |
=(23*17;0) | |
=(D24*18;0) |
1.5.7. - :
, . = () , . + () , . ─ () , .;
, . = , . + , .- , .;
, . = ( , . +
, . ─ , .) ´ ´ , .
, . = , . + , . ─ ─ , .
|
|
.
1.5.8. 1.4.
1.4 -
D | F | G | ||
=D10+C15-D15 | =D23+C16-D16 | =D23*4 | =E23*4 | |
=(E23+C17-D17)*C4 | =D24+C18-D18 | =D24*4 | =E24*4 |
1.5.9. 1.1 1.4 , 1.11.4 .
1.1 201111
, . | |||
1.2
D | |||||
, . | , . | ||||
1.3
D | ||||
, % | , . | , . | ||
201111 | 25,00% | |||
201111 | 30,00% | |||
101113 | 25,00% | |||
101113 | 30,00% |
1.4 -
D | F | G | |||||
, . | , . | , . | , . | ||||
2
2. 1. .
2.2.
, , .
, .
, .
C .
.
2.3.
: 101111 101112. . . . - . , 60% . . .
2.4.
4.
, 2 1 .
2 3 8 .
Ļ | Ļ | |||||||||
|
4 2
2.5.1. 2. .
2.5.2. 2.1, 2.2, 2.3 .
2.1 101113
D | ||||
, /. | , ./ | |||
4,00 | 224,00 | |||
2,40 | 315,00 |
2.2
D | ||||
, % | , | , | ||
101111 | 60,00% | 720,00 | ||
101112 | 60,00% | 800,00 |
2.3
A | B | C | D | E | |
F | G | H | I | |
, | , . | , | , . | |
2.5.3. :
, = , /. ´ , . ´ , % /100.
2.5.4. 2.2.
2.2
='2. '!4*'1. '!$G$24*10 | |
='2. '!5*'1. '!$G$24*B11 |
2.5.5. :
, = , /. ´ , .;
, . = , ´ , ./;
, = , + , ─ , ;
, . = , ´ , ./.
2.5.6. 2.3.
2.3
F | G | |
='2. '!4*'1. '!$G$24 | ='2. '!D4*F15 | |
='2. '!5*'1. '!$G$24 | ='2. '!D5*F16 | |
=F15+F16 | =G15+G16 | |
I | ||
=F15+'2. '! 10-'2. '!D10 | ='2. '!D4*H15 | |
=F16+'2. '! 11-'2. '!D11 | ='2. '!D5*16 | |
=15+16 | =I15+I16 |
2.5.7. 2.1, 2.2, 2.3 , 2.1, 2.2, 2.3 .
2.1 101113
D | ||||
, /. | , ./ | |||
4,00 | 224,00 | |||
2,40 | 315,00 |
2.2
D | ||||
, % | , | , | ||
101111 | 60,00% | 6787,20 | 720,00 | |
101112 | 60,00% | 4072,32 | 800,00 |
2.3
A | B | C | D | E | |
F | G | H | I | |
, | , . | , | , . | |
11 312,00 | 2 533 888,00 | 17 379,20 | 3 892 940,80 | |
6787,20 | 2 137 968,00 | 10 059, 52 | 3 168 748,80 | |
18 099,20 | 4 671 856,00 | 27 438,72 | 7 061 689,60 |
3
3. 1. .
- , , .
, .
.