{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Carte","DATA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Carte","index":0,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"k"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Les ronds rouges sont déplacables et copiables à volonté"]

{"sheet":"DATA","index":1,"n_rows":97,"n_cols":10,"rows_kept":97,"cut":false,"hidden":false,"merged":[]}
["Départ",null,null,null,null,null,"Commercial 1"]
[null,"Ain ","01","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 2",null,null,"Entrer les noms des commerciaux en Col G"]
[null,"Allier ","03","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 3",null,null,"Puis attribuer les départements par choix dans liste déroulante  en E"]
[null,"Ardèche ","07","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 4"]
[null,"Cantal ","15","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 5",null,null,"Modifier à sa guise les couleurs en col H"]
[null,"Drôme ","26","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 6"]
[null,"Isère ","38","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 7"]
[null,"Loire ","42","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 8"]
[null,"Haute-Loire ","43","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 9"]
[null,"Puy-de-Dôme ","63","Auvergne-Rhône-Alpes","Commercial 1",null,"Commercial 10"]
[null,"Rhône ","69","Auvergne-Rhône-Alpes","Commercial 1"]
[null,"Savoie ","73","Auvergne-Rhône-Alpes","Commercial 1"]
[null,"Haute-Savoie ","74","Auvergne-Rhône-Alpes","Commercial 1"]
[null,"Côte-d'Or ","21","Bourgogne-Franche-Comté","Commercial 4",null,"Raccourci clavier Ctrl + k pour lancer la macro colorer pour mise à jour de la carte"]
[null,"Doubs ","25","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Jura ","39","Bourgogne-Franche-Comté","Commercial 4",null,"Cliquer sur le nom de l'onglet en bas puis Visualiser le code pour ouvrir éditeur VBA et aller dans Module 1 pour voir le code commenté"]
[null,"Nièvre ","58","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Haute-Saône ","70","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Saône-et-Loire ","71","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Yonne ","89","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Territoire-de-Belfort ","90","Bourgogne-Franche-Comté","Commercial 4"]
[null,"Côtes d'Armor ","22","Bretagne","Commercial 2"]
[null,"Finistère ","29","Bretagne","Commercial 2"]
[null,"Île-et-Vilaine ","35","Bretagne","Commercial 2"]
[null,"Morbihan ","56","Bretagne","Commercial 2"]
[null,"Cher ","18","Centre-Val de Loire","Commercial 6"]
[null,"Eure-et-Loir ","28","Centre-Val de Loire","Commercial 6"]
[null,"Indre ","36","Centre-Val de Loire","Commercial 6"]
[null,"Indre-et-Loire ","37","Centre-Val de Loire","Commercial 6"]
[null,"Loir-et-Cher ","41","Centre-Val de Loire","Commercial 6"]
[null,"Loiret ","45","Centre-Val de Loire","Commercial 6"]
[null,"Corse-du-Sud","2A","Corse","Commercial 3"]
[null,"Haute-Corse","2B","Corse","Commercial 3"]
[null,"Ardennes ","08","Grand Est","Commercial 4"]
[null,"Aube ","10","Grand Est","Commercial 4"]
[null,"Marne ","51","Grand Est","Commercial 4"]
[null,"Haute-Marne ","52","Grand Est","Commercial 4"]
[null,"Meurthe-et-Moselle ","54","Grand Est","Commercial 4"]
[null,"Meuse ","55","Grand Est","Commercial 4"]
[null,"Moselle ","57","Grand Est","Commercial 4"]
[null,"Bas-Rhin ","67","Grand Est","Commercial 10"]
[null,"Haut-Rhin ","68","Grand Est","Commercial 10"]
[null,"Vosges ","88","Grand Est","Commercial 4"]
[null,"Aisne ","02","Hauts-de-France","Commercial 5"]
[null,"Nord ","59","Hauts-de-France","Commercial 5"]
[null,"Oise ","60","Hauts-de-France","Commercial 5"]
[null,"Pas-de-Calais ","62","Hauts-de-France","Commercial 5"]
[null,"Somme ","80","Hauts-de-France","Commercial 5"]
[null,"Seine-et-Marne ","77","Île-de-France","Commercial 5"]
[null,"Yvelines ","78","Île-de-France","Commercial 5"]
[null,"Essonne ","91","Île-de-France","Commercial 5"]
[null,"Val-d'Oise","95","Île-de-France","Commercial 5"]
[null,"Paris ","175","Île-de-France","Commercial 5"]
[null,"Hauts-de-Seine ","192","Île-de-France","Commercial 5"]
[null,"Seine-Saint-Denis","193","Île-de-France","Commercial 5"]
[null,"Val-de-Marne",194,"Île-de-France","Commercial 5"]
[null,"Calvados ","14","Normandie","Commercial 2"]
[null,"Eure ","27","Normandie","Commercial 2"]
[null,"Manche ","50","Normandie","Commercial 2"]
[null,"Orne ","61","Normandie","Commercial 8"]
[null,"Seine-Maritime ","76","Normandie","Commercial 2"]
[null,"Charente ","16","Nouvelle-Aquitaine","Commercial 9"]
[null,"Charente-Maritime ","17","Nouvelle-Aquitaine","Commercial 9"]
[null,"Corrèze ","19","Nouvelle-Aquitaine","Commercial 9"]
[null,"Creuse ","23","Nouvelle-Aquitaine","Commercial 9"]
[null,"Dordogne ","24","Nouvelle-Aquitaine","Commercial 9"]
[null,"Gironde ","33","Nouvelle-Aquitaine","Commercial 9"]
[null,"Landes ","40","Nouvelle-Aquitaine","Commercial 9"]
[null,"Lot-et-Garonne ","47","Nouvelle-Aquitaine","Commercial 9"]
[null,"Pyrénées-Atlantiques ","64","Nouvelle-Aquitaine","Commercial 9"]
[null,"Deux-Sèvres ","79","Nouvelle-Aquitaine","Commercial 9"]
[null,"Vienne ","86","Nouvelle-Aquitaine","Commercial 9"]
[null,"Haute-Vienne ","87","Nouvelle-Aquitaine","Commercial 9"]
[null,"Ariège ","09","Occitanie","Commercial 7"]
[null,"Aude ","11","Occitanie","Commercial 7"]
[null,"Aveyron ","12","Occitanie","Commercial 7"]
[null,"Gard ","30","Occitanie","Commercial 7"]
[null,"Haute-Garonne ","31","Occitanie","Commercial 7"]
[null,"Gers ","32","Occitanie","Commercial 7"]
[null,"Hérault ","34","Occitanie","Commercial 7"]
[null,"Lot ","46","Occitanie","Commercial 7"]
[null,"Lozère ","48","Occitanie","Commercial 7"]
[null,"Hautes-Pyrénées ","65","Occitanie","Commercial 7"]
[null,"Pyrénées-Orientales ","66","Occitanie","Commercial 7"]
[null,"Tarn ","81","Occitanie","Commercial 7"]
[null,"Tarn-et-Garonne ","82","Occitanie","Commercial 7"]
[null,"Loire-Atlantique ","44","Pays de la Loire","Commercial 8"]
[null,"Maine-et-Loire ","49","Pays de la Loire","Commercial 8"]
[null,"Mayenne ","53","Pays de la Loire","Commercial 8"]
[null,"Sarthe ","72","Pays de la Loire","Commercial 8"]
[null,"Vendée ","85","Pays de la Loire","Commercial 8"]
[null,"Alpes de Haute-Provence ","04","Provence-Alpes-Côte d'Azur","Commercial 3"]
[null,"Hautes-Alpes ","05","Provence-Alpes-Côte d'Azur","Commercial 3"]
[null,"Alpes-Maritimes ","06","Provence-Alpes-Côte d'Azur","Commercial 3"]
[null,"Bouches-du-Rhône ","13","Provence-Alpes-Côte d'Azur","Commercial 3"]
[null,"Var ","83","Provence-Alpes-Côte d'Azur","Commercial 3"]
[null,"Vaucluse ","84","Provence-Alpes-Côte d'Azur","Commercial 3"]