{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Machinists","Graphs"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Data","index":0,"n_rows":414,"n_cols":15,"rows_kept":414,"cut":false,"hidden":false,"merged":[]}
[null,"Part number","XTA","Machinist ID","Machinist Name","Forcast","Actual","Delta","ACC %"]
[null,"Part 1",8007,1,{"$f":"IF(D2=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D2,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D2,Mach_ID,0)))","v":"Brian Walmsley"},6,5,{"$f":"F2-G2","v":1},{"$f":"1-F2/G2","v":-0.19999999999999996},null,{"$f":"I2-$O$5","v":-0.29195767195767197},{"$f":"K2^2","v":8.5239282214943604E-2},null,"UCL",0.1]
[null,"Part 2",8007,55,"Michael Willdig",4,6,{"$f":"F3-G3","v":-2},{"$f":"1-F3/G3","v":0.33333333333333337},null,{"$f":"I3-$O$5","v":0.24137566137566138},{"$f":"K3^2","v":5.8262209904537947E-2},null,"LCL",-0.1]
[null,"Part 3",8007,1,"Brian Walmsley",5,4,1,-0.25,null,{"$f":"I4-$O$5","v":-0.34195767195767202},0.11693504941071083,null,"Wrong STDEV",{"$f":"_xlfn.STDEV.P(I2:I16)","v":0.19938152180592694}]
[null,"Part 4",8007,216,"Anthony Cooper",6,7,-1,0.1428571428571429,null,{"$f":"I5-$O$5","v":5.0899470899470917E-2},2.5907561378460866E-3,null,"Xbar",{"$f":"AVERAGE(I:I)","v":9.1957671957671988E-2}]
[null,"Part 5",7511,1,"Brian Walmsley",2,3,-1,0.33333333333333337,null,{"$f":"I6-$O$5","v":0.24137566137566138},5.8262209904537947E-2]
[null,"Part 6",7511,15,"David Devaney",8,8,0,0,null,{"$f":"I7-$O$5","v":-9.1957671957671988E-2},8.4562134318748126E-3]
[null,"Part 7",7511,1,"Brian Walmsley",4,4.5,-0.5,0.11111111111111116,null,{"$f":"I8-$O$5","v":1.9153439153439172E-2},3.668542314044967E-4]
[null,"Part 8",7511,1,"Brian Walmsley",6,8,-2,0.25,null,{"$f":"I9-$O$5","v":0.15804232804232801},2.497737745303882E-2]
[null,"Part 9",7511,1,"Brian Walmsley",4,3.5,0.5,-0.14285714285714279,null,{"$f":"I10-$O$5","v":-0.23481481481481478},5.5137997256515761E-2]
[null,"Part 10",8160,15,"David Devaney",4,3.5,{"$f":"F11-G11","v":0.5},-0.14285714285714279,null,{"$f":"I11-$O$5","v":-0.23481481481481478},5.5137997256515761E-2]
[null,"Part 11",8160,216,"Anthony Cooper",8,8,0,0,null,{"$f":"I12-$O$5","v":-9.1957671957671988E-2},8.4562134318748126E-3]
[null,"Part 12",8160,1,"Brian Walmsley",10,12,-2,0.16666666666666663,null,{"$f":"I13-$O$5","v":7.4708994708994642E-2},5.5814338904285896E-3]
[null,"Part 13",8160,15,"David Devaney",4,4.5,-0.5,0.11111111111111116,null,{"$f":"I14-$O$5","v":1.9153439153439172E-2},3.668542314044967E-4]
[null,"Part 14",8160,15,"David Devaney",1,1.5,-0.5,0.33333333333333337,null,{"$f":"I15-$O$5","v":0.24137566137566138},5.8262209904537947E-2]
[null,"Part 15",8160,216,"Anthony Cooper",0.5,0.75,-0.25,0.33333333333333337,null,{"$f":"I16-$O$5","v":0.24137566137566138},5.8262209904537947E-2]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L16)","v":0.5962948685647097}]
[null,null,null,null,"",null,null,null,null,null,"STDEV",{"$f":"L17/COUNT(I2:I16)","v":3.9752991237647313E-2}]
[null,null,null,null,"",null,null,null,null,null,"CPL",{"$f":"(O5-O3)/(3*L18)","v":1.6095868175062185}]
[null,null,null,null,"",null,null,null,null,null,"CPU",{"$f":"(O2-O5)/(3*L18)","v":6.7435831383942782E-2}]
[null,null,null,null,"",null,null,null,null,null,"CPK",{"$f":"(MIN(L19:L20))/(3*L18)","v":0.56545708288804997}]
[null,null,null,null,"",null,null,null,null,null,"  ",{"$f":"(O2-O3)/(6*L18)","v":0.83851132444508059}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D66=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D66,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D66,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D130=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D130,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D130,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D194=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D194,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D194,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D258=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D258,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D258,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D322=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D322,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D322,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D386=\"\",\"\",INDEX(OFFSET(Mach_ID,0,1),MATCH(D386,Mach_ID,0))&\" \"&INDEX(OFFSET(Mach_ID,0,2),MATCH(D386,Mach_ID,0)))","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]

{"sheet":"Machinists","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"ID","First Name","Last Name"]
[null,1,"Brian","Walmsley"]
[null,15,"David","Devaney"]
[null,28,"Christopher","Parsons"]
[null,55,"Michael","Willdig"]
[null,95,"Tony","Groves"]
[null,208,"Ian ","Evans"]
[null,216,"Anthony","Cooper"]
[null,218,"Lewis ","Garnett"]
[null,219,"William","Prince"]
[null,221,"Stephen","Williams"]
[null,486,"Robert","Walker"]
[null,613,"David","Brain"]
[null,614,"James","Badland"]
[null,"n/a","Jamie","Elliot"]

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