{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Rooster","Planning","Agenda"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Rooster","index":0,"n_rows":6,"n_cols":7,"rows_kept":6}
[]
[null,"The Emerald Sox"]
[null,"TEAMROOSTER"]
[]
[null,"SPELER #","NAAM","VERJAARDAG","FUNCTIE","E-MAIL","TELEFOON"]
[null,8,"Ariane Panetier","1989-04-06","2e honk","ariane@example.com","415-555-0145"]

{"sheet":"Planning","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[]
[null,{"$f":"TeamName","v":"The Emerald Sox"}]
[null,"TEAMPLANNING"]
[]
[null,"DATUM","GEBEURTENIS","LOCATIE","STATUS","OPMERKINGEN"]
[null,{"$f":"IF(MONTH(TODAY())=12,TODAY()+92,TODAY())","v":"2024-04-02"},"Emerald Sox vs. Rain City Rats","Premier Stadium","Gepland","Openingsdag"]

{"sheet":"Agenda","index":2,"n_rows":17,"n_cols":15,"rows_kept":17}
[]
[null,{"$f":"TeamName","v":"The Emerald Sox"},{"$nulls":12},{"$f":"DATE(H3,MONTH(G3&\"1\"),1)","v":45352}]
[null,"AGENDA",{"$nulls":4},"Maart",2024]
[]
[null,"MA","DI","WO","DO","VR","ZA","ZO",null,"LEGENDA"]
[null,{"$f":"IFERROR(FirstDayofTheMonth-WEEKDAY(FirstDayofTheMonth,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,"GEPLAND"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H6,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},null,null,"VOORLOPIG"]
[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,"VOLTOOID"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H8,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},null,null,"GEANNULEERD"]
[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,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H10,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H10,Tabel2[[DATUM]:[GEBEURTENIS]],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,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H12,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H12,Tabel2[[DATUM]:[GEBEURTENIS]],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,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H14,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H14,Tabel2[[DATUM]:[GEBEURTENIS]],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,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(B16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(C16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":"Emerald Sox vs. Rain City Rats"},{"$f":"IFERROR(IF(VLOOKUP(D16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(D16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(E16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(F16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(G16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE)<>\"\",VLOOKUP(H16,Tabel2[[DATUM]:[GEBEURTENIS]],2,FALSE),\"\"),\"\")","v":""}]