Garden & outdoors

Fertiliser nutrient mass budget

Sum declared N–P₂O₅–K₂O masses across listed products.

Fertiliser nutrient mass budget
Esc to restore

Your inputs

Comma-separated headings shown in the example. Up to 1,000 source rows; keep this project table small enough to review.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Results update as you type. Larger files run when you press Update result.

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Multiplies each product mass by each supplied grade percentage and sums product/N/P₂O₅/K₂O totals. Values are mass percentages from 0–100; oxide equivalents are retained as labelled, not converted to elemental phosphorus/potassium. Up to 1,000 rows. This is an inventory calculation and does not recommend application rates or replace soil testing/product instructions.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Project CSV
Product,Kg,N,P2O5,K2O
Product A,2,10,5,5
Product B,1,0,0,10

Example result

Example result
ProductProduct mass (kg)N (kg)P₂O₅ equivalent (kg)K₂O equivalent (kg)
Product A20.20.10.1
Product B1000.1
TOTAL30.20.10.2

Grade is percent by mass N–P₂O₅–K₂O; oxide equivalents are not elemental phosphorus/potassium. This sums supplied quantities and does not recommend an application rate.