Demanda.xlsx

Hoja1CULTIVOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREMAIZ AMARILLO DURO1,250.00MAIZ AMARILLO DURO3,500.00MAIZ AMARILLO DURO4,000.00MAIZ AMARILLO DURO1,800.00CAA DE AZUCAR7,800.00QUINUA1,350.00ALGODN2,600.00NARANJA3,200.00VID1,800.00TOTAL14,050.000.003,500.005,350.004,400.000.000.000.000.000.000.000.0027,300.00Periodo vegetativo MAIZ AMARILLO DURO5mesesCAA DE AZUCAR12mesesQUINUA4mesesALGODN8mesesNARANJA12mesesVID12meses

Coeficiente del CultivoMAIZ AMARILLO DURO0.701.101.151.000.70CAA DE AZUCAR0.750.751.151.201.351.351.351.351.351.100.750.75QUINUA0.350.751.150.45ALGODN1.151.171.201.000.700.700.500.50NARANJA0.650.650.650.650.700.700.700.700.700.650.650.65VID0.850.850.700.700.600.000.400.450.450.600.600.70Eto (mm/mes)150.70155.80154.90141.90132.40119.50109.40105.60107.90118.90126.50132.10Precipitacin (mm/mes)14.5016.8017.9013.207.600.000.000.000.000.000.000.00Eficiencia Conduccin90%Eficiencia Distribucin75%Poblacin actual150,000habitantesEjemploQ captado en el rio5.00m3/segQ entregado en cabecera de la irrigacin4.50m3/segQ distribuido a nivel de las parcelas3.38m3/segEficiencia de Riego =Efic. Cond. X Efic. Distr.= 90% x 75%67.5%CULTIVOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREMAIZ AMARILLO DURO1,250.001,250.001,250.001,250.001,250.00MAIZ AMARILLO DURO3,500.003,500.003,500.003,500.003,500.00MAIZ AMARILLO DURO4,000.004,000.004,000.004,000.004,000.00MAIZ AMARILLO DURO1,800.001,800.001,800.001,800.001,800.00CAA DE AZUCAR7,800.007,800.007,800.007,800.007,800.007,800.007,800.007,800.007,800.007,800.007,800.007,800.00QUINUA1,350.001,350.001,350.001,350.00ALGODN2,600.002,600.002,600.002,600.002,600.002,600.002,600.002,600.00NARANJA3,200.003,200.003,200.003,200.003,200.003,200.003,200.003,200.003,200.003,200.003,200.003,200.00VID1,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.001,800.00TOTAL14,050.0014,050.0017,550.0022,900.0027,300.0026,050.0026,050.0021,200.0017,200.0015,400.0015,400.0015,400.00

CULTIVOENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREMAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70CAA DE AZUCAR0.750.751.151.201.351.351.351.351.351.100.750.75QUINUA0.350.751.150.45ALGODN1.151.171.201.000.700.700.500.50NARANJA0.650.650.650.650.700.700.700.700.700.650.650.65VID0.850.850.700.700.600.000.400.450.450.600.600.70

MAIZ AMARILLO DURO312831303130313130313031CALCULOSENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREEtc = Eto x Kc (mm/mes)105.49171.38178.14141.9092.68DA = Etc - Precip (mm/mes)90.99154.58160.24128.7085.08DAP = DA x Area bajo riego (m3/mes)1,137,3751,932,2502,002,9381,608,7501,063,500Q neto = DAP/N dias/24 horas/3600 seg0.420.800.750.620.40Q bruto = Q neto/Efic. Riego0.631.181.110.920.59MAIZ AMARILLO DURO312831303130313130313031CALCULOSENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREEtc = Eto x Kc (mm/mes)108.43156.09152.26119.5076.58DA = Etc - Precip (mm/mes)90.53142.89144.66119.5076.58DAP = DA x Area bajo riego (m3/mes)3,168,5505,001,1505,063,1004,182,5002,680,300Q neto = DAP/N dias/24 horas/3600 seg1.181.931.891.611.00Q bruto = Q neto/Efic. Riego1.752.862.802.391.48MAIZ AMARILLO DURO312831303130313130313031CALCULOSENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREEtc = Eto x Kc (mm/mes)113.03116.85178.14170.28178.74161.33147.69142.56145.67130.7994.8899.08DA = Etc - Precip (mm/mes)98.53100.05160.24157.08171.14161.33147.69142.56145.67130.7994.8899.08DAP = DA x Area bajo riego (m3/mes)7,684,9507,803,90012,498,33012,252,24013,348,92012,583,35011,519,82011,119,68011,361,87010,201,6207,400,2507,727,850Q neto = DAP/N dias/24 horas/3600 seg2.873.234.674.734.984.854.304.154.383.812.862.89Q bruto = Q neto/Efic. Riego4.254.786.917.007.387.196.376.156.495.644.234.27Q total (m3/seg)4.885.969.7710.7810.779.587.856.156.495.644.234.27Kc Ponderado0.740.770.920.921.041.050.990.980.970.880.670.68312831303130313130313031CALCULOSENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREEtc = Eto x Kc (mm/mes)110.85120.15142.96130.58137.80125.90108.09103.51104.51104.6984.6989.98DA = Etc - Precip (mm/mes)96.35103.35125.06117.38130.20125.90108.09103.51104.51104.6984.6989.98DAP = DA x Area bajo riego (m3/mes)13,537,59514,520,53021,948,47826,879,07835,543,35032,796,17828,156,82521,943,68017,976,14016,122,84013,042,15013,857,290Q neto = DAP/N dias/24 horas/3600 seg5.056.008.1910.3713.2712.6510.518.196.946.025.035.17Q bruto = Q neto/Efic. Riego7.498.8912.1415.3619.6618.7415.5712.1410.278.927.457.66

DEMANDA DE AGUA POBLACIONALCALCULOSENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREPOBLACION (habitantes)150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00150,000.00DOTACION (Lt/hab/dia)150.00150.00150.00150.00150.00150.00150.00150.00150.00150.00150.00150.00Demanda Poblacin (m3/dia)22,50022,50022,50022,50022,50022,50022,50022,50022,50022,50022,50022,500|Q neto = DP/24/36000.260.260.260.260.260.260.260.260.260.260.260.26Q bruto = Q neto/Efic. Cond0.290.290.290.290.290.290.290.290.290.290.290.29

DESCRIPCIONENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSETIEMBREOCTUBRENOVIEMBREDICIEMBREOFERTA (m3/seg)37.8042.8044.5029.7020.8016.8011.307.508.9011.5013.7016.80DEMANDA TOTAL (m3/seg)7.789.1812.4315.6519.9519.0315.8612.4310.569.217.747.95DEFICIT 2.234.564.931.66SUPERAVIT30.0233.6232.0714.050.852.295.968.85

Hoja2CULTIVOENEFEBMARABRMAYJUNJULAGOSEPOCTNOVDICMAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70MAIZ AMARILLO DURO0.701.101.151.000.70CAA DE AZUCAR0.750.751.151.201.351.351.351.351.351.100.750.75QUINUA0.350.751.150.45ALGODN1.151.171.201.000.700.700.500.50NARANJA0.650.650.650.650.700.700.700.700.700.650.650.65VID0.850.850.700.700.600.000.400.450.450.600.600.70ALCACHOFA0.501.001.151.101.10FRIJOL1.001.151.000.35CAA DE AZUCAR0.750.751.151.201.351.351.351.351.351.200.750.75ESPARRAGO0.500.701.001.101.100.700.300.30MANGO0.700.700.700.700.700.700.700.700.700.700.700.70AJO1.000.700.700.700.600.30CEBOLLA0.801.001.201.20TOMATE0.450.801.101.05CAMOTE0.600.751.151.150.85ZAPALLO0.350.751.100.70REPOLLO0.450.801.150.800.450.801.150.80NARANJA0.650.650.650.650.700.700.700.700.700.650.650.65ARROZ0.900.900.900.601.051.20ARROZ1.200.900.900.900.601.20ARROZ1.201.200.900.900.900.60QUINUA0.500.801.001.050.50PAPA0.750.751.151.150.85

Documents

Demanda.xlsx