Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: Complaints Log 2022

 |  |  | All Complaints |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | %Late |  |  |  |  |  |  |  |  |  |  |  |  | This Week
 |  |  | Open Complaints |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Min Time |  | %Ontime
 |  |  | Open Late |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average |  | %Open
 |  |  | Late
Comp number | Period | Date received | Product Code | Product Name | Batch | Quantity | Customer | Site | Customer Reference number | Contact | Comments / extra info | Cost | Complaint  Top category | Complaint Sub Category | Product to be returned? | Sample to be returned? | Sample Received Date | Logged onto [NAME] | Root cause Required  Y/ N | Report / Root cause [NAME] | Customer required date | Due Date | [NAME] | [NAME] | Planning Response | Production Response | [NAME] | NPD Response | Technical Response | Transport/Warehouse Response | Final Response | Non-Con No | Completed | Signed off | Acceptance Received | Time Days | Status | Credit Required | Credit Amount | Credit Cost | Credit Authorised | Credit Issued and Sent | Signed off by | Replacement Required | Replacement Amount | Replacement Cost | Replacement Authorised | Replacement Issued and Sent | Signed off by | Open | Week | Month | Year
2201 | 1 | 2022-01-05 00:00:00 | E221 |  | 84345 | 25kg |  |  | 340791 |  |  |  | Order Error | Picking error | No | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-11 00:00:00 | LA
2202 | 1 | 2022-01-06 00:00:00 | XKF-W-200460A81 |  | 220976/ 220977/ 22077/22078 | 15KG |  |  | 6318741 |  |  |  | [NAME] | [NAME] | Yes | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-11 00:00:00 | LA
2203 | 1 | 2022-01-07 00:00:00 | XFK-J-170354 |  | 220438 | 5 x 25Kg |  |  | rpo125395 |  |  |  | Quality | Incorrect Shelf Life | Yes | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-14 00:00:00 | LA
2204 | 1 | 2022-01-05 00:00:00 | XT/F10329A47 |  | 220968 |  |  |  | [NAME] |  |  |  | Transport | Damage |  | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-11 00:00:00 | SD
2205 | 1 | 2022-01-10 00:00:00 | XHF30825B81 |  | 221027 | 676.8kg |  |  | 23065 |  |  |  | Quality | Product not comparable | Yes | Yes | 2022-01-12 00:00:00 | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-12 00:00:00
2206 | 1 | 2022-01-04 00:00:00 | XHFA33846115 |  | 220575 | TBC |  |  | 290456 |  |  |  | Quality | Underweight | Yes | Yes | 2022-01-09 00:00:00 | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-20 00:00:00 | GE |  |  |  |  | 3kg
2207 | 1 | 2022-01-12 00:00:00 | XECHALCTS-3100 |  | 220307 | 500 SAC |  |  | Plan 29/11/21 |  |  |  | Packaging | [NAME] | No | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-14 00:00:00
2208 | 1 | 2022-01-11 00:00:00 | XT/F31045B47 |  | 212990 | TBC |  |  | 4512393625 |  |  |  | Quality | Product not comparable | No | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-21 00:00:00 | LA
2209 | 1 | 2022-01-17 00:00:00 | XT/F12934A23 |  | 216412 | 1 |  |  | 25299 |  |  |  | Other | Short Delivery | No | No |  | No | No |  |  |  |  |  | N/A | N/A | N/A | N/A | N/A |  |  |  | 2022-01-21 00:00:00 | SD
2210 | 1 | 2022-01-24 00:00:00 | XECCGM-347 |  | 221272 | 1 |  |  | 18970 |  |  |  | Transport | Damage | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-03 00:00:00 | SD |  |  |  | Yes | Yes 1 Bag
2211 | 1 | 2022-01-25 00:00:00 | [NAME] |  | 83844 +  84784 | 250kg |  |  | N/A |  |  |  | Order Error | Processing error | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-01 00:00:00 | LA |  |  |  | Yes
2212 | 1 | 2022-01-27 00:00:00 | xt/f22089c81 |  | 220426 | TBC |  |  | PO300733 |  |  |  | Order Error | Processing error | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-02 00:00:00 | LA
2213 | 1 | 2022-01-28 00:00:00 | XT/F4427A47 |  | 221950 + 221951 | 54.45kg |  |  | 26817 |  |  |  | Transport | Damage | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-08 00:00:00 | SD |  |  |  | Yes
2214 | 1 | 2022-01-28 00:00:00 | XT/F21514A47 |  | 2135093 | 400kg |  |  | N/A |  |  |  | Quality | Product not comparable | Yes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-04 00:00:00 | LA
2215 | 1 | 2022-01-28 00:00:00 | XT/F20374H81 |  | 219718 + 213719 | 11250 |  |  | 4503127778 |  |  |  | Quality | Incorrect Shelf Life | Yes | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-03 00:00:00 | SD
2216 | 2 | 2022-02-03 00:00:00 | XFK-M-19049447 |  | 220824 |  |  |  | N/A |  |  |  | Foreign Body | Other | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-02-04 00:00:00 | SD
2217 | 2 | 2022-02-02 00:00:00 | XT/F15067A10 |  | 216817 | 10 Units |  |  | 971464/0 |  |  |  | Order Error | Short | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | 113.6
2218 | 2 | 2022-02-07 00:00:00 | XT/F1883713 |  | 220029 | 16kg |  |  |  |  |  |  | Foreign Body | Other
2219 | 2 | 2022-02-08 00:00:00 | X325 |  | 13657 | TBC |  |  | 310419 |  |  |  | Order Error | Incorrect shelf life