line intersection (this is a hard one.)
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: line intersection (this is a hard one.)

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have two lines, one is a straight line which I can easily develope an equation for, the other is an irregular curved line that I only have data points for. How do I automatically determine the value where they meet?


  2. #2
    MrExcel MVP Damon Ostrander's Avatar
    Join Date
    Feb 2002
    Location
    Denver, Colorado USA
    Posts
    4,240
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Dhussar,

    There are many ways to do this. Which way depends on your problem and needs. First, how accurate does the solution have to be? How close together and how "curved" is the curve. If close together or not very curved then very simple linear interpolation between points would probably be appropriate. If the curve is represented by sparse points or has a lot of curvature then the best way would probably be to curve fit and equation, probably a polynomial power series, to the points in the vicinity of the intersection, and solve the two equations simultaneously to find the intersection.

    Another factor that must be considered is whether the data of the curve is "noisy", e.g., did it come from measurements that contain measurement error? If so a least-squares curve fitting method is appropriate since it allows the errors to exist but minimizes their effects.

    Perhaps if you could describe your problem in a bit more detail, I could make more specific recommendations, and even propose a specific algorithm or code.
    Keep Excelling.

    Damon

    VBAexpert Excel Consulting
    LinkedIn Profile http://www.linkedin.com/pub/damon-ostrander/7/79/a93
    AllExperts Profile http://www.allexperts.com/ep/1059-30...-Ostrander.htm

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I sent a private message to you but not sure if you got it. Anyway, I'm trying to find the yield point of a tensile test. The graph starts flat, increases rapidly in a linear fasion, flatnes out with a slight increase, and then drops back to zero. The yield point is defined as the point where a straight line offset from this linear portion by .2% crosses the point where the graph flatens. I don't know if this is much help, its a lot to say in the limited space. The data looks something like this:
    y x
    1 .01
    2 .02
    2 .03
    5 .04
    10 .05
    15 .06
    20 .07
    25 .08
    26 .09
    27 .1
    28 .11
    4 .12
    2 .13
    1 .14
    0 .15

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com