Door Schedules, Calculated Values, and "Count" parameter

[goodtastingsteak]

Hello!

I haven't been able to figure a workaround and was hoping someone might have some helpful information here.

Background:
We have a residential high rise tower with 12 different units, each unit as its own model group and copied. For our door schedule, we were thinking of creating a door schedule for each unit that shows how many of what door types there are within the units.

What we want to do:
In addition to showing how many of each door is in each unit, we wanted to show the total number of units and thus give a number for how many total doors there are. Ex: If the unit 2A door schedule shows that we have 3 "A" type doors and we know there are 70 2A Units, Revit calculates that there are 210 "A" type doors.

Unit 2A Door Schedule
Type Count Total
A 3 210
B 5 350
C 2 140

and "Total" would be calculated from an Instance parameter "Number of units" (which in this example is 70) * Count

but...
Revit won't allow me to use the "Count" parameter in the calculated values box so I was wondering if anyone had any workarounds or experience with such an issue.

Thanks in advance!

[dwebber]

Bad news, you can't re-use totals information in a calculated value. The only way is to export it to a spreadsheet and create the calcualtions you want there.

To get it back into revit the help guide says this:

1.In the spreadsheet application, open the spreadsheet. Display the data as you want it to display on the Revit sheet.

2.Use a screen capture utility to take a screenshot of the spreadsheet.
For example, you can use a screen capture utility such as SnagIt® by TechSmith Corporation or !Quick Screen Capture by Etrusoft, Inc. (or the print screen button and crop it)

3.Save the image using one of the following file types: BMP (bitmap), JPEG, JPG, PNG (portable network graphics), and TIFF.

4.Add the spreadsheet image to the Revit sheet.

Not the best solution, but we work with what we have, right?

[Scott Womack]

No you can't reuse the totals, but you can create another door schedule, sort by door type, uncheck list all instances, and you'll get the "total number of each type of door.

[twiceroadsfool]

What Scott said. And if the CV's field is set to calculate totals, it will as well. And if you want to USE the CV value n another CV.... then you just need to make the formula for the CV longer....:P

[goodtastingsteak]

Thanks for the help! We ended up just leaving it as is showing the number and types of doors per unit

[Alfredo Medina]

I agree with Scott. This can be done with 2 different schedules, by using sorting and grouping settings, as shown in the illustration provided. The schedule on the left shows the number of doors per type; how many "A", "B", and "C" types of doors there are in the whole project. The schedule on the right shows how many "A", "B", "C" there are in "Unit A", how many for "Unit B", etc.