{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Gestion Mdp Admin","Indicateurs - 2020 -","Menu","Journal Formation","Planning Formation","Listing Formations","Informations salariés","GestionLISTE","Contacts"],"not_rendered":{"charts":1,"images":33,"macros":1,"external_links":0,"defined_names":53,"comments":1,"pivot_tables":1},"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":"Gestion Mdp Admin","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Users","Passworld","Niveau","Date"]
["Users","Passworld","Niveau","Date"]
["Admin","Admin",1,"2020-04-09"]

{"sheet":"Indicateurs - 2020 -","index":1,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Étiquettes de lignes","Somme de Quantité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(vide)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECHLINE ADDITIF MOUILLANT 20L",322]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TECHLINE JAVEL PASTILLES 500g",12]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total général",334]

{"sheet":"Menu","index":2,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":false,"merged":[[7,23,8,23],[7,24,8,24],[1,8,1,11],[1,12,1,14],[2,8,2,11],[2,12,2,14],[3,8,3,11],[3,12,3,14]]}
[]
[null,null,null,null,null,null,null,null,"Suivi Commande"]
[null,null,null,null,null,null,null,null,"Suivi Produit à Commander"]
[null,null,null,null,null,null,null,null,"Suivi Date de Péremption"]

{"sheet":"Journal Formation","index":3,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Journal_Suivi_Formation[Formation(s) à renouveler],\"Date dépassée\")>0, COUNTIF(Journal_Suivi_Formation[Formation(s) à renouveler],\"Date dépassée\") &\" \" & Q7,\"OK\")","v":"3 Formation(s) à renouveler"}]
["Matricule","Nom / Prénom","ID Session","Formation","Sigle","Type de Formation","Lieu de la formation","Date Début","Date Fin","Durée de la formation","Coût de la formation","Coût frais du salarié","Coût Global ","Formation Acquise","Date fin de validité","Nombre de Jours Restants","Formation(s) à renouveler"]
["M123456",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[Matricule]],Info_Salarie[],COLUMN(Info_Salarie[Nom / Prénom]),FALSE)","v":"René"},"S001",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Formation]),FALSE)","v":"SST"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Sigle]),FALSE)","v":"SST"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Type de formation]),FALSE)","v":"Qualifiante"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Lieu de formation]),FALSE)","v":"LV 1"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Début]),FALSE)","v":"2020-05-11"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Fin]),FALSE)","v":"2020-05-13"},{"$f":"Journal_Suivi_Formation[[#This Row],[Date Fin]]-Journal_Suivi_Formation[[#This Row],[Date Début]]+1","v":3},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Coût de la formation]),FALSE)","v":1100},120,{"$f":"Journal_Suivi_Formation[[#This Row],[Coût de la formation]]+Journal_Suivi_Formation[[#This Row],[Coût frais du salarié]]","v":1220},"oui","2020-04-08",{"$f":"MAX(Journal_Suivi_Formation[[#This Row],[Date fin de validité]]-TODAY(),0)","v":0},{"$f":"IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=120,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>30),\"Attention date de validité moins de 4 mois\",IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=60,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>0),\"Attention date de validité moins de 2 mois\",IF(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=0,\"Date dépassée\",\"Valide \")))","v":"Date dépassée"}]
["M123461",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[Matricule]],Info_Salarie[],COLUMN(Info_Salarie[Nom / Prénom]),FALSE)","v":"redge"},"S001",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Formation]),FALSE)","v":"SST"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Sigle]),FALSE)","v":"SST"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Type de formation]),FALSE)","v":"Qualifiante"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Lieu de formation]),FALSE)","v":"LV 1"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Début]),FALSE)","v":"2020-05-11"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Fin]),FALSE)","v":"2020-05-13"},{"$f":"Journal_Suivi_Formation[[#This Row],[Date Fin]]-Journal_Suivi_Formation[[#This Row],[Date Début]]+1","v":3},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Coût de la formation]),FALSE)","v":1100},100,{"$f":"Journal_Suivi_Formation[[#This Row],[Coût de la formation]]+Journal_Suivi_Formation[[#This Row],[Coût frais du salarié]]","v":1200},"EN COURS","2020-04-15",{"$f":"MAX(Journal_Suivi_Formation[[#This Row],[Date fin de validité]]-TODAY(),0)","v":0},{"$f":"IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=120,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>30),\"Attention date de validité moins de 4 mois\",IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=60,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>0),\"Attention date de validité moins de 2 mois\",IF(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=0,\"Date dépassée\",\"Valide \")))","v":"Date dépassée"}]
["M123456",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[Matricule]],Info_Salarie[],COLUMN(Info_Salarie[Nom / Prénom]),FALSE)","v":"René"},"S003",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Formation]),FALSE)","v":"SSIAP"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Sigle]),FALSE)","v":"SSIAP"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Type de formation]),FALSE)","v":"Non Qualifiante"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Lieu de formation]),FALSE)","v":"LV 2"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Début]),FALSE)","v":"2020-04-28"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Fin]),FALSE)","v":"2020-04-30"},{"$f":"Journal_Suivi_Formation[[#This Row],[Date Fin]]-Journal_Suivi_Formation[[#This Row],[Date Début]]+1","v":3},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Coût de la formation]),FALSE)","v":1500},150,{"$f":"Journal_Suivi_Formation[[#This Row],[Coût de la formation]]+Journal_Suivi_Formation[[#This Row],[Coût frais du salarié]]","v":1650},"EN COURS","2020-04-08",{"$f":"MAX(Journal_Suivi_Formation[[#This Row],[Date fin de validité]]-TODAY(),0)","v":0},{"$f":"IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=120,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>30),\"Attention date de validité moins de 4 mois\",IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=60,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>0),\"Attention date de validité moins de 2 mois\",IF(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=0,\"Date dépassée\",\"Valide \")))","v":"Date dépassée"}]
["M123461",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[Matricule]],Info_Salarie[],COLUMN(Info_Salarie[Nom / Prénom]),FALSE)","v":"redge"},"S003",{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Formation]),FALSE)","v":"SSIAP"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Sigle]),FALSE)","v":"SSIAP"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Type de formation]),FALSE)","v":"Non Qualifiante"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Lieu de formation]),FALSE)","v":"LV 2"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Début]),FALSE)","v":"2020-04-28"},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Date Fin]),FALSE)","v":"2020-04-30"},{"$f":"Journal_Suivi_Formation[[#This Row],[Date Fin]]-Journal_Suivi_Formation[[#This Row],[Date Début]]+1","v":3},{"$f":"VLOOKUP(Journal_Suivi_Formation[[#This Row],[ID Session]],Listing_Formations[],COLUMN(Listing_Formations[Coût de la formation]),FALSE)","v":1500},100,{"$f":"Journal_Suivi_Formation[[#This Row],[Coût de la formation]]+Journal_Suivi_Formation[[#This Row],[Coût frais du salarié]]","v":1600},"EN COURS","2020-05-17",{"$f":"MAX(Journal_Suivi_Formation[[#This Row],[Date fin de validité]]-TODAY(),0)","v":20},{"$f":"IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=120,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>30),\"Attention date de validité moins de 4 mois\",IF(AND(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=60,Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]>0),\"Attention date de validité moins de 2 mois\",IF(Journal_Suivi_Formation[[#This Row],[Nombre de Jours Restants]]<=0,\"Date dépassée\",\"Valide \")))","v":"Attention date de validité moins de 2 mois"}]

{"sheet":"Planning Formation","index":4,"n_rows":78,"n_cols":367,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,0,3,0]]}
[2020]
["AVRIL",{"$f":"UPPER(TEXT(B3,\"mmmm\"))","v":"AVRIL"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(AG3,\"mmmm\"))","v":"MAI"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(BL3,\"mmmm\"))","v":"JUIN"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(CQ3,\"mmmm\"))","v":"JUILLET"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(DU3,\"mmmm\"))","v":"AOÛT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(EZ3,\"mmmm\"))","v":"SEPTEMBRE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(GD3,\"mmmm\"))","v":"OCTOBRE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(HI3,\"mmmm\"))","v":"NOVEMBRE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(IN3,\"mmmm\"))","v":"DÉCEMBRE"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(JQ3,\"mmmm\"))","v":"JANVIER"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(KV3,\"mmmm\"))","v":"FÉVRIER"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(TEXT(LZ3,\"mmmm\"))","v":"MARS"}]
["NOMS & Prénoms",{"$f":"DATE(Année_planning,MONTH(1&A2),1)","v":"2020-04-01"},{"$f":"B3+1","v":"2020-04-02"},"2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04",{"$f":"BN3+1","v":"2020-06-05"},"2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19","2020-06-20","2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29","2020-06-30","2020-07-01","2020-07-02","2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31","2020-08-01","2020-08-02","2020-08-03","2020-08-04","2020-08-05","2020-08-06","2020-08-07",{"$f":"DZ3+1","v":"2020-08-08"},"2020-08-09","2020-08-10","2020-08-11","2020-08-12","2020-08-13","2020-08-14","2020-08-15","2020-08-16","2020-08-17","2020-08-18","2020-08-19","2020-08-20","2020-08-21","2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10",{"$f":"GL3+1","v":"2020-10-11"},"2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11","2020-12-12","2020-12-13",{"$f":"IX3+1","v":"2020-12-14"},"2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30","2020-12-31","2021-01-01","2021-01-02","2021-01-03","2021-01-04","2021-01-05","2021-01-06","2021-01-07","2021-01-08","2021-01-09","2021-01-10","2021-01-11","2021-01-12","2021-01-13","2021-01-14","2021-01-15","2021-01-16","2021-01-17","2021-01-18","2021-01-19","2021-01-20","2021-01-21","2021-01-22","2021-01-23","2021-01-24","2021-01-25","2021-01-26","2021-01-27","2021-01-28","2021-01-29","2021-01-30","2021-01-31","2021-02-01","2021-02-02","2021-02-03","2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15",{"$f":"LJ3+1","v":"2021-02-16"},"2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28","2021-03-01","2021-03-02","2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07","2021-03-08","2021-03-09","2021-03-10","2021-03-11","2021-03-12","2021-03-13","2021-03-14","2021-03-15","2021-03-16","2021-03-17","2021-03-18","2021-03-19","2021-03-20","2021-03-21","2021-03-22","2021-03-23","2021-03-24","2021-03-25","2021-03-26","2021-03-27","2021-03-28","2021-03-29","2021-03-30","2021-03-31","2021-04-01"]
[null,{"$f":"B3","v":"2020-04-01"},"2020-04-02","2020-04-03","2020-04-04","2020-04-05","2020-04-06","2020-04-07","2020-04-08","2020-04-09","2020-04-10","2020-04-11","2020-04-12","2020-04-13","2020-04-14","2020-04-15","2020-04-16","2020-04-17","2020-04-18","2020-04-19","2020-04-20","2020-04-21","2020-04-22","2020-04-23","2020-04-24","2020-04-25","2020-04-26","2020-04-27","2020-04-28","2020-04-29","2020-04-30","2020-05-01","2020-05-02","2020-05-03","2020-05-04","2020-05-05","2020-05-06","2020-05-07","2020-05-08","2020-05-09","2020-05-10","2020-05-11","2020-05-12","2020-05-13","2020-05-14","2020-05-15","2020-05-16","2020-05-17","2020-05-18","2020-05-19","2020-05-20","2020-05-21","2020-05-22","2020-05-23","2020-05-24","2020-05-25","2020-05-26","2020-05-27","2020-05-28","2020-05-29","2020-05-30","2020-05-31","2020-06-01","2020-06-02","2020-06-03","2020-06-04","2020-06-05","2020-06-06","2020-06-07","2020-06-08","2020-06-09","2020-06-10","2020-06-11","2020-06-12","2020-06-13","2020-06-14","2020-06-15","2020-06-16","2020-06-17","2020-06-18","2020-06-19","2020-06-20","2020-06-21","2020-06-22","2020-06-23","2020-06-24","2020-06-25","2020-06-26","2020-06-27","2020-06-28","2020-06-29","2020-06-30","2020-07-01","2020-07-02","2020-07-03","2020-07-04","2020-07-05","2020-07-06","2020-07-07","2020-07-08","2020-07-09","2020-07-10","2020-07-11","2020-07-12","2020-07-13","2020-07-14","2020-07-15","2020-07-16","2020-07-17","2020-07-18","2020-07-19","2020-07-20","2020-07-21","2020-07-22","2020-07-23","2020-07-24","2020-07-25","2020-07-26","2020-07-27","2020-07-28","2020-07-29","2020-07-30","2020-07-31","2020-08-01","2020-08-02","2020-08-03","2020-08-04","2020-08-05","2020-08-06","2020-08-07","2020-08-08","2020-08-09","2020-08-10","2020-08-11","2020-08-12","2020-08-13","2020-08-14","2020-08-15","2020-08-16","2020-08-17","2020-08-18","2020-08-19","2020-08-20","2020-08-21","2020-08-22","2020-08-23","2020-08-24","2020-08-25","2020-08-26","2020-08-27","2020-08-28","2020-08-29","2020-08-30","2020-08-31","2020-09-01","2020-09-02","2020-09-03","2020-09-04","2020-09-05","2020-09-06","2020-09-07","2020-09-08","2020-09-09","2020-09-10","2020-09-11","2020-09-12","2020-09-13","2020-09-14","2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19","2020-09-20","2020-09-21","2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26","2020-09-27","2020-09-28","2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03","2020-10-04","2020-10-05","2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10","2020-10-11","2020-10-12","2020-10-13","2020-10-14","2020-10-15","2020-10-16","2020-10-17","2020-10-18","2020-10-19","2020-10-20","2020-10-21","2020-10-22","2020-10-23","2020-10-24","2020-10-25","2020-10-26","2020-10-27","2020-10-28","2020-10-29","2020-10-30","2020-10-31","2020-11-01","2020-11-02","2020-11-03","2020-11-04","2020-11-05","2020-11-06","2020-11-07","2020-11-08","2020-11-09","2020-11-10","2020-11-11","2020-11-12","2020-11-13","2020-11-14","2020-11-15","2020-11-16","2020-11-17","2020-11-18","2020-11-19","2020-11-20","2020-11-21","2020-11-22","2020-11-23","2020-11-24","2020-11-25","2020-11-26","2020-11-27","2020-11-28","2020-11-29","2020-11-30","2020-12-01","2020-12-02","2020-12-03","2020-12-04","2020-12-05","2020-12-06","2020-12-07","2020-12-08","2020-12-09","2020-12-10","2020-12-11",{"$f":"IW3","v":"2020-12-12"},"2020-12-13","2020-12-14","2020-12-15","2020-12-16","2020-12-17","2020-12-18","2020-12-19","2020-12-20","2020-12-21","2020-12-22","2020-12-23","2020-12-24","2020-12-25","2020-12-26","2020-12-27","2020-12-28","2020-12-29","2020-12-30","2020-12-31","2021-01-01","2021-01-02","2021-01-03","2021-01-04","2021-01-05","2021-01-06","2021-01-07","2021-01-08","2021-01-09","2021-01-10","2021-01-11","2021-01-12","2021-01-13","2021-01-14","2021-01-15","2021-01-16","2021-01-17","2021-01-18","2021-01-19","2021-01-20","2021-01-21","2021-01-22","2021-01-23","2021-01-24","2021-01-25","2021-01-26","2021-01-27","2021-01-28","2021-01-29","2021-01-30","2021-01-31","2021-02-01","2021-02-02","2021-02-03","2021-02-04","2021-02-05","2021-02-06","2021-02-07","2021-02-08","2021-02-09","2021-02-10","2021-02-11","2021-02-12","2021-02-13","2021-02-14","2021-02-15","2021-02-16","2021-02-17","2021-02-18","2021-02-19","2021-02-20","2021-02-21","2021-02-22","2021-02-23","2021-02-24","2021-02-25","2021-02-26","2021-02-27","2021-02-28","2021-03-01","2021-03-02","2021-03-03","2021-03-04","2021-03-05","2021-03-06","2021-03-07","2021-03-08","2021-03-09","2021-03-10","2021-03-11","2021-03-12","2021-03-13","2021-03-14","2021-03-15","2021-03-16","2021-03-17","2021-03-18","2021-03-19","2021-03-20","2021-03-21","2021-03-22","2021-03-23","2021-03-24","2021-03-25","2021-03-26","2021-03-27","2021-03-28","2021-03-29","2021-03-30","2021-03-31","2021-04-01"]
["René",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSIAP","SSIAP","SSIAP",null,null,null,null,null,null,null,null,null,null,"SST","SST","SST"]
["redge",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SSIAP","SSIAP","SSIAP",null,null,null,null,null,null,null,null,null,null,"SST","SST","SST"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CP","CP"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]
[0]
[0]
[0]
[0]

{"sheet":"Listing Formations","index":5,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"Listing Formations"]
[]
["Id Session","Formation","Sigle","Type de formation","Lieu de formation","Date Début","Date Fin","Durée","Coût de la formation"]
["S001","SST","SST","Qualifiante","LV 1","2020-05-11","2020-05-13",{"$f":"Listing_Formations[[#This Row],[Date Fin]]-Listing_Formations[[#This Row],[Date Début]]+1","v":3},1100]
["S002","SSIAP","SSIAP","Qualifiante","LV 3","2020-04-27","2020-04-30",{"$f":"Listing_Formations[[#This Row],[Date Fin]]-Listing_Formations[[#This Row],[Date Début]]+1","v":4},500]
["S003","SSIAP","SSIAP","Non Qualifiante","LV 2","2020-04-28","2020-04-30",{"$f":"Listing_Formations[[#This Row],[Date Fin]]-Listing_Formations[[#This Row],[Date Début]]+1","v":3},1500]

{"sheet":"Informations salariés","index":6,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,"Informations Salariés"]
[]
["Matricule","Nom / Prénom","Fonction","Date de prise de fonction","Ancienneté","Site","Adresse Mail","Numéro de Téléphone","Lien Photo"]
["M123456","René","CHEF DE SERVICE","2020-04-14","0 ans 0 mois 11 jours ","BQV","xxxxxxxxx","yy yy yy yy yy ","D:\\Documents\\Patrice\\Excel\\REGLAET\\boilly_1.JPG"]
["M123462","Gégé","CHEF DE SERVICE","2020-04-08",null,"PDS","xxxxxxxxxx","yy yy yy yy "]
["M123461","redge","AS","2020-04-15",{"$f":"datediff_ymd(Info_Salarie[[#This Row],[Date de prise de fonction]],TODAY())","v":"0 ans 0 mois 12 jours "},"PDS","fefe","05 65 70 19 65 "]
["M123460","eeee","AS","2017-06-07",{"$f":"datediff_ymd(Info_Salarie[[#This Row],[Date de prise de fonction]],TODAY())","v":"2 ans 10 mois 20 jours "},"BQV","eeee","05 65 18 48 47 "]
["M123459","popo","AS","2020-02-12",{"$f":"datediff_ymd(Info_Salarie[[#This Row],[Date de prise de fonction]],TODAY())","v":"0 ans 2 mois 15 jours "},"BQV","pip","op oi p"]

{"sheet":"GestionLISTE","index":7,"n_rows":34,"n_cols":44,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,3],[5,20,10,20],[11,20,21,20],[14,23,14,24],[22,20,30,20],[9,9,9,10]]}
[]
["Paramètre GMAO",null,null,null,null,"Liste Salarié",null,"Fonction",null,"Formations","Sigles",null,"Domaine Habilitation HT",null,"Formation Acquise",null,"Liste Site",null,"Type Formation",null,null,null,"Chemin pour Archivage Bon de Commande",null,"Chemin pour sauvegarde Image PhotosProduits",null,"Chemin pour sauvegarde Image interventions",null,"RechercheFournisseur","Ncol","Liste",null,"RechercheProduits","Ncol","Liste",null,"RechercheEntreSortie","Ncol","Liste",null,null,"RechercheCommande","Ncol","Liste"]
["Couleur de fond des userform Valeurs RGB",96,138,195,null,"Gégé",null,"AMP",null,"SST","SST",null,"HT1",null,"OUI",null,"BQV",null,"Qualifiante",null,null,null,"Q:\\Commun\\partage plan de maintenance\\Gestion Stock Lingerie\\Archivage Bon de Commandes",null,"Q:\\",null,"C:\\",null,"Entreprise",1,1,null,"Référence produit",1,7,null,"Référence interne",1,1,null,null,"N°Commande",1,7]
["MDP Admin",null,null,null,null,"Gérard",null,"AS",null,"SSIAP","SSIAP",null,"HT2",null,"NON",null,"PDS",null,"Non Qualifiante",null,null,null,null,null,"\\\\Commun\\partage plan de maintenance\\Gestion Stock Lingerie\\Photos Produits Lingerie",null,null,null,"activités",2,1,null,"Conditionnement",2,1,null,"Désignation",2,1,null,null,"Saisi Par",2,7]
["Sauvegarde pour multi utilisateur 1=Yes 2=No",1,null,null,null,"René",null,"ASI",null,"Hablitation électrique","HELEC",null,"FIN",null,"EN COURS",null,"FIN",null,"Habilitation",null,"A LIRE",null,null,null,null,null,null,null,"Adresse",3,3,null,"Dosage ",3,1,null,"Type",3,1,null,null,"Réf Produit",3,1]
["MDP Affichage feuille Parc",null,null,null,null,"FIN",null,"IDE",null,"AS","AS",null,null,null,"PARTIELLEMENT",null,null,null,"FIN",null,"Les données Verte peuvent etre supprimer et modifier ou ajouter meme si les Base de Données sont rempli ",null,null,null,null,null,"Chemin pour sauvegarde Image preventif",null,"Code postal",4,1,null,"Descriptif",4,3,null,"Date E/S",4,4,null,null,"Conditionnement ",4,1]
["Liste intervenant",3,null,null,null,null,null,"CHEF DE SERVICE",null,"AMP","AMP",null,null,null,"FIN",null,null,null,null,null,null,null,null,null,null,null,"C:\\",null,"Boite postale",5,1,null,"Péremption",5,1,null,"Qté",5,5,null,null,"Dosage",5,1]
["Selection ligne sur BD, 1= ok , autres = noOk",1,null,null,null,null,null,"DIRECTEUR",null,"Gestion de la douleur","GDOUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ville",6,1,null,"Lieux",6,1,null,"Lieux",6,1,null,null,"Fournisseur",6,1]
["blocage des touches 1= ok , autres = noOk","noOK",null,null,null,null,null,"FIN",null,"Hygiène dentaire","HDENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pays",7,1,null,"Fournisseur1",7,1,null,null,null,null,null,null,"Réf Fournisseur",7,1]
["mot de passe pour supression interventions",null,null,null,null,null,null,null,null,"FIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contact",8,3,null,"Reference F1",8,1,null,null,null,null,null,null,"Prix Unitaire",8,5]
["mot de passe pour supression preventif",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Email",9,3,null,"Delais F1",9,1,null,null,null,null,null,null,"Quantité",9,5]
["mot de passe pour supression fournisseur",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les données ORANGE sont des listes utilisées dans tout le classeur .\nVous pouvez ajouter et ou modifier les valeurs,\nCependant ne pas les suprimmer une fois les Base de Données rempli car des problèmes risque d'arrivé",null,null,null,null,null,null,null,"Tel.",10,3,null,"Prix unitaire F1",10,5,null,null,null,null,null,null,"Date de commande",10,4]
["mot de passe pour supression produit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fax",11,3,null,"Fournisseur 2",11,1,null,null,null,null,null,null,"Date de livraison prévue",11,4]
["mot de passe pour supression commande",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Site",12,3,null,"Reference F2",12,1,null,null,null,null,null,null,"Date de réception",12,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Permet de définir les type de recherche (col N3)",null,null,null,null,"Nom C1",13,3,null,"Delais F2",13,1,null,null,null,null,null,null,"Etat",13,7]
["Modif Désignation des pièces 1= ok , autres = noOk",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N°","Liste Recherche",null,null,null,"Fonction C1",14,3,null,"Prix unitaire F2",14,5]
["Choix référence interne  1= ok , autres = noOk",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Liste suivant feuille",null,null,null,"Tel C1",15,3,null,"Stock",15,5]
["Coéfficient multiplicateur  Stock Mini pour Commande",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"ListeRange",null,null,null,"Email C1",16,3,null,"Stock Min",16,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"SansListe",null,null,null,"Nom C2",17,3,null,"Produit à commander",17,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lieux",null,null,null,null,null,null,4,"Date",null,null,null,"Fonction C2",18,3,null,"Coût stock",18,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 1",null,null,null,null,null,null,5,"Numerique",null,null,null,"Tel C2",19,3,null,"Lieu de stockage",19,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 2",null,null,null,null,null,null,6,"Lieux",null,null,null,"Email C2",20,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 3",null,null,null,"Les données Bleu corresponde à des listes qui sont utilisées pour la fonction recherche (Voir collone T , cela explique les types de listes)",null,null,7,"Liste case à cocher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 4",null,null,null,null,null,null,null,"MEMO VBAListe de recherche définit :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LV 5",null,null,null,null,null,null,null,"RechercheFournisseur X2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Séjour",null,null,null,null,null,null,null,"RecherchePieces AB2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Infirmerie",null,null,null,null,null,null,null,"RechercheEntreSortie AF2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Piscine",null,null,null,null,null,null,null,"Recherche Preventif P AJ2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Snoezelen",null,null,null,null,null,null,null,"RechercheCommande AN2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Secrétariat",null,null,null,null,null,null,null,"Recherche Interventions AR3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BIP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cuisine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lingerie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FIN"]

{"sheet":"Contacts","index":8,"n_rows":176,"n_cols":20,"rows_kept":176,"cut":false,"hidden":false,"merged":[]}
[]
["Entreprise","activités","Adresse","Code postal","Boite postale","Ville","Pays","Contact","Email","Tel.","Fax","Site","Nom C1","Fonction C1","Tel C1","Email C1","Nom C2","Fonction C2","Tel C2","Email C2"]
["GROUPE PIERRE LE GOFF-SUD-OUEST","Produits d'entretien","22,rue Saint Exupéry\r\nParc d'activités des Lacs","33295","","BLANQUEFORT","FRANCE","ALVES JEAN-CLAUDE","","","","https://www.groupeplg.com","NATHALIE J","","05 57 10 61 07","","","","",""]
["STANDARD TEXTILE","Lingeire Collective","85, Avenue de l'industrie","69142","CS 90230","RILLIEUX LA PAPE ","FRANCE","04 72 47 17 55","","","","www.standard-textile.fr","Nadine Marquez","Conseiller commercial sédentaire ","","nmarquez@standardtextile.com","","","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]
[null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,"","",""]