INSTRUCTIONS

1.  Use the "Volume Calculation" sheets

2.  Enter cumulative data in the green cells.

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"

VOLUME AND BASAL AREA CALCULATIONS BASED ON FIELD DATA

Species:

Enter data in green cells ONLY

Step 1:  Fill in green cells in table below using

sums from field tally sheets

Crew#

#Trees

#Sawlogs

#Pulpsticks

#Plots

1

Board Feet Per Acre:

#DIV/0!

2

Cords per Acre:

#DIV/0!

3

Stand Basal Area:

#DIV/0!

4

(square feet / acre)

5

6

7

SAWLOG FACTORS

375 if trees avg. 1.0 logs

8

375 if trees avg. 1.5 logs

9

BF/acre =

(#logs x 300)

375 if trees avg. 2.0 logs

10

#plots

330 if trees avg. 2.5 logs

11

International Rule

330 if trees avg. 3.0 logs

12

330 if trees avg. 3.5 logs

13

313 if trees avg. 4.0 logs

14

313 if trees avg. 4.5 logs

15

300 if trees avg. 5.0 logs

Sums

0

0

0

0

300 if trees avg. 5.5 logs

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

#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 2:  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).