balance hidrico - hoja de calculo

6
ESTACION: CUZCO - ULCUMAYO CULTIVO AREA (HAS) ENERO FEBRERO PAPA 1,589.4 QUINUA 1,757.1 1,757.1 TOMATE 1,647.2 PLATANO 2,091.9 2,091.9 FRIJOLES 1,891.9 CAFÉ 3,678.5 CACAO 3,674.8 Precipitacion mm/mes 19.77 25.70 Efc 0.95 0.95 Efd 0.85 0.85 Eto mm/mes 119.40 113.90 Poblacion hab 47313 KC DE CULTIVOS CULTIVO AREA (HAS) ENERO FEBRERO PAPA 1,589.4 QUINUA 1,757.1 0.500 TOMATE 1,647.2 PLATANO 2,091.9 1.200 1.200 FRIJOLES 1,891.9 CAFÉ 3,678.5 0.950 0.950 CACAO 3,674.8 1.050 1.050 CALCULO DEL KC PONDERADO CULTIVO AREA (HAS) ENERO FEBRERO PAPA 1,589.4 QUINUA 1,757.1 1,757.1 TOMATE 1,647.2 PLATANO 2,091.9 2,091.9 2,091.9 FRIJOLES 1,891.9 CAFÉ 3,678.5 3,678.5 3,678.5 CACAO 3,674.8 3,674.8 3,674.8 TOTAL 9445.175 11202.275

Upload: jose-rc

Post on 18-Dec-2015

117 views

Category:

Documents


21 download

DESCRIPTION

HIDROLOGIA

TRANSCRIPT

Hoja1BALANCE HIDRICOESTACION: CUZCO - ULCUMAYOCULTIVOAREA (HAS)ENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREPAPA1,589.41,589.4QUINUA1,757.11,757.1TOMATE1,647.21,647.2PLATANO2,091.92,091.9FRIJOLES1,891.91,891.9CAF 3,678.53,678.5CACAO3,674.83,674.8Precipitacionmm/mes19.7725.7024.6015.5011.7010.500.000.000.000.000.007.40Efc0.950.950.950.950.950.950.950.950.950.950.950.95Efd0.850.850.850.850.850.850.850.850.850.850.850.85Etomm/mes119.40113.90104.90107.56103.4774.8975.6960.7969.8784.4183.4787.52Poblacionhab47313KC DE CULTIVOSCULTIVOAREA (HAS)ENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREPAPA1,589.40.4500.7501.1500.8500.850QUINUA1,757.10.5000.8001.0500.5000.500TOMATE1,647.20.7501.1501.1500.8000.800PLATANO2,091.91.2001.2001.2001.2001.2001.2001.1001.0001.0001.0001.0001.200FRIJOLES1,891.91.0001.1500.3500.350CAF 3,678.50.9500.9500.9500.9500.9500.9500.9500.9000.9000.9500.9500.950CACAO3,674.81.0501.0501.0501.0501.0501.0501.0501.0001.0001.0501.0501.050

CALCULO DEL KC PONDERADOCULTIVOAREA (HAS)ENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREPAPA1,589.41,589.41,589.41,589.41,589.41,589.4QUINUA1,757.11,757.11,757.11,757.11,757.11,757.1TOMATE1,647.21,647.21,647.21,647.21,647.21,647.2PLATANO2,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.92,091.9FRIJOLES1,891.91,891.91,891.91,891.91,891.9CAF 3,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.53,678.5CACAO3,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.83,674.8TOTAL9445.17511202.27514438.87514438.87514438.87516330.77514573.67511337.07511337.0759445.1759445.1759445.175CULTIVOAREA (HAS)ENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREPAPA1,589.40.4500.7501.1500.8500.850QUINUA1,757.10.5000.8001.0500.5000.500TOMATE1,647.20.7501.1501.1500.8000.800PLATANO2,091.91.2001.2001.2001.2001.2001.2001.1001.0001.0001.0001.0001.200FRIJOLES1,891.90.0001.0001.1500.3500.350CAF 3,678.50.9500.9500.9500.9500.9500.9500.9500.9000.9000.9500.9500.950CACAO3,674.81.0501.0501.0501.0501.0501.0501.0501.0001.0001.0501.0501.050KC PONDERADO 1.040.960.921.021.000.940.990.860.861.001.001.04CALCULO DE LA DEMANDA DE AGUAMESESENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREDias312831303130313130313031E00.810.810.810.810.810.810.810.810.810.810.810.81AREA (ha)9445.1811202.2814438.8814438.8814438.8816330.7814573.6811337.0811337.089445.189445.189445.18Kc(ponderado)1.040.960.921.021.000.940.990.860.861.001.001.04Prec. (mm)19.7725.7024.6015.5011.7010.500.000.000.000.000.007.40ETo (mm/mes)119.40113.90104.90107.56103.4774.8975.6960.7969.8784.4183.4787.52ETc (mm/dia)124.69109.2296.04110.21103.6570.1775.3052.2260.0284.4183.4791.40DA (mm/mes)104.9283.5271.4494.7191.9559.6775.3052.2260.0284.4183.4784.00DAP (m3/ha)1299.281034.30884.741172.881138.70739.01932.51646.73743.331045.301033.661040.19DAB (m3/ha)12.2711.5912.7716.9416.4412.0713.597.338.439.879.769.82MR(l/s/ha)0.490.430.330.450.430.290.350.240.290.390.400.39Q (l/s)4581.804789.384769.496533.616138.584656.085073.962737.483251.243686.193766.643668.14Q (m3/s)4.584.794.776.536.144.665.072.743.253.693.773.67DEMANDA DE AGUA USO AGRICOLA (Q ua) :Qua6.53m3/sDEMANDA DE AGUA USO AGRICOLA (Qpo) :DOTACION150l/s/habHABITANTES47313habQpo0.08m3/sDEMANDA DE AGUA TOTAL Qt6.62m3/s

=(())/()