{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Roster","Schedule","Calendar"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Roster","index":0,"n_rows":6,"n_cols":7,"rows_kept":6}
[]
[null,"The Emerald Sox"]
[null,"TEAM ROSTER"]
[]
[null,"PLAYER #","NAME","BIRTHDAY","POSITION","EMAIL","PHONE"]
[null,8,"Ariane Panetier","1989-04-06","2nd base","ariane@example.com","415-555-0145"]

{"sheet":"Schedule","index":1,"n_rows":6,"n_cols":6,"rows_kept":6}
[]
[null,{"$f":"TeamName","v":"The Emerald Sox"}]
[null,"TEAM SCHEDULE"]
[]
[null,"DATE","EVENT","VENUE","STATUS","REMARKS"]
[null,{"$f":"IF(MONTH(TODAY())=12,TODAY()+92,TODAY())","v":"2024-03-12"},"Emerald Sox vs. Rain City Rats","Premier Stadium","Scheduled","Opening day"]

{"sheet":"Calendar","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,"SCHEDULE CALENDAR",{"$nulls":4},"March",2024]
[]
[null,"SUN","MON","TUE","WED","THUR","FRI","SAT",null,"LEGEND"]
[null,{"$f":"IFERROR(FirstDayofTheMonth-WEEKDAY(FirstDayofTheMonth,2),\"\")","v":"2024-02-25"},{"$f":"IFERROR(B6+1,\"\")","v":"2024-02-26"},{"$f":"IFERROR(C6+1,\"\")","v":"2024-02-27"},"2024-02-28","2024-02-29","2024-03-01","2024-03-02",null,null,"SCHEDULED"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H6,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H6,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},null,null,"TENTATIVE"]
[null,{"$f":"IFERROR(H6+1,\"\")","v":"2024-03-03"},{"$f":"IFERROR(B8+1,\"\")","v":"2024-03-04"},{"$f":"IFERROR(C8+1,\"\")","v":"2024-03-05"},"2024-03-06","2024-03-07","2024-03-08","2024-03-09",null,null,"COMPLETED"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H8,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H8,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},null,null,"CANCELLED"]
[null,{"$f":"IFERROR(H8+1,\"\")","v":"2024-03-10"},{"$f":"IFERROR(B10+1,\"\")","v":"2024-03-11"},"2024-03-12","2024-03-13","2024-03-14","2024-03-15","2024-03-16"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":"Emerald Sox vs. Rain City Rats"},{"$f":"IFERROR(IF(VLOOKUP(E10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H10,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H10,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H10+1,\"\")","v":"2024-03-17"},{"$f":"IFERROR(B12+1,\"\")","v":"2024-03-18"},"2024-03-19","2024-03-20","2024-03-21","2024-03-22","2024-03-23"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H12,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H12,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H12+1,\"\")","v":"2024-03-24"},{"$f":"IFERROR(B14+1,\"\")","v":"2024-03-25"},"2024-03-26","2024-03-27","2024-03-28","2024-03-29","2024-03-30"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H14,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H14,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H14+1,\"\")","v":"2024-03-31"},{"$f":"IFERROR(B16+1,\"\")","v":"2024-04-01"},"2024-04-02","2024-04-03","2024-04-04","2024-04-05","2024-04-06"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(B16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(C16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(D16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(E16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(F16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(G16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H16,Table2[[DATE]:[EVENT]],2,FALSE)<>\"\",VLOOKUP(H16,Table2[[DATE]:[EVENT]],2,FALSE),\"\"),\"\")","v":""}]