Field |
Excel cell reference |
Accepted values |
Value key |
Unit System |
B1 |
1, 2 |
1 – English
2 – Metric
|
Group Name |
Column A |
Any string value excluding single, double quotes and/or commas |
|
Pile Type |
Column B |
1, 2 |
1 – Hand
2 – Machine
|
Number of Piles |
Column C |
Any integer > 0 |
|
Pile Shape |
Column D |
0, 1, 2, 3, 4, 5, 6 |
0 – Half sphere
1 – Paraboloid
2 – Half cylinder
3 – Half-frustum of cone
4 – Half-frustum of cone w/ rounded edges
5 – Half ellipsoid
6 – Irregular solid
|
W1 |
Column E |
Any positive float or null if N/A |
|
H1 |
Column F |
Any positive float or null if N/A |
|
L1 |
Column G |
Any positive float or null if N/A |
|
W2 |
Column H |
Any positive float or null if N/A |
|
H2 |
Column I |
Any positive float or null if N/A |
|
L2 |
Column J |
Any positive float or null if N/A |
|
Hand Pile Composition |
Column K |
1, 2
or null if machine pile
|
1 – Conifer
2 – Shrub/Hardwood
|
% Soil Volume |
Column L |
0 – 100
or null if hand pile
|
|
Packing Ratio |
Column M |
10, 20, 25
or null if hand pile
|
|
Species 1 Common Name |
Column N |
From the species density look-up table |
|
Species 1 Density |
Column O |
Positive float from species density look-up table
or null if hand pile
|
|
% Species 1 |
Column P |
0 – 100
or null if hand pile
|
|
Species 2 Common Name |
Column Q |
From the species density look-up table |
|
Species 2 Density |
Column R |
Positive float from species density look-up table
or null if N/A or hand pile
|
|
% Species 2 |
Column S |
0 – 100
or null if if N/A or hand pile
|
|
Pile Quality |
Column T |
1, 2, 3
or null if hand pile
|
1 – Clean
2 – Dirty
3 – Very dirty
|
% Consumed |
Column U |
0 – 100 |
|