I have been queried a few times in the last week on the ability of Revit to schedule our hydraulic models, so I’ve quickly written up this short guide on how to make it work. It is really quite powerful and an easy process to undertake, provided you have modelled everything correctly, with less than 10 minutes of configuration, Revit can do instantly what it may have taken a few hours or even days to undertake manually.

Our hydraulic template is setup to schedule a few basic items out of the box, in fact to make this work, only a single additional parameter which we normally utilise for tagging was used to separate between each individual service. A good example of what can be quickly scheduled is pipe lengths. This is a quick run through on how to make scheduling work quickly. It can be applied to many other items as well.

I also decided to write this guide as simply as possible, the intention being that within our company, even non-Revit users would understand. The reason being is I often hear around the office “Oh but it’s so hard to make Revit do this…”

In Revit, under analyze, select schedules/quantities

Select piping schedule and new construction

Add the parameters you want. In this instance, I used the H_SERVICE_HOR parameter as previously mentioned to filter by service. This way it will list the services in an easy to follow manner.

Select the sorting order as Service -> Size-> Length

Format the fields as you want it to appear. The only one you should really have to change is length as the default measurement is in millimetres.

Change to metres.

And admire the results. In this case the results did not appear correctly due to the pipework not being configured properly (whoever made this template needs a clip around the ears)

Don’t stress though, there is an easy way to fix this. Check the pipe settings within the project by selecting properties on the pipe type in the project browser.

The problem was that the H_SERVICE_HOR parameter was empty. Fill it out by using the drop-down box of template presets.

Now marvel at the updated schedule. But we used different materials.. no worries, we can modify the schedule to break down the results further.

In the schedule properties, click the ‘Edit…’ button next to the ‘Fields’ parameter

Add the material to the list, use the ‘Move Up’ button to place the material parameter as the second on the list so that your hierarchy is now AUR_H_SERVICE_HOR -> Material -> Size -> Length

The finished results – now you can use in your pricing spreadsheet. Quantity counts that would have taken a day or more just took 10mins and now that it is setup, it will automatically update as you develop your model.

You can further apply this to create schedules on a per level basis by creating multiple schedules and splitting the schedule down further using additional parameters. For example, you can show how much pipework, plumbing fixture counts, sprinkler head counts or any other variety of configuration on each drawing for each service.