{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["How to build a Pareto Chart","Data & Excel Navigation","Chart"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"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":"How to build a Pareto Chart","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,3,23,8],[0,0,2,8],[5,0,7,2],[9,0,11,2],[13,0,15,2],[17,0,19,2],[21,0,23,2],[5,3,7,8],[9,3,11,8],[13,3,15,8],[17,3,19,8]]}
["How To Build A Pareto Chart?"]
[]
[]
[]
[]
["STEP ONE",null,null,"Plot the contributing factors based on the number of votes received in order from highest to lowest"]
[]
[]
[]
["STEP TWO",null,null,"Calculate the proportion that each factor contributes to the problem. Plot the proportions on the cumulative frequency axis"]
[]
[]
[]
["STEP THREE",null,null,"Draw a line from the factor with the highes proportion until it meets the 100 per cent mark on the cumulative frequency axis."]
[]
[]
[]
["STEP FOUR",null,null,"Draw a straight line from the 80 per cent mark on the cumulative frequency axis until it meets the curved line"]
[]
[]
[]
["STEP FIVE",null,null,"Draw a line straight down from the point of intersection to the x axis on the bar graph"]

{"sheet":"Data & Excel Navigation","index":1,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,0,29,0],[31,0,32,0],[6,0,8,0],[9,0,12,0],[13,0,15,0],[21,0,22,0],[23,0,26,0],[16,0,20,0]]}
[]
[]
["Pareto Chart Template"]
[]
[]
["Navigation for Excel:","Root Cause","Frequency\n(# of Votes)","%Frequency",null,"Cumulative Frequency",null,"Frequency Total",{"$f":"SUM(OFFSET($C$7,0,0,COUNTA(C:C),1))","v":9}]
["Overwrite the Sample data, entering the Root Causes and the Frequency (# of votes) from the Root Cause Analysis tools (fishbone, 5 whys, etc)","sample 3",3,{"$f":"C7/$I$6","v":0.33333333333333331},null,{"$f":"Table2[[#This Row],[%Frequency]]","v":0.33333333333333331},null,"%Frequency Total",{"$f":"SUM(OFFSET($D$7,0,0,COUNTA(D:D),1))","v":1}]
[null,"sample 2",2,0.22222222222222221,null,{"$f":"F7+Table2[[#This Row],[%Frequency]]","v":0.55555555555555558}]
[null,"sample 4",2,0.22222222222222221,null,{"$f":"F8+Table2[[#This Row],[%Frequency]]","v":0.77777777777777779}]
["Use your \"Tab\" Key to move between the cells. Using the \"Tab\" key in the %Frequency column will add additional rows to the table.","sample 1",1,0.1111111111111111,null,{"$f":"F9+Table2[[#This Row],[%Frequency]]","v":0.88888888888888884}]
[null,"sample 5",1,0.1111111111111111,null,{"$f":"F10+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F11+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F12+Table2[[#This Row],[%Frequency]]","v":1}]
["As you add data, the table will update the % Frequency and % Cumulative Frequency values",null,0,0,null,{"$f":"F13+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F14+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F15+Table2[[#This Row],[%Frequency]]","v":1}]
["Click the filter button for Frequency(# of votes) to sort your list from largest to smallest.",null,0,0,null,{"$f":"F16+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F17+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F18+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F19+Table2[[#This Row],[%Frequency]]","v":1}]
[null,null,0,0,null,{"$f":"F20+Table2[[#This Row],[%Frequency]]","v":1}]
["As you add data, the table will update the Pareto Chart on the Chart Tab"]
[]
["On the Chart tab, review your chart. \nSelect and move the vertical blue line to intersect where the %Cumulative Frequency line crosses over the 80% line. "]
[]
[]
[]
["Everything to the left of this intersection is the \"Vital Few\". Everything to the right of this intersection is the \"Trivial Many\"."]
[]
[]
[]
["Congratulations! \nYou have successfully built a Pareto Chart."]

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