Hoja1CEDULA DE CULTIVOEto=p*(0.46*t+8.13)CULTIVOAREA% AREAEneroFebreroMarzoAbrilMayoJunioJulioAgostoSeptiembreOctubreNoviembreDiciembrePAPA11023.40%0.700.750.450.751.050.85MAIZ AMILACEO12025.53%0.950.800.400.801.051.00ARVEJA8017.02%0.400.701.051.000.950.80PASTOS9019.15%1.001.001.001.001.001.001.001.001.001.001.001.00TRIGO7014.89%1.050.700.200.800.400.75N dias mel mes312831303130313130313031AREA DE TERRENO CULTIVADO470100.00%390390240240170170170170320320390390Kc promedio0.910.810.570.841.021.000.980.910.590.840.920.91Evapotrans. Potencial113.5883.3691.293.92104.5791.35112.21113.26107.4585.47115103.6Evapotrans. Real103.2467.8651.6879.05107.0391.35109.57102.6062.9671.71106.0194.57Precipitacin 75%33.8061.2591.9043.9020.002.251.003.5014.8046.1040.0084.70PP EFECTIVA13.5224.536.7617.5680.90.41.45.9218.441633.88Requerimiento neto(mm/ha)

R.ORTIZ.V:suma(areas*kc)/areasR.ORTIZ.V:DE DATOS METEREOLOGICOSR.ORTIZ.V:0.4*PP al 75%

Hoja2

Hoja3