C-Dax Pasture Meter, Assembly And Operation Manual

Page: 69 / 71

66
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 it’s 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 Meter Formula Equation Table
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