{"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":57,"n_cols":8,"rows_kept":57,"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\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"]
[10012,"跨服累充",1,2,10012,"2302#1","981#1#2#3","101#70"]
[10021,"周末豪礼",2,1,10011,"901#1&903#7&991#6","981#2#1#2","101#70"]
[10022,"周末累充",2,2,10012,"901#1&903#7&991#6","981#2#2#2","101#70"]
[10024,"钻石礼包",2,4,10014,"901#1&903#7&991#6","981#2#4#2","101#70"]
[10031,"周末豪礼",3,1,10011,"901#8&903#14&991#6","981#3#1#2","101#70"]
[10032,"周末累充",3,2,10012,"901#8&903#14&991#6","981#3#2#2","101#70"]
[10033,"好运抽奖",3,3,10013,"901#8&903#14&991#6","981#3#3#2","101#70"]
[10034,"钻石礼包",3,4,10014,"901#8&903#14&991#6","981#3#4#2","101#70"]
[10035,"充值排行",3,5,10015,"901#8&903#14&991#6","981#3#5#2","101#70"]
[10041,"周末豪礼",4,1,10011,"901#15&903#21&991#6","981#4#1#2","101#70"]
[10042,"周末累充",4,2,10012,"901#15&903#21&991#6","981#4#2#2","101#70"]
[10044,"钻石礼包",4,4,10014,"901#15&903#21&991#6","981#4#4#2","101#70"]
[10051,"周末豪礼",5,1,10011,"901#22&903#28&991#6","981#5#1#2","101#70"]
[10052,"周末累充",5,2,10012,"901#22&903#28&991#6","981#5#2#2","101#70"]
[10053,"好运抽奖",5,3,10013,"901#22&903#28&991#6","981#5#3#2","101#70"]
[10054,"钻石礼包",5,4,10014,"901#22&903#28&991#6","981#5#4#2","101#70"]
[10055,"充值排行",5,5,10015,"901#22&903#28&991#6","981#5#5#2","101#70"]
[10061,"变身豪礼",6,1,10011,"901#29&903#35&991#6","981#6#1#2","101#70"]
[10062,"变身累充",6,2,10012,"901#29&903#35&991#6","981#6#2#2","101#70"]
[10064,"钻石礼包",6,4,10014,"901#29&903#35&991#6","981#6#4#2","101#70"]
[10071,"变身豪礼",7,1,10011,"901#36&903#42&991#6","981#7#1#2","101#70"]
[10072,"变身累充",7,2,10012,"901#36&903#42&991#6","981#7#2#2","101#70"]
[10073,"好运抽奖",7,3,10013,"901#36&903#42&991#6","981#7#3#2","101#70"]
[10074,"钻石礼包",7,4,10014,"901#36&903#42&991#6","981#7#4#2","101#70"]
[10075,"充值排行",7,5,10015,"901#36&903#42&991#6","981#7#5#2","101#70"]
[10081,"变身豪礼",8,1,10011,"901#43&903#49&991#6","981#8#1#2","101#70"]
[10082,"变身累充",8,2,10012,"901#43&903#49&991#6","981#8#2#2","101#70"]
[10084,"钻石礼包",8,4,10014,"901#43&903#49&991#6","981#8#4#2","101#70"]
[10091,"变身豪礼",9,1,10011,"901#50&903#56&991#6","981#9#1#2","101#70"]
[10092,"变身累充",9,2,10012,"901#50&903#56&991#6","981#9#2#2","101#70"]
[10093,"好运抽奖",9,3,10013,"901#50&903#56&991#6","981#9#3#2","101#70"]
[10094,"钻石礼包",9,4,10014,"901#50&903#56&991#6","981#9#4#2","101#70"]
[10095,"充值排行",9,5,10015,"901#50&903#56&991#6","981#9#5#2","101#70"]
[10101,"天使豪礼",10,1,10011,"901#57&903#63&991#6","981#10#1#2","101#70"]
[10102,"天使累充",10,2,10012,"901#57&903#63&991#6","981#10#2#2","101#70"]
[10104,"钻石礼包",10,4,10014,"901#57&903#63&991#6","981#10#4#2","101#70"]
[10111,"天使豪礼",11,1,10011,"901#64&903#70&991#6","981#11#1#2","101#70"]
[10112,"天使累充",11,2,10012,"901#64&903#70&991#6","981#11#2#2","101#70"]
[10113,"好运抽奖",11,3,10013,"901#64&903#70&991#6","981#11#3#2","101#70"]
[10114,"钻石礼包",11,4,10014,"901#64&903#70&991#6","981#11#4#2","101#70"]
[10115,"充值排行",11,5,10015,"901#64&903#70&991#6","981#11#5#2","101#70"]
[10121,"天使豪礼",12,1,10011,"901#71&903#77&991#6","981#12#1#2","101#70"]
[10122,"天使累充",12,2,10012,"901#71&903#77&991#6","981#12#2#2","101#70"]
[10124,"钻石礼包",12,4,10014,"901#71&903#77&991#6","981#12#4#2","101#70"]
[10131,"天使豪礼",13,1,10011,"901#78&903#84&991#6","981#13#1#2","101#70"]
[10132,"天使累充",13,2,10012,"901#78&903#84&991#6","981#13#2#2","101#70"]
[10133,"好运抽奖",13,3,10013,"901#78&903#84&991#6","981#13#3#2","101#70"]
[10134,"钻石礼包",13,4,10014,"901#78&903#84&991#6","981#13#4#2","101#70"]
[10135,"充值排行",13,5,10015,"901#78&903#84&991#6","981#13#5#2","101#70"]
[10141,"合服豪礼",14,1,10011,"2402#1","981#14#1#3","101#70"]
[10142,"合服累充",14,2,10012,"2402#1","981#14#2#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":[]}