{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Accueil","Formulaire Préventif","Formulaire Curatif","Manuel_d'utilisation","Login","Accueil 2","Planning_général","Planification du préventif","Feuil1","Planning","Histo maintenances Préventif","Historique maintenances Curatif","Pense-bête","Ressources","Membres"],"not_rendered":{"charts":0,"images":35,"macros":1,"external_links":0,"defined_names":57,"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":"Formulaire Préventif","index":1,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,1,2,6]]}
[null,"Préventif"]
[]
[]
[]
[null,"Pôle","Équipement","Type de maintenance","Mois de la maintenance","Date du jour","ÉTAT"]
[null,null,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-08-21"},{"$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":""}]

{"sheet":"Formulaire Curatif","index":2,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
[null,null,"Curatif"]
[]
[null,null,"Pôle","Équipement","Problème","Action réalisé","Date de réparation","Intervenant"]

{"sheet":"Manuel_d'utilisation","index":3,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,3,2,7],[7,3,7,4],[5,4,5,7],[7,5,7,8]]}
[]
[null,null,null,"Manuel d'utilisation"]
[]
[]
[]
[null,null,null,"Technicien :","D:\\Petit Armand Taff\\IUT\\Bonnin Méca Spé\\GMAO\\Plan de maintenance\\Excel Corrective et Préventif\\Manuel d'utilisation\\Manuel Technicien.odp"]
[]
[null,null,null,"Responsable maintenance :",null,"D:\\Petit Armand Taff\\IUT\\Bonnin Méca Spé\\GMAO\\Plan de maintenance\\Excel Corrective et Préventif\\Manuel d'utilisation\\Manuel Responsable Maintenance.odp"]

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

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

{"sheet":"Planning_général","index":6,"n_rows":116,"n_cols":16,"rows_kept":116,"cut":false,"hidden":false,"merged":[[1,42,3,46],[23,46,25,63],[14,45,17,45],[14,46,17,46],[14,47,17,47],[14,48,17,48],[14,49,17,49],[14,50,17,50],[14,51,17,51],[14,52,17,52],[14,53,17,53],[14,54,17,54],[14,55,17,55],[14,56,17,56],[4,42,4,46],[5,42,6,46],[14,74,17,74],[14,75,17,75],[14,70,17,70],[14,71,17,71],[14,72,17,72],[14,73,17,73],[14,67,17,67],[14,68,17,68],[14,69,17,69],[14,62,17,62],[14,63,17,63],[14,64,17,64],[14,65,17,65],[14,66,17,66],[14,59,17,59],[14,60,17,60],[14,57,17,57],[14,58,17,58],[14,61,17,61]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N° Équipement","Opérations de maintenance","Mois prochain d'intervention","janvier-19","février-19","mars-19","avril-19","mai-19","juin-19","juillet-19","août-19","septembre-19","octobre-19","novembre-19","décembre-19","État"]
["ES1_Compresseur_GENESIS","Vidange Huile 3 - 4 L",{"$f":"IFERROR(IF(ISBLANK($B14),0,VLOOKUP($B14,Tableau1[],7,0)),\"\")","v":"2020-03-29"},{"$f":"IFERROR(IF(AND(MONTH($C14)=MONTH(D$13),$C14<>\"\"),\"X\",\"\"),\"\")","v":""},{"$f":"IFERROR(IF(AND(MONTH($C14)=MONTH(E$13),$C14<>\"\"),\"X\",\"\"),\"\")","v":""},"X","","","","","","","","",""]
["ES1_Compresseur_GENESIS","Changement Filtres Oléophiles Blanc",{"$f":"IFERROR(IF(ISBLANK($B15),0,VLOOKUP($B15,Tableau1[],7,0)),\"\")","v":"2020-05-28"},{"$f":"IFERROR(IF(AND(MONTH($C15)=MONTH(D$13),$C15<>\"\"),\"X\",\"\"),\"\")","v":""},"","","","X","","","","","","",""]
["ES1_Compresseur_GENESIS","Changement KIT A : Filtre à huile - Cartouche de séparation - Filtre Final - Panneau filtrant ventilation",{"$f":"IFERROR(IF(ISBLANK($B16),0,VLOOKUP($B16,Tableau1[],7,0)),\"\")","v":"2020-06-27"},{"$f":"IFERROR(IF(AND(MONTH($C16)=MONTH(D$13),$C16<>\"\"),\"X\",\"\"),\"\")","v":""},"","","","","X","","","","","",""]
["ES1_Compresseur_GENESIS","Changement Filtres Charbon Noir",{"$f":"IFERROR(IF(ISBLANK($B17),0,VLOOKUP($B17,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["ES2_Groupe_FROID_ROBOFORM200","Nettoyage Filtre à air",{"$f":"IFERROR(IF(ISBLANK($B18),0,VLOOKUP($B18,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["EC1_MMT_DEA_GAMMA_1103","Nettoyer le marbre (acétone)",{"$f":"IFERROR(IF(ISBLANK($B19),0,VLOOKUP($B19,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["EC1_MMT_DEA_GAMMA_1103","Nettoyer et graisser le coulisseau (acétone)",{"$f":"IFERROR(IF(ISBLANK($B20),0,VLOOKUP($B20,Tableau1[],7,0)),\"\")","v":"2020-02-28"},"","X","","","","","","","","","",""]
["EC2_Projecteur_de_profil_SAGEM","Nettoyage (à l'aide d'une brosse pour le nettoyage optique)",{"$f":"IFERROR(IF(ISBLANK($B21),0,VLOOKUP($B21,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["EC3_Colonne_de_mesure_TRIMOS","Nettoyage du marbre (acétone)",{"$f":"IFERROR(IF(ISBLANK($B22),0,VLOOKUP($B22,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["D1_Scie_Ruban_KASTO","Vérifier état courroie + variateur",{"$f":"IFERROR(IF(ISBLANK($B23),0,VLOOKUP($B23,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["D1_Scie_Ruban_KASTO","Vérifier et Huiler (coupe) si nécessaire - \nVérifier état de la scie\nNettoyer Crépine",{"$f":"IFERROR(IF(ISBLANK($B24),0,VLOOKUP($B24,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["D1_Scie_Ruban_KASTO","Vidange",{"$f":"IFERROR(IF(ISBLANK($B25),0,VLOOKUP($B25,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B26),0,VLOOKUP($B26,Tableau1[],7,0)),\"\")","v":"00:00:00"},"X","","","","","","","","","","",""]
["A1_Fraiseuse_GAMBIN","Nettoyage au poste",{"$f":"IFERROR(IF(ISBLANK($B27),0,VLOOKUP($B27,Tableau1[],7,0)),\"\")","v":"2020-01-06"},"X","","","","","","","","","","",""]
["A1_Fraiseuse_GAMBIN","Nettoyage approfondi de la machine",{"$f":"IFERROR(IF(ISBLANK($B28),0,VLOOKUP($B28,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["A1_Fraiseuse_GAMBIN","Vérifier le niveau d'huile glissière - \nHuiler les glissières",{"$f":"IFERROR(IF(ISBLANK($B29),0,VLOOKUP($B29,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["A2_Fraiseuse_HOLKE","Nettoyage au poste",{"$f":"IFERROR(IF(ISBLANK($B30),0,VLOOKUP($B30,Tableau1[],7,0)),\"\")","v":"2020-01-06"},"X","","","","",{"$f":"IFERROR(IF(AND(MONTH($C30)=MONTH(I$13),$C30<>\"\"),\"X\",\"\"),\"\")","v":""},"","","",{"$f":"IFERROR(IF(AND(MONTH($C30)=MONTH(M$13),$C30<>\"\"),\"X\",\"\"),\"\")","v":""},"",""]
["A2_Fraiseuse_HOLKE","Nettoyage approfondi de la machine",{"$f":"IFERROR(IF(ISBLANK($B31),0,VLOOKUP($B31,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","",{"$f":"IFERROR(IF(AND(MONTH($C31)=MONTH(H$13),$C31<>\"\"),\"X\",\"\"),\"\")","v":""},"X","","","","","",""]
["A2_Fraiseuse_HOLKE","Vérification niveau huile glissière",{"$f":"IFERROR(IF(ISBLANK($B32),0,VLOOKUP($B32,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["A3_MICROBILLEUSE","Vider le récipient à poussière",{"$f":"IFERROR(IF(ISBLANK($B33),0,VLOOKUP($B33,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["A3_MICROBILLEUSE","Nettoyer le sac",{"$f":"IFERROR(IF(ISBLANK($B34),0,VLOOKUP($B34,Tableau1[],7,0)),\"\")","v":"2020-09-25"},"","","","","","","","","X","","",""]
["A4_SABLEUSE","Vider le pot à poussière",{"$f":"IFERROR(IF(ISBLANK($B35),0,VLOOKUP($B35,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["A4_SABLEUSE","Changer ou nettoyer le filtre",{"$f":"IFERROR(IF(ISBLANK($B36),0,VLOOKUP($B36,Tableau1[],7,0)),\"\")","v":"2020-09-25"},"","","","","","","","","X","","",""]
["RO3_Rectification_CN","Lubrifier les glissières - Niveau huile de coupe +ajustage si nécessaire - Huile pneumatique + ajustage si nécessaire",{"$f":"IFERROR(IF(ISBLANK($B37),0,VLOOKUP($B37,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["RO3_Rectification_CN","Vidanger le bac à lubrifiant et graisser les axes",{"$f":"IFERROR(IF(ISBLANK($B38),0,VLOOKUP($B38,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Changement des 4 filtres diélectriques",{"$f":"IFERROR(IF(ISBLANK($B39),0,VLOOKUP($B39,Tableau1[],7,0)),\"\")","v":"2020-04-28"},"","","","X","","","","","","","",""]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IFERROR(IF(ISBLANK($B40),0,VLOOKUP($B40,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Soufflage Filtre groupe froid",{"$f":"IFERROR(IF(ISBLANK($B41),0,VLOOKUP($B41,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Remplacement liquide diélectrique",{"$f":"IFERROR(IF(ISBLANK($B42),0,VLOOKUP($B42,Tableau1[],7,0)),\"\")","v":"2021-12-29"},"","","","","","","","","","","","X"]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Changement des 2 filtres diélectriques",{"$f":"IFERROR(IF(ISBLANK($B43),0,VLOOKUP($B43,Tableau1[],7,0)),\"\")","v":"2020-04-28"},"","","","X","","","","","","","",""]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IFERROR(IF(ISBLANK($B44),0,VLOOKUP($B44,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Soufflage filtre groupe froid",{"$f":"IFERROR(IF(ISBLANK($B45),0,VLOOKUP($B45,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Remplacement du liquide diélectrique",{"$f":"IFERROR(IF(ISBLANK($B46),0,VLOOKUP($B46,Tableau1[],7,0)),\"\")","v":"2021-12-29"},"","","","","","","","","","","","X"]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Vérification et changement si nécessaire du filtre résidu",{"$f":"IFERROR(IF(ISBLANK($B47),0,VLOOKUP($B47,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Changement des 16 filtres eau ",{"$f":"IFERROR(IF(ISBLANK($B48),0,VLOOKUP($B48,Tableau1[],7,0)),\"\")","v":"2020-04-28"},"","","","X","","","","","","","",""]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IFERROR(IF(ISBLANK($B49),0,VLOOKUP($B49,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Soufflage filtre armoire",{"$f":"IFERROR(IF(ISBLANK($B50),0,VLOOKUP($B50,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E04_Érosion_CN_Découpe_Fil_CUT300","Vérification et changement si nécessaire du filtre résidu",{"$f":"IFERROR(IF(ISBLANK($B51),0,VLOOKUP($B51,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["E04_Érosion_CN_Découpe_Fil_CUT300","Changement des filtres eau",{"$f":"IFERROR(IF(ISBLANK($B52),0,VLOOKUP($B52,Tableau1[],7,0)),\"\")","v":"2020-04-28"},"","","","X","","","","","","","",""]
["E04_Érosion_CN_Découpe_Fil_CUT300","Niveau Graisse glissière + vidange de récipient de récupération",{"$f":"IFERROR(IF(ISBLANK($B53),0,VLOOKUP($B53,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E04_Érosion_CN_Découpe_Fil_CUT300","Soufflage filtre Armoire",{"$f":"IFERROR(IF(ISBLANK($B54),0,VLOOKUP($B54,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["E05_Perçage_Microforage_CCR_Technologie_CR200","Nettoyer pour enlever les résidus",{"$f":"IFERROR(IF(ISBLANK($B55),0,VLOOKUP($B55,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["E05_Perçage_Microforage_CCR_Technologie_CR200","Soufflage filtre armoire",{"$f":"IFERROR(IF(ISBLANK($B56),0,VLOOKUP($B56,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F01_Centre_usinage_3_axes_VICTOR","Lubrifier les axes et la broche",{"$f":"IFERROR(IF(ISBLANK($B57),0,VLOOKUP($B57,Tableau1[],7,0)),\"\")","v":"2020-01-13"},"X","","","","","","","","","","",""]
["F01_Centre_usinage_3_axes_VICTOR","Lubrification glissière",{"$f":"IFERROR(IF(ISBLANK($B58),0,VLOOKUP($B58,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F01_Centre_usinage_3_axes_VICTOR","Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression",{"$f":"IFERROR(IF(ISBLANK($B59),0,VLOOKUP($B59,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F01_Centre_usinage_3_axes_VICTOR","Vidanger l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B60),0,VLOOKUP($B60,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["F02_Centre_usinage_3_axes_FEELER","Lubrifier les axes et la broche",{"$f":"IFERROR(IF(ISBLANK($B61),0,VLOOKUP($B61,Tableau1[],7,0)),\"\")","v":"2020-01-13"},"X","","","","","","","","","","",""]
["F02_Centre_usinage_3_axes_FEELER","Lubrification glissière",{"$f":"IFERROR(IF(ISBLANK($B62),0,VLOOKUP($B62,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F02_Centre_usinage_3_axes_FEELER","Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression",{"$f":"IFERROR(IF(ISBLANK($B63),0,VLOOKUP($B63,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F02_Centre_usinage_3_axes_FEELER","Vidanger l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B64),0,VLOOKUP($B64,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler et ajuster le niveau de graisse blanche(broches)",{"$f":"IFERROR(IF(ISBLANK($B65),0,VLOOKUP($B65,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage général du convoyeur à copeaux\nNettoyage général de la machine\nContrôler et ajuster le niveau d'huile hydraulique",{"$f":"IFERROR(IF(ISBLANK($B66),0,VLOOKUP($B66,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage approfondi\nContrôler et ajuster le niveau de graisse glissière",{"$f":"IFERROR(IF(ISBLANK($B67),0,VLOOKUP($B67,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Changement rouleau préfiltre\nChangement Filtre résidus 1\nChangement Filtre résidus 2",{"$f":"IFERROR(IF(ISBLANK($B68),0,VLOOKUP($B68,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B69),0,VLOOKUP($B69,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage du double filtre, remplacement si nécessaire",{"$f":"IFERROR(IF(ISBLANK($B70),0,VLOOKUP($B70,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyer en profondeur l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air",{"$f":"IFERROR(IF(ISBLANK($B71),0,VLOOKUP($B71,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage général du convoyeur à copeaux et du réservoir du lubrifiant\nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajuster le niveau de lubrification pour les glissières\nNettoyage général de la machine",{"$f":"IFERROR(IF(ISBLANK($B72),0,VLOOKUP($B72,Tableau1[],7,0)),\"\")","v":""},"","","","","","","","","","","",""]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage approfondi\nChangement rouleau préfiltre",{"$f":"IFERROR(IF(ISBLANK($B73),0,VLOOKUP($B73,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B74),0,VLOOKUP($B74,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","",{"$f":"IFERROR(IF(AND(MONTH($C74)=MONTH(H$13),$C74<>\"\"),\"X\",\"\"),\"\")","v":""},"","","","","","","X"]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler les salissures du fitre fin",{"$f":"IFERROR(IF(ISBLANK($B75),0,VLOOKUP($B75,Tableau1[],7,0)),\"\")","v":"2020-01-29"},"X","","","","","","","","","","",""]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile pneumatique\nContrôler et ajuster le niveau de lubrification pour les glissières\nNettoyage général de la machine",{"$f":"IFERROR(IF(ISBLANK($B76),0,VLOOKUP($B76,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage approfondi\nVérification visuel + Nettoyage du double filtre, remplacement si nécessaire\nContrôler et ajuster le niveau de lubrification pour le groupe froid",{"$f":"IFERROR(IF(ISBLANK($B77),0,VLOOKUP($B77,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Vidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B78),0,VLOOKUP($B78,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["F06_Fraiseuse_3_axes_KIHEUNG","Examiner l'état du lubrifiant. \nSouffler le filtre à air. \nContrôler et ajouter si nécessaire de la graisse blanche pour les broches ",{"$f":"IFERROR(IF(ISBLANK($B79),0,VLOOKUP($B79,Tableau1[],7,0)),\"\")","v":"2020-01-29"},{"$f":"IFERROR(IF(AND(MONTH($C79)=MONTH(D$13),$C79<>\"\"),\"X\",\"\"),\"\")","v":"X"},"","","","","","","","","","",""]
["F06_Fraiseuse_3_axes_KIHEUNG","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",{"$f":"IFERROR(IF(ISBLANK($B80),0,VLOOKUP($B80,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["F06_Fraiseuse_3_axes_KIHEUNG","Nettoyage approfondi",{"$f":"IFERROR(IF(ISBLANK($B81),0,VLOOKUP($B81,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["F06_Fraiseuse_3_axes_KIHEUNG","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B82),0,VLOOKUP($B82,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["T01_Tour_Conv_HERNAULT","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles",{"$f":"IFERROR(IF(ISBLANK($B83),0,VLOOKUP($B83,Tableau1[],7,0)),\"\")","v":"2020-01-06"},"X","","","","","","","","","","",""]
["T01_Tour_Conv_HERNAULT","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)",{"$f":"IFERROR(IF(ISBLANK($B84),0,VLOOKUP($B84,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T02_Tour_Conv_MÉTAFLEX","Nettoyage complet de toute la poussière, les copeaux et les corps étrangers des pièces mobiles",{"$f":"IFERROR(IF(ISBLANK($B85),0,VLOOKUP($B85,Tableau1[],7,0)),\"\")","v":"2020-01-06"},"X","","","","","","","","","","",""]
["T02_Tour_Conv_MÉTAFLEX","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)",{"$f":"IFERROR(IF(ISBLANK($B86),0,VLOOKUP($B86,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T03_Tour_MICROCUT_omnitechnique","Inspection et si besoin remplissage de l'huile glissière",{"$f":"IFERROR(IF(ISBLANK($B87),0,VLOOKUP($B87,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["T03_Tour_MICROCUT_omnitechnique","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",{"$f":"IFERROR(IF(ISBLANK($B88),0,VLOOKUP($B88,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T03_Tour_MICROCUT_omnitechnique","Vidanger l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B89),0,VLOOKUP($B89,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Inspection et si besoin remplissage de l'huile glissière\nInspection et si besoin remplissage de l'huile hydraulique",{"$f":"IFERROR(IF(ISBLANK($B90),0,VLOOKUP($B90,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",{"$f":"IFERROR(IF(ISBLANK($B91),0,VLOOKUP($B91,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B92),0,VLOOKUP($B92,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Inspection et si besoin remplissage de l'huile glissière\nInspection et si besoin remplissage d l'huile hydraulique",{"$f":"IFERROR(IF(ISBLANK($B93),0,VLOOKUP($B93,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","",{"$f":"IFERROR(IF(AND(MONTH($C93)=MONTH(L$13),$C93<>\"\"),\"X\",\"\"),\"\")","v":""},"","",""]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",{"$f":"IFERROR(IF(ISBLANK($B94),0,VLOOKUP($B94,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B95),0,VLOOKUP($B95,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["T06_STARMECA","Inspection et si besoin remplissage de l'huile glissière",{"$f":"IFERROR(IF(ISBLANK($B96),0,VLOOKUP($B96,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["T06_STARMECA","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",{"$f":"IFERROR(IF(ISBLANK($B97),0,VLOOKUP($B97,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T06_STARMECA","Vidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B98),0,VLOOKUP($B98,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
["T07_CAZENEUVE","Inspection et si besoin remplissage de l'huile glissière",{"$f":"IFERROR(IF(ISBLANK($B99),0,VLOOKUP($B99,Tableau1[],7,0)),\"\")","v":"2020-03-29"},"","","X","","","","","","","","",""]
["T07_CAZENEUVE","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",{"$f":"IFERROR(IF(ISBLANK($B100),0,VLOOKUP($B100,Tableau1[],7,0)),\"\")","v":"2020-06-27"},"","","","","","X","","","","","",""]
["T07_CAZENEUVE","Vidange de l'huile de coupe",{"$f":"IFERROR(IF(ISBLANK($B101),0,VLOOKUP($B101,Tableau1[],7,0)),\"\")","v":"2020-12-29"},"","","","","","","","","","","","X"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B110),0,VLOOKUP($B110,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B111),0,VLOOKUP($B111,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B112),0,VLOOKUP($B112,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B113),0,VLOOKUP($B113,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B114),0,VLOOKUP($B114,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B115),0,VLOOKUP($B115,Tableau1[],7,0)),\"\")","v":"00:00:00"}]
[null,null,{"$f":"IFERROR(IF(ISBLANK($B116),0,VLOOKUP($B116,Tableau1[],7,0)),\"\")","v":"00:00:00"}]

{"sheet":"Planification du préventif","index":7,"n_rows":102,"n_cols":41,"rows_kept":102,"cut":false,"hidden":false,"merged":[[1,6,1,7],[1,9,1,11],[1,33,1,37],[1,28,1,32]]}
[]
[null,null,null,null,null,null,"Mois d'intervention",null,"Tps inter","Périodicité",null,null,null,null,null,null,null,null,null,null,null,null,null,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","Prochain","Tps inter(h)","P ","Unité","en jrs","ÉTAT",null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",{"$f":"AO4","v":90},{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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($AC4=1,$J4*1,0)","v":0},{"$f":"IF($AD4=1,$J4*7,0)","v":0},{"$f":"IF($AE4=1,$J4*30,0)","v":90},{"$f":"IF($AF4=1,$J4*365,0)","v":0},{"$f":"IF($AG4=1,$J4*365,0)","v":0},{"$f":"IF(AND($J4>1,$K4=\"Année\"),\"Erreur de saisie\",ROUND(SUM($AH4:$AL4),0))","v":90},{"$f":"IF(AND($K4>0,$J4=\"\"),0,1)","v":1},{"$f":"IF(AND($AM4=0,$AN4=0),\"Erreur de saisie\", $AM4)","v":90}]
["ES1_Compresseur_GENESIS","Changement Filtres Oléophiles Blanc",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-05-28"},null,5,"Mois",150,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 281 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K5=\"Jours\",1,0)","v":0},{"$f":"IF($K5=\"Semaine\",1,0)","v":0},{"$f":"IF($K5=\"Mois\",1,0)","v":1},{"$f":"IF($K5=\"Année\",1,0)","v":0},{"$f":"IF($K5=\"Années\",1,0)","v":0},0,0,150,0,0,150,{"$f":"IF(AND($K5>0,$J5=\"\"),0,1)","v":1},150]
["ES1_Compresseur_GENESIS","Changement KIT A : Filtre à huile - Cartouche de séparation - Filtre Final - Panneau filtrant ventilation",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["ES1_Compresseur_GENESIS","Changement Filtres Charbon Noir",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["ES1_Compresseur_GENESIS","Changement KIT B Soupapes",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2021-12-29"},null,2,"Années",730,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 861 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["EC1_MMT_DEA_GAMMA_1103","Nettoyer et graisser le coulisseau (acétone)",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-02-28"},null,2,"Mois",60,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 191 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["EC3_Colonne_de_mesure_TRIMOS","Nettoyage du marbre (acétone)",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["D1_Scie_Ruban_KASTO","Vérifier état courroie + variateur",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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\nNettoyer Crépine",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["D1_Scie_Ruban_KASTO","Vidange",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
[null,null,null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["A1_Fraiseuse_GAMBIN","Nettoyage au poste",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-06"},null,1,"Semaine",7,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 138 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,7,0,0,0,7,1,7]
["A1_Fraiseuse_GAMBIN","Nettoyage approfondi de la machine",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A1_Fraiseuse_GAMBIN","Vérifier le niveau d'huile glissière - \nHuiler les glissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A2_Fraiseuse_HOLKE","Nettoyage au poste",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-06"},null,1,"Semaine",7,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 138 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,7,0,0,0,7,1,7]
["A2_Fraiseuse_HOLKE","Nettoyage approfondi de la machine",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A2_Fraiseuse_HOLKE","Vérification niveau huile glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A3_MICROBILLEUSE","Vider le récipient à poussière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A3_MICROBILLEUSE","Nettoyer le sac",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-09-25"},null,9,"Mois",270,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 401 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,270,0,0,270,1,270]
["A4_SABLEUSE","Vider le pot à poussière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["A4_SABLEUSE","Changer ou nettoyer le filtre",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-09-25"},null,9,"Mois",270,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 401 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,270,0,0,270,1,270]
["RO3_Rectification_CN","Lubrifier les glissières - Niveau huile de coupe +ajustage si nécessaire - Huile pneumatique + ajustage si nécessaire",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["RO3_Rectification_CN","Vidanger le bac à lubrifiant et graisser les axes",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Changement des 4 filtres diélectriques",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-04-28"},null,4,"Mois",120,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 251 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Soufflage Filtre groupe froid",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E01_Érosion_CN_Enfonçage_ROBOFORM200","Remplacement liquide diélectrique",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2021-12-29"},null,2,"Années",730,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 861 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,1,0,0,0,0,730,730,1,730]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Changement des 2 filtres diélectriques",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-04-28"},null,4,"Mois",120,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 251 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Soufflage filtre groupe froid",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,{"$f":"IF($AD36=1,$J36*7,0)","v":0},{"$f":"IF($AE36=1,$J36*30,0)","v":180},{"$f":"IF($AF36=1,$J36*365,0)","v":0},{"$f":"IF($AG36=1,$J36*365,0)","v":0},{"$f":"IF(AND($J36>1,$K36=\"Année\"),\"Erreur de saisie\",ROUND(SUM($AH36:$AL36),0))","v":180},1,{"$f":"IF(AND($AM36=0,$AN36=0),\"Erreur de saisie\", $AM36)","v":180}]
["E02_Érosion_CN_Enfonçage_EDM_FORM20","Remplacement du liquide diélectrique",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2021-12-29"},null,2,"Années",730,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 861 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,1,0,0,0,0,730,730,1,730]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Vérification et changement si nécessaire du filtre résidu",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Changement des 16 filtres eau ",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-04-28"},null,4,"Mois",120,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 251 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Niveau d'huile pour glissière + vidange récipient de récupération",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E03_Érosion_CN_Découpe_Fil_ROBOFIL2020","Soufflage filtre armoire",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E04_Érosion_CN_Découpe_Fil_CUT300","Vérification et changement si nécessaire du filtre résidu",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["E04_Érosion_CN_Découpe_Fil_CUT300","Changement des filtres eau",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-04-28"},null,4,"Mois",120,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 251 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,120,0,0,120,1,120]
["E04_Érosion_CN_Découpe_Fil_CUT300","Niveau Graisse glissière + vidange de récipient de récupération",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E04_Érosion_CN_Découpe_Fil_CUT300","Soufflage filtre Armoire",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["E05_Perçage_Microforage_CCR_Technologie_CR200","Nettoyer pour enlever les résidus",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["E05_Perçage_Microforage_CCR_Technologie_CR200","Soufflage filtre armoire",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F01_Centre_usinage_3_axes_VICTOR","Lubrifier les axes et la broche",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-13"},null,2,"Semaine",14,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 145 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,14,0,0,0,14,1,14]
["F01_Centre_usinage_3_axes_VICTOR","Lubrification glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F01_Centre_usinage_3_axes_VICTOR","Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F01_Centre_usinage_3_axes_VICTOR","Vidanger l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["F02_Centre_usinage_3_axes_FEELER","Lubrifier les axes et la broche",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-13"},null,2,"Semaine",14,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 145 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,14,0,0,0,14,{"$f":"IF(AND($K52>0,$J52=\"\"),0,1)","v":1},14]
["F02_Centre_usinage_3_axes_FEELER","Lubrification glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,{"$f":"IF(AND($K53>0,$J53=\"\"),0,1)","v":1},90]
["F02_Centre_usinage_3_axes_FEELER","Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F02_Centre_usinage_3_axes_FEELER","Vidanger l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler et ajuster le niveau de graisse blanche(broches)",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage général du convoyeur à copeaux\nNettoyage général de la machine\nContrôler et ajuster le niveau d'huile hydraulique",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Nettoyage approfondi\nContrôler et ajuster le niveau de graisse glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Changement rouleau préfiltre\nChangement Filtre résidus 1\nChangement Filtre résidus 2",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F03_Fraiseuse_5_axes_FPT_TESSEN","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage du double filtre, remplacement si nécessaire",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyer en profondeur l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage général du convoyeur à copeaux et du réservoir du 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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Nettoyage approfondi\nChangement rouleau préfiltre",null,null,null,"Voir Technicien","2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F04_Fraiseuse_5_axes_HEDELIUS_BC100","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler les salissures du fitre fin",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile pneumatique\nContrôler et ajuster le niveau de lubrification pour les glissières\nNettoyage général de la machine",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Nettoyage approfondi\nVérification visuel + Nettoyage du double filtre, remplacement si nécessaire\nContrôler et ajuster le niveau de lubrification pour le groupe froid",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",{"$f":"AO68","v":180},{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,{"$f":"IF($AC68=1,$J68*1,0)","v":0},{"$f":"IF($AD68=1,$J68*7,0)","v":0},{"$f":"IF($AE68=1,$J68*30,0)","v":180},{"$f":"IF($AF68=1,$J68*365,0)","v":0},{"$f":"IF($AG68=1,$J68*365,0)","v":0},{"$f":"IF(AND($J68>1,$K68=\"Année\"),\"Erreur de saisie\",ROUND(SUM($AH68:$AL68),0))","v":180},1,{"$f":"IF(AND($AM68=0,$AN68=0),\"Erreur de saisie\", $AM68)","v":180}]
["F05_Fraiseuse_5_axes_HEDELIUS_TILENTA_7","Vidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,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":1},{"$f":"IF($K69=\"Années\",1,0)","v":0},0,0,0,365,0,365,{"$f":"IF(AND($K69>0,$J69=\"\"),0,1)","v":1},365]
["F06_Fraiseuse_3_axes_KIHEUNG","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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-29"},null,1,"Mois",30,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 161 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,30,0,0,30,1,30]
["F06_Fraiseuse_3_axes_KIHEUNG","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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["F06_Fraiseuse_3_axes_KIHEUNG","Nettoyage approfondi",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["F06_Fraiseuse_3_axes_KIHEUNG","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-06"},null,1,"Semaine",7,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 138 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,7,0,0,0,7,1,7]
["T01_Tour_Conv_HERNAULT","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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-01-06"},null,1,"Semaine",7,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 138 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,1,0,0,0,0,{"$f":"IF($AD76=1,$J76*7,0)","v":7},0,0,0,{"$f":"IF(AND($J76>1,$K76=\"Année\"),\"Erreur de saisie\",ROUND(SUM($AH76:$AL76),0))","v":7},1,7]
["T02_Tour_Conv_MÉTAFLEX","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,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T03_Tour_MICROCUT_omnitechnique","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["T03_Tour_MICROCUT_omnitechnique","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T03_Tour_MICROCUT_omnitechnique","Vidanger l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Inspection et si besoin remplissage de l'huile glissière\nInspection et si besoin remplissage de l'huile hydraulique",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T04_Tour_3_et_4_axes_CMZ_TL20M","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Inspection et si besoin remplissage de l'huile glissière\nInspection et si besoin remplissage d l'huile hydraulique",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T05_Tour_3_et_4_axes_CMZ_TA30Y","Vidange de l'huile hydraulique\nVidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["T06_STARMECA","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["T06_STARMECA","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T06_STARMECA","Vidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
["T07_CAZENEUVE","Inspection et si besoin remplissage de l'huile glissière",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-03-29"},null,3,"Mois",90,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 221 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,90,0,0,90,1,90]
["T07_CAZENEUVE","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-06-27"},null,6,"Mois",180,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 311 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,1,0,0,0,0,180,0,0,180,1,180]
["T07_CAZENEUVE","Vidange de l'huile de coupe",null,null,null,null,"2019-12-30",{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":"2020-12-29"},null,1,"Année",365,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":"À faire dans 496 jours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,1,0,0,0,0,365,0,365,1,365]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(IF(Tableau1[[#This Row],[Anterieure]]=\"\",\"\",Tableau1[[#This Row],[Anterieure]]+Tableau1[[#This Row],[en jrs]]),\"Voir Technicien\")","v":""},null,null,null,0,{"$f":"IFERROR(_xlfn.IFS(TODAY()>Tableau1[[#This Row],[Prochain]],\"En retard de \"&(TODAY()-Tableau1[[#This Row],[Prochain]])&\" jours\",Tableau1[[#This Row],[Prochain]]>TODAY(),\"À faire dans \"&Tableau1[[#This Row],[Prochain]]-TODAY()&\" jours\",Tableau1[[#This Row],[Prochain]]=TODAY(),\"À faire\"&Tableau1[[#This Row],[Prochain]]= TODAY()&\"jours\"),\"\")","v":""}]

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

{"sheet":"Planning","index":9,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,9,1,10]]}
[]
[null,null,null,null,null,null,null,null,null,"PLANNING PERSONNEL"]
[]
[]
[null,null,null,null,null,"Technicien"]
[null,null,null,null,null,"Christophe",null,null,"N° Équipement","Opérations de maintenance","Mois pro intervention"]
[null,null,null,null,null,null,null,null,"E01_Érosion_CN_Enfonçage_ROBOFORM200","Changement des 4 filtres diélectriques",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J7,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-04-28"}]
[null,null,null,null,null,null,null,null,null,"Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J8,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-06-27"}]
[null,null,null,null,null,null,null,null,null,"Soufflage Filtre groupe froid",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J9,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-06-27"}]
[null,null,null,null,null,null,null,null,null,"Remplacement liquide diélectrique",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J10,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2021-12-29"}]
[null,null,null,null,null,null,null,null,"E02_Érosion_CN_Enfonçage_EDM_FORM20","Changement des 2 filtres diélectriques",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J11,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-04-28"}]
[null,null,null,null,null,null,null,null,null,"Niveau d'huile pour glissière + vidange récipient de récupération",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J12,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-06-27"}]
[null,null,null,null,null,null,null,null,null,"Soufflage filtre groupe froid",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J13,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-06-27"}]
[null,null,null,null,null,null,null,null,null,"Remplacement du liquide diélectrique",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J14,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2021-12-29"}]
[null,null,null,null,null,null,null,null,"E05_Perçage_Microforage_CCR_Technologie_CR200","Nettoyer pour enlever les résidus",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J15,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-01-29"}]
[null,null,null,null,null,null,null,null,null,"Soufflage filtre armoire",{"$f":"IFERROR(INDEX('Planification du préventif'!$H$4:$H$92,MATCH(Planning!J16,'Planification du préventif'!$B$4:$B$92,0)),\"\")","v":"2020-06-27"}]

{"sheet":"Histo maintenances Préventif","index":10,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Pôle","Equipement","Maintenance","Date","État"]
[null,"Érosion","E01_Érosion_CN_Enfonçage_ROBOFORM200","Changement des 4 filtres diélectriques","20/08/2019","Effectuée En avance de 156 jours"]
[null,"Fraisage","F01_Centre_usinage_3_axes_VICTOR","Lubrification glissière","20/08/2019","Effectuée En avance de 115 jours"]
[null,"Tournage","T02_Tour_Conv_MÉTAFLEX","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)","20/08/2019","Effectuée En avance de 200 jours"]

{"sheet":"Historique maintenances Curatif","index":11,"n_rows":6,"n_cols":10,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,9,7,11]]}
[]
[]
[null,"Pôle","Équipement","Problème","Tâches Planifiées","Date de maintenance","Utilisateur assigné"]
[null,"Fraisage","F01_Centre_usinage_3_axes_VICTOR","efz","qerf","31/12/1899","zef"]
[null,"Érosion","E02_Érosion_CN_Enfonçage_EDM_FORM20","Courroie","Remplacement courroie","24/08/2019","Benoit.C"]
[null,null,null,null,null,null,null,null,null,"Curatif"]

{"sheet":"Pense-bête","index":12,"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":"Ressources","index":13,"n_rows":81,"n_cols":40,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,3,3],[0,4,3,7]]}
["/!\\ 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","Michel","Michel","Alexandre","Alexandre","Loïc","Christophe","Christophe","Loïc","Loïc","Christophe","Damien / Henrique / Samuel","Damien / Henrique / Samuel","Jeremy / Jean-Yves","Jeremy / Jean - Yves","Guillaume / Alexis","Manuel","Olivier","Yoann.G","Yoann.G","Olivier","Yannis","Yoann.P","Yoann.P"]
["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 état courroie + variateur","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","Changement des 4 filtres diélectriques","Changement des 2 filtres diélectriques","Vérification et changement si nécessaire du filtre résidu","Vérification et changement si nécessaire du filtre résidu","Nettoyer pour enlever les résidus","Lubrifier les axes et la broche","Lubrifier les axes et la broche","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler et ajuster le niveau de graisse blanche(broches)","Nettoyage du double filtre, remplacement si nécessaire","Nettoyage en profondeur de l'espace de travail de la machine. Examiner l'état du lubrifiant. \nSouffler le filtre à air\nContrôler les salissures du fitre fin","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\nInspection et si besoin remplissage de l'huile hydraulique","Inspection et si besoin remplissage de l'huile glissière\nInspection et si besoin remplissage d l'huile hydraulique","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 Filtres Oléophiles Blanc",null,"Nettoyer et graisser le coulisseau (acétone)",null,null,"Vérifier et Huiler (coupe) si nécessaire - \nVérifier état de la scie\nNettoyer Crépine","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","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","Changement des 16 filtres eau ","Changement des filtres eau","Soufflage filtre armoire","Lubrification glissière","Lubrification glissière","Nettoyage général du convoyeur à copeaux\nNettoyage général de la machine\nContrôler et ajuster le niveau d'huile hydraulique","Nettoyer en profondeur l'espace de travail de la machine. Examiner l'état du lubrifiant\nSouffler le filtre à air","Nettoyage général du convoyeur à copeaux\nContrôler et ajuster le niveau d'huile pneumatique\nContrôler et ajuster le niveau de lubrification pour les glissières\nNettoyage général de la machine","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 approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage approfondi\nNettoyage filtre à air (armoire électrique)\nNettoyage protection des gissières","Nettoyage approfondi\nNettoyage 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 KIT A : Filtre à huile - Cartouche de séparation - Filtre Final - Panneau filtrant ventilation",null,null,null,null,"Vidange","Vérifier le niveau d'huile glissière - \nHuiler les glissières","Vérification niveau huile glissière",null,null,null,"Soufflage Filtre groupe froid","Soufflage filtre groupe froid","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",null,"Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression","Nettoyage approfondi de la machine. Soufflage\navec de l'air sous pression","Nettoyage approfondi\nContrôler et ajuster le niveau de graisse glissière","Nettoyage général du convoyeur à copeaux et du réservoir du lubrifiant\nContrôler et ajuster le niveau d'huile hydraulique\nContrôler et ajuster le niveau de lubrification pour les glissières","Nettoyage approfondi\nVérification visuel + Nettoyage du double filtre, remplacement si nécessaire\nContrôler et ajuster le niveau de lubrification pour le groupe froid","Nettoyage approfondi",null,null,"Vidanger l'huile de coupe","Vidange de l'huile hydraulique\nVidange de l'huile de coupe","Vidange de l'huile hydraulique\nVidange de l'huile de coupe","Vidange de l'huile de coupe","Vidange 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,null,null,null,null,null,null,"Remplacement liquide diélectrique","Remplacement du liquide diélectrique","Soufflage filtre armoire","Soufflage filtre Armoire",null,"Vidanger l'huile de coupe","Vidanger l'huile de coupe","Changement rouleau préfiltre\nChangement Filtre résidus 1\nChangement Filtre résidus 2","Nettoyage approfondi\nChangement rouleau préfiltre","Vidange de l'huile de coupe","Vidange 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,null,null,"Vidange de l'huile hydraulique\nVidange de l'huile de coupe","Vidange de l'huile hydraulique\nVidange de l'huile de coupe"]
["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"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Niveau de maintenance",null,"Périodicité",null,"Technicien"]
[null,null,null,1,null,"Jours",null,"Yoann.G"]
[null,null,null,2,null,"Semaine",null,"Yoann.B"]
[null,null,null,3,null,"Mois",null,"Yannis"]
[null,null,null,null,null,"Année",null,"Olivier"]
[null,null,null,null,null,"Années",null,"Samuel"]
[null,null,null,null,null,null,null,"Damien / Henrique / Samuel"]
[null,null,null,null,null,null,null,"Jeremy / Jean-Yves"]
[null,null,null,null,null,null,null,"Guillaume / Alexis"]
[null,null,null,null,null,null,null,"Manuel"]
[null,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":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Utilisateur","Mot_de_passe"]
[null,"Jean-Bernard","stage"]
[null,"Benoît","stage"]