==============================================================================
TOPIC: More from the Formula Factory
http://groups.google.com/group/entstrees/browse_thread/thread/0167e5cf3cd8b354?hl=en
==============================================================================
== 1 of 1 ==
Date: Wed, Nov 14 2007 6:50 pm
From: dbhguru
Ed,
Right. Will started the whole thing by sending me a spreadsheet that
consisted of columns A  F, showing the taper of the listed hemlocks
from their breasthigh diameters to their diameters at 95.5 feet.
Will was getting a feel for how quickly or gradually the giant
hemlocks tapered in terms of how much diameter they had lost going
from 4.5 to 95.5 feet. I added the remaining columns in order to
predict what the taper would be were the whole form of the tree a
paraboloid, a cone, half way between a paraboloid and a cone (or
conoid as it is sometimes called), and 2/3rd paraboloid and 1/3
cone. The percentage columns show how much the the predicted
deviates from the actual. The way I developed the predictive
equations, I employed radius, thus the "r" columns. I then
convert to circumference, thus the "c" columns. I
frequently bounce between circumference, diameter, and radius
without much thought given. I probably eed to be more consistent for
the sake of the rest of you.
The R, H, h1, and h2 columns figure into the frustum formulas for
100% paraboloid and cone and the hybrids. The direction of the
analysis suggests two things: (1) the huge hemlocks tend toward the
paraboloid form, and (2) there are mavericks among them that don't
behave themselves.
Bob
==============================================================================
TOPIC: OG Hemlock modeling
http://groups.google.com/group/entstrees/browse_thread/thread/ae5d2d51eb90c0d6?hl=en
==============================================================================
Will,
The following table shows the results of testing 38
modeled OG hemlocks against standard shapes. All trees are
ones you've climbed and modeled. The notes in the table explain
how well modeled hemlocks fit the paraboloid, cone, 50% paraboloid
and 50% cone, 67% paraboloid and 33% cone, and 33% paraboloid and
67% cone. More to come.
Bob
Results
of OG hemlock modeling 









Sample
Size 
%
Fit Parabola 
Abs(%)
Parabola 
%
Fit Cone 
Abs(%)
Cone 
Para
Cone %
5050 
Abs(%)
5050 
Para
 Cone %
6733 
Abs(%)
6733 
Para
 Cone %
3367 
Abs(%)
3367 


38 
13.4 
18.5 
32.5 
32.5 
9.6 
16.1 
1.9 
14.4 
17.2 
20.4 















Notes: 
Objective
is to predict circumference at a designated height using a
variety of predictive models. 

utilizing the following formula. The designated
height is 100 feet. 


















c
= C*[f1*SQRT((Hh)/H) + (1f1)*(Hh)/H] 








c
= the predicted circumference for the mix of paraboloid
and cone 





based
on proportions f1 and (1f1) 






















C
= circumference at 4.5 feet 









H
= total height 











h
= height at designated point where c is calculated. 



















%
fit is calculated by:
[(Predicted  Actual)/Actual]*100 



















The
best fit is 67% paraboloid and 33% cone 




















The
2nd best fit is 50% paraboliid abd 50% cone 




















The
worst fit is the cone. It underpredicts in 100% of the
cases. 





The
paraboloid overpredicts in 27 of 38 cases. 







The
6733 overpredicts in 15 of 38 cases. 








The
5050 overpredicts in 6 cases, meaning that it
underpredicts 





in 32 cases. This means that the correct mix needs
more paraboloid 
















