Arte SheetsLearn. Try. Understand.

Controlled-Environment Agriculture (CEA), Hydroponics & Venturi/Dosatron Fertigation

Hydroponic Fertigation Injector Stock Tank & ppm Formula

Calculate Dripper-Line Fertilizer Salt Concentration (mg/L), Concentrated Stock-Tank Salt Concentration (g/L), Total Dry Fertilizer Bag Charge (kg), and Cold-Water Solubility Utilization (%).

Weighing 150 mg/L of Calcium Nitrate salt instead of 150 ppm Elemental Nitrogen starves tomato crops by 84.5%

Commercial greenhouse hydroponic recipes specify elemental nutrient targets in ppm (mg/L of pure Nitrogen N, Potassium K, or Calcium Ca at the dripper emitter), whereas fertilizer bags contain only a fraction P_elem (%) of that element (e.g. greenhouse-grade Calcium Nitrate 15.5-0-0 carries 15.5% elemental N and 19.0% Ca) AND proportional Dosatron/Venturi injectors dilute A/B stock barrels by Injector Ratio R_inj (1:100 -> R_inj = 100, 1:200 -> R_inj = 200). First divide Target Elemental ppm by Elemental Purity Fraction to get Dripper-Line Salt Concentration C_line = ppm_target / (P_elem / 100) (mg/L); next multiply by Injector Ratio R_inj and divide by 1,000 mg/g to obtain Stock-Tank Salt Concentration C_stock = (C_line * R_inj) / 1,000 (g/L); finally multiply by Stock-Tank Volume V_tank (L) / 1,000 to weigh exact Dry Fertilizer Charge M_bag (kg)—checking that C_stock stays safely below cold-water salt solubility.

Verify on a 200 L Tank-A Calcium Nitrate Stock Recipe—Target_Dripper_Nitrogen = 150.0 ppm N (B2), Calcium_Nitrate_Elemental_N_Pct = 15.5% (B3 -> Dripper-Line Salt = 967.74 mg/L in E2), Proportional_Injector_Ratio 1:100 = 100 (B4 -> Stock Concentration = 96.77 g/L in E3), and Stock_Barrel_Volume = 200.0 L (B5): Weigh exactly 19.35 kg of Calcium Nitrate into Tank A (E4), utilizing 8.06% of its 1,200 g/L cold-water solubility limit (E5).

CEA Fertigation Stock-Tank KPI (150 ppm N, 15.5% Ca(NO3)2, 1:100 Injector, 200 L)FormulaVerified Output
Dripper-Line Salt Conc. (mg/L)Target_Element_ppm / (Purity_Pct / 100)967.74 mg/L
Concentrated Stock Tank (g/L)(Line_Salt_mg_L * Injector_Ratio) / 100096.77 g/L (193.55 g/L @ 1:200 injector)
Total Dry Salt Charge (kg)(Stock_Conc_g_L * Tank_Vol_L) / 100019.35 kg (38.71 kg @ 1:200 injector)
Ca(NO3)2 Solubility Used (%)(Stock_Conc_g_L / 1200) * 1008.06% (16.13% @ 1:200 injector)

Proportional Fertigation Injector Dilution & Elemental Salt Mass Formula

Validate Target_ppm > 0, Elemental_Purity in (0%, 100%], Injector_Ratio >= 1 (1 = direct batch tank without injector; 50–500 = proportional injector), and Stock_Tank_L > 0.

=LET(pp_m, B2, pu_p, B3, ir_t, B4, vt_l, B5, IF(OR(pp_m <= 0, pu_p <= 0, pu_p > 100, ir_t < 1, vt_l <= 0), "Invalid Fertigation Input", LET(cl_m, pp_m / (pu_p / 100), cs_g, (cl_m * ir_t) / 1000, ROUND((cs_g / 1200) * 100, 2))))

High-Ratio 1:200 Injector Upgrade Check (Set Injector Ratio R_inj = 200)

Dial the proportional injector from 1:100 (0.5% -> 1%) to 1:200 (0.5% injection, set B4 = 200) so Tank A lasts twice as many irrigation cycles: Dripper-Line Salt E2 stays 967.74 mg/L (150 ppm N), while Stock Concentration E3 doubles to 193.55 g/L, Bag Charge E4 doubles to 38.71 kg, and Solubility Used E5 reaches 16.13%.

=IF(ISTEXT(E5), E5, LET(cl_m, B2 / (B3 / 100), cs_g, (cl_m * B4) / 1000, ROUND((cs_g * B5) / 1000, 2)))

Try the example

Use the original values or change them to test your understanding.

Further reading