|| || (. . . 3.2) || Excel. , ' 2-8 . , || || || ( ||)
|| "" . 7.1.
" " . || || || .
|| || || .
Ҳ|| ²²Ͳ |,,| || в|',,'|.
|| .
, || , || , , .. . , , , .
|| "" (. . 7.2) || |,,| D25:D28. ||, |,,| D25:D28 .
. 7.1
. 7.2 ""
|| "" |,| || || :
. 7.3
|| |,| ( ). ֳ , . , '|| , || "". || ( '|| ), , , || ||. , '|| , "" . , || || . || .
, .
|,,| "", " " ( " |,,|") , 1/3, 1/7 .
|
|
:
7.1 ""
B | C | D | E | F | G | H | I | J | L | |
=!C4 | =!C5 | =(!C6="";"";!C6) | =(!C7="";"";!C7) | =(!C8="";"";!C8) | =(!C9="";"";!C9) | =(!C10="";"";!C10) | =(!C11="";"";!C11) | |||
0=!C4 | =D17 | |||||||||
=!C5 | =1/D4 | 1/3 | =D18 | |||||||
=(!C6="";"";!C6) | =((1/E4);"";(1/E4)) | =((1/E5);"";(1/E5)) | =(B6="";"";1) | =D19 | ||||||
=(!C7="";"";!C7) | =((1/F4);"";(1/F4)) | =((1/F5);"";(1/F5)) | =((1/F6);"";(1/F6)) | =(B7="";"";1) | =D20 | |||||
=(!C8="";"";!C8) | =((1/G4);"";(1/G4)) | =((1/G5);"";(1/G5)) | =((1/G6);"";(1/G6)) | =((1/G7);"";(1/G7)) | =(B8="";"";1) | =D21 | ||||
= (!C9="";"";!C9) | =((1/H4);"";(1/H4)) | =((1/H5);"";(1/H5)) | =((1/H6);"";(1/H6)) | =((1/H7);"";(1/H7)) | =((1/H8);"";(1/H8)) | =(B9="";"";1) | =D22 | |||
= (!C10="";"";!C10) | =((1/I4);"";(1/I4)) | =((1/I5);"";(1/I5)) | =((1/I6);"";(1/I6)) | =((1/I7);"";(1/I7)) | =((1/I8);"";(1/I8)) | =((1/I9);"";(1/I9)) | =(B10="";"";1) | =D23 | ||
= (!C11="";"";!C11) | =((1/J4);"";(1/J4)) | =((1/J5);"";(1/J5)) | =((1/J6);"";(1/J6)) | =((1/J7);"";(1/J7)) | =((1/J8);"";(1/J8)) | =((1/J9);"";(1/J9)) | =((1/J10);"";(1/J10)) | =(B11="";"";1) | =D24 |
, || . 7.1 || , || :
-
- || ""
- |,,|,
- || |,,| , |,|, |,,|, (- )
|
|
, , 䳿 ||, .
|| |,| . ':
. 7.4 ""
|| ||, |,| ( 4, .31)
|,,| 13 || || :
"=D38/!D27"
||, . 7.3 ( ||).
ϳ|| |,| . ( 1, 2., 8). || || , || . || , || |,,| 1, || , , || 1 || , || 2 ..
. 7.5 ()
"", ; :
A | B | C | D | E | F | G | H | I | |
=!C4 | |||||||||
: | =" """&A1&"""" | ||||||||
=!C17 | |||||||||
=(!C18= "";"";!C18) | |||||||||
=(!C19= "";"";!C19) | |||||||||
=(!C20= "";"";!C20) | |||||||||
=(!C21= "";"";!C21) | |||||||||
=!C17 | =!C18 | =(!C19= "";"";!C19) | =(!C20= "";"";!C20) | =(!C21= "";"";!C21) | |||||
=!C17 | =(!D$26>= !B17;1;0) | =(!D$26>= !B17;D23;"") | |||||||
=(!C18= "";"";!C18) | =((1/D10);""; 1/D10) | =(!D$26>= !B18;1;0) | =(!D$26>= !B18;D24;"") | ||||||
=(!C19= "";"";!C19) | =((1/E10); "";(1/E10)) | =((1/E11); "";(1/E11)) | =(B12="";"";1) | =(!D$26>= !B19;1;0) | =(!D$26>= !B19;D25;"") | ||||
=(!C20= "";"";!C20) | =((1/F10); "";(1/F10)) | =((1/F11); "";(1/F11)) | =((1/F12); "";(1/F12)) | =(B13="";"";1) | =(!D$26>=!B20;1;0) | =(!D$26>=!B20;D26;"") | |||
=(!C21=""; "";!C21) | =((1/G10);""; (1/G10)) | =((1/G11);""; (1/G11)) | =((1/G12);""; (1/G12)) | =((1/G13);""; (1/G13)) | =(B14="";"";1) | =(!D$26>=!B21;1;0) | =(!D$26>=!B21;D27;"") | ||
() = | =((D39/!D28);"";D39/!D28) |
|| || |',| |',| ':
|
|
. 7.6
(. ! .) || .
2, 3., 8 || , || 1, || || 1. (|| || |,,| 1).
. 7.7 "2" "3"
"":
. 7.8 ""
|| "" || . (|,,| 13). , || , .
|| ||:
B | C | D | E | F | G | H | I | J | K | |||||||
=!C4 | =!C5 | =(!C6=""; "";!C6) | =(!C7=""; "";!C7) | =(!C8=""; "";!C8) | =(!C9=""; "";!C9) | =(!C10="";"";!C10) | =(!C11="";"";!C11) | |||||||||
=!D17 | =!D18 | =(!D19=""; "";!D19) | =(!D20=""; "";!D20) | =(!D21=""; "";!D21) | =(!D22=""; "";!D22) | =(!D23=""; "";!D23) | =(!D24=""; "";!D24) | |||||||||
=!C17 | =1!I10 | =2!I10 | =3!I10 | =4!I10 | =5!I10 | =6!I10 | =7!I10 | =8!I10 | =C$6*1!D23+!D$6*2!D23+!E$6*3!D23+!F$6*4!D23+!G$6*5!D23+!H$6*6!D23+!I$6*7!D23+!J$6*8!D23 | |||||||
=(!C18="";""; !C18) | =1!I11 | =2!I11 | =3!I11 | =4!I11 | =5!I11 | =6!I11 | =7!I11 | =8!I11 | =C$6*1!D24+!D$6*2!D24+!E$6*3!D24+!F$6*4!D24+!G$6*5!D24+!H$6*6!D24+!I$6*7!D24+!J$6*8!D24 | |||||||
=(!C19="";""; !C19) | =1!I12 | =2!I12 | =3!I12 | =4!I12 | =5!I12 | =6!I12 | =7!I12 | =8!I12 | =C$6*1!D25+!D$6*2!D25+!E$6*3!D25+!F$6*4!D25+!G$6*5!D25+!H$6*6!D25+!I$6*7!D25+!J$6*8!D25 | |||||||
=(!C20="";""; !C20) | =1!I13 | =2!I13 | =3!I13 | =4!I13 | =5!I13 | =6!I13 | =7!I13 | =8!I13 | =C$6*1!D26+!D$6*2!D26+!E$6*3!D26+!F$6*4!D26+!G$6*5!D26+!H$6*6!D26+!I$6*7!D26+!J$6*8!D26 | |||||||
=(!C21="";"";!C21) | =1!I14 | =2!I14 | =3!I14 | =4!I14 | =5!I14 | =6!I14 | =7!I14 | =8!I14 | =C$6*1!D27+!D$6*2!D27+!E$6*3!D27+!F$6*4!D27+!G$6*5!D27+!H$6*6!D27+!I$6*7!D27+!J$6*8!D27 | |||||||
=" """&(B7;(K13;K7:K11;0)-1;0;1;1)&"""" | =(K7:K12;1) | |||||||||||||||
= | ||||||||||||||||
|
|
|',| ( Excel || || , || .), ( || , || , || ).
|| || , , , || ||. || ||, , || . ʳ , |',,'|.
Excel .
, (. . 6.2) , , | , , | ( ) 1, 2., 6.
||:
. 7.9
( . .6.2.1):
. 7.10
||:
. 7.11 " " ()
. 7.12 "" ()
. 7.13 : " " ()
. 7.14 : " " ()
. 7.15 " " ()
. 7.16 " " ()
:
. 7.17
Excel |,| || , || (. . 6.2.1), || || . , Excel || - || .
(, Excel, ) |',| , |',,'|, .
||.
|| (. . 7.10) 22,65%. , , || (. . 7.18).
(. . 7.19)
. 7.18
. 7.19
, , .
7.2 [1]
|| |,| |',,'| , , , , , . |,| |',,'| (Decision Support System) .
|
|
|| , ||, , |,| |',,'|.
:
|',,'|;
.
|,| |',,'| ( | ), || ||. , , | ||.
- | || . || , || .
:
;
|| ;
|| ;
|,| |',,'|;
, | ;
;
|| ||;
;
( ||);
;
||;
|| Microsoft Excel ;
Microsoft Word.
|,| |',,'|, ' , ( ), . |,| |',,'| ||.
, , || , 㳿 || , ||. -| .
, , , . ³ , |,| .|',,'|
- "" www.neirosplav.com