+ Reply to Thread
Results 1 to 5 of 5

Calculating vectors/intercepts

  1. #1
    Registered User
    Join Date
    05-07-2017
    Location
    Western Australia
    MS-Off Ver
    2011
    Posts
    6

    Calculating vectors/intercepts

    Hi all, hoping there is a trig/geometry/intercept function that could solve this problem? Or maybe I need to graph it somehow and measure the intercept?

    All I know how to do right now is draw it with a ruler, compass and protractor and measure, not so accurate!
    I know there's a 90 degree angle in there so possibly it simplifies the problem (?) , but it won't always be 90 degrees as I have future problems to solve with whatever solution I can develop.

    Any ideas greatly appreciated!
    Thanks

    (NOT DRAWN TO SCALE)
    Attached Images Attached Images
    Last edited by kopity; 05-07-2017 at 07:15 AM. Reason: last line to show diagram not to scale

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,224

    Re: Calculating vectors/intercepts

    There is no built in function for solving these things. As you suggest, this is first a trig problem before it really becomes a programming problem. Here's what I see:

    1) With AB and AW known, I know everything there is to know about right triangle ABW (not drawn) -- including length BW.
    2) With BW, CW, and angle B known, I can solve for BC using the law of cosines: https://en.wikipedia.org/wiki/Law_of_cosines Note that you will likely need the quadratic formula (https://en.wikipedia.org/wiki/Quadratic_equation ) to solve for BC.

    That's how I would probably solve this, though note that I have note yet found the intersection between AB and CW. If that is an important part of the overall problem, then further application of the law of cosines and other trig functions should allow you to solve for that point.

    One important thing to note -- you have you angles written in degrees. Note that Excel's built in trig functions (like other programming languages) use angles in radians. As a mathematician, I might suggest that it is often easier to learn radians and become comfortable expressing angles in radians rather than degrees. Until you are comfortable with radians, you must recognize that there are "convert degrees to radians" and "convert radians to degrees" steps whenever you are working with trig functions.
    Last edited by MrShorty; 05-07-2017 at 09:35 AM.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,805

    Re: Calculating vectors/intercepts

    Hi kopity and welcome to the forum,

    Put you problem on a X,Y Cartesian coordinate system, with A being at (0,0).

    You have two circles in your problem. Look for the equations for those circles using the standard form of circles equations and solve where they intersect. The angle at point B has nothing to do with this problem.

    http://www.mathwarehouse.com/geometr...f-a-circle.php

    Try solving:
    (x+75)^2 + y^2 = 75^2 and
    x^2 + (y+25)^2 = 140^2

    Then find the distance between the correct intersection of the two circles and point (-75,0).
    Last edited by MarvinP; 05-07-2017 at 10:29 AM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    05-07-2017
    Location
    Western Australia
    MS-Off Ver
    2011
    Posts
    6
    Quote Originally Posted by MrShorty View Post
    There is no built in function for solving these things. As you suggest, this is first a trig problem before it really becomes a programming problem. Here's what I see:

    1) With AB and AW known, I know everything there is to know about right triangle ABW (not drawn) -- including length BW.
    2) With BW, CW, and angle B known, I can solve for BC using the law of cosines: https://en.wikipedia.org/wiki/Law_of_cosines Note that you will likely need the quadratic formula (https://en.wikipedia.org/wiki/Quadratic_equation ) to solve for BC.

    That's how I would probably solve this, though note that I have note yet found the intersection between AB and CW. If that is an important part of the overall problem, then further application of the law of cosines and other trig functions should allow you to solve for that point.

    One important thing to note -- you have you angles written in degrees. Note that Excel's built in trig functions (like other programming languages) use angles in radians. As a mathematician, I might suggest that it is often easier to learn radians and become comfortable expressing angles in radians rather than degrees. Until you are comfortable with radians, you must recognize that there are "convert degrees to radians" and "convert radians to degrees" steps whenever you are working with trig functions.
    Thanks! Yes, I don't know why I didn't pick up that I could calculate CW length and calculate CB length that way! And yes, I've already figured out the radians thing in excel! I'm very unfamiliar with rads. I've worked out how to make the conversion but it's just a funny number to me. I will look into it thanks

  5. #5
    Registered User
    Join Date
    05-07-2017
    Location
    Western Australia
    MS-Off Ver
    2011
    Posts
    6
    Quote Originally Posted by MarvinP View Post
    Hi kopity and welcome to the forum,

    Put you problem on a X,Y Cartesian coordinate system, with A being at (0,0).

    You have two circles in your problem. Look for the equations for those circles using the standard form of circles equations and solve where they intersect. The angle at point B has nothing to do with this problem.

    http://www.mathwarehouse.com/geometr...f-a-circle.php

    Try solving:
    (x+75)^2 + y^2 = 75^2 and
    x^2 + (y+25)^2 = 140^2

    Then find the distance between the correct intersection of the two circles and point (-75,0).
    Thanks for you reply!

+ 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. Vectors
    By scientist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-14-2014, 10:38 AM
  2. calculating cross product using two vectors A and B
    By tjsdndnjs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-16-2012, 04:19 AM
  3. A little help with vectors?
    By bbbbates in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 02-22-2012, 04:41 PM
  4. linear and exponential graphs and x,y intercepts
    By Mozam.ali@asterand.com in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-14-2011, 01:10 AM
  5. Scatter graphs and horizontal line intercepts
    By Notrealbright in forum Excel - New Users/Basics
    Replies: 20
    Last Post: 10-07-2010, 12:02 AM
  6. Calculate multiple x intercepts in a line graph
    By jhabel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-23-2009, 02:05 PM
  7. Vectors on Charts
    By Wyvern in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-21-2005, 08:45 PM
  8. [SOLVED] adding vectors.. help on how
    By Ralph2 in forum Excel General
    Replies: 1
    Last Post: 11-01-2005, 10:05 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