{"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,"60;5000","0;0",null,1,"28800;4","0;5000",null,"999004;999004;999004;999004;999004;999004;999004;999004;999004",999005,999006,99,"看广告得钻石",-1,null,{"$f":"_xlfn.TEXTJOIN(\";\",1,T5:V5)","v":"2;2;2"},{"$f":"_xlfn.TEXTJOIN(\";\",1,W5:Y5)","v":"425;400;175"},2,2,2,{"$f":"1000-X5-Y5","v":425},400,175,{"$f":"W5/1000","v":0.42499999999999999},{"$f":"X5/1000","v":0.4},0.17499999999999999,{"$f":"SUMPRODUCT(T5:V5,Z5:AB5)","v":2}]
[2,1002,300,"0;0","0;5000",null,2700,"0;0","0;5000",null,"999007;999007;999007;999007;999007;999007;999007;999007;999008",999009,999010,99,"代金券抽功法+法宝",200,null,{"$f":"_xlfn.TEXTJOIN(\";\",1,T6:V6)","v":"2;2;2"},{"$f":"_xlfn.TEXTJOIN(\";\",1,W6:Y6)","v":"425;400;175"},2,2,2,{"$f":"1000-X6-Y6","v":425},400,175,{"$f":"W6/1000","v":0.42499999999999999},{"$f":"X6/1000","v":0.4},{"$f":"Y6/1000","v":0.17499999999999999},{"$f":"SUMPRODUCT(T6:V6,Z6:AB6)","v":2}]
[{"$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",10071,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",10072,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",10073,5,"连续出紫","连续2次十连同时得到1个紫色法宝or功法","法宝or功法"]
[4,2,1,2,1,4,"11;12;13;14",10074,10,"十连双紫","连续1次十连同时得到2个紫色法宝or功法","法宝or功法"]
[5,2,1,3,1,4,"11;12;13;14",10075,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",10076,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",10077,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",10078,12,"连续出橙","连续2次十连同时得到1个橙色法宝or功法","法宝or功法"]
[9,2,1,2,1,5,"11;12;13;14",10079,20,"十连双橙","连续1次十连同时得到2个橙色法宝or功法","法宝or功法"]
[10,2,2,2,1,5,"11;12;13;14",10080,40,"连续双橙",{"$f":"CONCATENATE(\"连续\",C14,\"次十连同时得到\",CHOOSE(E14,\"\",\"≥\",\"≤\"),D14,\"个\",CHOOSE(F14,\"白\",\"绿\",\"蓝\",\"紫\",\"橙\",\"红\"),\"色\",L14)","v":"连续2次十连同时得到2个橙色法宝or功法"},"法宝or功法"]

{"sheet":"OpenBoxProgressReward","index":2,"n_rows":15,"n_cols":15,"rows_kept":15,"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,20,{"$f":"_xlfn.TEXTJOIN(\";\",1,F5,H5)","v":"23101;1004"},{"$f":"_xlfn.TEXTJOIN(\";\",1,G5,I5)","v":"4;600"},23101,4,1004,600,{"$f":"CONCATENATE(VLOOKUP(F5,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G5)","v":"倍源净尘符碎片×4"},{"$f":"CONCATENATE(VLOOKUP(H5,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I5)","v":"仙缘宝券×600"},20,null,6]
[2,2,35,{"$f":"_xlfn.TEXTJOIN(\";\",1,F6,H6)","v":"23001;1004"},{"$f":"_xlfn.TEXTJOIN(\";\",1,G6,I6)","v":"1;400"},23001,1,1004,400,{"$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":"仙缘宝券×400"},35,null,1]
[3,2,50,"23101;1004","2;200",23101,2,1004,200,{"$f":"CONCATENATE(VLOOKUP(F7,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G7)","v":"倍源净尘符碎片×2"},{"$f":"CONCATENATE(VLOOKUP(H7,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I7)","v":"仙缘宝券×200"},50,null,3]
[4,2,65,"23101;1004","1;100",23101,1,1004,100,{"$f":"CONCATENATE(VLOOKUP(F8,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G8)","v":"倍源净尘符碎片×1"},{"$f":"CONCATENATE(VLOOKUP(H8,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I8)","v":"仙缘宝券×100"},65,null,1]
[5,2,80,"23102;1004","1;200",23102,1,1004,200,{"$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":"仙缘宝券×200"},80,null,1]
[6,2,100,"23102;1004","2;300",23102,2,1004,300,{"$f":"CONCATENATE(VLOOKUP(F10,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G10)","v":"全域无尘玉牌碎片×2"},{"$f":"CONCATENATE(VLOOKUP(H10,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I10)","v":"仙缘宝券×300"},100,null,3]
[7,2,120,"23102;1004","4;400",23102,4,1004,400,{"$f":"CONCATENATE(VLOOKUP(F11,[1]ItemConfig!$A:$C,3,FALSE),\"×\",G11)","v":"全域无尘玉牌碎片×4"},{"$f":"CONCATENATE(VLOOKUP(H11,[1]ItemConfig!$A:$C,3,FALSE),\"×\",I11)","v":"仙缘宝券×400"},120,null,6]
[8,2,160,"23001;1004","1;600",23001,1,1004,600,{"$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":"仙缘宝券×600"},150,null,1]
[]
[]
[{"$nulls":14},{"$f":"270*200/200*0.1*30/2","v":405}]