Schedules

[ben]

I'm basically trying to make a schedule for pipe, fittings, accessories, etc. I made a schedule from schedules & quantities instead of material takeoff (only because I couldn't find pipe in the material take off schedule). It took some tinkering to get it this far, but I made the Schedule with the following fields - Family & Type (hidden), Alternate Description II (Just because I was able to make a better description than what was there by default), Size, and Length. Sorting is as fallows - Alternate Description II (header), the Size. Formatting - Length calculate totals. It is pretty close, displayed I have my pipe description, then the size, then the total length of pipe.

I have add-in software that converts the generic pipe & fittings to actual ones so we can spool and prefab. This would be fine if I were converting all the pipe and fittings for prefab, but I am only doing the main trunk line racks. So in my schedule I have my Pipe Descriptions all sorted out nice "Black Iron - Sch 40 - Grooved End", "Type L Copper", etc. The rub is that I still have all of the generic "Pipe Type: Standard" showing up in my schedule. My first thought was to filter out any Family & Type with the word "standard" and that would hide all of the generic pipe, but apparently you cant filter by Family & Type. So, I tried adding the field Type, but it turns out you cant filter by that either. Next, I tried adding the field Material and filtering by that, same song and dance. Then I thought I'd filter by Alternate Description II with "parameter exists" thinking that would hide pipe that didn't have something in the Alternative Description II field, but it didn't do anything.

Side note, with the way I have everything sorted I can actually remove the field Family & Type and it wont change anything, but I left it in there just in case there was a way to use it to filter out the generic Pipe Type: Standard.

I'm quickly learning that in Revit drawing and figuring out the piping is the easy part, it's all the other software stuff that's a pain.

Any help would be greatly appreciated! Thank you!

[ToanDN · Accepted solution]

---

@ben wrote:

Then I thought I'd filter by Alternate Description II with "parameter exists" thinking that would hide pipe that didn't have something in the Alternative Description II field, but it didn't do anything.

---

If the ones you want to filter out have no content in Alternate Description II field then the filter should be if Alternate Description II > 0.  Yes it works even for text field.  By the way, keeping Family/Type as hidden fields to filter and sort is not a bad idea.

[ben]

@ToanDN

That did the trick! Thank you!

The only reason I have Family & Type hidden is because if I turn my list over for ordering and it says "Pipe Types: DI GRV Grinnell (PEX Uponor x DI GRV Grinnell)" the gal that does ordering would hate me because she wouldn't know what the heck I had on my list, its just easier if I use the Alternatite Description II that says "Black Iron - Sch 40 - Grooved End"

[ben]

@ToanDN I have another one for you when it comes to a fitting schedule. The fittings actually have a fairly good and straight forward description under family and type. I don't think I actually need a an Alternate Description, is there a way to filter out Generic: Standard as a Family & Type?

[ToanDN]

Yeah I forgot to mention we cannot filter by Family and/or Type.  I don't understand what drives the limitation though.  Anyways, you would have to use other criteria to filter.  I have been using Type Mark, Description prefix, OMNI Class/Assembly code, or a Yes/No check box, etc... whatever make it easier.