Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp38.428.28110.61291.53204.86196.73253.37345.06447.77550.22179.9911.32850.431787.732638.16
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.000.00454.1830.770.00707.04103.8658.93334.6623.700.000.001191.99521.151713.14
Water excessMm3/monthE=IF(W-WN>=0,W-WN,0)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Water withdrawal from local sourcesMm3/monthW_loc=IF(WP_loc<=WN-WP_gr-WP_rp+V_r-W_tr,WP_loc,WN-WP_gr-WP_rp+V_r-W_tr)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Water withdrawal from transboundary sourcesMm3/monthW_tr=IF(WP_tr<=WN-WP_gr-WP_rp+V_r,WP_tr,WN-WP_gr-WP_rp+V_r)38.428.28110.61291.53204.86196.73253.37345.06447.77550.22179.9911.32850.431787.732638.16
Available water for irrigated landK_irr=W_irr/WN_irr1.000.000.000.000.000.000.700.850.570.961.001.001.005.086.08
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.000.000.00108.15103.8658.93334.6623.700.000.00108.15521.15629.30
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)13.110.000.000.000.000.00111.46152.77199.92246.7177.120.2313.11788.21801.32
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)28.620.000.000.000.000.00243.31333.48436.40538.52168.350.4928.621720.551749.17
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth28.620.00102.53284.20197.38188.99243.31333.48436.40538.52168.350.49801.721720.552522.27
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr76.7268.2498.62152.44126.72124.23140.33167.05197.54227.80118.1268.38646.97919.221566.19
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E83.2073.84104.10157.49131.85129.52146.97174.58204.95235.40125.6975.47680.00963.061643.06
Amount of wastewater from non-irrigation water useMm3/monthW_was=a_was*(WN_ind+WN_dom+WN_oth)+b_was6.495.605.485.045.135.286.647.537.417.607.577.0933.0243.8476.86
Idle discharge from local water sourcesMm3/monthW_h=IF(WR_loc-W_loc>=0,WR_loc-W_loc,0)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Total amount of drainage water and wastewaterMm3/monthW_drwas=W_dr+W_was83.2073.84104.10157.49131.85129.52146.97174.58204.95235.40125.6975.47680.00963.061643.06
Amount of return water discharged into lakes and depressionsMm3/monthW_drl=K_drl*(W_ret+W_drfrom-WP_rp)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Amount of return water discharged into riversMm3/monthW_drtr=K_drtr*(W_ret+W_drfrom-WP_rp)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00
Amount of return water flowing to neighboring PZsMm3/monthW_drto=K_drto*(W_ret+W_drfrom-WP_rp)0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00