Spreadsheet: 867532d1714388286-updating-excel-data-from-another-spreadsheet-workbook-2
Sheet: Update 2023 & 2024 ENG % DT

Week | DT TARGET % | [NAME] % | AVERAGE - YEAR | AVERAGE 2024 - YEAR. 2 | AVERAGE MONTHLY | Month | Month End | DT TARGET % | Year |  | [NAME] time (Mins) | Maintenance D/Time (Mins)
 | 0.03 | 0.075 | 0.03556862745098039 |  | 0.075 |  | MONTH | 0.03 | 2021
 | 0.03 | 0.099 | 0.03556862745098039 |  | 0.087 |  |  | 0.03 | 2021
 | 0.03 | 0.02 | 0.03556862745098039 |  | 0.06466666666666666 |  |  | 0.03 | 2021
 | 0.03 | 0.027 | 0.03556862745098039 |  | 0.05524999999999999 |  |  | 0.03 | 2021
 | 0.03 | 0.026 | 0.03556862745098039 |  | 0.026 |  |  | 0.03 | 2021
 | 0.03 | 0.03 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.011 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.019 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.04 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.016 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.024 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.014 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.028 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.016 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.028 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.028 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.03 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.022 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.048 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.03 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.031 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.018 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.015 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.023 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.035 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.022 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.022 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.027 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.024 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.026 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.056 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.026 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.071 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.041 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.044 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.038 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.061 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.027 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.023 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.034 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.052 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.132 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.044 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.051 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.053 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.051 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.053 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.012 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.023 |  |  |  |  | MONTH | 0.03 | 2021
 | 0.03 | 0.021 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.027 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.03 |  |  |  |  |  | 0.03 | 2021
 | 0.03 | 0.073 |  |  |  |  | MONTH | 0.03 | 2021
1 | 0.03 | 0.0587 |  |  |  |  | MONTH | 0.03 | 2022
2 | 0.03 | 0.0267 |  |  |  |  |  | 0.03 | 2022
3 | 0.03 | 0.0293 |  |  |  |  |  | 0.03 | 2022
4 | 0.03 | 0.1139 |  |  |  |  |  | 0.03 | 2022
5 | 0.03 | 0.0449 |  |  |  |  |  | 0.03 | 2022
6 | 0.03 | 0.0285 |  |  |  |  | MONTH | 0.03 | 2022
7 | 0.03 | 0.0227 |  |  |  |  |  | 0.03 | 2022
8 | 0.03 | 0.0181 |  |  |  |  |  | 0.03 | 2022
9 | 0.03 | 0.0223 |  |  |  |  |  | 0.03 | 2022
10 | 0.03 | 0.016 |  |  |  |  | MONTH | 0.03 | 2022
11 | 0.03
12 | 0.03
13 | 0.03
14 | 0.03
15 | 0.03
16 | 0.03
17 | 0.03
18 | 0.03
19 | 0.03
20 | 0.03
21 | 0.03
22 | 0.03
23 | 0.03
24 | 0.03
25 | 0.03
26 | 0.03
27 | 0.03
28 | 0.03
29 | 0.03
30 | 0.03
31 | 0.03
32 | 0.03
33 | 0.03
34 | 0.03
35 | 0.03
36 | 0.03
37 | 0.03
38 | 0.03
39 | 0.03
40 | 0.03
41 | 0.03
42 | 0.03
43 | 0.03
44 | 0.03 |  |  |  |  | NOV
45 | 0.03 | 0.0838 |  |  |  | NOV |  | 0.03 | 2022
46 | 0.03 | 0.0127 |  |  |  | NOV |  | 0.03 | 2022
47 | 0.03 | 0.0178830352827453 |  |  |  | NOV |  | 0.03 | 2022
48 | 0.03 | 0.0244 |  |  |  | NOV | MONTH | 0.03 | 2022
49 | 0.03 | 0.0269 |  |  |  | DEC |  | 0.03 | 2022
50 | 0.03 | 0.0059 |  |  |  | DEC |  | 0.03 | 2022
51 | 0.03 | 0.0644 |  |  |  | DEC |  | 0.03 | 2022
52 | 0.03 |  |  |  |  | DEC | MONTH | 0.03
53 (1) | 0.03 | 0.0181 |  |  |  |  | Jan |  | 2023
54 (2) | 0.03 | 0.0118 |  |  |  |  | Jan |  | 2023
55 (3) | 0.03 | 0.0226 |  |  |  |  | Jan |  | 2023
56 (4) | 0.03 | 0.0163 |  |  |  | Jan | Jan
5 | 0.03 | 0.0291 |  |  |  |  | Feb
6 | 0.03 | 0.0153 |  |  |  |  | Feb
7 | 0.03 | 0.0094 |  |  |  |  | Feb
8 | 0.03 | 0.028 |  |  |  |  | Feb
9 | 0.03 | 0.0223 |  |  |  | Feb | Feb
10 | 0.03 | 0.0152 |  |  |  |  | March
11 | 0.03 | 0.0321 |  |  |  |  | March
12 | 0.03 | 0.0464 |  |  |  |  | March
13 | 0.03 | 0.0089 |  |  |  | March | March
14 | 0.03 | 0.0093 |  |  |  |  | April
15 | 0.03 | 0.0197 |  |  |  |  | April
16 | 0.03 | 0.0094 |  |  |  |  | April
17 | 0.03 | 0.0067 |  |  |  | April | April
18 | 0.03 | 0.0144 |  |  |  |  | May
19 | 0.03 | 0.0197 |  |  |  |  | May
20 | 0.03 | 0.0238 |  |  |  |  | May
21 | 0.03 | 0.0096 |  |  |  |  | May |  |  |  | J15 | D15
22 | 0.03 | 0.0256 |  |  |  | May | May |  |  | 2023 Week | [NAME] time (Mins) | Maintenance D/Time (Mins)
23 | 0.03 | 0.0326 |  |  |  |  | June |  |  | 23
24 | 0.03 | 0.0461 |  |  |  |  | June |  |  | 24
25 | 0.03 | 0.0166 |  |  |  | June | June |  | June | 25
26 | 0.03 | 0.0478 |  |  |  | June | June |  |  | 26 | 4730 | 226
27 | 0.03 | 0.0309 |  |  |  | July | July |  | June | 27 | 5340 | 165
28 | 0.03 | 0.0117 |  |  |  |  | July |  | June | 28 | 5315 | 62
29 | 0.03 | 0.0323 |  |  |  |  | July |  |  | 29 | 5390 | 174
30 | 0.03 | 0.041 |  |  |  | July | July |  |  | 30 | 5615 | 230
31 | 0.03 | 0.0122 |  |  |  | August | August |  |  | 31 | 5430 | 66
32 | 0.03 | 0.0109 |  |  |  |  | August |  |  | 32
33 | 0.03 | 0.0338 |  |  |  |  | August |  |  | 33
34 | 0.03 | 0.0225 |  |  |  |  | August |  |  | 34
35 | 0.03 | 0.0226 |  |  |  | August | August |  |  | 35
36 | 0.03 | 0.0511 |  |  |  | September | September |  |  | 36
37 | 0.03 | 0.0253 |  |  |  |  | September |  |  | 37
38 | 0.03 | 0.0234 |  |  |  |  | September |  |  | 38
39 | 0.03 | 0.0266 |  |  |  | September | September |  |  | 39
40 | 0.03 | 0.0289 |  |  |  | October | October |  |  | 40
41 | 0.03 | 0.0163 |  |  |  |  | October |  |  | 41
42 | 0.03 | 0.0397 |  |  |  |  | October |  |  | 42
43 | 0.03 | 0.0157 |  |  |  |  | October |  |  | 43
44 | 0.03 | 0.0089 |  |  |  | November | November |  |  | 44
45 | 0.03 | 0.0053 |  |  |  |  | November |  |  | 45
46 | 0.03 | 0.0255 |  |  |  |  | November |  |  | 46
47 | 0.03 | 0.0171 |  |  |  |  | November |  |  | 47
48 | 0.03 | 0.0125 |  |  |  |  | November |  |  | 48
49 | 0.03 | 0.0208 |  |  |  | December | December |  |  | 49
50 | 0.03 | 0.0188 |  |  |  |  | December |  |  | 50
51 | 0.03 | 0.0211 |  |  |  |  | December |  |  | 51
52 | 0.03 | 0.0127 |  |  |  |  | December |  |  | 52
53 | 0.03 | 0.056 |  |  |  |  | December |  |  | 53
1 | 0.03 | 0.0302 |  |  |  | January | January |  | 2024
2 | 0.03 | 0.0547 |  |  |  |  | January |  | 2024
3 | 0.03 | 0.029 |  |  |  |  | January |  | 2024
4 | 0.03 | 0.0076 |  |  |  |  | January |  | 2024
5 | 0.03 | 0.0134 |  |  |  |  | January |  | 2024
6 | 0.03 | 0.0276 |  |  |  | February | February |  | 2024
7 | 0.03 | 0.0209 |  |  |  |  | February |  | 2024
8 | 0.03 | 0.0158 |  |  |  |  | February |  | 2024
9 | 0.03 | 0.0165
10 | 0.03 | 0.025
11 | 0.03 | 0.0125
12 | 0.03 | 0.0219
13 | 0.03 | 0.0119
14 | 0.03 | 0.0414
15 | 0.03 | 0.0229
16 | 0.03
17
18
19
20
21
22
23
24
25
26
27
 |  | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Whole Factory
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL D/Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All site |  |  | Mins | %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Week |  | Maintenance D/Time % | Average YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  | 0.0295 |  |  | 17774 | 0.1445
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 0.0271 |  |  | 15405 | 0.1053
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 0.0314 |  |  | 19106 | 0.1224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 0.0307 |  |  | 16718 | 0.1074
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 0.0192 |  |  | 17292 | 0.1104
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  | 0.0275 |  |  | 19235 | 0.1281
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 0.0202 |  |  | 21660 | 0.1027
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 0.0196 |  |  | 18942 | 0.1207
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  | 0.0324 |  |  | 24171 | 0.1535
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  | 0.0421 |  |  | 24625 | 0.1634
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  | 0.0266 |  |  | 22001 | 0.1434
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  | 0.0195 |  |  | 18341 | 0.1167
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 0.0225 |  |  | 21369 | 0.1447
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  | 0.0162 |  |  | 21191 | 0.1378
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | 0.0273 |  |  | 23375 | 0.1544
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  | 0.0225 |  |  | 23964 | 0.1527
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  | 0.0303 |  |  | 23789 | 0.1459
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 |  | 0.0192 |  |  | 18727 | 0.117
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 |  | 0.0158 |  |  | 20154 | 0.135
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  | 0.0188 |  |  | 20363 | 0.1354
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  | 0.0203 |  |  | 31923 | 0.1679
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  | 0.0199 |  |  | 43566 | 0.1728
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  | 0.026 |  |  | 64459 | 0.2106
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  | 0.0175 |  |  | 15051 | 0.1006
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 0.0193 |  |  | 18284 | 0.1192
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  | 0.015 |  |  | 12781 | 0.0883
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 |  | 0.0219 |  |  | 16547 | 0.1189
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 |  | 0.0175 |  |  | 18119 | 0.1266
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  | 0.0243 |  |  | 17698 | 0.1267
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 0.0249 |  |  | 16805 | 0.1159
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  | 0.0388 |  |  | 19062 | 0.1509
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  | 0.0252 |  |  | 15721 | 0.1127
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  | 0.0366 |  |  | 19616 | 0.1478
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  | 0.0503 |  |  | 20503 | 0.1544
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  | 0.0498 |  |  | 19713 | 0.1512
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 |  | 0.0366 |  |  | 16912 | 0.1357
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  | 0.0252 |  |  | 16339 | 0.1355
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 |  | 0.0385 |  |  | 15694 | 0.1258
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  | 0.038 |  |  | 17463 | 0.1433
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 |  | 0.0409 |  |  | 17192 | 0.1437
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 |  | 0.0188 |  |  | 16405 | 0.1342
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 |  | 0.0237 |  |  | 16044 | 0.1372
 | Month | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 |  | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 |  | 43 |  | 0.023 |  |  | 15330 | 0.1231
 | DT % | 0.029 | 0.024 |  | 0.028 | 0.024 | 0.02 | 0.02 | 0.022 | 0.04 | 0.035 | 0.027 | 0.024 |  | 44 |  | 0.0347 |  |  | 10487 | 0.087
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 |  | 0.0316 |  |  | 10468 | 0.0872
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 |  | 0.0129 |  |  | 8342 | 0.0411
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 |  | 0.0188 |  |  | 8322 | 0.0389
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 |  | 0.0204 |  |  | 8506 | 0.0404
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52