{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Master Architecture","Start Page","Definitions","Pareto Example","Histogram Example","ScatterPlot Example","Control Chart Example","Examples and Interpretation","Chart Maker","Make a Box Plot","Box Plot","Make a Pareto Chart","Pareto Chart","Make a Histogram","Histogram","Make a Control Chart","Control Chart","Make a ScatterPlot","Scatterplot","Sigma Calculator"],"not_rendered":{"charts":10,"images":12,"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":"Master Architecture","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Start Page","index":1,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,4,1,11],[2,3,3,12],[23,0,23,1],[22,0,22,1],[6,6,6,9],[6,0,7,1],[5,7,5,8],[9,0,9,1],[16,0,16,1]]}
[]
[]
[null,null,null,"SIX SIGMA PRACTITIONER'S TOOLKIT: GRAPHICAL ANALYSIS"]

{"sheet":"Definitions","index":2,"n_rows":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,2,4,2],[1,0,2,1],[14,14,19,14],[3,0,3,1],[10,0,10,1],[16,0,16,1],[17,0,17,1],[12,11,12,12],[13,11,13,12],[6,7,6,8],[55,2,55,4],[15,9,19,10],[15,11,19,12],[9,7,13,8],[12,9,14,10],[15,7,15,8],[10,9,10,10]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Used To..."]
[null,null,"Choose A Tool…"]
[null,null,1]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$9,$C$48:$G$54,3,FALSE)","v":"View variability and centering in a variable Y vs. an attribute X"}]
[null,null,null,null,null,null,null,null,null,"How It Works…"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$9,$C$48:$G$54,4,FALSE)","v":"Rank-orders observations into quartiles"}]
[null,null,null,null,null,null,null,null,null,null,null,"More Info…"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($C$9,$C$48:$G$54,5,FALSE)","v":"The interquartile range is the range from the 1st to 3rd quartiles"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,"Box Plot","View variability and centering in a variable Y vs. an attribute X","Rank-orders observations into quartiles","The interquartile range is the range from the 1st to 3rd quartiles"]
[null,null,2,"Pareto Chart","Identify the \"Critical\" few","Organizes categories from largest to smallest","Pareto's Principle: 80% of the defects comes from 20% of the causes"]
[null,null,3,"Histogram","A frequency plot showing the amount or percentage of data points in each class","Organizes counts for output being measured","Visual analysis of data sample"]
[null,null,4,"Scatter Plot","Visually identify corrilation between two variables","Plot points of data related to two variables","A best fit line and R Squared Coefficient can be obtained"]
[null,null,5,"Control Chart","Identify if a process is \"in control;\" indicates the possibility of special cause variation","Plots time series data along equal intervals","Calculates standard deviation, mean, and Upper and Lower Control Limits"]
[null,null,6,"Sigma Value","Identifies the level of quality of a process based on DPO","Based on the number of defects per million opportunities","Allows a standard measure to be used that can apply to any process"]

{"sheet":"Pareto Example","index":3,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[6,0,8,1]]}
[]
[]
[]
[null,null,null,"Category Label","# of Defects","% of Total","Cumulative %"]
[null,null,null,"Correct/Complete Response/Resolution",133,{"$f":"E5/(SUM($E$5:$E$70))","v":0.34366925064599474},{"$f":"F5","v":0.34366925064599474}]
[null,null,null,"Interpreted/Applied Tax Law Correctly",54,0.1395348837209302,{"$f":"F6+G5","v":0.48320413436692494}]
[null,null,null,"Apparent Use of the Probe and Response Guide",42,0.10852713178294571,0.59173126614987059]
[null,null,null,"Effective Listening: ",22,5.6847545219638224E-2,0.64857881136950879]
[null,null,null,"Obtain/Determine Tax Law Facts",20,5.1679586563307477E-2,0.7002583979328163]
[null,null,null,"Appropriate Referral",18,4.651162790697673E-2,0.74677002583979302]
[null,null,null,"Avoid Extraneous Dialog",14.000000000000114,3.6175710594315527E-2,0.78294573643410859]
[null,null,null,"Complete Probing per Probe & Response Guide",13,3.3591731266149859E-2,0.81653746770025848]
[null,null,null,"Courteous (Phones)",12.000000000000114,3.100775193798478E-2,0.84754521963824325]
[null,null,null,"Issue Identification",10,2.5839793281653738E-2,0.87338501291989701]
[null,null,null,"Complete Response per Probe & Response Guide",10,2.5839793281653738E-2,0.89922480620155076]
[null,null,null,"Explain IRS Time Frames",7.0000000000000142,1.8087855297157653E-2,0.91731266149870838]
[null,null,null,"Ensured Taxpayer’s Level of Understanding(Phones)",7,1.8087855297157618E-2,0.935400516795866]
[null,null,null,"Used Appropriate Language(Phones)",5,1.2919896640826869E-2,0.94832041343669282]
[null,null,null,"Complete Research - Account Related Systems",5,1.2919896640826869E-2,0.96124031007751964]
[null,null,null,"Apologized (Phones)",3,7.7519379844961213E-3,0.96899224806201578]
[null,null,null,"Conversation Control",2.9999999999999929,7.7519379844961031E-3,0.97674418604651192]
[null,null,null,"Closing (Phones)",1.9999999999998863,5.1679586563304538E-3,0.98191214470284238]
[null,null,null,"Assistor Identification",1,2.5839793281653739E-3,0.98449612403100772]
[null,null,null,"Verify Name",1,2.5839793281653739E-3,0.98708010335917307]
[null,null,null,"Verify Address",1,2.5839793281653739E-3,0.98966408268733841]
[null,null,null,"Verify Ofc/Signatory",1,2.5839793281653739E-3,0.99224806201550375]
[null,null,null,"Authorized Disclosure ",1,2.5839793281653739E-3,0.99483204134366909]
[null,null,null,"High Risk",1,2.5839793281653739E-3,0.99741602067183444]
[null,null,null,"Return Delinquency Liability Determination",1,2.5839793281653739E-3,0.99999999999999978]
[null,null,null,"Greeting/Opening:",0,0,0.99999999999999978]
[null,null,null,"Appropriate use of Hold Time",0,0,0.99999999999999978]
[null,null,null,"Phone Purpose Statement:",0,0,0.99999999999999978]
[null,null,null,"Verify TIN",0,0,0.99999999999999978]
[null,null,null,"Verify Date of Birth",0,0,0.99999999999999978]
[null,null,null,"Verify Filing  Status",0,0,0.99999999999999978]
[null,null,null,"Appropriate Call Transfer",0,0,0.99999999999999978]
[null,null,null,"History Item",0,{"$f":"E37/(SUM($E$5:$E$70))","v":0},0.99999999999999978]
[null,null,null,"Check Annotation Explained",0,0,{"$f":"F38+G37","v":0.99999999999999978}]
[null,null,null,"Verify POA/3rd",0,0,0.99999999999999978]
[null,null,null,"Balance Due / Payoff Computation",0,0,0.99999999999999978]
[null,null,null,"Appropriate Timely Actions - For use by National Quality Review Staffs Only",0,0,0.99999999999999978]
[null,null,null,"Identified Taxpayer Advocate Service",0,0,0.99999999999999978]
[null,null,null,"Oral Statement",0,0,0.99999999999999978]
[null,null,null,"Notice Suppression/Release ",0,0,0.99999999999999978]
[null,null,null,"Appropriate use of Wrap Time - Managers Only",0,0,0.99999999999999978]
[null,null,null,"Verify Refund Amount",0,0,0.99999999999999978]
[null,null,null,"Accepted Information from Third Party",0,0,0.99999999999999978]
[null,null,null,"Full Compliance/Cause & Cure Addressed",0,0,0.99999999999999978]
[null,null,null,"Analyze Ability to Pay",0,0,0.99999999999999978]
[null,null,null,"Telephone Contact Attempted",0,0,0.99999999999999978]
[null,null,null,"Lien Determination/Filing",0,0,0.99999999999999978]
[null,null,null,"Warned of Enforced Action",0,0,0.99999999999999978]
[null,null,null,"IA Input",0,0,0.99999999999999978]
[null,null,null,"IA Terms/Conditions/Deadlines",0,0,0.99999999999999978]
[null,null,null,"IA Regulations ",0,0,0.99999999999999978]
[null,null,null,"Requested / Secured Financial Information",0,0,0.99999999999999978]
[null,null,null,"Levy(s) Issued",0,0,0.99999999999999978]
[null,null,null,"Levy Source(s)",0,0,0.99999999999999978]
[null,null,null,"Levy Release(s)",0,0,0.99999999999999978]
[null,null,null,"Input into ACS",0,0,0.99999999999999978]
[null,null,null,"Payment Code",0,0,0.99999999999999978]
[null,null,null,"Exam Techniques",0,0,0.99999999999999978]
[null,null,null,"Work Papers Support Conclusion",0,0,0.99999999999999978]
[null,null,null,"Exam/AUR Required Statutory Procedures",0,0,0.99999999999999978]
[null,null,null,"Case Administration",0,0,0.99999999999999978]
[null,null,null,"Report Writing",0,0,0.99999999999999978]
[null,null,null,"Tax Computation",0,0,0.99999999999999978]
[null,null,null,"Interest Computation",0,0,0.99999999999999978]
[null,null,null,"Penalty Computation",0,{"$f":"E69/(SUM($E$5:$E$70))","v":0},0.99999999999999978]
[null,null,null,"Credits Computation",0,{"$f":"E70/(SUM($E$5:$E$70))","v":0},{"$f":"F70+G69","v":0.99999999999999978}]
[null,null,null,null,387]

{"sheet":"Histogram Example","index":4,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[27,6,27,12],[23,6,23,12],[4,0,6,1],[20,5,20,12],[21,6,21,12],[22,6,22,12]]}
[]
[]
[]
[null,null,"Output","Count"]
[null,null,1,1]
[null,null,2,10]
[null,null,3,20]
[null,null,4,20]
[null,null,5,30]
[null,null,6,30]
[null,null,7,30]
[null,null,8,40]
[null,null,9,50]
[null,null,10,50]
[null,null,11,60]
[null,null,12,60]
[null,null,13,70]
[null,null,14,80]
[null,null,15,90]
[null,null,16,100]
[null,null,17,130,null,"Legend"]
[null,null,18,160,null,"A","Mean - Average"]
[null,null,19,180,null,"B","Mode - Greatest count"]
[null,null,20,200,null,"C","Median - Center point of Data"]
[null,null,21,190]
[null,null,22,180]
[null,null,23,170]
[null,null,24,160]
[null,null,25,150]
[null,null,26,140]
[null,null,27,120]
[null,null,28,110]
[null,null,29,100]
[null,null,30,90]
[null,null,31,80]
[null,null,32,70]
[null,null,33,60]
[null,null,34,60]
[null,null,35,50]
[null,null,36,50]
[null,null,37,40]
[null,null,38,40]
[null,null,39,40]
[null,null,40,40]
[null,null,41,30]
[null,null,42,30]
[null,null,43,20]
[null,null,44,20]
[null,null,45,20]
[null,null,46,10]
[null,null,47,10]
[null,null,48,10]
[null,null,49,10]
[null,null,50,10]

{"sheet":"ScatterPlot Example","index":5,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[27,6,27,12],[24,6,24,12],[25,6,25,12],[4,0,6,1],[26,6,26,12],[20,5,20,12],[21,6,21,12],[22,6,22,12],[23,6,23,12]]}
[]
[]
[]
[null,null,"# of Reviews","Total Opportunities"]
[null,null,16,179]
[null,null,12,129]
[null,null,84,814]
[null,null,16,111]
[null,null,45,612]
[null,null,20,210]
[null,null,4,53]
[null,null,29,351]
[null,null,17,214]
[null,null,8,89]
[null,null,28,323]
[null,null,19,247]
[null,null,32,410]
[null,null,31,450]
[null,null,1,5]
[null,null,42,587]
[null,null,1,7,null,"Legend"]
[null,null,39,489,null,"A","The dependent variable (the right column)"]
[null,null,51,671,null,"B","Data points falling here would suggest performing too few reviews"]
[null,null,40,336,null,"C","Data points falling here would suggest coding too few opportunities"]
[null,null,18,277,null,"D","The independendent variable (the lest column)"]
[null,null,24,310,null,"E","Regression \"line of best fit\""]
[null,null,30,400,null,"F","Linear equation that defines line"]
[null,null,14,164]
[null,null,4,39]
[null,null,17,179]
[null,null,9,130]
[null,null,28,339]
[null,null,12,176]
[null,null,1,15]
[null,null,28,445]
[null,null,10,111]
[null,null,9,161]
[null,null,37,644]
[null,null,39,598]
[null,null,7,117]
[null,null,29,190]
[null,null,77,1067]
[null,null,27,294]
[null,null,17,90]
[null,null,4,26]
[null,null,21,410]
[null,null,38,411]
[null,null,13,74]
[null,null,3,32]
[null,null,51,811]
[null,null,17,305]
[null,null,37,446]

{"sheet":"Control Chart Example","index":6,"n_rows":74,"n_cols":15,"rows_kept":74,"cut":false,"hidden":false,"merged":[[55,2,55,8],[4,0,6,1],[23,0,25,1],[26,0,26,1],[65,0,67,1],[62,0,64,1],[73,13,73,15],[71,13,71,15],[69,13,69,15],[68,14,68,15],[67,13,67,15],[70,14,70,15],[72,14,72,15]]}
[]
[]
[]
[]
[null,null,"Week #","No","Yes","Total Opport","Weekly Yield","Range","Mean Yield","UCL","LCL"]
[null,null,1,151,402,553,0.72694394213381552,null,{"$f":"$H$57","v":0.84153209264162909},{"$f":"$I$59","v":0.93140341105637026},{"$f":"$I$60","v":0.75166077422688793}]
[null,null,2,252,1045,1297,0.80570547417116423,7.8761532037348703E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,3,237,1135,1372,0.82725947521865895,2.155400104749472E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,4,197,1082,1279,0.84597341673182169,1.8713941513162746E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,5,245,1426,1671,0.85338120885697188,7.4077921251501921E-3,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,6,238,1319,1557,0.84714193962748874,6.2392692294831464E-3,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,7,217,1195,1412,0.84631728045325783,8.2465917423091284E-4,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,8,246,1147,1393,0.82340272792534097,2.2914552527916854E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,9,231,1406,1637,0.85888821014050087,3.5485482215159903E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,10,223,1174,1397,0.84037222619899787,1.8515983941503E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,11,198,1037,1235,0.83967611336032388,6.961128386739901E-4,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,12,202,1264,1466,0.86221009549795358,2.2533982137629693E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,13,201,1155,1356,0.85176991150442483,1.0440183993528751E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,14,231,1424,1655,0.86042296072507551,8.6530492206506882E-3,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,15,296,1570,1866,0.84137191854233651,1.9051042182739009E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,16,161,632,793,0.79697351828499374,4.4398400257342763E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,17,2,17,19,0.89473684210526316,9.7763323820269421E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,18,21,109,130,0.83846153846153848,5.6275303643724683E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,19,8,74,82,0.90243902439024393,6.3977485928705446E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,20,18,147,165,0.89090909090909087,1.1529933481153054E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,21,12,112,124,0.90322580645161288,1.2316715542522005E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,22,10,116,126,0.92063492063492058,1.7409114183307706E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,23,22,202,224,0.9017857142857143,1.8849206349206282E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,24,20,157,177,0.88700564971751417,1.4780064568200135E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,25,12,118,130,0.90769230769230769,2.0686657974793521E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,26,14,112,126,0.88888888888888884,1.8803418803418848E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,27,18,71,89,0.797752808988764,9.1136079900124844E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,28,22,183,205,0.89268292682926831,9.4930117840504313E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,29,18,120,138,0.86956521739130432,2.3117709437963985E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,30,32,156,188,0.82978723404255317,3.9777983348751156E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,31,27,162,189,0.8571428571428571,2.7355623100303927E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,32,28,123,151,0.81456953642384111,4.2573320719015983E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,33,20,142,162,0.87654320987654322,6.1973673452702105E-2,{"$f":"$H$57","v":0.84153209264162909},{"$f":"$I$59","v":0.93140341105637026},{"$f":"$I$60","v":0.75166077422688793}]
[null,null,34,18,130,148,0.8783783783783784,1.8351685018351827E-3,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,35,18,97,115,0.84347826086956523,3.4900117508813167E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,36,22,104,126,0.82539682539682535,1.8081435472739882E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,37,28,133,161,0.82608695652173914,6.9013112491378426E-4,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,38,23,132,155,0.85161290322580641,2.5525946704067271E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,39,22,190,212,0.89622641509433965,4.461351186853324E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,40,10,48,58,0.87,6.8640208197787933E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,41,7,54,61,0.85,5.7659694742792533E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,42,19,80,99,0.82,7.716509355853618E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,43,28,185,213,0.8,6.046379285815906E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,44,35,125,160,0.78125,8.7294600938967126E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,45,53,201,254,0.73,1.0088582677165392E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,46,28,105,133,0.78947368421052633,1.8648984666390644E-3,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,47,19,105,124,0.84677419354838712,5.7300509337860794E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,48,27,124,151,0.82119205298013243,2.5582140568254697E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[null,null,49,35,143,178,0.8033707865168539,1.7821266463278529E-2,0.84153209264162909,0.93140341105637026,0.75166077422688793]
[]
[null,null,"Control Chart Calculations"]
[null,null,"X Bar",null,null,null,null,0.84153209264162909]
[null,null,"R Bar",null,null,null,null,null,{"$f":"AVERAGE(H5:H48)","v":3.3786209930353826E-2}]
[null,null,"UCL",null,null,null,null,null,{"$f":"H57+(2.66*I58)","v":0.93140341105637026}]
[null,null,"LCL",null,null,null,null,null,{"$f":"H57-(2.66*I58)","v":0.75166077422688793}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Legend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Upper Control Limit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3 standard deviation above mean"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"B","Mean Line"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Average of Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"C","Lower Control Limit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3 standard deviation below mean"]

{"sheet":"Examples and Interpretation","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,2,4,2],[3,0,3,1],[1,0,2,1],[17,9,18,10],[21,11,22,12],[13,8,17,8],[10,0,10,1],[16,0,16,1],[17,0,17,1]]}

{"sheet":"Chart Maker","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[27,5,27,7],[17,0,17,1],[1,0,2,1],[0,2,4,2],[3,0,3,1],[10,0,10,1],[16,0,16,1]]}

{"sheet":"Make a Box Plot","index":9,"n_rows":1043,"n_cols":7,"rows_kept":1043,"cut":false,"hidden":false,"merged":[[2,6,2,12],[1,5,1,12],[6,6,6,12],[3,6,3,12],[4,6,4,12],[5,6,5,12],[17,0,17,1],[5,0,5,1],[10,0,10,1],[16,0,16,1],[3,0,4,1]]}
[]
[null,null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,null,1,"This Box Plot can be used to compare up to four groups.  Enter the sample data in the four columns under Groups 1-4 (these can be re-named to new categories if needed)"]
[null,null,null,null,null,2,"Click on the \"View Box Plot\" button"]
[null,null,null,null,null,3,"Click on the 'Chart Title,' 'Y Axis,' and 'X Axis' to edit the labels"]
[null,null,null,null,null,4,"Click on \"Import Practice Data\" to see a sample"]
[null,null,null,null,null,5,"Click on \"Clear Box Plot Data\" to erase data"]
[]
[]
[null,null,"Shift 1","Shift 2","Shift 3"]
[null,null,2.4409392206443847,5.213692993804302,1.7223172755459915]
[null,null,4.8496088061875486,6.5002361710944729,2.8208892690629628]
[null,null,6.0989122734118251,3.0863565463078806,2.2286466434723717]
[null,null,4.9746449583352081,4.6192448581791057,1.9468509538002703]
[null,null,8.269545658471646,1.579692899828647,2.7018112602581805]
[null,null,9.0576584204077513,5.5900752746307205,3.0573990540156482]
[null,null,8.8063792177526103,3.5582495990025409,2.3750366235793496]
[null,null,2.8103238934285613,0.13048331984474479,0.85626648419502671]
[null,null,5.711593786699094,2.462701366809068,2.3458966979973903]
[null,null,1.4228677796012446,4.6744840814270399,1.7309546086839889]
[null,null,8.2354100041192844,3.3802350956550846,2.1968675755182652]
[null,null,4.4059809246281301,0.18079592525047508,2.1036450866535095]
[null,null,9.2640739675408508,7.8562702785127198E-2,2.2365581725446186]
[null,null,0.21689757910096308,0.57804437550787602,1.5861257031412928]
[null,null,1.0782681780158132,1.7355110151123829,1.3335012565817417]
[null,null,5.8837170739602129,0.14109287548074062,1.1850959890098176]
[null,null,6.3178700080151184,4.0933760588930728E-3,3.6352749242771534]
[null,null,4.470384404897576,0.77022751276001311,3.5336492225144713]
[null,null,7.8205942798598915,1.7210597425199894E-2,1.7948390987425531]
[null,null,2.5426930685140192,4.4207216241137823,1.7341187645714482]
[null,null,5.8934869455644119,3.658991423798013,0.95480934199935397]
[null,null,2.3368067249369506,3.4845545781194196,3.1015978891022566]
[null,null,5.925211889466377,6.2158043351974221,0.23126220702480627]
[null,null,0.25042707710623446,0.13953867748655571,1.6293223142650659]
[null,null,7.1138276365932374,7.1047294654459373E-2,2.3200462812179854]
[null,null,5.1579693836702489,3.0771053812936646,1.4437050807333121]
[null,null,7.777760975709036E-2,5.3014515301327441,1.3699439279587826]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,2.4409392206443847,5.213692993804302,1.7223172755459915]
[null,null,4.8496088061875486,6.5002361710944729,2.8208892690629628]
[null,null,6.0989122734118251,3.0863565463078806,2.2286466434723717]
[null,null,4.9746449583352081,4.6192448581791057,1.9468509538002703]
[null,null,8.269545658471646,1.579692899828647,2.7018112602581805]
[null,null,9.0576584204077513,5.5900752746307205,3.0573990540156482]
[null,null,8.8063792177526103,3.5582495990025409,2.3750366235793496]
[null,null,2.8103238934285613,0.13048331984474479,0.85626648419502671]
[null,null,5.711593786699094,2.462701366809068,2.3458966979973903]
[null,null,1.4228677796012446,4.6744840814270399,1.7309546086839889]
[null,null,8.2354100041192844,3.3802350956550846,2.1968675755182652]
[null,null,4.4059809246281301,0.18079592525047508,2.1036450866535095]
[null,null,9.2640739675408508,7.8562702785127198E-2,2.2365581725446186]
[null,null,0.21689757910096308,0.57804437550787602,1.5861257031412928]
[null,null,1.0782681780158132,1.7355110151123829,1.3335012565817417]
[null,null,5.8837170739602129,0.14109287548074062,1.1850959890098176]
[null,null,6.3178700080151184,4.0933760588930728E-3,3.6352749242771534]
[null,null,4.470384404897576,0.77022751276001311,3.5336492225144713]
[null,null,7.8205942798598915,1.7210597425199894E-2,1.7948390987425531]
[null,null,2.5426930685140192,4.4207216241137823,1.7341187645714482]
[null,null,5.8934869455644119,3.658991423798013,0.95480934199935397]
[null,null,2.3368067249369506,3.4845545781194196,3.1015978891022566]
[null,null,5.925211889466377,6.2158043351974221,0.23126220702480627]
[null,null,0.25042707710623446,0.13953867748655571,1.6293223142650659]
[null,null,7.1138276365932374,7.1047294654459373E-2,2.3200462812179854]
[null,null,5.1579693836702489,3.0771053812936646,1.4437050807333121]
[null,null,7.777760975709036E-2,5.3014515301327441,1.3699439279587826]

{"sheet":"Box Plot","index":10,"n_rows":6,"n_cols":21,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistic",{"$f":"'Make a Box Plot'!C10","v":"Shift 1"},{"$f":"'Make a Box Plot'!D10","v":"Shift 2"},{"$f":"'Make a Box Plot'!E10","v":"Shift 3"},{"$f":"'Make a Box Plot'!F10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q1",{"$f":"IF('Make a Box Plot'!$C$11=\"\",\"\",QUARTILE('Make a Box Plot'!$C$11:$C$1010,1))","v":2.491816144579202},{"$f":"IF('Make a Box Plot'!$D$11=\"\",\"\",QUARTILE('Make a Box Plot'!$D$11:$D$1010,1))","v":0.16094440036560786},{"$f":"IF('Make a Box Plot'!$E$11=\"\",\"\",QUARTILE('Make a Box Plot'!$E$11:$E$1010,1))","v":1.5149153919373024},{"$f":"IF('Make a Box Plot'!$F$11=\"\",\"\",QUARTILE('Make a Box Plot'!$F$11:$F$1010,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF('Make a Box Plot'!$C$11=\"\",\"\",MIN('Make a Box Plot'!$C$11:$C$1010,1))","v":7.777760975709036E-2},{"$f":"IF('Make a Box Plot'!$D$11=\"\",\"\",MIN('Make a Box Plot'!$D$11:$D$1010,1))","v":4.0933760588930728E-3},{"$f":"IF('Make a Box Plot'!$E$11=\"\",\"\",MIN('Make a Box Plot'!$E$11:$E$1010,1))","v":0.23126220702480627},{"$f":"IF('Make a Box Plot'!$F$11=\"\",\"\",MIN('Make a Box Plot'!$F$11:$F$1010,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"median",{"$f":"IF('Make a Box Plot'!$C$11=\"\",\"\",MEDIAN('Make a Box Plot'!$C$11:$C$1010,1))","v":5.0663071710027285},{"$f":"IF('Make a Box Plot'!$D$11=\"\",\"\",MEDIAN('Make a Box Plot'!$D$11:$D$1010,1))","v":2.7699033740513661},{"$f":"IF('Make a Box Plot'!$E$11=\"\",\"\",MEDIAN('Make a Box Plot'!$E$11:$E$1010,1))","v":1.8708450262714118},{"$f":"IF('Make a Box Plot'!$F$11=\"\",\"\",MEDIAN('Make a Box Plot'!$F$11:$F$1010,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max",{"$f":"IF('Make a Box Plot'!$C$11=\"\",\"\",MAX('Make a Box Plot'!$C$11:$C$1010,1))","v":9.2640739675408508},{"$f":"IF('Make a Box Plot'!$D$11=\"\",\"\",MAX('Make a Box Plot'!$D$11:$D$1010,1))","v":6.5002361710944729},{"$f":"IF('Make a Box Plot'!$E$11=\"\",\"\",MAX('Make a Box Plot'!$E$11:$E$1010,1))","v":3.6352749242771534},{"$f":"IF('Make a Box Plot'!$F$11=\"\",\"\",MAX('Make a Box Plot'!$F$11:$F$1010,1))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q3",{"$f":"IF('Make a Box Plot'!$C$11=\"\",\"\",QUARTILE('Make a Box Plot'!$C$11:$C$1010,3))","v":6.7158488223041779},{"$f":"IF('Make a Box Plot'!$D$11=\"\",\"\",QUARTILE('Make a Box Plot'!$D$11:$D$1010,3))","v":4.519983241146444},{"$f":"IF('Make a Box Plot'!$E$11=\"\",\"\",QUARTILE('Make a Box Plot'!$E$11:$E$1010,3))","v":2.36046666078837},{"$f":"IF('Make a Box Plot'!$F$11=\"\",\"\",QUARTILE('Make a Box Plot'!$F$11:$F$1010,3))","v":""}]

{"sheet":"Make a Pareto Chart","index":11,"n_rows":144,"n_cols":6,"rows_kept":144,"cut":false,"hidden":false,"merged":[[3,0,4,1],[2,5,2,11],[1,4,1,11],[0,2,2,2],[17,0,17,1],[5,0,5,1],[10,0,10,1],[16,0,16,1],[6,5,6,11],[3,5,3,11],[4,5,4,11],[5,5,5,11]]}
[]
[null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,1,"List your data in two columns: the category (e.g. attribute name) and the values (# of defects)"]
[null,null,null,null,2,"Click on the \"Calculate and Make Pareto Chart\" button"]
[null,null,null,null,3,"Click on the 'Chart Title,' 'Y Axis,' and 'X Axis' to edit the labels"]
[null,null,null,null,4,"Click Calculate and Make Pareto Chart button to make chart"]
[null,null,null,null,5,"When ready click the pareto chart button to make chart"]
[]
[]
[null,null,"Category Label ","Value","% of Total","Cumulative %"]
[null,null,null,null,{"$f":"D11/(SUM($D$10:$D$75))","v":{"$error":"#DIV/0!"}},{"$f":"E11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"E12+F11","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$f":"E13+F12","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"D43/(SUM($D$10:$D$75))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"D75/(SUM($D$10:$D$75))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,{"$f":"D76/(SUM($D$10:$D$75))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"rd",0]
[null,null,"rf",0]
[null,null,"gr",0]
[null,null,"hr",0]
[null,null,"hy",0]
[null,null,"hu",0]
[null,null,"hi",0]
[null,null,"hp",0]
[null,null,"vt",0]
[null,null,"vy",0]
[null,null,"ve",0]
[null,null,"vb",0]
[null,null,"vn",0]
[null,null,"vm",0]
[null,null,"ja",0]
[null,null,"js",0]
[null,null,"jd",0]
[null,null,"jf",0]
[null,null,"jg",0]
[null,null,"jh",0]
[null,null,"kl",0]
[null,null,"ks",0]
[null,null,"qp",0]
[null,null,"qm",0]
[null,null,"pm",0]
[null,null,"om",0]
[null,null,"im",0]
[null,null,"un",0]
[null,null,"yb",0]
[null,null,"tb",0]
[null,null,"rb",0]
[null,null,"ec",0]
[null,null,"wx",0]
[null,null,"qz",0]
[null,null,"m",0]
[null,null,"n",0]
[null,null,"b",0]
[null,null,"v",0]
[null,null,"c",0]
[null,null,"x",1]
[null,null,"z",1]
[null,null,"l",1]
[null,null,"k",1]
[null,null,"j",1]
[null,null,"h",1]
[null,null,"g",1]
[null,null,"f",1.9999999999998863]
[null,null,"d",2.9999999999999929]
[null,null,"s",3]
[null,null,"a",5]
[null,null,"p",5]
[null,null,"o",7]
[null,null,"I",7.0000000000000142]
[null,null,"u",10]
[null,null,"y",10]
[null,null,"t",12.000000000000114]
[null,null,"rs ",13]
[null,null,"e",14.000000000000114]
[null,null,"ws",18]
[null,null,"asd",20]
[null,null,"ws",22]
[null,null,"qwe",42]
[null,null,"a",54]
[null,null,"rsx",133]

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

{"sheet":"Make a Histogram","index":13,"n_rows":147,"n_cols":6,"rows_kept":147,"cut":false,"hidden":false,"merged":[[0,2,2,2],[0,4,0,13],[1,5,1,13],[2,5,2,13],[10,0,10,1],[16,0,16,1],[3,0,3,1],[3,5,3,13],[4,5,4,13],[5,5,5,13]]}
[null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,1,"Paste the values for output variable in the left column"]
[null,null,null,null,2,"Paste the values for the frequency variable in the right column"]
[null,null,null,null,3,"Order does not matter"]
[null,null,null,null,4,"The chart will automatically plot the data"]
[null,null,null,null,5,"When ready click Histogram button to see graph"]
[]
[]
[]
[]
[null,null,"Output","Frequency"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,4,375]
[null,null,5,400]
[null,null,6,425]
[null,null,7,450]
[null,null,8,475]
[null,null,9,500]
[null,null,10,525]
[null,null,11,550]
[null,null,12,575]
[null,null,13,600]
[null,null,14,625]
[null,null,15,650]
[null,null,16,675]
[null,null,17,700]
[null,null,18,725]
[null,null,19,750]
[null,null,20,775]
[null,null,21,800]
[null,null,22,850]
[null,null,23,900]
[null,null,24,950]
[null,null,25,1000]
[null,null,26,950]
[null,null,27,900]
[null,null,28,850]
[null,null,29,800]
[null,null,30,775]
[null,null,31,750]
[null,null,32,725]
[null,null,33,700]
[null,null,34,675]
[null,null,35,650]
[null,null,36,625]
[null,null,37,600]
[null,null,38,575]
[null,null,39,550]
[null,null,40,525]
[null,null,41,500]
[null,null,42,475]
[null,null,43,450]
[null,null,44,425]
[null,null,45,400]
[null,null,46,375]
[null,null,47,350]
[null,null,48,325]
[null,null,49,300]
[null,null,50,300]

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

{"sheet":"Make a Control Chart","index":15,"n_rows":116,"n_cols":10,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,6,1,14],[0,9,0,16],[16,0,16,1],[15,0,15,1],[4,0,4,1],[9,0,9,1],[0,2,7,4],[2,7,2,14],[3,7,3,14],[4,7,4,14],[5,7,5,14],[6,7,6,14]]}
[]
[null,null,null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,null,null,1,"Enter data to be charted in Data Column"]
[null,null,null,null,null,null,2,"The Mean is automatically calculated"]
[null,null,null,null,null,null,3,"Upper and Lower Control limits are automatically calculated"]
[null,null,null,null,null,null,4,"When ready click the control chart button to make chart"]
[null,null,null,null,null,null,5,"The program will graph: Data, Mean, UCL, LCL"]
[]
[]
[null,null,null,null,"Sample","Data","Range","Mean","UCL","LCL"]
[null,null,{"$f":"ISBLANK(F11)","v":true},null,1,null,0,{"$f":"(AVERAGE($F$11:$F$62))","v":{"$error":"#DIV/0!"}},{"$f":"($H11+(($G$63))*2.66)","v":{"$error":"#DIV/0!"}},{"$f":"($H11-(($G$63))*2.66)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"ISBLANK(F12)","v":true},null,2,null,{"$f":"IF(OR(F11=\"\",F12=\"\"),\"\",(ABS(F12-F11)))","v":""},{"$f":"(AVERAGE($F$11:$F$62))","v":{"$error":"#DIV/0!"}},{"$f":"($H12+(($G$63))*2.66)","v":{"$error":"#DIV/0!"}},{"$f":"($H12-(($G$63))*2.66)","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"ISBLANK(F13)","v":true},null,3,null,{"$f":"IF(OR(F12=\"\",F13=\"\"),\"\",(ABS(F13-F12)))","v":""},{"$f":"(AVERAGE($F$11:$F$62))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,4,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,5,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,6,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,7,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,8,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,9,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,10,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,11,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,12,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,13,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,14,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,15,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,16,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,17,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,18,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,19,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,20,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,21,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,22,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,23,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,24,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,25,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,26,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,27,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,28,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,29,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,30,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,31,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,32,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,33,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,34,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,35,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,36,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,37,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,38,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,39,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,40,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,41,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,42,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,43,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,44,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,45,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,46,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,47,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,48,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,49,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,50,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,51,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,true,null,52,null,"",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,{"$f":"AVERAGE(G11:G62)","v":0}]
[]
[]
[]
[null,null,null,null,null,86.498400000000004]
[null,null,null,null,null,86.516499999999994]
[null,null,null,null,null,81.543199999999999]
[null,null,null,null,null,83.857200000000006]
[null,null,null,null,null,86.921499999999995]
[null,null,null,null,null,84.867199999999997]
[null,null,null,null,null,81.841300000000004]
[null,null,null,null,null,86.276499999999999]
[null,null,null,null,null,88.250299999999996]
[null,null,null,null,null,82.492400000000004]
[null,null,null,null,null,88.727000000000004]
[null,null,null,null,null,85.307699999999997]
[null,null,null,null,null,84.825199999999995]
[null,null,null,null,null,83.114699999999999]
[null,null,null,null,null,83.378200000000007]
[null,null,null,null,null,83.147300000000001]
[null,null,null,null,null,82.955200000000005]
[null,null,null,null,null,84.591499999999996]
[null,null,null,null,null,88.528499999999994]
[null,null,null,null,null,85.945300000000003]
[null,null,null,null,null,88.040599999999998]
[null,null,null,null,null,83.166300000000007]
[null,null,null,null,null,82.736400000000003]
[null,null,null,null,null,89.566500000000005]
[null,null,null,null,null,86.404399999999995]
[null,null,null,null,null,90.156800000000004]
[null,null,null,null,null,85.242099999999994]
[null,null,null,null,null,84.477699999999999]
[null,null,null,null,null,82.816800000000001]
[null,null,null,null,null,84.000900000000001]
[null,null,null,null,null,86.236199999999997]
[null,null,null,null,null,90.129800000000003]
[null,null,null,null,null,87.280100000000004]
[null,null,null,null,null,88.953100000000006]
[null,null,null,null,null,82.543999999999997]
[null,null,null,null,null,86.558899999999994]
[null,null,null,null,null,81.453900000000004]
[null,null,null,null,null,84.996099999999998]
[null,null,null,null,null,81.431200000000004]
[null,null,null,null,null,83.703599999999994]
[null,null,null,null,null,84.773700000000005]
[null,null,null,null,null,80.629599999999996]
[null,null,null,null,null,88.899000000000001]
[null,null,null,null,null,79.652299999999997]
[null,null,null,null,null,83.748500000000007]
[null,null,null,null,null,88.554900000000004]
[null,null,null,null,null,86.0518]
[null,null,null,null,null,81.885300000000001]
[null,null,null,null,null,87]
[null,null,null,null,null,85]

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

{"sheet":"Make a ScatterPlot","index":17,"n_rows":145,"n_cols":6,"rows_kept":145,"cut":false,"hidden":false,"merged":[[0,2,2,2],[3,5,3,13],[16,0,16,1],[0,4,0,13],[1,5,1,13],[2,5,2,13],[3,0,3,1],[10,0,10,1],[4,5,4,13],[5,5,5,13],[6,5,6,13]]}
[null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,1,"Paste the values for Variable 1 in the left column"]
[null,null,null,null,2,"Paste the values for the Variable 2 in the right column"]
[null,null,null,null,3,"Order does not matter"]
[null,null,null,null,4,"The chart will automatically plot the data"]
[null,null,null,null,5,"The chart will automatically calculate and display the line of best fit and R-squared value"]
[null,null,null,null,6,"When ready click Scatterplot button to see graph"]
[]
[]
[]
[null,null,"Variable 1","Variable 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,16,111]
[null,null,45,612]
[null,null,20,210]
[null,null,4,53]
[null,null,29,351]
[null,null,17,214]
[null,null,8,89]
[null,null,28,323]
[null,null,19,247]
[null,null,32,410]
[null,null,31,450]
[null,null,1,5]
[null,null,42,587]
[null,null,1,7]
[null,null,39,489]
[null,null,51,671]
[null,null,40,336]
[null,null,18,277]
[null,null,24,310]
[null,null,30,400]
[null,null,14,164]
[null,null,4,39]
[null,null,17,179]
[null,null,9,130]
[null,null,28,339]
[null,null,12,176]
[null,null,1,15]
[null,null,28,445]
[null,null,10,111]
[null,null,9,161]
[null,null,37,644]
[null,null,39,598]
[null,null,7,117]
[null,null,29,190]
[null,null,77,1067]
[null,null,27,294]
[null,null,17,90]
[null,null,4,26]
[null,null,21,410]
[null,null,38,411]
[null,null,13,74]
[null,null,3,32]
[null,null,51,811]
[null,null,17,305]
[null,null,37,446]

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

{"sheet":"Sigma Calculator","index":19,"n_rows":147,"n_cols":13,"rows_kept":147,"cut":false,"hidden":false,"merged":[[16,0,16,1],[3,0,3,1],[3,5,3,13],[4,5,4,13],[5,5,5,13],[10,0,10,1],[0,2,2,2],[0,4,0,13],[1,5,1,13],[2,5,2,13],[7,4,7,13]]}
[null,null,null,null,"INSTRUCTIONS:"]
[null,null,null,null,1,"Enter total units or forms in sample"]
[null,null,null,null,2,"Enter opportunities per unit or form"]
[null,null,null,null,3,"Enter Total defects recorded for the sample"]
[null,null,null,null,4,"The tool will automatically calculate the DPO Value, Total Opportunities, and Sigma"]
[]
[]
[null,null,null,null,"Example of opportunities, defects, and sigma level"]
[]
[null,null,null,null,"Total number of opportunities for defects:",null,null,null,null,null,10000,null,"Total opportunities"]
[]
[null,null,null,null,"Total number of defects in the sample:",null,null,null,null,null,3900,null,"Defects"]
[]
[]
[null,null,null,null,"Percent correct for opportunities sampled",null,null,null,null,null,{"$f":"1 - (K12/K10)","v":0.61},null,"Yield"]
[]
[null,null,null,null,"Results in a Defect Per Opportunity (DPO) of:",null,null,null,null,null,{"$f":"K12/K10","v":0.39},null,"DPO"]
[]
[null,null,null,null,"There is a function in Excel used to calculate the sigma level:",null,null,null,null,null,{"$f":"NORMSINV(1-K17) +1.5","v":1.7793190344474541},null,"Sigma"]
[]
[]
[null,null,null,null,null,"NOTE:","Change the numbers in BLUE to calculate different levels."]
[null,null,null,null,null,null,"The numbers in BLACK will automatically recalculate."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,1,300]
[null,null,2,325]
[null,null,3,350]
[null,null,4,375]
[null,null,5,400]
[null,null,6,425]
[null,null,7,450]
[null,null,8,475]
[null,null,9,500]
[null,null,10,525]
[null,null,11,550]
[null,null,12,575]
[null,null,13,600]
[null,null,14,625]
[null,null,15,650]
[null,null,16,675]
[null,null,17,700]
[null,null,18,725]
[null,null,19,750]
[null,null,20,775]
[null,null,21,800]
[null,null,22,850]
[null,null,23,900]
[null,null,24,950]
[null,null,25,1000]
[null,null,26,950]
[null,null,27,900]
[null,null,28,850]
[null,null,29,800]
[null,null,30,775]
[null,null,31,750]
[null,null,32,725]
[null,null,33,700]
[null,null,34,675]
[null,null,35,650]
[null,null,36,625]
[null,null,37,600]
[null,null,38,575]
[null,null,39,550]
[null,null,40,525]
[null,null,41,500]
[null,null,42,475]
[null,null,43,450]
[null,null,44,425]
[null,null,45,400]
[null,null,46,375]
[null,null,47,350]
[null,null,48,325]
[null,null,49,300]
[null,null,50,300]