Editing a Schedule

[Anonymous]

Is there anyway a really long schedule can be changed to fit on a sheet?  I have a 5 storey block and ideally would like it to be based on floors - so that I have for example, ground floor with all the door tags, etc and then next to it 1st floor, and so on.  Or should I be creating 5 separate schedules and filter them to the appropriate floor and then drag each schedule into my drawing sheet?

[RichConyers]

you can create separate schedules and filter as you suggested or you can create a parameter for floor and add a heading to the schedule. This will group your tags by floor but allow the schedule to be more "fluid" per sheet. Is there a particular way you are trying to make it fit on one sheet? Are you trying to reduce size, reformat, or just how to organize through multiple sheets?

Cheers,

-R.

[L.Maas]

You can split a schedule in multiple parts when placed on the sheet. Then drag till where the split should happen. However when data changes you might need to drag to split at the right row. 

Otherwise you will have to create multiple schedules as you suggested

[Anonymous]

Thanks for the replies.  Just looking at getting a long schedule smaller so it fits on my A1 sheet.  I haven't done parameters before so that scares me a little!!  Will try the self-split thing and see how I go!

[Anonymous]

Right, splitting it up myself only seems to split the table in half and then half again so I can't split it relative to the floors ( Grd to 4th )

How is it best to set up the parameter options?  There seems to be loads of ways to save/setup.  All I want is 5 boxes, one for each floor, that state the doors on that particular floor. 

[RichConyers]

Drag that bottom handle up to a floor break and it will adjust the schedule automatically.

If you want this to be consistent and not have to worry about adjusting everytime you add or remove a door, a parameter and separate filtered schedules is a much better solution. Usually, doors are tagged by floor if possible (Doors on first floor = 100's, second floor 200's etc.) With this in mind, you could simply sort schedules by mark and filter to the 100 level of the floor you wanted. An easier solution than creating a floor parameter and filtering the same way. 

[Anonymous]

I've just noticed my numbers are all over the place as I did Tag All.  Is there a quick way to change to your suggested numbering system without having to go to the schedule and click on each line individually.  Thanks for your help Rich.

[RichConyers]

Unfortunately, without a Dynamo solution or plugin, you have to change each door. Revit automatically creates door tags in the order the doors were created. We are still trying to get Revit to auto-number doors based on room numbers but it hasn't happened yet to my knowledge. It will probably be faster to change the numbers manually than trying to add a parameter and change each of those. Sorry there isn't a quick answer. 

Feel free to mark solutions or give kudos when you find information useful!

Cheers,

-R.

[Anonymous]

Ok done that for the doors.  New to this so as I've got to schedule the windows as well, would they be numbered the same - what I mean is start at 1,2,3 etc or should I donate them in some other way?

Also, I'm not sure the format looks right in my door schedule.  Maybe it would be better if I had them sorted by level and then by family but I don't want tons of Doors_IntSgl showing for each row.  Can I get it to have just the one family name but the adjacent columns still list the numbers, etc?

[RichConyers]

From what I'm seeing here, you're not sorting by family at all, you just have the column before the level column. Have you considered renaming your families to coincide with door types like a typical schedule (A,B,C etc.)? We usually note the Windows as W1, W2, W3, unless the project is small enough to have A,B,C but that's pretty rare for us anymore.

Did I answer your question?

Cheers,

-R.

[ToanDN]

If you sort by Door Mark and every door has an unique Mark then you have to accept to show every single row in your shcedule.

Below is anther approach if you want to group the schedule differently:

1. If you want to show the door Family information then rename them to something more conceivable, such as: Door - Interior - Single, etc...
2. Do you have Types within each Family for different door dimensions?  You should.
3. Add 'Type' parameter to the schedule
4. Go to Sorting/Grouping Tab:

• Sort #1: Level ; Check Header box ; Check "Bank Line"
• Sort #2: Family ; Check Header box
• Sort #3: Type

5. Go to Format tab:

• Set Level field to Hidden
• Set Family field to Hidden