Split Schedule in different sheets

[Anonymous]

Hello community,

We need to Split a schedule into two sheets, because is too long, there is no way we can sort it by any field because is the way it needs to be, any idea???

Many thanks!!!

[HermanSolomon]

What you can try is to create a project parameter for the scheduled category, called Element Sheet No. This parameter should be an instance. Depending on the category, and how you are sorting and grouping these elements, you should be able to select all elements that needs to show on sheet 1 and add 1 to the Sheet No field. Add the Element Sheet No. parameter to the schedule, but hide the category in the formatting properties. You can then filter your schedule according to the Element Sheet No. that Equals, 1. The schedule can be duplicated and the filter condition changed to 2 for your second schedule. 

If you choose to use this method, I would advise to have a master schedule where the Element Sheet No field is visible and no filtering conidions have been set up. If any other element belonging to the category gets added to the project, you will be able to quickly add the Element Sheet No value to ensure the element is included in the schedules which are added to the sheets

[L.Maas]

Depending on the situation you would have to resort to some creative solutions.

-Add a new parameter to the items in the schedule (e.g. Destination_Sheet). FIll the parameter with 'Sheet1' or 'Sheet2' and filter on this parameter

-Put  you Items in different phases and filter your schedule on those phases

-Create the schedule twice and put one on sheet 1 and the other on sheet 2. You can use  annotation to cover the parts wihich you do not need.

-Export your data to for example excel and reimport them as two images

-Use larger sheet

-....

You can possbily think of several more different creative solutions. It depends on your project and schedule to find the most appropriate solution

[Anonymous]

Thank you very much guys!!!

[Anonymous]

We are using the Archigrafix Reports. This tool automatically splits long schedules into a PDF document with multiple pages. It also exports to Word or sends to a printer. You can have a look on the link on Archigrafix Reports. What we like it that once all the settings for a schedule are set it automatically saves them. We export drawing lists about 50-100 times per project, so this tool really helps us save time.

[ToanDN]

I think they were talking about split a long schedule on multiple Drawing Sheets in Revit.

[Anonymous]

I have used the filter technique previously; I think the right approach in a production environment is an automatic process that allows the schedule data (nr. of rows) to expand and contract. For instance: the schedule may need to spread into another page as it does not fit on the last page. Therefore I believe that a tool like archigrafix reports is more convenient, faster and professional then the manual process of setting filters and split into revit sheets. 

[ToanDN]

I agree with what you think. But the tool you mentioned does not actually address a solution to have the schedule tables on Sheets in the construction document. Create reports as separate documents can be done right off the bat.  Export it to Excel and make multi-page PDF from Excel take a few mouse clicks.

[Anonymous]

Hi spitffire-s

Thank you. I'll give it a try to the archigrafix reports. This is what I've been looking for a long time.

[bms953]

it's possible, take a look to this page:  https://dddmodeling.wordpress.com/2016/10/06/useful-tricks-break-schedules-per-sheet-in-revit/