Closed Thread
Results 1 to 6 of 6

Length and distance from the line coordinate and point coordinate

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    358

    Length and distance from the line coordinate and point coordinate

    Dear Experts,

    I am trying to find out the distance and length of perpendicular points from line coordinates. I already have an excel file that detects the distance and length of the point but it is a difficult one. It can only know one line from coordinates. This is another way to find out from several coordinates of the line.

    Thank you in advance
    Attached Files Attached Files
    Last edited by sanju2323; 02-25-2019 at 06:32 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,784

    Re: Length and distance from the line

    How does this differ from your post of yesterday, i.e.:

    https://www.excelforum.com/excel-pro...ml#post5071793

    which you had marked as Solved?

    Is this a duplicate thread?

    Pete

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    358

    Re: Length and distance from the line

    Hi pete _UK,
    No, it's not a duplicate thread Both have different requirements You read carefully.

  4. #4
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    358

    Re: Length and distance from the line coordinate and point coordinate

    Is there no solution?

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,478

    Re: Length and distance from the line coordinate and point coordinate

    I'm sure there is a solution -- it is more about understanding your exact requirements and figuring out the desired algorithm.

    Like Pete, I am not sure I understand what is different about this question and the previous one. Can you elaborate? Considering the success of karedog's solution in the other thread, it might be easier to start with his VBA code and adapt it to the new requirements for this question rather than start from scratch.

    It also might be important to know if, like the other thread, you are trying to replicate an AutoCad calculation -- just in case there is something about the AutoCad method that needs to be taken into account.

    If I were starting from scratch on this question, it looks like the question should reduce down to the "distance from a point to a line defined by by two points" formula given by Wikipedia: https://en.wikipedia.org/wiki/Distan..._by_two_points I expect that, if I were starting from scratch, I would start there. The main complication I see beyond the basic formula is that your problem needs to decide which line segment to use. I'm not sure, but I expect that I might use some kind of trial and error algorithm for that.

    Before spending a lot of time exploring this, can you clarify your requirements? Do you understand karedog's solution in the other thread to suggest how it needs to be modified for these requirements? Are there specific parts of this you need help with, or, like with the other thread, do you need someone to develop the entire solution for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    21,150

    Re: Length and distance from the line coordinate and point coordinate

    This thread has been duplicated. Because there are answers in both I am going to close this one. Continue in the newer one which has additional attachments. (I was unable to merge them.)
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] find the X Y coordinate using length and distance.
    By sanju2323 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2019, 04:16 AM
  2. [SOLVED] VBA code to calculate the distance between point and the regression line
    By Lalikos in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-18-2016, 10:25 AM
  3. calculate maximum distance from a line that intersects a curve
    By DRAGOS ROTARU in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-03-2016, 06:01 AM
  4. Replies: 5
    Last Post: 09-23-2015, 08:48 AM
  5. Slope, distance, expeculating next point on a line
    By kaiknux in forum Excel General
    Replies: 1
    Last Post: 01-26-2015, 07:57 AM
  6. shortest distance between a point and a line
    By stockgoblin42 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-04-2013, 02:18 PM
  7. Perpendicular distance of a point from linear regression line?
    By Winny in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 09-24-2005, 08:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1