{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["COORDONNEES CENTRES","VM REIMS","VM TROYES","CdC"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"COORDONNEES CENTRES","index":0,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["LOCALISATION","NOM DU CENTRE","N°ADHERENT","CONTACT","ADRESSE","CP - VILLE","TEL 1 ","TEL 2 ","MAIL "]

{"sheet":"VM REIMS","index":1,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,2,7],[58,0,58,1]]}
["SUIVI DES VISITES MEDICALES\n"]
[]
[]
[]
["CDP","NOM","Prénom","Dernière visite","Particularité","Prochaine visite avant le :","Relance  \nM-2","Centre de Médecine"]
[110,"REIMS","Prenom","2015-06-17",0,"2017-10-16",null,"Mail du centre",null,{"$f":"IF(E6=0,(D6+1825),(D6+730))","v":"2020-06-15"}]
[110,"REIMS","Prenom","2015-06-12",0,"2017-10-16",null,"Mail du centre"]
[110,null,null,"2016-11-07",0,{"$f":"IF(E8=0,(D8+1825),(D8+730))","v":"2021-11-06"},null,"Mail du centre"]
[110,null,null,"2016-11-25",0,"2021-11-24",null,"Mail du centre"]
[110,null,null,"2013-12-02",0,"2018-12-01",null,"Mail du centre"]
[110,null,null,"2015-04-07",0,"2020-04-05",null,"Mail du centre"]
[110,null,null,"2013-11-28",0,"2018-11-27",null,"Mail du centre"]
[110,null,null,"2015-06-08","VM renforcée","2017-06-07",null,"Mail du centre"]
[116,null,null,"2017-04-20",0,"2022-04-19"]
[116,null,null,"2016-02-16",0,"2021-02-14"]
[116,null,null,"2017-04-21",0,"2022-04-20"]
[116,null,null,"2016-01-29",0,"2021-01-27"]
[311,null,null,"2017-04-27",0,"2022-04-26"]
[311,null,null,"2016-05-12",0,"2021-05-11"]
[311,null,null,"2016-11-23",0,"2021-11-22"]
[311,null,null,"2017-04-06",0,"2022-04-05"]
[311,null,null,"2016-08-29",0,"2021-08-28"]
[311,null,null,"2017-06-16",0,"2022-06-15"]
[311,null,null,"2017-01-12",0,"2022-01-11"]
[311,null,null,"2016-07-21",0,"2021-07-20"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,null,0]
[311,null,null,"2016-11-23",0,"2021-11-22"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,"2016-11-17",0,"2021-11-16"]
[311,null,null,"2016-06-07",0,"2021-06-06"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,"2015-11-02",0,"2020-10-31"]
[343,null,null,null,0]
[343,null,null,"2016-11-24",0,"2021-11-23"]
[343,null,null,"2015-12-11",0,"2020-12-09"]
[343,null,null,"2017-04-21",0,"2022-04-20"]
[343,null,null,"2017-03-30",0,"2022-03-29"]
[343,null,null,"2016-11-24",0,"2021-11-23"]
[2013,null,null,"2017-04-13",0,"2022-04-12"]
[2013,null,null,"2016-09-08",0,"2021-09-07"]
[2013,null,null,"2017-04-03",0,"2022-04-02"]
[2013,null,null,"2017-06-10",0,"2022-06-09"]
[6751,null,null,null,0]
[6751,null,null,"2016-11-07",0,"2021-11-06"]
[6751,null,null,"2016-02-16",0,"2021-02-14"]
[6751,null,null,"2017-01-17",0,"2022-01-16"]
[6751,null,null,"2016-11-22",0,"2021-11-21"]
[6751,null,null,"2015-10-15",0,"2020-10-13"]
[6751,null,null,"2013-09-27",0,"2018-09-26"]
[6751,null,null,"2014-09-23",0,"2019-09-22"]
[6751,null,null,"2016-09-05",0,"2021-09-04"]
[6751,null,null,null,0,"1904-12-29"]
[6751,null,null,"2016-06-10",0,"2021-06-09"]
[6951,null,null,"2016-09-17",0,"2021-09-16"]
[6951,null,null,"2016-06-02",0,"2021-06-01"]
[311,null,null,"2015-04-16",0,"2020-04-14"]
[]
["Suivi médical renforcée 2 ans"]

{"sheet":"VM TROYES","index":2,"n_rows":59,"n_cols":10,"rows_kept":59,"cut":false,"hidden":false,"merged":[[0,0,2,7],[58,0,58,1]]}
["SUIVI DES VISITES MEDICALES\n"]
[]
[]
[]
["CDP","NOM","Prénom","Dernière visite","Particularité","Prochaine visite avant le :","Relance  \nM-2","Centre de Médecine"]
[110,"TROYES","Prenom","2015-06-17",0,"2017-10-16",null,"Mail du centre",null,{"$f":"IF(E6=0,(D6+1825),(D6+730))","v":"2020-06-15"}]
[110,"TROYES","Prenom","2015-06-12",0,"2017-10-16",null,"Mail du centre"]
[110,null,null,"2016-11-07",0,{"$f":"IF(E8=0,(D8+1825),(D8+730))","v":"2021-11-06"},null,"Mail du centre"]
[110,null,null,"2016-11-25",0,"2021-11-24",null,"Mail du centre"]
[110,null,null,"2013-12-02",0,"2018-12-01",null,"Mail du centre"]
[110,null,null,"2015-04-07",0,"2020-04-05",null,"Mail du centre"]
[110,null,null,"2013-11-28",0,"2018-11-27",null,"Mail du centre"]
[110,null,null,"2015-06-08","VM renforcée","2017-06-07",null,"Mail du centre"]
[116,null,null,"2017-04-20",0,"2022-04-19"]
[116,null,null,"2016-02-16",0,"2021-02-14"]
[116,null,null,"2017-04-21",0,"2022-04-20"]
[116,null,null,"2016-01-29",0,"2021-01-27"]
[311,null,null,"2017-04-27",0,"2022-04-26"]
[311,null,null,"2016-05-12",0,"2021-05-11"]
[311,null,null,"2016-11-23",0,"2021-11-22"]
[311,null,null,"2017-04-06",0,"2022-04-05"]
[311,null,null,"2016-08-29",0,"2021-08-28"]
[311,null,null,"2017-06-16",0,"2022-06-15"]
[311,null,null,"2017-01-12",0,"2022-01-11"]
[311,null,null,"2016-07-21",0,"2021-07-20"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,null,0]
[311,null,null,"2016-11-23",0,"2021-11-22"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,"2016-11-17",0,"2021-11-16"]
[311,null,null,"2016-06-07",0,"2021-06-06"]
[311,null,null,"2015-10-15",0,"2020-10-13"]
[311,null,null,"2015-11-02",0,"2020-10-31"]
[343,null,null,null,0]
[343,null,null,"2016-11-24",0,"2021-11-23"]
[343,null,null,"2015-12-11",0,"2020-12-09"]
[343,null,null,"2017-04-21",0,"2022-04-20"]
[343,null,null,"2017-03-30",0,"2022-03-29"]
[343,null,null,"2016-11-24",0,"2021-11-23"]
[2013,null,null,"2017-04-13",0,"2022-04-12"]
[2013,null,null,"2016-09-08",0,"2021-09-07"]
[2013,null,null,"2017-04-03",0,"2022-04-02"]
[2013,null,null,"2017-06-10",0,"2022-06-09"]
[6751,null,null,null,0]
[6751,null,null,"2016-11-07",0,"2021-11-06"]
[6751,null,null,"2016-02-16",0,"2021-02-14"]
[6751,null,null,"2017-01-17",0,"2022-01-16"]
[6751,null,null,"2016-11-22",0,"2021-11-21"]
[6751,null,null,"2015-10-15",0,"2020-10-13"]
[6751,null,null,"2013-09-27",0,"2018-09-26"]
[6751,null,null,"2014-09-23",0,"2019-09-22"]
[6751,null,null,"2016-09-05",0,"2021-09-04"]
[6751,null,null,null,0,"1904-12-29"]
[6751,null,null,"2016-06-10",0,"2021-06-09"]
[6951,null,null,"2016-09-17",0,"2021-09-16"]
[6951,null,null,"2016-06-02",0,"2021-06-01"]
[311,null,null,"2015-04-16",0,"2020-04-14"]
[]
["Suivi médical renforcée 2 ans"]

{"sheet":"CdC","index":3,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Alerte Excel / Outlook"]
[]
[null,null,null,"Morganepgnz - 17 août 2017 à 09:13 - Dernière réponse le 17 août 2017 à 13:56 par Morganepgnz"]
[null,null,null,"Ne plus suivre"]
[null,null,null,"Bonjour,"]
[]
[null,null,null,"Je suis actuellement en BTS Assistante de Gestion alternance."]
[null,null,null,"Dans le cadre d'un projet d'amélioration de l'entreprise, j'ai décidé de créer un suivi des visites médicales sous Excel 2010."]
[]
[null,null,null,"Je souhaite élaborer une alerte de relance 2 mois avant la prochaine visite médicale (pour rester dans les clous) qui sera transmise directement sur mon adresse mail Outlook (pour ne pas aller tous les jours sur le fichier)."]
[]
[]
[null,null,null,"Vous trouverez ci joint une partie du fichier des visites médicales."]
[null,null,null,"Je vous remercie par avance de votre retour."]
[]
[null,null,null,"Bien cordialement."]
[null,null,null,"Morgane."]