+ Reply to Thread
Results 1 to 6 of 6

Triangles and intercepts

  1. #1
    Registered User
    Join Date
    10-09-2019
    Location
    Luton, England
    MS-Off Ver
    365
    Posts
    13

    Triangles and intercepts

    Hi,

    I'm pulling my hair out trying to figure out the math for excel to determine the below. Any help would very appreciated.

    Set Up
    So I have a right angled triangle of say 3 along the bottom, 4 up, and therefor 5 along the hypthoneus. Form the right angle corner created from this triangle, I draw a line at x degrees back to the hypothenuse.

    Question
    Based upon the angle of the vector, what is the x and y co-oridnate of where the line intercepts the hypothenuse.

  2. #2
    Valued Forum Contributor
    Join Date
    07-13-2021
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    513

    Re: Triangles and intercepts

    [.... deleted; based on over-simplified assumptions that were never specified ....]
    Last edited by curiouscat408; 02-13-2023 at 03:56 AM.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,777

    Re: Triangles and intercepts

    Assuming that the right angle vertex is at the origin and the base of the triangle extends into the positive x axis:

    Formula for the new vector is (please don't use x for an angle, it's for an independent variable. Use Greek letters for angles.):
    y = Tan(θ)

    Formula for the hypotenuse is:
    y = -4/3x + 4

    If we set the two expressions equal we can determine the intersection:
    tan(θ) = -4/3x + 4

    Solve for x
    x = -(3/4)*(tan(θ) - 4)

    Now you know x, so you can plug x back into either of the first two equations to solve for y.

    Please disregard this solution and see Croweater's post for a correct solution.

    If you want an implemented Excel solution, please attach an Excel file to show your sample data.
    Last edited by 6StringJazzer; 02-13-2023 at 11:15 AM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Triangles and intercepts

    Assuming the orientation of the triangle is as in post #3, the line will intersect at a point (x,y) such that.

    Tan(θ) = y/x (This is where I disagree with post #3)

    ie. x = y/Tan(θ)
    y = xTan(θ)

    Also (as stated in post#3 above) we know that x and y satisfy the equation of the hypotenuse. ie.

    y = -4x/3 + 4 (Another point I disagree with post#3)

    So we have 2 equations and 2 unknowns. Solve them simultaneously.

    xTan(θ) = -4x/3+4
    x(Tan(θ)+4/3) = 4

    x=4/(Tan(θ)+4/3)

    y = 4Tan(θ)/(Tan(θ)+4/3)
    Attached Files Attached Files
    Last edited by Croweater; 02-13-2023 at 02:33 AM.

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,777

    Re: Triangles and intercepts

    Quote Originally Posted by Croweater View Post
    y = -4x/3 + 4 (Another point I disagree with post#3)
    My notation was poor. I should have written
    -(4/3)x + 4
    which is effectively the same as yours.

    I'll look at the other bit when I get some time, but I think you are correct.

  6. #6
    Registered User
    Join Date
    10-09-2019
    Location
    Luton, England
    MS-Off Ver
    365
    Posts
    13

    Re: Triangles and intercepts

    Thanks for all the responses. I guess some of the problem is not knowing the correct terminology. I've created an image if that helps clear up what I mean, though the above may have offered a solution which I will go through

    Attachment 817546

    so I'm looking to find where on that y axis (green line) the intercept happens based upon the variable of the degree entered, and the length and height of the triangle iteself. I hope that makes more sense, just in case

+ 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. Can I draw triangles using VBA
    By Anthraquinone in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2021, 06:54 PM
  2. Calculating vectors/intercepts
    By kopity in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2017, 08:37 PM
  3. [SOLVED] linear and exponential graphs and x,y intercepts
    By [email protected] in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 11-14-2011, 01:10 AM
  4. Scatter graphs and horizontal line intercepts
    By Notrealbright in forum Excel - New Users/Basics
    Replies: 20
    Last Post: 10-07-2010, 12:02 AM
  5. 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
  6. little green triangles - XL 2003
    By dpenny in forum Excel General
    Replies: 2
    Last Post: 09-30-2005, 04:05 PM
  7. Little Green Triangles.
    By Derrick Fawsitt in forum Excel General
    Replies: 2
    Last Post: 01-12-2005, 02:06 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