Closed Thread
Results 1 to 4 of 4

How to calculate GPS XY offsets

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

    How to calculate GPS XY 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 method 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 /function on the data 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 Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How to calculate GPS XY offsets

    Duplicate thread: http://www.excelforum.com/excel-prog...s-offsets.html
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

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

    Re: How to calculate GPS XY offsets

    how do i delete this post?!

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: How to calculate GPS XY offsets

    Thanks OllyXLS.


    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. GPS Offsets
    By briggsa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-11-2013, 06:18 AM
  2. [SOLVED] Help with Copying Ranges and Offsets
    By lfwake2wake in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-25-2013, 01:57 PM
  3. [SOLVED] If statement and offsets
    By rlkerr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2012, 11:33 AM
  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