Spreadsheet: 842295d1694424376-how-to-return-a-value-based-on-2-criteria-a3-problem-solving-log
Sheet: Log

A3 # | Area | Open Date | Details of Issue | Supporting Images [if applicable] | Team |  | 1. Define The Problem |  | 2. Protect the Customer [Internal / External | Root Cause  Analysis & Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Permanent Corrective Action | 5. Verification of Action | Close Date
23-XXX |  | 2023-09-06 00:00:00 | Enter details of reported issue |  | Operations Lead |  | WHAT |  | Internal  & External Customers: - Does WIP material need sorting - Does product in stores require sorting - Define sorting criteria to conduct sort - Is a Quality Alert required to provide communication - Is there a need for ongoing protection of internal / external customer(s). | Material | A1 |  |  | A2 |  |  | A3 |  |  | A4 |  |  | A5 |  |  | Summarise the root cause of the issue | This is sample corrective action | [NAME] how corrective action veriifed as effective
 |  |  |  |  | Operator |  |  |  |  | Method | B1 |  |  | B2 |  |  | B3 |  |  | B4 |  |  | B5
 |  |  |  |  | Quality Lead |  | WHERE |  |  | Machine | C1 |  |  | C2 |  |  | [NAME] |  |  | C4 |  |  | C5
 |  |  |  |  | Manuf Engineer |  | WHY |  |  | Measurement | D1 |  |  | D2 |  |  | D3 |  |  | D4 |  |  | D5
 |  |  |  |  | Supply Chain |  | WHEN |  |  | Man | E1 |  |  | E2 |  |  | E3 |  |  | E4 |  |  | E5
 |  |  |  |  | Design Engineer |  | HOW MANY |  |  | Environment | F1 |  |  | F2 |  |  | F3 |  |  | F4 |  |  | F5
23-001 | Engels | 2023-09-14 00:00:00 | 10 occurrences of parts on-hold for incorrect data in MRB |  | Operations Lead | [NAME] | WHAT | Incorrect Data Inserts Used |  | Material | A1 | Material 1 |  | A2 | Material 2 |  | A3 | Material 3 |  | A4 | Material 4 |  | A5 | Material 5
 |  |  |  |  | Operator | [NAME] |  |  |  | Method | B1 | Method 1 |  | B2 | Method 2 |  | B3 | Method 3 |  | B4 | Method 4 |  | B5 | Method 5
 |  |  |  |  | Quality Lead | [NAME] | WHERE | [NAME] 2,3 +5 |  | Machine | C1 | Machine 1 |  | C2 | Machine 2 |  | [NAME] | Machine 3 |  | C4 | Machine 4 |  | C5 | Machine 5
 |  |  |  |  | Manuf Engineer | [NAME] | WHY | Parts incorrectly marked as per drawing |  | Measurement | D1 | MS1 |  | D2 | MS2 |  | D3 | MS3 |  | D4 | MS4 |  | D5 | [NAME]
 |  |  |  |  | Supply Chain | [NAME] | WHEN | During tooling set-up |  | Man | E1 | Man 1 |  | E2 | Man 2 |  | E3 | Man 3 |  | E4 | Man 4 | V2 | E5 | Man 5
 |  |  |  |  | Design Engineer | [NAME] | HOW MANY | Each Piece |  | Environment | F1 | Env 1 |  | F2 | Env 2 |  | F3 | Env 3 |  | F4 | Env 4 |  | F5 | Env 5 | V1
23-XXX |  | 2023-09-06 00:00:00 | Enter details of reported issue |  | Operations Lead | [NAME] | WHAT |  | Internal  & External Customers: - Does WIP material need sorting - Does product in stores require sorting - Define sorting criteria to conduct sort - Is a Quality Alert required to provide communication - Is there a need for ongoing protection of internal / external customer(s). | Material | A1 |  |  | A2 |  |  | A3 |  |  | A4 |  |  | A5 |  |  | Summarise the root cause of the issue | This is sample corrective action | [NAME] how corrective action veriifed as effective
 |  |  |  |  | Operator | [NAME] |  |  |  | Method | B1 |  |  | B2 |  |  | B3 |  |  | B4 |  |  | B5
 |  |  |  |  | Quality Lead | [NAME] | WHERE |  |  | Machine | C1 |  |  | C2 |  |  | [NAME] |  |  | C4 |  |  | C5
 |  |  |  |  | Manuf Engineer | [NAME] | WHY |  |  | Measurement | D1 |  |  | D2 |  |  | D3 |  |  | D4 |  |  | D5
 |  |  |  |  | Supply Chain | [NAME] | WHEN |  |  | Man | E1 |  |  | E2 |  |  | E3 |  |  | E4 |  |  | E5
 |  |  |  |  | Design Engineer | [NAME] | HOW MANY |  |  | Environment | F1 |  |  | F2 |  |  | F3 |  |  | F4 |  |  | F5