+ Reply to Thread
Results 1 to 4 of 4

GPS Offsets

  1. #1
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    GPS Offsets

    Hi,
    I need some help with post processing lat long GPS data to more accurately plot where sensor readings were taken. I have a CSV with columns: Lat, Long, Sensor 1 reading, sensor 2 reading.
    The problem is that only one lat long is taken every second, but 2 readings from 2 different sensors are taken. The sensors are offset in permanent positions.
    I need help with a macro where I can input the offsets for each sensor (the sensors are behind and to the left of the GPS (I don't know the exact distance in centimeters yet), as the machine moves forwards) and then run the macro to create a new lat long for the reading from the 1st sensor and for the 2nd sensor, and assign the sensor reading accordingly!
    Hopefully this all makes sense?
    Any advice would be greatly appreciated!
    Many thanks,
    Alex

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    Re: GPS Offsets

    Could you post a workbook with some sample data and some example of what you want to achieve?
    <----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left

    If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
    I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.

  3. #3
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    Re: GPS Offsets

    Hi Jacc,
    Here is some sample data, but its not been corrected how i want as im not sure how to!
    I have two of the same sensors collecting data, and in the output i just want a list of coordinates and sensor readings! I noticed the data does have track degrees... im guessing the bearing?
    Does that make sense?
    Many thanks,
    Alex
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    07-25-2013
    Location
    preston
    MS-Off Ver
    Excel 2011
    Posts
    16

    Re: GPS Offsets

    Sorry, that CSV didnt save properly, here is the workbook.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] If statement and offsets
    By rlkerr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2012, 11:33 AM
  2. Macro for Org Chart with Offsets
    By vanilla_thunderrr in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-18-2012, 05:50 AM
  3. sumifs with vlookups? offsets?
    By bearhorn in forum Excel General
    Replies: 1
    Last Post: 08-25-2011, 06:24 PM
  4. [SOLVED] dynamic offsets
    By lost in forum Excel General
    Replies: 3
    Last Post: 01-08-2006, 03:35 AM
  5. Easy one about offsets
    By carg1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2005, 01:36 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1