Combine Areas for Two Story Units in Schedule?

[Anonymous]

I am new to using the schedule feature. I am trying to figure out how to have it automatically add the two areas from the lower and upper floors of a townhouse unit.

As you can see in the attached image, units 201-206 have an upper and lower area listed. Rather than listing:

201 Lower: 378 SF

201 Upper: 409 SF

I would instead like:

201 (Total): 787 SF

Does anyone know of a solution?

[amorap · Accepted solution]

Hi naomiP5XWN

I would do it this way:

1- I would create a new parameter for the room category named for example "duplex" (or can use an existent other like "department" if it is not used yet)
2- Give each room the proper value for this new parameter.
3- Create a new room schedule table. Add the fields you need, and the new parameter "duplex". Be sure that totals are calculated for the field "area" (in "formatting" tab).
4- In sorting/grouping tab, classify by this new parameter "duplex". Allow to show totals in "footer".
5- Make sure to untick "itemize every instance".

That`s all.

regards from Spain. 

[ToanDN · Accepted solution]

I would use the Unit Number field to indicate only the number, i.e. 201, and add another Unit Level field to indicate the level if applicable.  In your schedule, don't include the Unit Level field, sort by Unit Number and for mat it to calculate total, untick itemized every instance, and you will have the sum of the area of a 2-level unit in one row.

[Anonymous]

Great! That did the trick perfectly. To follow up, is there a way to achieve the same result within the area tag on the plans? I have created my own area tags and figured out I could change the area parameter to read as the area plus a value, where the value was the upper area. This let me have the whole unit area listed within the tag on the lower level of each unit, but I have to manually change the value within the tag itself, and would need multiple tags for any variance in areas. 

[ToanDN]

---

@Anonymous wrote:

Great! That did the trick perfectly. To follow up, is there a way to achieve the same result within the area tag on the plans? I have created my own area tags and figured out I could change the area parameter to read as the area plus a value, where the value was the upper area. This let me have the whole unit area listed within the tag on the lower level of each unit, but I have to manually change the value within the tag itself, and would need multiple tags for any variance in areas. 

---

For the tag you would need to add a shared parameter for the upper level's area (Area2) and a Label from a shared parameter for the total area (AreaSum).  Enter the formula for the Label (AreaSum) = Area+Area2.  Add the same two shared parameters in project and assign them to the Rooms or Areas category, whichever you use.  Manually enter the upper level's value for 2-level Units and enter 0 for 1-level Units then you can use a single Tag for all Units.

[Anonymous]

Thank you! I assume that when you say "Manually enter the upper level's value," by value you mean the area. This is by far a better solution than what I had, but unfortunate that it still has to be manually entered. 

[ToanDN]

---

@Anonymous wrote:

Thank you! I assume that when you say "Manually enter the upper level's value," by value you mean the area. This is by far a better solution than what I had, but unfortunate that it still has to be manually entered. 

---

Yes it was what I meant.  Unfortunately one Tag can only associate with one host (Room or Area) so you cannot automatically add a value from another Room or Area to it.  You could create a Dynamo script to read a value from a parameter of one object and write it to a parameter of another.  Visit dynamo forum (link in my signature) and you can find some guidance.

[Anonymous]

I thought I understood how to set up the tag, but when I tried to put it into action I hit a roadblock. I set up a shared parameter (those are new to me) called Area2 and was able to add it to the label formula AreaSum. I then added the Area2 as a parameter, but when I load it into my Revit Project, I cannot get the Area2 parameter to show as an instance parameter. I am able to make it a type parameter, but not all the upper floor areas are the same, so I want to be able to specify on each tag a different Area2. 

[ToanDN]

How did you add the Area2 shared parameter in the project?  When you do it, check only Room or Area category, nothing else, and you should be able to set it as Instance parameter.

[ToanDN]

Oh, your Area2 in the family is incorrect.  It must be a shared parameter, not Family parameter.  

[Anonymous]

---

@ToanDN wrote:

How did you add the Area2 shared parameter in the project?  When you do it, check only Room or Area category, nothing else, and you should be able to set it as Instance parameter.

---

Not sure where you are to be able to see the category list. When I open the Parameter properties (even with Shared parameter selected), I do not have the option to select a category. 

[Anonymous]

---

@ToanDN wrote:

Oh, your Area2 in the family is incorrect.  It must be a shared parameter, not Family parameter.  

---

Ah I see now that you were in project parameters, not the family parameters. I found the categories and checked only area, but it still does not show up as an instance parameter for the tag.

[ToanDN]

See screencast for workflow.  These steps are important.  Revit file is also attached.

[Anonymous]

THANK YOU! Not sure what step I was missing before, but it works perfectly now.

[joe_aylward]

Hi!

I have tried this but I can't make it work out. In fact it doesn't show the sum of the areas but the voice <varies>.

Do you have an idea of what I might do wrong?

Thank you

[Khaled-CDPartners]

You can have a new parameter having the same name, remove the itemize check, and in the formatting, select the area and calculate the totals.