Hello Excel Masters,
I am trying to find a clever way to find exactly what x and y distance from an original location that I would be 100' from a line.
I would greatly appreciate help, I have points every ~100 feet but I would like to come up with a way to easily paste the x and y's and have excel interpolate between points to find where i am 100' from the line.
Thank you,
Strother
Line Calculator.xlsx
Please put your desired answer or speak something more understandable.......
How much of this is a math question, and how much of it is Excel?
I find that I must first understand the math part of the problem before I can figure out how to program it into Excel (or any other programming language). With that in mind, I would first suggest a reference such as https://en.wikipedia.org/wiki/Distan...oint_to_a_line Your file shows x,y coordinates (in what units??) and slope and interecept parameters for a line (in what units???). Once you know exactly what those values mean, it should be as easy as applying the formula given in wikipedia [=abs(ax+by+c)/sqrt(sumsq(a,b))] to each point, then analyzing that "helper column" to determine where the 100 ft distance would be.
Originally Posted by shg
Your scaling seems inappropriate. Your original coordinates are in the millions, but your table data runs up only to 7000 or so.
Whatever distances you calculate are going to be much much larger than 100'.
Hi
I think something is wrong because the smallest distance is 1071005.8
see the attached file.
regards
Hi again
I used this formula for distance of point from line.
Line Equation : ax+by+c=0
Point (x0,y0)
distance=abs(a*x0+b*y0+c)/sqrt(a^2+b^2)
regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks