Documentation
About Archicad's documenting tools, views, model filtering, layouts, publishing, etc.

Add calculation parameters to schedules

Yvonne
Advocate
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.
AC26 | Win11 | 64 bit | 32Gb RAM | Intel i9-9900K @ 3.60GHz
3 REPLIES 3
Marc H
Advisor
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?.
“The best thing about the future is that it comes one day at a time.” - Abraham Lincoln

AC27 USA on 16” 2019 MBP (2.4GHz i9 8-Core, 32GB DDR4, AMD Radeon Pro 5500M 8G GDDR5, 500GB SSD, T3s, Trackpad use) running Sonoma OS + extended w/ (2) 32" ASUS ProArt PAU32C (4K) Monitors
Erwin Edel
Rockstar
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.
Erwin Edel, Project Lead, Leloup Architecten
www.leloup.nl

ArchiCAD 9-26NED FULL
Windows 10 Pro
Adobe Design Premium CS5
sinceV6
Advocate
Hi.

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.