.
,
.
:
,14
,,14,45,12,86
,,21,32,28,74
,,62,76,84,22
,.
,03,11,55,48
,,60,89,48,6
,,73,26,62,18
,,52,68,36,95
,,51,18,87,21
,,52,58,9,88
,.
,34,93,74,36
,,94,47,19,72
,,71,31,40,45
,,52,54,69,68
,
,01,40,94,59
:
1 40 94 59
.
3 11 55 48
14 45 12 86
.
34 93 74 36
52
58 9 88
51
18 87 21
52 54 69 68
52 68 36 95
62 76 84 22
71 31 40 45
21
32 28 74
60 89 48 6
73 26 62 18
94 47 19 72
,
,
..
,
.
(
).
,
(
).
:
,
2- ,
4- .
,
.
,
,
.
,
Basic.
II
-
BASIC
.
,
.
,
,
, .
10,
5 .
:
,
.
:
,
(
).
:
, , .
.
.
.
:
/
/ -;
500 250 ;
;
-;
4 4
-
;
,
,
,
,
.
60 94
I
MS
Excel.
.
60
.
,
.
,
%:
;
85%;
15%;
MS
Excel:
,
:
;
;
. .
(
);
. .
(
);
(
);
. .
(
);
%
(
);
%
(
);
:
. .
;
. . ;
% ;
%;
;
;
30 ;
.
,
,
,
.
:
. .
;
;
%
,
;
.
.. ,
|
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
|
6 |
9 |
12 |
15 |
10 |
8 |
9 |
6 |
18 |
14 |
12 |
9 |
17 |
21 |
14 |
9 |
3 |
6 |
9 |
12 |
10 |
11 |
15 |
9 |
V=1150 3
(
);
V =35% (
);
Q=310
3/ (
);
=16,2
(
).
,
.
,
,
Excel
97:
(;_)
,
(1;2;)
,
(;)
,
.
(1;2;),
(1;2;)
()
.
, ,
,
..
ABS()
(
) .
(__)
(
1 31)
()
.
:
(())
1
31. ,
7
2000 .
7
.
.
Excel.
,
.
.
.
1.
I
1.1.
2 .
1.2.
EXCEL 4
.
1.3.
8
.
1.4
9 .
1.5
10
.
1.6
11 .
1.7
12
.
2.
II
2.1.
13
.
2.2.
14
.
2.3
BASIC 20
.
2.4
22
.
2.5
24
.
.
Microsoft
Excel
.
,
.
,
.
.
,
.
,
,
,
,
..
:
.
.
.
,
(
),
,
.
.
.
.
,
.
,
, ..
,
.
- ,
..
.. IBM
PC
.
.
7- .-.;
-, 1997.
..
Windows
95. .: , 1996
. Excel
Windows
95. ..: Bhm,
1998
Microsoft
Office.
. :
,
1995
.
, 1997
.. .
,
:
.
, ,
1998
⢮ 㤮 ,14
,宭異᪨,14,45,12,86
,,21,32,28,74
,,62,76,84,22
,.稡,03,11,55,48
,,60,89,48,6
,㢠,73,26,62,18
,⠫,52,68,36,95
,,51,18,87,21
,㭣,52,58,9,88
,.,34,93,74,36
,,94,47,19,72
,ફ,71,31,40,45
,䭯,52,54,69,68
, ࡠ,01,40,94,59
94
-11
..
:
..
2000.
2.
2. 2
3.
Excel 4
4.
7
5.
,
8
6.
,
,
10
7.
11
8.
, (
,
). 12
9.
. 13
10.
. 13
11.
-
14
12.
Basic 15
13.
. 18
14.
: 18
15.
19
2.
.
60 . .
.
:
|
V
|
1000 3
|
- |
V
|
50% |
|
Q
|
290 3/
|
|
P
|
13,8 |
,
%
MS Excel:
,
:
;
;
. .
;
. .
;
;
. .;
%
;
%
;
:
. .
;
. . ;
% ;
%;
;
;
-
- 30 ;
-
.
. .
;
;
%
,
,
,
;
%
.
3.
Excel
Microsoft Excel 97
Windows 95 (98, NT)
,
,
,
.
(
)
Microsoft Office 97
,
Office 97,
()
.
Excel.
:
- Excel
Microsoft Office 97,
,
Excel
,
()
.
Excel
,
OLE 2.0 (Object Linking and Embedding).
Microsoft Office 97- Microsoft Outlook
Office.
Web.
Microsoft Excel Office,
.
Web.
Office
,
.
Microsoft Excel
,
,
.
.
-
(),
,
.
Office.
,
,
.
.
EXCEL
-
Excel
.
Excel,
,
.
,
,
,
,
.
Microsoft
Office 97
.
-
,
.
.
,
255 ,
VBA-
.
- ,
,
.
32 000
65 536 .
Excel
16
,
.
,
Microsoft Excel,
Microsoft
Excel 97.
-
,
.
,
,
.
Excel
,
.
,
.
.
,
.
.
-
.
,
,
(=),
Excel
.
,
,
.
.
,
.
.
,
.
,
.
,
Excel
,
.
,
Excel
,
.
,
.
.
,
,
.
.
-
.
-
.
,
Excel
200
,
.
,
,
,
.
.
,
,
Office
.
-
,
Excel
,
"
".
,
.
MS Excel 5.0
-
,
.
.
Excel.
.
,
,
.
-
.
,
.
,
,
.
,
().
Excel
,
.
,
,
- .
Excel
,
.
-
Excel
.
,
,
.
(Pivot Table),
Excel,
.
.
.
,
Excel
.
,
,
.
-
Excel
,
.
,
,
,
.
,
.
,
,
. Excel
,
,
.
,
,
,
.
-
Excel
MS Query.
Query ()
,
:
Ms Access, dBASE, FoxPro, Oracle, Paradox, SQL Server.
,
,
,
.
VISUAL BASIC
-
5.0
Excel
,
Visual
Basic for Applications (VBA).
Excel
,
.
,
.
-
,
,
.
,
.
.
,
,
.
4.
1).
.
,
2, 2,5.
2).
:
()
:
(9:10),
- ,
,
,
(A9;A10, B9;C10, D9;D10, F9:G9, H9:H10)
(
).
,
.
(
)
.
.
,
8:8,
-
.
,
( Arial Cyr,
-
16, ,
-
14, ,
- 10).
(-).
()
(
).
(
).
3).
:
,
(
)
,
/
.
,
.
Vr
V = Z k *
60 , Z k
.
VSk
VS k = VS k-1 + V k
.
().,
N k
=(VR k-1+Vk-V*V%)/Q
.
.
VR k
=VR k-1+V k-N *Q
3
k- . .
VR %k -
k-
VR
%k= VRk/V ΔVR %k-
%
, :
ΔVR %k = VR %k-V%.
,
|