{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["OpenBoxConfig","OpenBoxScoreRule","OpenBoxProgressReward"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"OpenBoxConfig","index":0,"n_rows":13,"n_cols":29,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["ID","CostItemID","oneConsume","oneConsumeFreePara","oneConsumeChargePara",null,"tenConsume","oneConsumeFreePara","oneConsumeChargePara",null,"reward","reward1","reward2","reward2para1",null,"ProgressRewardChoukaCount",null,"betPara1","betPara2"]
["int","int","int","int[]","int[]",null,"int","int[]","int[]",null,"int","int","int","int",null,"int",null,"float[]","int[]"]
[]
["ID\n","开箱子所需道具ID","单次消耗","免费单抽常量\nCD（秒）；单日最大次数","付费单抽常量\nCD（秒）；单日最大次数",null,"10次消耗","免费十连常量\nCD（秒）；单日最大次数","付费十连常量\nCD（秒）；单日最大次数",null,"基础池子","十连保底池子1\n每次十连必出的道具池子","十连保底池子2\n每X次十连必出的道具池子","十连保底池子2\n每X次十连必出的道具池子中的X","备注","累计积分每X抽结算奖励",null,"看广告翻倍的倍率选项","看广告翻倍的选项权重","倍率1","倍率2","倍率3","权重1","权重2","权重3","概率1","概率2","概率3","综合倍率"]
[1,1007,1,"300;10","0;5000",null,1,"0;1","0;5000",null,999004,999005,999006,100,"看广告得钻石",-1,null,{"$f":"_xlfn.TEXTJOIN(\";\",1,T5:V5)","v":"2;3;4"},{"$f":"_xlfn.TEXTJOIN(\";\",1,W5:Y5)","v":"600;300;100"},2,3,4,{"$f":"1000-X5-Y5","v":600},300,100,{"$f":"W5/1000","v":0.6},{"$f":"X5/1000","v":0.3},0.1,{"$f":"SUMPRODUCT(T5:V5,Z5:AB5)","v":2.4999999999999996}]
[2,1002,300,"0;1","0;5000",null,2700,"0;0","0;5000",null,999007,999008,999009,100,"钻石抽功法+法宝",300,null,{"$f":"_xlfn.TEXTJOIN(\";\",1,T6:V6)","v":"2;3;4"},{"$f":"_xlfn.TEXTJOIN(\";\",1,W6:Y6)","v":"600;300;100"},2,3,4,{"$f":"1000-X6-Y6","v":600},300,100,{"$f":"W6/1000","v":0.6},{"$f":"X6/1000","v":0.3},{"$f":"Y6/1000","v":0.1},{"$f":"SUMPRODUCT(T6:V6,Z6:AB6)","v":2.4999999999999996}]
[{"$nulls":10},"A","B","C"]
[{"$nulls":10},"规则1","每次十连出9个A+1个B，客户端显示顺序需要打乱，不要让B老是显示在固定位置"]
[{"$nulls":10},"规则2","通过十连抽到的每第100次出一个C，客户端显示顺序需要打乱，不要让C老是显示在固定位置"]
[{"$nulls":10},"规则3","如果前99抽出了C中的任意一个道具，则规则2重置"]
[{"$nulls":10},"规则4","每次单抽出一个A"]
[]
[{"$nulls":11}," "]

{"sheet":"OpenBoxScoreRule","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID","openBoxID","para0","para1","para2","para3","para4","lanID","score"]
["int","int","int","int","int","int","int[]","int","int"]
[]
["ID\n","openboxID","连续{0}次十连同时得到{1}个品质{2}{3}的道具\n参数0","连续{0}次十连同时得到{1}个品质{2}{3}的道具\n参数1","连续{0}次十连同时得到{1}个品质{2}{3}的道具\n参数2：1= 2≥ 3≤","连续{0}次十连同时得到{1}个品质{2}{3}的道具\n参数3","计入分数的Itemtag\n不填就是所有tag","语言表ID","获得分数","玩家看到的","详细说明"]
[1,2,1,1,1,3,"11;12;13;14",null,1,"十连出蓝",{"$f":"CONCATENATE(\"连续\",C5,\"次十连同时得到\",CHOOSE(E5,\"\",\"≥\",\"≤\"),D5,\"个\",CHOOSE(F5,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L5)","v":"连续1次十连同时得到1个蓝色法宝or功法"},"法宝or功法"]
[2,2,1,1,1,4,"11;12;13;14",null,2,"十连出紫",{"$f":"CONCATENATE(\"连续\",C6,\"次十连同时得到\",CHOOSE(E6,\"\",\"≥\",\"≤\"),D6,\"个\",CHOOSE(F6,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L6)","v":"连续1次十连同时得到1个紫色法宝or功法"},"法宝or功法"]
[3,2,2,1,1,4,"11;12;13;14",null,5,"连续出紫","连续2次十连同时得到1个紫色法宝or功法","法宝or功法"]
[4,2,1,2,1,4,"11;12;13;14",null,10,"十连双紫","连续1次十连同时得到2个紫色法宝or功法","法宝or功法"]
[5,2,1,3,1,4,"11;12;13;14",null,25,"十连三紫",{"$f":"CONCATENATE(\"连续\",C9,\"次十连同时得到\",CHOOSE(E9,\"\",\"≥\",\"≤\"),D9,\"个\",CHOOSE(F9,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L9)","v":"连续1次十连同时得到3个紫色法宝or功法"},"法宝or功法"]
[6,2,1,4,1,4,"11;12;13;14",null,50,"十连四紫",{"$f":"CONCATENATE(\"连续\",C10,\"次十连同时得到\",CHOOSE(E10,\"\",\"≥\",\"≤\"),D10,\"个\",CHOOSE(F10,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L10)","v":"连续1次十连同时得到4个紫色法宝or功法"},"法宝or功法"]
[7,2,1,1,1,5,"11;12;13;14",null,4,"十连出橙",{"$f":"CONCATENATE(\"连续\",C11,\"次十连同时得到\",CHOOSE(E11,\"\",\"≥\",\"≤\"),D11,\"个\",CHOOSE(F11,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L11)","v":"连续1次十连同时得到1个橙色法宝or功法"},"法宝or功法"]
[8,2,2,1,1,5,"11;12;13;14",null,12,"连续出橙","连续2次十连同时得到1个橙色法宝or功法","法宝or功法"]
[9,2,1,2,1,5,"11;12;13;14",null,20,"十连双橙","连续1次十连同时得到2个橙色法宝or功法","法宝or功法"]
[10,2,2,2,1,5,"11;12;13;14",null,40,"连续双橙",{"$f":"CONCATENATE(\"连续\",C14,\"次十连同时得到\",CHOOSE(E14,\"\",\"≥\",\"≤\"),D14,\"个\",CHOOSE(F14,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L14)","v":"连续2次十连同时得到2个橙色法宝or功法"},"法宝or功法"]

{"sheet":"OpenBoxProgressReward","index":2,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["ID","OpenboxID","TotalScore","PrizeID","PrizeCount"]
["int","int","int","int[]","int[]"]
[]
["ID\n","抽奖组ID\n","积累分数\n","奖励道具","奖励数量","道具1","数量1","道具2","数量2","道具1","道具2"]
[1,2,30,{"$f":"_xlfn.TEXTJOIN(\";\",1,F5,H5)","v":"23001;1701"},{"$f":"_xlfn.TEXTJOIN(\";\",1,G5,I5)","v":"1;1"},23001,1,1701,1,{"$f":"CONCATENATE(VLOOKUP(F5,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G5)","v":"免双倍广告卡×1"},{"$f":"CONCATENATE(VLOOKUP(H5,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I5)","v":"神识丹-小×1"}]
[2,2,40,{"$f":"_xlfn.TEXTJOIN(\";\",1,F6,H6)","v":"23003;1701"},{"$f":"_xlfn.TEXTJOIN(\";\",1,G6,I6)","v":"1;2"},23003,1,1701,2,{"$f":"CONCATENATE(VLOOKUP(F6,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G6)","v":"免双倍广告卡碎片×1"},{"$f":"CONCATENATE(VLOOKUP(H6,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I6)","v":"神识丹-小×2"}]
[3,2,50,"23003;1702","3;1",23003,3,1702,1,{"$f":"CONCATENATE(VLOOKUP(F7,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G7)","v":"免双倍广告卡碎片×3"},{"$f":"CONCATENATE(VLOOKUP(H7,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I7)","v":"神识丹-中×1"}]
[4,2,60,"23003;1702","6;1",23003,6,1702,1,{"$f":"CONCATENATE(VLOOKUP(F8,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G8)","v":"免双倍广告卡碎片×6"},{"$f":"CONCATENATE(VLOOKUP(H8,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I8)","v":"神识丹-中×1"}]
[5,2,70,"23004;1702","1;2",23004,1,1702,2,{"$f":"CONCATENATE(VLOOKUP(F9,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G9)","v":"免所有广告卡碎片×1"},{"$f":"CONCATENATE(VLOOKUP(H9,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I9)","v":"神识丹-中×2"}]
[6,2,80,"23004;1702","3;2",23004,3,1702,2,{"$f":"CONCATENATE(VLOOKUP(F10,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G10)","v":"免所有广告卡碎片×3"},{"$f":"CONCATENATE(VLOOKUP(H10,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I10)","v":"神识丹-中×2"}]
[7,2,90,"23004;1702","6;2",23004,6,1702,2,{"$f":"CONCATENATE(VLOOKUP(F11,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G11)","v":"免所有广告卡碎片×6"},{"$f":"CONCATENATE(VLOOKUP(H11,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I11)","v":"神识丹-中×2"}]
[8,2,100,"23001;1703","1;1",23001,1,1703,1,{"$f":"CONCATENATE(VLOOKUP(F12,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G12)","v":"免双倍广告卡×1"},{"$f":"CONCATENATE(VLOOKUP(H12,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I12)","v":"神识丹-大×1"}]