{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["BIAIS","Linéarité","R & R  RAPIDE","R & R  COMPLET","R&R Attributs","CNOMO","init1","init2"],"not_rendered":{"charts":28,"images":0,"macros":1,"external_links":1,"defined_names":3,"comments":3,"pivot_tables":0},"unopened":[{"sheet":"init1","index":6,"reason":"part_missing"},{"sheet":"init2","index":7,"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":"BIAIS","index":0,"n_rows":251,"n_cols":24,"rows_kept":251,"cut":false,"hidden":false,"merged":[[32,3,32,11],[0,2,0,19],[16,3,16,11],[28,3,28,11],[29,3,29,5],[30,3,30,5],[29,8,29,10],[30,8,30,11]]}
["N°","Données","Mesure du biais d'une mesure"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"echantillon"]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"moyenne",{"$f":"L21","v":{"$error":"#DIV/0!"}},"moyenne"]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SEM",{"$f":"L22","v":{"$error":"#DIV/0!"}},"écartype sur l'échantillon"]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mediane",{"$f":"MEDIAN(B2:B251)","v":{"$error":"#NUM!"}},"Median"]
[5,null,null,"Risque alpha maximun choisi (bilatéral)",null,null,null,0.05,null,null,null,null,null,null,null,null,null,null,null,null,null,"Q1",{"$f":"PERCENTILE(B2:B251,0.25)","v":{"$error":"#NUM!"}},"premier quartile"]
[6,null,null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,"Q3",{"$f":"PERCENTILE(B2:B251,0.75)","v":{"$error":"#NUM!"}},"troisième quartile"]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",{"$f":"MIN(B2:B251)","v":0},"Minimum"]
[8,null,null,"Valeur \"vraie\" de la mesure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max",{"$f":"MAX(B2:B251)","v":0},"Maximum"]
[9,null,null,"Valeur réputée \"Vraie\" de la caraactéristique (m)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25 pct",{"$f":"W6","v":{"$error":"#NUM!"}},"position premier quartile"]
[10,null,null,"Intervalle de tolérance de la caractéristique",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"50 pct",{"$f":"W5-W6","v":{"$error":"#NUM!"}},"position médiane"]
[11,null,null,"Valeur de l'échantillon (si rien dans le tableau)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"75 pct",{"$f":"W7-W5","v":{"$error":"#NUM!"}},"position troisième quartile"]
[12,null,null,"Taille de l'échantillon (n)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"min",{"$f":"W6-W8","v":{"$error":"#NUM!"}},"position barre erreur bas"]
[13,null,null,"Valeur de la moyenne de l'échantillon",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"max",{"$f":"W9-W7","v":{"$error":"#NUM!"}},"position barre erreur du haut"]
[14,null,null,"Valeur de l'écart-type de l'échantillon"]
[15]
[16,null,null,"Test  t théorique pour savoir si le biiais est significatif ou non "]
[17,null,null,"Comparaison d'une moyenne à une valeur donnée; écart-type inconnu"]
[18,null,null,"Taille de l'échantillon (n)",null,null,{"$f":"IF(H14=\"\",COUNTA(B2:B251),H14)","v":0}]
[19,null,null,"Valeurs de la population",null,null,null,"Valeurs de l'échantillon"]
[20,null,null,"Valeur de la cible (m)",null,null,{"$f":"H10","v":0},"Valeur de la moyenne de l'échantillon",null,null,null,{"$f":"IF(H14=\"\",AVERAGE(B2:B251),H14)","v":{"$error":"#DIV/0!"}}]
[21,null,null,"Taille de l'échantillon (n)",null,null,{"$f":"IF(H13=\"\",COUNTA(B2:B251),H13)","v":0},"Valeur de l'écart-type de l'échantillon",null,null,null,{"$f":"IF(H15=\"\",STDEV(B2:B251),H15)","v":{"$error":"#DIV/0!"}}]
[22]
[23,null,null,"Fonction discriminante (t0)",null,null,{"$f":"ABS((L21-H10)/(L22/SQRT(G19)))","v":{"$error":"#DIV/0!"}},"t limite de la loi de student",null,null,null,{"$f":"TINV(H6,G22-1)","v":{"$error":"#NUM!"}}]
[24,null,null,null,null,null,null,"Risque alpha de conclure \"significatif\" à tort",null,null,null,{"$f":"TDIST(G24,G22-1,2)","v":{"$error":"#DIV/0!"}}]
[25,null,null,null,"Conclusion sur le biais",null,null,null,null,{"$f":"IF(G24>L24,\"Biais significatif\",\"Biais non significatif\")","v":{"$error":"#DIV/0!"}}]
[26]
[27]
[28,null,null,"Récapitulatif du test",null,null,null,null,null,null,null,null,null,"Intervalle sur l'échantillon","Moyenne théorique"]
[29,null,null,"Vraie valeur du mesurande",null,null,{"$f":"H10","v":0},null,"Importance du biais ",null,null,{"$f":"ABS(G31-G30)","v":{"$error":"#DIV/0!"}},null,{"$f":"N31+L24*L22/SQRT(G22)","v":{"$error":"#DIV/0!"}},{"$f":"H10","v":0}]
[30,null,null,"Moyenne des valeurs mesurées",null,null,{"$f":"L21","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(L30>(H11/20),\"Biais supérieur à IT/20\",\"Biais inférieur à IT/20\")","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"L21","v":{"$error":"#DIV/0!"}},{"$f":"O30","v":0}]
[31,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N31-L24*L22/SQRT(G22)","v":{"$error":"#DIV/0!"}},{"$f":"O30","v":0}]
[32,null,null,{"$f":"IF(G24>L24,IF(L30>H11/20,\"Biais significatif et important, pas acceptable\",\"Biais significatif mais faible, acceptable\"),IF(L30>H11/20,\"Biais non significatif mais important, pas acceptable problème de rpétabilité\",\"Biais non significatif et faible, acceptable\"))","v":{"$error":"#DIV/0!"}}]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]

{"sheet":"Linéarité","index":1,"n_rows":80,"n_cols":17,"rows_kept":80,"cut":false,"hidden":false,"merged":[[11,9,11,10],[0,0,0,17],[9,1,9,10],[10,1,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[2,0,2,2],[2,3,2,4],[2,5,2,6],[2,7,2,8],[2,9,2,10],[4,0,4,2],[4,5,4,6],[4,7,4,8],[3,9,3,10],[5,0,5,2],[5,5,5,6],[5,7,5,8],[5,9,5,10],[4,3,4,4],[3,0,3,2],[3,3,3,4],[3,5,3,6],[3,7,3,8],[4,9,4,10],[7,0,7,2],[6,9,6,10],[76,7,76,8],[75,9,75,10],[76,9,76,10],[74,1,74,2],[75,1,75,2],[74,3,74,4],[75,3,75,4],[75,7,75,8],[74,7,74,8],[74,9,74,10],[11,1,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[79,1,79,2],[79,3,79,4],[79,5,79,6],[76,1,76,2],[76,3,76,4]]}
["Mesure de la linéarité  d'une mesure"]
[]
["Analyse de linéarité",null,null,"Date ",null,null,null,"Référence ",null,null,null,null,null,"ref moy","ref","valeurs","Ecarts"]
["Moyen de mesure ",null,null,"Type ",null,null,null,"Référence ",null,null,null,null,null,{"$f":"O4-$O$55","v":0},{"$f":"$B$12","v":0},{"$f":"B14","v":0},{"$f":"P4-O4","v":0}]
["Pièce mesurée",null,null,"désignation",null,null,null,"Référence ",null,null,null,null,null,{"$f":"O5-$O$55","v":0},{"$f":"$B$12","v":0},{"$f":"B15","v":0},{"$f":"P5-O5","v":0}]
["Caractéristiques",null,null,"Désignation",null,null,null,"Tolérance mini",null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,"Tolérance maxi",null,null,null,null,null,0,0,0,0]
["Intervalle de tol",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"10 mesures consécutives de chacune des pièces",null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"Pièce 1",null,"Pièce 2",null,"Pièce 3",null,"Pièce 4",null,"Pièce 5",null,null,null,0,0,0,0]
["Mesure",null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,"Mes ","ecart ","Mes ","ecart ","Mes ","ecart ","Mes ","ecart ","Mes ","ecart ",null,null,0,0,0,0]
[1,null,{"$f":"B14-$B$12","v":0},null,{"$f":"D14-$D$12","v":0},null,{"$f":"F14-$F$12","v":0},null,{"$f":"H14-$H$12","v":0},null,{"$f":"J14-$J$12","v":0},null,null,0,{"$f":"$D$12","v":0},{"$f":"D14","v":0},0]
[2,null,{"$f":"B15-$B$12","v":0},null,{"$f":"D15-$D$12","v":0},null,{"$f":"F15-$F$12","v":0},null,{"$f":"H15-$H$12","v":0},null,{"$f":"J15-$J$12","v":0},null,null,0,{"$f":"$D$12","v":0},{"$f":"D15","v":0},0]
[3,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[4,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[5,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[6,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[7,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[8,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[9,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
[10,null,0,null,0,null,0,null,0,null,0,null,null,0,0,0,0]
["Moyenne",null,{"$f":"AVERAGE(C14:C23)","v":0},null,{"$f":"AVERAGE(E14:E23)","v":0},null,{"$f":"AVERAGE(G14:G23)","v":0},null,{"$f":"AVERAGE(I14:I23)","v":0},null,{"$f":"AVERAGE(K14:K23)","v":0},null,null,0,{"$f":"$F$12","v":0},{"$f":"F14","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$F$12","v":0},{"$f":"F15","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$H$12","v":0},{"$f":"H14","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$H$12","v":0},{"$f":"H15","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$J$12","v":0},{"$f":"J14","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$J$12","v":0},{"$f":"J15","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(O4:O53)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LINEST(Q4:Q53,O4:O53,,TRUE)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#NUM!"},49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Coefficients",null,"s ","Stat t","Probabilité",null,"Conclusion"]
[null,"Biais",null,{"$f":"P57","v":0},null,{"$f":"P58","v":0},{"$f":"ABS(D76/F76)","v":{"$error":"#DIV/0!"}},{"$f":"TDIST(G76,P60,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(H76<0.05,\"Significatif\",\"Non Significatif\")","v":{"$error":"#DIV/0!"}}]
[null,"Pente",null,{"$f":"O57","v":0},null,{"$f":"O58","v":0},{"$f":"ABS(D77/F77)","v":{"$error":"#DIV/0!"}},{"$f":"TDIST(G77,P60,2)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(H77<0.05,\"Significatif\",\"Non Significatif\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Importance du biais ",null,{"$f":"ABS(D76/D8)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(D80<0.05,\"Le biais est faible\", \"Le biais est important\")","v":{"$error":"#DIV/0!"}}]

{"sheet":"R & R  RAPIDE","index":2,"n_rows":155,"n_cols":31,"rows_kept":155,"cut":false,"hidden":false,"merged":[[3,5,3,6],[4,5,4,6],[5,5,5,6],[31,1,31,2]]}
[]
[]
[]
[null,"Moyen de mesure ",null,"Référence :",null,"Désignation :"]
[null,"Pièces mesurées",null,"Référence :",null,"Lot :"]
[null,"Caractéristiques",null,"Cible :",null,"Intervalle de tolérance"]
[]
[]
[]
[]
[]
[null,"Pièce","Contrôleur 1","Contôleur 2","Contrôleur 3","Moyenne /X","étendue R ",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(AND(C13=\"\",D13=\"\",E13=\"\"),0,1)","v":0}]
[null,1,null,null,null,{"$f":"IF(AE12=1,AVERAGE(C13:E13),\"\")","v":""},{"$f":"IF(AE12=1,(MAX(C13,D13,E13)-MIN(C13:E13)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,2,null,null,null,{"$f":"IF(AE13=1,AVERAGE(C14:E14),\"\")","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,3,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,4,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,5,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,6,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,7,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,8,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,9,null,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,10,null,null,null,"",""]
[null,null,null,null,"Moyennes :",{"$f":"AVERAGE(F13:F22)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(G13:G22)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"IF(SUM('R & R  RAPIDE'!B104:C104)<>0,\"Le nombre de mesures doit être identique pour chaque opérateur\",\"\")","v":""}]
[null,{"$f":"IF(MAX(G13:G22)>E26,\"La limite de contrôle des étendues est dépassée\",\"\")","v":{"$error":"#DIV/0!"}}]
[null,"LIC /X :",{"$f":"F23-G23*C115","v":{"$error":"#DIV/0!"}},"LSCR :",{"$f":"G23*C116","v":{"$error":"#DIV/0!"}}]
[null,"LSC /X :",{"$f":"F23+G23*C115","v":{"$error":"#DIV/0!"}}]
[]
["sigma i",{"$f":"G23/'R & R  RAPIDE'!C114","v":{"$error":"#DIV/0!"}},null,"IT mini pour être capable",null,{"$f":"24*B29","v":{"$error":"#DIV/0!"}}]
["dispersion i",{"$f":"6*B29","v":{"$error":"#DIV/0!"}}]
["Cpc",{"$f":"H6/(B30)","v":{"$error":"#DIV/0!"}}]
["Procédé :",{"$f":"IF(B31>4, \"capable\", \"non capable\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C13),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D13),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E13),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C14),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D14),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E14),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C15),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D15),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E15),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C16),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D16),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E16),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C17),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D17),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E17),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C18),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D18),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E18),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C19),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D19),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E19),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C20),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D20),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E20),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C21),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D21),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E21),0,1)","v":0}]
[{"$f":"IF(ISBLANK('R & R  RAPIDE'!C22),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!D22),0,1)","v":0},{"$f":"IF(ISBLANK('R & R  RAPIDE'!E22),0,1)","v":0},"Nb opérateur"]
[{"$f":"IF(SUM(A92:A101)=0,0,1)","v":0},{"$f":"IF(SUM(B92:B101)=0,0,1)","v":0},{"$f":"IF(SUM(C92:C101)=0,0,1)","v":0},{"$f":"SUM(A102:C102)","v":0}]
[{"$f":"SUM(A92:A101)","v":0},{"$f":"SUM(B92:B101)","v":0},{"$f":"SUM(C92:C101)","v":0},{"$f":"MAX(A103:C103)","v":0}]
[null,{"$f":"IF(B102=1,B103-$A103,0)","v":0},{"$f":"IF(C102=1,C103-$A103,0)","v":0}]
[]
[]
["Taille","d2","A2","D4"]
[2,1.1279999999999999,1.88,3.2669999999999999]
[3,1.6930000000000001,1.0229999999999999,2.5739999999999998]
[4,2.0590000000000002,0.72899999999999998,2.282]
[5,2.3260000000000001,0.57699999999999996,2.1139999999999999]
[6,2.3260000000000001,0.48599999999999999,2.004]
[]
[null,"d2*",{"$f":"VLOOKUP(D102,A136:V155,D103+1)","v":{"$error":"#N/A"}}]
[null,"A2",{"$f":"VLOOKUP(D102,A107:C112,3)","v":{"$error":"#N/A"}}]
[null,"D4",{"$f":"VLOOKUP(D102,A107:D112,4)","v":{"$error":"#N/A"}}]
[]
[]
[]
["LIC","LSC",null,"Moyennes"]
[{"$f":"C$26","v":{"$error":"#DIV/0!"}},{"$f":"C$27","v":{"$error":"#DIV/0!"}},{"$f":"$F$23","v":{"$error":"#DIV/0!"}},{"$f":"IF(F13=\"\",F$23,F13)","v":{"$error":"#DIV/0!"}},null,1,{"$f":"E$26","v":{"$error":"#DIV/0!"}}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,2,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,3,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,4,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,5,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,6,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,7,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,8,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,9,{"$error":"#DIV/0!"}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,10,{"$error":"#DIV/0!"}]
[]
[]
[null,"d2*"]
[]
[null,"Nombre de sous-groupes = Nombre de pièces x Nombre d'opérateurs"]
[null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,">20"]
[2,1.41421,1.2793099999999999,1.23105,1.20621,1.1910499999999999,1.18083,1.1734800000000001,1.16794,1.16361,1.1601399999999999,1.1572899999999999,1.1549,1.15289,1.1511499999999999,1.1496500000000001,1.1483300000000001,1.14717,1.1461300000000001,1.1452,1.1443700000000001,1.1283799999999999]
[3,1.9115500000000001,1.80538,1.76858,1.7498899999999999,1.7385699999999999,1.73099,1.7255499999999999,1.7214700000000001,1.71828,1.71573,1.71363,1.7118899999999999,1.71041,1.7091400000000001,1.70804,1.7070799999999999,1.7062299999999999,1.70547,1.7048000000000001,1.7041900000000001,1.6925699999999999]
[4,2.2388699999999999,2.15069,2.1204900000000002,2.1052200000000001,2.0960100000000002,2.0985,2.0854300000000001,2.0821200000000002,2.0795300000000001,2.0774599999999999,2.0757699999999999,2.07436,2.0731600000000001,2.07213,2.07125,2.0704699999999998,2.0667800000000001,2.0691700000000002,2.0686200000000001,2.06813,2.0587499999999999]
[5,2.4812400000000001,2.4004840000000001,2.3788299999999998,2.36571,2.3578100000000002,2.3525299999999998,2.3487499999999999,2.3459099999999999,2.3437000000000001,2.34192,2.3404799999999999,2.33927,2.3382399999999999,2.3373699999999999,2.3366099999999999,2.3359399999999999,2.3553500000000001,2.3348300000000002,2.3343600000000002,2.3339400000000001,2.3259300000000001]
[6,2.6725300000000001,2.6043799999999999,2.58127,2.5696400000000001,2.56263,2.5579499999999999,2.5546000000000002,2.5520800000000001,2.5501299999999998,2.5485600000000002,2.5472800000000002,2.5462099999999999,2.5423,2.5445199999999999,2.5438499999999999,2.5432600000000001,2.5427399999999998,2.5422799999999999,2.5418699999999999,2.54149,2.5344099999999998]
[7,2.8298100000000002,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,2.7043599999999999]
[8,2.9628800000000002,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,2.8472]
[9,3.0779399999999999,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,2.9700299999999999]
[10,3.1790500000000002,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,3.0775100000000002]
[11,3.2690899999999998,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,3.1728700000000001]
[12,3.3501599999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2584599999999999]
[13,3.4237799999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3359800000000002]
[14,3.4911599999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4067599999999998]
[15,3.5533299999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.47193]
[16,3.6107100000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5319799999999999]
[17,3.6642199999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5878800000000002]
[18,3.7142400000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6400600000000001]
[19,3.76118,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6889599999999998]
[20,3.8053699999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7349999999999999]

{"sheet":"R & R  COMPLET","index":3,"n_rows":171,"n_cols":50,"rows_kept":171,"cut":false,"hidden":false,"merged":[[4,0,4,2],[5,0,5,2],[6,9,6,10],[5,12,5,14],[6,12,6,14],[4,9,4,10],[5,9,5,10],[4,7,4,8],[4,5,4,6],[5,5,5,6],[2,7,2,8],[3,7,3,8],[2,0,2,2],[2,3,2,4],[2,5,2,6],[3,0,3,2],[3,3,3,4],[3,5,3,6],[29,3,29,6],[36,0,36,2],[29,0,29,2],[35,0,35,2],[32,0,32,2],[30,0,30,2],[31,0,31,2],[33,0,33,2],[32,14,32,15],[32,12,32,13],[31,12,31,13],[30,12,30,13],[115,0,115,2],[34,0,34,2],[38,0,38,17],[39,0,39,17],[40,0,40,17],[35,14,35,15],[35,12,35,13],[33,12,33,13],[33,14,33,15],[35,16,35,17],[0,0,0,13],[0,14,0,17],[34,12,34,14],[29,12,29,15],[29,7,29,10],[5,7,5,8],[2,9,2,10],[3,9,3,10],[29,16,29,17],[30,16,30,17],[31,16,31,17],[33,16,33,17],[32,16,32,17],[34,16,34,17],[30,14,30,15],[31,14,31,15]]}
["Cpc (Capabilité du processus de contrôle)\nMéthode de l'étendue et Analyse de la Variance",null,null,null,null,null,null,null,null,null,null,null,null,null,"Conception et réalisation  : Pr. Maurice Pillet\nUniversité de Savoie - Laboratoire SYMME \nIUT ANNECY QLIO - tous droits réservés",null,null,null,null,"CMC par l'Analyse de la Variance"]
[]
["Analyse Cpc",null,null,"Date ",null,null,null,"Référence "]
["Moyen de mesure ",null,null,"Type ",null,null,null,"Référence "]
["Pièce mesurée",null,null,"désignation",null,null,null,"Référence "]
["Caractéristiques",null,null,"Désignation",null,null,null,"Tolérance mini",null,null,null,null,"Intervalle de tol",null,null,{"$f":"J7-J6","v":0}]
[null,null,null,null,null,null,null,"Tolérance maxi",null,null,null,null,"Sigma connu de la population",null,null,null,null,null,null,null,null,"SS","ddl","Moy SS","ddl'","Moy SS'","Fexp","Flimite","Risque","Signif","Contr totale","Source","Variance","sigma","Sigma","Cont instrum","Cont totale"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pièces",{"$f":"O120*DEVSQ(AA17:AA26)","v":{"$error":"#NUM!"}},{"$f":"B132-1","v":-1},{"$f":"V8/W8","v":{"$error":"#NUM!"}},{"$f":"W8","v":-1},{"$f":"X8","v":{"$error":"#NUM!"}},{"$f":"IF(AC10<0.05,X8/X10,Z8/Z11)","v":{"$error":"#NUM!"}},{"$f":"FINV(0.05,W8,Y$10)","v":{"$error":"#NUM!"}},{"$f":"FDIST(AA8,W8,Y10)","v":{"$error":"#NUM!"}},{"$f":"IF(AA8>AB8,\"OUI\",\"NON\")","v":{"$error":"#NUM!"}},{"$f":"V8/V$12","v":{"$error":"#NUM!"}},"Pièces",{"$f":"IF(AC10<0.05,(Z8-Z10)/(K136*K137),(Z8-Z11)/(K137*K136))","v":{"$error":"#NUM!"}},{"$f":"SQRT(AG8)","v":{"$error":"#NUM!"}},{"$f":"IF(AH8<0,0,AH8)","v":{"$error":"#NUM!"}},null,{"$f":"AG8/$AG$12","v":{"$error":"#NUM!"}}]
[null,"Opérateur 1",null,null,null,null,"   Opérateur 2",null,null,null,null,"Opérateur 3",null,null,null,null,null,null,null,null,"Opérateurs",{"$f":"E132*DEVSQ(V22:V24)","v":{"$error":"#NUM!"}},{"$f":"K136-1","v":-1},{"$f":"V9/W9","v":{"$error":"#NUM!"}},{"$f":"W9","v":-1},{"$f":"X9","v":{"$error":"#NUM!"}},{"$f":"IF(AC10<0.05,X9/X10,Z9/Z11)","v":{"$error":"#NUM!"}},{"$f":"FINV(0.05,W9,Y$10)","v":{"$error":"#NUM!"}},{"$f":"FDIST(AA9,W9,Y10)","v":{"$error":"#NUM!"}},{"$f":"IF(AA9>AB9,\"OUI\",\"NON\")","v":{"$error":"#NUM!"}},{"$f":"V9/V$12","v":{"$error":"#NUM!"}},"reproductibilité",{"$f":"IF(Z9<Z11,0,IF(AC10<0.05,IF(Z9<Z10,0,(Z9-Z10)/(K138*K137)),(Z9-Z11)/(K138*K137)))","v":{"$error":"#NUM!"}},{"$f":"SQRT(AG9)","v":{"$error":"#NUM!"}},{"$f":"IF(AH9<0,0,AH9)","v":{"$error":"#NUM!"}},{"$f":"AG9/$AG$13","v":{"$error":"#NUM!"}},{"$f":"AG9/$AG$12","v":{"$error":"#NUM!"}}]
["N°","1ère","2ème","3ème","/X","R","1ère","2ème","3ème","/X","R","1ère","2ème","3ème","/X","R","//X","/R",null,null,"Pièces/opé",{"$f":"E131*DEVSQ(Z57:AB66)","v":{"$error":"#NUM!"}},{"$f":"W8*W9","v":1},{"$f":"V10/W10","v":{"$error":"#NUM!"}},{"$f":"IF(AC10>0.05,W11+W10,W10)","v":{"$error":"#NUM!"}},{"$f":"IF(AC10>0.05,0,X10)","v":{"$error":"#NUM!"}},{"$f":"X10/X11","v":{"$error":"#NUM!"}},{"$f":"FINV(0.05,W10,W$11)","v":{"$error":"#NUM!"}},{"$f":"FDIST(AA10,W10,W11)","v":{"$error":"#NUM!"}},{"$f":"IF(AA10>AB10,\"OUI\",\"NON\")","v":{"$error":"#NUM!"}},{"$f":"IF(AC10>0.05,0,)*V10/V$12","v":{"$error":"#NUM!"}},"Interaction",{"$f":"IF(AC10>0.05,0,(Z10-Z11)/K137)","v":{"$error":"#NUM!"}},{"$f":"SQRT(AG10)","v":{"$error":"#NUM!"}},{"$f":"IF(Z10-Z11>0,SQRT((Z10-Z11)/K137),0)","v":{"$error":"#NUM!"}},{"$f":"AG10/$AG$13","v":{"$error":"#NUM!"}},{"$f":"AG10/$AG$12","v":{"$error":"#NUM!"}}]
["pièce","mesure","mesure","mesure",null,null,"mesure","mesure","mesure",null,null,"mesure","mesure","mesure",null,null,null,null,null,null,"Résidus",{"$f":"V12-V9-V8-V10","v":{"$error":"#NUM!"}},{"$f":"W12-W9-W8-W10","v":0},{"$f":"V11/W11","v":{"$error":"#NUM!"}},{"$f":"IF(AC10>0.05,W10+W11,W11)","v":{"$error":"#NUM!"}},{"$f":"IF(AC10>0.05,(V10+V11)/(Y11),X11)","v":{"$error":"#NUM!"}},null,null,null,null,{"$f":"IF(AC10>0.05,(V10+V11)/V12,V11/V$12)","v":{"$error":"#NUM!"}},"répétabilité",{"$f":"Z11","v":{"$error":"#NUM!"}},{"$f":"SQRT(AG11)","v":{"$error":"#NUM!"}},{"$f":"SQRT(Z11)","v":{"$error":"#NUM!"}},{"$f":"AG11/$AG$13","v":{"$error":"#NUM!"}},{"$f":"AG11/$AG$12","v":{"$error":"#NUM!"}},null,null,null,null,"Xb1","Min1","Max1","Xb2","Min2","Max2","Xb3","Min3","Max3"]
[1,null,null,null,{"$f":"IF(ISBLANK(B12),\"\",AVERAGE(B12:D12))","v":""},{"$f":"IF(B12=\"\",\"\",MAX(B12:D12)-MIN(B12:D12))","v":""},null,null,null,{"$f":"IF(ISBLANK(G12),\"\",AVERAGE(G12:I12))","v":""},{"$f":"IF(G12=\"\",\"\",MAX(G12:I12)-MIN(G12:I12))","v":""},null,null,null,{"$f":"IF(ISBLANK(L12),\"\",AVERAGE(L12:N12))","v":""},{"$f":"IF(L12=\"\",\"\",MAX(L12:N12)-MIN(L12:N12))","v":""},{"$f":"IF(E12=\"\",\"\",AVERAGE(E12,J12,O12))","v":""},"",null,null,"Total",{"$f":"DEVSQ(B12:D21,G12:I21,L12:N21)","v":{"$error":"#NUM!"}},{"$f":"COUNT(B12:D21,G12:I21,L12:N21)-1","v":-1},{"$f":"VAR(B12:D21,G12:I21,L12:N21)","v":{"$error":"#DIV/0!"}},{"$f":"COUNT(D12:F21,I12:K21,N12:P21)-1","v":-1},{"$f":"X12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Total",{"$f":"SUM(AG8:AG11)","v":{"$error":"#NUM!"}},{"$f":"SQRT(AG12)","v":{"$error":"#NUM!"}},{"$f":"AH12","v":{"$error":"#NUM!"}},null,{"$f":"AG12/$AG$12","v":{"$error":"#NUM!"}},null,null,null,1,{"$f":"IF(E12=\"\",#N/A,E12)","v":{"$error":"#N/A"}},{"$f":"AP12-MIN(B12:D12)","v":{"$error":"#N/A"}},{"$f":"MAX(B12:D12)-AP12","v":{"$error":"#N/A"}},{"$f":"IF(J12=\"\",#N/A,J12)","v":{"$error":"#N/A"}},{"$f":"AS12-MIN(G12:I12)","v":{"$error":"#N/A"}},{"$f":"MAX(G12:I12)-AS12","v":{"$error":"#N/A"}},{"$f":"IF(O12=\"\",#N/A,O12)","v":{"$error":"#N/A"}},{"$f":"AV12-MIN(L12:N12)","v":{"$error":"#N/A"}},{"$f":"MAX(L12:N12)-AV12","v":{"$error":"#N/A"}}]
[2,null,null,null,{"$f":"IF(ISBLANK(B13),\"\",AVERAGE(B13:D13))","v":""},{"$f":"IF(B13=\"\",\"\",MAX(B13:D13)-MIN(B13:D13))","v":""},null,null,null,{"$f":"IF(ISBLANK(G13),\"\",AVERAGE(G13:I13))","v":""},{"$f":"IF(G13=\"\",\"\",MAX(G13:I13)-MIN(G13:I13))","v":""},null,null,null,{"$f":"IF(ISBLANK(L13),\"\",AVERAGE(L13:N13))","v":""},{"$f":"IF(L13=\"\",\"\",MAX(L13:N13)-MIN(L13:N13))","v":""},"","",null,null,"instrument",{"$f":"V9+V10+V11","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"AG12-AG8","v":{"$error":"#NUM!"}},{"$f":"AH12-AH8","v":{"$error":"#NUM!"}},null,null,null,null,null,null,2,{"$f":"IF(E13=\"\",#N/A,E13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(J13=\"\",#N/A,J13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(O13=\"\",#N/A,O13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[3,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[4,null,null,null,"","",null,null,null,"","",null,null,null,"","",{"$f":"IF(E15=\"\",\"\",AVERAGE(E15,J15,O15))","v":""},"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[5,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,null,null,null,null,null,"Moyenne","Effets","Graph",null,null,"Moyenne",null,null,"Effets",null,null,null,null,null,5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[6,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,"Disp instr",{"$f":"6*SQRT(AI9^2+AI10^2+AI11^2)","v":{"$error":"#NUM!"}},{"$f":"W17/6","v":{"$error":"#NUM!"}},null,"P 1",{"$f":"Q12","v":""},{"$f":"IF(O120>0,AA17-$F$24,\"\")","v":""},{"$f":"IF(ISNUMBER(AA17),AA17,#N/A)","v":{"$error":"#N/A"}},null,"Mes 1",{"$f":"B22","v":""},null,null,{"$f":"IF(AF17=\"\",\"\",AF17-$F$24)","v":""},{"$f":"IF(ISNUMBER(AF17),AF17,#N/A)","v":{"$error":"#N/A"}},null,null,null,null,6,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[7,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,"Cpc =",{"$f":"IF(V13=0,10000,P6/(W17))","v":{"$error":"#NUM!"}},null,null,"P 2","","",{"$f":"IF(ISNUMBER(AA18),AA18,#N/A)","v":{"$error":"#N/A"}},null,"Mes 2",{"$f":"C22","v":""},null,null,"",{"$error":"#N/A"},null,null,null,null,7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[8,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,null,null,null,null,"P 3","","",{"$error":"#N/A"},null,"Mes 3",{"$f":"G22","v":""},null,null,"",{"$error":"#N/A"},null,null,null,null,8,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[9,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,null,null,null,null,"P 4","","",{"$error":"#N/A"},null,"Mes 4",{"$f":"H22","v":""},null,null,"",{"$error":"#N/A"},null,null,null,null,9,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[10,null,null,null,"","",null,null,null,"","",null,null,null,"","","","",null,null,null,"Moyenne","Effets","Graph",null,"P 5","","",{"$error":"#N/A"},null,"Mes 5",{"$f":"L22","v":""},null,null,"",{"$error":"#N/A"},null,null,null,null,10,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF(B132>0,AVERAGE(B12:B21),\"\")","v":""},{"$f":"IF(C132>0,AVERAGE(C12:C21),\"\")","v":""},{"$f":"IF(D132>0,AVERAGE(D12:D21),\"\")","v":""},{"$f":"IF(E132=0,\"\",AVERAGE(E12:E21))","v":""},{"$f":"IF(E132=0,\"\",AVERAGE(F12:F21))","v":""},{"$f":"IF(G132>0,AVERAGE(G12:G21),\"\")","v":""},{"$f":"IF(H132>0,AVERAGE(H12:H21),\"\")","v":""},{"$f":"IF(I132>0,AVERAGE(I12:I21),\"\")","v":""},{"$f":"IF(J132=0,\"\",AVERAGE(J12:J21))","v":""},{"$f":"IF(J132=0,\"\",AVERAGE(K12:K21))","v":""},{"$f":"IF(L132>0,AVERAGE(L12:L21),\"\")","v":""},{"$f":"IF(M132>0,AVERAGE(M12:M21),\"\")","v":""},{"$f":"IF(N132>0,AVERAGE(N12:N21),\"\")","v":""},{"$f":"IF(O132=0,\"\",AVERAGE(O12:O21))","v":""},{"$f":"IF(O132=0,\"\",AVERAGE(P12:P21))","v":""},null,null,null,null,"Opérateur 1 ",{"$f":"E22","v":""},{"$f":"IF(E132>0,V22-$F$24,\"\")","v":""},{"$f":"IF(ISNUMBER(V22),V22,#N/A)","v":{"$error":"#N/A"}},null,"P 6","","",{"$error":"#N/A"},null,"Mes 6",{"$f":"M22","v":""},null,null,"",{"$error":"#N/A"}]
[null,null,null,null,"//X1","/R1",null,null,null,"//X2","/R2",null,null,null,"//X3","/R3",null,null,null,null,"Opérateur 2",{"$f":"J22","v":""},{"$f":"IF(J132>0,V23-$F$24,\"\")","v":""},{"$f":"IF(ISNUMBER(V23),V23,#N/A)","v":{"$error":"#N/A"}},null,"P 7","","",{"$error":"#N/A"}]
[null,"Moyenne générale = ",null,null,null,{"$f":"IF(K136=3,AVERAGE(E22,J22,O22),AVERAGE(J22,E22))","v":{"$error":"#DIV/0!"}},null,null,null,null,"//R =",{"$f":"AVERAGE(F22,K22,P22)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,"Opérateur 2",{"$f":"O22","v":""},{"$f":"IF(O132>0,V24-$F$24,\"\")","v":""},{"$f":"IF(ISNUMBER(V24),V24,#N/A)","v":{"$error":"#N/A"}},null,"P 8","","",{"$error":"#N/A"}]
["messages",null,{"$f":"IF(Q131=1,\"\",\"Les opérateurs doivent effectuer le même nombre de série de mesures\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P 9","","",{"$error":"#N/A"}]
[null,null,{"$f":"IF(Q132=1,\"\",\"Chaque opérateur doit contrôler le même nombre de pièces, le même nombre de fois\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P 10","","",{"$error":"#N/A"}]
[null,null,{"$f":"IF(AND(Q31=0,K138>0),\"Problème de définition de l'instrument de mesure, la dispersion de mesure est nulle\",\"\")","v":{"$error":"#NUM!"}}]
[null,null,{"$f":"IF(MAX(F12:F21,K12:K21,P12:P21)>B76,\"La limite des étendues est dépassée\",\"\")","v":{"$error":"#N/A"}}]
[]
["MSA",null,null,"Méthode Range",null,null,null,"Méthode ANAVAR",null,null,null,null,"Méthode Range",null,null,null,"ANAVAR"]
["sigma répétabilité (EV)",null,null,{"$f":"L24/E141","v":{"$error":"#DIV/0!"}},{"$f":"D31^2/(D31^2+D32^2)","v":{"$error":"#DIV/0!"}},{"$f":"D31/$D$36","v":{"$error":"#DIV/0!"}},{"$f":"D31/$D$37","v":{"$error":"#DIV/0!"}},{"$f":"AI11","v":{"$error":"#NUM!"}},{"$f":"H31^2/(H31^2+H32^2)","v":{"$error":"#NUM!"}},{"$f":"H31/$H$36","v":{"$error":"#NUM!"}},{"$f":"H31/$H$37","v":{"$error":"#NUM!"}},null,"s instrument",null,{"$f":"D34","v":{"$error":"#DIV/0!"}},null,{"$f":"H34","v":{"$error":"#NUM!"}}]
["sigma reproductibilité (AV)",null,null,{"$f":"IF(D115^2-(D31^2/(K137*K138))>0,SQRT(D115^2-(D31^2/(K137*K138))),0)","v":{"$error":"#N/A"}},{"$f":"D32^2/(D31^2+D32^2)","v":{"$error":"#N/A"}},{"$f":"D32/$D$36","v":{"$error":"#N/A"}},{"$f":"D32/$D$37","v":{"$error":"#N/A"}},{"$f":"SQRT(AI9^2+H33^2)","v":{"$error":"#NUM!"}},{"$f":"H32^2/(H31^2+H32^2)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"H32/$H$37","v":{"$error":"#NUM!"}},null,"Cpc=",null,{"$f":"IF(D34=0,10000,P6/(6*D34))","v":{"$error":"#DIV/0!"}},null,{"$f":"W18","v":{"$error":"#NUM!"}}]
["Interaction",null,null,"-","-","-","-",{"$f":"AI10","v":{"$error":"#NUM!"}},{"$f":"H33^2/(H31^2+H32^2)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"H33/$H$37","v":{"$error":"#NUM!"}},null,"Interaction",null,"-",null,{"$f":"AD10","v":{"$error":"#NUM!"}}]
["sigma instrument (GRR)",null,null,{"$f":"SQRT(POWER(D31,2)+POWER(D32,2))","v":{"$error":"#DIV/0!"}},1,{"$f":"D34/$D$36","v":{"$error":"#DIV/0!"}},{"$f":"D34/$D$37","v":{"$error":"#DIV/0!"}},{"$f":"SQRT(H31^2+H32^2)","v":{"$error":"#NUM!"}},1,{"$error":"#NUM!"},{"$f":"H34/$H$37","v":{"$error":"#NUM!"}},null,"Procédé:",null,{"$f":"IF(O32>4,\"acceptable\", \"inacceptable\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(Q32>4,\"acceptable\", \"inacceptable\")","v":{"$error":"#NUM!"}}]
["sigma pièces (PV)",null,null,{"$f":"IF(D116^2>D31^2/(K138*K137),SQRT(D116^2-D31^2/(K138*K137)))","v":{"$error":"#N/A"}},null,{"$f":"D35/$D$36","v":{"$error":"#N/A"}},{"$f":"D35/$D$37","v":{"$error":"#N/A"}},{"$f":"AI8","v":{"$error":"#NUM!"}},null,{"$error":"#NUM!"},{"$f":"H35/$H$37","v":{"$error":"#NUM!"}},null,"CpcProd (sprod/sMes)",null,null,{"$f":"IF(P7=\"\",D36/D34,P7/D34)","v":{"$error":"#N/A"}},{"$f":"IF(P7=\"\",H36/H34,P7/H34)","v":{"$error":"#NUM!"}}]
["Sigma Total (TV)",null,null,{"$f":"SQRT(D116^2+D31^2+D32^2)","v":{"$error":"#N/A"}},null,{"$f":"D36/$D$36","v":{"$error":"#N/A"}},"-",{"$f":"SQRT(H35^2+H31^2+H32^2)","v":{"$error":"#NUM!"}},null,{"$error":"#NUM!"},"-",null,"Nb de catégories\nndc",null,{"$f":"IF(P7=\"\",1.41*(D35/D34),1.41*(P7/D34))","v":{"$error":"#N/A"}},null,{"$f":"IF(P7=\"\",1.41*(H35/H34),1.41*(P7/H34))","v":{"$error":"#NUM!"}}]
["Sigma Total estimé (IT/6)",null,null,{"$f":"P6/6","v":0},null,"-",1,{"$f":"P6/6","v":0},null,"-",1]
[]
["Interprétation"]
[{"$f":"IF(Q32<3,\"La capabilité du processus de contrôle est inférieure à 3, le processus n'est pas adaptée à la tolérance souhaitée\",IF(Q32<4,\"La capabilité du processus de contrôle est < à 4 mais > à 3, le processus n'est pas adaptée à la tolérance souhaitée suf pour des tolérances très serrées\",\"La capabilité du processus de contrôle est supérieure à 4, le processus est adaptée à la tolérance souhaitée\"))","v":{"$error":"#NUM!"}}]
[{"$f":"IF(Q35<3,\"Le ratio Cpc Prod est inférieure à 3, le processus  de mersure n'est pas adaptée à la dispersion de la production observée\",IF(Q35<4,\"Le ratio Cpc Prod est < à 4 mais > à 3, le processus de mesure n'est pas adaptée à la la dispersion observée\",\"Le ratio Cpc Prod est est supérieure à 4, le processus de mesure est adaptée à la dispersion observée\"))","v":{"$error":"#NUM!"}}]
["Part de la dispersion imputable à la répétabilité des opérateurs ",null,null,null,null,null,null,null,{"$f":"I31","v":{"$error":"#NUM!"}}]
["Part de la dispersion imputable à la reproductibilité entre opérateurs",null,null,null,null,null,null,null,{"$f":"I32","v":{"$error":"#NUM!"}}]
["Part de la dispersion imputable à l'interaction pièces/opérateurs",null,null,null,null,null,null,null,{"$f":"I33","v":{"$error":"#NUM!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opé1","Opé2","Opé3",null,"Opé1","Opé2","Opé3",null,"Répétabilité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P1",{"$f":"IF(F12=\"\",\"\",AVERAGE(B12:D12))","v":""},{"$f":"IF(K12=\"\",\"\",AVERAGE(G12:I12))","v":""},{"$f":"IF(P12=\"\",\"\",AVERAGE(L12:N12))","v":""},"P1",{"$f":"IF(V57=\"\",\"\",V57-W$22-AB17-$F$24)","v":""},{"$f":"IF(W57=\"\",\"\",W57-W$23-AB17-$F$24)","v":""},{"$f":"IF(X57=\"\",\"\",X57-W$24-AB17-$F$24)","v":""},null,"Reproductibilité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2","","","","P2","","","",null,"Interaction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3","","","","P3","","","",null,"Instrument"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P4","","","","P4","","","",null,"Pieces"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P5","","","","P5","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P6","","","","P6","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P7","","","","P7","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P8","","","","P8","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P9","","","","P9","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P10","","","","P10","","",""]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opé1","Opé2","Opé3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P1",{"$f":"IF(V57=\"\",#N/A,V57)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P2",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P3",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["LSCR =",{"$f":"B140*L24","v":{"$error":"#N/A"}},null,"LSC /X :",{"$f":"F24+L24*B144","v":{"$error":"#DIV/0!"}},"LIC /X :",{"$f":"F24-L24*B144","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"P4",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P5",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P6",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P7",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P8",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P9",{"$f":"IF(V65=\"\",#N/A,V65)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"P10",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Reproductibilité",null,null,{"$f":"(MAX(E22,J22,O22)-MIN(E22,J22,O22))/E142","v":{"$error":"#N/A"}},{"$f":"D115^2-(D31^2/(K137*K138))","v":{"$error":"#N/A"}}]
["sigma pièces (PV)",null,null,{"$f":"(MAX(Q12:Q21)-MIN(Q12:Q21))/E143","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"OP1",null,null,null,null,"OP2",null,null,null,null,"OP3"]
[null,{"$f":"IF(ISBLANK(B12),0,1)","v":0},0,0,null,null,{"$f":"IF(ISBLANK(G12),0,1)","v":0},0,0,null,null,{"$f":"IF(ISBLANK(L12),0,1)","v":0},0,0,{"$f":"SUM(B120:D120,G120:I120,L120:N120)","v":0}]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,{"$f":"SUM(B121:D121,G121:I121,L121:N121)","v":0}]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,0,0,0,null,null,0,0,0,null,null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Test si nb de mesures constantes"]
[null,{"$f":"IF(SUM(B120:B129)=0,0,1)","v":0},{"$f":"IF(SUM(C120:C129)=0,0,1)","v":0},{"$f":"IF(SUM(D120:D129)=0,0,1)","v":0},{"$f":"SUM(B131:D131)","v":0},null,{"$f":"IF(SUM(G120:G129)=0,0,1)","v":0},{"$f":"IF(SUM(H120:H129)=0,0,1)","v":0},{"$f":"IF(SUM(I120:I129)=0,0,1)","v":0},{"$f":"SUM(G131:I131)","v":0},null,{"$f":"IF(SUM(L120:L129)=0,0,1)","v":0},{"$f":"IF(SUM(M120:M129)=0,0,1)","v":0},{"$f":"IF(SUM(N120:N129)=0,0,1)","v":0},{"$f":"SUM(L131:N131)","v":0},null,{"$f":"IF((E131+J131+O131)<>(K136*E131),0,1)","v":1}]
[null,{"$f":"SUM(B120:B129)","v":0},{"$f":"SUM(C120:C129)","v":0},{"$f":"SUM(D120:D129)","v":0},{"$f":"SUM(B132:D132)","v":0},null,{"$f":"SUM(G120:G129)","v":0},{"$f":"SUM(H120:H129)","v":0},{"$f":"SUM(I120:I129)","v":0},{"$f":"SUM(G132:I132)","v":0},null,{"$f":"SUM(L120:L129)","v":0},{"$f":"SUM(M120:M129)","v":0},{"$f":"SUM(N120:N129)","v":0},{"$f":"SUM(L132:N132)","v":0},null,{"$f":"IF((E132+J132+O132)<>(K136*E132),0,1)","v":1}]
[null,null,{"$f":"IF(C131=1,C132-$B132,0)","v":0},{"$f":"IF(D131=1,D132-$B132,0)","v":0},null,null,null,{"$f":"IF(H131=1,H132-$G132,0)","v":0},{"$f":"IF(I131=1,I132-$G132,0)","v":0},null,null,null,{"$f":"IF(M131=1,M132-$L132,0)","v":0},{"$f":"IF(N131=1,N132-$L132,0)","v":0}]
[null,null,null,{"$f":"IF(SUM(B120:D129)=0,0,1)","v":0},null,null,null,null,{"$f":"IF(SUM(G120:I129)=0,0,1)","v":0},null,null,null,null,{"$f":"IF(SUM(L120:N129)=0,0,1)","v":0}]
[]
["Taille","D4","d2","c4","A2",null,null,null,"Nb d'opérateur=",null,{"$f":"SUM(D134,I134,N134)","v":0}]
[2,3.2669999999999999,1.1283799999999999,0.79790000000000005,1.88,null,null,null,"Nb de mesures =",null,{"$f":"SUM(B131:D131)","v":0}]
[3,2.5739999999999998,1.6925699999999999,0.88619999999999999,1.0229999999999999,null,null,null,"Nb de pièces =",null,{"$f":"B132","v":0}]
[]
["D4",{"$f":"VLOOKUP(K137,A136:B138,2)","v":{"$error":"#N/A"}},null,null,null,null,null,null,"Rp ",{"$f":"MAX(Q12:Q21)-MIN(Q12:Q21)","v":0}]
["d2repe",{"$f":"VLOOKUP(K137,A136:C138,3)","v":{"$error":"#N/A"}},null,"d2* repe",{"$f":"IF(K138*K136>20,B141,VLOOKUP(K137,L148:AI153,K138*K136+1))","v":{"$error":"#N/A"}},null,null,null,"Rxb",{"$f":"MAX(E22,J22,O22)-MIN(E22,J22,O22)","v":0}]
["d2repr",{"$f":"VLOOKUP(K136,A136:C138,3)","v":{"$error":"#N/A"}},null,"d2*repro",{"$f":"VLOOKUP(K136,L148:AI153,2)","v":{"$error":"#N/A"}}]
["c4",{"$f":"VLOOKUP(K136,A136:D138,4)","v":{"$error":"#N/A"}},null,"d2*pièce",{"$f":"VLOOKUP(K138,L148:AI167,2)","v":{"$error":"#N/A"}}]
["A2",{"$f":"VLOOKUP(K136,A136:E138,5)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"d2*"]
[]
[null,"LSC","LIC","moyennes",null,null,"LSC",null,null,null,null,null,"Nombre de sous-groupes = Nombre de pièces x Nombre d'opérateurs"]
[{"$f":"F$24","v":{"$error":"#DIV/0!"}},{"$f":"E$76","v":{"$error":"#DIV/0!"}},{"$f":"G$76","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q12=\"\",#N/A,Q12)","v":{"$error":"#N/A"}},null,null,{"$f":"B$76","v":{"$error":"#N/A"}},null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,null,null,">20"]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,{"$f":"1/M149","v":0.7071085623775818},2,1.41421,1.2793099999999999,1.23105,1.20621,1.1910499999999999,1.18083,1.1734800000000001,1.16794,1.16361,1.1601399999999999,1.1572899999999999,1.1549,1.15289,1.1511499999999999,1.1496500000000001,1.1483300000000001,1.14717,1.1461300000000001,1.1452,1.1443700000000001,null,null,1.1283799999999999,{"$f":"1/AI149","v":0.88622627129158627}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,{"$f":"1/M150","v":0.52313567523737281},3,1.9115500000000001,1.80538,1.76858,1.7498899999999999,1.7385699999999999,1.73099,1.7255499999999999,1.7214700000000001,1.71828,1.71573,1.71363,1.7118899999999999,1.71041,1.7091400000000001,1.70804,1.7070799999999999,1.7062299999999999,1.70547,1.7048000000000001,1.7041900000000001,null,null,1.6925699999999999,{"$f":"1/AI150","v":0.59081751419439077}]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.44665389236534503,4,2.2388699999999999,2.15069,2.1204900000000002,2.1052200000000001,2.0960100000000002,2.0985,2.0854300000000001,2.0821200000000002,2.0795300000000001,2.0774599999999999,2.0757699999999999,2.07436,2.0731600000000001,2.07213,2.07125,2.0704699999999998,2.0667800000000001,2.0691700000000002,2.0686200000000001,2.06813,null,null,2.0587499999999999,0.48573163327261693]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.40302429430446063,5,2.4812400000000001,2.4004840000000001,2.3788299999999998,2.36571,2.3578100000000002,2.3525299999999998,2.3487499999999999,2.3459099999999999,2.3437000000000001,2.34192,2.3404799999999999,2.33927,2.3382399999999999,2.3373699999999999,2.3366099999999999,2.3359399999999999,2.3553500000000001,2.3348300000000002,2.3343600000000002,2.3339400000000001,null,null,2.3259300000000001,0.42993555266065614]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.37417727771063375,6,2.6725300000000001,2.6043799999999999,2.58127,2.5696400000000001,2.56263,2.5579499999999999,2.5546000000000002,2.5520800000000001,2.5501299999999998,2.5485600000000002,2.5472800000000002,2.5462099999999999,2.5423,2.5445199999999999,2.5438499999999999,2.5432600000000001,2.5427399999999998,2.5422799999999999,2.5418699999999999,2.54149,null,null,2.5344099999999998,0.39456915021642119]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.35338061565970857,7,2.8298100000000002,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,70,null,null,2.7043599999999999,0.36977325504000946]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.33750945026460738,8,2.9628800000000002,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,80,null,null,2.8472,0.35122225344197811]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.32489262298810245,9,3.0779399999999999,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,null,null,2.9700299999999999,0.33669693572118803]
[{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#N/A"},null,null,{"$error":"#N/A"},null,null,null,0.31455938094713826,10,3.1790500000000002,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,100,null,null,3.0775100000000002,0.32493801807305256]
[null,null,null,null,null,null,null,null,null,null,0.30589552444258189,11,3.2690899999999998,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,110,null,null,3.1728700000000001,0.31517206819062865]
[null,null,null,null,null,null,null,null,null,null,0.29849320629462472,12,3.3501599999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.2584599999999999,0.30689344045960365]
["Graphique des étendues",null,null,null,null,null,null,null,null,null,0.2920748412573238,13,3.4237799999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.3359800000000002,0.29976198898074929]
[null,null,null,null,null,null,null,null,null,null,0.28643774562036689,14,3.4911599999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.4067599999999998,0.29353403233570902]
[{"$f":"IF(F12=\"\",#N/A,F12)","v":{"$error":"#N/A"}},{"$f":"IF(K12=\"\",#N/A,K12)","v":{"$error":"#N/A"}},{"$f":"IF(P12=\"\",#N/A,P12)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,0.28142615518401048,15,3.5533299999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.47193,0.28802424012004851]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,0.27695384010346996,16,3.6107100000000001,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5319799999999999,0.28312731102667626]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,0.27290937771203694,17,3.6642199999999998,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.5878800000000002,0.27871612205536417]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,0.26923408288102008,18,3.7142400000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6400600000000001,0.27472074636132371]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,0.26587400762526653,19,3.76118,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.6889599999999998,0.27107911172796673]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,0.26278653586904821,20,3.8053699999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3.7349999999999999,0.2677376171352075]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,21]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"R&R Attributs","index":4,"n_rows":119,"n_cols":57,"rows_kept":119,"cut":false,"hidden":false,"merged":[[12,9,12,12],[12,13,12,16],[12,17,12,20],[2,17,2,19],[2,13,2,15],[84,3,84,4],[82,17,82,20],[75,17,75,20],[76,17,76,20],[77,17,77,20],[78,17,78,20],[79,17,79,20],[80,17,80,20],[81,17,81,20],[83,5,83,7],[83,17,83,20],[84,17,84,20],[80,5,80,7],[82,5,82,7],[81,5,81,7],[84,5,84,7],[0,0,0,25],[76,5,76,7],[77,3,77,4],[78,3,78,4],[77,5,77,7],[78,5,78,7],[77,0,77,1],[78,0,78,1],[6,4,6,5],[6,1,6,3],[2,1,2,4],[3,1,3,4],[4,1,4,4],[2,9,2,11],[2,5,2,8],[4,5,4,8],[83,3,83,4],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[82,3,82,4],[80,3,80,4],[81,3,81,4],[3,5,3,8],[79,0,79,1],[7,1,7,3],[8,1,8,3],[76,3,76,4],[7,4,7,5],[8,4,8,5],[79,5,79,7],[79,3,79,4],[9,1,9,3],[10,1,10,3],[9,4,9,5],[10,4,10,5],[12,1,12,4],[12,5,12,8]]}
["Cmc par R&R Charbonneau"]
[]
[null,"Moyen de mesure ",null,null,null,null,null,null,null,"Désignation :"]
[null,"Pièce mesurée",null,null,null,null,null,null,null,"Lot :"]
[null,"Caractéristiques"]
[]
[null,"Opérateur 1"]
[null,"Opérateur 2"]
[null,"Opérateur 3"]
[null,"Opérateur 4"]
[null,"Opérateur 5"]
[]
[null,{"$f":"IF(E7=\"\",B7,E7)","v":"Opérateur 1"},null,null,null,{"$f":"IF(E8=\"\",B8,E8)","v":"Opérateur 2"},null,null,null,{"$f":"IF(E9=\"\",B9,E9)","v":"Opérateur 3"},null,null,null,{"$f":"IF(E10=\"\",B10,E10)","v":"Opérateur 4"},null,null,null,{"$f":"IF(E11=\"\",B11,E11)","v":"Opérateur 5"},null,null,null,null,"EXPERT"]
["N°","1ère","2ème","3ème","Répétabilité","1ère","2ème","3ème","Répétabilité","1ère","2ème","3ème","Répétabilité ","1ère","2ème","3ème","Répétabilité ","1ère","2ème","3ème","Répétabilité ",null,"Valeur","Répétabilité","Repro","Repro"]
["pièce","mesure","mesure","mesure",{"$f":"B13","v":"Opérateur 1"},"mesure","mesure","mesure",{"$f":"F13","v":"Opérateur 2"},"mesure","mesure","mesure",{"$f":"J13","v":"Opérateur 3"},"mesure","mesure","mesure",{"$f":"N13","v":"Opérateur 4"},"mesure","mesure","mesure",{"$f":"R13","v":"Opérateur 5"},null,"\"Juste\"","Totale","sans expert","avec expert",null,null,null,null,"Repro 1&2","Repro1&3","Repro1&4","Repro1&5","Repro 2&3","Repro 2&4","Repro 2&5","Repro 3&4","Repro3&5","Repro4&5",null,"1 & expert","2 & expert","3 & expert","4 & expert","5 & expert",null,"1 plus sévère","1 moins sévère","2. plus sévère","2 moins sévère","3 plus sévère","3 moins sévère","4 plus sévère","4 moins sévère","5 plus sévère","5 moins sévère"]
[1,"NC","NC",null,{"$f":"IF(B16=\"\",\"\",IF(D16=\"\",IF(B16=C16,1,0),IF(AND(B16=D16,B16=C16,C16=D16),1,0)))","v":1},"NC","NC",null,{"$f":"IF(F16=\"\",\"\",IF(H16=\"\",IF(F16=G16,1,0),IF(AND(F16=H16,F16=H16,G16=H16),1,0)))","v":1},"NC","NC",null,{"$f":"IF(J16=\"\",\"\",IF(L16=\"\",IF(J16=K16,1,0),IF(AND(J16=L16,J16=L16,K16=L16),1,0)))","v":1},"NC","NC",null,{"$f":"IF(N16=\"\",\"\",IF(P16=\"\",IF(N16=O16,1,0),IF(AND(N16=P16,N16=P16,O16=P16),1,0)))","v":1},"NC","NC",null,{"$f":"IF(R16=\"\",\"\",IF(T16=\"\",IF(R16=S16,1,0),IF(AND(R16=T16,R16=T16,S16=T16),1,0)))","v":1},null,"NC",{"$f":"IF(B16=\"\",\"\",IF(SUM(E16,I16,M16,Q16,U16)<>$D$72,0,1))","v":1},{"$f":"IF(B16=\"\",\"\",IF(X16=0,1,IF(PRODUCT(AE16:AN16)=0,0,1)))","v":1},{"$f":"IF(W16=\"\",\"\",IF(B16=\"\",\"\",IF(OR(Y16=0,X16=0),1,IF(B16<>W16,0,1))))","v":1},null,null,null,null,{"$f":"IF(OR(B16=\"\",F16=\"\"),\"\",IF(B16<>F16,0,1))","v":1},{"$f":"IF(OR(B16=\"\",J16=\"\"),\"\",IF(B16<>J16,0,1))","v":1},{"$f":"IF(OR(B16=\"\",N16=\"\"),\"\",IF(B16<>N16,0,1))","v":1},{"$f":"IF(OR(B16=\"\",R16=\"\"),\"\",IF(B16<>R16,0,1))","v":1},{"$f":"IF(OR(F16=\"\",J16=\"\"),\"\",IF(F16<>J16,0,1))","v":1},{"$f":"IF(OR(F16=\"\",N16=\"\"),\"\",IF(F16<>N16,0,1))","v":1},{"$f":"IF(OR(F16=\"\",R16=\"\"),\"\",IF(F16<>R16,0,1))","v":1},{"$f":"IF(OR(J16=\"\",N16=\"\"),\"\",IF(J16<>N16,0,1))","v":1},{"$f":"IF(OR(J16=\"\",R16=\"\"),\"\",IF(J16<>R16,0,1))","v":1},{"$f":"IF(OR(N16=\"\",R16=\"\"),\"\",IF(N16<>R16,0,1))","v":1},null,{"$f":"IF(B16=\"\",\"\",IF(E16=0,1,IF(B16<>$W16,0,1)))","v":1},{"$f":"IF(F16=\"\",\"\",IF(I16=0,1,IF(F16<>$W16,0,1)))","v":1},{"$f":"IF(J16=\"\",\"\",IF(M16=0,1,IF(J16<>$W16,0,1)))","v":1},{"$f":"IF(N16=\"\",\"\",IF(Q16=0,1,IF(N16<>$W16,0,1)))","v":1},{"$f":"IF(R16=\"\",\"\",IF(U16=0,1,IF(R16<>$W16,0,1)))","v":1},null,{"$f":"IF(AP16=0,IF(W16=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP16=0,IF(W16=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ16=0,IF(W16=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ16=0,IF(W16=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR16=0,IF(W16=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR16=0,IF(W16=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AS16=0,IF(W16=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AS16=0,IF(W16=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AT16=0,IF(W16=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AT16=0,IF(W16=\"NC\",1,\"\"),\"\")","v":""}]
[2,"NC","NC",null,{"$f":"IF(B17=\"\",\"\",IF(D17=\"\",IF(B17=C17,1,0),IF(AND(B17=D17,B17=C17,C17=D17),1,0)))","v":1},"NC","NC",null,{"$f":"IF(F17=\"\",\"\",IF(H17=\"\",IF(F17=G17,1,0),IF(AND(F17=H17,F17=H17,G17=H17),1,0)))","v":1},"NC","NC",null,{"$f":"IF(J17=\"\",\"\",IF(L17=\"\",IF(J17=K17,1,0),IF(AND(J17=L17,J17=L17,K17=L17),1,0)))","v":1},"NC","NC",null,{"$f":"IF(N17=\"\",\"\",IF(P17=\"\",IF(N17=O17,1,0),IF(AND(N17=P17,N17=P17,O17=P17),1,0)))","v":1},"NC","NC",null,{"$f":"IF(R17=\"\",\"\",IF(T17=\"\",IF(R17=S17,1,0),IF(AND(R17=T17,R17=T17,S17=T17),1,0)))","v":1},null,"NC",{"$f":"IF(B17=\"\",\"\",IF(SUM(E17,I17,M17,Q17,U17)<>$D$72,0,1))","v":1},{"$f":"IF(B17=\"\",\"\",IF(X17=0,1,IF(PRODUCT(AE17:AN17)=0,0,1)))","v":1},{"$f":"IF(W17=\"\",\"\",IF(B17=\"\",\"\",IF(OR(Y17=0,X17=0),1,IF(B17<>W17,0,1))))","v":1},null,null,null,null,{"$f":"IF(OR(B17=\"\",F17=\"\"),\"\",IF(B17<>F17,0,1))","v":1},{"$f":"IF(OR(B17=\"\",J17=\"\"),\"\",IF(B17<>J17,0,1))","v":1},{"$f":"IF(OR(B17=\"\",N17=\"\"),\"\",IF(B17<>N17,0,1))","v":1},{"$f":"IF(OR(B17=\"\",R17=\"\"),\"\",IF(B17<>R17,0,1))","v":1},{"$f":"IF(OR(F17=\"\",J17=\"\"),\"\",IF(F17<>J17,0,1))","v":1},{"$f":"IF(OR(F17=\"\",N17=\"\"),\"\",IF(F17<>N17,0,1))","v":1},{"$f":"IF(OR(F17=\"\",R17=\"\"),\"\",IF(F17<>R17,0,1))","v":1},{"$f":"IF(OR(J17=\"\",N17=\"\"),\"\",IF(J17<>N17,0,1))","v":1},{"$f":"IF(OR(J17=\"\",R17=\"\"),\"\",IF(J17<>R17,0,1))","v":1},{"$f":"IF(OR(N17=\"\",R17=\"\"),\"\",IF(N17<>R17,0,1))","v":1},null,1,{"$f":"IF(F17=\"\",\"\",IF(I17=0,1,IF(F17<>$W17,0,1)))","v":1},{"$f":"IF(J17=\"\",\"\",IF(M17=0,1,IF(J17<>$W17,0,1)))","v":1},{"$f":"IF(N17=\"\",\"\",IF(Q17=0,1,IF(N17<>$W17,0,1)))","v":1},{"$f":"IF(R17=\"\",\"\",IF(U17=0,1,IF(R17<>$W17,0,1)))","v":1},null,{"$f":"IF(AP17=0,IF(W17=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP17=0,IF(W17=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ17=0,IF(W17=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ17=0,IF(W17=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR17=0,IF(W17=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR17=0,IF(W17=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AS17=0,IF(W17=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AS17=0,IF(W17=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AT17=0,IF(W17=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AT17=0,IF(W17=\"NC\",1,\"\"),\"\")","v":""}]
[3,"NC","NC",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,null,"NC",{"$f":"IF(B18=\"\",\"\",IF(SUM(E18,I18,M18,Q18,U18)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,0,0,0,1,1,1,1,1,1,null,1,0,0,0,0,null,{"$f":"IF(AP18=0,IF(W18=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP18=0,IF(W18=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ18=0,IF(W18=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ18=0,IF(W18=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR18=0,IF(W18=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR18=0,IF(W18=\"NC\",1,\"\"),\"\")","v":1},"",1,"",1]
[4,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B19=\"\",\"\",IF(SUM(E19,I19,M19,Q19,U19)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,1,1,1,0,0,0,1,1,1,null,1,0,1,1,1,null,{"$f":"IF(AP19=0,IF(W19=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP19=0,IF(W19=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ19=0,IF(W19=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ19=0,IF(W19=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR19=0,IF(W19=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR19=0,IF(W19=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[5,"NC","NC",null,1,"C","C",null,1,"C","C",null,1,"NC","NC",null,1,"C","C",null,1,null,"C",{"$f":"IF(B20=\"\",\"\",IF(SUM(E20,I20,M20,Q20,U20)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,0,1,0,1,0,1,0,1,0,null,0,1,1,0,1,null,{"$f":"IF(AP20=0,IF(W20=\"C\",1,\"\"),\"\")","v":1},{"$f":"IF(AP20=0,IF(W20=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ20=0,IF(W20=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ20=0,IF(W20=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR20=0,IF(W20=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR20=0,IF(W20=\"NC\",1,\"\"),\"\")","v":""},1,"","",""]
[6,"NC","NC",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B21=\"\",\"\",IF(SUM(E21,I21,M21,Q21,U21)<>$D$72,0,1))","v":1},0,{"$f":"IF(W21=\"\",\"\",IF(B21=\"\",\"\",IF(OR(Y21=0,X21=0),1,IF(B21<>W21,0,1))))","v":1},null,null,null,null,1,0,1,1,0,1,1,0,0,1,null,1,{"$f":"IF(F21=\"\",\"\",IF(I21=0,1,IF(F21<>$W21,0,1)))","v":1},{"$f":"IF(J21=\"\",\"\",IF(M21=0,1,IF(J21<>$W21,0,1)))","v":0},1,1,null,{"$f":"IF(AP21=0,IF(W21=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP21=0,IF(W21=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ21=0,IF(W21=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ21=0,IF(W21=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR21=0,IF(W21=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR21=0,IF(W21=\"NC\",1,\"\"),\"\")","v":1},"","","",""]
[7,"NC","NC",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B22=\"\",\"\",IF(SUM(E22,I22,M22,Q22,U22)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,0,0,1,1,1,0,1,0,0,null,1,0,0,0,1,null,{"$f":"IF(AP22=0,IF(W22=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP22=0,IF(W22=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ22=0,IF(W22=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ22=0,IF(W22=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR22=0,IF(W22=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR22=0,IF(W22=\"NC\",1,\"\"),\"\")","v":1},"",1,"",""]
[8,"C","C",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B23=\"\",\"\",IF(SUM(E23,I23,M23,Q23,U23)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,1,1,0,1,1,0,1,0,0,null,0,0,0,0,1,null,{"$f":"IF(AP23=0,IF(W23=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP23=0,IF(W23=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AQ23=0,IF(W23=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ23=0,IF(W23=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR23=0,IF(W23=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR23=0,IF(W23=\"NC\",1,\"\"),\"\")","v":1},"",1,"",""]
[9,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B24=\"\",\"\",IF(SUM(E24,I24,M24,Q24,U24)<>$D$72,0,1))","v":1},1,1,null,null,null,null,1,1,1,1,1,1,1,1,1,1,null,1,1,1,1,1,null,{"$f":"IF(AP24=0,IF(W24=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP24=0,IF(W24=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ24=0,IF(W24=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ24=0,IF(W24=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR24=0,IF(W24=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR24=0,IF(W24=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[10,"NC","NC",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"C","C",null,1,null,"NC",{"$f":"IF(B25=\"\",\"\",IF(SUM(E25,I25,M25,Q25,U25)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,0,1,0,0,1,0,0,1,0,null,1,1,0,1,0,null,{"$f":"IF(AP25=0,IF(W25=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP25=0,IF(W25=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ25=0,IF(W25=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ25=0,IF(W25=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR25=0,IF(W25=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR25=0,IF(W25=\"NC\",1,\"\"),\"\")","v":1},"","","",1]
[11,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B26=\"\",\"\",IF(SUM(E26,I26,M26,Q26,U26)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,1,0,1,1,0,1,0,1,0,null,1,1,1,0,1,null,{"$f":"IF(AP26=0,IF(W26=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP26=0,IF(W26=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ26=0,IF(W26=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ26=0,IF(W26=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR26=0,IF(W26=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR26=0,IF(W26=\"NC\",1,\"\"),\"\")","v":""},"",1,"",""]
[12,"C","C",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,"C","C",null,1,null,"C",{"$f":"IF(B27=\"\",\"\",IF(SUM(E27,I27,M27,Q27,U27)<>$D$72,0,1))","v":1},1,1,null,null,null,null,1,1,1,1,1,1,1,1,1,1,null,1,1,1,1,1,null,{"$f":"IF(AP27=0,IF(W27=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP27=0,IF(W27=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ27=0,IF(W27=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ27=0,IF(W27=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR27=0,IF(W27=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR27=0,IF(W27=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[13,"NC","NC",null,1,"C","C",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B28=\"\",\"\",IF(SUM(E28,I28,M28,Q28,U28)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,0,1,1,1,0,0,0,0,1,null,1,0,0,1,1,null,{"$f":"IF(AP28=0,IF(W28=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP28=0,IF(W28=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ28=0,IF(W28=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ28=0,IF(W28=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR28=0,IF(W28=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR28=0,IF(W28=\"NC\",1,\"\"),\"\")","v":1},"","","",""]
[14,"NC","NC",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B29=\"\",\"\",IF(SUM(E29,I29,M29,Q29,U29)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,0,1,1,0,1,1,0,0,1,null,1,1,0,1,1,null,{"$f":"IF(AP29=0,IF(W29=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP29=0,IF(W29=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ29=0,IF(W29=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ29=0,IF(W29=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR29=0,IF(W29=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR29=0,IF(W29=\"NC\",1,\"\"),\"\")","v":1},"","","",""]
[15,"C","C",null,1,"C","C",null,1,"NC","NC",null,1,"C","C",null,1,"C","C",null,1,null,"C",{"$f":"IF(B30=\"\",\"\",IF(SUM(E30,I30,M30,Q30,U30)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,0,1,1,0,1,1,0,0,1,null,1,1,0,1,1,null,{"$f":"IF(AP30=0,IF(W30=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP30=0,IF(W30=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ30=0,IF(W30=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ30=0,IF(W30=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR30=0,IF(W30=\"C\",1,\"\"),\"\")","v":1},{"$f":"IF(AR30=0,IF(W30=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[16,"C","C",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B31=\"\",\"\",IF(SUM(E31,I31,M31,Q31,U31)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,1,0,0,0,1,1,0,0,1,null,0,1,0,1,1,null,{"$f":"IF(AP31=0,IF(W31=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP31=0,IF(W31=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AQ31=0,IF(W31=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ31=0,IF(W31=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR31=0,IF(W31=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR31=0,IF(W31=\"NC\",1,\"\"),\"\")","v":1},"","","",""]
[17,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B32=\"\",\"\",IF(SUM(E32,I32,M32,Q32,U32)<>$D$72,0,1))","v":1},0,1,null,null,null,null,0,1,1,1,0,0,0,1,1,1,null,{"$f":"IF(B32=\"\",\"\",IF(E32=0,1,IF(B32<>$W32,0,1)))","v":1},0,1,1,1,null,{"$f":"IF(AP32=0,IF(W32=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP32=0,IF(W32=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ32=0,IF(W32=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ32=0,IF(W32=\"NC\",1,\"\"),\"\")","v":1},{"$f":"IF(AR32=0,IF(W32=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR32=0,IF(W32=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[18,"NC","NC",null,1,"NC","NC",null,1,"C","C",null,1,"NC","NC",null,1,"NC","NC",null,1,null,"NC",{"$f":"IF(B33=\"\",\"\",IF(SUM(E33,I33,M33,Q33,U33)<>$D$72,0,1))","v":1},0,1,null,null,null,null,1,0,1,1,0,1,1,0,0,1,null,1,1,0,1,1,null,{"$f":"IF(AP33=0,IF(W33=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP33=0,IF(W33=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ33=0,IF(W33=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ33=0,IF(W33=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR33=0,IF(W33=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR33=0,IF(W33=\"NC\",1,\"\"),\"\")","v":1},"","","",""]
[19,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B34=\"\",\"\",IF(SUM(E34,I34,M34,Q34,U34)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP34=0,IF(W34=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP34=0,IF(W34=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ34=0,IF(W34=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ34=0,IF(W34=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR34=0,IF(W34=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR34=0,IF(W34=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[20,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B35=\"\",\"\",IF(SUM(E35,I35,M35,Q35,U35)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP35=0,IF(W35=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP35=0,IF(W35=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ35=0,IF(W35=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ35=0,IF(W35=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR35=0,IF(W35=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR35=0,IF(W35=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[21,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B36=\"\",\"\",IF(SUM(E36,I36,M36,Q36,U36)<>$D$72,0,1))","v":""},"","",null,null,null,null,"",{"$f":"IF(OR(B36=\"\",J36=\"\"),\"\",IF(B36<>J36,0,1))","v":""},"","","","","","","","",null,"","","","","",null,{"$f":"IF(AP36=0,IF(W36=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP36=0,IF(W36=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ36=0,IF(W36=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ36=0,IF(W36=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR36=0,IF(W36=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR36=0,IF(W36=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[22,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B37=\"\",\"\",IF(SUM(E37,I37,M37,Q37,U37)<>$D$72,0,1))","v":""},"","",null,null,null,null,"",{"$f":"IF(OR(B37=\"\",J37=\"\"),\"\",IF(B37<>J37,0,1))","v":""},"","","","","","","","",null,"","","","","",null,{"$f":"IF(AP37=0,IF(W37=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP37=0,IF(W37=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ37=0,IF(W37=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ37=0,IF(W37=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR37=0,IF(W37=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR37=0,IF(W37=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[23,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B38=\"\",\"\",IF(SUM(E38,I38,M38,Q38,U38)<>$D$72,0,1))","v":""},"","",null,null,null,null,"",{"$f":"IF(OR(B38=\"\",J38=\"\"),\"\",IF(B38<>J38,0,1))","v":""},"","","","","","","","",null,"","","","","",null,{"$f":"IF(AP38=0,IF(W38=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP38=0,IF(W38=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ38=0,IF(W38=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ38=0,IF(W38=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR38=0,IF(W38=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR38=0,IF(W38=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[24,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B39=\"\",\"\",IF(SUM(E39,I39,M39,Q39,U39)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP39=0,IF(W39=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP39=0,IF(W39=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ39=0,IF(W39=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ39=0,IF(W39=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR39=0,IF(W39=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR39=0,IF(W39=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[25,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B40=\"\",\"\",IF(SUM(E40,I40,M40,Q40,U40)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP40=0,IF(W40=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP40=0,IF(W40=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ40=0,IF(W40=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ40=0,IF(W40=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR40=0,IF(W40=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR40=0,IF(W40=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[26,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B41=\"\",\"\",IF(SUM(E41,I41,M41,Q41,U41)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP41=0,IF(W41=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP41=0,IF(W41=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ41=0,IF(W41=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ41=0,IF(W41=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR41=0,IF(W41=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR41=0,IF(W41=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[27,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B42=\"\",\"\",IF(SUM(E42,I42,M42,Q42,U42)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP42=0,IF(W42=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP42=0,IF(W42=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ42=0,IF(W42=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ42=0,IF(W42=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR42=0,IF(W42=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR42=0,IF(W42=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[28,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B43=\"\",\"\",IF(SUM(E43,I43,M43,Q43,U43)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP43=0,IF(W43=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP43=0,IF(W43=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ43=0,IF(W43=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ43=0,IF(W43=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR43=0,IF(W43=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR43=0,IF(W43=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[29,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B44=\"\",\"\",IF(SUM(E44,I44,M44,Q44,U44)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP44=0,IF(W44=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP44=0,IF(W44=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ44=0,IF(W44=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ44=0,IF(W44=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR44=0,IF(W44=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR44=0,IF(W44=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[30,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B45=\"\",\"\",IF(SUM(E45,I45,M45,Q45,U45)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP45=0,IF(W45=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP45=0,IF(W45=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ45=0,IF(W45=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ45=0,IF(W45=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR45=0,IF(W45=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR45=0,IF(W45=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[31,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B46=\"\",\"\",IF(SUM(E46,I46,M46,Q46,U46)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP46=0,IF(W46=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP46=0,IF(W46=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ46=0,IF(W46=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ46=0,IF(W46=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR46=0,IF(W46=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR46=0,IF(W46=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[32,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B47=\"\",\"\",IF(SUM(E47,I47,M47,Q47,U47)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP47=0,IF(W47=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP47=0,IF(W47=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ47=0,IF(W47=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ47=0,IF(W47=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR47=0,IF(W47=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR47=0,IF(W47=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[33,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B48=\"\",\"\",IF(SUM(E48,I48,M48,Q48,U48)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP48=0,IF(W48=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP48=0,IF(W48=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ48=0,IF(W48=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ48=0,IF(W48=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR48=0,IF(W48=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR48=0,IF(W48=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[34,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B49=\"\",\"\",IF(SUM(E49,I49,M49,Q49,U49)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP49=0,IF(W49=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP49=0,IF(W49=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ49=0,IF(W49=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ49=0,IF(W49=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR49=0,IF(W49=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR49=0,IF(W49=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[35,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B50=\"\",\"\",IF(SUM(E50,I50,M50,Q50,U50)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP50=0,IF(W50=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP50=0,IF(W50=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ50=0,IF(W50=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ50=0,IF(W50=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR50=0,IF(W50=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR50=0,IF(W50=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[36,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B51=\"\",\"\",IF(SUM(E51,I51,M51,Q51,U51)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP51=0,IF(W51=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP51=0,IF(W51=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ51=0,IF(W51=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ51=0,IF(W51=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR51=0,IF(W51=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR51=0,IF(W51=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[37,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B52=\"\",\"\",IF(SUM(E52,I52,M52,Q52,U52)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP52=0,IF(W52=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP52=0,IF(W52=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ52=0,IF(W52=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ52=0,IF(W52=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR52=0,IF(W52=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR52=0,IF(W52=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[38,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B53=\"\",\"\",IF(SUM(E53,I53,M53,Q53,U53)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP53=0,IF(W53=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP53=0,IF(W53=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ53=0,IF(W53=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ53=0,IF(W53=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR53=0,IF(W53=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR53=0,IF(W53=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[39,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B54=\"\",\"\",IF(SUM(E54,I54,M54,Q54,U54)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP54=0,IF(W54=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP54=0,IF(W54=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ54=0,IF(W54=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ54=0,IF(W54=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR54=0,IF(W54=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR54=0,IF(W54=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[40,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B55=\"\",\"\",IF(SUM(E55,I55,M55,Q55,U55)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP55=0,IF(W55=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP55=0,IF(W55=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ55=0,IF(W55=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ55=0,IF(W55=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR55=0,IF(W55=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR55=0,IF(W55=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[41,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B56=\"\",\"\",IF(SUM(E56,I56,M56,Q56,U56)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP56=0,IF(W56=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP56=0,IF(W56=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ56=0,IF(W56=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ56=0,IF(W56=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR56=0,IF(W56=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR56=0,IF(W56=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[42,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B57=\"\",\"\",IF(SUM(E57,I57,M57,Q57,U57)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP57=0,IF(W57=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP57=0,IF(W57=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ57=0,IF(W57=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ57=0,IF(W57=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR57=0,IF(W57=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR57=0,IF(W57=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[43,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B58=\"\",\"\",IF(SUM(E58,I58,M58,Q58,U58)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP58=0,IF(W58=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP58=0,IF(W58=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ58=0,IF(W58=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ58=0,IF(W58=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR58=0,IF(W58=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR58=0,IF(W58=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[44,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B59=\"\",\"\",IF(SUM(E59,I59,M59,Q59,U59)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP59=0,IF(W59=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP59=0,IF(W59=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ59=0,IF(W59=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ59=0,IF(W59=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR59=0,IF(W59=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR59=0,IF(W59=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[45,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B60=\"\",\"\",IF(SUM(E60,I60,M60,Q60,U60)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP60=0,IF(W60=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP60=0,IF(W60=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ60=0,IF(W60=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ60=0,IF(W60=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR60=0,IF(W60=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR60=0,IF(W60=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[46,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B61=\"\",\"\",IF(SUM(E61,I61,M61,Q61,U61)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP61=0,IF(W61=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP61=0,IF(W61=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ61=0,IF(W61=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ61=0,IF(W61=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR61=0,IF(W61=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR61=0,IF(W61=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[47,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B62=\"\",\"\",IF(SUM(E62,I62,M62,Q62,U62)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP62=0,IF(W62=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP62=0,IF(W62=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ62=0,IF(W62=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ62=0,IF(W62=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR62=0,IF(W62=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR62=0,IF(W62=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[48,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B63=\"\",\"\",IF(SUM(E63,I63,M63,Q63,U63)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP63=0,IF(W63=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP63=0,IF(W63=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ63=0,IF(W63=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ63=0,IF(W63=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR63=0,IF(W63=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR63=0,IF(W63=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[49,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B64=\"\",\"\",IF(SUM(E64,I64,M64,Q64,U64)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP64=0,IF(W64=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP64=0,IF(W64=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ64=0,IF(W64=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ64=0,IF(W64=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR64=0,IF(W64=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR64=0,IF(W64=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[50,null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,null,"",null,null,{"$f":"IF(B65=\"\",\"\",IF(SUM(E65,I65,M65,Q65,U65)<>$D$72,0,1))","v":""},"","",null,null,null,null,"","","","","","","","","","",null,"","","","","",null,{"$f":"IF(AP65=0,IF(W65=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AP65=0,IF(W65=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ65=0,IF(W65=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AQ65=0,IF(W65=\"NC\",1,\"\"),\"\")","v":""},{"$f":"IF(AR65=0,IF(W65=\"C\",1,\"\"),\"\")","v":""},{"$f":"IF(AR65=0,IF(W65=\"NC\",1,\"\"),\"\")","v":""},"","","",""]
[null,{"$f":"$A$65-COUNTBLANK(B16:B65)","v":18},{"$f":"$A$65-COUNTBLANK(C16:C65)","v":18},{"$f":"$A$65-COUNTBLANK(D16:D65)","v":0},{"$f":"SUM(E16:E65)","v":18},{"$f":"$A$65-COUNTBLANK(F16:F65)","v":18},{"$f":"$A$65-COUNTBLANK(G16:G65)","v":18},{"$f":"$A$65-COUNTBLANK(H16:H65)","v":0},{"$f":"SUM(I16:I65)","v":18},{"$f":"$A$65-COUNTBLANK(J16:J65)","v":18},{"$f":"$A$65-COUNTBLANK(K16:K65)","v":18},{"$f":"$A$65-COUNTBLANK(L16:L65)","v":0},{"$f":"SUM(M16:M65)","v":18},{"$f":"$A$65-COUNTBLANK(N16:N65)","v":18},{"$f":"$A$65-COUNTBLANK(O16:O65)","v":18},{"$f":"$A$65-COUNTBLANK(P16:P65)","v":0},{"$f":"SUM(Q16:Q65)","v":18},{"$f":"$A$65-COUNTBLANK(R16:R65)","v":18},{"$f":"$A$65-COUNTBLANK(S16:S65)","v":18},{"$f":"$A$65-COUNTBLANK(T16:T65)","v":0},{"$f":"SUM(U16:U65)","v":18},null,{"$f":"$A$65-COUNTBLANK(W16:W65)","v":18},{"$f":"$B$66-SUM(X16:X65)","v":0},{"$f":"$B$66-SUM(Y16:Y65)","v":14},0,null,null,null,null,{"$f":"$B$66-SUM(AE16:AE65)","v":7},{"$f":"$B$66-SUM(AF16:AF65)","v":9},{"$f":"$B$66-SUM(AG16:AG65)","v":4},{"$f":"$B$66-SUM(AH16:AH65)","v":5},8,{"$f":"$B$66-SUM(AJ16:AJ65)","v":5},6,{"$f":"$B$66-SUM(AL16:AL65)","v":9},8,{"$f":"$B$66-SUM(AN16:AN65)","v":5},null,{"$f":"$B$66-SUM(AP16:AP65)","v":3},{"$f":"$B$66-SUM(AQ16:AQ65)","v":6},{"$f":"$B$66-SUM(AR16:AR65)","v":10},{"$f":"$B$66-SUM(AS16:AS65)","v":5},{"$f":"$B$66-SUM(AT16:AT65)","v":2},null,{"$f":"SUM(AV16:AV65)","v":1},2,0,6,1,9,1,4,0,2]
[]
[]
["messages",null,null,{"$f":"IF(J116=0,\"\",\"Les opérateurs doivent effectuer le même nombre de série de mesures\")","v":""}]
[null,null,null,{"$f":"IF(B119=0,\"\",\"Chaque opérateur doit contrôler le même nombre de pièces, le même nombre de fois\")","v":""}]
[]
["Nombre d'opérateurs : ",null,null,{"$f":"SUM(E118:I118)","v":5}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":"Opérateur 1"},{"$f":"F13","v":"Opérateur 2"},{"$f":"J13","v":"Opérateur 3"},{"$f":"N13","v":"Opérateur 4"},{"$f":"R13","v":"Opérateur 5"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E7","v":0},{"$f":"E8","v":0},{"$f":"E9","v":0},{"$f":"F9","v":0},{"$f":"G9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total inspecté",null,null,null,{"$f":"B66","v":18},{"$f":"F66","v":18},{"$f":"J66","v":18},{"$f":"N66","v":18},{"$f":"R66","v":18}]
[null,null,null,"Entre opérateurs",null,"Avec l'expert",null,null,null,null,null,null,null,null,null,null,null,"Problèmes répétabilité",null,null,null,{"$f":"V76-E66","v":0},{"$f":"W76-I66","v":0},{"$f":"X76-M66","v":0},{"$f":"Y76-Q66","v":0},{"$f":"Z76-U66","v":0}]
["Total inspecté",null,null,{"$f":"B66","v":18},null,{"$f":"IF(W66=0,\"\",B66)","v":18},null,null,null,null,null,null,null,null,null,null,null,"Problèmes vs expert",null,null,null,{"$f":"IF(W66=0,0,IF(V76<>0,AP66,0))","v":3},{"$f":"IF(W66=0,0,IF(W76<>0,AQ66,0))","v":6},{"$f":"IF(W66=0,0,IF(X76<>0,AR66,0))","v":10},{"$f":"IF(W66=0,0,IF(Y76<>0,AS66,0))","v":5},{"$f":"IF(W66=0,0,IF(Z76<>0,AT66,0))","v":2}]
["Problèmes répétabilité",null,null,{"$f":"X66","v":0},null,{"$f":"IF(W66=0,\"\",X66)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Plus sévère",null,null,null,{"$f":"AV66","v":1},{"$f":"AX66","v":0},{"$f":"AZ66","v":1},{"$f":"BB66","v":1},{"$f":"BD66","v":0}]
["Problèmes reproductibilité",null,null,{"$f":"Y66","v":14},null,{"$f":"IF(W66=0,\"\",Y66+Z66)","v":14},null,null,null,null,null,null,null,null,null,null,null,"Moins sévère",null,null,null,{"$f":"AW66","v":2},{"$f":"AY66","v":6},{"$f":"BA66","v":9},{"$f":"BC66","v":4},{"$f":"BE66","v":2}]
["Total problèmes",null,null,{"$f":"SUM(D79:D80)","v":14},null,{"$f":"IF(W66=0,\"\",F79+F80)","v":14},null,null,null,null,null,null,null,null,null,null,null,"Total Problèmes",null,null,null,{"$f":"V77+V78","v":3},{"$f":"W77+W78","v":6},10,5,2]
["95% LSC",null,null,{"$f":"IF((D78-D81)=0,1-10^(LOG10((1-0.95)/2)/D78),IF(D81=0,1,BETAINV((1+0.95)/2,(D78-D81)+1,D81)))","v":0.47637271881103516},null,{"$f":"IF(W66=0,\"\",IF((F78-F81)=0,1-10^(LOG10((1-0.95)/2)/F78),IF(F81=0,1,BETAINV((1+0.95)/2,(F78-F81)+1,F81))))","v":0.47637271881103516},null,null,null,null,null,null,null,null,null,null,null,"95% LSC",null,null,null,{"$f":"IF(B66=0,\"\",IF((V76-V81)=0,1-10^(LOG10((1-0.95)/2)/V76),IF(V81=0,1,BETAINV((1+0.95)/2,(V76-V81)+1,V81))))","v":0.96421480178833008},{"$f":"IF(F66=0,\"\",IF((W76-W81)=0,1-10^(LOG10((1-0.95)/2)/W76),IF(W81=0,1,BETAINV((1+0.95)/2,(W76-W81)+1,W81))))","v":0.86657238006591797},{"$f":"IF(J66=0,\"\",IF((X76-X81)=0,1-10^(LOG10((1-0.95)/2)/X76),IF(X81=0,1,BETAINV((1+0.95)/2,(X76-X81)+1,X81))))","v":0.6924285888671875},{"$f":"IF(N66=0,\"\",IF((Y76-Y81)=0,1-10^(LOG10((1-0.95)/2)/Y76),IF(Y81=0,1,BETAINV((1+0.95)/2,(Y76-Y81)+1,Y81))))","v":0.90305089950561523},{"$f":"IF(R66=0,\"\",IF((Z76-Z81)=0,1-10^(LOG10((1-0.95)/2)/Z76),IF(Z81=0,1,BETAINV((1+0.95)/2,(Z76-Z81)+1,Z81))))","v":0.98624873161315918}]
["Score s %",null,null,{"$f":"(D78-D81)/D78","v":0.22222222222222221},null,{"$f":"IF(W66=0,\"\",(F78-F81)/F78)","v":0.22222222222222221},null,null,null,null,null,null,null,null,null,null,null,"Score %",null,null,null,{"$f":"IF(V76>0,(V76-V81)/V76,\"\")","v":0.83333333333333337},{"$f":"IF(W76>0,(W76-W81)/W76,\"\")","v":0.66666666666666663},0.44444444444444442,0.72222222222222221,0.88888888888888884]
["95% LIC",null,null,{"$f":"IF(D81=0,10^(LOG10((1-0.95)/2)*D78),IF(D78=D81,0,1-BETAINV((1+0.95)/2,D81+1,D78-D81)))","v":6.4092159271240234E-2},null,{"$f":"IF(W66=0,\"\",IF(F81=0,10^(LOG10((1-0.95)/2)*F78),IF(F78=F81,0,1-BETAINV((1+0.95)/2,F81+1,F78-F81))))","v":6.4092159271240234E-2},null,null,null,null,null,null,null,null,null,null,null,"95% LIC",null,null,null,{"$f":"IF(B66=0,\"\",IF(V81=0,10^(LOG10((1-0.95)/2)*V76),IF(V76=V81,0,1-BETAINV((1+0.95)/2,V81+1,V76-V81))))","v":0.58582305908203125},{"$f":"IF(F66=0,\"\",IF(W81=0,10^(LOG10((1-0.95)/2)*W76),IF(W76=W81,0,1-BETAINV((1+0.95)/2,W81+1,W76-W81))))","v":0.40992546081542969},{"$f":"IF(J66=0,\"\",IF(X81=0,10^(LOG10((1-0.95)/2)*X76),IF(X76=X81,0,1-BETAINV((1+0.95)/2,X81+1,X76-X81))))","v":0.215301513671875},{"$f":"IF(N66=0,\"\",IF(Y81=0,10^(LOG10((1-0.95)/2)*Y76),IF(Y76=Y81,0,1-BETAINV((1+0.95)/2,Y81+1,Y76-Y81))))","v":0.46519851684570313},{"$f":"IF(R66=0,\"\",IF(Z81=0,10^(LOG10((1-0.95)/2)*Z76),IF(Z76=Z81,0,1-BETAINV((1+0.95)/2,Z81+1,Z76-Z81))))","v":0.65287971496582031}]
[null,null,null,{"$f":"IF(D83<0.9,\"Pas adapté\",\"Adapté\")","v":"Pas adapté"},null,{"$f":"IF(F83=\"\",\"\",IF(F83<0.8,\"Pas adapté\",\"Adapté\"))","v":"Pas adapté"},null,null,null,null,null,null,null,null,null,null,null,"Conclusion",null,null,null,{"$f":"IF(V83=\"\",\"\",IF(V83<0.9,\"Pas adapté\",\"Adapté\"))","v":"Pas adapté"},{"$f":"IF(W83=\"\",\"\",IF(W83<0.9,\"Pas adapté\",\"Adapté\"))","v":"Pas adapté"},{"$f":"IF(X83=\"\",\"\",IF(X83<0.9,\"Pas adapté\",\"Adapté\"))","v":"Pas adapté"},{"$f":"IF(Y83=\"\",\"\",IF(Y83<0.9,\"Pas adapté\",\"Adapté\"))","v":"Pas adapté"},"Pas adapté"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Test du nombre de mesures par opérateurs",null,null,null,"Test du nombre de pièces par opérateurs"]
[]
["Opé1",{"$f":"IF(D66=0,IF(B66<>C66,1,0),IF(OR(B66<>C66,B66<>D66),1,0))","v":0},null,null,{"$f":"B66","v":18},{"$f":"F66","v":18},{"$f":"J66","v":18},{"$f":"N66","v":18},{"$f":"R66","v":18}]
["Opé2",{"$f":"IF(H66=0,IF(F66<>G66,1,0),IF(OR(F66<>G66,F66<>H66),1,0))","v":0}]
["Opé3",{"$f":"IF(L66=0,IF(J66<>K66,1,0),IF(OR(J66<>K66,J66<>L66),1,0))","v":0},null,null,{"$f":"IF(OR(E114=0,F114=0),0,IF(E114<>F114,1,0))","v":0},{"$f":"IF(OR(F114=0,G114=0),0,IF(F114<>G114,1,0))","v":0},0,0,0,{"$f":"SUM(E116:G116)","v":0}]
["Opé4",{"$f":"IF(P66=0,IF(N66<>O66,1,0),IF(OR(N66<>O66,N66<>P66),1,0))","v":0}]
["Opé5",{"$f":"IF(T66=0,IF(R66<>S66,1,0),IF(OR(R66<>S66,R66<>T66),1,0))","v":0},null,null,{"$f":"IF(E114<>0,1,0)","v":1},{"$f":"IF(F114<>0,1,0)","v":1},1,1,1]
[null,{"$f":"SUM(B114:B118)","v":0}]

{"sheet":"CNOMO","index":5,"n_rows":55,"n_cols":8,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,2,0,5],[1,2,1,5],[2,2,2,5],[3,2,3,5]]}
["cible :"]
["Intervalle de tolérance :"]
["Moyen de contrôle :"]
["Résolution :"]
["Phase préliminaire - Répétabilité des mesurages de l'étalon sur le moyen"]
["Mesure n° :",1,2,3,4,5,null,"Indice de qualité:"]
["Valeur :"]
["Se =",{"$f":"STDEV(B7:F7)","v":{"$error":"#DIV/0!"}}]
["Répétabilité des mesurages = +/- Ie = +/- 2 Se =    +/-",null,null,null,{"$f":"2*B8","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"IF(E9<=C2/A55,\"la répétabilité est acceptable\",\"la répétabilité n'est pas acceptable\")","v":{"$error":"#DIV/0!"}}]
[]
[]
["Phase préliminaire - Répétabilité des mesurages d'une pièce sur le moyen"]
["Mesure n°",1,2,3,4,5]
["Valeur"]
["Mesure n°",6,7,8,9,10]
["Valeur"]
["Sr =",{"$f":"STDEV(B16:F16,B18:F18)","v":{"$error":"#DIV/0!"}}]
["Répétabilité des mesurages = +/- Ir = +/- 2Sr =       +/-",null,null,null,{"$f":" 2*B19","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"IF(E20<=C2/8,\"la répétabilité est acceptable\",\"la répétabilité n'est pas acceptable\")","v":{"$error":"#DIV/0!"}}]
[]
["Mesure de 5 pièces sur le moyen de contrôle"]
["Mesure n° ","Pièce 1","Pièce 2","Pièce 3","Pièce 4","Pièce 5"]
["Yi1"]
["Yi2"]
["Yi3"]
["Yi4"]
["Yi5"]
["Mesure de 5 pièces en métrologie"]
["Xi"]
["Différence entre la vraie valeur et le mesurage par le moyen"]
["di1=Yi1-Xi",{"$f":"IF(B26=\"\",\"\",B26-B$32)","v":""},"","","",""]
["di2=Yi2-Xi","","","","",""]
["di3=Yi3-Xi","","","","",""]
["di4=Yi4-Xi","","","","",""]
["di5=Yi5-Xi","","","","",{"$f":"IF(F30=\"\",\"\",F30-F$32)","v":""}]
["Moyenne des différences : J =",null,null,{"$f":"AVERAGE(B34:F38)","v":{"$error":"#DIV/0!"}}]
["Ecart-type des différences : Sg =",null,null,{"$f":"STDEV(B34:F38)","v":{"$error":"#DIV/0!"}}]
["Calcul du Cmc"]
[]
["Incertitude de mesure : Ig= ",null,{"$f":"ABS(D39)+2*SQRT(POWER(B8,2)+POWER(D40,2))","v":{"$error":"#DIV/0!"}}]
[]
["Cmc = IT/2.Ig = ",null,{"$f":"C2/(2*C43)","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"IF(C45>4,\"MOYEN DECLARE CAPABLE\",\"MOYEN DECLARE NON CAPABLE\")","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Q","Résolution","Ie","Ir","Imetro","CMC"]
[2,{"$f":"IF($A$55=1,\"10\",\"20\")","v":"20"},{"$f":"IF($A$55=1,\"10\",\"20\")","v":"20"},{"$f":"IF($A$55=1,\"4\",\"8\")","v":"8"},{"$f":"IF($A$55=1,\"8\",\"16\")","v":"16"},{"$f":"IF($A$55=1,\"2\",\"4\")","v":"4"}]