{"text_format":"1","workbook":"xlsx","n_sheets":32,"sheets":["Settings","Rev History","Instructions","8D Overview","Toolbox","D0 PLAN & ERA","D1 CREATE A TEAM","D2 DEFINE PROBLEM","D2 IS-IS NOT","D3 CONTAIN","D4 DETERMINE ROOT CAUSE","D5 ID CORRECTIVE ACTIONS","D6 IMPLEMENT & VERIFY EFF","D6 Gantt Chart","D7 TAKE PREVENTATIVE MEASURES","5W Template","3x5W Template","D8 RECOGNIZE","C&E Template","PC Template","HT Template","IS Template","PFD Template","CM Template","PM Template","PM C&E Template","CPK Template","MSA Template","PFMEA Template","Control Plan Instructions","CP Template","PR Template"],"not_rendered":{"charts":9,"images":7,"macros":1,"external_links":2,"defined_names":31,"comments":4,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Settings","index":0,"n_rows":15,"n_cols":23,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Tool Name","Template Name","Tool Definition","WS Name",null,null,"Loaded Tools:","Tool Name","Sheetname","Sheet CodeName",null,null,"Initial Use:",true,"Disabled:",false,null,null,null,null,"Checkboxes on D8:","PR - Accept",true]
["Causal Map Diagram","CM Template","Used to create a map to link different cause and effects together to show their influences on each other. ","Causal Diagram",null,null,null,"Cause & Effect Diagram (Fishbone Diagram)","Cause & Effect Diagram","Sheet8",null,null,null,null,null,null,null,null,null,null,null,"PR - R",true]
["Cause & Effect Diagram (Fishbone Diagram)","C&E Template","(also known as Ishikawa / Fishbone Diagram) is a tool used to simplify the data gathering process and identify probable causes of the problem based on 5 areas of focus (the 5 Focus Areas are also known as the 5M: Man, Materials, Mother Nature, Methods & Machine).","Cause & Effect Diagram",null,null,null,"Hypothesis Testing","Hypothesis Testing Result","Sheet14",null,null,null,null,null,null,null,null,null,null,null,"DFMEA",false]
["Control Plan","CP Template","To be used as a living document; the control plan lists all the steps in the process as well as their description and the controls associated to each step in order to reduce defects or potential defects (to be used in accordance with the PFMEA and Process Flow Chart as a group of aligned living documents).","Control Plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Process Flow",false]
["Hypothesis Testing","HT Template","Use this form to list all the possible causes as well as the experimentation or action taken to prove them.","Hypothesis Testing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PFMEA",false]
["IS / IS NOT","IS Template","An \"is/is not\" comparative analysis can be a good tool for figuring out the root cause-or, what the problem is or is not about. This tool is useful when you need to: Understand plausible problem causes amid many possible causes Identify issues that are not related to the problem.","IS-IS NOT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Control Plan",false]
["MSA \"Measure Systems Analysis\"","MSA Template","Also known as Gauge R&R; is a methodical approach to measuring data (usually using Gage R&R) to measure error and assess whether the variability of a process result is mostly due to the operator (reproducibility) or the gauge (repeatability) being used.  Gauge R&R is a very useful and the most popular tool for MSA.  See Gauge R&R Template.","MSA GR&R",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSA",false]
["PFMEA","PFMEA Template","A PFMEA is used to list all the process steps as identified in the Process Map and using a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by a team member separate from the core implementation team in order to objectively assess effectiveness of the corrective action implemented); data will be reviewed for repetition of defect / problem as well as other relevant occurrences. ","PFMEA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Work instructions",false]
["Probable Causes","PC Template","Can be used in conjunction with the Cause & Effect Diagram or by itself; this diagram assigns a level of contribution to each factor listed as a potential cause.","Probable Causes"]
["Process Capability Study","CPK Template","Process Capability Studies are used to statistically determine if the process identified can operate within the specified parameters.","Process Capability Study"]
["Process Flow Diagram","PFD Template","A Process Flow Diagram  lists all the process steps in order of sequence, in order to gather data and establish relationships or potential causes.\n","Process Flow Diagram"]
["Process Map","PM Template","An alternate to the Process Flow Diagram, this process map details the inputs and outputs of the sequence of steps that make up the process in an attempt to depict the critical variables that each step entails and whether each is a controlled or uncontrolled part of the process.","Process Map"]
["Process Map - C&E","PM C&E Template","An alternate to the Process Flow Diagram, this process map relates each process step to the customer requirements.","Process Map C&E "]
["5 WHY","5W Template","Not a preferred tool - only use for Low Risk RCCA. 5-WHY is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem. The primary goal of the technique is to determine the root cause of a defect or problem by repeating the question \"Why?\". Each answer forms the basis of the next question. ","5 WHY"]
["5 WHY - 3 legged","3x5W Template","Not a preferred tool - only use for Low Risk RCCA. 5-WHY is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem. The primary goal of the technique is to determine the root cause of a defect or problem by repeating the question \"Why?\". Each answer forms the basis of the next question. ","5x3 5WHY"]

{"sheet":"Rev History","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Revision History"]
[null,"Date","Author","Version","Change History"]
[null,"-","Nicholas Jabar\nPete Trainor\nMichael Goderre\nMarguerite Farahmand","0-18","Initial development/creation of form."]
[null,"2020-03-30","Nicholas Jabar",19,"DCR14624: \n- Initial Release in ESDR\nAdded:\n- 5 WHY and Is/Is Not tools\n- Ability for Probable causes to load into hypothesis testing"]
[null,"2020-05-14","Nicholas Jabar",19,"DCR15025: No changes to form. Adding Export Approval."]
[null,"2020-10-20","Nicholas Jabar",19,"DCR16142: Added missing copy write from Is / Is Not Tool"]
[null,"2021-07-13","Nicholas Jabar",20,"DCR17432:\n - General Formatting Updates/Enhancements\n - Added ability to add multiple tools\n  ○ Individual Tool buttons removed and Add Tool button added to cover all tools\n - Tools Updated/Added:\n  ○ Added: 3 Legged 5 Why and Causal Map\n  ○ Updated: Cause and Effect Diagram, Process Flow Diagram, 5Why Diagram, Probably Causes, Hypothesis Testing\n  ○ Process Map, PFMEA and Control Plan tools setup to align with AS9145 PPAP Forms Package\n - General bug fixes in VBA Code\n - Added Definitions Section to D5 and D7 Tabs\n - Broke D5 out into PCA Activities into Correction and Corrective Action sections\nUpdated D5,D6 and D7 tabs to have individual actions"]
[null,"2021-08-11","Nicholas Jabar",21,"DCR17886:\n- Bug Fixes to macro that loads Hypothesis Testing\n- Various formatting fixes\n- Updated MSA Tool\n- D5 Tab updated to include concurrence of action item"]
[null,"2021-11-19","David Roberts",22,"Move document From ESDR 20-0045 to Proquis ESFM5000.3.3. No content change."]
[null,"2023-05-24","Nicholas Jabar",23,"- D0 Added to Form\n- IS/IS Not template updated\n- Formatting Fixes"]
[null,"2023-06-28","Nicholas Jabar",24,"Changed column heading in Is/IS Not template from \"Get Information\" to \"Differences\"."]
[null,"2023-11-28","David Roberts",25,"Updated to align with new ESPD5000.3 terminology."]
[null,"2025-04-03","Roxanne Benzel\nMark Cimini\nMichael Daly\nNina Daniels\nSydney Holtzen",26,"- Embedded Is-Is Not template, Containment Checklist, and Gantt Chart into the appropriate tabs. Updated and fixed errors in the GR&R MSA template. Added Gantt Chart template.\n- Various formatting fixes for consistency. Debugging Visual Basic errors.\n- Various verbiage fixes for adherence to ESPD5000.3; added terminology and definitions from BAE Systems command media and AS9100.\n- Added functionality that loads updates from the C&E Diagram to the Hypothesis Testing worksheet.\n- Added validation sections to D5/D6/D7 to bolster the documentation of validation activities.\n- Provided reminders of leadership gate reviews throughout the document.\n- Removed \"Generate Report\" functionality due to lack of usage.\n- Includes recommended team members in D1 with definitions."]
[null,"2025-06-11","Sydney Holtzen",27,"Fixed two bugs \nThe Is/Is-Not in the Toolbox is the old version and not reflective of the selection you can use from the D2 Tab which has the new format.\nCause Effect/Ishikawa – the default font color is ‘white’ so when folks bring their D2 Problem Statement into the ‘Effect’ Box it is invisible."]

{"sheet":"Instructions","index":2,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,1,5,3],[9,1,9,3],[1,1,1,3],[10,1,17,3],[20,1,37,3],[19,1,19,3]]}
[]
[null,"Template Usage Instructions"]
[null,"Macros are REQUIRED for this form to operate correctly\nIf you see the below ribbon at the top, please click \"Enable Content\"\n"]
[]
[]
[]
[]
[]
[]
[null,"Additional Instructions"]
[null,"If the above does not work you may need to enable Macros in the Trust Center using the following Steps. \n1.Click the File tab.\n2. Click Options.\n3. Click Trust Center, and then click Trust Center Settings.\n4. In the Trust Center, click Macro Settings.\n5.Under \"Developer Macro Settings\", select \"Trust access to the VBA project object model\"."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Notes"]
[null,"PLEASE BE ADVISED: Deleting Tabs or modifying worksheets may cause the built in Macros to no longer function. You may add as many Tabs to this Workbook as you would like without causing issues. "]

{"sheet":"8D Overview","index":3,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[[3,1,8,14],[1,1,2,14]]}
[]
[null,"BAE SYSTEMS 8D Overview"]
[]
[null,"Instructions: The process steps below are intended to provide guidelines to perform a formal RCCA (Root Cause Corrective Action) Implementation utilizing the 8D Method. Each process step in the 8D Method is highlighted in a color and listed in sequence in the first row below followed by a definition. The tools associated with each process step are listed and defined under each pertaining step. Each tool is color-coded to match the tab in this Excel file where it is located. Not all tools have to be used in the 8D process in order to complete an 8D successfully; however, a minimum of one tool is recommended per process step in the 8D RCCA."]

{"sheet":"Toolbox","index":4,"n_rows":49,"n_cols":3,"rows_kept":49,"cut":false,"hidden":false,"merged":[[33,1,33,2],[0,1,0,2]]}
[null,"8D Toolbox"]
[]
[null,"Click on the \"Add Tool\" button to select the tool you would like to add. You can add as many tools as needed on the form. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Tool to Use\n(Click \"Add Tool\" button)","Tool Definition / When to Use"]
[null,"MSA \"Measure Systems Analysis\"","MSA is a methodical approach to measuring data to measure error and assess whether the variability of a process result is mostly due to the operator (reproducibility) or the gauge (repeatability) being used. Gauge R&R is a very useful and the most popular tool for MSA, and there is a template in the Toolbox. Minitab can be utilized to create and analyze an MSA."]
[null,"Process Flow Diagram","A Process Flow Diagram lists all the process steps in order of sequence in order to gather data and establish relationships or potential causes."]
[null,"Process Map Template","An alternate to the Process Flow Diagram, this process map details the inputs and outputs of the sequence of steps that make up the process in an attempt to depict the critical variables that each step entails and whether each is a controlled or uncontrolled part of the process."]
[null,"Process Capability Study Worksheet","Process Capability Studies are used to statistically determine if the process identified can operate within the specified parameters."]
[null,"PFMEA","A PFMEA is used to list all the process steps as identified in the Process Map and using a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by a team member separate from the core implementation team in order to objectively assess effectiveness of the corrective action implemented); data will be reviewed for repetition of defect / problem as well as other relevant occurrences. "]
[null,"Control Plan","Control plans list all the steps in the process as well as their description and the controls associated to each step in order to reduce defects or potential defects (to be used in accordance with the PFMEA and Process Flow Chart as a group of aligned living documents). The control plan is intended to be used as a living document."]
[null,"Probable Causes","This diagram assigns a level of contribution to each factor listed as a potential cause. The diagram can be used in conjunction with the Cause & Effect Diagram or by itself."]
[null,"Cause & Effect Diagram","Also known as Ishikawa / Fishbone Diagram, the C&E Diagram is a tool used to simplify the data gathering process and identify probable causes of the problem based on 5 areas of focus (the 5 Focus Areas are also known as the 5M: Man, Materials, Mother Nature, Methods & Machine)."]
[null,"Hypothesis Testing","Use this form to list all the possible causes as well as the experimentation or action taken to prove them."]
[null,"IS / IS NOT","An \"Is/Is Not\" comparative analysis can be a good tool for figuring out the root cause or what the problem is or is not about. This tool is useful when you need to understand plausible problem causes amid many possible causes and identify issues that are not related to the problem."]
[null,"Causal Map Diagram","Used to create a map to link different cause and effects together to show their influences on each other. "]
[null,"5-WHY","Not a preferred tool - only use for Low Risk RCCA. 5-WHY is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem. The primary goal of the technique is to determine the root cause of a defect or problem by repeating the question \"Why?\". Each answer forms the basis of the next question. "]
[null,"3-Legged 5-WHY","Not a preferred tool - only use for Low Risk RCCA. 5-WHY is an iterative interrogative technique used to explore the cause-and-effect relationships underlying a particular problem. The primary goal of the technique is to determine the root cause of a defect or problem by repeating the question \"Why?\". Each answer forms the basis of the next question. "]
[]
[null,"ADDITIONAL TOOLS (NOT INCLUDED IN 8D TEMPLATE)\nMany of these tools can be found in Minitab"]
[null,"Tool Name","Tool Definition / When to Use"]
[null,"Histogram","A Histogram is used to display of statistical information that uses rectangles to show the frequency of data items in successive numerical intervals of equal size."]
[null,"Scatter Plot","A Scatter Plot is a graph that can be used in order to plot all the data points collected (usually numerical / quantitative data) and identify possible correlation."]
[null,"Pareto Chart","A Pareto Chart can be used to plot all the data and see how it accumulates into groups of likely items; usually used to identify the \"vital few\" that are most common and recurrent in order to determine patterns or areas of focus."]
[null,"Fault Tree Analysis","Also known as FTA, the main purpose of Fault Tree Analysis is to help identify potential causes of system failures before the failures actually occur. It can also be used to evaluate the probability of the top event using analytical or statistical methods. These calculations involve system quantitative reliability and maintainability information, such as failure probability, failure rate and repair rate."]
[null,"ANOVA","An ANOVA (Analysis Of Variance) test is a way to find out if survey or experiment results are significant. In other words, they help you to figure out if you need to reject the null hypothesis or accept the alternate hypothesis.  There are two types of ANOVA (One-Way and Two-Way Analysis); One-way or two-way refers to the number of independent variables (IVs) in your Analysis of Variance test. One-way has one independent variable (with 2 levels) and two-way has two independent variables (can have multiple levels). For example, a one-way Analysis of Variance could have one IV (brand of cereal) and a two-way Analysis of Variance has two IVs (brand of cereal, calories)."]
[null,"Regression","Statistical Analysis used to determine the strength of the relationship between one dependent variable (usually denoted by Y) and a series of other changing variables (known as independent variables)."]
[null,"Multi-Vari Analysis","A multi-vari chart is a graphical representation of the relationships between factors and a response. Use a multi-vari chart to present analysis of variance data in a graphical form especially in the preliminary stages of data analysis to view data, possible relationships, and root causes for variation."]
[null,"Box & Whisker Plot","A graphic way to display the median, quartiles, and extremes of a data set on a number line to show the distribution of the data."]
[null,"Correlation","A statistical tool that uses a Correlation coefficients to measure the strength of association between two variables. The most common correlation coefficient, called the Pearson product-moment correlation coefficient, measures the strength of the linear association between variables."]
[null,"Yokoten","A Japanese term that can be roughly translated as “across everywhere” or \"Read Across\". In the Japanese Lean system, it is used to mean “best practice sharing.”"]
[null,"Control Chart","The control chart is a graph used to study how a process changes over time. Data are plotted in time order. A control chart always has a central line for the average, an upper line for the upper control limit, and a lower line for the lower control limit. These lines are determined from historical data."]
[null,"Design Review","Cross-functional team meeting to discuss / determine if design is robust enough to meet product functionality.  Design Reviews are held at the beginning stages of a product life cycle or anytime after design modifications are merited."]
[null,"DFMEA","A DFMEA lists all the design characteristics of a part / product and uses a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by the design team) in order to assign potential risk due to design and also develop / design alternate measures to reduce risk of failure."]
[null,"Poka Yoke","Japanese term (also known as \"mistake proofing\") is a method to reduce possible defects by aligning the process with techniques that reduce or eliminate probability of defects."]

{"sheet":"D0 PLAN & ERA","index":5,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[[6,1,6,11],[15,2,15,11],[16,2,16,11],[17,2,17,11],[5,1,5,11],[14,1,14,7],[7,2,7,11],[11,2,11,11],[12,2,12,11],[13,2,13,11],[8,1,10,1],[8,3,8,11],[9,3,9,11],[10,3,10,11],[4,2,4,11],[1,8,1,9],[2,2,2,6],[2,7,2,8],[2,9,2,11],[3,4,3,6],[3,7,3,11],[1,1,1,6],[3,2,3,3]]}
[]
[null,"8D Details",null,null,null,null,null,"Date Opened:",null,null,"CAR NO."]
[null,"Program/Supplier Name:",null,null,null,null,null,"Supplier/Program ID:"]
[null,"Part Number:",null,null,"Part Description:"]
[null,"Symptom Title:"]
[null,"D0  PLAN & EMERGENCY RESPONSE ACTION"]
[null,"Specify the Symptom being experienced and the Emergency Response Action (ERA) being taken to protect the Customer (Internal or External). Include how the ERA was verified and validated to be effective. Log data into TipQA or System of Record. Understand the scope and magnitude of the symptom to formulate plans for subsequent 8D steps and to resource accordingly. "]
[null,"Symptom Identified"]
[null,"ERA Action(s)","#1"]
[null,null,"#2"]
[null,null,"#3"]
[null,"Responsiblilites"]
[null,"Verification"]
[null,"Validation"]
[null,"Note: Blank fields highlighted in yellow"]
[null,"Term","Definition"]
[null,"Verification","Proof developed before implementation that the action will do what is intended by providing a \"before\" and \"after\" data comparison; it does not introduce a new problem."]
[null,"Validation","Ongoing evidence that the implemented action is doing what was intended without introducing a new problem. Validation follows after successful verification. Although the Customer (Internal or External) is the final check for validation, prudence dictates that the Customer is not the primary way validation is accomplished."]

{"sheet":"D1 CREATE A TEAM","index":6,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":true,"merged":[[19,2,19,11],[20,2,20,11],[21,2,21,11],[23,2,23,11],[16,2,16,11],[17,2,17,11],[18,2,18,11],[22,2,22,11],[8,1,8,2],[8,3,8,6],[8,7,8,9],[8,10,8,11],[4,1,4,2],[4,3,4,6],[4,7,4,9],[4,10,4,11],[5,1,5,2],[5,3,5,6],[5,7,5,9],[5,10,5,11],[1,1,1,11],[6,1,6,2],[6,3,6,6],[6,7,6,9],[6,10,6,11],[3,1,3,2],[3,3,3,6],[3,7,3,9],[3,10,3,11],[2,1,2,11],[12,5,13,8],[9,1,9,2],[9,3,9,6],[9,7,9,9],[9,10,9,11],[10,1,10,2],[10,3,10,6],[10,7,10,9],[10,10,10,11]]}
[]
[null,"D1 CREATE A TEAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Select and establish a team of individuals with subject matter, product, and/or process knowledge.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Name",null,"Company",null,null,null,"Position",null,null,"Contact Number",null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,"8D Facilitator",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Champion",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Sponsor/Project Lead",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Recorder/Scribe",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Team Member",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Team Member",null,null,null,null,null,null,null,null,"t"]
[null,null,null,null,null,null,null,"Team Member",null,null,null,null,null,null,null,null,"te"]
[]
[]
[]
[]
[]
[null,"Role","Role Description"]
[null,"8D Facilitator","Leader of the 8D Process, spokesperson for the team, facilitates discussion and investigation, forms sub-teams."]
[null,"Champion","Owner of the system/process under consideration. Authority to make changes to this system/process. Helps to remove roadblocks."]
[null,"Sponsor/Project Lead","Provides resources to execute the 8D/RCCA."]
[null,"Recorder","Continuously updates TipQA/Oracle with latest 8D and status. Works with scribe to obtain latest versions of the 8D form."]
[null,"Scribe","Documents discussions occuring during team meetings. Live-edits 8D Form during team meetings."]
[null,"Stakeholders","Anyone else with a vested interest in the 8D and its completion. Examples: QMS, DCMA, Customer (Internal or External)"]
[null,"Team Members","Contributors, knowledgeable of process under consideration."]

{"sheet":"D2 DEFINE PROBLEM","index":7,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":true,"merged":[[3,1,6,9],[2,1,2,11],[1,1,1,11]]}
[]
[null,"D2  DEFINE THE PROBLEM"]
[null,"Specify the problem by identifying in quantifiable terms the WHO, WHAT, WHERE, WHEN WHY, HOW & HOW MANY for the problem."]
[null,null,null,null,null,null,null,null,null,null,"REPEAT CONCERN:"]
[null,null,null,null,null,null,null,null,null,null,"QTY RECEIVED"]
[null,null,null,null,null,null,null,null,null,null,"QTY REJECTED"]
[null,null,null,null,null,null,null,null,null,null,"REJECT %",{"$f":"IFERROR(L6/L5,\"\")","v":""}]
[null,"Note: It is highly recommended that the 8D Team uses the IS/IS NOT Comparative Analysis tool to complete D2 Define the Problem."]

{"sheet":"D2 IS-IS NOT","index":8,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[[3,1,3,2],[14,1,18,1],[19,1,22,1],[1,1,1,9],[2,1,2,9],[3,3,3,9],[4,3,4,9],[8,1,10,1],[11,1,13,1],[6,3,7,3],[6,4,7,4],[5,1,5,4],[5,6,5,9]]}
[]
[null,"PROBLEM SOLVING WORKSHEET"]
[null,"Is/Is Not & Comparative Analysis Tool"]
[null,"Problem Description:"]
[null,null,null,"Problem Description Syntax:  Object/Deviation/How Sensed/Impact to Business"]
[null,"Is/Is Not Analysis - Complete during D2",null,null,null,null,"Comparative Analysis - Complete during D4"]
[null,null,null,"IS","IS NOT",null,"Differences","Changes ","Dates","Get Information"]
[null,null,null,null,null,null,"What is different, odd, unusual, special, or unique about each IS compared to its IS NOT?\nWhat else is different?","What changed in, on, around, or about each distinction? When did the change occur?  Record date and time.\nWhat else has changed?"]
[null,"WHAT","What Object?"]
[null,null,"What Deviation?"]
[]
[null,"WHERE","Where geographically?"]
[null,null,"Where on the object?"]
[]
[null,"WHEN","When first?"]
[null,null,"When since?  "]
[null,null,"What is the pattern?"]
[null,null,"When in the life cycle?"]
[]
[null,"HOW BIG / EXTENT","How many objects?"]
[null,null,"What is the size?"]
[]
[]
[]
[null,"Add rows as needed for each category."]

{"sheet":"D3 CONTAIN","index":9,"n_rows":27,"n_cols":17,"rows_kept":27,"cut":false,"hidden":true,"merged":[[20,1,20,7],[26,2,26,7],[26,8,26,9],[26,10,26,11],[21,8,21,10],[22,1,22,7],[22,8,22,10],[24,1,24,7],[24,8,24,10],[25,1,25,7],[25,8,25,10],[23,1,23,7],[23,8,23,10],[19,8,19,10],[4,6,4,11],[8,6,8,11],[9,6,9,11],[5,6,5,11],[6,6,6,11],[7,6,7,11],[15,6,15,11],[10,6,10,11],[11,6,11,11],[3,13,3,15],[21,1,21,7],[20,8,20,10],[1,1,1,11],[2,1,2,11],[12,6,12,11],[13,6,13,11],[14,6,14,11],[16,1,16,7],[16,8,16,10],[17,1,17,7],[17,8,17,10],[3,1,3,11],[18,1,18,7],[18,8,18,10],[19,1,19,7]]}
[]
[null,"D3  CONTAIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Provide details on containment activities at BAE Systems, Suppliers and Customer (Internal or External) sites, if applicable. Perform Read Across. \nFor BAE Systems containment, the ESCK5000.3.5 Containment Checklist should be utilized.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"ESCK5000.3.5 Containment Checklist",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Location","Affected","Total","Sorted","Not Good","Notes / Comments",null,null,null,null,null,null,null,null,null,"x"]
[null,"Supplier In Process","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"l"]
[null,"Supplier Finished Goods","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Supplier In Transit","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Incoming inspection","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Internal Inventory","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Manufacturing process","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Finished Goods","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Customer Stock","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Customer Side of Line","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Customer Shipping","Select",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,"Overall",{"$f":"SUM(D6:D15)","v":0},{"$f":"SUM(E6:E15)","v":0},{"$f":"SUM(F6:F15)","v":0},null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Containment Action(s) Taken at BAE Systems",null,null,null,null,null,null,"Effect",null,null,"Date",null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cb"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cbe"]
[null,"Containment Action(s) Taken at Supplier Location",null,null,null,null,null,null,"Effect",null,null,"Date",null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cse"]
[null,"Containment Identification Mark",null,null,null,null,null,null,"1st Containment Batch Shipping Details",null,null,null,null,null,null,null,"D313"]

{"sheet":"D4 DETERMINE ROOT CAUSE","index":10,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[[3,1,3,6],[3,8,3,10],[4,1,4,6],[4,8,4,10],[1,1,1,11],[2,1,2,11],[39,2,39,11],[7,1,7,11],[8,1,8,11],[13,1,13,11],[14,1,14,11],[9,1,9,6],[9,8,9,10],[10,1,10,6],[10,8,10,10],[19,2,19,11],[36,2,36,11],[29,1,29,11],[37,2,37,11],[38,2,38,11],[31,2,31,11],[32,2,32,11],[33,2,33,11],[34,2,34,11],[35,2,35,11],[30,2,30,11],[27,2,27,11],[5,1,5,6],[25,2,25,11],[26,2,26,11],[11,1,11,6],[11,8,11,10],[5,8,5,10],[12,1,12,6],[12,8,12,10],[6,1,6,6],[6,8,6,10],[20,2,20,11],[21,2,21,11],[22,2,22,11],[23,2,23,11],[24,2,24,11]]}
[]
[null,"D4 DETERMINE ROOT CAUSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Identify all possible causes that could explain why the problem occurred. Also, identify why the problem was not detected or prevented.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Action Items to Find Occurrence Root Cause",null,null,null,null,null,"Due Date","Action Owner",null,null,"Closed Date",null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"r"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"re"]
[null,"Occurrence Root Cause (How the issue was created)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rc"]
[null,"Action Items to Find Escape Root Cause",null,null,null,null,null,"Due Date","Action Owner",null,null,"Closed Date",null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ee"]
[null,"Escape Root Cause (Earliest point in the QMS where the problem should have been detected)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ec"]
[null,"Note: It is highly recommended that the 8D Team updates the IS/IS NOT Analysis from D2 and complete the Comparative Analysis."]
[]
[]
[]
[null,"Tool to Use","Tool Definition / When to Use"]
[null,"MSA \"Measure Systems Analysis\"","Also known as Gauge R&R; is a methodical approach to measuring data (usually using Gauge R&R) to measure error and assess whether the variability of a process result is mostly due to the operator (reproducibility) or the gauge (repeatability) being used. Gauge R&R is a very useful and the most popular tool for MSA. See Gauge R&R Template or utilize Minitab to create and analyze an MSA. "]
[null,"Process Flow Diagram","A Process Flow Diagram (PFD) lists all the process steps in order of sequence in order to gather data and establish relationships or potential causes."]
[null,"Process Map Template","An alternate to the Process Flow Diagram, this process map details the inputs and outputs of the sequence of steps that make up the process in an attempt to depict the critical variables that each step entails and whether each is a controlled or uncontrolled part of the process."]
[null,"Process Capability Study Worksheet","Process Capability Studies are used to statistically determine if the process identified can operate within the specified parameters."]
[null,"Probable Causes","Can be used in conjunction with the Cause & Effect Diagram or by itself; this diagram assigns a level of contribution to each factor listed as a potential cause."]
[null,"Cause & Effect Diagram","Also known as Ishikawa / Fishbone Diagram, Cause & Effect Diagram is a tool used to simplify the data gathering process and identify probable causes of the problem based on 5 areas of focus (the 5 Focus Areas are also known as the 5M: Man, Materials, Mother Nature, Methods & Machine)."]
[null,"Hypothesis Testing","Use this form to list all the possible causes as well as the experimentation or action taken to prove them."]
[null,"IS / IS NOT","An \"Is/Is Not\" comparative analysis can be a good tool for defining what the problem is or is not about. This tool is useful when you need to understand plausible problem causes amid many possible causes, and to identify issues that are not related to the problem. Go back to the IS-IS NOT tab under D2 to complete the comparative analysis."]
[]
[null,"Additional Tools that can be used in Root Cause Analysis\nMany of these tools can be found in Minitab."]
[null,"Tool Name","Tool Definition / When to Use"]
[null,"Histogram","A Histogram is used to display of statistical information that uses rectangles to show the frequency of data items in successive numerical intervals of equal size."]
[null,"Scatter Plot","A Scatter Plot is a graph that can be used in order to plot all the data points collected (usually numerical / quantitative data) and identify possible correlation."]
[null,"Pareto Chart","A Pareto Chart can be used to plot all the data and see how it accumulates into groups of likely items; usually used to identify the \"vital few\" that are most common and recurrent in order to determine patterns or areas of focus."]
[null,"Fault Tree Analysis","Also known as FTA; the main purpose of the fault tree analysis is to help identify potential causes of system failures before the failures actually occur. It can also be used to evaluate the probability of the top event using analytical or statistical methods. These calculations involve system quantitative reliability and maintainability information, such as failure probability, failure rate and repair rate."]
[null,"ANOVA","An ANOVA (Analysis Of Variance) test is a way to find out if survey or experiment results are significant. In other words, they help you to figure out if you need to reject the null hypothesis or accept the alternate hypothesis.  There are two types of ANOVA (One-Way and Two-Way Analysis); One-way or two-way refers to the number of independent variables (IVs) in your Analysis of Variance test. One-way has one independent variable (with 2 levels) and two-way has two independent variables (can have multiple levels). For example, a one-way Analysis of Variance could have one IV (brand of cereal) and a two-way Analysis of Variance has two IVs (brand of cereal, calories)."]
[null,"Regression","Statistical Analysis used to determine the strength of the relationship between one dependent variable (usually denoted by Y) and a series of other changing variables (known as independent variables)."]
[null,"Multi-Vari Analysis","A multi-vari chart is a graphical representation of the relationships between factors and a response. Use a multi-vari chart to present analysis of variance data in a graphical form especially in the preliminary stages of data analysis to view data, possible relationships, and root causes for variation."]
[null,"Box & Whisker Plot","A graphic way to display the median, quartiles, and extremes of a data set on a number line to show the distribution of the data."]
[null,"Correlation","A statistical tool that uses a Correlation coefficients to measure the strength of association between two variables. The most common correlation coefficient, called the Pearson product-moment correlation coefficient, measures the strength of the linear association between variables."]

{"sheet":"D5 ID CORRECTIVE ACTIONS","index":11,"n_rows":29,"n_cols":18,"rows_kept":29,"cut":false,"hidden":true,"merged":[[28,1,28,2],[15,1,15,12],[26,1,26,2],[26,3,26,12],[27,3,27,12],[28,3,28,12],[16,2,16,12],[17,2,17,12],[18,2,18,12],[19,2,19,12],[20,2,20,12],[27,1,27,2],[6,2,6,7],[7,2,7,7],[8,2,8,7],[4,9,4,10],[5,9,5,10],[6,9,6,10],[7,9,7,10],[8,9,8,10],[13,2,13,7],[14,2,14,7],[10,2,10,7],[11,2,11,7],[1,1,1,12],[2,1,2,12],[3,1,3,12],[9,1,9,12],[12,2,12,7],[10,9,10,10],[11,9,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[4,2,4,7],[5,2,5,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"D5  IDENTIFY CORRECTIVE ACTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,"Establish Corrective Actions that prevent the recurrence of the problem and Corrections that eliminate the nonconformity.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Correction: Action(s) taken to eliminate a detected nonconformity",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,"#","Correction Activity",null,null,null,null,null,"Due Date","Action Owner",null,"Concurrence","Closed Date",null,null,null,"x","x"]
[null,"C1",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,"d5c","d5c"]
[null,"C2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5c"]
[null,"C3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5c"]
[null,"C4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5cE"]
[null,"Corrective Action: Action(s) taken to eliminate the cause of a nonconformity\nPrior to implementation, the team will evaluate how the Corrective Actions will address the root cause.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,"#","Corrective Action",null,null,null,null,null,"Due Date","Action Owner",null,"Concurrence","Closed Date",null,null,null,"x","x"]
[null,"CA1",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,"d5","d5"]
[null,"CA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5"]
[null,"CA3",null,null,null,null,null,null,null,null,null,"No",null,null,null,null,"d5","d5"]
[null,"CA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5e"]
[null,"Corrective Action Validation: How will you verify the effectiveness of the Permanent Corrective Action(s) to turn off the D2 Problem Statement?\nFor each Corrective Action, list the evidence that the team PLANS to collect.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x","x"]
[null,"#","Validation Plan"]
[null,"CA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5v"]
[null,"CA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5v"]
[null,"CA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5v"]
[null,"CA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d5vE","d5v"]
[]
[]
[]
[]
[]
[null,"Term",null,"Definition according to ISO 9000:2015 Section 3.12"]
[null,"Corrective Action",null,"Action to eliminate the cause of a nonconformity and to prevent recurrence.\n     • There can be more than one cause for a nonconformity.\n     • Corrective action is taken to prevent recurrence whereas preventive action is taken to prevent occurrence.\n     • This constitutes one of the common terms and core definitions within the ISO management system standards."]
[null,"Correction",null,"Action to eliminate a detected nonconformity.\n     • A correction can be made in advance of, in conjunction with, or after a corrective action.\n     • A correction can be, for example, rework or regrade."]

{"sheet":"D6 IMPLEMENT & VERIFY EFF","index":12,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":true,"merged":[[1,1,1,11],[14,1,14,11],[2,1,2,11],[15,2,15,9],[16,2,16,9],[3,2,3,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,2,7,8],[13,2,13,11],[8,1,8,11],[9,2,9,11],[10,2,10,11],[11,2,11,11],[12,2,12,11],[47,3,47,11],[47,1,47,2],[48,3,48,11],[48,1,48,2],[28,13,28,15],[44,3,44,11],[44,1,44,2],[45,3,45,11],[45,1,45,2],[46,3,46,11],[46,1,46,2],[34,3,34,11],[34,1,34,2],[28,3,28,11],[28,1,28,2],[35,3,35,11],[17,2,17,9],[18,2,18,9],[19,2,19,9],[35,1,35,2],[29,3,29,11],[29,1,29,2],[30,3,30,11],[30,1,30,2],[31,3,31,11],[31,1,31,2],[32,3,32,11],[32,1,32,2],[33,3,33,11],[33,1,33,2],[36,3,36,11],[36,1,36,2],[39,3,39,11],[39,1,39,2],[40,3,40,11],[40,1,40,2],[38,1,38,11],[41,3,41,11],[41,1,41,2],[42,3,42,11],[42,1,42,2],[43,3,43,11],[43,1,43,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"D6  IMPLEMENT CORRECTIVE ACTIONS AND VERIFY EFFECTIVENESS\nImplement the Corrective Actions and verify the actions were effective in preventing recurrence of the problem.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Corrective Action Implementation\nDescribe what activities were performed to implement the Permanent Corrective Action(s).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Corrective Action Implementation Activity",null,null,null,null,null,null,"Due Date","Action Owner","Closed Date",null,null,null,null,"x"]
[null,"CA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6"]
[null,"CA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6"]
[null,"CA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6"]
[null,"CA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6e"]
[null,"Verification of Corrective Action Implementation\nProvide evidence that each Corrective Action has been implemented.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Evidence of Corrective Action Implementation",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"CA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6vi"]
[null,"CA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6vi"]
[null,"CA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6vi"]
[null,"CA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6viE"]
[null,"How were all the Corrective Action(s) validated to be effective?\nUpon implementation of the Corrective Action(s), add objective evidence (data) that proves that the Corrective Action(s) prevents recurrence of the D2 Problem Statement (turn the problem on/off).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Validation Data ",null,null,null,null,null,null,null,"Action Owner","Date",null,null,null,null,"x"]
[null,"CA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6v"]
[null,"CA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6v"]
[null,"CA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6v"]
[null,"CA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d6vE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Tool to Use",null,"Tool Definition / When to Use"]
[null,"MSA \"Measure Systems Analysis\"",null,"Also known as Gauge R&R; is a methodical approach to measuring data (usually using Gage R&R) to measure error and assess whether the variability of a process result is mostly due to the operator (reproducibility) or the gauge (repeatability) being used. Gauge R&R is a very useful and the most popular tool for MSA. See Gauge R&R Template or use Minitab to generate the MSA."]
[null,"Process Flow Diagram",null,"A Process Flow Diagram lists all the process steps in order of sequence in order to gather data and establish relationships or potential causes."]
[null,"Process Map Template",null,"An alternate to the Process Flow Diagram, this process map details the inputs and outputs of the sequence of steps that make up the process in an attempt to depict the critical variables that each step entails and whether each is a controlled or uncontrolled part of the process."]
[null,"Process Capability Study Worksheet",null,"Process Capability Studies are used to statistically determine if the process identified can operate within the specified parameters."]
[null,"Probable Causes",null,"Can be used in conjunction with the Cause & Effect Diagram or by itself; this diagram assigns a level of contribution to each factor listed as a potential cause."]
[null,"Cause & Effect Diagram",null,"Also known as Ishikawa / Fishbone Diagram, Cause & Effect Diagram is a tool used to simplify the data gathering process and identify probable causes of the problem based on 5 areas of focus (the 5 Focus Areas are also known as the 5M: Man, Materials, Mother Nature, Methods & Machine)."]
[null,"Hypothesis Testing",null,"Use this form to list all the possible causes as well as the experimentation or action taken to prove them."]
[null,"Gantt Chart",null,"A Gantt Chart is a project management tool that helps the user visualize the timeline and monitor the progress of corrective actions over time."]
[]
[null,"ADDITIONAL TOOLS (NOT INCLUDED IN 8D TEMPLATE)\nMany of these tools can be found in Minitab"]
[null,"Tool Name",null,"Tool Definition / When to Use"]
[null,"Histogram",null,"A Histogram is used to display of statistical information that uses rectangles to show the frequency of data items in successive numerical intervals of equal size."]
[null,"Scatter Plot",null,"A Scatter Plot is a graph that can be used in order to plot all the data points collected (usually numerical / quantitative data) and identify possible correlation."]
[null,"Pareto Chart",null,"A Pareto Chart can be used to plot all the data and see how it accumulates into groups of likely items; usually used to identify the \"vital few\" that are most common and recurrent in order to determine patterns or areas of focus."]
[null,"Fault Tree Analysis",null,"The main purpose of the fault tree analysis (FTA) is to help identify potential causes of system failures before the failures actually occur. It can also be used to evaluate the probability of the top event using analytical or statistical methods. These calculations involve system quantitative reliability and maintainability information, such as failure probability, failure rate and repair rate."]
[null,"ANOVA",null,"An ANOVA (Analysis Of Variance) test is a way to find out if survey or experiment results are significant. In other words, they help you to figure out if you need to reject the null hypothesis or accept the alternate hypothesis.  There are two types of ANOVA (One-Way and Two-Way Analysis); One-way or two-way refers to the number of independent variables (IVs) in your Analysis of Variance test. One-way has one independent variable (with 2 levels) and two-way has two independent variables (can have multiple levels). For example, a one-way Analysis of Variance could have one IV (brand of cereal) and a two-way Analysis of Variance has two IVs (brand of cereal, calories)."]
[null,"Regression",null,"Statistical Analysis used to determine the strength of the relationship between one dependent variable (usually denoted by Y) and a series of other changing variables (known as independent variables)."]
[null,"Multi-Vari Analysis",null,"Multi-Vari Charts are a graphical representation of the relationships between factors and a response. Use a Multi-Vari Chart to present analysis of variance data in a graphical form especially in the preliminary stages of data analysis to view data, possible relationships, and root causes for variation."]
[null,"Box & Whisker Plot",null,"A graphic way to display the median, quartiles, and extremes of a data set on a number line to show the distribution of the data."]
[null,"Correlation",null,"A statistical tool that uses a Correlation coefficients to measure the strength of association between two variables. The most common correlation coefficient, called the Pearson product-moment correlation coefficient, measures the strength of the linear association between variables."]

{"sheet":"D6 Gantt Chart","index":13,"n_rows":19,"n_cols":42,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,9,0,38],[2,6,3,6],[2,7,3,7],[2,8,3,8],[2,9,3,9],[0,2,0,8],[2,21,3,21],[2,10,3,10],[2,11,3,11],[2,12,3,12],[2,30,3,30],[2,31,3,31],[2,32,3,32],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,16,3,16],[2,17,3,17],[2,18,3,18],[2,5,3,5],[2,13,3,13],[2,14,3,14],[2,15,3,15],[2,36,3,36],[2,37,3,37],[2,38,3,38],[2,19,3,19],[2,20,3,20],[2,33,3,33],[2,22,3,22],[2,23,3,23],[2,27,3,27],[2,28,3,28],[2,29,3,29],[2,34,3,34],[2,35,3,35],[2,25,3,25],[2,26,3,26],[2,24,3,24]]}
["Gantt Chart for Corrective Action Implementation",null,"May",null,null,null,null,null,null,"June"]
[null,"Date",25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,"Day",-7,-6,-5,-4,-3,-2,-1,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
["Corrective Action #","ACTIVITY"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,".",".","."]

{"sheet":"D7 TAKE PREVENTATIVE MEASURES","index":14,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":true,"merged":[[45,3,45,12],[27,1,27,12],[42,3,42,12],[43,3,43,12],[39,3,39,12],[41,3,41,12],[33,3,33,12],[45,1,45,2],[40,1,40,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[40,3,40,12],[37,4,37,8],[44,3,44,12],[38,1,38,2],[39,1,39,2],[1,1,2,12],[38,3,38,12],[41,1,41,2],[34,3,34,12],[3,1,3,12],[4,2,4,9],[9,1,9,12],[5,2,5,9],[6,2,6,9],[21,1,21,12],[18,2,18,12],[19,2,19,12],[20,2,20,12],[33,1,33,2],[34,1,34,2],[14,2,14,9],[15,1,15,12],[16,2,16,12],[17,2,17,12],[7,2,7,9],[8,2,8,9],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[22,2,22,10],[23,2,23,10],[24,2,24,10],[25,2,25,10],[26,2,26,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"D7  TAKE PREVENTATIVE MEASURES (PREVENTATIVE ACTION)\nAction(s) taken to eliminate the cause of a potential nonconformity or other undesirable situation.   ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Preventative Actions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Preventative Action",null,null,null,null,null,null,null,"Due Date","Action Owner","Closed Date",null,null,null,"x"]
[null,"PA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7p"]
[null,"PA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7p"]
[null,"PA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7p"]
[null,"PA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7pe"]
[null,"Preventative Action Implementation\nDescribe what activities were performed to implement the Preventative Action(s).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Preventative Action Implementation Activity",null,null,null,null,null,null,null,"Due Date","Action Owner","Closed Date",null,null,null,"x"]
[null,"PA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7pi"]
[null,"PA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7pi"]
[null,"PA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7pi"]
[null,"PA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7piE"]
[null,"Verification of Preventative Action Implementation\nProvide evidence that each Preventative Action has been implemented.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Evidence of Preventative Action Implementation",null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"PA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7ev"]
[null,"PA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7ev"]
[null,"PA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7ev"]
[null,"PA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7evE"]
[null,"Preventative Action Validation: How was the effectiveness of all the Preventative Action(s) validated?\nUpon implementation of the Preventative Action(s), add objective evidence (data) that proves that the Preventative Action(s) prevents occurrence of the D2 Problem Statement (turn the problem on/off).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"#","Validation Data ",null,null,null,null,null,null,null,null,"Action Owner","Date",null,null,null,"x"]
[null,"PA1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7v"]
[null,"PA2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7v"]
[null,"PA3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7v"]
[null,"PA4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"d7vE"]
[null,"Note: Preventative Action is taken to prevent occurrence whereas corrective action is taken to prevent recurrence.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x"]
[null,"Term",null,"Definition according to ISO 9000:2015 Section 3.12"]
[null,"Preventative Action",null,"Preventative action is taken to prevent occurrence whereas corrective action is taken to prevent recurrence. Preventative actions are designed to eliminate the cause of a potential nonconformity or other potential undesirable situation. There can be more than one cause for a potential nonconformity.\n"]
[]
[]
[]
[null,"Tool To Use",null,"Tool Definition / When to Use"]
[null,"PFMEA",null,"A PFMEA is used to list all the process steps as identified in the Process Map and using a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by a team member separate from the core implementation team in order to objectively assess effectiveness of the corrective action implemented); data will be reviewed for repetition of defect / problem as well as other relevant occurrences. "]
[null,"DFMEA",null,"A DFMEA lists all the design characteristics of a part / product and uses a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by the design team) in order to assign potential risk due to design and also develop / design alternate measures to reduce risk of failure."]
[null,"Control Plan",null,"To be used as a living document; the control plan lists all the steps in the process as well as their description and the controls associated to each step in order to reduce defects or potential defects (to be used in accordance with the PFMEA and Process Flow Chart as a group of aligned living documents)."]
[null,"Yokoten",null,"A Japanese term that can be roughly translated as “across everywhere” or \"Read Across\".  In the Japanese Lean system, it is used to mean “best practice sharing.”"]
[null,"Control Chart",null,"The control chart is a graph used to study how a process changes over time. Data are plotted in time order. A control chart always has a central line for the average, an upper line for the upper control limit, and a lower line for the lower control limit. These lines are determined from historical data."]
[null,"DFMEA",null,"A DFMEA lists all the design characteristics of a part / product and uses a methodical approach to assign risk based on severity, probability of occurrence and detection of a possible defect or \"failure\" in the process step.: (recommended to be performed by the design team) in order to assign potential risk due to design and also develop / design alternate measures to reduce risk of failure."]
[null,"Poka Yoke",null,"Japanese term (also known as \"mistake proofing\") is a method to reduce possible defects by aligning the process with techniques that reduce / eliminate probability of defects."]

{"sheet":"5W Template","index":15,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":true,"merged":[[0,1,0,15],[3,1,14,1],[5,3,5,7],[7,5,7,9],[9,7,9,11],[11,9,11,13],[13,11,13,15]]}
[null,"5 WHY Analysis"]
[]
[]
[null,"WHY IS THIS \nA PROBLEM?",null,"PRIMARY CAUSE"]
[null,null,null,"Why is it happening?"]
[null,null,1,"It is happening because"]
[null,null,null,null,null,"Why is that?"]
[null,null,null,null,2,"It is happening because"]
[null,null,null,null,null,null,null,"Why is that?"]
[null,null,null,null,null,null,3,"It is happening because"]
[null,null,null,null,null,null,null,null,null,"Why is that?"]
[null,null,null,null,null,null,null,null,4,"It is happening because"]
[null,null,null,null,null,null,null,null,null,null,null,"Why is that?",null,null,null,"ROOT CAUSE"]
[null,null,null,null,null,null,null,null,null,"NOTE: If the final \"Why\" has no controllable solution, return to the previous \"Why.\"",5,"It is happening because"]

{"sheet":"3x5W Template","index":16,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,1,0,2],[2,1,3,1],[2,2,3,4],[5,2,5,4],[14,1,15,1]]}
[null,"5x3 5Why Analysis"]
[]
[null,"5Why Proof\nRead Back","\"Problem Statement” occurred due to “Fifth Why”. This was caused by “Fourth why” mainly because “Third Why” was allowed by “Second why”, and this led to “First Why"]
[]
[]
[null,"Problem Statement:","List the OBJECT and the DEVIATION and what tells us the DEVIATION exists\n(or state Requirement, Deviation from Requirement, and Impact)."]
[]
[null,null,"NONCONFORMANCE ESCAPE","INSPECTION ESCAPE","DOCUMENTATION ESCAPE"]
[null,null,"Why Did This Specific Problem/Issue Occur?","Why Did This Problem/Issue Go Undetected?","Why Did the Management System (CM, Process, etc.) Fail?"]
[null,"1St Why"]
[null,"2nd Why"]
[null,"3rd Why"]
[null,"4th Why"]
[null,"5th Why"]
[null,"Root Cause(s)","Root Cause  1","Root Cause  2","Root Cause  3"]

{"sheet":"D8 RECOGNIZE","index":17,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":true,"merged":[[7,1,7,3],[7,4,7,5],[7,6,7,11],[1,1,1,11],[4,10,4,11],[6,1,6,3],[6,4,6,5],[6,6,6,11],[4,1,4,3],[5,1,5,3],[5,10,5,11],[2,1,2,11],[3,1,3,11],[4,4,4,9],[5,4,5,9]]}
[]
[null,"D8  RECOGNIZE  \nRecognize the collective efforts of the RCCA team."]
[null,"How has the team been recognized for their efforts on this RCCA?\nSuch as a recognition email to the team, Impact Awards, a nomination for a STARS Award, or a nomination for a Quality Award."]
[]
[null,"Reported By",null,null,"Verified By",null,null,null,null,null,"Date Verified"]
[]
[null,"8D Closed By",null,null,"Date Closed",null,"Documents Updated"]
[]
[null,"Ensure that the TipQA record has been updated in accordance with ESPD5000.3 Appendix B (Corrective Action Closure Checklist)."]

{"sheet":"C&E Template","index":18,"n_rows":38,"n_cols":79,"rows_kept":38,"cut":false,"hidden":true,"merged":[[3,16,3,17],[2,15,2,17],[19,13,19,17],[20,13,26,17]]}
[null,"Cause & Effect Diagram (Ishikawa Diagram)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C&E Template",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C&E Template"]
[]
[null,"After filling in the Cause & Effect diagram, select the \"Load Hypothesis Testing\" button to populate the Hypothesis Testing worksheet.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Contribution Rating Selection"]
[null,"If changes are made to the Cause & Effect Diagram after the Hypothesis Testing worksheet is populated, select \"Load Hypothesis Testing\" again to refresh the Hypothesis Testing tab.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Select:","Medium/High"]
[]
[null,"People",null,"Rating",null,"Environment",null,"Rating",null,"Material",null,"Rating"]
[null,1,null,null,null,1,null,null,null,1]
[null,2,null,null,null,2,null,null,null,2]
[null,3,null,null,null,3,null,null,null,3]
[null,4,null,null,null,4,null,null,null,4]
[null,5,null,null,null,5,null,null,null,5]
[null,6,null,null,null,6,null,null,null,6]
[null,7,null,null,null,7,null,null,null,7]
[null,8,null,null,null,8,null,null,null,8]
[null,9,null,null,null,9,null,null,null,9]
[null,10,null,null,null,10,null,null,null,10]
[null,11,null,null,null,11,null,null,null,11]
[null,12,null,null,null,12,null,null,null,12]
[null,13,null,null,null,13,null,null,null,13]
[null,14,null,null,null,14,null,null,null,14,null,null,null,"Effect"]
[]
[]
[null,1,null,null,null,1,null,null,null,1]
[null,2,null,null,null,2,null,null,null,2]
[null,3,null,null,null,3,null,null,null,3]
[null,4,null,null,null,4,null,null,null,4]
[null,5,null,null,null,5,null,null,null,5]
[null,6,null,null,null,6,null,null,null,6]
[null,7,null,null,null,7,null,null,null,7]
[null,8,null,null,null,8,null,null,null,8]
[null,9,null,null,null,9,null,null,null,9]
[null,10,null,null,null,10,null,null,null,10]
[null,11,null,null,null,11,null,null,null,11]
[null,12,null,null,null,12,null,null,null,12]
[null,13,null,null,null,13,null,null,null,13]
[null,14,null,null,null,14,null,null,null,14]
[]
[null,"Machine",null,"Rating",null,"Method",null,"Rating",null,"Measurement",null,"Rating"]

{"sheet":"PC Template","index":19,"n_rows":93,"n_cols":79,"rows_kept":93,"cut":false,"hidden":true,"merged":[[2,5,2,7],[78,1,78,2],[18,1,18,2],[3,1,3,2],[33,1,33,2],[3,6,3,7]]}
[null,null,"PROBABLE CAUSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PC Template",null,null,null,null,null,null,null,null,null,"PC Template"]
[]
[null,"CAUSE & EFFECT",null,null,null,"Contribution Rating Selection"]
[null,"PEOPLE",null,"Contribution Rating",null,"Select:","Medium/High"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,"ENVIRONMENT",null,"Contribution Rating"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,"MATERIAL",null,"Contribution Rating"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,"MACHINE",null,"Contribution Rating"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,"METHOD",null,"Contribution Rating"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,"MEASUREMENT",null,"Contribution Rating"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]

{"sheet":"HT Template","index":20,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":true,"merged":[[0,1,0,4]]}
[null,"Hypothesis Testing"]
[]
[null,"Sr. No","Probable Cause","Testing & observations for probable causes","Conclusion - Valid or Invalid "]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]

{"sheet":"IS Template","index":21,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":true,"merged":[[5,6,5,9],[6,3,7,3],[1,1,1,9],[2,1,2,9],[3,1,3,2],[3,3,3,9],[4,3,4,9],[6,4,7,4],[8,1,10,1],[11,1,13,1],[14,1,18,1],[19,1,22,1],[5,1,5,4]]}
[]
[null,"PROBLEM SOLVING WORKSHEET"]
[null,"Is/Is Not & Comparative Analysis Tool"]
[null,"Problem Description:"]
[null,null,null,"Problem Description Syntax:  Object/Deviation/How Sensed/Impact to Business"]
[null,"Is/Is Not Analysis - Complete during D2",null,null,null,null,"Comparative Analysis - Complete during D4"]
[null,null,null,"IS","IS NOT",null,"Differences","Changes ","Dates","Get Information"]
[null,null,null,null,null,null,"What is different, odd, unusual, special, or unique about each IS compared to its IS NOT?\nWhat else is different?","What changed in, on, around, or about each distinction? When did the change occur?  Record date and time.\nWhat else has changed?"]
[null,"WHAT","What Object?"]
[null,null,"What Deviation?"]
[]
[null,"WHERE","Where geographically?"]
[null,null,"Where on the object?"]
[]
[null,"WHEN","When first?"]
[null,null,"When since?  "]
[null,null,"What is the pattern?"]
[null,null,"When in the life cycle?"]
[]
[null,"HOW BIG / EXTENT","How many objects?"]
[null,null,"What is the size?"]
[]
[]
[]
[null,"Add rows as needed for each category."]

{"sheet":"PFD Template","index":22,"n_rows":8,"n_cols":27,"rows_kept":8,"cut":false,"hidden":true,"merged":[[7,2,7,3],[7,4,7,54],[2,31,2,37],[3,31,3,37],[4,26,4,37],[2,26,2,30],[3,26,3,30],[0,2,0,18],[6,2,6,16],[4,7,4,13],[2,19,2,25],[3,19,3,25],[4,19,4,25],[2,7,2,13],[2,14,2,18],[3,14,3,18],[4,14,4,18],[3,7,3,13],[4,2,4,6],[3,2,3,6],[2,2,2,6]]}
[null,null,"Process Flow Diagram"]
[]
[null,null,"Part #:",null,null,null,null,null,null,null,null,null,null,null,"Org. Creation Date:",null,null,null,null,null,null,null,null,null,null,null,"Rev Date:"]
[null,null,"Description:",null,null,null,null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,null,null,null,null,"Revised By:"]
[null,null,"HDW / DWG Rev:",null,null,null,null,null,null,null,null,null,null,null,"PFD Revision:"]
[]
[null,null,"See example picture below. Delete picture when starting. "]
[null,"COPY AND PASTE \nBLANK ICONS\nBELOW","K E Y"]

{"sheet":"CM Template","index":23,"n_rows":7,"n_cols":27,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,2,0,18],[2,2,2,6],[2,7,2,13],[2,14,2,18],[2,19,2,25],[6,2,6,3],[6,4,6,54],[5,2,5,16],[2,31,2,37],[3,2,3,6],[3,7,3,13],[3,14,3,18],[3,19,3,25],[3,26,3,30],[3,31,3,37],[2,26,2,30]]}
[null,null,"Causal Map"]
[]
[null,null,"Part #:",null,null,null,null,null,null,null,null,null,null,null,"Org. Creation Date:",null,null,null,null,null,null,null,null,null,null,null,"Rev Date:"]
[null,null,"Description:",null,null,null,null,null,null,null,null,null,null,null,"Prepared by:",null,null,null,null,null,null,null,null,null,null,null,"Revised By:"]
[]
[null,null,"See example picture below. Delete picture when starting. "]
[null,"COPY AND PASTE \nBLANK ICONS\nBELOW","K E Y"]

{"sheet":"PM Template","index":24,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":true,"merged":[[15,4,15,12],[0,1,1,17],[15,1,15,3],[11,2,11,4],[12,2,12,4],[13,2,13,4],[3,1,3,17],[4,1,4,17],[6,2,6,4],[7,2,7,4],[7,6,11,10],[8,2,8,4],[9,2,9,4],[10,2,10,4],[7,13,12,13]]}
[null,"PART SPECIFIC PROCESS FLOW DIAGRAM (PFD)"]
[]
[]
[null,"Process Flow Diagrams is to document and clarify all the steps required in the manufacturing of a part.  "]
[null,"Process flows must include the entire manufacturing process, receiving through shipping."]
[]
[null,"Part #:"]
[null,"Description:",null,null,null,null,"Inspection Key\nA = AUTOMATIC\nM = MANUAL \nV = VISUAL\nQ = QUALITY AUDIT\n",null,null,null,null,null,null,"Changeover Key\nP = PRODUCT\nT = TOOLING\nS = SOFTWARE\nD = DUNNAGE\nL = LABEL\n"]
[null,"HDW / DWG Rev:"]
[null,"Org. Creation Date:"]
[null,"Prepared by:"]
[null,"PFD Revision:"]
[null,"Rev Date:"]
[null,"Revised By:"]
[]
[null,"Example text listed below - Delete prior to usage",null,null,"Operation Type"]
[null,"Op-\nSeq","Process\nCharacteristics\nSources of\nVariation\n(Inputs)","Special\nProcess\nCharacteristic","Administration (A) \nTraceability (T)","Fabrication / Transformation","Move / Transport","Lift / Get / Store","Inspect / Verify","Rework","Scrap / Contain","Packaging Interaction","Changeover","Operation Description\n(Process Function)\n(Do This - To This - With\nThis)\n(Purpose of Operation)","Process Function Priority ","Product\nCharacteristics\n(Outputs)","Special Product\nCharacteristic","Comments"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,"Receiving"]
[null,10.1,"1. box cutter\n2. barcode reader",null,"A / T","X",null,null,null,null,null,null,null,"Open Box & Scan paperwork barcode",null,"Printed Receiver",null,"Traceability"]
[null,10.199999999999999,"barcode reader",null,"T",null,null,"X",null,null,null,null,null,"Get ESD bag",null,"Correct ESD bag",null,"Traceability"]
[null,10.3,"ESD bag",null,null,null,"X",null,null,null,null,null,null,"Place parts in ESD bag",null,"No Damage"]
[null,10.4,"1. Parts\n2. Paperwork\n3. Bin",null,null,null,"X",null,null,null,null,null,null,"Place parts & paperwork in bin on Incoming Inspection Rack (FIFO)",null,"Jobs in order (FIFO)"]
[null,20,null,null,null,null,null,null,null,null,null,null,null,"Incoming Inspection"]
[null,"20.1, 20.2, 20.3, etc"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"Wiper Arm Subassembly"]
[null,"30.1, 30.2, 30.3, etc"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"Route Wire Harness"]
[null,"40.1, 40.2, 40.3, etc"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"Wiper System Installation"]
[null,30.1,"Bar Code reader\nBin Placard",null,"A / T",null,null,"X",null,null,null,null,null,"Get wiper linkage",null,"1) Correct w iper linkage\n2) No damage",null,"Traceability"]
[null,30.2,"Placement of isolators",null,null,"X",null,null,null,null,null,null,null,"Get and manually install isolators",null,"Alignment of isolators to windshield molding","Dimensional placement of\nisolators w ith respect to\nw iper linkage"]
[null,30.3,"Torque tool setting",null,null,"X",null,null,null,null,null,null,null,"Orient and secure w iper linkage to\nbody structure w ith battery torque\ntool",null,"1) Alignment of Linkage to windshield molding\n2) Torque within design\nspecification","Clearance to w indshield","Speed control, rotation\ncontrol, torque control"]
[null,30.4,"30.15 Bar Code reader",null,"T",null,null,"X",null,null,null,null,null,"Get wiper motor",null,"1) Correct wiper motor\n2) No damage",null,"Traceability will be needed"]
[null,30.5,"Locating feature in tray\ndesign\nBattery torque tool",null,null,"X",null,null,null,null,null,null,null,"Orient and secure wiper motor to\nbody and w iper linkage w ith battery\ntorque tool",null,"1) Correct alignment of motor to vehicle\n2) Torque within design specification","Secured with correct\ntorque","Speed control, rotation\ncontrol, torque control"]
[null,30.6,"1) Operation layout to\nenable connector\norientation\n2) Torque tool setup\n2) Torque tool\ncalibration","1: KCC\nDegree of connector\nrotation\n2: KCC\nTool RPM",null,"X",null,null,null,null,null,null,null,"Orient and secure wIper motor\nground w ire to vehicle with battery\ntorque tool",null,"1) Error proof design to prevent connector rotation\n2) Torque","1: CC\nConnector orientation\n2: CC\nGround w ire fastener\ntorque spec","Speed control, rotation\ncontrol, torque control"]

{"sheet":"PM C&E Template","index":25,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":true,"merged":[[1,1,1,2]]}
[null,"Step","Process Input",1,2,3,4,5,6]
[null,"LEVEL OF IMPORTANCE\n TO CUSTOMER RATING\nSCALE OF 1–10",null,8,5,7,6]
[null,"Process Step","Process Input","wire in location ","Repeatability ","meet pull Force ","Properly dressed",null,null,"Total"]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D4,E$2*E4,F$2*F4,G$2*G4,H$2*H4,I$2*I4)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D5,E$2*E5,F$2*F5,G$2*G5,H$2*H5,I$2*I5)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D6,E$2*E6,F$2*F6,G$2*G6,H$2*H6,I$2*I6)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D21,E$2*E21,F$2*F21,G$2*G21,H$2*H21,I$2*I21)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D36,E$2*E36,F$2*F36,G$2*G36,H$2*H36,I$2*I36)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(D$2*D68,E$2*E68,F$2*F68,G$2*G68,H$2*H68,I$2*I68)","v":0}]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,1,2,3,4,5,6]
[null,"Process Step","Process Input"]

{"sheet":"CPK Template","index":26,"n_rows":116,"n_cols":14,"rows_kept":116,"cut":false,"hidden":true,"merged":[[16,9,16,10],[17,9,17,10],[18,9,18,10],[11,6,11,7],[11,8,11,10],[12,9,12,10],[13,9,13,10],[14,9,14,10],[15,9,15,10],[6,13,6,15],[7,1,7,3],[7,4,7,5],[7,13,7,15],[5,1,5,3],[5,4,5,5],[3,8,7,12],[3,6,7,7],[9,6,10,10],[0,1,0,15],[3,1,3,3],[3,4,3,5],[3,13,3,15],[4,1,4,3],[4,4,4,5],[4,13,4,15],[2,1,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,12],[2,13,2,15],[5,13,5,15],[6,1,6,3],[6,4,6,5]]}
[null,"Process Capability Study Worksheet"]
[]
[null,"Part Number:",null,null,null,null,"Supplier Name:",null,null,null,null,null,null,"Date"]
[null,"Drawing Number:",null,null,null,null,"Supplier Address:"]
[null,"Drawing Rev.:",null,null,null,null,null,null,null,null,null,null,null,"Supplier Contact"]
[null,"Rev. Date:"]
[null,"Drawing Location:"]
[null,"Part Feature:"]
[]
[null,"USL",null,null,null,null," Summary"]
[null,"LSL"]
[null,null,null,null,null,null,"Process Data",null,"Potential Capability"]
[null,"Subgroup","Test Value","Range",null,null,"LSL=",{"$f":"C11","v":0},"Cp=",{"$f":"IF(SUM(C14:C63)>0,(C10-C11)/(6*(H16)),\"\")","v":""}]
[null,1,null,null,null,null,"USL=",{"$f":"C10","v":0},"CpkL=",{"$f":"IF(SUM(C14:C63)>0,(AVERAGE(C14:C63)-C11)/(3*H16),\"\")","v":""}]
[null,2,null,{"$f":"ABS(C15-C14)","v":0},null,null,"Mean=",{"$f":"IF(SUM(C14:C63)>0,AVERAGE(C14:C63),\"\")","v":""},"CpkU=",{"$f":"IF(SUM(C14:C63)>0,(C10-AVERAGE(C14:C63))/(3*H16),\"\")","v":""}]
[null,3,null,0,null,null,"StDev",{"$f":"AVERAGE(D15:D63)/1.128","v":0},"Cpk=",{"$f":"MIN(J14,J15)","v":0}]
[null,4,null,0,null,null,"UCLX=",{"$f":"IF(SUM(C14:C63)>0,C64+2.66*D64,\"\")","v":""},"%Cr=",{"$f":"IF(SUM(C14:C63)>0,1/((C10-C11)/(6*AVERAGE(D14:D63)/1.128)),\"\")","v":""}]
[null,5,null,0,null,null,"LCLX=",{"$f":"IF(SUM(C14:C63)>0,C64-2.66*D64,\"\")","v":""},"Max=",{"$f":"MAX(C14:C63)","v":0}]
[null,6,null,0,null,null,"UCLR=",{"$f":"3.267 * D64","v":0},"Min=",{"$f":"MIN(C14:C63)","v":0}]
[null,7,null,0]
[null,8,null,0,null,null,null,"Spec","Frequency"]
[null,9,null,0,null,null,1,{"$f":"$C$11 + $G21*(($C$10-$C$11)/7)","v":0},{"$f":"FREQUENCY(C14:C63,H22:H29)","v":0}]
[null,10,null,0,null,null,2,0,0]
[null,11,null,0,null,null,3,0,0]
[null,12,null,0,null,null,4,0,0]
[null,13,null,0,null,null,5,0,0]
[null,14,null,0,null,null,6,0,0]
[null,15,null,0,null,null,7,0,0]
[null,16,null,0,null,null,8,0,0]
[null,17,null,0]
[null,18,null,0]
[null,19,null,0]
[null,20,null,0]
[null,21,null,0]
[null,22,null,0]
[null,23,null,0]
[null,24,null,0]
[null,25,null,0]
[null,26,null,0]
[null,27,null,0]
[null,28,null,0]
[null,29,null,0]
[null,30,null,0]
[null,31,null,0]
[null,32,null,0]
[null,33,null,0]
[null,34,null,0]
[null,35,null,0]
[null,36,null,0]
[null,37,null,0]
[null,38,null,0]
[null,39,null,0]
[null,40,null,0]
[null,41,null,0]
[null,42,null,0]
[null,43,null,0]
[null,44,null,0]
[null,45,null,0]
[null,46,null,0]
[null,47,null,0]
[null,48,null,0]
[null,49,null,0]
[null,50,null,0]
[null,"Average",{"$f":"IF(ISNUMBER(AVERAGE(C14:C63)), AVERAGE(C14:C63),\"\")","v":""},{"$f":"SUM(D14:D63)/COUNT(D14:D63)","v":0}]
[]
[null,null,"UCLX","LCLX","Mean","UCLR","XmR","Range Average"]
[null,1,{"$f":"$H$17","v":""},{"$f":"$H$18","v":""},{"$f":"$H$15","v":""},{"$f":"$H$19","v":0},{"$f":"SUM($D$14:$D14)/COUNT($D$14:$D14)","v":{"$error":"#DIV/0!"}},{"$f":"$D$64","v":0}]
[null,2,"","","",0,{"$f":"SUM($D$14:$D15)/COUNT($D$14:$D15)","v":0},0]
[null,3,"","","",0,{"$f":"SUM($D$14:$D16)/COUNT($D$14:$D16)","v":0},0]
[null,4,"","","",0,{"$f":"SUM($D$14:$D17)/COUNT($D$14:$D17)","v":0},0]
[null,5,"","","",0,{"$f":"SUM($D$14:$D18)/COUNT($D$14:$D18)","v":0},0]
[null,6,"","","",0,{"$f":"SUM($D$14:$D19)/COUNT($D$14:$D19)","v":0},0]
[null,7,"","","",0,{"$f":"SUM($D$14:$D20)/COUNT($D$14:$D20)","v":0},0]
[null,8,"","","",0,{"$f":"SUM($D$14:$D21)/COUNT($D$14:$D21)","v":0},0]
[null,9,"","","",0,{"$f":"SUM($D$14:$D22)/COUNT($D$14:$D22)","v":0},0]
[null,10,"","","",0,{"$f":"SUM($D$14:$D23)/COUNT($D$14:$D23)","v":0},0]
[null,11,"","","",0,{"$f":"SUM($D$14:$D24)/COUNT($D$14:$D24)","v":0},0]
[null,12,"","","",0,{"$f":"SUM($D$14:$D25)/COUNT($D$14:$D25)","v":0},0]
[null,13,"","","",0,{"$f":"SUM($D$14:$D26)/COUNT($D$14:$D26)","v":0},0]
[null,14,"","","",0,{"$f":"SUM($D$14:$D27)/COUNT($D$14:$D27)","v":0},0]
[null,15,"","","",0,{"$f":"SUM($D$14:$D28)/COUNT($D$14:$D28)","v":0},0]
[null,16,"","","",0,{"$f":"SUM($D$14:$D29)/COUNT($D$14:$D29)","v":0},0]
[null,17,"","","",0,{"$f":"SUM($D$14:$D30)/COUNT($D$14:$D30)","v":0},0]
[null,18,"","","",0,{"$f":"SUM($D$14:$D31)/COUNT($D$14:$D31)","v":0},0]
[null,19,"","","",0,{"$f":"SUM($D$14:$D32)/COUNT($D$14:$D32)","v":0},0]
[null,20,"","","",0,{"$f":"SUM($D$14:$D33)/COUNT($D$14:$D33)","v":0},0]
[null,21,"","","",0,{"$f":"SUM($D$14:$D34)/COUNT($D$14:$D34)","v":0},0]
[null,22,"","","",0,{"$f":"SUM($D$14:$D35)/COUNT($D$14:$D35)","v":0},0]
[null,23,"","","",0,{"$f":"SUM($D$14:$D36)/COUNT($D$14:$D36)","v":0},0]
[null,24,"","","",0,{"$f":"SUM($D$14:$D37)/COUNT($D$14:$D37)","v":0},0]
[null,25,"","","",0,{"$f":"SUM($D$14:$D38)/COUNT($D$14:$D38)","v":0},0]
[null,26,"","","",0,{"$f":"SUM($D$14:$D39)/COUNT($D$14:$D39)","v":0},0]
[null,27,"","","",0,{"$f":"SUM($D$14:$D40)/COUNT($D$14:$D40)","v":0},0]
[null,28,"","","",0,{"$f":"SUM($D$14:$D41)/COUNT($D$14:$D41)","v":0},0]
[null,29,"","","",0,{"$f":"SUM($D$14:$D42)/COUNT($D$14:$D42)","v":0},0]
[null,30,"","","",0,{"$f":"SUM($D$14:$D43)/COUNT($D$14:$D43)","v":0},0]
[null,31,"","","",0,{"$f":"SUM($D$14:$D44)/COUNT($D$14:$D44)","v":0},0]
[null,32,"","","",0,{"$f":"SUM($D$14:$D45)/COUNT($D$14:$D45)","v":0},0]
[null,33,"","","",0,{"$f":"SUM($D$14:$D46)/COUNT($D$14:$D46)","v":0},0]
[null,34,"","","",0,{"$f":"SUM($D$14:$D47)/COUNT($D$14:$D47)","v":0},0]
[null,35,"","","",0,{"$f":"SUM($D$14:$D48)/COUNT($D$14:$D48)","v":0},0]
[null,36,"","","",0,{"$f":"SUM($D$14:$D49)/COUNT($D$14:$D49)","v":0},0]
[null,37,"","","",0,{"$f":"SUM($D$14:$D50)/COUNT($D$14:$D50)","v":0},0]
[null,38,"","","",0,{"$f":"SUM($D$14:$D51)/COUNT($D$14:$D51)","v":0},0]
[null,39,"","","",0,{"$f":"SUM($D$14:$D52)/COUNT($D$14:$D52)","v":0},0]
[null,40,"","","",0,{"$f":"SUM($D$14:$D53)/COUNT($D$14:$D53)","v":0},0]
[null,41,"","","",0,{"$f":"SUM($D$14:$D54)/COUNT($D$14:$D54)","v":0},0]
[null,42,"","","",0,{"$f":"SUM($D$14:$D55)/COUNT($D$14:$D55)","v":0},0]
[null,43,"","","",0,{"$f":"SUM($D$14:$D56)/COUNT($D$14:$D56)","v":0},0]
[null,44,"","","",0,{"$f":"SUM($D$14:$D57)/COUNT($D$14:$D57)","v":0},0]
[null,45,"","","",0,{"$f":"SUM($D$14:$D58)/COUNT($D$14:$D58)","v":0},0]
[null,46,"","","",0,{"$f":"SUM($D$14:$D59)/COUNT($D$14:$D59)","v":0},0]
[null,47,"","","",0,{"$f":"SUM($D$14:$D60)/COUNT($D$14:$D60)","v":0},0]
[null,48,"","","",0,{"$f":"SUM($D$14:$D61)/COUNT($D$14:$D61)","v":0},0]
[null,49,"","","",0,{"$f":"SUM($D$14:$D62)/COUNT($D$14:$D62)","v":0},0]
[null,50,"","","",0,{"$f":"SUM($D$14:$D63)/COUNT($D$14:$D63)","v":0},0]

{"sheet":"MSA Template","index":27,"n_rows":103,"n_cols":17,"rows_kept":103,"cut":false,"hidden":true,"merged":[[11,10,11,15],[12,10,12,15],[13,10,13,15],[14,10,14,15],[0,0,1,17],[3,2,3,3],[3,4,3,6],[3,8,3,9],[3,10,8,17],[4,2,4,3],[4,4,4,6],[5,2,5,3],[7,2,9,9],[11,1,11,4]]}
["GAUGE R&R TEMPLATE"]
[]
[]
[null,"Part Number:",null,null,"Date Completed:",null,null,null,"Comments:"]
[null,"Part Description:",null,null,"Completed By:"]
[null,"Part Rev:"]
[]
[null,"Instructions:","Measure 10 Parts spanning total process output, measured in three random sequences.\nEach Operator completes one set of measurements, then to the next operator.  Repeat for 2 or 3 trials.\nEnter measurements in Measure1 , Measure2 and Measure3."]
[]
[]
[]
[null,"Three Operator Measurement Error Test",null,null,null,null,null,"10 Parts, 3 Operators, 3 Replicates",null,null,{"$f":"IF(I18>=30%,\"Measuring System not suited to detect process changes\",IF(I18<15%,\"OK to use for process improvement\",IF(AND(I18>=15%,I18<30%),\"Measurement Sytem is Marginal and May Need Work\")))","v":"Measuring System not suited to detect process changes"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I24>=30%,\"Measuring System must not  be used for Accept/Reject of parts\", \"OK to use for inspection\")","v":"OK to use for inspection"}]
[null,"Operator","Part Number","Measure1","Measure2","Measure3",null,null,null,null,{"$f":"IF(I19<5,\"Measuring System cannot distinguish between parts well\", \"OK to use for measuring parts\")","v":"Measuring System cannot distinguish between parts well"}]
[null,1,1,0.65200000000000002,0.60199999999999998,0.60399999999999998,null,"# OF TRIALS (2 OR 3)",3,null,{"$f":"IF(P44<0.05,\"Operators have statistically different results\", \"Operators are statistically alike\")","v":"Operators have statistically different results"}]
[null,1,2,1.002,1.002,1.004,null,"Measurement Sigma Est",{"$f":"SQRT(L52)","v":6.7050008976164227E-2},"sms"]
[null,1,3,0.85199999999999998,0.80200000000000005,0.80400000000000005,null,"Total Study Variability",{"$f":"SQRT(L54)","v":0.20411614139247961}]
[null,1,4,0.85199999999999998,0.95199999999999996,0.95399999999999996,null,"%R&R",{"$f":"P47","v":0.32848949876648315}]
[null,1,5,0.55200000000000005,0.45200000000000001,0.45400000000000001,null,"#Distinct Categories",{"$f":"ROUND(O49/O52*1.41,0)","v":1}]
[null,1,6,1.002,1.002,1.004]
[null,1,7,0.95199999999999996,0.95199999999999996,0.95399999999999996,null,"Upper Specification",2.7]
[null,1,8,0.85199999999999998,0.80200000000000005,0.80400000000000005,null,"Lower Specification",0.5]
[null,1,9,1.002,1.002,1.004,null,"Tolerance",{"$f":"I21-I22","v":2.2000000000000002}]
[null,1,10,0.60199999999999998,0.70199999999999996,0.70399999999999996,null,"%P/T Ratio",{"$f":"Q47","v":0.18286366084408423}]
[null,2,1,0.55200000000000005,0.55200000000000005,0.55400000000000005]
[null,2,2,1.052,0.95199999999999996,0.95399999999999996,null,"Diagnostics","%Contrib"]
[null,2,3,0.80200000000000005,0.752,0.754,null,{"$f":"K49","v":"Operator"},{"$f":"M49","v":2.807627580869047E-2}]
[null,2,4,0.80200000000000005,0.752,0.754,null,{"$f":"K51","v":"Sys. Repeatability"},{"$f":"M51","v":2.0513608672126985E-2}]
[null,2,5,0.40200000000000002,0.40200000000000002,0.40400000000000003,null,{"$f":"K52","v":"Total GR&R"},{"$f":"M52","v":0.10790535079985535}]
[null,2,6,1.002,1.052,1.054,null,{"$f":"K53","v":"Part"},{"$f":"M53","v":0.8920946492001447}]
[null,2,7,0.95199999999999996,0.90200000000000002,0.90400000000000003,null,{"$f":"K54","v":"Total Variance"},{"$f":"M54","v":1}]
[null,2,8,0.752,0.70199999999999996,0.70399999999999996]
[null,2,9,1.002,0.95199999999999996,0.95399999999999996,null,null,null,null,"ANOVA Table Without Interaction"]
[null,2,10,0.55200000000000005,0.502,0.504,null,{"$f":"IF(P44<0.05,\"Part*Operator Interaction Significant\",\"\")","v":"Part*Operator Interaction Significant"},null,null,"Source","dF","SS","MS","F","P"]
[null,3,1,0.502,0.55200000000000005,0.55400000000000005,null,null,null,null,"Part",{"$f":"L57","v":9},{"$f":"(OperatorDF+1)*Trials*SUM(N61:N70)","v":3.085},{"$f":"M35/L35","v":0.34277777777777779},{"$f":"N35/N37","v":133.60762234733619},{"$f":"_xlfn.F.DIST.RT(O35,L35,L37)","v":1.2564821586714314E-43}]
[null,3,2,1.052,1.002,1.004,null,null,null,null,"Operator",{"$f":"COUNT(B15:B44)-SUM(L57:L59)-1","v":2},{"$f":"(PartDF+1)*Trials*SUM((N57-N60)^2,(N58-N60)^2,(N59-N60)^2)","v":8.6722222222221979E-2},{"$f":"M36/L36","v":4.3361111111110989E-2},{"$f":"N36/N37","v":16.901255954958767},{"$f":"_xlfn.F.DIST.RT(O36,L36,L37)","v":7.9813916295965996E-7}]
[null,3,3,0.80200000000000005,0.80200000000000005,0.80400000000000005,null,null,null,null,"Repeatability",{"$f":"COUNT(D15:F44)-1-L35-L36","v":78},{"$f":"M38-M36-M35","v":0.20011333333333381},{"$f":"M37/L37","v":2.5655555555555618E-3}]
[null,3,4,0.80200000000000005,0.80200000000000005,0.80400000000000005,null,null,null,null,"Total",{"$f":"COUNT(D15:F44)-1","v":89},{"$f":"SUM(F74:F103)","v":3.3718355555555557}]
[null,3,5,0.45200000000000001,0.502,0.504]
[null,3,6,1.002,1.052,1.054,null,null,null,null,"ANOVA Table With Interaction"]
[null,3,7,0.95199999999999996,0.95199999999999996,0.95399999999999996,null,null,null,null,"Source","dF","SS","MS","F","P"]
[null,3,8,0.80200000000000005,0.80200000000000005,0.80400000000000005,null,null,null,null,"Part",{"$f":"PartDF","v":9},{"$f":"M35","v":3.085},{"$f":"M42/L42","v":0.34277777777777779},{"$f":"N42/N44","v":41.455767077267566},{"$f":"_xlfn.F.DIST.RT(O42,L42,L45)","v":1.7442239417560767E-22}]
[null,3,9,1.052,1.052,1.054,null,null,null,null,"Operator",{"$f":"OperatorDF","v":2},{"$f":"M36","v":8.6722222222221979E-2},{"$f":"M43/L43","v":4.3361111111110989E-2},{"$f":"N43/N44","v":5.2441209406494727},{"$f":"_xlfn.F.DIST.RT(O43,L43,L45)","v":7.9622746823986255E-3}]
[null,3,10,0.85199999999999998,0.80200000000000005,0.80400000000000005,null,null,null,null,"Part*Operator",{"$f":"PartDF*OperatorDF","v":18},{"$f":"M46-M45-M43-M42","v":0.1488333333333336},{"$f":"M44/L44","v":8.2685185185185327E-3},{"$f":"N44/N45","v":9.6745536488126351},{"$f":"_xlfn.F.DIST.RT(O44,L44,L45)","v":9.1353846952433755E-12}]
[null,null,null,null,null,null,null,null,null,null,"Repeatability",{"$f":"COUNT(D15:F44)-1-L42-L43-L44","v":60},{"$f":"(Trials-1)*SUM(K57:K86)","v":5.1280000000000006E-2},{"$f":"M45/L45","v":8.5466666666666677E-4}]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"L38","v":89},{"$f":"M38","v":3.3718355555555557}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O52/O54","v":0.32848949876648315},{"$f":"6*O52/I23","v":0.18286366084408423}]
[null,"Rev 0.1 J. Ficalora",null,null,null,null,null,null,null,null,"MSA Components",null,"%Contribution",null,"Std.Dev.","%R&R","%TOL"]
[null,null,null,null,null,null,null,null,null,null,"Operator",{"$f":"(N43-N45-3*L50)/3/10","v":1.1697530864197485E-3},{"$f":"L49/$L$54","v":2.807627580869047E-2},null,{"$f":"SQRT(L49)","v":3.4201653270269673E-2},{"$f":"O49/$O$54","v":0.16755976787012586},{"$f":"6*O49/$I$23","v":9.3277236191644561E-2}]
[null,null,null,null,null,null,null,null,null,null,"Part*Oper",{"$f":"IF(P44<0.05,(N44-N45)/3,0)","v":2.4712839506172888E-3},{"$f":"IF(P44<0.05,L50/L54,0)","v":5.9315466319037884E-2},null,4.971201012448892E-2,{"$f":"O50/$O$54","v":0.24354766744733541},{"$f":"6*O50/$I$23","v":0.13557820943042431}]
[null,null,null,null,null,null,null,null,null,null,"Sys. Repeatability",{"$f":"IF(P44<0.05,N45,N37)","v":8.5466666666666677E-4},{"$f":"L51/$L$54","v":2.0513608672126985E-2},null,2.9234682599040933E-2,{"$f":"O51/$O$54","v":0.14322572629289398},{"$f":"6*O51/$I$23","v":7.9730952542838893E-2}]
[null,null,null,null,null,null,null,null,null,null,"Total GR&R",{"$f":"SUM(L49:L51)","v":4.495703703703704E-3},{"$f":"L52/$L$54","v":0.10790535079985535},null,6.7050008976164227E-2,{"$f":"O52/$O$54","v":0.32848949876648315},{"$f":"6*O52/$I$23","v":0.18286366084408423}]
[null,null,null,null,null,null,null,null,null,null,"Part",{"$f":"IF(P44<0.05,(N42-N45-3*L50)/9,(N35-N37)/9)","v":3.7167695473251022E-2},{"$f":"L53/$L$54","v":0.8920946492001447},{"$f":"(M42-M43-M44-M45)/(L45+3)","v":4.4415308641975307E-2},0.1927892514463683,{"$f":"O53/$O$54","v":0.94450762262680799},{"$f":"6*O53/$I$23","v":0.5257888675810044}]
[null,null,null,null,null,null,null,null,null,null,"Total Variance",{"$f":"L52+L53","v":4.1663399176954725E-2},{"$f":"SUM(M52:M53)","v":1},null,0.20411614139247961]
[]
[null,"Part Number","Operator1","Operator2","Operator3",null,null,null,null,null,"Var of repeats","df"]
[null,1,{"$f":"AVERAGE(D15:F15)","v":0.6193333333333334},{"$f":"AVERAGE(D25:F25)","v":0.55266666666666675},{"$f":"AVERAGE(D35:F35)","v":0.53600000000000003},null,null,null,null,null,{"$f":"VAR(D15:F15)","v":8.0133333333333478E-4},{"$f":"COUNT(D15:F24)/COUNT(D15:F15)-1","v":9},"Op1bar",{"$f":"AVERAGE(D15:F24)","v":0.82933333333333337},{"$f":"STDEV(D15:F24)","v":0.17894582754398583}]
[null,2,1.0026666666666666,0.9860000000000001,1.0193333333333334,null,null,null,null,null,1.3333333333333357E-6,{"$f":"COUNT(D25:F34)/COUNT(D25:F25)-1","v":9},"Op2bar",{"$f":"AVERAGE(D25:F34)","v":0.76433333333333331},{"$f":"STDEV(D25:F34)","v":0.21156043130026445}]
[null,3,0.81933333333333336,0.76933333333333331,0.80266666666666675,null,null,null,null,null,8.0133333333333109E-4,{"$f":"COUNT(D35:F44)/COUNT(D35:F35)-1","v":9},"Op3bar",{"$f":"AVERAGE(D35:F44)","v":0.83099999999999974},{"$f":"STDEV(D35:F44)","v":0.19105063419833662}]
[null,4,0.91933333333333334,0.76933333333333331,0.80266666666666675,null,null,null,null,null,3.4013333333333317E-3,1,"Ybarbar",{"$f":"AVERAGE(D15:F44)","v":0.80822222222222295}]
[null,5,0.48599999999999999,0.40266666666666673,0.48599999999999999,null,null,null,null,null,3.2680000000000018E-3,"Part1",{"$f":"AVERAGE(D15:F15,D25:F25,D35:F35)","v":0.56933333333333336},{"$f":"(M61-$N$60)^2","v":5.7067901234568237E-2}]
[null,6,1.0026666666666666,1.0360000000000003,1.0360000000000003,null,null,null,null,null,1.3333333333333357E-6,"Part2",1.0026666666666668,3.7808641975308414E-2]
[null,7,0.95266666666666655,0.91933333333333334,0.95266666666666655,null,null,null,null,null,1.3333333333333357E-6,"Part3",0.7971111111111111,1.2345679012347319E-4]
[null,8,0.81933333333333336,0.71933333333333327,0.80266666666666675,null,null,null,null,null,8.0133333333333109E-4,"Part4",0.83044444444444443,4.93827160493794E-4]
[null,9,1.0026666666666666,0.96933333333333327,1.0526666666666669,null,null,null,null,null,1.3333333333333357E-6,"Part5",0.45822222222222231,0.12250000000000046]
[null,10,0.66933333333333334,0.51933333333333331,0.81933333333333336,null,null,null,null,null,3.4013333333333317E-3,"Part6",1.024888888888889,4.6944444444444157E-2]
[null,"Ybar",{"$f":"AVERAGE(D74:D103)","v":0.80822222222222229},null,null,null,null,null,null,null,1.3333333333333357E-6,"Part7",0.94155555555555559,1.7777777777777594E-2]
[null,"Rbar",{"$f":"AVERAGE(E74:E103)","v":3.9466666666666685E-2},null,null,null,null,null,null,null,3.2680000000000053E-3,"Part8",0.78044444444444439,7.7160493827164881E-4]
[null,"d2",{"$f":"IF(I15=3,1.693,1.128)","v":1.6930000000000001},null,null,null,null,null,null,null,8.0133333333333478E-4,"Part9",1.0082222222222221,3.9999999999999675E-2]
[null,"UCL",{"$f":"C67+3*(C68/C69)/SQRT(Trials)","v":0.8485992286439894},null,null,null,null,null,null,null,8.0133333333333478E-4,"Part10",0.66933333333333345,1.9290123456790296E-2]
[null,"LCL",{"$f":"C67-3*(C68/C69)/SQRT(Trials)","v":0.76784521580045517},null,null,null,null,null,null,null,1.3333333333333357E-6]
[null,null,null,null,null,null,null,null,null,null,8.6800000000000158E-4]
[null,"UCL","LCL","Part Averages","Range","SumSqs","Rbar","Mean",null,null,8.0133333333333109E-4]
[null,{"$f":"C70","v":0.8485992286439894},{"$f":"$C$71","v":0.76784521580045517},{"$f":"AVERAGE(D15:F15)","v":0.6193333333333334},{"$f":"IF(OR(D15=\"\",E15=\"\"),\"\",MAX(D15:F15)-MIN(D15:F15))","v":5.0000000000000044E-2},{"$f":"IF(Trials=3,(D15-$N$60)^2+(E15-$N$60)^2+(F15-$N$60)^2,(D15-$N$60)^2+(E15-$N$60)^2)","v":0.10863970370370454},{"$f":"$C$68","v":3.9466666666666685E-2},{"$f":"$C$67","v":0.80822222222222229},null,null,8.0133333333333478E-4]
[null,{"$f":"B74","v":0.8485992286439894},0.76784521580045517,1.0026666666666666,2.0000000000000018E-3,0.11342859259259175,3.9466666666666685E-2,0.80822222222222229,null,null,8.0133333333333478E-4]
[null,0.8485992286439894,0.76784521580045517,0.81933333333333336,4.9999999999999933E-2,1.9730370370369854E-3,3.9466666666666685E-2,0.80822222222222229,null,null,8.0133333333333478E-4]
[null,0.8485992286439894,0.76784521580045517,0.91933333333333334,0.10199999999999998,4.3839703703703187E-2,3.9466666666666685E-2,0.80822222222222229,null,null,8.6800000000000158E-4]
[null,0.8485992286439894,0.76784521580045517,0.48599999999999999,0.10000000000000003,0.3180174814814829,3.9466666666666685E-2,0.80822222222222229,null,null,8.0133333333333478E-4]
[null,0.8485992286439894,0.76784521580045517,1.0026666666666666,2.0000000000000018E-3,0.11342859259259175,3.9466666666666685E-2,0.80822222222222229,null,null,1.3333333333333357E-6]
[null,0.8485992286439894,0.76784521580045517,0.95266666666666655,2.0000000000000018E-3,6.2595259259258587E-2,3.9466666666666685E-2,0.80822222222222229,null,null,1.3333333333333357E-6]
[null,0.8485992286439894,0.76784521580045517,0.81933333333333336,4.9999999999999933E-2,1.9730370370369854E-3,3.9466666666666685E-2,0.80822222222222229,null,null,8.6799999999999963E-4]
[null,0.8485992286439894,0.76784521580045517,1.0026666666666666,2.0000000000000018E-3,0.11342859259259175,3.9466666666666685E-2,0.80822222222222229,null,null,8.6800000000000158E-4]
[null,0.8485992286439894,0.76784521580045517,0.66933333333333334,0.10199999999999998,6.4673037037037667E-2,3.9466666666666685E-2,0.80822222222222229,null,null,1.3333333333333357E-6]
[null,0.8485992286439894,0.76784521580045517,0.55266666666666675,2.0000000000000018E-3,0.19592859259259365,3.9466666666666685E-2,0.80822222222222229,null,null,1.3333333333333357E-6]
[null,0.8485992286439894,0.76784521580045517,0.9860000000000001,0.10000000000000009,0.10135081481481403,3.9466666666666685E-2,0.80822222222222229,null,null,1.3333333333333357E-6]
[null,0.8485992286439894,0.76784521580045517,0.76933333333333331,5.0000000000000044E-2,6.1397037037038728E-3,3.9466666666666685E-2,0.80822222222222229,null,null,8.0133333333333109E-4]
[null,0.8485992286439894,0.76784521580045517,0.76933333333333331,5.0000000000000044E-2,6.1397037037038728E-3,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.40266666666666673,2.0000000000000018E-3,0.49342859259259431,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,1.0360000000000003,5.2000000000000046E-2,0.15738414814814719,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.91933333333333334,4.9999999999999933E-2,3.8639703703703211E-2,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.71933333333333327,5.0000000000000044E-2,2.5306370370370777E-2,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.96933333333333327,5.0000000000000044E-2,7.9473037037036315E-2,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.51933333333333331,5.0000000000000044E-2,0.25197303703703827,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.53600000000000003,5.2000000000000046E-2,0.22405081481481595,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,1.0193333333333334,5.0000000000000044E-2,0.13530637037036947,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.80266666666666675,2.0000000000000018E-3,9.5259259259282043E-5,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.80266666666666675,2.0000000000000018E-3,9.5259259259282043E-5,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.48599999999999999,5.1999999999999991E-2,0.31321748148148287,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,1.0360000000000003,5.2000000000000046E-2,0.15738414814814719,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.95266666666666655,2.0000000000000018E-3,6.2595259259258587E-2,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.80266666666666675,2.0000000000000018E-3,9.5259259259282043E-5,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,1.0526666666666669,2.0000000000000018E-3,0.17926192592592491,3.9466666666666685E-2,0.80822222222222229]
[null,0.8485992286439894,0.76784521580045517,0.81933333333333336,4.9999999999999933E-2,1.9730370370369854E-3,3.9466666666666685E-2,0.80822222222222229]

{"sheet":"PFMEA Template","index":28,"n_rows":64,"n_cols":24,"rows_kept":64,"cut":false,"hidden":true,"merged":[[61,1,61,2],[61,4,61,5],[62,1,62,2],[62,4,62,5],[63,1,63,2],[63,4,63,5],[58,1,58,2],[58,4,58,5],[59,1,59,2],[59,4,59,5],[60,1,60,2],[60,4,60,5],[55,1,55,2],[55,4,55,5],[56,1,56,2],[56,4,56,5],[57,1,57,2],[57,4,57,5],[52,1,52,2],[52,4,52,5],[53,1,53,2],[53,4,53,5],[54,1,54,2],[54,4,54,5],[49,1,49,2],[49,4,49,5],[50,1,50,2],[50,4,50,5],[51,1,51,2],[51,4,51,5],[46,1,46,2],[46,4,46,5],[47,1,47,2],[47,4,47,5],[48,1,48,2],[48,4,48,5],[43,1,43,2],[43,4,43,5],[44,1,44,2],[44,4,44,5],[45,1,45,2],[45,4,45,5],[40,1,40,2],[40,4,40,5],[41,1,41,2],[41,4,41,5],[42,1,42,2],[42,4,42,5],[37,1,37,2],[37,4,37,5],[38,1,38,2],[38,4,38,5],[39,1,39,2],[39,4,39,5],[34,1,34,2],[34,4,34,5],[35,1,35,2],[35,4,35,5],[36,1,36,2],[36,4,36,5],[31,1,31,2],[31,4,31,5],[32,1,32,2],[32,4,32,5],[33,1,33,2],[33,4,33,5],[28,1,28,2],[28,4,28,5],[29,1,29,2],[29,4,29,5],[30,1,30,2],[30,4,30,5],[25,1,25,2],[25,4,25,5],[26,1,26,2],[26,4,26,5],[27,1,27,2],[27,4,27,5],[22,1,22,2],[22,4,22,5],[23,1,23,2],[23,4,23,5],[24,1,24,2],[24,4,24,5],[19,1,19,2],[19,4,19,5],[20,1,20,2],[20,4,20,5],[21,1,21,2],[21,4,21,5],[16,1,16,2],[16,4,16,5],[17,1,17,2],[17,4,17,5],[18,1,18,2],[18,4,18,5],[13,1,13,2],[13,4,13,5],[14,1,14,2],[14,4,14,5],[15,1,15,2],[15,4,15,5],[9,20,11,20],[9,21,11,21],[9,22,11,22],[12,1,12,2],[12,4,12,5],[9,14,11,14],[9,15,11,15],[9,16,11,16],[9,17,11,17],[9,18,11,18],[9,19,11,19],[9,8,11,8],[9,9,11,9],[9,10,11,10],[9,11,11,11],[9,12,11,12],[9,13,11,13],[0,0,2,23],[4,5,4,6],[4,9,4,14],[5,5,5,6],[5,9,5,14],[5,19,5,20],[9,0,11,0],[9,1,11,2],[9,3,11,3],[9,4,11,5],[9,6,11,6],[9,7,11,7],[6,5,6,14],[6,21,6,23],[7,1,7,4],[7,5,7,6],[8,0,8,12],[8,13,8,15],[8,16,8,17],[8,18,8,23],[9,23,11,23]]}
["PROCESS FAILURE MODE EFFECTS ANALYSIS\n(PFMEA)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMEA number"]
[null,null,"Item",null,null,null,null,null,"Process Responsibility",null,null,null,null,null,null,null,null,null,"No. of Pages"]
[null,null,"Part Number",null,null,null,null,null,"Key dates",null,null,null,null,null,null,null,null,null,"Prepared by"]
[null,null,"Core Team",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FMEA date (Orig.)",null,"Rev. Date"]
[]
["Technical Risk Analysis",null,null,null,null,null,null,null,null,null,null,null,null,"Risk Assessment",null,null,"Action Plan",null,"Actions Results"]
["Item (Op-Seq)","Process Function",null,"Requirement(s)","Potential Failure  Mode",null,"Potential Effects of Failure","SEV","Potential Cause(s) of Failure","OCC","Current Process Controls - Prevention (P)","Current Process Controls - Detection (D)","DET","RPN","Product Special Characteristic(s)","Process Special Characteristic(s)","Recommended Action(s)","Responsibility & Target Completion Date","Completion Date","Actions Taken","NEW SEV","NEW OCC","NEW DET","RPN"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H13*J13*M13)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(U13*V13*W13)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U14*V14*W14)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,0]

{"sheet":"Control Plan Instructions","index":29,"n_rows":53,"n_cols":19,"rows_kept":53,"cut":false,"hidden":true,"merged":[[50,1,50,9],[50,10,50,18],[51,1,51,9],[51,10,51,18],[52,1,52,9],[52,10,52,18],[47,0,47,9],[47,10,47,18],[48,1,48,9],[48,10,48,18],[49,1,49,9],[49,10,49,18],[44,1,44,9],[44,10,44,18],[45,1,45,9],[45,10,45,18],[46,1,46,9],[46,10,46,18],[41,1,41,9],[41,10,41,18],[42,0,42,9],[42,10,42,18],[43,1,43,9],[43,10,43,18],[38,1,38,9],[38,10,38,18],[39,1,39,9],[39,10,39,18],[40,1,40,9],[40,10,40,18],[35,1,35,9],[35,10,35,18],[36,1,36,9],[36,10,36,18],[37,1,37,9],[37,10,37,18],[32,1,32,9],[32,10,32,18],[33,1,33,9],[33,10,33,18],[34,1,34,9],[34,10,34,18],[29,1,29,9],[29,10,29,18],[30,1,30,9],[30,10,30,18],[31,1,31,9],[31,10,31,18],[27,1,27,9],[27,10,27,18],[28,1,28,9],[28,10,28,18],[23,1,23,9],[23,10,23,18],[24,1,24,9],[24,10,24,18],[25,1,25,9],[25,10,25,18],[22,1,22,9],[22,10,22,18],[14,11,18,11],[14,12,18,12],[14,13,18,13],[14,14,18,14],[14,15,18,15],[14,16,18,16],[26,1,26,9],[26,10,26,18],[14,0,18,1],[14,2,18,5],[14,6,18,8],[14,9,18,9],[14,10,18,10],[14,17,18,17],[14,18,18,18],[21,1,21,9],[21,10,21,18],[9,13,9,18],[10,0,10,5],[10,6,10,8],[10,9,10,12],[10,13,10,18],[11,2,11,5],[11,13,11,17],[11,18,13,18],[12,2,12,5],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,15,12,16],[12,17,13,17],[13,2,13,5],[6,0,6,8],[6,9,6,12],[6,13,6,18],[7,13,7,18],[8,0,8,8],[8,9,8,12],[8,13,8,18],[0,0,1,18],[2,0,3,0],[2,3,3,3],[2,4,2,5],[2,6,3,6],[3,9,4,12],[3,13,4,15],[3,16,4,18],[4,0,4,3],[4,4,4,8]]}
["BAE CONTROL PLAN INSTRUCTIONS"]
[]
["1A"," Prototype",null,"1B"," Pre-Launch",null,null," Production",null,"Key Contact / Phone",null,null,null,"Date of Origination",null,null,"Date of Latest Revision - ref. electronic rev. history"]
[null,null,null,null,null,null,null,null,null,"xxx-xxx-xxxx",null,null,null,"M/DD/YYYY",null,null,"M/DD/YYYY"]
["Control Plan Number",null,null,null,"xxxxx"]
["Part Number / Latest Revision Change",null,null,null,null,null,null,null,null,"Core Team",null,null,null,"Customer Engineering Approval / Date (If Required)"]
["sssss",null,null,null,null,null,null,null,null,"xxxx"]
["Part Name / Description",null,null,null,null,null,null,null,null,"Supplier / Plant Approval / Date (If Required)",null,null,null,"Customer Quality Approval / Date (If Required)"]
["xxxxxx "]
["Supplier / Plant",null,null,null,null,null,"Supplier Code",null,null,"Other Approval / Date (If Required)",null,null,null,"Other Approval / Date (If Required)"]
["xxxxxx ",null,null,null,null,null,"xxxxxx"]
["Part /",null,"Process Name /",null,null,null,"Machine, Device,",null,null,"Characteristics",null,null,"Special","Methods",null,null,null,null,"Reaction Plan"]
["Process",null,"Operation",null,null,null,"Jig, Tools",null,null,"No.","Product","Process","Char.","Product / Process","Measurement","Sample",null,"Control Method"]
["Number",null,"Description",null,null,null,"for Mfg.",null,null,null,null,null,"Class","Specification / Tolerance","Technique","Size","Frequency"]
[]
[]
[]
[]
[]
[]
[]
["Cell Number","Title",null,null,null,null,null,null,null,null,"Description"]
["1 - 14","Header information",null,null,null,null,null,null,null,null,"Complete all required information on the Master Control Plan form that is hi-lited in light blue"]
["1A","Prototype",null,null,null,null,null,null,null,null,"Indicate the appropriate category\nPrototype - A description of the dimensional measurements, material and performance tests occurring during Prototype build."]
["1B","Pre-Launch",null,null,null,null,null,null,null,null,"Indicate the appropriate category\nPre-launch - A description of the dimensional measurements, material and performance tests that will occur after Prototype and before normal Production."]
["1C","Production",null,null,null,null,null,null,null,null,"Indicate the appropriate category\nProduction - A comprehensive documentation of product/process characteristics, process controls, testes, and measurement systems occurring during normal production."]
[2,"Control Plan Number",null,null,null,null,null,null,null,null,"Enter the control plan document number used for tracking, if applicable."]
[3,"Part Number / Latest Revision Change",null,null,null,null,null,null,null,null,"Enter the number of the system, subsystem or component being controlled. When applicable enter the latest engineering change level and or/issue date from the drawing specification"]
[4,"Part Name / Description",null,null,null,null,null,null,null,null,"Enter the name and description of the product/process being controlled."]
[5,"Supplier / Plant",null,null,null,null,null,null,null,null,"Enter the name of the company and the appropriate division/plant/department preparing the control plan."]
[6,"Supplier Code",null,null,null,null,null,null,null,null,"Enter the identification number as requested by the procuring organization."]
[7,"Key Contact / Phone",null,null,null,null,null,null,null,null,"Enter the name and telephone number of the primary contact responsible for the control plan."]
[8,"Core Team",null,null,null,null,null,null,null,null,"Enter the name(s) and telephone number(s) of the of the individual(s) responsible for preparing the Control Plan to the latest revision.  It is recommended that all of the team members' names, phone numbers, and locations be included on an attached distribution list."]
[9,"Supplier / Plant Approval /Date (If Required)",null,null,null,null,null,null,null,null,"Obtain the responsible manufacturing plant approval (if required)."]
[10,"Date of Origination",null,null,null,null,null,null,null,null,"Enter the date that the original control plan was compiled."]
[11,"Date of Latest Revision - ref. electronic rev. history",null,null,null,null,null,null,null,null,"Enter the date of the latest Control Plan updates.  Revision history will be located in the Revision History Work book for each Control Plan."]
[12,"Customer Engineering Approval / Date (If Required)",null,null,null,null,null,null,null,null,"Obtain the responsible engineering approval (if required)"]
[13,"Customer Quality Approval / Date (If Required)",null,null,null,null,null,null,null,null,"Obtain the responsible supplier quality representative approval (if required)."]
[14,"Other Approval / Date (If Required)",null,null,null,null,null,null,null,null,"Obtain any other agreed upon approval (if required)"]
[15,"Part / Process Number",null,null,null,null,null,null,null,null,"This item number is usually referenced from the Process Flow Chart. If multiple part numbers exist (assembly), list the individual part numbers and their processes accordingly."]
[16,"Process Name / Operation Description",null,null,null,null,null,null,null,null,"All steps in the manufacturing of a system, subsystem, or component are described in a process flow diagram that best describes the activity being addressed."]
[17,"Machine, Device, Jig, Tools for Mfg.",null,null,null,null,null,null,null,null,"For each operation that is described, identify the processing equipment, e.g., machine, device, jig, or other tools for manufacturing, as appropriate."]
["CHARACTERISTICS",null,null,null,null,null,null,null,null,null,"A distinguishing feature, dimension or property of a process or its output (product) on which variable or attribute data can be collected. Use visual aids where applicable."]
[18,"Characteristics No.",null,null,null,null,null,null,null,null,"Enter a cross reference number from all applicable documents such as, but not limited to, process flow diagram, numbered blue print, FMEAs, and sketches (computer generated or otherwise) if required."]
[19,"Characteristics Product",null,null,null,null,null,null,null,null,"Product Characteristics are the features or properties of a part, component or assembly that are described on drawings or other primary engineering information. The Core Team should identify the Special Product Characteristics from all sources. "]
[20,"Characteristics Process.",null,null,null,null,null,null,null,null,"Process Characteristics are the process variables (input variables) that have a cause and effect relationship with the identified Product Characteristic.  The Process Characteristic can only be measured at the time it occurs."]
[21,"Special Char. Class",null,null,null,null,null,null,null,null,"Use the appropriate classification as required by the Customer, to identify the type of special characteristic or this field can be left blank for other undesignated characteristics.  Customers may use unique symbols to identify important characteristics"]
["METHODS",null,null,null,null,null,null,null,null,null,"A systematic plan for using procedures and other tools to control a process."]
[22,"Product / Process Specification / Tolerance",null,null,null,null,null,null,null,null,"Specifications/tolerance may be obtained from various engineering documents, such as, but not limited to , drawings, design reviews, material standard, computer aided design data, manufacturing, and/or assembly requirements."]
[23,"Measurement Technique",null,null,null,null,null,null,null,null,"This column identifies the measurement system being used.  This could include gages, fixtures, tools, and/or test equipment required to measure the part/process/manufacturing equipment."]
[24,"Sample Size / Sample Frequency",null,null,null,null,null,null,null,null,"When sampling is required list the corresponding sample size and frequency."]
[25,"Control Method",null,null,null,null,null,null,null,null,"This column contains a brief description of how the operation will be controlled, including procedure numbers where applicable.  The control method utilized should be based on effective analysis of the process. "]
[26,"Reaction Plan",null,null,null,null,null,null,null,null,"The reaction plan specifies the corrective actions necessary to avoid producing nonconforming products or operating out of control.  The actions should normally be the responsibility of the people closest to the process, the operator, jobsetter, or supervisor."]

{"sheet":"CP Template","index":30,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[[11,7,11,11],[11,12,13,12],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,9,12,10],[12,11,13,11],[8,0,8,2],[8,3,8,6],[8,7,8,10],[8,11,8,12],[10,0,10,1],[10,3,10,6],[10,7,10,10],[10,11,10,12],[6,0,6,2],[6,3,6,6],[6,7,6,10],[6,11,6,12],[0,0,2,12],[3,11,3,12],[4,3,4,6],[4,7,4,10],[4,11,5,12]]}
["BAE CONTROL PLAN"]
[]
[]
["Proto-Type","Pre-Launch","Production","Key Contact / Phone",null,null,null,"Date of Origination",null,null,null,"Date of Latest Revision - ref. electronic rev. history"]
["Control Plan Number",null,null,null,null,null,null,"M/DD/YY",null,null,null,"M/DD/YY"]
["Part Number / Latest Revision Change",null,null,"Core Team",null,null,null,"Customer Engineering Approval / Date (If Required)"]
[]
["Part Name / Description",null,null,"Supplier / Plant Approval / Date (If Required)",null,null,null,"Customer Quality Approval / Date (If Required)"]
[]
["Supplier / Plant",null,"Supplier Code","Other Approval / Date (If Required)",null,null,null,"Other Approval / Date (If Required)"]
[]
["Part /","Process Name /","Machine, Device,","Characteristics",null,null,"Special","Methods",null,null,null,null,"Reaction Plan"]
["Process","Operation","Jig, Tools","No.","Product","Process","Char.","Product / Process","Measurement","Sample",null,"Control Method"]
["Number","Description","for Mfg.",null,null,null,"Class","Specification / Tolerance","Technique","Size","Freq."]

{"sheet":"PR Template","index":31,"n_rows":32,"n_cols":16,"rows_kept":32,"cut":false,"hidden":true,"merged":[[29,5,31,5],[0,1,0,5],[2,1,2,2],[3,1,3,2],[4,1,5,3],[4,4,5,5],[6,1,6,2],[26,1,27,1],[8,1,11,1],[12,1,15,1],[16,1,18,1],[19,1,21,1],[22,1,25,1]]}
[null,"PEER REVIEW FORM"]
[]
[null,"8D No:",null,null,"Date Raised: "]
[null,"Reviewed By:",null,null,"Review Date: "]
[null,"Standard Achieved: ",null,null,{"$f":"IF(N30<>35,\"NOT TO REQUIRED STANDARD\",IF(M30=\"Gold\",\"Gold\",IF(L30=\"Silver\",\"Silver\",IF(K30=\"Bronze\",\"Bronze\",IF(J30=\"Blue\",\"Blue\",IF(I30=\"Red\",\"Red\",\"Not to minimum required standard\"))))))","v":"NOT TO REQUIRED STANDARD"},null,null,null,null,null,null,"YES"]
[null,null,null,null,null,null,null,null,null,null,null,"NO"]
[null,null,null,"Question","Result","Comments",null,null,"Red","Blue","Bronze","Silver","Gold","Sum"]
[null,"Step 1",1,"Has the problem been clearly defined? Does the problem description clearly state the nonconformity description, the requirement and the deviation from the requirement?",null,null,null,null,{"$f":"IF($E8=$L$5,1,0)","v":0},{"$f":"IF($E8=$L$5,1,0)","v":0},0,0,0,{"$f":"SUM(I8:M8)","v":0}]
[null,"Step 2",2,"Is response to containment adequate?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I9:M9)","v":0}]
[null,null,3,"Has containment been implemented within 48Hrs of concern being raised?",null,null,null,null,null,0,0,0,0]
[null,null,4,"Has containment implemented proved effective?",null,null,null,null,null,0,0,0,0]
[null,null,5,"Has there been adequate containment read across? \n(If not applicable answer N/A)",null,null,null,null,null,{"$f":"IF($E12=$L$5,1,IF($E12=\"N/A\",1,0))","v":0},{"$f":"IF($E12=$L$5,1,IF($E12=\"N/A\",1,0))","v":0},{"$f":"IF($E12=$L$5,1,IF($E12=\"N/A\",1,0))","v":0},{"$f":"IF($E12=$L$5,1,IF($E12=\"N/A\",1,0))","v":0}]
[null,"Step 3",6,"Is there a Statement of Root Cause of escape ?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I13:M13)","v":0}]
[null,null,7,"Is there adequate evidence of the root cause('s) of escape  e.g testing, validation of Escape root cause?",null,null,null,null,null,0,0,0,0]
[null,null,8,"Have suitable tools been used and is there objective evidence of tool usage?\n(If not applicable answer N/A)",null,null,null,null,null,{"$f":"IF($E15=$L$5,1,IF($E15=\"N/A\",1,0))","v":0},{"$f":"IF($E15=$L$5,1,IF($E15=\"N/A\",1,0))","v":0},{"$f":"IF($E15=$L$5,1,IF($E15=\"N/A\",1,0))","v":0},{"$f":"IF($E15=$L$5,1,IF($E15=\"N/A\",1,0))","v":0}]
[null,null,9,"Is there clear statement of actions taken to Prevent Further escapes ?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I16:M16)","v":0}]
[null,"Step 4",10,"Has the root cause of escape been actioned?",null,null,null,null,null,0,0,0,0]
[null,null,11,"Have actions been verified for there effectivness?",null,null,null,null,null,{"$f":"IF($E18=$L$5,1,0)","v":0},0,0,0]
[null,null,12,"Is there evidence of adequate read across?\n(If not applicable answer N/A)",null,null,null,null,null,{"$f":"IF($E19=$L$5,1,IF($E19=\"N/A\",1,0))","v":0},{"$f":"IF($E19=$L$5,1,IF($E19=\"N/A\",1,0))","v":0},{"$f":"IF($E19=$L$5,1,IF($E19=\"N/A\",1,0))","v":0},{"$f":"IF($E19=$L$5,1,IF($E19=\"N/A\",1,0))","v":0}]
[null,"Step 5",13,"Is there a Statement of Root Cause of problem?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I20:M20)","v":0}]
[null,null,14,"Is there adequate information / data to show true root cause has been identified?",null,null,null,null,null,0,0,0,0]
[null,null,15,"Have suitable tools been used to determine true root cause? \n(If applicable - If not applicable answer Yes)",null,null,null,null,null,{"$f":"IF($E22=$L$5,1,IF($E22=\"N/A\",1,0))","v":0},{"$f":"IF($E22=$L$5,1,IF($E22=\"N/A\",1,0))","v":0},{"$f":"IF($E22=$L$5,1,IF($E22=\"N/A\",1,0))","v":0},{"$f":"IF($E22=$L$5,1,IF($E22=\"N/A\",1,0))","v":0}]
[null,"Step 6",16,"Is there clear statement of actions taken to Prevent Further Problems?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I23:M23)","v":0}]
[null,null,17,"Has the root cause of the problem been actioned?",null,null,null,null,null,0,0,0,0]
[null,null,18,"Have actions been verified for there effectivness?",null,null,null,null,null,0,0,0,0]
[null,null,19,"Is there evidence of adequate read across?\n(If not applicable answer N/A)",null,null,null,null,null,{"$f":"IF($E26=$L$5,1,IF($E26=\"N/A\",1,0))","v":0},{"$f":"IF($E26=$L$5,1,IF($E26=\"N/A\",1,0))","v":0},{"$f":"IF($E26=$L$5,1,IF($E26=\"N/A\",1,0))","v":0},{"$f":"IF($E26=$L$5,1,IF($E26=\"N/A\",1,0))","v":0}]
[null,"Step 7",20,"Have all actions implemented been verified and data provided to prove effectivness?",null,null,null,null,0,0,0,0,0,{"$f":"SUM(I27:M27)","v":0}]
[null,null,21,"Go and review the corrective actions to check the processes are being worked?\n(If not applicable answer N/A)",null,null,null,null,null,{"$f":"IF($E28=$L$5,1,IF($E28=\"N/A\",1,0))","v":0},{"$f":"IF($E28=$L$5,1,IF($E28=\"N/A\",1,0))","v":0},{"$f":"IF($E28=$L$5,1,IF($E28=\"N/A\",1,0))","v":0},{"$f":"IF($E28=$L$5,1,IF($E28=\"N/A\",1,0))","v":0}]
[null,"General",22,"Has all revelant documentation been updated to reflect corrective actions taken?",null,null,null,null,0,0,0,0,0]
[null,null,null,"Quantity YES",{"$f":"COUNTIF(E8:E29,\"YES\")","v":0},"Note : If there has been no escape, Step 3 & 4 will not be applicable, therefore, record the result as Yes and provide details in the Comments box.",null,null,{"$f":"IF(SUM(I8:I29)<=7,\"Red\",\"Failed\")","v":"Red"},{"$f":"IF(SUM(J8:J29)>=10,\"Blue\",\"Failed\")","v":"Failed"},{"$f":"IF(SUM(K8:K29)>=14,\"Bronze\",\"Failed\")","v":"Failed"},{"$f":"IF(SUM(L8:L29)>=19,\"Silver\",\"Failed\")","v":"Failed"},{"$f":"IF(SUM(M8:M29)=22,\"Gold\",\"Failed\")","v":"Failed"},{"$f":"SUM(N8:N29)","v":0},null,{"$f":"IF(N30<35,\"1\")","v":"1"}]
[null,null,null,"Quantity NO",{"$f":"COUNTIF(E8:E29,\"NO\")","v":0}]
[null,null,null,"Percentage score:",{"$f":"IFERROR(E30/(E30+E31),\"\")","v":""}]