Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp12.860.0096.940.00141.42352.97191.81263.35357.70546.39451.61259.13604.192069.992674.18
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.008.52244.09307.34171.380.0035.05121.26526.59346.32241.459.01731.331279.682011.01
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)12.860.0096.940.00141.42352.97191.81263.35357.70546.39451.61259.13604.192069.992674.18
Available water for irrigated landK_irr=W_irr/WN_irr1.000.000.000.000.001.000.840.680.400.610.650.972.004.156.15
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.000.000.000.0035.05121.26526.59346.32241.459.010.001279.681279.68
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)4.890.000.000.000.0015.6991.91126.50173.13264.54218.60125.8120.581000.491021.07
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)9.870.000.000.000.0031.64185.41255.19349.26533.67441.00253.8141.512018.342059.85
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth9.87-8.5288.98-2.71139.06342.09185.41255.19349.26533.67441.00253.81568.772018.342587.11
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr101.7795.12130.3697.22148.46221.83192.93214.77244.22301.94272.93214.34794.761441.132235.89
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E104.71100.56135.55100.03151.11228.35197.42220.05249.62309.29279.32218.34820.311474.042294.35
Amount of wastewater from non-irrigation water useMm3/monthW_was=a_was*(WN_ind+WN_dom+WN_oth)+b_was2.945.445.192.812.656.514.485.285.407.356.394.0025.5432.9058.44
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_was104.71100.56135.55100.03151.11228.35197.42220.05249.62309.29279.32218.34820.311474.042294.35
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)4.935.3750.2414.895.8330.9614.0011.2311.1926.3928.3722.15112.22113.33225.55