Calculations and formulas in Schedules

[Erik Bjornhage]

So, this is perhaps a bump from previous topics but the full functionality has not yet been solved.

My wish is for spreadsheet style calculations in Schedules.

As a simple example:

A big residential project - with a number of different apartment types (1 bed, 2 bed, 3 bed etc.) which is of course a part of a total number of apartments. Currently we cannot list these apartments and have the schedule display their repective percentages in relation to the total. This would be extremely beneficial to general project management and how and what we can deliver to clients.

[yuryuymanov]

A giant leap into the bright future if it were possible to enter parameters and formulas, refer to the internal data of the project, create dependences between data directly when editing the table, and be able to have any custom format of tables like this all are in the Excel or Google Sheets. I face this every day, and it is my dream!

[poco2013]

Graphisoft might take a look at it's sister company, Vectorworks, which has had the capability to run Python scripts within schedules for some time although i believe they call them worksheets.

Although the last time i looked, data access was limited.

That is the major problem with using Python in Archicad today --- limited access to data and functions and a non existent easy interactive data display scheme. Other than that -- easy peasy

[yuryuymanov]

Scripts are really powerful, and your idea is great! But i think, for most of users the graphical interface is more easy to use, like it is in Excel, Google Sheets or other similar software. I understand that functionality may be to complex to be directly added to the Archicad, this is just a dream. But if we could have a direct link to Excel or GSheets with real-time sync and ability to import in Layouts as a Drawing with automatic update function - it will be really good and easier to implement, i guess!

[Minh Nguyen]

Dear All,

Thank you for sharing your ideas and opinions regarding this request!

I'm glad to say that we took notice and we have added this Wish into our Wish database.
(For future reference, you can refer to it as IDEA-4483)

I hope we see this get implemented in the future.
Have a great day!

Best regards,
Minh

[cocoloco]

Omg omg omg THIS!!!! CREATE DEPENDENCES...  We spent days on doing schedule and dare if we do adjustment

[Stefano fuma]

great idea

[nitizz]

Very great Idea. Need it for calculation of areas
-Minus

-Divide

-Multiply

-Percentage

[Mats Knutsson]

This is a recurring wish originating before electricity was invented. Would be epic!

[Vlaho]

That would be fantastic!

[Francois_MCD]

Hi @Erik Bjornhage 
I might be missing something to understand your wish but looking at your example, I expect that using Expressions in Properties might give you exactly the calculations that you are looking for.
There are several ways (ie. use Layers / IDs / Properties / Zone Categories for each type) and filter by means of these parameters to distinguish the 1 bed, 2 bed, 3 bed units from each other so that they can be filtered in the schedules & calculations.
Yes, it does not work the same way of doing as in Excel / Google Sheets, etc but you can get the exact same outcome with quite good flexibility.