{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["FLOW1","FLOW2","FLOW 3","PFMEA-1","PFMEA-2","CPLAN","DIMENSIONAL","MATERIAL","PERFORMANCE","APPEARANCE","GR&R ATT(Analytic)","Graph","GR&R ATT(Risk)","GR&R VAR(TV)","GR&R VAR(Tol)","GR&R ANOVA","Graphical","GR&R X&R","Gage R","TI PPC","Flexfab PSW","Instructions for Completing PSW","LISTS","Module1"],"not_rendered":{"charts":23,"images":5,"macros":1,"external_links":0,"defined_names":18,"comments":4,"pivot_tables":0},"unopened":[{"sheet":"Module1","index":23,"reason":"part_missing"}],"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":"FLOW1","index":0,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["PROCESS / INSPECTION FLOWCHART"]
[]
[null,"Product Program",null,null,null,null,null,null,"Issue Date",null,"ECL"]
[null,"Supplier Name",null,null,null,null,null,null,"Part Name"]
[null,"Supplier Location",null,null,null,null,null,null,"Part Number"]
[]
[]
[null,"Legend:"]
[]
[null,"     Operation",null,null,"   Transportation",null,null,"     Inspection",null,"Delay",null,"Storage"]
[]
[]
[null,null,null,"Operation or Event",null,null,null,"Description of",null,null,"Evaluation"]
[null,null,null,null,null,null,null,"Operation or Event",null,null,"and Analysis Methods"]

{"sheet":"FLOW2","index":1,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["PROCESS FLOW DIAGRAM"]
[]
["PART NUMBER:",null,null,null,null,null,null,"DATE:"]
["PART DESCRIPTION:",null,null,null,null,null,null,"ECL:"]
[null,null,null,null,null,null,null,"PREPARED BY:"]
[]
["STEP","FABRICATION","MOVE","STORE","INSPECT","OPERATION DESCRIPTION","ITEM #","PRODUCT AND PROCESS CHARACTERISTICS","ITEM #","CONTROL METHODS"]

{"sheet":"FLOW 3","index":2,"n_rows":23,"n_cols":22,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["PROCESS FLOW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"JOB #"]
["Part #",null,null,null,"ECL",null,null,null,"Process Responsibility",null,null,null,null,null,null,null,"Prepared By"]
[]
["Part Name",null,null,null,"Product Line",null,null,null,"Core Team",null,null,null,null,null,null,null,"Date (revised)"]
[]
["Component to",null,null,null,"Assembly Name",null,null,null,"Key Date",null,null,null,null,null,null,null,"Date (original)"]
[]
[]
["Process Flow Diagram",null,null,null,null,null,null,null,"Operation",null,null,null,"Potential Quality Problems",null,null,null,"Product Characteristics",null,null,null,"Process Characteristics"]
[]
["operation",null,"w/auto inspection"]
[]
["w/mult product streams"]
[]
["transportation",null,null,null,"storage"]
[]
["inspection"]
[]
["decision",null,null,"Delay"]
[]
["operator",null,null,"partial"]
[]
["rework"]

{"sheet":"PFMEA-1","index":3,"n_rows":49,"n_cols":17,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,12,2,15],[4,12,4,15],[6,12,6,15],[8,12,8,15],[2,3,2,4],[4,1,4,3],[6,2,6,3],[8,1,8,3],[4,6,4,9],[6,6,6,9],[10,0,14,0],[10,1,14,1],[10,2,14,2],[10,5,14,5],[10,12,11,16],[10,11,14,11],[12,12,14,12],[10,10,14,10]]}
[null,null,null,null,null,null,"      POTENTIAL"]
[null,null,null,null,null,null,"FAILURE MODE AND EFFECTS ANALYSIS"]
["Print #",null,"Rev.  ",null,null,null,"(PROCESS FMEA)",null,null,null,null,"FMEA Number:"]
[]
["Item:  ",null,null,null,null,"Process Responsibility:",null,null,null,null,null,"Prepared by:"]
[]
["Model Year(s)/Vehicle(s)  ",null,null,null,null,"Key Date",null,null,null,null,null,"Date (Orig.)"]
[]
["Core Team:",null,null,null,null,null,null,null,null,null,null,"Date (Rev.)"]
[]
["Process \nFunction/ \nRequire- \nments","Potential \nFailure \nMode","Potential \nEffect(s) \nof Failure",null,"C","Potential \nCauses(s)/ \nMechanism(s) \nof Failure","O","Current","D",null,"Recommended \nAction(s)","Responsibility \n& Target \nCompletion \nDate","Action Results"]
[null,null,null,"S","l",null,"c","Process","e","R."]
[null,null,null,"e","a",null,"c","Controls","t","P.",null,null,"Actions \nTaken","S","O","D","R."]
[null,null,null,"v","s",null,"u","     -Prevention","e","N.",null,null,null,"e","c","e","P."]
[null,null,null,null,"s",null,"r","   -Detection","c",null,null,null,null,"v","c","t","N."]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D16<>\"\",D16*G16*I16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N16<>\"\",N16*O16*P16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D17<>\"\",D17*G17*I17,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N17<>\"\",N17*O17*P17,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D33<>\"\",D33*G33*I33,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N33<>\"\",N33*O33*P33,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D44<>\"\",D44*G44*I44,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(N44<>\"\",N44*O44*P44,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]

{"sheet":"PFMEA-2","index":4,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[2,3,2,4],[4,1,4,3],[6,2,6,3],[10,8,14,8],[10,12,14,12],[4,6,4,10],[6,6,6,10],[10,0,14,0],[10,1,14,1],[10,2,14,2],[10,5,14,5],[10,13,11,17],[12,13,14,13],[10,11,14,11],[2,13,2,16],[4,13,4,16],[6,13,6,16],[8,13,8,16],[10,7,14,7]]}
[null,null,null,null,null,null,null,"      POTENTIAL"]
[null,null,null,null,null,null,null,"FAILURE MODE AND EFFECTS ANALYSIS"]
["Print #",null,"Rev.  ",null,null,null,null,"(PROCESS FMEA)",null,null,null,null,"FMEA Number:"]
[]
["Item:  ",null,null,null,null,"Process Responsibility",null,null,null,null,null,null,"Prepared by:"]
[]
["Model Year(s)/Vehicle(s)  ",null,null,null,null,"Key Date",null,null,null,null,null,null,"Date (Orig.)"]
[]
["Core Team:",null,null,null,null,null,null,null,null,null,null,null,"Date (Rev.)"]
[]
["Process \nFunction/ \nRequire- \nments","Potential \nFailure \nMode","Potential \nEffect(s) \nof Failure",null,"C","Potential \nCauses(s)/ \nMechanism(s) \nof Failure","O","Current\nProcess\nControls\nPrevention","Current\nProcess\nControls\nDetection","D",null,"Recommended \nAction(s)","Responsibility \n& Target \nCompletion \nDate","Action Results"]
[null,null,null,"S","l",null,"c",null,null,"e","R."]
[null,null,null,"e","a",null,"c",null,null,"t","P.",null,null,"Actions \nTaken","S","O","D","R."]
[null,null,null,"v","s",null,"u",null,null,"e","N.",null,null,null,"e","c","e","P."]
[null,null,null,null,"s",null,"r",null,null,"c",null,null,null,null,"v","c","t","N."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D16<>\"\",D16*G16*J16,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(O16<>\"\",O16*P16*Q16,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D17<>\"\",D17*G17*J17,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(O17<>\"\",O17*P17*Q17,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,""]

{"sheet":"CPLAN","index":5,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,0,14,0],[10,1,14,1],[13,10,14,10],[12,11,14,11],[10,3,11,5],[10,7,11,11],[9,2,9,3],[10,12,14,12],[3,9,3,10],[3,11,3,12],[10,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[10,6,14,6],[13,9,14,9]]}
[null,null,null,null,null,"CONTROL PLAN"]
[]
["Control Plan Number",null,null,null,"Key Contact/Phone",null,null,null,null,"Date (Orig.)",null,"Date (Rev.)"]
[null,null,null,null,null,null,null,null,null,"1996-01-01",null,"1996-01-01"]
["Part Number/Latest Change Level",null,null,null,"Core Team",null,null,null,null,"Customer Engineering Approval/Date (If Req'd.)"]
[]
["Part Name/Description",null,null,null,"Supplier/Plant Approval/Date",null,null,null,null,"Customer Quality Approval/Date (If Req'd.)"]
[]
["Supplier/Plant",null,"Supplier Code",null,"Other Approval/Date (If Req'd.)",null,null,null,null,"Other Approval/Date (If Req'd.)"]
[]
["PART/ \nPROCESS\nNUMBER","PROCESS NAME/\nOPERATION\nDESCRIPTION","MACHINE,\nDEVICE\nJIG, TOOLS\nFOR MFG.","CHARACTERISTICS",null,null,"SPECIAL\nCHAR.\nCLASS","METHODS",null,null,null,null,"REACTION\nPLAN"]
[]
[null,null,null,"NO.","PRODUCT","PROCESS",null,"PRODUCT/PROCESS","EVALUATION/","SAMPLE",null,"CONTROL\nMETHOD"]
[null,null,null,null,null,null,null,"SPECIFICATION/","MEASUREMENT","SIZE","FREQ."]
[null,null,null,null,null,null,null,"TOLERANCE","TECHNIQUE"]

{"sheet":"DIMENSIONAL","index":6,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[54,10,54,12],[52,8,52,19],[47,0,47,1],[47,2,47,5],[47,6,47,8],[47,9,47,10],[50,0,50,1],[50,2,50,5],[50,6,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,17],[49,11,49,12],[49,13,49,17],[48,0,48,1],[48,2,48,5],[49,0,49,1],[49,2,49,5],[49,6,49,8],[49,9,49,10],[48,6,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,17],[47,11,47,12],[47,13,47,17],[45,11,45,12],[45,13,45,17],[46,11,46,12],[46,13,46,17],[45,0,45,1],[45,2,45,5],[45,6,45,8],[45,9,45,10],[46,0,46,1],[46,2,46,5],[46,6,46,8],[46,9,46,10],[41,13,41,17],[42,11,42,12],[42,13,42,17],[44,11,44,12],[44,13,44,17],[41,0,41,1],[41,2,41,5],[41,6,41,8],[41,9,41,10],[43,11,43,12],[43,13,43,17],[42,0,42,1],[42,2,42,5],[42,6,42,8],[42,9,42,10],[43,0,43,1],[43,2,43,5],[44,0,44,1],[44,2,44,5],[44,6,44,8],[44,9,44,10],[43,6,43,8],[43,9,43,10],[41,11,41,12],[37,13,37,17],[38,11,38,12],[38,13,38,17],[40,11,40,12],[40,13,40,17],[37,0,37,1],[37,2,37,5],[37,6,37,8],[37,9,37,10],[39,11,39,12],[39,13,39,17],[38,0,38,1],[38,2,38,5],[38,6,38,8],[38,9,38,10],[39,0,39,1],[39,2,39,5],[40,0,40,1],[40,2,40,5],[40,6,40,8],[40,9,40,10],[39,6,39,8],[39,9,39,10],[37,11,37,12],[36,11,36,12],[36,13,36,17],[35,11,35,12],[35,13,35,17],[36,0,36,1],[36,2,36,5],[36,6,36,8],[36,9,36,10],[35,6,35,8],[35,9,35,10],[35,0,35,1],[35,2,35,5],[33,11,33,12],[33,13,33,17],[34,11,34,12],[34,13,34,17],[33,0,33,1],[33,2,33,5],[33,6,33,8],[33,9,33,10],[34,0,34,1],[34,2,34,5],[34,6,34,8],[34,9,34,10],[32,11,32,12],[32,13,32,17],[31,0,31,1],[31,2,31,5],[32,0,32,1],[32,2,32,5],[32,6,32,8],[32,9,32,10],[31,6,31,8],[31,9,31,10],[31,13,31,17],[31,11,31,12],[30,0,30,1],[30,2,30,5],[30,6,30,8],[30,9,30,10],[29,13,29,17],[30,11,30,12],[30,13,30,17],[29,0,29,1],[29,2,29,5],[29,6,29,8],[29,9,29,10],[29,11,29,12],[26,0,26,1],[26,2,26,5],[26,6,26,8],[22,0,22,1],[22,2,22,5],[22,6,22,8],[28,11,28,12],[28,13,28,17],[26,11,26,12],[26,13,26,17],[27,11,27,12],[27,13,27,17],[26,9,26,10],[27,0,27,1],[27,2,27,5],[27,6,27,8],[27,9,27,10],[28,0,28,1],[28,2,28,5],[28,6,28,8],[28,9,28,10],[25,0,25,1],[25,2,25,5],[25,6,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,17],[23,0,23,1],[23,2,23,5],[23,6,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,17],[24,0,24,1],[24,2,24,5],[24,6,24,8],[22,9,22,10],[20,11,20,12],[20,9,20,10],[24,9,24,10],[22,11,22,12],[20,13,20,17],[22,13,22,17],[24,11,24,12],[21,0,21,1],[21,2,21,5],[21,6,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,17],[20,0,20,1],[20,2,20,5],[20,6,20,8],[24,13,24,17],[16,13,16,17],[17,11,17,12],[17,13,17,17],[19,11,19,12],[19,13,19,17],[16,0,16,1],[16,2,16,5],[16,6,16,8],[16,9,16,10],[18,11,18,12],[18,13,18,17],[17,0,17,1],[17,2,17,5],[17,6,17,8],[17,9,17,10],[18,0,18,1],[18,2,18,5],[19,0,19,1],[19,2,19,5],[19,6,19,8],[19,9,19,10],[18,6,18,8],[18,9,18,10],[16,11,16,12],[12,13,12,17],[13,11,13,12],[13,13,13,17],[15,11,15,12],[15,13,15,17],[12,0,12,1],[12,2,12,5],[12,6,12,8],[12,9,12,10],[14,11,14,12],[14,13,14,17],[13,0,13,1],[13,2,13,5],[13,6,13,8],[13,9,13,10],[14,0,14,1],[14,2,14,5],[15,0,15,1],[15,2,15,5],[15,6,15,8],[15,9,15,10],[14,6,14,8],[14,9,14,10],[12,11,12,12],[10,11,10,12],[10,13,10,17],[3,3,3,10],[4,4,4,10],[8,18,9,18],[11,11,11,12],[11,13,11,17],[10,0,10,1],[10,2,10,5],[11,0,11,1],[11,2,11,5],[11,6,11,8],[11,9,11,10],[10,6,10,8],[10,9,10,10],[8,19,9,19],[8,11,9,12],[8,13,9,17],[3,14,3,19],[4,14,4,19],[5,17,5,19],[8,0,9,1],[8,2,9,5],[8,6,9,8],[8,9,9,10]]}
[null,null,null,null,null,null,null,"Production Part Approval"]
[null,null,null,null,null,null,null,"Dimensional Test Results"]
[]
["ORGANIZATION:",null,null,null,null,null,null,null,null,null,null,"PART NUMBER:"]
["SUPPLIER / VENDOR CODE:",null,null,null,null,null,null,null,null,null,null,"PART NAME:"]
["INSPECTION FACILITY:",null,null,null,null,null,null,null,null,null,null,"DESIGN RECORD CHANGE LEVEL:"]
[null,null,null,null,null,null,null,null,null,null,null,"ENGINEERING CHANGE DOCUMENTS:"]
[]
["ITEM",null,"DIMENSION / SPECIFICATION",null,null,null,"SPECIFICATION / LIMITS",null,null,"TEST DATE",null,"QTY. TESTED",null,"ORGANIZATION MEASUREMENT RESULTS (DATA)",null,null,null,null,"OK","NOT OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Blanket statements of conformance are unacceptable for any test results."]
[]
[null,null,null,null,null,null,null,null,null,null,"SIGNATURE",null,null,null,null,"TITLE",null,null,"DATE"]

{"sheet":"MATERIAL","index":7,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[50,11,50,12],[50,13,50,17],[52,8,52,19],[54,10,54,12],[50,6,50,8],[50,9,50,10],[50,0,50,5],[48,11,48,12],[48,13,48,17],[49,6,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,17],[48,0,48,5],[49,0,49,5],[48,6,48,8],[48,9,48,10],[47,6,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,17],[45,11,45,12],[45,13,45,17],[46,0,46,5],[47,0,47,5],[46,6,46,8],[46,9,46,10],[44,0,44,5],[45,0,45,5],[44,6,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,17],[45,6,45,8],[45,9,45,10],[46,11,46,12],[46,13,46,17],[42,0,42,5],[43,0,43,5],[42,6,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,17],[43,6,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,17],[40,0,40,5],[41,0,41,5],[40,6,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,17],[41,6,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,17],[38,0,38,5],[39,0,39,5],[38,6,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,17],[39,6,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,17],[36,0,36,5],[37,0,37,5],[36,6,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,17],[37,6,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,17],[34,0,34,5],[35,0,35,5],[34,6,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,17],[35,6,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,17],[32,0,32,5],[33,0,33,5],[32,6,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,17],[33,6,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,17],[30,0,30,5],[31,0,31,5],[30,6,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,17],[31,6,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,17],[28,0,28,5],[29,0,29,5],[28,6,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,17],[29,6,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,17],[26,0,26,5],[27,0,27,5],[26,6,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,17],[27,6,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,17],[24,0,24,5],[25,0,25,5],[24,6,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,17],[25,6,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,17],[22,0,22,5],[23,0,23,5],[22,6,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,17],[23,6,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,17],[20,0,20,5],[21,0,21,5],[20,6,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,17],[21,6,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,17],[18,0,18,5],[19,0,19,5],[18,6,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,17],[19,6,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,17],[16,0,16,5],[17,0,17,5],[16,6,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,17],[17,6,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,17],[14,0,14,5],[15,0,15,5],[14,6,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,17],[15,6,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,17],[12,0,12,5],[13,0,13,5],[12,6,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,17],[13,6,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,17],[10,0,10,5],[11,0,11,5],[10,6,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,17],[11,6,11,8],[11,9,11,10],[8,6,9,8],[8,9,9,10],[8,0,9,5],[11,11,11,12],[11,13,11,17],[3,14,3,19],[4,4,4,10],[4,14,4,19],[5,17,5,19],[3,3,3,10],[8,11,9,12],[8,13,9,17],[8,18,9,18],[8,19,9,19]]}
[null,null,null,null,null,null,null,"Production Part Approval"]
[null,null,null,null,null,null,null,"Material Test Results"]
[]
["ORGANIZATION:",null,null,null,null,null,null,null,null,null,null,"PART NUMBER:"]
["SUPPLIER / VENDOR CODE:",null,null,null,null,null,null,null,null,null,null,"PART NAME:"]
["MATERIAL SUPPLIER:",null,null,null,null,null,null,null,null,null,null,"DESIGN RECORD CHANGE LEVEL:"]
["*CUSTOMER SPECIFIED SUPPLIER / VENDOR CODE:",null,null,null,null,null,null,null,null,null,null,"ENGINEERING CHANGE DOCUMENTS:"]
["*If source approval is req'd, include the Supplier (Source) & Customer assigned code.",null,null,null,null,null,null,null,null,null,null,"NAME of LABORATORY:"]
["MATERIAL SPEC. NO. / REV / DATE",null,null,null,null,null,"SPECIFICATION / LIMITS",null,null,"TEST DATE",null,"QTY. TESTED",null,"SUPPLIER TEST RESULTS (DATA)",null,null,null,null,"OK","NOT OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Blanket statements of conformance are unacceptable for any test results."]
[]
[null,null,null,null,null,null,null,null,null,null,"SIGNATURE",null,null,null,null,"TITLE",null,null,"DATE"]

{"sheet":"PERFORMANCE","index":8,"n_rows":55,"n_cols":20,"rows_kept":55,"cut":false,"hidden":false,"merged":[[52,8,52,19],[54,10,54,12],[10,0,10,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[14,0,14,5],[15,0,15,5],[16,0,16,5],[17,0,17,5],[49,0,49,5],[50,0,50,5],[49,6,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,17],[50,6,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,17],[47,0,47,5],[48,0,48,5],[47,6,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,17],[48,6,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,17],[45,0,45,5],[46,0,46,5],[45,6,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,17],[46,6,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,17],[43,0,43,5],[44,0,44,5],[43,6,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,17],[44,6,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,17],[41,0,41,5],[42,0,42,5],[41,6,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,17],[42,6,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,17],[39,0,39,5],[40,0,40,5],[39,6,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,17],[40,6,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,17],[37,0,37,5],[38,0,38,5],[37,6,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,17],[38,6,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,17],[35,0,35,5],[36,0,36,5],[35,6,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,17],[36,6,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,17],[33,0,33,5],[34,0,34,5],[33,6,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,17],[34,6,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,17],[31,0,31,5],[32,0,32,5],[31,6,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,17],[32,6,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,17],[29,0,29,5],[30,0,30,5],[29,6,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,17],[30,6,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,17],[27,0,27,5],[28,0,28,5],[27,6,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,17],[28,6,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,17],[25,0,25,5],[26,0,26,5],[25,6,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,17],[26,6,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,17],[23,0,23,5],[24,0,24,5],[23,6,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,17],[24,6,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,17],[21,0,21,5],[22,0,22,5],[21,6,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,17],[22,6,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,17],[19,0,19,5],[20,0,20,5],[19,6,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,17],[20,6,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,17],[18,0,18,5],[17,6,17,8],[17,9,17,10],[15,11,15,12],[17,11,17,12],[17,13,17,17],[18,6,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,17],[15,13,15,17],[16,6,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,17],[15,6,15,8],[15,9,15,10],[13,11,13,12],[13,13,13,17],[14,6,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,17],[13,6,13,8],[13,9,13,10],[11,11,11,12],[11,13,11,17],[12,6,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,17],[11,6,11,8],[11,9,11,10],[8,18,9,18],[8,19,9,19],[10,6,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,17],[3,14,3,19],[4,4,4,10],[4,14,4,19],[5,17,5,19],[3,3,3,10],[8,0,9,5],[8,6,9,8],[8,9,9,10],[8,11,9,12],[8,13,9,17]]}
[null,null,null,null,null,null,null,"Production Part Approval"]
[null,null,null,null,null,null,null,"Performance Test Results"]
[]
["ORGANIZATION:",null,null,null,null,null,null,null,null,null,null,"PART NUMBER:"]
["SUPPLIER / VENDOR CODE:",null,null,null,null,null,null,null,null,null,null,"PART NAME:"]
["NAME of LABORATORY:",null,null,null,null,null,null,null,null,null,null,"DESIGN RECORD CHANGE LEVEL:"]
["*CUSTOMER SPECIFIED SUPPLIER / VENDOR CODE:",null,null,null,null,null,null,null,null,null,null,"ENGINEERING CHANGE DOCUMENTS:"]
["*If source approval is req'd, include the Supplier (Source) & Customer assigned code."]
["TEST SPECIFICATION / REV / DATE",null,null,null,null,null,"SPECIFICATION / LIMITS",null,null,"TEST DATE",null,"QTY. TESTED",null,"SUPPLIER TEST RESULTS (DATA)/ TEST CONDITIONS",null,null,null,null,"OK","NOT OK"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Blanket statements of conformance are unacceptable for any test results."]
[]
[null,null,null,null,null,null,null,null,null,null,"SIGNATURE",null,null,null,null,"TITLE",null,null,"DATE"]

{"sheet":"APPEARANCE","index":9,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,7,35,8],[35,9,35,11],[35,22,35,23],[20,20,20,21],[13,17,14,19],[15,17,16,19],[17,17,18,19]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"APPEARANCE APPROVAL REPORT"]
["PART",null,null,null,null,null,null,null,null,null,"DRAWING",null,null,null,null,null,null,null,"APPLICATION"]
["NUMBER",null,null,null,null,null,null,null,null,null,"NUMBER",null,null,null,null,null,null,null,"(VEHICLES)"]
["PART",null,null,null,null,null,null,null,null,null,"BUYER",null,null,null,null,"E/C LEVEL",null,null,null,null,"DATE"]
["NAME",null,null,null,null,null,null,null,null,null,"CODE"]
["ORGANIZATION",null,null,null,null,null,null,null,null,"MANUFACTURING",null,null,null,null,null,null,null,null,null,null,"SUPPLIER / VENDOR"]
["NAME",null,null,null,null,null,null,null,null,"LOCATION",null,null,null,null,null,null,null,null,null,null,"CODE"]
["REASON FOR",null,null,null,"PART SUBMISSION WARRANT",null,null,null,null,"SPECIAL SAMPLE",null,null,null,null,null,"RE-SUBMISSION",null,null,null,null,"OTHER"]
["SUBMISSION",null,null,null,"PRE TEXTURE",null,null,null,null,"FIRST PRODUCTION SHIPMENT",null,null,null,null,null,"ENGINEERING CHANGE"]
[null,null,null,null,null,null,null,null,null,null,null,"APPEARANCE EVALUATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  AUTHORIZED CUSTOMER"]
[null,null,null,null,null,"ORGANIZATION SOURCING AND TEXTURE INFORMATION",null,null,null,null,null,null,null,null,null,null,null,"   PRE-TEXTURE",null,null,"  REPRESENTATIVE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   EVALUATION",null,null,"  SIGNATURE AND DATE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORRECT AND PROCEED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CORRECT AND PROCEED"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APPROVED TO ETCH/TOOL/EDM"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"COLOR EVALUATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"METALLIC",null,"COLOR"]
["COLOR",null,null,"TRISTIMULUS DATA",null,null,"MASTER","MASTER","MATERIAL","MATERIAL","HUE",null,null,null,"VALUE",null,"CHROMA",null,"GLOSS",null,"BRILLIANCE",null,"SHIPPING","PART"]
["SUFFIX","DL*","Da*","Db*","DE*","CMC","NUMBER","DATE","TYPE","SOURCE","RED","YEL","GRN","BLU","LIGHT","DARK","GRAY","CLEAN","HIGH","LOW","HIGH","LOW","SUFFIX","DISPOSITION"]
[]
[]
[]
[]
[]
[]
[]
[]
["COMMENTS"]
[]
[]
["ORGANIZATION",null,null,null,null,null,null,"PHONE NO.",null,"DATE",null,null,"AUTHORIZED CUSTOMER",null,null,null,null,null,null,null,null,null,"DATE"]
["SIGNATURE",null,null,null,null,null,null,null,null,null,null,null,"REPRESENTATIVE SIGNATURE"]

{"sheet":"GR&R ATT(Analytic)","index":10,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["GAGE REPEATABILITY AND REPRODUCIBILITY REPORT"]
["ATTRIBUTE ANALYTICAL METHOD"]
[]
["Part Number",null,null,null,"Gage Name",null,null,"Appraiser"]
[]
["Part Name",null,null,null,"Gage Number",null,null,"Date Performed"]
[]
["Characteristic",null,null,null,"Gage Type",null,"Upper Limit",null,"Lower Limit"]
[]
[]
[]
["ATTRIBUTE DATA"]
["#","XT","a","P'a",null,"After entering data, follow the directions on the tab marked"]
[1,null,null,{"$f":"IF(AND(C14=0,C15=0),0,IF(AND(C14=0,C15<>0),0.025,IF(C14<10,(C14+0.5)/20,IF(C14=10,0.5,IF(AND(C14>10,C14<20),(C14-0.5)/20,IF(AND(C14=20,A14<>9),0.975,IF(AND(C14=20,A14=9),1,\"?\")))))))","v":0},null,"'Graph' to create the Gage Performance Curve"]
[2,null,null,{"$f":"IF(AND(C15=0,C16=0),0,IF(AND(C15=0,C16<>0),0.025,IF(C15<10,(C15+0.5)/20,IF(C15=10,0.5,IF(AND(C15>10,C15<20),(C15-0.5)/20,IF(AND(C15=20,A15<>9),0.975,IF(AND(C15=20,A15=9),1,\"?\")))))))","v":0}]
[3,null,null,0]
[4,null,null,0]
[5,null,null,0]
[6,null,null,0]
[7,null,null,0]
[8,null,null,0]
[9,null,null,0]
[]
[]
[null,"FROM THE GRAPH"]
[null,"ENTER THE FOLLOWING:"]
[null,"XT (P=.5) ="]
[null,"XT (P=.995) ="]
[null,"XT (P=.005) ="]
[]
[]
[]
[]
["Measurement Unit Analysis"]
["  Bias",null,null,null,null,"  Repeatability"]
[null,"B","=",{"$f":"IF(D27<>\"\",CONCATENATE(TEXT($I$9,\"0.0000\"),\" - (\",TEXT($D$27,\"0.000\"),\")\"),\"\")","v":""},null,"R","=",{"$f":"IF(D27<>\"\",CONCATENATE(\"(\",TEXT($D$28,\"0.0000\"),\" - (\",TEXT($D$29,\"0.0000\"),\")) / \",1.08),\"\")","v":""}]
[null,null,"=",{"$f":"IF(D27<>\"\",$I$9-$D$27,\"\")","v":""},null,null,"=",{"$f":"IF(D27<>\"\",($D$28-$D$29)/1.08,\"\")","v":""}]
[]
["  t Statistic"]
[null,"t","=","31.3 IBI / R",null,null,"t0.025,19","=",2.093]
[null,null,"=",{"$f":"IF(D27<>\"\",CONCATENATE(\"31.3 x \",TEXT(ABS($D$37),\"0.0000\"),\" / \",TEXT($H$37,\"0.0000\")),\"\")","v":""}]
[null,null,"=",{"$f":"IF(D27<>\"\",31.3*ABS($D$37)/$H$37,\"\")","v":""}]
[]
["  Result"]
[]
[null,{"$f":"IF(D27<>\"\",IF($D$42>$I$40,\"The bias is significantly different from zero, the gage FAILS\",\"The bias is insignificant from zero, the gage PASSES.\"),\"\")","v":""}]
[]
[]
[null,null,null,null,null,"Reviewed"]
[null,null,null,null,null,null,null,"Title"]

{"sheet":"Graph","index":11,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Directions for Gage Performance Curve for Attribute Analytical Method Form"]
[]
["1)  Click Tools - Data Analysis - Regression"]
["     (If Data Analysis is not available load Analysis Tool Pak from the Add-Ins menu)"]
["2)  In the box for Input Y Range select the cells GR&R ATT(L)!D14:D22"]
["3)  In the box for Input X Range select the cells GR&R ATT(L)!B14:B22"]
["4)  In the box for Output range select the cells below A23:M60"]
["5)  Check Line Fit Plots"]
["6)  Press OK"]
["7)  Copy the Line Fit plot graph to the space on the Analytic sheet"]
["8)  Change the graph title to Gage Performance Curve"]
["9)  Change the x axis to Xt"]
["10)  Change the y axis to Probability"]

{"sheet":"GR&R ATT(Risk)","index":12,"n_rows":123,"n_cols":25,"rows_kept":123,"cut":false,"hidden":false,"merged":[[116,2,116,4],[117,2,117,4],[118,2,118,4],[77,8,77,9],[81,8,81,9],[78,8,78,9],[80,6,80,7],[84,1,84,10],[89,6,89,7],[89,8,89,9],[100,6,100,7],[100,8,100,9],[88,1,91,1],[105,1,106,2],[105,6,105,7],[105,8,105,9],[76,1,79,1],[115,1,115,4],[77,6,77,7],[78,6,78,7],[93,6,93,7],[106,6,106,7],[111,7,111,8],[102,6,102,7],[102,8,102,9],[86,6,86,9],[87,6,87,7],[87,8,87,9],[80,1,81,2],[80,8,80,9],[76,6,76,7],[76,8,76,9],[74,10,75,10],[8,4,8,6],[0,0,0,12],[1,0,1,12],[72,1,72,10],[75,6,75,7],[75,8,75,9],[8,7,8,9],[10,0,10,12],[54,0,54,12],[74,6,74,9],[79,6,79,7],[79,8,79,9],[81,6,81,7],[99,6,99,9],[88,6,88,7],[88,8,88,9],[90,6,90,7],[90,8,90,9],[91,8,91,9],[91,6,91,7],[106,8,106,9],[104,6,104,7],[92,1,93,2],[92,6,92,7],[92,8,92,9],[93,8,93,9],[97,1,97,10],[104,8,104,9],[111,1,111,2],[109,5,109,6],[109,7,109,8],[110,5,110,6],[110,7,110,8],[111,5,111,6],[86,10,87,10],[99,10,100,10],[112,1,112,2],[109,3,109,4],[111,3,111,4],[112,3,112,4],[110,3,110,4],[109,1,109,2],[110,1,110,2],[101,1,104,1],[112,5,112,6],[112,7,112,8],[101,6,101,7],[101,8,101,9],[103,6,103,7],[103,8,103,9]]}
["GAGE REPEATABILITY AND REPRODUCIBILITY REPORT"]
["ATTRIBUTE RISK METHOD"]
[]
["Part Number",null,null,null,"Gage Name",null,null,"Date Performed",null,null,"Appraiser A"]
[]
["Part Name",null,null,null,"Gage Number",null,null,"Gage Type",null,null,"Appraiser B"]
[]
["Characteristic",null,null,null,"Upper Specification",null,null,"Lower Specification",null,null,"Appraiser C"]
[]
[]
["DATA TABLE",null,null,null,null,null,null,null,null,null,null,null,null,null,"AB Tabulation",null,null,null,"BC Tabulation",null,null,null,"AC Tabulation"]
["PART","A-1","A-2","A-3","B-1","B-2","B-3","C-1","C-2","C-3","Reference","Reference Value","Code",null,1,2,3,null,1,2,3,null,1,2,3]
[1,null,null,null,null,null,null,null,null,null,{"$f":"IF(L13<>\"\",IF(OR(L13<$H$9,L13>$E$9),0,1),\"\")","v":""},null,{"$f":"IF(B13<>\"\",IF(SUM(B13:J13)=9,\"+\",IF(SUM(B13:J13)=0,\"-\",\"x\")),\"\")","v":""},null,{"$f":"IF(B13<>\"\",IF(AND(B13=0,E13=0),\"a\",IF(AND(B13=1,E13=0),\"b\",IF(AND(B13=0,E13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C13<>\"\",IF(AND(C13=0,F13=0),\"a\",IF(AND(C13=1,F13=0),\"b\",IF(AND(C13=0,F13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D13<>\"\",IF(AND(D13=0,G13=0),\"a\",IF(AND(D13=1,G13=0),\"b\",IF(AND(D13=0,G13=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(E13<>\"\",IF(AND(E13=0,H13=0),\"a\",IF(AND(E13=1,H13=0),\"b\",IF(AND(E13=0,H13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(F13<>\"\",IF(AND(F13=0,I13=0),\"a\",IF(AND(F13=1,I13=0),\"b\",IF(AND(F13=0,I13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(G13<>\"\",IF(AND(G13=0,J13=0),\"a\",IF(AND(G13=1,J13=0),\"b\",IF(AND(G13=0,J13=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(B13<>\"\",IF(AND(B13=0,H13=0),\"a\",IF(AND(B13=1,H13=0),\"b\",IF(AND(B13=0,H13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C13<>\"\",IF(AND(C13=0,I13=0),\"a\",IF(AND(C13=1,I13=0),\"b\",IF(AND(C13=0,I13=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D13<>\"\",IF(AND(D13=0,J13=0),\"a\",IF(AND(D13=1,J13=0),\"b\",IF(AND(D13=0,J13=1),\"c\",\"d\"))),\"\")","v":""}]
[{"$f":"A13+1","v":2},null,null,null,null,null,null,null,null,null,{"$f":"IF(L14<>\"\",IF(OR(L14<$H$9,L14>$E$9),0,1),\"\")","v":""},null,{"$f":"IF(B14<>\"\",IF(SUM(B14:J14)=9,\"+\",IF(SUM(B14:J14)=0,\"-\",\"x\")),\"\")","v":""},null,{"$f":"IF(B14<>\"\",IF(AND(B14=0,E14=0),\"a\",IF(AND(B14=1,E14=0),\"b\",IF(AND(B14=0,E14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C14<>\"\",IF(AND(C14=0,F14=0),\"a\",IF(AND(C14=1,F14=0),\"b\",IF(AND(C14=0,F14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D14<>\"\",IF(AND(D14=0,G14=0),\"a\",IF(AND(D14=1,G14=0),\"b\",IF(AND(D14=0,G14=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(E14<>\"\",IF(AND(E14=0,H14=0),\"a\",IF(AND(E14=1,H14=0),\"b\",IF(AND(E14=0,H14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(F14<>\"\",IF(AND(F14=0,I14=0),\"a\",IF(AND(F14=1,I14=0),\"b\",IF(AND(F14=0,I14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(G14<>\"\",IF(AND(G14=0,J14=0),\"a\",IF(AND(G14=1,J14=0),\"b\",IF(AND(G14=0,J14=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(B14<>\"\",IF(AND(B14=0,H14=0),\"a\",IF(AND(B14=1,H14=0),\"b\",IF(AND(B14=0,H14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C14<>\"\",IF(AND(C14=0,I14=0),\"a\",IF(AND(C14=1,I14=0),\"b\",IF(AND(C14=0,I14=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D14<>\"\",IF(AND(D14=0,J14=0),\"a\",IF(AND(D14=1,J14=0),\"b\",IF(AND(D14=0,J14=1),\"c\",\"d\"))),\"\")","v":""}]
[{"$f":"A14+1","v":3},null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[4,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[5,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[6,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[7,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[8,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[9,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[10,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[11,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[12,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[13,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[14,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[15,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[16,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[17,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[18,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[19,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[20,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[21,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[22,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[23,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[24,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[25,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[26,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[27,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[28,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[29,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[30,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[31,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[32,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[33,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[34,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[35,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[36,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[37,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[38,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[39,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[40,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[]
[]
["DATA TABLE CONTINUED"]
["PART","A-1","A-2","A-3","B-1","B-2","B-3","C-1","C-2","C-3","Reference","Reference Value","Code"]
[{"$f":"A52+1","v":41},null,null,null,null,null,null,null,null,null,{"$f":"IF(L57<>\"\",IF(OR(L57<$H$9,L57>$E$9),0,1),\"\")","v":""},null,{"$f":"IF(B57<>\"\",IF(SUM(B57:J57)=9,\"+\",IF(SUM(B57:J57)=0,\"-\",\"x\")),\"\")","v":""},null,{"$f":"IF(B57<>\"\",IF(AND(B57=0,E57=0),\"a\",IF(AND(B57=1,E57=0),\"b\",IF(AND(B57=0,E57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C57<>\"\",IF(AND(C57=0,F57=0),\"a\",IF(AND(C57=1,F57=0),\"b\",IF(AND(C57=0,F57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D57<>\"\",IF(AND(D57=0,G57=0),\"a\",IF(AND(D57=1,G57=0),\"b\",IF(AND(D57=0,G57=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(E57<>\"\",IF(AND(E57=0,H57=0),\"a\",IF(AND(E57=1,H57=0),\"b\",IF(AND(E57=0,H57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(F57<>\"\",IF(AND(F57=0,I57=0),\"a\",IF(AND(F57=1,I57=0),\"b\",IF(AND(F57=0,I57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(G57<>\"\",IF(AND(G57=0,J57=0),\"a\",IF(AND(G57=1,J57=0),\"b\",IF(AND(G57=0,J57=1),\"c\",\"d\"))),\"\")","v":""},null,{"$f":"IF(B57<>\"\",IF(AND(B57=0,H57=0),\"a\",IF(AND(B57=1,H57=0),\"b\",IF(AND(B57=0,H57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(C57<>\"\",IF(AND(C57=0,I57=0),\"a\",IF(AND(C57=1,I57=0),\"b\",IF(AND(C57=0,I57=1),\"c\",\"d\"))),\"\")","v":""},{"$f":"IF(D57<>\"\",IF(AND(D57=0,J57=0),\"a\",IF(AND(D57=1,J57=0),\"b\",IF(AND(D57=0,J57=1),\"c\",\"d\"))),\"\")","v":""}]
[42,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[43,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[44,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[45,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[46,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[47,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[48,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[49,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[50,null,null,null,null,null,null,null,null,null,"",null,"",null,"","","",null,"","","",null,"","",""]
[]
[]
[]
[]
[null,"Risk Analysis"]
[]
[null,"A * B Crosstabulation"]
[]
[null,null,null,null,null,null,"B",null,null,null,"Total"]
[null,null,null,null,null,null,0,null,1]
[null,"A",0,"Count",null,null,{"$f":"COUNTIF($O$13:$Q$66,\"=a\")","v":0},null,{"$f":"COUNTIF($O$13:$Q$66,\"=c\")","v":0},null,{"$f":"SUM(G77:J77)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K81<>0,K77/K81*G81,\"\")","v":""},null,{"$f":"IF(K81<>0,K77/K81*I81,\"\")","v":""},null,{"$f":"IF(G78<>\"\",G78+I78,\"\")","v":""}]
[null,null,1,"Count",null,null,{"$f":"COUNTIF($O$13:$Q$66,\"=b\")","v":0},null,{"$f":"COUNTIF($O$13:$Q$66,\"=d\")","v":0},null,{"$f":"SUM(G79:J79)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K81<>0,K79/K81*G81,\"\")","v":""},null,{"$f":"IF(K81<>0,K79/K81*I81,\"\")","v":""},null,{"$f":"IF(G80<>\"\",G80+I80,\"\")","v":""}]
[null,"Total",null,"Count",null,null,{"$f":"G77+G79","v":0},null,{"$f":"I77+I79","v":0},null,{"$f":"K77+K79","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(G78<>\"\",G78+G80,\"\")","v":""},null,{"$f":"IF(I78<>\"\",I78+I80,\"\")","v":""},null,{"$f":"IF(K78<>\"\",K78+K80,\"\")","v":""}]
[]
[]
[null,"B * C Crosstabulation"]
[]
[null,null,null,null,null,null,"C",null,null,null,"Total"]
[null,null,null,null,null,null,0,null,1]
[null,"B",0,"Count",null,null,{"$f":"COUNTIF($S$13:$U$66,\"=a\")","v":0},null,{"$f":"COUNTIF($S$13:$U$66,\"=c\")","v":0},null,{"$f":"SUM(G89:J89)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K93<>0,K89/K93*G93,\"\")","v":""},null,{"$f":"IF(K93<>0,K89/K93*I93,\"\")","v":""},null,{"$f":"IF(G90<>\"\",G90+I90,\"\")","v":""}]
[null,null,1,"Count",null,null,{"$f":"COUNTIF($S$13:$U$66,\"=b\")","v":0},null,{"$f":"COUNTIF($S$13:$U$66,\"=d\")","v":0},null,{"$f":"SUM(G91:J91)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K93<>0,K91/K93*G93,\"\")","v":""},null,{"$f":"IF(K93<>0,K91/K93*I93,\"\")","v":""},null,{"$f":"IF(G92<>\"\",G92+I92,\"\")","v":""}]
[null,"Total",null,"Count",null,null,{"$f":"G89+G91","v":0},null,{"$f":"I89+I91","v":0},null,{"$f":"K89+K91","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(G90<>\"\",G90+G92,\"\")","v":""},null,{"$f":"IF(I90<>\"\",I90+I92,\"\")","v":""},null,{"$f":"IF(K90<>\"\",K90+K92,\"\")","v":""}]
[]
[]
[]
[null,"A * C Crosstabulation"]
[]
[null,null,null,null,null,null,"C",null,null,null,"Total"]
[null,null,null,null,null,null,0,null,1]
[null,"A",0,"Count",null,null,{"$f":"COUNTIF($W$13:$Y$66,\"=a\")","v":0},null,{"$f":"COUNTIF($W$13:$Y$66,\"=c\")","v":0},null,{"$f":"SUM(G102:J102)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K106<>0,K102/K106*G106,\"\")","v":""},null,{"$f":"IF(K106<>0,K102/K106*I106,\"\")","v":""},null,{"$f":"IF(G103<>\"\",G103+I103,\"\")","v":""}]
[null,null,1,"Count",null,null,{"$f":"COUNTIF($W$13:$Y$66,\"=b\")","v":0},null,{"$f":"COUNTIF($W$13:$Y$66,\"=d\")","v":0},null,{"$f":"SUM(G104:J104)","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(K106<>0,K104/K106*G106,\"\")","v":""},null,{"$f":"IF(K106<>0,K104/K106*I106,\"\")","v":""},null,{"$f":"IF(G105<>\"\",G105+I105,\"\")","v":""}]
[null,"Total",null,"Count",null,null,{"$f":"G102+G104","v":0},null,{"$f":"I102+I104","v":0},null,{"$f":"K102+K104","v":0}]
[null,null,null,"Expected Count",null,null,{"$f":"IF(G103<>\"\",G103+G105,\"\")","v":""},null,{"$f":"IF(I103<>\"\",I103+I105,\"\")","v":""},null,{"$f":"IF(K103<>\"\",K103+K105,\"\")","v":""}]
[]
[]
[null,"Kappa",null,"A",null,"B",null,"C"]
[null,"A",null,"-",null,{"$f":"IF(G81<>0,((G77+I79)/K81-(G78+I80)/K82)/(1-(G78+I80)/K82),\"\")","v":""},null,{"$f":"IF(G106<>0,((G102+I104)/K106-(G103+I105)/K107)/(1-(G103+I105)/K107),\"\")","v":""}]
[null,"B",null,{"$f":"F111","v":""},null,"-",null,{"$f":"IF(G93<>0,((G89+I91)/K93-(G90+I92)/K94)/(1-(G90+I92)/K94),\"\")","v":""}]
[null,"C",null,{"$f":"H111","v":""},null,{"$f":"H112","v":""},null,"-"]
[]
[]
[null,"DETERMINATION"]
[null,"A x B",{"$f":"IF(F111<>\"\",IF(F111>0.7,\"Good Agreement\",IF(F111<0.4,\"Poor Agreement\",\"Some Agreement\")),\"\")","v":""}]
[null,"A x C",{"$f":"IF(H112<>\"\",IF(H111>0.7,\"Good Agreement\",IF(H111<0.4,\"Poor Agreement\",\"Some Agreement\")),\"\")","v":""}]
[null,"B x C",{"$f":"IF(F113<>\"\",IF(F113>0.7,\"Good Agreement\",IF(F113<0.4,\"Poor Agreement\",\"Some Agreement\")),\"\")","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,"Approved for Use",null,null,null,"Date"]

{"sheet":"GR&R VAR(TV)","index":13,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,21,35,24]]}
["GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,"GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET"]
["VARIABLE DATA RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE DATA RESULTS"]
[]
["Part Number",null,null,null,null,"Gage Name",null,null,null,"Appraiser A",null,null,null,null,"Part Number",null,null,"Gage Name",null,null,null,"Appraiser A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F5<>\"\",F5,\"\")","v":""},null,null,null,{"$f":"IF(J5<>\"\",J5,\"\")","v":""}]
["Part Name",null,null,null,null,"Gage Number",null,null,null,"Appraiser B",null,null,null,null,"Part Name",null,null,"Gage Number",null,null,null,"Appraiser B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F7<>\"\",F7,\"\")","v":""},null,null,null,{"$f":"IF(J7<>\"\",J7,\"\")","v":""}]
["Characteristic",null,null,"Specification",null,"Gage Type",null,null,null,"Appraiser C",null,null,null,null,"Characteristic",null,null,"Gage Type",null,null,null,"Appraiser C"]
[null,null,null,"Lower","Upper",null,null,null,null,null,null,null,null,null,{"$f":"IF(A9<>\"\",A9,\"\")","v":""},null,null,{"$f":"IF(F9<>\"\",F9,\"\")","v":""},null,null,null,{"$f":"IF(J9<>\"\",J9,\"\")","v":""}]
["Characteristic Classification",null,null,null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed",null,null,"Characteristic Classification",null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed"]
[null,null,null,null,null,{"$f":"IF(C15<>\"\",COUNT(C15:C17),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15:L15),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15,C20,C25),\"\")","v":""},null,null,null,null,{"$f":"IF(A11<>\"\",A11,\"\")","v":""},null,null,{"$f":"F11","v":""},null,{"$f":"H11","v":""},null,{"$f":"J11","v":""},null,{"$f":"IF(L11<>\"\",L11,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(D9>E9,\"ENTER LOWER TOLERANCE IN D9\",\"\")","v":""},{"$f":"IF(C15<>\"\",IF(F11*H11*J11<90,\"DERIVED RESULTS MAY NOT BE STATISTICALLY SOUND\",\"\"),\"\")","v":""}]
["APPRAISER/",null,"PART",null,null,null,null,null,null,null,null,null,"AVERAGE",null,null,null,null,"Measurement Unit Analysis",null,null,null,"% Total Variation (TV)"]
["TRIAL #",null,1,2,3,4,5,6,7,8,9,10,null,null,"  Repeatability - Equipment Variation (EV)"]
["1.  A",1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15<>\"\",AVERAGE(C15:L15),\"\")","v":""},"EV","=","R  x  K1",null,null,"Trials","K1","% EV","=","100 (EV/TV)"]
[2,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(TEXT($N$32,\"0.000\"),\" x \",CHOOSE($F$11,0,U16,U17)),\"\")","v":""},null,null,2,0.88649999999999995,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$17,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[{"$f":"A16+1","v":3},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",$N$32*(CHOOSE($F$11,0,U16,U17)),\"\")","v":""},null,null,3,0.5907,null,"=",{"$f":"IF(C15<>\"\",100*($Q$17/$Q$35),\"\")","v":""}]
[{"$f":"A17+1","v":4},"AVE",{"$f":"IF(C15<>\"\",SUM(C15:C17)/COUNT(C15:C17),\"\")","v":""},"","","","","","","","","","xa=","","  Reproducibility - Appraiser Variation (AV)"]
[{"$f":"A18+1","v":5},"R",{"$f":"IF(C15<>\"\",MAX(C15:C17)-MIN(C15:C17),\"\")","v":""},"","","","","","","","","","ra=","","AV","=","{(xDIFF x K2)2 - (EV2/nr)}1/2",null,null,null,null,"% AV","=","100 (AV/TV)"]
["6.  B",1,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"{(\",TEXT($N$33,\"0.00\"),\" x \",CHOOSE($J$11,0,T23,U23),\")^2 - (\",TEXT($Q$17,\"0.00\"),\" ^2/(\",$H$11,\" x \",$F$11,\"))}^1/2\"),\"\")","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$21,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[7,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15=\"\",\"\",IF(($N$33*CHOOSE($J$11,0,T23,U23))^2-$Q$17^2/($H$11*$F$11)<0,0,(($N$33*CHOOSE($J$11,0,T23,U23))^2-$Q$17^2/($H$11*$F$11))^(1/2)))","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",100*($Q$21/$Q$35),\"\")","v":""}]
[{"$f":"A21+1","v":8},3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"Appraisers",2,3]
[{"$f":"A22+1","v":9},"AVE",{"$f":"IF(C20<>\"\",SUM(C20:C22)/COUNT(C20:C22),\"\")","v":""},"","","","","","","","","","xb=","","           n = parts        r = trials",null,null,null,"K2",0.7087,0.52359999999999995]
[{"$f":"A23+1","v":10},"R",{"$f":"IF(C20<>\"\",MAX(C20:C22)-MIN(C20:C22),\"\")","v":""},"","","","","","","","","","rb=","","  Repeatability & Reproducibility (GRR)",null,null,null,null,null,null,"% GRR","=","100 (GRR/TV)"]
["11.  C",1,null,null,null,null,null,null,null,null,null,null,null,"","GRR","=","{(EV2 + AV2)}1/2",null,null,"Parts","K3",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$27,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[12,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"{(\",TEXT($Q$17,\"0.000\"),\"^2 + \",TEXT($Q$21,\"0.000\"),\"^2)}^1/2\"),\"\")","v":""},null,null,2,0.7087,null,"=",{"$f":"IF(C15<>\"\",100*($Q$27/$Q$35),\"\")","v":""}]
[{"$f":"A26+1","v":13},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",($Q$17^2+$Q$21^2)^(1/2),\"\")","v":""},null,null,3,0.52359999999999995,{"$f":"IF(C16<>\"\",IF(X26<10,\"Gage system O.K\",IF(X26<30,\"Gage system may be acceptable\",\"Gage system needs improvement\")),\"\")","v":""}]
[{"$f":"A27+1","v":14},"AVE",{"$f":"IF(C25<>\"\",SUM(C25:C27)/COUNT(C25:C27),\"\")","v":""},"","","","","","","","","","xc=","","  Part Variation (PV)",null,null,null,null,4,0.44640000000000002]
[{"$f":"A28+1","v":15},"R",{"$f":"IF(C25<>\"\",MAX(C25:C27)-MIN(C25:C27),\"\")","v":""},"","","","","","","","","","rc=","","PV","=","RP x K3",null,null,5,0.4032,"% PV","=","100 (PV/TV)"]
["16. PART ",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(C15<>\"\",AVERAGE(C31:L31),\"\")","v":""},null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(TEXT($N$31,\"0.000\"),\" x \",CHOOSE($H$11,0,U26,U27,U28,U29,U30,U31,U32,U33,U34)),\"\")","v":""},null,null,6,0.3745,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$31,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
["   AVERAGE",null,{"$f":"IF(C18<>\"\",SUM(C18,C23,C28)/COUNT(C18,C23,C28),\"\")","v":""},{"$f":"IF(D18<>\"\",SUM(D18,D23,D28)/COUNT(D18,D23,D28),\"\")","v":""},"","","","","","","","","Rp=",{"$f":"IF(C15<>\"\",MAX(C31:L31)-MIN(C31:L31),\"\")","v":""},null,"=",{"$f":"IF(C15<>\"\",$N$31*CHOOSE($H$11,0,U26,U27,U28,U29,U30,U31,U32,U33,U34),\"\")","v":""},null,null,7,0.35339999999999999,null,"=",{"$f":"IF(C15<>\"\",100*($Q$31/$Q$35),\"\")","v":""}]
[{"$f":"A29+2","v":17},"(ra + rb + rc) / (# OF APPRAISERS) =",null,null,null,null,null,null,null,null,null,null,"R=",{"$f":"IF(C15<>\"\",SUM(N19,N24,N29)/COUNT(C15,C20,C25),\"\")","v":""},"  Total Variation (TV)",null,null,null,null,8,0.33779999999999999]
[{"$f":"A32+1","v":18},"xDIFF = (Max x - Min x) =",null,null,null,null,null,null,null,null,null,null,"xDIFF=",{"$f":"IF(C15<>\"\",MAX(N18,N23,N28)-MIN(N18,N23,N28),\"\")","v":""},"TV","=","{(GRR2 + PV2)}1/2",null,null,9,0.32469999999999999,"ndc","=","1.41(PV/GRR)"]
[{"$f":"A33+1","v":19},"* UCLR = R x D4 =",null,null,{"$f":"IF(C15=\"\",\"\",IF(OR(G34<>\"\",H34<>\"\",I34<>\"\"),\"APPRAISER\",\"\"))","v":""},null,{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C19<>\"\",$C19>$N$34),AND($D19<>\"\",$D19>$N$34),AND($E19<>\"\",$E19>$N$34),AND($F19<>\"\",$F19>$N$34),AND($G19<>\"\",$G19>$N$34),AND($H19<>\"\",$H19>$N$34),AND($I19<>\"\",$I19>$N$34),AND($J19<>\"\",$J19>$N$34),AND($K19<>\"\",$K19>$N$34),AND($L19<>\"\",$L19>$N$34)),\"A\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C24<>\"\",$C24>$N$34),AND($D24<>\"\",$D24>$N$34),AND($E24<>\"\",$E24>$N$34),AND($F24<>\"\",$F24>$N$34),AND($G24<>\"\",$G24>$N$34),AND($H24<>\"\",$H24>$N$34),AND($I24<>\"\",$I24>$N$34),AND($J24<>\"\",$J24>$N$34),AND($K24<>\"\",$K24>$N$34),AND($L24<>\"\",$L24>$N$34)),\"B\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C29<>\"\",$C29>$N$34),AND($D29<>\"\",$D29>$N$34),AND($E29<>\"\",$E29>$N$34),AND($F29<>\"\",$F29>$N$34),AND($G29<>\"\",$G29>$N$34),AND($H29<>\"\",$H29>$N$34),AND($I29<>\"\",$I29>$N$34),AND($J29<>\"\",$J29>$N$34),AND($K29<>\"\",$K29>$N$34),AND($L29<>\"\",$L29>$N$34)),\"C\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(G34<>\"\",H34<>\"\",I34<>\"\"),\"OUT OF CONTROL\",\"\"))","v":""},null,null,"UCLR=",{"$f":"IF(C15<>\"\",IF(F11=3,2.58*N32,3.27*N32),\"\")","v":""},null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"{(\",TEXT($Q$27,\"0.000\"),\"^2 + \",TEXT($Q$31,\"0.000\"),\"^2)}^1/2\"),\"\")","v":""},null,null,10,0.3145,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"1.41(\",TEXT($Q$31,\"0.000\"),\"/\",TEXT($Q$27,\"0.000\"),\")\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",($Q$27^2+$Q$31^2)^(1/2),\"\")","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",TRUNC(1.41*($Q$31/$Q$27)),\"\")","v":""}]
["* D4 =3.27 for 2 trials and 2.58 for 3 trials.  UCLR represents the limit of individual R's.  Circle those that are",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X35<>\"\",IF(X35<5,\"Gage discrimination low\",\"Gage discrimination acceptable\"),\"\")","v":""}]
["beyond this limit.  Identify the cause and correct.  Repeat these readings using the same appraiser and unit as originally used or"]
["discard values and re-average and recompute R and the limiting value from the remaining observations.",null,null,null,null,null,null,null,null,null,null,null,null,null,"   For information on the theory and constants used in the form see MSA Reference Manual, Third edition."]
[]
["Notes:"]

{"sheet":"GR&R VAR(Tol)","index":14,"n_rows":40,"n_cols":24,"rows_kept":40,"cut":false,"hidden":false,"merged":[[35,21,35,24]]}
["GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET",null,null,null,null,null,null,null,null,null,null,null,null,null,"GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET"]
["VARIABLE DATA RESULTS",null,null,null,null,null,null,null,null,null,null,null,null,null,"VARIABLE DATA RESULTS"]
[]
["Part Number",null,null,null,null,"Gage Name",null,null,null,"Appraiser A",null,null,null,null,"Part Number",null,null,"Gage Name",null,null,null,"Appraiser A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F5<>\"\",F5,\"\")","v":""},null,null,null,{"$f":"IF(J5<>\"\",J5,\"\")","v":""}]
["Part Name",null,null,null,null,"Gage Number",null,null,null,"Appraiser B",null,null,null,null,"Part Name",null,null,"Gage Number",null,null,null,"Appraiser B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F7<>\"\",F7,\"\")","v":""},null,null,null,{"$f":"IF(J7<>\"\",J7,\"\")","v":""}]
["Characteristic",null,null,"Specification",null,"Gage Type",null,null,null,"Appraiser C",null,null,null,null,"Characteristic",null,null,"Gage Type",null,null,null,"Appraiser C"]
[null,null,null,"Lower","Upper",null,null,null,null,null,null,null,null,null,{"$f":"IF(A9<>\"\",A9,\"\")","v":""},null,null,{"$f":"IF(F9<>\"\",F9,\"\")","v":""},null,null,null,{"$f":"IF(J9<>\"\",J9,\"\")","v":""}]
["Characteristic Classification",null,null,null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed",null,null,"Characteristic Classification",null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed"]
[null,null,null,null,null,{"$f":"IF(C15<>\"\",COUNT(C15:C17),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15:L15),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15,C20,C25),\"\")","v":""},null,null,null,null,{"$f":"IF(A11<>\"\",A11,\"\")","v":""},null,null,{"$f":"F11","v":""},null,{"$f":"H11","v":""},null,{"$f":"J11","v":""},null,{"$f":"IF(L11<>\"\",L11,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(D9>E9,\"ENTER LOWER TOLERANCE IN D9\",\"\")","v":""},{"$f":"IF(C15<>\"\",IF(F11*H11*J11<90,\"DERIVED RESULTS MAY NOT BE STATISTICALLY SOUND\",\"\"),\"\")","v":""}]
["APPRAISER/",null,"PART",null,null,null,null,null,null,null,null,null,"AVERAGE",null,null,null,null,"Measurement Unit Analysis",null,null,null,"% Tolerance (Tol)"]
["TRIAL #",null,1,2,3,4,5,6,7,8,9,10,null,null,"  Repeatability - Equipment Variation (EV)"]
["1.  A",1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15<>\"\",AVERAGE(C15:L15),\"\")","v":""},"EV","=","R  x  K1",null,null,"Trials","K1","% EV","=","100 (EV/Tol)"]
[2,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(TEXT($N$32,\"0.000\"),\" x \",CHOOSE($F$11,0,U16,U17)),\"\")","v":""},null,null,2,0.88649999999999995,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$17,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[{"$f":"A16+1","v":3},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",$N$32*(CHOOSE($F$11,0,U16,U17)),\"\")","v":""},null,null,3,0.5907,null,"=",{"$f":"IF(C15<>\"\",100*($Q$17/$Q$35),\"\")","v":""}]
[{"$f":"A17+1","v":4},"AVE",{"$f":"IF(C15<>\"\",SUM(C15:C17)/COUNT(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",SUM(D15:D17)/COUNT(D15:D17),\"\")","v":""},"","","","","","","","","xa=","","  Reproducibility - Appraiser Variation (AV)"]
[{"$f":"A18+1","v":5},"R",{"$f":"IF(C15<>\"\",MAX(C15:C17)-MIN(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",MAX(D15:D17)-MIN(D15:D17),\"\")","v":""},"","","","","","","","","ra=","","AV","=","{(xDIFF x K2)2 - (EV2/nr)}1/2",null,null,null,null,"% AV","=","100 (AV/Tol)"]
["6.  B",1,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"{(\",TEXT($N$33,\"0.000\"),\" x \",CHOOSE($J$11,0,T23,U23),\")^2 - (\",TEXT($Q$17,\"0.000\"),\" ^2/(\",$H$11,\" x \",$F$11,\"))}^1/2\"),\"\")","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$21,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[7,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15=\"\",\"\",IF(($N$33*CHOOSE($J$11,0,T23,U23))^2-$Q$17^2/($H$11*$F$11)<0,0,(($N$33*CHOOSE($J$11,0,T23,U23))^2-$Q$17^2/($H$11*$F$11))^(1/2)))","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",100*($Q$21/$Q$35),\"\")","v":""}]
[{"$f":"A21+1","v":8},3,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"Appraisers",2,3]
[{"$f":"A22+1","v":9},"AVE",{"$f":"IF(C20<>\"\",SUM(C20:C22)/COUNT(C20:C22),\"\")","v":""},"","","","","","","","","","xb=","","           n = parts        r = trials",null,null,null,"K2",0.7087,0.52359999999999995]
[{"$f":"A23+1","v":10},"R",{"$f":"IF(C20<>\"\",MAX(C20:C22)-MIN(C20:C22),\"\")","v":""},"","","","","","","","","","rb=","","  Repeatability & Reproducibility (GRR)",null,null,null,null,null,null,"% GRR","=","100 (GRR/Tol)"]
["11.  C",1,null,null,null,null,null,null,null,null,null,null,null,"","GRR","=","{(EV2 + AV2)}1/2",null,null,"Parts","K3",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$27,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
[12,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"{(\",TEXT($Q$17,\"0.000\"),\"^2 + \",TEXT($Q$21,\"0.000\"),\"^2)}^1/2\"),\"\")","v":""},null,null,2,0.7087,null,"=",{"$f":"IF(C15<>\"\",100*($Q$27/$Q$35),\"\")","v":""}]
[{"$f":"A26+1","v":13},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"=",{"$f":"IF(C15<>\"\",($Q$17^2+$Q$21^2)^(1/2),\"\")","v":""},null,null,3,0.52359999999999995,{"$f":"IF(C16<>\"\",IF(X26<10,\"Gage system O.K\",IF(X26<30,\"Gage system may be acceptable\",\"Gage system needs improvement\")),\"\")","v":""}]
[{"$f":"A27+1","v":14},"AVE",{"$f":"IF(C25<>\"\",SUM(C25:C27)/COUNT(C25:C27),\"\")","v":""},"","","","","","","","","","xc=","","  Part Variation (PV)",null,null,null,null,4,0.44640000000000002]
[{"$f":"A28+1","v":15},"R",{"$f":"IF(C25<>\"\",MAX(C25:C27)-MIN(C25:C27),\"\")","v":""},"","","","","","","","","","rc=","","PV","=","RP x K3",null,null,5,0.4032,"% PV","=","100 (PV/Tol)"]
["16. PART ",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(C15<>\"\",AVERAGE(C31:L31),\"\")","v":""},null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(TEXT($N$31,\"0.000\"),\" x \",CHOOSE($H$11,0,U26,U27,U28,U29,U30,U31,U32,U33,U34)),\"\")","v":""},null,null,6,0.3745,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"100(\",TEXT($Q$31,\"0.000\"),\"/\",TEXT($Q$35,\"0.000\"),\")\"),\"\")","v":""}]
["   AVERAGE",null,{"$f":"IF(C18<>\"\",SUM(C18,C23,C28)/COUNT(C18,C23,C28),\"\")","v":""},{"$f":"IF(D18<>\"\",SUM(D18,D23,D28)/COUNT(D18,D23,D28),\"\")","v":""},"","","","","","","","","Rp=",{"$f":"IF(C15<>\"\",MAX(C31:L31)-MIN(C31:L31),\"\")","v":""},null,"=",{"$f":"IF(C15<>\"\",$N$31*CHOOSE($H$11,0,U26,U27,U28,U29,U30,U31,U32,U33,U34),\"\")","v":""},null,null,7,0.35339999999999999,null,"=",{"$f":"IF(C15<>\"\",100*($Q$31/$Q$35),\"\")","v":""}]
[{"$f":"A29+2","v":17},"(ra + rb + rc) / (# OF APPRAISERS) =",null,null,null,null,null,null,null,null,null,null,"R=",{"$f":"IF(C15<>\"\",SUM(N19,N24,N29)/COUNT(C15,C20,C25),\"\")","v":""},"  Tolerance (Tol)",null,null,null,null,8,0.33779999999999999]
[{"$f":"A32+1","v":18},"xDIFF = (Max x - Min x) =",null,null,null,null,null,null,null,null,null,null,"xDIFF=",{"$f":"IF(C15<>\"\",MAX(N18,N23,N28)-MIN(N18,N23,N28),\"\")","v":""},"Tol","=","Upper - Lower / 6",null,null,9,0.32469999999999999,"ndc","=","1.41(PV/GRR)"]
[{"$f":"A33+1","v":19},"* UCLR = R x D4 =",null,null,{"$f":"IF(C15=\"\",\"\",IF(OR(G34<>\"\",H34<>\"\",I34<>\"\"),\"APPRAISER\",\"\"))","v":""},null,{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C19<>\"\",$C19>$N$34),AND($D19<>\"\",$D19>$N$34),AND($E19<>\"\",$E19>$N$34),AND($F19<>\"\",$F19>$N$34),AND($G19<>\"\",$G19>$N$34),AND($H19<>\"\",$H19>$N$34),AND($I19<>\"\",$I19>$N$34),AND($J19<>\"\",$J19>$N$34),AND($K19<>\"\",$K19>$N$34),AND($L19<>\"\",$L19>$N$34)),\"A\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C24<>\"\",$C24>$N$34),AND($D24<>\"\",$D24>$N$34),AND($E24<>\"\",$E24>$N$34),AND($F24<>\"\",$F24>$N$34),AND($G24<>\"\",$G24>$N$34),AND($H24<>\"\",$H24>$N$34),AND($I24<>\"\",$I24>$N$34),AND($J24<>\"\",$J24>$N$34),AND($K24<>\"\",$K24>$N$34),AND($L24<>\"\",$L24>$N$34)),\"B\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(AND($C29<>\"\",$C29>$N$34),AND($D29<>\"\",$D29>$N$34),AND($E29<>\"\",$E29>$N$34),AND($F29<>\"\",$F29>$N$34),AND($G29<>\"\",$G29>$N$34),AND($H29<>\"\",$H29>$N$34),AND($I29<>\"\",$I29>$N$34),AND($J29<>\"\",$J29>$N$34),AND($K29<>\"\",$K29>$N$34),AND($L29<>\"\",$L29>$N$34)),\"C\",\"\"))","v":""},{"$f":"IF(C15=\"\",\"\",IF(OR(G34<>\"\",H34<>\"\",I34<>\"\"),\"OUT OF CONTROL\",\"\"))","v":""},null,null,"UCLR=",{"$f":"IF(C15<>\"\",IF(F11=3,2.58*N32,3.27*N32),\"\")","v":""},null,"=",{"$f":"CONCATENATE(\"( \",E9,\" - \",D9,\" ) / 6\")","v":"( Upper - Lower ) / 6"},null,null,10,0.3145,null,"=",{"$f":"IF(C15<>\"\",CONCATENATE(\"1.41(\",TEXT($Q$31,\"0.000\"),\"/\",TEXT($Q$27,\"0.000\"),\")\"),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",(E9-D9)/6,\"\")","v":""},null,null,null,null,null,"=",{"$f":"IF(C15<>\"\",TRUNC(1.41*($Q$31/$Q$27)),\"\")","v":""}]
["* D4 =3.27 for 2 trials and 2.58 for 3 trials.  UCLR represents the limit of individual R's.  Circle those that are",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X35<>\"\",IF(X35<5,\"Gage discrimination low\",\"Gage discrimination acceptable\"),\"\")","v":""}]
["beyond this limit.  Identify the cause and correct.  Repeat these readings using the same appraiser and unit as originally used or"]
["discard values and re-average and recompute R and the limiting value from the remaining observations.",null,null,null,null,null,null,null,null,null,null,null,null,null,"   For information on the theory and constants used in the form see MSA Reference Manual, Third edition."]
[]
["Notes:"]

{"sheet":"GR&R ANOVA","index":15,"n_rows":60,"n_cols":37,"rows_kept":60,"cut":false,"hidden":false,"merged":[[34,10,34,11],[35,4,35,5],[36,4,36,5],[37,4,37,5],[35,10,35,11],[36,10,36,11],[37,6,37,7],[37,8,37,9],[37,10,37,11],[47,1,48,4],[34,4,34,5],[34,6,34,7],[34,8,34,9],[38,4,38,5],[39,4,39,5],[35,6,35,7],[35,8,35,9],[36,6,36,7],[36,8,36,9],[38,6,38,7],[38,8,38,9],[52,10,52,12],[38,10,38,11],[39,6,39,7],[39,8,39,9],[39,10,39,11],[52,5,52,6],[53,10,53,12],[53,5,53,6],[47,7,48,9],[47,10,48,12],[47,5,48,6],[49,5,49,6],[50,5,50,6],[51,5,51,6],[49,7,49,9],[50,7,50,9],[51,7,51,9],[52,7,52,9],[53,7,53,9],[49,10,49,12],[50,10,50,12],[51,10,51,12]]}
["GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET"]
["ANOVA METHOD"]
[]
["Part Number",null,null,null,null,"Gage Name",null,null,null,"Appraiser A"]
[]
["Part Name",null,null,null,null,"Gage Number",null,null,null,"Appraiser B"]
[]
["Characteristic",null,null,"Specification",null,"Gage Type",null,null,null,"Appraiser C"]
[null,null,null,"Lower","Upper"]
["Characteristic Classification",null,null,null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed"]
[null,null,null,null,null,{"$f":"IF(C15<>\"\",COUNT(C15:C17),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15:L15),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15,C20,C25),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(D9>E9,\"ENTER LOWER TOLERANCE IN D9\",\"\")","v":""},{"$f":"IF(C15<>\"\",IF(F11*H11*J11<90,\"DERIVED RESULTS MAY NOT BE STATISTICALLY SOUND\",\"\"),\"\")","v":""}]
["APPRAISER/",null,"PART",null,null,null,null,null,null,null,null,null,"AVERAGE"]
["TRIAL #",null,1,2,3,4,5,6,7,8,9,10,null,null,null,null,null,"squared","/nr","/nkr","/kr",null,null,"squared","/r"]
["1.  A",1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C15<>\"\",AVERAGE(C15:L15),\"\")","v":""},null,"x.1.",{"$f":"SUM(C15:L17)","v":0},{"$f":"Q15*Q15","v":0},{"$f":"R15/$Q$19","v":{"$error":"#VALUE!"}},null,null,"x11.",{"$f":"SUM(C15:C17)","v":0},{"$f":"W15*W15","v":0},{"$f":"X15/$F$11","v":{"$error":"#VALUE!"}},null,"Squared","Part 1","Part 2","Part 3","Part 4","Part 5","Part 6","Part 7","Part 8","Part 9","Part 10"]
[2,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"x.2.",{"$f":"SUM(C20:L22)","v":0},{"$f":"Q16*Q16","v":0},{"$f":"R16/$Q$19","v":{"$error":"#VALUE!"}},null,null,"x21.",{"$f":"SUM(D15:D17)","v":0},{"$f":"W16*W16","v":0},{"$f":"X16/$F$11","v":{"$error":"#VALUE!"}},"Appr A","Trial 1",{"$f":"C15*C15","v":0},0,0,0,0,0,0,0,{"$f":"K15*K15","v":0},0]
[{"$f":"A16+1","v":3},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"x.3.",{"$f":"SUM(C25:L27)","v":0},{"$f":"Q17*Q17","v":0},{"$f":"R17/$Q$19","v":{"$error":"#VALUE!"}},null,null,"x31.",{"$f":"SUM(E15:E17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 2",0,0,0,0,0,0,0,0,0,0]
[{"$f":"A17+1","v":4},"AVE",{"$f":"IF(C15<>\"\",SUM(C15:C17)/COUNT(C15:C17),\"\")","v":""},"","","","","","","","","","xa=","",null,"x…",{"$f":"SUM(Q15:Q17)","v":0},{"$f":"Q18*Q18","v":0},null,{"$f":"R18/Q20","v":{"$error":"#VALUE!"}},null,"x41.",{"$f":"SUM(F15:F17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 3",0,0,0,0,0,0,0,0,0,0]
[{"$f":"A18+1","v":5},"R",{"$f":"IF(C15<>\"\",MAX(C15:C17)-MIN(C15:C17),\"\")","v":""},"","","","","","","","","","ra=","",null,"nr",{"$f":"J11*H11","v":{"$error":"#VALUE!"}},null,null,null,null,"x51.",{"$f":"SUM(G15:G17)","v":0},0,{"$error":"#VALUE!"},"Appr B","Trial 1",{"$f":"C20*C20","v":0},0,0,0,0,0,0,0,{"$f":"K20*K20","v":0},0]
["6.  B",1,null,null,null,null,null,null,null,null,null,null,null,"",null,"nkr",{"$f":"F11*H11*J11","v":{"$error":"#VALUE!"}},null,null,null,null,"x61.",{"$f":"SUM(H15:H17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 2",0,0,0,0,0,0,0,0,0,0]
[7,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"kr",{"$f":"F11*J11","v":{"$error":"#VALUE!"}},null,null,null,null,"x71.",{"$f":"SUM(I15:I17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 3",0,0,0,0,0,0,0,0,0,0]
[{"$f":"A21+1","v":8},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"x1..",{"$f":"SUM(C15:C17)+SUM(C20:C22)+SUM(C25:C27)","v":0},{"$f":"Q22*Q22","v":0},null,null,{"$f":"R22/$Q$21","v":{"$error":"#VALUE!"}},"x81.",{"$f":"SUM(J15:J17)","v":0},0,{"$error":"#VALUE!"},"Appr C","Trial 1",{"$f":"C25*C25","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"A22+1","v":9},"AVE",{"$f":"IF(C20<>\"\",SUM(C20:C22)/COUNT(C20:C22),\"\")","v":""},"","","","","","","","","","xb=","",null,"x2..",{"$f":"SUM(D15:D17)+SUM(D20:D22)+SUM(D25:D27)","v":0},0,null,null,{"$f":"R23/$Q$21","v":{"$error":"#VALUE!"}},"x91.",{"$f":"SUM(K15:K17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 2",0,0,0,0,0,0,0,0,0,0]
[{"$f":"A23+1","v":10},"R",{"$f":"IF(C20<>\"\",MAX(C20:C22)-MIN(C20:C22),\"\")","v":""},"","","","","","","","","","rb=","",null,"x3..",{"$f":"SUM(E15:E17)+SUM(E20:E22)+SUM(E25:E27)","v":0},0,null,null,{"$error":"#VALUE!"},"x101.",{"$f":"SUM(L15:L17)","v":0},0,{"$error":"#VALUE!"},null,"Trial 3",{"$f":"C27*C27","v":0},0,0,0,0,0,0,0,0,{"$f":"L27*L27","v":0}]
["11.  C",1,null,null,null,null,null,null,null,null,null,null,null,"",null,"x4..",{"$f":"SUM(F15:F17)+SUM(F20:F22)+SUM(F25:F27)","v":0},0,null,null,{"$error":"#VALUE!"},"x12.",{"$f":"SUM(C20:C22)","v":0},0,{"$error":"#VALUE!"}]
[12,2,null,null,null,null,null,null,null,null,null,null,null,"",null,"x5..",{"$f":"SUM(G15:G17)+SUM(G20:G22)+SUM(G25:G27)","v":0},0,null,null,{"$error":"#VALUE!"},"x22.",{"$f":"SUM(D20:D22)","v":0},0,{"$error":"#VALUE!"}]
[{"$f":"A26+1","v":13},3,null,null,null,null,null,null,null,null,null,null,null,"",null,"x6..",{"$f":"SUM(H15:H17)+SUM(H20:H22)+SUM(H25:H27)","v":0},0,null,null,{"$error":"#VALUE!"},"x32.",{"$f":"SUM(E20:E22)","v":0},0,{"$error":"#VALUE!"}]
[{"$f":"A27+1","v":14},"AVE",{"$f":"IF(C25<>\"\",SUM(C25:C27)/COUNT(C25:C27),\"\")","v":""},"","","","","","","","","","xc=","",null,"x7..",{"$f":"SUM(I15:I17)+SUM(I20:I22)+SUM(I25:I27)","v":0},0,null,null,{"$error":"#VALUE!"},"x42.",{"$f":"SUM(F20:F22)","v":0},0,{"$error":"#VALUE!"}]
[{"$f":"A28+1","v":15},"R",{"$f":"IF(C25<>\"\",MAX(C25:C27)-MIN(C25:C27),\"\")","v":""},"","","","","","","","","","rc=","",null,"x8..",{"$f":"SUM(J15:J17)+SUM(J20:J22)+SUM(J25:J27)","v":0},0,null,null,{"$error":"#VALUE!"},"x52.",{"$f":"SUM(G20:G22)","v":0},0,{"$error":"#VALUE!"}]
["16. PART ",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(C15<>\"\",AVERAGE(C31:L31),\"\")","v":""},null,"x9..",{"$f":"SUM(K15:K17)+SUM(K20:K22)+SUM(K25:K27)","v":0},0,null,null,{"$error":"#VALUE!"},"x62.",{"$f":"SUM(H20:H22)","v":0},0,{"$error":"#VALUE!"}]
["   AVERAGE",null,{"$f":"IF(C18<>\"\",SUM(C18,C23,C28)/COUNT(C18,C23,C28),\"\")","v":""},{"$f":"IF(D18<>\"\",SUM(D18,D23,D28)/COUNT(D18,D23,D28),\"\")","v":""},"","","","","","","","","Rp=",{"$f":"IF(C15<>\"\",MAX(C31:L31)-MIN(C31:L31),\"\")","v":""},null,"x10..",{"$f":"SUM(L15:L17)+SUM(L20:L22)+SUM(L25:L27)","v":0},0,null,null,{"$error":"#VALUE!"},"x72.",{"$f":"SUM(I20:I22)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x82.",{"$f":"SUM(J20:J22)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x92.",{"$f":"SUM(K20:K22)","v":0},0,{"$error":"#VALUE!"}]
[null,"Anova Table",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x102.",{"$f":"SUM(L20:L22)","v":0},0,{"$error":"#VALUE!"}]
[null,"Source",null,null,"DF",null,"SS",null,"MS",null,"F",null,"Sig",null,null,null,null,null,null,null,null,"x13.",{"$f":"SUM(C25:C27)","v":0},0,{"$error":"#VALUE!"}]
[null,"Appraiser",null,null,{"$f":"IF(J11<>\"\",J11-1,\"\")","v":""},null,{"$f":"IF(C15<>\"\",IF(SUM(S15:S17)-T18<0,0,SUM(S15:S17)-T18),\"\")","v":""},null,{"$f":"IF(G36<>\"\",G36/E36,\"\")","v":""},null,{"$f":"IF(I39<>\"\",IF(I39=0,0,I36/I39),\"\")","v":""},null,{"$f":"IF(K36<>\"\",IF(K36>FINV(0.05,E36,E39),\"*\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,"x23.",{"$f":"SUM(D25:D27)","v":0},0,{"$error":"#VALUE!"}]
[null,"Parts",null,null,{"$f":"IF(H11<>\"\",H11-1,\"\")","v":""},null,{"$f":"IF(C15<>\"\",IF(SUM(U22:U31)-T18<0,0,SUM(U22:U31)-T18),\"\")","v":""},null,{"$f":"IF(G37<>\"\",G37/E37,\"\")","v":""},null,{"$f":"IF(I39<>\"\",IF(I39=0,0,I37/I39),\"\")","v":""},null,{"$f":"IF(K37<>\"\",IF(K37>FINV(0.05,E37,E39),\"*\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,"x33.",{"$f":"SUM(E25:E27)","v":0},0,{"$error":"#VALUE!"}]
[null,"Appraiser-by-Part",null,null,{"$f":"IF(E36<>\"\",E36*E37,\"\")","v":""},null,{"$f":"IF(C15<>\"\",IF(SUM(Y15:Y44)-SUM(U22:U31)-SUM(S15:S17)+T18<0,0,SUM(Y15:Y44)-SUM(U22:U31)-SUM(S15:S17)+T18),\"\")","v":""},null,{"$f":"IF(G38<>\"\",G38/E38,\"\")","v":""},null,{"$f":"IF(I39<>\"\",IF(I39=0,0,I38/I39),\"\")","v":""},null,{"$f":"IF(K38<>\"\",IF(K38>FINV(0.05,E38,E39),\"*\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,"x43.",{"$f":"SUM(F25:F27)","v":0},0,{"$error":"#VALUE!"}]
[null,"Equipment",null,null,{"$f":"IF(H11<>\"\",H11*J11*(F11-1),\"\")","v":""},null,{"$f":"IF(C15<>\"\",IF(G40-G36-G37-G38<0,0,G40-G36-G37-G38),\"\")","v":""},null,{"$f":"IF(G39<>\"\",G39/E39,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"x53.",{"$f":"SUM(G25:G27)","v":0},0,{"$error":"#VALUE!"}]
[null,"Total",null,null,{"$f":"IF(F11<>\"\",F11*H11*J11-1,\"\")","v":""},null,{"$f":"IF(C15<>\"\",(SUM(AB16:AK24)-T18),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x63.",{"$f":"SUM(H25:H27)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,"* Significant at a = 0.05 level",null,null,null,null,null,null,null,null,null,null,null,"x73.",{"$f":"SUM(I25:I27)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x83.",{"$f":"SUM(J25:J27)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x93.",{"$f":"SUM(K25:K27)","v":0},0,{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x103.",{"$f":"SUM(L25:L27)","v":0},0,{"$error":"#VALUE!"}]
[]
[]
[]
[null,"Anova Report",null,null,null,"Standard Deviation (s)",null,"% Total Variation",null,null,"% Contribution"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MSpool",{"$f":"IF(G39<>\"\",(G39+G38)/(Q20-H11-J11+1),\"\")","v":""}]
[null,"Repeatability (EV)",null,null,null,{"$f":"IF(Q49<>\"\",SQRT(Q49),\"\")","v":""},null,{"$f":"IF(F50<>\"\",F50/M58,\"\")","v":""},null,null,{"$f":"IF(H50<>\"\",H50*H50,\"\")","v":""}]
[null,"Reproducibility (AV)",null,null,null,{"$f":"IF(Q49<>\"\",IF(I36-Q49<0,0,SQRT((I36-Q49)/Q19)),\"\")","v":""},null,{"$f":"IF(F51<>\"\",F51/M58,\"\")","v":""},null,null,{"$f":"IF(H51<>\"\",H51*H51,\"\")","v":""}]
[null,"Appraiser by Part (INT)",null,null,null,{"$f":"IF(I38<>\"\",IF(I38-I39<0,0,SQRT((I38-I39)/H11)),\"\")","v":""},null,{"$f":"IF(F52<>\"\",F52/M58,\"\")","v":""},null,null,{"$f":"IF(H52<>\"\",H52*H52,\"\")","v":""}]
[null,"GRR",null,null,null,{"$f":"IF(F50<>\"\",SQRT(F50*F50+F51*F51),\"\")","v":""},null,{"$f":"IF(F53<>\"\",F53/M58,\"\")","v":""},null,null,{"$f":"IF(H53<>\"\",H53*H53,\"\")","v":""}]
[null,"Part-to-Part (PV)",null,null,null,{"$f":"IF(Q49<>\"\",IF(I37-Q49<0,0,SQRT((I37-Q49)/J11/F11)),\"\")","v":""},null,{"$f":"IF(F54<>\"\",F54/M58,\"\")","v":""},null,null,{"$f":"IF(H54<>\"\",H54*H54,\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(H53<>\"\",IF(H53<10%,\"Gage system O.K\",IF(H53<30%,\"Gage system may be acceptable\",\"Gage system needs improvement\")),\"\")","v":""}]
[]
[null,"Note:"]
[null,"Tolerance =",null,{"$f":"IF(AND(C15<>\"\",D9<>\"Lower\"),E9-D9,\"\")","v":""},null,null,null,null,null,"Total variation (TV) =",null,null,{"$f":"IF(F53<>\"\",SQRT(F53*F53+F54*F54),\"\")","v":""}]
[null,"Number of distinct data categories (ndc) =",null,null,null,null,null,{"$f":"IF(H54<>\"\",TRUNC(1.41*F54/F53),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(H59<>\"\",IF(H59<5,\"Gage discrimination low\",\"Gage discrimination acceptable\"),\"\")","v":""}]

{"sheet":"Graphical","index":16,"n_rows":458,"n_cols":61,"rows_kept":458,"cut":false,"hidden":false,"merged":[]}
["GAGE REPEATABILITY AND REPRODUCIBILITY DATA SHEET"]
["GRAPHICAL ANALYSIS"]
[]
["Part Number",null,null,null,null,"Gage Name",null,null,null,"Appraiser A"]
[]
["Part Name",null,null,null,null,"Gage Number",null,null,null,"Appraiser B"]
[]
["Characteristic",null,null,"Specification",null,"Gage Type",null,null,null,"Appraiser C"]
[null,null,null,"Lower","Upper"]
["Characteristic Classification",null,null,null,null,"Trials",null,"Parts",null,"Appraisers",null,"Date Performed"]
[null,null,null,null,null,{"$f":"IF(C15<>\"\",COUNT(C15:C17),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15:L15),\"\")","v":""},null,{"$f":"IF(C15<>\"\",COUNT(C15,C20,C25),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(D9>E9,\"ENTER LOWER TOLERANCE IN D9\",\"\")","v":""},{"$f":"IF(C15<>\"\",IF(F11*H11*J11<90,\"DERIVED RESULTS MAY NOT BE STATISTICALLY SOUND\",\"\"),\"\")","v":""}]
["APPRAISER/",null,"PART",null,null,null,null,null,null,null,null,null,"AVERAGE"]
["TRIAL #",null,1,2,3,4,5,6,7,8,9,10]
["1.  A",1,{"$f":"IF('GR&R VAR(Tol)'!C15<>\"\",'GR&R VAR(Tol)'!C15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D15<>\"\",'GR&R VAR(Tol)'!D15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E15<>\"\",'GR&R VAR(Tol)'!E15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F15<>\"\",'GR&R VAR(Tol)'!F15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G15<>\"\",'GR&R VAR(Tol)'!G15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H15<>\"\",'GR&R VAR(Tol)'!H15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I15<>\"\",'GR&R VAR(Tol)'!I15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J15<>\"\",'GR&R VAR(Tol)'!J15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K15<>\"\",'GR&R VAR(Tol)'!K15,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L15<>\"\",'GR&R VAR(Tol)'!L15,\"\")","v":""},null,{"$f":"IF(C15<>\"\",AVERAGE(C15:L15),\"\")","v":""}]
[2,2,{"$f":"IF('GR&R VAR(Tol)'!C16<>\"\",'GR&R VAR(Tol)'!C16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D16<>\"\",'GR&R VAR(Tol)'!D16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E16<>\"\",'GR&R VAR(Tol)'!E16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F16<>\"\",'GR&R VAR(Tol)'!F16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G16<>\"\",'GR&R VAR(Tol)'!G16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H16<>\"\",'GR&R VAR(Tol)'!H16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I16<>\"\",'GR&R VAR(Tol)'!I16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J16<>\"\",'GR&R VAR(Tol)'!J16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K16<>\"\",'GR&R VAR(Tol)'!K16,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L16<>\"\",'GR&R VAR(Tol)'!L16,\"\")","v":""},null,""]
[{"$f":"A16+1","v":3},3,{"$f":"IF('GR&R VAR(Tol)'!C17<>\"\",'GR&R VAR(Tol)'!C17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D17<>\"\",'GR&R VAR(Tol)'!D17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E17<>\"\",'GR&R VAR(Tol)'!E17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F17<>\"\",'GR&R VAR(Tol)'!F17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G17<>\"\",'GR&R VAR(Tol)'!G17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H17<>\"\",'GR&R VAR(Tol)'!H17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I17<>\"\",'GR&R VAR(Tol)'!I17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J17<>\"\",'GR&R VAR(Tol)'!J17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K17<>\"\",'GR&R VAR(Tol)'!K17,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L17<>\"\",'GR&R VAR(Tol)'!L17,\"\")","v":""},null,""]
[{"$f":"A17+1","v":4},"AVE",{"$f":"IF(C15<>\"\",SUM(C15:C17)/COUNT(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",SUM(D15:D17)/COUNT(D15:D17),\"\")","v":""},"","","","","","","","","xa=",""]
[{"$f":"A18+1","v":5},"R",{"$f":"IF(C15<>\"\",MAX(C15:C17)-MIN(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",MAX(D15:D17)-MIN(D15:D17),\"\")","v":""},"","","","","","","","","ra=",""]
["6.  B",1,{"$f":"IF('GR&R VAR(Tol)'!C20<>\"\",'GR&R VAR(Tol)'!C20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D20<>\"\",'GR&R VAR(Tol)'!D20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E20<>\"\",'GR&R VAR(Tol)'!E20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F20<>\"\",'GR&R VAR(Tol)'!F20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G20<>\"\",'GR&R VAR(Tol)'!G20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H20<>\"\",'GR&R VAR(Tol)'!H20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I20<>\"\",'GR&R VAR(Tol)'!I20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J20<>\"\",'GR&R VAR(Tol)'!J20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K20<>\"\",'GR&R VAR(Tol)'!K20,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L20<>\"\",'GR&R VAR(Tol)'!L20,\"\")","v":""},null,""]
[7,2,{"$f":"IF('GR&R VAR(Tol)'!C21<>\"\",'GR&R VAR(Tol)'!C21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D21<>\"\",'GR&R VAR(Tol)'!D21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E21<>\"\",'GR&R VAR(Tol)'!E21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F21<>\"\",'GR&R VAR(Tol)'!F21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G21<>\"\",'GR&R VAR(Tol)'!G21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H21<>\"\",'GR&R VAR(Tol)'!H21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I21<>\"\",'GR&R VAR(Tol)'!I21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J21<>\"\",'GR&R VAR(Tol)'!J21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K21<>\"\",'GR&R VAR(Tol)'!K21,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L21<>\"\",'GR&R VAR(Tol)'!L21,\"\")","v":""},null,""]
[{"$f":"A21+1","v":8},3,{"$f":"IF('GR&R VAR(Tol)'!C22<>\"\",'GR&R VAR(Tol)'!C22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D22<>\"\",'GR&R VAR(Tol)'!D22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E22<>\"\",'GR&R VAR(Tol)'!E22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F22<>\"\",'GR&R VAR(Tol)'!F22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G22<>\"\",'GR&R VAR(Tol)'!G22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H22<>\"\",'GR&R VAR(Tol)'!H22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I22<>\"\",'GR&R VAR(Tol)'!I22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J22<>\"\",'GR&R VAR(Tol)'!J22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K22<>\"\",'GR&R VAR(Tol)'!K22,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L22<>\"\",'GR&R VAR(Tol)'!L22,\"\")","v":""},null,""]
[{"$f":"A22+1","v":9},"AVE",{"$f":"IF(C20<>\"\",SUM(C20:C22)/COUNT(C20:C22),\"\")","v":""},"","","","","","","","","","xb=",""]
[{"$f":"A23+1","v":10},"R",{"$f":"IF(C20<>\"\",MAX(C20:C22)-MIN(C20:C22),\"\")","v":""},"","","","","","","","","","rb=",""]
["11.  C",1,{"$f":"IF('GR&R VAR(Tol)'!C25<>\"\",'GR&R VAR(Tol)'!C25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D25<>\"\",'GR&R VAR(Tol)'!D25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E25<>\"\",'GR&R VAR(Tol)'!E25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F25<>\"\",'GR&R VAR(Tol)'!F25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G25<>\"\",'GR&R VAR(Tol)'!G25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H25<>\"\",'GR&R VAR(Tol)'!H25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I25<>\"\",'GR&R VAR(Tol)'!I25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J25<>\"\",'GR&R VAR(Tol)'!J25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K25<>\"\",'GR&R VAR(Tol)'!K25,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L25<>\"\",'GR&R VAR(Tol)'!L25,\"\")","v":""},null,""]
[12,2,{"$f":"IF('GR&R VAR(Tol)'!C26<>\"\",'GR&R VAR(Tol)'!C26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D26<>\"\",'GR&R VAR(Tol)'!D26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E26<>\"\",'GR&R VAR(Tol)'!E26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F26<>\"\",'GR&R VAR(Tol)'!F26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G26<>\"\",'GR&R VAR(Tol)'!G26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H26<>\"\",'GR&R VAR(Tol)'!H26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I26<>\"\",'GR&R VAR(Tol)'!I26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J26<>\"\",'GR&R VAR(Tol)'!J26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K26<>\"\",'GR&R VAR(Tol)'!K26,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L26<>\"\",'GR&R VAR(Tol)'!L26,\"\")","v":""},null,""]
[{"$f":"A26+1","v":13},3,{"$f":"IF('GR&R VAR(Tol)'!C27<>\"\",'GR&R VAR(Tol)'!C27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!D27<>\"\",'GR&R VAR(Tol)'!D27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!E27<>\"\",'GR&R VAR(Tol)'!E27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!F27<>\"\",'GR&R VAR(Tol)'!F27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!G27<>\"\",'GR&R VAR(Tol)'!G27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!H27<>\"\",'GR&R VAR(Tol)'!H27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!I27<>\"\",'GR&R VAR(Tol)'!I27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!J27<>\"\",'GR&R VAR(Tol)'!J27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!K27<>\"\",'GR&R VAR(Tol)'!K27,\"\")","v":""},{"$f":"IF('GR&R VAR(Tol)'!L27<>\"\",'GR&R VAR(Tol)'!L27,\"\")","v":""},null,""]
[{"$f":"A27+1","v":14},"AVE",{"$f":"IF(C25<>\"\",SUM(C25:C27)/COUNT(C25:C27),\"\")","v":""},"","","","","","","","","","xc=",""]
[{"$f":"A28+1","v":15},"R",{"$f":"IF(C25<>\"\",MAX(C25:C27)-MIN(C25:C27),\"\")","v":""},"","","","","","","","","","rc=",""]
["16. PART ",null,null,null,null,null,null,null,null,null,null,null,"X=",{"$f":"IF(C15<>\"\",AVERAGE(C31:L31),\"\")","v":""}]
["     AVE ( Xp )",null,{"$f":"IF(C18<>\"\",SUM(C18,C23,C28)/COUNT(C18,C23,C28),\"\")","v":""},{"$f":"IF(D18<>\"\",SUM(D18,D23,D28)/COUNT(D18,D23,D28),\"\")","v":""},"","","","","","","","","Rp=",{"$f":"IF(C15<>\"\",MAX(C31:L31)-MIN(C31:L31),\"\")","v":""}]
[]
[]
["Note:","The REFERENCE VALUE can be substituted for PART AVE to generate graphs indication true bias."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting line"]
[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,"Upper Spec",{"$f":"$E$9","v":"Upper"},{"$f":"$Q$55","v":"Upper"},{"$f":"$Q$55","v":"Upper"},"Upper","Upper","Upper","Upper","Upper","Upper","Upper"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower Spec",{"$f":"$D$9","v":"Lower"},{"$f":"$Q$56","v":"Lower"},{"$f":"$Q$56","v":"Lower"},"Lower","Lower","Lower","Lower","Lower","Lower","Lower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rucl",{"$f":"IF(F11=3,2.58*(N19+N24+N29)/J11,3.27*(N19+N24+N29)/3)","v":{"$error":"#VALUE!"}},{"$f":"$Q$57","v":{"$error":"#VALUE!"}},{"$f":"$Q$57","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr A",null,null,null,null,null,null,null,null,null,"Appr B",null,null,null,null,null,null,null,null,null,"Appr C"]
[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,1,2,3,4,5,6,7,8,9,10,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,"Mean",{"$f":"C18","v":""},"","","","","","","","","",{"$f":"C23","v":""},"","","","","","","","","",{"$f":"C28","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range",{"$f":"C19","v":""},"","","","","","","","",{"$f":"L19","v":""},{"$f":"C24","v":""},"","","","","","","","",{"$f":"L24","v":""},{"$f":"C29","v":""},"","","","","","","","",{"$f":"L29","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL B",null,null,null,null,null,null,null,null,null,null,{"$f":"Q55","v":"Upper"},"Upper","Upper","Upper","Upper","Upper","Upper","Upper","Upper","Upper"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL B",null,null,null,null,null,null,null,null,null,null,{"$f":"Q56","v":"Lower"},"Lower","Lower","Lower","Lower","Lower","Lower","Lower","Lower",{"$f":"Z56","v":"Lower"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA99","v":"Upper"},"Upper","Upper","Upper","Upper","Upper","Upper","Upper","Upper","Upper"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lower","Lower","Lower","Lower","Lower","Lower","Lower","Lower","Lower","Lower"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rucl B",null,null,null,null,null,null,null,null,null,null,{"$f":"Q57","v":{"$error":"#VALUE!"}},{"$f":"AA103","v":{"$error":"#VALUE!"}},{"$f":"AB103","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rucl C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA103","v":{"$error":"#VALUE!"}},{"$f":"AB103","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part 1",null,null,null,null,null,null,null,null,"Part 2",null,null,null,null,null,null,null,null,"Part 3",null,null,null,null,null,null,null,null,"Part 4",null,null,null,null,null,null,null,null,"Part 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Value",{"$f":"C15","v":""},{"$f":"C16","v":""},{"$f":"C17","v":""},null,null,null,null,null,null,{"$f":"D15","v":""},{"$f":"D16","v":""},{"$f":"D17","v":""},null,null,null,null,null,null,{"$f":"E15","v":""},{"$f":"E16","v":""},{"$f":"E17","v":""},null,null,null,null,null,null,{"$f":"F15","v":""},{"$f":"F16","v":""},{"$f":"F17","v":""},null,null,null,null,null,null,{"$f":"G15","v":""},{"$f":"G16","v":""},{"$f":"G17","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Value",null,null,null,{"$f":"IF(C20<>\"\",C20,\"\")","v":""},{"$f":"IF(C21<>\"\",C21,\"\")","v":""},{"$f":"IF(C22<>\"\",C22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D20<>\"\",D20,\"\")","v":""},{"$f":"IF(D21<>\"\",D21,\"\")","v":""},{"$f":"IF(D22<>\"\",D22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(E20<>\"\",E20,\"\")","v":""},{"$f":"IF(E21<>\"\",E21,\"\")","v":""},{"$f":"IF(E22<>\"\",E22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(F20<>\"\",F20,\"\")","v":""},{"$f":"IF(F21<>\"\",F21,\"\")","v":""},{"$f":"IF(F22<>\"\",F22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(G20<>\"\",G20,\"\")","v":""},{"$f":"IF(G21<>\"\",G21,\"\")","v":""},{"$f":"IF(G22<>\"\",G22,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C Value",null,null,null,null,null,null,{"$f":"IF(C25<>\"\",C25,\"\")","v":""},{"$f":"IF(C26<>\"\",C26,\"\")","v":""},{"$f":"IF(C27<>\"\",C27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D25<>\"\",D25,\"\")","v":""},{"$f":"IF(D26<>\"\",D26,\"\")","v":""},{"$f":"IF(D27<>\"\",D27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(E25<>\"\",E25,\"\")","v":""},{"$f":"IF(E26<>\"\",E26,\"\")","v":""},{"$f":"IF(E27<>\"\",E27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(F25<>\"\",F25,\"\")","v":""},{"$f":"IF(F26<>\"\",F26,\"\")","v":""},{"$f":"IF(F27<>\"\",F27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(G25<>\"\",G25,\"\")","v":""},{"$f":"IF(G26<>\"\",G26,\"\")","v":""},{"$f":"IF(G27<>\"\",G27,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part 6",null,null,null,null,null,null,null,null,"Part 7",null,null,null,null,null,null,null,null,"Part 8",null,null,null,null,null,null,null,null,"Part 9",null,null,null,null,null,null,null,null,"Part 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Value",{"$f":"H15","v":""},{"$f":"H16","v":""},{"$f":"H17","v":""},null,null,null,null,null,null,{"$f":"I15","v":""},{"$f":"I16","v":""},{"$f":"I17","v":""},null,null,null,null,null,null,{"$f":"J15","v":""},{"$f":"J16","v":""},{"$f":"J17","v":""},null,null,null,null,null,null,{"$f":"K15","v":""},{"$f":"K16","v":""},{"$f":"K17","v":""},null,null,null,null,null,null,{"$f":"L15","v":""},{"$f":"L16","v":""},{"$f":"L17","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Value",null,null,null,{"$f":"IF(H20<>\"\",H20,\"\")","v":""},{"$f":"IF(H21<>\"\",H21,\"\")","v":""},{"$f":"IF(H22<>\"\",H22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I20<>\"\",I20,\"\")","v":""},{"$f":"IF(I21<>\"\",I21,\"\")","v":""},{"$f":"IF(I22<>\"\",I22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J20<>\"\",J20,\"\")","v":""},{"$f":"IF(J21<>\"\",J21,\"\")","v":""},{"$f":"IF(J22<>\"\",J22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K20<>\"\",K20,\"\")","v":""},{"$f":"IF(K21<>\"\",K21,\"\")","v":""},{"$f":"IF(K22<>\"\",K22,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(L20<>\"\",L20,\"\")","v":""},{"$f":"IF(L21<>\"\",L21,\"\")","v":""},{"$f":"IF(L22<>\"\",L22,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C Value",null,null,null,null,null,null,{"$f":"IF(H25<>\"\",H25,\"\")","v":""},{"$f":"IF(H26<>\"\",H26,\"\")","v":""},{"$f":"IF(H27<>\"\",H27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I25<>\"\",I25,\"\")","v":""},{"$f":"IF(I26<>\"\",I26,\"\")","v":""},{"$f":"IF(I27<>\"\",I27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J25<>\"\",J25,\"\")","v":""},{"$f":"IF(J26<>\"\",J26,\"\")","v":""},{"$f":"IF(J27<>\"\",J27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K25<>\"\",K25,\"\")","v":""},{"$f":"IF(K26<>\"\",K26,\"\")","v":""},{"$f":"IF(K27<>\"\",K27,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(L25<>\"\",L25,\"\")","v":""},{"$f":"IF(L26<>\"\",L26,\"\")","v":""},{"$f":"IF(L27<>\"\",L27,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting Data"]
[null,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,"Appr A","Max",{"$f":"IF(C15<>\"\",MAX(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",MAX(D15:D17),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"IF(C18<>\"\",R224-C18,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(C15<>\"\",MIN(C15:C17),\"\")","v":""},{"$f":"IF(D15<>\"\",MIN(D15:D17),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(C18<>\"\",C18-R226,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr B","Max",{"$f":"IF(C20<>\"\",MAX(C20:C22),\"\")","v":""},{"$f":"IF(D20<>\"\",MAX(D20:D22),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"IF(C23<>\"\",R228-C23,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(C20<>\"\",MIN(C20:C22),\"\")","v":""},{"$f":"IF(D20<>\"\",MIN(D20:D22),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(C23<>\"\",C23-R230,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr C","Max",{"$f":"IF(C25<>\"\",MAX(C25:C27),\"\")","v":""},{"$f":"IF(D25<>\"\",MAX(D25:D27),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"IF(C28<>\"\",R232-C28,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Min",{"$f":"IF(C25<>\"\",MIN(C25:C27),\"\")","v":""},{"$f":"IF(D25<>\"\",MIN(D25:D27),\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"IF(C28<>\"\",C28-R234,\"\")","v":""},"","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Supporting Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part 1",null,null,null,null,null,null,null,null,"Part 2",null,null,null,null,null,null,null,null,"Part 3",null,null,null,null,null,null,null,null,"Part 4",null,null,null,null,null,null,null,null,"Part 5"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Value",{"$f":"IF(C15<>\"\",C15-C31,\"\")","v":""},{"$f":"IF(C16<>\"\",C16-C31,\"\")","v":""},{"$f":"IF(C17<>\"\",C17-C31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D15<>\"\",D15-D31,\"\")","v":""},{"$f":"IF(D16<>\"\",D16-D31,\"\")","v":""},{"$f":"IF(D17<>\"\",D17-D31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(E15<>\"\",E15-E31,\"\")","v":""},{"$f":"IF(E16<>\"\",E16-E31,\"\")","v":""},{"$f":"IF(E17<>\"\",E17-E31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(F15<>\"\",F15-F31,\"\")","v":""},{"$f":"IF(F16<>\"\",F16-F31,\"\")","v":""},{"$f":"IF(F17<>\"\",F17-F31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(G15<>\"\",G15-G31,\"\")","v":""},{"$f":"IF(G16<>\"\",G16-G31,\"\")","v":""},{"$f":"IF(G17<>\"\",G17-G31,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Value",null,null,null,{"$f":"IF(C20<>\"\",C20-C31,\"\")","v":""},{"$f":"IF(C21<>\"\",C21-C31,\"\")","v":""},{"$f":"IF(C22<>\"\",C22-C31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D20<>\"\",D20-D31,\"\")","v":""},{"$f":"IF(D21<>\"\",D21-D31,\"\")","v":""},{"$f":"IF(D22<>\"\",D22-D31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(E20<>\"\",E20-E31,\"\")","v":""},{"$f":"IF(E21<>\"\",E21-E31,\"\")","v":""},{"$f":"IF(E22<>\"\",E22-E31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(F20<>\"\",F20-F31,\"\")","v":""},{"$f":"IF(F21<>\"\",F21-F31,\"\")","v":""},{"$f":"IF(F22<>\"\",F22-F31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(G20<>\"\",G20-G31,\"\")","v":""},{"$f":"IF(G21<>\"\",G21-G31,\"\")","v":""},{"$f":"IF(G22<>\"\",G22-G31,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C Value",null,null,null,null,null,null,{"$f":"IF(C25<>\"\",C25-C31,\"\")","v":""},{"$f":"IF(C26<>\"\",C26-C31,\"\")","v":""},{"$f":"IF(C27<>\"\",C27-C31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(D25<>\"\",D25-D31,\"\")","v":""},{"$f":"IF(D26<>\"\",D26-D31,\"\")","v":""},{"$f":"IF(D27<>\"\",D27-D31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(E25<>\"\",E25-E31,\"\")","v":""},{"$f":"IF(E26<>\"\",E26-E31,\"\")","v":""},{"$f":"IF(E27<>\"\",E27-E31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(F25<>\"\",F25-F31,\"\")","v":""},{"$f":"IF(F26<>\"\",F26-F31,\"\")","v":""},{"$f":"IF(F27<>\"\",F27-F31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(G25<>\"\",G25-G31,\"\")","v":""},{"$f":"IF(G26<>\"\",G26-G31,\"\")","v":""},{"$f":"IF(G27<>\"\",G27-G31,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Part 6",null,null,null,null,null,null,null,null,"Part 7",null,null,null,null,null,null,null,null,"Part 8",null,null,null,null,null,null,null,null,"Part 9",null,null,null,null,null,null,null,null,"Part 10"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3","A1","A2","A3","B1","B2","B3","C1","C2","C3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A Value",{"$f":"IF(H15<>\"\",H15-H31,\"\")","v":""},{"$f":"IF(H16<>\"\",H16-H31,\"\")","v":""},{"$f":"IF(H17<>\"\",H17-H31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I15<>\"\",I15-I31,\"\")","v":""},{"$f":"IF(I16<>\"\",I16-I31,\"\")","v":""},{"$f":"IF(I17<>\"\",I17-I31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J15<>\"\",J15-J31,\"\")","v":""},{"$f":"IF(J16<>\"\",J16-J31,\"\")","v":""},{"$f":"IF(J17<>\"\",J17-J31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K15<>\"\",K15-K31,\"\")","v":""},{"$f":"IF(K16<>\"\",K16-K31,\"\")","v":""},{"$f":"IF(K17<>\"\",K17-K31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(L15<>\"\",L15-L31,\"\")","v":""},{"$f":"IF(L16<>\"\",L16-L31,\"\")","v":""},{"$f":"IF(L17<>\"\",L17-L31,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B Value",null,null,null,{"$f":"IF(H20<>\"\",H20-H31,\"\")","v":""},{"$f":"IF(H21<>\"\",H21-H31,\"\")","v":""},{"$f":"IF(H22<>\"\",H22-H31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I20<>\"\",I20-I31,\"\")","v":""},{"$f":"IF(I21<>\"\",I21-I31,\"\")","v":""},{"$f":"IF(I22<>\"\",I22-I31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J20<>\"\",J20-J31,\"\")","v":""},{"$f":"IF(J21<>\"\",J21-J31,\"\")","v":""},{"$f":"IF(J22<>\"\",J22-J31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K20<>\"\",K20-K31,\"\")","v":""},{"$f":"IF(K21<>\"\",K21-K31,\"\")","v":""},{"$f":"IF(K22<>\"\",K22-K31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(L20<>\"\",L20-L31,\"\")","v":""},{"$f":"IF(L21<>\"\",L21-L31,\"\")","v":""},{"$f":"IF(L22<>\"\",L22-L31,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C Value",null,null,null,null,null,null,{"$f":"IF(H25<>\"\",H25-H31,\"\")","v":""},{"$f":"IF(H26<>\"\",H26-H31,\"\")","v":""},{"$f":"IF(H27<>\"\",H27-H31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(I25<>\"\",I25-I31,\"\")","v":""},{"$f":"IF(I26<>\"\",I26-I31,\"\")","v":""},{"$f":"IF(I27<>\"\",I27-I31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(J25<>\"\",J25-J31,\"\")","v":""},{"$f":"IF(J26<>\"\",J26-J31,\"\")","v":""},{"$f":"IF(J27<>\"\",J27-J31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(K25<>\"\",K25-K31,\"\")","v":""},{"$f":"IF(K26<>\"\",K26-K31,\"\")","v":""},{"$f":"IF(K27<>\"\",K27-K31,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(L25<>\"\",L25-L31,\"\")","v":""},{"$f":"IF(L26<>\"\",L26-L31,\"\")","v":""},{"$f":"IF(L27<>\"\",L27-L31,\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"supporting data"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"divisions",null,-1,{"$f":"R311+0.1","v":-0.9},{"$f":"S311+0.1","v":-0.8},-0.70000000000000007,-0.60000000000000009,-0.50000000000000011,-0.40000000000000013,-0.30000000000000016,-0.20000000000000015,-0.10000000000000014,-1.3877787807814457E-16,9.9999999999999867E-2,0.19999999999999987,0.29999999999999988,0.39999999999999991,0.49999999999999989,0.59999999999999987,0.69999999999999984,0.79999999999999982,0.8999999999999998,0.99999999999999978]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Count","Appr A",{"$f":"COUNTIF($Q268:$BI268,\">-1\")+COUNTIF($Q274:$BI274,\">-1\")-SUM(S312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.9\")+COUNTIF($Q274:$BI274,\">-.9\")-SUM(T312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.8\")+COUNTIF($Q274:$BI274,\">-.8\")-SUM(U312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.7\")+COUNTIF($Q274:$BI274,\">-.7\")-SUM(V312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.6\")+COUNTIF($Q274:$BI274,\">-.6\")-SUM(W312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.5\")+COUNTIF($Q274:$BI274,\">-.5\")-SUM(X312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.4\")+COUNTIF($Q274:$BI274,\">-.4\")-SUM(Y312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.3\")+COUNTIF($Q274:$BI274,\">-.3\")-SUM(Z312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.2\")+COUNTIF($Q274:$BI274,\">-.2\")-SUM(AA312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-.1\")+COUNTIF($Q274:$BI274,\">-.1\")-SUM(AB312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">-0\")+COUNTIF($Q274:$BI274,\">0\")-SUM(AC312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.1\")+COUNTIF($Q274:$BI274,\">.1\")-SUM(AD312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.2\")+COUNTIF($Q274:$BI274,\">.2\")-SUM(AE312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.3\")+COUNTIF($Q274:$BI274,\">.3\")-SUM(AF312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.4\")+COUNTIF($Q274:$BI274,\">.4\")-SUM(AG312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.5\")+COUNTIF($Q274:$BI274,\">.5\")-SUM(AH312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.6\")+COUNTIF($Q274:$BI274,\">.6\")-SUM(AI312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.7\")+COUNTIF($Q274:$BI274,\">.7\")-SUM(AJ312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.8\")+COUNTIF($Q274:$BI274,\">.8\")-SUM(AK312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">.9\")+COUNTIF($Q274:$BI274,\">.9\")-SUM(AL312:AL312)","v":0},{"$f":"COUNTIF($Q268:$BI268,\">1\")+COUNTIF($Q274:$BI274,\">1\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr B",{"$f":"COUNTIF($Q269:$BI269,\">-1\")+COUNTIF($Q275:$BI275,\">-1\")-SUM(S313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.9\")+COUNTIF($Q275:$BI275,\">-.9\")-SUM(T313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.8\")+COUNTIF($Q275:$BI275,\">-.8\")-SUM(U313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.7\")+COUNTIF($Q275:$BI275,\">-.7\")-SUM(V313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.6\")+COUNTIF($Q275:$BI275,\">-.6\")-SUM(W313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.5\")+COUNTIF($Q275:$BI275,\">-.5\")-SUM(X313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.4\")+COUNTIF($Q275:$BI275,\">-.4\")-SUM(Y313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.3\")+COUNTIF($Q275:$BI275,\">-.3\")-SUM(Z313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.2\")+COUNTIF($Q275:$BI275,\">-.2\")-SUM(AA313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-.1\")+COUNTIF($Q275:$BI275,\">-.1\")-SUM(AB313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">-0\")+COUNTIF($Q275:$BI275,\">0\")-SUM(AC313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.1\")+COUNTIF($Q275:$BI275,\">.1\")-SUM(AD313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.2\")+COUNTIF($Q275:$BI275,\">.2\")-SUM(AE313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.3\")+COUNTIF($Q275:$BI275,\">.3\")-SUM(AF313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.4\")+COUNTIF($Q275:$BI275,\">.4\")-SUM(AG313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.5\")+COUNTIF($Q275:$BI275,\">.5\")-SUM(AH313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.6\")+COUNTIF($Q275:$BI275,\">.6\")-SUM(AI313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.7\")+COUNTIF($Q275:$BI275,\">.7\")-SUM(AJ313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.8\")+COUNTIF($Q275:$BI275,\">.8\")-SUM(AK313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">.9\")+COUNTIF($Q275:$BI275,\">.9\")-SUM(AL313:AL313)","v":0},{"$f":"COUNTIF($Q269:$BI269,\">1\")+COUNTIF($Q275:$BI275,\">1\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr C",{"$f":"COUNTIF($Q270:$BI270,\">-1\")+COUNTIF($Q276:$BI276,\">-1\")-SUM(S314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.9\")+COUNTIF($Q276:$BI276,\">-.9\")-SUM(T314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.8\")+COUNTIF($Q276:$BI276,\">-.8\")-SUM(U314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.7\")+COUNTIF($Q276:$BI276,\">-.7\")-SUM(V314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.6\")+COUNTIF($Q276:$BI276,\">-.6\")-SUM(W314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.5\")+COUNTIF($Q276:$BI276,\">-.5\")-SUM(X314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.4\")+COUNTIF($Q276:$BI276,\">-.4\")-SUM(Y314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.3\")+COUNTIF($Q276:$BI276,\">-.3\")-SUM(Z314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.2\")+COUNTIF($Q276:$BI276,\">-.2\")-SUM(AA314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-.1\")+COUNTIF($Q276:$BI276,\">-.1\")-SUM(AB314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">-0\")+COUNTIF($Q276:$BI276,\">0\")-SUM(AC314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.1\")+COUNTIF($Q276:$BI276,\">.1\")-SUM(AD314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.2\")+COUNTIF($Q276:$BI276,\">.2\")-SUM(AE314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.3\")+COUNTIF($Q276:$BI276,\">.3\")-SUM(AF314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.4\")+COUNTIF($Q276:$BI276,\">.4\")-SUM(AG314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.5\")+COUNTIF($Q276:$BI276,\">.5\")-SUM(AH314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.6\")+COUNTIF($Q276:$BI276,\">.6\")-SUM(AI314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.7\")+COUNTIF($Q276:$BI276,\">.7\")-SUM(AJ314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.8\")+COUNTIF($Q276:$BI276,\">.8\")-SUM(AK314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">.9\")+COUNTIF($Q276:$BI276,\">.9\")-SUM(AL314:AL314)","v":0},{"$f":"COUNTIF($Q270:$BI270,\">1\")+COUNTIF($Q276:$BI276,\">1\")","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appr C"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Analysis:"]

{"sheet":"GR&R X&R","index":17,"n_rows":111,"n_cols":64,"rows_kept":111,"cut":false,"hidden":false,"merged":[[89,19,89,20],[93,19,93,20],[96,19,96,20],[99,24,99,26],[90,27,90,29],[91,27,91,29],[93,27,93,29],[95,24,95,26],[94,24,94,26],[94,27,94,29],[95,27,95,29],[104,19,104,20],[96,27,96,29],[97,27,97,29],[97,24,97,26],[98,24,98,26],[96,24,96,26],[98,27,98,29],[99,27,99,29],[87,24,87,29],[89,24,89,26],[89,27,89,29],[90,24,90,26],[93,24,93,26],[91,24,91,26],[92,24,92,26],[92,27,92,29],[98,2,98,3],[98,4,98,5],[96,2,96,3],[96,4,96,5],[97,2,97,3],[97,4,97,5],[95,4,95,5],[92,2,92,3],[92,4,92,5],[93,2,93,3],[93,4,93,5],[94,2,94,3],[94,4,94,5],[95,2,95,3],[89,2,89,3],[89,4,89,5],[90,2,90,3],[90,4,90,5],[91,2,91,3],[91,4,91,5],[77,2,77,3],[77,4,77,5],[76,24,76,26],[76,27,76,29],[77,24,77,26],[77,27,77,29],[77,15,77,16],[77,19,77,20],[73,24,73,29],[75,2,75,3],[75,4,75,5],[76,2,76,3],[76,4,76,5],[75,19,75,20],[75,24,75,26],[75,27,75,29],[85,19,85,20],[78,24,78,26],[78,27,78,29],[79,19,79,20],[81,19,81,20],[49,22,49,31],[28,7,28,8],[71,19,71,20],[68,27,68,28],[69,27,69,28],[70,27,70,28],[71,27,71,28],[69,25,69,26],[70,25,70,26],[71,25,71,26],[67,19,67,20],[69,19,69,20],[65,1,65,31],[67,27,67,28],[67,25,67,26],[68,25,68,26],[0,0,0,18],[1,0,1,18],[50,0,50,1],[49,2,49,11],[7,2,7,3],[7,7,7,8],[7,12,7,13],[49,12,49,21],[28,2,28,3],[28,12,28,13]]}
["VARIABLES CONTROL CHART ( x & R )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PART NO.",null,null,null,null,null,null,null,null,null,"CHART NO."]
["MEASUREMENT EVALUATION"]
["PART NAME (Product)",null,null,null,null,null,null,null,null,null,null,null,"OPERATION (Process)",null,null,null,null,null,null,null,null,null,null,"SPECIFICATION LIMITS"]
[]
["APPRAISER A",null,null,null,"APPRAISER B",null,null,null,null,"APPRAISER C",null,null,null,null,"MACHINE",null,null,null,"GAGE",null,null,null,"UNIT OF MEASURE",null,null,null,null,"ZERO EQUALS"]
[]
[]
[null,"x =",{"$f":"IF(C52<>\"\",AVERAGE(C58:AF58),\"\")","v":""},null,null,"UCL =",null,{"$f":"IF(C8<>\"\",C8+AI16*C29,\"\")","v":""},null,null,"LCL =",null,{"$f":"IF(C8<>\"\",C8-AI16*C29,\"\")","v":""},null,null,null,null,null,"AVERAGES (X BAR CHART)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X BAR CHART INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATAPOINT",1,{"$f":"AI10+1","v":2},{"$f":"AJ10+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL LINE",{"$f":"$H$8","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE",{"$f":"$C$8","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",{"$f":"C58","v":""},{"$f":"IF(D52<>\"\",D58,AJ12)","v":""},{"$f":"IF(E52<>\"\",E58,AK12)","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL LINE",{"$f":"$M$8","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A2=",{"$f":"IF(COUNT(C52:C56)=5,0.577,IF(COUNT(C52:C56)=4,0.729,IF(COUNT(C52:C56)=3,1.023,1.88)))","v":1.88}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"r =",{"$f":"IF(C59<>\"\",AVERAGE(C59:AF59),\"\")","v":""},null,null,"UCL =",null,{"$f":"IF(C52=\"\",\"\",IF(COUNT(C52:C56)=5,AI34*2.115,IF(COUNT(C52:C56)=4,AI34*2.282,IF(COUNT(C52:C56)=3,AI34*2.575,AI34*3.267))))","v":""},null,null,"LCL =",null,{"$f":"IF(C52<>\"\",0,\"\")","v":""},null,null,null,null,null,null,"RANGES (R CHART)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANGE CHART INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATAPOINT",1,{"$f":"AI32+1","v":2},3,4,5,6,7,8,9,10,11,{"$f":"AS32+1","v":12},13,14,15,16,17,18,19,20,21,{"$f":"BC32+1","v":22},23,24,25,26,27,28,29,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL LINE",{"$f":"$H$29","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE",{"$f":"AVERAGE(C59:AF59)","v":{"$error":"#DIV/0!"}},{"$f":"$AI$34","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANGE",{"$f":"C59","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL LINE",{"$f":"$M$29","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"APPRAISER A",null,null,null,null,null,null,null,null,null,"APPRAISER B",null,null,null,null,null,null,null,null,null,"APPRAISER C"]
["PART NUMBER",null,1,{"$f":"C51+1","v":2},3,4,5,6,7,8,9,10,1,{"$f":"M51+1","v":2},3,4,5,6,7,8,9,10,1,{"$f":"W51+1","v":2},3,4,5,6,7,8,9,10]
["R",1]
["EA",2]
["D I",3]
["NG",4]
["S",5]
["SUM",null,{"$f":"IF(C52<>\"\",SUM(C52:C56),\"\")","v":""},{"$f":"IF(D52<>\"\",SUM(D52:D56),\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(T52<>\"\",SUM(T52:T56),\"\")","v":""},"","","","","","","","","","","",""]
["x","SUM NUM",{"$f":"IF(C52<>\"\",AVERAGE(C52:C56),\"\")","v":""},{"$f":"IF(D52<>\"\",AVERAGE(D52:D56),\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(T52<>\"\",AVERAGE(T52:T56),\"\")","v":""},"","","","","","","","","","","",""]
["R","HIGH- LOW",{"$f":"IF(C52<>\"\",MAX(C52:C56)-MIN(C52:C56),\"\")","v":""},{"$f":"IF(D52<>\"\",MAX(D52:D56)-MIN(D52:D56),\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(T52<>\"\",MAX(T52:T56)-MIN(T52:T56),\"\")","v":""},"","","","","","","","","","","",""]
[null,null,{"$f":"IF(C59<>\"\",IF(C59>$H$29,\"**\",\"\"),\"\")","v":""},{"$f":"IF(D59<>\"\",IF(D59>$H$29,\"**\",\"\"),\"\")","v":""},"","","","","","","","","","","","","","","",{"$f":"IF(T59<>\"\",IF(T59>$H$29,\"**\",\"\"),\"\")","v":""},"","","","","","","","","","","",""]
[null,null,"** = POINT OUT OF CONTROL"]
[]
[]
[]
[]
[null,"Computations for the Control Chart Method of Evaluating a Measurement Process"]
[]
[null,"REPLICATION ERROR:",null,null,null,null,null,"Average Subgroup Range = r =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"C29","v":""},null,null,null,null,null,"r",null,"d2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,1.1259999999999999]
[null,null,null,null,null,null,null,"Number of replications = Subgroup Size = r  = ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C52<>\"\",COUNT(C52:C56),\"\")","v":""},null,null,null,null,null,3,null,1.6930000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,2.0590000000000002]
[null,null,null,null,null,null,null,"Estimate Replication Standard Deviation r / d2 = se =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T68<>\"\",T68/VLOOKUP(T70,Z69:AC72,3),\"\")","v":""},null,null,null,null,null,5,null,2.3260000000000001]
[]
[null,"CALCULATION FOR APPRAISER EFFECT:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Appraiser Averages"]
[]
[null,null,"no",null,"d2*",null,null,"Number of Appraisers = nA =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AB77:AD79)","v":0},null,null,null,null,"Appraiser",null,null,"Average"]
[null,null,2,null,1.41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,{"$f":"IF(C58<>\"\",AVERAGE(C58:L58),\"\")","v":""}]
[null,null,3,null,1.9059999999999999,null,null,"Number of Samples = n =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(C52:L52)","v":0},null,null,null,null,"B",null,null,{"$f":"IF(M58<>\"\",AVERAGE(M58:V58),\"\")","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,"C",null,null,{"$f":"IF(W58=\"\",\"\",AVERAGE(W58:AF58))","v":""}]
[null,null,null,null,null,null,null,"Range of Appraiser Averages = RA = ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AB77:AD79)-MIN(AB77:AD79)","v":0}]
[]
[null,null,null,null,null,null,null,"Appraiser Effect = RA / d2* = sA = ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T76<>0,T80/VLOOKUP(T76,C77:F78,3),\"\")","v":""}]
[]
[null,"CALCULATIONS FOR MEASUREMENT ERROR STANDARD DEVIATION:"]
[]
[null,null,null,null,null,null,null,"sm","=","SQRT ( se + sA )",null,null,null,null,null,null,null,null,null,{"$f":"IF(T72<>\"\",SQRT(T72*T72+T82*T82),\"\")","v":""}]
[]
[null,"CALCULATIONS FOR SIGNAL TO NOISE RATIO:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sample Averages"]
[]
[null,null,"no",null,"d2*",null,null,"Range for these Sample Averages = Rp =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AB91:AD100)-MIN(AB91:AD100)","v":0},null,null,null,null,"Sample",null,null,"Average"]
[null,null,2,null,1.41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,null,null,{"$f":"IF(C58=\"\",\"\",(C58+M58+W58)/COUNT(C58,M58,W58))","v":""}]
[null,null,3,null,1.9059999999999999,null,null,"Estimate Sample to Sample Standard Deviation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,{"$f":"IF(D58=\"\",\"\",(D58+N58+X58)/COUNT(D58,N58,X58))","v":""}]
[null,null,4,null,2.2370000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,{"$f":"IF(E58=\"\",\"\",(E58+O58+Y58)/COUNT(E58,O58,Y58))","v":""}]
[null,null,5,null,2.4769999999999999,null,null,null,null,null,null,null,null,null,"sp","=","Rp / d2* =",null,null,{"$f":"IF(T78<>0,T90/VLOOKUP(T78,C91:F99,3),\"\")","v":""},null,null,null,null,4,null,null,{"$f":"IF(F58=\"\",\"\",(F58+P58+Z58)/COUNT(F58,P58,Z58))","v":""}]
[null,null,6,null,2.669,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,null,null,{"$f":"IF(G58=\"\",\"\",(G58+Q58+AA58)/COUNT(G58,Q58,AA58))","v":""}]
[null,null,7,null,2.827,null,null,"Signal to Noise Ratio:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,{"$f":"IF(H58=\"\",\"\",(H58+R58+AB58)/COUNT(H58,R58,AB58))","v":""}]
[null,null,8,null,2.9609999999999999,null,null,null,null,null,null,null,null,null,null,"sp / sm =",null,null,null,{"$f":"IF(T86<>\"\",T94/T86,\"\")","v":""},null,null,null,null,7,null,null,{"$f":"IF(I58=\"\",\"\",(I58+S58+AC58)/COUNT(I58,S58,AC58))","v":""}]
[null,null,9,null,3.0760000000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,{"$f":"IF(J58=\"\",\"\",(J58+T58+AD58)/COUNT(J58,T58,AD58))","v":""}]
[null,null,10,null,3.1779999999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,{"$f":"IF(K58=\"\",\"\",(K58+U58+AE58)/COUNT(K58,U58,AE58))","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,10,null,null,{"$f":"IF(L58=\"\",\"\",(L58+V58+AF58)/COUNT(L58,V58,AF58))","v":""}]
[]
[]
[null,null,"Thus the number of distinct categories that can be reliably distinguished by these measurements is:"]
[]
[null,null,null,null,null,"ndc =",null,"1.41 x sp / sm =",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T97<>\"\",TRUNC(T97*1.41),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T105<>\"\",IF(T105<5,\"Gage discrimination low\",\"Gage discrimination acceptable\"),\"\")","v":""}]
[]
[null,null,"This is the number of non-overlapping 97% confidence intervals that will span the range of product variation.  (A 97% confidence"]
[null,null,"interval centered on a single measurement would contain the actual product value that is represented by that measurement 97%"]
[null,null,"of the time.)"]

{"sheet":"Gage R","index":18,"n_rows":53,"n_cols":44,"rows_kept":53,"cut":false,"hidden":false,"merged":[[50,17,50,18],[5,22,5,26],[0,0,0,15],[1,0,1,15],[48,1,48,25],[8,2,8,3],[8,7,8,8],[8,12,8,13],[5,17,5,21],[28,2,28,3],[28,7,28,8],[28,12,28,13],[42,0,42,1],[43,0,43,1]]}
["GAGE R STUDY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PART NO.",null,null,null,null,null,null,null,"CHART NO."]
["MEASUREMENT EVALUATION"]
["PART NAME (Product)",null,null,null,null,null,null,null,null,null,"OPERATION (Process)",null,null,null,null,null,null,null,null,"ZERO EQUALS"]
[]
["APPRAISER ",null,null,null,"MACHINE",null,null,null,"GAGE",null,null,null,"UNIT OF MEASURE",null,null,null,null,"UPPER SPECIFICATION",null,null,null,null,"LOWER SPECIFICATION"]
[]
[]
[null,"AVERAGES (X BAR CHART)"]
[null,"x =",{"$f":"IF(C44<>\"\",AVERAGE(C44:L44),\"\")","v":""},null,null,"UCL =",null,{"$f":"IF(C9<>\"\",C9+AI17*C29,\"\")","v":""},null,null,"LCL =",null,{"$f":"IF(C9<>\"\",C9-AI17*C29,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X BAR CHART INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATAPOINT",1,{"$f":"AI11+1","v":2},{"$f":"AJ11+1","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL LINE",{"$f":"$H$9","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE",{"$f":"$C$9","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X",{"$f":"IF(C44<>\"\",C44,\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL LINE",{"$f":"$M$9","v":""},{"$f":"AI15","v":""},{"$f":"AJ15","v":""},"","","","","","",""]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E2",2.66]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"RANGES (R CHART)"]
[null,"r =",{"$f":"IF(C44<>\"\",AVERAGE(C45:L45),\"\")","v":""},null,null,"UCL =",null,{"$f":"IF(C29=\"\",\"\",C29*3.27)","v":""},null,null,"LCL =",null,{"$f":"IF(C29<>\"\",0,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANGE CHART INFORMATION"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DATAPOINT",1,{"$f":"AI33+1","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UCL LINE",{"$f":"$H$29","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AVERAGE",{"$f":"AVERAGE(C45:L45)","v":0},{"$f":"$AI$35","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RANGE",{"$f":"C45","v":"n/a"},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LCL LINE",{"$f":"$M$29","v":""},"","","","","","","","",""]
[]
[]
[]
[]
[]
["READING",null,1,{"$f":"C43+1","v":2},3,4,5,6,7,8,9,10]
["VALUE"]
["R","HIGH- LOW","n/a",{"$f":"ABS(D44-C44)","v":0},{"$f":"ABS(E44-D44)","v":0},0,0,0,0,0,0,0]
[null,null,{"$f":"IF(C45<>\"\",IF(OR(C44>$H$9,C44<$M$9),\"**\",\"\"),\"\")","v":""},{"$f":"IF(D45<>\"\",IF(OR(D45>$H$29,D44>$H$9,D44<$M$9),\"**\",\"\"),\"\")","v":""},{"$f":"IF(E45<>\"\",IF(OR(E45>$H$29,E44>$H$9,E44<$M$9),\"**\",\"\"),\"\")","v":""},"","","","","","",""]
[null,null,"** = POINT OUT OF CONTROL"]
[]
[null,"GAGE R ANALYSIS"]
[]
[null,"Data in control?",null,null,null,null,{"$f":"IF(L44<>\"\",IF(OR(C46<>\"\",D46<>\"\",E46<>\"\",F46<>\"\",G46<>\"\",H46<>\"\",I46<>\"\",J46<>\"\",K46<>\"\",L46<>\"\"),\"No\",\"Yes\"),\"\")","v":""},null,null,null,null,"% Repeatability =",null,null,null,null,null,{"$f":"IF(L44<>\"\",STDEV(C44:L44)*6/(R6-W6)*100,\"\")","v":""},null,null,null,null,{"$f":"IF(R51<>\"\",IF(R51>30,\"Reject\",\"Accept\"),\"\")","v":""}]
[]
[null,"This method CANNOT be used for final gage acceptance without other complete and detailed MSA methods."]

{"sheet":"TI PPC","index":19,"n_rows":59,"n_cols":16,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,1,1,17],[7,7,7,8],[9,16,9,17],[9,13,9,14],[9,5,9,8],[3,1,5,17],[11,5,11,8],[13,5,13,8],[11,13,11,14],[11,16,11,17],[13,15,13,17],[15,3,15,7],[31,10,31,14],[38,8,38,12],[41,1,44,17],[19,2,19,10],[20,4,20,11],[19,13,19,16],[54,12,54,13],[54,14,54,17],[58,0,58,18],[50,10,50,11],[52,6,52,11],[52,14,52,17],[52,12,52,13]]}
[]
[null,"PRODUCT / PROCESS CHANGE NOTIFICATION"]
[]
[null,"Complete this form and e-mail to your customer organization whenever customer notification is required by the PPAP Manual in Table 3.1.  Your customer will respond back with an acknowledgement and may request additional change clarification or PPAP submission requirements."]
[]
[]
[]
[null,"To:",null,null,null,null,null,"Customer:"]
[]
[null,"Organization Part Number:",null,null,null,null,null,null,null,"Engineering Revision Level:",null,null,null,null,null,"Dated:"]
[]
[null,"Customer Part Number:",null,null,null,null,null,null,null,"Engineering Revision Level:",null,null,null,null,null,"Dated:"]
[]
[null,"Purchase Order Number:",null,null,null,null,null,null,null,"Safety and/or Government Regulation:"]
[]
[null,"Application:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[null,"ORGANIZATION MANUFACTURING INFORMATION"]
[]
[null,"Name:",null,null,null,null,null,null,null,null,null,null,"Code:"]
[null,"Street Address:"]
[null,"City, State, Zip:",null,null,null,null,null,null,null,null,null,null,null,"Change Type (check all that apply)"]
[]
[null,"Customer Plants Affected:"]
[]
[null,"Design Responsibility:"]
[]
[null,"Organization Change That May Affect End Item:"]
[]
[]
[]
[null,"Expected PPAP Completion / Submission Date:"]
[]
[null,"DETAILED DESCRIPTION OF PRODUCT / PROCESS CHANGE:"]
[]
[]
[]
[]
[null,"Planned Date of Implementation:"]
[]
[null,"DECLARATION:"]
[null,"I hereby certify that representative samples will be manufactured using the revised product and/or process and verified, where appropriate, for dimensional change, appearance change, physical property change, functionally for performance and durability.  I also certify that documented evidence of such compliance is on file and available for customer review."]
[]
[]
[]
[]
[null,"Explanation/Comments:"]
[]
[]
[]
[null,"NAME:",null,null,null,null,null,null,null,null,"TITLE:"]
[]
[null,"BUSINESS PHONE NO:",null,null,null,null,null,null,null,null,null,null,"FAX NO:"]
[]
[null,"E-MAIL:",null,null,null,null,null,null,null,null,null,null,"DATE:"]
[]
[null,"NOTE: Please submit this notification at least 6 weeks prior to the planned change implementation!"]
[]
["Contact your customer to determine if this form is available in an electronic format or if this form should be faxed."]

{"sheet":"Flexfab PSW","index":20,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,18],[4,3,4,9],[12,13,12,14],[14,4,14,6],[6,5,6,9],[4,13,4,17],[6,13,6,17],[10,11,10,12],[8,11,8,12],[12,15,12,16],[8,5,8,8],[8,16,8,17],[10,16,10,17],[78,15,78,17],[71,13,71,14],[71,9,71,12],[14,12,14,14],[14,16,14,17],[59,1,62,17],[71,7,71,8],[69,15,69,17]]}
["If this form is not aligned properly, please complete the .pdf fillable form that is included in the .zip file…thank you"]
[]
[null,null,null,null,null,null,null,null,null,"Part Submission Warrant"]
[]
[null,"Part Name",null,null,null,null,null,null,null,null,"Cust. Part Number"]
[]
[null,"Shown on Drawing Number",null,null,null,null,null,null,null,null,"Orig. Part Number"]
[]
[null,"Engineering Change Level",null,null,null,null,null,null,null,null,"Dated",null,null,null,"Serial No. (if req'd)"]
[]
[null,"Additional Engineering Changes",null,null,null,null,null,null,null,null,"Dated",null,null,null,"Part Rev. (if req'd)"]
[]
[null,"Safety and/or Government Regulation",null,null,null,null,null,null,null,null,"Purchase Order No.",null,null,null,null,"Weight (kg)"]
[]
[null,"Checking Aid Number",null,null,null,null,null,"Checking Aid Eng. Change Level",null,null,null,null,null,null,null,"Dated"]
[]
[null,"ORGANIZATION MANUFACTURING INFORMATION",null,null,null,null,null,null,null,"CUSTOMER SUBMITTAL INFORMATION"]
[]
[]
[null,"Organization Name & Supplier/Vendor Code",null,null,null,null,null,null,null,null,"Customer Name/Division"]
[]
[]
[null,"Street Address",null,null,null,null,null,null,null,null,"Buyer/Buyer Code"]
[]
[]
[null,"City",null,null,"Region",null,"Postal Code",null,"Country",null,"Application"]
[]
[null,"MATERIALS REPORTING"]
[]
[null,"Has customer-required Substances of Concern information been reported?"]
[]
[null,null,null,"Submitted by IMDS or other customer format:"]
[]
[]
[null,"Are polymeric parts identified with appropriate ISO marking codes?"]
[]
[null,"SUBMISSION TYPE (Check at least one)",null,null,null,null,null,null,null,"SUBMISSION LEVEL (Check FULL unless directed)"]
[null,null,"Detail",null,null,"Assembly",null,null,null,null,"Full",null,null,"Partial (Delta)"]
[]
[null,"REASON FOR SUBMISSION (Check at least one)"]
[null,null,"Initial submission",null,null,null,null,null,null,null,null,null,"Change to Optional Construction or Material"]
[null,null,"Engineering Change(s)",null,null,null,null,null,null,null,null,null,"Sub-Supplier or Material Source Change"]
[null,null,"Tooling: Transfer, Replacement, Refurbishment, or additional",null,null,null,null,null,null,null,null,null,"Change in Part Processing"]
[null,null,"Correction of Discrepancy",null,null,null,null,null,null,null,null,null,"Parts produced at Additional Location"]
[null,null,"Tooling Inactive > than 1 year",null,null,null,null,null,null,null,null,null,"Other - please specify"]
[]
[null,"REQUESTED SUBMISSION LEVEL (Check one)"]
[null,null,"Level 1 - Warrant only (and for designated appearance items, an Appearance Approval Report) submitted to customer."]
[null,null,"Level 2 - Warrant with product samples and limited supporting data submitted to customer."]
[null,null,"Level 3 - Warrant with product samples and complete supporting data submitted to customer."]
[null,null,"Level 4 - Warrant and other requirements as defined by customer."]
[null,null,"Level 5 - Warrant with product samples and complete supporting data reviewed at organization's manufacturing location."]
[]
[null,"SUBMISSION RESULTS"]
[null,"The results for"]
[null,"These results meet all design record requirements:",null,null,null,null,null,null,null,null,null,"(If \"NO\" - Explanation Required)"]
[null,"Mold / Cavity / Production Process"]
[]
[null,"DECLARATION"]
[null,"I affirm that the samples represented by this warrant are representative of our parts, which were made by a process that meets all Production Part Approval Process Manual 4th Edition Requirements.  I further affirm that these samples were produced at the production rate of ____/____ hours.  I also certify that documented evidence of such compliance is on file and available for your review.  I have noted any deviation from this declaration below."]
[]
[]
[]
[]
[null,"EXPLANATION/COMMENTS:"]
[]
[]
[null,"Is each Customer Tool properly tagged and numbered?"]
[]
[null,"Organization Authorized Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,"Print Name",null,null,null,null,null,"Phone No.",null,null,null,null,null,"Fax No."]
[null,"Title",null,null,null,null,null,"E-mail"]
[]
[null,null,null,null,null,null,null,null,"FOR CUSTOMER USE ONLY (IF APPLICABLE)"]
[]
[null,"PPAP Warrant Disposition:"]
[]
[null,"Customer Signature",null,null,null,null,null,null,null,null,null,null,null,null,"Date"]
[]
[null,"Print Name",null,null,null,null,null,null,null,"Customer Tracking Number (optional)"]
[]
[null,"ZZZ-37735",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-01"]

{"sheet":"Instructions for Completing PSW","index":21,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"PART INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,1,"Part Name and 2a. Customer Part Number: Engineering released finished end item part name and number."]
[null,null,null,null,null,null,null,null,null,null,null,null,"2b.","Org, Part Number: Part number defined by the organization, if any."]
[null,null,null,null,null,null,null,null,null,null,null,null,3,"Shown on Drawing Number: The design record that specifies the customer part number being submitted."]
[null,null,null,null,null,null,null,null,null,null,null,null,4,"Engineering Change Level & Date: Show the change level and date of the design record."]
[null,null,null,null,null,null,null,null,null,null,null,null,5,"Additional Engineering Changes & Date: List all authorized engineering changes not yet incorporated in the design record but which are incorporated in the part."]
[null,null,null,null,null,null,null,null,null,null,null,null,6,"Safety and/or Government Regulation: ‘Yes” if so indicated by the design record, otherwise No.’"]
[null,null,null,null,null,null,null,null,null,null,null,null,7,"Purchase Order Number: Enter this number as found on the contract/purchase order."]
[null,null,null,null,null,null,null,null,null,null,null,null,8,"Weight: Enter the actual weight in kilograms to four decimal places unless otherwise specified by the customer."]
[null,null,null,null,null,null,null,null,null,null,null,null,"9,/10.","Checking Aid Number, Change Level and Date: if requested by the customer, enter the checking aid number, its change level and date."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"ORGANIZATION MANUFACTURING INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,11,"Organization Name & Supplier/Vendor Code: Show the name and code assigned to the manufacturing site on the purchase order contract."]
[null,null,null,null,null,null,null,null,null,null,null,null,12,"Street Address, Region, Postal Code, Country: Show the complete address of the location where the product was manufactured. For Region.’ enter state, county, province, etc."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"CUSTOMER SUBMITTAL INFORMATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,13,"Customer Name/Division: Show the corporate name and division or operations group."]
[null,null,null,null,null,null,null,null,null,null,null,null,14,"Buyer/Buyer Code: Enter the buyer’s name and code."]
[null,null,null,null,null,null,null,null,null,null,null,null,15,"Application: Enter the model year, vehicle name, engine, transmission, etc."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MATERIALS REPORTING"]
[null,null,null,null,null,null,null,null,null,null,null,null,16,"Substances of Concern: Enter \"Yes,\" \"No,\" or \"n/a\"."]
[null,null,null,null,null,null,null,null,null,null,null,null,"IMDS/Other Customer Format: Circle either \"IMDS\" or \"Other Customer Format\" as appropriate. If submitted via IMDS include: Module ID #, Version #, and Creation Date. If submitted via other customer format, enter the date customer confirmation was received."]
[null,null,null,null,null,null,null,null,null,null,null,null,17,"Polymeric Parts identification: Enter \"Yes,\" \"No,\" or \"n/a\"."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION TYPE"]
[null,null,null,null,null,null,null,null,null,null,null,null,18,"Check the appropriate box"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION LEVEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,19,"Check the appropriate box"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"REASON FOR SUBMISSION"]
[null,null,null,null,null,null,null,null,null,null,null,null,20,"Check the appropriate box(es). For bulk materials, in addition to checking the appropriate box, check \"Other\" and write \"Bulk Material\" in the space provided."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION LEVEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,21,"SUBMISSION LEVEL: Identify the submission level requested by the customer."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"SUBMISSION RESULTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,22,"Check the appropriate boxes for dimensional, material tests, performance tests, appearance evaluation, and statistical data."]
[null,null,null,null,null,null,null,null,null,null,null,null,23,"Check the appropriate box. if \"no,\" enter the explanation in \"comments\" below."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Molds/Cavities/Production Processes: For instruction, see PPAP Manual 4th Edition paragraph 2.2.18."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"DECLARATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,24,"Enter the number of pieces manufactured during the significant production run."]
[null,null,null,null,null,null,null,null,null,null,null,null,25,"Enter the time (in hours) taken for the significant production run."]
[null,null,null,null,null,null,null,null,null,null,null,null,26,"EXPLANATION/COMMENTS: Provide any explanatory comments on the Submission Results or any deviations from the Declaration. Attach additional information as appropriate."]
[null,null,null,null,null,null,null,null,null,null,null,null,27,"CUSTOMER TOOL TAGGING/NUMBERING: Are customer-owned tools identified in accord with ISO/TS 16949 and any customer-specific requirements, answer “Yes” or “No.” May not be applicable to OEM internal suppliers."]
[null,null,null,null,null,null,null,null,null,null,null,null,27,"ORGANIZATION AUTHORIZED SIGNATURE: A responsible organization official, after verifying that the results show conformance to all customer requirements and that all required documentation is available, shall approve the declaration and provide Title, Phone Number. Fax Number, and E-mail address."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"FOR CUSTOMER USE ONLY"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Leave blank."]

{"sheet":"LISTS","index":22,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CUSTOMER LIST",null,"D/P FMEA LISTS",null,null,null,"M FMEA LISTS"]
[null,"ACTIVE # IN DOCUMENT",1,"SEVERITY SCALE",null,null,null,"SEVERITY SCALE"]
[1,"GM",null,"10  Hazardous - w/o warning",null,null,null,"10  Hazardous - w/o warning"]
[2,"Ford Motor Company",null," 9  Hazardous - w/ warning",null,null,null," 9  Hazardous - w/ warning"]
[3,"DaimlerChrysler",null," 8  Very High",null,null,null," 8  Very High (Downtime - 8 hrs, Defects - 4 hrs)"]
[4,null,null," 7  High",null,null,null," 7  High (Downtime - 4-8 hrs, Defects - 2-4 hrs)"]
[5,null,null," 6  Moderate",null,null,null," 6  Moderate (Downtime - 1-4 hrs, Defects - 1-2 hrs)"]
[6,null,null," 5  Low",null,null,null," 5  Low (Downtime - 0.5-1 hrs, Defects - 0-1 hrs)"]
[7,null,null," 4  Very Low",null,null,null," 4  Very Low (Downtime - 10-30 min., 0 Defects)"]
[8,null,null," 3  Minor",null,null,null," 3  Minor (Downtime - 0-10 min., 0 Defects)"]
[9,null,null," 2  Very Minor",null,null,null," 2  Very Minor (0 Downtime, 0 Defects)"]
[10,null,null," 1  None",null,null,null," 1  None"]
[11,null,null,"OCCURENCE SCALE",null,null,null,"OCCURENCE SCALE"]
[12,null,null,"10  >100 Per 1,000",null,null,null,"10  1 in 1 hour, 1 in 90 cycles"]
[13,null,null," 9    50 Per 1,000",null,null,null,"9  1 in 8 hours, 1 in 900 cycles"]
[14,null,null," 8    20 per 1,000",null,null,null,"8  1 in 24 hour, 1 in 36,000 cycles"]
[15,null,null," 7    10 Per 1,000",null,null,null,"7  1 in 80 hour, 1 in 90,000 cycles"]
[16,null,null," 6    5 Per 1,000",null,null,null,"6  1 in 350 hour, 1 in 180,000 cycles"]
[17,null,null," 5    2 Per 1,000",null,null,null,"5  1 in 1,000 hour, 1 in 270,000 cycles"]
[18,null,null," 4    1 Per 1,000",null,null,null,"4  1 in 2,500 hour, 1 in 360,000 cycles"]
[19,null,null," 3    0.5 per 1,000",null,null,null,"3  1 in 5,000 hour, 1 in 540,000 cycles"]
[20,null,null," 2    0.1 Per 1,000",null,null,null,"2  1 in 10,000 hour, 1 in 900,000 cycles"]
[null,null,null," 1    <0.01 Per 1,000",null,null,null,"1  1 in 25,000 hour, 1 in >900,000 cycles"]
[null,null,null,"DETECTION SCALE",null,null,null,"DETECTION SCALE"]
[null,null,null,"10  Absolute Impossible",null,null,null,"10  Absolute Impossible"]
[null,null,null," 9  Very Remote",null,null,null," 9  Very Remote"]
[null,null,null," 8  Remote",null,null,null," 8  Remote"]
[null,null,null," 7  Very Low",null,null,null," 7  Very Low"]
[null,null,null," 6  Low",null,null,null," 6  Low"]
[null,null,null," 5  Moderate",null,null,null," 5  Moderate"]
[null,null,null," 4  Moderately High",null,null,null," 4  Moderately High"]
[null,null,null," 3  High",null,null,null," 3  High"]
[null,null,null," 2  Almost Certain",null,null,null," 2  Almost Certain"]
[null,null,null," 1  Certain",null,null,null," 1  Certain"]