GPS sentence re-sampling
Thread Starter
Joined: Jan 2005
Posts: 1
Likes: 0
From: earth
GPS sentence re-sampling
I am using a RCATS GPS logger on a glider to determine pitot-static position errors correction.
the data are coming as :
$GPGGA,194154.00,5100.3512,N,00017.6352,W,1,03,6.23,-00047,M,047,M,,*53,$GPVTG,000.0,T,005.2,M,000.0,N,000.0,K,A* 24
Does anybody have an excel macro (or VB application) which could re-sample the data?
Ideally GPGGA and GPVTG sentences would be in separate sheet
Thanks in advance
the data are coming as :
$GPGGA,194154.00,5100.3512,N,00017.6352,W,1,03,6.23,-00047,M,047,M,,*53,$GPVTG,000.0,T,005.2,M,000.0,N,000.0,K,A* 24
Does anybody have an excel macro (or VB application) which could re-sample the data?
Ideally GPGGA and GPVTG sentences would be in separate sheet
Thanks in advance
Joined: Feb 2005
Posts: 340
Likes: 1
From: KPHL
Need a bit more information on what you're working with, but if the logger is creating a comma delimited data file then import the whole file into excel. If you need to convert the data or seperate it, that will be easy using standard excel. If you want to do this in real time, it gets a bit more complicated.
