{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["名单","赛程","日历"],"not_rendered":{"defined_names":3},"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},{"$f":"YEAR(TODAY())","v":2019},{"$f":"TEXT(TODAY(),\"m月\")","v":"6月"},{"$f":"DATE(G2,MONTH(H2&\"1日\"),1)","v":"2019-06-01"}]
[null,"周日","周一","周二","周三","周四","周五","周六"]
[null,{"$f":"IFERROR(FirstDayofTheMonth-WEEKDAY(FirstDayofTheMonth,2),\"\")","v":"2019-05-26"},{"$f":"IFERROR(B4+1,\"\")","v":"2019-05-27"},{"$f":"IFERROR(C4+1,\"\")","v":"2019-05-28"},"2019-05-29","2019-05-30","2019-05-31","2019-06-01"]
[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":"2019-06-02"},{"$f":"IFERROR(B6+1,\"\")","v":"2019-06-03"},{"$f":"IFERROR(C6+1,\"\")","v":"2019-06-04"},"2019-06-05","2019-06-06","2019-06-07","2019-06-08"]
[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":"2019-06-09"},{"$f":"IFERROR(B8+1,\"\")","v":"2019-06-10"},"2019-06-11","2019-06-12","2019-06-13","2019-06-14","2019-06-15"]
[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":"2019-06-16"},{"$f":"IFERROR(B10+1,\"\")","v":"2019-06-17"},"2019-06-18","2019-06-19","2019-06-20","2019-06-21","2019-06-22"]
[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":"2019-06-23"},{"$f":"IFERROR(B12+1,\"\")","v":"2019-06-24"},"2019-06-25","2019-06-26","2019-06-27","2019-06-28","2019-06-29"]
[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":"2019-06-30"},{"$f":"IFERROR(B14+1,\"\")","v":"2019-07-01"},"2019-07-02","2019-07-03","2019-07-04","2019-07-05","2019-07-06"]
[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,"已取消"]