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

**bsurveyor33** · 12-06-2014, 02:16 PM

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

**shg** · 12-06-2014, 04:13 PM

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))

**xladept** · 12-06-2014, 04:48 PM

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.

**bsurveyor33** · 12-06-2014, 11:44 PM

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

**xladept** · 12-07-2014, 03:32 PM

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.

**bsurveyor33** · 12-08-2014, 05:53 PM

The Actual Azimuth is 317 degrees 00 minutes 00 seconds

**xladept** · 12-08-2014, 07:16 PM

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??

**bsurveyor33** · 12-08-2014, 09:57 PM

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

**xladept** · 12-09-2014, 12:06 AM

Yes - the polarities would change

**bsurveyor33** · 12-09-2014, 10:19 PM

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!��

**xladept** · 12-10-2014, 01:32 AM

Yes, if you agree with the polarities then:

Please Login or Register  to view this content.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Directional arrow chart with starting perpendicular line?

How do I solve for a missing variable?

HERE'S A REAL BRAIN TWISTER:

Perpendicular distance of a point from linear regression line?

Perpendicular distance from linear regression line to a point?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions