topic Re: Schedule total in Revit Architecture Forum

Schedule total

roscopeco2000 — Wed, 07 Dec 2022 11:06:05 GMT

Hello

I need some help please i am working on a schedule which works total amount of glazing % per room area. I have got the first part to work so it will divide the purge ventilation area/ the room area. I need it to combine each instance into a total so the 2x windows in test and the 2 in ROSS. So test would have a % of 20% and and ROSS would be 13.4%. Eventually i would like to do this for the whole house so total glazing to total house areas.

Thanks hope i have been clear

Re: Schedule total

barthbradley — Wed, 07 Dec 2022 16:40:03 GMT

Can't you get there by Sorting/Grouping by Room Location with Footer and Calculating the Percentage of Room Glazing?

Re: Schedule total

ToanDN — Wed, 07 Dec 2022 18:48:58 GMT

Share your file here then we can show you how to get it done.

Re: Schedule total

roscopeco2000 — Mon, 12 Dec 2022 14:55:01 GMT

I would appreciate your thoughts both @ToanDN and @barthbradley , i have saved as project with PART o schedule in. @barthbradley are you saying add totals at the bottom? can these they be referenced into a parameter?

Re: Schedule total

barthbradley — Mon, 12 Dec 2022 15:09:31 GMT

Isn't this what you want?

Re: Schedule total

roscopeco2000 — Mon, 12 Dec 2022 16:04:41 GMT

Hi yes it is can i use the value from the total in the footer back into a parameter?

Re: Schedule total

barthbradley — Mon, 12 Dec 2022 16:08:43 GMT

To do what exactly? Can you elaborate with pictures?

Re: Schedule total

barthbradley — Mon, 12 Dec 2022 16:49:37 GMT

Look into Calculated Parameter by Percentage.

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-Model/files/GUID-44EC6734-D36B-4083-8FCD-833B166D6C0A-htm.html

Re: Schedule total

ToanDN — Mon, 12 Dec 2022 16:56:51 GMT

Like this?

Re: Schedule total

roscopeco2000 — Mon, 12 Dec 2022 17:22:27 GMT

So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round

Good, as this schedule trick is dependent on the sorting levels (calculated values have access to the sorting level totals), and you are working within the same sorting level. I think you can do this with (2) additional CVs.

Parameters you already have (I'm renaming them here):
roomArea (area of room), roomAreaLimit (10% of roomArea), windowArea (area of each window unit), roomOK (y/n)

Parameters you need:
windowAreaPercentage: calculated value Of windowArea By Room:Name (this is one of your sorting levels). This is each window's percentage of the total window area for that room.
windowAreaPercentageTotal: formula, Type: Area, windowArea / windowAreaPercent. This is the total window area for the room.

Now you need to adjust your roomOK formula to: not(windowAreaPercentageTotal > roomAreaLimit)

Re: Schedule total

ToanDN — Mon, 12 Dec 2022 17:26:50 GMT

@roscopeco2000 wrote:

So i want to get this total in pink circle back into the schedule, the below text i have found on another forum i think is what i am after. I just need to get my head round

The total circled in pink IS in the schedule so I don't understand your question. Where do you want to show it exactly?

Re: Schedule total

roscopeco2000 — Mon, 12 Dec 2022 18:12:26 GMT

I don't count that as in the schedule, its a total as a footer to me. I want the total as a cell in the schedule. I need it display as cell so i can reference in a conditional format .