Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

converting GPS recordings saved as a word doc to Exel

  • 03-07-2013 10:40am
    #1
    JBrah123
    Registered Users, Registered Users 2 Posts: 1 ✭


    Im trying to graph a chart showing location (GPS) and Temperature. I saved both as txt files in notepad and am trying to put them into excel to make a graph. The data from the GPS looks like this: $GPRMC,215614.000,A,5321.389749,N,00626.973976,W,0.16,284.73,310113,,,A*7F
    $PTSI5544*1E
    $GPGGA,215615.000,5321.389926,N,00626.973415,W,1,5,1.54,26.330,M,55.163,M,,*7A
    $GPGSA,A,3,25,17,12,24,14,,,,,,,,1.80,1.54,0.94*07

    Im not sure where to go from here and how to sort out this GPS information, any help would be greatly appreciated!


Comments

  • #2
    NotCarrotRidge
    Registered Users, Registered Users 2 Posts: 160 ✭✭NotCarrotRidge


    One thing you need is to know what coordinate system was used. It is also not clear where you got your data. When you say that you 'saved both as txt files', what exactly do you mean? What did you save? If you give us a bit more information as to what exactly you've done, we can probably help.


  • #3
    slowburner
    Moderators, Science, Health & Environment Moderators Posts: 5,223 Mod ✭✭✭✭slowburner


    JBrah123 wrote: »
    Im trying to graph a chart showing location (GPS) and Temperature. I saved both as txt files in notepad and am trying to put them into excel to make a graph. The data from the GPS looks like this: $GPRMC,215614.000,A,5321.389749,N,00626.973976,W,0.16,284.73,310113,,,A*7F
    $PTSI5544*1E
    $GPGGA,215615.000,5321.389926,N,00626.973415,W,1,5,1.54,26.330,M,55.163,M,,*7A
    $GPGSA,A,3,25,17,12,24,14,,,,,,,,1.80,1.54,0.94*07

    Im not sure where to go from here and how to sort out this GPS information, any help would be greatly appreciated!
    The Ordnance Survey of Ireland offers an extremely useful co-ordinate converter, free to download or to use online.
    (Note: it doesn't work on the Mac OS)
    http://www.osi.ie/Services/GPS-Services.aspx


Advertisement