CS1 Posted June 20, 2008 Share Posted June 20, 2008 In a worksheet how can I retrieve the value from the "BOT Z" field on a floor object? Quote Link to comment
Pat Stanford Posted June 20, 2008 Share Posted June 20, 2008 I hope I am wrong, but I don't think you can. A Floor is not a Plug-In Object and does not have a record defining it. If you don't have a record, you can't get any of the info from the object other than the standard information. The standard information does not contain the Z location. Maybe put a named locus at the BOT Z and reference that in the worksheet? Pat Quote Link to comment
CS1 Posted June 22, 2008 Author Share Posted June 22, 2008 I have 3 Design Layers Mod Ground Mod First Mod Second I have set the Layer heights to: 7.100m 9.815m 12.530m On each layer I have inserted one 3D Loci at 0.000 high since the height is goverend by the layer no the object. I have created a worksheet with a database. I have set the criteria to get the 3 x 3D loci on the particular layers and in the equation line I have entered <=BOTBOUND>. The worksheet says. Mod Ground = 9.350 Mod First = 9.350 Mod Second = 9.350 I also tried <=TOPBOUND> and get the same results. What am I doing wrong? Quote Link to comment
CS1 Posted June 22, 2008 Author Share Posted June 22, 2008 Ok after looking a bit further I see that the TOPBOUND and BOTBOUND are the Y coordinates on the page. How do I retrieve the Z value for the 3D Locis? Quote Link to comment
CS1 Posted June 23, 2008 Author Share Posted June 23, 2008 Can I retrieve the Z value for the 3D Locis? Quote Link to comment
Pat Stanford Posted June 24, 2008 Share Posted June 24, 2008 Unfortunately, No. The worksheet does not provide a way to get the Z value of objects. The best work around is to attach a custom record and then use a VectorScript to put the Z value of objects into that record. You can then display the record value in the worksheet. You just have to remember to attach the custom record to the objects of interest and to run/re-run the script each time you make changes to the z values and need to update the worksheet (please insert sarcastic voice into the the above sentence.) Pat Quote Link to comment
CS1 Posted June 24, 2008 Author Share Posted June 24, 2008 Haha thanks Pat. I havent used Vectorscripts yet so will have to do sum reading. Is this something worth adding to the "wishlist forum", or is there some reason why worksheets cant work with Z values? 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.