{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Check Sheet - Before","Check Sheet - After","Check Sheet - Comparison","Before Example","After Example","Comparison Example"],"not_rendered":{"charts":10,"images":2,"macros":1,"external_links":0,"defined_names":13,"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":"Instructions","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,5]]}
[]
["Check Sheet, Bar Chart, and Pareto Chart Instructions"]
["Data input",null,"Enter the type of error in the error type column and use the buttons to increase or decrease the count as needed. You can also directly enter a number into the count field if that is more convenient."]
["Formatting the graphs",null,"To sort the errors types by frequency and format the graphs, click on the button below the check sheet labeled \"Delete rows and format chart\". Please note that this cannot be undone, so only click the button when you have entered all the data required for that tab. "]
["Including after data",null,"If you want to compare data before and after you've made an improvement, you will need to fill out the 'Check Sheet - Before' and 'Check Sheet - After' tabs. Once you've included both sets of data, click 'Delete rows and format chart' on the 'Check Sheet - Comparison' tab to view a bar chart comparing the before and after data. "]
[]
[]
[]
["Adding rows",null,"If you need to add additional error types, select the bottom row and copy and paste it to the row below. Right click on the arrow button control and select \"Format control\". Click the arrow to the right of the \"Cell link\" field and then select the cell to the left of the control in the count column and click \"Ok\". Lastly, click in the white space somewhere in the center of the chart. When the colored boxes show up, drag them over  the new column to include them in the chart"]
["Selecting data",null,"To select or deselect data, click the white space in the center of the bar chart and drag the colored boxes that appear on the left over the desired data"]

{"sheet":"Check Sheet - Before","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,10],[0,11,0,14],[1,1,1,5],[1,7,1,10],[1,12,1,14]]}
[]
[null,"[Insert title]",null,null,null,null,null,{"$f":"$B$2","v":"[Insert title]"},null,null,null,null,{"$f":"$B$2","v":"[Insert title]"}]
[]
[null,"Error Type","Count",null,"% of Total","Cumulative"]
[null,null,0,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0},{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E6)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E7)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E8)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E9)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E10)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E11)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E12)","v":0}]
[null,null,0,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C13/SUM($C$5:$C$15))","v":0},{"$f":"SUM($E$5:E13)","v":0}]
[null,null,0,null,0,{"$f":"SUM($E$5:E14)","v":0}]
[null,null,0,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C15/SUM($C$5:$C$15))","v":0},{"$f":"SUM($E$5:E15)","v":0}]

{"sheet":"Check Sheet - After","index":2,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,10],[0,11,0,14],[1,1,1,5],[1,7,1,10],[1,12,1,14]]}
[]
[null,{"$f":"'Check Sheet - Before'!B2:F2","v":"[Insert title]"},null,null,null,null,null,{"$f":"B2","v":"[Insert title]"},null,null,null,null,{"$f":"H2","v":"[Insert title]"}]
[]
[null,"Error Type","Count",null,"% of Total","Cumulative"]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B5),\"\",IF(ISBLANK('Check Sheet - Before'!B5),\"\",'Check Sheet - Before'!B5))","v":""},0,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0},{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B6),\"\",IF(ISBLANK('Check Sheet - Before'!B6),\"\",'Check Sheet - Before'!B6))","v":""},0,null,0,{"$f":"SUM($E$5:E6)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B8),\"\",IF(ISBLANK('Check Sheet - Before'!B8),\"\",'Check Sheet - Before'!B8))","v":""},0,null,0,{"$f":"SUM($E$5:E7)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B9),\"\",IF(ISBLANK('Check Sheet - Before'!B9),\"\",'Check Sheet - Before'!B9))","v":""},0,null,0,{"$f":"SUM($E$5:E8)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B7),\"\",IF(ISBLANK('Check Sheet - Before'!B7),\"\",'Check Sheet - Before'!B7))","v":""},0,null,0,{"$f":"SUM($E$5:E9)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B10),\"\",IF(ISBLANK('Check Sheet - Before'!B10),\"\",'Check Sheet - Before'!B10))","v":""},0,null,0,{"$f":"SUM($E$5:E10)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B11),\"\",IF(ISBLANK('Check Sheet - Before'!B11),\"\",'Check Sheet - Before'!B11))","v":""},0,null,0,{"$f":"SUM($E$5:E11)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B13),\"\",IF(ISBLANK('Check Sheet - Before'!B13),\"\",'Check Sheet - Before'!B13))","v":""},0,null,0,{"$f":"SUM($E$5:E12)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B14),\"\",IF(ISBLANK('Check Sheet - Before'!B14),\"\",'Check Sheet - Before'!B14))","v":""},0,null,0,{"$f":"SUM($E$5:E13)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B15),\"\",IF(ISBLANK('Check Sheet - Before'!B15),\"\",'Check Sheet - Before'!B15))","v":""},0,null,0,{"$f":"SUM($E$5:E14)","v":0}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B12),\"\",IF(ISBLANK('Check Sheet - Before'!B12),\"\",'Check Sheet - Before'!B12))","v":""},0,null,0,{"$f":"SUM($E$5:E15)","v":0}]

{"sheet":"Check Sheet - Comparison","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,4],[1,7,1,18]]}
[]
[null,{"$f":"'Check Sheet - Before'!B2:F2","v":"[Insert title]"},null,null,null,null,null,{"$f":"B2","v":"[Insert title]"}]
[]
[null,"Error Type","Before","After","% Improvement"]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B5), \"\", IF(ISBLANK('Check Sheet - Before'!B5), \"\", 'Check Sheet - Before'!B5))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C5), \"\", IF(ISBLANK('Check Sheet - Before'!C5), \"\", 'Check Sheet - Before'!C5)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B5,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B5,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},{"$f":"_xlfn.IFNA(IFERROR((C5-D5)/C5,\"\"),\"\")","v":""}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B6), \"\", IF(ISBLANK('Check Sheet - Before'!B6), \"\", 'Check Sheet - Before'!B6))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C6), \"\", IF(ISBLANK('Check Sheet - Before'!C6), \"\", 'Check Sheet - Before'!C6)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B6,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B6,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},{"$f":"_xlfn.IFNA(IFERROR((C6-D6)/C6,\"\"),\"\")","v":""}]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B7), \"\", IF(ISBLANK('Check Sheet - Before'!B7), \"\", 'Check Sheet - Before'!B7))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C7), \"\", IF(ISBLANK('Check Sheet - Before'!C7), \"\", 'Check Sheet - Before'!C7)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B7,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B7,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B8), \"\", IF(ISBLANK('Check Sheet - Before'!B8), \"\", 'Check Sheet - Before'!B8))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C8), \"\", IF(ISBLANK('Check Sheet - Before'!C8), \"\", 'Check Sheet - Before'!C8)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B8,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B8,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B9), \"\", IF(ISBLANK('Check Sheet - Before'!B9), \"\", 'Check Sheet - Before'!B9))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C9), \"\", IF(ISBLANK('Check Sheet - Before'!C9), \"\", 'Check Sheet - Before'!C9)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B9,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B9,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B10), \"\", IF(ISBLANK('Check Sheet - Before'!B10), \"\", 'Check Sheet - Before'!B10))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C10), \"\", IF(ISBLANK('Check Sheet - Before'!C10), \"\", 'Check Sheet - Before'!C10)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B10,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B10,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B11), \"\", IF(ISBLANK('Check Sheet - Before'!B11), \"\", 'Check Sheet - Before'!B11))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C11), \"\", IF(ISBLANK('Check Sheet - Before'!C11), \"\", 'Check Sheet - Before'!C11)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B11,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B11,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B12), \"\", IF(ISBLANK('Check Sheet - Before'!B12), \"\", 'Check Sheet - Before'!B12))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C12), \"\", IF(ISBLANK('Check Sheet - Before'!C12), \"\", 'Check Sheet - Before'!C12)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B12,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B12,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B13), \"\", IF(ISBLANK('Check Sheet - Before'!B13), \"\", 'Check Sheet - Before'!B13))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C13), \"\", IF(ISBLANK('Check Sheet - Before'!C13), \"\", 'Check Sheet - Before'!C13)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B13,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B13,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B14), \"\", IF(ISBLANK('Check Sheet - Before'!B14), \"\", 'Check Sheet - Before'!B14))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C14), \"\", IF(ISBLANK('Check Sheet - Before'!C14), \"\", 'Check Sheet - Before'!C14)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B14,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B14,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]
[null,{"$f":"IF(ISERROR('Check Sheet - Before'!B15), \"\", IF(ISBLANK('Check Sheet - Before'!B15), \"\", 'Check Sheet - Before'!B15))","v":""},{"$f":"_xlfn.IFNA(IF(ISERROR('Check Sheet - Before'!C15), \"\", IF(ISBLANK('Check Sheet - Before'!C15), \"\", 'Check Sheet - Before'!C15)),\"\")","v":0},{"$f":"_xlfn.IFNA(IF(ISERR(VLOOKUP(B15,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),,VLOOKUP(B15,'Check Sheet - After'!$B$5:$C$15, 2, FALSE)),\"\")","v":0},""]

{"sheet":"Before Example","index":4,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,10],[0,11,0,14],[1,1,1,5],[1,7,1,10],[1,12,1,14]]}
[]
[null,"Errors on employee onboarding form",null,null,null,null,null,{"$f":"$B$2","v":"Errors on employee onboarding form"},null,null,null,null,{"$f":"$B$2","v":"Errors on employee onboarding form"}]
[]
[null,"Error Type","Count",null,"% of Total","Cumulative"]
[null,"Invalid date format",17,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0.24637681159420291},{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0.24637681159420291}]
[null,"Did not receive forms",14,null,0.20289855072463769,{"$f":"SUM($E$5:E6)","v":0.44927536231884058}]
[null,"Hand writing unreadable",9,null,0.13043478260869565,{"$f":"SUM($E$5:E7)","v":0.57971014492753625}]
[null,"Forms were late",8,null,0.11594202898550725,{"$f":"SUM($E$5:E8)","v":0.69565217391304346}]
[null,"Invalid divers license",6,null,8.6956521739130432E-2,{"$f":"SUM($E$5:E9)","v":0.78260869565217384}]
[null,"No signature",4,null,5.7971014492753624E-2,{"$f":"SUM($E$5:E10)","v":0.84057971014492749}]
[null,"Used a pencil",4,null,5.7971014492753624E-2,{"$f":"SUM($E$5:E11)","v":0.89855072463768115}]
[null,"Missing back page",3,null,4.3478260869565216E-2,{"$f":"SUM($E$5:E12)","v":0.94202898550724634}]
[null,"No SSN",2,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C13/SUM($C$5:$C$15))","v":2.8985507246376812E-2},{"$f":"SUM($E$5:E13)","v":0.97101449275362317}]
[null,"No name",1,null,1.4492753623188406E-2,{"$f":"SUM($E$5:E14)","v":0.98550724637681153}]
[null,"Invalid SSN",1,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C15/SUM($C$5:$C$15))","v":1.4492753623188406E-2},{"$f":"SUM($E$5:E15)","v":0.99999999999999989}]

{"sheet":"After Example","index":5,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5],[0,6,0,10],[0,11,0,14],[1,1,1,5],[1,7,1,10],[1,12,1,14]]}
[]
[null,{"$f":"'Before Example'!B2:F2","v":"Errors on employee onboarding form"},null,null,null,null,null,{"$f":"B2","v":"Errors on employee onboarding form"},null,null,null,null,{"$f":"H2","v":"Errors on employee onboarding form"}]
[]
[null,"Error Type","Count",null,"% of Total","Cumulative"]
[null,"Forms were late",5,null,{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0.3125},{"$f":"IF(SUM($C$5:$C$15)<1,0,C5/SUM($C$5:$C$15))","v":0.3125}]
[null,"Did not receive forms",3,null,0.1875,{"$f":"SUM($E$5:E6)","v":0.5}]
[null,"No signature",3,null,0.1875,{"$f":"SUM($E$5:E7)","v":0.6875}]
[null,"No SSN",2,null,0.125,{"$f":"SUM($E$5:E8)","v":0.8125}]
[null,"Invalid SSN",1,null,6.25E-2,{"$f":"SUM($E$5:E9)","v":0.875}]
[null,"Invalid date format",1,null,6.25E-2,{"$f":"SUM($E$5:E10)","v":0.9375}]
[null,"Invalid divers license",1,null,6.25E-2,{"$f":"SUM($E$5:E11)","v":1}]
[null,"Hand writing unreadable",0,null,0,{"$f":"SUM($E$5:E12)","v":1}]
[null,"Used a pencil",0,null,0,{"$f":"SUM($E$5:E13)","v":1}]
[null,"No name",0,null,0,{"$f":"SUM($E$5:E14)","v":1}]
[null,"Missing back page",0,null,0,{"$f":"SUM($E$5:E15)","v":1}]

{"sheet":"Comparison Example","index":6,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,4],[1,7,1,18]]}
[]
[null,{"$f":"'Before Example'!B2:F2","v":"Errors on employee onboarding form"},null,null,null,null,null,{"$f":"B2","v":"Errors on employee onboarding form"}]
[]
[null,"Error Type","Before","After","% Improvement"]
[null,"Invalid date format",17,1,{"$f":"IFERROR((C5-D5)/C5,\"\")","v":0.94117647058823528}]
[null,"Did not receive forms",14,3,{"$f":"IFERROR((C6-D6)/C6,\"\")","v":0.7857142857142857}]
[null,"Hand writing unreadable",9,0,{"$f":"IFERROR((C7-D7)/C7,\"\")","v":1}]
[null,"Forms were late",8,5,0.375]
[null,"Invalid divers license",6,1,0.83333333333333337]
[null,"No signature",4,3,{"$f":"IFERROR((C10-D10)/C10,\"\")","v":0.25}]
[null,"Used a pencil",4,0,{"$f":"IFERROR((C11-D11)/C11,\"\")","v":1}]
[null,"Missing back page",3,0,1]
[null,"No SSN",2,2,0]
[null,"No name",1,0,1]
[null,"Invalid SSN",1,1,0]