Schedule Filtering

[mikermyers73708414]

I am trying to filter a door schedule. I have a 600 doors over 5 floors and I braking up the doors into floors. I have regular doors 100,101,102 (suite rooms) and I have W100,V100 . How Do I filter these doors so that they dont fall in the end of the schedule but maintain in the first floor. What Filter method would you use.

Is there a list of filter varibels somewhere? * + - or things like that?

[david_peterson]

How would you like them to "Fall In"?
Revit will schedule them Alpha Numerically.
If you need your schedule to go say, 100, 101, 102, V102, W102, 103, W103, 104, V104....... I'm not sure you can "Filter" or "Sort" them that way with a magical formula.
You could put the letter value at the end of the number, then they would sort. I'm not sure what the purpose is here, but that doesn't really matter.
You could filter out all of the doors that start with a V and put them on their own schedule.
You could add a "Door Sorting" parameter and number them that way. Not sure how easy that would be. I'm guessing there's a way to populate that value via Dynamo.
But as far as I know there's no method I've seen to exclude the first value in the Number mark.
Just my thoughts.

[peterjegan]

I would suggest using Levels.

In your door schedule:

Under "Fields," add "Level."
Under "Formatting," make "Level" a "Hidden Field."

For Filtering:

Filter by: Level <equals> <YourLevel>
or
Filter by: <Level> <is at or above> <YourLevel>
And: <Level> <is below> <YourLevelAbove>

For Sorting/Grouping:

Sort by: <Level> <Ascending> (Probably)
Then by: <Mark>
Then by: Whatever else you need.

[david_peterson]

I don't generally suggest Levels for several reasons.

If you copy and paste from floor to floor, you can end up with doors that are offset from the level and they will show up in the Level 1 schedule even though they are on level 3.

The other reason has to do with the number of levels. On larger complex projects or remodels where you're adding a new building between existing buildings or connecting back to another building, you may have doors that are on "half levels" or something but still get the same base designation. So I have door 1004 that's on level 1.2 and not level 1 but I still want to associate it with that floor plate. If you're filtering by level, that door may never show up.

Typically we number by Level, Smoke compartment, Corridor number or Area number, then Room number. If I have closet door within a room, we tend to add a letter designation at the end. I've also seen teams us a .# at the end (1004.1). This tends to provide a nice logical order to your schedule and make life a lot easier to find it on the plan.

I've seen teams use the floor, room type (as a letter) and then number. 1E01 for a first floor electrical closet. This works and will group all of your mechanical type rooms together.
A combination of these methods were used on a recent hospital project that we just completed. I'm guessing there were close to 1000 doors, might have been more.

So there's some options. But I don't know that your question has been answered.