Grow soil-test trend worksheet calculator

Calculate observed-value target-band differences and OLS observed trend per day with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use observed-value target-band differences and OLS observed trend per day to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Soil-test [sample day,observed value]
[[0,5.5],[30,5.8],[60,6]]
User target lower bound
6
User target upper bound
7
Measurement unit label
pH
Observed-value target-band differences
[[0,5.5,0.5,0],[30,5.8,0.2,0],[60,6,0,0]]
OLS observed trend per day
0.008333

Try another scenario

Soil-test [sample day,observed value]
[[0,5.5],[30,5.8],[60,6]]
User target lower bound
6.2
User target upper bound
7
Measurement unit label
pH
Observed-value target-band differences
[[0,5.5,0.7,0],[30,5.8,0.4,0],[60,6,0.2,0]]
OLS observed trend per day
0.008333
Calculation method

Calculation method

Observed-value target-band differences

[day,value,distance below band,distance above band]; same analyte and method throughout.

OLS observed trend per day

Linear slope on supplied dates; not extrapolated agronomic advice.

Symbols and units
a
Soil-test [sample day,observed value]
b
User target lower bound
c
User target upper bound
d
Measurement unit label

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Lab values, sample dates, units, supplied target bands. Returns Trends and user-band differences. All coefficients and observations are user supplied; results describe only the stated mathematical model. Quantities are deterministic calculations from supplied observations and assumptions; no external data is fetched. Supported limits: Finite inputs only; numeric fields bounded as labelled. Lists and JSON records are limited to 256 entries unless a stricter tool bound is stated. No automatic design approval, legal conclusion, treatment recommendation or safety certification. User target lower bound: minimum None, maximum 1000000000000.0. User target upper bound: minimum None, maximum 1000000000000.0.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

Method reference ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.