+ Reply to Thread
Results 1 to 11 of 11

Here's a brain twister.. solve for missing distances along and perpendicular to a line

  1. #1
    Registered User
    Join Date
    12-06-2014
    Location
    lockport, ny
    MS-Off Ver
    windows 7
    Posts
    5

    Lightbulb Here's a brain twister.. solve for missing distances along and perpendicular to a line

    See attached,

    Trying to muddle thru this. The concept seems simple enough. Applying the Pythagorean is simple and the distance between (inverse) the known coordinates is good too.

    But my quandary is trying to solve for delta's P and Q along (and perpendicular to) an azimuth direction of a line... See attached sketch..

    Thanks!


    solvepandq.JPG

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,672

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    Row\Col
    A
    B
    C
    D
    E
    F
    1
    x
    y
    2
    Point 1
    2.000
    2.000
    C2:D2: Input
    3
    Unit Direction Vector
    105
    0.966
    -0.259
    C3: =SIN(RADIANS(B3)) D3: =COS(RADIANS(B3))
    4
    Point 2
    5.000
    7.000
    C4:D4: Input
    5
    Point 3
    3.549
    1.585
    C5:D5: {=C2:D2 + SUMPRODUCT(C4:D4-C2:D2, C3:D3) * C3:D3}
    6
    7
    Check perpendicularity
    0.000
    B7: =SUMPRODUCT(C4:D4-C5:D5, C3:D3)
    8
    9
    Delta P
    1.604
    B9: =SQRT(SUMXMY2(C2:D2, C5:D5))
    10
    Delta Q
    5.606
    B10: =SQRT(SUMXMY2(C4:D4, C5:D5))
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    It's a little sloppy - for some reason my worksheet function atan wasn't working so I had to use the atan2 and subtract (Add) 180

    Please Login or Register  to view this content.
    Last edited by xladept; 12-06-2014 at 04:52 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  4. #4
    Registered User
    Join Date
    12-06-2014
    Location
    lockport, ny
    MS-Off Ver
    windows 7
    Posts
    5

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    Thanks for the input so far... Still having a bit of trouble trying to get to this format..

    I'm reporting my delta's in the following format..

    solve p and q.jpg

    So most likely the equation will reside in the delta cells... I think..

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    Hey B,

    Where is the Azimuth angle - or is it always 105??

    in the cell for Delta P value:
    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by xladept; 12-07-2014 at 03:46 PM.

  6. #6
    Registered User
    Join Date
    12-06-2014
    Location
    lockport, ny
    MS-Off Ver
    windows 7
    Posts
    5

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    The Actual Azimuth is 317 degrees 00 minutes 00 seconds

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    With an Azimuth angle of 317 degrees, we get:P=1.610772133 @ 317 degrees and Q=-5.604053497 at 47 degrees - are those the kind of values that you're looking for??

  8. #8
    Registered User
    Join Date
    12-06-2014
    Location
    lockport, ny
    MS-Off Ver
    windows 7
    Posts
    5

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    The values are correct.. 47 being perp to 317...
    That azimuth angle of 317.. Does the equation matter if it is 137? Basically heading in the opposite direction..

  9. #9
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    Yes - the polarities would change

  10. #10
    Registered User
    Join Date
    12-06-2014
    Location
    lockport, ny
    MS-Off Ver
    windows 7
    Posts
    5

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    xladept, I very much appreciate your talent..

    Looks like this will work,but having some difficulty understanding the basic formatting to make this work..

    not afraid to say this is beyond my expertise, but learning as I go.. This function, how do I reside this in the worksheet to make it work?. Ugh.. And for delta q result, do I apply the same?

    ThanksAgain!��

  11. #11
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,379

    Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

    Yes, if you agree with the polarities then:

    Please Login or Register  to view this content.

+ 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] Directional arrow chart with starting perpendicular line?
    By SueWithQuestion in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-29-2013, 08:23 AM
  2. How do I solve for a missing variable?
    By dtevol in forum Excel General
    Replies: 1
    Last Post: 05-27-2008, 01:34 PM
  3. HERE'S A REAL BRAIN TWISTER:
    By greenlion in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-01-2006, 03:00 PM
  4. [SOLVED] Perpendicular distance of a point from linear regression line?
    By Winny in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-24-2005, 08:05 PM
  5. [SOLVED] Perpendicular distance from linear regression line to a point?
    By Winny in forum Excel General
    Replies: 6
    Last Post: 09-21-2005, 07: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