{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["cfg_OperateActivity_all","配表小助手","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"cfg_OperateActivity_all","index":0,"n_rows":6,"n_cols":9,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["唯一ID","备注","类型","活动图标","优先级","开启条件判定","关闭条件判定"]
["根据活动类型分组\n【常规活动】100000+1000（类型：每1000递增）+1（期数）\n【节日活动】200000+1000（类型：每1000递增）+1（期数）\n","无意义，策划自己用来自己备忘","程序好取数据","图标名称\n","数字越大，优先级越高","\n填写condition时间相关的表达式\n实际开启时间的条件用971\n多个填写格式condition1&condition2\n不填=没有此条限制 ","填写主活动持续时间\n填写condition表达式\n持续时间的条件用980\n多个填写格式condition1&condition2\n不填=没有此条限制 ","标题名","活动类型\n1=特殊活动（跨服、合服）\n0=周末"]
["int#c#s","string#c#s","int#c#s","string#c#s","int#c#s","string#c#s","string#c#s","string#c#s","int#c#s"]
["id","des","mainGroup","showIcon","priority","openCondition","closeCondition","showTitle","showType"]
[101001,"【跨服】跨服活动第1期",1,"button_kfhd",2,"2302#1","980#1#3","跨服活动",1]
[101014,"【合服】合服活动第1期",14,"button_hfhd",3,"2402#1","980#14#3","合服活动",1]

{"sheet":"配表小助手","index":1,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,4,1,9],[1,11,1,15]]}
[]
["通过填后面标绿的参数，直接配置好字段","填完后面的参数，直接复制AB两列数据即可，记得把公式转成数值!!!",null,971,"需要实际天数时使用\nopenCondition相关参数",{"$nulls":5},981,"closeCondition相关参数"]
["openCondition","closeCondition",null,null,"年","月","日","年月日1","年月日2","年月日链接",null,"mainGroup","活动持续天数"]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J4)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L4,M4)","v":"981#1#3"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E4:G4)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E4:G4)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H4:I4)","v":""},null,1,3]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J5)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L5,M5)","v":"981"},{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J6)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J7)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J8)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J9)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J10)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J11)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J12)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J13)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J14)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J15)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J16)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J17)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J18)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J19)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J20)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J21)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J22)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J23)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J24)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J25)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J26)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J27)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J28)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J29)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J30)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J31)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J32)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J33)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J34)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J35)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J36)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J37)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L37,M37)","v":"981"},{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J38)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J39)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J40)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J41)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J42)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J43)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J44)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J45)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J46)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J47)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J48)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J49)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J50)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J51)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J52)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J53)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J54)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J55)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J56)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J57)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J58)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J59)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J60)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J61)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J62)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J63)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J64)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J65)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J66)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J67)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J68)","v":"971"},"981",{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E68:G68)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E68:G68)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H68:I68)","v":""}]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J69)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L69,M69)","v":"981"},{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J70)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J71)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J72)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J73)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J74)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J75)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J76)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J77)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J78)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J79)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J80)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J81)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J82)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J83)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J84)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J85)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J86)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J87)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J88)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J89)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J90)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J91)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J92)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J93)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J94)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J95)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J96)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J97)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J98)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J99)","v":"971"},"981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J100)","v":"971"},"981",{"$nulls":5},"","",""]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}