+ Reply to Thread
Results 1 to 6 of 6

Calculate vertical distance between parallel lines

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Calculate vertical distance between parallel lines

    Hi All,

    Geometry Trigonometry where not my strong subjects at school and that was very very long time ago. no this creates a big problem. I have searched the net and come up blank.

    I'm was going to develop a spread sheet to automatically calculate the vertical distance between to parallel lines on a variety of slopes. I all ways have two known distances. The slop given as rise over run and the perpendicular distance between the lines.

    I would like to be able to input the two known distances, display the result in some graph showing the lines and there distances, that could be printed out.

    This is beyond me but may be simple for the gurus of Excel

    thanks in advance

  2. #2
    Valued Forum Contributor
    Join Date
    01-03-2016
    Location
    Conwy, Wales
    MS-Off Ver
    2016
    Posts
    974

    Re: Calculate vertical distance between parallel lines

    think Pythagoras can help here

    Pythagoras.jpg

    Hill.jpg
    If a response has helped then please consider rating it by clicking on *Add Reputation below the post
    When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)

  3. #3
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Calculate vertical distance between parallel lines

    vertical = perpendicular / SIN(90 degrees - TANH(slope))

    see attached for how I worked it out.
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  4. #4
    Registered User
    Join Date
    02-06-2013
    Location
    australia
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Calculate vertical distance between parallel lines

    wow Ben legend thanks brilliant awesome thanks heaps

  5. #5
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: Calculate vertical distance between parallel lines

    You may want to work on your uses of to, too, and two and there, their, and they're while you're working on your geometry.

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,747

    Re: Calculate vertical distance between parallel lines

    Cdubisms, please stick to answering the question.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to draw known didtance between parallel lines.
    By davesexcel in forum Excel General
    Replies: 5
    Last Post: 11-05-2014, 09:27 PM
  2. [SOLVED] Find Matching Parallel Lines, no matter how many.
    By stockgoblin42 in forum Excel General
    Replies: 12
    Last Post: 05-21-2013, 02:52 PM
  3. Calculate distance
    By mukesh mishra in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2013, 06:23 AM
  4. Comparing dates found on two lines an unknown distance apart
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-14-2010, 05:13 PM
  5. Vertical Lines?
    By webPragmatist in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-12-2008, 01:45 PM
  6. Replies: 3
    Last Post: 03-03-2006, 12:20 AM
  7. [SOLVED] calculate time/distance
    By KJO in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-20-2005, 05:06 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