{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pareto Chart","Pareto Table"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"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":"Pareto Chart","index":0,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,3,1,8],[0,13,0,14]]}
[null,null,null,"Pareto Chart",null,null,null,null,null,null,null,null,null,"Data Input"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause Category","Numbers"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause1",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause2",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause3",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause4",2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cause5",10]

{"sheet":"Pareto Table","index":1,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
["Cause Category","Numbers","Rank",null,"Cause Category","Numbers","Cumulative Numbers","Cumulative %Age",{"$f":"$L$2&\"% \"&\"Line\"","v":"80% Line"}]
[{"$f":"IF(OR('Pareto Chart'!N3=\"\",'Pareto Chart'!O3=\"\"),\"\",'Pareto Chart'!N3)","v":"Cause1"},{"$f":"IF($A2=\"\",\"\",'Pareto Chart'!O3)","v":2},{"$f":"IF($A2=\"\",\"\",RANK($B2,$B$2:$B$100)+COUNTIF(B$2:B2,B2)-1)","v":4},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:1),$C$2:$C$100,0)),\"\")","v":"Cause5"},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:1),$C$2:$C$100,0)),\"\")","v":10},{"$f":"IF($E2=\"\",\"\",SUM($F$2:F2))","v":10},{"$f":"IF($E2=\"\",\"\",$G2/SUM($F$2:$F$100))","v":0.41666666666666669},{"$f":"IF($E2=\"\",\"\",$L$2/100)","v":0.8},null,"Control Value for Slider",80]
[{"$f":"IF(OR('Pareto Chart'!N4=\"\",'Pareto Chart'!O4=\"\"),\"\",'Pareto Chart'!N4)","v":"Cause2"},{"$f":"IF($A3=\"\",\"\",'Pareto Chart'!O4)","v":4},{"$f":"IF($A3=\"\",\"\",RANK($B3,$B$2:$B$100)+COUNTIF(B$2:B3,B3)-1)","v":3},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:2),$C$2:$C$100,0)),\"\")","v":"Cause3"},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:2),$C$2:$C$100,0)),\"\")","v":6},{"$f":"IF($E3=\"\",\"\",SUM($F$2:F3))","v":16},{"$f":"IF($E3=\"\",\"\",$G3/SUM($F$2:$F$100))","v":0.66666666666666663},0.8,null,null,"Vertical Line"]
[{"$f":"IF(OR('Pareto Chart'!N5=\"\",'Pareto Chart'!O5=\"\"),\"\",'Pareto Chart'!N5)","v":"Cause3"},{"$f":"IF($A4=\"\",\"\",'Pareto Chart'!O5)","v":6},{"$f":"IF($A4=\"\",\"\",RANK($B4,$B$2:$B$100)+COUNTIF(B$2:B4,B4)-1)","v":2},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:3),$C$2:$C$100,0)),\"\")","v":"Cause2"},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:3),$C$2:$C$100,0)),\"\")","v":4},{"$f":"IF($E4=\"\",\"\",SUM($F$2:F4))","v":20},0.83333333333333337,0.8,null,{"$f":"IF($L$2=100,SUMPRODUCT(--($E$2:$E$100<>\"\")),IF(ISERROR(MATCH($L$2/100,$H$2:$H$100)),1,MATCH($L$2/100,$H$2:$H$100)+(($L$2/100-INDEX($H$2:$H$100,MATCH($L$2/100,$H$2:$H$100)))/(INDEX($H$2:$H$100,1+MATCH($L$2/100,$H$2:$H$100))-INDEX($H$2:$H$100,MATCH($L$2/100,$H$2:$H$100))))))","v":2.8000000000000003},0]
[{"$f":"IF(OR('Pareto Chart'!N6=\"\",'Pareto Chart'!O6=\"\"),\"\",'Pareto Chart'!N6)","v":"Cause4"},{"$f":"IF($A5=\"\",\"\",'Pareto Chart'!O6)","v":2},{"$f":"IF($A5=\"\",\"\",RANK($B5,$B$2:$B$100)+COUNTIF(B$2:B5,B5)-1)","v":5},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:4),$C$2:$C$100,0)),\"\")","v":"Cause1"},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:4),$C$2:$C$100,0)),\"\")","v":2},{"$f":"IF($E5=\"\",\"\",SUM($F$2:F5))","v":22},0.91666666666666663,0.8,null,{"$f":"K4","v":2.8000000000000003},1]
[{"$f":"IF(OR('Pareto Chart'!N7=\"\",'Pareto Chart'!O7=\"\"),\"\",'Pareto Chart'!N7)","v":"Cause5"},{"$f":"IF($A6=\"\",\"\",'Pareto Chart'!O7)","v":10},{"$f":"IF($A6=\"\",\"\",RANK($B6,$B$2:$B$100)+COUNTIF(B$2:B6,B6)-1)","v":1},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:5),$C$2:$C$100,0)),\"\")","v":"Cause4"},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:5),$C$2:$C$100,0)),\"\")","v":2},{"$f":"IF($E6=\"\",\"\",SUM($F$2:F6))","v":24},1,0.8]
[{"$f":"IF(OR('Pareto Chart'!N8=\"\",'Pareto Chart'!O8=\"\"),\"\",'Pareto Chart'!N8)","v":""},{"$f":"IF($A7=\"\",\"\",'Pareto Chart'!O8)","v":""},{"$f":"IF($A7=\"\",\"\",RANK($B7,$B$2:$B$100)+COUNTIF(B$2:B7,B7)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:6),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:6),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E7=\"\",\"\",SUM($F$2:F7))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N9=\"\",'Pareto Chart'!O9=\"\"),\"\",'Pareto Chart'!N9)","v":""},{"$f":"IF($A8=\"\",\"\",'Pareto Chart'!O9)","v":""},{"$f":"IF($A8=\"\",\"\",RANK($B8,$B$2:$B$100)+COUNTIF(B$2:B8,B8)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:7),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:7),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E8=\"\",\"\",SUM($F$2:F8))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N10=\"\",'Pareto Chart'!O10=\"\"),\"\",'Pareto Chart'!N10)","v":""},{"$f":"IF($A9=\"\",\"\",'Pareto Chart'!O10)","v":""},{"$f":"IF($A9=\"\",\"\",RANK($B9,$B$2:$B$100)+COUNTIF(B$2:B9,B9)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:8),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:8),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E9=\"\",\"\",SUM($F$2:F9))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N11=\"\",'Pareto Chart'!O11=\"\"),\"\",'Pareto Chart'!N11)","v":""},{"$f":"IF($A10=\"\",\"\",'Pareto Chart'!O11)","v":""},{"$f":"IF($A10=\"\",\"\",RANK($B10,$B$2:$B$100)+COUNTIF(B$2:B10,B10)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:9),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:9),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E10=\"\",\"\",SUM($F$2:F10))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N12=\"\",'Pareto Chart'!O12=\"\"),\"\",'Pareto Chart'!N12)","v":""},{"$f":"IF($A11=\"\",\"\",'Pareto Chart'!O12)","v":""},{"$f":"IF($A11=\"\",\"\",RANK($B11,$B$2:$B$100)+COUNTIF(B$2:B11,B11)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:10),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:10),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E11=\"\",\"\",SUM($F$2:F11))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N13=\"\",'Pareto Chart'!O13=\"\"),\"\",'Pareto Chart'!N13)","v":""},{"$f":"IF($A12=\"\",\"\",'Pareto Chart'!O13)","v":""},{"$f":"IF($A12=\"\",\"\",RANK($B12,$B$2:$B$100)+COUNTIF(B$2:B12,B12)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:11),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:11),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E12=\"\",\"\",SUM($F$2:F12))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N14=\"\",'Pareto Chart'!O14=\"\"),\"\",'Pareto Chart'!N14)","v":""},{"$f":"IF($A13=\"\",\"\",'Pareto Chart'!O14)","v":""},{"$f":"IF($A13=\"\",\"\",RANK($B13,$B$2:$B$100)+COUNTIF(B$2:B13,B13)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:12),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:12),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E13=\"\",\"\",SUM($F$2:F13))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N15=\"\",'Pareto Chart'!O15=\"\"),\"\",'Pareto Chart'!N15)","v":""},{"$f":"IF($A14=\"\",\"\",'Pareto Chart'!O15)","v":""},{"$f":"IF($A14=\"\",\"\",RANK($B14,$B$2:$B$100)+COUNTIF(B$2:B14,B14)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:13),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:13),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E14=\"\",\"\",SUM($F$2:F14))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N16=\"\",'Pareto Chart'!O16=\"\"),\"\",'Pareto Chart'!N16)","v":""},{"$f":"IF($A15=\"\",\"\",'Pareto Chart'!O16)","v":""},{"$f":"IF($A15=\"\",\"\",RANK($B15,$B$2:$B$100)+COUNTIF(B$2:B15,B15)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:14),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:14),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E15=\"\",\"\",SUM($F$2:F15))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N17=\"\",'Pareto Chart'!O17=\"\"),\"\",'Pareto Chart'!N17)","v":""},{"$f":"IF($A16=\"\",\"\",'Pareto Chart'!O17)","v":""},{"$f":"IF($A16=\"\",\"\",RANK($B16,$B$2:$B$100)+COUNTIF(B$2:B16,B16)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:15),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:15),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E16=\"\",\"\",SUM($F$2:F16))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N18=\"\",'Pareto Chart'!O18=\"\"),\"\",'Pareto Chart'!N18)","v":""},{"$f":"IF($A17=\"\",\"\",'Pareto Chart'!O18)","v":""},{"$f":"IF($A17=\"\",\"\",RANK($B17,$B$2:$B$100)+COUNTIF(B$2:B17,B17)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:16),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:16),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E17=\"\",\"\",SUM($F$2:F17))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N19=\"\",'Pareto Chart'!O19=\"\"),\"\",'Pareto Chart'!N19)","v":""},{"$f":"IF($A18=\"\",\"\",'Pareto Chart'!O19)","v":""},{"$f":"IF($A18=\"\",\"\",RANK($B18,$B$2:$B$100)+COUNTIF(B$2:B18,B18)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:17),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:17),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E18=\"\",\"\",SUM($F$2:F18))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N20=\"\",'Pareto Chart'!O20=\"\"),\"\",'Pareto Chart'!N20)","v":""},{"$f":"IF($A19=\"\",\"\",'Pareto Chart'!O20)","v":""},{"$f":"IF($A19=\"\",\"\",RANK($B19,$B$2:$B$100)+COUNTIF(B$2:B19,B19)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:18),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:18),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E19=\"\",\"\",SUM($F$2:F19))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N21=\"\",'Pareto Chart'!O21=\"\"),\"\",'Pareto Chart'!N21)","v":""},{"$f":"IF($A20=\"\",\"\",'Pareto Chart'!O21)","v":""},{"$f":"IF($A20=\"\",\"\",RANK($B20,$B$2:$B$100)+COUNTIF(B$2:B20,B20)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:19),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:19),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E20=\"\",\"\",SUM($F$2:F20))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N22=\"\",'Pareto Chart'!O22=\"\"),\"\",'Pareto Chart'!N22)","v":""},{"$f":"IF($A21=\"\",\"\",'Pareto Chart'!O22)","v":""},{"$f":"IF($A21=\"\",\"\",RANK($B21,$B$2:$B$100)+COUNTIF(B$2:B21,B21)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:20),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:20),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E21=\"\",\"\",SUM($F$2:F21))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N23=\"\",'Pareto Chart'!O23=\"\"),\"\",'Pareto Chart'!N23)","v":""},{"$f":"IF($A22=\"\",\"\",'Pareto Chart'!O23)","v":""},{"$f":"IF($A22=\"\",\"\",RANK($B22,$B$2:$B$100)+COUNTIF(B$2:B22,B22)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:21),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:21),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E22=\"\",\"\",SUM($F$2:F22))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N24=\"\",'Pareto Chart'!O24=\"\"),\"\",'Pareto Chart'!N24)","v":""},{"$f":"IF($A23=\"\",\"\",'Pareto Chart'!O24)","v":""},{"$f":"IF($A23=\"\",\"\",RANK($B23,$B$2:$B$100)+COUNTIF(B$2:B23,B23)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:22),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:22),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E23=\"\",\"\",SUM($F$2:F23))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N25=\"\",'Pareto Chart'!O25=\"\"),\"\",'Pareto Chart'!N25)","v":""},{"$f":"IF($A24=\"\",\"\",'Pareto Chart'!O25)","v":""},{"$f":"IF($A24=\"\",\"\",RANK($B24,$B$2:$B$100)+COUNTIF(B$2:B24,B24)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:23),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:23),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E24=\"\",\"\",SUM($F$2:F24))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N26=\"\",'Pareto Chart'!O26=\"\"),\"\",'Pareto Chart'!N26)","v":""},{"$f":"IF($A25=\"\",\"\",'Pareto Chart'!O26)","v":""},{"$f":"IF($A25=\"\",\"\",RANK($B25,$B$2:$B$100)+COUNTIF(B$2:B25,B25)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:24),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:24),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E25=\"\",\"\",SUM($F$2:F25))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N27=\"\",'Pareto Chart'!O27=\"\"),\"\",'Pareto Chart'!N27)","v":""},{"$f":"IF($A26=\"\",\"\",'Pareto Chart'!O27)","v":""},{"$f":"IF($A26=\"\",\"\",RANK($B26,$B$2:$B$100)+COUNTIF(B$2:B26,B26)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:25),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:25),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E26=\"\",\"\",SUM($F$2:F26))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N28=\"\",'Pareto Chart'!O28=\"\"),\"\",'Pareto Chart'!N28)","v":""},{"$f":"IF($A27=\"\",\"\",'Pareto Chart'!O28)","v":""},{"$f":"IF($A27=\"\",\"\",RANK($B27,$B$2:$B$100)+COUNTIF(B$2:B27,B27)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:26),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:26),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E27=\"\",\"\",SUM($F$2:F27))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N29=\"\",'Pareto Chart'!O29=\"\"),\"\",'Pareto Chart'!N29)","v":""},{"$f":"IF($A28=\"\",\"\",'Pareto Chart'!O29)","v":""},{"$f":"IF($A28=\"\",\"\",RANK($B28,$B$2:$B$100)+COUNTIF(B$2:B28,B28)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:27),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:27),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E28=\"\",\"\",SUM($F$2:F28))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N30=\"\",'Pareto Chart'!O30=\"\"),\"\",'Pareto Chart'!N30)","v":""},{"$f":"IF($A29=\"\",\"\",'Pareto Chart'!O30)","v":""},{"$f":"IF($A29=\"\",\"\",RANK($B29,$B$2:$B$100)+COUNTIF(B$2:B29,B29)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:28),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:28),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E29=\"\",\"\",SUM($F$2:F29))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N31=\"\",'Pareto Chart'!O31=\"\"),\"\",'Pareto Chart'!N31)","v":""},{"$f":"IF($A30=\"\",\"\",'Pareto Chart'!O31)","v":""},{"$f":"IF($A30=\"\",\"\",RANK($B30,$B$2:$B$100)+COUNTIF(B$2:B30,B30)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:29),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:29),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E30=\"\",\"\",SUM($F$2:F30))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N32=\"\",'Pareto Chart'!O32=\"\"),\"\",'Pareto Chart'!N32)","v":""},{"$f":"IF($A31=\"\",\"\",'Pareto Chart'!O32)","v":""},{"$f":"IF($A31=\"\",\"\",RANK($B31,$B$2:$B$100)+COUNTIF(B$2:B31,B31)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:30),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:30),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E31=\"\",\"\",SUM($F$2:F31))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N33=\"\",'Pareto Chart'!O33=\"\"),\"\",'Pareto Chart'!N33)","v":""},{"$f":"IF($A32=\"\",\"\",'Pareto Chart'!O33)","v":""},{"$f":"IF($A32=\"\",\"\",RANK($B32,$B$2:$B$100)+COUNTIF(B$2:B32,B32)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:31),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:31),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E32=\"\",\"\",SUM($F$2:F32))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N34=\"\",'Pareto Chart'!O34=\"\"),\"\",'Pareto Chart'!N34)","v":""},{"$f":"IF($A33=\"\",\"\",'Pareto Chart'!O34)","v":""},{"$f":"IF($A33=\"\",\"\",RANK($B33,$B$2:$B$100)+COUNTIF(B$2:B33,B33)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:32),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:32),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E33=\"\",\"\",SUM($F$2:F33))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N35=\"\",'Pareto Chart'!O35=\"\"),\"\",'Pareto Chart'!N35)","v":""},{"$f":"IF($A34=\"\",\"\",'Pareto Chart'!O35)","v":""},{"$f":"IF($A34=\"\",\"\",RANK($B34,$B$2:$B$100)+COUNTIF(B$2:B34,B34)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:33),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:33),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E34=\"\",\"\",SUM($F$2:F34))","v":""},"",{"$f":"IF($E34=\"\",\"\",$L$2/100)","v":""}]
[{"$f":"IF(OR('Pareto Chart'!N36=\"\",'Pareto Chart'!O36=\"\"),\"\",'Pareto Chart'!N36)","v":""},{"$f":"IF($A35=\"\",\"\",'Pareto Chart'!O36)","v":""},{"$f":"IF($A35=\"\",\"\",RANK($B35,$B$2:$B$100)+COUNTIF(B$2:B35,B35)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:34),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:34),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E35=\"\",\"\",SUM($F$2:F35))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N37=\"\",'Pareto Chart'!O37=\"\"),\"\",'Pareto Chart'!N37)","v":""},{"$f":"IF($A36=\"\",\"\",'Pareto Chart'!O37)","v":""},{"$f":"IF($A36=\"\",\"\",RANK($B36,$B$2:$B$100)+COUNTIF(B$2:B36,B36)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:35),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:35),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E36=\"\",\"\",SUM($F$2:F36))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N38=\"\",'Pareto Chart'!O38=\"\"),\"\",'Pareto Chart'!N38)","v":""},{"$f":"IF($A37=\"\",\"\",'Pareto Chart'!O38)","v":""},{"$f":"IF($A37=\"\",\"\",RANK($B37,$B$2:$B$100)+COUNTIF(B$2:B37,B37)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:36),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:36),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E37=\"\",\"\",SUM($F$2:F37))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N39=\"\",'Pareto Chart'!O39=\"\"),\"\",'Pareto Chart'!N39)","v":""},{"$f":"IF($A38=\"\",\"\",'Pareto Chart'!O39)","v":""},{"$f":"IF($A38=\"\",\"\",RANK($B38,$B$2:$B$100)+COUNTIF(B$2:B38,B38)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:37),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:37),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E38=\"\",\"\",SUM($F$2:F38))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N40=\"\",'Pareto Chart'!O40=\"\"),\"\",'Pareto Chart'!N40)","v":""},{"$f":"IF($A39=\"\",\"\",'Pareto Chart'!O40)","v":""},{"$f":"IF($A39=\"\",\"\",RANK($B39,$B$2:$B$100)+COUNTIF(B$2:B39,B39)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:38),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:38),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E39=\"\",\"\",SUM($F$2:F39))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N41=\"\",'Pareto Chart'!O41=\"\"),\"\",'Pareto Chart'!N41)","v":""},{"$f":"IF($A40=\"\",\"\",'Pareto Chart'!O41)","v":""},{"$f":"IF($A40=\"\",\"\",RANK($B40,$B$2:$B$100)+COUNTIF(B$2:B40,B40)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:39),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:39),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E40=\"\",\"\",SUM($F$2:F40))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N42=\"\",'Pareto Chart'!O42=\"\"),\"\",'Pareto Chart'!N42)","v":""},{"$f":"IF($A41=\"\",\"\",'Pareto Chart'!O42)","v":""},{"$f":"IF($A41=\"\",\"\",RANK($B41,$B$2:$B$100)+COUNTIF(B$2:B41,B41)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:40),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:40),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E41=\"\",\"\",SUM($F$2:F41))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N43=\"\",'Pareto Chart'!O43=\"\"),\"\",'Pareto Chart'!N43)","v":""},{"$f":"IF($A42=\"\",\"\",'Pareto Chart'!O43)","v":""},{"$f":"IF($A42=\"\",\"\",RANK($B42,$B$2:$B$100)+COUNTIF(B$2:B42,B42)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:41),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:41),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E42=\"\",\"\",SUM($F$2:F42))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N44=\"\",'Pareto Chart'!O44=\"\"),\"\",'Pareto Chart'!N44)","v":""},{"$f":"IF($A43=\"\",\"\",'Pareto Chart'!O44)","v":""},{"$f":"IF($A43=\"\",\"\",RANK($B43,$B$2:$B$100)+COUNTIF(B$2:B43,B43)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:42),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:42),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E43=\"\",\"\",SUM($F$2:F43))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N45=\"\",'Pareto Chart'!O45=\"\"),\"\",'Pareto Chart'!N45)","v":""},{"$f":"IF($A44=\"\",\"\",'Pareto Chart'!O45)","v":""},{"$f":"IF($A44=\"\",\"\",RANK($B44,$B$2:$B$100)+COUNTIF(B$2:B44,B44)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:43),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:43),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E44=\"\",\"\",SUM($F$2:F44))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N46=\"\",'Pareto Chart'!O46=\"\"),\"\",'Pareto Chart'!N46)","v":""},{"$f":"IF($A45=\"\",\"\",'Pareto Chart'!O46)","v":""},{"$f":"IF($A45=\"\",\"\",RANK($B45,$B$2:$B$100)+COUNTIF(B$2:B45,B45)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:44),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:44),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E45=\"\",\"\",SUM($F$2:F45))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N47=\"\",'Pareto Chart'!O47=\"\"),\"\",'Pareto Chart'!N47)","v":""},{"$f":"IF($A46=\"\",\"\",'Pareto Chart'!O47)","v":""},{"$f":"IF($A46=\"\",\"\",RANK($B46,$B$2:$B$100)+COUNTIF(B$2:B46,B46)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:45),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:45),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E46=\"\",\"\",SUM($F$2:F46))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N48=\"\",'Pareto Chart'!O48=\"\"),\"\",'Pareto Chart'!N48)","v":""},{"$f":"IF($A47=\"\",\"\",'Pareto Chart'!O48)","v":""},{"$f":"IF($A47=\"\",\"\",RANK($B47,$B$2:$B$100)+COUNTIF(B$2:B47,B47)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:46),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:46),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E47=\"\",\"\",SUM($F$2:F47))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N49=\"\",'Pareto Chart'!O49=\"\"),\"\",'Pareto Chart'!N49)","v":""},{"$f":"IF($A48=\"\",\"\",'Pareto Chart'!O49)","v":""},{"$f":"IF($A48=\"\",\"\",RANK($B48,$B$2:$B$100)+COUNTIF(B$2:B48,B48)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:47),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:47),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E48=\"\",\"\",SUM($F$2:F48))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N50=\"\",'Pareto Chart'!O50=\"\"),\"\",'Pareto Chart'!N50)","v":""},{"$f":"IF($A49=\"\",\"\",'Pareto Chart'!O50)","v":""},{"$f":"IF($A49=\"\",\"\",RANK($B49,$B$2:$B$100)+COUNTIF(B$2:B49,B49)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:48),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:48),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E49=\"\",\"\",SUM($F$2:F49))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N51=\"\",'Pareto Chart'!O51=\"\"),\"\",'Pareto Chart'!N51)","v":""},{"$f":"IF($A50=\"\",\"\",'Pareto Chart'!O51)","v":""},{"$f":"IF($A50=\"\",\"\",RANK($B50,$B$2:$B$100)+COUNTIF(B$2:B50,B50)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:49),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:49),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E50=\"\",\"\",SUM($F$2:F50))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N52=\"\",'Pareto Chart'!O52=\"\"),\"\",'Pareto Chart'!N52)","v":""},{"$f":"IF($A51=\"\",\"\",'Pareto Chart'!O52)","v":""},{"$f":"IF($A51=\"\",\"\",RANK($B51,$B$2:$B$100)+COUNTIF(B$2:B51,B51)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:50),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:50),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E51=\"\",\"\",SUM($F$2:F51))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N53=\"\",'Pareto Chart'!O53=\"\"),\"\",'Pareto Chart'!N53)","v":""},{"$f":"IF($A52=\"\",\"\",'Pareto Chart'!O53)","v":""},{"$f":"IF($A52=\"\",\"\",RANK($B52,$B$2:$B$100)+COUNTIF(B$2:B52,B52)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:51),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:51),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E52=\"\",\"\",SUM($F$2:F52))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N54=\"\",'Pareto Chart'!O54=\"\"),\"\",'Pareto Chart'!N54)","v":""},{"$f":"IF($A53=\"\",\"\",'Pareto Chart'!O54)","v":""},{"$f":"IF($A53=\"\",\"\",RANK($B53,$B$2:$B$100)+COUNTIF(B$2:B53,B53)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:52),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:52),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E53=\"\",\"\",SUM($F$2:F53))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N55=\"\",'Pareto Chart'!O55=\"\"),\"\",'Pareto Chart'!N55)","v":""},{"$f":"IF($A54=\"\",\"\",'Pareto Chart'!O55)","v":""},{"$f":"IF($A54=\"\",\"\",RANK($B54,$B$2:$B$100)+COUNTIF(B$2:B54,B54)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:53),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:53),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E54=\"\",\"\",SUM($F$2:F54))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N56=\"\",'Pareto Chart'!O56=\"\"),\"\",'Pareto Chart'!N56)","v":""},{"$f":"IF($A55=\"\",\"\",'Pareto Chart'!O56)","v":""},{"$f":"IF($A55=\"\",\"\",RANK($B55,$B$2:$B$100)+COUNTIF(B$2:B55,B55)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:54),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:54),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E55=\"\",\"\",SUM($F$2:F55))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N57=\"\",'Pareto Chart'!O57=\"\"),\"\",'Pareto Chart'!N57)","v":""},{"$f":"IF($A56=\"\",\"\",'Pareto Chart'!O57)","v":""},{"$f":"IF($A56=\"\",\"\",RANK($B56,$B$2:$B$100)+COUNTIF(B$2:B56,B56)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:55),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:55),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E56=\"\",\"\",SUM($F$2:F56))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N58=\"\",'Pareto Chart'!O58=\"\"),\"\",'Pareto Chart'!N58)","v":""},{"$f":"IF($A57=\"\",\"\",'Pareto Chart'!O58)","v":""},{"$f":"IF($A57=\"\",\"\",RANK($B57,$B$2:$B$100)+COUNTIF(B$2:B57,B57)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:56),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:56),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E57=\"\",\"\",SUM($F$2:F57))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N59=\"\",'Pareto Chart'!O59=\"\"),\"\",'Pareto Chart'!N59)","v":""},{"$f":"IF($A58=\"\",\"\",'Pareto Chart'!O59)","v":""},{"$f":"IF($A58=\"\",\"\",RANK($B58,$B$2:$B$100)+COUNTIF(B$2:B58,B58)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:57),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:57),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E58=\"\",\"\",SUM($F$2:F58))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N60=\"\",'Pareto Chart'!O60=\"\"),\"\",'Pareto Chart'!N60)","v":""},{"$f":"IF($A59=\"\",\"\",'Pareto Chart'!O60)","v":""},{"$f":"IF($A59=\"\",\"\",RANK($B59,$B$2:$B$100)+COUNTIF(B$2:B59,B59)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:58),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:58),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E59=\"\",\"\",SUM($F$2:F59))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N61=\"\",'Pareto Chart'!O61=\"\"),\"\",'Pareto Chart'!N61)","v":""},{"$f":"IF($A60=\"\",\"\",'Pareto Chart'!O61)","v":""},{"$f":"IF($A60=\"\",\"\",RANK($B60,$B$2:$B$100)+COUNTIF(B$2:B60,B60)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:59),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:59),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E60=\"\",\"\",SUM($F$2:F60))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N62=\"\",'Pareto Chart'!O62=\"\"),\"\",'Pareto Chart'!N62)","v":""},{"$f":"IF($A61=\"\",\"\",'Pareto Chart'!O62)","v":""},{"$f":"IF($A61=\"\",\"\",RANK($B61,$B$2:$B$100)+COUNTIF(B$2:B61,B61)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:60),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:60),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E61=\"\",\"\",SUM($F$2:F61))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N63=\"\",'Pareto Chart'!O63=\"\"),\"\",'Pareto Chart'!N63)","v":""},{"$f":"IF($A62=\"\",\"\",'Pareto Chart'!O63)","v":""},{"$f":"IF($A62=\"\",\"\",RANK($B62,$B$2:$B$100)+COUNTIF(B$2:B62,B62)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:61),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:61),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E62=\"\",\"\",SUM($F$2:F62))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N64=\"\",'Pareto Chart'!O64=\"\"),\"\",'Pareto Chart'!N64)","v":""},{"$f":"IF($A63=\"\",\"\",'Pareto Chart'!O64)","v":""},{"$f":"IF($A63=\"\",\"\",RANK($B63,$B$2:$B$100)+COUNTIF(B$2:B63,B63)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:62),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:62),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E63=\"\",\"\",SUM($F$2:F63))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N65=\"\",'Pareto Chart'!O65=\"\"),\"\",'Pareto Chart'!N65)","v":""},{"$f":"IF($A64=\"\",\"\",'Pareto Chart'!O65)","v":""},{"$f":"IF($A64=\"\",\"\",RANK($B64,$B$2:$B$100)+COUNTIF(B$2:B64,B64)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:63),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:63),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E64=\"\",\"\",SUM($F$2:F64))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N66=\"\",'Pareto Chart'!O66=\"\"),\"\",'Pareto Chart'!N66)","v":""},{"$f":"IF($A65=\"\",\"\",'Pareto Chart'!O66)","v":""},{"$f":"IF($A65=\"\",\"\",RANK($B65,$B$2:$B$100)+COUNTIF(B$2:B65,B65)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:64),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:64),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E65=\"\",\"\",SUM($F$2:F65))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N67=\"\",'Pareto Chart'!O67=\"\"),\"\",'Pareto Chart'!N67)","v":""},{"$f":"IF($A66=\"\",\"\",'Pareto Chart'!O67)","v":""},{"$f":"IF($A66=\"\",\"\",RANK($B66,$B$2:$B$100)+COUNTIF(B$2:B66,B66)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:65),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:65),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E66=\"\",\"\",SUM($F$2:F66))","v":""},"",{"$f":"IF($E66=\"\",\"\",$L$2/100)","v":""}]
[{"$f":"IF(OR('Pareto Chart'!N68=\"\",'Pareto Chart'!O68=\"\"),\"\",'Pareto Chart'!N68)","v":""},{"$f":"IF($A67=\"\",\"\",'Pareto Chart'!O68)","v":""},{"$f":"IF($A67=\"\",\"\",RANK($B67,$B$2:$B$100)+COUNTIF(B$2:B67,B67)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:66),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:66),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E67=\"\",\"\",SUM($F$2:F67))","v":""},{"$f":"IF($E67=\"\",\"\",$G67/SUM($F$2:$F$100))","v":""},""]
[{"$f":"IF(OR('Pareto Chart'!N69=\"\",'Pareto Chart'!O69=\"\"),\"\",'Pareto Chart'!N69)","v":""},{"$f":"IF($A68=\"\",\"\",'Pareto Chart'!O69)","v":""},{"$f":"IF($A68=\"\",\"\",RANK($B68,$B$2:$B$100)+COUNTIF(B$2:B68,B68)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:67),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:67),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E68=\"\",\"\",SUM($F$2:F68))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N70=\"\",'Pareto Chart'!O70=\"\"),\"\",'Pareto Chart'!N70)","v":""},{"$f":"IF($A69=\"\",\"\",'Pareto Chart'!O70)","v":""},{"$f":"IF($A69=\"\",\"\",RANK($B69,$B$2:$B$100)+COUNTIF(B$2:B69,B69)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:68),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:68),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E69=\"\",\"\",SUM($F$2:F69))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N71=\"\",'Pareto Chart'!O71=\"\"),\"\",'Pareto Chart'!N71)","v":""},{"$f":"IF($A70=\"\",\"\",'Pareto Chart'!O71)","v":""},{"$f":"IF($A70=\"\",\"\",RANK($B70,$B$2:$B$100)+COUNTIF(B$2:B70,B70)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:69),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:69),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E70=\"\",\"\",SUM($F$2:F70))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N72=\"\",'Pareto Chart'!O72=\"\"),\"\",'Pareto Chart'!N72)","v":""},{"$f":"IF($A71=\"\",\"\",'Pareto Chart'!O72)","v":""},{"$f":"IF($A71=\"\",\"\",RANK($B71,$B$2:$B$100)+COUNTIF(B$2:B71,B71)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:70),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:70),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E71=\"\",\"\",SUM($F$2:F71))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N73=\"\",'Pareto Chart'!O73=\"\"),\"\",'Pareto Chart'!N73)","v":""},{"$f":"IF($A72=\"\",\"\",'Pareto Chart'!O73)","v":""},{"$f":"IF($A72=\"\",\"\",RANK($B72,$B$2:$B$100)+COUNTIF(B$2:B72,B72)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:71),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:71),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E72=\"\",\"\",SUM($F$2:F72))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N74=\"\",'Pareto Chart'!O74=\"\"),\"\",'Pareto Chart'!N74)","v":""},{"$f":"IF($A73=\"\",\"\",'Pareto Chart'!O74)","v":""},{"$f":"IF($A73=\"\",\"\",RANK($B73,$B$2:$B$100)+COUNTIF(B$2:B73,B73)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:72),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:72),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E73=\"\",\"\",SUM($F$2:F73))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N75=\"\",'Pareto Chart'!O75=\"\"),\"\",'Pareto Chart'!N75)","v":""},{"$f":"IF($A74=\"\",\"\",'Pareto Chart'!O75)","v":""},{"$f":"IF($A74=\"\",\"\",RANK($B74,$B$2:$B$100)+COUNTIF(B$2:B74,B74)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:73),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:73),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E74=\"\",\"\",SUM($F$2:F74))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N76=\"\",'Pareto Chart'!O76=\"\"),\"\",'Pareto Chart'!N76)","v":""},{"$f":"IF($A75=\"\",\"\",'Pareto Chart'!O76)","v":""},{"$f":"IF($A75=\"\",\"\",RANK($B75,$B$2:$B$100)+COUNTIF(B$2:B75,B75)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:74),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:74),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E75=\"\",\"\",SUM($F$2:F75))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N77=\"\",'Pareto Chart'!O77=\"\"),\"\",'Pareto Chart'!N77)","v":""},{"$f":"IF($A76=\"\",\"\",'Pareto Chart'!O77)","v":""},{"$f":"IF($A76=\"\",\"\",RANK($B76,$B$2:$B$100)+COUNTIF(B$2:B76,B76)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:75),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:75),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E76=\"\",\"\",SUM($F$2:F76))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N78=\"\",'Pareto Chart'!O78=\"\"),\"\",'Pareto Chart'!N78)","v":""},{"$f":"IF($A77=\"\",\"\",'Pareto Chart'!O78)","v":""},{"$f":"IF($A77=\"\",\"\",RANK($B77,$B$2:$B$100)+COUNTIF(B$2:B77,B77)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:76),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:76),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E77=\"\",\"\",SUM($F$2:F77))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N79=\"\",'Pareto Chart'!O79=\"\"),\"\",'Pareto Chart'!N79)","v":""},{"$f":"IF($A78=\"\",\"\",'Pareto Chart'!O79)","v":""},{"$f":"IF($A78=\"\",\"\",RANK($B78,$B$2:$B$100)+COUNTIF(B$2:B78,B78)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:77),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:77),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E78=\"\",\"\",SUM($F$2:F78))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N80=\"\",'Pareto Chart'!O80=\"\"),\"\",'Pareto Chart'!N80)","v":""},{"$f":"IF($A79=\"\",\"\",'Pareto Chart'!O80)","v":""},{"$f":"IF($A79=\"\",\"\",RANK($B79,$B$2:$B$100)+COUNTIF(B$2:B79,B79)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:78),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:78),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E79=\"\",\"\",SUM($F$2:F79))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N81=\"\",'Pareto Chart'!O81=\"\"),\"\",'Pareto Chart'!N81)","v":""},{"$f":"IF($A80=\"\",\"\",'Pareto Chart'!O81)","v":""},{"$f":"IF($A80=\"\",\"\",RANK($B80,$B$2:$B$100)+COUNTIF(B$2:B80,B80)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:79),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:79),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E80=\"\",\"\",SUM($F$2:F80))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N82=\"\",'Pareto Chart'!O82=\"\"),\"\",'Pareto Chart'!N82)","v":""},{"$f":"IF($A81=\"\",\"\",'Pareto Chart'!O82)","v":""},{"$f":"IF($A81=\"\",\"\",RANK($B81,$B$2:$B$100)+COUNTIF(B$2:B81,B81)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:80),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:80),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E81=\"\",\"\",SUM($F$2:F81))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N83=\"\",'Pareto Chart'!O83=\"\"),\"\",'Pareto Chart'!N83)","v":""},{"$f":"IF($A82=\"\",\"\",'Pareto Chart'!O83)","v":""},{"$f":"IF($A82=\"\",\"\",RANK($B82,$B$2:$B$100)+COUNTIF(B$2:B82,B82)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:81),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:81),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E82=\"\",\"\",SUM($F$2:F82))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N84=\"\",'Pareto Chart'!O84=\"\"),\"\",'Pareto Chart'!N84)","v":""},{"$f":"IF($A83=\"\",\"\",'Pareto Chart'!O84)","v":""},{"$f":"IF($A83=\"\",\"\",RANK($B83,$B$2:$B$100)+COUNTIF(B$2:B83,B83)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:82),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:82),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E83=\"\",\"\",SUM($F$2:F83))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N85=\"\",'Pareto Chart'!O85=\"\"),\"\",'Pareto Chart'!N85)","v":""},{"$f":"IF($A84=\"\",\"\",'Pareto Chart'!O85)","v":""},{"$f":"IF($A84=\"\",\"\",RANK($B84,$B$2:$B$100)+COUNTIF(B$2:B84,B84)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:83),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:83),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E84=\"\",\"\",SUM($F$2:F84))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N86=\"\",'Pareto Chart'!O86=\"\"),\"\",'Pareto Chart'!N86)","v":""},{"$f":"IF($A85=\"\",\"\",'Pareto Chart'!O86)","v":""},{"$f":"IF($A85=\"\",\"\",RANK($B85,$B$2:$B$100)+COUNTIF(B$2:B85,B85)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:84),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:84),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E85=\"\",\"\",SUM($F$2:F85))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N87=\"\",'Pareto Chart'!O87=\"\"),\"\",'Pareto Chart'!N87)","v":""},{"$f":"IF($A86=\"\",\"\",'Pareto Chart'!O87)","v":""},{"$f":"IF($A86=\"\",\"\",RANK($B86,$B$2:$B$100)+COUNTIF(B$2:B86,B86)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:85),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:85),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E86=\"\",\"\",SUM($F$2:F86))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N88=\"\",'Pareto Chart'!O88=\"\"),\"\",'Pareto Chart'!N88)","v":""},{"$f":"IF($A87=\"\",\"\",'Pareto Chart'!O88)","v":""},{"$f":"IF($A87=\"\",\"\",RANK($B87,$B$2:$B$100)+COUNTIF(B$2:B87,B87)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:86),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:86),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E87=\"\",\"\",SUM($F$2:F87))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N89=\"\",'Pareto Chart'!O89=\"\"),\"\",'Pareto Chart'!N89)","v":""},{"$f":"IF($A88=\"\",\"\",'Pareto Chart'!O89)","v":""},{"$f":"IF($A88=\"\",\"\",RANK($B88,$B$2:$B$100)+COUNTIF(B$2:B88,B88)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:87),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:87),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E88=\"\",\"\",SUM($F$2:F88))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N90=\"\",'Pareto Chart'!O90=\"\"),\"\",'Pareto Chart'!N90)","v":""},{"$f":"IF($A89=\"\",\"\",'Pareto Chart'!O90)","v":""},{"$f":"IF($A89=\"\",\"\",RANK($B89,$B$2:$B$100)+COUNTIF(B$2:B89,B89)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:88),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:88),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E89=\"\",\"\",SUM($F$2:F89))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N91=\"\",'Pareto Chart'!O91=\"\"),\"\",'Pareto Chart'!N91)","v":""},{"$f":"IF($A90=\"\",\"\",'Pareto Chart'!O91)","v":""},{"$f":"IF($A90=\"\",\"\",RANK($B90,$B$2:$B$100)+COUNTIF(B$2:B90,B90)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:89),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:89),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E90=\"\",\"\",SUM($F$2:F90))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N92=\"\",'Pareto Chart'!O92=\"\"),\"\",'Pareto Chart'!N92)","v":""},{"$f":"IF($A91=\"\",\"\",'Pareto Chart'!O92)","v":""},{"$f":"IF($A91=\"\",\"\",RANK($B91,$B$2:$B$100)+COUNTIF(B$2:B91,B91)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:90),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:90),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E91=\"\",\"\",SUM($F$2:F91))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N93=\"\",'Pareto Chart'!O93=\"\"),\"\",'Pareto Chart'!N93)","v":""},{"$f":"IF($A92=\"\",\"\",'Pareto Chart'!O93)","v":""},{"$f":"IF($A92=\"\",\"\",RANK($B92,$B$2:$B$100)+COUNTIF(B$2:B92,B92)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:91),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:91),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E92=\"\",\"\",SUM($F$2:F92))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N94=\"\",'Pareto Chart'!O94=\"\"),\"\",'Pareto Chart'!N94)","v":""},{"$f":"IF($A93=\"\",\"\",'Pareto Chart'!O94)","v":""},{"$f":"IF($A93=\"\",\"\",RANK($B93,$B$2:$B$100)+COUNTIF(B$2:B93,B93)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:92),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:92),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E93=\"\",\"\",SUM($F$2:F93))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N95=\"\",'Pareto Chart'!O95=\"\"),\"\",'Pareto Chart'!N95)","v":""},{"$f":"IF($A94=\"\",\"\",'Pareto Chart'!O95)","v":""},{"$f":"IF($A94=\"\",\"\",RANK($B94,$B$2:$B$100)+COUNTIF(B$2:B94,B94)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:93),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:93),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E94=\"\",\"\",SUM($F$2:F94))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N96=\"\",'Pareto Chart'!O96=\"\"),\"\",'Pareto Chart'!N96)","v":""},{"$f":"IF($A95=\"\",\"\",'Pareto Chart'!O96)","v":""},{"$f":"IF($A95=\"\",\"\",RANK($B95,$B$2:$B$100)+COUNTIF(B$2:B95,B95)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:94),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:94),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E95=\"\",\"\",SUM($F$2:F95))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N97=\"\",'Pareto Chart'!O97=\"\"),\"\",'Pareto Chart'!N97)","v":""},{"$f":"IF($A96=\"\",\"\",'Pareto Chart'!O97)","v":""},{"$f":"IF($A96=\"\",\"\",RANK($B96,$B$2:$B$100)+COUNTIF(B$2:B96,B96)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:95),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:95),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E96=\"\",\"\",SUM($F$2:F96))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N98=\"\",'Pareto Chart'!O98=\"\"),\"\",'Pareto Chart'!N98)","v":""},{"$f":"IF($A97=\"\",\"\",'Pareto Chart'!O98)","v":""},{"$f":"IF($A97=\"\",\"\",RANK($B97,$B$2:$B$100)+COUNTIF(B$2:B97,B97)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:96),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:96),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E97=\"\",\"\",SUM($F$2:F97))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N99=\"\",'Pareto Chart'!O99=\"\"),\"\",'Pareto Chart'!N99)","v":""},{"$f":"IF($A98=\"\",\"\",'Pareto Chart'!O99)","v":""},{"$f":"IF($A98=\"\",\"\",RANK($B98,$B$2:$B$100)+COUNTIF(B$2:B98,B98)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:97),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:97),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E98=\"\",\"\",SUM($F$2:F98))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N100=\"\",'Pareto Chart'!O100=\"\"),\"\",'Pareto Chart'!N100)","v":""},{"$f":"IF($A99=\"\",\"\",'Pareto Chart'!O100)","v":""},{"$f":"IF($A99=\"\",\"\",RANK($B99,$B$2:$B$100)+COUNTIF(B$2:B99,B99)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:98),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:98),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E99=\"\",\"\",SUM($F$2:F99))","v":""},"",""]
[{"$f":"IF(OR('Pareto Chart'!N101=\"\",'Pareto Chart'!O101=\"\"),\"\",'Pareto Chart'!N101)","v":""},{"$f":"IF($A100=\"\",\"\",'Pareto Chart'!O101)","v":""},{"$f":"IF($A100=\"\",\"\",RANK($B100,$B$2:$B$100)+COUNTIF(B$2:B100,B100)-1)","v":""},null,{"$f":"IFERROR(INDEX($A$2:$A$100,MATCH(ROWS($1:99),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IFERROR(INDEX($B$2:$B$100,MATCH(ROWS($1:99),$C$2:$C$100,0)),\"\")","v":""},{"$f":"IF($E100=\"\",\"\",SUM($F$2:F100))","v":""},"",""]