Created by: James Porter
Last updated:
Allocate measured DWC air outlet flow across vessels, document rating basis and tubing losses, and screen duty and standby capacity without predicting dissolved oxygen.
Document rating basis, measured outlet allocation, entered tubing loss, duty, and standby flow without converting airflow into dissolved oxygen.
A DWC Air Pump & Diffuser Allocation Planner is a measurement-led hydroponic planning worksheet that compares pump label output and measured outlet flows, allocates the total across vessels, records imbalance and duty, and screens a standby-air shortfall. It exposes the entered evidence and intermediate arithmetic so operators can review an allocation or failure scenario before relying on it.
Hydroponic hydraulics link reservoirs, pumps, channels, emitters, diffusers, drains, controls, and crops. A number printed on one device rarely describes the installed system. Water-pump output falls as required head changes. Air-pump labels may state free-air output rather than output at the actual backpressure. Emitters foul, manifold branches differ, roots alter channels, filters load, and return paths may behave differently during shutdown.
Airflow cannot predict dissolved oxygen or plant safety; no universal litres-per-minute-per-volume rule is embedded. The worksheet deliberately asks the user to enter a target or capacity from a named source rather than embedding a universal rate. University extension descriptions show that NFT, deep-water culture, ebb-and-flow, and drip systems move or aerate solution differently; those descriptions do not make one flow or schedule correct for every crop and installation.
Use the result as a dated commissioning or inspection record. Identify the exact equipment and source for each target, measure representative outlets with consistent units and timing, calculate the scenario, observe a controlled operating test, and save the after-test measurement. Stop and obtain qualified help when leaks, electrical exposure, overflow, unexpected siphoning, blocked returns, pressure, structural loading, or food-safety consequences exceed routine arithmetic.
Rated flow is labelled by free-air or applicable-backpressure basis. An entered tubing-loss allowance produces a planning capacity, but measured outlet totals control the allocation and imbalance results. Standby output is compared with the measured operating demand. All streams and capacities are converted to a common unit before totals are calculated. The model rejects negative or impossible entries and displays differences rather than silently changing the user's assumptions.
Core formulas
entered available flow = rated flow × (1 − entered loss %)
per-vessel share = measured outlet total ÷ vessel count
outlet deviation = |outlet − average| ÷ average × 100
standby shortfall = max(0, measured demand − standby rating)
The chart is a comparison, not a safety grade. The table keeps component-level observations visible so a weak branch is not hidden inside a satisfactory total. Display rounding never changes the full-precision model.
A 12 L/min backpressure-rated pump with a 10% entered loss allowance shows 10.8 L/min for planning, while three measured outlets totalling 8 L/min remain the evidence for allocation. This is demonstration arithmetic, not a crop prescription, equipment approval, or acceptable-risk threshold.
Measured outlets of 3.0, 2.5, and 2.5 L/min reveal a distribution imbalance even if the pump label appears ample. This is demonstration arithmetic, not a crop prescription, equipment approval, or acceptable-risk threshold.
A 6 L/min standby unit compared with 8 L/min measured demand records a 2 L/min shortfall; it does not estimate how dissolved oxygen will change. This is demonstration arithmetic, not a crop prescription, equipment approval, or acceptable-risk threshold.
The worksheet is most useful when it accompanies physical measurements and a named operating procedure. Typical uses include:
It compares pump label output and measured outlet flows, allocates the total across vessels, records imbalance and duty, and screens a standby-air shortfall. It reports arithmetic from entered measurements rather than selecting a crop target or equipment specification. Airflow cannot predict dissolved oxygen or plant safety; no universal litres-per-minute-per-volume rule is embedded.
No. Example values only make the interface usable on first load. Replace every target, curve point, loss allowance, runtime, reserve, and return fraction with a measurement or a traceable crop, system, manufacturer, or qualified-design source.
No. Catalogue ratings depend on the stated test condition. Water-pump flow changes with head and restriction; air output changes with backpressure, depth, tubing, manifolds, and diffusers. Measure the installed outlets and retain the exact performance curve and test conditions.
No. Airflow does not predict dissolved oxygen, and circulated water volume does not prove film depth, oxygen transfer, temperature, nutrient balance, sanitation, or crop suitability. Record calibrated dissolved-oxygen or other crop-specific measurements when a qualified plan requires them.
Reserve is an entered planning allowance, while blockage is a failure scenario. Neither proves that equipment, drainage, containment, controls, or alarms are adequate. Separating them prevents a favourable normal result from concealing a shutdown or obstruction exposure.
Measure actual flow at representative outlets, operate the system through start-up and shutdown under controlled supervision, inspect leaks and return paths, and compare observations with current manufacturer documentation. Have consequential plumbing, electrical, structural, and containment decisions reviewed by qualified professionals.
No. The worksheet cannot certify food safety, worker safety, crop health, electrical work near water, plumbing, waste discharge, or code compliance. Commercial operators must follow applicable authorities, documented sanitation programs, equipment instructions, and professional design requirements.