{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Liste de présence","Planning","Calendrier"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Liste de présence","index":0,"n_rows":6,"n_cols":7,"rows_kept":6}
[]
[null,"Les Emerald Sox"]
[null,"TABLEAU DES ÉQUIPES"]
[]
[null,"JOUEUR #","NOM","ANNIVERSAIRE","FONCTION","E-MAIL","TÉLÉPHONE"]
[null,8,"Ariane Panetier","1989-04-06","2e base","ariane@example.com","415-555-0145"]

{"sheet":"Planning","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[]
[null,{"$f":"TeamName","v":"Les Emerald Sox"}]
[null,"PLANIFICATION DE L’ÉQUIPE"]
[]
[null,"DATE","ÉVÉNEMENT","LIEU","ÉTAT","REMARQUES"]
[null,{"$f":"IF(MONTH(TODAY())=12,TODAY()+92,TODAY())","v":"2024-04-15"},"Les Sox d'Émeraude contre Rats de la ville de la pluie","Stade Premier","Programmé","Jour d’ouverture"]

{"sheet":"Calendrier","index":2,"n_rows":17,"n_cols":15,"rows_kept":17}
[]
[null,{"$f":"TeamName","v":"Les Emerald Sox"},{"$nulls":12},{"$f":"DATE(H3,MONTH(G3&\"1\"),1)","v":45352}]
[null,"PLANIFIER LE CALENDRIER",{"$nulls":4},"Mars",2024]
[]
[null,"LUN","MAR","MER","JEU","VEN","SAM","DIM",null,"LÉGENDE"]
[null,{"$f":"IFERROR(PremierJourDuMois-WEEKDAY(PremierJourDuMois,2)+1,\"\")","v":"2024-02-26"},{"$f":"IFERROR(B6+1,\"\")","v":"2024-02-27"},{"$f":"IFERROR(C6+1,\"\")","v":"2024-02-28"},"2024-02-29","2024-03-01","2024-03-02","2024-03-03",null,null,"PROGRAMMÉ"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H6,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},null,null,"PROVISOIRE"]
[null,{"$f":"IFERROR(H6+1,\"\")","v":"2024-03-04"},{"$f":"IFERROR(B8+1,\"\")","v":"2024-03-05"},{"$f":"IFERROR(C8+1,\"\")","v":"2024-03-06"},"2024-03-07","2024-03-08","2024-03-09","2024-03-10",null,null,"TERMINÉ"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H8,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},null,null,"ANNULÉ"]
[null,{"$f":"IFERROR(H8+1,\"\")","v":"2024-03-11"},{"$f":"IFERROR(B10+1,\"\")","v":"2024-03-12"},"2024-03-13","2024-03-14","2024-03-15","2024-03-16","2024-03-17"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H10,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H10+1,\"\")","v":"2024-03-18"},{"$f":"IFERROR(B12+1,\"\")","v":"2024-03-19"},"2024-03-20","2024-03-21","2024-03-22","2024-03-23","2024-03-24"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H12,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H12+1,\"\")","v":"2024-03-25"},{"$f":"IFERROR(B14+1,\"\")","v":"2024-03-26"},"2024-03-27","2024-03-28","2024-03-29","2024-03-30","2024-03-31"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H14,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H14+1,\"\")","v":"2024-04-01"},{"$f":"IFERROR(B16+1,\"\")","v":"2024-04-02"},"2024-04-03","2024-04-04","2024-04-05","2024-04-06","2024-04-07"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(B16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(C16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(D16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(E16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(F16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(G16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE)<>\"\",VLOOKUP(H16,Tableau2[[DATE]:[ÉVÉNEMENT]],2,FALSE),\"\"),\"\")","v":""}]