Spreadsheet: 160326d1339053025-can-i-use-my-spreadsheet-graph-as-a-screen-saver-departmental-screen-shot-data
Sheet: All Data

 | Cables
Week | On Time Delivery | Dept Avg. | Efficiency | Dept Avg. | Throughput Days | Dept Avg. | Overheads | Extra time | Dept Avg. |  |  |  |  | raw material | in time Dep1 | in time Dep2 | in time Dep3 | in time Dep4 | in time Dep5 | in time [NAME] | total in time delivery
17 | 100 |  | 71 | 91.97 | 4.77 | 2.88 | 24.43 |  | 0.06
20 | 100 | 92.27 | 93 | 90.64 | 2.64 | 2.9 | 24.72 |  | 0.05
23 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 100 | 100 | 100 | 100 |  | 100 | 96 | 99
26 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-06 00:00:00 | 100 | 100 | 92 | 100 |  | 0 | 80 | 79
29 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-08 00:00:00 | 100 | 100 | 100 |  |  | 100 | 96 | 99
32 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-13 00:00:00 | 100 | 100 | 100 | 86 |  | 100 | 93 | 97
35 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-20 00:00:00 | 100 | 67 | 100 | 100 |  |  | 91 | 92
38 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-27 00:00:00 | 100 | 56 | 74 | 100 | 0 | 100 | 93 | 75
41 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-29 00:00:00 | 100 | 88 | 100 | 100 | 100 | 100 | 100 | 98
44 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-03 00:00:00 | 100 | 63 | 88 | 100 |  |  | 100 | 90
47 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-05 00:00:00 |  | 57 | 77 | 100 |  |  | 100 | 84
50 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-10 00:00:00 |  | 67 | 85 | 100 |  |  | 100 | 88
1 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-12 00:00:00 | 100 | 71 | 94 |  |  |  | 100 | 91
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-17 00:00:00 | 0 | 92 | 53 | 100 |  | 100 | 100 | 74
 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-19 00:00:00 | 80 | 85 | 71 | 100 |  |  | 93 | 86
 | Pcb |  |  |  |  |  |  |  |  |  |  |  | 2012-04-24 00:00:00 | 100 | 100 | 84 | 100 |  |  | 100 | 97
Week | On Time Delivery | Dept Avg. | Efficiency | Dept Avg. | Throughput Days | Dept Avg. | Overheads | Extra time | Dept Avg. |  |  |  | 2012-04-26 00:00:00 |  | 100 | 87 | 100 |  |  | 100 | 97
17 | 85.5 |  | 70 | 73 | 6.76 | 7.04 | 24.13 |  | 0.49 |  |  |  | 2012-05-01 00:00:00 |  | 83 | 88 | 50 |  |  | 88 | 77
20 | 62 | 84.54 | 70 | 72.78 | 6.89 | 7.27 | 24.1 |  | 0.5 |  |  |  | 2012-05-03 00:00:00 |  | 100 | 94 | 0 |  |  | 100 | 74
23 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-08 00:00:00 | 100 | 100 | 42 | 0 |  |  | 64 | 61
26 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-10 00:00:00 |  | 100 | 94 | 100 |  | 100 | 73 | 93
29 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-15 00:00:00 | 100 | 100 | 62 |  |  |  | 100 | 90
32 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-22 00:00:00 | 75 | 100 | 86 | 100 |  |  | 83 | 89
35 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-24 00:00:00 | 100 | 100 | 89 |  |  |  | 80 | 92
38 |  |  |  |  |  |  |  |  |  |  |  |  | Week 17
41 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86.75531914893617
44 |  |  |  |  |  |  |  |  |  |  |  |  | Week 20 |  |  | 1860 | 1536 | 100 | 700 | 2030
47 |  |  |  |  |  |  |  |  |  |  |  |  | Week 20 |  | 87.68181818181819 | 84.54545454545455 | 85.33333333333333 | 50 | 87.5 | 92.27272727272727 | 0
50
1
 | Testers
Week | On Time Delivery | Dept Avg. | Efficiency | Dept Avg. | Throughput Days | Dept Avg. | Overheads | Extra time | Dept Avg.
17 | 100 |  | 88 | 77.73 | 3.26 | 3.92 | 19.99 |  | 0.12
20 | 100 | 87.68 | 90 | 78.73 | 2.4 | 4.18 | 20.15 |  | 0.11
23
26
29
32
35
38
41
44
47
50
1
 | Trafo/Modules
Week | On Time Delivery | Dept Avg. | Efficiency | Dept Avg. | Throughput Days | Dept Avg. | Overheads | Extra time | Dept Avg.
17 | 50 |  | 63 | 65.76 | 4.88 | 5.71 | 24.05 |  | 0.71
20 | 100 | 85 | 48 | 63.92 | 4.62 | 5.78 | 26.23 |  | 0.7
23
26
29
32
35
38
41
44
47
50
1
 |  | Plant Avg. |  | Plant Avg. |  | Plant Avg. | Plant Avg. |  | Plant Avg.