C-Dax pasture meter+, Руководство по эксплуатации

Страница: 35 / 38

28
Equation Calculation Steps
Step 1 - Calculate total and Avg. For columns A & B
➢
Calculate (G) = Sum of Column A (i.e. 25 + 40 + ... = 250)
➢
Calculate (H) = Sum of Column B (i.e. 1200 + 2350 + ... = 7800)
➢
Calculate (I) = G ÷ No. of Samples (i.e. 250 ÷ 5 = 50)
➢
Calculate (J) = H ÷ No. of Samples (i.e. 7800 ÷ 5 = 1560)
Step 2
– Subtract the averages (I & J) from each entry
➢
Calculate values for Column C = A
– I (i.e. 10 – 50 = -40)
➢
Calculate values for Column D = B
– J (i.e. 1200 – 1560 = -360)
Step 3
– Calculate Column E
➢
Square each entry in Column C (i.e. -40 x -40 = 1600)
Step 4
– Calculate Column F
➢
Multiply each entry in Column C by its corresponding entry in Column D
(i.e. -40 x -360 = 14400)
Step 5
– Add up columns E & F and record in cells K & L respectively
Step 6
– Calculate parameters to use in pasture equation
➢
Calculate Slope of line (Factr) M = L ÷ K
➢
Calculate the Constant (Const) N = J
– (M x I)
Pasture
A B C D E F
Sample
Pasture Height
(mm)
Pasture Cover
(kgDM/ha)
(A - I) (B - J) (C
2
) (C x D)
Example
40 1500
-40 -360 1600 14400
1
2
3
4
5
Sum
G H K L
Average
I J
Eq. Slope
M
Eq. Constant
N