topic Re: Calculation formulas in schedules in Wishes forum
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49128#M5039
<BLOCKQUOTE>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...</BLOCKQUOTE>
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...Wed, 12 Mar 2008 21:14:55 GMTRob2008-03-12T21:14:55ZCalculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49126#M5037
<DIV class="actalk-migrated-content"><T>I just wonder if we could extend functionality of schedules to make calculations much easier and more usable...</T></DIV>Tue, 11 Mar 2008 21:57:32 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49126#M5037Rob2008-03-11T21:57:32ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49127#M5038
<BLOCKQUOTE>Rob wrote:<BR />I just wonder if we could extend functionality of schedules to make calculations much easier and more usable...</BLOCKQUOTE>
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...Wed, 12 Mar 2008 17:41:23 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49127#M5038vfrontiers2008-03-12T17:41:23ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49128#M5039
<BLOCKQUOTE>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...</BLOCKQUOTE>
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...Wed, 12 Mar 2008 21:14:55 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49128#M5039Rob2008-03-12T21:14:55ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49129#M5040
<BLOCKQUOTE>Rob wrote:<BR /><BLOCKQUOTE>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...</BLOCKQUOTE>
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...</BLOCKQUOTE>
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.Tue, 08 Apr 2008 16:44:37 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49129#M5040Ignacio2008-04-08T16:44:37ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49130#M5041
<BLOCKQUOTE>Ignacio wrote:<BR />
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.</BLOCKQUOTE>
Yes! Exactly...Tue, 08 Apr 2008 19:58:08 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49130#M5041vfrontiers2008-04-08T19:58:08ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49131#M5042
Ugh,<BR />
<BR />
I spent the day fighting with the schedules to get them to work right. Now I wish I could vote essential....AGAINWed, 16 Apr 2008 00:37:09 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49131#M5042Erich2008-04-16T00:37:09ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49132#M5043
<BLOCKQUOTE>Erich wrote:<BR />Ugh,<BR />
<BR />
I spent the day fighting with the schedules to get them to work right. <B>Now I wish I could vote essential....AGAIN</B></BLOCKQUOTE>
Voted for you as I don't have a need for it myself. <IMG src="https://community.graphisoft.com/legacyfs/online/emojis/icon_wink.gif" style="display : inline;" />Wed, 16 Apr 2008 04:32:38 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49132#M5043Anonymous2008-04-16T04:32:38ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49133#M5044
Thanks S2art! <IMG src="https://community.graphisoft.com/legacyfs/online/emojis/icon_biggrin.gif" style="display : inline;" />Sat, 19 Apr 2008 04:57:06 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49133#M5044Erich2008-04-19T04:57:06ZCalculations in Schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49134#M5045
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.Mon, 23 Mar 2015 23:13:42 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49134#M5045gdford2015-03-23T23:13:42ZRe: Calculations in Schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49135#M5046
Absolutely!<BR />
<BR />
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.<BR />
<BR />
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!)<BR />
<BR />
Also, the ability to add prefixes and suffixes to the Value cells. It could be FT, M, SF, etc.<BR />
<BR />
While there is certainly a lot more features than can be added, it seems that Graphisoft needs to be encouraged in small, manageable segments.<BR />
<BR />
Regards,<BR />
<BR />
Joe A.<BR />
ArchiCAD User since 8.0Thu, 14 May 2015 17:02:23 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49135#M5046Anonymous2015-05-14T17:02:23ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49136#M5047
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.<BR />
<BR />
*sigh* <IMG src="https://community.graphisoft.com/legacyfs/online/emojis/icon_rolleyes.gif" style="display : inline;" />Thu, 27 Jun 2019 14:27:22 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49136#M5047Anonymous2019-06-27T14:27:22ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49137#M5048
Expression-defined Properties are available in ARCHICAD:<BR />
<BR />
<IFRAME width="640" height="360" src="https://www.youtube.com/embed/eE-4fnx0YyE" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture" allowfullscreen=""></IFRAME><BR />
<BR />
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.Thu, 27 Jun 2019 14:44:54 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49137#M5048Laszlo Nagy2019-06-27T14:44:54ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49138#M5049
<BLOCKQUOTE>LaszloNagy wrote:<BR />
<BR />
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.
</BLOCKQUOTE>
<BR />
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.<BR />
<BR />
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.Fri, 25 Oct 2019 15:12:54 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49138#M5049David Larrew2019-10-25T15:12:54ZRe: Calculation formulas in schedules
https://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49139#M5050
<BLOCKQUOTE>David wrote:<BR />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.</BLOCKQUOTE>
<BR />
Hi David, long time no see on the forum. <IMG src="https://community.graphisoft.com/legacyfs/online/emojis/icon_smile.gif" style="display : inline;" /><BR />
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.<BR />
Yes, the dummy cells would be nice. You can make a wish for it any time. If you do, please post its link here.<BR />
<BR />
<BLOCKQUOTE>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.
</BLOCKQUOTE>
<BR />
Yes, that was neat. I think it did not work on Mac though. This might be the reason why it was discontinued.Fri, 25 Oct 2019 17:08:06 GMThttps://community.graphisoft.com/t5/Wishes-forum/Calculation-formulas-in-schedules/m-p/49139#M5050Laszlo Nagy2019-10-25T17:08:06Z