{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["LSS Project","Project Charter","Waste","SIPOC","VSM (1)","VSM (2)","Data","Statistics","Fishbone Diagram","Pareto Chart","SOV matrix"],"not_rendered":{"charts":6,"images":2,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"LSS Project","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[17,1,19,1],[20,1,22,1],[6,1,8,1],[9,1,12,1],[13,1,16,1]]}
[]
[]
[]
[null,null,"CHECK LIST"]
[]
[]
[null,"DEFINE","VOC",null,null,null,true]
[null,null,"Project charter",null,null,null,true]
[null,null,"SIPOC",null,null,null,true]
[null,"Measure","Value Stream Mapping",null,null,null,true]
[null,null,"Control Chart",null,null,null,true]
[null,null,"Histogram",null,null,null,true]
[null,null,"Process Capability Analysis",null,null,null,true]
[null,"Analyze","Brain Storming",null,null,null,true]
[null,null,"Cause & Effect Diagram",null,null,null,true,null,null,{"$f":"IF(AND(G7:G16,G18:G19,G21:G22)=TRUE,\"CONGRATUALATION!!!Training Complete\",\"Training Incomplete: Keep Working!!!\")","v":"CONGRATUALATION!!!Training Complete"}]
[null,null,"Pareto Chart",null,null,null,true]
[null,null,null,null,null,null,false]
[null,"Improve ","Pick Chart",null,null,null,true]
[null,null,"Improved Control Chart",null,null,null,true]
[]
[null,"Control","Standardize procedure",null,null,null,true]
[null,null,"PDCA",null,null,null,true]

{"sheet":"Project Charter","index":1,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[19,9,19,12],[7,3,7,6],[27,3,27,12],[52,9,56,12],[42,9,46,12],[37,3,40,12],[31,3,33,12],[42,3,42,6],[44,3,44,6],[46,3,46,6],[48,3,48,6],[52,3,52,6],[54,3,54,6],[56,3,56,6],[58,3,58,6],[62,9,62,12],[5,3,5,12],[9,3,9,6],[11,3,11,6],[13,3,13,6],[23,3,23,12],[15,3,15,6],[17,3,17,6],[19,3,19,6],[7,9,7,12],[9,9,9,12],[11,9,11,12],[13,9,13,12],[15,9,15,12],[17,9,17,12]]}
[]
[]
[]
[]
[]
[null,null,"Project Name","LSS TRAINING PROGRAM"]
[]
[null,null,"Group Name",null,null,null,null,null,"Black Belt","Espen Henrik Johannessen "]
[]
[null,null,"Department","Industrial Engineering",null,null,null,null,"Team Members","Lars Erik Sørgård"]
[]
[null,null,"Event Dates",null,null,null,null,null,null,"Lasse Olavsen Øien"]
[]
[null,null,"Project Champion",null,null,null,null,null,null,"Espen Hansen"]
[]
[null,null,"Sponsor",null,null,null,null,null,null,"Antonio Fianc"]
[]
[null,null,"Process Owner ",null,null,null,null,null,null,"Kristofer Jørgensen "]
[]
[null,null,"Coach Mentor",null,null,null,null,null,null,"Chunyu Kong"]
[]
[]
[]
[null,null,"Business Case"]
[]
[]
[]
[null,null,"Problem Statement"]
[]
[]
[]
[null,null,"SMART Objecticves"]
[]
[]
[]
[]
[]
[null,null,"Project Scope Information"]
[]
[]
[]
[]
[null,null,"Key Metric",null,null,null,null,null,"Operation Definition"]
[]
[null,null,"Entitlement"]
[]
[null,null,"Goal"]
[]
[null,null,"Baseline"]
[]
[]
[]
[null,null,"New Revenue",null,null,null,null,null,"Projected Benefit"]
[]
[null,null,"Cost Redcution"]
[]
[null,null,"Productivity"]
[]
[null,null,"Cost/Risk Avoidance"]
[]
[]
[]
[null,null,"Preliminary Plan","Target Date","Actual Date",null,null,null,"Estimated Cost Savings"]
[null,null,"Start Date"]
[null,null,"Completion Date"]
[null,null,"Define"]
[null,null,"Measure"]
[null,null,"Analyze"]
[null,null,"Improve"]
[null,null,"Control"]

{"sheet":"Waste","index":2,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,0,28,0],[26,1,28,1],[26,3,28,3],[17,1,19,1],[20,1,22,1],[23,1,25,1],[20,0,22,0],[23,0,25,0],[8,3,10,3],[14,3,16,3],[17,3,19,3],[20,3,22,3],[23,3,25,3],[11,3,13,3],[8,1,10,1],[8,0,10,0],[14,0,16,0],[14,1,16,1],[17,0,19,0],[11,0,13,0],[11,1,13,1]]}
[]
[]
[]
[]
[]
[]
[]
[null,"Waste Category","Observation","Occurrance Level","Impact on Process performance"]
["T","Transport","• Movement between functional area","High"]
[null,null,"• Moving WIP to the next step"]
[null,null,"• Moving finished goods to delivery"]
["I","Inventory","• Excess raw materials and stocks","High"]
[null,null,"• Work in process"]
[null,null,"• Spare parts"]
["M","Motion","• Unnecessary movement","Medium"]
[null,null,"• Extra movement for reaching for parts and tools"]
[null,null,"• Too much handling time for inspection"]
["W","Waiting","• Store keeper waiting for bottles to arrive","Medium"]
[null,null,"• Machines waiting to start"]
[null,null,"• Workers waiting to work"]
["O","Over-processing","• Too much time spend on washing","High"]
[null,null,"• Slow filling process"]
[null,null,"•  Long inspecting time"]
["O","Over-production","• Batch size production","High"]
[null,null,"• Make to stock"]
[null,null,"• Economic order quantity lot sizes"]
["D","Defects","• Unevenness","Medium"]
[null,null,"• Leakage"]
[null,null,"• Cracks"]
[]
[]
[]
["DOWNTIME"]

{"sheet":"SIPOC","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"VSM (1)","index":4,"n_rows":36,"n_cols":26,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,21,35,22],[35,3,35,4],[35,6,35,7],[35,9,35,10],[35,12,35,13],[35,15,35,16],[35,18,35,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,5,null,null,15,null,null,20,null,null,30,null,null,20,null,null,15,null,null,70,null,null,"Non Value-added",null,{"$f":"C34+F34+I34+L34+O34+R34+U34","v":175}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Value added",null,{"$f":"D36+G36+J36+M36+P36+S36+V36","v":61}]
[null,null,null,2,null,null,20,null,null,10,null,null,5,null,null,9,null,null,10,null,null,5]

{"sheet":"VSM (2)","index":5,"n_rows":36,"n_cols":27,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,3,35,4],[35,6,35,7],[35,9,35,10],[35,12,35,13],[35,15,35,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"FIFO-First in First Out"]
[]
[]
[]
[null,null,5,null,null,2,null,null,2,null,null,1,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non Value -added",null,{"$f":"C34+F34+I34+L34+O34+R3","v":13}]
[null,null,null,2,null,null,5,null,null,6,null,null,4,null,null,4,null,"Value-added",null,{"$f":"D36+G36+J36+M36+P36","v":21}]

{"sheet":"Data","index":6,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":false,"merged":[[7,15,7,18],[4,1,4,13],[44,10,44,11],[44,12,44,13],[45,10,45,11],[45,12,45,13],[46,10,46,11],[46,12,46,13],[41,10,41,11],[41,12,41,13],[42,10,42,11],[42,12,42,13],[43,10,43,11],[43,12,43,13],[38,10,38,11],[38,12,38,13],[39,10,39,11],[39,12,39,13],[40,10,40,11],[40,12,40,13],[35,10,35,11],[35,12,35,13],[36,10,36,11],[36,12,36,13],[37,10,37,11],[37,12,37,13],[32,10,32,11],[32,12,32,13],[33,10,33,11],[33,12,33,13],[34,10,34,11],[34,12,34,13],[29,10,29,11],[29,12,29,13],[30,10,30,11],[30,12,30,13],[31,10,31,11],[31,12,31,13],[26,10,26,11],[26,12,26,13],[27,10,27,11],[27,12,27,13],[28,10,28,11],[28,12,28,13],[23,10,23,11],[23,12,23,13],[24,10,24,11],[24,12,24,13],[25,10,25,11],[25,12,25,13],[20,10,20,11],[20,12,20,13],[21,10,21,11],[21,12,21,13],[22,10,22,11],[22,12,22,13],[17,10,17,11],[17,12,17,13],[18,10,18,11],[18,12,18,13],[19,10,19,11],[19,12,19,13],[14,12,14,13],[15,10,15,11],[15,12,15,13],[16,10,16,11],[16,12,16,13],[11,10,11,11],[11,12,11,13],[12,10,12,11],[12,12,12,13],[13,10,13,11],[13,12,13,13],[45,8,45,9],[46,8,46,9],[44,8,44,9],[34,8,34,9],[35,8,35,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[32,6,32,7],[32,8,32,9],[42,6,42,7],[43,6,43,7],[44,6,44,7],[45,6,45,7],[46,6,46,7],[35,6,35,7],[36,6,36,7],[37,6,37,7],[38,6,38,7],[39,6,39,7],[40,6,40,7],[33,6,33,7],[34,6,34,7],[5,2,5,7],[5,8,5,13],[6,10,6,11],[6,12,6,13],[7,10,7,11],[7,12,7,13],[42,8,42,9],[43,8,43,9],[39,8,39,9],[40,8,40,9],[41,8,41,9],[36,8,36,9],[37,8,37,9],[38,8,38,9],[33,8,33,9],[8,10,8,11],[8,12,8,13],[9,10,9,11],[9,12,9,13],[10,10,10,11],[10,12,10,13],[27,6,27,7],[27,8,27,9],[14,10,14,11],[28,8,28,9],[29,6,29,7],[29,8,29,9],[24,6,24,7],[24,8,24,9],[25,6,25,7],[25,8,25,9],[26,6,26,7],[26,8,26,9],[21,6,21,7],[21,8,21,9],[22,6,22,7],[22,8,22,9],[23,6,23,7],[23,8,23,9],[18,6,18,7],[18,8,18,9],[19,6,19,7],[19,8,19,9],[20,6,20,7],[20,8,20,9],[15,6,15,7],[15,8,15,9],[16,6,16,7],[16,8,16,9],[17,6,17,7],[17,8,17,9],[12,6,12,7],[12,8,12,9],[13,6,13,7],[13,8,13,9],[14,6,14,7],[14,8,14,9],[9,6,9,7],[9,8,9,9],[10,6,10,7],[10,8,10,9],[11,6,11,7],[11,8,11,9],[6,6,6,7],[6,8,6,9],[7,6,7,7],[7,8,7,9],[8,6,8,7],[8,8,8,9],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[41,6,41,7],[28,6,28,7],[46,2,46,3],[40,2,40,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[34,2,34,3],[35,2,35,3],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[31,2,31,3],[32,2,32,3],[33,2,33,3],[33,4,33,5],[34,4,34,5],[35,4,35,5],[6,2,6,3],[6,4,6,5],[7,2,7,3],[8,2,8,3],[9,2,9,3],[7,4,7,5],[22,2,22,3],[23,2,23,3],[24,2,24,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[17,4,17,5],[18,4,18,5],[19,4,19,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[45,4,45,5],[46,4,46,5],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[28,2,28,3],[29,2,29,3],[30,2,30,3]]}
[]
[]
[]
[]
[null,"INPUT BOX",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per unit"]
[null,null,"Water Volume",null,null,null,null,null,"Weight of a bottle",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean"]
[null,"S.N.","1st Experiment",null,"2nd Experiment",null,"3rd Experiment",null,"1st Experiment",null,"2nd Experiment",null,"3rd Experiment",null,null,null,null,null,null,null,null,null,null,"Standard Deviation"]
[null,1,14.1,null,15.1,null,null,null,null,null,null,null,null,null,null,"INPUT BOX",null,null,null,14.1,null,null,null,"Cp"]
[null,2,15.6,null,15,null,null,null,null,null,null,null,null,null,null,null,"1st Experiment","2nd Experiment","3rd Experiment",15.6,null,null,null,"Cpk"]
[null,3,14.7,null,14.8,null,null,null,null,null,null,null,null,null,null,"Customer Order",20,20,null,14.7]
[null,4,14.7,null,15.05,null,null,null,null,null,null,null,null,null,null,"Total Bottles Processed (n)",{"$f":"COUNTA(C8:D47)","v":40},26,null,14.7]
[null,5,14.9,null,15.05,null,null,null,null,null,null,null,null,null,null,"USL",15.3,15.3,null,14.9]
[null,6,14.9,null,15.15,null,null,null,null,null,null,null,null,null,null,"LSL",14.5,14.5,null,14.9]
[null,7,14.8,null,15.15,null,null,null,null,null,null,null,null,null,null,"Number of Defects",{"$f":"(COUNTIF(C8:C47,\">15.3\") + COUNTIF(C8:C47,\"<14.5\"))","v":14},{"$f":"(COUNTIF(E8:E47,\">15.3\") + COUNTIF(E8:E47,\"<14.5\"))","v":2},null,14.8]
[null,8,15.1,null,15.2,null,null,null,null,null,null,null,null,null,null,"Work-In-Progress",6,4,null,15.1]
[null,9,14.4,null,14.85,null,null,null,null,null,null,null,null,null,null,"Takt Time",30,30,null,14.4]
[null,10,15,null,14.8,null,null,null,null,null,null,null,null,null,null,"Total Lead Time",792,350,null,15]
[null,11,14.9,null,15.05,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.9]
[null,12,14.4,null,15.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.4]
[null,13,15.65,null,15.15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.65]
[null,14,14.6,null,15.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.6]
[null,15,15.4,null,15,null,null,null,null,null,null,null,null,null,null,null,"1st Experiment","2nd Experiment","3rd Experiment",15.4]
[null,16,15,null,15.1,null,null,null,null,null,null,null,null,null,1,"Customer Order",{"$f":"Q10","v":20},{"$f":"R10","v":20},null,15]
[null,17,15.4,null,15,null,null,null,null,null,null,null,null,null,2,"Total Bottles Processed",{"$f":"Q11","v":40},{"$f":"R11","v":26},null,15.4]
[null,18,15.3,null,15,null,null,null,null,null,null,null,null,null,3,"Number of Defects",{"$f":"Q14","v":14},{"$f":"R14","v":2},null,15.3]
[null,19,14.9,null,14.75,null,null,null,null,null,null,null,null,null,4,"Total Lead Time [sec]",{"$f":"Q17","v":792},{"$f":"R17","v":350},null,14.9]
[null,20,14.2,null,14.9,null,null,null,null,null,null,null,null,null,5,"Work-In-Progress",{"$f":"1","v":1},{"$f":"1","v":1},null,14.2]
[null,21,14.9,null,15.25,null,null,null,null,null,null,null,null,null,6,"Yield",{"$f":"Q23/Q24","v":0.5},{"$f":"R23/R24","v":0.76923076923076927},null,14.9]
[null,22,14.8,null,15,null,null,null,null,null,null,null,null,null,7,"Takt Time (Given)",{"$f":"Q16","v":30},{"$f":"R16","v":30},null,14.8]
[null,23,14.7,null,15.05,null,null,null,null,null,null,null,null,null,8,"Available Time",{"$f":"Q29*Q23","v":600},{"$f":"R29*R23","v":600},null,14.7]
[null,24,14.5,null,14.95,null,null,null,null,null,null,null,null,null,9,"Non-Value Time",{"$f":"Q26-Q30","v":192},0,null,14.5]
[null,25,14.7,null,15.35,null,null,null,null,null,null,null,null,null,10,"Time Penalty Cost",{"$f":"Q31*100","v":19200},{"$f":"R31*100","v":0},null,14.7]
[null,26,15.2,null,15.35,null,null,null,null,null,null,null,null,null,11,"Work-In-Progress Cost",{"$f":"Q27*500","v":500},{"$f":"R27*500","v":500},null,15.2]
[null,27,14.4,null,null,null,null,null,null,null,null,null,null,null,12,"Rework Cost",{"$f":"Q25*1500","v":21000},{"$f":"R25*1500","v":3000},null,14.4]
[null,28,14.1,null,null,null,null,null,null,null,null,null,null,null,13,"Warranty Cost",{"$f":"Q23*3000","v":60000},{"$f":"R23*3000","v":60000},null,14.1]
[null,29,15.2,null,null,null,null,null,null,null,null,null,null,null,14,"Cost of Poor Quality ",{"$f":"Q34+Q35","v":81000},{"$f":"R34+R35","v":63000},null,15.2]
[null,30,14.3,null,null,null,null,null,null,null,null,null,null,null,15,"Penalty Cost",0,0,null,14.3]
[null,31,15,null,null,null,null,null,null,null,null,null,null,null,16,"Total Cost",{"$f":"Q32+Q33+Q36+Q37","v":100700},{"$f":"R32+R33+R36+R37","v":63500},null,15]
[null,32,15,null,null,null,null,null,null,null,null,null,null,null,17,"Cost Per Unit",{"$f":"Q38/Q23","v":5035},{"$f":"R38/R23","v":3175},null,15]
[null,33,14.4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.4]
[null,34,15.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.2]
[null,35,14.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.2]
[null,36,14.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.5]
[null,37,15.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.2]
[null,38,15.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.2]
[null,39,14.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.3]
[null,40,15.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15.2]

{"sheet":"Statistics","index":7,"n_rows":54,"n_cols":524,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,23,2,26]]}
["n",40,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,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,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,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,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,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,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,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,null,"hi"]
["USL",15.3]
["LSL",14.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RESULT"]
["Mean",{"$f":"AVERAGE(I5:I44)","v":14.823749999999993},null,null,null,null,"S.N.","Data","Sorted","Rank","Normal Distribution","Difference","Mean","UCLx","LCLx","USL","LSL","Rmean","UCLR","LCLR","x̅+3σ","x̅-3σ",null,null,"1st Experiment","2nd Experiment","3rd Experiment"]
["Standard Deviation",{"$f":"_xlfn.STDEV.S(I5:I44)","v":0.41355052709619217},null,null,null,null,1,14.1,14.1,{"$f":"G5/($B$1+1)","v":2.4390243902439025E-2},{"$f":"_xlfn.NORM.DIST(I5,$B$4,$B$5,FALSE)","v":0.20859353228048805},null,{"$f":"$B$4","v":14.823749999999993},{"$f":"$B$7","v":14.929467948717942},{"$f":"$B$8","v":14.718032051282044},{"$f":"$B$2","v":15.3},{"$f":"$B$3","v":14.5},{"$f":"$B$6","v":3.9743589743589762E-2},{"$f":"$B$9","v":0.12996153846153852},{"$f":"$B$10","v":0},{"$f":"$B$4+3*$B$5","v":16.064401581288571},{"$f":"$B$4-3*$B$5","v":13.583098418711417},null,"Cost per unit",5035,3175]
["Rmean",{"$f":"AVERAGE(L6:L44)","v":3.9743589743589762E-2},null,null,null,null,2,15.6,14.1,{"$f":"G6/($B$1+1)","v":4.878048780487805E-2},{"$f":"_xlfn.NORM.DIST(I6,$B$4,$B$5,FALSE)","v":0.20859353228048805},{"$f":"ABS(I5-I6)","v":0},14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,{"$f":"$B$4+3*$B$5","v":16.064401581288571},{"$f":"$B$4-3*$B$5","v":13.583098418711417},null,"Mean",14.823749999999993,15.057692307692308,{"$error":"#DIV/0!"}]
["UCLx",{"$f":"B4+D7*B6","v":14.929467948717942},"E2",2.66,null,null,3,14.7,14.2,7.3170731707317069E-2,0.30930814245435428,{"$f":"ABS(I6-I7)","v":9.9999999999999645E-2},14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417,null,"Standard Deviation",0.41355052709619217,0.16105421925072785,{"$error":"#DIV/0!"}]
["LCLx",{"$f":"B4-D8*B6","v":14.718032051282044},"E2",2.66,null,null,4,14.7,14.2,9.7560975609756101E-2,0.30930814245435428,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417,null,"Cp",0.32241122812623091,0.82787854893612711,{"$error":"#DIV/0!"}]
["UCLR",{"$f":"B6*D9","v":0.12996153846153852},"D4",3.27,null,null,5,14.9,14.3,0.12195121951219512,0.43260157760473739,0.10000000000000142,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417,null,"Cpk",0.26095158776466254,0.50150335175938432,{"$error":"#DIV/0!"}]
["LCLR",{"$f":"D10*B6","v":0},"D3",0,null,null,6,14.9,14.3,0.14634146341463414,0.43260157760473739,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,7,14.8,14.4,0.17073170731707318,0.57067792905769887,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Defects",14,null,null,null,null,8,15.1,14.4,0.1951219512195122,0.57067792905769887,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417,null,"For Charts Scroll Down!!!"]
[null,null,null,null,null,null,9,14.4,14.4,0.21951219512195122,0.57067792905769887,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Cp",{"$f":"(B2-B3)/(6*B5)","v":0.32241122812623091},null,null,null,null,10,15,14.4,0.24390243902439024,0.57067792905769887,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Cpk",{"$f":"MIN((B2-B4)/(3*B5),(B4-B3)/(3*B5))","v":0.26095158776466254},null,null,null,null,11,14.9,14.5,0.26829268292682928,0.71006856362003712,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,12,14.4,14.5,0.29268292682926828,0.71006856362003712,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["z(USL)",{"$f":"(B2-B4)/B5","v":1.1516126054633979},null,null,null,null,13,15.65,14.6,0.31707317073170732,0.83332752474197891,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["z(LSL)",{"$f":"(B4-B3)/B5","v":0.78285476329398762},null,null,null,null,14,14.6,14.7,0.34146341463414637,0.92243845417204318,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,15,15.4,14.7,0.36585365853658536,0.92243845417204318,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["P1",{"$f":"1-_xlfn.NORM.S.DIST(B17,TRUE)","v":0.12474014957206958},null,null,null,null,16,15,14.7,0.3902439024390244,0.92243845417204318,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["P2",{"$f":"_xlfn.NORM.S.DIST(B18,TRUE)","v":0.78314379775411513},null,null,null,null,17,15.4,14.7,0.41463414634146339,0.92243845417204318,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Ptotal",{"$f":"SUM(B20:B21)","v":0.90788394732618471},null,null,null,null,18,15.3,14.8,0.43902439024390244,0.96308651838496406,0.10000000000000142,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["DPMO",{"$f":"ROUND(B22*10^6,)","v":907884},null,null,null,null,19,14.9,14.8,0.46341463414634149,0.96308651838496406,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Histogram",null,null,null,null,null,20,14.2,14.9,0.48780487804878048,0.94841723884075724,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Range",{"$f":"MAX(I5:I44)-MIN(I5:I44)","v":1.5500000000000007},null,null,null,null,21,14.9,14.9,0.51219512195121952,0.94841723884075724,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["k",{"$f":"SQRT($B$1)","v":6.324555320336759},null,null,null,null,22,14.8,14.9,0.53658536585365857,0.94841723884075724,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["k",{"$f":"ROUND(B26+0.5,0)","v":7},null,null,null,null,23,14.7,14.9,0.56097560975609762,0.94841723884075724,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["class width",{"$f":"B25/B26","v":0.2450765186630495},null,null,null,null,24,14.5,14.9,0.58536585365853655,0.94841723884075724,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,25,14.7,15,0.6097560975609756,0.88092676798481606,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,26,15.2,15,0.63414634146341464,0.88092676798481606,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Class","Bin",null,"Frequency",null,null,27,14.4,15,0.65853658536585369,0.88092676798481606,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[1,{"$f":"I5+$B$28","v":14.345076518663049},{"$f":"COUNTIF($I$5:$I$45,\"<=\"&B32)","v":6},{"$f":"C32","v":6},null,null,28,14.1,15,0.68292682926829273,0.88092676798481606,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[2,{"$f":"B32+$B$28","v":14.590153037326099},12,{"$f":"C33-C32","v":6},null,null,29,15.2,15.1,0.70731707317073167,0.77176735746977077,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[3,14.835229555989148,19,7,null,null,30,14.3,15.2,0.73170731707317072,0.63773350805471751,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[4,15.080306074652198,28,9,null,null,31,15,15.2,0.75609756097560976,0.63773350805471751,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[5,15.325382593315247,36,8,null,null,32,15,15.2,0.78048780487804881,0.63773350805471751,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[6,15.570459111978296,38,2,null,null,33,14.4,15.2,0.80487804878048785,0.63773350805471751,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[7,15.815535630641346,40,2,null,null,34,15.2,15.2,0.82926829268292679,0.63773350805471751,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,35,14.2,15.2,0.85365853658536583,0.63773350805471751,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,36,14.5,15.3,0.87804878048780488,0.49704796352503022,0.10000000000000142,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Skewness",{"$f":"SKEW(H5:H44)","v":-1.3220652992178507E-2},null,null,null,null,37,15.2,15.4,0.90243902439024393,0.36539583500705602,9.9999999999999645E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
["Kurtosis",{"$f":"KURT(H5:H44)","v":-0.80395301332850133},null,null,null,null,38,15.2,15.4,0.92682926829268297,0.36539583500705602,0,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,39,14.3,15.6,0.95121951219512191,0.16569632469370998,0.19999999999999929,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[null,null,null,null,null,null,40,15.2,15.65,0.97560975609756095,0.13109287584986251,5.0000000000000711E-2,14.823749999999993,14.929467948717942,14.718032051282044,15.3,14.5,3.9743589743589762E-2,0.12996153846153852,0,16.064401581288571,13.583098418711417]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Fishbone Diagram","index":8,"n_rows":42,"n_cols":25,"rows_kept":42,"cut":false,"hidden":false,"merged":[[10,0,21,0],[19,9,19,12],[20,1,20,4],[21,1,21,4],[20,5,20,8],[21,5,21,8],[20,9,20,12],[21,9,21,12],[33,19,37,19],[8,19,12,19],[13,19,17,19],[18,19,22,19],[23,19,27,19],[28,19,32,19],[7,3,7,10],[18,1,18,4],[19,1,19,4],[16,5,16,6],[17,5,17,8],[18,5,18,8],[19,5,19,8],[10,9,10,10],[11,9,11,12],[12,9,12,12],[13,9,13,12],[16,1,16,2],[17,1,17,4],[14,9,14,12],[15,9,15,12],[18,9,18,12],[5,1,5,5],[16,9,16,10],[17,9,17,12],[10,1,10,2],[11,1,11,4],[12,1,12,4],[13,1,13,4],[10,5,10,6],[11,5,11,8],[12,5,12,8],[13,5,13,8],[14,1,14,4],[15,1,15,4],[14,5,14,8],[15,5,15,8],[7,1,7,2]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hu"]
[null,"Cause & Effect Diagram (Fishbone Diagram)"]
[]
[null,"The Problem",null,"Too many defect bottles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1. Measurements","Experience of an operator",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X9:X$9))),\"\")","v":"Experience of an operator"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Simple measuring tool",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X10))),\"\")","v":"Simple measuring tool"}]
["INPUT BOX","1. Measurements",null,null,null,"2. Manpower",null,null,null,"3. Materials",null,null,null,null,null,null,null,null,null,null,"Inaccurate measuring caliber",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X11))),\"\")","v":"Inaccurate measuring caliber"}]
[null,"Experience of an operator",null,null,null,"Measuring error by operator",null,null,null,"Unstable & Light plastic bottles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X12))),\"\")","v":"Measuring error by operator"}]
[null,"Simple measuring tool",null,null,null,"Improper handling of bottles",null,null,null,"Transparency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X13))),\"\")","v":"Improper handling of bottles"}]
[null,"Inaccurate measuring caliber",null,null,null,"Over and under filling of liquids",null,null,null,"Caps not sealed perfectly",null,null,null,null,null,null,null,null,null,"2. Manpower","Measuring error by operator",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X14))),\"\")","v":"Over and under filling of liquids"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Improper handling of bottles",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X15))),\"\")","v":"Unstable & Light plastic bottles"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Over and under filling of liquids",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X16))),\"\")","v":"Transparency"}]
[null,"4. Environment",null,null,null,"4. Methods",null,null,null,"6. Machinery",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X17))),\"\")","v":"Caps not sealed perfectly"}]
[null,"Work floor is not flexible",null,null,null," Liquid filling",null,null,null,"Washing machine",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X18))),\"\")","v":"Work floor is not flexible"}]
[null," Machines cannot be moved",null,null,null," Batch size production",null,null,null,"Filling machine",null,null,null,null,null,null,null,null,null,"3. Materials","Unstable & Light plastic bottles",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X19))),\"\")","v":" Machines cannot be moved"}]
[null,"Long distance between departments",null,null,null," Labelling and capping",null,null,null,"Capping and labelling machine",null,null,null,null,null,null,null,null,null,null,"Transparency",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X20))),\"\")","v":"Long distance between departments"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Caps not sealed perfectly",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X21))),\"\")","v":" Liquid filling"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X22))),\"\")","v":" Batch size production"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X23))),\"\")","v":" Labelling and capping"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Environment","Work floor is not flexible",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X24))),\"\")","v":"Washing machine"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Machines cannot be moved",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X25))),\"\")","v":"Filling machine"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Long distance between departments",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X26))),\"\")","v":"Capping and labelling machine"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X27))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X28))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4. Methods"," Liquid filling",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X29))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Batch size production",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X30))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Labelling and capping",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X31))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X32))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X33))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6. Machinery","Washing machine",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X34))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filling machine",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X35))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capping and labelling machine",null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X36))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X37))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X38))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X39))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X40))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X41))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(U$9:U$42,_xlfn.AGGREGATE(15,6,(ROW(U$9:U$42)-ROW(U$9)+1)/(U$9:U$42<>\"\"),ROWS(X$9:X42))),\"\")","v":""}]

{"sheet":"Pareto Chart","index":9,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[5,6,5,7]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,"INPUT BOX"]
[null,"S.N","Causes of defects",null,null,null,"Weight","Score","Points","Cummulative %",null,"Major Causes","Minor causes","Cutoff %"]
[null,2,{"$f":"'Fishbone Diagram'!$Y10","v":"Simple measuring tool"},null,null,null,5,5,{"$f":"G8*H8","v":25},{"$f":"SUM(I$8:I8)/SUM($I$8:$I$25)","v":0.17241379310344829},null,{"$f":"IF(J8<=$K$5,I8,\"\")","v":25},{"$f":"IF(J8<=$K$5,\"\",I8)","v":""},{"$f":"$K$5","v":0.8}]
[null,3,{"$f":"'Fishbone Diagram'!$Y11","v":"Inaccurate measuring caliber"},null,null,null,4,5,20,{"$f":"SUM(I$8:I9)/SUM($I$8:$I$25)","v":0.31034482758620691},null,{"$f":"IF(J9<=$K$5,I9,\"\")","v":20},{"$f":"IF(J9<=$K$5,\"\",I9)","v":""},{"$f":"$K$5","v":0.8}]
[null,6,{"$f":"'Fishbone Diagram'!$Y14","v":"Over and under filling of liquids"},null,null,null,5,4,20,{"$f":"SUM(I$8:I10)/SUM($I$8:$I$25)","v":0.44827586206896552},null,20,"",0.8]
[null,13,{"$f":"'Fishbone Diagram'!$Y21","v":" Liquid filling"},null,null,null,4,4,16,{"$f":"SUM(I$8:I11)/SUM($I$8:$I$25)","v":0.55862068965517242},null,16,"",0.8]
[null,9,{"$f":"'Fishbone Diagram'!$Y17","v":"Caps not sealed perfectly"},null,null,null,5,2,10,{"$f":"SUM(I$8:I12)/SUM($I$8:$I$25)","v":0.62758620689655176},null,10,"",0.8]
[null,17,{"$f":"'Fishbone Diagram'!$Y25","v":"Filling machine"},null,null,null,5,2,10,{"$f":"SUM(I$8:I13)/SUM($I$8:$I$25)","v":0.69655172413793098},null,10,"",0.8]
[null,1,{"$f":"'Fishbone Diagram'!$Y9","v":"Experience of an operator"},null,null,null,3,3,9,{"$f":"SUM(I$8:I14)/SUM($I$8:$I$25)","v":0.75862068965517238},null,9,"",0.8]
[null,4,{"$f":"'Fishbone Diagram'!$Y12","v":"Measuring error by operator"},null,null,null,3,2,6,{"$f":"SUM(I$8:I15)/SUM($I$8:$I$25)","v":0.8},null,6,"",0.8]
[null,5,{"$f":"'Fishbone Diagram'!$Y13","v":"Improper handling of bottles"},null,null,null,3,2,6,{"$f":"SUM(I$8:I16)/SUM($I$8:$I$25)","v":0.8413793103448276},null,"",6,0.8]
[null,15,{"$f":"'Fishbone Diagram'!$Y23","v":" Labelling and capping"},null,null,null,3,2,6,{"$f":"SUM(I$8:I17)/SUM($I$8:$I$25)","v":0.88275862068965516},null,"",6,0.8]
[null,16,{"$f":"'Fishbone Diagram'!$Y24","v":"Washing machine"},null,null,null,3,2,6,{"$f":"SUM(I$8:I18)/SUM($I$8:$I$25)","v":0.92413793103448272},null,"",6,0.8]
[null,7,{"$f":"'Fishbone Diagram'!$Y15","v":"Unstable & Light plastic bottles"},null,null,null,2,1,2,{"$f":"SUM(I$8:I19)/SUM($I$8:$I$25)","v":0.93793103448275861},null,"",2,0.8]
[null,8,{"$f":"'Fishbone Diagram'!$Y16","v":"Transparency"},null,null,null,2,1,2,{"$f":"SUM(I$8:I20)/SUM($I$8:$I$25)","v":0.9517241379310345},null,"",2,0.8,null,null,{"$f":"IF(L20=\"\",\"\",C20)","v":""}]
[null,10,{"$f":"'Fishbone Diagram'!$Y18","v":"Work floor is not flexible"},null,null,null,2,1,2,{"$f":"SUM(I$8:I21)/SUM($I$8:$I$25)","v":0.96551724137931039},null,"",2,0.8,null,null,""]
[null,18,{"$f":"'Fishbone Diagram'!$Y26","v":"Capping and labelling machine"},null,null,null,2,1,2,{"$f":"SUM(I$8:I22)/SUM($I$8:$I$25)","v":0.97931034482758617},null,"",2,0.8,null,null,""]
[null,11,{"$f":"'Fishbone Diagram'!$Y19","v":" Machines cannot be moved"},null,null,null,1,1,1,{"$f":"SUM(I$8:I23)/SUM($I$8:$I$25)","v":0.98620689655172411},null,"",1,0.8,null,null,""]
[null,12,{"$f":"'Fishbone Diagram'!$Y20","v":"Long distance between departments"},null,null,null,1,1,1,{"$f":"SUM(I$8:I24)/SUM($I$8:$I$25)","v":0.99310344827586206},null,"",1,0.8,null,null,""]
[null,14,{"$f":"'Fishbone Diagram'!$Y22","v":" Batch size production"},null,null,null,1,1,1,{"$f":"SUM(I$8:I25)/SUM($I$8:$I$25)","v":1},null,"",1,0.8,null,null,""]
[null,19,{"$f":"'Fishbone Diagram'!$Y27","v":""}]
[null,20,{"$f":"'Fishbone Diagram'!$Y28","v":""}]
[null,21,{"$f":"'Fishbone Diagram'!$Y29","v":""}]
[null,22,{"$f":"'Fishbone Diagram'!$Y30","v":""}]
[null,23,{"$f":"'Fishbone Diagram'!$Y31","v":""}]
[null,24,{"$f":"'Fishbone Diagram'!$Y32","v":""}]
[null,25,{"$f":"'Fishbone Diagram'!$Y33","v":""}]
[null,26,{"$f":"'Fishbone Diagram'!$Y34","v":""}]
[null,27,{"$f":"'Fishbone Diagram'!$Y35","v":""}]
[null,28,{"$f":"'Fishbone Diagram'!$Y36","v":""}]
[null,29,{"$f":"'Fishbone Diagram'!$Y37","v":""}]
[null,30,{"$f":"'Fishbone Diagram'!$Y38","v":""}]
[null,31,{"$f":"'Fishbone Diagram'!$Y39","v":""}]
[null,32,{"$f":"'Fishbone Diagram'!$Y40","v":""}]
[null,33,{"$f":"'Fishbone Diagram'!$Y41","v":""}]
[null,34,{"$f":"'Fishbone Diagram'!$Y42","v":""}]

{"sheet":"SOV matrix","index":10,"n_rows":38,"n_cols":27,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,5,2,14],[33,5,33,12],[34,5,34,12],[35,5,35,12],[28,5,28,12],[29,5,29,12],[30,5,30,12],[31,5,31,12],[32,5,32,12],[8,5,8,12],[34,1,34,4],[35,1,35,4],[14,5,14,12],[15,5,15,12],[16,5,16,12],[17,5,17,12],[18,5,18,12],[19,5,19,12],[20,5,20,12],[21,5,21,12],[22,5,22,12],[23,5,23,12],[24,5,24,12],[25,5,25,12],[26,5,26,12],[27,5,27,12],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[33,1,33,4],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[22,1,22,4],[23,1,23,4],[16,1,16,4],[17,1,17,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[18,1,18,4],[14,1,14,4],[15,1,15,4],[9,1,9,4],[10,1,10,4],[10,5,10,12],[11,5,11,12],[12,5,12,12],[11,1,11,4],[12,1,12,4],[13,1,13,4],[9,5,9,12],[7,1,7,4],[8,1,8,4],[13,5,13,12],[5,1,5,4],[6,1,6,4],[5,5,5,12],[6,5,6,12],[7,5,7,12]]}
[]
[]
[null,null,null,null,null,"INPUT BOX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"E or D","L or H"]
[null,"Source of variation",null,null,null,"Action Plan",null,null,null,null,null,null,null,"Severity","PayOff","PICK Category",null,null,"I","C","K",null,null,"P","I","C","K"]
[1,{"$f":"IF('Pareto Chart'!L8=\"\",\"\",'Pareto Chart'!C8)","v":"Simple measuring tool"},null,null,null,"Train the operator/ Employ experienced worker",null,null,null,null,null,null,null,"E","H",{"$f":"IF(AND(N7=\"E\",O7=\"H\"),\"I\",IF(AND(N7=\"D\",O7=\"H\"),\"C\",IF(AND(N7=\"E\",O7=\"L\"),\"P\",IF(AND(N7=\"D\",O7=\"L\"),\"K\",\"\"))))","v":"I"},null,null,{"$f":"IF($P7:$P14=\"I\",$F7,\"\")","v":"Train the operator/ Employ experienced worker"},{"$f":"IF($P7:P$14=\"C\",$F7,\"\")","v":""},{"$f":"IF($P7:$P14=\"K\",$F7,\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W7))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X7))),\"\")","v":"Train the operator/ Employ experienced worker"},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y7))),\"\")","v":"Use Digital tool"},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z7))),\"\")","v":"Change bottle type"}]
[2,{"$f":"IF('Pareto Chart'!L9=\"\",\"\",'Pareto Chart'!C9)","v":"Inaccurate measuring caliber"},null,null,null,"Use Digital tool",null,null,null,null,null,null,null,"D","H",{"$f":"IF(AND(N8=\"E\",O8=\"H\"),\"I\",IF(AND(N8=\"D\",O8=\"H\"),\"C\",IF(AND(N8=\"E\",O8=\"L\"),\"P\",IF(AND(N8=\"D\",O8=\"L\"),\"K\",\"\"))))","v":"C"},null,null,{"$f":"IF($P8:$P15=\"I\",$F8,\"\")","v":""},{"$f":"IF($P8:P$14=\"C\",$F8,\"\")","v":"Use Digital tool"},{"$f":"IF($P8:$P15=\"K\",$F8,\"\")","v":""},null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W8))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X8))),\"\")","v":"Be serious in work"},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y8))),\"\")","v":"High precision measuring tool"},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z8))),\"\")","v":""}]
[3,{"$f":"IF('Pareto Chart'!L10=\"\",\"\",'Pareto Chart'!C10)","v":"Over and under filling of liquids"},null,null,null,"High precision measuring tool",null,null,null,null,null,null,null,"D","H","C",null,null,"",{"$f":"IF($P9:P$14=\"C\",$F9,\"\")","v":"High precision measuring tool"},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W9))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X9))),\"\")","v":"Define sealing procedure"},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y9))),\"\")","v":"Add wheels on equipments"},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z9))),\"\")","v":""}]
[4,{"$f":"IF('Pareto Chart'!L11=\"\",\"\",'Pareto Chart'!C11)","v":" Liquid filling"},null,null,null,"Be serious in work",null,null,null,null,null,null,null,"E","H","I",null,null,"Be serious in work",{"$f":"IF($P10:P$14=\"C\",$F10,\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($R$7:$R$14,_xlfn.AGGREGATE(15,6,(ROW($R$7:$R$14)-ROW($R$7)+1)/($R$7:$R$14<>\"\"),ROWS(W$7:W10))),\"\")","v":""},{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W10))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X10))),\"\")","v":"Change layout/Bring closer"},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y10))),\"\")","v":"Add wheels on equipments"},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z10))),\"\")","v":""}]
[5,{"$f":"IF('Pareto Chart'!L12=\"\",\"\",'Pareto Chart'!C12)","v":"Caps not sealed perfectly"},null,null,null,"Use boxes for transport",null,null,null,null,null,null,null,"E","L","P",null,null,"",{"$f":"IF($P11:P$14=\"C\",$F11,\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($R$7:$R$14,_xlfn.AGGREGATE(15,6,(ROW($R$7:$R$14)-ROW($R$7)+1)/($R$7:$R$14<>\"\"),ROWS(W$7:W11))),\"\")","v":""},{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W11))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X11))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y11))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z11))),\"\")","v":""}]
[6,{"$f":"IF('Pareto Chart'!L13=\"\",\"\",'Pareto Chart'!C13)","v":"Filling machine"},null,null,null,"Use dispenser/Taps",null,null,null,null,null,null,null,"E","L","P",null,null,"",{"$f":"IF($P12:P$14=\"C\",$F12,\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($R$7:$R$14,_xlfn.AGGREGATE(15,6,(ROW($R$7:$R$14)-ROW($R$7)+1)/($R$7:$R$14<>\"\"),ROWS(W$7:W12))),\"\")","v":""},{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W12))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X12))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y12))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z12))),\"\")","v":""}]
[7,{"$f":"IF('Pareto Chart'!L14=\"\",\"\",'Pareto Chart'!C14)","v":"Experience of an operator"},null,null,null,"Use support for bottles",null,null,null,null,null,null,null,"E","L","P",null,null,"",{"$f":"IF($P13:P$14=\"C\",$F13,\"\")","v":""},"",null,{"$f":"IFERROR(INDEX($R$7:$R$14,_xlfn.AGGREGATE(15,6,(ROW($R$7:$R$14)-ROW($R$7)+1)/($R$7:$R$14<>\"\"),ROWS(W$7:W13))),\"\")","v":""},{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W13))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X13))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y13))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z13))),\"\")","v":""}]
[8,{"$f":"IF('Pareto Chart'!L15=\"\",\"\",'Pareto Chart'!C15)","v":"Measuring error by operator"},null,null,null,"Change bottle type",null,null,null,null,null,null,null,"D","L","K",null,null,"",{"$f":"IF($P14:P$14=\"C\",$F14,\"\")","v":""},"Change bottle type",null,{"$f":"IFERROR(INDEX($R$7:$R$14,_xlfn.AGGREGATE(15,6,(ROW($R$7:$R$14)-ROW($R$7)+1)/($R$7:$R$14<>\"\"),ROWS(W$7:W14))),\"\")","v":""},{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W14))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X14))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y14))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z14))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L16=\"\",\"\",'Pareto Chart'!C16)","v":""},null,null,null,"Define sealing procedure",null,null,null,null,null,null,null,"E","H","I",null,null,"Define sealing procedure",{"$f":"IF($P$14:P15=\"C\",$F15,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W15))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X15))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y15))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z15))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L17=\"\",\"\",'Pareto Chart'!C17)","v":""},null,null,null,"Add wheels on equipments",null,null,null,null,null,null,null,"D","H","C",null,null,"",{"$f":"IF($P$14:P16=\"C\",$F16,\"\")","v":"Add wheels on equipments"},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W16))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X16))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y16))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z16))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L18=\"\",\"\",'Pareto Chart'!C18)","v":""},null,null,null,"Add wheels on equipments",null,null,null,null,null,null,null,"D","H","C",null,null,"",{"$f":"IF($P$14:P17=\"C\",$F17,\"\")","v":"Add wheels on equipments"},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W17))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X17))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y17))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z17))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L19=\"\",\"\",'Pareto Chart'!C19)","v":""},null,null,null,"Change layout/Bring closer",null,null,null,null,null,null,null,"E","H","I",null,null,"Change layout/Bring closer",{"$f":"IF($P$14:P18=\"C\",$F18,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W18))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X18))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y18))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z18))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L20=\"\",\"\",'Pareto Chart'!C20)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P19=\"C\",$F19,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W19))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X19))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y19))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z19))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L21=\"\",\"\",'Pareto Chart'!C21)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P20=\"C\",$F20,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W20))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X20))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y20))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z20))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L22=\"\",\"\",'Pareto Chart'!C22)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P21=\"C\",$F21,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W21))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X21))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y21))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z21))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L23=\"\",\"\",'Pareto Chart'!C23)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P22=\"C\",$F22,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W22))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X22))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y22))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z22))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L24=\"\",\"\",'Pareto Chart'!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P23=\"C\",$F23,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W23))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X23))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y23))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z23))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L25=\"\",\"\",'Pareto Chart'!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P24=\"C\",$F24,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W24))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X24))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y24))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z24))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L26=\"\",\"\",'Pareto Chart'!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P25=\"C\",$F25,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W25))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X25))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y25))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z25))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L27=\"\",\"\",'Pareto Chart'!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P26=\"C\",$F26,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W26))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X26))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y26))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z26))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L28=\"\",\"\",'Pareto Chart'!C28)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P27=\"C\",$F27,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W27))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X27))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y27))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z27))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L29=\"\",\"\",'Pareto Chart'!C29)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P28=\"C\",$F28,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W28))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X28))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y28))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z28))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L30=\"\",\"\",'Pareto Chart'!C30)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P29=\"C\",$F29,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W29))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X29))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y29))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z29))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L31=\"\",\"\",'Pareto Chart'!C31)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P30=\"C\",$F30,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W30))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X30))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y30))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z30))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L32=\"\",\"\",'Pareto Chart'!C32)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P31=\"C\",$F31,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W31))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X31))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y31))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z31))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L33=\"\",\"\",'Pareto Chart'!C33)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P32=\"C\",$F32,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W32))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X32))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y32))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z32))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L34=\"\",\"\",'Pareto Chart'!C34)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P33=\"C\",$F33,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W33))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X33))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y33))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z33))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L35=\"\",\"\",'Pareto Chart'!C35)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P34=\"C\",$F34,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W34))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X34))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y34))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z34))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L36=\"\",\"\",'Pareto Chart'!C36)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P35=\"C\",$F35,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W35))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X35))),\"\")","v":""},{"$f":"IFERROR(INDEX(T$7:T$36,_xlfn.AGGREGATE(15,6,(ROW(T$7:T$36)-ROW(T$7)+1)/(T$7:T$36<>\"\"),ROWS(Y$7:Y35))),\"\")","v":""},{"$f":"IFERROR(INDEX(U$7:U$36,_xlfn.AGGREGATE(15,6,(ROW(U$7:U$36)-ROW(U$7)+1)/(U$7:U$36<>\"\"),ROWS(Z$7:Z35))),\"\")","v":""}]
[null,{"$f":"IF('Pareto Chart'!L37=\"\",\"\",'Pareto Chart'!C37)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"",{"$f":"IF($P$14:P36=\"C\",$F36,\"\")","v":""},"",null,null,{"$f":"IFERROR(INDEX(R$7:R$36,_xlfn.AGGREGATE(15,6,(ROW(R$7:R$36)-ROW(R$7)+1)/(R$7:R$36<>\"\"),ROWS(W$7:W36))),\"\")","v":""},{"$f":"IFERROR(INDEX(S$7:S$36,_xlfn.AGGREGATE(15,6,(ROW(S$7:S$36)-ROW(S$7)+1)/(S$7:S$36<>\"\"),ROWS(X$7:X36))),\"\")","v":""}]
[]
[null,{"$f":"'Fishbone Diagram'!$Y39","v":""}]