https://community.graphisoft.com/t5/Collaboration-with-other/Working-around-the-limitations-of-Property-Expressions/m-p/289087#M37800 I think you can only work with a fixed set of parameters and properties in the Expression Editor.<BR /> <BR /> That said, if you would make a list of 'element' costs properties for m1, m2, m3, piece etc, in theory you would be able to make schedules with costs if you fill out those fields in ArchiCAD.<BR /> <BR /> However I find it quicker to fill out the quantities in Excel, derived from a well set up schedule, since there still are quite a few things that need to be taken in to consideration for costs, that make little sense to model.<BR /> <BR /> One way or the other, you are inputting data / numbers in to a field of text/data. Favourites would streamline some of this, but in practice during design, things get changed around quite a bit, and whatever was put there from a favourite settings (cost per m2 or such) will likely have changed by the time you get to the cost calculation phase.<BR /> <BR /> While it is possible to get data in to an object from a text file or such, I think this method is a bit crude, but maybe someone with more experience can help out here.<BR /> <BR /> Going back and forth between excel and archicad schedule with Properties is working quite fast, unless you are trying to import back a spreadsheet with a few hundred fields of properties. Thu, 28 Feb 2019 12:23:23 GMT Erwin Edel 2019-02-28T12:23:23Z https://community.graphisoft.com/t5/Collaboration-with-other/Working-around-the-limitations-of-Property-Expressions/m-p/289086#M37799 <DIV class="actalk-migrated-content"><T>I'm trying to see if I can work around some limits regarding the new Formula expressions for Properties, which seem to only allow calculations based on the built-in element attributes along with hard-coded numbers. <BR /> <BR /> Does anyone know:<BR /> Is there a way for a Property formula to pull data from a standard GDL parameter of a library part OR the Property Object associated with an element, and use it in a formula expression? <BR /> <BR /> Also, is there a way to use a Global GDL script to pull data from a CSV or Text file and make it available in a global array that could be queried and accessed in other GDL scripts? <BR /> <BR /> These are the ideas I have for possibly accessing external databases of cost information to get cost reports within ARCHICAD.<BR /> <BR /> Thanks in advance to anyone who can give me a clue about how or whether these things are possible.</T></DIV> Wed, 27 Feb 2019 19:58:32 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Working-around-the-limitations-of-Property-Expressions/m-p/289086#M37799 Eric Bobrow 2019-02-27T19:58:32Z https://community.graphisoft.com/t5/Collaboration-with-other/Working-around-the-limitations-of-Property-Expressions/m-p/289087#M37800 I think you can only work with a fixed set of parameters and properties in the Expression Editor.<BR /> <BR /> That said, if you would make a list of 'element' costs properties for m1, m2, m3, piece etc, in theory you would be able to make schedules with costs if you fill out those fields in ArchiCAD.<BR /> <BR /> However I find it quicker to fill out the quantities in Excel, derived from a well set up schedule, since there still are quite a few things that need to be taken in to consideration for costs, that make little sense to model.<BR /> <BR /> One way or the other, you are inputting data / numbers in to a field of text/data. Favourites would streamline some of this, but in practice during design, things get changed around quite a bit, and whatever was put there from a favourite settings (cost per m2 or such) will likely have changed by the time you get to the cost calculation phase.<BR /> <BR /> While it is possible to get data in to an object from a text file or such, I think this method is a bit crude, but maybe someone with more experience can help out here.<BR /> <BR /> Going back and forth between excel and archicad schedule with Properties is working quite fast, unless you are trying to import back a spreadsheet with a few hundred fields of properties. Thu, 28 Feb 2019 12:23:23 GMT https://community.graphisoft.com/t5/Collaboration-with-other/Working-around-the-limitations-of-Property-Expressions/m-p/289087#M37800 Erwin Edel 2019-02-28T12:23:23Z