Can you get a schedule table that indicate pipe slope?
Apparently it seems not.
I am perplexed
Solved! Go to Solution.
Solved by Revit_Whisperer. Go to Solution.
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.
@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
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.
@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 🙂
Thanks for this. It says top and bottom elevation is not a valid schedule field, interested to know how you made this work.
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?
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
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 😉
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))
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.
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
Can't find what you're looking for? Ask the community or share your knowledge.