{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Feuil1","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["liste des tranches","valeur",null,"noms","heure","tranche",null,"option éventuelle pour lister B automatiquement"]
["09h00 - 10h00","09:00:00",null,"personne_1","09:08:00",{"$f":"IF(ISERROR(MATCH(E2,$B$2:$B$14)),\"\",INDEX($A$2:$A$10,MATCH(E2,$B$2:$B$14)))","v":"09h00 - 10h00"},null,{"$f":"LEFT(A2,2)/24","v":"09:00:00"}]
["10h00 - 11h00","10:00:00",null,"personne_2","12:15:00",{"$f":"IF(ISERROR(MATCH(E3,$B$2:$B$10)),\"\",INDEX($A$2:$A$10,MATCH(E3,$B$2:$B$10)))","v":"12h00 - 13h00"},null,{"$f":"LEFT(A3,2)/24","v":"10:00:00"}]
["11h00 - 12h00","11:00:00",null,"personne_3","16:25:00",{"$f":"IF(ISERROR(MATCH(E4,$B$2:$B$10)),\"\",INDEX($A$2:$A$10,MATCH(E4,$B$2:$B$10)))","v":0},null,"11:00:00"]
["12h00 - 13h00","12:00:00",null,"personne_4","11:13:00",{"$f":"IF(ISERROR(MATCH(E5,$B$2:$B$10)),\"\",INDEX($A$2:$A$10,MATCH(E5,$B$2:$B$10)))","v":"11h00 - 12h00"},null,"12:00:00"]
["13h30 - 14h00","13:00:00",null,"personne_5","14:55:00",{"$f":"IF(ISERROR(MATCH(E6,$B$2:$B$10)),\"\",INDEX($A$2:$A$10,MATCH(E6,$B$2:$B$10)))","v":"16h00 - 16h30"},null,"13:00:00"]
["14h00 - 14h30","13:30:00",null,"personne_6","15:15:00",{"$f":"IFERROR(INDEX($A$2:$A$10,MATCH(E7,$B$2:$B$10)),\"\")","v":{"$error":"#NAME?"}},null,"14:00:00"]
["15h00 - 15h30","14:00:00",null,"personne_7","16:15:00",{"$f":"IFERROR(INDEX($A$2:$A$10,MATCH(E8,$B$2:$B$10)),\"\")","v":{"$error":"#NAME?"}},null,"15:00:00"]
["16h00 - 16h30","14:30:00",null,"personne_8","16:30:00",{"$f":"IFERROR(INDEX($A$2:$A$10,MATCH(E9,$B$2:$B$10)),\"\")","v":{"$error":"#NAME?"}},null,"16:00:00"]
[null,"15:00:00",null,"personne_9","17:00:00",{"$f":"IFERROR(INDEX($A$2:$A$10,MATCH(E10,$B$2:$B$10)),\"\")","v":{"$error":"#NAME?"}}]
[null,"15:30:00"]
[null,"16:00:00"]
[null,"16:30:00"]
[null,"17:00:00"]