Spreadsheet: 854723d1704485740-conditional-format-highest-value-in-previous-28-cells-receipted_for_forum
Sheet: RAW DATA

DAY | DATE | RETURNS SINGLE | RETURNS TRAY SET | RETURNS TOTAL | RETURNS SINGLE INSTRUMENTS | RETURNS TRAY SET INSTRUMENTS | RETURNS INSTRUMENTS TOTAL | DESPATCH SINGLE | DESPATCH TRAY SET | DESPATCH TOTAL | DESPATCH SINGLE INSTRUMENTS | DESPATCH TRAY SET INSTRUMENTS | DESPATCH TRAY SET TOTAL | N/C DIRTY | N/C BYPASSED | N/C RUSTY | N/C TOTAL | ALL PRIORITY (Mon - Sun) |  | PRIORITIES <24HRS | % PRIORITIES RETURNED <24HRS | % PRIORITIES <24HRS | [NAME] | [NAME] | Items in [NAME] | Expected Items | Clean Tech | Clean Man Hours | [NAME] | Expected Items
 | 2023-12-06 00:00:00 | 199 | 498 |  | 235 | 15804 |  | 213 | 516 |  | 225 | 18017 |  | 15 | 1 | 4 |  |  |  |  |  |  | 21.5 |  | 22623 |  | 31.38 |  |  |  |  | PM | 16 |  | 6
 | 2023-12-07 00:00:00 | 418 | 576 |  | 491 | 16777 |  | 136 | 528 |  | 162 | 18623 |  | 11 | 4 | 7 |  |  |  |  |  |  | 25 |  | 20169 |  | 41.44 |  |  |  |  | N | 9 |  | 8
 | 2023-12-08 00:00:00 | 76 | 489 |  | 100 | 15271 |  | 291 | 593 |  | 319 | 19880 |  | 11 | 4 | 7 |  |  |  |  |  |  | 22 |  | 18459 |  | 51.88 |  |  |  |  | O/T
 | 2023-12-09 00:00:00 | 203 | 495 |  | 215 | 14825 |  | 136 | 494 |  | 202 | 14928 |  | 16 | 6 | 2 |  |  |  |  |  |  | 12.75 |  | 16690 |  | 27.38
 | 2023-12-10 00:00:00 | 77 | 240 |  | 104 | 7798 |  | 138 | 245 |  | 157 | 8552 |  | 13 | 3 | 3 |  | 569 |  | 342 |  |  | 10 |  | 7172 |  | 13.5
 | 2023-12-11 00:00:00 | 104 | 310 |  | 142 | 11028 |  | 110 | 322 |  | 122 | 9803 |  | 4 | 0 | 4 |  |  |  |  |  |  | 15 |  | 10068 |  | 26.31 |  |  |  |  | Technicians ([NAME]) |  |  | Wash | Clean |  | Wash OT Hours |  |  | Clean OT Hours
 | 2023-12-12 00:00:00 | 107 | 450 |  | 131 | 15620 |  | 105 | 335 |  | 143 | 11993 |  | 15 | 8 | 3 |  |  |  |  |  |  | 16 |  | 16134 |  | 28.25 |  |  |  |  | AM | 3 |  | 0
 | 2023-12-13 00:00:00 | 221 | 308 |  | 306 | 14566 |  | 165 | 470 |  | 201 | 14615 |  | 30 | 9 | 1 |  |  |  |  |  |  | 16.5 |  | 15056 |  | 36.5 |  |  |  |  | PM | 5 |  | 0
 | 2023-12-14 00:00:00 | 218 | 443 |  | 301 | 12728 |  | 130 | 379 |  | 144 | 14188 |  | 12 | 2 | 4 |  |  |  |  |  |  | 22 |  | 21897 |  | 31.13 |  |  |  |  | N | 3 |  | 0
 | 2023-12-15 00:00:00 | 134 | 420 |  | 140 | 17323 |  | 263 | 551 |  | 308 | 20124 |  | 11 | 12 | 2 |  |  |  |  |  |  | 25 |  | 15912 |  | 37.5 |  |  |  |  | O/T
 | 2023-12-16 00:00:00 | 132 | 511 |  | 155 | 14861 |  | 151 | 373 |  | 163 | 11521 |  | 11 | 3 | 3 |  |  |  |  |  |  | 18.25 |  | 17950 |  | 60.85
 | 2023-12-17 00:00:00 | 55 | 296 |  | 69 | 11323 |  | 84 | 335 |  | 101 | 13821 |  | 6 | 1 | 3 |  | 650 |  | 345 |  |  | 13.5 |  | 11987 |  | 16.94
 | 2023-12-18 00:00:00 | 199 | 501 |  | 237 | 16662 |  | 199 | 434 |  | 226 | 14297 |  | 16 | 7 | 7 |  |  |  |  |  |  | 23.75 |  | 17857 |  | 31.63
 | 2023-12-19 00:00:00 | 138 | 566 |  | 194 | 16815 |  | 192 | 454 |  | 273 | 14898 |  | 12 | 2 | 1 |  |  |  |  |  |  | 23 |  | 17640 |  | 37.25
 | 2023-12-20 00:00:00 | 266 | 470 |  | 333 | 14333 |  | 194 | 510 |  | 215 | 14485 |  | 15 | 1 | 3 |  |  |  |  |  |  | 20 |  | 15718 |  | 43.06
 | 2023-12-21 00:00:00 | 121 | 440 |  | 129 | 12737 |  | 243 | 513 |  | 337 | 14670 |  | 12 | 1 | 2 |  |  |  |  |  |  | 22 |  | 15329 |  | 47.25
 | 2023-12-22 00:00:00 | 282 | 491 |  | 312 | 18079 |  | 189 | 447 |  | 197 | 13561 |  | 15 | 3 | 1 |  |  |  |  |  |  | 21 |  | 18224 |  | 42.44
 | 2023-12-23 00:00:00 | 61 | 204 |  | 71 | 5732 |  | 160 | 340 |  | 166 | 11138 |  | 7 | 1 | 6 |  |  |  |  |  |  | 9 |  | 12761 |  | 12.69
 | 2023-12-24 00:00:00 | 17 | 93 |  | 17 | 4900 |  | 126 | 270 |  | 134 | 9094 |  | 9 | 7 | 0 |  | 219 |  | 108 |  |  | 3 |  | 3184 |  | 16.63
 | 2023-12-25 00:00:00 | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | 2023-12-26 00:00:00 | 1 | 21 |  | 32 | 3078 |  | 18 | 127 |  | 32 | 3513 |  | 4 | 0 | 1 |  |  |  |  |  |  | 0.5 |  | 3904 |  | 1.5
 | 2023-12-27 00:00:00 | 74 | 338 |  | 106 | 13478 |  | 81 | 380 |  | 96 | 15091 |  | 9 | 5 | 1 |  |  |  |  |  |  | 24 |  | 18728 |  | 40
 | 2023-12-28 00:00:00 | 101 | 470 |  | 111 | 17810 |  | 92 | 315 |  | 92 | 13364 |  | 11 | 8 | 5 |  |  |  |  |  |  | 16 |  | 17983 |  | 43
 | 2023-12-29 00:00:00 | 141 | 363 |  | 148 | 13874 |  | 188 | 469 |  | 218 | 17784 |  | 20 | 1 | 3 |  |  |  |  |  |  | 16 |  | 15482 |  | 38
 | 2023-12-30 00:00:00 | 56 | 88 |  | 56 | 3046 |  | 106 | 328 |  | 133 | 13802 |  | 15 | 6 | 1 |  |  |  |  |  |  | 3 |  | 13630 |  | 35
 | 2023-12-31 00:00:00 | 9 | 62 |  | 11 | 3297 |  | 91 | 310 |  | 103 | 7849 |  | 7 | 5 | 3 |  | 115 |  | 65 |  |  | 0 |  | 1566 |  | 10
 | 2024-01-01 00:00:00 | 9 | 42 |  | 9 | 2781 |  | 70 | 103 |  | 70 | 4100 |  | 0 | 3 | 0 |  |  |  |  |  |  | 0 |  | 2345 |  | 4
 | 2024-01-02 00:00:00 | 154 | 376 |  | 160 | 13699 |  | 106 | 199 |  | 108 | 10040 |  | 4 | 1 | 1 |  |  |  |  |  |  | 15 |  | 11687 |  | 24
 | 2024-01-03 00:00:00 | 169 | 579 |  | 178 | 19059 |  | 164 | 373 |  | 170 | 11787 |  | 4 | 2 | 0 |  |  |  |  |  |  | 15 |  | 16656 |  | 39
 | 2024-01-04 00:00:00 | 175 | 461 |  | 181 | 14520 |  | 81 | 430 |  | 92 | 14607 |  | 11 | 2 | 3 |  |  |  |  |  |  | 19 |  | 17429 |  | 43
 | 2024-01-05 00:00:00
 | 2024-01-06 00:00:00
 | 2024-01-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 |  | 50
 | 2024-01-08 00:00:00
 | 2024-01-09 00:00:00
 | 2024-01-10 00:00:00
 | 2024-01-11 00:00:00
 | 2024-01-12 00:00:00
 | 2024-01-13 00:00:00