Author Topic: Designline length  (Read 1678 times)

0 Members and 1 Guest are viewing this topic.

Offline piper1Topic starter

  • Full Member
  • ***
  • Posts: 51
  • Country: us
  • Gender: Male
Designline length
« on: Jan 18, 2021, 21:14:46 PM »
Hello all,

Is there a way to find the aggregate length of all the segments of a designline?

Thanks!
Eric Fox

Offline cadbyken

  • Premier Member
  • *****
  • Posts: 5297
  • Country: us
  • Gender: Male
Re: Designline length
« Reply #1 on: Jan 18, 2021, 22:52:04 PM »
Not that I can think of but you could run a simple report after the designline is filled
Ken Taylor - Atlantic Constructors, Inc
BIM Technology & Database Manager
Revit - not ready for Primetime given all of the add-ons, work arounds, and general issues with Fabrication in Revit.  Tired of them taking our money for little results.

Offline dopefish

  • Senior Member
  • ****
  • Posts: 411
  • Country: us
  • Gender: Male
Re: Designline length
« Reply #2 on: Jan 19, 2021, 17:50:15 PM »
https://forums.autodesk.com/t5/autocad-forum/how-to-calculate-the-total-length-of-multiple-lines/m-p/5120604

So I have had to do this as well. I copy the designline and explode it an then run on of the lisp routines listed above.
"And the wood header is still 4  3/4" on top of the top of the double top plate." . . . Random VDC Coodinator

I love coordination

Offline Steadtler

  • Full Member
  • ***
  • Posts: 57
  • Country: us
  • Gender: Male
Re: Designline length
« Reply #3 on: Jan 20, 2021, 01:37:11 AM »
If you have access to a spreadsheet like EXCEL, use the following steps:
1.Draw your design line.
2. In the Design Line Dialog, Select View then select Calculate Pressure Drop.  Change the settings to only use Section and Length.  Section is needed to ensure uniqueness of each section in the event more than one section has the same length.Erase the blank and header row.
3. Select the Export Data located at the lower left corner of the dialog box. Your text editor should appear with all of the sections and length data. Save the text file.
4. Open EXCEL and import the text file data into a formatted table (later editions of EXCEL).  Be sure to check the Total Row checkbox located in the Design Tab.
5.  In the Design Tab select Remove Duplicates to eliminate all duplicates from the table (this is why the Section column is needed).
6. Read the total length from the bottom row.

If you need a breakout for different pipe sizes, add the Eff. Diam. column.
The advantage of this method is no copy/paste/explode/lisp is required, the data is retained in a file, and EXCEL operations could be handled using a VBA routine.

Here is a link to a short video (no audio) showing this method. https://youtu.be/9QvxL2bvGRk
« Last Edit: Jan 20, 2021, 02:57:11 AM by Steadtler »

Offline piper1Topic starter

  • Full Member
  • ***
  • Posts: 51
  • Country: us
  • Gender: Male
Re: Designline length
« Reply #4 on: Jan 20, 2021, 14:24:55 PM »
Thanks for the replies guys.  All good info.  Sometimes a simple question gains you a lot of valuable information.
Eric Fox

Offline cnash

  • Premier Member
  • *****
  • Posts: 1383
  • Country: us
  • Gender: Male
    • William R. Nash Companies
Re: Designline length
« Reply #5 on: Jan 20, 2021, 14:46:14 PM »
If you have access to a spreadsheet like EXCEL, use the following steps:
1.Draw your design line.
2. In the Design Line Dialog, Select View then select Calculate Pressure Drop.  Change the settings to only use Section and Length.  Section is needed to ensure uniqueness of each section in the event more than one section has the same length.Erase the blank and header row.
3. Select the Export Data located at the lower left corner of the dialog box. Your text editor should appear with all of the sections and length data. Save the text file.
4. Open EXCEL and import the text file data into a formatted table (later editions of EXCEL).  Be sure to check the Total Row checkbox located in the Design Tab.
5.  In the Design Tab select Remove Duplicates to eliminate all duplicates from the table (this is why the Section column is needed).
6. Read the total length from the bottom row.

If you need a breakout for different pipe sizes, add the Eff. Diam. column.
The advantage of this method is no copy/paste/explode/lisp is required, the data is retained in a file, and EXCEL operations could be handled using a VBA routine.

Here is a link to a short video (no audio) showing this method. https://youtu.be/9QvxL2bvGRk

This is a great use of that tool, never even thought about that! Kudos!
Christopher Nash
Operations Software & Process Manager
William R. Nash, LLC.