Spreadsheet: 889514d1740364343-special-function-cell-to-generate-graphs-automatically-for-certain-week-ranges-tool-downtime-4-
Sheet: Data and Graphs

ID | Year | WW | Factory MA | SDUT | 13 Week MA AVE | 13 Week SDUT AVE | SDUT/MA Difference | SDUT Comment | Factory MA reason below 80% | Factory Reference | Reference |  | Week | 8 | Year | 2025
46 | 2024 | 46 | 0.93 | 0.9507 | 0.803 | 0.9066 |  |  |  | 0.8 | 0.9
47 | 2024 | 47 | 0.84 | 0.78 | 0.774 | 0.8979 |  |  |  | 0.8 | 0.9
48 | 2024 | 48 | 0.88 | 0.85 | 0.7836 | 0.9034 |  |  |  | 0.8 | 0.9
49 | 2024 | 49 | 0.82 | 0.85 | 0.8016 | 0.9108 |  |  |  | 0.8 | 0.9
50 | 2024 | 50 | 0.87 | 0.89 | 0.8155 | 0.9132 |  |  |  | 0.8 | 0.9
51 | 2024 | 51 | 0.8202 | 0.85 | 0.8089 | 0.9094 |  |  |  | 0.8 | 0.9
52 | 2024 | 52 | 0.76 | 0.77 | 0.7864 | 0.9019 |  |  |  | 0.8 | 0.9
53 | 2025 | 1 | 0.88 | 0.9 | 0.7737 | 0.9011 |  |  |  | 0.8 | 0.9
54 | 2025 | 2 | 0.76 | 0.81 | 0.7668 | 0.9053 |  |  |  | 0.8 | 0.9
55 | 2025 | 3 | 0.61 | 0.75 | 0.7438 | 0.898 |  |  |  | 0.8 | 0.9
56 | 2025 | 4 | 0.43 | 0.55 | 0.7466 | 0.8929 |  |  |  | 0.8 | 0.9
57 | 2025 | 5 | 0.78 | 0.98 | 0.7668 | 0.8967 |  |  |  | 0.8 | 0.9
58 | 2025 | 6 | 0.7207 | 0.56 | 0.7704 | 0.8969 |  |  |  | 0.8 | 0.9
58 | 2025 | 7 | 0.88 | 0.65 | 0.755 | 0.8904 |  |  |  | 0.8 | 0.9
58 | 2025 | 8 | 0.93 | 0.9507 | 0.803 | 0.9066 |  |  |  | 0.8 | 0.9
58 | 2025 | 9 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 10 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 11 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 12 |  |  |  |  |  |  |  | 0.8 | 0.9 | [NAME] | Factory MA | SDUT | SDUT/MA Difference | SDUT Off 100%
58 | 2025 | 13 |  |  |  |  |  |  |  | 0.8 | 0.9 | 4 Week Average
58 | 2025 | 14 |  |  |  |  |  |  |  | 0.8 | 0.9 | 13 Week Average
58 | 2025 | 15 |  |  |  |  |  |  |  | 0.8 | 0.9 | All  Weeks
58 | 2025 | 16 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 17 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 18 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 19 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 20 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 21 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 35 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 36 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 37 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 38 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 39 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 40 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 41 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 42 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 43 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 44 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 45 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 46 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 47 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 48 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 49 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 50 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 51 |  |  |  |  |  |  |  | 0.8 | 0.9
58 | 2025 | 52 |  |  |  |  |  |  |  | 0.8 | 0.9
[NAME] | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507 | Total
Entity | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT | SDUT
1 | 0.67 | 0.979 | 0.983 | 0.931 | 1 | 0.999 | 0.978 | 0.884 | 0.965 | 1 | 1 | 1 | 0.969 | 0.924
2 | 0.66 | 0.614 | 0.946 | 0.791 | 0.974 | 0.254 | 0.967 | 0.619 | 0.046 | 1 | 0.66 | 0 | 0 | 0.562
3 | 0.97 | 0.974 | 0.254 | 0.967 | 0.465 | 0.965 | 0.997 | 0.974 | 0.254 | 0.967 | 0.511 | 0.935 | 0.999 | 0.797
4 | 0.78 | 0.979 | 0.983 | 0.931 | 0.994 | 0.657 | 0.93 | 0.979 | 0.983 | 0.931 | 0.98 | 0.971 | 0.95 | 0.95
5 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.56 | 0.251
6 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.45 | 0.416
7 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.67 | 0.013
Total | 0.477 | 0.51 | 0.544 | 0.51 | 0.49 | 0.427 | 0.586 | 0.554 | 0.46 | 0.7 | 0.706 | 0.616 | 0.613 | 0.554
[NAME] | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507 | Total
Entity | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA | Factory MA
1 | 0.199 | 0.979 | 0.983 | 0.931 | 1 | 0.999 | 0.971 | 0.797 | 0.958 | 1 | 0.937 | 1 | 0.969 | 0.902
2 | 0.308 | 0.614 | 0.931 | 0.791 | 0.974 | 0.254 | 0.967 | 0.614 | 0 | 0 | 0 | 0 | 0 | 0.419
3 | 0.822 | 1 | 0.878 | 0.847 | 0.428 | 0.965 | 0.997 | 0.967 | 0.813 | 0 | 0.511 | 0.935 | 0.999 | 0.782
4 | 0.797 | 0.977 | 0.998 | 1 | 0.88 | 0.631 | 0.93 | 0.993 | 0.995 | 0.943 | 0.98 | 0.948 | 0.95 | 0.925
5 | 0.309 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.091 | 0.74 | 0.842 | 0.446 | 0.706 | 0.23
6 | 0 | 0 | 0 | 0 | 0 | 0 | 0.228 | 0.255 | 0.677 | 0.9 | 0.951 | 0.96 | 0.629 | 0.393
7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.04 | 0.003
Total | 0.348 | 0.51 | 0.542 | 0.51 | 0.469 | 0.407 | 0.585 | 0.518 | 0.453 | 0.56 | 0.603 | 0.613 | 0.613 | 0.517
SDUT
Total Hrs | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507
1
2
3
4
5
6
7
Amendment | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507
1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
5
6
7
FINAL HOURS | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507
1
2
3
4
5
6
7
FINAL SDUT | 202447 | 202448 | 202449 | 202450 | 202451 | 202452 | 202501 | 202502 | 202503 | 202504 | 202505 | 202506 | 202507 | Averages
1
2
3
4
5
6
7
AVG