Results 1 to 9 of 9

XYZ Coordinates to Earth Plot

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2016
    Location
    S. Florida
    MS-Off Ver
    ms7
    Posts
    5

    XYZ Coordinates to Earth Plot

    Lost in 3D kind of explains my knowledge of advanced Excel. I've been trying to solve it on paper and can't get my head around the complexity. Hopefully some folks can help!
    I have data from 5 satellites and I'd like to know how to calculate the position on Earth of the receivers coordinates, XYZ,
    I know how to convert geodetic coordinates to Cartesian if necessary.

    Please, can anyone help?


    Satellite View.jpg
    Satellite View Data.jpg
    or Cartesian Coordinates:
    ECEF COORDS X Y Z
    SAT1 2926991.38342522 -3882838.58596944 4144244.87430255
    SAT2 3268136.54260175 -4639752.26938107 2944623.86418239
    SAT3 -347247.81198599 -5693759.79190739 2888355.61305460
    SAT4 3864424.69757511 -2592871.37042505 4375986.84769265
    SAT5 -1491397.01293895 -3254491.69640659 5285985.02139871

    Looking for more classroom geometry as the assumptions don't include any real life error. Some assumptions:
    •All four signals reached your GPS receiver simultaneously
    •The waypoint is at sea level
    •The Earth's atmosphere has no effect on the GPS signal
    •The Earth is a perfect sphere, with a radius of 6370 kilometers
    •The speed of light is 3.00E+08 meters per second
    •Your GPS receiver has no time differential error"
    Last edited by lostin3d; 02-08-2016 at 01:08 AM. Reason: better description

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return Scatter Plot Coordinates
    By Dendrinos2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2014, 07:12 AM
  2. [SOLVED] Plot coordinates using vba
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2014, 03:32 AM
  3. Build a map that I can enter and plot x,y coordinates.
    By johnmj57 in forum Excel General
    Replies: 3
    Last Post: 01-27-2014, 03:36 PM
  4. Read multiple earth coordinates from an excel file, and draw markers in a map
    By tirengarfio in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-10-2013, 10:53 AM
  5. plot histogram and also given coordinates
    By ngkj in forum Excel General
    Replies: 0
    Last Post: 06-27-2012, 05:03 AM
  6. Plot 3D Coordinates (x,y,z) on 3D surface Map
    By R_S_6 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-09-2009, 09:15 AM
  7. [SOLVED] Radar Plot using geographical coordinates
    By David in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-31-2005, 04:05 PM

Tags for this Thread

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