{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Manufacturing imperfections","Run chart with sample mean"],"not_rendered":{"charts":2,"defined_names":4},"unopened":[{"sheet":"Run chart with sample mean","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Manufacturing imperfections","index":0,"n_rows":30,"n_cols":10,"rows_kept":30,"merged":[[2,2,8,6],[2,7,2,8],[3,7,3,8],[4,7,4,8],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,7,8,8],[10,3,10,7]]}
[]
[]
[null,null,"Control chart for printing books",{"$nulls":4},"Plant name:",null,"Nod Publishers"]
[{"$nulls":7},"Report date:",null,{"$f":"TODAY()","v":"2023-02-23"}]
[{"$nulls":7},"QC Tech:",null,"Nicole Wagner"]
[{"$nulls":7},"Dept:",null,"Quality assurance"]
[{"$nulls":7},"Equipment ID:",null,78910]
[{"$nulls":7},"Start date:",null,{"$f":"TODAY()-30","v":"2023-01-24"}]
[{"$nulls":7},"End date:",null,{"$f":"TODAY()","v":"2023-02-23"}]
[]
[{"$nulls":3},"# of imperfections"]
[null,null,"Date","Sample 1","Sample 2","Sample 3","Sample 4","Sample 5","Mean","Sample mean (average of all means)"]
[null,null,{"$f":"J8","v":"2023-01-24"},{"v":0,"d":"0 "},{"v":3,"d":"3 "},{"v":2,"d":"2 "},{"v":5,"d":"5 "},{"v":4,"d":"4 "},{"$f":"AVERAGE(D13:H13)","v":2.8},{"$f":"AVERAGE($I$13:$I$30)","v":{"v":2.4555555555555553,"d":"2.5"}}]
[null,null,{"$f":"C13+1","v":"2023-01-25"},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"$f":"AVERAGE(D14:H14)","v":{"v":2,"d":"2.0"}},{"v":2.4555555555555553,"d":"2.5"}]
[null,null,{"$f":"C14+1","v":"2023-01-26"},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":0,"d":"0 "},2.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-01-27",{"v":5,"d":"5 "},{"v":5,"d":"5 "},{"v":4,"d":"4 "},{"v":2,"d":"2 "},{"v":5,"d":"5 "},4.2,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-01-28",{"v":2,"d":"2 "},{"v":0,"d":"0 "},{"v":2,"d":"2 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},1.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-01-29",{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":0,"d":"0 "},{"v":3,"d":"3 "},2.8,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-01-30",{"v":3,"d":"3 "},{"v":5,"d":"5 "},{"v":4,"d":"4 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},3.8,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,{"$f":"C19+1","v":"2023-01-31"},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":3,"d":"3 "},{"v":5,"d":"5 "},{"v":5,"d":"5 "},3.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-01",{"v":1,"d":"1 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":4,"d":"4 "},{"v":4,"d":"4 "},2.6,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-02",{"v":0,"d":"0 "},{"v":4,"d":"4 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":5,"d":"5 "},3.2,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-03",{"v":5,"d":"5 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":4,"d":"4 "},{"v":2,"d":"2 "},2.2,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-04",{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":0,"d":"0 "},1.6,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-05",{"v":3,"d":"3 "},{"v":0,"d":"0 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":1,"d":"1 "},1.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-06",{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":3,"d":"3 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},1.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-07",{"v":1,"d":"1 "},{"v":5,"d":"5 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":1,"d":"1 "},2.4,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,{"$f":"C27+2","v":"2023-02-09"},{"v":3,"d":"3 "},{"v":0,"d":"0 "},{"v":3,"d":"3 "},{"v":2,"d":"2 "},{"v":0,"d":"0 "},1.6,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,{"$f":"C28+2","v":"2023-02-11"},{"v":3,"d":"3 "},{"v":4,"d":"4 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},2.6,{"v":2.4555555555555553,"d":"2.5"}]
[null,null,"2023-02-13",{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":4,"d":"4 "},{"$f":"AVERAGE(D30:H30)","v":2.4},{"v":2.4555555555555553,"d":"2.5"}]