| Versions |
  |
|
| Author |
 Topic  |
|
danmancs
Australia
32 Posts |
 Posted - 06 févr. 2006 : 03:41:50
|
UPDATE:
http://www.gpspassion.com/upload/GPS%20Macro.zip
Hi,
I've created a new version of my earlier add-in for excel and also made an easier way of importing the data for those of you that had trouble with that.
To install:
Open the zip file, then extract the enclosed data filter zip to the C:.
Open excel, tools menu, add-ins, browse to the GPS.xla file and open, then ensure it is ticked in the add-ins box. Excel is a bit flakey and you may need to do this again on occasion.
To use:
Rename the NMEA text file you wish to analyse to Data.txt and overwrite the Data.txt file in C:\GPS Data Filter\
Open the MS Access file GPS Converter.mdb and run the query GPS_Output.
Then use the Analyse it in Excel funtion in tools > Office links.
An excel sheet will open with the data in the correct format for running the macro on. The query also takes out any superfluous sentances meaning that a longer time period can be loaded into Excel with its 65k line limit.
Now, in the Excel tools menu, select GPS.
After some working, a dialogue box will appear asking you to select some options. Once you have selected your timezone etc, press run then watch and wait... It may take some time to run if there is a lot of data.
I would appreciate any feedback anyone can give me...
Many thanks, Dan.
Please feel free
---------------------------------------------------------------------
Hi,
I have created an add-in for MS excel that takes an NMEA log file and analyses the data in it. It outputs plots of long/latitude in distance units, as well as alt over long, and speed and alt over time. It also calculates various information such as total distance, max speed, average speed, etc..
I have developed it primarily for use analysing the performance of earthmover tyres, where vehicles generally travel in cycles (load - haul - dump - etc), however, I'm sure there are other applications where it might be useful.
I have tested it with a few different data sets, but only in Australia. If anyone would be kind enough to test it for me in a different part of the planet and/or give me feedback and suggestions, I would be most grateful.
If you would like to help, let me know and if I can figure out how, I will post a copy up here, or email a copy to you... with instuctions for use.
Thanks
Dan. |
Edited by - danmancs on 25 oct. 2006 01:57:25
|
|
|
Ads
|
|
|
gpspassion
93392 Posts |
|
|
danmancs
Australia
32 Posts |
Posted - 07 févr. 2006 : 03:12:06
|
Ok, I have uploaded it to http://www.gpspassion.com/upload/GPS.zip
Install the addin in excel, then import an NMEA log file in txt format using import external data. Choose comma as the seperator, then, and this is critical, make sure all fields are imported as TEXT.
Then run the GPS macro from the tools menu.
Select the time zone you are in.
The TKPH is a function of load on a tyre multiplied by average speed of travel. You can leave this unchecked or put in a value (average family car tyre would be around 0.25T - Large earthmover tyre load could be around 100T)
Press run and watch it work.
Any comments would be much appreciated. |
 |
|
|
gpspassion
93392 Posts |
Posted - 07 févr. 2006 : 11:56:22
|
Thanks, downloaded and installed, but I am getting an error message : "9:the index does not belong to the selection" (translated from French), I did make make sure I had "text" in the third import screen.
_________________________________________________________________________
Discounts and Assistance/Réductions et Assistance (Club GpsPasSion) / Où commencer? |
|
|
|
danmancs
Australia
32 Posts |
Posted - 07 févr. 2006 : 22:33:32
|
I'm guessing this could be an issue related to different sentence strings being recorded in logs from different devices... I'm using a BT338, but if you could post the txt log file that would be useful.
Thanks.
|
|
|
|
gpspassion
93392 Posts |
|
|
danmancs
Australia
32 Posts |
Posted - 16 févr. 2006 : 01:53:59
|
Has anyone else been able to try this and get it to work?
I'd also appreciate it if I could get hold some NMEA logs in .txt form, from various devices and from various parts of the world...
Thanks,
Dan. |
Edited by - danmancs on 16 févr. 2006 01:58:46 |
|
|
|
frder
Italy
45 Posts |
Posted - 02 mars 2006 : 18:42:37
|
rbt-2001
got same error message as gpspassion
francesco
|
|
|
|
danmancs
Australia
32 Posts |
Posted - 02 mars 2006 : 20:34:53
|
make sure when you import the text file, all the columns are imported as TEXT and not GENERAL, or it will not work...
Could you post your log file so I can try running it?
Thanks. |
|
|
|
frder
Italy
45 Posts |
Posted - 03 mars 2006 : 00:55:59
|
yes, i imported all the colums as text.
Anyway, here a short log, just to check if it works or not
$GPGGA,234506.000,4402.3023,N,01235.9458,E,1,06,1.5,76.4,M,0.0,M,,0000*58
$GPGSA,A,3,18,26,09,10,29,28,,,,,,,2.4,1.5,1.9*3C
$GPGSV,2,1,08,29,87,184,29,26,81,305,44,28,49,056,27,17,26,119,18*78
$GPGSV,2,2,08,08,24,073,20,09,24,274,45,10,21,198,19,18,21,313,38*7C
$GPRMC,234506.000,A,4402.3023,N,01235.9458,E,0.00,313.90,020306,,,A*62
$GPGGA,234507.000,4402.3022,N,01235.9461,E,1,06,1.5,75.9,M,0.0,M,,0000*5C
$GPGSA,A,3,18,26,09,10,29,28,,,,,,,2.4,1.5,1.9*3C
$GPGSV,2,1,08,29,87,184,29,26,81,305,45,28,49,056,27,17,26,119,18*79
$GPGSV,2,2,08,08,24,073,20,09,24,274,45,10,21,198,19,18,21,313,38*7C
$GPRMC,234507.000,A,4402.3022,N,01235.9461,E,0.00,313.90,020306,,,A*68
$GPGGA,234508.000,4402.3020,N,01235.9465,E,1,06,1.4,75.2,M,0.0,M,,0000*5F
$GPGSA,A,3,18,26,09,10,29,28,,,,,,,2.4,1.4,1.9*3D
$GPGSV,2,1,08,29,87,184,29,26,81,305,45,28,49,056,27,17,26,119,18*79
$GPGSV,2,2,08,08,24,073,,09,24,274,45,10,21,198,19,18,21,313,38*7E
$GPRMC,234508.000,A,4402.3020,N,01235.9465,E,0.00,313.90,020306,,,A*61
$GPGGA,234509.000,4402.3021,N,01235.9467,E,1,05,3.3,75.0,M,0.0,M,,0000*59
$GPGSA,A,3,18,26,09,29,28,,,,,,,,4.9,3.3,3.6*3F
$GPGSV,2,1,08,29,87,184,29,26,81,305,45,28,49,056,27,17,26,119,18*79
$GPGSV,2,2,08,08,24,073,,09,24,274,45,10,21,198,18,18,21,313,38*7F
$GPRMC,234509.000,A,4402.3021,N,01235.9467,E,0.00,313.90,020306,,,A*63
$GPGGA,234510.000,4402.3020,N,01235.9470,E,1,06,1.4,74.3,M,0.0,M,,0000*52
$GPGSA,A,3,18,26,09,10,29,28,,,,,,,2.4,1.4,1.9*3D
$GPGSV,2,1,08,29,87,184,29,26,81,305,45,28,49,056,27,17,26,119,18*79
$GPGSV,2,2,08,08,24,073,08,09,24,274,45,10,21,198,18,18,21,313,38*77
$GPRMC,234510.000,A,4402.3020,N,01235.9470,E,0.00,313.90,020306,,,A*6C |
|
|
|
danmancs
Australia
32 Posts |
Posted - 03 mars 2006 : 03:37:52
|
Your log worked fine when imported into excel and run in the macro. I'm not sure what you are doing wrong, perhaps try importing it and running again?
I'll email you the resulting file to show you what it should look like... |
|
|
|
joe1981al
USA
13 Posts |
Posted - 03 mars 2006 : 14:06:14
|
worked fine for me :)
Excel XP (2002)
NMEA Log from VisualGPS |
Edited by - joe1981al on 03 mars 2006 14:08:09 |
|
|
|
Leif
Sweden
141 Posts |
Posted - 03 mars 2006 : 16:29:02
|
I tried loading the version you uploaded here in Excel from Office 97. It didn't load anything visible at all. Can you save your updated version to an older format and it still works?
|
|
|
|
danmancs
Australia
32 Posts |
Posted - 04 mars 2006 : 05:31:08
|
I created it using office 2003, I don't know whether it will work in previous versions unfortunatly.
|
|
|
|
forestir
USA
43 Posts |
Posted - 04 mars 2006 : 16:32:30
|
I'm getting "9: Subscript out of range" error. Running Excel 2002.
I'll keep playing with it. I think it will be useful as I'd been doing this manually (plotting speed, acceleration, etc).
Thanks for sharing! |
|
|
|
Leif
Sweden
141 Posts |
Posted - 04 mars 2006 : 18:14:56
|
Try "Save As.." and you should get a selection of formats to save in. How many depends on the Office installation options. If you rerun the Office installation program from Settings, Add and Remove programs, you add more translation formats.
|
|
|
|
Topic |
|
|
|
| This page was generated in 1,03 seconds. |
 |
|
- 
- 
GPS Analysis Add-in for MS excel
