.
. F(x, y), [a, b] × [c, d],
xi = a + ihx, yi = c + jhy,
i = 0 Nx, j = 0 Ny,
b a
hx = ,
Nx
d c
hy = .
Ny
| N | F(x,y) | a | b | c | d |
| tg (x + y) |
. 1. 2.
1
2
2
. .
5 , 2 , 25 . : , ( ), , . , 3,5 ( 0).
.
5
. . , . .
:
, .
, =(D2>3,5;1000;)+(D2>4;1000;)
=(D2>4;500;0);
=E2+F2.
, =(D2=5;1;0). 50% =$G$252*50%/250 .
.
3
( 10 ):
| A | B | C | D | E | F | G | H | I | J |
1. 1, 2 .
2. 1, 2 .
3. , 1, 2
4.
5.
6.
7. ,
8. ,
9. , 5000
3, Microsoft Excel. , , .
|
|
|
1
1, 2 . , 1, 2 . . . . , . , . , 5000 .
2
