Author Topic: Custom report: Pipe piece with fitting on it  (Read 155 times)

0 Members and 1 Guest are viewing this topic.

Offline docTopic starter

  • Senior Member
  • ****
  • Posts: 437
  • Country: us
  • Gender: Male
Custom report: Pipe piece with fitting on it
« on: May 10, 2018, 08:42:48 PM »
We have a four pipe copper system for fan coil units. I assign a piece number to every piece of pipe an a particular floor. I then run an optimized pipe cut list to minimize waste. Can anyone think of a way to create a report that will show what one fitting goes on what one piece of pipe in this optimized list? Currently the shop fabricator takes my list along with all the spool drawings home on the weekend and hand writes in what fitting gets sweat onto what piece of pipe on the optimized list. I have attached a sample of the optimized pipe report that I put together leaving a blank column at the end to write in which fitting goes on that piece of pipe.

Thanks for any help/suggestions ;)

Offline cadbyken

  • Premier Member
  • *****
  • Posts: 4792
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #1 on: May 10, 2018, 10:20:39 PM »
Only thing I can think of is a script.  Pick the two objects then write the field to the pipe.  One little hiccup is you will need to write to an external file to make this work.
Ken Taylor - (Limbach Eng & Design Services, LEDS)
Have you seen any good youtube videos <--- lately? ;)
AutoCAD MEP V16, Fabrication 2016/17/18...Dell Precision 7710 i7-2.70 GHz/32 GB RAM

Offline audiocycle

  • Senior Member
  • ****
  • Posts: 419
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #2 on: May 11, 2018, 12:55:46 PM »
What you are looking for is the nesting report.

https://youtu.be/2D9xo_hvnxo
Barry
Intell(R) Core(TM) i7-3960X CPU @ 3.30GHz /32 GB of RAM
NVIDIA Quadro K5000 / Windows 7 Pro SP 1 /64 bit
Autodesk Building Design Suite Ultimate 2017 / Autodesk Fabrication CADmep 2017

Offline docTopic starter

  • Senior Member
  • ****
  • Posts: 437
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #3 on: May 11, 2018, 01:23:31 PM »
As you can see by my attachment I have the nesting report down. If you look at my attachment there is a blank column at the end that has a heading of FITTINGS. I wanted to know if there was a was to report what fitting goes on that specific piece of pipe on the line item.

Offline Phred

  • Premier Member
  • *****
  • Posts: 537
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #4 on: May 11, 2018, 01:44:29 PM »
we put the unit number in the pallet field and report that. pretty easy to change that property
autocad 2015
fabrication 2015

Offline docTopic starter

  • Senior Member
  • ****
  • Posts: 437
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #5 on: May 11, 2018, 01:45:59 PM »
could you please explain further or show sample phred?

Offline dopefish

  • Full Member
  • ***
  • Posts: 74
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #6 on: May 11, 2018, 04:07:37 PM »
Add an "item filename" or "item product description", depending on how you are sorting you lists, print object on the end there. If the list sorts by spool name then any fitting with the same spool id should report there. You may have to be diligent with your spool tagging. oh and filter out the pipe on that object

Offline docTopic starter

  • Senior Member
  • ****
  • Posts: 437
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #7 on: May 11, 2018, 05:11:39 PM »
I think I understand what your saying here, but there are many pieces of pipe on the same spool. It doesn't seem the report would know what exact fitting goes on what exact piece of pipe setting it up this way. Thank you for the reply

Offline Phred

  • Premier Member
  • *****
  • Posts: 537
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #8 on: May 11, 2018, 07:27:54 PM »
add a column to your report as shown. use the mprop command and select the fittings/pipe in the model and change the "pallet" value to whatever you want. Probably easier ways to do this also.
autocad 2015
fabrication 2015

Offline davidratx

  • Premier Member
  • *****
  • Posts: 1173
  • Country: us
  • Gender: Male
Re: Custom report: Pipe piece with fitting on it
« Reply #9 on: May 11, 2018, 08:49:29 PM »
You could probably use XYZ values of the connector locations to figure out what pieces are connected. You could script the connector location into a custom data field and then use it in your report.
David Ronson
Applied Software Technical Advisor
Windows 10 - Revit - AutoCAD - CADmep - ESTmep - CAMduct