cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:
Design forum

## Adding percentage to Zone Area schedule

Booster

Hi,

How do you add a percentage column to a zone area schedule? Where each zone/area is a percentage of the total site area?

1 ACCEPTED SOLUTION
Solution
Moderator

This is what you need to do.

Barry.

One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10
15 REPLIES 15
Expert

I think you’d have to create a new property expression and a zone for the entire building or site area to calculate it or have a property which defines the overall area figure then use an expression to calculate the percentage of each zone based on that figure.

Lee Hankins
macOS Monterey (12.5)

To do this correctly,  you need to somehow collect all the data about the zones in one object, because formulas (property expressions) work at the individual element level. How can you do it?
In this case, it's probably possible to create an property for overall zone to have a total area figure, and then use an expression to calculate the percentage of each zone based on this figure, but this is a semi-automatic method. For complex projects, this is not a very suitable solution.

Unfortunately, the truth is that it's better to export this schedule to Excel, add a percentage column, and then import it back into Archicad.
Maybe you know how to do it differently?

Andrii
AC 8.1 - 25 INT/POL 5010
Moderator

Zones can not talk to each other and schedules can not do calculations, so you have to set it up with properties with expressions as Lee mentioned.

You need to create a fixed property for zones where you can manually set that property value to the overall area of all of your zones.

Then set up your percentage expression, based on the actual zone area as a percentage of the total area property.

See the Help reference for a similar example ... https://help.graphisoft.com/AC/25/INT/index.htm?rhcsh=1&rhnewwnd=0&rhmapid=#t=_AC25_Help%2F045_Prope...

Except is it not quite the same - the 'mandatory glazed area' which is a fixed value, will become your 'total zone area' fixed value.

If your total zone area ever changes, you will have to manually adjust that fixed value.

Barry.

One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10

Hi Barry,

I've created a new property in "General Rating", but it's like the schedule can read the property to populated it?

Use "Calc Area" --> convert unit to String --> convert to Number ...

Solution
Moderator

This is what you need to do.

Barry.

One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10

Thanks Barry. I managed to get it. (See attached).

Booster

It just seems a very convoluted way to determine simple percentages from the model.

Expert

is there a simpler way?

In the end what is your Objective?
Moderator

@ryejuan wrote:

is there a simpler way?

Manually doing the calculations yourself.

Or exporting the zone areas to an external spreadsheet you have set up that can do the calculations for you - but I wouldn't say that is easier.

Barry.

One of the forum moderators.
Versions 6.5 to 25
Dell XPS- i7-6700 @ 3.4Ghz, 16GB ram, GeForce GTX 960 (2GB), Windows 10
Dell Precision 3510 - i7 6820HQ @ 2.70GHz, 16GB RAM, AMD FirePro W5130M, Windows 10

In a way that's what I'm currently doing for most projects. Prone to error specially if you are rushing things and might overlook certain items. Am not sure how difficult it is for Graphisoft to incorporate this kind of things in their built in schedules (wishing that there is a button to press with % or show all FFL or Glass symbol for your door and windows schedules.)

In the end what is your Objective?
Booster

I've been asked to do it this way, where I'm gleaning data direct from the model.

I have not been show this method (before now) by the person who asked me to do it. so I'm assuming it could have been done.

I know and saw the revit dept here in our office can do computations in schedules vs Archicad well its always an on going debate which is best but trying to make it work is also another story. 😅

Showing the  plot ratio (Proposed GFA / Site Area) is also a simple yet manual task in Archicad, there's no way I can generate it automatically.

In the end what is your Objective?
Booster

Yes. I'm a Revit User also, and percentages of site areas can be collated easily.

Python Script ???

Gerry

Windows 10 - Visual Studio 2019; ArchiCAD 26

I wish everyone has time to fiddle and learn with several on going projects at hand not that easy... 😶

In the end what is your Objective?

Labels
Latest solutions