How to find intersection points between lines using Excel?

[Guest]

I need to find out intersection point between few (100 to be exact) parallel
lines with a another line. How could I program this using excel so that i can
view both X and Y coordinates in different column??

thanks

 

[Guest]

find the intersection of the topmost line, then it is just a matter of
adjusting for the distance between the parallel lines and the angle of
intersection.

Probably could be done with worksheet formulas, but you provide no
information.

 

[Guest]

sorry for not providing the other infor mation but i am a beginner at using
excel sheet..it would be really helpful if you could elaborate on this..what
if i need to find out intersection points between lines of different slope
with one line...
thanks

 

[Guest]

Assume the topmost or one of the 100 lines is

Y = 3X + 5

and the intersecting line is

Y = -6X - 10

then
3x + 5 = -6X - 10

9x = -15
x = -15/9
x = -3/5


substituting in to the first equation

y = 3 * (-3/5) + 5 = 0

So the equations for the parallel lines are just going to vary by the Y
intercept.

but the general form will be

x = (-5 - YIntercept)/ 9
and for y:

y = 3x - YIntercept
so
y = 3[(-5 - YIntercept)/9] + YIntercept

so you can use these to build your solutions.