Hello and thank you for your help. I am working on recreating my firms door schedule and am running into a bit of an issue in Revit 2020. It is our firms standard to place the text “PR” in the same cell as the width for double doors (EX: a 6’0” double door would have the cell read “3’-0” PR”). Currently, the width is a text parameter that we just type in the width of the door plus “PR” but has lead to issues in the past.
My goal is to have the door schedule update the width automatically and add “PR” to doors wider than 5’. I believe that the best way to do this would be to use Calculated Parameters. I was able to figure out 2 separate calculated parameters, one for the doors width to be divided by 2 and one for the text “PR” but they are in different columns. Is there a way to use the term “AND” in a calculated parameter to show door width and PR? If not, do you have other suggestions to achieve this goal without the cell being a text parameter?
These are the two calucated parameters that I was able to get to work and that I would ultimately like to combine:
Divide door width by 2 if door is wider than 5’-0”: if(Width > 5', Width / 2, Width)
If door is wider than 5’-0”, the cell fills with “PR” or “Single”: if(Width > 5', "PR", "SINGLE")
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
@PrestonL6EHQ wrote:
Hello and thank you for your help. I am working on recreating my firms door schedule and am running into a bit of an issue in Revit 2020. It is our firms standard to place the text “PR” in the same cell as the width for double doors (EX: a 6’0” double door would have the cell read “3’-0” PR”). Currently, the width is a text parameter that we just type in the width of the door plus “PR” but has lead to issues in the past.
My goal is to have the door schedule update the width automatically and add “PR” to doors wider than 5’. I believe that the best way to do this would be to use Calculated Parameters. I was able to figure out 2 separate calculated parameters, one for the doors width to be divided by 2 and one for the text “PR” but they are in different columns. Is there a way to use the term “AND” in a calculated parameter to show door width and PR? If not, do you have other suggestions to achieve this goal without the cell being a text parameter?
These are the two calucated parameters that I was able to get to work and that I would ultimately like to combine:
Divide door width by 2 if door is wider than 5’-0”: if(Width > 5', Width / 2, Width)
If door is wider than 5’-0”, the cell fills with “PR” or “Single”: if(Width > 5', "PR", "SINGLE")
- Add a [Panel Width] (length) shared parameter in the door families and enter the formula: if (Width > 5', Width/2, Width)
- Add a [Panel Configuration] (text) shared parameter in the door families and enter the formula: if (Width > 5', "PR", "SINGLE")
- Create a door schedule in the project, add [Panel Width] and [Panel Configuration] parameters as schedule fields
- Create a Combine parameter to the schedule and add the two fields above, format as you see fit
This is the problem with putting together a family library piecemeal. Parameters are all over the place and mean different things in different families. I have completely rebuilt my firms door library from scratch to get away from these issues. My suggestion would be to apply the width parameter to the individual doors within the family, so a double door with two 3' doors pulls the individual width rather than the 6' width. I added an egress width parameter to pull the total exit width when needed.
Using text parameters in a schedule for numerical values completely negates one of the primary strengths of Revit, adds tons of time to a project and is just asking for coordination issues.
Thank you for your quick response. Yes I am currently making the doors from scratch, so I can add in whatever parameters are required. I see, I will give applying the width parameter to the individual doors as opposed to the overall width. However, I still am struggling with adding the text "PR" to the same cell as the width. How would you suggest to do this? I have attached an image from a previous project for a 6'-0" door with the "PR" text, but this is a text parameter.
@PrestonL6EHQ wrote:
Thank you for your quick response. Yes I am currently making the doors from scratch, so I can add in whatever parameters are required. I see, I will give applying the width parameter to the individual doors as opposed to the overall width. However, I still am struggling with adding the text "PR" to the same cell as the width. How would you suggest to do this? I have attached an image from a previous project for a 6'-0" door with the "PR" text, but this is a text parameter.
Please read my earlier response. It has addressed your questions already.
Awesome, this is what I am looking for, however I am confused on something. I have created the shared parameters like you have described, but I am unable to enter formulas in the shared parameters. Do I add these formulas in the door schedule? Or if I am to add formulas to the shared parameters, can you please elaborate on how to do so? Thank you!
@PrestonL6EHQ wrote:
Awesome, this is what I am looking for, however I am confused on something. I have created the shared parameters like you have described, but I am unable to enter formulas in the shared parameters. Do I add these formulas in the door schedule? Or if I am to add formulas to the shared parameters, can you please elaborate on how to do so? Thank you!
No you need to add the formula to the shared parameters in the family in order to use Combine parameter in the project's schedule. Because a calculated value parameter in the project schedule can only showing on its own, cannot be combined to a single cell as the whole exercise is about.
If you have trouble entering the formula in the family, share it here and we can fix it.
I was able to figure out how to do the shared parameter formulas (I didn't realize it was under Family Types) and it works! Thanks for all your help!
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.