Formula to draw known didtance between parallel lines.

[davesexcel]

Hello, I need a geometry expert.
I need to draw an unknown parallel line exactly 11 from a known line.

Please see attached. So once the second line is drawn, the distance between the two will be 11.

If you can get it going on the chart, maybe take a look at the VBA code as well.

Thanks alot.

[Punnam]

davesexcel

Explain me in more detail
Check the attached file , i am not sure just tried

Punnam

[davesexcel]

Thanks Punnam,

You just added 11 to the x column, I need the parallel line to be 11 from the original.

hmm...
does anybody remember the formula
something like

Please Login or Register  to view this content.

it's been so long.

[shg]

Via formula?

Row\Col	A	B	C	D
1		x	y
2	point1	0.000	0.000	B2:C3: Input
3	point 2	0.500	2.000
4
5		angle	distance
6		(90.000)	11.000	B6:C6: Input
7
8	matrix	0.000	(5.336)	B8:C9: {=C6/SQRT(SUMSQ(B3:C3-B2:C2)) * CHOOSE({1,2;3,4}, COS(RADIANS($B$6)), SIN(RADIANS($B$6)), -SIN(RADIANS($B$6)),COS(RADIANS($B$6)))}
9		5.336	0.000
10
11	par point1	10.672	(2.668)	B11:C11: {=MMULT(B3:C3 - B2:C2, B8:C9)}
12	par point2	11.172	(0.668)	B12:C12: {=B11:C11 + B3:C3 - B2:C2}

B8:C9 calculates a rotation and scaling matrix. That's applied to the vector from point1 to point2 to get a point on the parallel line (B11:C11). A second point of the line is calculated by adding the direction vector from the first line.

[davesexcel]

Right on thanks.

[shg]

You're welcome.