cedula y et0

23
NOMBRES HECTAREAS 99.95 1 1 2 0.3 3 1.5 4 0.2 5 1 6 0.5 7 2.5 8 0.5 9 1 10 2 11 0.5 12 3 13 0.2 14 0.3 15 1.25 16 4 17 1 18 3 19 1 20 0.25 21 1 22 2 23 0.5 24 0.4 25 1 26 2 27 2 28 1.5 29 2 30 1.25 31 2 32 1.5 33 0.4 34 0.75 35 0.5 36 1 37 0.25 38 0.25 39 3 40 0.5 41 0.6 42 0.25 43 3 44 0.5 45 2 46 0.4 47 0.5 48 2.5 49 0.4 50 1.5 51 2 52 2

Upload: tatto-herrera-valdivia

Post on 09-Sep-2015

217 views

Category:

Documents


3 download

DESCRIPTION

Cedula de cultivo hoja de calculo

TRANSCRIPT

BENEFICIARIOSNNOMBRESHECTAREAS99.95CULTIVOS11PASTOS59.9520.3PAPA1031.5ARVEJA540.2ALFALFA599.9551MAIZ2060.572.580.591102110.5123130.2140.3151.25164171183191200.25211222230.5240.4251262272281.5292301.25312321.5330.4340.75350.5361370.25380.25393400.5410.6420.25433440.5452460.4470.5482.5490.4501.5512522530.5540.25551.5561571580.25592600.4610.4620.2630.75641651.5662672681692701711723731741752762770.5780.25791802812821

informacionSERVICIO NACIONAL DE METEOROLOGA E HIDROLOGA "SENAMHI"DIRECCIN REGIONAL SENAMHI - ESTACION AUGUSTO WEBERBAUER

COMPORTAMIENTO CLIMTICO DEL VALLE DE CONCHNESTACIN : AUGUSTO WEBERBAUER

TEMPERATURA CP . PH RINSOLARADIAC.MESESmm.%HorasLangleyMx. XMed. XMn. XMn. AbsSol /da/daEne.21.814.26.4 - -86.877.45.2473.7Feb.22.214.06.8 - -104.280.34.8456.5Mar.22.314.16.4 - -84.679.14.9474.3Abr.22.414.15.9 - -64.777.65.4433.4May.22.713.14.5 - -26.976.86.4429.0Jun.22.612.53.0 - -12.071.36.9419.3Jul.22.412.32.1 - -5.366.77.3439.8Ago.22.912.83.0 - -18.566.86.9441.9Set.23.113.94.6 - -33.068.85.7463.0Oct.23.213.74.9 - -69.572.75.7475.1Nov.23.214.04.5 - -66.472.85.8506.7Dic.23.113.94.9 - -62.574.26.0496.8Media22.713.54.852.973.75.9459.1

NOTA : P.P. = Precipitacin en m. m. HR = Humedad Relativa %Rad. = Radiacin Global en cal x cm. / da o langley / daETP = Evapotranspiracin Potencial Mtodo de Hargreaves con Mf y Mtodo de Thornthwaite

PRECIP 75%ANLISIS DE PRECIPITACION AL 75%Datos de la estacin AUGUSTO WEBERBAUERmAOP (%)ENEFEBMARABRMAYJUNJULAGOSEPOCTNOVDIC119732.7096.10146.50148.0053.1055.7013.6011.4023.5068.60146.0082.90100.30219745.4191.50107.90124.8043.6047.9010.809.6018.8048.3579.9058.8391.60319758.1186.7096.80115.9038.7041.408.509.2014.9046.6076.8058.3091.304197610.8183.2094.20101.3038.4040.308.308.3614.8046.5071.3057.6086.805197713.5182.4085.60100.1035.4035.807.507.4014.3042.8064.8052.7085.006197816.2281.4083.8098.7734.7033.906.906.5013.9037.0062.9052.0074.907197918.9278.4079.9096.4633.3024.906.906.0011.8035.6060.7843.0071.408198021.6276.4479.6092.6032.5024.096.805.8011.4034.8458.6042.3270.609198124.3269.2476.5082.2031.0023.105.905.5411.3034.8051.3039.6769.7310198227.0363.8073.4082.1230.9019.405.604.7010.7032.0150.9038.4467.1411198329.7363.5070.1077.6029.6519.304.924.6010.2031.7048.6038.0063.7012198432.4363.0668.5974.3029.5018.704.233.309.4030.8048.5037.1056.1013198535.1463.0068.1073.7029.0016.154.213.108.4024.4045.7035.4053.2014198637.8462.4068.0073.7028.8016.003.803.007.9421.7044.4035.4050.3915198740.5462.3067.8072.8028.3612.403.502.607.4421.3444.0535.2047.5116198843.2447.2067.6072.6828.3012.203.192.417.2320.4041.9235.1046.5617198945.9545.1566.4072.0028.2711.903.102.406.5019.8037.9135.0045.2018199048.6544.3065.9670.3026.4010.603.102.406.2618.9431.8034.7044.7019199151.3542.8065.7069.9026.3310.303.002.205.9118.8030.6034.7044.6020199254.0542.6065.4766.5025.909.323.002.105.9018.4026.9034.6542.9021199356.7642.1065.1764.6025.808.572.912.035.5815.7026.6433.1042.7022199459.4642.0063.4063.9924.548.002.891.805.4014.3026.0130.8040.2023199562.1639.3061.6063.5023.627.902.811.805.3513.7125.5030.3040.0024199664.8639.0061.6062.8023.106.702.601.805.1012.8021.5030.0039.9025199767.5739.0060.2062.0023.106.641.901.774.8011.9020.8029.7737.7026199870.2738.6058.8060.8022.406.501.601.704.5011.5919.7029.2037.2027199972.9737.5057.7058.5021.804.191.501.704.5010.2818.6028.4036.5028200075.6834.1056.5056.8021.602.901.301.604.5010.2018.2027.6035.4029200178.3833.5252.8056.4020.992.201.301.523.6010.2014.3026.9334.9630200281.0832.7451.5054.5620.401.101.201.433.5010.1010.2026.8030.8031200383.7831.0048.8054.4019.900.801.101.303.407.609.8026.2029.4032200486.4929.6048.3052.5018.800.001.101.302.706.807.7823.1029.2033200589.1929.0046.8051.5018.800.001.001.002.105.705.4022.5028.5034200691.8924.7044.5042.1017.400.000.200.901.605.104.5019.7028.0035200794.5924.2033.0040.2015.170.000.100.900.604.302.3019.6523.8036200897.3020.5029.8039.4013.300.000.000.800.003.600.9014.6021.50SD21.5121.1623.678.0914.703.122.815.2015.3228.9013.3721.40PM52.2967.7373.6027.3014.973.903.507.7222.4237.6636.1051.09PP ( 75 % )37.7853.4657.6421.845.051.791.614.2112.0918.1727.0836.66

CAL ETPCLCULO DE LA ETPMtodo de HargreavesDatos Estacin Weberbauer:INFORMACIN ADICIONAL PARA CALCULAR LA EVAPOTRANSPIRACIN POTENCIALLatitud:6.44Altitud:2,412msnmLatitud:6.44grados surDATOS OBTENIDOS DE TABLAS

CALCULO DEL ETP EN BASE A LA RADIACION SOLAR (ETP=0.0075*RSM*TMF*CE)CALCULO DEL ETP EN BASE A LA TEMPERATURA (ETP=MF*TMF*CH*CE)MESN DIASNRMM (mm/dia)MesN dasT CN hrs Sol mens. "n"Ra (mm/da)Ra (mm/mes)N (hr/da)N (hr/mes)S (%)RSMCETMFETPMFHR(%)CHT (C)TMF(F)CEETP5 10 6.440 6 8 6.440 6 8 0.000 Ene3114.20161.2015.87491.8512.39383.9841.98239.011.0557.56108.162.46077.40.78914.2057.561.048117.103Enero 3112.3012.6012.3915.8016.1015.87EN BASE A LA RADIACION SOLAS15.8016.1015.87Feb2814.00134.4016.02448.6212.33345.2138.93209.941.0557.2094.412.21280.30.73714.0057.201.04897.728Febrero2812.3012.4012.3316.0016.1016.0216.0016.1016.02Mar3114.10151.9015.60483.6012.10375.1040.50230.811.0557.38104.122.36379.10.75914.1057.381.048107.842Marzo3112.1012.1012.1015.6015.6015.6015.6015.6015.60Abr3014.10162.0014.63439.0211.94358.2745.22221.411.0557.3899.882.10977.60.78614.1057.381.04899.687Abril3012.0011.8011.9414.7014.4014.6314.7014.4014.63May3113.10198.4013.33413.3511.81366.2254.17228.181.0555.5899.711.96876.80.80013.1055.581.04891.721Mayo3111.9011.6011.8113.4013.1013.3313.4013.1013.33Jun3012.50207.0012.71381.3611.71351.4158.91219.521.0554.5094.061.80571.30.88912.5054.501.04891.631Junio3011.8011.5011.7112.8012.4012.7112.8012.4012.71Jul3112.30226.3013.01403.3711.74364.0162.17238.531.0554.14101.531.95066.70.95812.3054.141.048105.996Julio3111.8011.6011.7413.1012.7013.0113.1012.7013.01Ago3112.80213.9013.93431.9511.87368.0158.12246.991.0555.04106.872.09266.80.95612.8055.041.048115.373Agosto3111.9011.8011.8714.0013.7013.9314.0013.7013.93Sep3013.90171.0014.98449.3412.00360.0047.50232.261.0557.02104.122.22268.80.92713.9057.021.048123.114Septiembre3012.0012.0012.0015.0014.9014.9815.0014.9014.98Oct3113.70176.7015.72487.3812.23379.0946.61249.561.0556.66111.172.42772.660.86813.7056.661.048125.072Octubre3112.2012.3012.2315.7015.8015.7215.7015.8015.72Nov3014.00174.0015.84475.3218.79563.8330.86198.041.0557.2089.062.38272.80.86614.0057.201.048123.679Noviembre3021.3012.6018.7915.8016.0015.8415.8016.0015.84Dic3113.90186.0015.77488.7512.49387.0848.05254.101.0557.02113.912.45774.20.84313.9057.021.048123.77Diciembre3112.4012.7012.4915.7016.0015.7715.7016.0015.77Enero 2.452.512.46EN BASE A LA TEMPERATURAFebrero2.212.242.21Marzo2.362.362.36PARA INTERPOLARAbril2.122.082.11Mayo1.981.931.9762.476Junio1.821.751.800.44yJulio1.981.861.956.44xAgosto2.102.052.0920.03Septiembre2.232.212.2282.510Octubre2.422.442.43Noviembre2.372.422.380.44yDiciembre2.442.512.4620.03y = 0.0074815.7016.0015.77x = 2.483

CEDULA

CEDULA DE CULTIVO

ESTACION: AUGUSTO WEBERBAUERLAT:071414"=7.24LONG:7830=78.50ALT:2261msnm

ENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.T MEDIA MENSUAL21.9022.0022.5222.6022.4020.1621.7022.0022.3022.6022.6022.20N DE HRS DE SOL MENS.161.20134.40151.90162.00198.40207.00219.00213.90171.00176.70174.00186.00PP 75%37.7853.4657.6421.845.051.791.614.2112.0918.1727.0836.66

Eficienciaec =0.80ep =0.75

ed =0.70

ea =0.60

Donde : ec = Eficiencia de Conduccin.ed = Eficiencia de Distribucin.ea = Eficiencia de Aplicacinep = Eficiencia parcelaria.

Luego de realizar una visita a la zona en la que se realizar el proyecto, podemos elegir los productos que se sembrarn:

PRODUCTOPER.VEGETATIVOSIEMBRATIPO DE SUELOPENDIENTEPASTOS12meses 01 DE ENEROFranco arcilloso15PAPA4meses 01 DE DICIEMBREFranco arcilloso20ARVEJA4meses 01 DE ABRILFranco arcilloso30ALFALFA12meses 01 DE ENEROFranco arcilloso10MAIZ4meses 01 DE MARZOFranco arenoso45

Segn el area que se ha trazado, se cuenta con un terreno a iirigar de : 100HsEsta rea se la distribuir teniendo en cuenta un esquema de cultivo, de la siguiente manera:

ESQUEMA DEL PLAN DE CULTIVO CON PROYECTOACULTIVOENEFEBMARABRMAYJUNJULAGOSETOCTNOVDIC65PASTOS6565656565656565656565659.95PAPA9.959.959.959.959.959.959.959.959.959.955ARVEJA555510ALFALFA10101010101010101010101010MAIZ101010101099.95TOTAL94.9585.0094.9599.9589.9589.9589.9575.0084.9584.9584.9594.95

Kc para cada mes del cicloCultivoA. (Ha)F.SiemCPASTOS65.0001 DE ENERO0.60PAPA9.9501 DE DICIEMBRE0.50ARVEJA5.0001 DE ABRIL0.60ALFALFA10.0001 DE ENERO0.45MAIZ10.0001 DE MARZO0.60

CLCULO DEL Kc PONDERADO 1).-Kc para cada mes del ciclo

CULTIVOENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.PASTOS0.290.630.710.790.880.931.000.970.890.810.710.33PAPA0.860.520.700.850.760.740.600.850.920.94ARVEJA0.380.880.930.43ALFALFA0.250.570.750.791.001.000.970.850.890.690.310.20MAIZ0.660.880.760.750.49

2).-Kc y C ponderado para cada mes del ciclo

MESENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.Kc0.370.550.660.760.800.830.840.720.730.680.580.38C
Napolen Ros P.: Napolen Ros P.:DE ACUERDO A LA TABLA ANTERIOR(VERDE)0.570.580.570.580.570.570.570.580.570.570.570.57

CALCULO DE LA EVAPOTRANSPIRACION POTENCIAL (ETP)Para el calculo de la evapotraspiracion, tomaremos en cuenta el Metodo de HARGRAVES; cuyas formulas son:

Formula en Base a la Radiacion:ETP = 0.0075*RSM*TMF*CE RSM = 0.075*RMM*S 0.5S = n/Na).-Para el calculo de N:(interpolando)Tabla N 03

LATITUD sENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.512.3012.3012.1012.0011.9011.8011.8011.9012.0012.2012.3012.406.4412.3912.3312.1011.9411.8111.7111.7411.8712.0012.2312.3912.491012.6012.4012.1011.8011.6011.5011.6011.8012.0012.3012.6012.70Dias por mes31.0028.0031.0030.0031.0030.0031.0031.0030.0031.0030.0031.00N383.98345.21375.10358.27366.22351.41364.01368.01360.00379.09371.59387.08

b).-Para el calculo de RMM:Tabla N 02

LATITUD sENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.816.1016.1015.6014.4013.1012.4012.7013.7014.9015.8016.0016.006.4415.8715.9415.6814.5613.3312.7112.9313.8614.9815.7215.8415.841016.4016.3015.5014.2012.8012.0012.4013.5014.8015.9016.2016.20Dias por mes31.0028.0031.0030.0031.0030.0031.0031.0030.0031.0030.0031.00RMM491.85446.43486.02436.68413.35381.36400.95429.54449.34487.38475.32491.16

Entonces, haciendo un resumen de las caractersticas por cada mes, tenemos:

MesesENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.n161.20134.40151.90162.00198.40207.00219.00213.90171.00176.70174.00186.00N383.98345.21375.10358.27366.22351.41364.01368.01360.00379.09371.59387.08S (%)41.9838.9340.5045.2254.1758.9160.1658.1247.5046.6146.8348.05RMM491.85446.43486.02436.68413.35381.36400.95429.54449.34487.38475.32491.16RMS239.01208.92231.96220.23228.18219.52233.25245.61232.26249.56243.94255.36TMF ( Fo )71.4271.6072.5472.6872.3268.2971.0671.6072.1472.6872.6871.96CE1.051.051.051.051.051.051.051.051.051.051.051.05ETP (mm/mes)133.82117.26131.90125.48129.36117.51129.93137.85131.35142.19138.99144.05Dias del Mes312831303130313130313031

CUADRO N 08: CEDULA DE CULTIVO 2SECTOR DE RIEGO: Mejoramiento del Canal de Riego Ojo de Agua - La PcaraSECTOR DE RIEGO: Mejoramiento del Canal de Riego Ojo de Agua - La Pcara

ENE.FEB.MAR.ABR.MAY.JUN.JUL.AGO.SET.OCT.NOV.DIC.REFERENCIAA. de cult.por mes(Has.)94.9585.0094.9599.9589.9589.9589.9575.0084.9584.9584.9594.95COEFICIENTE PONDERADO Kc0.370.550.660.760.800.830.840.720.730.680.580.38ETP (mm)133.82117.26131.90125.48129.36117.51129.93137.85131.35142.19138.99144.0586400ETR (mm/mes)48.8865.0587.6694.89103.5897.16109.4498.6895.5796.7581.2154.34PP75%37.7853.4657.6421.845.051.791.614.2112.0918.1727.0836.66ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!"C "PONDERADO0.570.580.570.580.570.570.570.580.570.570.570.57P.E (1-C)PP75%16.1022.3324.579.282.160.770.691.775.197.8011.6315.63DEMANDA UNITARIA NETA (mm/ha/mes)32.7742.7363.0985.61101.4296.39108.7596.9290.3788.9469.5938.71DEMANDA UNITARIA NETA (m3/ha/mes)327.72427.26630.87856.111014.23963.921087.54969.16903.74889.45695.87387.10DEMANDA NETA TOTAL (m3/mes)31117.2036317.4059900.8985568.4291229.5686704.5897824.3572687.376772.875558.459114.0636755.42DEMANDA NETA (m3/seg)0.0120.0150.0220.0330.0340.0330.0370.0270.0300.0280.0230.014EFICIENCIA DEL PROYECTO : ep0.750.750.750.750.750.750.750.750.750.750.750.75DEMANDA BRUTA (m3/seg)0.020.020.030.040.04540.04460.04870.040.040.040.030.02DEMANDA BRUTA (lts/seg)15.4920.0229.8244.0245.4144.6048.7036.1839.4937.6130.4118.30Con el primer esquema de cultivo, obtenemos que el mximo requerimiento de agua es de : 48.70lts/segOferta aforada:112.00lts/segDemanda del canal97.396lts/seg0.112m3/seg3,071,474.357m3/ao3,532,032.000m3/aoDemanda Promedio84.192m3/Ha/daOferta promedio96.816m3/Ha/da

enero15.49febrero20.02marzo29.82abril44.02mayo45.41junio44.60julio48.70agosto36.18setiembre39.49octubre37.61noviembre30.41diciembra18.30

BAL. OFER-DEMSITUACIN CON PROYECTOBALANCE OFERTA Y DEMANDA HDRICA (M3/AO)(2013-2022)AOSDEMANDAOFERTA BALANCEAOSDEMANDA20133,071,4743,532,032460,55820133,071,47420143,071,4743,532,032460,55820143,071,47420153,071,4743,532,032460,55820153,071,47420163,071,4743,532,032460,55820163,071,47420173,071,4743,532,032460,55820173,071,47420183,071,4743,532,032460,55820183,071,47420193,071,4743,532,032460,55820193,071,47420203,071,4743,532,032460,55820203,071,47420213,071,4743,532,032460,55820213,071,47420223,071,4743,532,032460,55820223,071,47420233,071,4743,532,032460,55820233,071,474

SUPERVIT

DEMANDAMESSEQUIAFECHAENEROFEBREROMARZOABRILMAYOJUNIOJULIOAGOSTOSEPTIEMBREOCTUBRENOVIEMBREDICIEMBREOFERTA112.00112.00112.00112.00112.00112.00112.00112.00112.00112.00112.00112.00DEMANDA30.9840.0359.6488.0390.8389.2097.4072.3778.9875.2360.8236.59N DE DIAS31.0028.0031.0030.0031.0030.0031.0031.0030.0031.0030.0031.00OFERTA MES (M3/MES)299980.80270950.40299980.80290304.00299980.80290304.00299980.80299980.80290304.00299980.80290304.00299980.80DEMANDA MES (M3/MES)82979.1996846.40159735.70228182.46243278.83231212.22260864.95193832.89204727.56201489.06157637.4998014.44DIFERENCIA217001.61174104.00140245.1062121.5456701.9759091.7839115.85106147.9185576.4498491.74132666.51201966.36DEMANDA EN SEQUIAS1249764.17M3208294.03M3/MES12096.00M3

TABLAS