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

1. ## 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. ## 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))

3. ## 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.``

4. ## 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. ## 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.``

6. ## 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. ## 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. ## 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. ## Re: Here's a brain twister.. solve for missing distances along and perpendicular to a lin

Yes - the polarities would change

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

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. ## 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.``

There are currently 1 users browsing this thread. (0 members and 1 guests)