Wishes
Post your wishes about Graphisoft products: Archicad, BIMx, BIMcloud, and DDScad.
SOLVED!

Calculation formulas in schedules

Rob
Graphisoft
Graphisoft
I just wonder if we could extend functionality of schedules to make calculations much easier and more usable...
::rk
13 REPLIES 13
Anonymous
Not applicable
This would make so much sense to have. Off the top of my head, room light and vent calculations, site coverage and FAR, egress width required/ number of exits, room occupancy; all of these tedious calculations would become automatic. I would look for more, but I have to go export some schedules to Excel so that I can attach them after the math is done.

*sigh*
Solution
Laszlo Nagy
Community Admin
Community Admin
Expression-defined Properties are available in ARCHICAD:



You can then schedule these Properties. Additionally, the value of these Properties can be displayed in Labels, used in Find & Select criteria, Graphic Override criteria and Collision Detection criteria. So this solution is more comprehensive than having to ability to do calculations/work with formulas in Schedule cells.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27
David Larrew
Booster
LaszloNagy wrote:

You can then schedule these Properties. Additionally, the value of these Properties can be displayed in Labels, used in Find & Select criteria, Graphic Override criteria and Collision Detection criteria. So this solution is more comprehensive than having to ability to do calculations/work with formulas in Schedule cells.

The addition of formulas/expressions in Properties is welcome. But falls short when you need to calculate percentages or other formula-based calculations between scheduled elements. Plus the ability to have/add "dummy" cells in a schedule would be highly productive. FYI - Revit does all of this.

I remember when we used to be able to use OLE and paste an Excel spreadsheet into a Layout and interactively work in the spreadsheet in AC or Excel. It would be nice to get that functionality back.
David Larrew, AIA, GDLA, GSRC

Architectural Technology Specialist

a r c h i S O L U T I O N S



WIN7-10/ OSX 10.15.7

AC 5.1-25 USA
Laszlo Nagy
Community Admin
Community Admin
David wrote:
The addition of formulas/expressions in Properties is welcome. But falls short when you need to calculate percentages or other formula-based calculations between scheduled elements. Plus the ability to have/add "dummy" cells in a schedule would be highly productive. FYI - Revit does all of this.

Hi David, long time no see on the forum.
I would solve this by defining a new Property that would contain the percentage value, and by defining another Property that would multiply this percentage Property with the other Property. So the calculations would be done in the background, and you could display all 3 Properties involved in the Schedule.
Yes, the dummy cells would be nice. You can make a wish for it any time. If you do, please post its link here.

I remember when we used to be able to use OLE and paste an Excel spreadsheet into a Layout and interactively work in the spreadsheet in AC or Excel. It would be nice to get that functionality back.

Yes, that was neat. I think it did not work on Mac though. This might be the reason why it was discontinued.
Loving Archicad since 1995 - Find Archicad Tips at x.com/laszlonagy
AMD Ryzen9 5900X CPU, 64 GB RAM 3600 MHz, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), Windows 10 PRO ENG, Ac20-Ac27