{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Pareto Chart Template ","80 20 Rule","Example "],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":1,"defined_names":0,"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 Template ","index":0,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[14,4,14,8],[15,4,15,8],[16,4,16,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Chart title"]
[null,null,null,"Y Axis label"]
[null,null,null,"X Axis Label"]
[]
[null,null,null,"Causes ","Frequency ","Cumulative Total","Cumulative %",0.8]
[null,null,null,null,null,{"$f":"E20","v":0},{"$f":"IF($E$30<>0, F20/$E$30, \"\")","v":""},0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E21)","v":0},{"$f":"IF($E$30<>0, F21/$E$30, \"\")","v":""},0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E22)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E23)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E24)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E25)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E26)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E27)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E28)","v":0},"",0.8]
[null,null,null,null,null,{"$f":"SUM(E20:E29)","v":0},"",0.8]
[null,null,null,"Total",{"$f":"SUM(E20:E29)","v":0}]

{"sheet":"80 20 Rule","index":1,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 1 Pareto chart example"]

{"sheet":"Example ","index":2,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[18,3,18,7],[16,3,16,7],[15,3,15,7],[17,3,17,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Chart title","Medication Errors"]
[null,null,"Left y-axis label","Frequency of medication errors"]
[null,null,"Right y-axis label","Cumulative percentage "]
[null,null,"X-axis label","Types of medication errors"]
[]
[null,null,"Causes ","Frequency ","Cumulative Total","Cumulative %",0.8]
[null,null,"Dose missed",92,{"$f":"D22","v":92},{"$f":"E22/$D$32","v":0.215962441314554},0.8]
[null,null,"Wrong time",83,{"$f":"SUM(D22:D23)","v":175},0.41079812206572769,0.8]
[null,null,"Wrong drug",76,{"$f":"SUM(D22:D24)","v":251},0.58920187793427226,0.8]
[null,null,"Overdose",59,{"$f":"SUM(D22:D25)","v":310},0.72769953051643188,0.8]
[null,null,"Wrong patient",53,{"$f":"SUM(D22:D26)","v":363},0.852112676056338,0.8]
[null,null,"Wrong route",27,{"$f":"SUM(D22:D27)","v":390},0.91549295774647887,0.8]
[null,null,"Wrong calculation ",16,{"$f":"SUM(D22:D28)","v":406},0.95305164319248825,0.8]
[null,null,"Duplicated drugs",9,{"$f":"SUM(D22:D29)","v":415},0.9741784037558685,0.8]
[null,null,"Underdose",7,{"$f":"SUM(D22:D30)","v":422},0.99061032863849763,0.8]
[null,null,"Wrong IV rate ",4,{"$f":"SUM(D22:D31)","v":426},1,0.8]
[null,null,"Total",{"$f":"SUM(D22:D31)","v":426}]