{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Relevé","Compteur","Garnissage","Usinage version simple"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"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":"Relevé","index":0,"n_rows":51,"n_cols":19,"rows_kept":51,"cut":false,"hidden":false,"merged":[[14,2,14,3],[20,2,20,3],[33,13,38,13],[27,13,32,13],[39,13,44,13],[45,13,50,13],[3,0,8,0],[9,0,14,0],[9,13,14,13],[21,0,26,0],[21,1,26,1],[15,0,20,0],[9,1,14,1],[15,1,20,1],[15,13,20,13],[21,13,26,13],[27,1,32,1],[39,0,44,0],[1,0,2,0],[1,2,2,2],[1,1,2,1],[0,0,0,13],[3,13,8,13],[3,1,8,1],[8,2,8,3],[1,14,2,14],[1,4,2,4],[1,13,2,13],[1,3,2,3],[1,5,1,12],[27,0,32,0],[39,1,44,1],[45,0,50,0],[45,1,50,1],[33,0,38,0],[33,1,38,1]]}
["Detection probleme usinage Imac 1"]
["Piece","N° d'OP","N° D'OF","Qui","Date","Cause",null,null,null,null,null,null,null,"Nbre de rebut /100pcs",null,null,"Date de debut",{"$f":"Compteur!O2","v":"2014-03-01"},"N°de semaine en cours"]
[null,null,null,null,null,"Brut","Dimension","Déformation","Casse Outil","Esthétique ","Reglage","Dysfonctionnement","Manipulation",null,null,null,"1ere Sem du mois en cours",{"$f":"Compteur!O3","v":9},{"$f":"Sem_Cours","v":13}]
["Platine",1,null,null,{"$f":"IF((SUM(F4:M4))>0,TODAY(),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F4:M8)>0,SUM(F4:M8),\"\")","v":""}]
[null,null,null,null,{"$f":"IF((SUM(F5:M5))>0,TODAY(),\"\")","v":""}]
[null,null,null,null,{"$f":"IF((SUM(F6:M6))>0,TODAY(),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F4:F8)","v":0},{"$f":"SUM(G4:G8)","v":0},0,0,0,0,0,{"$f":"SUM(M4:M8)","v":0}]
["Platine",2,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F10:M14)>0,SUM(F10:M14),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF((SUM(F12:M12))>0,TODAY(),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F10:F14)","v":0},{"$f":"SUM(G10:G14)","v":0},0,0,0,0,0,0]
["Platine",3,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F16:M20)>0,SUM(F16:M20),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F16:F20)","v":0},{"$f":"SUM(G16:G20)","v":0},0,0,0,0,0,0]
["Rouage",1,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F22:M26)>0,SUM(F22:M26),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F22:F26)","v":0},{"$f":"SUM(G22:G26)","v":0},0,0,0,0,0,0]
["Rouage",2,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F28:M32)>0,SUM(F28:M32),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F28:F32)","v":0},{"$f":"SUM(G28:G32)","v":0},{"$f":"SUM(H28:H32)","v":0},{"$f":"SUM(I28:I32)","v":0},{"$f":"SUM(J28:J32)","v":0},{"$f":"SUM(K28:K32)","v":0},{"$f":"SUM(L28:L32)","v":0},{"$f":"SUM(M28:M32)","v":0}]
["Rouage",3,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F34:M38)>0,SUM(F34:M38),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F34:F38)","v":0},{"$f":"SUM(G34:G38)","v":0},0,0,0,0,0,0]
["Balancier",1,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F40:M44)>0,SUM(F40:M44),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F40:F44)","v":0},{"$f":"SUM(G40:G44)","v":0},0,0,0,0,0,0]
["Balancier",2,null,null,"",null,null,null,null,null,null,null,null,{"$f":"IF(SUM(F46:M50)>0,SUM(F46:M50),\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,"TOTAL",{"$f":"SUM(F46:F50)","v":0},{"$f":"SUM(G46:G50)","v":0},{"$f":"SUM(H46:H50)","v":0},{"$f":"SUM(I46:I50)","v":0},{"$f":"SUM(J46:J50)","v":0},{"$f":"SUM(K46:K50)","v":0},{"$f":"SUM(L46:L50)","v":0},{"$f":"SUM(M46:M50)","v":0}]

{"sheet":"Compteur","index":1,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,11,2,11],[1,2,2,2],[1,3,1,10],[38,0,42,0],[38,1,42,1],[13,0,17,0],[13,1,17,1],[18,0,22,0],[18,1,22,1],[23,0,27,0],[23,1,27,1],[28,0,32,0],[28,1,32,1],[33,1,37,1],[3,1,7,1],[3,0,7,0],[1,1,2,1],[1,0,2,0],[33,0,37,0],[8,1,12,1],[8,0,12,0]]}
[]
["Piece","N° d'OP","Date (n° de semaine)","Cause",null,null,null,null,null,null,null," rebut /100pcs / semaine",null,"Date de debut",{"$f":"DATE(2014,3,1)","v":"2014-03-01"},"N°de semaine en cours"]
[null,null,null,"Brut","Dimension","Déformation","Casse Outil","Esthétique ","Reglage","Dysfonct","Manipulation",null,null,"1ere Sem du mois en cours",{"$f":"_xludf.IsoWeekNum(O2)","v":9},{"$f":"_xludf.IsoWeekNum(TODAY())","v":13},null,"\"=SI(IsoWeekNum(AUJOURDHUI())=C4;Relevé!F9;\"\")"]
["Platine",1,{"$f":"O3","v":9},{"$f":"IF(C4=$P$3,Relevé!$F$9,\"\")","v":""},{"$f":"IF(C4=$P$3,Relevé!$G$9,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(D4:K4)>0,SUM(D4:K4),\"\")","v":""}]
[null,null,{"$f":"C4+1","v":10},{"$f":"IF(C5=$P$3,Relevé!$F$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$G$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$H$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$K$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$L$9,\"\")","v":""},{"$f":"IF(C5=$P$3,Relevé!$M$9,\"\")","v":""},{"$f":"IF(SUM(D5:K5)>0,SUM(D5:K5),\"\")","v":""}]
[null,null,{"$f":"C5+1","v":11},{"$f":"IF(C6=$P$3,Relevé!$F$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$G$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$H$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$K$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$L$9,\"\")","v":""},{"$f":"IF(C6=$P$3,Relevé!$M$9,\"\")","v":""},""]
[null,null,12,{"$f":"IF(C7=$P$3,Relevé!$F$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$G$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$H$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$J$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$K$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$L$9,\"\")","v":""},{"$f":"IF(C7=$P$3,Relevé!$M$9,\"\")","v":""},""]
[null,null,13,51,48,49,46,52,42,47,42,377]
["Platine",2,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C9+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C10+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,6,6,6,6,6,6,6,6,48]
["Platine",3,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C14+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C15+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,4,4,4,4,4,4,4,4,32]
["Rouage",1,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C19+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C20+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,3,3,3,3,3,3,3,3,24]
["Rouage",2,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C24+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C25+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,3,3,3,3,3,3,3,3,24]
["Rouage",3,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C29+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C30+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,3,3,3,3,3,3,3,3,24]
["Balancier",1,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C34+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C35+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,17,17,17,17,17,17,17,17,136]
["Balancier",2,{"$f":"O3","v":9},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C39+1","v":10},null,null,null,null,null,null,null,null,""]
[null,null,{"$f":"C40+1","v":11},null,null,null,null,null,null,null,null,""]
[null,null,12,null,null,null,null,null,null,null,null,""]
[null,null,13,0,0,0,0,0,0,0,0,""]

{"sheet":"Garnissage","index":2,"n_rows":175,"n_cols":12,"rows_kept":175,"cut":false,"hidden":false,"merged":[[0,4,1,4],[0,5,1,5],[0,6,1,6],[2,0,33,0],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,4,36,4],[23,1,33,1],[12,1,22,1],[2,1,11,1],[0,3,1,3],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,7,1,7],[0,8,1,8],[0,9,1,9],[35,11,36,11],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[35,9,36,9],[35,10,36,10],[0,10,1,10],[0,11,1,11],[37,1,46,1],[47,1,56,1],[57,1,66,1],[37,0,66,0],[70,0,71,0],[70,1,71,1],[70,2,71,2],[70,3,71,3],[70,4,71,4],[70,11,71,11],[72,0,91,0],[72,1,81,1],[82,1,91,1],[105,0,106,0],[105,1,106,1],[105,2,106,2],[105,3,106,3],[105,4,106,4],[70,5,71,5],[70,6,71,6],[70,7,71,7],[70,8,71,8],[70,9,71,9],[70,10,71,10],[105,11,106,11],[105,5,106,5],[105,6,106,6],[105,7,106,7],[105,8,106,8],[105,9,106,9],[105,10,106,10],[107,0,138,0],[107,1,116,1],[117,1,127,1],[128,1,138,1],[140,0,141,0],[140,1,141,1],[140,2,141,2],[140,3,141,3],[140,4,141,4],[140,11,141,11],[142,0,152,0],[142,1,152,1],[155,0,156,0],[155,1,156,1],[155,2,156,2],[155,3,156,3],[155,4,156,4],[140,5,141,5],[140,6,141,6],[140,7,141,7],[140,8,141,8],[140,9,141,9],[140,10,141,10],[172,7,173,7],[172,8,173,8],[172,9,173,9],[172,10,173,10],[172,11,173,11],[174,0,184,0],[174,1,184,1],[155,11,156,11],[157,0,167,0],[157,1,167,1],[172,0,173,0],[172,1,173,1],[172,2,173,2],[172,3,173,3],[172,4,173,4],[172,5,173,5],[172,6,173,6],[155,5,156,5],[155,6,156,6],[155,7,156,7],[155,8,156,8],[155,9,156,9],[155,10,156,10]]}
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Platine","Ebavurage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Garnissage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empierrage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Pont de barillet","Rivetage  1ère roue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Rivetage  2ième roue"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empierrage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Pont de balancier","Ebavurage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Assemblage composant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Pont de rouage","Ebavurage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Garnissage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Empierrage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Pont de dispo","Empierrage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Pont d'ancre","Empierrage"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Piece","Opération","Qui","Date","Nbre de rebut ","Composant","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation"]
[]
["Couvre méca","Assemblage composant"]

{"sheet":"Usinage version simple","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,5,1,5],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,12,1,12],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["Piece","Opération","Qui","Date","Nbre de rebut ","Brut","Dysfonctionnement","Reglage","Dimension","Déformation","Esthétique","Manipulation","Casse outil"]