Jump to content

Where to find worksheet functions for spaces.


Recommended Posts

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 

Link to comment

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.

 

 

  • Like 1
Link to comment
  • 3 years later...
  • 1 year later...
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 by Ramon PG
Link to comment

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.

Link to comment

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...