practica excel

17
(empty) Column D Column E 0.00100 0.00100 Res0.00300 0.00300 Res breack 0.01 0.02 adm aj cf chei chock dir loop OEE org Total Result

Upload: osmar-borda

Post on 22-Dec-2015

222 views

Category:

Documents


7 download

DESCRIPTION

prac excel

TRANSCRIPT

Page 1: Practica Excel

(empty) Column D Column E0.00100 0.00100 Resul0.00300 0.00300 Resul0.01400

breack 0.01 0.02 0.07admajcfcheichockdirloopOEEorgTotal Result

Page 2: Practica Excel

0.01400 Resul0.01450 0.01450 Resul0.02000 0.02000 Resul0.02100 0.02100 Resul0.08 0.11 0.11

Page 3: Practica Excel

0.02800 0.02800 Resul0.04000 0.04000 Resul0.81280 0.81280 ResultTotal Result0.15 0.21 (empty)

Page 4: Practica Excel

Column D0.00100 0.00300 ### ### ### ### ### ### ### Total Result

1 1 1 1 1 1 1 1 1 9

10%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

Total Result 0.81280 0.04000 0.02800 0.02100 0.02000 0.01450 0.01400 0.00300

Page 5: Practica Excel

Total Result

Page 6: Practica Excel

JHFUYKFF PERD1 PERD2adm 0.001 0.00534188

Page 7: Practica Excel

PERD1 JHFUYKFF0.00100 0.00100 Resul0.00300 0.00300 Result0.01400

Data adm dir ajSuma de PERD1 0.00100 0.00100 0.00300 0.00300 0.01400Promedio de PERD2 0.01 0.01 0.02 0.02 0.07

Promedio de PERD20%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

0.53%1.60%

7.48%

7.75%

10.68%

11.22%

14.96%

21.37%

24.41%

Chart Title

0.81280 OEE 0.81280 0.04570 breack 0.04570 0.04000 cf 0.04000 0.02800 chock 0.02800 0.02100 chei 0.02100 0.02000 org 0.02000 0.01450 loop 0.01450 0.01400 aj 0.01400 0.00300 dir 0.00300PERD1 0.00100 adm 0.00100

Axis Title

Axis Title

Page 8: Practica Excel

0.01400 Result0.01450 0.01450 Result0.02000 0.02000 Result0.02100 0.02100 Resultloop org chei

0.01400 0.01450 0.01450 0.02000 0.02000 0.02100 0.021000.07 0.08 0.08 0.11 0.11 0.11 0.11

Promedio de PERD20%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

0.53%1.60%

7.48%

7.75%

10.68%

11.22%

14.96%

21.37%

24.41%

Chart Title

0.81280 OEE 0.81280 0.04570 breack 0.04570 0.04000 cf 0.04000 0.02800 chock 0.02800 0.02100 chei 0.02100 0.02000 org 0.02000 0.01450 loop 0.01450 0.01400 aj 0.01400 0.00300 dir 0.00300PERD1 0.00100 adm 0.00100

Axis Title

Axis Title

Page 9: Practica Excel

0.02800 0.02800 Resul0.04000 0.04000 Result0.04570 0.04570 Result0.81280chock cf breack OEE

0.02800 0.02800 0.04000 0.04000 0.04570 0.04570 0.812800.15 0.15 0.21 0.21 0.24 0.24

Promedio de PERD20%

10%

20%

30%

40%

50%

60%

70%

80%

90%

100%

0.53%1.60%

7.48%

7.75%

10.68%

11.22%

14.96%

21.37%

24.41%

Chart Title

0.81280 OEE 0.81280 0.04570 breack 0.04570 0.04000 cf 0.04000 0.02800 chock 0.02800 0.02100 chei 0.02100 0.02000 org 0.02000 0.01450 loop 0.01450 0.01400 aj 0.01400 0.00300 dir 0.00300PERD1 0.00100 adm 0.00100

Axis Title

Axis Title

Page 10: Practica Excel

0.81280 ResultTotal Result

0.81280 1.000000.11

Page 11: Practica Excel

JHFUYKFFadm aj breack cf chei chock dir loop OEE org

0.00100 0.01400 ### 0.04000 ### ### ### ### 0.81280 0.02000

0.001001.40%0.045700.040000.021000.028000.003000.01450

0.81280

0.02000

1.00000

Chart Title aj breack cf chei chock dir loop OEE org Total Result

Page 12: Practica Excel

Total Result###

0.001001.40%0.045700.040000.021000.028000.003000.01450

0.81280

0.02000

1.00000

Chart Title aj breack cf chei chock dir loop OEE org Total Result

Page 13: Practica Excel

breack cf chock chei org loop0.05 0.04 0.03 0.02 0.02 0.01

0.24 0.21 0.15 0.11 0.11 0.08

JHFUYKFF PERD1 PERD2breack 0.04570 0.24cf 0.04000 0.21chock 0.02800 0.15chei 0.02100 0.11org 0.02000 0.11loop 0.01450 0.08aj 0.01400 0.07dir 0.00300 0.02adm 0.00100 0.01OEE 0.81280TOTAL 1.00000

Page 14: Practica Excel

aj dir adm OEE0.01 0.00 0.00 0.81

0.07 0.02 0.01

1 2 3 4 5 6 7 8 9 100%

10%20%30%40%50%60%70%80%90%

100%

PERD1

PERD1

Axis Title

Axis Title

Page 15: Practica Excel

-55415

564654545

54643654646

644494

-5.00 €(0,05€)

61,655+

58984,8es negativo