Totals from Un-Itemized List (Scheduling Links within Links)

[harryNR27R]

I have linked model that has been duplicated 4 times throughout a parent project. In the parent project, I have our G sheets set up, and I would like to start implementing schedules for takeoffs of different elements. However, I have realized that calculating totals in an un-itemized list is combining all duplicate rooms to give a total that is 4x as large.

I hope you can understand that the purpose for this schedule is to only report these takeoffs for a single model type. How can I provide totals for only the information shown on screen, without calculating totals for all 4 models?

Correct Calculation that I need totals for:

Incorrect Calculation (calculating totals for all instances):

This goes without saying that a single unit type will not have 4000 LF of baseboard.

Edit: Here is the itemized list for reference. I need to get the totals (Area/Baseboard) for a single instance of each room. How can I filter for duplicates? Leaving the list un-itemized will combine the totals for all 4 instances.

[SteveKStafford]

You could not choose the option "include elements in links"?

[harryNR27R]

There are no live elements in this parent model. The proposed strategy was to load all models to get total window/door schedules and takeoffs for the entire project and to have our general sheets in one file.

There are 50 units that consist of 8 types. I would like to provide a schedule for each unit type on a single sheet. How would you accomplish this, or does Revit not have the capability to provide totals for unitemized lists?

[barthbradley]

What about Filtering in/out what you want the Schedules to report/not report?  

...you can always add Parameters to use to Filter, Sort and Group by.  

[harryNR27R]

Yes, I have done this to filter for a single unit type. Since there are multiple units of this type, is there a filter to purge duplicate rooms/elements from this schedule?

For example, Unit type B appears 4 times in our project. Therefore, there are 4 identical instances of each room. How can I filter out 3 other identical rooms and only get the totals for a single instance?

Edit: Here is the itemized list for reference. I need to get the totals (Area/Baseboard) for a single instance of each room.

[barthbradley]

I would need other questions answered to come up with a targeted solution, but one way to get there would be to Filter by Comments.  You would type in the Comments and Filters would do the rest of the work.  

...just in case you are unaware, you can hide Parameters. The Schedule doesn't have to show those Parameters that you are using for Filtering.  

[harryNR27R]

These are rooms from a linked model. Comments to rooms can only be added while in the linked model. Adding comments to the linked model would just result in duplicate comments in the parent model where I am trying to create a schedule. 

[barthbradley]

Are you pulling any RVT Links Parameters into the Schedule via the "Select Available Fields From:" dropdown?  

[barthbradley]

.

[TripleM-Dev.net]

Hi @harryNR27R,

If I'm correct you only want to list elements from one Link instance and not the others in the Schedule?

Well then just incheck those in the Schedule settings, just like a normal view.

If it's the same LinkType, give the instances a name so you can easy id them. (Schedule View > Visibility/Graphics Overrides > Revit Links.)

Or add the Link field "Rvt Link: Name" and filter on it's value?

- Michel

[harryNR27R]

Thank you for your response; this gets me incredibly close. However, there is still one more step to go: these are coming from a sub-link of a linked model. To lay out the condition:

1. A unit model is Linked into a parent: Type A is used for Units 1-8.

2. The model for units 1-8 is linked into a master.

3. The master is used for our schedules and take offs so that we can coordinate all units 1-8/9-18/19-28/etc. on to our sheets.

Because the single unit model is contained in the group, link parameters will only read for the group:

The group model that has been linked into our live file. Note the link parameters previously shown are only for the group model.

Here I have selected the sub-link for the group. Note that the name/mark are greyed out and cannot be read/written.

Is there a way for Revit to read through to a "sub-linked model" to grab its link parameters? I am disappointed that there is no way for Revit to provide totals for an Un-Itemized list.

[harryNR27R]

Here is a similar question I found that has not been solved. I believe that I may need to submit an Idea to be able to achieve this functionality in the future. I also believe the workaround for us is going to have to be removing the groups and manually placing the individual unit models.

[ToanDN]

Give each instance of your link an unique name, add the parameter to the schedule to create a filter to show one link instance only.

[TripleM-Dev.net]

Hi @harryNR27R ,

That the Nested Links name would be empty in the schedule was my experience (R2019-2020).

As I always try to stay away of using nested links, but when I just now tried the setup, to see if I could come up with something, I noticed something strange.

To my surprise the walls of the nested Link reported as the Link name of the top link and not the nested link....so would be filterable on it's "parent"name.

This is in R2022 and R2024, could be due to some element id's identical as all were started from same template and no further editing in them....(didn't try it with rooms, maybe they behave different.)

What Revit version are you using?

If all else fails, divide all calc-fields by x-amount? As work around..

[harryNR27R]

Please refer to the previous replies.

[harryNR27R · Accepted solution]

Revit LT 2024.

I already moved forward with purging the group models and inserting the individual links, but this would be an effective work around as well.