View
217
Download
3
Category
Preview:
DESCRIPTION
Cedula de cultivo hoja de calculo
Citation preview
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
Recommended