Scheduling Gross and Net Areas in the same schedule

[jrathLHK5W]

I want to create an area schedule that will schedule Gross and net areas in the same schedule. Normally Revit won't allow this. But perhaps I can trick Revit or I can use dynamo.

This is the first schedule.

I would want to harvest the value in yellow.

Here is the 2nd schedule.

Again I want to harvest the value in yellow. Then I want that data to be put into this schedule.

Here I have to currently manually put the data in and I want Revit to do it for me.

So far my attempts to outsmart Revit and to write a dynamo script have failed. So I am looking for any help that I can get.

[ToanDN]

Like this?

[jrathLHK5W]

hmmm ... that is an interesting way to get around the Gross and net problem.

[yes_and_no]

I ve not yet to get around this issue in Rv17 legitimately (wonder if Rv22 actually solves it).

The way I do it: have the net area counted by room areas, normally, and get the sum.

Create another table reports fill region area where I have a fill region goes around the building outmost boundary for gross and another parameter to report the net by user input. And the efficient is a simple calc.

So in summary, there are still two manual steps: the boundary and the net sum input.

Let me know, Toan, if you do differently, bec I can't benefit from your 2022 file.

[ToanDN]

Yeah I do differently.

[jrathLHK5W]

OK ... I think I figured it out ... I will try it tomorrow ... 

I want gross and net for level 1. I create a level 1A do a units net area on level 1 and then do an overall area on level 1A. I put level 1A on a workset that is turned off most of the time. I can make level 1A maybe 6" or 12" above level 1.

[jrathLHK5W]

It still looks like that Revit is not capable of putting Gross and net areas in the same schedule

[RDAOU]

@jrathLHK5W 

it depends on how you define the gross and the net. If you place them on two different area type plans, then NO you can't. They would be two different spacial categories which may or may not be related to one another

In most cases it is a ration of X/Y. Being able to define the Gross and the Net in the same Area Type plan, there is no reason why Revit cannot report both in the same schedule

1. define the net
2. define the non-usable areas
3. the total would be sum of both which you calculate based on the
   • Net Area percentagewith respect to the grand total 
   • non-usable Area percentage with respect to the grand total

[yes_and_no]

I ll go with filled region in a separate schedule knowing AHJ quote their
fees, tax, allowable, etc. based on gross (which are more sqft).
I only use the net for internal/ schematic info with disclaimer notes.
Percentage use can come back and bite you.

[RDAOU]

hi @yes_and_no 

If you are happy with that, sure why not. 

I was only replying to the other question from the other forum visitor on whether this has been solved and if Net, Non-usable and gross can be all added into one schedule