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

{"sheet":"Liste de présence","index":0,"n_rows":4,"n_cols":7,"rows_kept":4}
[null,"Nom de l’équipe"]
[null,"Liste de présence des joueurs"]
[null,"N° du joueur","Nom","DateNaissance","Position","E-mail","Téléphone"]
[null,null,"Entrer les détails du joueur"]

{"sheet":"Planning","index":1,"n_rows":4,"n_cols":6,"rows_kept":4}
[null,{"$f":"_xlfn.SINGLE(NomÉquipe)","v":"Nom de l’équipe"}]
[null,"Planning de l’équipe"]
[null,"Date","Événement","Lieu","Statut","Remarques"]
[null,null,"Entrez le planning de l’équipe"]

{"sheet":"Calendrier","index":2,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,{"$f":"_xlfn.SINGLE(NomÉquipe)","v":"Nom de l’équipe"}]
[null,"Calendrier de planning",{"$nulls":4},{"$f":"YEAR(TODAY())","v":2019},{"$f":"TEXT(TODAY(),\"mmmm\")","v":"juin"},{"$f":"DATE(G2,MONTH(H2&\"1\"),1)","v":"2019-06-01"}]
[null,"Lun","Mar","Mer","Jeu","Ven","Sam","Dim"]
[null,{"$f":"IFERROR(_xlfn.SINGLE(PremierJourDuMois)-WEEKDAY(_xlfn.SINGLE(PremierJourDuMois),2)+1,\"\")","v":"2019-05-27"},{"$f":"IFERROR(B4+1,\"\")","v":"2019-05-28"},{"$f":"IFERROR(C4+1,\"\")","v":"2019-05-29"},"2019-05-30","2019-05-31","2019-06-01","2019-06-02"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(B4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(C4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(D4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(E4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(F4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(G4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H4,Tableau2[[Date]:[Événement]],2,FALSE)<>\"\",VLOOKUP(H4,Tableau2[[Date]:[Événement]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H4+1,\"\")","v":"2019-06-03"},{"$f":"IFERROR(B6+1,\"\")","v":"2019-06-04"},{"$f":"IFERROR(C6+1,\"\")","v":"2019-06-05"},"2019-06-06","2019-06-07","2019-06-08","2019-06-09"]
[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,{"$f":"IFERROR(H6+1,\"\")","v":"2019-06-10"},{"$f":"IFERROR(B8+1,\"\")","v":"2019-06-11"},"2019-06-12","2019-06-13","2019-06-14","2019-06-15","2019-06-16"]
[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,{"$f":"IFERROR(H8+1,\"\")","v":"2019-06-17"},{"$f":"IFERROR(B10+1,\"\")","v":"2019-06-18"},"2019-06-19","2019-06-20","2019-06-21","2019-06-22","2019-06-23"]
[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":"2019-06-24"},{"$f":"IFERROR(B12+1,\"\")","v":"2019-06-25"},"2019-06-26","2019-06-27","2019-06-28","2019-06-29","2019-06-30"]
[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":"2019-07-01"},{"$f":"IFERROR(B14+1,\"\")","v":"2019-07-02"},"2019-07-03","2019-07-04","2019-07-05","2019-07-06","2019-07-07"]
[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,"Légende :"]
[null,null,"Planifié"]
[null,null,"Provisoire"]
[null,null,"Terminé"]
[null,null,"Annulé"]