+ Reply to Thread
Results 1 to 5 of 5

Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

  1. #1
    Registered User
    Join Date
    05-01-2015
    Location
    Riyadh
    MS-Off Ver
    iOS
    Posts
    6

    Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

    Helloooo ...


    Can someone kindly direct me ...

    I have 3 points in an x,y,z plane. and I would like to calculate (in degrees) the angle between the 2 lines formed by these.

    Example:

    point A: 3,5,7
    point B: 5,6,1
    point C: 9,9,4

    how can i measure the angle between A-B (line) and B-C (line)?

    or in other words, how to implement calculating angles between vectors in 3-D coordinates in excel?

    Thank you

  2. #2
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

    There's a nice brief explanation of how to calculate here:

    http://www.intmath.com/vectors/7-vec...n-3d-space.php

    What you'll to do in Excel is determine the relative axial differences from the common point to the end points and those values will represent P and Q with vector end points i, j, k as calculated (common point is now relative zero). Then you calculate the dot product of the points divided by the product of the magnitudes and get the arccos of the result.

  3. #3
    Registered User
    Join Date
    05-01-2015
    Location
    Riyadh
    MS-Off Ver
    iOS
    Posts
    6

    Re: Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

    Sounds great.
    Can you kindly help me implement that in an excel function?

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

    See attached...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-01-2015
    Location
    Riyadh
    MS-Off Ver
    iOS
    Posts
    6

    Re: Calculating angles between 2 lines made of 3 points in 3-D (x,y,z)

    THANK YOU SOOOO MUCH.

    Highly appreciated :D

+ 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. Replacing Minus Signs on Angles with N/E/S/W Compass Points
    By Keith360 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2014, 05:35 AM
  2. [SOLVED] Calculate angles and distances from XYZ-points
    By Giake in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-27-2014, 09:23 PM
  3. [SOLVED] Area between weird curves made out of lines (math problem?)
    By dejhantulip in forum Excel General
    Replies: 4
    Last Post: 04-04-2012, 07:07 PM
  4. Calculating info for angles
    By Thenior in forum Excel General
    Replies: 3
    Last Post: 07-01-2008, 11:15 AM
  5. Calculating angles
    By Roo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-23-2007, 07:54 AM

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