cedula de cultivo

9
CULTIVOS % AREA (ha) JULIO ha/mes Maiz grano 51.86 691.21 Papa s.t. 28.56 278.40 1.00 278.40 Papa s.g 6.97 67.95 Hortalizas 13.62 132.81 Haba GS 19.34 188.54 Haba GV 10.51 102.50 0.23 102.50 Arveja GV 9.72 94.80 0.19 94.80 Trigo 7.26 168.66 Cebada Forrajera 10.10 98.44 Alfalfa 8.56 83.40 0.90 83.40 TOTAL 166.50 1,906.71 Area Cultivada Mensual (ha) 559.10 Kc Ponderado 0.71 ETP(mm) 10.50 ETR(mm) 7.42 PE (mm) 2.14 PE 75% (mm) 1.61 Consumo Teorico (mm) 5.81 Demanda Unitaria Neta (m3/ha) 58.14 Eficiencia de riego (%) 42.50 Demanda Bruta de Agua (mm/ha) 13.68 N` Dias/mes 31.00 Modulo de Riego 0.05 Caudal a Captar (Q=l/s) 62.8241935

Upload: dayana-valencia-pezo

Post on 09-Dec-2015

13 views

Category:

Documents


3 download

DESCRIPTION

hoja de calculo para hallar cedula de cultivo

TRANSCRIPT

CULTIVOS % AREA (ha) JULIO ha/mes kc*haMaiz grano 51.86 691.21 - Papa s.t. 28.56 278.40 1.00 278.40 278.40 Papa s.g 6.97 67.95 - Hortalizas 13.62 132.81 - Haba GS 19.34 188.54 - Haba GV 10.51 102.50 0.23 102.50 23.58 Arveja GV 9.72 94.80 0.19 94.80 18.01 Trigo 7.26 168.66 - Cebada Forrajera 10.10 98.44 - Alfalfa 8.56 83.40 0.90 83.40 75.06 TOTAL 166.50 1,906.71 395.05

Area Cultivada Mensual (ha) 559.10 Kc Ponderado 0.71 ETP(mm) 10.50 ETR(mm) 7.42 PE (mm) 2.14 PE 75% (mm) 1.61 Consumo Teorico (mm) 5.81 Demanda Unitaria Neta (m3/ha) 58.14 Eficiencia de riego (%) 42.50 Demanda Bruta de Agua (mm/ha) 13.68 N` Dias/mes 31.00 Modulo de Riego 0.05 Caudal a Captar (Q=l/s) 62.8241935

AGOSTO ha/mes kc*ha SETIEMBRE ha/mes kc*ha OCTUBRE ha/mes 1.00 691.21 691.21 0.20 691.21 138.24 0.54 691.21 0.32 278.40 89.09 0.81 278.40 225.50 0.98 278.40

- 1.00 67.95 67.95 0.24 67.95 - - - 1.00 188.54 188.54 0.24 188.54 - -

0.48 94.80 45.50 0.59 94.80 55.93 0.53 94.80 - - 1.00 168.66 - -

0.90 83.40 75.06 0.90 83.40 75.06 0.90 83.40 900.86 751.23

1,147.81 1,404.30 1,572.96 0.78 0.53 0.64 11.60 12.35 13.50 9.10 6.61 8.60 2.96 5.78 3.65 2.22 4.33 2.74 6.88 2.27 5.86 68.84 22.72 58.59 42.50 42.50 42.50 16.20 5.34 13.79 31.00 30.00 31.00 0.06 0.02 0.05 152.717111 63.7078401 178.109638

#DIV/0!

kc*ha NOVIEMBRE ha/mes kc*ha DICIEMBRE ha/mes kc*ha ENERO 373.25 0.79 691.21 546.06 0.94 691.21 649.74 0.99 272.83 0.87 278.40 242.21 0.38 278.40 105.79 16.31 0.65 67.95 44.17 0.90 67.95 61.16 0.99 - - 1.00 132.81 132.81 0.19 45.25 0.65 188.54 122.55 0.90 188.54 169.69 0.99 - - - 50.24 0.23 94.80 21.80 - 168.66 0.14 168.66 23.61 0.40 168.66 67.46 0.65 - - - 1.00 75.06 0.90 83.40 75.06 0.90 83.40 75.06 0.90 1,001.61 1,075.46 1,261.70

1,572.96 1,610.97 1,431.01 0.68 0.78 0.87 13.45 12.45 11.70 9.20 9.75 10.19 12.60 25.78 37.98 9.45 19.33 28.49 -0.25 -9.58 -18.29 -2.54 -95.84 -182.93 42.50 42.50 42.50 -0.60 -22.55 -43.04 30.00 31.00 31.00 -0.00 -0.08 -0.16 -7.97941638 -298.402447 -505.920854

ha/mes kc*ha FEBRERO ha/mes kc*ha MARZO ha/mes kc*ha 691.21 684.30 1.00 691.21 691.21 0.94 691.21 649.74

- - - 67.95 67.27 0.94 67.95 63.87 0.74 67.95 50.28 132.81 25.23 0.48 132.81 63.75 0.59 132.81 78.36 188.54 186.65 0.94 188.54 177.23 0.74 188.54 139.52

- 1.00 102.50 102.50 0.19 102.50 19.48 - - -

168.66 109.63 0.84 168.66 141.67 0.45 168.66 75.90 98.44 98.44 0.17 98.44 16.73 0.49 98.44 48.24 83.40 75.06 0.90 83.40 75.06 0.90 83.40 75.06

1,246.59 1,332.03 1,136.57

1,533.51 1,533.51 0.87 0.74 10.90 11.95 9.47 8.86 21.65 7.85 16.24 5.89 -6.77 2.97 -67.70 29.69 42.50 42.50 -15.93 6.99 28.00 31.00 -0.07 0.03 -222.132403 88.0026594

ABRIL ha/mes kc*ha MAYO ha/mes kc*ha JUNIO ha/mes 0.76 691.21 525.32 0.32 691.21 221.19

- - 0.29 67.95 19.71 - 0.53 132.81 70.39 0.23 132.81 30.55 0.29 188.54 54.68 - 0.48 102.50 49.20 0.59 102.50 60.47 0.53 102.50

- - 1.00 94.80 - -

0.78 98.44 76.78 0.45 98.44 44.30 0.90 83.40 75.06 0.90 83.40 75.06 0.90 83.40

871.13 431.57

1,364.85 1,108.36 280.70 0.64 0.39 0.80 11.72 11.20 9.95 7.48 4.36 7.95 2.15 0.25 0.15 1.61 0.19 0.11 5.87 4.17 7.83 58.68 41.73 78.34 42.50 42.50 42.50 13.81 9.82 18.43 30.00 31.00 30.00 0.05 0.04 0.07 159.944797 89.4001692 43.9173602

kc*ha - - - - - 54.33 94.80 - - 75.06 224.19