Wishes forum
cancel
Showing results for
Did you mean:

## Calculation formulas in schedules

Graphisoft
I just wonder if we could extend functionality of schedules to make calculations much easier and more usable...
::rk
1 ACCEPTED SOLUTION
Solution
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.
....................................................................................................
AMD Ryzen 1700X CPU, 48 GB RAM, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
13 REPLIES 13
Contributor
Rob wrote:
I just wonder if we could extend functionality of schedules to make calculations much easier and more usable...
And while we're at it, we should just have cells that we can type freely, without having to add parameters to EACH object / element. The should be recognizable as NUMBERS or TEXT for inclusion into those CALCUATIONS...
Duane
Visual Frontiers
AC22 6021:|: AC24 4007:|: Enscape3:|:TwinMotion
DellXPS 4.7ghz i7:|: 8gb GPU 1070ti
Graphisoft
And while we're at it, we should just have cells that we can type freely, without having to add parameters to EACH object / element. The should be recognizable as NUMBERS or TEXT for inclusion into those CALCUATIONS...
a very good idea, I would call those 'tags'. So we could tag each object with any number of element-specific tags that could be used in schedules etc...
::rk
Enthusiast
Rob wrote:
And while we're at it, we should just have cells that we can type freely, without having to add parameters to EACH object / element. The should be recognizable as NUMBERS or TEXT for inclusion into those CALCUATIONS...
a very good idea, I would call those 'tags'. So we could tag each object with any number of element-specific tags that could be used in schedules etc...
Actually Rob is talking more of basic spreadsheet functionality --text or numeric values (or formulas, which was the point of the thread) tied to the cell and not to the object or database value of any kind. You could do all of this in the Minicad pre-VectorWorks spreadsheets, which handled database formulas too, in 1995.
Contributor
Ignacio wrote:
Actually Rob is talking more of basic spreadsheet functionality --text or numeric values (or formulas, which was the point of the thread) tied to the cell and not to the object or database value of any kind. You could do all of this in the Minicad pre-VectorWorks spreadsheets, which handled database formulas too, in 1995.
Yes! Exactly...
Duane
Visual Frontiers
AC22 6021:|: AC24 4007:|: Enscape3:|:TwinMotion
DellXPS 4.7ghz i7:|: 8gb GPU 1070ti
Newcomer
Ugh,

I spent the day fighting with the schedules to get them to work right. Now I wish I could vote essential....AGAIN
Erich

AC 19 6006 & AC 20
Mac OS 10.11.5
15" Retina MacBook Pro 2.6
27" iMac Retina 5K
Anonymous
Not applicable
Erich wrote:
Ugh,

I spent the day fighting with the schedules to get them to work right. Now I wish I could vote essential....AGAIN
Voted for you as I don't have a need for it myself.
Newcomer
Thanks S2art!
Erich

AC 19 6006 & AC 20
Mac OS 10.11.5
15" Retina MacBook Pro 2.6
27" iMac Retina 5K
Enthusiast
It would be very handy to have the ability to place calculation in schedules or to export the schedule to another internal to archicad spread-sheet type process that would let me work in a more spread sheet type environment. It is a shame that to get calculations on scheduled information done in a reasonable manner I have to export the schedule and then attach an external doc back to my project.
Gary Ford
Self Employed - Modeling, Estimating, Construction
Win 10 - ASUSTeK Zephyrus M GU502GV - 64 bit
Intel(R) Core(TM) i7-9750H CPU @ 2.60 GHz
16.0 GB ram
Anonymous
Not applicable
Absolutely!

There are numerous situation where an enhanced scheduling tool in ArchiCAD could eliminate the need to use a third party application such as Excel or Numbers. Once a third party application is used, the benefits of BIM are lost.

I could imagine a series of simple columns that can be added to a schedule scheme; such as one column for basic mathematical operations; +, -, * & /; one for = and then a third for the calculated total. (You know, just like Excel and Numbers!)

Also, the ability to add prefixes and suffixes to the Value cells. It could be FT, M, SF, etc.

While there is certainly a lot more features than can be added, it seems that Graphisoft needs to be encouraged in small, manageable segments.

Regards,

Joe A.
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
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.
....................................................................................................
AMD Ryzen 1700X CPU, 48 GB RAM, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25
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
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.
....................................................................................................
AMD Ryzen 1700X CPU, 48 GB RAM, Nvidia GTX 1060 6GB, 500 GB NVMe SSD
2x28" (2560x1440), WIN10 PRO ENG, AC20-AC25

Latest solutions

Most liked posts