{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["cfg_OperateActivity_subActivity","配表小助手","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_subActivity","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["唯一ID","页签名称",null,"活动组",null,"开启条件判定","关闭条件判定","特殊条件判断"]
[null,"页签名称","关联cfg_OperateActivity_all表mainGroupID\n关联主表活动，本期活动开哪几个活动","活动类型\n1.直购\n2.累充\n3.抽奖                                                                                                                                                                                             4.钻石礼包                                                                                                                                                                                         5.消费排行","填cfg_sub_OperateActivity表id\n关联cfg_sub_OperateActivity表","填写活动开启时间\n填写condition表达式\n活动开启的时间条件用971，且只填开启的当天，不填持续几天\n多个填写格式condition1&condition2\n不填=没有此条限制 ","填写活动持续时间\n填写condition表达式\n持续时间的condition用981\n多个填写格式condition1&condition2\n不填=没有此条限制 ","填非时间的条件表达式"]
["int#c#s","string#c#s","int#c#s","int#c#s","int#c#s","string#c#s","string#c#s","string#c#s"]
["id","showTogName","mainGroup","subType","subId","openCondition","closeCondition","specialCondition"]
[10011,"跨服直购",1,1,10011,"2302#1","981#1#1#3","101#70"]
[10033,"好运抽奖",3,3,10013,"901#8&903#14&991#6","981#3#3#2","101#70"]
[10053,"好运抽奖",5,3,10013,"901#22&903#28&991#6","981#5#3#2","101#70"]
[10073,"好运抽奖",7,3,10013,"901#36&903#42&991#6","981#7#3#2","101#70"]
[10093,"好运抽奖",9,3,10013,"901#50&903#56&991#6","981#9#3#2","101#70"]
[10113,"好运抽奖",11,3,10013,"901#64&903#70&991#6","981#11#3#2","101#70"]
[10133,"好运抽奖",13,3,10013,"901#78&903#84&991#6","981#13#3#2","101#70"]
[10141,"合服豪礼",14,1,10011,"2402#1","981#14#1#3","101#70"]
[10144,"合服礼包",14,4,10014,"2402#1","981#14#4#3","101#70"]

{"sheet":"配表小助手","index":1,"n_rows":100,"n_cols":14,"rows_kept":100,"cut":false,"hidden":false,"merged":[[1,4,1,9],[1,11,1,16]]}
[]
["通过填后面标绿的参数，直接配置好字段","填完后面的参数，直接复制AB两列数据即可，记得把公式转成数值!!!",null,971,"openCondition相关参数",{"$nulls":5},981,"closeCondition相关参数"]
["openCondition","closeCondition",null,null,"年","月","日","年月日1","年月日2","年月日链接",null,"mainGroup","subGroup","活动持续天数"]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J4)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L4,M4,N4)","v":"981"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E4:G4)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E4:G4)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H4:I4)","v":""}]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J5)","v":"971"},{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L5,M5,N5)","v":"981"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E5:G5)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E5:G5)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H5:I5)","v":""}]
["971",{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L6,M6,N6)","v":"981"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E6:G6)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E6:G6)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H6:I6)","v":""}]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J37)","v":"971"},"981",{"$nulls":5},"","",""]
["971",{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L38,M38,N38)","v":"981"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E38:G38)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E38:G38)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H38:I38)","v":""}]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
[{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$D$2,J69)","v":"971"},"981",{"$nulls":5},"","",""]
["971",{"$f":"_xlfn.TEXTJOIN(\"#\",TRUE,$K$2,L70,M70,N70)","v":"981"},{"$nulls":5},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E70:G70)","v":""},{"$f":"_xlfn.TEXTJOIN(\"_\",TRUE,E70:G70)","v":""},{"$f":"_xlfn.TEXTJOIN(\"-\",TRUE,H70:I70)","v":""}]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]
["971","981",{"$nulls":5},"","",""]

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