{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["BD","Listes contrats","10","20","30","40","50","60","70","80","90"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"BD","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Liste des onglets"]
[{"$f":"TRANSPOSE(Liste_onglets)","v":"BD"},"Voici la source de la liste déroulante de l'onglet \"Listes contrats\" pour la selection de l'Employé N°1, Employé N°2, etc."]
["Listes contrats","La source ci-jointe se met à jour selon les onglets (presque automatique car je dois à chaque fois revalider la fonction avec la touche ENTER"]
["10"]
["20"]
["30"]
["40"]
["50"]
["60"]
["70"]
["80"]
["90"]

{"sheet":"Listes contrats","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"La tableau ci-dessous servira de liste de tous les clients. Les données actuelles sont des exemples afin de remplir le tableau.",null,null,null,null,null,null,null,"Cette partie servira à la selection des employés à qui sera attribué le client."]
[null,null,null,null,null,null,null,null,null,"Chacun de ces employés a un onglet qui lui est propre, répertoriant chaque client sur lequel il est indiqué."]
["N°","Client","Adresse","Lieu","Type","Jour d'intervenion","SP  SI","Temps par semaine","Horaire / Remarques","Employé 1","Employé 2","Employé 3","Employé 4","Employé 5"]
[1111,"Client 1","Adresse client 1","Lieu client 1","P","Lundi","SP",2]
[2222,"Client 2","Adresse client 2","Lieu client 2","P","Mardi","SI",2]
[3333,"Client 3","Adresse client 3","Lieu client 3","P","Mercredi","SP",2]
[4444,"Client 4","Adresse client 4","Lieu client 4","P","Jeudi","SI",2]
[5555,"Client 5","Adresse client 5","Lieu client 5","P","Vendredi","SP",2]
[6666,"Client 6","Adresse client 6","Lieu client 6","P","Lundi","SI",2]
[7777,"Client 7","Adresse client 7","Lieu client 7","P","Mardi","SP",2]
[8888,"Client 8","Adresse client 8","Lieu client 8","P","Mercredi","SI",2]
[9999,"Client 9","Adresse client 9","Lieu client 9","P","Jeudi","SP",2]
[101010,"Client 10","Adresse client 10","Lieu client 10","P","Vendredi","SI",2]
[111111,"Client 11","Adresse client 11","Lieu client 11","P","Lundi","SP",2]
[121212,"Client 12","Adresse client 12","Lieu client 12","P","Mardi","SI",2]
[131313,"Client 13","Adresse client 13","Lieu client 13","P","Mercredi","SP",2]
[141414,"Client 14","Adresse client 14","Lieu client 14","P","Jeudi","SI",2]
[151515,"Client 15","Adresse client 15","Lieu client 15","P","Vendredi","SP",2]
[161616,"Client 16","Adresse client 16","Lieu client 16","P","Lundi","SI",2]
[171717,"Client 17","Adresse client 17","Lieu client 17","P","Mardi","SP",2]
[181818,"Client 18","Adresse client 18","Lieu client 18","P","Mercredi","SI",2]
[191919,"Client 19","Adresse client 19","Lieu client 19","P","Jeudi","SP",2]
[202020,"Client 20","Adresse client 20","Lieu client 20","P","Vendredi","SI",2]
[212121,"Client 21","Adresse client 21","Lieu client 21","P","Lundi","SP",2]
[222222,"Client 22","Adresse client 22","Lieu client 22","P","Mardi","SI",2]
[232323,"Client 23","Adresse client 23","Lieu client 23","P","Mercredi","SP",2]
[242424,"Client 24","Adresse client 24","Lieu client 24","P","Jeudi","SI",2]
[252525,"Client 25","Adresse client 25","Lieu client 25","P","Vendredi","SP",2]
[262626,"Client 26","Adresse client 26","Lieu client 26","P","Lundi","SI",2]
[272727,"Client 27","Adresse client 27","Lieu client 27","P","Mardi","SP",2]
[282828,"Client 28","Adresse client 28","Lieu client 28","P","Mercredi","SI",2]
[292929,"Client 29","Adresse client 29","Lieu client 29","P","Jeudi","SP",2]
[303030,"Client 30","Adresse client 30","Lieu client 30","P","Vendredi","SI",2]

{"sheet":"10","index":2,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa","Je souhaiterait que la date soit mise à jour selon la dernière modification pour l'employé en question"]
[10,"Employé A","Employé A","Ville A"]
[null,"Les données de l'employé sont remplies manuellement"]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"20","index":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[20,"Employé B","Employé B","Ville B"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"30","index":4,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[30,"Employé C","Employé C","Ville C"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"40","index":5,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[40,"Employé D","Employé D","Ville D"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"50","index":6,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[50,"Employé E","Employé E","Ville E"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"60","index":7,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[60,"Employé F","Employé F","Ville F"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"70","index":8,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[70,"Employé G","Employé G","Ville G"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"80","index":9,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[80,"Employé H","Employé H","Ville H"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]

{"sheet":"90","index":10,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["N°","Nom","Prénom","Domicile",null,"Dernière modification le","jj.mm.aaaa"]
[90,"Employé I","Employé I","Ville I"]
[]
[]
["N°","Client","Adresse","Lieu","Type","Jour","SP  SI","Temps par semaine","Horaire / Remarques"]