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

{"sheet":"Accueil","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Ce classeur sert à faire une étude de capabilité à partir d'un échantillon que l'on indique colonne D feuille données"]
[null,null,"Le résultat avec le graphique se trouve feuille capabilité."]
[]
[null,null,"données"]
[null,null,"capabilité"]
[]
[]
[]
[null,null,"Télécharger XLSTORE pour afficher l'aide"]
[null,null,"D'autres classeurs utilisant xlstore ici"]
[null,null,"http://excel-store.fr"]

{"sheet":"données","index":1,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["numéro","date","heure","rayon µm",null,"Indiquez les valeurs colonne D"]
[1,"2003-08-29T08:26:30","08:26:30",{"$f":"RAND()+RAND()+RAND()+RAND()+RAND()-RAND()-RAND()-RAND()-RAND()-RAND()-RAND()-RAND()","v":-0.13538035810015259}]
[2,"2003-08-29T08:26:32","08:26:32",{"$f":"RAND()+RAND()+RAND()+RAND()+RAND()-RAND()-RAND()-RAND()-RAND()-RAND()-RAND()-RAND()","v":-0.18738010299948449}]
[3,"2003-08-29T08:26:33","08:26:33",-2.8846930685243621]
[4,"2003-08-29T08:26:34","08:26:34",-0.67066966956401364]
[5,"2003-08-29T08:26:36","08:26:36",-1.8771827590454127]
[6,"2003-08-29T08:26:37","08:26:37",-0.37235611998268225]
[7,"2003-08-29T08:26:38","08:26:38",-0.90369674500958985]
[8,"2003-08-29T08:26:39","08:26:39",-5.3660029666837694E-3]
[9,"2003-08-29T08:26:40","08:26:40",-0.44124480139422617]
[10,"2003-08-29T08:26:42","08:26:42",-0.89884338351327864]
[11,"2003-08-29T08:26:43","08:26:43",-2.8503426365641751]
[12,"2003-08-29T08:26:44","08:26:44",-3.7685693702045162]
[13,"2003-08-29T08:26:44","08:26:44",-0.8268250464001452]
[14,"2003-08-29T08:26:45","08:26:45",-1.2417460171779564]
[15,"2003-08-29T08:26:46","08:26:46",-1.7779623100048618]
[16,"2003-08-29T08:26:47","08:26:47",-0.79176234586569705]
[17,"2003-08-29T08:26:48","08:26:48",-1.0120671184563719]
[18,"2003-08-29T08:26:49","08:26:49",-1.4469870718903484]
[19,"2003-08-29T08:26:50","08:26:50",-1.2262500360325665]
[20,"2003-08-29T08:26:51","08:26:51",-1.2961943862674183]
[21,"2003-08-29T08:26:52","08:26:52",-0.5531186448480343]
[22,"2003-08-29T08:26:56","08:26:56",-1.4090793083648383]
[23,"2003-08-29T08:26:58","08:26:58",-1.9495145385395298]
[24,"2003-08-29T08:26:59","08:26:59",-2.5264172260161479]
[25,"2003-08-29T08:27:00","08:27:00",-2.288240777026227]
[26,"2003-08-29T08:27:01","08:27:01",2.8694621680233512E-2]
[27,"2003-08-29T08:27:04","08:27:04",-2.3878482600213218]
[28,"2003-08-29T08:27:06","08:27:06",-1.4060144064351512]
[29,"2003-08-29T08:27:09","08:27:09",-1.3476551884937606]
[31,"2003-08-29T08:27:14","08:27:14",0.90382061045607787]
[32,"2003-08-29T08:27:15","08:27:15",-0.71406828394030997]
[33,"2003-08-29T08:27:16","08:27:16",-1.9390419553772509]
[35,"2003-08-29T08:27:21","08:27:21",-2.0349134733023053]
[37,"2003-08-29T08:27:25","08:27:25",9.555644914477468E-2]
[38,"2003-08-29T08:27:27","08:27:27",0.21080420322277704]
[39,"2003-08-29T08:27:29","08:27:29",-0.62343014196865187]
[44,"2003-08-29T08:27:39","08:27:39",0.38996191815136927]
[46,"2003-08-29T08:27:43","08:27:43",-1.6890310891129126]
[48,"2003-08-29T08:27:48","08:27:48",-3.1603900044962367]
[50,"2003-08-29T08:27:53","08:27:53",-1.6114756131688361]
[51,"2003-08-29T08:27:53","08:27:53",-1.7941695304041052]
[53,"2003-08-29T08:27:58","08:27:58",-1.5299408923523821]
[54,"2003-08-29T08:27:59","08:27:59",-0.14412123126495857]
[55,"2003-08-29T08:28:00","08:28:00",-2.0826532739108541]
[56,"2003-08-29T08:28:01","08:28:01",-3.8715278330475806]
[57,"2003-08-29T08:28:02","08:28:02",-0.3696921291321954]
[59,"2003-08-29T08:28:07","08:28:07",-0.68301054198722255]
[60,"2003-08-29T08:28:08","08:28:08",-0.38002984819270713]
[61,"2003-08-29T08:28:09","08:28:09",-0.85077027180869425]
[62,"2003-08-29T08:28:10","08:28:10",0.12606117191572264]

{"sheet":"capabilité","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Etude de capabilité \"&données!D1","v":"Etude de capabilité rayon µm"},null,null,null,null,null,null,null," "]
[]
[]
[]
["mesures",null,"tolérances",null,"Capabilité",null,"Limites du graphique"]
["min",{"$f":"MIN(données!D:D)","v":-3.8715278330475806},"min",-4,"cpmin",{"$f":"MAX(0,(B9-D6)/3/B8)","v":0.87717234099774688},"mini",-6]
["max",{"$f":"MAX(données!D:D)","v":0.90382061045607787},"max",4,"cpmax",{"$f":"MAX((B9-D7)/-3/B8,0)","v":1.6327413976259364},"maxi",5]
["écart type",{"$f":"STDEV(données!D:D)","v":1.0624535120991605},"étendue",{"$f":"D7-D6","v":8},"cp",{"$f":"(D7-D6)/6/B8","v":1.2549568693118416},"pas",{"$f":"ROUND((H7-H6)/20,2)","v":0.55000000000000004}]
["moyenne",{"$f":"AVERAGE(données!D:D)","v":-1.2041354967721041},"centre",{"$f":"(D7+D6)/2","v":0},"cpk",{"$f":"MIN(F6:F7)","v":0.87717234099774688},"nombre",{"$f":"COUNT(données!D:D)","v":50}]
[]
["normalité (K2 10%) :",{"$f":"IF(Calculs!G58<5,Calculs!B74,IF(Calculs!I59<0.1,\"non\",\"normale\"))","v":"normale"}]

{"sheet":"aide","index":3,"n_rows":41,"n_cols":7,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Code aide xlstore","a","b","c","d","e","f"]
["Entête","merci d'utiliser ce classeur,","Lles données","La normalité","les valeurs à saisir","le graphique","Avertissement"]
["Icone"]
["Texte","son but est de faire un calcul simple de capabilité en présentant la répartition des données dans des classes, ainsi que les limites de tolérances.\r\ncette répartition est comparée à une loi normale pour vérifier la normalité de la distribution\r\n\r\nréalisé par Sylvain NICOLAS:\r\nnicolas.sylvain1@libertysurf.fr\r\nhttp://sn1.chez-alice.fr","Elles sont saisies dans la colonne D de l'onglet données, Le nom saisi en D1 sert comme titre des pages capabilité.\r\nSouvent de nos jours les mesures s'effectuent de manière automatiques et vous disposez peut-être de fichiers texte plein d'informations que vous voudriez utiliser pour des calculs de capabilité.\r\nDans ce cas, sachez qu'il est possible de créer des macros permettant de remonter ces valeurs automatiquement pour avoir rapidement une étude de capabilité. Si cela vous intéresse, retenez mes coordonnées :\r\nhttp://sn1.chez-alice.fr/feedback/coor.html\r\n","En effet les calculs de capabilités avec plus ou moins 3 écarts types ne sont valables que dans ce cas.\nPour le test de normalité j'utilise un test du khi2 à 21 ou 9 ddl suivant le nombre de données.\nEn effet les calculs de normalité par le test du K2 demandent au moins 5 individus par classe, soit au minimum ici 50 mesures.\nPour des précisions concernant la vérification de la normalité :\nhttp://sn1.chez-alice.fr/calculs/normale/norma.html\n","En plus des données il y a 4 valeurs à saisir :\r\nles tolérances mini et maxi pour le calcul de la capabilité\r\nles valeurs mini et maxi pour l'affichage du graphique.\r\nl'étendue choisie pour le graphique influence bien sûr le calcul de la normalité : \r\nsi les classes sont très larges, une classe pourra contenir toutes les données, ce qui est aussi le cas pour une loi normale. Il faut donc prendre une étendue qui permette de représenter les données de manière raisonnable.\r\n","Il contient 3 séries : les données réparties en classes, la courbe d'une loi normale de moyenne et d'écart type étant le même que ceux des données, des barres indiquant la moyenne des données et l'intervalle de tolérance. Il s'agit d'un graphique en barre donc l'effet de seuil provoque quelques aberrations mais on peut corriger l'apparence en jouant sur l'intervalle d'affichage.\r\nles données sont réparties 20 classes, la série ne représente pas la classe de moins l'infini à la première borne pour des raisons d'esthétique et de compréhension (cela ferait une bosse sur la gauche)\r\nla courbe représentant la loi normale est un ajustement entre des points calculés, elle peut donc être légèrement déformée, mais le point au milieu de la classe représente bien la valeur théorique.\r\nLes barres verticales sont créées au milieu de la classe correspondante.\r\nLes deux extrêmes indiquent les tolérances mini et maxi\r\ncelle du milieu indique la moyenne de l'échantillon\r\n\r\n","Bien que je fasse attention, une erreur est vite arrivée, alors si vous en trouvez une n'hésitez pas à me la signaler. \r\nRéalisé par Sylvain NICOLAS:\r\nnicolas.sylvain1@libertysurf.fr\r\n"]
["Labels1",null,null,null,null,null,"mon site"]
["Labels2"]
["Labels3"]
["Labels4"]
["Labels5"]
["Type 1",null,null,null,null,null,"lien aide"]
["Type 2"]
["Type 3"]
["Type 4"]
["Type 5"]
["Code Aide liée 1",null,null,null,null,null,"http://sn1.chez-alice.fr"]
["Code Aide liée 2"]
["Code Aide liée 3"]
["Code Aide liée 4"]
["Code Aide liée 5"]
["Affichage modal","Non","Non","Non","Non","Non","Non"]
["Autorisation croix rouge pour fermer","Oui","Oui","Oui","Oui","Oui","Oui"]
["Bouton 1","Premier","Premier","Premier","Premier","Premier","Premier"]
["Bouton 2","précédent","précédent","précédent","précédent","précédent","précédent"]
["Bouton 3","Fermer","Fermer","Fermer","Fermer","Fermer","Fermer"]
["Bouton 4","Suivant","Suivant","Suivant","Suivant","Suivant"]
["Bouton 5","Dernier","Dernier","Dernier","Dernier","Dernier"]
["Zone saisie texte","Non","Non","Non","Non","Non","Non"]
["Afficher l'image","Non","Oui","Non","Oui","Oui","Non"]
["Image ou adresse image",null,"données!$A$1:$F$15",null,"capabilité!$C$5:$h$7","capabilité!$A$13:$H$32"]
["Mots clés","","",null,"","",""]
["Bouton","Fermer"]
["Choix 1",false]
["Choix 2",false]
["Choix 3",false]
["Choix 4",false]
["Choix 5",false]
["Colonne",7]
["Répertoire aide"]
[]
["Modèle fichier html"]
["Texte entré"]

{"sheet":"Calculs","index":4,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"limites intervalles","loi normale cumulée","loi normale intervalle",null,"Barres verticales"]
["intervalle",null,"contenu intervalle",0,null,null,"courbe jaune",{"$f":"MAX($C$35:$C$57)","v":11}]
[{"$f":"\"< \"&D35","v":"< -6"},{"$f":"COUNTIF(données!D:D,\"<\"&D35)","v":0},{"$f":"B35-B34","v":0},{"$f":"capabilité!H6","v":-6},{"$f":"NORMDIST(D35,moy,sigma,1)","v":3.1815263045246442E-6},{"$f":"E35-E34","v":3.1815263045246442E-6},{"$f":"F35*nb","v":1.5907631522623221E-4},{"$f":"IF(AND(D35>mini,D34<=mini),$H$34,IF(AND(D35>maxi,D34<=maxi),$H$34,IF(AND(D35>moy,D34<=moy),$H$34,\"\")))","v":""},{"$f":"IF(G35=0,0,(G35-C35)^2/G35)","v":1.5907631522623221E-4}]
[{"$f":"\"[\"&D35&\"-\"&D36&\"[\"","v":"[-6--5,45["},{"$f":"COUNTIF(données!D:D,\"<\"&D36)","v":0},0,{"$f":"ROUND(D35+capabilité!$H$8,2)","v":-5.45},3.2172455878679651E-5,2.8990929574155008E-5,1.4495464787077504E-3,"",1.4495464787077504E-3]
["[-5,45--4,9[",{"$f":"COUNTIF(données!D:D,\"<\"&D37)","v":0},0,{"$f":"ROUND(D36+capabilité!$H$8,2)","v":-4.9000000000000004},2.5200802908979325E-4,2.198355732111136E-4,1.099177866055568E-2,"",1.099177866055568E-2]
["[-4,9--4,35[",{"$f":"COUNTIF(données!D:D,\"<\"&D38)","v":0},0,{"$f":"ROUND(D37+capabilité!$H$8,2)","v":-4.3499999999999996},1.533492471754945E-3,1.2814844426651518E-3,6.4074222133257586E-2,"",6.4074222133257586E-2]
["[-4,35--3,8[",{"$f":"COUNTIF(données!D:D,\"<\"&D39)","v":1},1,{"$f":"ROUND(D38+capabilité!$H$8,2)","v":-3.8},7.2773514023843685E-3,5.7438589306294235E-3,0.28719294653147115,11,1.769172612387987]
["[-3,8--3,25[",{"$f":"COUNTIF(données!D:D,\"<\"&D40)","v":2},1,{"$f":"ROUND(D39+capabilité!$H$8,2)","v":-3.25},2.7076932939059412E-2,1.9799581536675041E-2,0.98997907683375208,"",1.0143537722535892E-4]
["[-3,25--2,7[",{"$f":"COUNTIF(données!D:D,\"<\"&D41)","v":5},3,{"$f":"ROUND(D40+capabilité!$H$8,2)","v":-2.7},7.9575295922991451E-2,5.249836298393204E-2,2.6249181491966018,"",5.3596488273419868E-2]
["[-2,7--2,15[",{"$f":"COUNTIF(données!D:D,\"<\"&D42)","v":8},3,{"$f":"ROUND(D41+capabilité!$H$8,2)","v":-2.15},0.18666197486947508,0.10708667894648363,5.3543339473241813,"",1.0352152835541963]
["[-2,15--1,6[",{"$f":"COUNTIF(données!D:D,\"<\"&D43)","v":17},9,{"$f":"ROUND(D42+capabilité!$H$8,2)","v":-1.6},0.35472507456769464,0.16806309969821956,8.4031549849109783,"",4.2391693676513603E-2]
["[-1,6--1,05[",{"$f":"COUNTIF(données!D:D,\"<\"&D44)","v":25},8,{"$f":"ROUND(D43+capabilité!$H$8,2)","v":-1.05},0.5576741916015151,0.20294911703382046,10.147455851691022,11,0.45445545192428899]
["[-1,05--0,5[",{"$f":"COUNTIF(données!D:D,\"<\"&D45)","v":36},11,{"$f":"ROUND(D44+capabilité!$H$8,2)","v":-0.5},0.74625298079664892,0.18857878919513382,9.4289394597566911,"",0.26177188130692369]
["[-0,5-0,05[",{"$f":"COUNTIF(données!D:D,\"<\"&D46)","v":45},9,{"$f":"ROUND(D45+capabilité!$H$8,2)","v":0.05},0.8810822946986997,0.13482931390205077,6.7414656951025389,"",0.75665699969434774]
["[0,05-0,6[",{"$f":"COUNTIF(données!D:D,\"<\"&D47)","v":49},4,{"$f":"ROUND(D46+capabilité!$H$8,2)","v":0.6},0.9552540621494402,7.41717674507405E-2,3.708588372537025,"",2.2898399091545958E-2]
["[0,6-1,15[",{"$f":"COUNTIF(données!D:D,\"<\"&D48)","v":50},1,{"$f":"ROUND(D47+capabilité!$H$8,2)","v":1.1499999999999999},0.98664581884886837,3.1391756699428175E-2,1.5695878349714087,"",0.2066977677316966]
["[1,15-1,7[",{"$f":"COUNTIF(données!D:D,\"<\"&D49)","v":50},0,{"$f":"ROUND(D48+capabilité!$H$8,2)","v":1.7},0.99686601679350262,1.0220197944634246E-2,0.51100989723171231,"",0.51100989723171231]
["[1,7-2,25[",{"$f":"COUNTIF(données!D:D,\"<\"&D50)","v":50},0,{"$f":"ROUND(D49+capabilité!$H$8,2)","v":2.25},0.99942518938276403,2.5591725892614159E-3,0.12795862946307079,"",0.12795862946307079]
["[2,25-2,8[",{"$f":"COUNTIF(données!D:D,\"<\"&D51)","v":50},0,{"$f":"ROUND(D50+capabilité!$H$8,2)","v":2.8},0.99991797072056565,4.927813378016177E-4,2.4639066890080885E-2,"",2.4639066890080885E-2]
["[2,8-3,35[",{"$f":"COUNTIF(données!D:D,\"<\"&D52)","v":50},0,{"$f":"ROUND(D51+capabilité!$H$8,2)","v":3.35},0.99999092174208903,7.2951021523381954E-5,3.6475510761690977E-3,"",3.6475510761690977E-3]
["[3,35-3,9[",{"$f":"COUNTIF(données!D:D,\"<\"&D53)","v":50},0,{"$f":"ROUND(D52+capabilité!$H$8,2)","v":3.9},0.99999922276378728,8.3010216982426499E-6,4.150510849121325E-4,"",4.150510849121325E-4]
["[3,9-4,45[",{"$f":"COUNTIF(données!D:D,\"<\"&D54)","v":50},0,{"$f":"ROUND(D53+capabilité!$H$8,2)","v":4.45},0.99999994861938013,7.2585559285354151E-7,3.6292779642677075E-5,11,3.6292779642677075E-5]
["[4,45-5[",{"$f":"COUNTIF(données!D:D,\"<\"&D55)","v":50},0,{"$f":"ROUND(D54+capabilité!$H$8,2)","v":5},0.99999999738120027,4.8761820137244172E-8,2.4380910068622086E-6,"",2.4380910068622086E-6]
["[5-5,55[",{"$f":"COUNTIF(données!D:D,\"<\"&D56)","v":50},0,{"$f":"ROUND(D55+capabilité!$H$8,2)","v":5.55},0.99999999989720867,2.5160084016206952E-9,1.2580042008103476E-7,"",1.2580042008103476E-7]
["[5,55-6,1[",{"$f":"COUNTIF(données!D:D,\"<\"&D57)","v":50},0,{"$f":"ROUND(D56+capabilité!$H$8,2)","v":6.1},0.99999999999689571,9.9687036403395268E-11,4.9843518201697634E-9,"",4.9843518201697634E-9]
[null,null,null,null,null,null,{"$f":"AVERAGE(G35:G57)","v":2.1739130434715124},null,{"$f":"SUM(I35:I57)","v":5.3473416940072589}]
["vérification de la normalité pour 50 à 100 valeurs",null,null,null,null,null,null,null,{"$f":"CHIDIST(I58,21)","v":0.99977092988457894}]
[null,null,null,{"$f":"ROUND((capabilité!B7-capabilité!B6*1.1)/10,2)","v":0.52}]
["intervalle",null,"contenu intervalle",0,null,null,null,{"$f":"MAX($C$62:$C$72)","v":9}]
[{"$f":"\"[\"&D61&\"-\"&D62&\"[\"","v":"[0--3,87["},{"$f":"COUNTIF(données!D:D,\"<\"&D62)","v":1},{"$f":"B62-B61","v":1},{"$f":"ROUND(capabilité!B6,2)","v":-3.87},{"$f":"NORMDIST(D62,moy,sigma,1)","v":6.0509545366701171E-3},{"$f":"E62-E61","v":6.0509545366701171E-3},{"$f":"F62*nb","v":0.30254772683350584},{"$f":"IF(AND(D62>capabilité!$D$6,D61<=capabilité!$D$6),$H$34,IF(AND(D62>capabilité!$D$7,D61<=capabilité!$D$7),$H$34,IF(AND(D62>capabilité!$B$9,D61<=capabilité!$B$9),$H$34,\"\")))","v":""},{"$f":"IF(G62=0,0,(G62-C62)^2/G62)","v":1.6078113639663907}]
["[-3,87--3,35[",{"$f":"COUNTIF(données!D:D,\"<\"&D63)","v":2},1,{"$f":"ROUND(D62+$D$60,2)","v":-3.35},2.1705931713713798E-2,1.5654977177043679E-2,0.78274885885218393,{"$f":"IF(AND(D63>capabilité!$D$6,D62<=capabilité!$D$6),$H$34,IF(AND(D63>capabilité!$D$7,D62<=capabilité!$D$7),$H$34,IF(AND(D63>capabilité!$B$9,D62<=capabilité!$B$9),$H$34,\"\")))","v":""},6.0297830902288539E-2]
["[-3,35--2,83[",{"$f":"COUNTIF(données!D:D,\"<\"&D64)","v":5},3,-2.83,6.297218800836632E-2,4.1266256294652526E-2,2.0633128147326261,{"$f":"IF(AND(D64>capabilité!$D$6,D63<=capabilité!$D$6),$H$34,IF(AND(D64>capabilité!$D$7,D63<=capabilité!$D$7),$H$34,IF(AND(D64>capabilité!$B$9,D63<=capabilité!$B$9),$H$34,\"\")))","v":""},0.42523018166676352]
["[-2,83--2,31[",{"$f":"COUNTIF(données!D:D,\"<\"&D65)","v":7},2,-2.31,0.14897045197212602,8.5998263963759702E-2,4.2999131981879852,{"$f":"IF(AND(D65>capabilité!$D$6,D64<=capabilité!$D$6),$H$34,IF(AND(D65>capabilité!$D$7,D64<=capabilité!$D$7),$H$34,IF(AND(D65>capabilité!$B$9,D64<=capabilité!$B$9),$H$34,\"\")))","v":""},1.2301645348162757]
["[-2,31--1,79[",{"$f":"COUNTIF(données!D:D,\"<\"&D66)","v":14},7,-1.79,0.29067083659343218,0.14170038462130616,7.0850192310653082,{"$f":"IF(AND(D66>capabilité!$D$6,D65<=capabilité!$D$6),$H$34,IF(AND(D66>capabilité!$D$7,D65<=capabilité!$D$7),$H$34,IF(AND(D66>capabilité!$B$9,D65<=capabilité!$B$9),$H$34,\"\")))","v":""},1.0202187764350521E-3]
["[-1,79--1,27[",{"$f":"COUNTIF(données!D:D,\"<\"&D67)","v":23},9,-1.27,0.47528426970054716,0.18461343310711498,9.2306716553557493,{"$f":"IF(AND(D67>capabilité!$D$6,D66<=capabilité!$D$6),$H$34,IF(AND(D67>capabilité!$D$7,D66<=capabilité!$D$7),$H$34,IF(AND(D67>capabilité!$B$9,D66<=capabilité!$B$9),$H$34,\"\")))","v":""},5.7644139637107366E-3]
["[-1,27--0,75[",{"$f":"COUNTIF(données!D:D,\"<\"&D68)","v":31},8,-0.75,0.66547068690262801,0.19018641720208085,9.509320860104042,{"$f":"IF(AND(D68>capabilité!$D$6,D67<=capabilité!$D$6),$H$34,IF(AND(D68>capabilité!$D$7,D67<=capabilité!$D$7),$H$34,IF(AND(D68>capabilité!$B$9,D67<=capabilité!$B$9),$H$34,\"\")))","v":11},0.23955963756598711]
["[-0,75--0,23[",{"$f":"COUNTIF(données!D:D,\"<\"&D69)","v":40},9,-0.23,0.82039554064440423,0.15492485374177623,7.7462426870888113,{"$f":"IF(AND(D69>capabilité!$D$6,D68<=capabilité!$D$6),$H$34,IF(AND(D69>capabilité!$D$7,D68<=capabilité!$D$7),$H$34,IF(AND(D69>capabilité!$B$9,D68<=capabilité!$B$9),$H$34,\"\")))","v":""},0.20292514231425893]
["[-0,23-0,29[",{"$f":"COUNTIF(données!D:D,\"<\"&D70)","v":48},8,0.28999999999999998,0.92018346486278868,9.9787924218384449E-2,4.9893962109192227,{"$f":"IF(AND(D70>capabilité!$D$6,D69<=capabilité!$D$6),$H$34,IF(AND(D70>capabilité!$D$7,D69<=capabilité!$D$7),$H$34,IF(AND(D70>capabilité!$B$9,D69<=capabilité!$B$9),$H$34,\"\")))","v":""},1.81659960277191]
["[0,29-0,81[",{"$f":"COUNTIF(données!D:D,\"<\"&D71)","v":49},1,0.81,0.97100277563820681,5.0819310775418125E-2,2.540965538770906,{"$f":"IF(AND(D71>capabilité!$D$6,D70<=capabilité!$D$6),$H$34,IF(AND(D71>capabilité!$D$7,D70<=capabilité!$D$7),$H$34,IF(AND(D71>capabilité!$B$9,D70<=capabilité!$B$9),$H$34,\"\")))","v":""},0.93451672423236309]
["[0,81-1,33[",{"$f":"COUNTIF(données!D:D,\"<\"&D72)","v":50},1,1.33,0.99146445575140196,2.0461680113195158E-2,1.0230840056597579,{"$f":"IF(AND(D72>capabilité!$D$6,D71<=capabilité!$D$6),$H$34,IF(AND(D72>capabilité!$D$7,D71<=capabilité!$D$7),$H$34,IF(AND(D72>capabilité!$B$9,D71<=capabilité!$B$9),$H$34,\"\")))","v":""},5.2084805778592944E-4]
[null,null,null,null,null,null,{"$f":"AVERAGE(G62:G72)*1.2","v":5.4079879404621929},null,{"$f":"SUM(I62:I72)","v":6.5244104990341691}]
["normalité (K2 10%) :",{"$f":"IF(capabilité!H9<50,\"pas assez de données\",IF(Calculs!I74<0.1,\"non\",\"normale\"))","v":"normale"},null,null,null,null,null,null,{"$f":"CHIDIST(I73,9)","v":0.68649996737652097}]