Spreadsheet: 837113d1689863731-conditional-format-summary-total-book3-v2-2-
Sheet: Sheet3

 |  |  | Week 1 | Week 2 | Week 3 | Week 4+
 |  | Target | 25 | 50 | 75 | 85 |  |  |  | Red
 |  |  |  |  |  |  |  |  |  | Black
 |  | red | 0 | 1 | 2 | 7
 |  | black | 3 | 5 | 14 | 15
Induction Date | ID Number | Area | 2023-05-29 00:00:00 | 2023-06-05 00:00:00 | 2023-06-12 00:00:00 | 2023-06-19 00:00:00 | 2023-06-26 00:00:00 | 2023-07-03 00:00:00 | 2023-07-10 00:00:00
2023-05-29 00:00:00 | 1122349942 | Mezz | 51 | 74 | 75 | 107 | 87 |  | 99
2023-05-29 00:00:00 | 936053880 | Mezz | 56 | 81 | 86 | 106 | 99 | 89 | 93
2023-05-29 00:00:00 | 270096300 | Mezz | 34 | 49 | 65 | 60 | 57 | 58 | 70
2023-06-05 00:00:00 | 940684434 | Mezz |  | 25 | 46 | 52 | 61 |  | 82
2023-06-05 00:00:00 | 622768821 | Mezz |  | 30 | 60 | 72 | 84 | 82 | 79
2023-06-05 00:00:00 | 1118626004 | Mezz |  | 30 | 65 | 65 | 70 | 79 | 90
2023-06-12 00:00:00 | 1071082624 | Mezz |  |  | 54 | 73 | 62 | 69 | 72
2023-06-12 00:00:00 | 1169967366 | Mezz |  |  | 36 | 45 | 55 | 65 | 60
2023-06-12 00:00:00 | 1169807520 | Mezz |  |  | 36 | 45 | 53 | 61 | 66
2023-06-12 00:00:00 | 686628478 | Mezz |  |  | 44 | 46 | 50 | 46 | 62
2023-06-12 00:00:00 | 1015889856 | Mezz |  |  | 42 | 58 | 71 | 77 | 83
2023-06-12 00:00:00 | 1164055544 | HB2 |  |  | 45 | 59 | 54 | 65 | 67
2023-06-12 00:00:00 | 304507814 | HB2 |  |  | 52 | 62 | 142 | 75
2023-06-12 00:00:00 | 1158062774 | HB2 |  |  | 56 | 56 | 87
2023-06-12 00:00:00 | 379335048 | HB2 |  |  | 54 | 61 | 131
2023-06-12 00:00:00 | 379133574 | HB2 |  |  | 39 | 57 | 49 | 48 | 51
2023-06-19 00:00:00 | 1177110238 | HB2 |  |  |  | 37 | 48 | 59 | 66
2023-06-19 00:00:00 | 864268082 | HB2 |  |  |  | 35 | 53 | 314 | 49
2023-06-19 00:00:00 | 1079216224 | HB2 |  |  |  | 41 | 56 | 49 | 47
2023-06-19 00:00:00 | 1176678044 | Mezz |  |  |  | 63 | 79 | 87 | 113
2023-06-19 00:00:00 | 681006806 | Mezz |  |  |  | 35 | 50 | 46 | 42
2023-06-19 00:00:00 | 1158062408 | Mezz |  |  |  | 49 | 69 | 76 | 72
2023-06-26 00:00:00 | 1020601724 | Intake |  |  |  |  | 46 | 58
2023-06-26 00:00:00 | 1180112680 | Intake |  |  |  |  | 80 | 88 | 88
2023-06-26 00:00:00 | 793753280 | Intake |  |  |  |  | 38 | 50 | 67
2023-06-26 00:00:00 | 1179773062 | Mezz |  |  |  |  | 80 | 94 | 83
2023-06-26 00:00:00 | 1111294608 | Mezz |  |  |  |  | 33 | 45 | 46
2023-06-26 00:00:00 | 1085206106 | Mezz |  |  |  |  | 97 | 68 | 89
2023-06-26 00:00:00 | 1180376904 | HB2 |  |  |  |  | 37 | 33
2023-06-26 00:00:00 | 254823910 | HB2 |  |  |  |  | 54 | 75 | 78
2023-06-26 00:00:00 | 1174063760 | HB2 |  |  |  |  | 58 | 62
2023-06-26 00:00:00 | 1168966876 | HB2 |  |  |  |  | 66 | 67 | 82
2023-06-26 00:00:00 | 1116093156 | HB2 |  |  |  |  | 48 | 40
2023-06-26 00:00:00 | 1177389322 | Mezz |  |  |  |  | 41 | 62 | 77
2023-06-26 00:00:00 | 1126351016 | Mezz |  |  |  |  | 49 | 70 | 78
2023-06-26 00:00:00 | 1182689818 | Mezz |  |  |  |  | 43 | 61 | 64
2023-06-26 00:00:00 | 259718456 | Intake |  |  |  |  | 124 | 128 | 80
2023-06-26 00:00:00 | 323793916 | Intake |  |  |  |  | 53 | 107 | 72
2023-06-26 00:00:00 | 1170281270 | Intake |  |  |  |  | 56 | 127 | 88
2023-07-03 00:00:00 | 1184788122 | HB2 |  |  |  |  |  | 38
2023-07-03 00:00:00 | 1138886760 | HB2 |  |  |  |  |  | 37
2023-07-03 00:00:00 | 827938734 | Intake |  |  |  |  |  | 57 | 80
2023-07-03 00:00:00 | 1014174868 | Intake |  |  |  |  |  | 58 | 82
2023-07-03 00:00:00 | 1009143596 | Intake |  |  |  |  |  | 54 | 88
2023-07-03 00:00:00 | 1184608394 | Intake |  |  |  |  |  | 72 | 89
2023-07-03 00:00:00 | 362895852 | Intake |  |  |  |  |  | 35 | 58
2023-07-03 00:00:00 | 1104171924 | Intake |  |  |  |  |  | 46 | 55
2023-07-03 00:00:00 | 647986116 | Intake |  |  |  |  |  | 36 | 79
2023-07-03 00:00:00 | 1187069716 | Intake |  |  |  |  |  | 51 | 58
2023-07-10 00:00:00 | 556860622 | Despatch |  |  |  |  |  |  | 16
2023-07-10 00:00:00 | 630858160 | Despatch |  |  |  |  |  |  | 39
2023-07-10 00:00:00 | 1102745968 | Despatch |  |  |  |  |  |  | 25
2023-07-10 00:00:00 | 1186236334 | Mezz |  |  |  |  |  |  | 42
2023-07-10 00:00:00 | 1162577730 | Mezz |  |  |  |  |  |  | 50
2023-07-10 00:00:00 | 956321114 | Mezz |  |  |  |  |  |  | 41