{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["SUIVI CRIMES","Codes","Calculs"],"not_rendered":{"macros":1,"external_links":6,"defined_names":63},"read":"whole","date_system":"1900"}

{"sheet":"SUIVI CRIMES","index":0,"n_rows":39,"n_cols":27,"rows_kept":39,"merged":[[0,1,2,8],[1,12,2,12],[5,1,7,1],[5,2,7,2],[8,1,10,1],[8,2,10,2],[14,1,15,1],[14,2,15,2],[16,1,18,1],[16,2,18,2],[21,1,24,1],[21,2,24,2],[25,1,26,1],[25,2,26,2],[27,1,28,1],[27,2,28,2],[29,1,30,1],[29,2,30,2],[33,1,34,1],[33,2,34,2],[35,1,36,1],[35,2,36,2],[37,1,38,1],[37,2,38,2]]}
[null,"TABLEAU DE SUIVI \nDES ACTIONS C.R.I.M.E.S.",{"$nulls":7},"Total",{"$f":"COUNTA(H6:H60000)","v":34},{"$nulls":4},"Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre"]
[{"$nulls":9},"En cours",{"$f":"K1-K3","v":3},null,"Service","Solde Mois",null,null,1,1,4,1,2,0,1,1]
[{"$nulls":9},"Soldée",{"$f":"COUNTA(K6:K60000)","v":31},null,null,"Solde Moyen",null,{"$f":"AVERAGE(P6:P49)","v":{"v":45.61764705882353,"d":"46"}}]
[]
[null,"Référence analyse CRIMES","Défaut","Etape","Action","Porteur de l'action","Mails","Date cible","Etat","Avancement","Date solde","Commentaires","SERVICE","VIDE","Mois","Délai de solde / action","Solde"]
[null,"14RC002","zrs","M1","restfg","P.TETE",{"$f":"VLOOKUP(F6,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-02-08","100%",{"$f":"IF(I6=\"\",\"\",VLOOKUP(I6,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-03-08","Plannifiée - réponse OK du contact le 14/02","Log- Aval",null,3,{"$f":"IF(K6=\"\",TODAY()-H6,K6-H6)","v":28},1]
[{"$nulls":3},"M2","eqrdf","P.TETE",{"$f":"VLOOKUP(F7,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-03-21","100%",{"$f":"IF(I7=\"\",\"\",VLOOKUP(I7,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-03-21","Plannifiée - réponse OK du contact le 14/02","Log- Aval",null,3,0,1]
[{"$nulls":3},"M3","eardf","P.TETE",{"$f":"VLOOKUP(F8,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-02-27","100%",{"$f":"IF(I8=\"\",\"\",VLOOKUP(I8,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-03-19","Plannifiée - réponse OK Com dans une RIM","BE",null,3,20,1]
[null,"14RC006","zrsd","M1","erqdf","P.TETE",{"$f":"VLOOKUP(F9,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-02-20","100%",{"$f":"IF(I9=\"\",\"\",VLOOKUP(I9,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-02-26","Mail Ok le 14/02 - Retour et remarques","SRA",null,2,6,1]
[{"$nulls":3},"M2","aerq","P.TETE",{"$f":"VLOOKUP(F10,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-02-20","100%",{"$f":"IF(I10=\"\",\"\",VLOOKUP(I10,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-03-14","Mail Ok le 14/03 - impossible pas de modif schéma client","Production",null,3,22,1]
[{"$nulls":3},"M3","qerfd","P.TETE",{"$f":"VLOOKUP(F11,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-03-04","100%",{"$f":"IF(I11=\"\",\"\",VLOOKUP(I11,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},null,"Mail OK du 28/02\nRéponse de Dr.Mundo le 11/11","Méthodes",null,11,287,1]
[null,"14RC012","rzs","M1","areq","P.TETE",{"$f":"VLOOKUP(F12,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-02-28","100%",{"$f":"IF(I12=\"\",\"\",VLOOKUP(I12,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-07","1.Le 18/03- Le moyen fonctionne en l'état - cependant la configuration de l'imprimante FR33-008 -MPP reste manuel\nDemande de passe en auto ( Patou regarde le sujet )\n2.Relance auprès de K.Chêne pour générer les codes barres étiquettes","Log- Amont",null,4,38,1]
[null,"14RC013","zrs","M2","aerd","O.TOTO",{"$f":"VLOOKUP(F13,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-02-28","75%",{"$f":"IF(I13=\"\",\"\",VLOOKUP(I13,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},null,"Mail Ok le 19/02","Log- Amont",null,null,{"$f":"IF(K13=\"\",TODAY()-H13,K13-H13)","v":291}]
[null,"14RC013","zrs","M3","a\"req","J.TATA",{"$f":"VLOOKUP(F14,Codes!$V$1:$W$32,2)","v":"j.tata@holyshit.com"},"2014-11-20","75%",{"$f":"IF(I14=\"\",\"\",VLOOKUP(I14,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},null,"Mail Ok le 19/02","Log- Amont",null,null,{"$f":"IF(K14=\"\",TODAY()-H14,K14-H14)","v":26}]
[null,"14RC008","zrs","M1","aeqfd","O.TOTO",{"$f":"VLOOKUP(F15,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-02-21","100%",{"$f":"IF(I15=\"\",\"\",VLOOKUP(I15,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-01",null,"Qualité",null,4,39,1]
[{"$nulls":3},"M4","a\"e","J.TATA",{"$f":"VLOOKUP(F16,Codes!$V$1:$W$32,2)","v":"j.tata@holyshit.com"},"2014-03-29","100%",{"$f":"IF(I16=\"\",\"\",VLOOKUP(I16,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-10-20","Mail Ok le 19/03\nAutre solution sur ce sujet","Qualité",null,10,205,1]
[null,"14RC010","zrs","M1","ae","P.TETE",{"$f":"VLOOKUP(F17,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-03-19","100%",{"$f":"IF(I17=\"\",\"\",VLOOKUP(I17,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-02","2 affaires impactées - Ok le 21/03","GIL",null,4,14,1]
[{"$nulls":3},"M2","eardf","P.TETE",{"$f":"VLOOKUP(F18,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-03-21","100%",{"$f":"IF(I18=\"\",\"\",VLOOKUP(I18,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-02","Listing disponible - le 21/03","Qualité",null,4,12,1]
[{"$nulls":3},"M4","\"aer","O.TOTO",{"$f":"VLOOKUP(F19,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-03-24","100%",{"$f":"IF(I19=\"\",\"\",VLOOKUP(I19,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-01","Diffusé en Prod le 24/03","Qualité",null,4,8,1]
[null,"14RC011","rs","M1","eardf","O.TOTO",{"$f":"VLOOKUP(F20,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-04-02","100%",{"$f":"IF(I20=\"\",\"\",VLOOKUP(I20,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-08","Ok","SRA",null,null,6,1]
[null,"14RC015","rs","M1","a\"req","P.TETE",{"$f":"VLOOKUP(F21,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-04-09","100%",{"$f":"IF(I21=\"\",\"\",VLOOKUP(I21,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-04-12",null,"Production",null,4,3,1]
[null,"14RC032","sr","M1","rtdg","P.TETE",{"$f":"VLOOKUP(F22,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-05-16","100%",{"$f":"IF(I22=\"\",\"\",VLOOKUP(I22,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-05-19",null,"Méthodes",null,5,3,1]
[{"$nulls":3},"M2","retd","P.TETE",{"$f":"VLOOKUP(F23,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-05-16","100%",{"$f":"IF(I23=\"\",\"\",VLOOKUP(I23,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-05-19",null,"Qualité",null,5,3,1]
[{"$nulls":3},"M3","etqdg","O.TOTO",{"$f":"VLOOKUP(F24,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-04-28","100%",{"$f":"IF(I24=\"\",\"\",VLOOKUP(I24,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-05-05",null,"Méthodes",null,5,7,1]
[{"$nulls":3},"M4","etqdg","P.TETE",{"$f":"VLOOKUP(F25,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-04-28","100%",{"$f":"IF(I25=\"\",\"\",VLOOKUP(I25,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-05-07",null,"Qualité",null,5,9,1]
[null,"14RC040","sr","M1","eqtd","O.TOTO",{"$f":"VLOOKUP(F26,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-06-02","100%",{"$f":"IF(I26=\"\",\"\",VLOOKUP(I26,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-08-05","J'ai modifié ce jour la FS afin d'apporter un point d'attention particulier sur le bon sertissage des écrous et la vérification du dépassement de 1 à 2 filets minimum","Log- Aval",null,8,64,1]
[{"$nulls":3},"M2","etd","J.TATA",{"$f":"VLOOKUP(F27,Codes!$V$1:$W$32,2)","v":"j.tata@holyshit.com"},"2014-06-02","100%",{"$f":"IF(I27=\"\",\"\",VLOOKUP(I27,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-11","Ce point n'est pas mentionné en tant que tel sur les fiches suiveuses mais fait partie du contrôle général de conformité.\nJe rappelle que dans le cas présent, la présence ou non d'un dépassement de 2 à 3 filets ne garantie pas la validité du serrage. En effet, comme tu peux le voir sur les photos ci-dessous, la vis est prise sur environ 1 cm. En conséquence, même si la vis affleure en sortie d'insert, la prise est suffisante pour garantir la tenue.\nLa différence qu'il peut y avoir d'une vis à l'autre dépend de la façon dont est fixé l'insert en question. Pour info, la sertisseuse est suivi en étalonage. La prochaine date limite de révision étant Octobre 2014.","Qualité",null,9,101,1]
[null,"14RC041","s","M1","aetq","O.TOTO",{"$f":"VLOOKUP(F28,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-06-30","100%",{"$f":"IF(I28=\"\",\"\",VLOOKUP(I28,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-05",null,"PSC",null,9,67,1]
[{"$nulls":3},"M11","eaq","P.TETE",{"$f":"VLOOKUP(F29,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-06-30","100%",{"$f":"IF(I29=\"\",\"\",VLOOKUP(I29,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-09"," l'étiquette rouge tombe bien dans les bom et est dispo en Bdl","Méthodes",null,9,71,1]
[null,"14RC048","s","M1","etd","O.TOTO",{"$f":"VLOOKUP(F30,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-06-30","100%",{"$f":"IF(I30=\"\",\"\",VLOOKUP(I30,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-06-30","Action Non retenue","Qualité",null,6,0,1]
[{"$nulls":3},"M3","tedq","P.TETE",{"$f":"VLOOKUP(F31,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-06-30","100%",{"$f":"IF(I31=\"\",\"\",VLOOKUP(I31,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-07-30",null,"IQF",null,7,30,1]
[null,"14RC051","sr","M1","etd","P.TETE",{"$f":"VLOOKUP(F32,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-07-01","100%",{"$f":"IF(I32=\"\",\"\",VLOOKUP(I32,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-07-01","Modification de l'UG dans SAP","Méthodes",null,6,0,1]
[null,"14RC052","sf","M1","et","P.TETE",{"$f":"VLOOKUP(F33,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-07-04","100%",{"$f":"IF(I33=\"\",\"\",VLOOKUP(I33,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-09",null,"BE",null,9,67,1]
[null,null,"zr","M2","etd","P.TETE",{"$f":"VLOOKUP(F34,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-09-11","100%",{"$f":"IF(I34=\"\",\"\",VLOOKUP(I34,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-10-21","Fait -Ok sous FQMC7/067 Ind .A","Qualité",null,10,40,1]
[{"$nulls":3},"M3","aetd","P.TETE",{"$f":"VLOOKUP(F35,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-09-11","100%",{"$f":"IF(I35=\"\",\"\",VLOOKUP(I35,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-10-15","Réponse le 10/09 : C'est validé de mon cotés, les modifications des gammes dans SAP seront réaliser en même temps que les modifs du Kitting pour début octobre.\nRéponse Greg le 03/11 :Converger vers une uniques étapes de finition (450 & 470) : C'est ok sur tous les nouveaux OF depuis S42","Méthodes",null,10,34,1]
[null,"14RC066","q","M1","etqdg","O.TOTO",{"$f":"VLOOKUP(F36,Codes!$V$1:$W$32,2)","v":"o.toto@holyshit.com"},"2014-09-11","100%",{"$f":"IF(I36=\"\",\"\",VLOOKUP(I36,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-15","Pas de retour la défaillance provien du moulage de la traversée","PSC",null,9,4,1]
[{"$nulls":3},"M2","etd","P.TETE",{"$f":"VLOOKUP(F37,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-09-08","100%",{"$f":"IF(I37=\"\",\"\",VLOOKUP(I37,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-08","Réponse du supplier conforme aux attentes ","Qualité",null,9,0,1]
[null,"14RC071","eqt","M1","etaqd","P.TETE",{"$f":"VLOOKUP(F38,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-09-17","100%",{"$f":"IF(I38=\"\",\"\",VLOOKUP(I38,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-09-17","Référence du Flash ligne poste porte","Qualité",null,9,0,1]
[{"$nulls":3},"M2","eqdf","P.TETE",{"$f":"VLOOKUP(F39,Codes!$V$1:$W$32,2)","v":"p.tete@holyshit.com"},"2014-09-19","25%",{"$f":"IF(I39=\"\",\"\",VLOOKUP(I39,[6]Codes!$O$4:$R$8,3,FALSE))","v":""},"2014-11-04","Vu avec J.TOTO - date cible le 31/10 \n\nOk - Fait","Méthodes",null,11,{"$f":"IF(K39=\"\",TODAY()-H39,K39-H39)","v":46},1]

{"sheet":"Codes","index":1,"n_rows":4,"n_cols":23,"rows_kept":4,"merged":[[0,6,0,9],[88,0,88,2]]}
[{"$nulls":21},"Porteurs d'actions","e-mail"]
[{"$nulls":21},"J.TATA","j.tata@holyshit.com"]
[{"$nulls":21},"O.TOTO","o.toto@holyshit.com"]
[{"$nulls":21},"P.TETE","p.tete@holyshit.com"]

{"sheet":"Calculs","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}