topic Re: Schedule of pipe slope in Revit MEP Forum

Schedule of pipe slope

arqyt — Sun, 04 Sep 2016 06:16:00 GMT

Can you get a schedule table that indicate pipe slope?
Apparently it seems not.
I am perplexed

Re: Schedule of pipe slope

Revit_Whisperer — Tue, 06 Sep 2016 14:11:43 GMT

The system slope parameter is not something that is available in the schedule fields natively in Revit. There is a tool that will allow you to pull the information from system parameters into a parameter you create in the project. I use the IMAGINiT Revit Utilities, there may be others that can do something similar.

I did a quick video on the process.

http://screencast.com/t/cxkjIxvA

Re: Schedule of pipe slope

arqyt — Wed, 07 Sep 2016 09:31:58 GMT

OLE!!!
Magnifico plugin, Whisperer
Thank you very much for your invaluable help

Re: Schedule of pipe slope

Revit_Whisperer — Wed, 07 Sep 2016 12:01:27 GMT

Happy to help =)!

Sherry

Re: Schedule of pipe slope

Anonymous — Wed, 16 Jan 2019 12:18:38 GMT

@Revit_Whisperer wrote:

The system slope parameter is not something that is available in the schedule fields natively in Revit. There is a tool that will allow you to pull the information from system parameters into a parameter you create in the project. I use the IMAGINiT Revit Utilities, there may be others that can do something similar.

I did a quick video on the process.

http://screencast.com/t/cxkjIxvA

Could you please reshare the video? I can not open this one.

Thank you.

Miguel

Re: Schedule of pipe slope

brownbr2VHQE — Thu, 21 Jul 2022 17:28:46 GMT

Realizing this is a old post, but I have a possible solution. Also this is my first reply on the forum.
A solution I found for scheduling the pipe angle (Slope) is to create a calculated field using the following formula;

asin((Top - Bottom) / (sqrt(Length ^ 2 + (2 * ((Outside Diameter * Length) / 2) / Length) ^ 2))) - asin(Outside Diameter / (sqrt(Length ^ 2 + (2 * ((Outside Diameter * Length) / 2) / Length) ^ 2)))

This formula uses the top elevation, bottom elevation, pipe outside diameter and length to figure the angle of the pipe (top-most corner to bottom-most corner) and then subtracts that from the angle of the pipe to a flat plane level with the bottom most point of the pipe. It could be refined a bit as vertical pipe simply returns an extreme angle, I plan on adding a logical iff to return a set value for vertical pipe and exclude it. You could also create another field identifying a pipe section as horizontal, vertical, or slope. It could also be refined to return a typical slope value instead of an angle if one wished.

Re: Schedule of pipe slope

casquatch — Thu, 02 Feb 2023 19:42:06 GMT

@brownbr2VHQE - This is beautiful! I added a bit to it on our end to show the value of the slope in length (first half of the slope ratio). I thought this would be more useful for our users to see it this way rather than the angle.

Note: this calculated value must be setup as a Length, where yours required it to be an Angle.

tan(asin((Top Elevation - Bottom Elevation) / (sqrt(Length ^ 2 + (2 * ((Outside Diameter * Length) / 2) / Length) ^ 2))) - asin(Outside Diameter / (sqrt(Length ^ 2 + (2 * ((Outside Diameter * Length) / 2) / Length) ^ 2))))*12"

So if your angle was 1.19, the value for the length would end up being 1/4", then it's assumed per 12".

Thanks again! Good stuff 🙂

Re: Schedule of pipe slope

WheelerCJ — Wed, 15 Feb 2023 12:08:22 GMT

Thanks for this. It says top and bottom elevation is not a valid schedule field, interested to know how you made this work.

Re: Schedule of pipe slope

brownbr2VHQE — Wed, 15 Feb 2023 12:39:49 GMT

I think he added the "elevation" for clarity. The field/parameter is simply "Top" and "Bottom" in a MEP Pipework Schedule.

Re: Schedule of pipe slope

casquatch — Wed, 15 Feb 2023 14:17:24 GMT

No, I actually pulled those direct from the pre-defined schedule fields for the formula. I'm wondering if it's a version issue and things have changed? I was in 2022, are you in a previous version?

Re: Schedule of pipe slope

brownbr2VHQE — Wed, 15 Feb 2023 14:22:06 GMT

I was probably in '20 when I initially posted that, however I happen to have '22 open right now and I just checked and I still show "Top" and "Bottom" in my '22 for a MEP Pipework schedule so very interesting yours is different.

Re: Schedule of pipe slope

casquatch — Wed, 15 Feb 2023 14:26:38 GMT

Yes. Odd indeed. I wondered the same thing when I saw the initial formula, but just assumed it was an older version.

Here's a snip of things in action on my system. This is in Revit 2022.1.3

Re: Schedule of pipe slope

brownbr2VHQE — Wed, 15 Feb 2023 14:37:16 GMT

So yeah that is why, yours is a Pipe Schedule, we work with Fabrication Parts so mine is a MEP Fabrication Pipework schedule. It is nice to know it can work for either though with that minor change. I am guessing maybe WheelerCJ is in Fabrication as well and hopefully he see this and can make that adjustment. Thank you by the way for improving the original, I got sidetracked and never improved upon my version after the initial post.

Re: Schedule of pipe slope

casquatch — Wed, 15 Feb 2023 14:44:04 GMT

Fab parts was another thought I just had too, I figured you would pick up on that if it was the case.

No problem, glad it does work for either! ...and that is just like Autodesk to have different naming for basically the same thing 😉

Re: Schedule of pipe slope

ASOL89GEY — Sat, 15 Jul 2023 06:32:11 GMT

Nevermind...found the error 😃

Re: Schedule of pipe slope

SvedaM — Thu, 18 Jul 2024 14:56:50 GMT

Hi everyone,

I reviewed the formulas that were shared, and I found them to be quite complex. To simplify things, I created a more straightforward version. I've attached the Revit file along with a PDF guide that provides a brief explanation.

I hope this helps!

Formula for slope angel:

asin((Upper End Centerline Elevation - Lower End Centerline Elevation) / Length)

Formula for slope percentage:

((Upper End Centerline Elevation - Lower End Centerline Elevation) / sqrt(Length ^ 2 - (Upper End Centerline Elevation - Lower End Centerline Elevation) ^ 2))

Re: Schedule of pipe slope

brownbr2VHQE — Fri, 19 Jul 2024 15:20:19 GMT

Yes, I believe those Built in Properties were added in 2023 and do make the formula far simpler. Better yet and where we have evolved is to make a shared parameter and a iUpdater using the Revit APIto make this data for you. With the assistance of ChatGTP this is very easy now.

Re: Schedule of pipe slope

iainsavage — Sat, 20 Jul 2024 11:26:03 GMT

It can also be done in Dynamo

https://forums.autodesk.com/t5/revit-mep-forum/pipe-slope-not-available-in-schedule-view/m-p/7421554

Re: Schedule of pipe slope

revitPWC6K — Fri, 09 May 2025 21:53:32 GMT

I am just wondering, when i click onto the pipe with slope, i see the slope written on the parameters window.

Why the hack developers did not allow to show this value within the schedules ?

this software is expensive so these elementary things should be already implemented

Re: Schedule of pipe slope

iainsavage — Sat, 10 May 2025 11:53:07 GMT

Many of the built-in parameters don't appear in schedules so unfortunately you need to use a workaround such as Dynamo to transfer values from the built-in parameter to your own shared parameter.

See the post that I linked earlier - read it all because the originally posted dynamo script was creating some errors and needed to be updated.

https://forums.autodesk.com/t5/revit-mep-forum/pipe-slope-not-available-in-schedule-view/m-p/7421554

Also make sure that the parameter name typed in the code block feeding into the Element.SetParameterByName node exactly matches the parameter name loaded into your project, including the character case.

Regarding your question "Why the hack developers did not allow to show this value within the schedules ?" - I don't think anyone on this forum will know the answer to this, its been a problem since the very earliest versions of Revit.