3. 3 .
. , 10000 . 2000 . 7 . 7%?
.4.3.1 5
=(4;2;-)
. 4.3.1
, 2 6
=(2=1;"";((2>=2;2<=4);"";""))
= (1<5; " "; (5=1; " "; " "))
(pv) . . , , , . , , .
: (; ; ; ; )
:
, , , . , . . , 0 ( , , 0), 0 1, , .
= 0 = 0, (5):
(5)
;
i ;
n .
: , , . . , , . . , (Tools, Scenarios) . : 6, 2000; 12, 1500 7, 1500.
/ (Tools, Scenarios). (Scenarios Manager) (Add) (.4.3.2).
(Add Scenario) (Scenario Name) , 1, (hanging Cells) 2 , ( ) (. 4.3.3).
|
|
(Scenario Values), (.4.3.4).
(Add) . (Scenarios Manager) , . 4.3.5.
.4.3.2
. 4.3.3
. 3.4.4
. 4.3.5
(Show) , . (Summary) (Scenario Summary) (.4.3.6).
. 4.3.6
(Scenario Type) (Scenario Summary) a (Scenario Pivot Table), (Result Cells) , . . .4.3.7 (Scenario Summary).
. 4.3.7