Varast 3.1

Descargar como xlsx, pdf o txt
Descargar como xlsx, pdf o txt
Está en la página 1de 17

Cátedra de Climatología y Fenología Agrícolas

Facultad de Agonómía - Universidad de Buenos Aires (FAUBA)

Fernández Long María Elena, Hurtado Rafael

VarAst 3.1
Planilla de cálculo de variables astronómicas

Ingrese en la hoja "Datos" la información necesaria para los cálculos.

En la hoja "Resultados" se presentan las variables calculadas:


1. Heliofanía Astronómica (o duración del día).
2. Fotoperíodo (o duración del día más los crepúsculos).
3. Radiación Astronómica (también llamada radiación extraterrestre).

En las hojas "Gráficos" encontrará las figuras correspondientes.


ogía Agrícolas
enos Aires (FAUBA)

do Rafael

1
ronómicas
Ingrese el nombre de la
Nombre Pergamino localidad

Latitud
Ingrese la latitud de la
Lat (°) 47 localidad en grados,
Lat (') 0 minutos y segundos
Lat ('') 0
Ingrese "S" para localidades del hemisferio sur y
Hemisferio S "N" para localidades del hemisferio norte

Latitud -47.440

Ingresar la unidad elegida:


Unidades: 2 1 para cal/cm2 min
2 para MJ/m2 dia
3 para W/m2
4 para mm
alidades del hemisferio sur y
del hemisferio norte

egida:
Pergamino
Fecha HA F RA
(hs) (hs) (Mj/m2dia)
1-ene 15.7 17.2 44.3
2-ene 15.7 17.2 44.3
3-ene 15.6 17.2 44.2
Var Ast 3.1 4-ene 15.6 17.1 44.1
5-ene 15.6 17.1 44.0
6-ene 15.6 17.1 43.9
7-ene 15.6 17.1 43.8
8-ene 15.5 17.0 43.7
9-ene 15.5 17.0 43.6
10-ene 15.5 17.0 43.5
11-ene 15.5 16.9 43.4
12-ene 15.4 16.9 43.3
13-ene 15.4 16.9 43.2
14-ene 15.4 16.8 43.0
15-ene 15.3 16.8 42.9
16-ene 15.3 16.8 42.8
17-ene 15.3 16.7 42.6
18-ene 15.2 16.7 42.5
19-ene 15.2 16.6 42.3
20-ene 15.2 16.6 42.1
21-ene 15.1 16.6 42.0
22-ene 15.1 16.5 41.8
23-ene 15.0 16.5 41.6
24-ene 15.0 16.4 41.4
25-ene 15.0 16.4 41.2
26-ene 14.9 16.3 41.0
27-ene 14.9 16.3 40.9
28-ene 14.8 16.2 40.6
29-ene 14.8 16.2 40.4
30-ene 14.8 16.1 40.2
31-ene 14.7 16.1 40.0
1-feb 14.7 16.0 39.8
2-feb 14.6 16.0 39.6
3-feb 14.6 15.9 39.3
4-feb 14.5 15.9 39.1
5-feb 14.5 15.8 38.9
6-feb 14.4 15.8 38.6
7-feb 14.4 15.7 38.4
8-feb 14.3 15.7 38.1
9-feb 14.3 15.6 37.9
10-feb 14.2 15.5 37.6
11-feb 14.2 15.5 37.4
12-feb 14.1 15.4 37.1
13-feb 14.1 15.4 36.8
14-feb 14.0 15.3 36.6
15-feb 14.0 15.3 36.3
16-feb 13.9 15.2 36.0
17-feb 13.9 15.1 35.7
18-feb 13.8 15.1 35.5
19-feb 13.8 15.0 35.2
20-feb 13.7 15.0 34.9
21-feb 13.6 14.9 34.6
22-feb 13.6 14.9 34.3
23-feb 13.5 14.8 34.0
24-feb 13.5 14.7 33.7
25-feb 13.4 14.7 33.4
26-feb 13.4 14.6 33.1
27-feb 13.3 14.6 32.8
28-feb 13.3 14.5 32.5
1-mar 13.2 14.4 32.2
2-mar 13.1 14.4 31.9
3-mar 13.1 14.3 31.6
4-mar 13.0 14.3 31.3
5-mar 13.0 14.2 30.9
6-mar 12.9 14.1 30.6
7-mar 12.9 14.1 30.3
8-mar 12.8 14.0 30.0
9-mar 12.7 13.9 29.7
10-mar 12.7 13.9 29.4
11-mar 12.6 13.8 29.0
12-mar 12.6 13.8 28.7
13-mar 12.5 13.7 28.4
14-mar 12.5 13.6 28.1
15-mar 12.4 13.6 27.7
16-mar 12.3 13.5 27.4
17-mar 12.3 13.5 27.1
18-mar 12.2 13.4 26.8
19-mar 12.2 13.3 26.5
20-mar 12.1 13.3 26.1
21-mar 12.0 13.2 25.8
22-mar 12.0 13.2 25.5
23-mar 11.9 13.1 25.2
24-mar 11.9 13.1 24.8
25-mar 11.8 13.0 24.5
26-mar 11.8 12.9 24.2
27-mar 11.7 12.9 23.9
28-mar 11.6 12.8 23.6
29-mar 11.6 12.8 23.3
30-mar 11.5 12.7 22.9
31-mar 11.5 12.6 22.6
1-abr 11.4 12.6 22.3
2-abr 11.3 12.5 22.0
3-abr 11.3 12.5 21.7
4-abr 11.2 12.4 21.4
5-abr 11.2 12.4 21.1
6-abr 11.1 12.3 20.8
7-abr 11.1 12.2 20.5
8-abr 11.0 12.2 20.2
9-abr 10.9 12.1 19.9
10-abr 10.9 12.1 19.6
11-abr 10.8 12.0 19.3
12-abr 10.8 12.0 19.0
13-abr 10.7 11.9 18.7
14-abr 10.7 11.9 18.4
15-abr 10.6 11.8 18.2
16-abr 10.5 11.8 17.9
17-abr 10.5 11.7 17.6
18-abr 10.4 11.6 17.3
19-abr 10.4 11.6 17.1
20-abr 10.3 11.5 16.8
21-abr 10.3 11.5 16.6
22-abr 10.2 11.4 16.3
23-abr 10.2 11.4 16.0
24-abr 10.1 11.3 15.8
25-abr 10.1 11.3 15.5
26-abr 10.0 11.2 15.3
27-abr 9.9 11.2 15.1
28-abr 9.9 11.1 14.8
29-abr 9.8 11.1 14.6
30-abr 9.8 11.0 14.4
1-may 9.7 11.0 14.1
2-may 9.7 10.9 13.9
3-may 9.6 10.9 13.7
4-may 9.6 10.9 13.5
5-may 9.5 10.8 13.3
6-may 9.5 10.8 13.1
7-may 9.4 10.7 12.9
8-may 9.4 10.7 12.7
9-may 9.4 10.6 12.5
10-may 9.3 10.6 12.3
11-may 9.3 10.6 12.1
12-may 9.2 10.5 11.9
13-may 9.2 10.5 11.8
14-may 9.1 10.4 11.6
15-may 9.1 10.4 11.4
16-may 9.1 10.4 11.3
17-may 9.0 10.3 11.1
18-may 9.0 10.3 11.0
19-may 8.9 10.3 10.8
20-may 8.9 10.2 10.7
21-may 8.9 10.2 10.5
22-may 8.8 10.2 10.4
23-may 8.8 10.1 10.3
24-may 8.7 10.1 10.1
25-may 8.7 10.1 10.0
26-may 8.7 10.0 9.9
27-may 8.7 10.0 9.8
28-may 8.6 10.0 9.7
29-may 8.6 9.9 9.6
30-may 8.6 9.9 9.5
31-may 8.5 9.9 9.4
1-jun 8.5 9.9 9.3
2-jun 8.5 9.9 9.2
3-jun 8.5 9.8 9.1
4-jun 8.4 9.8 9.0
5-jun 8.4 9.8 9.0
6-jun 8.4 9.8 8.9
7-jun 8.4 9.8 8.8
8-jun 8.4 9.7 8.8
9-jun 8.3 9.7 8.7
10-jun 8.3 9.7 8.7
11-jun 8.3 9.7 8.6
12-jun 8.3 9.7 8.6
13-jun 8.3 9.7 8.5
14-jun 8.3 9.7 8.5
15-jun 8.3 9.7 8.5
16-jun 8.3 9.7 8.5
17-jun 8.3 9.7 8.4
18-jun 8.3 9.6 8.4
19-jun 8.2 9.6 8.4
20-jun 8.2 9.6 8.4
21-jun 8.2 9.6 8.4
22-jun 8.2 9.6 8.4
23-jun 8.2 9.6 8.4
24-jun 8.3 9.6 8.4
25-jun 8.3 9.7 8.4
26-jun 8.3 9.7 8.4
27-jun 8.3 9.7 8.5
28-jun 8.3 9.7 8.5
29-jun 8.3 9.7 8.5
30-jun 8.3 9.7 8.6
1-jul 8.3 9.7 8.6
2-jul 8.3 9.7 8.6
3-jul 8.3 9.7 8.7
4-jul 8.4 9.7 8.8
5-jul 8.4 9.8 8.8
6-jul 8.4 9.8 8.9
7-jul 8.4 9.8 8.9
8-jul 8.4 9.8 9.0
9-jul 8.5 9.8 9.1
10-jul 8.5 9.9 9.2
11-jul 8.5 9.9 9.2
12-jul 8.5 9.9 9.3
13-jul 8.6 9.9 9.4
14-jul 8.6 9.9 9.5
15-jul 8.6 10.0 9.6
16-jul 8.7 10.0 9.7
17-jul 8.7 10.0 9.8
18-jul 8.7 10.1 10.0
19-jul 8.7 10.1 10.1
20-jul 8.8 10.1 10.2
21-jul 8.8 10.2 10.3
22-jul 8.9 10.2 10.5
23-jul 8.9 10.2 10.6
24-jul 8.9 10.3 10.7
25-jul 9.0 10.3 10.9
26-jul 9.0 10.3 11.0
27-jul 9.1 10.4 11.2
28-jul 9.1 10.4 11.3
29-jul 9.1 10.4 11.5
30-jul 9.2 10.5 11.7
31-jul 9.2 10.5 11.8
1-ago 9.3 10.6 12.0
2-ago 9.3 10.6 12.2
3-ago 9.4 10.6 12.4
4-ago 9.4 10.7 12.6
5-ago 9.4 10.7 12.8
6-ago 9.5 10.8 13.0
7-ago 9.5 10.8 13.2
8-ago 9.6 10.9 13.4
9-ago 9.6 10.9 13.6
10-ago 9.7 10.9 13.8
11-ago 9.7 11.0 14.0
12-ago 9.8 11.0 14.2
13-ago 9.8 11.1 14.5
14-ago 9.9 11.1 14.7
15-ago 9.9 11.2 14.9
16-ago 10.0 11.2 15.1
17-ago 10.1 11.3 15.4
18-ago 10.1 11.3 15.6
19-ago 10.2 11.4 15.9
20-ago 10.2 11.4 16.1
21-ago 10.3 11.5 16.4
22-ago 10.3 11.5 16.6
23-ago 10.4 11.6 16.9
24-ago 10.4 11.6 17.2
25-ago 10.5 11.7 17.4
26-ago 10.5 11.8 17.7
27-ago 10.6 11.8 18.0
28-ago 10.7 11.9 18.2
29-ago 10.7 11.9 18.5
30-ago 10.8 12.0 18.8
31-ago 10.8 12.0 19.1
1-sep 10.9 12.1 19.4
2-sep 10.9 12.1 19.7
3-sep 11.0 12.2 20.0
4-sep 11.1 12.2 20.2
5-sep 11.1 12.3 20.5
6-sep 11.2 12.4 20.8
7-sep 11.2 12.4 21.1
8-sep 11.3 12.5 21.4
9-sep 11.3 12.5 21.7
10-sep 11.4 12.6 22.1
11-sep 11.5 12.6 22.4
12-sep 11.5 12.7 22.7
13-sep 11.6 12.8 23.0
14-sep 11.6 12.8 23.3
15-sep 11.7 12.9 23.6
16-sep 11.8 12.9 23.9
17-sep 11.8 13.0 24.2
18-sep 11.9 13.1 24.6
19-sep 11.9 13.1 24.9
20-sep 12.0 13.2 25.2
21-sep 12.0 13.2 25.5
22-sep 12.1 13.3 25.8
23-sep 12.2 13.3 26.1
24-sep 12.2 13.4 26.5
25-sep 12.3 13.5 26.8
26-sep 12.3 13.5 27.1
27-sep 12.4 13.6 27.4
28-sep 12.5 13.6 27.7
29-sep 12.5 13.7 28.1
30-sep 12.6 13.8 28.4
1-oct 12.6 13.8 28.7
2-oct 12.7 13.9 29.0
3-oct 12.7 13.9 29.3
4-oct 12.8 14.0 29.7
5-oct 12.9 14.1 30.0
6-oct 12.9 14.1 30.3
7-oct 13.0 14.2 30.6
8-oct 13.0 14.3 30.9
9-oct 13.1 14.3 31.2
10-oct 13.1 14.4 31.5
11-oct 13.2 14.4 31.8
12-oct 13.3 14.5 32.2
13-oct 13.3 14.6 32.5
14-oct 13.4 14.6 32.8
15-oct 13.4 14.7 33.1
16-oct 13.5 14.7 33.4
17-oct 13.5 14.8 33.7
18-oct 13.6 14.9 34.0
19-oct 13.6 14.9 34.3
20-oct 13.7 15.0 34.5
21-oct 13.8 15.0 34.8
22-oct 13.8 15.1 35.1
23-oct 13.9 15.1 35.4
24-oct 13.9 15.2 35.7
25-oct 14.0 15.3 36.0
26-oct 14.0 15.3 36.2
27-oct 14.1 15.4 36.5
28-oct 14.1 15.4 36.8
29-oct 14.2 15.5 37.0
30-oct 14.2 15.5 37.3
31-oct 14.3 15.6 37.6
1-nov 14.3 15.7 37.8
2-nov 14.4 15.7 38.1
3-nov 14.4 15.8 38.3
4-nov 14.5 15.8 38.6
5-nov 14.5 15.9 38.8
6-nov 14.6 15.9 39.0
7-nov 14.6 16.0 39.3
8-nov 14.7 16.0 39.5
9-nov 14.7 16.1 39.7
10-nov 14.8 16.1 39.9
11-nov 14.8 16.2 40.1
12-nov 14.8 16.2 40.4
13-nov 14.9 16.3 40.6
14-nov 14.9 16.3 40.8
15-nov 15.0 16.4 41.0
16-nov 15.0 16.4 41.2
17-nov 15.1 16.5 41.4
18-nov 15.1 16.5 41.5
19-nov 15.1 16.6 41.7
20-nov 15.2 16.6 41.9
21-nov 15.2 16.6 42.1
22-nov 15.2 16.7 42.2
23-nov 15.3 16.7 42.4
24-nov 15.3 16.8 42.5
25-nov 15.3 16.8 42.7
26-nov 15.4 16.8 42.8
27-nov 15.4 16.9 43.0
28-nov 15.4 16.9 43.1
29-nov 15.5 16.9 43.2
30-nov 15.5 17.0 43.4
1-dic 15.5 17.0 43.5
2-dic 15.5 17.0 43.6
3-dic 15.6 17.1 43.7
4-dic 15.6 17.1 43.8
5-dic 15.6 17.1 43.9
6-dic 15.6 17.1 44.0
7-dic 15.6 17.2 44.1
8-dic 15.7 17.2 44.2
9-dic 15.7 17.2 44.2
10-dic 15.7 17.2 44.3
11-dic 15.7 17.2 44.4
12-dic 15.7 17.3 44.4
13-dic 15.7 17.3 44.5
14-dic 15.7 17.3 44.5
15-dic 15.7 17.3 44.5
16-dic 15.7 17.3 44.6
17-dic 15.7 17.3 44.6
18-dic 15.8 17.3 44.6
19-dic 15.8 17.3 44.6
20-dic 15.8 17.3 44.7
21-dic 15.8 17.3 44.7
22-dic 15.8 17.3 44.7
23-dic 15.8 17.3 44.7
24-dic 15.7 17.3 44.6
25-dic 15.7 17.3 44.6
26-dic 15.7 17.3 44.6
27-dic 15.7 17.3 44.6
28-dic 15.7 17.3 44.5
29-dic 15.7 17.3 44.5
30-dic 15.7 17.2 44.4
31-dic 15.7 17.2 44.4
Altura del Sol (grados)
para el día 21 de cada mes
Horas Ene Feb Mar Abr May Jun
0 -22.5 -31.4 -42.7 -54.6 -62.9 -66.0
1 -21.2 -29.9 -40.9 -52.4 -60.3 -63.2
2 -17.3 -25.6 -35.9 -46.6 -53.7 -56.1
Var Ast 3.1 3 -11.3 -19.1 -28.7 -38.4 -44.8 -47.0
4 -3.7 -10.9 -19.8 -28.9 -35.0 -37.1
5 5.1 -1.7 -10.2 -18.9 -24.9 -27.0
6 14.6 8.2 -0.1 -8.8 -14.9 -17.0
7 24.7 18.3 10.0 1.0 -5.3 -7.6
8 34.8 28.3 19.7 10.2 3.5 1.0
9 44.6 37.7 28.5 18.3 11.1 8.4
10 53.4 45.8 35.8 24.8 17.0 14.2
11 60.0 51.6 40.7 29.1 20.9 17.9
12 62.6 53.7 42.5 30.6 22.2 19.1
13 60.0 51.6 40.7 29.1 20.9 17.9
14 53.4 45.8 35.8 24.8 17.0 14.2
15 44.6 37.7 28.5 18.3 11.1 8.4
16 34.8 28.3 19.7 10.2 3.5 1.0
17 24.7 18.3 10.0 1.0 -5.3 -7.6
18 14.6 8.2 -0.1 -8.8 -14.9 -17.0
19 5.1 -1.7 -10.2 -18.9 -24.9 -27.0
20 -3.7 -10.9 -19.8 -28.9 -35.0 -37.1
21 -11.3 -19.1 -28.7 -38.4 -44.8 -47.0
22 -17.3 -25.6 -35.9 -46.6 -53.7 -56.1
23 -21.2 -29.9 -40.9 -52.4 -60.3 -63.2
del Sol (grados)
día 21 de cada mes
Jul Ago Sep Oct Nov Dic
-62.7 -53.9 -41.9 -30.4 -21.9 -19.1
-60.1 -51.7 -40.1 -28.9 -20.6 -17.9
-53.5 -46.0 -35.2 -24.7 -16.7 -14.2
-44.7 -37.8 -28.0 -18.2 -10.8 -8.4
-34.9 -28.4 -19.2 -10.1 -3.2 -1.0
-24.7 -18.4 -9.6 -0.9 5.5 7.6
-14.7 -8.3 0.5 8.9 15.1 17.0
-5.1 1.6 10.6 19.1 25.1 27.0
3.6 10.8 20.3 29.1 35.2 37.1
11.2 18.9 29.2 38.5 45.0 47.0
17.2 25.5 36.5 46.7 53.9 56.1
21.1 29.8 41.5 52.6 60.6 63.2
22.4 31.3 43.3 54.7 63.2 66.0
21.1 29.8 41.5 52.6 60.6 63.2
17.2 25.5 36.5 46.7 53.9 56.1
11.2 18.9 29.2 38.5 45.0 47.0
3.6 10.8 20.3 29.1 35.2 37.1
-5.1 1.6 10.6 19.1 25.1 27.0
-14.7 -8.3 0.5 8.9 15.1 17.0
-24.7 -18.4 -9.6 -0.9 5.5 7.6
-34.9 -28.4 -19.2 -10.1 -3.2 -1.0
-44.7 -37.8 -28.0 -18.2 -10.8 -8.4
-53.5 -46.0 -35.2 -24.7 -16.7 -14.2
-60.1 -51.7 -40.1 -28.9 -20.6 -17.9
Heliofanía Astronómica y Fotoperíodo

20

15

HA
F
Horas

10

0
21-jun 21-jul 21-ago 21-sep 21-oct 21-nov 21-dic 21-ene 21-feb 21-mar 21-abr 21-may 21-jun
Radiación Astronómica
50

45

40

35

30
Radiación Astronómica

RA
25

20

15

10

0
21-jun 21-jul 21-ago 21-sep 21-oct 21-nov 21-dic 21-ene 21-feb 21-mar 21-abr 21-may 21-jun
Altura del Sol al mediodía
90

80

70

60
Altura del Sol (grados)

50

40

30

20

10

0
Jun Jul Ago Sep Oct Nov Dic Ene Feb Mar Abr May Jun

También podría gustarte