, ( = 2,3,4),
.
, , :
, (1.4)
(1.3) (1.5):
, ( = 2,3,4). (1.5)
3. ( , , )
(1.6)
.
4. , , ( , , ) , .
.
( , MathCad).
:
,
,
, .
:
. (1.8)
5. GPS :
(1.9)
:
, (1.10)
1
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
2
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
3
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
4
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
5
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
6
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
7
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
8
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
9
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
10
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
11
|
|
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
12
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
13
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
14
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
15
ᒺ | , | , | , | , |
1 | ||||
2 | ||||
3 | -12739068 | |||
4 | -8192554 | -14189920 |
5
: GPS-
: , GPS , Microsoft Office 2007.
ճ :
1. ( Lab GPS 5 ).
2. , ( Microsoft Office 2007).
3. ( AGrapher - ).
4. .
( ) ( ):
.
, ( ) ( ):
.
1. LabGPS_5 _N, N . : 1.txt, 2.txt 3.txt, , .
2. 1.txt MS Excel ( MS Excel). . 4, . 5.
. 4. MS Excel
. 5. ( ߔ)
ϳ $GPGGA - , . , $GPGGA . ϳ $GPGGA , .
|
|
3. MS Excel . . . ,
$GPGGA,104846.000,5023.9905,N,03036.8312,E,1,08,1.2,106.3,M,27.8,M,,0000*5E
104846.000, 8 17 ( 10). . , . (1,8,10). , , , 璺 (). , ( ()), 2!!!, , , ( ()). :
(((A2;8;2)+2;"00");":";((A2;10;2);"00");":";(((A1;12;6);".";",");"00,000")).
12:28:02,000. , (.) 䳿 ( Y - (A2;21;7), X - (A2;34;7)).
, ( 4 5 : 80, 160), . , . (). , . :
(A1;(",";A1;52)+1;("M";A1;3)-(",";A1;52)-2)
, . 6.
. 6.
4. 䳿 . 4 ., . , , ( 12:48:46,000 . 6). ϳ 4 . (), , (), . (1,5,9,13 ..), 4*n+1, n , , . :
(E$2:E$3466;((F2)-2)*4+1;1).
. 7.
. 7. 4
5. dz . Excel, , , . (), (). , Excel (Excel ). , . 8.
. 8.
. 8 , 1, 2 3 , .
6. ( , ()). ( -ճ, =1,2,3). ABS(). . 9.
|
|
.9. ³
( ()). , , AGrapher, . . 10.
7. . , , , . , , .
8. ³ , AGrapher. ( , X, Y) , 璺 .. , . , . . 11.
.10.
11.
6
: GPS-
: , GPS , Microsoft Office 2007.
ճ :
1. ( Lab GPS 6 ).
2. , ( Microsoft Office 2007).
3. ( AGrapher - ).
4. .
1. , 1- , , .
N.txt N . .txt ( ) . MS Excel ( MS Excel).
$GPGGA , . , $GPGGA . ϳ $GPGGA .