# 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'

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

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

nothing shown for boards or infill...

What does Length(vertical boards) give you?

1 hour ago, Tom W. said:

What does Length(vertical boards) give you?

That results in 96

Depth (vertical boards) = 2

I can't think of anything that is 96x2 in the fence... the posts are set at 96" intervals - but are 4x1.62 in profile.

Maybe post the file

Here is the file.

The worksheet just has some test formulas.

I'm really just trying to figure out what data you can get at this point.

...discovering that things like "post height" are the cumulative height of all the post and to be divided by the number of posts.

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.

@Tom W. I'll try that.

...In this case I would then also need to multiply by two as I have the vertical boards lapped - to do that I had to make a profile with both a front board and a back board lapped in one profile

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×
×

• KBASE
• #### MARIONETTE

×
• Create New...