{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["8D Report - PSS 2018 (engl.)","D2 - IS - IS NOT","D4.1-2 - Delta Examination","D4.1-2 - Ishikawa","D4.2 - 5 Why","Check List (engl.)","OPL Template","Evaluation","8D Report - PSS 2018 (deutsch)","Check Liste (deutsch)","OPL Example","Front page","Variables"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":8,"defined_names":309,"comments":7,"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":"8D Report - PSS 2018 (engl.)","index":0,"n_rows":148,"n_cols":14,"rows_kept":148,"cut":false,"hidden":false,"merged":[[140,0,146,0],[48,0,56,0],[52,9,52,11],[53,1,53,4],[53,5,53,8],[53,9,53,11],[54,1,54,4],[54,5,54,8],[54,9,54,11],[55,9,55,11],[56,1,56,4],[56,5,56,8],[56,9,56,11],[76,2,76,3],[76,5,76,6],[74,2,74,3],[75,8,75,10],[76,8,76,10],[75,2,75,3],[62,6,62,7],[99,1,99,11],[60,9,60,10],[61,9,61,10],[62,9,62,10],[1,12,3,13],[144,12,146,12],[34,12,37,12],[34,13,37,13],[44,12,47,12],[44,13,47,13],[73,12,76,12],[73,13,76,13],[96,12,99,12],[96,13,99,13],[110,12,113,12],[110,13,113,13],[124,12,127,12],[124,13,127,13],[136,12,139,12],[136,13,139,13],[27,1,30,7],[21,1,25,7],[65,9,65,10],[61,6,61,7],[61,2,61,4],[62,2,62,4],[55,1,55,4],[55,5,55,8],[144,13,146,13],[70,6,70,7],[67,6,67,7],[96,8,96,10],[95,2,95,3],[95,5,95,6],[95,8,95,10],[96,2,96,3],[96,5,96,6],[64,9,64,10],[70,2,70,4],[7,10,8,11],[9,4,10,6],[9,7,10,9],[9,10,10,11],[11,4,12,6],[11,7,12,9],[11,10,12,11],[13,4,14,6],[13,7,14,9],[13,10,14,11],[38,0,47,0],[57,0,76,0],[145,8,146,11],[9,1,10,3],[11,1,12,3],[13,1,14,3],[102,2,102,8],[103,2,103,8],[104,2,104,8],[105,2,105,8],[106,2,106,8],[107,2,107,8],[116,2,116,8],[124,2,124,8],[75,5,75,6],[68,2,68,4],[69,2,69,4],[16,1,18,11],[36,1,37,2],[36,3,37,11],[63,6,63,7],[125,2,125,8],[126,2,126,8],[63,9,63,10],[97,0,99,0],[60,2,60,4],[73,5,73,6],[111,2,111,8],[112,2,112,8],[113,2,113,8],[123,2,123,8],[117,2,117,8],[118,2,118,8],[119,2,119,8],[93,8,93,10],[90,9,90,10],[85,9,85,10],[68,9,68,10],[69,9,69,10],[70,9,70,10],[67,9,67,10],[66,9,66,10],[74,8,74,10],[80,9,80,10],[73,8,73,10],[83,9,83,10],[84,9,84,10],[98,1,98,11],[4,0,37,0],[77,0,96,0],[90,2,90,4],[63,2,63,4],[64,2,64,4],[65,2,65,4],[66,2,66,4],[93,2,93,3],[93,5,93,6],[80,2,80,4],[67,2,67,4],[90,6,90,7],[83,2,83,4],[84,2,84,4],[64,6,64,7],[65,6,65,7],[66,6,66,7],[68,6,68,7],[69,6,69,7],[80,6,80,7],[74,5,74,6],[83,6,83,7],[84,6,84,7],[94,2,94,3],[2,1,3,5],[60,6,60,7],[2,6,3,9],[2,10,3,11],[7,1,8,3],[6,1,6,3],[6,4,6,6],[6,7,6,9],[6,10,6,11],[19,8,35,11],[45,5,45,11],[40,1,40,8],[41,1,41,8],[43,1,43,8],[44,1,44,8],[52,1,52,4],[52,5,52,8],[4,4,4,11],[46,1,46,11],[47,1,47,11],[5,1,5,11],[32,1,35,7],[7,4,8,6],[7,7,8,9],[1,0,3,0],[73,2,73,3],[94,5,94,6],[94,8,94,10],[81,6,81,7],[81,9,81,10],[82,2,82,4],[82,6,82,7],[82,9,82,10],[85,2,85,4],[85,6,85,7],[86,2,86,4],[86,6,86,7],[86,9,86,10],[87,2,87,4],[87,6,87,7],[87,9,87,10],[88,2,88,4],[88,6,88,7],[88,9,88,10],[89,2,89,4],[89,6,89,7],[89,9,89,10],[81,2,81,4],[147,12,149,12],[147,13,149,13],[100,0,112,0],[138,2,138,8],[139,2,139,8],[134,2,134,8],[135,2,135,8],[136,2,136,8],[137,2,137,8],[130,2,130,8],[131,2,131,8],[114,0,127,0],[128,0,139,0],[144,5,144,7],[144,2,144,4],[144,8,144,11],[145,1,146,1],[145,2,146,4],[145,5,146,7],[127,2,127,8],[120,2,120,8],[121,2,121,8],[109,2,109,8],[110,2,110,8]]}
["CIP@ST - Be Better Be Faster",null,"8D Report & Problem Solving Sheet for 8D Attachment"]
["D1 \nTeam","Team Leader (Responsible Party):",null,null,null,null,"8D/CAR Nr.:",null,null,null,"Date:",null,"Pre- Evaluation"]
[null,"Team Members:"]
[]
["D2 \nProblem Description","First Problem Description (Symptom):"]
[]
[null,"Central Questions",null,null,"Is",null,null,"Is Not",null,null,"Differences or Changes"]
[null,"What exactly is the problem?"]
[]
[null,"Where exactly is the problem observed?"]
[]
[null,"When exactly was the problem observed?"]
[]
[null,"How often exactly has the problem occurred?\n(e.g. nonrecurring or recurring)"]
[]
[null,"Which facts help define the specific problem, such as data, pareto analysis, trend charts, pictures, ....(summarize, provide links to your analysis)"]
[]
[]
[]
[null,"Fundamental Problem: Describe the fundamental problem, occurrence and effects comprehensibly and",null,null,null,null,null,null,"Picture"]
[null,"unambiguously (including detailed quantitative data: what,where,when,how much,who..)"]
[]
[]
[]
[]
[]
[null,"Explain your preliminary risk level selection (QI/MQI/SQI):"]
[]
[]
[]
[]
[null,"Describe the impact on customers and end users:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M35=\"Basic\",4,IF(M35=\"Excellent\",5,0))","v":0}]
[]
[null,"Briefly Summarize the \nFundamental Problem:"]
[]
["D3 \nContainment Actions","Describe the actions to minimize the problem until the root cause is eliminated clearly. Introduce with deadlines and responsibilities."]
[null,"A. Actions to minimize impact on future customers/end users:",null,null,null,null,null,null,null,"Responsible","Date","Status"]
[]
[]
[null,"B. Actions to minimize impact on existing customers/end users:",null,null,null,null,null,null,null,"Responsible","Date","Status"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M45=\"Basic\",1,IF(M45=\"Excellent\",2,0))","v":0}]
[null,"C. Describe effectiveness of containment actions:"]
[]
[]
["D4.1 Cause and Effect \nAnalysis","Determine Possible Causes (Fundamental Considerations) and define Direct Causes"]
[null,"Identify relevant functions, cause and effect relationships (physical, chemical, technical, …) and compare target and actual state."]
[null,"Derive all possible causes on the basis of understanding of content and function."]
[null,"Prioritize and mark the causes which may be contributing to the problem. Distinguish between occurrence and non detection."]
[null,"Probable Causes\n(functions)",null,null,null,"Target State",null,null,null,"Actual State"]
[]
[]
[]
[]
["D4.2 Cause and Effect \nAnalysis - Occurrence","Work out Technical Root Cause (TRC) and Managerial Root Cause (MRC). "]
[null,"Select the main causes of the problem and identify the real root causes of each with 5 times why."]
[null,"Distinguish between technical (TRC) and managerial (MRC) root cause and mark each real root cause with TRC or MRC."]
[null,"5 Times Why","Direct Root Cause 1:",null,null,"Work out\nTRC & MRC","Direct Root Cause 2:",null,"Work out \nTRC & MRC","Direct Root Cause 3:",null,"Work out \nTRC & MRC"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?",null,null,null,"TRC 1"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?",null,null,null,"MRC 1"]
[]
[null,"Define the risk of interaction of the found root causes related to other products/processes/locations:"]
[null,"Risk to other:","Products",null,"Risk Level","Processes",null,"Risk Level","Locations",null,null,"Risk Level",null,{"$f":"IF(M74=\"Basic\",4,IF(M74=\"Excellent\",6,0))","v":0}]
[]
[]
[]
["D4.2 Cause and Effect\n Analysis - Non Detection","Work out Technical Root Cause (TRC) and Managerial Root Cause (MRC). "]
[null,"Select the three main causes of the problem from the diagram and identify the real root causes of each with 5 times why."]
[null,"Distinguish between technical (TRC) and managerial (MRC) root cause and mark each real root cause with TRC or MRC."]
[null,"5 Times Why","Direct Root Cause 1:",null,null,"Work out \nTRC & MRC","Direct Root Cause 2:",null,"Work out \nTRC & MRC","Direct Root Cause 3:",null,"Work out \nTRC & MRC"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?",null,null,null,"TRC 1"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?"]
[null,"Why?",null,null,null,"MRC 1"]
[]
[null,"Define the risk of interaction of the found root causes related to other processes/products/locations:"]
[null,"Risk to other:","Products",null,"Risk Level","Processes",null,"Risk Level","Locations",null,null,"Risk Level"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97=\"Basic\",4,IF(M97=\"Excellent\",6,0))","v":0}]
["D4 Risk ","Describe and explain the final risk level selection (QI/MQI/SQI) after the successful root cause analysis."]
[]
[]
["D5/D6_a \nCorr. Action (Occurrence)","Identify and document the specific actions to be taken to eliminate all found root causes occurrence (TRC and MRC)."]
[null,"Nr.TRC/MRC","Describe the corrective actions to eliminate the root causes (occurrence)",null,null,null,null,null,null,"Responsible","Date","Status"]
[null,"TRC 1"]
[null,"MRC 1"]
[]
[]
[]
[]
[null,"Nr.TRC/MRC","Describe the actions to verify the efficiency of the corrective action (occurrence)",null,null,null,null,null,null,"Responsible","Date","Status"]
[null,"TRC 1"]
[null,"MRC 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M111=\"Basic\",2,IF(M111=\"Excellent\",3,0))","v":0}]
[]
[]
[]
["D5/D6_b \nCorr. Action (Non-detection)","Identify and document the specific actions to be taken to eliminate all found root causes non detection (TRC and MRC)."]
[null,"Nr.TRC/MRC","Describe the corrective actions to eliminate the root causes (non detection)",null,null,null,null,null,null,"Responsible","Date","Status"]
[null,"TRC 1"]
[null,"MRC 1"]
[]
[]
[]
[]
[null,"Nr.TRC/MRC","Describe the actions to verify the efficiency of the corrective action (non detection)",null,null,null,null,null,null,"Responsible","Date","Status"]
[null,"TRC 1"]
[null,"MRC 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M125=\"Basic\",2,IF(M125=\"Excellent\",3,0))","v":0}]
[]
[]
[]
["D7 \nPreventive Actions","QM documentation"]
[null,"Nr.","Describe actions to be taken to standardize the solution",null,null,null,null,null,null,"Responsible","Date","Status"]
[]
[]
[null,"Lessons Learned - started on all concerned products, processes and locations."]
[null,"Describe actions to share transferred recommendations to related products/processes/locations.",null,null,null,null,null,null,null,"Responsible","Date","Status"]
[null,"Product"]
[]
[null,"Process",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M137=\"Basic\",2,IF(M137=\"Excellent\",3,0))","v":0}]
[]
[null,"Location"]
[]
["D8 Final","Final Meeting",null,"Date:"]
[null,"Participants final meeting:"]
[]
[]
[null,"Approvers","Responsible Party (Team Leader)",null,null,"Sponsor",null,null,"Plant or BU Manager",null,null,null,null,{"$f":"IF(M145=\"Basic\",1,IF(M145=\"Excellent\",2,0))","v":0}]
[null,"Sign & Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(N35:N147)","v":0}]

{"sheet":"D2 - IS - IS NOT","index":1,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[[54,1,56,2],[54,3,56,3],[57,0,57,3],[57,4,57,13],[42,0,44,0],[42,1,44,2],[42,3,44,3],[45,0,56,0],[45,1,47,2],[45,3,47,3],[48,1,50,2],[48,3,50,3],[51,1,53,2],[51,3,53,3],[3,8,3,10],[30,0,41,0],[30,1,33,2],[30,3,33,3],[34,1,37,2],[34,3,37,3],[38,1,41,2],[38,3,41,3],[3,6,4,6],[3,7,4,7],[15,0,29,0],[15,1,19,2],[15,3,19,3],[20,1,24,2],[20,3,24,3],[25,1,29,2],[25,3,29,3],[5,0,14,0],[5,1,9,2],[5,3,9,3],[10,1,14,2],[10,3,14,3],[3,11,4,11],[0,0,0,2],[0,3,0,9],[0,11,0,13],[1,0,1,2],[1,3,1,9],[1,11,1,13],[3,12,4,12],[3,13,4,13],[4,9,4,10],[2,0,4,2],[2,3,4,3],[2,4,3,4],[2,5,3,5],[2,8,2,10],[2,11,2,13]]}
["Problem:",null,null,null,null,null,null,null,null,null,"No."]
["Author:",null,null,null,null,null,null,null,null,null,"Date/Version"]
["Collection of facts",null,null,"No.","IS","IS-NOT","Difference",null,"Changes",null,null,"Proceeding"]
[null,null,null,null,null,null," between IS and IS-Not\n(with proof)","Date","What has changed regarding the difference?",null,null,"open points\nto be clarified","who","until when"]
[null,null,null,null,null,"(but could be ?)",null,null,"Time","Description"]
["What ?","object with defect\n(Supplier, plant, \ncustomer, application)",null,1]
[]
[]
[]
[]
[null,"defect at object\n(from analysis)",null,2]
[]
[]
[]
[]
["Where ?","geographically is the object with defect observed",null,3]
[]
[]
[]
[]
[null,"in process \n is failure observed?",null,4]
[]
[]
[]
[]
[null,"at the object is the observed \n(from analysis)",null,5]
[]
[]
[]
[]
["When ?","occured first, was observed or claimed the object with defect? ",null,6]
[]
[]
[]
[null,"again trend, repetition, rythm of occurence)",null,7]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"in life cycle of the object is the defect observed",null,8]
[]
[]
[]
["Who ?","has observed the failure?",null,9]
[]
[]
["How many ?","how many objects\nshow the failure",null,10]
[]
[]
[null,"how much at the object \nis affected",null,11]
[]
[]
[null,"how many defects \nat the object",null,12]
[]
[]
[null,"tendancy, trend",null,13]
[]
[]
["Fundamental problem"]
[null,null,null,null," ",null,null,null,null," "]
[null," "]
[]
[null," "]

{"sheet":"D4.1-2 - Delta Examination","index":2,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[3,0,3,2],[3,7,3,8],[0,0,0,4],[0,5,0,8],[1,0,2,2],[1,3,1,6],[1,7,2,8],[7,0,7,2],[7,7,7,8],[8,0,8,2],[8,7,8,8],[4,0,4,2],[4,7,4,8],[5,0,5,2],[5,7,5,8],[6,0,6,2],[6,7,6,8]]}
["Surch direction (stress resp. strength due to  fundamental problem):"]
["Probable causes",null,null,"Detailed delta examination",null,null,null,"Result\ndecision for next step"]
[null,null,null,"Target state","Actual state","Deviation (∆)","Reason for the deviation (evidence)"]

{"sheet":"D4.1-2 - Ishikawa","index":3,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,14,14,15],[17,2,22,14],[11,14,11,15],[12,14,12,15],[13,2,13,3],[13,6,13,7],[13,10,13,11],[13,14,13,15],[10,14,10,15],[2,2,2,3],[2,6,2,7],[2,10,2,11],[7,4,7,5],[7,8,7,9],[7,12,7,13],[7,14,7,15],[8,4,8,5],[8,8,8,9],[8,12,8,13],[8,14,8,15]]}
[]
[]
[null,null,"Man\ne.g. involved people",null,null,null,"Machine \ne.g. IT system, process equip.",null,null,null,"Material\ne.g. reports, work orders etc."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic Problem:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Color Legend:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Can't be changed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No influence"]
[null,null,"Method\ne.g. process",null,null,null,"Environment\ne.g. working environment",null,null,null,"Other…",null,null,null,"Influence"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Critical influence"]
[]
[]
[null,null,"Change Log:\n[dd.mmm.yyyy] \n\n"]

{"sheet":"D4.2 - 5 Why","index":4,"n_rows":23,"n_cols":15,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,3,2,13],[3,3,3,13],[4,3,4,13],[8,3,8,13],[16,3,16,13],[9,3,9,13],[11,3,11,13],[14,3,14,4],[14,5,14,6],[14,7,14,13],[15,3,15,4],[15,5,15,6],[15,7,15,13]]}
[]
[]
[]
[null,null,"Problem description"]
[null,null,"Product"," "]
[null,null,"Complaint Number:"]
[]
[null,null,"Detection Date:"]
[]
[]
[null,null,"8D (or 5x Why) Team Leader:"]
[]
[null,null,"8D Sponsor:"]
[]
[null,null,"Review Participants:"]
[null,null,"5x Why Team Meeting Date(s):"]
[]
[]
[null,null,"Direct Causes","1. Why?","2. Why?","3. Why?","4. Why?","5. Why?","6. Why?","7. Why?","8. Why?","9. Why?","10. Why?","Action / Countermeasure ","Responsible Person & due date"]
[null,"1) Why did it occur?\nWrite the \"Direct Causes\" here:"]
[]
[]
[null,"2) Why was it not detected?\nWrite the \"Direct Causes\" here:"]

{"sheet":"Check List (engl.)","index":5,"n_rows":160,"n_cols":8,"rows_kept":160,"cut":false,"hidden":false,"merged":[[77,1,93,1],[97,1,114,1],[118,1,131,1],[135,1,146,1],[150,1,156,1],[75,1,75,4],[1,1,1,3],[3,1,9,1],[13,1,26,1],[30,1,47,1],[51,1,73,1]]}
[null,"8D - Checklist to Tick",null,null,"Guideline for Assessments\n*  Excellent\n** Additional Information","V.2\n.xls"]
[null,"D1 – Establishing Problem Solving Team / Project ",null,null,"D1: no Assessment"]
[null,null,null,null,null,null,null," Is the meeting of the 8D-team organized and well prepared?\n"]
[null,"Problem solving team",null,null,"Is a team leader and sponsor defined? (Authority)                         "]
[]
[null,null,null,null,"Is the team qualified for the task?"]
[]
[null,null,null,null,"Are customers or suppliers necessary in the team?"]
[]
[null,null,null,null," Is the meeting of the 8D team organized and well prepared?"]
[]
[null,"D2 – Problem Description"]
[]
[null,"Clear and traceable problem description, incl. relevant data.  The occurred problem of the customer is understood. \n",null,null,"Was the failure verified at inspection?"]
[]
[null,null,null,null,"Is the problem clearly described? (Defect / defect location, Smallest Possible Object - SPO)"]
[]
[null,null,null,null,"Are all relevant data available? (Type, Serial-no., 0h/field failure, delivered quantity, complained quantity,  tool-No, mould No, "]
[null,null,null,null,"returned quantity, production date period, concerning products/product families, concerned customers, repetitive failure yes/no)"]
[]
[null,null,null,null,"Is it a repeated failure and are there previous 8D reports? If yes, reference to previous 8D report or relevant actions from it."]
[]
[null,null,null,null,"Is the risk of the failure evaluated and the risk level (QI/MQI/SQI) selected and described?"]
[null,null,null,null," (Risk for the customer and Bosch ST: expenses, hazard and liability)."]
[]
[null,null,null,null,"* Is the impact on the customer product known and described? Which risk does the customer have after assembly of the "]
[null,null,null,null,"defective part? Which function is affected? How was the failure detected (testing method, location, e.g. assembly?"]
[]
[null,"D3 – Containment Actions"]
[]
[null,"Customer is protected against further problems by \n respective measures.\n\n Containment actions include checking those products\n that are similar or constructed in the same way.\n",null,null,"Secure the current ongoing production; all internal production lines, processes, locations, products, blocking of"]
[null,null,null,null,"inventory and  work plan, information to employees, action is fixed."]
[]
[null,null,null,null,"Check stock and parts in circulating stock. Who, when, who and how was informed?"]
[null,null,null,null,"Stock at ST, goods in transit, customer, service, other customers , similar  products (e.g. other size), plant to plant delivery. "]
[]
[null,null,null,null,"Have results been well documented? E.g. 80 parts in warehouse 4711, checked 100, 96 o.k., 4 found with failures,"]
[null,null,null,null,"(e.g. description of testing method & characteristics (What, how, how often, how many?) ® rework / scrap?)"]
[]
[null,null,null,null,"If considered measures are not in use, it’s required to give a clear explanation of the risk (proof by data, e.g. quantity, costs)."]
[]
[null,null,null,null,"Tracking of implementation of defined action?  Is the expected efficiency described?"]
[]
[null,null,null,null,"Has it been ensured that the implemented containment actions will not initiate or cause new additional problems?"]
[]
[null,null,null,null,"Is the customer informed, if necessary?"]
[]
[null,null,null,null,"* Evaluation of efficiency of containment actions are done."]
[]
[null,"D4 – Cause and Effects Analysis"]
[]
[null,"Occurrence (Root Cause Analysis for occurrence)\n - Technical explanation for the occurrence of the non-conformity\n - root cause within managerial process\nNon-detection (Root Cause Analysis for non-detection)\n - Technical explanation for the non-detection of the non-conformity\n - root cause within managerial process\nExplanation:\nDirect cause = Straight reason for non-conformity;\nRoot cause = Reason why direct cause occurred.\nDifference Root Cause:\nTRC: Technical Root Cause\nMRC: Managerial Root Cause\n",null,null,"Are the possible root causes of the problem analyzed (differentiate between occurrence and non detection)?"]
[null,null,null,null,"Collection of all possible causes and systematic evaluation to detect the possible root cause."]
[]
[null,null,null,null,"*Systematic identification of possible causes using techniques like Ishikawa? (binding demand at ST!)"]
[]
[null,null,null,null,"Define root cause: Are root causes for occurrence analyzed?"]
[null,null,null,null,"Why could the failure occur? TRC and MRC in the management system."]
[]
[null,null,null,null,"*Systematic identification of root causes using 5 x why technique? (binding demand at ST!)"]
[]
[null,null,null,null,"*Complete TRC and MRC incl. business processes and leadership was worked out."]
[null,null,null,null,"Others: "]
[null,null,null,null,"Define root cause: Are root causes for non-detection analyzed?"]
[null,null,null,null,"Why could the failure not be detected? TRC and MRC in the management  system."]
[]
[null,null,null,null,"*Systematic identification of root causes using 5 x why technique? (binding demand at ST!)"]
[]
[null,null,null,null,"*Complete TRC and MRC incl. business processes and leadership was worked out."]
[]
[null,null,null,null,"Others"]
[null,null,null,null,"Is the risk of the failure evaluated and described within the 8D-Report? Effects on other products / processes / locations."]
[]
[null,null,null,null,"** Why did the failure not occur earlier?"]
[]
[null,"D5 – Defining Corrective Actions and Proving Effectiveness"]
[]
[null,"- Mention all possible corrective actions, independent on \n    expenses and total conversion time.\n\n- BASIC principle: Defect prevention is better than \n   defect detection.",null,null,"Are actions with responsibilities and dates against all in D4 root causes listed"]
[null,null,null,null,"Against occurrence and non- detection, TRC and MRC in management system considered?"]
[]
[null,null,null,null,"* Against occurrence and non- detection, complete TRC and MRC considered?"]
[]
[null,null,null,null,"Is the evidence for effectiveness of the corrective action proved? (e.g. via feasible description or test)"]
[]
[null,null,null,null,"Is there a clear link between counter measures and root cause (D4)?"]
[]
[null,null,null,null,"Is the basic principle, “Defect prevention is better than defect detection” considered? Check first if the occurrence of the failure"]
[null,null,null,null,"can be avoided. If this is not possible, it has to be explained and it has to be focused on the detection of the failure."]
[]
[null,null,null,null,"* Is verified that the corr. action doesn’t cause unexpected problems and secondary effects?(Consider other products/process)"]
[]
[null,null,null,null,"* Are all actions described in a clear and comprehensive way?"]
[]
[null,null,null,null," ** Ensure that internal information stay intern (e.g. expected effort, efficiency of action, expected costs)."]
[]
[null,"D6 – Implementing Corrective Actions and Proving Effectiveness "]
[]
[null,"Occurrence\nCounter measure against occurrence of the non-conformity (in consideration of the product, the respective process and the basic conditions).\nNon-Detection\nCounter measure for detecting the non-conformity \n(in consideration of the product, the respective process \nand the basic conditions).\nValidation of counter measure\nEvidence / proof in practice of the effectiveness after\nimplementation of the measure, e.g. in running production. \nA theoretical verification is done before.\n",null,null,"Which action will be implemented against occurrence of the root cause? "]
[]
[null,null,null,null,"Which action will be implemented to detect the root cause ?"]
[]
[null,null,null,null,"Is the implementation of the action planned and scheduled? Are closing date, milestones, responsibilities fixed? "]
[]
[null,null,null,null,"Are all systems, processes, process instructions and work instructions etc. updated?"]
[]
[null,null,null,null,"Is the decision made to remove the containment action?"]
[]
[null,null,null,null,"* Is checked and ensured that the problem is effectively eliminated (Validation)? E.g. tracking of efficiency within"]
[null,null,null,null,"QAM, failure statistic, detection via introduced failure-part verified? Documentation of result."]
[]
[null,null,null,null,"* If applicable: Is a Poka Yoke corrective action implemented?"]
[]
[null,null,null,null,"* The MRC in the business processes and/or Leadership is fixed and effectively introduced."]
[]
[null,null,null,null,"** Are higher levels of hierarchy involved? (e.g. approval - Resources, Budget, actions with MRC)."]
[]
[null,"D7 – Establishing Preventive Actions"]
[]
[null,"-  Update of QM system (PQP, FMEA etc.…)\n- Preventive actions to avoid recurrence of the defect\n\n",null,null,"Is the improvement of the QM-System clearly documented? "]
[]
[null,null,null,null,"Who was informed about necessary activities?"]
[]
[null,null,null,null,"Which documents (e.g. FMEA, working instruction, CP) are updated? (e.g. document No, -title, FMEA No?"]
[]
[null,null,null,null,"What was changed (short description of the changes)?"]
[]
[null,null,null,null,"Are the identified improvement measures defined as requirements and transferred to other comparable products / processes / plants?"]
[null,null,null,null,"Yes? - What is to do? Who (Customer, Supplier, Other plants/Production sites) was informed by who?"]
[null,null,null,null,"No?   - Please describe why not needed?"]
[]
[null,null,null,null,"* Feedback of Lessons Learned (LL) network is available, e.g. Feedback of implementation in FMEA or feedback of"]
[null,null,null,null,"implementation in not directly affected areas."]
[]
[null,"D8 – Final Meeting"]
[]
[null,"Was the closure of 8D signed?",null,null,"Was the final 8D-Report signed by Team leader, Sponsor and QMM for external complaints"]
[]
[null,null,null,null,"* Is the closed 8D additional signed by Plant leader, BU-Management?"]
[]
[null,null,null,null,"* Has a final discussion with the 8D-Team taken place? What was good? What must be improved?"]
[null,null,null,null,"Are the results / expertise documented?"]
[]
[null,null,null,null,"* Has the self - assessment with the 8D Evaluation tool taken place?"]
[]
[null,null,null,null,"* Is the customer informed about the final conclusions?"]
[]
[null,null,null,null,"** Are all necessary information / documents attached in the 8D-Report?"]
[]
[null,"Attachments",null,null,"Attachments: No Assessment"]
[]
[null," Was the closure of 8D signed?",null,null,"Data Collection"]
[]
[null,null,null,null,"Ishikawa"]
[]
[null,null,null,null,"5x Why"]
[]
[null,null,null,null,"Inspection reports, drawings, photos etc."]
[]
[]
[null,"V2.06 / 2013-Oct-23\nST/QMM1 Koerv"]

{"sheet":"OPL Template","index":6,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[1,0,1,13],[4,0,5,1],[4,2,5,5],[4,6,5,6],[4,7,5,12]]}
[]
["CIP  - Open Point List"]
[]
[]
["Status Date: ",null," ",null,null,null,"Department/Meeting:   "," "]
[]
["No","Date Initiated","Source of Topic (Step D1-D8)","Project (A3)","Problem (PSS)","Task","Topic or Task","Priority","Solution or Brief Status \n[effectiveness check for solution\n(tasks only)]","Responsible Party","Planned","Revised","Actual","Status\nView Definitions"]
[1,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null," N"]
[2,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null," P"]
[3,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null," D"]
[4,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null," C"]
[5,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null," A"]
[6,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[7,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,"N/A"]
[8,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,"\"Just Do It\""]
[9,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,"Low Priority"]
[10,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,"Med Priority"]
[11,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,"High Priority"]
[12,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[13,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[14,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[15,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[16,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[17,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[18,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[19,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[20,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[21,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[22,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[23,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[24,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[25,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[26,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[27,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[28,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[29,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null," "]
[30,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[31,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[32,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[33,null,null,null,null,null,null,null,null,null,null,null,null," N",null,null,null,null," "]
[34,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[35,null,null,null,null,null,null,null,null,null,null,null,null," N"]
[]
[null,"P  P","Deadlines and responsibilities of the measure/task(s) are defined",null,null,null,null,null,"Back to Status","           D D","Implementation of the measure/task(s) proceeds"]
[null,"C  C","Measure/task(s) has been implemented",null,null,null,null,null,null,"            A  A","Efficiency of the measure/tasks(s) is proved"]

{"sheet":"Evaluation","index":7,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["8D Evaluation Tool (CDQ 907: Appendix 6)"]
["Content:","- Web based evaluation tool for 8D cases."]
["Link:","http://www.intranet.bosch.com/app/CQMC_8DEvaluation/8DEvaluationSheet.aspx"]
["Important:","- CAR Number Definition in 8D Tool:    Use “000000”+CAR Number\n  Example: CAR 120052 –> 8D Report Number 000000120052"]
[null,"- Attachment of Signed Evaluation Sheet:\n  The scanned and signed evaluation sheet shall be attached to the CAR System."]
[]
[]
[]
["Booklet 16 - „Problem Solving“ – „8D Method”"]
["Content:","- Terms and definitions "]
[null,"- Descriptions of Steps D1 to D8"]
["Link:","CGP 01900-016"]
[]
[]
["Root Cause Definition (Booklet 16)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Managerial Root Cause, consists of:"]
[null,"1.Systemic Root Cause"]
[null,"a) Management System, Root Cause: "]
[null,"Example: Quality of FMEA, Control Plan, use of design rules and "]
[null,"norms, product and process release…"]
[null,"b) Business Processes, Root Cause: "]
[null,"Example: How the use of a preventive quality tool or design rules is"]
[null,"defined or regulated"]
[null,"2.Leadership Root Cause: "]
[null,"Example: How the organization was set up, tasks and "]
[null,"responsibilities defined and how competences and "]
[null,"capacities were managed, how decisions were taken"]

{"sheet":"8D Report - PSS 2018 (deutsch)","index":8,"n_rows":148,"n_cols":14,"rows_kept":148,"cut":false,"hidden":false,"merged":[[140,0,146,0],[144,12,146,12],[144,13,146,13],[147,12,149,12],[147,13,149,13],[110,12,113,12],[110,13,113,13],[124,12,127,12],[124,13,127,13],[136,12,139,12],[136,13,139,13],[144,2,144,4],[144,5,144,7],[144,8,144,11],[145,1,146,1],[145,2,146,4],[145,5,146,7],[145,8,146,11],[127,2,127,8],[128,0,139,0],[130,2,130,8],[131,2,131,8],[134,2,134,8],[135,2,135,8],[77,0,96,0],[1,12,3,13],[34,12,37,12],[34,13,37,13],[44,12,47,12],[44,13,47,13],[73,12,76,12],[73,13,76,13],[96,12,99,12],[96,13,99,13],[57,0,76,0],[13,10,14,11],[6,4,6,6],[6,7,6,9],[6,10,6,11],[4,4,4,11],[5,1,5,11],[9,4,10,6],[9,7,10,9],[9,10,10,11],[11,4,12,6],[11,7,12,9],[11,10,12,11],[73,2,73,3],[116,2,116,8],[117,2,117,8],[118,2,118,8],[119,2,119,8],[136,2,136,8],[137,2,137,8],[138,2,138,8],[139,2,139,8],[114,0,127,0],[120,2,120,8],[121,2,121,8],[123,2,123,8],[124,2,124,8],[125,2,125,8],[126,2,126,8],[97,0,99,0],[98,1,98,11],[99,1,99,11],[100,0,113,0],[102,2,102,8],[103,2,103,8],[104,2,104,8],[105,2,105,8],[106,2,106,8],[107,2,107,8],[109,2,109,8],[110,2,110,8],[111,2,111,8],[112,2,112,8],[113,2,113,8],[95,2,95,3],[95,5,95,6],[95,8,95,10],[96,2,96,3],[96,5,96,6],[96,8,96,10],[93,2,93,3],[93,5,93,6],[93,8,93,10],[94,2,94,3],[94,5,94,6],[94,8,94,10],[89,2,89,4],[89,6,89,7],[89,9,89,10],[90,2,90,4],[90,6,90,7],[90,9,90,10],[87,2,87,4],[87,6,87,7],[87,9,87,10],[88,2,88,4],[88,6,88,7],[88,9,88,10],[85,2,85,4],[85,6,85,7],[85,9,85,10],[86,2,86,4],[86,6,86,7],[86,9,86,10],[82,9,82,10],[83,2,83,4],[83,6,83,7],[83,9,83,10],[84,2,84,4],[84,6,84,7],[84,9,84,10],[80,2,80,4],[80,6,80,7],[80,9,80,10],[81,2,81,4],[81,6,81,7],[81,9,81,10],[82,2,82,4],[82,6,82,7],[75,2,75,3],[75,5,75,6],[75,8,75,10],[76,2,76,3],[76,5,76,6],[76,8,76,10],[73,5,73,6],[73,8,73,10],[74,2,74,3],[74,5,74,6],[74,8,74,10],[69,2,69,4],[69,6,69,7],[69,9,69,10],[70,2,70,4],[70,6,70,7],[70,9,70,10],[67,2,67,4],[67,6,67,7],[67,9,67,10],[68,2,68,4],[68,6,68,7],[68,9,68,10],[65,2,65,4],[65,6,65,7],[65,9,65,10],[66,2,66,4],[66,6,66,7],[66,9,66,10],[62,9,62,10],[63,2,63,4],[63,6,63,7],[63,9,63,10],[64,2,64,4],[64,6,64,7],[64,9,64,10],[60,2,60,4],[60,6,60,7],[60,9,60,10],[61,2,61,4],[61,6,61,7],[61,9,61,10],[62,2,62,4],[62,6,62,7],[38,0,47,0],[40,1,40,8],[41,1,41,8],[43,1,43,8],[44,1,44,8],[45,5,45,11],[46,1,46,11],[47,1,47,11],[4,0,37,0],[13,1,14,3],[16,1,18,11],[19,8,35,11],[21,1,25,7],[27,1,30,7],[32,1,35,7],[13,4,14,6],[13,7,14,9],[9,1,10,3],[11,1,12,3],[7,4,8,6],[7,7,8,9],[7,10,8,11],[54,9,54,11],[1,0,3,0],[2,1,3,5],[2,6,3,9],[2,10,3,11],[6,1,6,3],[7,1,8,3],[48,0,56,0],[55,1,55,4],[55,5,55,8],[55,9,55,11],[56,1,56,4],[56,5,56,8],[56,9,56,11],[52,1,52,4],[52,5,52,8],[52,9,52,11],[53,1,53,4],[53,5,53,8],[53,9,53,11],[54,1,54,4],[54,5,54,8],[36,1,37,2],[36,3,37,11]]}
["CIP@ST - Be Better Be Faster",null,"8D Report & Problem Lösungsblatt für 8D Anhang"]
["D1 \nTeam","Team Leiter (Verantwortlich):",null,null,null,null,"8D/CAR Nr.:",null,null,null,"Datum:",null,"Pre- Evaluation"]
[null,"Team Mitglieder:"]
[]
["D2 \nProblem Beschreibung","Erste Problem Beschreibung (Symptom):"]
[]
[null,"Zentrale Fragen",null,null,"Ist",null,null,"Ist Nicht",null,null,"Unterschiede/Änderungen"]
[null,"Was genau ist das Problem?"]
[]
[null,"Wo genau wurde das Problem beobachtet?"]
[]
[null,"Wann genau wurde das Problem beobachtet?"]
[]
[null,"Wie oft genau ist das Problem aufgetreten?"]
[]
[null,"Welche Fakten helfen das spezifische Problem zu definieren, z.B. Daten, Pareto Analysen, Trendkurven, Bilder…(Links zu den Analysen)?"]
[]
[]
[]
[null,"Beschreibe das Grundproblem, Auftreten und Wirkung nachvollziehbar und eindeutig",null,null,null,null,null,null,"Bild"]
[null," (inklusive detaillierte quantitativer Daten: Was, Wo, Wann, Wieviel, Wer…)"]
[]
[]
[]
[]
[]
[null,"Erkläre deine vorläufige Risiko Kategorie Auswahl (QI/MQI/SQI):"]
[]
[]
[]
[]
[null,"Beschreibe die Auswirkungen auf den Kunden und Endverbraucher:"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M35=\"Basic\",4,IF(M35=\"Excellent\",5,0))","v":0}]
[]
[null,"Fasse das Grundpro-blem kurz zusammen:"]
[]
["D3 \nSofort Maßnahmen","Beschreibe die Maßnahmen um das Problem zu minimieren bis die Ursache eindeutig beseitigt ist. Definiere Termine&Verantwortungen."]
[null,"A. Maßnahmen um Auswirkungen auf zukünftige Kunden/Endverbraucher zu minimieren:",null,null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[]
[]
[null,"B. Maßnahmen um Auswirkungen auf existierende Kunden/Endverbraucher zu minimieren:",null,null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M45=\"Basic\",1,IF(M45=\"Excellent\",2,0))","v":0}]
[null,"C. Beschreibe die Wirksamkeit der Sofort Maßnahmen:"]
[]
[]
["D4.1 Ursache und Wirkungs \nAnalyse","Ermittle wahrscheinliche Grundursachen (Grundsätzliche Überlegungen) und definiere die direkten Grundursachen"]
[null,"Identifiziere relevante Funktionen, Ursachen und Wirkzusammenhang (physikalisch, chemisch, technisch, …) und vergleiche Ziel und Ist Zustand."]
[null,"Sammle die direkten Ursachen die zum Auftreten des Problems beitragen können und weise es den vordefinierten Kategorien zu:"]
[null,"Prioriziere und markiere die Ursachen die wahrscheinlich zum Problem beitragen. Unterscheide zwischen Auftreten und Nicht Entdecken."]
[null,"Wahrscheinliche Ursache\n(Funktion)",null,null,null,"Ziel Zustand",null,null,null,"Ist Zustand"]
[]
[]
[]
[]
["D4.2 Ursache und Wirkungs\n Analyse - Auftreten","Ermittle die technische Grundursache (TRC) und die Grundursache im Management (MRC)."]
[null,"Wähle die Hauptursachen des Problems aus und identifiziere die endgültige Grundursache mit \"5 mal warum\"."]
[null,"Unterscheide zwischen technischer (TRC) und managment (MRC) Grundursache und markiere jede Grundurache mit TRC oder MRC."]
[null,"5 mal Warum","Direkte Grundursache 1:",null,null,"Ermittle \nTRC & MRC","Direkte Grundursache 2:",null,"Ermittle\nTRC & MRC","Direkte Grundursache 3:",null,"Ermittle \nTRC & MRC"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?",null,null,null,"TRC 1"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?",null,null,null,"MRC 1"]
[]
[null,"Definiere das Risiko der Wechselwirkung der gefundenen Grundursache auf andere Produkte/Prozesse/Standorte:"]
[null,"Risiko zu:","Produkten",null,"Risiko","Prozesse",null,"Risiko","Standorte",null,null,"Risiko",null,{"$f":"IF(M74=\"Basic\",4,IF(M74=\"Excellent\",6,0))","v":0}]
[]
[]
[]
["D4.2 Ursache und Wirkungs\n Analyse - Nicht Entdeckung","Ermittle die technische Grundursache (TRC) und die Grundursache im Management (MRC). "]
[null,"Wähle die drei Hauptursachen des Problems aus dem Diagramm und identifiziere die endgültige Grundursache mit \"5 mal warum\"."]
[null,"Unterscheide zwischen technischer (TRC) und managment (MRC) Grundursache und markiere jede Grundursache mit TRC oder MRC."]
[null,"5 mal Warum","Direkte Grundursache  1:",null,null,"Ermittle \nTRC & MRC","Direkte Grundursache  2:",null,"Ermittle\nTRC & MRC","Direkte Grundursache  3:",null,"Ermittle \nTRC & MRC"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?",null,null,null,"TRC 1"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?"]
[null,"Warum?",null,null,null,"MRC 1"]
[]
[null,"Definiere das Risiko der Wechselwirkung der gefundenen Grundursache auf andere Produkte/Prozesse/Standorte:"]
[null,"Risiko zu:","Produkten",null,"Risiko","Prozesse",null,"Risiko","Standorte",null,null,"Risiko"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M97=\"Basic\",4,IF(M97=\"Excellent\",6,0))","v":0}]
["D4 \nRisiko ","Erkläre deine endgültige Risiko Kategorie Auswahl (QI/MQI/SQI) nach der erfolgreichen Grundursachen Analyse:"]
[]
[]
["D5/D6_a \nKorr.Maßnahme (Auftreten)","Ermittle und dokumentiere die geeigneten Maßnahmen um alle gefundenen Grundursachen Auftreten (TRC und MRC) zu beseitigen."]
[null,"Nr.TRC/MRC","Beschreibe die Korrekturmaßnahmen um die Grundursache (Auftreten) zu eliminieren",null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[null,"TRC 1"]
[null,"MRC 1"]
[]
[]
[]
[]
[null,"Nr.TRC/MRC","Beschreibe die Maßnahmen um die Effektivität der Korrekturmaßnahme (Auftreten) zu überprüfen.",null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[null,"TRC 1"]
[null,"MRC 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M111=\"Basic\",2,IF(M111=\"Excellent\",3,0))","v":0}]
[]
[]
[]
["D5/D6_b \nKorr.Maßnahme (Nicht Entdeckung)","Ermittle und dokumentiere die geeigneten Maßnahmen um alle gef. Grundursachen Nicht Entdeckung (TRC und MRC) zu beseitigen."]
[null,"Nr.TRC/MRC","Beschreibe die Korrekturmaßnahmen um die Grundursache (Nicht Entdeckung) zu eliminieren",null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[null,"TRC 1"]
[null,"MRC 1"]
[]
[]
[]
[]
[null,"Nr.TRC/MRC","Beschreibe die Maßnahmen um die Effektivität der Korrekturmaßnahme (Nicht Entdeckung) zu überprüfen.",null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[null,"TRC 1"]
[null,"MRC 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M125=\"Basic\",2,IF(M125=\"Excellent\",3,0))","v":0}]
[]
[]
[]
["D7 \nPräventiv Maßnahme","QM Dokumentation"]
[null,"Nr.","Beschreibe die Maßnahmen die ergriffen werden müssen um die Lösung zu standardisieren",null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[]
[]
[null,"Lessons Learned - für alle betroffenen Produkte, Prozesse und Standorte gestartet"]
[null,"Beschreibe Maßnahmen zum Verbreiten der übertragenen Empfehlungen auf verwandte Produkte/Prozesse/Standorte",null,null,null,null,null,null,null,"Verantwortlich","Datum","Status"]
[null,"Produkt"]
[]
[null,"Prozess",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M137=\"Basic\",2,IF(M137=\"Excellent\",3,0))","v":0}]
[]
[null,"Standort"]
[]
["D8 \nAbschluß","Abschlussbesprechung",null,"Date:"]
[null,"Teilnehmer Abschlussbesprechung:"]
[]
[]
[null,"Genehmiger","Verantwortlich (Team Leiter)",null,null,"Sponsor",null,null,"Werks oder BU Manager",null,null,null,null,{"$f":"IF(M145=\"Basic\",1,IF(M145=\"Excellent\",2,0))","v":0}]
[null,"Unterschrift & Datum"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Summe",{"$f":"SUM(N35:N147)","v":0}]

{"sheet":"Check Liste (deutsch)","index":9,"n_rows":160,"n_cols":6,"rows_kept":160,"cut":false,"hidden":false,"merged":[[118,1,131,1],[135,1,146,1],[150,1,156,1],[3,1,9,1],[13,1,26,1],[30,1,47,1],[51,1,73,1],[77,1,93,1],[97,1,114,1]]}
[null,"8D - Checkliste zum Abhaken",null,null,"Richtlinie für Bewertung\n* Ausgezeichnet\n** zusätzliche Information","V.2\n.xls"]
[null,"D1 – Problemlösungsteam / Projekt einrichten",null,null,"D1: keine Bewertung"]
[]
[null,"Problemlösungsteam",null,null,"Ist ein geeigneter Teamleiter und Pate verpflichtet (Weisungsbefugnis)?                                  "]
[]
[null,null,null,null,"Ist das benannte Team für die Aufgabe geeignet?"]
[]
[null,null,null,null,"Werden Kunden oder Lieferanten im Team benötigt?"]
[]
[null,null,null,null,"Ist das Treffen des 8D-Teams organisiert und angemessen vorbereitet? "]
[]
[null,"D2 – Problembeschreibung"]
[]
[null,"Klare, nachvollziehbare Beschreibung des Problems, inkl. Angabe relevanter Daten. Das aufgetretene Problem des Kunden ist verstanden.\n",null,null,"Wurde bei der Befundung der Fehler eindeutig festgestellt? "]
[]
[null,null,null,null,"Ist das Problem nachvollziehbar beschrieben? (Fehler  -(bild ) / Fehlerort, Smallest Possible Object - SPO)"]
[]
[null,null,null,null,"Sind alle relevante Daten vorhanden/angegeben? Typ, Seriennr., 0h-/Feldausfall, Liefer-, beanstandete Menge, Kavitäten-, WZ-"]
[null,null,null,null," Nr., rückgel. Menge, Produktionszeitraum, betroffene Produkte/Produktfamilien, betr. Kunden, Wiederholfehler: ja / nein)"]
[]
[null,null,null,null,"Handelt es sich um einen Wiederholfehler? Verweis auf früheren 8D-Bericht bzw. relevante Maßnahmen aus diesem."]
[]
[null,null,null,null,"Ist das Risiko des Fehlers bewertet und das Risiko Niveau (QI/MQI/SQI) gewählt und beschrieben? "]
[null,null,null,null,"(Risiko für den Kunden und Bosch ST: Kosten, Gefahr und Produkthaftung)"]
[]
[null,null,null,null,"* Ist das Problem aus Sicht des Kunden detailliert beschrieben? Welches Risiko hat der Kunde nach der Montage des defekten"]
[null,null,null,null,"Teils? Welche Funktion wird nicht erfüllt? Wie und wo wurde der Fehler festgestellt (Prüfmethode, Ort)?"]
[]
[null,"D3 – Sofortmaßnahmen"]
[]
[null,"- Kunde wird durch geeignete Maßnahmen vor zukünftigen Schäden bewahrt.\n- Bei Sofortmaßnahmen sind ähnliche oder baugleiche Produkte berücksichtigt.\n",null,null,"Absicherung der laufenden Fertigung; alle Linien, Prozesse, Standorte, Produkte, Sperrung der  Bestände /  des Arbeitsplans"]
[null,null,null,null,"    (Fertigungs-, Liefersperre, Information an Mitarbeiter, Vorgehen ist festgelegt)"]
[]
[null,null,null,null,"Prüfung und Absicherung der Bestände, Warenlager, Transportweg, Kundenlager, Service, Weitere Kunden, baugleiche Teile"]
[null,null,null,null,"    (z.B.: andere Größe), Werk zu Werk (wer, wann, von wem und wie wird informiert?)"]
[]
[null,null,null,null,"Sind Ergebnisse aussagefähig dokumentiert? z. B. Lager 4711, Bestand: 100, geprüft: 100, i.O.: 96, AS: 1, NA: 3 mit"]
[null,null,null,null,"    Verfahren x z. B. Beschreibung der Prüfmethode / Prüfkriterien (Was, wie, wie oft, welche Menge?)"]
[]
[null,null,null,null,"Ist begründet, warum naheliegende Maßnahmen nicht durchgeführt werden? (Nachweis, z. B. Stückzahlen,  Kosten, etc.)"]
[]
[null,null,null,null,"Wird die Umsetzung der Maßnahme nachgehalten? Ist die Wirksamkeit der Sofortmaßnahmen gegeben / beschrieben?"]
[]
[null,null,null,null,"Ist abgesichert, dass die Maßnahmen keine  neuen / anderen  negativen Auswirkungen hat?  "]
[]
[null,null,null,null,"Sind  ggf. Kunden über getroffene Maßnahmen informiert?"]
[]
[null,null,null,null,"* Effizienz der Sofortmaßnahme (n) ist bewertet  "]
[]
[null,"D4 – Ursachen-Wirkungs-Analyse"]
[]
[null,"Auftreten (Ursachenanalyse für die Abweichung):\n   - Technische Erklärung für Auftreten der Abweichung\n   - Ursache im Geschäftsprozeß\nNicht-Entdeckung (Ursachenanalyse für d. Nicht-Entdeckung):\n  - Technische Erklärung für Nicht-Entdeckung der Abweichung   \n- Ursache im Geschäftsprozess Wieso wurde die Abweichung nicht rechtzeitig entdeckt?\nErläuterung:\n  Auslöser = Direkter Grund für den Fehler\n  Ursache = Grund  für das Auftreten des Auslösers\nUnterscheidung Grundursachen:\n  TRC: Technische Grundursache (Technical Root  Cause)\n  MRC: Ursache im Geschäftsprozess (Managerial Root Cause)\n\n\n",null,null,"Sind die möglichen Ursachen  des Problems analysiert (unterscheide zwischen Auftreten und Nicht Entdecken des Fehlers)?"]
[null,null,null,null,"Sammlung aller möglichen Ursachen und systematische Bewertung mit dem Ziel, die zutreffendsten Ursachen zu erkennen!"]
[]
[null,null,null,null,"* Systematische Ursachenfindung mit  Ishikawa (Verpflichtend bei ST)."]
[]
[null,null,null,null,"Wurden die Grundursachen für das Auftreten analysiert?"]
[null,null,null,null,"Warum konnte der Fehler auftreten? TRC und  MRC im Managementsystem."]
[]
[null,null,null,null,"* Systematische  Analyse der  Grundursachen für das Auftreten mit  5xWhy (Verpflichtend bei ST)."]
[]
[null,null,null,null,"* Kompletter MRC inkl. Geschäftsprozess und Führung (Organisation, Personal) ist dargelegt."]
[]
[null,null,null,null,"Wurden die Grundursachen für das Nicht-Entdecken analysiert?"]
[null,null,null,null,"Warum wurde der Fehler nicht entdeckt (TRC und MRC im Managementsystem, z. B. Prüflücke im Fertigungsprozess)?"]
[]
[null,null,null,null,"* Systematische  Analyse der  Grundursachen für das Nicht-Entdecken mit  5xWhy (Verpflichtend bei ST)."]
[]
[null,null,null,null,"* Kompletter MRC inkl. Geschäftsprozess und Führung (Organisation, Personal) ist dargelegt."]
[]
[null,null,null,null,"Sonstiges:"]
[null,null,null,null,"Ist das Risiko des Fehlers bewertet und im 8D-Bericht dargelegt? Auswirkungen auf andere Produkte/ Prozesse/Standorte"]
[]
[null,null,null,null,"** Warum ist der Fehler nicht bereits früher aufgetreten?"]
[]
[null,"D5 – Mögliche Abstellmaßnahmen festlegen und Wirksamkeit nachweisen"]
[]
[null,"- Alle möglichen Abstellmaßnahmen nennen, unabhängig von Kosten und Umsetzungszeit\n\n- Grundsatz: Fehlervermeidung vor Fehlerentdeckung",null,null,"Sind gegen alle in D4 ermittelten  Grundursachen Maßnahmen inkl. Verantwortlichkeit und Termin aufgeführt?"]
[null,null,null,null,"Gegen Auftreten und für Nicht-Entdecken des Fehlers (TRC und MRC Managementsystem)"]
[]
[null,null,null,null,"* Gegen Auftreten und für Nicht-Entdecken des Fehlers (komplett TRC und MRC)"]
[]
[null,null,null,null,"Ist der Nachweis erbracht, dass jede Maßnahme wirksam wäre? z.B.: mittels plausibler Beschreibung oder Tests"]
[]
[null,null,null,null,"Wirken die Maßnahmen gegen die in D4 ermittelte(n) Grundursache(n)? "]
[]
[null,null,null,null,"Ist der Grundsatz „Fehlervermeidung vor Fehlerentdeckung“ berücksichtigt? Zuerst prüfen ob Fehler vermieden werden"]
[null,null,null,null,"kann. Falls dies nicht möglich ist, muss dies begründet u. Maßnahmen zur Fehlerentdeckung erarbeitet werden!"]
[]
[null,null,null,null,"* Ist abgesichert, dass die Maßnahmen keine neuen negativen Auswirkungen nach sich ziehen? (auch auf andere Produkte/Prozesse)"]
[]
[null,null,null,null,"* Sind die Maßnahmen vollständig, detailliert und nachvollziehbar beschrieben?"]
[]
[null,null,null,null,"** Ist abgesichert, dass Interna intern bleiben (z.B.: erwarteter Aufwand , Wirksamkeit der Maßnahme, geschätzte Kosten)"]
[]
[null,"D6 – Abstellmaßnahmen einführen und Wirksamkeit verfolgen"]
[]
[null,"Auftreten\nAbstellmaßnahme geg. das Auftr. der Abweichung (unter Berücksichtigung des Produkts, des zu- gehörigen Prozesses bzw. der Rahmenbedingungen)\nNicht-Entdeckung\nFehlerentdeckungsmaßnahme (unter Berücksichtigung des Produkts, des zugehörigen Prozesses bzw. der Rahmenbedingungen)\nValidierung der Abstellmaßnahme\nPraktischer Nachweis der Wirksamkeit nach Umsetzung der Abstellmaßnahme, z. B. in laufender Fertigung. Zuvor ist ein theoretischer Nachweis = Verifizierung erfolgt.",null,null,"Ist die Entscheidung getroffen, welche Maßnahme n) gegen das Auftreten der Grundursache umgesetzt wird?"]
[]
[null,null,null,null,"Ist die Entscheidung getroffen, welche Maßnahme n) zur Entdeckung der Grundursache umgesetzt wird? "]
[]
[null,null,null,null,"Ist die Einführung der Maßnahmen geplant und terminiert? Sind Endtermine / Meilensteine / Verantwortlichkeiten festgelegt?"]
[]
[null,null,null,null,"Sind alle betroffenen Systeme, Prozesse, Produkte, Verfahrensrichtlinien und Anweisungen etc. angepasst?"]
[]
[null,null,null,null,"Ist über die Aufhebung von Sofortmaßnahmen entschieden?"]
[]
[null,null,null,null,"* Ist definiert, wie der Erfolg der Maßnahmen gemessen und nachgewiesen wird, Kontrolle der Wirksamkeit? z.B. in QAM,"]
[null,null,null,null,"    Fehlerauswertung, Fehlerentdeckung durch eingeschleustes  Fehlteil nachgewiesen? Dokumentation des Ergebnisses."]
[]
[null,null,null,null,"* ggf. Poka Yoke Lösung eingeführt."]
[]
[null,null,null,null,"* MRC im Geschäftsprozess und / oder in der Führung (Personal, Organisation) ist bestimmt und effektiv eingeführt."]
[]
[null,null,null,null,"** Sind ggf. höhere Hierarchieebenen eingebunden? (z.B.: zur Freigabe von Ressourcen, Budget, Maßnahmen zu MRC)."]
[]
[null,"D7 – Vorbeugende Maßnahmen einführen"]
[]
[null,"Aktualisierung des QM-Systems (PQP, FMEA, …) Vorbeugende Maßnahmen gegen Wiederholfehler\n",null,null,"Ist die Verbesserung des QM-Systems klar dargelegt?"]
[]
[null,null,null,null,"Wer wurde über erforderliche Aktivitäten informiert?"]
[]
[null,null,null,null,"Welches Dokument (z.B. FMEA, Verfahrensanweisung, CP) wurde überarbeitet? (z.B. Dokument-Nr./-Titel, FMEA-Nr.)"]
[]
[null,null,null,null,"Was wurde geändert? (z.B. Kurzbeschreibung der Änderung)"]
[]
[null,null,null,null,"Sind die gefundenen Lösungen als Anforderungen definiert und auf verwandte Produkte / Prozesse / Werke übertragen?"]
[null,null,null,null,"     Ja: Was ist zu tun? Wer wurde wann, von wem  informiert? (Kunde, Lieferant, andere Werke/ Standorte)"]
[null,null,null,null,"     Nein: Ist begründet, warum dies nicht möglich / erforderlich ist?"]
[]
[null,null,null,null,"* Rückmeldung aus Lessons Learned Netzwerk liegt vor, z.B. Rückmeldung aus Umsetzung in FMEA oder Umsetzung bei"]
[null,null,null,null,"  nicht unmittelbar betroffenen Bereichen."]
[]
[null,"D8 – Abschlussdurchsprache"]
[]
[null,"Wurde der abgeschlossene 8D-Bericht durch die erforderlichen Personen unterzeichnet?",null,null,"Wurde der abgeschlossene 8D-Bericht durch den Teamleiter, den Paten, des Werksqualitätsleiter (für externe) unterzeichnet?"]
[]
[null,null,null,null,"* Wurde der abgeschlossene 8D-Bericht  zusätzlich von Werk-, BU-Leiter unterzeichnet?"]
[]
[null,null,null,null,"* Wurde eine Abschlussdurchsprache im 8D-Team durchgeführt? Was lief gut?"]
[null,null,null,null,"     Wo besteht Verbesserungspotential im 8D-Ablauf? Sind Ergebnisse / Erkenntnisse dokumentiert?"]
[]
[null,null,null,null,"* Wurde eine Bewertung des 8D-Berichts mittels des 8D Bewertungs Werkzeugs vorgenommen? "]
[]
[null,null,null,null,"* Ist der Kunde über den endgültigen Abschluss informiert?"]
[]
[null,null,null,null,"** Sind dem 8D-Bericht alle erforderlichen Unterlagen beigefügt?"]
[]
[null,"Anhänge",null,null,"Anhänge: keine Bewertung"]
[]
[null," Sind relevante Anhänge beigefügt? ",null,null,"Faktensammung"]
[]
[null,null,null,null,"Ishikawa"]
[]
[null,null,null,null,"5x Warum"]
[]
[null,null,null,null,"Prüfberichte, Zeichnungen, Fotos etc."]
[]
[]
[null,"V 2.06 / 2013-Oct-23\nST/QMM1 Koerv"]

{"sheet":"OPL Example","index":10,"n_rows":21,"n_cols":16,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,3,20,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[6,6,8,6],[6,7,8,7],[6,8,6,10],[6,11,8,11],[7,8,8,8],[7,9,8,9],[7,10,8,10],[1,0,1,10],[4,0,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,5],[6,0,8,0],[6,1,8,1],[6,2,8,2],[6,3,8,4],[6,5,8,5]]}
[]
["CIP  - Open Point List"]
[]
[]
["Status Date: ",null,"2011-10-11","Department:  ST CIP NA","ST-IN/ENG1 & CAR Crash Team"]
[]
["No","Date Initiated","Source of Topic (Step D1-D8)","Topic or Task",null,"Priority","Solution or Brief Status \n[effectiveness check for solution                                           (tasks only)]","Responsible Party","Deadlines",null,null,"Status           View Definitions"]
[null,null,null,null,null,null,null,null,"Planned","Revised","Actual"]
[]
["1.","2011-10-01","D1","Need to complete Situation and Problem Analysis according to Kepner-Tregoe.",null,1,"Analysis completed - see Abbrev PSS","(Names)\n Ex: J. Doe","2011-10-07","2011-10-10","2011-10-10","A",null,null,null,"N"]
["2.","2011-10-01","D1","Requested product samples from customer and/or photos of defective units.",null,1,"Request has been placed; waiting for product ","(Names)\n Ex: J. Doe","2011-11-01",null,null,"P"]
[3,"2011-10-02","D3","Requested breakdown of product by CDC to assist with blocking decision.",null,1,"BU Planner provided required data.  Shipping block is not required.","(Names)\n Ex: J. Doe","2011-10-02",null,"2011-10-02","A",null,null,null,"P"]
["4.","2011-10-11","D4","Set meeting to focus on root cause and completion of abbreviated PSS.",null,1,"Crash meeting has been set to correspond with return of product samples","(Names)\n Ex: J. Doe","2011-11-01",null,null,"N",null,null,null,"D"]
["5.",null,null,null,null,null,null,null,null,null,null,"N",null,null,null,"C"]
[6,null,null,null,null,null,null,null,null,null,null,"N"]
[7,null,null,null,null,null,null,null,null,null,null,"N",null,null,null,"A"]
[8,null,null,null,null,null,null,null,null,null,null,"N"]
["9.",null,null,null,null,null,null,null,null,null,null,"N"]
["10.",null,null,null,null,null,null,null,null,null,null,"N"]
["11.",null,null,null,null,null,null,null,null,null,null,"N"]
["12.",null,null,null,null,null,null,null,null,null,null,"N"]

{"sheet":"Front page","index":11,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[6,1,6,4],[7,1,7,4],[8,1,8,4],[0,3,0,4],[1,1,1,3],[2,1,2,4],[3,1,3,3],[4,1,4,4],[5,1,5,4]]}
[null,"Bosch Security Systems"]
[null,"STFR-00006-001: \"8D Report and Problem Solving Sheet for CAR Attachment\" Instructions"]
[null,"It is recommended that you attach this template in its entirety to the CAR and then delete unused sections at the end of the problem-solving process to reduce the file size."]
[null,"For more detailed instructions as to the CAR requirements, refer to STCD-00006-000."]
["A)","Assessment of Risk:\nQuality Issue (QI) – This covers all potential or actual product or process issues, which do not meet the criteria for the “Major” or “Serious” Quality Issue classification.\n\nMajor Quality Issue (MQI) – This covers any process or product issue which results in a shipping and/or production block.  Independent of shipping or production blocks, this classification also applies to any “major” impact to customers, employees, the environment and/or the company with costs > 20,000 EUR.  Cost estimates are based on measurable expenses such as R&D, rework &/or inspection labor, components, equipment, shipping, site visits, customer reimbursements, etc. \n\nSerious Quality Issue (SQI) – This covers one or more of the following potential issues where additional notification is required and where a systematically-prepared decision must be made, without delay.  \n* Products may have safety-related issues \n* There is a potential cost risk of > 200,000 EUR \n* There is a risk of notification to a public authority \n* There is risk of a negative effect on the public (e.g. brand image)\n"]
["B)","Problem Solving Sheet (PSS):  The use of the PSS, at a minimum, is required for ALL product CAR's to document \"Ishikawa/fish bone diagram\" and \"5 times why analysis\"  during the 8D-Step 4 (Root Cause Analysis) for a structured determination and documentation of the root causes for the occurrence of the defect and for the non-detection of the defect.  It can also be used to improve the entire problem solving process.  The completed PSS must be attached to the CAR."]
["C)","CAR Actions - Open Point List Template:  This worksheet is available to track CAR actions, if desired by the CAR Team.  The CAR may NOT be closed until all actions have been addressed. See the worksheet OPL Example to understand how it can be used."]
["D)","View the following table to determine the requirements for a PSS and Evaluation based on CAR Type and the assigned Risk Level:"]
[]
[null,"Version","Revision Date","Description of Change","Approved by"]
[null,"1.00","2009-07-27","First release document.","Johannes Lindbüchl"]
[null,"draft","2011-10-10","Added OPL Template, OPL Template example and new CAR Evaluation Form. Instructions sheet modified to align with new CAR risk levels and other requirements.  Added a section within the abbreviated PSS to expand the problem description. ","Betty Green"]
[null,"draft","2011-10-27","Incorporated feedback received during the review cycle. Replaced text with the CAR procedure table for identifying specific requirements.  Added a link to the procedure.","Betty Green\nJohannes Lindbüchl"]
[null,"draft","2011-10-28","Added explanation on the \"Add in\" section of the new evaluation form to \"New Eval-Instru-p2\" sheet.","Betty Green\nJohannes Lindbüchl"]
[null,"draft","2011-12-28","Removed obsolete evaluation form. Ready for publication.","Betty Green\nJohannes Lindbüchl"]
[null,"draft","2012-01-23","Replaced previous BPS & Abbreviated PSS with new 2012 PSS. Updated front page to reflect updated CAR Requirements.","Betty Green\nJohannes Lindbüchl"]
[null,"2.00","2012-01-26","Received final PSS from Dave Urech.","Betty Green\nJohannes Lindbüchl"]
[null,"2.01","2012-02-02","Instructions still had reference to Abbreviated PSS which no longer exists.","Betty Green\nJohannes Lindbüchl"]
[null,"2.02","2012-03-23","Minor formatting changes to the PSS based on input from ZhuP and BU Intrusion.","Betty Green\nJohannes Lindbüchl"]
[null,"2.03","2012-09-26","Adjusting instructions for web based evaluation tool","Oliver Koerv"]
[null,"2.04","2012-10-22","Comment for 8D number declaration added.","Oliver Koerv"]
[null,"2.05","2012-12-20","PSS 2013 and checklist added","Oliver Koerv"]
[null,"2.06","2013-10-23","PSS adapted to use as a one page report or two page PSS","Oliver Koerv"]
[null,"2.1","2017-05-18","8D Report / PSS adapted: fundamental considerations adapted, pre evaluation integrated","Oliver Koerv"]
[null,"2.11","2018-07-06","8D Report / PSS adapted: final meeting participants section added.","Oliver Koerv"]

{"sheet":"Variables","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["8D Step","Not satifsfying","Basic","Excellent"]
["D2",0,4,5]
["D3",0,1,2]
["D4_a",0,4,6]
["D4_b",0,4,6]
["D5_6_a",0,2,3]
["D5_6_b",0,2,3]
["D7",0,2,3]
["D8",0,1,2]
["Summe",{"$f":"SUM(B2:B9)","v":0},{"$f":"SUM(C2:C9)","v":20},30]
["Summe %",{"$f":"B10/$D10","v":0},{"$f":"C10/$D10","v":0.66666666666666663},{"$f":"D10/$D10","v":1}]