Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp22.478.52126.0432.7564.34347.69255.25334.15450.02605.41623.45292.88601.812561.163162.97
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.000.00209.42281.39250.510.0016.25150.75107.570.000.000.00741.32274.571015.89
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)22.478.52126.0432.7564.34347.69255.25334.15450.02605.41623.45292.88601.812561.163162.97
Available water for irrigated landK_irr=W_irr/WN_irr1.000.000.000.000.001.000.940.680.801.001.001.002.005.427.42
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.006.187.240.0016.25150.75107.570.000.000.0013.42274.57287.99
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)9.660.000.000.000.0015.64123.36161.59218.90293.79303.79142.5425.301243.971269.27
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)19.480.000.000.000.0031.56248.85325.99441.59592.68612.84287.5651.042509.512560.55
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth19.480.00118.0830.0361.98336.81248.85325.99441.59592.68612.84287.56566.382509.513075.89
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr105.2498.20140.87109.05120.60219.92212.79236.94273.12320.41326.72224.90793.881594.882388.76
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E108.18103.64146.06111.87123.25226.44217.27242.22278.52327.76333.11228.90819.441627.782447.22
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_was108.18103.64146.06111.87123.25226.44217.27242.22278.52327.76333.11228.90819.441627.782447.22
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)5.105.5454.1316.654.7630.7015.4112.3612.4927.9633.8323.22116.88125.27242.15