{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Enter Data","Pareto Chart","DO NOT MODIFY","Contact Info"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Pareto Chart","index":1,"reason":"not_a_worksheet"}],"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":"Enter Data","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1]]}
["  1. Add Reasons / Types / Causes in Column A & Number of Occurences in Column B",null,"  2. Enter Chart Title in cell C3"]
["  3. Select Ctrl-P to generate Pareto Chart"]
["Reasons","Quantity","Chart Title"]
["Cause 1",87]
["Cause 2",230]
["Cause 3",40]
["Cause 4",333]
["Cause 5",400]
["Cause 6",10]
["Cause 7",211]

{"sheet":"DO NOT MODIFY","index":2,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Reasons","Quantity","Cumulative","Percent"]
["Cause 5",400,{"$f":"D4","v":0.30511060259344014},{"$f":"B4/$B$29","v":0.30511060259344014}]
["Cause 4",333,{"$f":"C4+D5","v":0.55911517925247911},0.25400457665903892]
["Cause 2",230,{"$f":"C5+D6","v":0.73455377574370717},0.17543859649122806]
["Cause 7",211,0.89549961861174687,0.16094584286803967]
["Cause 1",87,0.96186117467582011,6.6361556064073221E-2]
["Cause 3",40,0.99237223493516413,3.0511060259344011E-2]
["Cause 6",10,1.0000000000000002,7.6277650648360028E-3]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[null,null,1.0000000000000002,0]
[{"$f":"COUNTA(A4:A28)","v":7},{"$f":"SUM(B4:B28)","v":1311}]

{"sheet":"Contact Info","index":3,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Karen Martin, President        \n858.677.6799"]
["www.ksmartin.com/subscribe"]