ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Date and TimeDurationLocationShiftProductOperatorReason
Additional description
2
9/19/2022 6:10:000:12:00Line 11st ShiftProduct ARoel LiamSetup
3
9/19/2022 6:49:000:36:00Line 11st ShiftProduct ARoel LiamWaiting for material
4
9/19/2022 12:00:000:50:00Line 11st ShiftProduct ARoel LiamBreakdown
5
9/19/2022 14:12:000:15:00Line 12nd ShiftProduct BCloe MartheChangeover
6
9/19/2022 15:47:000:10:00Line 12nd ShiftProduct BCloe MartheWaiting for material
7
9/19/2022 17:22:001:01:00Line 12nd ShiftProduct BCloe MartheForklift wait
8
9/19/2022 19:06:000:22:00Line 12nd ShiftProduct CCloe MartheChangeover
9
9/19/2022 20:00:000:05:00Line 12nd ShiftProduct CCloe MartheWaiting for material
10
11
12
This is an example. Make a copy to your own Google Drive to edit it
13
14
Check out other sheets for analysis of downtime by reason, shift or product. Make your own breakdowns using example formulas.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100