{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["SPAT","Data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SPAT","index":0,"n_rows":58,"n_cols":54,"rows_kept":58,"cut":false,"hidden":false,"merged":[[48,0,48,8],[57,10,64,13]]}
["Single Point Articulation (SPAT) Accuracy Test Rev A"]
[]
["Name"]
["Date of Test",null,"Test Results"]
["Time of Test"]
["Microscribe Model","G2X 5DoF","Test 1",{"$f":"I19","v":0}]
["Serial Number","R","Test 2",{"$f":"N19","v":0}]
["Firmware Version","G 3.20","Test 3",{"$f":"S19","v":0}]
["Driver Version","3.0.0.1","Test 4",{"$f":"X19","v":0},null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z",null,null,"X","Y","Z"]
["MUS Units","Inch","Test 5",{"$f":"AC19","v":0}]
["Tip Installed","Point","Test 6",{"$f":"AH19","v":0}]
["MUS set to defualt tip?","Yes","Test 7",{"$f":"AM19","v":0}]
[null,null,"Test 8",{"$f":"AR19","v":0}]
[null,null,"Test 9",{"$f":"AW19","v":0}]
[null,null,"Test 10",{"$f":"BB19","v":0}]
[]
[null,null,"Average",{"$f":"SUM(D6:D15)/10","v":0}]
[null,"Specification",{"$f":"VLOOKUP(B6,Data!A2:B9,2,FALSE)","v":"G2X"},{"$f":"IF(VLOOKUP(B11,Data!F2:G8,2,FALSE)>0,VLOOKUP(B6,Data!A2:C9,3,FALSE)*VLOOKUP(B11,Data!F2:G8,2,FALSE),\"\")/2*IF(B10=\"Inch\",1,25.4)","v":8.9999999999999993E-3}]
[null,null,null,null,null,null,null,null,{"$f":"H48/2","v":0},null,null,null,null,{"$f":"M48/2","v":0},null,null,null,null,{"$f":"R48/2","v":0},null,null,null,null,{"$f":"W48/2","v":0},null,null,null,null,{"$f":"AB48/2","v":0},null,null,null,null,{"$f":"AG48/2","v":0},null,null,null,null,{"$f":"AL48/2","v":0},null,null,null,null,{"$f":"AQ48/2","v":0},null,null,null,null,{"$f":"AV48/2","v":0},null,null,null,null,{"$f":"BA48/2","v":0}]
[]
[null,null,null,null,null,{"$f":"SUM(F10:F19)/10","v":0},{"$f":"SUM(G10:G19)/10","v":0},{"$f":"SUM(H10:H19)/10","v":0},null,null,{"$f":"SUM(K10:K19)/10","v":0},{"$f":"SUM(L10:L19)/10","v":0},{"$f":"SUM(M10:M19)/10","v":0},null,null,{"$f":"SUM(P10:P19)/10","v":0},{"$f":"SUM(Q10:Q19)/10","v":0},{"$f":"SUM(R10:R19)/10","v":0},null,null,{"$f":"SUM(U10:U19)/10","v":0},{"$f":"SUM(V10:V19)/10","v":0},{"$f":"SUM(W10:W19)/10","v":0},null,null,{"$f":"SUM(Z10:Z19)/10","v":0},{"$f":"SUM(AA10:AA19)/10","v":0},{"$f":"SUM(AB10:AB19)/10","v":0},null,null,{"$f":"SUM(AE10:AE19)/10","v":0},{"$f":"SUM(AF10:AF19)/10","v":0},{"$f":"SUM(AG10:AG19)/10","v":0},null,null,{"$f":"SUM(AJ10:AJ19)/10","v":0},{"$f":"SUM(AK10:AK19)/10","v":0},{"$f":"SUM(AL10:AL19)/10","v":0},null,null,{"$f":"SUM(AO10:AO19)/10","v":0},{"$f":"SUM(AP10:AP19)/10","v":0},{"$f":"SUM(AQ10:AQ19)/10","v":0},null,null,{"$f":"SUM(AT10:AT19)/10","v":0},{"$f":"SUM(AU10:AU19)/10","v":0},{"$f":"SUM(AV10:AV19)/10","v":0},null,null,{"$f":"SUM(AY10:AY19)/10","v":0},{"$f":"SUM(AZ10:AZ19)/10","v":0},{"$f":"SUM(BA10:BA19)/10","v":0}]
[null,null,null,null,null,"Dev",null,null,"3-D Dev",null,null,null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev",null,"Dev",null,null,"3-D Dev"]
["Mean: 1.  Average coordinate (sample mean) of the 10 measurements.",null,null,null,null,{"$f":"F10-$F$21","v":0},{"$f":"G10-$G$21","v":0},{"$f":"H10-$H$21","v":0},{"$f":"SQRT(($F$21-F10)^2+($G$21-G10)^2+($H$21-H10)^2)","v":0},null,{"$f":"K10-$K$21","v":0},{"$f":"L10-$L$21","v":0},{"$f":"M10-$M$21","v":0},{"$f":"SQRT(($K$21-K10)^2+($L$21-L10)^2+($M$21-M10)^2)","v":0},null,{"$f":"P10-$P$21","v":0},{"$f":"Q10-$Q$21","v":0},{"$f":"R10-$R$21","v":0},{"$f":"SQRT(($P$21-P10)^2+($Q$21-Q10)^2+($R$21-R10)^2)","v":0},null,{"$f":"U10-$U$21","v":0},{"$f":"V10-$V$21","v":0},{"$f":"W10-$W$21","v":0},{"$f":"SQRT(($U$21-U10)^2+($V$21-V10)^2+($W$21-W10)^2)","v":0},null,{"$f":"Z10-$Z$21","v":0},{"$f":"AA10-$AA$21","v":0},{"$f":"AB10-$AB$21","v":0},{"$f":"SQRT(($Z$21-Z10)^2+($AA$21-AA10)^2+($AB$21-AB10)^2)","v":0},null,{"$f":"AE10-$AE$21","v":0},{"$f":"AF10-$AF$21","v":0},{"$f":"AG10-$AG$21","v":0},{"$f":"SQRT(($AE$21-AE10)^2+($AF$21-AF10)^2+($AG$21-AG10)^2)","v":0},null,{"$f":"AJ10-$AJ$21","v":0},{"$f":"AK10-$AK$21","v":0},{"$f":"AL10-$AL$21","v":0},{"$f":"SQRT(($AJ$21-AJ10)^2+($AK$21-AK10)^2+($AL$21-AL10)^2)","v":0},null,{"$f":"AO10-$AO$21","v":0},{"$f":"AP10-$AP$21","v":0},{"$f":"AQ10-$AQ$21","v":0},{"$f":"SQRT(($AO$21-AO10)^2+($AP$21-AP10)^2+($AQ$21-AQ10)^2)","v":0},null,{"$f":"AT10-$AT$21","v":0},{"$f":"AU10-$AU$21","v":0},{"$f":"AV10-$AV$21","v":0},{"$f":"SQRT(($AT$21-AT10)^2+($AU$21-AU10)^2+($AV$21-AV10)^2)","v":0},null,{"$f":"AY10-$AY$21","v":0},{"$f":"AZ10-$AZ$21","v":0},{"$f":"BA10-$BA$21","v":0},{"$f":"SQRT(($AY$21-AY10)^2+($AZ$21-AZ10)^2+($BA$21-BA10)^2)","v":0}]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,{"$f":"P11-$P$21","v":0},{"$f":"Q11-$Q$21","v":0},{"$f":"R11-$R$21","v":0},{"$f":"SQRT(($P$21-P11)^2+($Q$21-Q11)^2+($R$21-R11)^2)","v":0},null,{"$f":"U11-$U$21","v":0},{"$f":"V11-$V$21","v":0},{"$f":"W11-$W$21","v":0},{"$f":"SQRT(($U$21-U11)^2+($V$21-V11)^2+($W$21-W11)^2)","v":0},null,{"$f":"Z11-$Z$21","v":0},{"$f":"AA11-$AA$21","v":0},{"$f":"AB11-$AB$21","v":0},{"$f":"SQRT(($Z$21-Z11)^2+($AA$21-AA11)^2+($AB$21-AB11)^2)","v":0},null,{"$f":"AE11-$AE$21","v":0},{"$f":"AF11-$AF$21","v":0},{"$f":"AG11-$AG$21","v":0},{"$f":"SQRT(($AE$21-AE11)^2+($AF$21-AF11)^2+($AG$21-AG11)^2)","v":0},null,{"$f":"AJ11-$AJ$21","v":0},{"$f":"AK11-$AK$21","v":0},{"$f":"AL11-$AL$21","v":0},{"$f":"SQRT(($AJ$21-AJ11)^2+($AK$21-AK11)^2+($AL$21-AL11)^2)","v":0},null,{"$f":"AO11-$AO$21","v":0},{"$f":"AP11-$AP$21","v":0},{"$f":"AQ11-$AQ$21","v":0},{"$f":"SQRT(($AO$21-AO11)^2+($AP$21-AP11)^2+($AQ$21-AQ11)^2)","v":0},null,{"$f":"AT11-$AT$21","v":0},{"$f":"AU11-$AU$21","v":0},{"$f":"AV11-$AV$21","v":0},{"$f":"SQRT(($AT$21-AT11)^2+($AU$21-AU11)^2+($AV$21-AV11)^2)","v":0},null,{"$f":"AY11-$AY$21","v":0},{"$f":"AZ11-$AZ$21","v":0},{"$f":"BA11-$BA$21","v":0},{"$f":"SQRT(($AY$21-AY11)^2+($AZ$21-AZ11)^2+($BA$21-BA11)^2)","v":0}]
["Deviation from Mean: 2. Distance from each measurement to the average coordinate.",null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[null,null,null,null,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0,null,0,0,0,0]
[]
[null,null,null,null,null,{"$f":"STDEV(F23:F32)","v":0},{"$f":"STDEV(G23:G32)","v":0},{"$f":"STDEV(H23:H32)","v":0},{"$f":"STDEV(I23:I32)","v":0},null,{"$f":"STDEV(K23:K32)","v":0},{"$f":"STDEV(L23:L32)","v":0},{"$f":"STDEV(M23:M32)","v":0},{"$f":"STDEV(N23:N32)","v":0},null,{"$f":"STDEV(P23:P32)","v":0},{"$f":"STDEV(Q23:Q32)","v":0},{"$f":"STDEV(R23:R32)","v":0},{"$f":"STDEV(S23:S32)","v":0},null,{"$f":"STDEV(U23:U32)","v":0},{"$f":"STDEV(V23:V32)","v":0},{"$f":"STDEV(W23:W32)","v":0},{"$f":"STDEV(X23:X32)","v":0},null,{"$f":"STDEV(Z23:Z32)","v":0},{"$f":"STDEV(AA23:AA32)","v":0},{"$f":"STDEV(AB23:AB32)","v":0},{"$f":"STDEV(AC23:AC32)","v":0},null,{"$f":"STDEV(AE23:AE32)","v":0},{"$f":"STDEV(AF23:AF32)","v":0},{"$f":"STDEV(AG23:AG32)","v":0},{"$f":"STDEV(AH23:AH32)","v":0},null,{"$f":"STDEV(AJ23:AJ32)","v":0},{"$f":"STDEV(AK23:AK32)","v":0},{"$f":"STDEV(AL23:AL32)","v":0},{"$f":"STDEV(AM23:AM32)","v":0},null,{"$f":"STDEV(AO23:AO32)","v":0},{"$f":"STDEV(AP23:AP32)","v":0},{"$f":"STDEV(AQ23:AQ32)","v":0},{"$f":"STDEV(AR23:AR32)","v":0},null,{"$f":"STDEV(AT23:AT32)","v":0},{"$f":"STDEV(AU23:AU32)","v":0},{"$f":"STDEV(AV23:AV32)","v":0},{"$f":"STDEV(AW23:AW32)","v":0},null,{"$f":"STDEV(AY23:AY32)","v":0},{"$f":"STDEV(AZ23:AZ32)","v":0},{"$f":"STDEV(BA23:BA32)","v":0},{"$f":"STDEV(BB23:BB32)","v":0}]
[null,null,null,null,null,{"$f":"2*F34","v":0},{"$f":"2*G34","v":0},{"$f":"2*H34","v":0},{"$f":"2*I34","v":0},null,{"$f":"2*K34","v":0},{"$f":"2*L34","v":0},{"$f":"2*M34","v":0},{"$f":"2*N34","v":0},null,{"$f":"2*P34","v":0},{"$f":"2*Q34","v":0},{"$f":"2*R34","v":0},{"$f":"2*S34","v":0},null,{"$f":"2*U34","v":0},{"$f":"2*V34","v":0},{"$f":"2*W34","v":0},{"$f":"2*X34","v":0},null,{"$f":"2*Z34","v":0},{"$f":"2*AA34","v":0},{"$f":"2*AB34","v":0},{"$f":"2*AC34","v":0},null,{"$f":"2*AE34","v":0},{"$f":"2*AF34","v":0},{"$f":"2*AG34","v":0},{"$f":"2*AH34","v":0},null,{"$f":"2*AJ34","v":0},{"$f":"2*AK34","v":0},{"$f":"2*AL34","v":0},{"$f":"2*AM34","v":0},null,{"$f":"2*AO34","v":0},{"$f":"2*AP34","v":0},{"$f":"2*AQ34","v":0},{"$f":"2*AR34","v":0},null,{"$f":"2*AT34","v":0},{"$f":"2*AU34","v":0},{"$f":"2*AV34","v":0},{"$f":"2*AW34","v":0},null,{"$f":"2*AY34","v":0},{"$f":"2*AZ34","v":0},{"$f":"2*BA34","v":0},{"$f":"2*BB34","v":0}]
["Std Dev."]
["2 X Std Dev: 3. Twice the standard deviation (2*sspat )",null,null,null,null,{"$f":"F23*F23","v":0},{"$f":"G23*G23","v":0},{"$f":"H23*H23","v":0},null,null,{"$f":"K23*K23","v":0},0,0,null,null,{"$f":"P23*P23","v":0},0,0,null,null,{"$f":"U23*U23","v":0},0,0,null,null,{"$f":"Z23*Z23","v":0},0,0,null,null,{"$f":"AE23*AE23","v":0},0,0,null,null,{"$f":"AJ23*AJ23","v":0},0,0,null,null,{"$f":"AO23*AO23","v":0},0,0,null,null,{"$f":"AT23*AT23","v":0},0,0,null,null,{"$f":"AY23*AY23","v":0},0,0]
[null,null,null,null,null,{"$f":"F24*F24","v":0},0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[null,null,null,null,null,0,0,0,null,null,{"$f":"K32*K32","v":0},{"$f":"L32*L32","v":0},{"$f":"M32*M32","v":0},null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0,null,null,0,0,0]
[]
[null,null,null,null,null,null,null,{"$f":"2*SQRT(SUM(F37:H46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(K37:M46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(P37:R46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(U37:W46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(Z37:AB46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(AE37:AG46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(AJ37:AL46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(AO37:AQ46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(AT37:AV46)/9)","v":0},null,null,null,null,{"$f":"2*SQRT(SUM(AY37:BA46)/9)","v":0}]
["The B89.4.22 draft document refers to this test as the “Single Point Articulation Performance Test Using a Hard Probe.” At each location the following calculations are performed: \n1. Average coordinate (sample mean) of the 10 measurements. \n2. Distance from each measurement to the average coordinate. \n3. Twice the standard deviation (2*sspat ) \nThe SPAT performance reports the sspat at the location with the highest result from calculation 3. \n"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Copyright © 2015, 2016 Revware, Inc. All rights reserved. Revware, the Revware logo, and MicroScribe are registered trademarks of Revware, Inc. in the United States and other countries. All other trademarks are the property of their respective owners."]

{"sheet":"Data","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Model","Base","2SPAT","Units","Answer","Tip","Multiplier","Firm Ver"]
["G2X 5DoF","G2X",1.7999999999999999E-2,"Inch","Yes","Point",1,"G 3.17"]
["G2X 6DoF","G2X",1.7999999999999999E-2,"Millimeters","No","1/8\" Ball",1,"G 3.20"]
["G2LX 5DoF","G2LX",2.4E-2,null,null,"3mm Ball",1,"M 1.19"]
["G2LX 6DoF","G2LX",2.4E-2,null,null,"5mm Ball",1,"M 1.30"]
["MX 5DoF","MX",4.0000000000000001E-3,null,null,"6mm Ball",1]
["MX 6DoF","MX",4.0000000000000001E-3,null,null,".375\" Long Angle",3.5]
["MLX 5DoF","MLX",5.0000000000000001E-3,null,null,"Custom",0]
["MLX 6DoF","MLX",5.0000000000000001E-3]