|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
INSTRUCTIONS |
|
|
|
|
|
|
|
1. Use the "Volume Sheets" to obtain
aggregate class data. |
|
|
|
2. Enter aggregate data in the green cells
(species, #trees, #sawlogs, #pulpsticks, #plots) |
|
|
|
3. Use the calculated averages to look up the
"factors" |
|
|
|
4. Enter the appropriate factor in the green
cells. |
|
|
|
5. Volumes and BA will be calculated (red
text). |
|
|
|
6. This spreadsheet can be used to calculate
figures for each species, or for the entire stand. |
|
|
|
7. If a printer is attached, you can print
this spreadsheet by selected the cells below and printing just that
selection. |
|
|
|
(Click "File",
then "print", then the "selection" button, then
"OK" |
|
|
|
8. |
Once stand data are
entered, you can model changes by "harvesting" trees (tables in the
blue section). |
|
|
For the Excel spreadsheet, click here. |
|
|
|
|
|
|
|
|
|
|
|
|
|
Enter number of trees you
would like to cut in the ORANGE column |
|
|
|
|
VOLUME AND BASAL AREA
CALCULATIONS BASED ON FIELD DATA |
|
|
|
to see what effect that
will have on the total stand volumes and basal area. |
|
|
|
|
|
|
CAUTION - Do NOT change
any other cell!! |
|
|
|
Species: |
all species |
|
|
|
Enter data in green cells
ONLY |
|
|
Note: Right-clicking a highlighted cell(s), and
selecting "clear contents" is the |
|
|
|
|
|
|
|
|
best way to remove
numbers in the orange column. |
|
|
|
|
|
|
|
Step 1: Fill in green cells in table below using |
|
|
|
|
|
PERCENT OF EACH SPECIES BY
TREE COUNT, |
|
|
|
HARVEST CALCULATOR |
|
|
|
|
species names and sums from
field tally sheets |
|
|
|
|
|
SAWTIMBER, AND PULPWOOD |
|
|
Existing stand data |
|
|
|
Post-harvest stand data |
|
|
|
|
Species |
#Trees |
#Sawlogs |
#Pulpsticks |
|
|
|
|
|
|
|
|
Species |
#Trees |
#Sawlogs |
#Pulpsticks |
|
Species |
#Trees |
#Sawlogs |
#Pulpsticks |
|
#Cut |
#Left |
|
Current Stand Description |
|
|
|
|
|
|
|
|
|
Board Feet Per Acre: |
#DIV/0! |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
Board Feet Per Acre: |
###### |
|
|
|
|
|
|
|
|
|
Cords per Acre: |
#DIV/0! |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
5 |
-5 |
|
|
Cords per Acre: |
###### |
|
|
|
|
|
|
|
|
|
Stand Basal Area: |
#DIV/0! |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
1 |
-1 |
|
|
Stand Basal Area: |
###### |
|
|
|
|
|
|
|
|
|
(square feet / acre) |
|
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
10 |
-10 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
Post-harvest Description |
|
|
|
|
|
|
|
|
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
10 |
-10 |
|
|
New Tree Count |
-32 |
|
|
|
|
|
|
|
|
SAWLOG FACTORS |
375 if trees avg. 1.0 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
New Sawlog Count |
271 |
|
|
|
|
|
|
Step 2: |
|
|
|
375 if trees avg. 1.5 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
New Pulpstick Count |
0 |
|
|
|
|
|
|
Total of all |
|
|
(#logs x 300) |
375 if trees avg. 2.0 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
3 |
-3 |
|
|
Board Feet Per Acre: |
###### |
|
|
|
|
|
|
plots, all |
|
|
#plots |
330 if trees avg. 2.5 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
3 |
-3 |
|
|
Cords per Acre: |
###### |
|
|
|
|
|
|
students. |
|
International Rule |
330 if trees avg. 3.0 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
Stand Basal Area: |
###### |
|
|
|
|
|
|
|
|
|
|
330 if trees avg. 3.5 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
313 if trees avg. 4.0 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
|
Total |
|
|
|
313 if trees avg. 4.5 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
|
|
|
|
|
|
|
#Plots |
|
|
|
300 if trees avg. 5.0 logs |
|
|
|
0 |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
0 |
0 |
0 |
0 |
|
|
0 |
|
|
|
|
|
Sums |
0 |
0 |
0 |
|
|
|
|
300 if trees avg. 5.5 logs |
|
|
|
Sums |
#DIV/0! |
#DIV/0! |
#DIV/0! |
|
Sums |
0 |
0 |
0 |
|
32 |
-32 |
|
|
|
|
|
|
|
|
|
|
290 if trees avg. 6.0 logs |
|
|
|
|
|
|
|
|
|
|
Avg. # sawlogs |
#DIV/0! |
|
|
PULPWOOD FACTORS |
0.9 if trees avg. 1 sticks |
|
|
|
Avg. # Pulpsticks |
#DIV/0! |
|
|
|
|
0.7 if trees avg. 2 sticks |
|
|
|
|
|
Cords/acre= |
(#sticks x 0.65) |
0.65 if trees avg. 3 sticks |
|
Edits by Joshua Shields 2022 |
|
|
|
|
#plots |
0.6 if trees avg. 4+ sticks |
|
|
|
|
Board Foot Factor |
|
Source: Reference Handbook for Foresters, USDA
NA-FR-15. |
|
|
|
|
Cord Factor |
|
Note: Basal area is used to calculate volumes,
not dbh. |
|
|
|
|
|
|
|
Step 3: Use calculated sawlog & pulpstick
averages to select appropriate sawlog & pulpwood factor. |
|
|
|
Enter these factors into green
cells above. Read final calculated
volumes & basal area in red text (above). |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|