cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
2024 Technology Preview Program

2024 Technology Preview Program:
Master powerful new features and shape the latest BIM-enabled innovations

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

Calculations need to upgrade: wish for an excel-like scheme

gap
Booster

I often need to calculate the total amount of zone areas and compare it to some max area. I can sum zones using schemes but there is no way to do the comparison. I need this to be done automatically, not by manually typing the result to a text. I wish that Graphisoft would upgrade massively the functionality of schemes and provide us a excel-like scheme.

archiCAD 26
3 REPLIES 3
Karl Ottenstein
Moderator

There are 13 and 15 year old wishes for this...(and many more)...

 

https://community.graphisoft.com/t5/Wishes/Spreadsheet-capability-in-Schedules/m-p/182684

 

https://community.graphisoft.com/t5/Wishes/Calculation-formulas-in-schedules/m-p/49126

 

and the Roadmap "Idea Pool" includes this wish as "Calculations in Interactive Schedules":

https://graphisoft.com/product-roadmap/idea-pool

 

One of the forum moderators
AC 27 USA and earlier   •   macOS Ventura 13.6.7, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
poco2013
Mentor

This can easily be done via the Python API and has been demonstrated here by several people with different approaches. Mostly using Zone areas and custom properties. As to Graphisoft's promises for "Calculations in Interactive Schedules", I remain skeptical that anything useful will be provided other than a minimum calculator. Seems like a long time to wait for nothing significant (years away?)? Note: that Graphisoft has not bothered to even solicit any input on this feature and i doubt that they ever will

Gerry

Windows 11 - Visual Studio 2022; ArchiCAD 27
Ahmed_K
Advisor

Personally I prefer exporting schedules to excel and manage all data there, you just create a masterfile and link your exported schedules folder to it, 

Once you make changes on your file, excel will update all data, 

Excel have great calculation options, conditional calculations, diagrams, manual inputs, statistics, 

Graphisoft will add calculation option for schedules but it woulnd not be very advanced, 

AMD Ryzen 9 3900X, 32 GB RAM, RTX 3080 10 GB
Archicad 27
Windows 11 professional
https://www.behance.net/Nuance-Architects