{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Manufacturing Imperfections","Control Chart"],"not_rendered":{"charts":2},"unopened":[{"sheet":"Control Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Manufacturing Imperfections","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"merged":[[1,0,1,7],[3,7,8,12],[11,2,11,6],[11,7,12,7],[11,8,12,8],[11,9,12,9],[11,10,12,10],[11,11,12,11],[11,12,12,12]]}
[]
["Control Chart for Printing Books"]
["Plant Name:","#1",{"$nulls":5},"Notes:"]
["Report Date:","2005-02-02"]
["QC Tech:","Kevin McDowell"]
["Dept:","Quality Assurance"]
["Equipment ID:","Press 4"]
["Start date:","2005-01-01"]
["End date:","2005-01-31"]
["Desired level",{"v":1,"d":"100%"}]
[]
[null,null,"Number of Imperfections",{"$nulls":4},"Mean (Daily Average)","Sample Mean (Average of All Means)","Standard Deviation","Sample Standard Deviation","Lower Control Limit","Upper Control Limit"]
[null,"Date","Sample 1","Sample 2","Sample 3","Sample 4","Sample 5"]
[null,"2005-01-01",0,3,2,5,4,{"$f":"AVERAGE(C14:G14)","v":2.8},{"$f":"AVERAGE($H$14:$H$36)","v":{"v":2.5043478260869563,"d":"2.50"}},{"$f":"STDEV(C14:G14)","v":{"v":1.9235384061671343,"d":"1.92"}},{"$f":"AVERAGE($J$14:$J$36)","v":{"v":1.5776999234197282,"d":"1.58"}},{"$f":"I14-($B$10*K14)","v":{"v":0.9266479026672281,"d":"0.93"}},{"$f":"I14+($B$10*K14)","v":{"v":4.0820477495066845,"d":"4.08"}}]
[null,"2005-01-02",4,3,1,3,1,{"$f":"AVERAGE(C15:G15)","v":2.4},{"v":2.5043478260869563,"d":"2.50"},{"v":1.3416407864998738,"d":"1.34"},{"v":1.5776999234197282,"d":"1.58"},{"$f":"I15-($B$10*K15)","v":{"v":0.9266479026672281,"d":"0.93"}},{"$f":"I15+($B$10*K15)","v":{"v":4.0820477495066845,"d":"4.08"}}]
[null,"2005-01-03",3,4,2,3,0,2.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.51657508881031,"d":"1.52"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-04",5,5,4,2,5,4.2,{"v":2.5043478260869563,"d":"2.50"},{"v":1.3038404810405295,"d":"1.30"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-05",4,0,2,1,2,1.8,{"v":2.5043478260869563,"d":"2.50"},{"v":1.4832396974191326,"d":"1.48"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-06",4,3,4,0,3,2.8,{"v":2.5043478260869563,"d":"2.50"},{"v":1.6431676725154982,"d":"1.64"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-07",3,5,4,4,3,3.8,{"v":2.5043478260869563,"d":"2.50"},{"v":0.8366600265340751,"d":"0.84"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-10",3,1,3,5,5,3.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.6733200530681513,"d":"1.67"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-11",4,3,1,4,4,3.2,{"v":2.5043478260869563,"d":"2.50"},{"v":1.3038404810405295,"d":"1.30"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-12",0,4,4,3,5,3.2,{"v":2.5043478260869563,"d":"2.50"},{"v":1.9235384061671343,"d":"1.92"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-13",5,0,0,4,2,2.2,{"v":2.5043478260869563,"d":"2.50"},{"v":2.280350850198276,"d":"2.28"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-14",2,3,1,2,0,1.6,{"v":2.5043478260869563,"d":"2.50"},{"v":1.1401754250991378,"d":"1.14"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-17",3,0,1,2,1,1.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.1401754250991378,"d":"1.14"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-18",3,1,3,0,0,1.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.51657508881031,"d":"1.52"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-19",1,5,4,1,1,2.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.9493588689617927,"d":"1.95"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-20",4,0,3,2,0,1.8,{"v":2.5043478260869563,"d":"2.50"},{"v":1.7888543819998317,"d":"1.79"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-21",3,4,1,2,3,2.6,{"v":2.5043478260869563,"d":"2.50"},{"v":1.1401754250991383,"d":"1.14"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-24",1,4,0,5,0,{"v":2,"d":"2.0"},{"v":2.5043478260869563,"d":"2.50"},{"v":2.345207879911715,"d":"2.35"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-25",4,4,0,2,2,2.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.6733200530681511,"d":"1.67"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-26",0,3,4,4,1,2.4,{"v":2.5043478260869563,"d":"2.50"},{"v":1.816590212458495,"d":"1.82"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-27",4,2,0,3,2,2.2,{"v":2.5043478260869563,"d":"2.50"},{"v":1.4832396974191326,"d":"1.48"},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-28",5,3,0,4,2,{"$f":"AVERAGE(C35:G35)","v":2.8},{"v":2.5043478260869563,"d":"2.50"},{"$f":"STDEV(C35:G35)","v":{"v":1.9235384061671343,"d":"1.92"}},{"v":1.5776999234197282,"d":"1.58"},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]
[null,"2005-01-31",2,3,1,2,4,{"$f":"AVERAGE(C36:G36)","v":2.4},{"$f":"AVERAGE($H$14:$H$36)","v":{"v":2.5043478260869563,"d":"2.50"}},{"$f":"STDEV(C36:G36)","v":{"v":1.1401754250991378,"d":"1.14"}},{"$f":"AVERAGE($J$14:$J$36)","v":{"v":1.5776999234197282,"d":"1.58"}},{"v":0.9266479026672281,"d":"0.93"},{"v":4.0820477495066845,"d":"4.08"}]