{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["名单","赛程","日历"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"名单","index":0,"n_rows":4,"n_cols":7,"rows_kept":4}
[null,"球队名称"]
[null,"球员名单"]
[null,"球员 #","姓名","出生日期","位置","电子邮件","电话"]
[null,null,"输入球员详细信息"]

{"sheet":"赛程","index":1,"n_rows":4,"n_cols":6,"rows_kept":4}
[null,{"$f":"TeamName","v":"球队名称"}]
[null,"球队赛程"]
[null,"日期","活动","场所","状态","备注"]
[null,null,"输入球队赛程"]

{"sheet":"日历","index":2,"n_rows":20,"n_cols":9,"rows_kept":20}
[null,{"$f":"TeamName","v":"球队名称"}]
[null,"赛程日历",{"$nulls":4},2020,"9月",{"$f":"DATE(G2,MONTH(G2&\"年\"&H2&\"1日\"),1)","v":"2020-09-01"}]
[null,"周日","周一","周二","周三","周四","周五","周六"]
[null,{"$f":"IFERROR(FirstDayofTheMonth-WEEKDAY(FirstDayofTheMonth,2),\"\")","v":"2020-08-30"},{"$f":"IFERROR(B4+1,\"\")","v":"2020-08-31"},{"$f":"IFERROR(C4+1,\"\")","v":"2020-09-01"},"2020-09-02","2020-09-03","2020-09-04","2020-09-05"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H4,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H4,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H4+1,\"\")","v":"2020-09-06"},{"$f":"IFERROR(B6+1,\"\")","v":"2020-09-07"},{"$f":"IFERROR(C6+1,\"\")","v":"2020-09-08"},"2020-09-09","2020-09-10","2020-09-11","2020-09-12"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H6,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H6,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H6+1,\"\")","v":"2020-09-13"},{"$f":"IFERROR(B8+1,\"\")","v":"2020-09-14"},"2020-09-15","2020-09-16","2020-09-17","2020-09-18","2020-09-19"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H8,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H8,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H8+1,\"\")","v":"2020-09-20"},{"$f":"IFERROR(B10+1,\"\")","v":"2020-09-21"},"2020-09-22","2020-09-23","2020-09-24","2020-09-25","2020-09-26"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H10,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H10,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H10+1,\"\")","v":"2020-09-27"},{"$f":"IFERROR(B12+1,\"\")","v":"2020-09-28"},"2020-09-29","2020-09-30","2020-10-01","2020-10-02","2020-10-03"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H12,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H12,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,{"$f":"IFERROR(H12+1,\"\")","v":"2020-10-04"},{"$f":"IFERROR(B14+1,\"\")","v":"2020-10-05"},"2020-10-06","2020-10-07","2020-10-08","2020-10-09","2020-10-10"]
[null,{"$f":"IFERROR(IF(VLOOKUP(B14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(B14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(C14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(C14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(D14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(D14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(E14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(E14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(F14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(F14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(G14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(G14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(H14,Table2[[日期]:[活动]],2,FALSE)<>\"\",VLOOKUP(H14,Table2[[日期]:[活动]],2,FALSE),\"\"),\"\")","v":""}]
[null,"图例："]
[null,null,"已安排"]
[null,null,"暂定"]
[null,null,"已完成"]
[null,null,"已取消"]