{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Planning 2023","Résumé","Congés","Feuil2","Résumé (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"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":"Planning 2023","index":0,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"IF(ISNA(VLOOKUP(B2,congés,2,FALSE)),\"-\",VLOOKUP(B2,congés,2,FALSE))","v":"Congé"},{"$f":"B1","v":"Congé"},{"$f":"B1","v":"Congé"},{"$f":"B1","v":"Congé"},{"$f":"IF(ISNA(VLOOKUP(F2,congés,2,FALSE)),\"-\",VLOOKUP(F2,congés,2,FALSE))","v":"-"},{"$f":"F1","v":"-"},{"$f":"F1","v":"-"},{"$f":"F1","v":"-"},{"$f":"IF(ISNA(VLOOKUP(J2,congés,2,FALSE)),\"-\",VLOOKUP(J2,congés,2,FALSE))","v":"-"},{"$f":"J1","v":"-"},{"$f":"J1","v":"-"},{"$f":"J1","v":"-"},{"$f":"IF(ISNA(VLOOKUP(N2,congés,2,FALSE)),\"-\",VLOOKUP(N2,congés,2,FALSE))","v":"-"},{"$f":"N1","v":"-"},{"$f":"N1","v":"-"},{"$f":"N1","v":"-"}]
[null,"2023-01-06",null,null,null,"2023-01-09",null,null,null,"2023-01-10",null,null,null,"2023-01-11"]
["Agents","Véhicule","Chronos","Chantier","Adresse","Véhicule","Chronos","Chantier","Adresse","Véhicule","Chronos","Chantier","Adresse","Véhicule","Chronos","Chantier","Adresse"]
["Olivier B",null,null,null,null,"Porsche",123456,"2525/2525","Circuit Francorchamp","Porsche",789345,"8787/9526","Circuit Croix en Ternois","Porsche",7419654,"7419/8523","Circuit Folembray"]
[]
[]
[]
["Yves",null,null,null,null,"Bugatti",789345,"8787/9526","Circuit Croix en Ternois","Bugatti",123456,"2525/2525","Circuit Francorchamp","Bugatti",7419654,"7419/8523","Circuit Folembray"]
[]
[]
[]
["Fonzy",null,null,null,null,"Maserati",123456,"2525/2525","Circuit Francorchamp","Maserati",789345,"8787/9526","Circuit Croix en Ternois","Maserati",7419654,"7419/8523","Circuit Folembray"]
[]
[]
[]
["Johnny",null,null,null,null,"Lamborghini",123456,"2525/2525","Circuit Francorchamp","Lamborghini",789345,"8787/9526","Circuit Croix en Ternois","Lamborghini",7419654,"7419/8523","Circuit Folembray"]
[]
[]
[]
["Jean-Pierre",null,null,null,null,"Mc Laren",789345,"8787/9526","Circuit Croix en Ternois","Mc Laren",123456,"2525/2525","Circuit Francorchamp","Mc Laren",7419654,"7419/8523","Circuit Folembray"]

{"sheet":"Résumé","index":1,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,3,2,3]]}
[null,null,null,"Date"]
[null,null,null,"2023-01-09"]
[]
[]
["Agents","Véhicule","Chronos","Chantier","Adresse",null,"Planning",{"$f":"D2","v":"2023-01-09"}]
[null,null,null,null,null,null,"Equipes","Véhicules","Code","Chantier","Adresse","Remarques"]
[null,null,null,null,null,null,"Olivier B",{"$f":"B8","v":0},{"$f":"C8","v":0},{"$f":"D8","v":0},{"$f":"E6","v":0},"Qualifications"]
[null,null,null,null,null,null,"Fonzy",{"$f":"B16","v":0}]
[null,null,null,null,null,null,"Johnny",{"$f":"B20","v":0}]
[null,null,null,null,null,null,{"$f":"A12","v":0},{"$f":"B12","v":0},{"$f":"C12","v":0},{"$f":"D12","v":0},{"$f":"E10","v":0},"Course"]
[null,null,null,null,null,null,{"$f":"A24","v":0},{"$f":"B24","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I21=0,\"\",CONCATENATE(VLOOKUP(I21,'[2]1847-1949-3347-3581'!$C:$I,6,FALSE),\"  \",VLOOKUP(I21,'[2]1847-1949-3347-3581'!$C:$I,7,FALSE)))","v":""}]

{"sheet":"Congés","index":2,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["2023-01-02","Congé"]
["2023-01-03","Congé"]
["2023-01-04","Congé"]
["2023-01-05","Congé"]
["2023-01-06","Congé"]
["2023-04-10","Congé"]
["2023-04-11","Congé"]
["2023-04-12","Congé"]
["2023-04-13","Congé"]
["2023-04-14","Congé"]
["2023-05-01","Congé"]
["2023-05-18","Congé"]
["2023-05-19","Congé"]
["2023-05-29","Congé"]
["2023-07-17","Congé"]
["2023-07-18","Congé"]
["2023-07-19","Congé"]
["2023-07-20","Congé"]
["2023-07-21","Congé"]
["2023-07-24","Congé"]
["2023-07-25","Congé"]
["2023-07-26","Congé"]
["2023-07-27","Congé"]
["2023-07-28","Congé"]
["2023-07-31","Congé"]
["2023-08-01","Congé"]
["2023-08-02","Congé"]
["2023-08-03","Congé"]
["2023-08-04","Congé"]
["2023-08-14","Congé"]
["2023-08-15","Congé"]
["2023-10-30","Congé"]
["2023-10-31","Congé"]
["2023-11-01","Congé"]
["2023-11-02","Congé"]
["2023-11-03","Congé"]
["2023-12-25","Congé"]
["2023-12-26","Congé"]
["2023-12-27","Congé"]
["2023-12-28","Congé"]
["2023-12-29","Congé"]
["2024-01-01","Congé"]
["2024-01-02","Congé"]
["2024-01-03","Congé"]
["2024-01-04","Congé"]
["2024-01-05","Congé"]

{"sheet":"Feuil2","index":3,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Samahome"]
[null,null,"6 janv. 2023 à 10:14"]
[null,null,"Bonjour,"]
[null,null,"Voici comme demandé"]
[null,null,"https://www.cjoint.com/c/MAgi7bNizgG"]
[null,null,"j'ai minimisé le fichier au max pour simplifier (les datas sont fictives bien sur ;))"]
[null,null,"En bref, j'aimerai en indiquant une date dans l'onglet \"Résumé\" (D:2) importer les données du \"Planning 2023\" en dessous de la date de référence et regrouper les données de ce tableau par équipes (je l'ai fait manuellement dans le classeur pour montrer le résultat souhaité)"]
[null,null,"Pour l'instant je \"m'amuse\" avec des copy/paste mais je gagnerai pas mal de temps avec une petite macro"]
[null,null,"Merci d'avance pour votre aide :-)"]

{"sheet":"Résumé (2)","index":4,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,3,2,3]]}
[null,null,null,"Date"]
[null,null,null,"2023-01-09"]
[]
[]
["Agents","Véhicule","Chronos","Chantier","Adresse",null,"Planning",{"$f":"D2","v":"2023-01-09"}]
["Olivier B","Porsche",123456,"2525/2525","Circuit Francorchamp",null,"Equipes","Véhicules","Code","Chantier","Adresse","Remarques"]
[null,null,null,null,null,null,"Olivier B",{"$f":"B8","v":0},{"$f":"C8","v":0},{"$f":"D8","v":0},{"$f":"E6","v":"Circuit Francorchamp"},"Qualifications"]
[null,null,null,null,null,null,"Fonzy",{"$f":"B16","v":0}]
[null,null,null,null,null,null,"Johnny",{"$f":"B20","v":0}]
["Yves","Bugatti",789345,"8787/9526","Circuit Croix en Ternois",null,{"$f":"A12","v":0},{"$f":"B12","v":0},{"$f":"C12","v":0},{"$f":"D12","v":0},{"$f":"E10","v":"Circuit Croix en Ternois"},"Course"]
[null,null,null,null,null,null,{"$f":"A24","v":0},{"$f":"B24","v":0}]
[]
[]
["Fonzy","Maserati",123456,"2525/2525","Circuit Francorchamp"]
[]
[]
[]
["Johnny","Lamborghini",123456,"2525/2525","Circuit Francorchamp"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I21=0,\"\",CONCATENATE(VLOOKUP(I21,'[2]1847-1949-3347-3581'!$C:$I,6,FALSE),\"  \",VLOOKUP(I21,'[2]1847-1949-3347-3581'!$C:$I,7,FALSE)))","v":""}]
["Jean-Pierre","Mc Laren",789345,"8787/9526","Circuit Croix en Ternois"]