santiago flores tp9

Elementos importecaja*10 discos 110boligrafos 135resaltadores 60caja*10 resmas 180

nota 3 trim promedio funcion si contar siHelguera 6 8 7 7 aprovado 2Mafalda 7 8 9 8 aprovadoRodriguez 4 6 6 5 desaprovado

apellido nota 1 trim nota 2 trim

Aprovados y desaprovados

Helguera Mafalda Rodriguez Column B Column C Column D0

1

2

3

4

5

6

7

8

9

10

Alumnos y notas por trimestre

HelgueraMafaldaRodriguez

Column B Column C Column D

Alumnos y notas por trimestre

HelgueraMafaldaRodriguez

Marca de Auto Ctdad.Vend.1er.Cuat Ctdad.Vend.2do.Cuat total Funcion SiAudi 1,024.00 € 455.00 € 1,066.00 € 2,545.00 € venta ok Peugeot 254.00 321.00 1,223.00 1,798.00 revisar Renault 1,005.00 233.00 554.00 1,792.00 revisar Ford 511.00 1,217.00 1,980.00 3,708.00 venta ok total 2,794.00 € 2,226.00 € 4,823.00 € 9,843.00 €

Dia X-Men 3 Cod. Da vinci La Profecia Cars Total Porcentaje8/8/2008 102 203 187 76 568 6%8/8/2008 140 208 123 32 503 5%8/8/2008 103 245 154 44 546 5%8/8/2008 146 231 99 76 552 5%8/8/2008 157 212 135 102 606 6%8/9/2008 164 256 124 98 642 6%8/10/2008 208 265 154 45 672 7%8/11/2008 187 210 165 26 588 6%8/12/2008 165 198 176 94 633 6%8/13/2008 145 199 201 65 610 6%8/14/2008 156 203 235 78 672 7%8/15/2008 136 201 266 132 735 7%8/16/2008 176 210 278 154 818 8%8/17/2008 165 187 254 155 761 7%8/18/2008 132 198 210 123 663 7%8/19/2008 102 143 199 176 620 6%total 2384 3369 2960 1476 10189 100%promedio 0.23 0.33 0.29 0.14 1prcentaje 23% 33% 29% 14%

X-Men 3 Cod. Da vinci La Profecia Cars0

0.05

0.1

0.15

0.2

0.25

0.3

0.35

0.23

0.33

0.29

0.14

Promedio semanales de cada pelicula


500

1000

1500

2000

2500

3000

3500

4000

2384

3369

2960

1476

Peliculas y cantidad de entradas vendidas


500

1000

1500

2000

2500

3000

3500

4000

2384

3369

2960

1476

Peliculas y cantidad de entradas vendidas

Porcentaje vendido por dia

8/8/2008 8/8/2008 8/8/2008 8/8/2008 8/8/2008 8/9/20088/10/2008 8/11/2008 8/12/2008 8/13/2008 8/14/2008 8/15/20088/16/2008 8/17/2008 8/18/2008 8/19/2008

Veces Numeros Numeros Total Porcentaje1 1.00 € 2.00 € 3.00 € 0.02 € 2 1.00 2.00 3.00 0.02 3 1.00 2.00 3.00 0.02 4 1.00 6.00 7.00 0.04 5 1.00 6.00 7.00 0.04 6 1.00 5.00 6.00 0.04 7 1.00 4.00 5.00 0.03 8 1.00 3.00 4.00 0.02 9 2.00 1.00 3.00 0.02 10 2.00 1.00 3.00 0.02 11 2.00 1.00 3.00 0.02 12 2.00 2.00 4.00 0.02 13 2.00 2.00 4.00 0.02 14 2.00 3.00 5.00 0.03 15 2.00 3.00 5.00 0.03 16 2.00 4.00 6.00 0.04 17 3.00 2.00 5.00 0.03 18 3.00 2.00 5.00 0.03 19 3.00 2.00 5.00 0.03 20 3.00 4.00 7.00 0.04 21 3.00 2.00 5.00 0.03 22 3.00 6.00 9.00 0.05 23 3.00 1.00 4.00 0.02 24 4.00 3.00 7.00 0.04 25 4.00 3.00 7.00 0.04 26 4.00 3.00 7.00 0.04 27 5.00 4.00 9.00 0.05 28 5.00 6.00 11.00 0.06 29 5.00 3.00 8.00 0.05 30 6.00 4.00 10.00 0.06 Total 170.00 €

Row 2Row 3

Row 4Row 5

Row 6Row 7

Row 8Row 9

Row 10Row 11

Row 12Row 13

Row 14Row 15

Row 16Row 17

Row 18Row 19

Row 20Row 21

Row 22Row 23

Row 24Row 25

Row 26Row 27

Row 28Row 29

Row 30Row 31

- €

1.00 €

2.00 €

3.00 €

4.00 €

5.00 €

6.00 €

7.00 €

3.00 € 3.00 3.00 7.00 7.00 6.00 5.00 4.00 3.00 3.00 3.00 4.00 4.00 5.00 5.00 6.00 5.00 5.00 5.00 7.00 5.00

9.00

4.00

7.00

7.00

7.00

9.00

11.00 8.00 10.00

Veces que Salio C/suma

Row 2 Row 3 Row 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10 Row 11Row 12 Row 13 Row 14 Row 15 Row 16 Row 17 Row 18 Row 19 Row 20 Row 21Row 22 Row 23 Row 24 Row 25 Row 26 Row 27 Row 28 Row 29 Row 30 Row 31

3.00 € 3.00 3.00 7.00 7.00 6.00 5.00 4.00 3.00 3.00 3.00 4.00 4.00 5.00 5.00 6.00 5.00 5.00 5.00 7.00 5.00

9.00

4.00

7.00

7.00

7.00

9.00

11.00 8.00 10.00


Row 2 Row 3 Row 4 Row 5 Row 6 Row 7 Row 8 Row 9 Row 10 Row 11Row 12 Row 13 Row 14 Row 15 Row 16 Row 17 Row 18 Row 19 Row 20 Row 21Row 22 Row 23 Row 24 Row 25 Row 26 Row 27 Row 28 Row 29 Row 30 Row 31

Row 20Row 21

Row 22Row 23

Row 24Row 25

Row 26Row 27

Row 28Row 29

Row 30Row 31


Row 7 Row 8 Row 9 Row 10 Row 11Row 17 Row 18 Row 19 Row 20 Row 21Row 27 Row 28 Row 29 Row 30 Row 31


Row 7 Row 8 Row 9 Row 10 Row 11Row 17 Row 18 Row 19 Row 20 Row 21Row 27 Row 28 Row 29 Row 30 Row 31

Nombre Nota 1 Nota 2 Nota 3 Promedio Premio

Daniela Agüero 2.5 6.2 4.5 4.4 6380.0Solange Gonzalez 3.2 5.2 5.3 4.6 6621.7Nolfa Nova 2.0 5.1 4.6 3.9 5655.0Henry Barrientos 4.5 4.8 6.0 5.1 7395.0Cindy Ceròn 6.0 5.2 4.8 5.3 7733.3Miguel Gómez 2.0 3.1 7.0 4.0 5848.3Max 6.0 6.2 7.0Min 2.0 3.1 4.5Bonificación 1450

0 2 4 6 8 10 120.0

2.0

4.0

6.0

8.0

10.0

12.0

Promedios

Daniela Agüero

Solange Gonzalez

Nolfa Nova

Henry Barrientos

Cindy Ceròn

Miguel Gómez

6380.0

6621.7

5655.0

7395.0

7733.3

5848.3

Column F

Daniela Agüero

Solange Gonzalez

Nolfa Nova

Henry Barrientos

Cindy Ceròn

Miguel Gómez

6380.0

6621.7

5655.0

7395.0

7733.3

5848.3

Column F

Especie 1996 1997 1998 1999 2000 2001 2002 Total MaxMañio 12000 3500 1200 3100 6500 3200 3400 32900 12000Pino Oregon 10000 4300 2300 4500 5400 1300 2800 30600 10000Encino 12000 2400 4200 2100 3300 3400 1900 29300 12000Abedul 9800 5300 8000 7500 3200 6500 2500 42800 9800Total Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504Max 12000 5300 8000 7500 6500 6500 3400Min Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504Porcentaje Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504 Err:504

Mañio Pino Oregon Encino Abedul0

2000

4000

6000

8000

10000

12000

1996199719981999200020012002

Porcentaje

Min Porcentaje1200 Err:5041300 Err:5041900 Err:5042500 Err:504

Err:504

Columna1 Domingo$ 8.00 4 7 8 10$ 6.00 3 7 8 10$ 5.00 8 4 5 0$ 4.00 16 10 11 14

Total 31 28 32 3425% 22% 26% 27%

Precio Jueves Viernes SábadoVipPlatea AltaPlatea BajaCésped

Porcentaje

Vip

Platea Alta

Platea Baja

Césped

0 10 20 30 40 50 60

Entradas Vendidas

Total29 $ 232.00 23%28 $ 174.00 22%17 $ 145.00 14%51 $ 116.00 41%

125 $ 667.00 100%100%

Importe Porcentaje

60

santiago flores tp9

Business