{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Carte PreControl"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Carte PreControl","index":0,"n_rows":54,"n_cols":19,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Paramètres de la Carte de PreControl"]
[]
[null,null,null,null,null,null,null,null,null,null,"Tolérance Supérieure :",22,{"$f":"IF(ISERROR((L4-L5)<=0),\"Erreur\",IF((L4-L5)<=0,\"Erreur\",\"\"))","v":""},null,{"$f":"L4-(L4-L5)/4","v":20}]
[null,null,null,null,null,null,null,null,null,null,"Tolérance Inférieure :",14,{"$f":"IF(ISERROR((L4-L5)<=0),\"Erreur\",IF((L4-L5)<=0,\"Erreur\",\"\"))","v":""},null,{"$f":"L5+(L4-L5)/4","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(B28:D52)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Cpk minimun attendu :",1.33,{"$f":"IF(ISNUMBER(L7),\"\",\"Erreur\")","v":""},null,{"$f":"STDEV(B28:D52)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Consécutives bonnes :",{"$f":"MAX(0,ROUND((L7-0.6)/0.2,0))+1","v":5},null,null,{"$f":"MIN((O6-L5)/3/O7,(L4-O6)/3/O7)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,"Cpk constaté estimé : ",{"$f":"IF(ISERROR(O8),IF(ISERROR(O9),L7,O9),O8)","v":1.33},null,null,{"$f":"IF(AND(O6<=O4,O6>=O5),2,IF(AND(O6<=L4,O6>=L5),1,0))","v":{"$error":"#DIV/0!"}}]
[]
[null,"Visualisation des Saisies"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Mesures Réalisées",null,null,null,null,null,null,"Données d'Entrée"]
[null,null,null,null,null,null,null,null,"N'autoriser le lancement d'une production que"]
[null,"Mes.1",null,"Mes.2",null,"Statut",null,null,"si la caractéristique clé du produit est mesurée",null,null,null,null,null,"Nb","Vert","Jaune","Rouge",0]
[null,null,null,null,null,{"$f":"IF(OR(Q28=\"2\",R28>0),\"/!\\\",IF(Q28=\"1\",\"ok ?\",IF(Q28>0,\"i\",IF(AND(P28>0,P28=O28),\"Ok\" & IF(AND(S28<>S27,S28=$L$8),\"!\",\"\"),\"\"))))","v":""},null,null,"centrée (zone verte) un nombre de fois suffisant",null,null,null,null,null,{"$f":"COUNTIF($B28,\"<>\")+COUNTIF($D28,\"<>\")","v":0},{"$f":"IF($B28<>\"\",IF(AND($B28>=$O$5,$B28<=$O$4),1,0),0)+IF($D28<>\"\",IF(AND($D28>=$O$5,$D28<=$O$4),1,0),0)","v":0},{"$f":"IF((O28-P28-R28)=0,0,IF((O28-P28-R28)=1,\"1\",IF(ABS(B28-D28)>(O$4-O$5),\"2\",2)))","v":0},{"$f":"IF($B28<>\"\",IF(OR($B28>$L$4,$B28<$L$5),1,0),0)+IF($D28<>\"\",IF(OR($D28>$L$4,$D28<$L$5),1,0),0)","v":0},{"$f":"IF(OR(AND(Q28<>\"1\",Q28>1),R28>0),0,S27+P28)","v":0}]
[null,null,null,null,null,"",null,null,"et à la suite.",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Ensuite, surveiller avec des prélèvements de",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"deux pièces consécutives.",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Processus",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Préparation du Formulaire (macros activées) :",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Renseigner la Tolérance Supérieure",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Renseigner la Tolérance Inférieure",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Renseigner le Cpk min attendu",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Le nombre de mesures centrées s'affiche",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Premières Saisies (Mes.1) :",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Renseigner les Mesures réalisées,",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Jusqu'à l'autorisation de lancer (Ok !)",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"En suivi, saisir un couple (Mes.1 et Mes.2) :",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Renseigner les Mesures réalisées…",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,null,null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Données de Sortie",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Aide au Pilotage d'une Production",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Si 2 verts, ou 1 seul jaune :",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - la production peut continuer (Ok) (ok ?)",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Si 2 jaunes consécutifs : ",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - la ligne doit être réglée (i)",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null,"Si 2 jaunes opposés, ou 1 rouge :",null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,"",null,null," - Arrêter tout et rechercher les causes (/!\\)",null,null,null,null,null,0,0,0,0,0]
[]
[null,"Réf: CPC_FR_v1.2",null,null,null,null,null,null,null,null,null,null,"www.capLSS.com"]