ЛР VBA Excel
.pdf
. , . , .
:
-2005
32.81. 772
. , . , . . :
. – : « »
, 2005. – 136 .
« »
. , ,
:
», « », « » « ».
Visual Basic for Application (VBA).
:
., . ,
., .
,
© . , . ,
. , 2005 © « »
, 2005
« »
.
04190 06.03.2001 . . 24.12. 04.
09.02.05.
. 60 84/16. .11,0. .- . .11,6. 485. 60 .
, 644112, . , . , 13
2
,
( ) .
( 90%) , 9% –
1% - ( ,
). ,
.
. ,
, , ,
.
.
, , ,
, .
.
( , ).
( ,
). , ,
, .
, .
– , ,
.
, ( ).
, - ),
(
.).
Internet
,
.
,
, .
,
, , .
( ,
),
( , ).
,
, .
, .
3
.
.
–
, ,
,
.
I.
.
,
.
, . ,
: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9.
– ,
,
.
:
.
, –
.
. : I (1), V (5), X (10), L (50), C (100), D (500), M (1000).
. ,
XXX (30) X
– 10, 10+10+10=30.
V (205) 100,
, 100+100+5=205.
, ,
! ,
, 60 ( 1
60 , 1 – 60 ).
4
.
.
, ,
, , , 10, – (0 1) 2, – 8,
– (
) 16 ( . 1).
1
|
– |
|
|
q |
|||
|
|
||
|
10 |
0, 1, 2, 3, 4, 5, 6, 7, 8, 9 |
|
|
2 |
0, 1 |
|
|
8 |
0, 1, 2, 3, 4, 5, 6, 7 |
|
|
16 |
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A (10), B (11), C (12), |
|
|
|
D (13), E (14), F (15) |
q-
q, .
q .
, .
.
1. 9 .
2, .
. , 9
1001 , . 910=10012 (
, ).
|
|
9 |
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
8 |
|
|
|
|
|
|
|
2 |
|
|
|
|
|
|
|
|
||
|
4 |
|
|
|
|
|
|
|
|||||||||||
|
1 |
|
|
|
|
4 |
|
|
2 |
|
|
2 |
|
|
|||||
|
|
|
|
0 |
|
|
|
|
2 |
|
|
1 |
|
2 |
|||||
|
|
|
|
|
|||||||||||||||
|
|
|
|
|
|
|
|
|
|
0 |
|
|
|
|
0 |
|
0 |
||
|
|
|
|
|
|
|
|
|
|
|
|||||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|||||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
1 |
|
|
||
2. 34510 .
_345 8
5
344 |
_43 |
8 |
|
1 |
40 |
_5 |
8 |
30 0
5
. 5318.
q-
,
q- , q ,
, ,
.
,
, .
1. 0,25 .
0, ´25 2
0 ´50
2
1 00
,
, 0,25 - 0,01 , . 0,2510=0,012.
2. 0,610 .
0, ´6 2
1 ´2
2
0 ´4
2
0 ´8
2
1 6
…
. 0,10012.
3. 0,2310
.
6
0, ´23 8
1 ´84
8
6 ´72
8
5 ´76
8
6 08
. . .
. 0,16568.
, ,
.
4. 7,510 . 1. 7 :
_7 |
|
2 |
|
|
|
|
|
|
|
|
|
|
|
|
|||
6 |
|
_ 3 |
2 |
|
|
|
||
1 |
|
2 |
_ 1 |
|
|
2 |
||
|
|
|
||||||
|
|
|
1 |
0 |
|
|
0 |
|
|
|
|
|
|
1 |
|
|
|
710=1112
2. 0,5 :
0, ´5 2
1 0
0,510=0,12
. 111,12.
5. 62,510 .
_62 |
16 |
|
|
|
0, |
|
´ 5 |
|
|
|
|
|
|
|
|||||
48 |
_ 3 |
|
16 |
|
|
|
|||
|
|
|
|
16 |
|||||
|
|
|
|
|
|
|
|
||
14 |
0 |
|
0 |
|
|
||||
|
|
8 |
|
0 |
|
||||
|
|
|
|
|
|
|
|
||
|
3 |
|
|
|
|||||
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
. 3 ,816. |
|
|
|
|
|||||
7
q-
q-
:
·q- :
, 0, ,
, –1, ;
·q-
q ;
·.
1. 100112 .
1. 100112
10011
4 3 2 1 0
2. 100112=1×24 + 0×23 + 0×22 + 1×21 + 1×20 = 16 + 0 + 0 + 2 +1 = 1910
2. 132,018 .
132,01= 1×82 + 3×81 + 2×80 + 0×8-1 + 1×8-2 = 64 + 24 + 2 + 0 + 1/64 =
90,01610
2 1 0 -1 -2
3. 16 .
= ×161 + ×160 = 10×161 + 12×160 = 160 + 12 = 17210
1 0
4. 162358 268.
2358 :
2358 = 2×82 + 3×81 + 5×80 = 128+24+5=15710
2 1 0
268 :
268 = 2×81 + 6×80 = 16+6 =2210
1 0
: 15710 – 2210 = 13510
, . 13510 16- :
135 |
|
|
16 |
|
|
|
|||||
|
|
|
|
||||||||
|
|
128 |
|
|
8 |
|
|
16 |
|||
|
|
|
|
|
|||||||
|
|
|
|
|
|
0 |
|
|
|
||
|
7 |
|
|
|
|
0 |
|||||
|
|
|
|
|
8 |
|
|
|
|||
8
13510 = 8716
, 2358 268 8716.
5. , , : =110012, =10112,
=2318.
, . :
=110012 = 1×24 + 1×23 + 0×22 + 0×21 + 1×20 = 16 + 8 + 0 + 0 + 1 = 2510
4 3 2 1 0
= 10112 = 1×23 + 0×22 + 1×21 + 1×20 = 8 + 0 + 2 + 1 =1110
3 2 1 0
= 2318 = 2×82 + 3×81 + 1×80 = 128 + 24 +1 = 15310
2 1 0
: <A<C.
6. , 1012, [-128; 248].
,
, .
.
1012 = 1×22 + 0×21 + 1×20 = 4 + 0 + 1 = 510
2 1 0
128 = 1×81 + 2×80 = 8 + 2 = 1010
1 0
248 = 2×81 + 4×80 = 16 + 4 = 2010
1 0
, , 510
[-1010; 2010]. –10, –5, 0, 5, 10, 15, 20.
7.
7. 258–128+278×48.
16- .
258 = 2×81 + 5×80 = 16 + 5 = 2110
1 0
128 = 1×81 + 2×80 = 8 + 2 = 1010
1 0
278 = 2×81 + 7×80 = 16 + 7 = 2310
1 0
48 = 4×80 = 410
2110–1010+2310×410 = 10310.
9
16- :
103 |
16 |
|
|
|
|
|||||
96 |
|
|
|
|
|
6 |
|
|
16 |
|
|
7 |
|
|
|
|
|
0 |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
6 |
|
|
|
, 6716.
,
, .
:
0+0=0 |
0×0=0 |
0–0=0 |
1+0=1 |
1×0=0 |
1–1=0 |
0+1=1 |
0×1=0 |
1–0=1 |
1+1=10 |
1×1=1 |
10–1=1 |
1. 100112 + 1112.
1 0 0 1 1 + 1 1 1 1 1 0 1 0
:
1.
1+1=10, 0 , 1 .
2.1,
10, 0 , 1 ,
0 1, 1.
3.0, 1 1 (
), , 1+0=1, 1+1=10, 0
, 1 .
4.1 0, 1.
5.1 .
. 110102.
2. 1001,112 + 11,12.
1 0 0 1 , 1 1 + 1 1 , 1
1 1 0 1 , 0 1
. 1101,012.
10