+ Reply to Thread
Results 1 to 1 of 1

Intersection of 2 3D Vectors using equation of line

  1. #1
    Registered User
    Join Date
    10-24-2012
    Location
    Adelaide
    MS-Off Ver
    Excel 2019
    Posts
    79

    Intersection of 2 3D Vectors using equation of line

    G'day Excel forum

    I'm trying to calculate the coordinates of the intersection of two vectors using the slope and Yint of each coupled with the Easting, Northing and Elevation data, however i can't seem to get the correct Northing.

    Would anyone out there be able to tell me where I've gone wrong in the attached spreadsheet? Ive highlighted the issue in pale blue, on each row in the sheet there is a combination of 2 vectors and the associated data for that combination (including slope and y int), I have been able to calculate the Elevation and Easting with ease however the Northing doesn't seem to be working.

    P.S. I'm really up the creek on this one, it has been the bane of my existence for quite some time now so any help would be awesome, cheers
    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] Get Point intersection between vertical plane ('ZY') and 3d line
    By thomasaxn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 09:41 AM
  2. [SOLVED] Rounding Vectors based on length of line
    By JTHOM in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2012, 07:48 PM
  3. shading above/below intersection areas in line chart
    By BigL76 in forum Excel General
    Replies: 2
    Last Post: 07-05-2010, 11:46 AM
  4. Add vertical line at intersection of 2 curves
    By LeAnne in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-28-2006, 05:00 PM
  5. [SOLVED] who to make intersection between two line?
    By g in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-24-2005, 07:30 AM

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