## Monday, April 18, 2011

### Working with Schedules - Relationship between areas

In this recent thread on www.revitforum.org a question was brought op on how to calculate the Ratio between two Area Types. I’ve dealt with this a lot in trying to create a Template for Building Code Calculations, and came up with a solution.

A copy of the sample file used in this post is found here.

The problem with Revit Schedules is that it’s not possible to make calculations based on a Grand Total. Revit will only calculate per row, and this might not be what you’re after.
An important rule in the Dutch Building Codes, the 55% rule: 55% of the usable area of ​​a building (“gebruiksoppervlak”) must be qualified as suitable for the long-term presence of people (“verblijfsgebied”). This kind of Area is required to meet all kinds of rules that we just ignore. This blog is about the question: how can I calculate the ratio between “gebruiksoppervlak” and “verblijfsgebied”?

Simple Floor Plan with Rooms assigned

To begin, I just modelled a very simple geometry and placed some Rooms. Now it is important to identify the Rooms that actually belong to the type “verblijfsgebied”. As mentioned, the the rules for assigning a Room to the type “verblijfsgebied” are left for another time, so I pick a random room that I want to assign as a “verblijfsgebied”, while the rest is going to be assigned to “gebruiksoppervlak”. The assignment of a room or area to a certain Building Code Type is still fairly easy:
1. Create a Shared Parameter "VO_naam" for the type of Room and / or Area. This is a text parameter. Group the Parameter under Identity Data, make it an Instance Parameter and assign to the appropriate Category, in this case Room (which can also be Areas).
2. Give the various Rooms correct values of the parameter, in this case and GO and VG1.
3. Make a Schedule of room. Add the following fields:
a. Name
b. Area
c. VO_naam

Room Schedule filled with 3 parameters

4. Add a Calculated Value "VO_oppervlak" as an Area Parameter but you leave the formula field temporarily blank, it will later be filled on a later occasion.

Now it gets more complicated: how can a Revit decide whether a room belongs to “verblijfsgebied” (VO) or “gebruiksoppervlak” (GO), and how to calculate the proper Area?

First off, let’s start with defining the type of Room. To define this a Yes/No Parameter can be used: the user manually checks off whether a Room belongs to the VO or the GO. There is also a more automated (but also complicated) way: by using a so-called Key Schedule. The Dutch Building Code has but a limited number of types of rooms. That certain types of rooms have properties and rules assigned to the, and one of them is whether the type of Room belongs to the VO or GO. Since the Key Schedule can also be used for other purposes and calculations, this method is applied here.

1. Create a Key to Schedule: View Tab> Schedule. Select as a type of Schedule the Room Schedule and select Key Schedule.
2. Assign a Key Name and an additional parameter: OF_VO (Conversion Factor_VerblijfsOppervlak). This is an Integer.
3. Press the right mouse button in the Schedule View and choose Add Row. Add as many rows as desired.
4. After adding the appropriate rows can be filled the different types. Additional Rows may be added at any time during this excersize. Fill OF_VO parameter. In this case, only the Room Type “verblijfsruimte” is part of the VO (value 1) and the rest of the room types are part of the “gebruiksoppervlak” (value 0).

Setup of the Key Schedule

Once this is completed you can return to the Room Schedule and add the Parameters from the Key Schedule to the Fields in the Room Schedule.
Next, select the parameter VO_oppervlak again and press Edit. In the Formula bar add the following formula: Area * OF_VO. Because you have indicated in the Schedule Key that only the Rooms with the Room type "verblijfsruimte" have a conversion factor of 1, the result of this formula will be 0, unless the Room Type ‘verblijfsruimte" is applied.

Room Schedule with automatic calculation of Area types per room

Second: how can we calculate the Ratio between two types of Area? This cannot be done without some trickery. The problem is, that I can format the Schedule in a way that it will only show two rows, one with VO_naam set to GO and one with VO_naam set to VG 1. I can also create a Ratio-parameter which calculates the Ratio between the two. Just add the Parameters Ratio = Area VG / Area GO.
But, there are a few rules to using Schedules for calculations which causes problems:

1. Revit will calculate a formula for each Room. This DOESN’T change when Itemize Every Instance is unchecked.
2. In other words: unchecking Itemize Every Instance does NOT change the outcome of any given Calculated Value in the Schedule. It will look this way because Revit can add up the outcome of all Rows that are hidden, but the outcome of each Room is still the same. In this case we want to reference to the Grand Total Area so this causes a erroneous outcome of the formula:
3. The formula will read Area VG / 0 = (cannot be solved), when the Room is assigned to Room Type “VG”.
4. The formula will read 0 / Area GO = 0, when the Room is not assigned to Room Type “VG”.

This outcome is shown in the next few figures and was also the problem in the message posted on Revitforum.

Even though the Grand Totals are correct, the calculated Ratio stays 0%

But how can we now calculate the ratio between “verblijfsruimte” en “gebruiksoppervlak”? For starters, go to the Formatting Tab an check the box Calculate Totals for Area and VO_oppervlak. Then go to the Sorting And Grouping Tab, set Sort By VO_naam on and check Grand Totals.

Switch to “Sorting and Grouping”, Sort By “VO_naam” and check Grand Totals.
After this we create an additional Calculated Value. Create a Calculated Value of the type Percentage and divide Area by .This shows the percentage of a single Room to the overall Grand Total Area.

Calculated Value Verdeling VO_GO

After this we create another Calculated Value, “Area_totaal” with the formula: “Area / Verdeling VO_GO”. With this parameter the Grand Total Area of all Rooms is calculated . Crucial in this step is that the Grand Total Area now is a Room Parameter and therefor appears on each Schedule Row. This makes it possible to use this value in further calculations.

The third Calculated Value is “Percentage_VO” and uses the formula “Verdeling VO_GO / Area_totaal”. This parameter calculates the total percentage of Room type “verblijfsruimte”.
Finally a Calculated Value “Percentage_GO” is created with the formula “(Area-Distribution VO_GO) / Area_totaal”. Theoretically, also the formula “100 - Percentage_VO” could be used, but this formula gives a good check if everything is calculated and whether all available Rooms have been assigned to a certain Room Type.

Calculated Value Area_totaal

Calculated Value Percentage_VO

Calculated Value Percentage_GO

It should now only be a matter of setting the proper Schedule Formatting. The columns

“Name”, “Area”, “Type ruimte”, “OF_VO”, “Verdeling VO_GO” en “Area_totaal“ can be hidden in the Schedule. Click the right mouse button on the column and select Hide Column. Then go to the Sorting And Grouping tab and uncheck "Itemize Every Instance”. Next, in the Format tab, the formatting of the columns “Percentage_VO” and “Percentage_GO” can be adjusted. Set the Units to Percent, 2 decimal places and with the unit symbol %. The end result should look something like shown in the figure below.

Final result

Does this work with multiple types of Rooms? To investigate this I added a new Phase and an extra room. This also gets as Type "verblijfsruimte" but named VG 2. Now the intention is that both the individual percentages and the total Ratio is calculated. The final result below shows that the desired outcome is indeed shown in the Schedule.

Filling Room Type and VO_naam provides with an accurate Schedule

1. Excellent work Martin. I'm guessing this must of taken quite a bit of experimentation to get right. I have applied this process to the Hotel job I've been doing and its works sweet. I am also able to see how this can be applied to other situation, ie car parking computations.
Really good post.

2. Writing is usually possibly your own hardest skill for ESL students to learn, AS WELL AS ESL writing activities so must end up being carefully created regardless of whether these include to be able to always be effective in improving students' writing skills. quite possibly ones most ticks thing to bear in mind when coming up with ESL stress in college activities can be This writing Should not end up being viewed to be a routine AND boring process. the better approach regarding ESL teachers can be to help treat writing As your art application This It is. When assigning writing activities within class, teachers will probably occasionally introduce activities which might be fun, lighthearted, even silly.

3. Nice tutorial. The building codes vary from country to country, and local to local.

4. Thanks for posting this useful content, Good to know about new things here, Let me share this, . LINUX training in pune

5. This comment has been removed by the author.

6. Bruce isn't kept in the dark for long, though, as Kris decides to come clean and tell him about the secret meeting. Bruce is unhappy and hurt by the admission and tells Kris he doesn't think he can trust her anymore.
liedetector.uk

7. The suspect to be interviewed is put in an ordinary seat.At that point,the mediator or interpreter puts the sensors on the single person.One sensor measures sweat and an alternate measures heart rate.liedetectortest.us

8. New technology used in has both negative as well as positive consequences. E-mail is the easier way to communicating with people. website link

9. This comment has been removed by the author.

10. I propose that each and every lawyer be given a lie detector test and a drug tests annually or they cannot renewal their legal license to practice law http://www.liedetectors.co.uk

11. We primarily attract situations to ourselves that create interactions, allowing us to continue to accelerate, serve, and learn who we are click here

12. They also have the advantage of being quite structured which may allow you to consider aspects you might not already have thought about https://relationadvisor.com/

13. This comment has been removed by the author.

14. This comment has been removed by the author.

15. This could be, for instance, on the grounds that the individual feels that he or she is prepared to get hitched and additionally needs kids and just searches for somebody to wed.adultentertainmentstore

16. These are your own "property lines". This is the place someone else's space closes and yours starts. Indian cam girls

17. On the off chance that a relationship is developed on this reason, there would be no happiness in it.his secret obsession reviews

18. A definitive method to recover a young lady is to pursue a solid arrangement, with your sentiments in parity.Oligarch Escorts

19. There is a huge number of Arab young ladies online at free Arab dating locales. The greater part of these young ladies are single and open for relationship. www.seksitreffit.cam

20. This issue is cause by a quick change Song Hye Kyo Skin Care in the extent of your body, for example, experienced amid pregnancy.

21. What's more, you can have precisely the same objectives and life vision of someone that has no enthusiasm for having any kind of effect on the planet. So if your esteem framework follow me
is extraordinary, it is anything but a match.

22. Here is a good Weblog You might Come across Fascinating that we Encourage You
โปรโมชั่นGclub ของทางทีมงานตอนนี้แจกฟรีโบนัส 50%
เพียงแค่คุณสมัคร Gclub กับทางทีมงานของเราเพียงเท่านั้น
ร่วมมาเป็นส่วนหนึ่งกับเว็บไซต์คาสิโนออนไลน์ของเราได้เลยค่ะ
สมัครสล็อตออนไลน์ >>> goldenslot
สนใจร่วมลงทุนกับเรา สมัครเอเย่น Gclub คลิ๊กได้เลย

23. Enjoyed studying this, very good stuff, thanks.
เว็บไซต์คาสิโนออนไลน์ที่ได้คุณภาพอับดับ 1 ของประเทศ
เป็นเว็บไซต์การพนันออนไลน์ที่มีคนมา สมัคร Gclub Royal1688
และยังมีหวยให้คุณได้เล่น สมัครหวยออนไลน์ ได้เลย
สมัครสมาชิกที่นี่ >>> Gclub Royal1688
ร่วมลงทุนสมัครเอเย่นคาสิโนกับทีมงานของเราได้เลย

24. Do not base the happiness of your relationship on money so that its absence will not cause any relationship problems. Both or all of you should put your heads and hands together and then sooner than you are expecting it, money wouldn't be a problem anymore.Relationship Advice

25. Pre-marriage sex puts a programmed stop to the development of the dating and romance relationships. poly dating

26. Wonderful information! I found amazing information on the blogs i suggest everyone to follow the links below to get download files from this website.
Snapchat For PC

27. Our array of English assignment help makes it easier for you to get cracking on the reading tasks. Here are a few tips on how you can excel at doing that while we take care of the writing assignments.

28. Thank you for your outstanding article. You will always find clients coming back to us which is a result of our excellent services. Our goal is to offer unique and specialized services to our clients and in return create a long-lasting working relationship. The best thing about working with us being that, we provide samples for any client who would want to see some before ordering from us. Learn more from Nursing Care Plan.

29. Thanks for sharing it is important for me. I also searched for that from here. Visit our site panda bellen