The Global Archicad Community

Stay informed. Get help. Share your knowledge.

Sections/Elevation/3D Document/Worksheets/Details etc., Annotations, Texts, Labeling, Autotext/Project Info, Layouting, Renovation Filters, Graphic Overrides, Revisions/Issues, Printing/Plotting, PDF, Mark-Up, etc.

Moderators: Karl Ottenstein, LaszloNagy, ejrolon, Barry Kelly, Gordana Radonic, nbalogh, mnguyen, gkmethy

Is it possible to add parameters/formulas to schedules to calculate percentages of zone areas to a fixed number?

For example, the percentage of floor area to site area. We adjust zones to calculate floor area as we design a building then we work out the % but we would had to manually add it as a text.
area schedules percentages.PNG
area schedules percentages.PNG (25.79 KiB) Viewed 125 times
Shooting from the hip here (haven’t tested it), but have you tried adding an expression field in the Property Manager and making it available to your zones?.
Since you are comparing a sum total of a set of zones (or fills, not sure which it is) to another single one, I don't think this calculation can be done with properties. Since properties are set for a single element.

We do these sort of calculations in Excel, since we need to derive a lot more calculations from the square meters of a project. That does mean manually typing in the values in excel initially, but even with large appartment projects that rarely means more than a few stories and appartment types.

You can also add dummy text fields to schedules where you can just type values if you don't like adding the text to layout.

Like Erwin said, Excel is the way to go. You can "link" the information in a sort of automatic way.

- Prepare a schedule that has every bit of information you'll need to make your calculations, like floor number, floor name, dwelling ID, zone ID, zone area, category, etc.
- Save the resulting schedule to .xlsx, or better yet create a publisher set of the information
- In a new excel file link the info you just saved/published.
- With this as a database, use pivot tables to analyze the data and create any information you need.

Change something in the project and just publish again and update the link in excel. It is a great workflow!
If you need to place it back to a layout, just create a PDF and you can link that in AC.

Hope that helps.
Best regards.