1. .
1. 6, ,
2. , , , ,
3. - , . , .
, , :
1. 1 .
2. S 100
:
1. Vi = Ci * 100 - Si , .
2. .
4. , MS-Word
1 , | 100 , S | , V | |||
76,30 | --- | ||||
68,70 | --- | ||||
65,40 | --- | ||||
60,55 | +++ | ||||
70,00 | --- | ||||
: | |||||
: |
5. =C2*100-D2, 2, 2:6. , VS-EXCEL . F2:F6. E2:E6.
1 . | 100 . S | . V | |||
71,3 | =C2*100-D2 | =(E2=($E$2:$E$6);"+++";"---") | |||
68,7 | =C3*100-D3 | =(E3=($E$2:$E$6);"+++";"---") | |||
65,4 | =C4*100-D4 | =(E4=($E$2:$E$6);"+++";"---") | |||
69,55 | =C5*100-D5 | =(E5=($E$2:$E$6);"+++";"---") | |||
=C6*100-D6 | =(E6=($E$2:$E$6);"+++";"---") | ||||
: | =(E2:E6) | =(E7=($E$2:$E$6);"+++";"---") | |||
: | =(E2:E6) |
2. .
. 1.
|
|
1 . | 100 . S | . V | |||
71,30 | 4 167 | 2 963 | --- | ||
68,70 | 4 948 | 2 680 | --- | ||
65,40 | 4 760 | 2 270 | --- | ||
69,55 | 3 654 | 3 301 | +++ | ||
70,00 | 3 875 | 3 125 | --- | ||
: | 14 339 | --- | |||
: | 3 301 |
. 2.
3. .
:
1.
100
2. .
( .)