cedula de cultivo

Post on 09-Dec-2015

13 Views

Category:

Documents

3 Downloads

Preview:

Click to see full reader

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

top related