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

{"sheet":"07-04-2022","index":0,"n_rows":61,"n_cols":33,"rows_kept":61,"cut":false,"hidden":false,"merged":[[31,1,31,2],[32,1,32,2],[47,18,47,19],[49,18,49,19],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,18,1],[1,2,4,3],[1,4,4,16],[1,17,1,19],[1,21,1,23],[2,17,2,19],[2,21,2,23],[3,17,3,19],[3,21,3,23],[4,17,4,19],[4,21,4,23]]}
[]
[null,null,null,null,"Rapport journalier"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A","B","C","D","E","F","M","N","O","P","I","L","K","J","G","H"]
[null,"Machine",null,"SST16","SB16","BIGLIA 301 SM","BIGLIA 42 S2M bitourelle","L32","TSUGAMI","MORI SEIKI 3 axes","MORI SEIKI 5 axes","HARDING","KITAMURA","MULTIBROCHE","NAKAMURA","TOUR WEILER","Tour CNC WEILER UD 24 - 100","Tour STAR SV-32-J","Tour CNC STAR SB avec embarreur LNS Express"]
[null,"Référence",null,"-","G022-CP1","0-5928A-1","MI018-B42","200200-2022","i097-tsughami ","I110-01-004",null,480387,"9518-maj","MPS000300","I007","POMEL-P1","4-8748-1",68.081500000000005,200300]
[null,"Désignation",null,"Arrêt","AXE D15-M11*100 maj-c","Bague Galvanisée  14*22,9*54,2","GOUJON DE ROUE MITSIBITCHI GM-SUR-B42","Embout de tige-2022","ECROU DE ROUE FORD RANGER- finition rayon ","INSERT LEVIER SURMOULEE 345833-01 - fraisage ","Arrêt","Evacuation 2 et 3","USINAGE BORNE RBD-1 ","Raccord hex 17","ECROU SEMI ARBRE ISUZU","POMELLE-PIECE male","Bague Galvaniée 38*40,4*28-chutes ","Buse droite à collerette Ø8 M445 FRD","TIGE DE PISTON"]
[null,"Compteur 8h ",null,0,6470,0,9810,4771,6576,1148,0,84,6065,0,1648,855,36,10138,165]
[null,"Compteur 17h",null,0,6862,240,10124,4771,7063,1171,0,92,6220,0,1776,1053,193,10761,398]
[null,"Enregistrement","9h","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,null,"16h","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,"Identification",null,"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,"Propreté des tables de contrôle",null,"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,"Rangement des outils de contrôle",null,"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,"Existance de l'OF",null,"OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK","OK"]
[null,"Affutage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTA(D24:S24)","v":0}]
[null,"Maintenance"]
[null,"Nombre des NC poubelle "]
[null,"Nombre des NC à retoucher"]
[null,"Machine pour retouche"]
[null,"Panne"]
[null,"Cout pièces de rechange",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D30:S30)","v":0}]
[null,"prix de revient pièce",null,{"$f":"IFERROR(VLOOKUP(D14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(E14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(F14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(G14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(H14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(I14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(J14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":2.1488},{"$f":"IFERROR(VLOOKUP(K14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(L14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":5.3719999999999999},{"$f":"IFERROR(VLOOKUP(M14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(N14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(O14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":0},{"$f":"IFERROR(VLOOKUP(P14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(Q14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(R14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":"0"},{"$f":"IFERROR(VLOOKUP(S14,'[1]Prix de revient'!$A:$D,4,0),\"0\")","v":3.2674400000000001}]
[null,"coût de rebuts",null,{"$f":"D26*D31","v":0},{"$f":"E26*E31","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(D32:S32)","v":0}]
[null,"gestion de modification"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Clients","Audit","Réclamation","Avoir",null,"Fournisseurs/ sous-traitants","Réception de matiere","Probleme qualité",null,"Les formations professionnelles","Cout","Chiffrage décliné","Actions à suivre",null,"Article qui a subit un tri","durée du tri","Nombre des pieces non-conformes","ouvrier faisant le tri","cout par tri",null,"Article qui a subit la reprise","durée de la reprise","opérateur faisant la reprise","coût de reprise",null,null,null,"Machine ","article","gamme","objet de la modification"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R42=\"\",\"\",R42*VLOOKUP(T42,'[1]cout opérateur machines'!A1:B8,2,0))","v":""},null,null,null,null,{"$f":"X42*8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R43=\"\",\"\",R43*VLOOKUP(T43,'[1]cout opérateur machines'!A2:B9,2,0))","v":""},null,null,null,null,{"$f":"X43*8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R44=\"\",\"\",R44*VLOOKUP(T44,'[1]cout opérateur machines'!A3:B10,2,0))","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R45=\"\",\"\",R45*VLOOKUP(T45,'[1]cout opérateur machines'!A4:B11,2,0))","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R46=\"\",\"\",R46*VLOOKUP(T46,'[1]cout opérateur machines'!A5:B12,2,0))","v":""},null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R47=\"\",\"\",R47*VLOOKUP(T47,'[1]cout opérateur machines'!A6:B13,2,0))","v":""},null,null,null,null,0]
[null,null,null,null,{"$f":"COUNTA(E42:E47)","v":0},{"$f":"SUM(F42:F47)","v":0},null,null,null,null,null,null,{"$f":"SUM(M42:M47)","v":0},"causes de refus",null,null,null,null,"cout total du jour",null,{"$f":"SUM(U42:U47)","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,"envoi des réclamations F/ S-T","réponse F/ S-T","alerte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z42:Z48)","v":0}]
[null,null,"dans le cas d'une réclamation",null,null,null,null,null,null,{"$f":"IF(J42=\"\",\"\",IF(H50=0,\" réclamation non traitée\",IF(I50=0, \"veuillez contacter le F/ S-T par téléphone\",\"\")))","v":""},null,null,null,null,null,null,null,null,"N° mois",null,4]
[null,null,"nombre de pièces NC",null,null,null,null,null,null,{"$f":"IF(J43=\"\",\"\",IF(H51=0,\" réclamation non traitée\",IF(I51=0, \"veuillez contacter le F/ S-T par téléphone\",\"\")))","v":""}]
[null,null,"nombre de pièces par carton",null,null,null,null,null,null,""]
[null,null,"coût de transport par carton",null,null,null,null,null,null,""]
[null,null,"nombre de cartons renvoyés",null,null,null,null,null,null,""]
[null,null,"temps de tri",null,null,null,null,null,null,""]
[null,null,"coût horaire de tri"]
[null,null,"temps de retouche"]
[null,null,"coût horaire de retouche"]
[null,null,"temps de traitement de la réclamation"]
[null,null,"coût horaire de traitement"]
[null,null,"coût total",{"$f":"IFERROR(((D51/D52)*D53)+D54*D53+D55*D56+D57*D58+D59*D60,\"\")","v":""}]