{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["SETUP","A) Cover Page","A) Cover Page 2","B) FUNCTIONS","1) MSA Type 1","2) MSA Type 2 (ANOVA)","3) MSA Attribute","4) MSA Supplier Format","5) Capability Study","16) MSA Average Range"],"not_rendered":{"charts":7,"images":13,"macros":1,"external_links":0,"defined_names":20,"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":"SETUP","index":0,"n_rows":9,"n_cols":18,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[]
[]
[null,"Button text","Unlock Function",null,"Date of function in use",null,"By User",null,"Current Status"]
[]
[null,{"$f":"IF(rng_status_edit=\"Locked\",\"Edit Unlocked\",\" Edit Locked\")","v":" Edit Locked"},"Change logo"]
[]
[]
[null,null,"Password",null,"Windpower"]

{"sheet":"A) Cover Page","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"cut":false,"hidden":false,"merged":[[32,2,34,7],[9,1,9,6],[36,14,36,19],[38,14,38,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Advanced Product Quality Planning Analysis Tool for the Wind Industry"]
[null,null,{"$f":"'A) Cover Page 2'!C26","v":"Version 1.3 - March 2024"}]
[]
[null,null,"For more information, please go to: APQP4Wind.org"]

{"sheet":"A) Cover Page 2","index":2,"n_rows":42,"n_cols":3,"rows_kept":42,"cut":false,"hidden":false,"merged":[[26,2,26,3],[27,2,27,3],[1,2,1,3],[10,2,10,3],[13,2,13,3],[16,2,16,3],[20,2,20,3],[23,2,23,3]]}
[]
[null,null,"APQP4Wind"]
[null,null,"Lysbrohøjen 24"]
[null,null,"8600 Silkeborg"]
[null,null,"Denmark"]
[]
[null,null,"Mail: contact@apqp4wind.org"]
[null,null,"Website: www.apqp4wind.org"]
[null,null,"LinkedIn: APQP4Wind"]
[]
[null,null,"Text and data:"]
[null,null,"Manual and Toolbox developed by the APQP4Wind organization"]
[]
[null,null,"Layout and print:"]
[null,null,"Digitalprint - PrimaPrint"]
[]
[null,null,"Photo credit, front page:"]
[null,null,"Offshore Windpark Burbo Bank Extension"]
[null,null,"Copyright: © Ørsted A/S"]
[]
[null,null,"Copyright:"]
[null,null,"© APQP4Wind, all rights reserved"]
[]
[null,null,"Version:"]
[null,null,"Advanced Product Quality Planning Manual for the Wind Industry"]
[null,null,"Version 1.3 - March 2024"]
[]
[null,null,"Contributors:"]
[null,null,"Bureau Veritas Certification                        "]
[null,null,"DNV"]
[null,null,"GE Vernova"]
[null,null,"Goldwind"]
[null,null,"GRI Renewable Industries"]
[null,null,"KK Wind Solutions                                          "]
[null,null,"LM Wind Power                                              "]
[null,null,"Siemens Gamesa Renewable Energy      "]
[null,null,"TÜV Rheinland Greater China"]
[null,null,"Vattenfall"]
[null,null,"Vejby"]
[null,null,"Vestas Wind Systems                                    "]
[null,null,"ZF Wind Power"]
[null,null,"Ørsted"]

{"sheet":"B) FUNCTIONS","index":3,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1]
[]
[]
[null,null,"Edit height and wide of rows and columns"]
[]
[null,null,"Current status",null,{"$f":"IF(rng_status_edit=\"Unlocked\",\"Unlocked\",\"Locked\")","v":"Locked"}]

{"sheet":"1) MSA Type 1","index":4,"n_rows":126,"n_cols":22,"rows_kept":126,"cut":false,"hidden":false,"merged":[[44,16,44,17],[59,20,59,21],[54,20,54,21],[48,16,48,17],[46,16,46,17],[50,16,50,17],[52,16,52,17],[54,16,54,17],[44,20,44,21],[46,20,46,21],[48,20,48,21],[50,20,50,21],[62,20,62,21],[56,20,56,21],[60,20,60,21],[82,14,82,18],[82,19,82,21],[58,16,58,17],[58,20,58,21],[60,16,60,17],[85,14,85,16],[85,17,85,18],[85,20,85,21],[86,14,86,16],[86,17,86,18],[86,19,86,21],[83,17,83,18],[83,20,83,21],[84,14,84,16],[84,17,84,18],[84,20,84,21],[83,14,83,16],[87,14,87,16],[87,17,87,18],[87,19,87,21],[88,14,88,16],[88,17,88,18],[88,19,88,21],[89,14,89,21],[90,14,90,21],[91,14,91,16],[91,18,91,21],[92,14,92,16],[92,18,93,21],[98,16,98,17],[98,20,98,21],[99,16,99,17],[99,20,99,21],[95,14,95,21],[96,16,96,17],[96,20,96,21],[97,16,97,17],[97,20,97,21]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSA Variable Type 1\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,null,"Gauge Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Value",null,null,null,null,"Gauge Number"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specification Number",null,null,null,null,"Gauge Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Name",null,null,null,null,"Date Performed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resolution",null,null,null,null,"Approved Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specifications",null,null,null,null,"Approved By ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - LSL",null,null,null,null,"Approved Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - USL",null,null,null,null,"Approved Function"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(Q59>Q61,Q61<>\"\"),\"LSL is > USL\",\"\")","v":""},"Approved Company"]
[]
[null,null,null,null,"STDV",{"$f":"R87","v":""},null,null,null,null,null,null,null,null,"No.","Data","No.","Data","No.","Data","No.","Data"]
[null,"msa","No","data","avarage","UCL","LCL","Column1","No.","range","range -","UCL2","LCL3",null,1,null,16,null,31,null,46]
[null,"msa",1,{"$f":"IF('1) MSA Type 1'!P66<>\"\",'1) MSA Type 1'!P66,\"\")","v":""},{"$f":"IF(D67<>\"\",AVERAGE(D67:D126),\"\")","v":""},{"$f":"+E67+(3*$F$65)","v":{"$error":"#VALUE!"}},{"$f":"+E67-(3*$F$65)","v":{"$error":"#VALUE!"}},null,{"$f":"C67","v":1},null,{"$f":"AVERAGE(J68:J126)","v":0},{"$f":"+K67+(3*_xlfn.STDEV.P(J68:J126))","v":0},{"$f":"IF(K67-(3*_xlfn.STDEV.P(J68:J126))<0,0,(K67-(3*_xlfn.STDEV.P(J68:J126))))","v":0},null,2,null,17,null,32,null,47]
[null,"msa",{"$f":"C67+1","v":2},{"$f":"IF('1) MSA Type 1'!P67<>\"\",'1) MSA Type 1'!P67,\"\")","v":""},{"$f":"E67","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2,{"$f":"IFERROR(ABS(D67-D68),0)","v":0},{"$f":"K67","v":0},{"$f":"L67","v":0},{"$f":"M67","v":0},null,3,null,18,null,33,null,48]
[null,"msa",3,{"$f":"IF('1) MSA Type 1'!P68<>\"\",'1) MSA Type 1'!P68,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,0,0,0,0,null,4,null,19,null,34,null,49]
[null,"msa",4,{"$f":"IF('1) MSA Type 1'!P69<>\"\",'1) MSA Type 1'!P69,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4,0,0,0,0,null,5,null,20,null,35,null,50]
[null,"msa",5,{"$f":"IF('1) MSA Type 1'!P70<>\"\",'1) MSA Type 1'!P70,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5,0,0,0,0,null,6,null,21,null,36,null,51]
[null,"msa",6,{"$f":"IF('1) MSA Type 1'!P71<>\"\",'1) MSA Type 1'!P71,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,6,0,0,0,0,null,7,null,22,null,37,null,52]
[null,"msa",7,{"$f":"IF('1) MSA Type 1'!P72<>\"\",'1) MSA Type 1'!P72,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,0,0,0,0,null,8,null,23,null,38,null,53]
[null,"msa",8,{"$f":"IF('1) MSA Type 1'!P73<>\"\",'1) MSA Type 1'!P73,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,0,0,0,0,null,9,null,24,null,39,null,54]
[null,"msa",9,{"$f":"IF('1) MSA Type 1'!P74<>\"\",'1) MSA Type 1'!P74,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,0,0,0,0,null,10,null,25,null,40,null,55]
[null,"msa",10,{"$f":"IF('1) MSA Type 1'!P75<>\"\",'1) MSA Type 1'!P75,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,10,0,0,0,0,null,11,null,26,null,41,null,56]
[null,"msa",11,{"$f":"IF('1) MSA Type 1'!P76<>\"\",'1) MSA Type 1'!P76,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,11,0,0,0,0,null,12,null,27,null,42,null,57]
[null,"msa",12,{"$f":"IF('1) MSA Type 1'!P77<>\"\",'1) MSA Type 1'!P77,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,12,0,0,0,0,null,13,null,28,null,43,null,58]
[null,"msa",13,{"$f":"IF('1) MSA Type 1'!P78<>\"\",'1) MSA Type 1'!P78,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,13,0,0,0,0,null,14,null,29,null,44,null,59]
[null,"msa",14,{"$f":"IF('1) MSA Type 1'!P79<>\"\",'1) MSA Type 1'!P79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,14,0,0,0,0,null,15,null,30,null,45,null,60]
[null,null,15,{"$f":"IF('1) MSA Type 1'!P80<>\"\",'1) MSA Type 1'!P80,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,15,0,0,0,0]
[null,null,16,{"$f":"IF('1) MSA Type 1'!R66<>\"\",'1) MSA Type 1'!R66,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,16,0,0,0,0]
[null,null,17,{"$f":"IF('1) MSA Type 1'!R67<>\"\",'1) MSA Type 1'!R67,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,17,0,0,0,0,null,"Basic Statistics",null,null,null,null,"Bias"]
[null,null,18,{"$f":"IF('1) MSA Type 1'!R68<>\"\",'1) MSA Type 1'!R68,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,18,0,0,0,0,null,"Reference value",null,null,{"$f":"IF(Q47<>\"\",Q47,\"\")","v":""},null,"Bias:",{"$f":"IF(AND(R86<>\"\",R84<>\"\"),R86-R84,\"\")","v":""}]
[null,null,19,{"$f":"IF('1) MSA Type 1'!R69<>\"\",'1) MSA Type 1'!R69,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,19,0,0,0,0,null,"Measurements",null,null,{"$f":"IF(P66<>\"\",COUNT(P66:P80,R66:R80,T66:T80,V66:V80),\"\")","v":""},null,"T:",{"$f":"IF(AND(R84<>\"\",R86<>\"\",R87<>\"\"),(R86-R84)*SQRT(ABS(R85))/(R87),\"\")","v":""}]
[null,null,20,{"$f":"IF('1) MSA Type 1'!R70<>\"\",'1) MSA Type 1'!R70,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,20,0,0,0,0,null,"Average:",null,null,{"$f":"IF(P66<>\"\",AVERAGE(P66:P80,R66:R80,T66:T80,V66:V80),\"\")","v":""},null,"P-value: ",{"$f":"IF(AND(U85<>\"\",R85>1),TDIST(ABS(U85),R85-1,2),\"\")","v":""}]
[null,null,21,{"$f":"IF('1) MSA Type 1'!R71<>\"\",'1) MSA Type 1'!R71,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,21,0,0,0,0,null,"Standard dev. (STDEV.S)",null,null,{"$f":"IF(AND(R85<>\"\",R85>1),_xlfn.STDEV.S(P66:P80,R66:R80,T66:T80,V66:V80),\"\")","v":""}]
[null,null,22,{"$f":"IF('1) MSA Type 1'!R72<>\"\",'1) MSA Type 1'!R72,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,22,0,0,0,0]
[null,null,23,{"$f":"IF('1) MSA Type 1'!R73<>\"\",'1) MSA Type 1'!R73,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,23,0,0,0,0,null,"Tolerance:",null,null,{"$f":"IF(AND(Q59<>\"\",Q61<>\"\"),Q61-Q59,\"\")","v":""}]
[null,null,24,{"$f":"IF('1) MSA Type 1'!R74<>\"\",'1) MSA Type 1'!R74,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,24,0,0,0,0]
[null,null,25,{"$f":"IF('1) MSA Type 1'!R75<>\"\",'1) MSA Type 1'!R75,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,25,0,0,0,0,null,"Gauge R&R result"]
[null,null,26,{"$f":"IF('1) MSA Type 1'!R76<>\"\",'1) MSA Type 1'!R76,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,26,0,0,0,0,null,"%VAR (Repeatability)",null,null,{"$f":"IF(AND(R87<>\"\",R89<>\"\"),R87*6/R89,\"\")","v":""},{"$f":"IF(R93<>\"\",IF(R93<0.1,\"MSA OK\",IF(R93<0.15,\"Gauge may be OK\",\"Gauge needs improvement\")),\"\")","v":""}]
[null,null,27,{"$f":"IF('1) MSA Type 1'!R77<>\"\",'1) MSA Type 1'!R77,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,27,0,0,0,0,null,"% VAR (Repeatability & Bias)",null,null,{"$f":"IF(AND(R87<>\"\",R89<>\"\"),(R87*6+2*ABS(R84-R86))/R89,\"\")","v":""},{"$f":"IF(COUNTA(P66:P80,R66:R80,T66:T80,V66:V80)<30,\"Less than 30 trials, the statistical uncertainty decreases with increased number of trials\",\"\")","v":"Less than 30 trials, the statistical uncertainty decreases with increased number of trials"}]
[null,null,28,{"$f":"IF('1) MSA Type 1'!R78<>\"\",'1) MSA Type 1'!R78,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,28,0,0,0,0]
[null,null,29,{"$f":"IF('1) MSA Type 1'!R79<>\"\",'1) MSA Type 1'!R79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,29,0,0,0,0]
[null,null,30,{"$f":"IF('1) MSA Type 1'!R80<>\"\",'1) MSA Type 1'!R80,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,30,0,0,0,0,null,"Capability results"]
[null,null,31,{"$f":"IF('1) MSA Type 1'!T66<>\"\",'1) MSA Type 1'!T66,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,31,0,0,0,0,null,null,"Cp",{"$f":"IFERROR(R89/(6*R87),\"\")","v":""}]
[null,null,32,{"$f":"IF('1) MSA Type 1'!T67<>\"\",'1) MSA Type 1'!T67,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,32,0,0,0,0,null,null,"Cpk ",{"$f":"IF(AND(Q99=\"\",Q100=\"\"),\"\",MIN(Q99,Q100))","v":""}]
[null,null,33,{"$f":"IF('1) MSA Type 1'!T68<>\"\",'1) MSA Type 1'!T68,\"\")","v":""},"",{"$f":"+E99+(3*$F$65)","v":{"$error":"#VALUE!"}},{"$f":"+E99-(3*$F$65)","v":{"$error":"#VALUE!"}},null,{"$f":"C99","v":33},0,0,0,0,null,null,"Cpl",{"$f":"IFERROR((R86-Q59)/(3*R87),\"\")","v":""}]
[null,null,{"$f":"C99+1","v":34},{"$f":"IF('1) MSA Type 1'!T69<>\"\",'1) MSA Type 1'!T69,\"\")","v":""},{"$f":"E99","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,34,{"$f":"IFERROR(ABS(D99-D100),0)","v":0},{"$f":"K99","v":0},{"$f":"L99","v":0},{"$f":"M99","v":0},null,null,"Cpu",{"$f":"IFERROR((Q61-R86)/(3*R87),\"\")","v":""}]
[null,null,35,{"$f":"IF('1) MSA Type 1'!T70<>\"\",'1) MSA Type 1'!T70,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,35,0,0,0,0]
[null,null,36,{"$f":"IF('1) MSA Type 1'!T71<>\"\",'1) MSA Type 1'!T71,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,36,0,0,0,0]
[null,null,37,{"$f":"IF('1) MSA Type 1'!T72<>\"\",'1) MSA Type 1'!T72,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,37,0,0,0,0]
[null,null,38,{"$f":"IF('1) MSA Type 1'!T73<>\"\",'1) MSA Type 1'!T73,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,38,0,0,0,0]
[null,null,39,{"$f":"IF('1) MSA Type 1'!T74<>\"\",'1) MSA Type 1'!T74,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,39,0,0,0,0]
[null,null,40,{"$f":"IF('1) MSA Type 1'!T75<>\"\",'1) MSA Type 1'!T75,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,40,0,0,0,0]
[null,null,41,{"$f":"IF('1) MSA Type 1'!T76<>\"\",'1) MSA Type 1'!T76,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,41,0,0,0,0]
[null,null,42,{"$f":"IF('1) MSA Type 1'!T77<>\"\",'1) MSA Type 1'!T77,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,42,0,0,0,0]
[null,null,43,{"$f":"IF('1) MSA Type 1'!T78<>\"\",'1) MSA Type 1'!T78,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,43,0,0,0,0]
[null,null,44,{"$f":"IF('1) MSA Type 1'!T79<>\"\",'1) MSA Type 1'!T79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,44,0,0,0,0]
[null,null,45,{"$f":"IF('1) MSA Type 1'!T80<>\"\",'1) MSA Type 1'!T80,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,45,0,0,0,0]
[null,null,46,{"$f":"IF('1) MSA Type 1'!V66<>\"\",'1) MSA Type 1'!V66,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,46,0,0,0,0]
[null,null,47,{"$f":"IF('1) MSA Type 1'!V67<>\"\",'1) MSA Type 1'!V67,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,47,0,0,0,0]
[null,null,48,{"$f":"IF('1) MSA Type 1'!V68<>\"\",'1) MSA Type 1'!V68,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,48,0,0,0,0]
[null,null,49,{"$f":"IF('1) MSA Type 1'!V69<>\"\",'1) MSA Type 1'!V69,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,49,0,0,0,0]
[null,null,50,{"$f":"IF('1) MSA Type 1'!V70<>\"\",'1) MSA Type 1'!V70,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,50,0,0,0,0]
[null,null,51,{"$f":"IF('1) MSA Type 1'!V71<>\"\",'1) MSA Type 1'!V71,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,51,0,0,0,0]
[null,null,52,{"$f":"IF('1) MSA Type 1'!V72<>\"\",'1) MSA Type 1'!V72,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,52,0,0,0,0]
[null,null,53,{"$f":"IF('1) MSA Type 1'!V73<>\"\",'1) MSA Type 1'!V73,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,53,0,0,0,0]
[null,null,54,{"$f":"IF('1) MSA Type 1'!V74<>\"\",'1) MSA Type 1'!V74,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,54,0,0,0,0]
[null,null,55,{"$f":"IF('1) MSA Type 1'!V75<>\"\",'1) MSA Type 1'!V75,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,55,0,0,0,0]
[null,null,56,{"$f":"IF('1) MSA Type 1'!V76<>\"\",'1) MSA Type 1'!V76,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,56,0,0,0,0]
[null,null,57,{"$f":"IF('1) MSA Type 1'!V77<>\"\",'1) MSA Type 1'!V77,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,57,0,0,0,0]
[null,null,58,{"$f":"IF('1) MSA Type 1'!V78<>\"\",'1) MSA Type 1'!V78,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,58,0,0,0,0]
[null,null,59,{"$f":"IF('1) MSA Type 1'!V79<>\"\",'1) MSA Type 1'!V79,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,59,0,0,0,0]
[null,null,60,{"$f":"IF('1) MSA Type 1'!V80<>\"\",'1) MSA Type 1'!V80,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,60,0,0,0,0]

{"sheet":"2) MSA Type 2 (ANOVA)","index":5,"n_rows":120,"n_cols":36,"rows_kept":120,"cut":false,"hidden":false,"merged":[[82,27,83,27],[82,28,83,29],[92,27,92,36],[91,27,91,36],[109,25,109,30],[109,31,109,36],[34,15,34,16],[34,21,34,22],[56,21,56,22],[82,30,83,30],[82,31,83,32],[64,15,64,16],[36,15,36,16],[36,21,36,22],[38,15,38,16],[38,21,38,22],[40,15,40,16],[40,21,40,22],[62,15,62,16],[46,15,46,16],[48,15,48,16],[48,21,48,22],[62,21,62,22],[60,21,60,22],[58,21,58,22],[42,15,42,16],[42,21,42,22],[44,15,44,16],[54,21,54,22],[56,15,56,16],[58,15,58,16],[52,21,52,22],[54,15,54,16],[50,15,50,16],[50,21,50,22],[52,15,52,16],[59,21,59,22],[109,11,109,17],[109,18,109,24],[67,11,68,11],[67,12,68,12],[67,13,67,22],[67,23,67,24],[69,11,73,11],[74,11,78,11],[79,11,83,11]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,null,null,null,null,null,null,null,null,null,null,"MSA Variable Type 2\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,null,null,null,"Gauge Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reference Value",null,null,null,null,null,null,"Date Performed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Specification Number",null,null,null,null,null,null,"Gauge Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Characteristic Name",null,null,null,null,null,null,"Gauge Number"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Characteristic Type",null,null,null,null,null,null,"Gauge Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"TPS No.",null,null,null,null,null,null,null,"Gauge Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Known sigma",null,null,null,null,null,null,null,"Gauge Number"]
[]
[null,null,null,null,null,null,null,null,null,null,null," - LSL",null,null,null,null,null,null,"Appraiser A","Gauge Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null," - USL",null,null,null,null,null,null,"Appraiser B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Resolution",null,null,null,null,null,null,"Appraiser C"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"No. of Trials",null,null,null,{"$f":"IF(N70<>\"\",COUNT(N70:N72),\"\")","v":""},null,null,"Approved Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"No. of Parts",null,null,null,{"$f":"IF(N70<>\"\",COUNT(N70:W70),\"\")","v":""},null,null,"Approved By ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"No. of Appraisers",null,null,null,{"$f":"IF(N70<>\"\",COUNT(N70,N75,N80),\"\")","v":""},null,null,"Approved Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approved Function"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Tolerance",null,null,null,{"$f":"P51-P49","v":0},null,null,"Approved Company"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Level of significance"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Apprai\nser","Trial","Part",null,null,null,null,null,null,null,null,null,"Average",null,"Sum app",null,"Calculations "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,null,null,null,null,"SST",{"$f":"IFERROR(SUMSQ(N70:W72)+SUMSQ(N75:W77)+SUMSQ(N80:W82),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Appariser A",1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N70<>\"\",AVERAGE(N70:W70),\"\")","v":""},null,null,"P1-X",{"$f":"IFERROR(SUMSQ(N89:W91)/COUNT(N70:N72),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"P2-X rks",{"$f":"IFERROR(SUMSQ(N87:W87)/(COUNT(N70:N82)-4),\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"P2*-X ss",{"$f":"IFERROR(SUMSQ(Z73:Z83)/IF(N70<>\"\",COUNT(N70:W72),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(N70<>\"\",SUM(N70:N72)/COUNT(N70:N72),\"\")","v":""},"","","","","","","","","","xa=","",{"$f":"SUM(N70:W72)","v":0},null,"P3X",{"$f":"IFERROR(Y87*Y87/IF(N70<>\"\",P59*(COUNT(N70:W72)),\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(N70<>\"\",MAX(N70:N72)-MIN(N70:N72),\"\")","v":""},"","","","","","","","","","ra=","",null,null,"P3/2 X",{"$f":"IFERROR(AC71+AC72-AC73,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Appariser B",1,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Anova Table"]
[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Source",null,"DF","SS","MS","F","P-value","Significant"]
[null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Appraiser",null,{"$f":"IFERROR(P59-1,\"\")","v":""},{"$f":"IFERROR(AC74-AC71,\"\")","v":""},{"$f":"IFERROR(AE77/AD77,\"\")","v":""},{"$f":"IFERROR(AF77/AF80,\"\")","v":""},{"$f":"IFERROR(FDIST(AG77,AD77,AD80),\"\")","v":""},{"$f":"IF(AH77<P65,\"*\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(N75<>\"\",SUM(N75:N77)/COUNT(N75:N77),\"\")","v":""},"","","","","","","","","","xb=","",{"$f":"SUM(N75:W77)","v":0},null,"Parts",null,{"$f":"IFERROR(P57-1,\"\")","v":""},{"$f":"IFERROR(AC74-AC72,\"\")","v":""},{"$f":"IFERROR(AE78/AD78,\"\")","v":""},{"$f":"IFERROR(AF78/AF80,\"\")","v":""},{"$f":"IFERROR(FDIST(AG78,AD78,AD80),\"\")","v":""},{"$f":"IF(AH78<P65,\"*\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(N75<>\"\",MAX(N75:N77)-MIN(N75:N77),\"\")","v":""},"","","","","","","","","","rb=","",null,null,"Appraiser by Part",null,{"$f":"IFERROR(AD77*AD78,\"\")","v":""},{"$f":"IFERROR(AC70-AC74,\"\")","v":""},{"$f":"IFERROR(AE79/AD79,\"\")","v":""},{"$f":"IFERROR(AF79/AF80,\"\")","v":""},{"$f":"IFERROR(FDIST(AG79,AD79,AD80),\"\")","v":""},{"$f":"IF(AH79<P65,\"*\",\" \")","v":" "}]
[null,null,null,null,null,null,null,null,null,null,null,"Appariser C",1,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Equipment",null,{"$f":"IFERROR(P59*P57*(P55-1),\"\")","v":""},{"$f":"IFERROR(AC69-AC70,\"\")","v":""},{"$f":"IFERROR(AE80/AD80,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"Total",null,{"$f":"IFERROR(SUM(AD77:AD80),\"\")","v":0},{"$f":"IFERROR(AC69-AC73,\"\")","v":""},null,null,null,"* effect is significant "]
[null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,"checksum",null,null,{"$f":"IFERROR(SUM(AE77:AE80),\"\")","v":0},null,null,null,"MS pool",{"$f":"IFERROR((AE79+AE80)/(AD79+AD80),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(N80<>\"\",SUM(N80:N82)/COUNT(N80:N82),\"\")","v":""},"","","","","","","","","","xc=",{"$f":"IF(N83<>\"\",AVERAGE(N83:W83),0)","v":0},{"$f":"SUM(N80:W82)","v":0},null,"Anova Report","Standard Deviation (s)",null,"% Total Variation","% Contribution "]
[null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(N80<>\"\",MAX(N80:N82)-MIN(N80:N82),\"\")","v":""},"","","","","","","","","","rc=",{"$f":"IF(N84<>\"\",AVERAGE(N84:W84),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Part",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(N70<>\"\",AVERAGE(N86:W86),)","v":0},null,null,"Repeatability (EV)",null,{"$f":"IFERROR(SQRT((AE79+AE80)/(AD79+AD80)),\"\")","v":""},{"$f":"IFERROR(100*AD85/AD90,\"\")","v":""},{"$f":"IFERROR(AE85*AE85/100,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"Average",null,{"$f":"IF(N73<>\"\",SUM(N73,N78,N83)/COUNT(N73,N78,N83),\"\")","v":""},"","","","","","","","","","Rp=",{"$f":"IF(N70<>\"\",MAX(N86:W86)-MIN(N86:W86),0)","v":0},null,null,"Reproducibility (AV)",null,{"$f":"IFERROR(IF(AF77-AJ82<0,0,SQRT((AF77-AJ82)/(P59*P57))),\"\")","v":""},{"$f":"IFERROR(100*AD86/AD90,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,"Sum part ",null,{"$f":"SUM(N70:N72)+SUM(N75:N77)+SUM(N80:N82)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(N87:W87)","v":0},null,null,"Appraiser by Part (INT)",null,{"$f":"IFERROR(IF(AF79-AF80<0,0,SQRT((AF79-AF80)/(AD79+AD77))),\"\")","v":""},{"$f":"IFERROR(100*AD87/AD90,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,"Sum table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"GRR",null,{"$f":"IFERROR(SQRT(AD85*AD85+AD86*AD86),\"\")","v":""},{"$f":"IFERROR(100*AD88/AD90,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"SUM(N70:N72)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,"Part-to-Part (PV)",null,{"$f":"IFERROR(IF(AF78-AJ82<0,0,SQRT((AF78-AJ82)/(P59*P55))),\"\")","v":""},{"$f":"IFERROR(100*AD89/AD90,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"SUM(N75:N77)","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,"Total variation ",null,{"$f":"IFERROR(SQRT(AD88*AD88+AD89*AD89),\"\")","v":""},{"$f":"IFERROR(100*AD90/AD90,\"\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"SUM(N80:N82)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R93<>\"\",IF(R93<0.1,\"MSA OK\",IF(R93<0.15,\"Gauge may be OK\",\"Gauge needs improvement\")),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(N70<>\"\",IF(P57<5,\"Less than 5 parts, the statistical uncertainty decreases with increased number of parts\",\"\"),\"\")","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,{"$f":"IF(N70<>\"\",IF(P55*P59<9,\"Less than 3 appraisers and / or 3 repetitions, the statistical uncertainty decreases with increased number of trials\",\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Measurement Unit Analysis",null,null,null,null,null,null,"% GRR to Total variation",null,null,null,null,null,null,"% GRR to Tolerance",null,null,null,null,null,"% GRR to Known sigma"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Repeatability - Equipment Variation (EV)",null,null,null,null,{"$f":"+AD85","v":""},null,"% Equipment Variation (%EV)",null,null,null,null,{"$f":"IFERROR(Q97/Q107,\"\")","v":""},null,"% Equipment Variation (%EV)",null,null,null,{"$f":"IF(AD85<>\"\",AD85*6/(P51-P49),\"\")","v":""},null,"% Equipment Variation (%EV)",null,null,null,{"$f":"IF(AD85<>\"\",AD85/P47)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Reproducibility - Appraiser variation (AV)",null,null,null,null,{"$f":"+AD86","v":""},null,"% Appraiser Variation (%AV)",null,null,null,null,{"$f":"IFERROR(Q99/Q107,\"\")","v":""},null,"% Appraiser Variation (%AV)",null,null,null,{"$f":"IF(AD86<>\"\",AD86*6/(P51-P49),\"\")","v":""},null,"% Appraiser Variation (%AV)",null,null,null,{"$f":"IF(AD86<>\"\",AD86/P47)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Appraiser by Part (INT)",null,null,null,null,{"$f":"+AD87","v":""},null,"% Appraiser by Part (INT)",null,null,null,null,{"$f":"IFERROR(Q101/Q107,\"\")","v":""},null,"% Appraiser by Part (INT)",null,null,null,{"$f":"IF(AD87<>\"\",AD87*6/(P51-P49),\"\")","v":""},null,"% Appraiser by Part (INT)",null,null,null,{"$f":"IF(AD87<>\"\",AD87/P47)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Gauge R & R",null,null,null,null,{"$f":"+AD88","v":""},null,"% Gauge R & R Variation (%GRR)",null,null,null,null,{"$f":"IFERROR(Q103/Q107,\"\")","v":""},null,"% Gauge R & R Variation (%GRR)",null,null,null,{"$f":"IF(AD88<>\"\",AD88*6/(P51-P49),\"\")","v":""},null,"% Gauge R & R Variation (%GRR)",null,null,null,{"$f":"IF(AD88<>\"\",AD88/P47)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Part-to-Part (PV)",null,null,null,null,{"$f":"+AD89","v":""},null,"% Part-to-Part (PV)",null,null,null,null,{"$f":"IFERROR(Q105/Q107,\"\")","v":""},null,"% Part-to-Part (PV)",null,null,null,{"$f":"IF(AD89<>\"\",AD89*6/(P51-P49),\"\")","v":""},null,"% Part-to-Part (PV)",null,null,null,{"$f":"IF(AD89<>\"\",AD89/P47)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Total Variation (TV)",null,null,null,null,{"$f":"+AD90","v":""},null,"Number of Distinct Characteristics",null,null,null,null,{"$f":"IFERROR(1.41*AD89/AD88,\"\")","v":""},null,"Number of Distinct Characteristics",null,null,null,{"$f":"+X107","v":""},null,"Number of Distinct Characteristics",null,null,null,{"$f":"+X107","v":""}]
[]
[]
[null,"MSA ANOVA","UCL a","LCL a","avarage",{"$f":"'2) MSA Type 2 (ANOVA)'!L70","v":"Appariser A"},{"$f":"'2) MSA Type 2 (ANOVA)'!L75","v":"Appariser B"},{"$f":"'2) MSA Type 2 (ANOVA)'!L80","v":"Appariser C"},null,"UCL r",null,"RESULT",null,null,null,null,null,null,{"$f":"IF(X103<>\"\",IF(X103<0.1,\"MSA OK\",IF(X103<0.3,\"Gauge may be OK\",\"Gauge needs improvement\")),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AD103<>\"\",IF(AD103<0.1,\"MSA OK\",IF(AD103<0.3,\"Gauge may be OK\",\"Gauge needs improvement\")),\"\")","v":""},null,null,null,null,null,{"$f":"IF(AJ103<>\"\",IF(AJ103<0.1,\"MSA OK\",IF(AJ103<0.3,\"Gauge may be OK\",\"Gauge needs improvement\")),\"\")","v":"Gauge needs improvement"}]
[null,1,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!N73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!N78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!N83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,2,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!O73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!O78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!O83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,3,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!P73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!P78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!P83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,4,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Q73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!Q78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!Q83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,5,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!R73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!R78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!R83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,6,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!S73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!S78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!S83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,7,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!T73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!T78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!T83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,8,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!U73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!U78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!U83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,9,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!V73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!V78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!V83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]
[null,10,{"$f":"'2) MSA Type 2 (ANOVA)'!Y81+(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!Y81-(3*_xlfn.STDEV.P('2) MSA Type 2 (ANOVA)'!Y70,'2) MSA Type 2 (ANOVA)'!Y80,'2) MSA Type 2 (ANOVA)'!Y75))","v":{"$error":"#VALUE!"}},{"$f":"AVERAGE('2) MSA Type 2 (ANOVA)'!N82:W82)","v":{"$error":"#DIV/0!"}},{"$f":"'2) MSA Type 2 (ANOVA)'!W73","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!W78","v":""},{"$f":"'2) MSA Type 2 (ANOVA)'!W83","v":""},null,{"$f":"+'2) MSA Type 2 (ANOVA)'!Y85","v":0}]

{"sheet":"3) MSA Attribute","index":6,"n_rows":123,"n_cols":36,"rows_kept":123,"cut":false,"hidden":false,"merged":[[7,6,7,7],[7,12,7,13],[9,6,9,7],[9,12,9,13],[15,6,15,7],[19,6,19,7],[19,12,19,13],[21,6,21,7],[21,12,21,13],[23,6,23,7],[23,12,23,13],[11,6,11,7],[11,12,11,13],[13,6,13,7],[13,12,13,13],[34,14,35,14],[25,6,25,7],[25,12,25,13],[27,6,27,7],[29,12,29,13],[29,6,29,7],[34,2,35,2],[34,3,34,11],[34,12,35,12],[34,13,35,13],[27,12,27,13],[91,2,92,4],[91,5,91,10],[91,11,92,13],[92,5,92,6],[92,7,92,8],[92,9,92,10],[87,2,87,14],[88,2,88,14],[93,2,93,4],[94,2,94,4],[94,5,94,6],[94,7,94,8],[94,9,94,10],[94,11,94,12],[93,5,93,6],[93,7,93,8],[93,9,93,10],[93,11,93,12],[97,2,97,4],[97,5,97,6],[97,7,97,8],[97,9,97,10],[97,11,97,12],[103,2,103,13],[95,2,95,4],[95,5,95,6],[95,7,95,8],[95,9,95,10],[95,11,95,12],[96,2,96,4],[96,5,96,6],[96,7,96,8],[96,9,96,10],[96,11,96,12],[104,2,105,4],[104,5,104,10],[104,11,105,13],[106,2,106,4],[106,11,106,13],[107,2,107,4],[107,11,107,13],[108,2,108,4],[108,11,108,13],[108,5,108,6],[108,7,108,8],[108,9,108,10],[106,5,106,6],[106,7,106,8],[106,9,106,10],[107,5,107,6],[107,7,107,8],[107,9,107,10],[105,5,105,6],[105,7,105,8],[105,9,105,10],[109,2,109,4],[109,11,109,13],[110,2,110,4],[110,11,110,13],[111,2,111,4],[111,5,111,6],[111,7,111,8],[111,9,111,10],[111,11,111,13],[110,5,110,6],[110,7,110,8],[110,9,110,10],[109,5,109,6],[109,7,109,8],[109,9,109,10],[114,2,114,4],[114,5,114,6],[114,7,114,8],[114,9,114,10],[114,11,114,13],[112,2,112,4],[112,5,112,6],[112,7,112,8],[112,9,112,10],[112,11,112,13],[113,5,113,6],[113,7,113,8],[113,9,113,10],[113,11,113,13]]}
[]
[]
[]
[null,"Section",{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[null,{"$f":"OFFSET(B6,-1,)+1","v":1},"MSA Attribute\n"]
[null,{"$f":"OFFSET(B7,-1,)","v":1}]
[null,{"$f":"OFFSET(B8,-1,)","v":1},"Reference Value",null,null,null,null,null,null,"Date Performed"]
[null,1]
[null,1,"Specification Number",null,null,null,null,null,null,"Gauge Name"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"B",null,"C"]
[null,1,"Characteristic Name",null,null,null,null,null,null,"Gauge Number"]
[null,1]
[null,1,"Characteristic Type",null,null,null,null,null,null,"Gauge Type"]
[null,1]
[null,1,"TPS No."]
[null,1]
[null,1,"Specifications"]
[null,1]
[null,1," - LSL",null,null,null,null,null,null,"Appraiser A"]
[null,1]
[null,1," - USL",null,null,null,null,null,null,"Appraiser B"]
[null,1]
[null,1,"Resolution",null,null,null,null,null,null,"Appraiser C"]
[null,1]
[null,1,"No. of Trials",null,null,null,{"$f":"IF(D37<>\"\",COUNT(D37:F37),\"\")","v":""},null,null,"Approved Date"]
[null,1]
[null,1,"No. of Parts",null,null,null,{"$f":"IF(D37<>\"\",COUNT(D37:D86),\"\")","v":""},null,null,"Approved By ID"]
[null,1]
[null,1,"No. of Appraisers",null,null,null,{"$f":"IF(D37<>\"\",COUNT(D37,G37,J37),\"\")","v":""},null,null,"Approved By Name"]
[null,1]
[null,1]
[null,1]
[null,1]
[null,1,"Part","Appraiser-Evaluation",null,null,null,null,null,null,null,null,"Stan-dard","Standard Value","Code",null,null,null,null,null,null,null,"A analysis",null,null,null,"B analysis",null,null,null,"C analysis",null,null,null,"System"]
[null,1,null,"A-1","A-2","A-3","B-1","B-2","B-3","C-1","C-2","C-3",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D37<>\"\",IF(AND(D37=E37,E37=F37),1,0),\"\")","v":""},{"$f":"IF(D37<>\"\",IF(AND(D37=E37,E37=F37,F37=M37),1,0),\"\")","v":""},{"$f":"IF(W36<>\"\",IF(W36<>X36,M37,\"\"),\"\")","v":""},null,{"$f":"IF(G37<>\"\",IF(AND(G37=H37,G37=I37),1,0),\"\")","v":""},{"$f":"IF(G37<>\"\",IF(AND(G37=H37,H37=I37,I37=M37),1,0),\"\")","v":""},{"$f":"IF(AA36<>\"\",IF(AA36<>AB36,M37,\"\"),\"\")","v":""},null,{"$f":"IF(J37<>\"\",IF(AND(J37=K37,K37=L37),1,0),\"\")","v":""},{"$f":"IF(J37<>\"\",IF(AND(J37=K37,K37=L37,L37=M37),1,0),\"\")","v":""},{"$f":"IF(AE36<>\"\",IF(AE36<>AF36,M37,\"\"),\"\")","v":""},null,{"$f":"IF(D37<>\"\",IF(OR(SUM(D37:L37)=COUNT(D37:L37),SUM(D37:L37)=0),1,0),\"\")","v":""},{"$f":"IF(AF36<>\"\",IF(X36+AB36+AF36=3,1,0),\"\")","v":""}]
[null,1,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D37<>\"\",IF(SUM(D37:L37)=COUNT(D37:L37),\"+\",IF(SUM(D37:L37)=0,\"-\",\"x\")),\"\")","v":""},null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,{"$f":"C37+1","v":2},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D38<>\"\",IF(SUM(D38:L38)=COUNT(D38:L38),\"+\",IF(SUM(D38:L38)=0,\"-\",\"x\")),\"\")","v":""},null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,4,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,5,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,6,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,7,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,8,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,9,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,10,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,11,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,12,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,13,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,14,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,15,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,16,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,17,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,18,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,19,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,20,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,21,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,22,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,23,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,24,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,25,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,26,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,27,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,28,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,29,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,30,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,31,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D67<>\"\",IF(SUM(D67:L67)=9,\"+\",IF(SUM(D67:L67)=0,\"-\",\"x\")),\"\")","v":""},null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,32,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,{"$f":"IF(D69<>\"\",IF(AND(D69=E69,E69=F69),1,0),\"\")","v":""},{"$f":"IF(D69<>\"\",IF(AND(D69=E69,E69=F69,F69=M69),1,0),\"\")","v":""},{"$f":"IF(W68<>\"\",IF(W68<>X68,M69,\"\"),\"\")","v":""},null,{"$f":"IF(G69<>\"\",IF(AND(G69=H69,G69=I69),1,0),\"\")","v":""},{"$f":"IF(G69<>\"\",IF(AND(G69=H69,H69=I69,I69=M69),1,0),\"\")","v":""},{"$f":"IF(AA68<>\"\",IF(AA68<>AB68,M69,\"\"),\"\")","v":""},null,{"$f":"IF(J69<>\"\",IF(AND(J69=K69,K69=L69),1,0),\"\")","v":""},{"$f":"IF(J69<>\"\",IF(AND(J69=K69,K69=L69,L69=M69),1,0),\"\")","v":""},{"$f":"IF(AE68<>\"\",IF(AE68<>AF68,M69,\"\"),\"\")","v":""},null,{"$f":"IF(D69<>\"\",IF(OR(SUM(D69:L69)=COUNT(D69:L69),SUM(D69:L69)=0),1,0),\"\")","v":""},""]
[null,1,33,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,34,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,35,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,{"$f":"OFFSET(B72,-1,)","v":1},36,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,37,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,38,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,39,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,40,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,{"$f":"C76+1","v":41},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D77<>\"\",IF(SUM(D77:L77)=9,\"+\",IF(SUM(D77:L77)=0,\"-\",\"x\")),\"\")","v":""},null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,{"$f":"C77+1","v":42},null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,43,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,44,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,45,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,46,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,47,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,48,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,49,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"","","",null,"","","",null,"","","",null,"",""]
[null,1,50,null,null,null,null,null,null,null,null,null,null,null,""]
[null,1]
[null,1,{"$f":"IF(D37<>\"\",IF(G28<30,\"Less than 30 trials, the statistical uncertainty decreases with increased number of trials\",\"\"),\"\")","v":""}]
[null,1,{"$f":"IF(D37<>\"\",IF(G26<3,\"Less than 3 repetitions, the statistical uncertainty decreases with increased number of trials\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,"B",null,"C"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F94<>\"\",F96-F97,\"\")","v":""},null,{"$f":"IF(H94<>\"\",H96-H97,\"\")","v":""},null,{"$f":"IF(J94<>\"\",J96-J97,\"\")","v":""}]
[null,1,"Appraisers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F94<>\"\",F97-F98,\"\")","v":""},null,{"$f":"IF(H94<>\"\",H97-H98,\"\")","v":""},null,{"$f":"IF(J94<>\"\",J97-J98,\"\")","v":""}]
[null,1,null,null,null,"Within Appraiser (*1)",null,null,null,null,null,"Between \nAppraisers (*2)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F94<>\"\",F112-F113,\"\")","v":""},null,{"$f":"IF(H94<>\"\",H112-H113,\"\")","v":""},null,{"$f":"IF(J94<>\"\",J112-J113,\"\")","v":""}]
[null,1,null,null,null,"Appraiser A",null,"Appraiser B",null,"Appraiser C",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F94<>\"\",F113-F114,\"\")","v":""},null,{"$f":"IF(H94<>\"\",H113-H114,\"\")","v":""},null,{"$f":"IF(J94<>\"\",J113-J114,\"\")","v":""}]
[null,1,"Total Inspected",null,null,{"$f":"IF(D37<>\"\",COUNT(D37:D86),\"\")","v":""},null,{"$f":"IF(G37<>\"\",COUNT(G37:G86),\"\")","v":""},null,{"$f":"IF(J37<>\"\",COUNT(J37:J86),\"\")","v":""},null,{"$f":"F94","v":""}]
[null,1,"# Matched",null,null,{"$f":"IF(D37<>\"\",SUM(W36:W85),\"\")","v":""},null,{"$f":"IF(G37<>\"\",SUM(AA36:AA85),\"\")","v":""},null,{"$f":"IF(J37<>\"\",SUM(AE36:AE85),\"\")","v":""},null,{"$f":"IF(F94<>\"\",SUM(AI36:AI85),\"\")","v":""}]
[null,1,"95% upper CI",null,null,{"$f":"IF(F95<>\"\",IF(F94=F95,1,(2*(F95+1)*FINV(0.025,2*(F95+1),2*(F94-F95)))/(2*(F94-F95)+2*(F95+1)*FINV(0.025,2*(F95+1),2*(F94-F95)))),\"\")","v":""},null,{"$f":"IF(H95<>\"\",IF(H94=H95,1,(2*(H95+1)*FINV(0.025,2*(H95+1),2*(H94-H95)))/(2*(H94-H95)+2*(H95+1)*FINV(0.025,2*(H95+1),2*(H94-H95)))),\"\")","v":""},null,{"$f":"IF(J95<>\"\",IF(J94=J95,1,(2*(J95+1)*FINV(0.025,2*(J95+1),2*(J94-J95)))/(2*(J94-J95)+2*(J95+1)*FINV(0.025,2*(J95+1),2*(J94-J95)))),\"\")","v":""},null,{"$f":"IF(L95<>\"\",IF(L94=L95,1,(2*(L95+1)*FINV(0.025,2*(L95+1),2*(L94-L95)))/(2*(L94-L95)+2*(L95+1)*FINV(0.025,2*(L95+1),2*(L94-L95)))),\"\")","v":""}]
[null,1,"Calculated Score",null,null,{"$f":"IF(F94<>\"\",F95/F94,\"\")","v":""},null,{"$f":"IF(H94<>\"\",H95/H94,\"\")","v":""},null,{"$f":"IF(J94<>\"\",J95/J94,\"\")","v":""},null,{"$f":"IF(L94<>\"\",L95/L94,\"\")","v":""}]
[null,1,"95% lower CI",null,null,{"$f":"IF(F95<>\"\",IF(F95=0,0,(2*F95*FINV(0.975,2*F95,2*(F94-F95+1)))/(2*(F94-F95+1)+2*F95*FINV(0.975,2*F95,2*(F94-F95+1)))),\"\")","v":""},null,{"$f":"IF(H95<>\"\",IF(F95=0,0,(2*H95*FINV(0.975,2*H95,2*(H94-H95+1)))/(2*(H94-H95+1)+2*H95*FINV(0.975,2*H95,2*(H94-H95+1)))),\"\")","v":""},null,{"$f":"IF(J95<>\"\",IF(F95=0,0,(2*J95*FINV(0.975,2*J95,2*(J94-J95+1)))/(2*(J94-J95+1)+2*J95*FINV(0.975,2*J95,2*(J94-J95+1)))),\"\")","v":""},null,{"$f":"IF(L95<>\"\",IF(F95=0,0,(2*L95*FINV(0.975,2*L95,2*(L94-L95+1)))/(2*(L94-L95+1)+2*L95*FINV(0.975,2*L95,2*(L94-L95+1)))),\"\")","v":""}]
[null,1]
[null,1,"*1) Within Appraiser: Appraisers agree between themselves on all trials A"]
[null,1,"*2) Between Appraisers: All appraisers agreed within and between themselves C"]
[null,1]
[null,1]
[null,1,"Appraisers vs. Standard"]
[null,1,"Source",null,null,"Appraiser vs. Standard (*3)",null,null,null,null,null,"All Appraisers vs. Standard (*4)"]
[null,1,null,null,null,"Appraiser A",null,"Appraiser B",null,"Appraiser C"]
[null,1,"Total Inspected",null,null,{"$f":"F94","v":""},null,{"$f":"H94","v":""},null,{"$f":"J94","v":""},null,{"$f":"F107","v":""}]
[null,1,"# Matched",null,null,{"$f":"IF(F107<>\"\",SUM(X36:X85),\"\")","v":""},null,{"$f":"IF(H107<>\"\",SUM(AB36:AB85),\"\")","v":""},null,{"$f":"IF(J107<>\"\",SUM(AF36:AF85),\"\")","v":""},null,{"$f":"IF(F107<>\"\",SUM(AJ36:AJ85),\"\")","v":""}]
[null,1,"False Positive (*5)",null,null,{"$f":"IF(F107<>\"\",COUNTIF(Y36:Y85,\"=1\"),\"\")","v":""},null,{"$f":"IF(H107<>\"\",COUNTIF(AC36:AC85,\"=1\"),\"\")","v":""},null,{"$f":"IF(J107<>\"\",COUNTIF(AG36:AG85,\"=1\"),\"\")","v":""}]
[null,1,"False Negative (*6)",null,null,{"$f":"IF(F107<>\"\",COUNTIF(Y36:Y85,\"=0\"),\"\")","v":""},null,{"$f":"IF(H107<>\"\",COUNTIF(AC36:AC85,\"=0\"),\"\")","v":""},null,{"$f":"IF(J107<>\"\",COUNTIF(AG36:AG85,\"=0\"),\"\")","v":""}]
[null,1,"Mixed",null,null,{"$f":"IF(F107<>\"\",F107-F108-F109-F110,\"\")","v":""},null,{"$f":"IF(H107<>\"\",H107-H108-H109-H110,\"\")","v":""},null,{"$f":"IF(J107<>\"\",J107-J108-J109-J110,\"\")","v":""}]
[null,1,"95% upper CI (*7)",null,null,{"$f":"IF(F108<>\"\",IF(F107=F108,1,(2*(F108+1)*FINV(0.025,2*(F108+1),2*(F107-F108)))/(2*(F107-F108)+2*(F108+1)*FINV(0.025,2*(F108+1),2*(F107-F108)))),\"\")","v":""},null,{"$f":"IF(H108<>\"\",IF(H107=H108,1,(2*(H108+1)*FINV(0.025,2*(H108+1),2*(H107-H108)))/(2*(H107-H108)+2*(H108+1)*FINV(0.025,2*(H108+1),2*(H107-H108)))),\"\")","v":""},null,{"$f":"IF(J108<>\"\",IF(J107=J108,1,(2*(J108+1)*FINV(0.025,2*(J108+1),2*(J107-J108)))/(2*(J107-J108)+2*(J108+1)*FINV(0.025,2*(J108+1),2*(J107-J108)))),\"\")","v":""},null,{"$f":"IF(L108<>\"\",IF(L107=L108,1,(2*(L108+1)*FINV(0.025,2*(L108+1),2*(L107-L108)))/(2*(L107-L108)+2*(L108+1)*FINV(0.025,2*(L108+1),2*(L107-L108)))),\"\")","v":""}]
[null,1,"Calculated Score",null,null,{"$f":"IF(F107<>\"\",F108/F107,\"\")","v":""},null,{"$f":"IF(H107<>\"\",H108/H107,\"\")","v":""},null,{"$f":"IF(J107<>\"\",J108/J107,\"\")","v":""},null,{"$f":"IF(L107<>\"\",L108/L107,\"\")","v":""}]
[null,1,"95% lower CI (*7)",null,null,{"$f":"IF(F108<>\"\",IF(F108=0,0,(2*F108*FINV(0.975,2*F108,2*(F107-F108+1)))/(2*(F107-F108+1)+2*F108*FINV(0.975,2*F108,2*(F107-F108+1)))),\"\")","v":""},null,{"$f":"IF(H108<>\"\",IF(F108=0,0,(2*H108*FINV(0.975,2*H108,2*(H107-H108+1)))/(2*(H107-H108+1)+2*H108*FINV(0.975,2*H108,2*(H107-H108+1)))),\"\")","v":""},null,{"$f":"IF(J108<>\"\",IF(F108=0,0,(2*J108*FINV(0.975,2*J108,2*(J107-J108+1)))/(2*(J107-J108+1)+2*J108*FINV(0.975,2*J108,2*(J107-J108+1)))),\"\")","v":""},null,{"$f":"IF(L108<>\"\",IF(F108=0,0,(2*L108*FINV(0.975,2*L108,2*(L107-L108+1)))/(2*(L107-L108+1)+2*L108*FINV(0.975,2*L108,2*(L107-L108+1)))),\"\")","v":""}]
[null,1,"Decision",null,null,{"$f":"IF(F107<>\"\",IF(AND(F113>=0.9,F113<=1),\"Accepted\",IF(F113<=0.8,\"Not accepted\",\"Might be acceptable\")),\"\")","v":""},null,{"$f":"IF(H107<>\"\",IF(AND(H113>=0.9,H113<=1),\"Accepted\",IF(H113<=0.8,\"Not accepted\",\"Might be acceptable\")),\"\")","v":""},null,{"$f":"IF(J107<>\"\",IF(AND(J113>=0.9,J113<=1),\"Accepted\",IF(J113<=0.8,\"Not accepted\",\"Might be acceptable\")),\"\")","v":""},null,{"$f":"IF(L107<>\"\",IF(AND(L113>=0.9,L113<=1),\"Accepted\",IF(L113<=0.8,\"Not accepted\",\"Might be acceptable\")),\"\")","v":""}]
[null,1]
[null,1,"*3) Appraiser vs. Standard: Appraiser agrees on all trials with the known standard B"]
[null,1,"*4) All Appraisers vs. Standard: Appraisers agree on all trials with the known standard"]
[null,1,"*5) False Positive: Appraiser biased towards rejection"]
[null,1,"*6) False Negative: Appraiser biased towards acceptance"]
[null,1,"*7) UCL and LCL: Upper and lower confidence interval boundaries."]
[null,1]
[null,1]

{"sheet":"4) MSA Supplier Format","index":7,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,2,25,5],[24,2,24,3],[24,4,24,5]]}
[]
[]
[]
[null,null,{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"OFFSET(B13,-1,)","v":0},"Gauge Identification Number"]
[null,0]
[null,0,"Date of Approval"]
[null,0]
[null,0,"Test Report Approver ID"]
[null,0]
[null,0,"Test Report Approver Name "]
[null,0]
[null,0,"Test Report Approver Function"]
[null,0]
[null,0,"Test Report Approver Company"]
[null,0]
[null,0,"Description of the method and result evaluation"]
[null,0]
[null,0]
[null,0]

{"sheet":"5) Capability Study","index":8,"n_rows":122,"n_cols":22,"rows_kept":122,"cut":false,"hidden":false,"merged":[[39,20,39,21],[41,20,41,21],[43,20,43,21],[45,20,45,21],[37,14,37,21],[39,16,39,17],[57,20,57,21],[41,16,41,17],[43,16,43,17],[45,16,45,17],[47,16,47,17],[49,16,49,17],[51,20,51,21],[49,20,49,21],[54,16,54,17],[55,16,55,17],[55,20,55,21],[53,16,53,17],[53,20,53,21],[54,20,54,21],[77,14,77,18],[77,19,77,21],[78,14,78,16],[78,17,78,18],[78,20,78,21],[79,14,79,16],[79,17,79,18],[79,20,79,21],[84,14,84,21],[85,14,85,21],[80,14,80,16],[80,17,80,18],[80,20,80,21],[81,14,81,16],[81,17,81,18],[81,19,81,21],[86,14,86,16],[86,18,86,21],[87,14,87,16],[87,18,88,21],[82,14,82,16],[82,17,82,18],[82,19,82,21],[83,14,83,16],[83,17,83,18],[83,19,83,21],[94,16,94,17],[94,20,94,21],[90,14,90,21],[91,16,91,17],[91,20,91,21],[92,16,92,17],[92,20,92,21],[93,16,93,17],[93,20,93,21]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[null,"Inst"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capability Study Calculations\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No.",null,null,null,null,"Gauge Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean/Target Value",null,null,null,null,"Gauge Number"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specification Number",null,null,null,null,"Gauge Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Name",null,null,null,null,"Date Performed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resolution",null,null,null,null,"Approved Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specifications",null,null,null,null,"Approved By ID"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - LSL",null,null,null,null,"Approved Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - USL",null,null,null,null,"Approved Function"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Used sigma coverage (default 6):",null,null,6,null,"Approved Company"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ONLY INSERT VALUES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No.","Data","No.","Data","No.","Data","No.","Data"]
[null,"msa","Count",{"$f":"60-COUNTIF(D63:D122,\"\")","v":5},"STDV",{"$f":"R82","v":""},null,null,null,null,null,null,null,null,1,null,16,null,31,null,46]
[null,"msa","No","data","average","UCL","LCL","Column1","No.","range","range -","UCL2","LCL3",null,2,null,17,null,32,null,47]
[null,"msa",1,{"$f":"IF('1) MSA Type 1'!P86<>\"\",'1) MSA Type 1'!P86,\"\")","v":""},{"$f":"IF(D63<>\"\",AVERAGE(D63:D122),\"\")","v":""},{"$f":"+E63+(3*$F$41)","v":{"$error":"#VALUE!"}},{"$f":"+E63-(3*$F$41)","v":{"$error":"#VALUE!"}},null,{"$f":"C63","v":1},null,{"$f":"AVERAGE(J64:J122)","v":0},{"$f":"+K63+(3*_xlfn.STDEV.P(J64:J122))","v":0},{"$f":"IF(K63-(3*_xlfn.STDEV.P(J64:J122))<0,0,(K63-(3*_xlfn.STDEV.P(J64:J122))))","v":0},null,3,null,18,null,33,null,48]
[null,"msa",{"$f":"C63+1","v":2},{"$f":"IF('1) MSA Type 1'!P87<>\"\",'1) MSA Type 1'!P87,\"\")","v":""},{"$f":"E63","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2,{"$f":"IFERROR(ABS(D63-D64),0)","v":0},{"$f":"K63","v":0},{"$f":"L63","v":0},{"$f":"M63","v":0},null,4,null,19,null,34,null,49]
[null,"msa",3,{"$f":"IF('1) MSA Type 1'!P88<>\"\",'1) MSA Type 1'!P88,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,0,0,0,0,null,5,null,20,null,35,null,50]
[null,"msa",4,{"$f":"IF('1) MSA Type 1'!P89<>\"\",'1) MSA Type 1'!P89,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4,0,0,0,0,null,6,null,21,null,36,null,51]
[null,"msa",5,{"$f":"IF('1) MSA Type 1'!P90<>\"\",'1) MSA Type 1'!P90,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5,0,0,0,0,null,7,null,22,null,37,null,52]
[null,"msa",6,{"$f":"IF('1) MSA Type 1'!P91<>\"\",'1) MSA Type 1'!P91,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,6,0,0,0,0,null,8,null,23,null,38,null,53]
[null,"msa",7,{"$f":"IF('1) MSA Type 1'!P92<>\"\",'1) MSA Type 1'!P92,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,0,0,0,0,null,9,null,24,null,39,null,54]
[null,"msa",8,{"$f":"IF('1) MSA Type 1'!P93<>\"\",'1) MSA Type 1'!P93,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,0,0,0,0,null,10,null,25,null,40,null,55]
[null,"msa",9,{"$f":"IF('1) MSA Type 1'!P94<>\"\",'1) MSA Type 1'!P94,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,0,0,0,0,null,11,null,26,null,41,null,56]
[null,"msa",10,{"$f":"IF('1) MSA Type 1'!P95<>\"\",'1) MSA Type 1'!P95,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,10,0,0,0,0,null,12,null,27,null,42,null,57]
[null,"msa",11,{"$f":"IF('1) MSA Type 1'!P96<>\"\",'1) MSA Type 1'!P96,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,11,0,0,0,0,null,13,null,28,null,43,null,58]
[null,"msa",12,{"$f":"IF('1) MSA Type 1'!P97<>\"\",'1) MSA Type 1'!P97,\"\")","v":"Cp"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,12,0,0,0,0,null,14,null,29,null,44,null,59]
[null,"msa",13,{"$f":"IF('1) MSA Type 1'!P98<>\"\",'1) MSA Type 1'!P98,\"\")","v":"Cpk "},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,13,0,0,0,0,null,15,null,30,null,45,null,60]
[null,null,14,{"$f":"IF('1) MSA Type 1'!P99<>\"\",'1) MSA Type 1'!P99,\"\")","v":"Cpl"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,14,0,0,0,0]
[null,null,15,{"$f":"IF('1) MSA Type 1'!P100<>\"\",'1) MSA Type 1'!P100,\"\")","v":"Cpu"},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,15,0,0,0,0]
[null,null,16,{"$f":"IF('1) MSA Type 1'!R86<>\"\",'1) MSA Type 1'!R86,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,16,0,0,0,0,null,"Basic Statistics",null,null,null,null,"Bias"]
[null,null,17,{"$f":"IF('1) MSA Type 1'!R87<>\"\",'1) MSA Type 1'!R87,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,17,0,0,0,0,null,"Reference value",null,null,{"$f":"IF(Q42<>\"\",Q42,\"\")","v":""},null,"Bias:",{"$f":"IF(AND(R81<>\"\",R79<>\"\"),R81-R79,\"\")","v":""}]
[null,null,18,{"$f":"IF('1) MSA Type 1'!R88<>\"\",'1) MSA Type 1'!R88,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,18,0,0,0,0,null,"Measurements",null,null,{"$f":"IF(P61<>\"\",COUNT(P61:P75,R61:R75,T61:T75,V61:V75),\"\")","v":""},null,"T:",{"$f":"IF(AND(R79<>\"\",R81<>\"\",R82<>\"\"),(R81-R79)*SQRT(ABS(R80))/(R82),\"\")","v":""}]
[null,null,19,{"$f":"IF('1) MSA Type 1'!R89<>\"\",'1) MSA Type 1'!R89,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,19,0,0,0,0,null,"Average:",null,null,{"$f":"IF(P61<>\"\",AVERAGE(P61:P75,R61:R75,T61:T75,V61:V75),\"\")","v":""},null,"P-value: ",{"$f":"IF(AND(U80<>\"\",R80>1),TDIST(ABS(U80),R80-1,2),\"\")","v":""}]
[null,null,20,{"$f":"IF('1) MSA Type 1'!R90<>\"\",'1) MSA Type 1'!R90,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,20,0,0,0,0,null,"Standard dev. (STDEV.S)",null,null,{"$f":"IF(AND(R80<>\"\",R80>1),_xlfn.STDEV.S(P61:P75,R61:R75,T61:T75,V61:V75),\"\")","v":""}]
[null,null,21,{"$f":"IF('1) MSA Type 1'!R91<>\"\",'1) MSA Type 1'!R91,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,21,0,0,0,0,null," ",null,null," "]
[null,null,22,{"$f":"IF('1) MSA Type 1'!R92<>\"\",'1) MSA Type 1'!R92,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,22,0,0,0,0,null,"Tolerance:",null,null,{"$f":"IF(AND(Q54<>\"\",Q56<>\"\"),Q56-Q54,\"\")","v":""}]
[null,null,23,{"$f":"IF('1) MSA Type 1'!R93<>\"\",'1) MSA Type 1'!R93,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,23,0,0,0,0]
[null,null,24,{"$f":"IF('1) MSA Type 1'!R94<>\"\",'1) MSA Type 1'!R94,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,24,0,0,0,0]
[null,null,25,{"$f":"IF('1) MSA Type 1'!R95<>\"\",'1) MSA Type 1'!R95,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,25,0,0,0,0]
[null,null,26,{"$f":"IF('1) MSA Type 1'!R96<>\"\",'1) MSA Type 1'!R96,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,26,0,0,0,0]
[null,null,27,{"$f":"IF('1) MSA Type 1'!R97<>\"\",'1) MSA Type 1'!R97,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,27,0,0,0,0]
[null,null,28,{"$f":"IF('1) MSA Type 1'!R98<>\"\",'1) MSA Type 1'!R98,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,28,0,0,0,0]
[null,null,29,{"$f":"IF('1) MSA Type 1'!R99<>\"\",'1) MSA Type 1'!R99,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,29,0,0,0,0,null,"Capability results"]
[null,null,30,{"$f":"IF('1) MSA Type 1'!R100<>\"\",'1) MSA Type 1'!R100,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,30,0,0,0,0,null,null,"Cp",{"$f":"IFERROR(R84/(R58*R82),\"\")","v":""},null,null," "," "]
[null,null,31,{"$f":"IF('1) MSA Type 1'!T86<>\"\",'1) MSA Type 1'!T86,\"\")","v":"P-value: "},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,31,0,0,0,0,null,null,"Cpk ",{"$f":"IF(Q54<>\"\",IF(AND(Q94=\"\",Q95=\"\"),\"\",MIN(Q94,Q95)),\"\")","v":""},null,null," "," "]
[null,null,32,{"$f":"IF('1) MSA Type 1'!T87<>\"\",'1) MSA Type 1'!T87,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,32,0,0,0,0,null,null,"Cpl",{"$f":"IF(Q54<>\"\",IFERROR((R81-Q54)/(R58*0.5*R82),\"\"),\"\")","v":""},null,null," "," "]
[null,null,33,{"$f":"IF('1) MSA Type 1'!T88<>\"\",'1) MSA Type 1'!T88,\"\")","v":""},"",{"$f":"+E95+(3*$F$41)","v":{"$error":"#VALUE!"}},{"$f":"+E95-(3*$F$41)","v":{"$error":"#VALUE!"}},null,{"$f":"C95","v":33},0,0,0,0,null,null,"Cpu",{"$f":"IF(Q56<>\"\",IFERROR((Q56-R81)/(R58*0.5*R82),\"\"),\"\")","v":""},null,null," "," "]
[null,null,{"$f":"C95+1","v":34},{"$f":"IF('1) MSA Type 1'!T89<>\"\",'1) MSA Type 1'!T89,\"\")","v":""},{"$f":"E95","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,34,{"$f":"IFERROR(ABS(D95-D96),0)","v":0},{"$f":"K95","v":0},{"$f":"L95","v":0},{"$f":"M95","v":0}]
[null,null,35,{"$f":"IF('1) MSA Type 1'!T90<>\"\",'1) MSA Type 1'!T90,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,35,0,0,0,0]
[null,null,36,{"$f":"IF('1) MSA Type 1'!T91<>\"\",'1) MSA Type 1'!T91,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,36,0,0,0,0]
[null,null,37,{"$f":"IF('1) MSA Type 1'!T92<>\"\",'1) MSA Type 1'!T92,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,37,0,0,0,0]
[null,null,38,{"$f":"IF('1) MSA Type 1'!T93<>\"\",'1) MSA Type 1'!T93,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,38,0,0,0,0]
[null,null,39,{"$f":"IF('1) MSA Type 1'!T94<>\"\",'1) MSA Type 1'!T94,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,39,0,0,0,0]
[null,null,40,{"$f":"IF('1) MSA Type 1'!T95<>\"\",'1) MSA Type 1'!T95,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,40,0,0,0,0]
[null,null,41,{"$f":"IF('1) MSA Type 1'!T96<>\"\",'1) MSA Type 1'!T96,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,41,0,0,0,0]
[null,null,42,{"$f":"IF('1) MSA Type 1'!T97<>\"\",'1) MSA Type 1'!T97,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,42,0,0,0,0]
[null,null,43,{"$f":"IF('1) MSA Type 1'!T98<>\"\",'1) MSA Type 1'!T98,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,43,0,0,0,0]
[null,null,44,{"$f":"IF('1) MSA Type 1'!T99<>\"\",'1) MSA Type 1'!T99,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,44,0,0,0,0]
[null,null,45,{"$f":"IF('1) MSA Type 1'!T100<>\"\",'1) MSA Type 1'!T100,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,45,0,0,0,0]
[null,null,46,{"$f":"IF('1) MSA Type 1'!V86<>\"\",'1) MSA Type 1'!V86,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,46,0,0,0,0]
[null,null,47,{"$f":"IF('1) MSA Type 1'!V87<>\"\",'1) MSA Type 1'!V87,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,47,0,0,0,0]
[null,null,48,{"$f":"IF('1) MSA Type 1'!V88<>\"\",'1) MSA Type 1'!V88,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,48,0,0,0,0]
[null,null,49,{"$f":"IF('1) MSA Type 1'!V89<>\"\",'1) MSA Type 1'!V89,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,49,0,0,0,0]
[null,null,50,{"$f":"IF('1) MSA Type 1'!V90<>\"\",'1) MSA Type 1'!V90,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,50,0,0,0,0]
[null,null,51,{"$f":"IF('1) MSA Type 1'!V91<>\"\",'1) MSA Type 1'!V91,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,51,0,0,0,0]
[null,null,52,{"$f":"IF('1) MSA Type 1'!V92<>\"\",'1) MSA Type 1'!V92,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,52,0,0,0,0]
[null,null,53,{"$f":"IF('1) MSA Type 1'!V93<>\"\",'1) MSA Type 1'!V93,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,53,0,0,0,0]
[null,null,54,{"$f":"IF('1) MSA Type 1'!V94<>\"\",'1) MSA Type 1'!V94,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,54,0,0,0,0]
[null,null,55,{"$f":"IF('1) MSA Type 1'!V95<>\"\",'1) MSA Type 1'!V95,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,55,0,0,0,0]
[null,null,56,{"$f":"IF('1) MSA Type 1'!V96<>\"\",'1) MSA Type 1'!V96,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,56,0,0,0,0]
[null,null,57,{"$f":"IF('1) MSA Type 1'!V97<>\"\",'1) MSA Type 1'!V97,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,57,0,0,0,0]
[null,null,58,{"$f":"IF('1) MSA Type 1'!V98<>\"\",'1) MSA Type 1'!V98,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,58,0,0,0,0]
[null,null,59,{"$f":"IF('1) MSA Type 1'!V99<>\"\",'1) MSA Type 1'!V99,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,59,0,0,0,0]
[null,null,60,{"$f":"IF('1) MSA Type 1'!V100<>\"\",'1) MSA Type 1'!V100,\"\")","v":""},"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,60,0,0,0,0]

{"sheet":"16) MSA Average Range","index":9,"n_rows":108,"n_cols":65,"rows_kept":108,"cut":false,"hidden":true,"merged":[[64,18,64,19],[62,18,62,19],[54,18,54,19],[52,18,52,19],[52,24,52,25],[56,18,56,19],[56,24,56,25],[58,18,58,19],[54,24,54,25],[106,28,106,34],[106,35,106,41],[34,14,34,27],[74,14,78,14],[79,14,83,14],[87,14,88,14],[87,15,87,16],[87,17,87,18],[87,19,87,20],[88,15,88,16],[88,17,88,18],[88,19,88,20],[67,14,68,14],[67,15,68,15],[38,18,38,19],[44,24,44,25],[106,14,106,20],[106,21,106,27],[67,26,67,27],[90,14,90,25],[91,14,91,25],[36,18,36,19],[69,14,73,14],[58,24,58,25],[60,24,60,25],[64,24,64,25],[50,24,50,25],[40,18,40,19],[40,24,40,25],[42,18,42,19],[42,24,42,25],[44,18,44,19],[46,18,46,19],[48,18,48,19],[38,24,38,25],[60,18,60,19],[50,18,50,19]]}
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(\"Sheet specific INFORMATION\")","v":"SHEET SPECIFIC INFORMATION"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSA Variable Type 2\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ref. No."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reference Value",null,null,null,null,null,null,"Date Preformed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specification Number",null,null,null,null,null,null,"Gage Name"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Name",null,null,null,null,null,null,"Gage Number"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Characteristic Type",null,null,null,null,null,null,"Gage Type"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TPS No."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known sigma"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - LSL",null,null,null,null,null,null,"Appraiser A"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," - USL",null,null,null,null,null,null,"Appraiser B"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resolution",null,null,null,null,null,null,"Appraiser C"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of Trails",null,null,null,{"$f":"IF(Q70<>\"\",COUNT(Q70:Q72),\"\")","v":3},null,null,"Approved Date"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of Parts",null,null,null,{"$f":"IF(Q70<>\"\",COUNT(Q70:Z70),\"\")","v":10},null,null,"Approved By Id",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"squared","/nr","/nkr","/kr",null,null,"squared","/r"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x.1.",{"$f":"SUM(Q70:Z72)","v":5.7099999999999991},{"$f":"AS60*AS60","v":32.604099999999988},{"$f":"AT60/AS64","v":1.0868033333333329},null,null,"x11.",{"$f":"SUM(Q70:Q72)","v":1.3399999999999999},{"$f":"AY60*AY60","v":1.7955999999999996},{"$f":"AZ60/S57","v":0.59853333333333325},null,"Squared","Part 1","Part 2","Part 3","Part 4","Part 5","Part 6","Part 7","Part 8","Part 9","Part 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No. of Appraisers",null,null,null,{"$f":"IF(Q70<>\"\",COUNT(Q70,Q75,Q80),\"\")","v":3},null,null,"Approved Name",null,null,{"$f":"IFERROR(VLOOKUP(Y59,#REF!,2,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x.2.",{"$f":"SUM(Q75:Z77)","v":2.0499999999999998},{"$f":"AS61*AS61","v":4.2024999999999997},{"$f":"AT61/AS64","v":0.14008333333333331},null,null,"x21.",{"$f":"SUM(R70:R72)","v":-1.8200000000000003},3.3124000000000011,{"$f":"AZ61/S57","v":1.1041333333333336},"Appr A","Trial 1",{"$f":"Q70*Q70","v":8.4099999999999994E-2},{"$f":"R70*R70","v":0.31360000000000005},1.7956000000000003,0.22089999999999999,0.64000000000000012,4.0000000000000002E-4,0.34809999999999997,9.6100000000000005E-2,5.1075999999999988,1.8496000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x.3.",{"$f":"SUM(Q80:Z82)","v":-7.63},{"$f":"AS62*AS62","v":58.216899999999995},{"$f":"AT62/AS64","v":1.9405633333333332},null,null,"x31.",{"$f":"SUM(S70:S72)","v":3.78},14.288399999999999,{"$f":"AZ62/S57","v":4.7627999999999995},null,"Trial 2",{"$f":"Q71*Q71","v":0.16809999999999997},0.46240000000000009,1.3688999999999998,0.25,0.84640000000000004,1.21E-2,0.5625,4.0000000000000008E-2,3.9601000000000002,1.5625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Known proces variation",null,null,null,null,null,null,"Approved Function",null,null,{"$f":"IFERROR(VLOOKUP(Y59,#REF!,4,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x…",{"$f":"SUM(AS60:AS62)","v":0.12999999999999901},{"$f":"AS63*AS63","v":1.6899999999999742E-2},null,{"$f":"AT63/AS65","v":1.8777777777777491E-4},null,"x41.",{"$f":"SUM(T70:T72)","v":1.6099999999999999},2.5920999999999994,{"$f":"AZ63/S57","v":0.8640333333333331},null,"Trial 3",{"$f":"Q72*Q72","v":0.40960000000000002},0.33639999999999998,1.6129,0.40960000000000002,0.70559999999999989,4.4099999999999993E-2,0.43560000000000004,2.8900000000000006E-2,4.0400999999999989,1.7161000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nr",{"$f":"S57*S59","v":30},null,null,null,null,"x51.",{"$f":"SUM(U70:U72)","v":-2.56},6.5536000000000003,{"$f":"AZ64/S57","v":2.1845333333333334},"Appr B","Trial 1",{"$f":"Q75*Q75","v":6.4000000000000003E-3},{"$f":"R75*R75","v":0.22089999999999999},1.4160999999999999,1E-4,0.31360000000000005,4.0000000000000008E-2,0.22089999999999999,0.39690000000000003,3.24,2.8223999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Use",null,null,null,null,null,null,"Approved Company",null,null,{"$f":"IFERROR(VLOOKUP(Y59,#REF!,5,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nkr",{"$f":"S57*S59*S61","v":90},null,null,null,null,"x61.",{"$f":"SUM(V70:V72)","v":-0.3},0.09,{"$f":"AZ65/S57","v":0.03},null,"Trial 2",{"$f":"Q76*Q76","v":6.25E-2},1.4883999999999999,0.88359999999999994,1.0609,1.44,4.8399999999999999E-2,0.30250000000000005,6.4000000000000003E-3,4.4944000000000006,2.6244000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(S51>S53,S53<>\"\"),\"LSL is > USL\",\"\")","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,"kr",{"$f":"S57*S61","v":9},null,null,null,null,"x71.",{"$f":"SUM(W70:W72)","v":2},4,{"$f":"AZ66/S57","v":1.3333333333333333},null,"Trial 3",{"$f":"Q77*Q77","v":4.9000000000000007E-3},0.46240000000000009,1.7956000000000003,4.0000000000000008E-2,1.6384000000000001,3.5999999999999999E-3,0.68889999999999996,0.11560000000000002,4.7961,2.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x1..",{"$f":"SUM(Q70:Q72)+SUM(Q75:Q77)+SUM(Q80:Q82)","v":1.5199999999999998},{"$f":"AS67*AS67","v":2.3103999999999996},null,null,{"$f":"AT67/AS66","v":0.25671111111111106},"x81.",{"$f":"SUM(X70:X72)","v":-0.68},0.46240000000000009,{"$f":"AZ67/S57","v":0.15413333333333337},"Appr C","Trial 1",{"$f":"Q80*Q80","v":1.6000000000000001E-3},{"$f":"R80*R80","v":1.9043999999999996},0.77439999999999998,1.9600000000000003E-2,2.1315999999999997,8.4099999999999994E-2,4.0000000000000002E-4,0.21160000000000001,3.1329000000000002,2.2201]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Apprai-\nser","Trial","Part",null,null,null,null,null,null,null,null,null,"Average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x2..",{"$f":"SUM(R70:R72)+SUM(R75:R77)+SUM(R80:R82)","v":-7.66},58.675600000000003,null,null,{"$f":"AT68/AS66","v":6.519511111111111},"x91.",{"$f":"SUM(Y70:Y72)","v":6.26},39.187599999999996,{"$f":"AZ68/S57","v":13.062533333333333},null,"Trial 2",{"$f":"Q81*Q81","v":1.21E-2},1.2768999999999997,1.1881000000000002,4.0000000000000008E-2,1.1449,0.44890000000000008,1E-4,0.31360000000000005,2.1025,3.1329000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x3..",{"$f":"SUM(S70:S72)+SUM(S75:S77)+SUM(S80:S82)","v":9.89},97.812100000000015,null,null,{"$f":"AT69/AS66","v":10.868011111111112},"x101.",{"$f":"SUM(Z70:Z72)","v":-3.9200000000000004},15.366400000000002,{"$f":"AZ69/S57","v":5.1221333333333341},null,"Trial 3",{"$f":"Q82*Q82","v":2.2499999999999999E-2},0.92159999999999997,0.44890000000000008,1.21E-2,2.1025,0.24009999999999998,4.4099999999999993E-2,0.24009999999999998,3.4969000000000006,4.6656000000000004]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appariser A",1,0.28999999999999998,-0.56000000000000005,1.34,0.47,-0.8,0.02,0.59,-0.31,2.2599999999999998,-1.36,null,{"$f":"IF(Q70<>\"\",AVERAGE(Q70:Z70),\"\")","v":0.19399999999999998},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x4..",{"$f":"SUM(T70:T72)+SUM(T75:T77)+SUM(T80:T82)","v":3.3},10.889999999999999,null,null,{"$f":"AT70/AS66","v":1.21},"x12.",{"$f":"SUM(Q75:Q77)","v":0.4},0.16000000000000003,{"$f":"AZ70/S57","v":5.3333333333333344E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.41,-0.68,1.17,0.5,-0.92,-0.11,0.75,-0.2,1.99,-1.25,null,0.16600000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x5..",{"$f":"SUM(U70:U72)+SUM(U75:U77)+SUM(U80:U82)","v":-9.58},91.776399999999995,null,null,{"$f":"AT71/AS66","v":10.197377777777778},"x22.",{"$f":"SUM(R75:R77)","v":-2.37},5.6169000000000002,{"$f":"AZ71/S57","v":1.8723000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0.64,-0.57999999999999996,1.27,0.64,-0.84,-0.21,0.66,-0.17,2.0099999999999998,-1.31,null,0.21100000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x6..",{"$f":"SUM(V70:V72)+SUM(V75:V77)+SUM(V80:V82)","v":-1.67},2.7888999999999999,null,null,{"$f":"AT72/AS66","v":0.30987777777777775},"x32.",{"$f":"SUM(S75:S77)","v":3.4699999999999998},12.040899999999999,{"$f":"AZ72/S57","v":4.0136333333333329}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(Q70<>\"\",SUM(Q70:Q72)/COUNT(Q70:Q72),\"\")","v":0.4466666666666666},-0.6066666666666668,1.26,0.53666666666666663,-0.85333333333333339,-9.9999999999999992E-2,0.66666666666666663,-0.22666666666666668,2.0866666666666664,-1.3066666666666669,"xa=",0.19033333333333327,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x7..",{"$f":"SUM(W70:W72)+SUM(W75:W77)+SUM(W80:W82)","v":4.09},16.728099999999998,null,null,{"$f":"AT73/AS66","v":1.8586777777777774},"x42.",{"$f":"SUM(T75:T77)","v":1.24},1.5376000000000001,{"$f":"AZ73/S57","v":0.5125333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(Q70<>\"\",MAX(Q70:Q72)-MIN(Q70:Q72),\"\")","v":0.35000000000000003},0.12,0.17000000000000015,0.17000000000000004,0.12,0.22999999999999998,0.16000000000000003,0.13999999999999999,0.2699999999999998,0.1100000000000001,"ra=",0.184,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x8..",{"$f":"SUM(X70:X72)+SUM(X75:X77)+SUM(X80:X82)","v":-3.08},9.4863999999999997,null,null,{"$f":"AT74/AS66","v":1.0540444444444443},"x52.",{"$f":"SUM(U75:U77)","v":-3.04},9.2416,{"$f":"AZ74/S57","v":3.0805333333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appariser B",1,0.08,-0.47,1.19,0.01,-0.56000000000000005,-0.2,0.47,-0.63,1.8,-1.68,null,1.0000000000000009E-3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x9..",{"$f":"SUM(Y70:Y72)+SUM(Y75:Y77)+SUM(Y80:Y82)","v":17.46},304.85160000000002,null,null,{"$f":"AT75/AS66","v":33.872399999999999},"x62.",{"$f":"SUM(V75:V77)","v":7.9999999999999988E-2},6.3999999999999977E-3,{"$f":"AZ75/S57","v":2.1333333333333326E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0.25,-1.22,0.94,1.03,-1.2,0.22,0.55000000000000004,0.08,2.12,-1.62,null,0.11499999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x10..",{"$f":"SUM(Z70:Z72)+SUM(Z75:Z77)+SUM(Z80:Z82)","v":-14.14},199.93960000000001,null,null,{"$f":"AT76/AS66","v":22.215511111111113},"x72.",{"$f":"SUM(W75:W77)","v":1.85},3.4225000000000003,{"$f":"AZ76/S57","v":1.1408333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,7.0000000000000007E-2,-0.68,1.34,0.2,-1.28,0.06,0.83,-0.34,2.19,-1.5,null,8.8999999999999968E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x82.",{"$f":"SUM(X75:X77)","v":-0.89000000000000012},0.79210000000000025,{"$f":"AZ77/S57","v":0.2640333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(Q75<>\"\",SUM(Q75:Q77)/COUNT(Q75:Q77),\"\")","v":0.13333333333333333},-0.79,1.1566666666666665,0.41333333333333333,-1.0133333333333334,2.6666666666666661E-2,0.6166666666666667,-0.29666666666666669,2.0366666666666666,-1.5999999999999999,"xb=",6.8333333333333288E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x92.",{"$f":"SUM(Y75:Y77)","v":6.1099999999999994},37.33209999999999,{"$f":"AZ78/S57","v":12.44403333333333}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(Q75<>\"\",MAX(Q75:Q77)-MIN(Q75:Q77),\"\")","v":0.18},0.75,0.40000000000000013,1.02,0.72,0.42000000000000004,0.36,0.71,0.3899999999999999,0.17999999999999994,"rb=",0.51300000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x102.",{"$f":"SUM(Z75:Z77)","v":-4.8},23.04,{"$f":"AZ79/S57","v":7.68}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appariser C",1,0.04,-1.38,0.88,0.14000000000000001,-1.46,-0.28999999999999998,0.02,-0.46,1.77,-1.49,null,-0.22299999999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x13.",{"$f":"SUM(Q80:Q82)","v":-0.22},4.8399999999999999E-2,{"$f":"AZ80/S57","v":1.6133333333333333E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,-0.11,-1.1299999999999999,1.0900000000000001,0.2,-1.07,-0.67,0.01,-0.56000000000000005,1.45,-1.77,null,-0.25600000000000006,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x23.",{"$f":"SUM(R80:R82)","v":-3.4699999999999998},12.040899999999999,{"$f":"AZ81/S57","v":4.0136333333333329}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,-0.15,-0.96,0.67,0.11,-1.45,-0.49,0.21,-0.49,1.87,-2.16,null,-0.28399999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x33.",{"$f":"SUM(S80:S82)","v":2.64},6.9696000000000007,{"$f":"AZ82/S57","v":2.3232000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Avg.",{"$f":"IF(Q80<>\"\",SUM(Q80:Q82)/COUNT(Q80:Q82),\"\")","v":-7.3333333333333334E-2},-1.1566666666666665,0.88,0.15,-1.3266666666666669,-0.48333333333333334,0.08,-0.5033333333333333,1.6966666666666665,-1.8066666666666666,"xc=",{"$f":"IF(Q83<>\"\",AVERAGE(Q83:Z83),0)","v":-0.2543333333333333},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x43.",{"$f":"SUM(T80:T82)","v":0.45},0.20250000000000001,{"$f":"AZ83/S57","v":6.7500000000000004E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R",{"$f":"IF(Q80<>\"\",MAX(Q80:Q82)-MIN(Q80:Q82),\"\")","v":0.19},0.41999999999999993,0.42000000000000004,9.0000000000000011E-2,0.3899999999999999,0.38000000000000006,0.19999999999999998,0.10000000000000003,0.42000000000000015,0.67000000000000015,"rc=",{"$f":"IF(Q84<>\"\",AVERAGE(Q84:Z84),0)","v":0.32800000000000001},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x53.",{"$f":"SUM(U80:U82)","v":-3.9800000000000004},15.840400000000004,{"$f":"AZ84/S57","v":5.2801333333333345}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(Q70<>\"\",AVERAGE(Q86:Z86),)","v":1.4444444444443815E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x63.",{"$f":"SUM(V80:V82)","v":-1.45},2.1025,{"$f":"AZ85/S57","v":0.70083333333333331}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",null,{"$f":"IF(Q73<>\"\",SUM(Q73,Q78,Q83)/COUNT(Q73,Q78,Q83),\"\")","v":0.16888888888888887},-0.85111111111111126,1.0988888888888888,0.36666666666666664,-1.0644444444444445,-0.18555555555555556,0.45444444444444443,-0.34222222222222226,1.9399999999999997,-1.5711111111111109,"Rp=",{"$f":"IF(Q70<>\"\",MAX(Q86:Z86)-MIN(Q86:Z86),0)","v":3.5111111111111106},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x73.",{"$f":"SUM(W80:W82)","v":0.24},5.7599999999999998E-2,{"$f":"AZ86/S57","v":1.9199999999999998E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R bb",{"$f":"IFERROR((AB74+AB79+AB84)/S61,\"\")","v":0.34166666666666673},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x83.",{"$f":"SUM(X80:X82)","v":-1.51},2.2801,{"$f":"AZ87/S57","v":0.76003333333333334}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bias",{"$f":"+O70","v":"Appariser A"},null,{"$f":"+O75","v":"Appariser B"},null,{"$f":"+O80","v":"Appariser C"},null,null,"T:",{"$f":"IF(AND(S39<>\"\",AB85<>\"\",_xlfn.STDEV.S(Q70:Z72,Q75:Z77,Q80:Z82)<>\"\"),(AB85-S39)*SQRT((S61*S59*S57))/(_xlfn.STDEV.S(Q70:Z72,Q75:Z77,Q80:Z82)),\"\")","v":""},null,null,"Xbd",{"$f":"IF(S61=3,MAX(AB73,AB78,AB83)-MIN(AB73,AB78,AB83),ABS(AB73-AB78))","v":0.44466666666666654},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x93.",{"$f":"SUM(Y80:Y82)","v":5.09},25.908099999999997,{"$f":"AZ88/S57","v":8.6360333333333319}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AB73<>\"\",S39<>\"\"),AB73-S39,\"\")","v":""},null,{"$f":"IF(AND(AB78<>\"\",S39<>\"\"),AB78-S39,\"\")","v":""},null,{"$f":"IF(AND(AB83<>\"\",S39<>\"\"),AB83-S39,\"\")","v":""},null,null,"P-value: ",{"$f":"IF(AND(X88<>\"\",+(S61*S59*S57)>1),TDIST(ABS(X88),+(S61*S59*S57)-1,2),\"\")","v":""},null,null,"UCL R",{"$f":"IFERROR(AB87*AS96,)","v":0.88150000000000017},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSpool",{"$f":"IF(T95<>\"\",(T95+T94)/(AS65-S59-S61+1),\"\")","v":""},null,null,"x103.",{"$f":"SUM(Z80:Z82)","v":-5.42},29.3764,{"$f":"AZ89/S57","v":9.792133333333334}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q70<>\"\",IF(S59<5,\"Less than 5 parts, the statistical uncertainty decreases with increased number of parts\",\"\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q70<>\"\",IF(S57*S61<9,\"Less than 3 appraisers and / or 3 repetitions, the statistical uncertainty decreases with increased number of trials\",\"\"),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Measurement Unit Analysis",null,null,null,null,null,null,"% GRR to Total variation",null,null,null,null,null,null,"% GRR to Tollerance",null,null,null,null,null,null,"% GRR to Known sigma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Constants",null,null,null,null,null,"total","tol","sigma"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Repeatability - Equipment Variation (EV)",null,null,null,null,{"$f":"IFERROR(AB87*AS97,)","v":0.20185666666666671},null,"% Equipment Variation (%EV)",null,null,null,null,{"$f":"IFERROR(AX96,)","v":0.17512838684404364},null,"% Equipment Variation (%EV)",null,null,null,null,{"$f":"IFERROR(AY96,)","v":0},null,"% Equipment Variation (%EV)",null,null,null,null,{"$f":"IFERROR(AZ96,)","v":0},null,null,"D4",{"$f":"IF(S57=3,2.58,3.27)","v":2.58},null,{"$f":"(AB88*AS97)^2","v":6.9016053708871081E-2},{"$f":"T96^2/(S57*S59)","v":1.3582037959259266E-3},null,{"$f":"T96/T104","v":0.17512838684404364},{"$f":"6*T96/(ABS(S53-S51))","v":{"$error":"#DIV/0!"}},{"$f":"(T96)/(S49)","v":{"$error":"#DIV/0!"}}]
[null,"MSA AVERAGE RANGE",null,"r","r","r",null,null,null,null,"average","average","average",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K1",{"$f":"IF(S57=3,0.5908,0.8862)","v":0.59079999999999999},null,null,null,null,{"$f":"T98/T104","v":0.22566933343817727},{"$f":"6*T98/(ABS(S53-S51))","v":{"$error":"#DIV/0!"}},{"$f":"(T98)/(S49)","v":{"$error":"#DIV/0!"}}]
[null,null,"UCL r",{"$f":"'16) MSA Average Range'!O70","v":"Appariser A"},{"$f":"'16) MSA Average Range'!O75","v":"Appariser B"},{"$f":"'16) MSA Average Range'!O80","v":"Appariser C"},null,"UCL a","LCL a","avarage",{"$f":"'16) MSA Average Range'!O70","v":"Appariser A"},{"$f":"'16) MSA Average Range'!O75","v":"Appariser B"},{"$f":"'16) MSA Average Range'!O80","v":"Appariser C"},null,"Reproducibility - Appraiser variation (AV)",null,null,null,null,{"$f":"IFERROR(SQRT(ABS(AU96-AV96)),)","v":0.26011122604175535},null,"% Appraiser Variation (%AV)",null,null,null,null,{"$f":"IFERROR(AX97,)","v":0.22566933343817727},null,"% Appraiser Variation (%AV)",null,null,null,null,{"$f":"IFERROR(AY97,)","v":0},null,"% Appraiser Variation (%AV)",null,null,null,null,{"$f":"IFERROR(AZ97,)","v":0},null,null,"K2",{"$f":"IF(S61=3,0.5231,0.7071)","v":0.52310000000000001},null,{"$f":"T96^2","v":4.0746113877777795E-2},{"$f":"T98^2","v":6.7657849912945142E-2}]
[null,1,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!Q74","v":0.35000000000000003},{"$f":"'16) MSA Average Range'!Q79","v":0.18},{"$f":"'16) MSA Average Range'!Q84","v":0.19},{"$f":"B99","v":1},{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!Q73","v":0.4466666666666666},{"$f":"'16) MSA Average Range'!Q78","v":0.13333333333333333},{"$f":"'16) MSA Average Range'!Q83","v":-7.3333333333333334E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K3",{"$f":"IF(S59=10,0.3146,IF(S59=9,0.3249,IF(S59=8,0.3375,IF(S59=7,0.3534,IF(S59=6,0.3742,IF(S59=5,0.403,0.4467))))))","v":0.31459999999999999},null,null,null,null,{"$f":"T100/T104","v":0.28565118577213755},{"$f":"6*T100/(ABS(S53-S51))","v":{"$error":"#DIV/0!"}},{"$f":"(T100)/(S49)","v":{"$error":"#DIV/0!"}}]
[null,2,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!R74","v":0.12},{"$f":"'16) MSA Average Range'!R79","v":0.75},{"$f":"'16) MSA Average Range'!R84","v":0.41999999999999993},2,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!R73","v":-0.6066666666666668},{"$f":"'16) MSA Average Range'!R78","v":-0.79},{"$f":"'16) MSA Average Range'!R83","v":-1.1566666666666665},null,"Gage R & R",null,null,null,null,{"$f":"SQRT(ABS(AU98+AV98))","v":0.32924757218652795},null,"% Gage R & R Variation (%GRR)",null,null,null,null,{"$f":"IFERROR(AX99,)","v":0.28565118577213755},null,"% Gage R & R Variation (%GRR)",null,null,null,null,{"$f":"IFERROR(AY99,)","v":0},null,"% Gage R & R Variation (%GRR)",null,null,null,null,{"$f":"IFERROR(AZ99,)","v":0},null,null,"K3",{"$f":"IF(S59=10,0.3146,IF(S59=9,0.3249,IF(S59=8,0.3375,IF(S59=7,0.3534,IF(S59=6,0.3742,IF(S59=5,0.403,0.4467))))))","v":0.31459999999999999},null,null,null,null,{"$f":"T102/T104","v":0.95833365800590131},{"$f":"6*T102/(ABS(S53-S51))","v":{"$error":"#DIV/0!"}},{"$f":"(T102)/(S49)","v":{"$error":"#DIV/0!"}}]
[null,3,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!S74","v":0.17000000000000015},{"$f":"'16) MSA Average Range'!S79","v":0.40000000000000013},{"$f":"'16) MSA Average Range'!S84","v":0.42000000000000004},3,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!S73","v":1.26},{"$f":"'16) MSA Average Range'!S78","v":1.1566666666666665},{"$f":"'16) MSA Average Range'!S83","v":0.88},null,null,null,null,null,null,null,null,null,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":"T100^2","v":0.10840396379072294},{"$f":"T102^2","v":1.2201313413530859},null,{"$f":"T102/T100","v":3.3549087339352379}]
[null,4,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!T74","v":0.17000000000000004},{"$f":"'16) MSA Average Range'!T79","v":1.02},{"$f":"'16) MSA Average Range'!T84","v":9.0000000000000011E-2},4,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!T73","v":0.53666666666666663},{"$f":"'16) MSA Average Range'!T78","v":0.41333333333333333},{"$f":"'16) MSA Average Range'!T83","v":0.15},null,"Part Variation (PV)",null,null,null,null,{"$f":"IFERROR(AB86*AS99,)","v":1.1045955555555553},null,"% Part Variation (% PV)",null,null,null,null,{"$f":"IFERROR(AX100,)","v":0.95833365800590131},null,"% Part Variation (% PV)",null,null,null,null,{"$f":"IFERROR(AY100,)","v":0},null,"% Part Variation (% PV)",null,null,null,null,{"$f":"IFERROR(AZ100,)","v":0}]
[null,5,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!U74","v":0.12},{"$f":"'16) MSA Average Range'!U79","v":0.72},{"$f":"'16) MSA Average Range'!U84","v":0.3899999999999999},5,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!U73","v":-0.85333333333333339},{"$f":"'16) MSA Average Range'!U78","v":-1.0133333333333334},{"$f":"'16) MSA Average Range'!U83","v":-1.3266666666666669}]
[null,6,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!V74","v":0.22999999999999998},{"$f":"'16) MSA Average Range'!V79","v":0.42000000000000004},{"$f":"'16) MSA Average Range'!V84","v":0.38000000000000006},6,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!V73","v":-9.9999999999999992E-2},{"$f":"'16) MSA Average Range'!V78","v":2.6666666666666661E-2},{"$f":"'16) MSA Average Range'!V83","v":-0.48333333333333334},null,"Total Variation (TV)",null,null,null,null,{"$f":"SQRT(ABS(AU101+AV101))","v":1.1526210587802952},null,"Number of Distinct Characteristics",null,null,null,null,{"$f":"IFERROR(1.41*AX101,)","v":4.7304213148486856},null,"Number of Distinct Characteristics",null,null,null,null,{"$f":"IFERROR(1.41*AX101,)","v":4.7304213148486856},null,"Number of Distinct Characteristics",null,null,null,null,{"$f":"IFERROR(1.41*AX101,)","v":4.7304213148486856}]
[null,7,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!W74","v":0.16000000000000003},{"$f":"'16) MSA Average Range'!W79","v":0.36},{"$f":"'16) MSA Average Range'!W84","v":0.19999999999999998},7,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!W73","v":0.66666666666666663},{"$f":"'16) MSA Average Range'!W78","v":0.6166666666666667},{"$f":"'16) MSA Average Range'!W83","v":0.08}]
[null,8,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!X74","v":0.13999999999999999},{"$f":"'16) MSA Average Range'!X79","v":0.71},{"$f":"'16) MSA Average Range'!X84","v":0.10000000000000003},8,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!X73","v":-0.22666666666666668},{"$f":"'16) MSA Average Range'!X78","v":-0.29666666666666669},{"$f":"'16) MSA Average Range'!X83","v":-0.5033333333333333}]
[null,9,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!Y74","v":0.2699999999999998},{"$f":"'16) MSA Average Range'!Y79","v":0.3899999999999999},{"$f":"'16) MSA Average Range'!Y84","v":0.42000000000000015},9,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!Y73","v":2.0866666666666664},{"$f":"'16) MSA Average Range'!Y78","v":2.0366666666666666},{"$f":"'16) MSA Average Range'!Y83","v":1.6966666666666665},null,"RESULT",null,null,null,null,null,null,{"$f":"IF(AA100<>\"\",IF(AA100<0.1,\"MSA OK\",IF(AA100<0.3,\"Gage may be OK\",\"Gage needs improvement\")),\"\")","v":"Gage may be OK"},null,null,null,null,null,null,{"$f":"IF(AH100<>\"\",IF(AH100<0.1,\"MSA OK\",IF(AH100<0.3,\"Gage may be OK\",\"Gage needs improvement\")),\"\")","v":"MSA OK"},null,null,null,null,null,null,{"$f":"IF(AO100<>\"\",IF(AO100<0.1,\"MSA OK\",IF(AO100<0.3,\"Gage may be OK\",\"Gage needs improvement\")),\"\")","v":"MSA OK"}]
[null,10,{"$f":"+'16) MSA Average Range'!AB89","v":0.88150000000000017},{"$f":"'16) MSA Average Range'!Z74","v":0.1100000000000001},{"$f":"'16) MSA Average Range'!Z79","v":0.17999999999999994},{"$f":"'16) MSA Average Range'!Z84","v":0.67000000000000015},10,{"$f":"'16) MSA Average Range'!AB85+(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":0.4054271173402012},{"$f":"'16) MSA Average Range'!AB85-(3*_xlfn.STDEV.P('16) MSA Average Range'!AB74,'16) MSA Average Range'!AB84,'16) MSA Average Range'!AB79))","v":-0.40253822845131249},{"$f":"AVERAGE('16) MSA Average Range'!Q86:Z86)","v":1.4444444444443815E-3},{"$f":"'16) MSA Average Range'!Z73","v":-1.3066666666666669},{"$f":"'16) MSA Average Range'!Z78","v":-1.5999999999999999},{"$f":"'16) MSA Average Range'!Z83","v":-1.8066666666666666}]