..
___________________
(, , )
1 . 3803-111
.._____________
( , )
1
, , , . , . . ( 0 1). , : (0), (1). , - [1].
1
.
, , . , , , 1 . , 2 , --4 . . , .
, : , , .
1 , . . I = 1 = 8 . , I, (, - ):
= 2I = 28 = 256,
. . 256 .
, 00000000 11111111 0 255.
, ( - 8, 1251, 866, , ISO), , . .
.
2
8 | 1251 | 866 | ISO | |||
- | - |
, , - , .
|
|
1997 . Microsoft Windows&Office Unicode, 2 , , , 256 , 65536 [2].
, , Word 6.0 / 95. "" - "", . . , , ( ) , , "" ( ).
Windows (1251) , . , .
ASCII
, , . , (8-, Windows. MS-DOS, Macintosh ISO), .
8 (" , 8-"). 70- , 80- UNIX[3].
8-
Microsoft Windows), CP1251 ("CP" "Code Page", " ").
CP1251
CP866
MAC
ISO
, , , . .
3
8 | 1251 | 866 | ISO | |||
- | - |
: . , - , , - . () . - . . ( ). , . : . , , , , . (. . ), , , , . - , . 3D () , . . .
|
|
: . - .
. , . , . . .
, , . , . , .
2
3
4
5
6
1. , .. : [] / .. , .. , .. . - .: -, 2013. - 400 c.
2. , .. : [] / .. . - .: , 2014. - 384 c.
3. , .. : [] / .. , .. ; .. , .. . - .: , 2013. - 378 c
4. , .. , : [] / .. . - .: , -, 2013. - 544 c.
5. , .. : . . . . [] / .. , .. , .. . - .: , 2013. - 208 c.
6. , .. : [] / .. , .. . - .: , -, 2013. - 416 c.
|
|
7
1. 2
2. 8
3. 10
4. 10
5. 10
6. 11
2
. , 3.
.
1. ( 10 ).
2. , 16 60. .
3. , 3 6. .
3
B | C | ||
, | , |
3 .
1. .
- , ;
- , .
2. : 16 24, 24 36, 36 52, 52 60 . (1, 2, 3 4). .
. 3, .
3. . .
4. . , .
5. 2- 3- ? .
6. 3 3 :
- ;
- ;
- , ;
- .
1 3 ( 1).
.
3
B | C | ||
, | , | ||
3 2 .
. : =(0,87*C2+0,01*C2^2)*(B2/100+0,001*C2^2)^2+0,0002*C2^3.
:
A | B | C | D | E | |
, | , | ||||
0,237635 | |||||
0,7326747 | |||||
0,71121528 | |||||
1,47188088 |
0,29008064 | |||||
0,855875 | |||||
0,372875 | |||||
0,37627584 | |||||
1,34953904 | |||||
0,18262784 |
|
|
( ):
A | B | C | D | E | |
, | , | ||||
=1!B2 | =1!C2 | =(0,87*C2+0,01*C2^2)* (B2/100+0,001*C2^2)^2 +0,0002*C2^3 | =(((16<=B2);(B2<24));1; (((24<=B2);(B2<36));2; (((36<=B2);(B2<52));3;4))) | ||
=1!B3 | =1!C3 | =(0,87*C3+0,01*C3^2)* (B3/100+0,001*C3^2)^2 +0,0002*C3^3 | =(((16<=B3);(B3<24));1; (((24<=B3);(B3<36));2; (((36<=B3);(B3<52));3;4))) | ||
=1!B4 | =1!C4 | =(0,87*C4+0,01*C4^2)* (B4/100+0,001*C4^2)^2 +0,0002*C4^3 | =(((16<=B4);(B4<24));1; (((24<=B4);(B4<36));2; (((36<=B4);(B4<52));3;4))) | ||
=1!B5 | =1!C5 | =(0,87*C5+0,01*C5^2)* (B5/100+0,001*C5^2)^2 +0,0002*C5^3 | =(((16<=B5);(B5<24));1; (((24<=B5);(B5<36));2; (((36<=B5);(B5<52));3;4))) | ||
=1!B6 | =1!C6 | =(0,87*C6+0,01*C6^2)* (B6/100+0,001*C6^2)^2 +0,0002*C6^3 | =(((16<=B6);(B6<24));1; (((24<=B6);(B6<36));2; (((36<=B6);(B6<52));3;4))) | ||
=1!B7 | =1!C7 | =(0,87*C7+0,01*C7^2)* (B7/100+0,001*C7^2)^2 +0,0002*C7^3 | =(((16<=B7);(B7<24));1; (((24<=B7);(B7<36));2; (((36<=B7);(B7<52));3;4))) | ||
=1!B8 | =1!C8 | =(0,87*C8+0,01*C8^2)* (B8/100+0,001*C8^2)^2 +0,0002*C8^3 | =(((16<=B8);(B9<24));1; (((24<=B8);(B9<36));2; (((36<=B8);(B8<52));3;4))) | ||
=1!B9 | =1!C9 | =(0,87*C9+0,01*C9^2)* (B9/100+0,001*C9^2)^2+0,0002*C9^3 | =(((16<=B9);(B9<24));1; (((24<=B9);(B9<36));2; (((36<=B9);(B9<52));3;4))) | ||
=1!B10 | =1!C10 | =(0,87*C10+0,01*C10^2)*(B10/100+0,001*C10^2)^2+0,0002*C10^3 | =(((16<=B10);(B10<24));1; (((24<=B10);(B10<36));2; (((36<=B10);(B10<52));3;4))) | ||
=1!B11 | =1!C11 | =(0,87*C11+0,01*C11^2)*(B11/100+0,001*C11^2)^2+0,0002*C11^3 | =(((16<=B11);(B11<24));1; (((24<=B11);(B11<36));2; (((36<=B11);(B11<52));3;4))) |
:
=(A2:A11;"";D2:D11)+(A2:A11;"";D2:D11). 1,987 3.
0,924 3 :
=(A2:A11;"";D2:D11)/ר(A2:A11;"").
2- 3- 7, :
=ר(E2:E11;3)+ר(E2:E11;2).
3 3 , : , .
:
:
A | B | C | D | E | |
, | , | ||||
1181,470372 | |||||
4146,927875 | |||||
6223,138419 | |||||
11551,53667 | |||||
19447,73427 | |||||
13426,04788 | |||||
32873,78215 | |||||
12875,65491 | |||||
12875,65491 | |||||
8515,317875 | |||||
6735,382372 | |||||
15250,70025 | |||||
3497,594432 | |||||
12933,61788 | |||||
16431,21231 | |||||
88982,88628 |
:
A | B | C | D | E | |
, | , | ||||
26944,5643 | |||||
9761,788004 | |||||
4108,601019 | |||||
11573,79253 | |||||
16049,95189 | |||||
68438,69774 |
|
|
3 ( ) . D, ( 1).
1 -
( 2).
2
1. , . .Microsoft Office 2010. []/ . . , . . , . . - .: , 2011.- 432 .
2. , .. Microsoft Excel 5.0 ( ). 1 []: , / .. . : , 1997. 184 .
3. . Microsoft Windows, Word Excel []: 0608, 0605, 2602, 2506, 1704 / .. [ .] , - , 2001. - 44 .
4. , .. []/ .. , .. .- .: , 2011. 576 .
5. , .. . : []/ .. . - 3- ., . . - .: , 2008. 592 .
[1] , .. : [] / .. , .. ; .. , .. . - .: , 2013. - 78 c.
[2] , .. : [] / .. , .. ; .. , .. . - .: , 2013. 93 c.
[3] , .. : [] / .. , .. , .. . - .: -, 2013. 74 c.