Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp14.880.00121.180.00176.77343.28239.76329.18447.12682.99515.60157.36656.112372.013028.12
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.0010.93240.77332.64155.510.0062.8273.85226.36138.690.000.00739.85501.721241.57
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)14.880.00121.180.00176.77343.28239.76329.18447.12682.99515.60157.36656.112372.013028.12
Available water for irrigated landK_irr=W_irr/WN_irr1.000.000.000.000.001.000.790.810.660.831.001.002.005.097.09
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.002.410.000.000.000.0062.8273.85226.36138.690.000.002.41501.72504.13
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)5.900.000.000.000.001.22115.68159.13217.46332.25250.3375.377.121150.221157.34
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)11.890.000.000.000.002.46233.36321.02438.69670.26504.99152.0414.352320.362334.71
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth11.89-8.52113.22-2.71174.42332.39233.36321.02438.69670.26504.99152.04620.692320.362941.05
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr102.5095.12139.1297.22161.23218.33207.94235.38272.21344.69292.96182.49813.521535.672349.19
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E105.44100.56144.31100.03163.89224.84212.42240.66277.61352.04299.35186.48839.071568.562407.63
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_was105.44100.56144.31100.03163.89224.84212.42240.66277.61352.04299.35186.48839.071568.562407.63
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.975.3753.4814.896.3330.4915.0712.2812.4530.0330.4118.92115.53119.16234.69