Data Collection & Input Analysis

profilecorybarrett1h
CopyofSERVICETIME-LAB1_InputAnalyzer_Macro-1.xls

EnterData

Data Collection Sheet for Lab #1
Only edit the yellow section. The rest is calculated.
Collect time to the second if possible.
Readings Service Time Diff Hr Diff Min Diff Sec Decimal Min
1 0:00:00
2 0:01:16 0.00 1.00 16.00 1.27
3 0:02:00 0.00 0.00 44.00 0.73
4 0:02:13 0.00 0.00 13.00 0.22
5 0:02:27 0.00 0.00 14.00 0.23
6 0:02:39 0.00 0.00 12.00 0.20
7 0:02:53 0.00 0.00 14.00 0.23
8 0:03:11 0.00 0.00 18.00 0.30 Process Summary:
9 0:03:27 0.00 0.00 16.00 0.27 Process of applying clear grain filler to wood veneer sheets. This is done by machine via roll coater but the machine is fed and emptied by hand. The service times logged are the times an operator fed the machine a new sheet of veneer. Time was taken when the veneer touched the conveyor belt.
10 0:03:42 0.00 0.00 15.00 0.25
11 0:03:54 0.00 0.00 12.00 0.20
12 0:04:09 0.00 0.00 15.00 0.25
13 0:04:21 0.00 0.00 12.00 0.20
14 0:04:35 0.00 0.00 14.00 0.23
15 0:04:50 0.00 0.00 15.00 0.25
16 0:05:04 0.00 0.00 14.00 0.23
17 0:05:17 0.00 0.00 13.00 0.22
18 0:05:31 0.00 0.00 14.00 0.23
19 0:05:44 0.00 0.00 13.00 0.22
20 0:05:55 0.00 0.00 11.00 0.18
21 0:06:09 0.00 0.00 14.00 0.23
22 0:06:23 0.00 0.00 14.00 0.23
23 0:06:40 0.00 0.00 17.00 0.28
24 0:06:54 0.00 0.00 14.00 0.23
25 0:07:07 0.00 0.00 13.00 0.22
26 0:07:22 0.00 0.00 15.00 0.25
27 0:07:34 0.00 0.00 12.00 0.20
28 0:07:46 0.00 0.00 12.00 0.20
29 0:08:12 0.00 0.00 26.00 0.43
30 0:08:22 0.00 0.00 10.00 0.17
31 0:08:50 0.00 0.00 28.00 0.47
32 0:09:02 0.00 0.00 12.00 0.20
33 0:09:19 0.00 0.00 17.00 0.28
34 0:09:31 0.00 0.00 12.00 0.20
35 0:09:44 0.00 0.00 13.00 0.22
36 0:10:01 0.00 0.00 17.00 0.28
37 0:10:12 0.00 0.00 11.00 0.18
38 0:10:27 0.00 0.00 15.00 0.25
39 0:10:49 0.00 0.00 22.00 0.37
40 0:11:01 0.00 0.00 12.00 0.20
41 0:11:15 0.00 0.00 14.00 0.23
42 0:11:27 0.00 0.00 12.00 0.20
43 0:11:39 0.00 0.00 12.00 0.20
44 0:11:55 0.00 0.00 16.00 0.27
45 0:12:06 0.00 0.00 11.00 0.18
46 0:12:19 0.00 0.00 13.00 0.22
47 0:12:33 0.00 0.00 14.00 0.23
48 0:12:46 0.00 0.00 13.00 0.22
49 0:12:58 0.00 0.00 12.00 0.20
50 0:13:11 0.00 0.00 13.00 0.22
51 0:13:24 0.00 0.00 13.00 0.22
Run Conversion to dst

ISYE4500_Lab1

1.27
0.73
0.22
0.23
0.20
0.23
0.30
0.27
0.25
0.20
0.25
0.20
0.23
0.25
0.23
0.22
0.23
0.22
0.18
0.23
0.23
0.28
0.23
0.22
0.25
0.20
0.20
0.43
0.17
0.47
0.20
0.28
0.20
0.22
0.28
0.18
0.25
0.37
0.20
0.23
0.20
0.20
0.27
0.18
0.22
0.23
0.22
0.20
0.22
0.22