Nuevo-hoja-de-cálculo-de-microsoft-excel-1.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Nuevo-hoja-de-cálculo-de-microsoft-excel-1.xlsx as PDF for free.
More details
- Words: 465
- Pages: 6
ESTACION MORELIA AÑO 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997
Pp (mm) 40.10 38.30 39.60 60.20 75.40 46.10 60.00 35.60 36.90 39.50 51.50 29.00 34.00 36.20 38.00 36.00 31.10 35.90 66.00 53.00 37.90 50.20 60.00 50.30 39.80 35.20 36.40 40.00
ESTACION MORELIA ORDEN MAYOR A MENOR AÑO PP(mm) Tr 1 80.10 2 75.40 3 68.84 4 66.00 5 60.20 6 60.00 7 60.00 8 55.28 9 53.71 10 53.00 11 52.36 12 51.50 13 50.30 14 50.20 15 46.10 16 40.10 17 40.00 18 39.80 19 39.63 20 39.60 21 39.53 22 39.50 23 38.30 24 38.00 25 37.90 26 37.76 27 37.55 28 37.44
41.00 20.50 13.67 10.25 8.20 6.83 5.86 5.13 4.56 4.10 3.73 3.42 3.15 2.93 2.73 2.56 2.41 2.28 2.16 2.05 1.95 1.86 1.78 1.71 1.64 1.58 1.52 1.46 Página 1
ALFREDO GONZALEZ GUAMAN
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
80.10 53.71 30.25 35.46 37.76 39.63 37.55 32.44 37.44 68.84 55.28 39.53 52.36
29 30 31 32 33 34 35 36 37 38 39 40 41
36.90 36.40 36.20 36.00 35.90 35.60 35.46 35.20 34.00 32.44 31.10 30.25 29.00
1.41 1.37 1.32 1.28 1.24 1.21 1.17 1.14 1.11 1.08 1.05 1.03 1.00
Chart Title 90.00 80.00 70.00 Axi s Ti tl e
60.00
f(x) = - 0.9572456446x + 64.7985 R² = 0.8287612674
50.00 40.00 30.00 20.00 10.00 0.00 0
5
10
15
20
25
30
35
40
45
Axi s Titl e PP(mm) Power (Tr)
Li nea r (PP(mm)) Logari thmic (Tr)
Tr
Página 2
ALFREDO GONZALEZ GUAMAN
Tr
PRECIPITACIONES MAXIMAS ANUALES
AÑOS 2 5 10 25 50 100
5 3.16 4.17 4.94 5.95 6.71 7.48
15 5.78 7.63 9.03 10.88 12.28 13.68
DURACION (min) 30 60 7.85 10.31 10.36 13.6 12.26 16.1 14.77 19.39 16.67 21.89 18.57 24.38
120 13.23 17.46 20.66 24.89 28.09 31.29
240 16.7 22.05 26.09 31.43 35.47 39.52
c U RVA S P -d -tr
Axi s Ti tl e
100
10
1 1
10
100
1000
Axi s Ti tl e 2
5
Página 3
10
25
50
100
ALFREDO GONZALEZ GUAMAN
INTENSIADEDES MAXIMAS ANUALES TR AÑOS
5 37.92 50.05 59.22 71.35 80.53 89.7
2 5 10 25 50 100
15 23.13 30.53 36.13 43.53 49.12 54.72
DURACION ( MIN) 30 60 15.7 10.31 20.72 13.6 24.52 16.1 29.54 19.39 33.34 21.89 37.14 24.38
120 6.61 8.73 10.33 12.45 14.05 15.65
240 4.18 5.51 6.52 7.86 8.87 9.88
CURVAS I-D-TR
Axis Title
100
10
1 1
10
100
1000
Axis Title 2
5
10
25
50
100
Página 4
ALFREDO GONZALEZ GUAMAN
cURVAS P-d-tr 100
2 5 10 25 50 100
10
1 1
10
100
1000
Pp (mm) 40.10 38.30 39.60 60.20 75.40 46.10 60.00 35.60 36.90 39.50 51.50 29.00 34.00 36.20 38.00 36.00 31.10 35.90 66.00 53.00 37.90 50.20 60.00 50.30 39.80 35.20 36.40 40.00
ESTACION MORELIA ORDEN MAYOR A MENOR AÑO PP(mm) Tr 1 80.10 2 75.40 3 68.84 4 66.00 5 60.20 6 60.00 7 60.00 8 55.28 9 53.71 10 53.00 11 52.36 12 51.50 13 50.30 14 50.20 15 46.10 16 40.10 17 40.00 18 39.80 19 39.63 20 39.60 21 39.53 22 39.50 23 38.30 24 38.00 25 37.90 26 37.76 27 37.55 28 37.44
41.00 20.50 13.67 10.25 8.20 6.83 5.86 5.13 4.56 4.10 3.73 3.42 3.15 2.93 2.73 2.56 2.41 2.28 2.16 2.05 1.95 1.86 1.78 1.71 1.64 1.58 1.52 1.46 Página 1
ALFREDO GONZALEZ GUAMAN
1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010
80.10 53.71 30.25 35.46 37.76 39.63 37.55 32.44 37.44 68.84 55.28 39.53 52.36
29 30 31 32 33 34 35 36 37 38 39 40 41
36.90 36.40 36.20 36.00 35.90 35.60 35.46 35.20 34.00 32.44 31.10 30.25 29.00
1.41 1.37 1.32 1.28 1.24 1.21 1.17 1.14 1.11 1.08 1.05 1.03 1.00
Chart Title 90.00 80.00 70.00 Axi s Ti tl e
60.00
f(x) = - 0.9572456446x + 64.7985 R² = 0.8287612674
50.00 40.00 30.00 20.00 10.00 0.00 0
5
10
15
20
25
30
35
40
45
Axi s Titl e PP(mm) Power (Tr)
Li nea r (PP(mm)) Logari thmic (Tr)
Tr
Página 2
ALFREDO GONZALEZ GUAMAN
Tr
PRECIPITACIONES MAXIMAS ANUALES
AÑOS 2 5 10 25 50 100
5 3.16 4.17 4.94 5.95 6.71 7.48
15 5.78 7.63 9.03 10.88 12.28 13.68
DURACION (min) 30 60 7.85 10.31 10.36 13.6 12.26 16.1 14.77 19.39 16.67 21.89 18.57 24.38
120 13.23 17.46 20.66 24.89 28.09 31.29
240 16.7 22.05 26.09 31.43 35.47 39.52
c U RVA S P -d -tr
Axi s Ti tl e
100
10
1 1
10
100
1000
Axi s Ti tl e 2
5
Página 3
10
25
50
100
ALFREDO GONZALEZ GUAMAN
INTENSIADEDES MAXIMAS ANUALES TR AÑOS
5 37.92 50.05 59.22 71.35 80.53 89.7
2 5 10 25 50 100
15 23.13 30.53 36.13 43.53 49.12 54.72
DURACION ( MIN) 30 60 15.7 10.31 20.72 13.6 24.52 16.1 29.54 19.39 33.34 21.89 37.14 24.38
120 6.61 8.73 10.33 12.45 14.05 15.65
240 4.18 5.51 6.52 7.86 8.87 9.88
CURVAS I-D-TR
Axis Title
100
10
1 1
10
100
1000
Axis Title 2
5
10
25
50
100
Página 4
ALFREDO GONZALEZ GUAMAN
cURVAS P-d-tr 100
2 5 10 25 50 100
10
1 1
10
100
1000
More Documents from "alfredo"
Actividad 2 Gadsi.docx
November 2019 31
Ch. De Beriot 3 Grandi Studi Op.43 Per 2 Violini
May 2020 17
