Jump to content

2 worksheet questions


toonau69

Recommended Posts

I am creating worksheets that contain Height and Spread values and have 2 querys.

Query 1. The Height is appearing OK...thanks to your help on my last issue [smile]

However I am expecting the Spread value on the Define Plant dialog to be displayed but am seeing the Spread that is displayed on the Set Plant Tool Options.

Select the Plant Settings button and the Spread that is displayed in the Set Default Plant Tool Options dialog is the one populated in the worksheet.

FYI the header used is:

='plant record'.spread

The end game for me is to show a worksheet with the spread and height from the Define Plant dialog.

Query 2. Ideally i would prefer to show the height and spread ranges from the Plant Reference DB. Can you help with the worksheet header values for these attributes?

thanks again for your help

toonie

Link to comment
  • Vectorworks, Inc Employee

1. The spread that is displayed will be the actual drawn spread of the plant (which as you have seen, is what the plant tool sees.) If you don't change the default for the tool when you choose a plant from your catalog, this value should match the value in the plant definition.

2. The values for the stored height and spread ranges are as follows:

Height

01: <=12in

02: >12 - 18in

03: >18 - 24in

04: >24 - 30in

05: >30in - 3ft

06: >3 - 5ft

07: >5 - 10ft

08: >10 - 15ft

09: >15 - 35ft

10: >35 - 50ft

11: >50 - 80ft

12: >80 - 100ft

13: >100ft

Spread

01: <=12in

02: >12 - 24in

03: >24 - 36in

04: >36in - 4ft

05: >4 - 7ft

06: >7 - 12ft

07: >12 - 20ft

08: >20 - 35ft

09: >35ft

The only way I know of to return these "verbose" values from the stored integer values is to use a nested IF() function.

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...