Calculating the Lower Basal Wedge - Alternate Method

General discussions of measurement techniques and the results of testing of techniques and equipment.

Moderators: edfrank, dbhguru

#1)  Calculating the Lower Basal Wedge - Alternate Method

Postby M.W.Taylor » Fri Sep 29, 2017 5:22 pm

The attached is an alternate method for computing the lower basal wedge volume using the ground perimeter instead of the horizontal offset of high side ground level vs. low side ground level. In some cases the perimeter with a tapeline is easier to obtain. In other cases as with older data, only the perimeter data was taken so this is a way to update old data sets with the improved lower basal wedge model without needing to go back to the tree to get a horizontal offset. The equation gets rather ugly so a numeric solution is needed. See attached write-up and spreadsheet with visual basic to solve the complex equation.

Michael Taylor

WNTS VP
Attachments
slant frustum perimeter solution-RevB.docx
write up on new alternate method
(62.06 KiB) Downloaded 7 times
slant frustum numeric perimeter solver.xlsb
spreadsheet with visual basic embedded. Enter perimeter instead of horizontal offset in cells AH1 instead of offset in AF1. Then press the black button to solve for horizontal offset. minor and major axis of the base will also be calculated. Cells with red borders should not be changed.
(21.96 KiB) Downloaded 6 times
User avatar
M.W.Taylor
 
Posts: 383
Joined: Sun May 29, 2011 12:45 pm
Location: Northern California
Has Liked: 34 times
Has Been Liked: 322 times
Print view this post

#2)  Re: Calculating the Lower Basal Wedge - Alternate Method

Postby dbhguru » Fri Sep 29, 2017 7:50 pm

Michael,

  Great work. We've come a long way from the days when tree volume was calculated through log volumes taken over a well behaved section of trunk.

Bob
Robert T. Leverett
Co-founder and Executive Director
Native Native Tree Society
Co-founder and President
Friends of Mohawk Trail State Forest
User avatar
dbhguru
 
Posts: 4034
Joined: Mon Mar 08, 2010 10:34 pm
Location: Florence, Massachusetts
Has Liked: 4 times
Has Been Liked: 1078 times
Print view this post


Return to Measurement and Dendromorphometry

Who is online

Users browsing this forum: No registered users and 0 guests

cron