Excel Avanzado

Función Indirecto
Complete las celdas C10, F10, I10

Empresa Backus

Cotización Promedio

Tabla 1: cotizaciones bursátiles al cierre de la sesión diaria

Fecha Bco_Crédito Telefónica

Wednesday, April 01, 2015 21.44 26.58

Thursday, April 02, 2015 41.97 29.64
Friday, April 03, 2015 39.59 43.47
Saturday, April 04, 2015 30.69 34.73
Sunday, April 05, 2015 41.59 38.39
Monday, April 06, 2015 20.94 42.15
Tuesday, April 07, 2015 34.18 32.12
Wednesday, April 08, 2015 26.92 34.72
Thursday, April 09, 2015 34.09 20.04
Friday, April 10, 2015 28.51 38.96
Saturday, April 11, 2015 38.85 44.8
Sunday, April 12, 2015 32.54 37.77
Monday, April 13, 2015 28.86 21.58
Tuesday, April 14, 2015 28.44 36.66
Wednesday, April 15, 2015 27.12 36.07
Thursday, April 16, 2015 27.32 29.77
Friday, April 17, 2015 24.28 42.36
Saturday, April 18, 2015 42.53 33.51
 Sunday, April 19, 2015 26.92 41.36
Monday, April 20, 2015 35.88 21.51
Tuesday, April 21, 2015 30.56 41.86
Wednesday, April 22, 2015 24.22 35.8
Thursday, April 23, 2015 37.03 34.62
Friday, April 24, 2015 41 23.87
Saturday, April 25, 2015 40.32 27.27
Sunday, April 26, 2015 29.65 35.11
Monday, April 27, 2015 21.93 36.66
Tuesday, April 28, 2015 41.49 24.56
Wednesday, April 29, 2015 32.56 34.72
Thursday, April 30, 2015 24.62 29.22
Friday, May 01, 2015 20.79 44.76
Saturday, May 02, 2015 42.23 30.47
Sunday, May 03, 2015 34.61 28.11
Monday, May 04, 2015 41.51 29.22
Tuesday, May 05, 2015 35.55 38.53
Wednesday, May 06, 2015 21.87 41.93
Thursday, May 07, 2015 37.67 44.62
Friday, May 08, 2015 38.55 24.09
Saturday, May 09, 2015 25.37 40.99
Sunday, May 10, 2015 35.32 21.03
Monday, May 11, 2015 26.8 43
Tuesday, May 12, 2015 32.95 20.96
Wednesday, May 13, 2015 25.07 34.7
Thursday, May 14, 2015 22.78 27.02
Friday, May 15, 2015 32.64 23.82
Saturday, May 16, 2015 35.47 21.99
Sunday, May 17, 2015 36.54 24.75
Monday, May 18, 2015 26.97 42.81
Tuesday, May 19, 2015 21.93 35.79
Wednesday, May 20, 2015 34.47 38.03
Thursday, May 21, 2015 35.72 27.87
Friday, May 22, 2015 22.91 35.68
Saturday, May 23, 2015 21.25 28.28
Sunday, May 24, 2015 38.4 27.21
Monday, May 25, 2015 44.32 30.47
Tuesday, May 26, 2015 35.41 43.7
Wednesday, May 27, 2015 42.64 27.6
Thursday, May 28, 2015 43.42 27.98
Friday, May 29, 2015 43.24 23.8
Saturday, May 30, 2015 25.21 25.46
 Sunday, May 31, 2015 35.26 41.93
Monday, June 01, 2015 40.04 43.95
Tuesday, June 02, 2015 35.11 31.8
Wednesday, June 03, 2015 26.97 36.14
Thursday, June 04, 2015 28.06 28.2
Friday, June 05, 2015 27.79 37.65
Saturday, June 06, 2015 24.99 23.07
Sunday, June 07, 2015 33 42.77
Monday, June 08, 2015 35.58 31.57
Tuesday, June 09, 2015 39.45 26.35
Wednesday, June 10, 2015 33.55 37.66
Thursday, June 11, 2015 41.67 30.17
Friday, June 12, 2015 43.53 31.21
Saturday, June 13, 2015 39.31 39.52
Sunday, June 14, 2015 25.65 43.24
Monday, June 15, 2015 37.32 28.28
Tuesday, June 16, 2015 20.05 37.55
Wednesday, June 17, 2015 20.28 26.95
Thursday, June 18, 2015 35.77 32.21
Friday, June 19, 2015 27.6 32.72
Saturday, June 20, 2015 39.12 38.77
Sunday, June 21, 2015 28.7 23.38
Monday, June 22, 2015 21.6 23.77
Tuesday, June 23, 2015 32.46 36.62
Wednesday, June 24, 2015 33.02 33.73
Thursday, June 25, 2015 26.67 20.62
Friday, June 26, 2015 22.68 36.08
Saturday, June 27, 2015 31.1 23.34
Sunday, June 28, 2015 29.28 39.84
Monday, June 29, 2015 35.78 35.09
Tuesday, June 30, 2015 29.98 43.7
Wednesday, July 01, 2015 36.45 43.15
Thursday, July 02, 2015 39.78 24.25
Friday, July 03, 2015 41.02 35.55
Saturday, July 04, 2015 28.44 32.35
Sunday, July 05, 2015 22 36.55
Monday, July 06, 2015 22.16 34.29
Tuesday, July 07, 2015 23.57 37.94
Wednesday, July 08, 2015 38.29 38.46
Thursday, July 09, 2015 39.35 43.08
Friday, July 10, 2015 25.71 26
Saturday, July 11, 2015 29.59 36.08
 Sunday, July 12, 2015 21.07 24.46
Monday, July 13, 2015 26.09 40.17
Tuesday, July 14, 2015 26.64 20.05
Wednesday, July 15, 2015 39.4 41.74
Thursday, July 16, 2015 21.49 44.65
Friday, July 17, 2015 36.76 33.01
Saturday, July 18, 2015 25.05 44.86
Sunday, July 19, 2015 43.92 23.55
Monday, July 20, 2015 26.96 37.23
Tuesday, July 21, 2015 40.71 41.36
Wednesday, July 22, 2015 29.81 31.8
Thursday, July 23, 2015 24.99 20.74
Friday, July 24, 2015 31.75 37.99
Saturday, July 25, 2015 43.23 21.64
Sunday, July 26, 2015 43.17 30.17
Monday, July 27, 2015 34.32 43.33
Tuesday, July 28, 2015 38.81 33.18
Wednesday, July 29, 2015 33.07 41.37
Thursday, July 30, 2015 42.94 44.97
Friday, July 31, 2015 34.96 30.63
Saturday, August 01, 2015 21.62 44.83
Sunday, August 02, 2015 34.73 41.67
Monday, August 03, 2015 35.31 39.6
Tuesday, August 04, 2015 23 37.75
Wednesday, August 05, 2015 20.44 41.58
Thursday, August 06, 2015 25.27 43.47
Friday, August 07, 2015 20.79 43.64
Saturday, August 08, 2015 22.98 30.71
Sunday, August 09, 2015 42.95 24.82
Monday, August 10, 2015 44.21 23.44
Tuesday, August 11, 2015 27.58 23.38
Wednesday, August 12, 2015 29.22 41.05
Thursday, August 13, 2015 23.02 37.23
Friday, August 14, 2015 31.84 38.42
Saturday, August 15, 2015 40.25 37.14
Sunday, August 16, 2015 37.37 29.06
Monday, August 17, 2015 44.82 22.77
Tuesday, August 18, 2015 42.65 42.93
Wednesday, August 19, 2015 34.51 24.93
Thursday, August 20, 2015 25.21 32.07
Friday, August 21, 2015 25.14 37.14
Saturday, August 22, 2015 31.12 37.1
 Sunday, August 23, 2015 40.03 37.67
Monday, August 24, 2015 26.09 30.07
Tuesday, August 25, 2015 34.01 29.17
Wednesday, August 26, 2015 44.73 30.12
Thursday, August 27, 2015 36.45 25.38
Friday, August 28, 2015 34.97 25.75
Saturday, August 29, 2015 32.49 20.57
Sunday, August 30, 2015 23.5 38.1
Monday, August 31, 2015 30.83 38.97
Tuesday, September 01, 2015 23.43 30.65
Wednesday, September 02, 2015 35.76 35.63
Thursday, September 03, 2015 28.05 29.42
Friday, September 04, 2015 22.47 29.55
Saturday, September 05, 2015 40.52 30.47
Sunday, September 06, 2015 42.81 21.83
Monday, September 07, 2015 28.94 43.31
Tuesday, September 08, 2015 29.33 42.87
Wednesday, September 09, 2015 39.34 27.13
Thursday, September 10, 2015 30.44 21.43
Friday, September 11, 2015 43.65 35.11
Saturday, September 12, 2015 40.37 41.47
Sunday, September 13, 2015 36.98 44.8
Monday, September 14, 2015 26.73 40.38
Tuesday, September 15, 2015 38.03 33.94
Wednesday, September 16, 2015 40.12 40.17
Thursday, September 17, 2015 38.46 22.22
Friday, September 18, 2015 21.59 35.48
Saturday, September 19, 2015 32.18 21.27
Sunday, September 20, 2015 33.21 39.98
Monday, September 21, 2015 29.23 38.13
Tuesday, September 22, 2015 25.09 22.53
Wednesday, September 23, 2015 22.23 31.23
Thursday, September 24, 2015 40.71 36.91
Friday, September 25, 2015 37.3 23.39
Saturday, September 26, 2015 26.35 44.47
Sunday, September 27, 2015 21.55 42.63
Monday, September 28, 2015 33.01 40.58
Tuesday, September 29, 2015 42.68 21.96
Wednesday, September 30, 2015 44.87 34.39
Thursday, October 01, 2015 26.82 31.39
Friday, October 02, 2015 24.75 21.09
Saturday, October 03, 2015 43.19 34.05
 Sunday, October 04, 2015 21.65 38.12
Monday, October 05, 2015 36.56 24.35
Tuesday, October 06, 2015 33.5 35.85
Wednesday, October 07, 2015 24.54 40.07
Thursday, October 08, 2015 21.05 26.82
Friday, October 09, 2015 38.41 31.33
Saturday, October 10, 2015 23.81 36.58
Sunday, October 11, 2015 33.65 28.05
Monday, October 12, 2015 24.64 40.18
Tuesday, October 13, 2015 41.97 28.85
Wednesday, October 14, 2015 24.05 43.34
Thursday, October 15, 2015 39.35 41.86
Friday, October 16, 2015 23.8 33.81
Saturday, October 17, 2015 36.26 27.99
Sunday, October 18, 2015 29.68 43.66
Monday, October 19, 2015 23.51 21.64
Tuesday, October 20, 2015 21.09 32.41
Wednesday, October 21, 2015 29.06 22.05
Thursday, October 22, 2015 24.34 23.54
Friday, October 23, 2015 25.8 37.72
Saturday, October 24, 2015 38.59 38.18
Sunday, October 25, 2015 37.41 25.15
Monday, October 26, 2015 30.7 38.9
Tuesday, October 27, 2015 27.57 23.29
Wednesday, October 28, 2015 23.5 21.58
Thursday, October 29, 2015 31.96 28.34
Friday, October 30, 2015 37.8 23.44
Saturday, October 31, 2015 35.8 20.68
Sunday, November 01, 2015 27 30.76
Monday, November 02, 2015 31.04 25.11
Tuesday, November 03, 2015 28.15 27.68
Wednesday, November 04, 2015 34.08 25.95
Thursday, November 05, 2015 38.25 34.56
Friday, November 06, 2015 37.59 21.52
Saturday, November 07, 2015 31.78 36.19
Sunday, November 08, 2015 20.87 32.14
Monday, November 09, 2015 22.72 35.42
Tuesday, November 10, 2015 23.71 31.07
Wednesday, November 11, 2015 33.29 33.57
Thursday, November 12, 2015 24.41 40.87
Friday, November 13, 2015 38.03 37.36
Saturday, November 14, 2015 39.43 30.18
 Sunday, November 15, 2015 32.69 43.24
Monday, November 16, 2015 40.1 22.16
Tuesday, November 17, 2015 40.54 29.38
Wednesday, November 18, 2015 20.72 34.99
Thursday, November 19, 2015 42.94 31.67
Friday, November 20, 2015 30.33 26.16
Saturday, November 21, 2015 35.72 30.07
Sunday, November 22, 2015 29.03 32.67
Monday, November 23, 2015 22.23 32.46
Tuesday, November 24, 2015 29.45 28.41
Wednesday, November 25, 2015 20.74 25.8
Thursday, November 26, 2015 26.07 43
Friday, November 27, 2015 30.85 22.28
Saturday, November 28, 2015 44.7 31.85
Sunday, November 29, 2015 33.1 44.43
Monday, November 30, 2015 42.22 39.44
Tuesday, December 01, 2015 39.64 25.37
Wednesday, December 02, 2015 21.53 42.49
Thursday, December 03, 2015 34.08 25.15
Friday, December 04, 2015 42.98 42.29
Saturday, December 05, 2015 29.23 23.38
Sunday, December 06, 2015 31.16 31.24
Monday, December 07, 2015 44.93 38.21
Tuesday, December 08, 2015 32.02 41.36
Wednesday, December 09, 2015 21.51 36.91
Thursday, December 10, 2015 30.44 38.52
Friday, December 11, 2015 40.05 39.84
Saturday, December 12, 2015 20.3 31.7
Sunday, December 13, 2015 32.27 38.41
Monday, December 14, 2015 41.76 38.61
Tuesday, December 15, 2015 35.41 20.97
Wednesday, December 16, 2015 32.27 29.11
Thursday, December 17, 2015 42.31 33.49
Friday, December 18, 2015 42.37 20.97
Saturday, December 19, 2015 44.35 29.63
Sunday, December 20, 2015 25.57 32.62
Monday, December 21, 2015 34.08 33.23
Tuesday, December 22, 2015 44.08 37.21
Wednesday, December 23, 2015 23.22 41.44
Thursday, December 24, 2015 44.51 30.43
Friday, December 25, 2015 36.57 22.1
Saturday, December 26, 2015 27.2 41.79
 Sunday, December 27, 2015 34.13 26.36
Monday, December 28, 2015 29.02 29.68
Tuesday, December 29, 2015 44.84 20.88
Wednesday, December 30, 2015 32.74 20.17
Thursday, December 31, 2015 44.44 35.61
Friday, January 01, 2016 28.43 44.68
Saturday, January 02, 2016 38.73 40.44
Sunday, January 03, 2016 20.49 28.42
Monday, January 04, 2016 35.07 24.54
Tuesday, January 05, 2016 37.4 43.77
Wednesday, January 06, 2016 39.97 32.53
Thursday, January 07, 2016 29.06 39.91
Friday, January 08, 2016 35.53 33.68
Saturday, January 09, 2016 21.78 31.13
Sunday, January 10, 2016 25.77 31.77
Monday, January 11, 2016 35.43 30.43
Tuesday, January 12, 2016 37.41 33.83
Wednesday, January 13, 2016 44.65 25.99
Thursday, January 14, 2016 20.8 31.05
Friday, January 15, 2016 21.75 24.04
Saturday, January 16, 2016 32.31 37.67
Sunday, January 17, 2016 42.63 22.09
Monday, January 18, 2016 28.57 42.41
Tuesday, January 19, 2016 23.44 36.2
Wednesday, January 20, 2016 44.9 43.31
Thursday, January 21, 2016 34.61 36.01
Friday, January 22, 2016 34.08 33.64
Saturday, January 23, 2016 34.61 25.14
Sunday, January 24, 2016 38.49 22.5
Monday, January 25, 2016 29.69 42.73
Tuesday, January 26, 2016 22.15 24.35
Wednesday, January 27, 2016 43.98 37.69
Thursday, January 28, 2016 24.58 34.41
Friday, January 29, 2016 35.48 36.48
Saturday, January 30, 2016 27.07 40.07
Sunday, January 31, 2016 37.03 21.82
Monday, February 01, 2016 22.9 41.77
Tuesday, February 02, 2016 39.63 20.16
Wednesday, February 03, 2016 33.29 30.47
Thursday, February 04, 2016 29.37 24.29
Friday, February 05, 2016 35.51 30.95
Saturday, February 06, 2016 26.9 26.49
 Sunday, February 07, 2016 41.28 35.01
Monday, February 08, 2016 37.91 26.1
Tuesday, February 09, 2016 29.44 36.59
Wednesday, February 10, 2016 29.3 26.93
Thursday, February 11, 2016 25.43 23.47
Friday, February 12, 2016 41.16 22.77
Saturday, February 13, 2016 40.6 42.37
Sunday, February 14, 2016 33.99 27.11
Monday, February 15, 2016 43.45 27.99
Tuesday, February 16, 2016 43.16 20.33
Wednesday, February 17, 2016 32.23 21.85
Thursday, February 18, 2016 20.58 43.38
Friday, February 19, 2016 38.15 24.86
Saturday, February 20, 2016 22.58 28.45
Sunday, February 21, 2016 23.74 22.05
Monday, February 22, 2016 42.98 24.94
Tuesday, February 23, 2016 33.25 39.51
Wednesday, February 24, 2016 28.62 36.89
Thursday, February 25, 2016 21.76 34.36
Friday, February 26, 2016 42.78 32.57
Saturday, February 27, 2016 24.98 35.87
Sunday, February 28, 2016 44.78 34.74
Monday, February 29, 2016 31.79 32.63
Tuesday, March 01, 2016 25.65 43.41
Wednesday, March 02, 2016 29.13 21.35
Thursday, March 03, 2016 33.77 40.54
Friday, March 04, 2016 33.35 44.36
Saturday, March 05, 2016 21.57 38.04
Sunday, March 06, 2016 26.53 41.53
Monday, March 07, 2016 33.16 30.54
Tuesday, March 08, 2016 39.02 39.34
Wednesday, March 09, 2016 36.55 36.56
Thursday, March 10, 2016 40.67 25.11
Friday, March 11, 2016 26.84 28.09
Saturday, March 12, 2016 21.94 40.63
Sunday, March 13, 2016 21.27 23.84
Monday, March 14, 2016 20.31 40.56
Tuesday, March 15, 2016 32.9 21.83
Wednesday, March 16, 2016 30.06 41.71
Thursday, March 17, 2016 38.34 33.87
Friday, March 18, 2016 27.02 21.55
Saturday, March 19, 2016 21.32 27.17
 Sunday, March 20, 2016 21.43 43.99
Monday, March 21, 2016 29.44 41.06
Tuesday, March 22, 2016 38.81 35.36
Wednesday, March 23, 2016 25.9 25.65
Thursday, March 24, 2016 32.6 41.95
Friday, March 25, 2016 44.41 23.85
 Empresa Backus
Año 2015

Cotización
Promedio

Backus Cem_Lima Yanacocha Bco_Continental

28.94 37.42 26.03 23.54

33.13 43.25 41.59 24.32
25.69 24.97 29.2 32.54
44.26 34.1 37.11 43.37
39.32 25.13 36.87 34.38
21.63 30.17 42.05 37.29
31.92 41.53 31.67 30.28
34.07 35.53 37.84 32.18
43.57 33.94 23.32 24.32
41.5 31.33 25.14 37.24
23.86 24.48 31.14 33.28
41.44 44.47 37.34 40.61
32.65 26.29 24.02 37.89
39.59 26.49 42.52 30.99
26.82 37.26 44.39 26.47
39.79 35.98 38.64 28.96
26.64 20.92 36.2 34.16
42.4 36.13 37.1 24.75
30.16 44.47 27.04 29.52
31.64 35.15 33.64 33.31
21.53 35.39 43.24 26.75
42.93 28.51 43.75 30.61
33.55 32.78 20.64 34.21
41.2 28.09 31.36 32.53
41.44 35.54 23.5 37.68
44.39 37.79 36.93 40.94
38.2 39.63 39.26 35.3
20.38 34.18 43.65 23.47
27.91 26.35 27.78 43.27
33.09 33.12 36.54 26.04
36.03 30.76 43.76 25.21
24.03 38.69 41.31 21.18
32.8 40.21 30.8 28.96
31.39 29.73 40.23 34.79
41.97 29.24 22.86 44.38
40.37 36.34 27.36 37.58
29.52 26.21 41.38 37.58
21.81 31.73 40.81 37.75
24.59 22.58 38.34 41.61
28.74 27.99 27.46 33.94
38.41 21.66 23.03 37.22
37.45 23.94 26.99 29.23
44.01 30.94 31.97 39.01
24.72 25.37 39.84 30.48
35.42 40.75 30.23 43.5
26.17 44.91 30.24 42.49
27.18 43.41 43.65 41.69
31.2 27.95 29.18 25.13
20.64 28.54 21.79 25.08
44.41 24.57 22.88 29.23
25.89 28.62 21.79 22.14
31.51 37.34 21.16 40.54
31.44 31.16 36.54 41.42
21.58 20.15 40.44 22.54
26.37 38.05 28.66 37.27
39.06 25.07 39.5 32.24
24.93 39.4 41.59 20.77
28.14 32.37 41.11 25.38
24.2 38.22 28.3 20.49
43.33 41.94 38.24 44.45
25.73 24.37 21.75 36.88
34.84 26.1 43.67 23.86
22.25 21.18 44.73 24.9
23.71 26.22 33.04 29.95
39.46 24.52 30.44 44.77
29.71 40.23 24.84 36.41
22.05 43 36.5 33.57
33.38 29.72 26.9 29.35
27.11 24.39 26.46 26.83
22.65 25.95 26.12 36.33
35.32 24.59 26.99 24.02
37.2 25.4 36.15 30.02
42.04 32.67 41.17 25.2
28.44 42.36 37.41 43.43
38.78 44.73 31.67 35.2
41.86 25.26 40.51 22.11
26.6 27.43 29.67 35.97
31.01 38.25 36.97 30.79
34.47 43.96 35.72 31.74
23.98 31.35 21.02 31.98
41.38 38.08 21.15 41.15
40.89 37.6 31.25 44.09
29.14 41.3 30.04 25.13
37.51 33.2 34.96 44.33
41.25 31.35 29.6 42.69
35.71 32.74 36.88 35.1
41.99 43.79 32.84 42.31
37.8 21.74 32.61 44.33
31.4 33.82 27.62 33.58
42.62 37.61 33.56 44.37
32.72 34.59 41.95 29.51
43.76 25.89 24.77 39
21.29 34.29 44.29 25.16
36.32 25.89 33.22 20.94
30.35 30.04 40.29 30.51
41.05 36.1 22.85 21.54
38.98 36.91 27.84 35.51
30.31 34.22 41.03 38.11
38.67 32.92 40.67 25.38
28.06 34.2 43.17 36.92
35.58 21.57 43.67 44.93
25.23 41.46 43.93 31.38
 42.8 22.09 30.05 44.93
21.78 26.27 22.31 29.02
28.85 21.45 44.22 41.51
36.16 36.2 23.42 26.09
41.78 39.31 25.71 32.17
26.1 20.83 26.13 44.91
21.05 23.22 25.36 20.71
25.71 32.59 40.47 37.09
42.5 26.71 30.57 27.04
41.4 32.72 33.55 29.4
21.44 22.94 38.23 38.82
31.22 30.31 38.95 38.99
22.75 25.26 27.77 20.47
28.61 22.87 35.12 30.05
35.6 25.36 32.49 40.92
43.44 44.3 24.89 43.57
40.33 20.65 22.06 37.69
38.14 43.61 34.92 37.12
27.7 27.59 22.63 33.04
24.74 42.03 22.67 26.53
40.08 38.61 38.32 30.02
38.09 39.37 33.63 36.01
31.41 25.77 31.5 37.44
34.2 42.63 28.35 34.01
30.87 25.42 39.62 41.83
42.75 43.24 35.73 34.75
28.03 21.79 22.2 22.11
34.03 21.32 38.4 41.96
39.92 34.35 44.42 42.16
37.43 24.78 21.95 41.04
32.11 32.64 30.26 34.7
23.33 37.13 34.85 20.34
28.22 37.68 34.96 30.35
25.9 20.38 43.33 20.83
32.09 41.97 38.14 25.27
27.12 20.66 39.32 24.6
37.05 43.82 27.43 36.91
27.7 36.01 21.35 39.52
42.62 40.82 21.08 43.76
34.8 32.55 39.98 31.24
40.6 25.89 44.78 29.73
36.37 35.16 35.22 43.9
24.03 38.89 20.34 37.78
25.57 36.39 37.21 33.38
26.77 30.73 35.82 44.33
35.03 24.62 35.99 34.72
37.36 22.91 39.92 42.92
37.9 33.96 26.44 22.3
31.99 29.22 34.1 26.72
35.61 43.16 43.4 20.41
35.88 41.11 44.74 40.53
25.9 32.95 32.13 36.05
26.01 42.07 33.67 33.09
20.49 20.81 38.44 38.62
23.26 32.9 33.25 36.04
41.15 32.82 33.03 31.24
38.06 21.83 26.1 31.45
35.36 29.65 37.09 43.14
31.13 28.65 31.12 44.62
27.37 20.25 36.4 30.88
36.63 33.1 27.34 41.52
32.19 27.59 38.08 43.47
40.38 25.37 25.62 28.38
36.16 38.03 30.51 21.31
31.31 29.44 37.25 40.74
33.88 35.97 42.01 34.83
20.38 22.21 32.52 26.02
20.39 29.33 22.24 43.1
28.08 24.63 26.13 29.53
38.09 24.48 32.37 30.34
24.17 22.69 40.22 24.18
31.37 29.36 32.26 44.57
38.27 35.56 24.54 20.08
38.01 32.89 43.05 29.4
28.66 22.87 25.05 34.25
43.93 22.67 39.7 40.55
41.16 37.38 28.09 44.91
38.29 20.69 22.31 31.86
42.41 44.65 31.05 38.29
23.59 32.45 32.19 26.51
40.02 43.61 23.21 22.88
27.85 30.52 26.01 25.5
29.53 24.7 28.81 43.57
43.42 33.88 23.81 35.92
38.14 31.95 44.86 39.42
36.24 42.42 38.87 34.35
34.32 32.9 20.73 43.98
44.77 21.05 20.76 44.69
39.08 42.2 39.91 33.68
31.25 27.25 42.29 41.53
38.41 27.86 38.19 38.38
30.35 38.31 25.58 38.12
25.35 38.11 37.68 38.51
23.02 36.88 43.66 35.91
36.74 32.55 34.85 39.4
29.21 28.67 35.5 32.84
33.63 29.95 30.04 25.45
34.76 38.09 22.93 20.73
27.74 41.64 21.62 44.05
25.71 21.12 30.15 27.29
31.54 37.87 32.86 26.63
41.02 39.34 25.27 29.4
34.42 42.6 38.4 33.63
24.47 34.99 34.68 33.2
41.2 36.01 28.13 43.67
35.1 22.02 22.4 28.76
20.23 28.2 22.06 41.4
25.26 44.37 23.33 35.15
24.78 20.66 29.69 38.49
42.67 26.21 39.75 37.74
37.58 42.31 37.52 41.96
43.38 20.7 38.19 37.44
28.53 37.24 44.13 25.6
23.85 21.01 40.33 31.97
35.69 21.93 36.02 43.85
30.35 32.77 26.15 37.49
42.54 22.59 24.93 28.13
21.22 44.77 37.29 28.48
33.7 24.44 42.74 28.54
22.12 40.85 22.7 43.71
21.79 27.91 21.35 28.24
42.85 40.31 28.82 39.79
20.26 27.35 23.87 35.54
22.53 26.59 35.74 27.06
36.96 20.57 31.01 31.34
25.16 44.32 44.65 28.64
38.85 35.18 25.46 23.48
23.76 20.18 29.96 41.79
23.91 27.65 37.83 28.71
40.92 35.31 39.62 29
27.78 22.31 32.79 31.76
43.38 24.8 35.91 44.74
39.45 21.37 38.39 24.15
29.31 27.15 44.05 40.67
29.87 25.01 24.37 22.55
41.54 27.13 29.62 42.88
22.35 43.78 31.43 33.38
31.86 42.41 37.53 29.16
36.7 24.21 35.5 21.02
42.72 21.39 41.38 30.65
23.65 39.73 39.85 43.57
33.31 35.29 30.65 24.7
33.57 24.98 44.7 32.92
35.1 36.75 40.79 24.52
30.1 40.43 37.35 44.28
34.13 23.23 36.22 29.86
25.15 34.78 43.64 34.54
41.74 38.22 44.22 30.46
33.22 37.67 34.06 22.84
39.75 22.31 32.31 39.84
39 32.92 42.13 36.39
38.37 44.46 27.88 28.52
32.19 34.29 25.46 24.33
22.37 31.24 22.04 36.2
43.56 39.77 39.96 30.65
37.76 29.47 44.38 24.07
26.58 39.25 29.8 40.27
30.29 25.91 42.15 42.32
25.32 34.73 25.88 27.93
29.74 22.59 39.52 28.79
42.67 37.73 23.69 26.68
32.71 23.21 34.77 43.71
41.73 28.79 40.78 34.04
37.4 34.81 30.51 34.91
40.45 43.8 21.73 37.2
27.87 28 28.89 28.48
34.45 24.37 24.83 39.76
20.82 39.93 20.03 40.5
35.13 39.19 38.22 33.1
41.89 43.06 34.73 41.24
38.21 20.02 34.03 39.96
40.24 27.11 44.23 32.33
28.75 34.67 44.37 22.26
40.26 20.89 31.96 21.74
25.61 33.75 35.04 30.28
24.23 31.45 38.44 34.02
39.16 41.76 25.5 24.23
44.97 24.34 38.05 33.62
25.49 23.57 35.04 23.78
24.72 25.54 33.18 35.78
44.9 22.72 21.77 23.47
38.18 30.85 25.11 27.76
27.02 32.14 31.88 23.66
37.51 31.35 22.49 23.12
36.93 32.37 25.05 32.24
41.39 24.6 37.28 25.7
21.95 42.42 22.13 25.95
24.84 39.63 38.52 33.68
42.48 25.2 40.75 27.92
23.24 29.03 21.75 24.34
35.7 44.39 28.63 42.02
23.94 30.13 40.24 33.92
39.41 27.25 25.22 34.77
37.6 34.56 29.65 28.49
22.92 43.24 42.31 41.73
44.2 25.62 31.19 36.7
26.57 27.93 37.79 24.41
24.4 30.82 36.87 21.99
26.66 25.54 32.27 25.48
35.63 22.93 36.91 36.83
25.87 42.77 22.43 33.59
22.21 36.41 28.67 37.42
26.29 43.8 29 20.57
41.1 32.54 30.58 29.54
32.52 43.67 40.38 21.82
36.44 22.48 33.84 42.04
29.21 43.67 23.3 23.64
33.74 20.82 40.8 31.25
27.65 31.85 35.5 28.76
36.4 37.06 39.36 41.11
27.99 29.48 24.91 26.47
27.04 25.36 26.33 22.31
21.56 44.41 35.27 36.67
24.06 24.92 21.24 22.2
20.7 35.04 42.07 29.94
26.11 21.3 42.34 42.23
31.11 33.69 26.85 42.19
29.44 42.42 26.75 21.53
32.49 24.67 39.43 42.64
44.86 30.78 36.19 32.74
27.41 43.1 39.35 41.14
42.56 29.25 20.34 42.22
30.48 26.03 37.31 42.49
42.62 36.9 20.56 21.2
32.7 21.22 40.63 26.41
43.3 39.28 34.33 27.27
21.27 21.89 28.79 21.16
34.7 28.22 37.08 37.41
33.14 29.23 27.72 37.54
44.03 24.92 34.36 44.33
30.4 40.16 39.75 27.13
39.93 27.19 26.78 42.86
43.38 22.2 26.79 28.27
38.02 33.59 40.32 30.36
20.61 27.36 44.57 27.84
30.57 38.39 40.57 44.09
36.15 28.33 26.94 21.64
33.14 38.04 21.92 29.1
38.61 35.69 20.33 22.01
36.5 36.2 23.05 34.8
36.69 43.7 36.53 38.65
29.52 27.09 27.08 40.27
41.07 43.47 35.67 29.85
30.35 32.31 40.47 27.11
42.85 41.91 42.09 26.66
22.52 32.29 37.78 28.93
30.5 34.24 25.08 27.53
36.63 23.46 25.08 37.01
42.96 44.32 23.73 32.92
37.31 38.35 25.46 34.72
20.94 29.28 40.86 44.53
41.89 22.43 37.33 22.28
39.46 35.77 23.86 37.92
40.41 39.49 40.87 32.03
26.49 36.08 39.18 34.46
26.72 42.98 42.22 20.83
34.25 44.67 30.79 21.33
35.71 42.53 42.96 44.65
Aceros_areq Exsa Bayer Centromin Claro Nextel

39.94 32.29 25.67 28.18 34.9 23.61

23.16 35.33 43.38 30.45 26.49 40.65
23.51 28.91 20.77 25.88 31.61 36.15
33.45 25.69 21.89 29.8 31.53 39.52
21.65 22.2 43.97 37.72 24.45 40.6
27.02 32.86 22.14 39.51 33.29 33.25
39.48 21.2 41.66 44.51 34.7 23.45
24.38 32.81 36.16 27.06 28.59 28.83
42.57 36.3 29.81 39.27 30.74 41.39
41.19 41 43.84 20.97 24.03 33.55
31 36.37 25.04 24.09 33.48 25.11
36.02 27.81 39.34 42.07 41.94 31.08
43.7 31.15 23.81 23.34 31.53 23.24
23.77 44.62 32.28 32.44 37.5 43.16
24.45 31.97 29.96 38.88 24.01 31.08
39.23 31.07 43.44 38.78 35.9 34.14
21.13 44.77 33.4 26.35 28.25 24.46
29.52 20.12 27.55 33.39 34.39 26.45
30.25 40.95 20.28 38.63 35.87 26.73
30.88 28.17 28.56 30.46 26.18 32.41
38.1 42.52 30.98 24.78 24.45 44.17
38.06 35.44 38.5 20.66 23.43 22.23
44.06 30.24 20.65 26.76 44.16 25.79
23.16 32.26 42.01 27.55 43.22 21.01
36.02 30.14 41.19 44.99 32.86 43.83
32.68 26.15 26.35 31.45 21.23 30.41
21.48 30.98 37.89 38.18 43.53 36.58
21.19 31.8 31.27 33.16 28.6 30.41
24.61 33.28 42.1 20.34 41.03 30.02
39.2 29.51 39.79 24.98 38.41 37.86
35.86 28.13 34.52 21.27 40.81 30.53
21.3 23.84 26.3 33.41 38.79 42.49
36.68 33.73 22.15 35.56 23.26 29.38
33.09 32.94 20.57 33.19 38.97 40.77
38.74 37.31 25.45 25.64 22.32 27.86
39.43 29.78 28.97 27.72 32.19 20.7
23.05 30.28 44.57 44.15 44.37 28.69
27.99 40.74 26.9 24.92 23.85 34.14
32.23 28.53 29.76 29.29 40.02 35.37
33.41 32.33 27.76 42.24 34.79 25.63
24.7 28.17 20.2 20.25 38.38 22.19
40.67 20.94 26.11 31.23 26.27 27.95
33.6 36.05 36 20.04 22.73 35.97
23.77 20.65 26.75 27.1 27.6 30
21.48 40.74 35.45 29.06 24.28 24.36
25 34.39 33.35 37.35 42.61 31.11
44.12 23.91 36.77 34.64 41.5 20.53
31.76 37.9 29.53 36.92 20.78 37.25
29.01 37.06 38.33 23.96 38.02 42.04
26.04 32.95 32.82 37.72 40.91 29.67
21.7 22.4 30.23 36.87 26.93 44.1
40.51 40.69 44.83 22.94 35.74 26.46
26.18 33.79 44.05 21.36 38.2 21.51
25.91 39.24 39.85 20.52 24.7 25.77
23.51 22.77 26.05 29.16 28.6 43.74
30.52 41.76 35.89 42.23 24.96 31.07
31.43 38.33 35.08 39.77 24.66 21.28
33.04 36.33 23.44 24.59 37.04 26.98
38.54 36.51 28.11 43.37 36.88 21.68
33.15 37.09 41.29 30.59 38.05 41.74
35.93 32.67 36.75 34.27 27.29 28.23
36.37 28.77 44.73 28.08 34.98 27.8
37.45 41.5 26.46 35.02 33.57 22.9
30.8 26.69 31.8 26.76 34.08 40.09
38.76 31.53 41.9 37.84 22.34 30.19
21.28 23.9 34.81 44 29.05 43.06
44.27 20.89 27.76 30.79 33.9 21.04
25.08 38.09 30.86 27.44 41.54 37.82
40.62 20.48 34.19 43 30.18 25.89
26.98 32.91 43.15 30.17 20.69 32.96
30.84 44.27 20.02 31.15 25.77 43.94
40.7 33.41 29.06 21.66 39.19 39.89
33.68 26.2 32.41 39.87 30 39.23
35.05 41.13 40.25 42.24 23.56 20.72
33.4 38.12 26.92 24.45 25.89 38.71
33.62 21.63 24.73 31.38 29.96 25.06
20.06 24.72 23.41 43.68 31.09 35.17
28.51 21.52 42.54 35.39 20.29 31.33
28.63 40.68 39.49 37.55 21.64 37.06
39.21 32.85 32.73 43.74 28.77 38.5
25.91 42.19 25.35 28.55 21.18 33.49
37.75 21.82 24.38 36.79 36.33 32.58
35.47 29.87 27.13 40.39 43.45 20.7
42.89 42.21 34.19 38.18 38.84 24.35
22.32 28.8 28.64 40.9 27.31 29.94
28.07 26.17 37.12 43.89 25.68 40.77
28.17 29.78 44.83 34.78 25.03 39.4
33.54 33.4 43.79 30.86 38.28 41.95
20.12 29.5 30.63 38.64 32.71 40.12
35.18 21.46 43.07 36.92 37.01 26.27
34.52 38.16 30.78 35.56 39.01 25.02
26.22 25.39 44.71 24.01 44.17 35.18
44.68 36.54 25.05 20.99 36.83 43.21
29.59 26.35 30.02 32.49 23 41.56
28.33 26.49 38.73 22.13 30.08 43.18
24.95 30.66 42.06 26.12 42.49 20.32
21.66 35.98 37.11 37.17 40.71 40.91
33.64 20.74 22.26 20.51 21.25 37.61
23.15 42.63 28.53 39.44 41.68 29.26
44.62 24.5 44.43 44.64 35.44 21.73
28.94 30.17 43.85 42.58 34.81 42.69
29.29 28.2 34.05 21.23 27.47 32.8
36.37 41.48 36.64 31.22 43.64 35.24
21.64 37.05 32.65 38.07 42.63 32.54
30.96 25.09 35.31 25.23 20.58 31.7
41.35 38.11 35.62 22.41 33.57 27.05
39.62 25.7 39.01 38.22 42.21 39.2
23.46 31.18 34.82 30.22 41.54 35.94
37.4 25.03 20.01 34.46 33.17 22.9
35.58 36.23 24.61 29.37 39.57 21.19
36.73 26.79 31.99 27.67 36.49 22.59
24.6 34.48 33.46 31.57 27.93 40.21
37.4 43.17 32.43 43.5 22.88 25.37
35.06 44.28 31.89 32.81 32.39 31.04
26.98 35.48 26.12 20.44 39.32 40.96
44.07 29.48 29.44 42.68 26.92 42.37
26.75 37.61 23.54 43.95 24.92 23.43
41.57 41.52 27.08 22.16 34.98 34.5
43.68 20.92 32.02 27.28 20.42 40.95
37.91 28.29 34.06 44.72 25.77 43.83
32.29 41.13 35.46 23.2 40.52 27.56
37.53 33.39 36.38 26.38 28.73 26.17
32.41 20.35 38.13 39.98 37.29 44.21
36.56 29.82 23.72 20.6 43.01 32.32
24.95 40.15 26.27 21.98 36.35 22.71
29.8 39.09 20.25 21.89 40.93 39.06
28.51 23.23 28.51 23.76 32.34 39.04
26.8 39.23 41.35 34.45 38.46 34.01
30.06 30.46 40.85 39.95 21.19 28.08
23.83 30.5 32.12 30.03 35.77 21.51
24.36 33.08 36.76 31.68 24.91 25.37
29.12 26.84 40.11 21.52 32.52 39.8
23.48 39.25 38.06 21.35 35.27 36.42
26.79 29.73 21.09 41.62 29.7 27.61
42.23 21.23 37.55 43 27.1 23.02
44.8 20.33 41.66 44.68 24.95 25.41
27.4 22.76 39.49 38.18 25.06 20.04
31.38 25.69 23.58 34.25 29.47 30.1
41.27 42.43 29.2 40.18 43.97 36.75
25.61 32.46 29.85 24.98 25.14 30.65
39.37 35.55 42.74 30.34 21.68 35.18
31.83 42.23 28.79 37.54 25.9 20.19
43.6 33.4 40.51 31.5 20.57 42.36
34.99 23.37 29.33 40.66 26.95 33.34
36.17 29.76 22.78 38.1 42.63 23.17
35.54 42.04 43.82 43.41 25.74 35.03
39.6 24.84 44.14 27.88 26.22 25.07
37.56 23.91 38.06 36.39 36.36 24.75
22.14 37.95 39.81 35.15 42.65 40.76
36.01 29.65 40.09 31.46 25.61 34.24
31.57 21.21 41.39 24.42 25.29 32.29
26.38 37.24 32.61 21.8 43.54 42.41
24.95 37.67 40.73 24.79 38.28 31.4
21.97 40.67 24.66 22.72 26.81 33.1
24.17 36.05 35.12 34.76 37.03 30.11
33.78 25.2 22.67 40.97 22.77 44.16
24.25 40.38 20.16 26.12 25.39 37.37
23.7 39.13 22.49 35.54 36.04 36.33
41.29 37.77 27.83 34.15 43.08 35.49
21.04 32.3 30.48 43.83 24.64 37.04
20.28 24.5 31.86 38.01 37.16 41.17
23.24 42.2 35.8 31.55 27.6 23.57
20.69 42.17 29.56 33.13 33.77 33.3
36.22 29.52 44.41 30.33 31.52 44.69
41.21 24.39 27.53 33.95 25.13 29.32
28.07 39.06 36.92 37.33 30.83 26.6
35.79 35.34 32.09 21.23 38.15 27.4
43.31 26.32 40.88 35.49 28.07 39.18
44.6 25.15 30.54 37.11 23.55 43.8
37.15 36.44 30.12 21.56 20.47 31.32
43.36 37.45 30.54 33.44 29.49 44.03
21.93 30.54 44.32 30.15 30.21 24.29
23.89 24.27 41.53 22.41 34.91 44.61
32.08 21.52 27.23 21.17 37.86 42.92
33.98 41 39.23 23.95 31.93 30.46
43.72 21.36 23.03 38.41 40.95 28.58
20.31 42.27 25.96 28.96 39.31 40.76
25.33 22.19 33.62 39.49 44.57 37.08
29.45 36.57 32.97 34.13 21.34 40.81
22.77 36.56 34.13 28.58 34.96 34.31
20.18 22 34.3 29.11 37.37 36.99
38.24 41.18 38.14 20.16 36.08 29.8
35.68 44.28 32.07 31.57 20.25 33.67
21.07 44.99 26 35.8 29.3 35.39
32.53 43.2 42.97 44.27 42.7 41.96
40.36 40.9 32.14 25.72 39.21 22.32
32.56 41.86 22.85 38.52 24.28 41.1
36.61 41.75 28.08 25.39 39.52 42.19
42.35 41.52 24.25 35.32 31.51 29.58
20.11 38.69 30.18 43.13 36.96 43.06
30.76 32.27 42.44 26.04 38.49 30.7
40.54 33.39 31.52 20.14 28.42 40.08
24.23 32.27 28.86 44.36 25.68 26.07
32.52 26.28 33.59 41.54 30.08 21.65
26.88 23.42 36.38 23.78 21.6 26.03
43.71 33.64 21.41 26.18 38.46 20.74
36.02 31.12 25.6 21.98 39.81 28.98
22.88 42.77 20.27 31.2 36.87 23.64
25.58 43.43 29.97 26.38 43.36 38.19
43.68 40.81 31.68 29.55 44.76 35.34
42.83 20.08 23.8 35.68 22.47 41.75
35.88 31.29 42.89 25.45 24.57 42.85
29.71 25.66 21.01 25.67 28.2 29.42
29.36 32.85 37.08 38.64 31.04 23.47
40.83 22.83 43.96 27.79 43.94 24.45
22.59 32.07 31.96 22.71 31.98 39.88
25.98 39.23 42.68 30.86 26.14 27.95
29.83 37.83 23.29 39.69 42.19 32.78
42.61 32.03 36.35 31.05 21.29 23.46
28.01 39.1 32.18 30.98 21.73 22.07
38.45 40.89 35.65 37.94 41.53 32.01
42.24 30.94 37.09 32.36 44.06 27.67
38.74 44.07 30.28 22.47 34.87 41.23
34.27 39.24 27.41 21.33 30.84 23.46
43.96 40.8 22.31 21.52 29.68 43.56
26.38 20.19 38.5 21.91 23.61 22.64
30.93 21.59 23.99 24.36 29.24 21.51
27.22 42.79 34.8 37.47 41.56 33.7
32.48 20.47 26.68 42.15 42.47 29.99
24.85 27.32 43.62 36.03 44.96 44.13
25.08 40.06 43.03 28.89 39.34 39.78
33.68 23.14 26.93 21.81 23.6 36.2
31.83 25.32 29.85 38.22 30.39 41.69
25.24 42.57 34.19 36.47 40.47 31.21
29.16 30.9 36.25 35.83 40.31 44.87
39.73 43.13 20.81 37.3 44.94 22.86
34.53 36.71 36.91 24.98 21.06 44.72
26.56 20.88 43.75 27.16 24.65 35.76
25.88 42.23 33.81 35.24 43.27 24.99
33.29 20.43 30.12 22.14 28.48 23.96
36.84 30 31.56 32.74 33.78 31.38
42.04 22.4 35.75 23.84 25.9 37.74
37.27 41.33 42.46 20.84 35.42 27.74
31.74 44 25.3 37.43 31.88 33.16
40.89 23.49 38.06 41.34 23.4 40.77
38.27 34.44 38.67 33.16 20.04 31.67
34.12 34.1 40.09 42.22 34.66 21.96
22.72 39.07 28.68 35.48 34.81 24.44
36.37 32.87 37.3 42.56 25.59 37.89
23.01 36.62 28.05 44.37 42.45 24.53
42.91 27.25 32.61 33.12 38.41 30.62
33.07 31.65 29.69 28.41 40.86 31.01
20.75 27.28 36.84 34.69 22.29 38.79
36.52 21.2 41.24 31.33 42.96 20.15
42.69 42.41 33.78 38.74 28.6 34.08
31.25 24.09 42.49 34.63 42.57 42.1
37.85 26.05 30.67 31.39 23.66 23.57
21.57 41.51 32.81 41.33 25.89 43.25
38.26 40.96 32.25 31.55 28.75 40.96
27.73 31.89 40.63 37.25 25.95 33.54
42.84 25.2 37.33 36.05 38.83 31.21
43.62 44 29.82 35.56 26.6 44.51
31.33 22.12 32.68 38.47 29.76 33.01
20.01 34.21 41.96 39.9 27.41 29.32
23.24 21.89 30.24 43.53 27.03 39.21
31.16 20.61 38.7 41.33 29.61 39.98
34.09 23.08 35.8 29.59 26.7 29.44
21.04 28.8 32.11 29.08 22.04 22.05
24.93 41.47 39.42 25.06 39.91 31.32
28.04 22.3 20.85 35.62 23.84 35.62
24.23 29.01 35.5 26.1 20.96 37.83
43.95 34.32 41.02 39.24 32.89 40.71
24.76 23.04 28.64 34.16 34.96 38.56
40.43 27.36 42.08 39.43 29.59 36.92
35.68 24.14 30.37 21.78 29.02 42.92
21.71 38.97 40.39 32.41 36.32 38.36
37.72 26.71 36.65 43.33 27.13 21.32
30.92 34.12 20.91 36.82 31.18 42.12
30.96 40.68 29.02 22.14 25.73 34.83
32.58 36.4 44.14 21.28 32.59 38.24
 26.3 38.9 20.42 37.24 41.75 37.08
23.65 35.21 22.87 21.07 38.77 36.12
41.09 29.88 27.98 24.86 33.85 34.26
44.68 22.3 26.12 36.01 33.63 32.21
39.03 32.9 34.42 20.03 35.64 43.17
23.88 23.36 33.58 27.54 41.06 38.08
25.71 41.63 35.14 36.81 34.9 43.96
23.03 25.49 34.6 24.34 29.33 32.3
20.7 28.88 39.53 43.25 28.93 30.8
32.18 28.5 41.32 38.53 36.43 29.06
37.41 27.91 35.03 43.9 44.92 37.17
36.09 42.79 40.49 32.84 41.02 22.65
33.46 33.22 37.51 25.28 43.42 28.04
43.15 30.13 24.4 40.35 30.03 26.75
41.07 25.77 36.6 34.75 33.43 36.25
33 29.44 37.03 42.92 43.71 31.69
25.61 24.29 20.34 28.58 24.93 31.78
26.75 33.76 27.4 39.74 22.01 38.37
24.46 30.43 31.15 40.28 39.42 33.38
21.04 23.23 30.63 39.32 27.56 33.65
37.25 26.31 22.02 40.28 23.8 43.06
37.34 27.9 20.55 32.3 20.48 29.08
20.89 26.39 20.5 22.41 37.05 25.99
32.61 35.04 34.96 23.69 37.85 41.14
38.48 39 33.22 20.33 40 38.85
41.52 41.59 27.97 24.88 33.02 27.99
35.56 39.95 32.68 24.26 39.95 35.72
28.65 31.72 40.79 20.34 26.26 26.71
20.34 43.59 22.16 40.45 26.27 28.3
29.44 38.76 24.73 37.89 38.39 34.91
25.7 26.45 42.96 41.86 28.26 27.99
20.92 37.54 27.43 35.38 28.86 40.21
31 24.33 33.53 30.08 29.16 39.4
20.87 42.88 27.03 35.48 34.17 22.32
30.18 22.99 27.51 29.21 36.36 28.73
33.32 40.57 23.55 41.56 21.85 34.23
24.39 44.48 43.38 44.91 36.35 36.06
41.85 20.72 39.53 39.53 43.04 36.44
27.85 26.28 31.25 23.76 33.58 38.39
39.76 20.53 23.98 35.39 31.31 37.22
29.66 24.68 21.41 42.87 25.31 21.21
31.21 23.74 38.61 27.36 33.33 36.13
 39.4 30.46 28.28 42.98 36.24 27.04
30.42 21.86 35.2 39.05 22.31 30.98
43.68 44.03 37.02 28.77 21.64 35.03
29.28 22.45 43.44 31.41 35.79 40.24
26.47 43.33 21.73 39.6 32.93 31.39
41.78 24.35 37.4 23.28 36.57 31.96
22.76 41.42 28.87 26.74 20.1 35.53
37.83 38.29 26.06 33.93 27.36 25.77
25.42 26.28 23.53 42.09 37.95 34.47
39.7 29.05 44.63 31.99 39.98 31.64
41.45 44.27 24.61 37.91 36.87 32.51
41.25 32.93 44.06 40.87 35.67 26.12
23.54 41.58 44.1 32.66 25.84 33.24
42.66 33.84 37.33 28.41 29.23 40.1
23.36 24.09 20.65 29.38 23.85 27.57
33.53 42.33 34.72 42.48 39.23 34.28
28.52 38.91 44.38 21.15 24.57 33.47
31.29 40.65 41.77 40.29 29.28 29.77
42.18 37.83 30.31 27.38 31.94 29.27
32.72 23.8 39.81 26.89 20.04 23.38
41.27 20.55 35.67 32.56 20 40.15
30.01 30.85 28.79 21.77 22.02 32.95
42.24 37.64 32.49 20.19 31.98 21.58
33.67 31.81 34.01 32.04 44.75 30.69
28.17 22.24 21.21 30.87 23.41 25.56
24.25 36.06 37.52 36.17 28.56 30.99
21.61 32.44 35.98 27.91 23.41 40.18
39.19 43.17 29.63 33.77 25.47 38.87
27.36 24.96 22.72 40.12 42.19 23.86
36.99 27.42 41.1 37.07 36.26 28.83
33.65 38.12 39.38 31.88 31.26 27.01
29.09 44.38 42.9 31.91 37.12 40.72
27.22 30.24 22.7 29.68 40.93 39.63
36.99 35.69 40.74 23.11 42.3 24.79
36 22.33 39.56 30.39 43.52 43.03
37.35 26.3 28.41 22.74 22.71 35.91
23.88 41.07 40.43 34.06 34.53 42.76
26.85 20.68 42.69 38.48 32.5 37.85
43.91 29.19 39.98 43.44 28.62 40.57
32.57 30.38 24.18 37.12 33.21 20.27
28.74 34.49 27.34 33.1 43.68 24.19
27.6 34.35 41.86 33.98 34.06 23.21
32.51 21.95 25.42 29.95 26.2 30.16
31.46 34.32 40.28 39.68 20.14 43.58
24.13 43.11 23.78 30.56 44.68 33.51
24.2 36.05 41.2 29.92 22.09 21.52
30.4 36.68 43.74 43.72 40.65 37.12
22.31 44.26 44.45 32.28 40.6 42.21
Excel Avanzado
Función Indirecto
Lista de productos vendidos (NO SE PUEDE USAR LA FUNCIÓN SI)
Halle el descuento en base a las tablas

Cliente Producto Almacen Cantidad Descuento

Cliente 13 P2 Almacen 4 53
Cliente 12 P1 Almacen 1 72
Cliente 5 P3 Almacen 3 63
Cliente 5 P2 Almacen 5 52
Cliente 14 P2 Almacen 5 2
Cliente 6 P3 Almacen 5 72
Cliente 14 P3 Almacen 5 98
Cliente 6 P2 Almacen 3 37
Cliente 5 P3 Almacen 1 55
Cliente 7 P2 Almacen 2 22
Cliente 9 P3 Almacen 2 78
Cliente 3 P2 Almacen 1 10
Cliente 2 P3 Almacen 4 79
Cliente 13 P3 Almacen 2 4
Cliente 5 P1 Almacen 2 68
Cliente 6 P2 Almacen 2 51
Cliente 10 P1 Almacen 1 79
Cliente 8 P2 Almacen 5 14
Cliente 7 P1 Almacen 3 76
Cliente 4 P1 Almacen 4 71
Cliente 4 P2 Almacen 5 90
Cliente 6 P2 Almacen 2 1
 PrecioUni Descripción Producto

S/. 945.00 Lavadora P1

S/. 125.00 Radio P2
S/. 1,020.00 Secadora P3
S/. 670.00 TV P4
S/. 320.00 Licuadora P5

TABLAS DE DESCUENTO DEPENDIENDO DEL PRODUCTO, ALMACEN Y CANTIDAD

P1 1 6 14 33
Almacen 5 13 32 a mas
1 7.5% 5.6% 8.6% 6.7%
2 7.5% 9.5% 4.2% 5.4%
3 7.1% 8.9% 5.1% 6.4%
4 3.4% 9.6% 9.8% 5.0%
5 5.2% 4.4% 6.5% 6.6%

P3 1 5 9 21
Almacen 4 8 20 a mas
1 8.2% 9.5% 8.5% 5.2%
2 9.5% 4.2% 6.3% 4.5%
3 4.8% 6.3% 4.0% 4.7%
4 9.6% 8.5% 9.9% 4.1%
5 9.6% 9.7% 6.6% 9.8%
 P2 1 6 13 32
Almacen 5 12 31 a mas
1 9.4% 3.3% 5.7% 4.7%
2 9.7% 7.7% 5.2% 3.3%
3 8.4% 9.7% 9.5% 3.3%
4 3.9% 5.8% 7.6% 7.7%
5 9.4% 9.8% 5.8% 4.2%