Jump to content

Can anyone think of a way to get fence vertical board infill height into a worksheet?


Recommended Posts

can anyone think of a way to get the height of fence panels?

 

It's determined by the difference between the 'Infill top line above grade' and 'Infill bottom line above grade'

In this case it's 6'

image.thumb.png.8952875ce31609f1e641fea90519e7c4.png

 

But I can't figure out the syntax to grab those fields.

 

The 'functions' options that are offered for "specialized for fence' are:

image.png.88fe70bb3286bd9c87937f240ac328ae.png

 

nothing shown for boards or infill...

Link to comment

The only way I can see to do it is to use =LENGTH('VERTICAL BOARDS') in one column to give you the total length of all the vertical boards in the fence then =COUNT('VERTICAL BOARDS') in a second column to give you the total number of vertical boards in the fence, then in a third column if you divide the first column by the second column that should give you the height of an individual board.

  • Like 2
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...