Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp40.4240.4196.4791.20142.5195.2088.08156.00231.57508.58330.7716.78506.211331.781837.99
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.000.00633.14154.2614.24774.54355.64510.38783.05272.130.000.001576.181921.203497.38
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)40.4240.4196.4791.20142.5195.2088.08156.00231.57508.58330.7716.78506.211331.781837.99
Available water for irrigated landK_irr=W_irr/WN_irr1.001.000.000.000.000.000.180.220.220.651.001.002.003.275.27
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.000.000.00266.95355.64510.38783.05272.130.000.00266.951921.202188.15
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)14.0114.760.000.000.000.0035.6165.95100.69227.43145.882.5428.77578.10606.87
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)30.5832.220.000.000.000.0077.74143.97219.79496.43318.435.5462.801261.901324.70
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth30.5832.2288.5083.49134.7587.1577.74143.97219.79496.43318.435.54456.691261.901718.59
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr77.3077.7894.4692.98108.1694.0691.27110.89133.36215.33162.5969.88544.74783.321328.06
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E83.8183.3399.8898.24113.4699.5298.07118.69141.01223.19170.5677.21578.24828.731406.97
Amount of wastewater from non-irrigation water useMm3/monthW_was=a_was*(WN_ind+WN_dom+WN_oth)+b_was6.515.555.425.275.305.466.807.797.657.867.977.3333.5145.4078.91
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.8183.3399.8898.24113.4699.5298.07118.69141.01223.19170.5677.21578.24828.731406.97
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