Scribd
Cargar
5K vistas31 páginas

Excel MTBF MTTR

Este documento presenta información sobre el cálculo y seguimiento de métricas de disponibilidad, como MTBF, MTTR y porcentaje de disponibilidad. Incluye tablas con datos de fallas, máquinas, metas de desempeño y un calendario de turnos.

Cargado por

Marco Palacios
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
5K vistas31 páginas

Excel MTBF MTTR

Este documento presenta información sobre el cálculo y seguimiento de métricas de disponibilidad, como MTBF, MTTR y porcentaje de disponibilidad. Incluye tablas con datos de fallas, máquinas, metas de desempeño y un calendario de turnos.

Cargado por

Marco Palacios
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

MTBF - MTTR

Tiempo Disponible (min)


Esta forma representa una segmentación de
o00o
datos. La segmentación de datos se admite en
Excel 2010 y versiones posteriores. 19,320
Si la forma se modificó en una versión
anterior de Excel o si el libro se guardó en
Excel 2003 o una versión anterior, no se
puede usar la segmentación de datos. MTBF (min) Tiempo Disponible
53,760
Tiempo Muerto
6,483

434

0 0 0 0 0 0 0

2021 ene feb mar abr may jun jul sep

Fallas (min) Suma Duración


2,486
Esta forma representa una segmentación de 300 271
201 188
datos. La segmentación de datos se admite 200
en Excel 2010 y versiones posteriores. 100
0

Si la forma se modificó en una versión


anterior de Excel o si el libro se guardó en
Excel 2003 o una versión anterior, no se
puede usar la segmentación de datos.

Fallas por departamento


Esta forma representa una segmentación de
datos. La segmentación de datos se admite MANTENIMIENTO
en Excel 2010 y versiones posteriores.
OPERACIONES
1,481
Si la forma se modificó en una versión CALIDAD
anterior de Excel o si el libro se guardó en 2,486 MATERIALES
Excel 2003 o una versión anterior, no se Total general
puede usar la segmentación de datos. 754

116 135

Línea de tiempo: Funciona en Excel 2013 o superior. No mover ni cambi


Línea de tiempo: Funciona en Excel 2013 o superior. No mover ni cambi

Última Actualización:
02/Mar/2021 12:41
NOMBRE DE TU EMPRESA
Tiempo Muerto (min) Tendencia Número de Fallas Tendencia

2,486 p 2%
45 q -16%

Tiempo Muerto
526 MTTR (min)
Tiempo Muerto # Fallas MTBF
6,483 109 434 Meta 6,483

434 59

0 0 0 0 0 0 0 0 00 00 0 00 00 00

may jun jul sep ago oct nov dic Total 2021 ene feb mar abr may jun j
general

# Fallas Acc # Acc Duración Acc %


Duración
24 5 1,027 41% Disponibilidad (%) 434
01 188 187 180 80%
40%
0% 87.9 %

0.0 % 0.0 % 0.0 % 0.0 % 0.0 % 0.

2021 ene feb mar abr may jun

mento Fallas por área


ANTENIMIENTO
2,486 2,486
ERACIONES
LIDAD
ATERIALES
tal general

Ensamble Total general

13 o superior. No mover ni cambiar el tamaño.


13 o superior. No mover ni cambiar el tamaño.
Información

Tendencia Microparos (min) Tendencia Número de Microparos Tendencia


-16%
16 q -86%
3 q -83%

Tiempo Muerto # Fallas MTTR


6,483 109 59 Límite 56 Fallas por máquina
59

00 00 00 00 00 00 00 00 00 0 Total general 2,486


br may jun jul sep ago oct nov dic Total
general

)
MTBF
434
MTTR
59
% Disp
87.9% Meta 96%
87.9 %
Linea 1 2,486

0% 0.0 % 0.0 % 0.0 % 0.0 % 0.0 % 0.0 % 0.0 % 0.0 %

abr may jun jul sep ago oct nov dic Total
general

Fallas por mes (min)


2,486 2,486

2021 mar Total general


formación

Tendencia
-83%

uina

2,486

2,486

,486

general
MTBF - MTTR

Fecha Máquina Falla Duración Falla (Min)


01/Jan/2021 Fri MA01 FA01 10
01/Jan/2021 Fri MA01 FA02 104
Observaciones
Dato 1 Ejemplo
Dato 2 Ejemplo
MTBF - MTTR
Fallas
Código Descripción Departamento Código

FA01 Falla Ejemplo 1 MANTENIMIENTO MA01


FA02 Falla Ejemplo 2 MANTENIMIENTO
Máquinas
Meta Mensual MTBF Meta Mensual MTTR Meta Mensual %
Descripción Área
(min) (min) Disponibilidad
Máquina Ejemplo Prensado 520 50 90%
Calendario Semanal
Descanso 1 Descanso 2
Día Nombre Turno Inicio Fin
(min) (min)
Lunes Primero 6:00 14:00 30 30
Lunes Segundo 14:00 22:00 30 30
Lunes Tercero 0:00 0:00 0 0
Martes Primero 6:00 14:00 30 30
Martes Segundo 14:00 22:00 30 30
Martes Tercero 0:00 0:00 0 0
Miércoles Primero 6:00 14:00 30 30
Miércoles Segundo 14:00 22:00 30 30
Miércoles Tercero 0:00 0:00 0 0
Jueves Primero 6:00 14:00 30 30
Jueves Segundo 14:00 22:00 30 30
Jueves Tercero 0:00 0:00 0 0
Viernes Primero 6:00 14:00 30 30
Viernes Segundo 14:00 22:00 30 30
Viernes Tercero 0:00 0:00 0 0
Sábado Primero 0:00 0:00 0 0
Sábado Segundo 0:00 0:00 0 0
Sábado Tercero 0:00 0:00 0 0
Domingo Primero 0:00 0:00 0 0
Domingo Segundo 0:00 0:00 0 0
Domingo Tercero 0:00 0:00 0 0
Disponibilidad
Tiempo Disponible
Fecha Inicio 01/Jan/2021 Fri Fecha
(min)
420 Fecha Final 31/Dec/2021 Fri 01/Jan/2021 Fri
420 02/Jan/2021 Sat
0 03/Jan/2021 Sun
420 04/Jan/2021 Mon
420.000000000005 05/Jan/2021 Tue
0 06/Jan/2021 Wed
420 07/Jan/2021 Thu
420.000000000005 08/Jan/2021 Fri
0 09/Jan/2021 Sat
420 10/Jan/2021 Sun
420.000000000005 11/Jan/2021 Mon
0 12/Jan/2021 Tue
420 13/Jan/2021 Wed
420.000000000004 14/Jan/2021 Thu
0 15/Jan/2021 Fri
0 16/Jan/2021 Sat
0 17/Jan/2021 Sun
0 18/Jan/2021 Mon
0 19/Jan/2021 Tue
0 20/Jan/2021 Wed
0 21/Jan/2021 Thu
22/Jan/2021 Fri
23/Jan/2021 Sat
24/Jan/2021 Sun
25/Jan/2021 Mon
26/Jan/2021 Tue
27/Jan/2021 Wed
28/Jan/2021 Thu
29/Jan/2021 Fri
30/Jan/2021 Sat
31/Jan/2021 Sun
01/Feb/2021 Mon
02/Feb/2021 Tue
03/Feb/2021 Wed
04/Feb/2021 Thu
05/Feb/2021 Fri
06/Feb/2021 Sat
07/Feb/2021 Sun
08/Feb/2021 Mon
09/Feb/2021 Tue
10/Feb/2021 Wed
11/Feb/2021 Thu
12/Feb/2021 Fri
13/Feb/2021 Sat
14/Feb/2021 Sun
15/Feb/2021 Mon
16/Feb/2021 Tue
17/Feb/2021 Wed
18/Feb/2021 Thu
19/Feb/2021 Fri
20/Feb/2021 Sat
21/Feb/2021 Sun
22/Feb/2021 Mon
23/Feb/2021 Tue
24/Feb/2021 Wed
25/Feb/2021 Thu
26/Feb/2021 Fri
27/Feb/2021 Sat
28/Feb/2021 Sun
01/Mar/2021 Mon
02/Mar/2021 Tue
03/Mar/2021 Wed
04/Mar/2021 Thu
05/Mar/2021 Fri
06/Mar/2021 Sat
07/Mar/2021 Sun
08/Mar/2021 Mon
09/Mar/2021 Tue
10/Mar/2021 Wed
11/Mar/2021 Thu
12/Mar/2021 Fri
13/Mar/2021 Sat
14/Mar/2021 Sun
15/Mar/2021 Mon
16/Mar/2021 Tue
17/Mar/2021 Wed
18/Mar/2021 Thu
19/Mar/2021 Fri
20/Mar/2021 Sat
21/Mar/2021 Sun
22/Mar/2021 Mon
23/Mar/2021 Tue
24/Mar/2021 Wed
25/Mar/2021 Thu
26/Mar/2021 Fri
27/Mar/2021 Sat
28/Mar/2021 Sun
29/Mar/2021 Mon
30/Mar/2021 Tue
31/Mar/2021 Wed
01/Apr/2021 Thu
02/Apr/2021 Fri
03/Apr/2021 Sat
04/Apr/2021 Sun
05/Apr/2021 Mon
06/Apr/2021 Tue
07/Apr/2021 Wed
08/Apr/2021 Thu
09/Apr/2021 Fri
10/Apr/2021 Sat
11/Apr/2021 Sun
12/Apr/2021 Mon
13/Apr/2021 Tue
14/Apr/2021 Wed
15/Apr/2021 Thu
16/Apr/2021 Fri
17/Apr/2021 Sat
18/Apr/2021 Sun
19/Apr/2021 Mon
20/Apr/2021 Tue
21/Apr/2021 Wed
22/Apr/2021 Thu
23/Apr/2021 Fri
24/Apr/2021 Sat
25/Apr/2021 Sun
26/Apr/2021 Mon
27/Apr/2021 Tue
28/Apr/2021 Wed
29/Apr/2021 Thu
30/Apr/2021 Fri
01/May/2021 Sat
02/May/2021 Sun
03/May/2021 Mon
04/May/2021 Tue
05/May/2021 Wed
06/May/2021 Thu
07/May/2021 Fri
08/May/2021 Sat
09/May/2021 Sun
10/May/2021 Mon
11/May/2021 Tue
12/May/2021 Wed
13/May/2021 Thu
14/May/2021 Fri
15/May/2021 Sat
16/May/2021 Sun
17/May/2021 Mon
18/May/2021 Tue
19/May/2021 Wed
20/May/2021 Thu
21/May/2021 Fri
22/May/2021 Sat
23/May/2021 Sun
24/May/2021 Mon
25/May/2021 Tue
26/May/2021 Wed
27/May/2021 Thu
28/May/2021 Fri
29/May/2021 Sat
30/May/2021 Sun
31/May/2021 Mon
01/Jun/2021 Tue
02/Jun/2021 Wed
03/Jun/2021 Thu
04/Jun/2021 Fri
05/Jun/2021 Sat
06/Jun/2021 Sun
07/Jun/2021 Mon
08/Jun/2021 Tue
09/Jun/2021 Wed
10/Jun/2021 Thu
11/Jun/2021 Fri
12/Jun/2021 Sat
13/Jun/2021 Sun
14/Jun/2021 Mon
15/Jun/2021 Tue
16/Jun/2021 Wed
17/Jun/2021 Thu
18/Jun/2021 Fri
19/Jun/2021 Sat
20/Jun/2021 Sun
21/Jun/2021 Mon
22/Jun/2021 Tue
23/Jun/2021 Wed
24/Jun/2021 Thu
25/Jun/2021 Fri
26/Jun/2021 Sat
27/Jun/2021 Sun
28/Jun/2021 Mon
29/Jun/2021 Tue
30/Jun/2021 Wed
01/Jul/2021 Thu
02/Jul/2021 Fri
03/Jul/2021 Sat
04/Jul/2021 Sun
05/Jul/2021 Mon
06/Jul/2021 Tue
07/Jul/2021 Wed
08/Jul/2021 Thu
09/Jul/2021 Fri
10/Jul/2021 Sat
11/Jul/2021 Sun
12/Jul/2021 Mon
13/Jul/2021 Tue
14/Jul/2021 Wed
15/Jul/2021 Thu
16/Jul/2021 Fri
17/Jul/2021 Sat
18/Jul/2021 Sun
19/Jul/2021 Mon
20/Jul/2021 Tue
21/Jul/2021 Wed
22/Jul/2021 Thu
23/Jul/2021 Fri
24/Jul/2021 Sat
25/Jul/2021 Sun
26/Jul/2021 Mon
27/Jul/2021 Tue
28/Jul/2021 Wed
29/Jul/2021 Thu
30/Jul/2021 Fri
31/Jul/2021 Sat
01/Aug/2021 Sun
02/Aug/2021 Mon
03/Aug/2021 Tue
04/Aug/2021 Wed
05/Aug/2021 Thu
06/Aug/2021 Fri
07/Aug/2021 Sat
08/Aug/2021 Sun
09/Aug/2021 Mon
10/Aug/2021 Tue
11/Aug/2021 Wed
12/Aug/2021 Thu
13/Aug/2021 Fri
14/Aug/2021 Sat
15/Aug/2021 Sun
16/Aug/2021 Mon
17/Aug/2021 Tue
18/Aug/2021 Wed
19/Aug/2021 Thu
20/Aug/2021 Fri
21/Aug/2021 Sat
22/Aug/2021 Sun
23/Aug/2021 Mon
24/Aug/2021 Tue
25/Aug/2021 Wed
26/Aug/2021 Thu
27/Aug/2021 Fri
28/Aug/2021 Sat
29/Aug/2021 Sun
30/Aug/2021 Mon
31/Aug/2021 Tue
01/Sep/2021 Wed
02/Sep/2021 Thu
03/Sep/2021 Fri
04/Sep/2021 Sat
05/Sep/2021 Sun
06/Sep/2021 Mon
07/Sep/2021 Tue
08/Sep/2021 Wed
09/Sep/2021 Thu
10/Sep/2021 Fri
11/Sep/2021 Sat
12/Sep/2021 Sun
13/Sep/2021 Mon
14/Sep/2021 Tue
15/Sep/2021 Wed
16/Sep/2021 Thu
17/Sep/2021 Fri
18/Sep/2021 Sat
19/Sep/2021 Sun
20/Sep/2021 Mon
21/Sep/2021 Tue
22/Sep/2021 Wed
23/Sep/2021 Thu
24/Sep/2021 Fri
25/Sep/2021 Sat
26/Sep/2021 Sun
27/Sep/2021 Mon
28/Sep/2021 Tue
29/Sep/2021 Wed
30/Sep/2021 Thu
01/Oct/2021 Fri
02/Oct/2021 Sat
03/Oct/2021 Sun
04/Oct/2021 Mon
05/Oct/2021 Tue
06/Oct/2021 Wed
07/Oct/2021 Thu
08/Oct/2021 Fri
09/Oct/2021 Sat
10/Oct/2021 Sun
11/Oct/2021 Mon
12/Oct/2021 Tue
13/Oct/2021 Wed
14/Oct/2021 Thu
15/Oct/2021 Fri
16/Oct/2021 Sat
17/Oct/2021 Sun
18/Oct/2021 Mon
19/Oct/2021 Tue
20/Oct/2021 Wed
21/Oct/2021 Thu
22/Oct/2021 Fri
23/Oct/2021 Sat
24/Oct/2021 Sun
25/Oct/2021 Mon
26/Oct/2021 Tue
27/Oct/2021 Wed
28/Oct/2021 Thu
29/Oct/2021 Fri
30/Oct/2021 Sat
31/Oct/2021 Sun
01/Nov/2021 Mon
02/Nov/2021 Tue
03/Nov/2021 Wed
04/Nov/2021 Thu
05/Nov/2021 Fri
06/Nov/2021 Sat
07/Nov/2021 Sun
08/Nov/2021 Mon
09/Nov/2021 Tue
10/Nov/2021 Wed
11/Nov/2021 Thu
12/Nov/2021 Fri
13/Nov/2021 Sat
14/Nov/2021 Sun
15/Nov/2021 Mon
16/Nov/2021 Tue
17/Nov/2021 Wed
18/Nov/2021 Thu
19/Nov/2021 Fri
20/Nov/2021 Sat
21/Nov/2021 Sun
22/Nov/2021 Mon
23/Nov/2021 Tue
24/Nov/2021 Wed
25/Nov/2021 Thu
26/Nov/2021 Fri
27/Nov/2021 Sat
28/Nov/2021 Sun
29/Nov/2021 Mon
30/Nov/2021 Tue
01/Dec/2021 Wed
02/Dec/2021 Thu
03/Dec/2021 Fri
04/Dec/2021 Sat
05/Dec/2021 Sun
06/Dec/2021 Mon
07/Dec/2021 Tue
08/Dec/2021 Wed
09/Dec/2021 Thu
10/Dec/2021 Fri
11/Dec/2021 Sat
12/Dec/2021 Sun
13/Dec/2021 Mon
14/Dec/2021 Tue
15/Dec/2021 Wed
16/Dec/2021 Thu
17/Dec/2021 Fri
18/Dec/2021 Sat
19/Dec/2021 Sun
20/Dec/2021 Mon
21/Dec/2021 Tue
22/Dec/2021 Wed
23/Dec/2021 Thu
24/Dec/2021 Fri
25/Dec/2021 Sat
26/Dec/2021 Sun
27/Dec/2021 Mon
28/Dec/2021 Tue
29/Dec/2021 Wed
30/Dec/2021 Thu
31/Dec/2021 Fri
Disponibilidad Anual
Máquina Disponibilidad (min) Observaciones

MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 -
MA01 -
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
MA01 840.00
Nombre Empresa Chokoteis
Empresa Microparos (Min)

NOMBRE DE TU EMPRESA 10
Actualización
Actualización

02/Mar/2021 12:41

También podría gustarte