Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp125.0613.9927.5619.9113.3324.55322.43484.33635.04662.22640.76305.31224.403050.093274.49
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.000.000.000.000.000.000.000.0040.24190.6644.540.000.00275.44275.44
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)125.0613.9927.5619.9113.3324.55322.43484.33635.04662.22640.76305.31224.403050.093274.49
Available water for irrigated landK_irr=W_irr/WN_irr1.000.001.000.000.000.001.001.000.940.770.931.002.005.647.64
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.000.000.000.000.000.0040.24190.6644.540.000.00275.44275.44
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)63.910.000.300.000.000.00170.72221.14358.32373.56357.05167.9964.211648.781712.99
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)110.550.000.510.000.000.00295.31382.52619.79646.15617.61290.58111.062851.962963.02
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth110.550.000.510.000.000.00295.31382.52619.79646.15617.61290.58111.062851.962963.02
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr10.241.351.391.351.351.3535.2644.8971.1174.0270.8734.7317.03330.88347.91
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E11.102.182.892.482.152.7236.7650.2372.0174.9672.1735.6023.52341.73365.25
Amount of wastewater from non-irrigation water useMm3/monthW_was=a_was*(WN_ind+WN_dom+WN_oth)+b_was0.860.831.501.140.801.371.515.340.900.941.300.876.5010.8617.36
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_was11.102.182.892.482.152.7236.7650.2372.0174.9672.1735.6023.52341.73365.25
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