Select planning zone




Total 18 items.
NameUnitFormulaOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberNon GrowingGrowingYear Sum
Total water withdrawalMm3/monthW=W_tr+W_loc+WP_gr+WP_rp22.227.63108.020.00158.05324.30176.94452.24653.18868.44638.71231.28620.223020.793641.01
Water deficitMm3/monthD=IF(WN-W>=0,WN-W,0)0.000.00317.41406.30245.43109.510.0039.95108.960.000.000.001078.65148.911227.56
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.227.63108.020.00158.05324.30176.94452.24653.18868.44638.71231.28620.223020.793641.01
Available water for irrigated landK_irr=W_irr/WN_irr1.000.000.000.000.000.001.000.910.851.001.001.001.005.766.76
Irrigation water deficitMm3/monthD_irr=IF(WN_irr-W_irr>=0,WN_irr-W_irr,0)0.000.000.000.000.004.140.0039.95108.960.000.000.004.14148.91153.05
Irrigation water lossesMm3/monthLO_irr=W_irr*(1-n)6.970.000.000.000.000.0079.55223.18330.42436.62318.75114.736.971503.251510.22
Irrigation water withdrawal, excluding leachingMm3/monthW_irr=IF(W_irrflu-WN_flu>0,W_irrflu-WN_flu,0)13.100.000.000.000.000.00149.54419.57621.18820.83599.24215.6913.102826.052839.15
Irrigation water withdrawal, including leachingMm3/monthW_irrflu=W-WN_ind-WN_dom-WN_oth13.100.0084.14-4.75156.12296.19149.54419.57621.18820.83599.24215.69544.802826.053370.85
Amount of drainage water generated from irrigation water useMm3/monthW_dr=W_irrflu*a_dr+W_irrflu*b_dr+c_dr16.6114.7027.0114.0037.5558.0671.1593.24109.73126.07107.9476.56167.93584.69752.62
Amount of return waterMm3/monthW_ret=W_drwas+W_h+E46.7744.3961.7542.8065.4894.10106.98130.70146.99168.16147.51108.73355.29809.071164.36
Amount of wastewater from non-irrigation water useMm3/monthW_was=a_was*(WN_ind+WN_dom+WN_oth)+b_was30.1629.7034.7328.8027.9336.0535.8237.4637.2542.0939.5732.16187.37224.35411.72
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_was46.7744.3961.7542.8065.4894.10106.98130.70146.99168.16147.51108.73355.29809.071164.36
Amount of return water discharged into lakes and depressionsMm3/monthW_drl=K_drl*(W_ret+W_drfrom-WP_rp)41.5726.5258.4931.3124.6546.0384.9671.8148.5980.1293.0670.07228.57448.61677.18
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