{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["En Cours Usinage","JAUGES OP","Données","Liste"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":0,"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":"En Cours Usinage","index":0,"n_rows":16,"n_cols":27,"rows_kept":16,"cut":false,"hidden":false,"merged":[[15,2,18,10]]}
[]
[]
[]
[]
["Client","étapes","type de travail","Emplacement","Gamme","Date de prise en charge","OF","DT","DESIGNATION","Opérateur ","Phase","description","gabarit","Machines","commentaires"," QTE CDEE ","QTE EFFECTUE","reste à faire","temps de cycle / pcs","REBUT","temps de prod","temps de panne","DATE DE SORTIE PREVU ","temps de prod restant","Date de sortie réalisable","Destination","recherche si mois en cours"]
["RENAULT","EC",null,null,null,null,null,1919,null,"Jacques","FINAL",null,null,"FRAISEUSE CN NUM",null,50,20,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":30},1.3888888888888888E-2,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0.41666666666666663},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Tableau17[[#This Row],[ QTE CDEE ]]-Tableau17[[#This Row],[QTE EFFECTUE]]","v":0},null,null,null,null,null,{"$f":"Tableau17[[#This Row],[temps de cycle / pcs]]*Tableau17[[#This Row],[reste à faire]]","v":0},null,null,false]
[]
[]
[null,null,"si dans une ligne il ya EC dans colonne \"étape\" et Jacques dans colonne \"Opérateur\" alors le tableau de la page \"JAUGE OP\" se remplie avec  les indication des colonnes \"DT\", nombre de pièces (QTE CDEE), pièces fini (QTE EFFECTUE), temps de cycle / pièces"]

{"sheet":"JAUGES OP","index":1,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,5],[14,5,15,5],[16,0,16,7],[1,2,1,4],[14,1,15,1],[7,5,7,6],[8,5,8,6],[0,7,15,7],[9,6,15,6],[9,2,10,5],[8,2,8,3],[5,0,6,1],[0,0,0,1]]}
[]
["Vert",80,"CARTER"]
["Orange",10]
["rouge",10]
["Somme",{"$f":"SUM(B2:B4)","v":100}]
[]
[]
[{"$f":"C15","v":0.7142857142857143},{"$f":"C15*100","v":71.428571428571431},{"$f":"B8/100","v":0.7142857142857143},null,"Phase :",1]
[{"$f":"B13","v":7027},1.5,null,null,"Machines :","NUM"]
[{"$f":"D15","v":0.20833333333333331},{"$f":"SUM(B2:B5)-B8-B9","v":127.07142857142856}]
[]
[null,"DT","nb pièces","TPS DE CYCLE / PCS","pièces fini","reste"]
[null,7027,70,1.0416666666666666E-2,50,{"$f":"C13-E13","v":20}]
[]
[null,"Jacques",{"$f":"SUM(E13/C13)","v":0.7142857142857143},{"$f":"F13*D13","v":0.20833333333333331},{"$f":"(D15/8.5)*24","v":0.58823529411764697}]
[null,null,"calcul jauge","reste en H","reste en jour"]

{"sheet":"Données","index":2,"n_rows":7,"n_cols":24,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["DATE","OF","N°DT","DENOMINATION","OPERATEUR","PHASE","description","GABARIT","MACHINES","Nb pieces total","pièces usinée","Rebuts","% de perte","TPS DE PRODUCTION","TPS DE CYCLE PAR PIECES","NB PIECES PAR HEURES","TPS DE PANNE","temps de production cumulé / machine","nombre d'utilisations","temps de pannes totale","pourcentage de production  / pannes","Gamme","Destination","Client"]
["2019-12-04","","9304.301","bossage","Laurent","FINAL","tournage suivant plan","","TOUR CN",18,18,0,{"$f":"L2/K2","v":0},0.33333333333333331,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":1.8518518518518517E-2},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":2.2464},0,{"$f":"SUMIFS($N$1:$N$1134,$I$1:$I$1134,I2)","v":0.33333333333333331},{"$f":"COUNTIF(I:I,I2)","v":1},{"$f":"SUMIFS($Q$1:$Q$1134,$I$1:$I$1134,I2)","v":0},{"$f":"1-(T2/R2)","v":1}]
["2019-12-03",null,"1999","sangle","Franck","FINAL","montage",null,2240,11,11,0,0,7.2916666666666671E-2,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":6.628787878787879E-3},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":6.2756571428571428},0,7.2916666666666671E-2,1,0,1]
["2019-12-03",null,"2476","deflecteurs","Jonathan",1,"mise à hauteur","","Cazeneuve 304","320","280","2",7.1428571428571426E-3,0.33333333333333331,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":1.1904761904761904E-3},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":34.944000000000003},0,0.33333333333333331,1,0,1]
["2019-12-03",null,"9450","tube coudé","Jean-marie","FINAL","decoupe en bié","","FRAISEUSE HURON 7828","31",31,"0",0,0.15625,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":5.0403225806451612E-3},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":8.2534399999999994},0,1.1979166666666667,2,0,1]
["2020-03-24","PF0211/020",2020.002,"bossage","Jacques","FINAL","perçage","K 504","FRAISEUSE CN NUM",50,50,2,{"$f":"L6/K6","v":0.04},8.4722222222222213E-2,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":1.6944444444444442E-3},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":24.550819672131151},"0h 00min",8.4722222222222213E-2,1,0,{"$f":"1-(T6/R6)","v":1},"OUI","SOUDURE","biloute"]
["2020-03-21","PF0211",1975.1,"bilu","Béatrice","FINAL","chanf","K 012","FRAISEUSE HURON 7828",200,200,1,{"$f":"L7/K7","v":5.0000000000000001E-3},1.0416666666666667,{"$f":"Tableau1[[#This Row],[TPS DE PRODUCTION]]/Tableau1[[#This Row],[pièces usinée]]","v":5.2083333333333339E-3},{"$f":"IF(Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0.0416/Tableau1[[#This Row],[TPS DE CYCLE PAR PIECES]],0)","v":7.9871999999999987},"1h 00min",1.1979166666666667,2,0,{"$f":"1-(T7/R7)","v":1},"NON","PRESSE","bibi"]

{"sheet":"Liste","index":3,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Opérateur",null,"type de travail",null,"ETAPE",null,"Machine",null,"operateur",null,"Phases",null,null,"GAMME",null,"DESTINATION"]
["Jacques",null,"fraisage",null,"EC",null,"TOUR CN",null,"Jacques",null,"Montage",null,null,"OUI",null,"SOUDURE"]
["Jean-marie",null,"taraudage",null,"ATT",null,"FRAISEUSE CN NUM",null,"Jean-marie",null,"REPRISE",null,null,"NON",null,"PRESSE"]
["Béatrice",null,"fraisurage",null,"OK",null,"CENTRE USINAGE BRIDGEPORT",null,"Béatrice",null,"FINAL",null,null,null,null,"QUALITER"]
["Franck",null,"tournage",null,"PB",null,"FRAISEUSE HURON 7828",null,"Franck",null,"Reprise outils",null,null,null,null,"SOUS TRAITANCE"]
["Laurent",null,"reprise",null,null,null,"ROSCAMAT",null,"Laurent",null,"Redressage",null,null,null,null,"EXPEDITION"]
["Castera stagière",null,"réparation",null,null,null,"TOUR RAMO T36 7817",null,"Castera stagière",null,"réglage",null,null,null,null,"CATAPHOREZE"]
["Téo stagière",null,null,null,null,null,"Cazeneuve 304",null,"Téo stagière",null,1,null,null,null,null,"PEINTURE"]
["Isabelle",null,null,null,null,null,"Radiale 7808",null,"Isabelle",null,2,null,null,null,null,"USINAGE"]
["Jonathan",null,null,null,null,null,"HURE 7814",null,"Jonathan",null,3,null,null,null,null,"PLIEUSE"]
["Romain",null,null,null,null,null,"TOUR 3310",null,"Romain",null,4,null,null,null,null,"ZONE PIECE FINI USINAGE"]
["Loïs",null,null,null,null,null,"DUFOUR 3322",null,"Loïs",null,5,null,null,null,null,"MONTAGE"]
[null,null,null,null,null,null,"MARTIN 7820",null,null,null,6]
[null,null,null,null,null,null,"CAZENEUVE 3330",null,null,null,7]
[null,null,null,null,null,null,"CAZENEUVE 3307",null,null,null,8]
[null,null,null,null,null,null,"VOEST 3303",null,null,null,9]
[null,null,null,null,null,null,"TOUR 3339",null,null,null,10]
[null,null,null,null,null,null,"BOSCH 3340"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE CINCINNATI"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 7812"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 7813"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 3326"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 3327"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 3311"]
[null,null,null,null,null,null,"PERCEUSE A COLONNE 7811"]
[null,null,null,null,null,null,"Ebogueuse 4032"]
[null,null,null,null,null,null,"SABLEUSE"]
[null,null,null,null,null,null,"RECTIFIEUSE"]
[null,null,null,null,null,null,"Mortaiseuse 3341"]
[null,null,null,null,null,null,2240]
[null,null,null,null,null,null,"GRAVEUSE"]
[null,null,null,null,null,null,"MANUEL"]
[null,null,null,null,null,null,"CAZENEUVE 3308"]
[null,null,null,null,null,null,"rectifieuse 7824 (petite)"]