balance hidrico - hoja de calculo

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

=(())/()