Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

Hi,

What information do you have about the curve? Radius, diameter, start
angle, finish angle etc?
And what is an irregular line?

I don't yet know the math required to calculate intersections between
curves and lines but google can help with that. It should then be a case
of creating formula and or VBA code.

Cheers
Andy

Geminist wrote:
Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Andy,

The irregular line is the same with the line shown in your website.

I have made a crude sketch here which may be of help.

http://img217.imageshack.us/img217/6937/untitled3tb.jpg

The radius/coordinaate of the semi circle will always remain the same
throughout. The semi circle will never go lower than -ve Y axis. Which
means is starts on the -ve side of X axis and terminates at +ve side of the X
axis, forming a 180 deg semi circle.

What I am trying to do is, the user will put in coordinates to draw the
irregular line while the semi circle will remain unchanged. Excel will then
find out all the coordinates where the line intersects with any of the semi
circle.

The semi circle will always be centered in the point of origin on the axis.

Hopefully this helps, thanks again.

"Andy Pope" wrote:

Hi,

What information do you have about the curve? Radius, diameter, start
angle, finish angle etc?
And what is an irregular line?

I don't yet know the math required to calculate intersections between
curves and lines but google can help with that. It should then be a case
of creating formula and or VBA code.

Cheers
Andy

Geminist wrote:
Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi Andy,

I missed something in the previous post.

I don't think I woul have problem solving this by hand. I'm having trouble
because although the equation for semi circle will remain the same, the
linear equation for the lines will change. Even though the basic form is y =
mx + c, I can't think of much way to do this over at VBA or Excel because to
find the intersection between the line and the curves, we'll need to solve
the equation of the semi circle and the lines.

Although I love the challenge over VBA, I am still a beginner and I can't
think of how to make excel derive an equation for the lines each time (as
they change coordinates based on what the user put in) and make excel derive
the equation between the line/curve.

Thanks for your help !

"Geminist" wrote:

Hi Andy,

The irregular line is the same with the line shown in your website.

I have made a crude sketch here which may be of help.

http://img217.imageshack.us/img217/6937/untitled3tb.jpg

The radius/coordinaate of the semi circle will always remain the same
throughout. The semi circle will never go lower than -ve Y axis. Which
means is starts on the -ve side of X axis and terminates at +ve side of the X
axis, forming a 180 deg semi circle.

What I am trying to do is, the user will put in coordinates to draw the
irregular line while the semi circle will remain unchanged. Excel will then
find out all the coordinates where the line intersects with any of the semi
circle.

The semi circle will always be centered in the point of origin on the axis.

Hopefully this helps, thanks again.

"Andy Pope" wrote:

Hi,

What information do you have about the curve? Radius, diameter, start
angle, finish angle etc?
And what is an irregular line?

I don't yet know the math required to calculate intersections between
curves and lines but google can help with that. It should then be a case
of creating formula and or VBA code.

Cheers
Andy

Geminist wrote:
Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Hi,

I have added a page to mu site providing a couple of udf's to return
intersect points between line and circle and circle and circle.
http://www.andypope.info/charts/linecircleintersect.htm

For you specific example see this file.
http://www.andypope.info/ngs/ng56.htm

Cheers
Andy

Geminist wrote:
Hi Andy,

I missed something in the previous post.

I don't think I woul have problem solving this by hand. I'm having trouble
because although the equation for semi circle will remain the same, the
linear equation for the lines will change. Even though the basic form is y =
mx + c, I can't think of much way to do this over at VBA or Excel because to
find the intersection between the line and the curves, we'll need to solve
the equation of the semi circle and the lines.

Although I love the challenge over VBA, I am still a beginner and I can't
think of how to make excel derive an equation for the lines each time (as
they change coordinates based on what the user put in) and make excel derive
the equation between the line/curve.

Thanks for your help !

"Geminist" wrote:


Hi Andy,

The irregular line is the same with the line shown in your website.

I have made a crude sketch here which may be of help.

http://img217.imageshack.us/img217/6937/untitled3tb.jpg

The radius/coordinaate of the semi circle will always remain the same
throughout. The semi circle will never go lower than -ve Y axis. Which
means is starts on the -ve side of X axis and terminates at +ve side of the X
axis, forming a 180 deg semi circle.

What I am trying to do is, the user will put in coordinates to draw the
irregular line while the semi circle will remain unchanged. Excel will then
find out all the coordinates where the line intersects with any of the semi
circle.

The semi circle will always be centered in the point of origin on the axis.

Hopefully this helps, thanks again.

"Andy Pope" wrote:


Hi,

What information do you have about the curve? Radius, diameter, start
angle, finish angle etc?
And what is an irregular line?

I don't yet know the math required to calculate intersections between
curves and lines but google can help with that. It should then be a case
of creating formula and or VBA code.

Cheers
Andy

Geminist wrote:

Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy

I must say, thank you very much for your help. I really appreciate it.

I will have a look at it now, thank you once again.

"Andy Pope" wrote:

Hi,

I have added a page to mu site providing a couple of udf's to return
intersect points between line and circle and circle and circle.
http://www.andypope.info/charts/linecircleintersect.htm

For you specific example see this file.
http://www.andypope.info/ngs/ng56.htm

Cheers
Andy

Geminist wrote:
Hi Andy,

I missed something in the previous post.

I don't think I woul have problem solving this by hand. I'm having trouble
because although the equation for semi circle will remain the same, the
linear equation for the lines will change. Even though the basic form is y =
mx + c, I can't think of much way to do this over at VBA or Excel because to
find the intersection between the line and the curves, we'll need to solve
the equation of the semi circle and the lines.

Although I love the challenge over VBA, I am still a beginner and I can't
think of how to make excel derive an equation for the lines each time (as
they change coordinates based on what the user put in) and make excel derive
the equation between the line/curve.

Thanks for your help !

"Geminist" wrote:


Hi Andy,

The irregular line is the same with the line shown in your website.

I have made a crude sketch here which may be of help.

http://img217.imageshack.us/img217/6937/untitled3tb.jpg

The radius/coordinaate of the semi circle will always remain the same
throughout. The semi circle will never go lower than -ve Y axis. Which
means is starts on the -ve side of X axis and terminates at +ve side of the X
axis, forming a 180 deg semi circle.

What I am trying to do is, the user will put in coordinates to draw the
irregular line while the semi circle will remain unchanged. Excel will then
find out all the coordinates where the line intersects with any of the semi
circle.

The semi circle will always be centered in the point of origin on the axis.

Hopefully this helps, thanks again.

"Andy Pope" wrote:


Hi,

What information do you have about the curve? Radius, diameter, start
angle, finish angle etc?
And what is an irregular line?

I don't yet know the math required to calculate intersections between
curves and lines but google can help with that. It should then be a case
of creating formula and or VBA code.

Cheers
Andy

Geminist wrote:

Hi there,

I have a few (approximately 5) semi circle curve and an irregular line that
cuts across these curves.

I am trying to find the points (x,y) where this line intersects with the
curves. This means that whenever the line intersects on any of the curves, a
point (x,y) where the line and the curves intersects will be returned.

http://www.andypope.info/charts/intersection.htm

I had a look on the above website and it does show that you can achieve this
with excel. My problem is, I'm dealing with a few curves and not just two
lines.

If this helps, the curve will always have the same coordinate (it will
always be the same shape at the same points). Only the irregular line will
change as this is what the user input.

I'm still looking around for an answer and I'm sure someone here will be
able to help me with my problem.

Thank you very much.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info