Deleting Rows in Schedules

[Anonymous]

I have learned slowly had to edit schedules, templates, etc. but far from proficient.  We have created some schedules in our models that when we open to edit, has a lot of blank rows.  So, I deleted the blank rows and whoa, a lot of model elements were deleted even though this schedule did not seem to have anything to do with them.  It was a schedule for listing Grounding Electrode Conductor sizes.  So I am thinking, schedules should not have blank rows.  Just like a light fixture schedule, it there is a row it is tied to a model element that may not have been given a name or type mark but exists in the model. Delete the row and delete all of this types in the model.  Mechanical engineers had a similar issue.  Am I on the right track with this?

[J.Wehmer · Accepted solution]

Each row on the schedule is generated because a model element prompted Revit to schedule an instance on the schedule. This is done by your family classification inside the family model. If you place a light, Revit Family Category - Lighting Fixture, and you have created a Lighting Fixture schedule.. anything with the Category that matches the schedule type, will create a row on the schedule. So each row "is" a model element of the category. Thus if you delete a row, you are deleting that model element instance.

If you need to sort or filter your schedule, use the buttons on the properties bar.

If you are getting a lot of blanks, choose a "Sort By" option (this will let you select a parameter to organize by....play with the settings and try them out), and make sure that your "Itemize Every Instance" is unchecked. This will collapse all the duplicates of the parameter that you have chosen to sort by. EX: If you sort by Type Mark and uncheck the Itemize every instance box, this will organize all your Type Marks in Alphanumeric/Numeric order and collapse all the duplicates, so that you only have 1 row of each data.

Experiment and find the right flavor of Sort/Grouping you need, because each schedule can be a little different.

[Anonymous · Accepted solution]

Every row in a quantity schedule corresponds to a model element of whatever category the schedule is applicable to.  Delete a row, delete the model element.  I once had a mechanical engineer absolute flip his lid because he wanted to consolidate a dozen rows of identical pieces of equipment into a single row, so he just deleted all of the excess rows, then tried to blame everyone else in the office for messing with his stuff.

The reason the rows were blank is that none of the schedule fields (parameters) had been given a value yet.