{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Accueil","Préventif","Formulaire Préventif","Planning","Pense-bête","Test Récapitulatif","Formulaire Curatif","Login","Accueil 2","Planning_général","Planification du préventif","Histo maintenances Préventif","Historique maintenances Curatif","Ressources","Membres"],"not_rendered":{"charts":0,"images":37,"macros":1,"external_links":0,"defined_names":50,"comments":2,"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":"Accueil","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[0,0,4,2]]}

{"sheet":"Préventif","index":1,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,11,3,14]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Préventif"]

{"sheet":"Formulaire Préventif","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,8,12,11]]}
[]
[]
[]
[]
[null,"Pôle","Équipement","Type de maintenance","Date de la maintenance","Date du jour","ÉTAT"]
[null,"Équipement_de_support",null,null,{"$f":"IFERROR(INDEX('Planification du préventif'!H4:H92,MATCH('Formulaire Préventif'!D6,'Planification du préventif'!B4:B92,0)),\"\")","v":""},{"$f":"TODAY()","v":"2019-07-09"},{"$f":"IFERROR(_xlfn.IFS(F6>E6,\"En retard de \"&(F6-E6)&\" jours\",E6>F6,\"En avance de \"&E6-F6&\" jours\",E6=F6,\"Date Prévue\"),\"\")","v":""}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Préventif"]

{"sheet":"Planning","index":3,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,12,4,15]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Préventif"]
[]
[null,null,null,null,null,"Technicien"]
[null,null,null,null,null,"Alexandre",null,null,"N° Équipement","Opérations de maintenance","Date pro intervention"]

{"sheet":"Pense-bête","index":4,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,2,2,2],[4,5,6,8]]}
[null,null,"Fiche procédure Récapitulatif"]
[]
[]
[]
[null,null,null,null,null,"Préventif"]
[]
[]
[]
[]
[]
["T01","Tour Conv HERNAULT","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\Préventif\\FICHE PROCÉDURE\\TOURNAGE\\T01 TOURNAGE CONV HERNAULT.odp"]
["T02","Tour conv. METAFLEX France","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T02 TOURNAGE CONV MÉTAFLEX.odp"]
["T03","Tour CN  MICROCUT omnitechnique","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T03 TOURNAGE MICROCUT.odp"]
["T04","Tour CN de 3 et 4 axes  - CMZ TL20M","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T04 TOURNAGE CMZ TL20M.odp"]
["T05","Tour CN de 3 et 4 axes  - CMZ TA30Y","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T05 TOURNAGE CMZ TA30Y.odp"]
["T06","Tour CN  STARMECA","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T06 TOURNAGE STARMECA.odp"]
["T07","Tour CN - Cazeneuve ","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\TO7 TOURNAGE CAZENEUVE.odp"]
["F01","Centre usinage CN 3 axes - VICTOR","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F02 - F01 FRAISEUSE VICTOR.odp"]
["F02","Centre usinage CN 3 axes - VICTOR","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F02 - F01 FRAISEUSE VICTOR.odp"]
["F03","Centre usinage CN 3 axes - FEELER","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F04 - F03 FRAISEUSE FEELER.odp"]
["F04","Centre usinage CN 3 axes - FEELER","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F04 - F03 FRAISEUSE FEELER.odp"]
["F05","Fraiseuse CN 5 axes - FPT TESSEN ","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F05 FRAISEUSE FPT TESSEN.odp"]
["F06","Fraiseuse CN 3 axes - HEDELIUS BC100","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F06 FRAISEUSE HEDELIUS BC100.odp"]
["F07","Fraiseuse CN 5 axes - HEDELIUS TILENTA 7","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F07 FRAISEUSE HEDELIUS TILENTA 7.odp"]
["F08","Fraiseuse CN3 axes - KIHEUNG","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F08 FRAISEUSE KIHEUNG.odp"]
["E01","Érosion CN Enfonçage - GF ROBOFORM200","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E01 Érosion Enfonçage ROBOFORM200.odp"]
["E02","Érosion CN Enfonçage - GF EDM FORM20","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E02 Érosion Enfonçage EDM FORM20.odp"]
["E03","Érosion CN Découpe fil - GF ROBOFIL2020","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E03 Érosion Fil ROBOFIL2020.odp"]
["E04","Érosion CN Découpe fil - GF CUT300","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E04 Érosion Fil CUT300.odp"]
["E05","Perçage Microforage (étincellage) - CCR Technologie CR200","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E05 Perçage Microforage.odp"]
["R03","Rectifieuse CN - CN HAUSER S3","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\RECTIFICATION\\R03 RECTIFIEUSE CN HAUSER.odp"]
["A1","Fraiseuse GAMBIN","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A1 Fraiseuse GAMBIN.odp"]
["A2","Fraiseuse HOLKE","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A2 Fraiseuse HOLKE.odp"]
["A3","MICROBILLEUSE","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A3 MICROBILLEUSE.odp"]
["A4","SABLEUSE","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A4 SABLEUSE.odp"]
["D1","Scie ruban KASTO","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\DÉBIT\\SCIE A RUBAN KASTO.odp"]
["EC1","Machine de Mesure Tridimensionnelle - DEA GAMMA 1103","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC1 MMT.odp"]
["EC2","Projecteur de profil SAGEM","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC2 PROJECTEUR DE PROFIL.odp"]
["EC3","Colonne de mesure TRIMOS","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC3 COLONNE DE MESURE.odp"]
["ES1","Compresseur GENESIS","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE SUPPORT\\ES1 COMPRESSEUR GENESIS.odp"]
["ES2","Groupe Froid ROBOFORM200","\\\\srv-clipper\\bms\\production\\STAGE\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE SUPPORT\\ES2 Groupe FROID.odp"]

{"sheet":"Test Récapitulatif","index":5,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,"Nom du fichier","LeagueClient.exe"]
[null,null,null,null,null,null,null,"Lien",{"$f":"IFERROR(VLOOKUP(I2,Tableau49[],2,0),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,"Nom du Fichier","Lien"]
[null,null,null,null,null,null,null,"T01 TOURNAGE CONV HERNAULT.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T01 TOURNAGE CONV HERNAULT.odp"]
[null,null,null,null,null,null,null,"T02 TOURNAGE CONV MÉTAFLEX.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T02 TOURNAGE CONV MÉTAFLEX.odp"]
[null,null,null,null,null,null,null,"T03 TOURNAGE MICROCUT.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T03 TOURNAGE MICROCUT.odp"]
[null,null,null,null,null,null,null,"T04 TOURNAGE CMZ TL20M.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T04 TOURNAGE CMZ TL20M.odp"]
[null,null,null,null,null,null,null,"T05 TOURNAGE CMZ TA30Y.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T05 TOURNAGE CMZ TA30Y.odp"]
[null,null,null,null,null,null,null,"T06 TOURNAGE STARMECA.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\T06 TOURNAGE STARMECA.odp"]
[null,null,null,null,null,null,null,"TO7 TOURNAGE CAZENEUVE.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\TOURNAGE\\TO7 TOURNAGE CAZENEUVE.odp"]
[null,null,null,null,null,null,null,"F02 - F01 FRAISEUSE VICTOR.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F02 - F01 FRAISEUSE VICTOR.odp"]
[null,null,null,null,null,null,null,"F04 - F03 FRAISEUSE FEELER.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F04 - F03 FRAISEUSE FEELER.odp"]
[null,null,null,null,null,null,null,"F05 FRAISEUSE FPT TESSEN.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F05 FRAISEUSE FPT TESSEN.odp"]
[null,null,null,null,null,null,null,"F06 FRAISEUSE HEDELIUS BC100.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F06 FRAISEUSE HEDELIUS BC100.odp"]
[null,null,null,null,null,null,null,"F07 FRAISEUSE HEDELIUS TILENTA 7.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F07 FRAISEUSE HEDELIUS TILENTA 7.odp"]
[null,null,null,null,null,null,null,"F08 FRAISEUSE KIHEUNG.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\FRAISAGE\\F08 FRAISEUSE KIHEUNG.odp"]
[null,null,null,null,null,null,null,"E01 Érosion Enfonçage ROBOFORM200.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E01 Érosion Enfonçage ROBOFORM200.odp"]
[null,null,null,null,null,null,null,"E02 Érosion Enfonçage EDM FORM20.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E02 Érosion Enfonçage EDM FORM20.odp"]
[null,null,null,null,null,null,null,"E03 Érosion Fil ROBOFIL2020.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E03 Érosion Fil ROBOFIL2020.odp"]
[null,null,null,null,null,null,null,"E04 Érosion Fil CUT300.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E04 Érosion Fil CUT300.odp"]
[null,null,null,null,null,null,null,"E05 Perçage Microforage.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉROSION\\E05 Perçage Microforage.odp"]
[null,null,null,null,null,null,null,"R03 RECTIFIEUSE CN HAUSER.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\RECTIFICATION\\R03 RECTIFIEUSE CN HAUSER.odp"]
[null,null,null,null,null,null,null,"A1 Fraiseuse GAMBIN.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A1 Fraiseuse GAMBIN.odp"]
[null,null,null,null,null,null,null,"A2 Fraiseuse HOLKE.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A2 Fraiseuse HOLKE.odp"]
[null,null,null,null,null,null,null,"A3 MICROBILLEUSE.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A3 MICROBILLEUSE.odp"]
[null,null,null,null,null,null,null,"A4 SABLEUSE.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\AJUSTAGE\\A4 SABLEUSE.odp"]
[null,null,null,null,null,null,null,"D1 SCIE A RUBAN KASTO.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\DÉBIT\\D1 SCIE A RUBAN KASTO.odp"]
[null,null,null,null,null,null,null,"EC1 MMT.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC1 MMT.odp"]
[null,null,null,null,null,null,null,"EC2 PROJECTEUR DE PROFIL.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC2 PROJECTEUR DE PROFIL.odp"]
[null,null,null,null,null,null,null,"EC3 COLONNE DE MESURE.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE CONTRÔLE\\EC3 COLONNE DE MESURE.odp"]
[null,null,null,null,null,null,null,"ES1 COMPRESSEUR GENESIS.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE SUPPORT\\ES1 COMPRESSEUR GENESIS.odp"]
[null,null,null,null,null,null,null,"ES2 Groupe FROID.odp","Z:\\Armand PETIT\\GMAO\\FICHE PROCÉDURE\\ÉQUIPEMENT DE SUPPORT\\ES2 Groupe FROID.odp"]

{"sheet":"Formulaire Curatif","index":6,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,4,19,6]]}
[]
[]
[null,null,"Pôle","Équipement","Problème","Tâche planifié","Date de maintenance","Niveau de maintenance","Utilisateur assigné à la tâche"]
[null,null,null,null,null,null,null,null,"Sous-traitant"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Curatif"]

{"sheet":"Login","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Accueil 2","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Planning_général","index":9,"n_rows":150,"n_cols":76,"rows_kept":150,"cut":false,"hidden":true,"merged":[[16,59,19,59],[16,60,19,60],[16,57,19,57],[16,58,19,58],[16,61,19,61],[16,67,19,67],[16,68,19,68],[16,69,19,69],[16,62,19,62],[16,63,19,63],[16,64,19,64],[16,65,19,65],[16,66,19,66],[16,74,19,74],[16,75,19,75],[16,70,19,70],[16,71,19,71],[16,72,19,72],[16,73,19,73],[1,42,3,46],[25,46,27,63],[16,45,19,45],[16,46,19,46],[16,47,19,47],[16,48,19,48],[16,49,19,49],[16,50,19,50],[16,51,19,51],[16,52,19,52],[16,53,19,53],[16,54,19,54],[16,55,19,55],[16,56,19,56],[4,42,4,46],[5,42,6,46]]}
[null,null,null,null,null,{"$f":"AQ6","v":"2019-07-09"},{"$f":"F1+1","v":"2019-07-10"},{"$f":"G1+1","v":"2019-07-11"},"2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16","2019-07-17","2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03","2019-08-04","2019-08-05","2019-08-06","2019-08-07","2019-08-08"]
["N° Équipement","Opérations de maintenance","Date pro intervention","Tps en jrs","Date Fin Intervention",{"$f":"AT22","v":"M"},{"$f":"AU22","v":"M"},"J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J",null,null,null,null,null,null,"Ne pas supprimer ces données car elles sont utilisées dans le graphique afin de faire avancer et faire reculer les jours."]
[null,"Colonne1","Colonne2","Colonne3","Colonne4","Colonne5","Colonne6","Colonne7","Colonne8","Colonne9","Colonne10","Colonne11","Colonne12","Colonne13","Colonne14","Colonne15","Colonne16","Colonne17","Colonne18","Colonne19","Colonne20","Colonne21","Colonne22","Colonne23","Colonne24","Colonne25","Colonne26","Colonne27","Colonne28","Colonne29","Colonne30","Colonne31","Colonne32","Colonne33","Colonne34","Colonne35"]
["ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L",{"$f":"IF(ISBLANK($B4),0,VLOOKUP($B4,Tableau1[],7,0))","v":"2019-10-07"},{"$f":"IF(ISBLANK($B4),0,VLOOKUP($B4,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B4),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-10-07"},{"$f":"IF(AND(($F$1-$C4)>=0,($F$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C4)>=0,($G$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C4)>=0,($H$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C4)>=0,($I$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C4)>=0,($J$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C4)>=0,($K$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C4)>=0,($L$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C4)>=0,($M$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C4)>=0,($N$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C4)>=0,($O$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C4)>=0,($P$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($Q$1-$C4)>=0,($Q$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C4)>=0,($R$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C4)>=0,($S$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C4)>=0,($T$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C4)>=0,($U$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C4)>=0,($V$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C4)>=0,($W$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C4)>=0,($X$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C4)>=0,($Y$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C4)>=0,($Z$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C4)>=0,($AA$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C4)>=0,($AB$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C4)>=0,($AC$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C4)>=0,($AD$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C4)>=0,($AE$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C4)>=0,($AF$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C4)>=0,($AG$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C4)>=0,($AH$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C4)>=0,($AI$1-$E4)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C4)>=0,($AJ$1-$E4)<=0),1,0)","v":0}]
[null,"Changement KIT A : Filtre à huile - Cartouche de séparation - Filtres à air - Panneau filtrant ventilation",{"$f":"IF(ISBLANK($B5),0,VLOOKUP($B5,Tableau1[],7,0))","v":"2019-07-14"},{"$f":"IF(ISBLANK($B5),0,VLOOKUP($B5,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B5),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-14"},{"$f":"IF(AND(($F$1-$C5)>=0,($F$1-$E5)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C5)>=0,($G$1-$E5)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C5)>=0,($H$1-$E5)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C5)>=0,($I$1-$E5)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C5)>=0,($J$1-$E5)<=0),1,0)","v":0},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"date de la cellule F1"]
[null,"Changement Filtres Oléophiles Blanc",{"$f":"IF(ISBLANK($B6),0,VLOOKUP($B6,Tableau1[],7,0))","v":"2020-01-30"},{"$f":"IF(ISBLANK($B6),0,VLOOKUP($B6,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B6),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-01-30"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,"2019-07-09"]
[null,"Changement Filtres Charbon Noir",{"$f":"IF(ISBLANK($B7),0,VLOOKUP($B7,Tableau1[],7,0))","v":"2020-06-25"},{"$f":"IF(ISBLANK($B7),0,VLOOKUP($B7,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B7),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-06-25"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Changement KIT B Soupapes",{"$f":"IF(ISBLANK($B8),0,VLOOKUP($B8,Tableau1[],7,0))","v":"2021-08-06"},{"$f":"IF(ISBLANK($B8),0,VLOOKUP($B8,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B8),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2021-08-06"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["ES2 - Groupe FROID ROBOFORM200","Nettoyage Filtre à air",{"$f":"IF(ISBLANK($B9),0,VLOOKUP($B9,Tableau1[],7,0))","v":"2019-08-06"},{"$f":"IF(ISBLANK($B9),0,VLOOKUP($B9,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B9),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-08-06"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0]
["EC1 - MMT DEA GAMMA 1103","Nettoyer le marbre (acétone)",{"$f":"IF(ISBLANK($B10),0,VLOOKUP($B10,Tableau1[],7,0))","v":"2019-05-07"},{"$f":"IF(ISBLANK($B10),0,VLOOKUP($B10,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B10),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-05-07"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nettoyer et graisser le coulisseau (acétone)",{"$f":"IF(ISBLANK($B11),0,VLOOKUP($B11,Tableau1[],7,0))","v":"2019-11-01"},{"$f":"IF(ISBLANK($B11),0,VLOOKUP($B11,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B11),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-11-01"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["EC2 - Projecteur de profil SAGEM","Nettoyage (à l'aide d'une brosse pour le nettoyage optique)",{"$f":"IF(ISBLANK($B12),0,VLOOKUP($B12,Tableau1[],7,0))","v":"2020-03-30"},{"$f":"IF(ISBLANK($B12),0,VLOOKUP($B12,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B12),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-03-30"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)",{"$f":"IF(ISBLANK($B13),0,VLOOKUP($B13,Tableau1[],7,0))","v":"2019-03-09"},{"$f":"IF(ISBLANK($B13),0,VLOOKUP($B13,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B13),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-03-09"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["D1 - Scie Ruban KASTO","Vérifier et Huiler (coupe) si nécessaire - \nVérifier état de la scie",{"$f":"IF(ISBLANK($B14),0,VLOOKUP($B14,Tableau1[],7,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($B14),0,VLOOKUP($B14,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B14),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Vérifier état courroie + variateur",{"$f":"IF(ISBLANK($B15),0,VLOOKUP($B15,Tableau1[],7,0))","v":"2019-10-02"},{"$f":"IF(ISBLANK($B15),0,VLOOKUP($B15,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B15),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-10-02"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nettoyer Crépine",{"$f":"IF(ISBLANK($B16),0,VLOOKUP($B16,Tableau1[],7,0))","v":"2019-05-08"},{"$f":"IF(ISBLANK($B16),0,VLOOKUP($B16,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B16),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-05-08"},0,0,0,0,{"$f":"IF(AND(($J$1-$C16)>=0,($J$1-$E16)<=0),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Vidange",{"$f":"IF(ISBLANK($B17),0,VLOOKUP($B17,Tableau1[],7,0))","v":"2019-09-05"},{"$f":"IF(ISBLANK($B17),0,VLOOKUP($B17,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B17),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-09-05"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"F1","v":"2019-07-09"},{"$f":"AT17+1","v":"2019-07-10"},"2019-07-11","2019-07-12","2019-07-13","2019-07-14","2019-07-15","2019-07-16",{"$f":"BA17+1","v":"2019-07-17"},"2019-07-18","2019-07-19","2019-07-20","2019-07-21","2019-07-22","2019-07-23","2019-07-24","2019-07-25","2019-07-26","2019-07-27","2019-07-28","2019-07-29","2019-07-30","2019-07-31","2019-08-01","2019-08-02","2019-08-03","2019-08-04","2019-08-05","2019-08-06","2019-08-07","2019-08-08"]
["A1 - Fraiseuse GAMBIN","Nettoyage au poste",{"$f":"IF(ISBLANK($B18),0,VLOOKUP($B18,Tableau1[],7,0))","v":"2019-09-09"},{"$f":"IF(ISBLANK($B18),0,VLOOKUP($B18,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B18),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-09-09"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nettoyage approfondi de la machine",{"$f":"IF(ISBLANK($B19),0,VLOOKUP($B19,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B19),0,VLOOKUP($B19,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B19),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Vérifier le niveau d'huile glissière - \nHuiler les glissières",{"$f":"IF(ISBLANK($B20),0,VLOOKUP($B20,Tableau1[],7,0))","v":"2019-11-03"},{"$f":"IF(ISBLANK($B20),0,VLOOKUP($B20,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B20),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-11-03"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["A2 - Fraiseuse HOLKE","Nettoyage au poste",{"$f":"IF(ISBLANK($B21),0,VLOOKUP($B21,Tableau1[],7,0))","v":"2019-09-09"},{"$f":"IF(ISBLANK($B21),0,VLOOKUP($B21,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B21),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-09-09"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,"N°","Jour","Désignation",null,"N° jour sem",{"$f":"WEEKDAY(AT17)","v":3},4,5,6,7,1,{"$f":"WEEKDAY(AZ17)","v":2},3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5,6,7,1,2,3,4,5]
[null,"Nettoyage approfondi de la machine",{"$f":"IF(ISBLANK($B22),0,VLOOKUP($B22,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B22),0,VLOOKUP($B22,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B22),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,2,"Lundi","L",null,"Désignat' j",{"$f":"VLOOKUP(AT21,$AO$22:$AQ$28,3,0)","v":"M"},{"$f":"VLOOKUP(AU21,$AO$22:$AQ$28,3,0)","v":"M"},{"$f":"VLOOKUP(AV21,$AO$22:$AQ$28,3,0)","v":"J"},{"$f":"VLOOKUP(AW21,$AO$22:$AQ$28,3,0)","v":"V"},"S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J","V","S","D","L","M","M","J"]
[null,"Vérification niveau huile glissière",{"$f":"IF(ISBLANK($B23),0,VLOOKUP($B23,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B23),0,VLOOKUP($B23,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B23),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,3,"Mardi","M"]
["A3 - MICROBILLEUSE","Vider le récipient à poussière",{"$f":"IF(ISBLANK($B24),0,VLOOKUP($B24,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B24),0,VLOOKUP($B24,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B24),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,4,"Mercredi","M"]
[null,"Nettoyer le sac",{"$f":"IF(ISBLANK($B25),0,VLOOKUP($B25,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B25),0,VLOOKUP($B25,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B25),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,5,"Jeudi","J"]
[null,null,{"$f":"IF(ISBLANK($B26),0,VLOOKUP($B26,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B26),0,VLOOKUP($B26,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B26),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,6,"Vendredi","V",null,null,null,"Ne pas supprimer car utiliser dans la determination des jours de la semaine et des week-end"]
[null,null,{"$f":"IF(ISBLANK($B27),0,VLOOKUP($B27,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B27),0,VLOOKUP($B27,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B27),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,7,"Samedi","S"]
[null,null,{"$f":"IF(ISBLANK($B28),0,VLOOKUP($B28,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B28),0,VLOOKUP($B28,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B28),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,1,"Dimanche","D"]
[null,null,{"$f":"IF(ISBLANK($B29),0,VLOOKUP($B29,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B29),0,VLOOKUP($B29,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B29),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B30),0,VLOOKUP($B30,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B30),0,VLOOKUP($B30,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B30),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B31),0,VLOOKUP($B31,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B31),0,VLOOKUP($B31,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B31),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},{"$f":"IF(AND(($F$1-$C31)>=0,($F$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C31)>=0,($G$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C31)>=0,($H$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C31)>=0,($I$1-$E31)<=0),1,0)","v":0},0,{"$f":"IF(AND(($K$1-$C31)>=0,($K$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C31)>=0,($L$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C31)>=0,($M$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C31)>=0,($N$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C31)>=0,($O$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C31)>=0,($P$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($Q$1-$C31)>=0,($Q$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C31)>=0,($R$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C31)>=0,($S$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C31)>=0,($T$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C31)>=0,($U$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C31)>=0,($V$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C31)>=0,($W$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C31)>=0,($X$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C31)>=0,($Y$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C31)>=0,($Z$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C31)>=0,($AA$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C31)>=0,($AB$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C31)>=0,($AC$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C31)>=0,($AD$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C31)>=0,($AE$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C31)>=0,($AF$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C31)>=0,($AG$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C31)>=0,($AH$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C31)>=0,($AI$1-$E31)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C31)>=0,($AJ$1-$E31)<=0),1,0)","v":0}]
[null,null,{"$f":"IF(ISBLANK($B32),0,VLOOKUP($B32,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B32),0,VLOOKUP($B32,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B32),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B33),0,VLOOKUP($B33,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B33),0,VLOOKUP($B33,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B33),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B34),0,VLOOKUP($B34,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B34),0,VLOOKUP($B34,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B34),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B35),0,VLOOKUP($B35,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B35),0,VLOOKUP($B35,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B35),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B36),0,VLOOKUP($B36,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B36),0,VLOOKUP($B36,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B36),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B37),0,VLOOKUP($B37,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B37),0,VLOOKUP($B37,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B37),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B38),0,VLOOKUP($B38,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B38),0,VLOOKUP($B38,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B38),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B39),0,VLOOKUP($B39,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B39),0,VLOOKUP($B39,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B39),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B40),0,VLOOKUP($B40,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B40),0,VLOOKUP($B40,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B40),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B41),0,VLOOKUP($B41,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B41),0,VLOOKUP($B41,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B41),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B42),0,VLOOKUP($B42,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B42),0,VLOOKUP($B42,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B42),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B43),0,VLOOKUP($B43,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B43),0,VLOOKUP($B43,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B43),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B44),0,VLOOKUP($B44,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B44),0,VLOOKUP($B44,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B44),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B45),0,VLOOKUP($B45,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B45),0,VLOOKUP($B45,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B45),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B46),0,VLOOKUP($B46,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B46),0,VLOOKUP($B46,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B46),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B47),0,VLOOKUP($B47,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B47),0,VLOOKUP($B47,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B47),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B48),0,VLOOKUP($B48,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B48),0,VLOOKUP($B48,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B48),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B49),0,VLOOKUP($B49,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B49),0,VLOOKUP($B49,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B49),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B50),0,VLOOKUP($B50,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B50),0,VLOOKUP($B50,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B50),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B51),0,VLOOKUP($B51,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B51),0,VLOOKUP($B51,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B51),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["A4 - SABLEUSE","Vider le pot à poussière",{"$f":"IF(ISBLANK($B52),0,VLOOKUP($B52,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B52),0,VLOOKUP($B52,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B52),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},{"$f":"IF(AND(($F$1-$C52)>=0,($F$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C52)>=0,($G$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C52)>=0,($H$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C52)>=0,($I$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C52)>=0,($J$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C52)>=0,($K$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C52)>=0,($L$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C52)>=0,($M$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C52)>=0,($N$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C52)>=0,($O$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C52)>=0,($P$1-$E52)<=0),1,0)","v":1},{"$f":"IF(AND(($Q$1-$C52)>=0,($Q$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C52)>=0,($R$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C52)>=0,($S$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C52)>=0,($T$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C52)>=0,($U$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C52)>=0,($V$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C52)>=0,($W$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C52)>=0,($X$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C52)>=0,($Y$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C52)>=0,($Z$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C52)>=0,($AA$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C52)>=0,($AB$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C52)>=0,($AC$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C52)>=0,($AD$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C52)>=0,($AE$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C52)>=0,($AF$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C52)>=0,($AG$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C52)>=0,($AH$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C52)>=0,($AI$1-$E52)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C52)>=0,($AJ$1-$E52)<=0),1,0)","v":0}]
[null,"Changer ou nettoyer le filtre",{"$f":"IF(ISBLANK($B53),0,VLOOKUP($B53,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B53),0,VLOOKUP($B53,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B53),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},{"$f":"IF(AND(($F$1-$C53)>=0,($F$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C53)>=0,($G$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C53)>=0,($H$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C53)>=0,($I$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C53)>=0,($J$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C53)>=0,($K$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C53)>=0,($L$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C53)>=0,($M$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C53)>=0,($N$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C53)>=0,($O$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C53)>=0,($P$1-$E53)<=0),1,0)","v":1},{"$f":"IF(AND(($Q$1-$C53)>=0,($Q$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C53)>=0,($R$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C53)>=0,($S$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C53)>=0,($T$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C53)>=0,($U$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C53)>=0,($V$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C53)>=0,($W$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C53)>=0,($X$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C53)>=0,($Y$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C53)>=0,($Z$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C53)>=0,($AA$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C53)>=0,($AB$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C53)>=0,($AC$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C53)>=0,($AD$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C53)>=0,($AE$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C53)>=0,($AF$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C53)>=0,($AG$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C53)>=0,($AH$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C53)>=0,($AI$1-$E53)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C53)>=0,($AJ$1-$E53)<=0),1,0)","v":0}]
["R03 - Rectifieuse CN HAUSER S3","Lubrifier les glissières - \nNiveau huile de coupe +ajustage si nécessaire - \nHuile pneumatique + ajustage si nécessaire",{"$f":"IF(ISBLANK($B54),0,VLOOKUP($B54,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B54),0,VLOOKUP($B54,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B54),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},{"$f":"IF(AND(($F$1-$C54)>=0,($F$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C54)>=0,($G$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C54)>=0,($H$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C54)>=0,($I$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C54)>=0,($J$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C54)>=0,($K$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C54)>=0,($L$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C54)>=0,($M$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C54)>=0,($N$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C54)>=0,($O$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C54)>=0,($P$1-$E54)<=0),1,0)","v":1},{"$f":"IF(AND(($Q$1-$C54)>=0,($Q$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C54)>=0,($R$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C54)>=0,($S$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C54)>=0,($T$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C54)>=0,($U$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C54)>=0,($V$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C54)>=0,($W$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C54)>=0,($X$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C54)>=0,($Y$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C54)>=0,($Z$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C54)>=0,($AA$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C54)>=0,($AB$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C54)>=0,($AC$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C54)>=0,($AD$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C54)>=0,($AE$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C54)>=0,($AF$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C54)>=0,($AG$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C54)>=0,($AH$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C54)>=0,($AI$1-$E54)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C54)>=0,($AJ$1-$E54)<=0),1,0)","v":0}]
[null,"Vidanger le bac à lubrifiant et graisser les axes",{"$f":"IF(ISBLANK($B55),0,VLOOKUP($B55,Tableau1[],7,0))","v":"2019-10-03"},{"$f":"IF(ISBLANK($B55),0,VLOOKUP($B55,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B55),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-10-03"},{"$f":"IF(AND(($F$1-$C55)>=0,($F$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C55)>=0,($G$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C55)>=0,($H$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C55)>=0,($I$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C55)>=0,($J$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C55)>=0,($K$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C55)>=0,($L$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C55)>=0,($M$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C55)>=0,($N$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C55)>=0,($O$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C55)>=0,($P$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($Q$1-$C55)>=0,($Q$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C55)>=0,($R$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C55)>=0,($S$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C55)>=0,($T$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C55)>=0,($U$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C55)>=0,($V$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C55)>=0,($W$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C55)>=0,($X$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C55)>=0,($Y$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C55)>=0,($Z$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C55)>=0,($AA$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C55)>=0,($AB$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C55)>=0,($AC$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C55)>=0,($AD$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C55)>=0,($AE$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C55)>=0,($AF$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C55)>=0,($AG$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C55)>=0,($AH$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C55)>=0,($AI$1-$E55)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C55)>=0,($AJ$1-$E55)<=0),1,0)","v":0}]
["E01 - Érosion CN Enfonçage - ROBOFORM200","Remplacement liquide diélectrique",{"$f":"IF(ISBLANK($B56),0,VLOOKUP($B56,Tableau1[],7,0))","v":"2021-09-01"},{"$f":"IF(ISBLANK($B56),0,VLOOKUP($B56,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B56),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2021-09-01"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND(($AB$1-$C56)>=0,($AB$1-$E56)<=0),1,0)","v":0},0,0,0,0,0,0,0,0]
[null,"Changement des 4 filtres diélectriques",{"$f":"IF(ISBLANK($B57),0,VLOOKUP($B57,Tableau1[],7,0))","v":"2019-12-31"},{"$f":"IF(ISBLANK($B57),0,VLOOKUP($B57,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B57),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-12-31"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IF(ISBLANK($B58),0,VLOOKUP($B58,Tableau1[],7,0))","v":"2020-02-03"},{"$f":"IF(ISBLANK($B58),0,VLOOKUP($B58,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B58),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-02-03"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Soufflage Filtre groupe froid",{"$f":"IF(ISBLANK($B59),0,VLOOKUP($B59,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B59),0,VLOOKUP($B59,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B59),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E02 - Érosion CN Enfonçage - EDM FORM20","Remplacement liquide diélectrique",{"$f":"IF(ISBLANK($B60),0,VLOOKUP($B60,Tableau1[],7,0))","v":"2021-09-01"},{"$f":"IF(ISBLANK($B60),0,VLOOKUP($B60,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B60),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2021-09-01"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Changement des 2 filtres diélectriques",{"$f":"IF(ISBLANK($B61),0,VLOOKUP($B61,Tableau1[],7,0))","v":"2019-12-31"},{"$f":"IF(ISBLANK($B61),0,VLOOKUP($B61,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B61),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-12-31"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IF(ISBLANK($B62),0,VLOOKUP($B62,Tableau1[],7,0))","v":"2020-02-03"},{"$f":"IF(ISBLANK($B62),0,VLOOKUP($B62,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B62),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-02-03"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Soufflage filtre groupe froid",{"$f":"IF(ISBLANK($B63),0,VLOOKUP($B63,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B63),0,VLOOKUP($B63,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B63),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E03 - Érosion CN Découpe Fil ROBOFIL2020","Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IF(ISBLANK($B64),0,VLOOKUP($B64,Tableau1[],7,0))","v":"2020-02-03"},{"$f":"IF(ISBLANK($B64),0,VLOOKUP($B64,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B64),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2020-02-03"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Changement des 16 filtres eau ",{"$f":"IF(ISBLANK($B65),0,VLOOKUP($B65,Tableau1[],7,0))","v":"2019-12-31"},{"$f":"IF(ISBLANK($B65),0,VLOOKUP($B65,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B65),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-12-31"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Filtre résidu",{"$f":"IF(ISBLANK($B66),0,VLOOKUP($B66,Tableau1[],7,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($B66),0,VLOOKUP($B66,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B66),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Soufflage filtre armoire",{"$f":"IF(ISBLANK($B67),0,VLOOKUP($B67,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B67),0,VLOOKUP($B67,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B67),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E04 - Érosion CN Découpe Fil CUT300","Niveau Graisse glissière + vidange de récipient de récupération",{"$f":"IF(ISBLANK($B68),0,VLOOKUP($B68,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B68),0,VLOOKUP($B68,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B68),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Changement des filtres eau",{"$f":"IF(ISBLANK($B69),0,VLOOKUP($B69,Tableau1[],7,0))","v":"2019-12-31"},{"$f":"IF(ISBLANK($B69),0,VLOOKUP($B69,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B69),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-12-31"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Filtre résidu",{"$f":"IF(ISBLANK($B70),0,VLOOKUP($B70,Tableau1[],7,0))","v":{"$error":"#VALUE!"}},{"$f":"IF(ISBLANK($B70),0,VLOOKUP($B70,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B70),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Soufflage filtre Armoire",{"$f":"IF(ISBLANK($B71),0,VLOOKUP($B71,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B71),0,VLOOKUP($B71,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B71),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["E05 - Perçage Microforage CCR Technologie CR200","Soufflage filtre armoire",{"$f":"IF(ISBLANK($B72),0,VLOOKUP($B72,Tableau1[],7,0))","v":"2019-07-19"},{"$f":"IF(ISBLANK($B72),0,VLOOKUP($B72,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B72),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-07-19"},0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Nettoyer pour enlever les résidus",{"$f":"IF(ISBLANK($B73),0,VLOOKUP($B73,Tableau1[],7,0))","v":"2019-10-02"},{"$f":"IF(ISBLANK($B73),0,VLOOKUP($B73,Tableau1[],8,0))","v":1},{"$f":"IF(ISBLANK($B73),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"2019-10-02"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["F01 - Centre d'usinage 3 axes VICTOR",null,{"$f":"IF(ISBLANK($B74),0,VLOOKUP($B74,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B74),0,VLOOKUP($B74,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B74),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B75),0,VLOOKUP($B75,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B75),0,VLOOKUP($B75,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B75),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B76),0,VLOOKUP($B76,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B76),0,VLOOKUP($B76,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B76),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B77),0,VLOOKUP($B77,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B77),0,VLOOKUP($B77,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B77),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B78),0,VLOOKUP($B78,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B78),0,VLOOKUP($B78,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B78),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B79),0,VLOOKUP($B79,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B79),0,VLOOKUP($B79,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B79),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B80),0,VLOOKUP($B80,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B80),0,VLOOKUP($B80,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B80),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B81),0,VLOOKUP($B81,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B81),0,VLOOKUP($B81,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B81),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B82),0,VLOOKUP($B82,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B82),0,VLOOKUP($B82,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B82),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B83),0,VLOOKUP($B83,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B83),0,VLOOKUP($B83,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B83),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B84),0,VLOOKUP($B84,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B84),0,VLOOKUP($B84,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B84),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B85),0,VLOOKUP($B85,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B85),0,VLOOKUP($B85,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B85),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B86),0,VLOOKUP($B86,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B86),0,VLOOKUP($B86,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B86),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B87),0,VLOOKUP($B87,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B87),0,VLOOKUP($B87,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B87),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},{"$f":"IF(AND(($F$1-$C87)>=0,($F$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C87)>=0,($G$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C87)>=0,($H$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C87)>=0,($I$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C87)>=0,($J$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C87)>=0,($K$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C87)>=0,($L$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C87)>=0,($M$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C87)>=0,($N$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C87)>=0,($O$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C87)>=0,($P$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($Q$1-$C87)>=0,($Q$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C87)>=0,($R$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C87)>=0,($S$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C87)>=0,($T$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C87)>=0,($U$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C87)>=0,($V$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C87)>=0,($W$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C87)>=0,($X$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C87)>=0,($Y$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C87)>=0,($Z$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C87)>=0,($AA$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C87)>=0,($AB$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C87)>=0,($AC$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C87)>=0,($AD$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C87)>=0,($AE$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C87)>=0,($AF$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C87)>=0,($AG$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C87)>=0,($AH$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C87)>=0,($AI$1-$E87)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C87)>=0,($AJ$1-$E87)<=0),1,0)","v":0}]
[null,null,{"$f":"IF(ISBLANK($B88),0,VLOOKUP($B88,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B88),0,VLOOKUP($B88,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B88),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B89),0,VLOOKUP($B89,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B89),0,VLOOKUP($B89,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B89),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B90),0,VLOOKUP($B90,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B90),0,VLOOKUP($B90,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B90),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B91),0,VLOOKUP($B91,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B91),0,VLOOKUP($B91,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B91),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B92),0,VLOOKUP($B92,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B92),0,VLOOKUP($B92,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B92),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B93),0,VLOOKUP($B93,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B93),0,VLOOKUP($B93,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B93),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B94),0,VLOOKUP($B94,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B94),0,VLOOKUP($B94,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B94),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B95),0,VLOOKUP($B95,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B95),0,VLOOKUP($B95,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B95),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B96),0,VLOOKUP($B96,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B96),0,VLOOKUP($B96,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B96),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B97),0,VLOOKUP($B97,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B97),0,VLOOKUP($B97,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B97),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B98),0,VLOOKUP($B98,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B98),0,VLOOKUP($B98,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B98),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B99),0,VLOOKUP($B99,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B99),0,VLOOKUP($B99,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B99),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B100),0,VLOOKUP($B100,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B100),0,VLOOKUP($B100,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B100),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B101),0,VLOOKUP($B101,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B101),0,VLOOKUP($B101,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B101),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B102),0,VLOOKUP($B102,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B102),0,VLOOKUP($B102,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B102),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B103),0,VLOOKUP($B103,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B103),0,VLOOKUP($B103,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B103),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B104),0,VLOOKUP($B104,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B104),0,VLOOKUP($B104,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B104),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B105),0,VLOOKUP($B105,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B105),0,VLOOKUP($B105,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B105),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B106),0,VLOOKUP($B106,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B106),0,VLOOKUP($B106,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B106),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B107),0,VLOOKUP($B107,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B107),0,VLOOKUP($B107,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B107),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B108),0,VLOOKUP($B108,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B108),0,VLOOKUP($B108,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B108),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B109),0,VLOOKUP($B109,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B109),0,VLOOKUP($B109,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B109),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B110),0,VLOOKUP($B110,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B110),0,VLOOKUP($B110,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B110),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B111),0,VLOOKUP($B111,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B111),0,VLOOKUP($B111,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B111),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B112),0,VLOOKUP($B112,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B112),0,VLOOKUP($B112,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B112),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B113),0,VLOOKUP($B113,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B113),0,VLOOKUP($B113,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B113),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B114),0,VLOOKUP($B114,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B114),0,VLOOKUP($B114,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B114),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B115),0,VLOOKUP($B115,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B115),0,VLOOKUP($B115,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B115),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B116),0,VLOOKUP($B116,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B116),0,VLOOKUP($B116,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B116),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B117),0,VLOOKUP($B117,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B117),0,VLOOKUP($B117,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B117),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(ISBLANK($B118),0,VLOOKUP($B118,Tableau1[],7,0))","v":"00:00:00"},{"$f":"IF(ISBLANK($B118),0,VLOOKUP($B118,Tableau1[],8,0))","v":0},{"$f":"IF(ISBLANK($B118),0,(Tableau9[[#This Row],[Colonne2]]-1)+Tableau9[[#This Row],[Colonne3]])","v":"00:00:00"},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(AND(($F$1-$C119)>=0,($F$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($G$1-$C119)>=0,($G$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($H$1-$C119)>=0,($H$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($I$1-$C119)>=0,($I$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($J$1-$C119)>=0,($J$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($K$1-$C119)>=0,($K$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($L$1-$C119)>=0,($L$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($M$1-$C119)>=0,($M$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($N$1-$C119)>=0,($N$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($O$1-$C119)>=0,($O$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($P$1-$C119)>=0,($P$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($Q$1-$C119)>=0,($Q$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($R$1-$C119)>=0,($R$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($S$1-$C119)>=0,($S$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($T$1-$C119)>=0,($T$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($U$1-$C119)>=0,($U$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($V$1-$C119)>=0,($V$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($W$1-$C119)>=0,($W$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($X$1-$C119)>=0,($X$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($Y$1-$C119)>=0,($Y$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($Z$1-$C119)>=0,($Z$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AA$1-$C119)>=0,($AA$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AB$1-$C119)>=0,($AB$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AC$1-$C119)>=0,($AC$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AD$1-$C119)>=0,($AD$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AE$1-$C119)>=0,($AE$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AF$1-$C119)>=0,($AF$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AG$1-$C119)>=0,($AG$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AH$1-$C119)>=0,($AH$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AI$1-$C119)>=0,($AI$1-$E119)<=0),1,0)","v":0},{"$f":"IF(AND(($AJ$1-$C119)>=0,($AJ$1-$E119)<=0),1,0)","v":0}]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Planification du préventif","index":10,"n_rows":102,"n_cols":28,"rows_kept":102,"cut":false,"hidden":true,"merged":[[1,6,1,7],[1,9,1,11],[1,20,1,24],[1,15,1,19]]}
[]
[null,null,null,null,null,null,"Date intervention",null,"Tps inter","Périodicité",null,null,null,null,null,"test information issue de la list",null,null,null,null,"Calcul du Nbr de Jours",null,null,null,null,"Som Nbr Jrs","Test H=\"\" et I<>\"\"","Nbr Pen Jrs"]
["N° Équipement","Opérations de maintenance","Descriptif","Materiels","Fiche procédure","Sécurité","Anterieure","Prochaine","Tps inter","P","Unité","en jrs","ETAT",null,null,"Jours","Semaine","Mois","Année","Années","Jours","Semaine","Mois","Année","Années","Somme 1","Test","P en jours"]
["ES1 - Compresseur GENESIS","Vidange Huile 3 - 4 L",null,null,null,null,"2019-07-09",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-10-07"},1,3,"Mois",{"$f":"AB4","v":90},{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 90 jours"},null,null,{"$f":"IF($K4=\"Jours\",1,0)","v":0},{"$f":"IF($K4=\"Semaine\",1,0)","v":0},{"$f":"IF($K4=\"Mois\",1,0)","v":1},{"$f":"IF($K4=\"Année\",1,0)","v":0},{"$f":"IF($K4=\"Années\",1,0)","v":0},{"$f":"IF($P4=1,$J4*1,0)","v":0},{"$f":"IF($Q4=1,$J4*7,0)","v":0},{"$f":"IF($R4=1,$J4*30,0)","v":90},{"$f":"IF($S4=1,$J4*365,0)","v":0},{"$f":"IF($T4=1,$J4*365,0)","v":0},{"$f":"IF(AND($J4>1,$K4=\"Année\"),\"Erreur de saisie\",ROUND(SUM($U4:$Y4),0))","v":90},{"$f":"IF(AND($K4>0,$J4=\"\"),0,1)","v":1},{"$f":"IF(AND($Z4=0,$AA4=0),\"Erreur de saisie\", $Z4)","v":90}]
[null,"Changement KIT A : Filtre à huile - Cartouche de séparation - Filtres à air - Panneau filtrant ventilation",null,null,null,null,"2019-07-08",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-14"},1,6,"Jours",{"$f":"AB5","v":6},{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 5 jours"},null,null,{"$f":"IF($K5=\"Jours\",1,0)","v":1},{"$f":"IF($K5=\"Semaine\",1,0)","v":0},{"$f":"IF($K5=\"Mois\",1,0)","v":0},{"$f":"IF($K5=\"Année\",1,0)","v":0},{"$f":"IF($K5=\"Années\",1,0)","v":0},6,{"$f":"IF($Q5=1,$J5*7,0)","v":0},{"$f":"IF($R5=1,$J5*30,0)","v":0},{"$f":"IF($S5=1,$J5*365,0)","v":0},{"$f":"IF($T5=1,$J5*365,0)","v":0},6,{"$f":"IF(AND($K5>0,$J5=\"\"),0,1)","v":1},{"$f":"IF(AND($Z5=0,$AA5=0),\"Erreur de saisie\", $Z5)","v":6}]
[null,"Changement Filtres Oléophiles Blanc",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2020-01-30"},1,5,"Mois",150,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 205 jours"},null,null,0,0,1,0,0,0,0,150,0,0,150,1,150]
[null,"Changement Filtres Charbon Noir",null,null,null,null,"26/06/2019",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2020-06-25"},1,1,"Année",365,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 352 jours"},null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
[null,"Changement KIT B Soupapes",null,null,null,null,"2019-08-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2021-08-06"},1,2,"Années",730,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 759 jours"},null,null,0,0,0,0,1,0,0,0,0,730,730,1,730]
["ES2 - Groupe FROID ROBOFORM200","Nettoyage Filtre à air",null,null,null,null,"2019-02-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-08-06"},1,6,"Mois",180,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 28 jours"},null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["EC1 - MMT DEA GAMMA 1103","Nettoyer le marbre (acétone)",null,null,null,null,"2019-04-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-05-07"},1,1,"Mois",30,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"En retard de 63 jours"},null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
[null,"Nettoyer et graisser le coulisseau (acétone)",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-11-01"},1,2,"Mois",60,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 115 jours"},null,null,0,0,1,0,0,0,0,60,0,0,60,1,60]
["EC2 - Projecteur de profil SAGEM","Nettoyage (à l'aide d'une brosse pour le nettoyage optique)",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2020-03-30"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 265 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)",null,null,null,null,"2019-02-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-03-09"},1,1,"Mois",30,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"En retard de 122 jours"},null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["D1 - Scie Ruban KASTO","Vérifier et Huiler (coupe) si nécessaire - \nVérifier état de la scie",null,null,null,"Voir Technicien","X",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":{"$error":"#VALUE!"}},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Vérifier état courroie + variateur",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-10-02"},1,1,"Mois",30,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 85 jours"},null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
[null,"Nettoyer Crépine",null,null,null,null,"2019-02-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-05-08"},1,3,"Mois",90,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"En retard de 62 jours"},null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
[null,"Vidange",null,null,null,null,"2019-02-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-09-05"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 58 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["A1 - Fraiseuse GAMBIN","Nettoyage au poste",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-09-09"},1,1,"Semaine",7,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 62 jours"},null,null,0,1,0,0,0,0,7,0,0,0,7,1,7]
[null,"Nettoyage approfondi de la machine",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Vérifier le niveau d'huile glissière - \nHuiler les glissières",null,null,null,null,"2019-04-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-11-03"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 117 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["A2 - Fraiseuse HOLKE","Nettoyage au poste",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-09-09"},1,1,"Semaine",7,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 62 jours"},null,null,0,1,0,0,0,0,7,0,0,0,7,1,7]
[null,"Nettoyage approfondi de la machine",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Vérification niveau huile glissière",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["A3 - MICROBILLEUSE","Vider le récipient à poussière",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Nettoyer le sac",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["A4 - SABLEUSE","Vider le pot à poussière",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,{"$f":"IF($Q26=1,$J26*1,0)","v":0},0,210,0,0,210,1,210]
[null,"Changer ou nettoyer le filtre",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["R03 - Rectifieuse CN HAUSER S3","Lubrifier les glissières - \nNiveau huile de coupe +ajustage si nécessaire - \nHuile pneumatique + ajustage si nécessaire",null,null,null,null,"2019-04-20",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,3,"Mois",90,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
[null,"Vidanger le bac à lubrifiant et graisser les axes",null,null,null,null,"2019-03-07",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-10-03"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 86 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["E01 - Érosion CN Enfonçage - ROBOFORM200","Remplacement liquide diélectrique",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2021-09-01"},1,2,"Années",730,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 785 jours"},null,null,0,0,0,0,1,0,0,0,0,730,730,1,730]
[null,"Changement des 4 filtres diélectriques",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-31"},1,4,"Mois",120,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 175 jours"},null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
[null,"Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2019-07-08",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2020-02-03"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 209 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Soufflage Filtre groupe froid",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["E02 - Érosion CN Enfonçage - EDM FORM20","Remplacement liquide diélectrique",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2021-09-01"},1,2,"Années",730,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 785 jours"},null,null,0,0,0,0,1,0,0,0,0,730,730,1,730]
[null,"Changement des 2 filtres diélectriques",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-31"},1,4,"Mois",120,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 175 jours"},null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
[null,"Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Soufflage filtre groupe froid",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["E03 - Érosion CN Découpe Fil ROBOFIL2020","Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Changement des 16 filtres eau ",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-31"},1,4,"Mois",120,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 175 jours"},null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
[null,"Filtre résidu",null,null,null,"Voir technicien","X",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":{"$error":"#VALUE!"}},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Soufflage filtre armoire",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["E04 - Érosion CN Découpe Fil CUT300","Niveau Graisse glissière + vidange de récipient de récupération",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Changement des filtres eau",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-31"},1,4,"Mois",120,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 175 jours"},null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
[null,"Filtre résidu",null,null,null,"Voir technicien","X",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":{"$error":"#VALUE!"}},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Soufflage filtre Armoire",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["E05 - Perçage Microforage CCR Technologie CR200","Soufflage filtre armoire",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Nettoyer pour enlever les résidus",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-10-02"},1,1,"Mois",30,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 85 jours"},null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["F01 - Centre d'usinage 3 axes VICTOR","Nettoyage de la machine. Soufflées avec delair sec sous pression",null,null,null,null,"2019-07-09",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2020-02-04"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 210 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Soufflage filtre",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Lubrifier les axes et la broche",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-09-14"},1,1.5,"Semaine",12,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 67 jours"},null,null,0,1,0,0,0,1.5,10.5,0,0,0,12,1,12]
[null,"Lubrification glissière",null,null,null,null,"2019-04-20",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,3,"Mois",90,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
[null,"Nettoyage approfondi de la machine + soufflage\nVidange de l'huile de coupe",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,{"$f":"IF($Q52=1,$J52*1,0)","v":0},{"$f":"IF($Q52=1,$J52*7,0)","v":0},{"$f":"IF($R52=1,$J52*30,0)","v":210},{"$f":"IF($S52=1,$J52*365,0)","v":0},{"$f":"IF($T52=1,$J52*365,0)","v":0},{"$f":"IF(AND($J52>1,$K52=\"Année\"),\"Erreur de saisie\",ROUND(SUM($U52:$Y52),0))","v":210},{"$f":"IF(AND($K52>0,$J52=\"\"),0,1)","v":1},210]
["F02 - Centre d'usinage 3 axes FEELER","Nettoyage de la machine. Soufflées avec delair sec sous pression",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,{"$f":"IF($Q53=1,$J53*1,0)","v":0},{"$f":"IF($Q53=1,$J53*7,0)","v":0},{"$f":"IF($R53=1,$J53*30,0)","v":210},{"$f":"IF($S53=1,$J53*365,0)","v":0},{"$f":"IF($T53=1,$J53*365,0)","v":0},{"$f":"IF(AND($J53>1,$K53=\"Année\"),\"Erreur de saisie\",ROUND(SUM($U53:$Y53),0))","v":210},{"$f":"IF(AND($K53>0,$J53=\"\"),0,1)","v":1},210]
[null,"Soufflage filtre",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Lubrifier les axes et la broche",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-09-14"},1,1.5,"Semaine",12,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 67 jours"},null,null,0,1,0,0,0,1.5,10.5,0,0,0,12,1,12]
[null,"Lubrification glissière",null,null,null,null,"2019-04-20",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,3,"Mois",90,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
[null,"Nettoyage approfondi de la machine + soufflage\nVidange de l'huile de coupe",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
["F03 - Fraiseuse 5 axes FPT TESSEN","Nettoyer en profondeur l'espace de travail. Examiner l'état du lubrifiant\nSouffler filtre à air\nContrôler et ajouter si nécessaire de la graisse blanche pour les broches",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-10-02"},1,1,"Mois",30,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 85 jours"},null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
[null,"Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile hydraulique\nNettoyage général de la machine",null,null,null,null,"2019-09-02",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-01"},1,3,"Mois",90,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 145 jours"},null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
[null,"Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe\nContrôler et ajouter si nécessaire de la graisse pour les glissières",null,null,null,null,"2018-12-21",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-07-19"},1,7,"Mois",210,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 10 jours"},null,null,0,0,1,0,0,0,0,210,0,0,210,1,210]
[null,"Changement rouleau préfiltre\nChangement fitre résidus 1\nChangement filtre résidus 2",null,null,null,"Voir technicien","26/06/2019",{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":"2019-12-23"},1,6,"Mois",180,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":"À faire dans 167 jours"},null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F04 -  Fraiseuse 5 axes HEDELIUS BC100","Nettoyage du double filtre, remplacement si nécessaire",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajouter le niveau de lubrification glissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Changement rouleau préfiltre",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["F05 - Fraiseuse 5 axes HEDELIUS TILENTA 7","Vérification visuel + Nettoyage du double filtre, remplacement si nécessaire",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(AND($J68>1,$K68=\"Année\"),\"Erreur de saisie\",ROUND(SUM($U68:$Y68),0))","v":0},1,0]
[null,"Nettoyage général du convoyeur à copeaux et du réservoir de lubrifiant \nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajuster le niveau de lubrification pour les glissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,{"$f":"AB69","v":0},{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF($K69=\"Jours\",1,0)","v":0},{"$f":"IF($K69=\"Semaine\",1,0)","v":0},{"$f":"IF($K69=\"Mois\",1,0)","v":0},{"$f":"IF($K69=\"Année\",1,0)","v":0},{"$f":"IF($K69=\"Années\",1,0)","v":0},0,{"$f":"IF($Q69=1,$J69*7,0)","v":0},{"$f":"IF($R69=1,$J69*30,0)","v":0},{"$f":"IF($S69=1,$J69*365,0)","v":0},{"$f":"IF($T69=1,$J69*365,0)","v":0},0,{"$f":"IF(AND($K69>0,$J69=\"\"),0,1)","v":1},{"$f":"IF(AND($Z69=0,$AA69=0),\"Erreur de saisie\", $Z69)","v":0}]
[null,"Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["F06 - Fraiseuse 3 axes - KIHEUNG","Nettoyer en profondeur l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air. \nContrôler et ajouter si nécessaire de la graisse blanche pour les broches ",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage général du convoyeur à copeaux et du réservoir de lubrifiant.\nContrôler et ajuster le niveau d'huile hydraulique.\nContrôler et ajuster le niveau de lubrification pour les glissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T01 - Tour Conv HERNAULT","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approdondi. Contrôler l'usure de tous les engrenages et de toutes les garnitures. Stabilité du corps de la machine (Serrer les boulons d'ancrage du corps de la machine au sol et stabiliser le corps de la machine)",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T02 - Tour Conv MÉTAFLEX","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approdondi. Contrôler l'usure de tous les engrenages et de toutes les garnitures. Stabilité du corps de la machine (Serrer les boulons d'ancrage du corps de la machine au sol et stabiliser le corps de la machine)",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T03 - Tour MICROCUT omnitechnique","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nVidanger l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T04 - Tour 3 et 4 axes CMZ TL20M","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nNettoyage réservoir de l'huile hydraulique + remplacement de l'huile hydraulique du réservoir\nVidanger l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T05 - Tour 3et 4 axes CMZ TA30Y","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nNettoyage réservoir de l'huile hydraulique + remplacement de l'huile hydraulique du réservoir\nVidanger l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T06 - STARMECA","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nVidange de l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,0,0,0,0,0,0,1,0]
["T07 - CAZENEUVE","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,{"$f":"IF($Q90=1,$J90*1,0)","v":0},0,0,0,0,0,1,0]
[null,"Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,{"$f":"IF($Q91=1,$J91*1,0)","v":0},0,0,0,0,0,1,0]
[null,"Nettoyage approfondi\nVidange de l'huile de coupe",null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,0,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}},null,null,0,0,0,0,0,{"$f":"IF($Q92=1,$J92*1,0)","v":0},0,0,0,0,0,1,0]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]])","v":""},1,null,null,null,{"$f":"_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochaine]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochaine]])&\" jours\",Tableau1[[#This Row],[Prochaine]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochaine]]-TODAY()&\" jours\")","v":{"$error":"#VALUE!"}}]

{"sheet":"Histo maintenances Préventif","index":11,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":true,"merged":[[6,11,6,16]]}
[]
[null,null,"Equipement","Maintenance","Date","État"]
[null,null,"D1 - Scie Ruban KASTO","Nettoyer Crépine","2019-01-07","Effectuée En avance de 153 jours"]
[null,null,"ES2 - Groupe FROID ROBOFORM200","Nettoyage Filtre à air","2019-02-07","Effectuée En avance de 4 jours"]
[null,null,"EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)","2019-02-07","Effectuée En avance de 24 jours"]
[null,null,"EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)","2019-02-07","Effectuée En retard de 115 jours"]
[null,null,"D1 - Scie Ruban KASTO","Nettoyer Crépine","2019-02-07","Effectuée En retard de 86 jours",null,null,null,null,null,"Ne pas oublier de modifier la \"date antérieure\" dans planification du préventif"]
[null,null,"EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)","2019-02-07","Effectuée En retard de 115 jours"]
[null,null,"D1 - Scie Ruban KASTO","Vidange","2019-02-07","Effectuée En avance de 34 jours"]
[null,null,"EC3 - Colonne de mesure TRIMOS","Nettoyage du marbre (acétone)","2019-02-07","Effectuée En retard de 115 jours"]
[null,null,"RO3_Rectification_CN","Vidanger le bac à lubrifiant et graisser les axes","2019-03-07","Effectuée En avance de 16 jours"]
[null,null,"A1_Fraiseuse_GAMBIN","Vérifier le niveau d'huile glissière - \nHuiler les glissières","2019-04-07","Effectuée En avance de 15 jours"]
[null,null,"EC1_MMT_DEA_GAMMA_1103","Nettoyer le marbre (acétone)","2019-04-07","Effectuée En retard de 148 jours"]
[null,null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","2019-08-07","Effectuée En retard de 92 jours"]
[null,null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","2019-08-07","Effectuée En avance de 120 jours"]
[null,null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","2019-08-07","Effectuée En avance de 120 jours"]
[null,null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","2019-08-07","Effectuée En avance de 120 jours"]
[null,null,"ES1_Compresseur_GENESIS","Changement KIT A : Filtre à huile - Cartouche de séparation - Filtres à air - Panneau filtrant ventilation","2019-08-07","Effectuée En avance de 89 jours"]
[null,null,"E01_Érosion_CN_Enfonçage_ROBOFORM200","Niveau d'huile pour glissière + vidange récipient de récupération","2019-08-07","Effectuée En avance de 11 jours"]
[null,null,"ES1_Compresseur_GENESIS","Changement KIT B Soupapes","2019-08-07","Effectuée En avance de 786 jours"]
[null,null,"F01_Centre_usinage_3_axes_VICTOR","Nettoyage de la machine. Soufflées avec delair sec sous pression","2019-09-07","Effectuée En avance de 10 jours"]
[null,null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","2019-09-07","Effectuée En avance de 89 jours"]

{"sheet":"Historique maintenances Curatif","index":12,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[[5,10,7,12]]}
[]
[]
[null,"Pôle","Équipement","Problème","Tâches Planifiées","Date de maintenance","Niveau de maintenance","Utilisateur assigné"]
[null,null,"EC2 - Projecteur de profil SAGEM","Fuite huile","Changement joint","2019-01-07",null,"Yannis"]
[null,null,"EC3 - Colonne de mesure TRIMOS","Courroie","Changement courroie","2019-08-08",1,"Olivier"]
[null,null,"D1 - Scie Ruban KASTO","Moteur cassé","Remplacement moteur","2019-09-08",2,"Olivier",null,null,"Curatif"]
[null,null,"EC2 - Projecteur de profil SAGEM","Fuite lubrification","Appel sous-traitant","2019-01-09",3,"Yoann.G"]
[null,null,"Débit","D1_Scie_Ruban_KASTO","Moteur cassé","Changement moteur","14/08/2019",3]
[null,null,"Tournage","T03_Tour_MICROCUT_omnitechnique","Fixation cassé","Changement fixation","2019-04-10",3]
[null,"Tournage","T07_CAZENEUVE","A","B","1900-03-01",1,"Samuel"]
[null,"Érosion","D1_Scie_Ruban_KASTO","Joint de culasse","Réparation ","2019-09-07",2,"Benoit.C"]
[null,"Équipement_de_support","ES1_Compresseur_GENESIS","A","B","31/12/1899",2,"Romain"]
[null,"Débit","D1_Scie_Ruban_KASTO","Moteur Cassé","Changement moteur","2019-12-07",3,"Sous-traitant"]

{"sheet":"Ressources","index":13,"n_rows":81,"n_cols":40,"rows_kept":81,"cut":false,"hidden":true,"merged":[[0,0,3,3]]}
["/!\\ NE PAS SUPPRIMER OU MODIFIER L'EXISTANT",null,null,null,"☺  JUSTE RAJOUTER DES INFORMATIONS "]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Benoit.C","Benoit.C","Benoit.M","Benoit.M","Benoit.M","Romain"]
["Pôle","Fraisage","Tournage","Érosion","Rectification","Ajustage","Débit","Équipement_de_support","Équipement_de_contrôle",null,"Équipement","ES1_Compresseur_GENESIS","ES2_Groupe_FROID_ROBOFORM200","EC1_MMT_DEA_GAMMA_1103","EC2_Projecteur_de_profil_SAGEM","EC3_Colonne_de_mesure_TRIMOS","D1_Scie_Ruban_KASTO","A1_Fraiseuse_GAMBIN","A2_Fraiseuse_HOLKE","A3_MICROBILLEUSE","A4_SABLEUSE","RO3_Rectification_CN","E01_Érosion_CN_Enfonçage_ROBOFORM200","E02_Érosion_CN_Enfonçage_EDM_FORM20","E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","E04_Érosion_CN_Découpe_Fil_CUT300","E05_Perçage_Microforage_CCR_Technologie_CR200","F01_Centre_usinage_3_axes_VICTOR","F02_Centre_usinage_3_axes_FEELER","F03_Fraiseuse_5_axes_FPT_TESSEN","F04_Fraiseuse_5_axes_HEDELIUS_BC100","F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","F06_Fraiseuse_3_axes_KIHEUNG","T01_Tour_Conv_HERNAULT","T02_Tour_Conv_MÉTAFLEX","T03_Tour_MICROCUT_omnitechnique","T04_Tour_3_et_4_axes_CMZ_TL20M","T05_Tour_3_et_4_axes_CMZ_TA30Y","T06_STARMECA","T07_CAZENEUVE"]
["Fraisage","F01_Centre_usinage_3_axes_VICTOR","T01_Tour_Conv_HERNAULT","E01_Érosion_CN_Enfonçage_ROBOFORM200","RO3_Rectification_CN","A1_Fraiseuse_GAMBIN","D1_Scie_Ruban_KASTO","ES1_Compresseur_GENESIS","EC1_MMT_DEA_GAMMA_1103",null,"ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L","Nettoyage Filtre à air","Nettoyer le marbre (acétone)","Nettoyage (à l'aide d'une brosse pour le nettoyage optique)","Nettoyage du marbre (acétone)","Vérifier et Huiler (coupe) si nécessaire - \nVérifier état de la scie","Nettoyage au poste","Nettoyage au poste","Vider le récipient à poussière","Vider le pot à poussière","Lubrifier les glissières - Niveau huile de coupe +ajustage si nécessaire - Huile pneumatique + ajustage si nécessaire","Remplacement liquide diélectrique","Remplacement liquide diélectrique","Niveau d'huile pour glissière + vidange récipient de récupération","Niveau Graisse glissière + vidange de récipient de récupération","Soufflage filtre armoire","Nettoyage de la machine. Soufflées avec delair sec sous pression","Nettoyage de la machine. Soufflées avec delair sec sous pression","Nettoyer en profondeur l'espace de travail. Examiner l'état du lubrifiant\nSouffler filtre à air\nContrôler et ajouter si nécessaire de la graisse blanche pour les broches","Nettoyage du double filtre, remplacement si nécessaire","Vérification visuel + Nettoyage du double filtre, remplacement si nécessaire","Nettoyer en profondeur l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air. \nContrôler et ajouter si nécessaire de la graisse blanche pour les broches ","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles","Inspection et si besoin remplissage de l'huile glissière","Inspection et si besoin remplissage de l'huile glissière","Inspection et si besoin remplissage de l'huile glissière","Inspection et si besoin remplissage de l'huile glissière","Inspection et si besoin remplissage de l'huile glissière"]
["Tournage","F02_Centre_usinage_3_axes_FEELER","T02_Tour_Conv_MÉTAFLEX","E02_Érosion_CN_Enfonçage_EDM_FORM20",null,"A2_Fraiseuse_HOLKE",null,"ES2_Groupe_FROID_ROBOFORM200","EC2_Projecteur_de_profil_SAGEM",null,"ES2_Groupe_FROID_ROBOFORM200","Changement KIT A : Filtre à huile - Cartouche de séparation - Filtres à air - Panneau filtrant ventilation",null,"Nettoyer et graisser le coulisseau (acétone)",null,null,"Vérifier état courroie + variateur","Nettoyage approfondi de la machine","Nettoyage approfondi de la machine","Nettoyer le sac","Changer ou nettoyer le filtre","Vidanger le bac à lubrifiant et graisser les axes","Changement des 4 filtres diélectriques","Changement des 2 filtres diélectriques","Changement des 16 filtres eau ","Changement des filtres eau","Nettoyer pour enlever les résidus","Soufflage filtre","Soufflage filtre","Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile hydraulique\nNettoyage général de la machine","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air","Nettoyage général du convoyeur à copeaux et du réservoir de lubrifiant.\nContrôler et ajuster le niveau d'huile hydraulique.\nContrôler et ajuster le niveau de lubrification pour les glissières","Nettoyage approdondi. Contrôler l'usure de tous les engrenages et de toutes les garnitures. Stabilité du corps de la machine (Serrer les boulons d'ancrage du corps de la machine au sol et stabiliser le corps de la machine)","Nettoyage approdondi. Contrôler l'usure de tous les engrenages et de toutes les garnitures. Stabilité du corps de la machine (Serrer les boulons d'ancrage du corps de la machine au sol et stabiliser le corps de la machine)","Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières"]
["Érosion","F03_Fraiseuse_5_axes_FPT_TESSEN","T03_Tour_MICROCUT_omnitechnique","E03_Érosion_CN_Découpe_Fil_ROBOFIL2020",null,"A3_MICROBILLEUSE",null,null,"EC3_Colonne_de_mesure_TRIMOS",null,"EC1_MMT_DEA_GAMMA_1103","Changement Filtres Oléophiles Blanc",null,null,null,null,"Nettoyer Crépine","Vérifier le niveau d'huile glissière - \nHuiler les glissières","Vérification niveau huile glissière",null,null,null,"Niveau d'huile pour glissière + vidange récipient de récupération","Niveau d'huile pour glissière + vidange récipient de récupération","Filtre résidu","Filtre résidu",null,"Lubrifier les axes et la broche","Lubrifier les axes et la broche","Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe\nContrôler et ajouter si nécessaire de la graisse pour les glissières","Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajouter le niveau de lubrification glissières","Nettoyage général du convoyeur à copeaux et du réservoir de lubrifiant \nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajuster le niveau de lubrification pour les glissières","Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,"Nettoyage approfondi\nVidanger l'huile de coupe","Nettoyage approfondi\nNettoyage réservoir de l'huile hydraulique + remplacement de l'huile hydraulique du réservoir\nVidanger l'huile de coupe","Nettoyage approfondi\nNettoyage réservoir de l'huile hydraulique + remplacement de l'huile hydraulique du réservoir\nVidanger l'huile de coupe","Nettoyage approfondi\nVidange de l'huile de coupe","Nettoyage approfondi\nVidange de l'huile de coupe"]
["Rectification","F04_Fraiseuse_5_axes_HEDELIUS_BC100","T04_Tour_3_et_4_axes_CMZ_TL20M","E04_Érosion_CN_Découpe_Fil_CUT300",null,"A4_SABLEUSE",null,null,null,null,"EC2_Projecteur_de_profil_SAGEM","Changement Filtres Charbon Noir",null,null,null,null,"Vidange",null,null,null,null,null,"Soufflage Filtre groupe froid","Soufflage filtre groupe froid","Soufflage filtre armoire","Soufflage filtre Armoire",null,"Lubrification glissière","Lubrification glissière","Changement rouleau préfiltre\nChangement fitre résidus 1\nChangement filtre résidus 2","Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe","Nettoyage approfondi\nVidange de l'huile hydraulique\nVidange de l'huile de coupe"]
["Ajustage","F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","T05_Tour_3_et_4_axes_CMZ_TA30Y","E05_Perçage_Microforage_CCR_Technologie_CR200",null,null,null,null,null,null,"EC3_Colonne_de_mesure_TRIMOS","Changement KIT B Soupapes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nettoyage approfondi de la machine + soufflage\nVidange de l'huile de coupe","Nettoyage approfondi de la machine + soufflage\nVidange de l'huile de coupe",null,"Changement rouleau préfiltre"]
["Débit","F06_Fraiseuse_3_axes_KIHEUNG","T06_STARMECA",null,null,null,null,null,null,null,"D1_Scie_Ruban_KASTO"]
["Équipement_de_support",null,"T07_CAZENEUVE",null,null,null,null,null,null,null,"A1_Fraiseuse_GAMBIN"]
["Équipement_de_contrôle",null,null,null,null,null,null,null,null,null,"A2_Fraiseuse_HOLKE"]
[null,null,null,null,null,null,null,null,null,null,"A3_MICROBILLEUSE"]
[null,null,null,null,null,null,null,null,null,null,"A4_SABLEUSE"]
[null,null,null,null,null,null,null,null,null,null,"RO3_Rectification_CN"]
[null,null,null,null,null,null,null,null,null,null,"E01_Érosion_CN_Enfonçage_ROBOFORM200"]
[null,null,null,null,null,null,null,null,null,null,"E02_Érosion_CN_Enfonçage_EDM_FORM20"]
[null,null,null,null,null,null,null,null,null,null,"E03_Érosion_CN_Découpe_Fil_ROBOFIL2020"]
[null,null,null,null,null,null,null,null,null,null,"E04_Érosion_CN_Découpe_Fil_CUT300"]
[null,null,null,null,null,null,null,null,null,null,"E05_Perçage_Microforage_CCR_Technologie_CR200"]
[null,null,null,null,null,null,null,null,null,null,"F01_Centre_usinage_3_axes_VICTOR"]
[null,null,null,null,null,null,null,null,null,null,"F02_Centre_usinage_3_axes_FEELER"]
[null,null,null,null,null,null,null,null,null,null,"F03_Fraiseuse_5_axes_FPT_TESSEN"]
[null,null,null,null,null,null,null,null,null,null,"F04_Fraiseuse_5_axes_HEDELIUS_BC100"]
[null,null,null,null,null,null,null,null,null,null,"F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7"]
[null,null,null,null,null,null,null,null,null,null,"F06_Fraiseuse_3_axes_KIHEUNG"]
[null,null,null,null,null,null,null,null,null,null,"T01_Tour_Conv_HERNAULT"]
[null,null,null,null,null,null,null,null,null,null,"T02_Tour_Conv_MÉTAFLEX"]
[null,null,null,null,null,null,null,null,null,null,"T03_Tour_MICROCUT_omnitechnique"]
[null,null,null,null,null,null,null,null,null,null,"T04_Tour_3_et_4_axes_CMZ_TL20M"]
[null,null,null,null,null,null,null,null,null,null,"T05_Tour_3_et_4_axes_CMZ_TA30Y"]
[null,null,null,null,null,null,null,null,null,null,"T06_STARMECA"]
[null,null,null,null,null,null,null,null,null,null,"T07_CAZENEUVE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Les raccourcis","Element affiché",null,"Niveau de maintenance",null,"Périodicité",null,"Technicien"]
["Ctrl + Shift + H","Formulaire de saisie des opérations de maintenance",null,1,null,"Jours",null,"Yoann.G"]
["Ctrl + Shift + P","Formulaire de saisie du personnel",null,2,null,"Semaine",null,"Yoann.B"]
["Ctrl + Shift + A","Accueil",null,3,null,"Mois",null,"Yannis"]
["Ctrl + Shift + M","Formulaire de saisie matériels",null,null,null,"Année",null,"Olivier"]
["Ctrl + Shift + N","Formulaire de fournisseurs",null,null,null,"Années",null,"Samuel"]
["Ctrl + Shift + E","Formulaire entrée de produits en magsin  ( stocks)",null,null,null,null,null,"Damien / Henrique / Samuel"]
["Ctrl + Shift + S","Formulaire de Sortie de produits du magasin (stocks)",null,null,null,null,null,"Jeremy / Jean-Yves"]
["Ctrl + Shift + C","Affichage de la codification des produits",null,null,null,null,null,"Guillaume / Alexis"]
["Ctrl + Shift +",null,null,null,null,null,null,"Manuel"]
["Ctrl + Shift +",null,null,null,null,null,null,"Michel"]
[null,null,null,null,null,null,null,"Romain"]
[null,null,null,null,null,null,null,"Alexandre"]
[null,null,null,null,null,null,null,"Loïc"]
[null,null,null,null,null,null,null,"Christophe"]
[null,null,null,null,null,null,null,"Benoit.C"]
[null,null,null,null,null,null,null,"Benoit.M"]
[null,null,null,null,null,null,null,"Sous-traitant"]

{"sheet":"Membres","index":14,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Utilisateur","Mot_de_passe"]
[null,"Jean-Bernard","stage"]
[null,"Benoît","stage"]
[null,"Artienne","Cadre"]