xander1027 Posted May 23, 2017 Share Posted May 23, 2017 Sorry if this is an obvious questions, however I tried searching on the forums but could not find anything. Im looking for the list of worksheet functions for spaces. I would like to see what they all are however right now want to include a ceiling height in a finish schedule. Thank you Quote Link to comment
Pat Stanford Posted May 23, 2017 Share Posted May 23, 2017 There are only two true Functions for getting info on Spaces. These can be accessed from the Insert:Function menu item. For spaces these are GetSpaceNameForObj and GetSpaceNumberForObj. There are many more options for Spaces (and most other Plugin Objects [PIOs]) based on the Record.Field data. For the ceiling height try ='Space'.'11_Net Height' Be careful with the quotes since the filed name has a space in it they are required. To get a list of all of the fields of a PIO, place a single instance in a drawing and run the script at the bottom of the following thread. It will create a worksheet showing all of the possible fields for that type of PIO. Remember that the internal names do not always match what is displayed in the PIO or the Setting Dialog box. Also, especially for spaces, there are sometimes similar fields but one is a text field and the other a numeric value. If you want to do calculations you have to use the numeric field. 1 Quote Link to comment
Ramon PG Posted January 7, 2021 Share Posted January 7, 2021 Wow... been looking for those two for a while, thanks!! GetSpaceNameForObj and GetSpaceNumberForObj. Quote Link to comment
Ramon PG Posted March 8, 2022 Share Posted March 8, 2022 (edited) On 5/22/2017 at 11:48 PM, Pat Stanford said: There are only two true Functions for getting info on Spaces. These can be accessed from the Insert:Function menu item. For spaces these are GetSpaceNameForObj and GetSpaceNumberForObj. There are many more options for Spaces (and most other Plugin Objects [PIOs]) based on the Record.Field data. For the ceiling height try ='Space'.'11_Net Height' Be careful with the quotes since the filed name has a space in it they are required. To get a list of all of the fields of a PIO, place a single instance in a drawing and run the script at the bottom of the following thread. It will create a worksheet showing all of the possible fields for that type of PIO. Remember that the internal names do not always match what is displayed in the PIO or the Setting Dialog box. Also, especially for spaces, there are sometimes similar fields but one is a text field and the other a numeric value. If you want to do calculations you have to use the numeric field. Hello, again. Can one create spaces from an excel spreadsheet? I created an excel from a spaces worksheet but cannot manage to do the reverse. Possible? Edited March 8, 2022 by Ramon PG Quote Link to comment
Pat Stanford Posted March 8, 2022 Share Posted March 8, 2022 I don't believe there is an easy way to create objects (any kind) from an external worksheet. You could probably write a script that would read in all the parameters from an imported worksheet and then create the Space object. It would not be a complicated script, but it would be fairly long as it would need to set all/most of the parameters. Or perhaps just create the Space Object and then copy/paste the data from the external worksheet in. But that would only work with Record.Field cells. Quote Link to comment
Ramon PG Posted March 8, 2022 Share Posted March 8, 2022 It would be useful if this could be done. You could give a client a list (Excel?) of items and once done importing it it could give you data on each space's requirement. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.