hoja de calculo - san lorenzo v2
TRANSCRIPT
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 1/20
Obra : REHABILITACIÓN Y MEJORAMIENTO DE CANAL SAN LORENZO, DISTRITO DE LUNAHUANA, CAÑETE, LIMA
Subpresup : ADICIONAL - PASE AEREO
Fecha : 01/11/2013
Lugar : LIMA - CAÑETE - LUNAHUANA
DATOS GEOMETRICOS:
Luz total del puente m
Altura de de torre " H1 " m → m
Altura de de torre " H2 " m → m
Altura de flecha " F1 " m
Altura de de torre " h1 " m → m
Altura de de torre " h2 " m
Altura de flecha " f1 " m
DISEÑO DE PENDOLAS:Distancia entre pendolas m
Diámetro de Tub. mm
Area de Tubería m2
Peso de tubería Kg/m
Peso de Agua en Tubería Kg/m
Peso de accesorios Kg/m
Peso de péndola Kg/m
Factor de Seguridad De 3 a 6
Peso total / péndola Kg.
# de cables
Tensión de rotura péndolTon
Se usará cable de pulg tipo BOA 6 x 19 , rotura = → Ok
DISEÑO DE CABLE PRINCIPAL:
Diámetro cable p. Pulg. Geometria:
# de cables
Peso cable(s) Kg/m 1ra interacción:
Peso Cables y Accesorios Kg/m Prom. Hs = = a =
Pviento = 0.005 x 0.7 x Velocidad viento ̂ 2 x ancho puente xo = Δy =
Pviento = Kg/m a = x2 =
Psismo = 0.18 x Peso 1ra interacción:
Psismo = Kg/m H1 = = m a =
Peso por unidad long. = Kg/m x2 = m Δy =Peso para el cable = Kg/m a = x2 =
Tensión en Cable Principal
TH = kg
Factor de Seguridad= De 2.5 a 6TV 1 = kg → T 1 = kg → T rup1 = ton Se usará cable de pulg tipTV 2 = kg → T 2 = kg → T rup2 = ton rotura = → Ok
DISEÑO DE CABLE SEGUNDARIO:
Diámetro cable p. Pulg. Geometria:
# de cables
Peso cable(s) Kg/m 1ra interacción:Peso Cables y Accesorios Kg/m h1 = = m x1 =
Pviento = 0.005 x 0.7 x Velocidad viento ̂2 x ancho puente x1 = m h1 =
Pviento = Kg/m a = m
Psismo = 0.18 x Peso
Psismo = Kg/m
Peso por unidad long. = Kg/m
Peso para el cable = Kg/m
Tensión en Cable Principal
5.60
2.93
24.78
6.00
6.00
2.00
5.95
1/2
1.36
2.00
1.00
72.71
0.22
1.00
0.50
0.39
3.00
3/8
160.00
0.02
14.00
10.05
4.00 3.10
DISE O DE PASE AEREO
60.00
2.00
0.50
Cant.
6.00
6.00
16.25
3.00
145.80
30.00
4.00
146.60
24.78
6.63
145.80
-
41.81
2,660.09
330.24
18.15
2,680.51 5.36
758.47 2,766.11 5.53
2.00
10.4
1.36 16.25 3.00
41.80
1/2
1/2
2.00
18.20
41.80
6.00 146.60
41.81 -
0.79
3.00
5.60 580.80
2.00
2.93
Modificar
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 2/20
Obra : REHABILITACIÓN Y MEJORAMIENTO DE CANAL SAN LORENZO, DISTRITO DE LUNAHUANA, CAÑETE, LIMA
Subpresup : ADICIONAL - PASE AEREO
Fecha : 01/11/2013
Lugar : LIMA - CAÑETE - LUNAHUANA
DISE O DE PASE AEREO
DISEÑO DE CAMARAS DE ANCLAJE:
Torre 1 Torre 1
Profund. de Fundación = m Profund. de Fundación =
H c.a. = m H c.a. =
b c.a. = m b c.a. =
prof. c.a. = m prof. c.a. =
Peso de la cámara = ton Peso de la cámara =Separacion de la Torre = m Separacion de la Torre =
Ø1° ' = ° Ø2° ' =
Ø1° '' = ° Ø2° '' =
T 1 ' = ton T 2 ' =
T 1 '' = ton T 2 '' =
Th = ton Th =
Tv = ton Tv =
d = m d =
e = m → Ok e =
µ = µ =
F.S.D. = → Ok F.S.D. =
F.S.V. = → Ok F.S.V. =
59.53
0.12
47.73
39.38
2.50
2.50
2.68
2.50
3.00
5.00
Factores de Seguridad alDeslizamiento y Volteo
Tipo de Suelo
Grano grueso
limo o arcilla
roca firme
Valor de µ
0.5
0.35
0.6
0.5
0.50
3.43
4.63
2.5
2.5
2.5
3.0
39.
5.0
59.
47.
3.85
3.95
5.16
1.13
H c.a.
prof. c.a.
b c.a.
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 3/20
Diámetros Peso Kg/m Rotura Ton.
mm3.2 1/8 0.04 0.69
4.8 3/16 0.1 1.43
6.4 1/4 0.17 2.67
8 5/16 0.27 4.16
9.5 3/8 0.39 5.95
11.5 7/16 0.52 8.07
13 1/2 0.68 10.414.5 9/16 0.88 13.2
16 5/8 1.07 16.2
19 3/4 1.55 23.2
22 7/8 2.11 31.4
26 1 2.75 40.7
29 1-1/8 3.48 51.3
32 1-1/4 4.3 63
35 1-3/8 5.21 75.7
38 1-1/2 6.19 89.7
42 1-5/8 7.26 104
45 1-3/4 8.44 121
48 1-7/8 9.67 138
52 2 11 156
54 2-1/8 12.4 174
57 2-1/4 13.9 195
60 2-3/8 15.5 217
64 2-1/2 17.3 238
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 4/20
H1 4.00 2.50
H2 4.00 1.50 -0.728
a= 146.60 580.80 2.9
X X Y Y
-18.2 -18.2 3.13 0.79 -18.2,3.13 -18.2,0.79
-17.5 -17.5 3.04 0.76 -17.47,3.04 -17.47,0.76
-16.7 -16.7 2.96 0.74 -16.74,2.96 -16.74,0.74
-16.0 -16.0 2.88 0.72 -16.02,2.88 -16.02,0.72
-15.3 -15.3 2.80 0.70 -15.29,2.8 -15.29,0.7
-14.6 -14.6 2.72 0.68 -14.56,2.72 -14.56,0.68
-13.8 -13.8 2.65 0.66 -13.83,2.65 -13.83,0.66
-13.1 -13.1 2.59 0.65 -13.1,2.59 -13.1,0.65
-12.4 -12.4 2.52 0.63 -12.38,2.52 -12.38,0.63
-11.6 -11.7 2.46 0.62 -11.65,2.46 -11.65,0.62
-10.9 -10.9 2.41 0.60 -10.92,2.41 -10.92,0.6
-10.2 -10.2 2.35 0.59 -10.19,2.35 -10.19,0.59
-9.5 -9.5 2.31 0.58 -9.46,2.31 -9.46,0.58
-8.7 -8.7 2.26 0.57 -8.74,2.26 -8.74,0.57-8.0 -8.0 2.22 0.56 -8.01,2.22 -8.01,0.56
-7.3 -7.3 2.18 0.55 -7.28,2.18 -7.28,0.55
-6.6 -6.6 2.15 0.54 -6.55,2.15 -6.55,0.54
-5.8 -5.8 2.12 0.53 -5.82,2.12 -5.82,0.53
-5.1 -5.1 2.09 0.52 -5.1,2.09 -5.1,0.52
-4.4 -4.4 2.07 0.52 -4.37,2.07 -4.37,0.52
-3.6 -3.6 2.05 0.51 -3.64,2.05 -3.64,0.51
-2.9 -2.9 2.03 0.51 -2.91,2.03 -2.91,0.51
-2.2 -2.2 2.02 0.50 -2.18,2.02 -2.18,0.5
-1.5 -1.5 2.01 0.50 -1.46,2.01 -1.46,0.5
-0.7 -0.7 2.00 0.50 -0.73,2 -0.73,0.5
0.0 0.0 2.00 0.50 0,2 0,0.52.9 2.9 2.03 0.51 2.87,2.03 2.87,0.51
5.7 5.7 2.11 0.53 5.74,2.11 5.74,0.53
8.6 8.6 2.25 0.56 8.62,2.25 8.62,0.56
11.5 11.5 2.45 0.61 11.49,2.45 11.49,0.61
14.4 14.4 2.70 0.68 14.36,2.7 14.36,0.68
17.2 17.2 3.01 0.76 17.23,3.01 17.23,0.76
20.1 20.1 3.38 0.85 20.1,3.38 20.1,0.85
23.0 23.0 3.80 0.95 22.98,3.8 22.98,0.95
25.8 25.9 4.28 1.08 25.85,4.28 25.85,1.08
28.7 28.7 4.82 1.21 28.72,4.82 28.72,1.21
31.6 31.6 5.42 1.36 31.59,5.42 31.59,1.36
34.5 34.5 6.07 1.52 34.46,6.07 34.46,1.5237.3 37.3 6.78 1.70 37.34,6.78 37.34,1.7
40.2 40.2 7.55 1.89 40.21,7.55 40.21,1.89
43.1 43.1 8.38 2.10 43.08,8.38 43.08,2.1
46.0 46.0 9.26 2.32 45.95,9.26 45.95,2.32
48.8 48.8 10.21 2.55 48.82,10.21 48.82,2.55
51.7 51.7 11.21 2.80 51.7,11.21 51.7,2.8
54.6 54.6 12.27 3.07 54.57,12.27 54.57,3.07
57.4 57.4 13.40 3.34 57.44,13.4 57.44,3.34
60.3 60.3 14.58 3.63 60.31,14.58 60.31,3.63
63.2 63.2 15.83 3.94 63.18,15.83 63.18,3.94
66.1 66.1 17.14 4.26 66.06,17.14 66.06,4.26
68.9 68.9 18.50 4.59 68.93,18.5 68.93,4.5971.8 71.8 19.94 4.94 71.8,19.94 71.8,4.94
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 5/20
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 6/20
DIBUJAR EN AUTOCAD
1.00
X X Y Y
-18.2 -18.2 3.13 0.79 -18.2,3.13 -18.2,0.79 -18.2,0
-17.2 -17.2 3.01 0.75 -17.2,3.01 -17.2,0.75 -17.2,0
-16.2 -16.2 2.90 0.73 -16.2,2.9 -16.2,0.73 -16.2,0
-15.2 -15.2 2.79 0.70 -15.2,2.79 -15.2,0.7 -15.2,0
-14.2 -14.2 2.69 0.67 -14.2,2.69 -14.2,0.67 -14.2,0
-13.2 -13.2 2.59 0.65 -13.2,2.59 -13.2,0.65 -13.2,0
-12.2 -12.2 2.51 0.63 -12.2,2.51 -12.2,0.63 -12.2,0
-11.2 -11.2 2.43 0.61 -11.2,2.43 -11.2,0.61 -11.2,0
-10.2 -10.2 2.35 0.59 -10.2,2.35 -10.2,0.59 -10.2,0
-9.2 -9.2 2.29 0.57 -9.2,2.29 -9.2,0.57 -9.2,0
-8.2 -8.2 2.23 0.56 -8.2,2.23 -8.2,0.56 -8.2,0
-7.2 -7.2 2.18 0.54 -7.2,2.18 -7.2,0.54 -7.2,0
-6.2 -6.2 2.13 0.53 -6.2,2.13 -6.2,0.53 -6.2,0
-5.2 -5.2 2.09 0.52 -5.2,2.09 -5.2,0.52 -5.2,0-4.2 -4.2 2.06 0.52 -4.2,2.06 -4.2,0.52 -4.2,0
-3.2 -3.2 2.03 0.51 -3.2,2.03 -3.2,0.51 -3.2,0
-2.2 -2.2 2.02 0.50 -2.2,2.02 -2.2,0.5 -2.2,0
-1.2 -1.2 2.00 0.50 -1.2,2 -1.2,0.5 -1.2,0
-0.2 -0.2 2.00 0.50 -0.2,2 -0.2,0.5 -0.2,0
0.8 0.8 2.00 0.50 0.8,2 0.8,0.5 0.8,0
1.8 1.8 2.01 0.50 1.8,2.01 1.8,0.5 1.8,0
2.8 2.8 2.03 0.51 2.8,2.03 2.8,0.51 2.8,0
3.8 3.8 2.05 0.51 3.8,2.05 3.8,0.51 3.8,0
4.8 4.8 2.08 0.52 4.8,2.08 4.8,0.52 4.8,0
5.8 5.8 2.11 0.53 5.8,2.11 5.8,0.53 5.8,0
6.8 6.8 2.16 0.54 6.8,2.16 6.8,0.54 6.8,07.8 7.8 2.21 0.55 7.8,2.21 7.8,0.55 7.8,0
8.8 8.8 2.26 0.57 8.8,2.26 8.8,0.57 8.8,0
9.8 9.8 2.33 0.58 9.8,2.33 9.8,0.58 9.8,0
10.8 10.8 2.40 0.60 10.8,2.4 10.8,0.6 10.8,0
11.8 11.8 2.48 0.62 11.8,2.48 11.8,0.62 11.8,0
12.8 12.8 2.56 0.64 12.8,2.56 12.8,0.64 12.8,0
13.8 13.8 2.65 0.66 13.8,2.65 13.8,0.66 13.8,0
14.8 14.8 2.75 0.69 14.8,2.75 14.8,0.69 14.8,0
15.8 15.8 2.85 0.71 15.8,2.85 15.8,0.71 15.8,0
16.8 16.8 2.96 0.74 16.8,2.96 16.8,0.74 16.8,0
17.8 17.8 3.08 0.77 17.8,3.08 17.8,0.77 17.8,0
18.8 18.8 3.21 0.80 18.8,3.21 18.8,0.8 18.8,019.8 19.8 3.34 0.84 19.8,3.34 19.8,0.84 19.8,0
20.8 20.8 3.48 0.87 20.8,3.48 20.8,0.87 20.8,0
21.8 21.8 3.62 0.91 21.8,3.62 21.8,0.91 21.8,0
22.8 22.8 3.78 0.95 22.8,3.78 22.8,0.95 22.8,0
23.8 23.8 3.94 0.99 23.8,3.94 23.8,0.99 23.8,0
24.8 24.8 4.10 1.03 24.8,4.1 24.8,1.03 24.8,0
25.8 25.8 4.28 1.07 25.8,4.28 25.8,1.07 25.8,0
26.8 26.8 4.46 1.12 26.8,4.46 26.8,1.12 26.8,0
27.8 27.8 4.64 1.17 27.8,4.64 27.8,1.17 27.8,0
28.8 28.8 4.84 1.21 28.8,4.84 28.8,1.21 28.8,0
29.8 29.8 5.04 1.26 29.8,5.04 29.8,1.26 29.8,0
30.8 30.8 5.25 1.32 30.8,5.25 30.8,1.32 30.8,031.8 31.8 5.46 1.37 31.8,5.46 31.8,1.37 31.8,0
32.8 32.8 5.68 1.43 32.8,5.68 32.8,1.43 32.8,0
33.8 33.8 5.91 1.48 33.8,5.91 33.8,1.48 33.8,0
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 7/20
34.8 34.8 6.15 1.54 34.8,6.15 34.8,1.54 34.8,0
35.8 35.8 6.39 1.60 35.8,6.39 35.8,1.6 35.8,0
36.8 36.8 6.64 1.67 36.8,6.64 36.8,1.67 36.8,0
37.8 37.8 6.90 1.73 37.8,6.9 37.8,1.73 37.8,0
38.8 38.8 7.16 1.80 38.8,7.16 38.8,1.8 38.8,0
39.8 39.8 7.44 1.86 39.8,7.44 39.8,1.86 39.8,0
40.8 40.8 7.71 1.93 40.8,7.71 40.8,1.93 40.8,0
41.8 41.8 8.00 2.00 41.8,8 41.8,2 41.8,0
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 8/20
PEGAR EN AUTOCAD desde 1 1.5 2 2.5 3 3.5 4 4.5
hasta 1.5 2 2.5 3 3.5 4 4.5 5
1.0 2.0 3.0 4.0 5.0 6.0 7.0 8.0
X Y1 Y2
0.00 3.13 0.79
1 1.00 3.01 0.75 0 0 0 0 1 0 0 0
2 2.00 2.90 0.73 0 0 0 1 0 0 0 0
3 3.00 2.79 0.70 0 0 0 1 0 0 0 0
4 4.00 2.69 0.67 0 0 0 1 0 0 0 0
5 5.00 2.59 0.65 0 0 0 1 0 0 0 0
6 6.00 2.51 0.63 0 0 0 1 0 0 0 0
7 7.00 2.43 0.61 0 0 1 0 0 0 0 0
8 8.00 2.35 0.59 0 0 1 0 0 0 0 0
9 9.00 2.29 0.57 0 0 1 0 0 0 0 0
10 10.00 2.23 0.56 0 0 1 0 0 0 0 0
11 11.00 2.18 0.54 0 0 1 0 0 0 0 0
12 12.00 2.13 0.53 0 0 1 0 0 0 0 0
13 13.00 2.09 0.52 0 0 1 0 0 0 0 014 14.00 2.06 0.52 0 0 1 0 0 0 0 0
15 15.00 2.03 0.51 0 0 1 0 0 0 0 0
16 16.00 2.02 0.50 0 0 1 0 0 0 0 0
17 17.00 2.00 0.50 0 1 0 0 0 0 0 0
18 18.00 2.00 0.50 0 1 0 0 0 0 0 0
19 19.00 2.00 0.50 0 1 0 0 0 0 0 0
20 20.00 2.01 0.50 0 0 1 0 0 0 0 0
21 21.00 2.03 0.51 0 0 1 0 0 0 0 0
22 22.00 2.05 0.51 0 0 1 0 0 0 0 0
23 23.00 2.08 0.52 0 0 1 0 0 0 0 0
24 24.00 2.11 0.53 0 0 1 0 0 0 0 0
25 25.00 2.16 0.54 0 0 1 0 0 0 0 026 26.00 2.21 0.55 0 0 1 0 0 0 0 0
27 27.00 2.26 0.57 0 0 1 0 0 0 0 0
28 28.00 2.33 0.58 0 0 1 0 0 0 0 0
29 29.00 2.40 0.60 0 0 1 0 0 0 0 0
30 30.00 2.48 0.62 0 0 1 0 0 0 0 0
31 31.00 2.56 0.64 0 0 0 1 0 0 0 0
32 32.00 2.65 0.66 0 0 0 1 0 0 0 0
33 33.00 2.75 0.69 0 0 0 1 0 0 0 0
34 34.00 2.85 0.71 0 0 0 1 0 0 0 0
35 35.00 2.96 0.74 0 0 0 1 0 0 0 0
36 36.00 3.08 0.77 0 0 0 0 1 0 0 0
37 37.00 3.21 0.80 0 0 0 0 1 0 0 038 38.00 3.34 0.84 0 0 0 0 1 0 0 0
39 39.00 3.48 0.87 0 0 0 0 1 0 0 0
40 40.00 3.62 0.91 0 0 0 0 0 1 0 0
41 41.00 3.78 0.95 0 0 0 0 0 1 0 0
42 42.00 3.94 0.99 0 0 0 0 0 1 0 0
43 43.00 4.10 1.03 0 0 0 0 0 0 1 0
44 44.00 4.28 1.07 0 0 0 0 0 0 1 0
45 45.00 4.46 1.12 0 0 0 0 0 0 1 0
46 46.00 4.64 1.17 0 0 0 0 0 0 0 1
47 47.00 4.84 1.21 0 0 0 0 0 0 0 1
48 48.00 5.04 1.26 0 0 0 0 0 0 0 0
49 49.00
5.25 1.32 0 0 0 0 0 0 0 050 50.00 5.46 1.37 0 0 0 0 0 0 0 0
51 51.00 5.68 1.43 0 0 0 0 0 0 0 0
52 52.00 5.91 1.48 0 0 0 0 0 0 0 0
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 9/20
53 53.00 6.15 1.54 0 0 0 0 0 0 0 0
54 54.00 6.39 1.60 0 0 0 0 0 0 0 0
55 55.00 6.64 1.67 0 0 0 0 0 0 0 0
56 56.00 6.90 1.73 0 0 0 0 0 0 0 0
57 57.00 7.16 1.80 0 0 0 0 0 0 0 0
58 58.00 7.44 1.86 0 0 0 0 0 0 0 0
59 59.00 7.71 1.93 0 0 0 0 0 0 0 0
60.00 8.00 2.00
59 0 3 21 10 5 3 3 2
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 10/20
5 5.5 6 6.5 7 7.5 8 8.5
5.5 6 6.5 7 7.5 8 8.5 9
9.0 10.0 11.0 12.0 13.0 14.0 15.0 16.0
Y1 3.13 3.01 2.90
Y2 0.79 0.75 0.73
0 0 0 0 0 0 0 0 X 0.00 1.00 2.00
0 0 0 0 0 0 0 0 -18.2 -17.2 -16.2
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 00 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 00 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 00 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
1 0 0 0 0 0 0 0
1 0 0 0 0 0 0 01 0 0 0 0 0 0 0
0 1 0 0 0 0 0 0
0 1 0 0 0 0 0 0
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 11/20
0 0 1 0 0 0 0 0
0 0 1 0 0 0 0 0
0 0 0 1 0 0 0 0
0 0 0 1 0 0 0 0
0 0 0 0 1 0 0 0
0 0 0 0 1 0 0 0
0 0 0 0 0 1 0 0
3 2 2 2 2 1 0 0
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 12/20
2.79 2.69 2.59 2.51 2.43 2.35 2.29 2.23 2.18 2.13 2.09 2.06 2.03
0.70 0.67 0.65 0.63 0.61 0.59 0.57 0.56 0.54 0.53 0.52 0.52 0.51
3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00
-15.2 -14.2 -13.2 -12.2 -11.2 -10.2 -9.2 -8.2 -7.2 -6.2 -5.2 -4.2 -3.2
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 13/20
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 14/20
2.02 2.00 2.00 2.00 2.01 2.03 2.05 2.08 2.11 2.16 2.21 2.26 2.33
0.50 0.50 0.50 0.50 0.50 0.51 0.51 0.52 0.53 0.54 0.55 0.57 0.58
16.00 17.00 18.00 19.00 20.00 21.00 22.00 23.00 24.00 25.00 26.00 27.00 28.00
-2.2 -1.2 -0.2 0.8 1.8 2.8 3.8 4.8 5.8 6.8 7.8 8.8 9.8
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 15/20
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 16/20
2.40 2.48 2.56 2.65 2.75 2.85 2.96 3.08 3.21 3.34 3.48 3.62 3.78
0.60 0.62 0.64 0.66 0.69 0.71 0.74 0.77 0.80 0.84 0.87 0.91 0.95
29.00 30.00 31.00 32.00 33.00 34.00 35.00 36.00 37.00 38.00 39.00 40.00 41.00
10.8 11.8 12.8 13.8 14.8 15.8 16.8 17.8 18.8 19.8 20.8 21.8 22.8
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 17/20
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 18/20
3.94 4.10 4.28 4.46 4.64 4.84 5.04 5.25 5.46 5.68 5.91 6.15 6.39
0.99 1.03 1.07 1.12 1.17 1.21 1.26 1.32 1.37 1.43 1.48 1.54 1.60
42.00 43.00 44.00 45.00 46.00 47.00 48.00 49.00 50.00 51.00 52.00 53.00 54.00
23.8 24.8 25.8 26.8 27.8 28.8 29.8 30.8 31.8 32.8 33.8 34.8 35.8
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 19/20
7/21/2019 Hoja de Calculo - San Lorenzo v2
http://slidepdf.com/reader/full/hoja-de-calculo-san-lorenzo-v2 20/20
6.64 6.90 7.16 7.44 7.71 8.00
1.67 1.73 1.80 1.86 1.93 2.00
55.00 56.00 57.00 58.00 59.00 60.00
36.8 37.8 38.8 39.8 40.8 41.8