{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["功能说明","界面逻辑","UI"],"not_rendered":{"charts":0,"images":54,"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":"功能说明","index":0,"n_rows":146,"n_cols":8,"rows_kept":146,"cut":false,"hidden":false,"merged":[]}
[]
[null,1,"简介"]
[]
[null,null,"1）选择指定的饰品进行抽奖"]
[null,null,"2）该饰品可选择不同的损耗度，进行抽奖（不同损耗度价格不同，不一定全部损耗度都有）"]
[null,null,"3）抽奖结果只有中奖、没中奖两种结果"]
[null,null,null,"中奖，获得该道具"]
[null,null,null,"没中奖，获得兑换币"]
[]
[null,null,"4）追梦抽奖可由玩家自行调节获奖概率，通用配置每个饰品的最低概率和最高概率"]
[null,null,"5）每件饰品拉取价格，根据公式，计算对应概率的价格"]
[]
[]
[null,2,"配置"]
[]
[null,null,"追梦常量表"]
[null,null,"id","注释","常量值"]
[null,null,1,"最小百分比",0.05]
[null,null,2,"最大百分比",0.85]
[null,null,3,"不中奖道具","代币*1"]
[null,null,4,"精彩瞬间记录中奖道具价格最小值（中奖的才记录）",10000]
[null,null,5,"每个追梦道具记录数量",20]
[null,null,6,"精彩瞬间记录数量",20]
[null,null,7,"全局历史最近追梦记录数量",20]
[null,null,8,"全局概率统计记录近x天",3]
[]
[]
[]
[null,null,"追梦入口箱子展示表（前端用）"]
[null,null,"箱子id","道具id"]
[null,null,1,"A"]
[null,null,2,"D"]
[null,null,3,"G"]
[]
[]
[]
[null,null,"追梦道具表"]
[null,null,"箱子id","道具id","道具价值","常数（成本）"]
[null,null,1,"A",null,null,null,"追梦常数配在道具表"]
[null,null,1,"B"]
[null,null,1,"C"]
[null,null,2,"D"]
[null,null,2,"E"]
[null,null,2,"F"]
[null,null,3,"G"]
[]
[null,null,null,"追梦价格=道具价值/道具对应常数*追梦成功对应百分比"]
[]
[]
[]
[null,3,"记录"]
[]
[null,null,"1）记录每件饰品近20次的抽奖记录"]
{"$rows_empty":19}
[null,null,"2）精彩瞬间"]
[null,null,null,"根据常量表配置的饰品价格最小值，达到该价格及以上的饰品成功中奖掉落记录"]
[null,null,null,"最近20条即可"]
{"$rows_empty":18}
[null,null,"3）历史掉落记录"]
[null,null,null,"记录最近玩家20条追梦抽奖记录"]
{"$rows_empty":30}
[null,null,"4）记录数据"]
[null,null,null,"1、玩家头像"]
[null,null,null,"2、玩家账号、id信息"]
[null,null,null,"3、追梦道具名"]
[null,null,null,"4、追梦损耗度"]
[null,null,null,"5、道具价格（记录时的价格）"]
[null,null,null,"6、该玩家的追梦概率"]
[null,null,null,"7、掉落的道具（成功、失败的道具）"]
[]
[]
[null,4,"全局统计"]
[]
[null,null,"1）记录近3日，追梦玩法的每1%概率的参与人数、中奖人数&中奖占比、没中奖人数&没中奖占比"]
[]
[]
[]
[null,null,null,"该概率参与人数=该概率中奖人数+该概率没中奖人数"]
[]
[null,null,null,"该概率中奖占比=中奖人数/参与人数*100.00%"]
[]
[null,null,null,"该概率没中奖占比=没中奖人数/参与人数*100.00%"]

{"sheet":"界面逻辑","index":1,"n_rows":472,"n_cols":19,"rows_kept":472,"cut":false,"hidden":false,"merged":[]}
[null,"【追梦—指定道具开箱】"]
[]
[{"$nulls":9},1,"标题"]
[]
[{"$nulls":9},2,"说明按钮"]
[{"$nulls":10},"1）点击弹出通用弹窗说明"]
[]
[{"$nulls":9},3,"导航标签"]
[]
[]
[]
[]
[]
[{"$nulls":10},"1）共4个标签，默认选中【热门饰品】"]
[]
[{"$nulls":10},"2）热门饰品即为选择的指定道具开箱"]
[]
[]
[]
[]
[]
[{"$nulls":10},"3）选中后下方显示饰品"]
[]
[]
[{"$nulls":9},4,"搜索栏"]
[{"$nulls":15},"点击饰品名字"]
[{"$nulls":10},"点击输入饰品名字，点击放大镜搜索",{"$nulls":4},"1）弹出气泡，显示饰品全名+磨损度"]
[{"$nulls":10},"空白，点击搜索恢复列表",{"$nulls":4},"2）约定所有饰品点击名字都是这样"]
[]
[]
[]
[{"$nulls":9},5,"价格排序"]
[]
[{"$nulls":10},"1）价格从高到低（默认）"]
[{"$nulls":10},"2）价格从低到高（点击切换）"]
[]
[{"$nulls":10},"3）根据当前筛选出的宝箱，按照该价格排序，从上到下，从左到右显示"]
{"$rows_empty":11}
[{"$nulls":12},6,"筛选"]
[]
[{"$nulls":13},"1）点击右侧拉出筛选页"]
{"$rows_empty":13}
[{"$nulls":13},"2）饰品种类"]
[{"$nulls":14},"①即饰品种类（同商城的除热推的8种饰品分类）"]
[]
[]
[]
[]
[]
[{"$nulls":14},"②默认选中推荐，即显示所有种类箱子"]
[]
[]
[]
[{"$nulls":13},"3）型号"]
{"$rows_empty":8}
[null,null,"排序"]
[null,null,"1）从上到下，从左到右显示",{"$nulls":11},"①当选中具体类别后，显示该类别的型号选择"]
[{"$nulls":14},"②每种类别有不同型号（同商城）"]
[null,null,"2）按照以下分类优先级排序",{"$nulls":11},"③默认选中【推荐】，显示该类别的所有箱子"]
[]
[null,null,null,"①价格高低"]
[]
[]
[{"$nulls":13},"4）价格范围筛选（根据选择，填写的价格范围筛选宝箱）"]
[]
[]
[{"$nulls":4},"1、根据选中的高低排序显示"]
[{"$nulls":4},"2、默认价格高到低"]
[]
[null,null,null,"②品质"]
[{"$nulls":4},"高>低"]
[{"$nulls":5},"违禁>隐秘>保密>受限>军规级>工业级>消费级"]
[null,null,null,"③类别"]
[{"$nulls":4},"高>低"]
[{"$nulls":5},"★》★ StatTrak™》StatTrak™》纪念品》普通"]
[{"$nulls":14},"①价格范围输入框"]
[]
[]
[]
[]
[{"$nulls":15},"1）不填写时，默认显示如上图"]
[{"$nulls":15},"2）最低价、最高价"]
[]
[{"$nulls":16},"最高价≥值≥最低价"]
[]
[{"$nulls":16},"可只填写其中一项，如只填最高价=33"]
[{"$nulls":17},"则筛选价格范围为 ≤33"]
[]
[{"$nulls":16},"最低价不可超过最高价，填写时，超过最高价，自动填写为最高价"]
[{"$nulls":16},"最高价不可低于最低价，填写时，低于最低价，自动填写为最低价"]
[]
[]
[{"$nulls":14},"①点击【清空价格】"]
[]
[]
[]
[{"$nulls":15},"输入框显示，最低价、最高价，筛选时不读取该价格区域"]
[]
[{"$nulls":14},"③系统默认价格范围选项"]
[]
[]
[]
[]
[]
[]
[{"$nulls":15},"1）如上图，默认给出4种价格范围，用户可点击选择，选中后自动填写该范围至最低、最高价输入框"]
[]
[{"$nulls":15},"2）选中后，用户可修改输入框数值，修改后，与系统价格范围不同，则选中的范围按钮取消选中"]
[]
[]
[{"$nulls":13},"4）确定/取消"]
{"$rows_empty":8}
[{"$nulls":14},"①【确定】、【取消】按钮固定显示，不可滑动（即按钮上面的那些筛选的东西可上下滑动）"]
[]
[{"$nulls":14},"②【确定】，点击确定筛选设置，收回筛选页，筛选追梦箱子"]
[]
[{"$nulls":14},"③【取消】，关闭筛选页"]
[]
[{"$nulls":15},"每次打开筛选页，所有筛选设置都为默认设置"]
[]
[null,"【指定道具开箱】"]
[]
[]
[{"$nulls":10},1,"进入开箱界面"]
[]
[{"$nulls":11},"1）道具图、价钱读追梦入口箱子展示表的道具"]
[{"$nulls":12},"名字不需显示损耗度"]
[{"$nulls":12},"价钱取道具id价钱"]
[{"$nulls":12},"颜色取道具品质颜色即可"]
{"$rows_empty":28}
[{"$nulls":11},"在热门饰品界面，点击饰品，进入开箱界面左图"]
[]
[{"$nulls":10},2,"标题&返回"]
[]
[]
[{"$nulls":10},3,"饰品展示部分"]
[]
[]
[]
[]
[{"$nulls":16},"道具名"]
{"$rows_empty":11}
[{"$nulls":12},"左侧和中间是同一件道具"]
[{"$nulls":11},"左侧：显示损耗成都名字"]
[]
[{"$nulls":11},"中间：显示所选择的抽奖概率"]
[]
[{"$nulls":11},"右侧：固定显示随机道具"]
[]
[]
[]
[]
[]
[{"$nulls":10},4,"概率选择"]
[]
[{"$nulls":11},"1）快捷概率选择"]
[]
[{"$nulls":12},"拖动条上方显示5种系统默认概率按钮，方便玩家快捷调节（配置选择的概率）"]
[]
[{"$nulls":12},0.05]
[{"$nulls":12},0.1]
[{"$nulls":12},0.25]
[{"$nulls":12},0.5]
[{"$nulls":12},0.85,null,"点击选中高亮"]
[]
[{"$nulls":11},"2）拖动条"]
{"$rows_empty":8}
[{"$nulls":12},"①最小值=配置的最小概率"]
[{"$nulls":12},"②最大值=配置的最大概率"]
[{"$nulls":12},"③拖动条每移动1格=1%"]
[]
[]
[{"$nulls":10},5,"抽奖"]
[]
[]
[]
[]
[]
[{"$nulls":11},"1）显示该概率的抽奖价钱"]
[]
[{"$nulls":12},"追梦价格=道具价值/道具对应常数*追梦成功对应百分比"]
[]
[]
[]
[]
[{"$nulls":10},6,"损耗度选择"]
[]
[{"$nulls":11},"1）共6种"]
[{"$nulls":13},"不一定所有道具全损耗度都有，根据配置显示"]
[{"$nulls":11},"①破损不堪",null,"排序，从左到右，按照价钱高的排序，默认选中第一个"]
[{"$nulls":11},"②久经沙场"]
[{"$nulls":11},"③崭新出厂"]
[{"$nulls":11},"④战痕累累"]
[{"$nulls":11},"⑤略有磨损"]
[{"$nulls":11},"⑥无涂装"]
[]
[]
[]
[]
[null,null,"如箱子id：1，包含3种道具"]
[]
[null,null,"A：略有磨损"]
[null,null,"B：久经沙场",{"$nulls":8},"2）可左右滑动选择"]
[null,null,"C：崭新出厂"]
[{"$nulls":11},"①点击选中高亮"]
[null,null,"进入箱子追梦界面，显示该3种道具损耗度选择"]
[null,null,"按照价格高得，从左到右排序",{"$nulls":8},"4）显示内容"]
[]
[{"$nulls":11},"①损耗度名字"]
[{"$nulls":12},"排序按照价格高的，从左到右排序"]
[]
[{"$nulls":11},"②价格"]
[{"$nulls":12},"取该道具拉取得价格"]
[]
[]
[null,"【箱子历史掉落记录】"]
[]
[]
[]
[]
[{"$nulls":16},"低品质颜色"]
[{"$nulls":16},"安慰奖"]
[]
[{"$nulls":16},"高品质颜色"]
[{"$nulls":16},"中奖"]
[]
[]
[]
[{"$nulls":11},"从左到右显示内容"]
[{"$nulls":11},"1）头像"]
[{"$nulls":11},"2）饰品名字"]
[null,"无记录",{"$nulls":9},"3）饰品图标（选中抽奖的饰品）"]
[{"$nulls":11},"4）抽奖价钱"]
[{"$nulls":11},"5）抽奖概率"]
[{"$nulls":11},"6）获得的奖励图标"]
[]
[{"$nulls":11},"7）底图颜色"]
[{"$nulls":12},"同开盲盒记录（通用2种颜色区别是否中奖）"]
[]
[]
[{"$nulls":12},"可上下滑动"]
[]
[]
[{"$nulls":4},"选择损耗度，显示该损耗度饰品的掉落记录"]
[{"$nulls":11},"记录数据"]
[{"$nulls":11},"1）最近掉落的20条"]
[]
[]
[]
[null,"【精彩瞬间】"]
[]
[]
[{"$nulls":9},"根据常量表精彩瞬间价格范围，若掉落的道具在精彩范围内，则记录入精彩瞬间（"]
[{"$nulls":10},"简单来说就记录贵的道具，常量配置价格≥X该值就记录入精彩瞬间"]
[]
[]
[{"$nulls":9},"记录内容"]
[{"$nulls":9},"1）玩家头像"]
[{"$nulls":9},"2）道具名字"]
[{"$nulls":9},"3）道具损耗度"]
[{"$nulls":9},"4）道具掉落时的价格"]
[{"$nulls":9},"5）玩家选择的掉落概率"]
[{"$nulls":9},"6）道具图"]
[]
[]
[{"$nulls":9},"保留20条精彩瞬间数据"]
[]
[]
[]
[]
[{"$nulls":9},"点击跳转到该追梦宝箱详情界面"]
{"$rows_empty":15}
[null,"【掉落记录】"]
[]
[]
[{"$nulls":12},1,"掉落记录"]
[]
[{"$nulls":13},"1）掉落记录该玩法，最近20条掉落的记录"]
[{"$nulls":13},"2）前端显示简洁查看、详细查看2种切换记录"]
[]
[]
[{"$nulls":12},2,"详细查看"]
[]
[{"$nulls":13},"显示内容（默认选择详细查看）"]
[]
[{"$nulls":13},"1）玩家头像"]
[{"$nulls":13},"2）追梦道具名、道具损耗度"]
[{"$nulls":13},"3）该道具当时价格"]
[{"$nulls":13},"4）玩家选择的概率"]
[{"$nulls":13},"5）开出的道具图"]
{"$rows_empty":8}
[{"$nulls":18},"无开出指定道具"]
[{"$nulls":13},"6）高亮底"]
[]
[]
[{"$nulls":18},"开出指定道具"]
[]
[]
[]
[null,"详细查看",{"$nulls":5},"简介查看"]
[]
[]
[{"$nulls":12},3,"简洁查看"]
[]
[{"$nulls":13},"显示内容"]
[]
[{"$nulls":13},"1）玩家选择的概率"]
[{"$nulls":13},"2）玩家头像"]
[{"$nulls":13},"3）追梦道具名、损耗度"]
[{"$nulls":13},"4）开出的道具图"]
[]
[{"$nulls":13},"ps：不需要高亮底"]
[]
[]
[]
[{"$nulls":13},"保留最近20条记录"]
[]
[]
[null,"【全局统计】"]
[]
[]
[]
[]
[{"$nulls":9},1,"说明"]
[]
[{"$nulls":10},"1）记录最近3天，所有概率的追梦次数、成功开出的次数&占比、没开出的次数&占比"]
[]
[]
[{"$nulls":9},2,"固定显示概率范围"]
[]
[{"$nulls":10},"5-15%，则显示该概率范围近3天的数据"]
[]
[]
[{"$nulls":9},3,"该概率范围的追梦次数"]
[]
[]
[{"$nulls":9},4,"失败次数&占比"]
[]
[{"$nulls":10},"失败占比=失败开出次数/该范围追梦次数"]
[]
[{"$nulls":9},5,"成功次数&占比"]
[]
[{"$nulls":10},"成功占比=成功开出次数/该范围追梦次数"]
[]
[]
[{"$nulls":9},6,"手动输入范围数据"]
[]
[{"$nulls":10},"1）点击修改弹出范围概率输入框"]
[{"$nulls":10},"2）最下的数据条就是玩家自定义输入概率范围数据"]
[]
[]
[{"$nulls":13},"玩家可自定义查看概率范围数据"]
[]
[{"$nulls":13},"最小值"]
[]
[{"$nulls":13},"1）最小值最小可输入=常量表概率最小值"]
[]
[{"$nulls":13},"2）当输入的最小值<常量表概率最小值，自动输入为常量表最小值"]
[]
[{"$nulls":13},"3）当输入的最小值>输入的最大值，确定时，飘字提示"]
[{"$nulls":15},"概率范围最小值，不可大于概率范围最大值"]
[]
[]
[{"$nulls":13},"最大值"]
[]
[{"$nulls":13},"1）最大值最大可输入=常量表概率最大值"]
[]
[{"$nulls":13},"2）当输入的最大值>常量表概率最大值，自动输入为常量表最大值"]
[]
[{"$nulls":13},"3）当输入的最大值<输入的最小值，确定时，飘字提示"]
[{"$nulls":15},"概率范围最大值，不可小于概率范围最小值"]

{"sheet":"UI","index":2,"n_rows":303,"n_cols":17,"rows_kept":303,"cut":false,"hidden":false,"merged":[]}
[null,"【追梦—指定道具开箱】"]
[]
[{"$nulls":9},1,"标题"]
[]
[{"$nulls":9},2,"说明按钮"]
[{"$nulls":10},"1）点击弹出通用弹窗说明"]
[]
[{"$nulls":9},3,"导航标签"]
[]
[]
[]
[]
[]
[{"$nulls":10},"1）共4个标签，默认选中【热门饰品】"]
[]
[{"$nulls":10},"2）热门饰品即为选择的指定道具开箱"]
[]
[{"$nulls":10},"3）选中后下方显示饰品"]
[]
[]
[{"$nulls":9},4,"搜索栏"]
[]
[{"$nulls":10},"点击输入饰品名字，点击放大镜搜索"]
[]
[]
[]
[]
[{"$nulls":9},5,"价格排序"]
[]
[{"$nulls":10},"1）点击高到低与低到高切换"]
{"$rows_empty":7}
[{"$nulls":10},"点击饰品名字"]
[{"$nulls":10},"弹出气泡，显示饰品全名"]
[]
[]
[{"$nulls":12},6,"筛选"]
[]
[{"$nulls":13},"1）点击右侧拉出筛选页"]
{"$rows_empty":13}
[{"$nulls":13},"2）类别"]
[{"$nulls":14},"如左图1，共19种"]
[]
[{"$nulls":13},"3）型号"]
[{"$nulls":14},"当选中具体类别后，显示该类别的型号选择"]
[{"$nulls":14},"每种类型有不同型号"]
[]
[{"$nulls":13},"4）价格范围筛选"]
[]
[{"$nulls":15},"点击恢复默认价格"]
[]
[{"$nulls":15},"点击输入最低或最高价"]
[]
[]
[{"$nulls":15},"默认设置的4种价格范围选择"]
{"$rows_empty":13}
[{"$nulls":15},"确定取消固定在下方显示，不可滑动，即绿框区域才可滑动"]
[]
[]
[]
[]
[]
[]
[null,"【指定道具开箱】"]
[]
[]
[{"$nulls":10},1,"进入开箱界面"]
{"$rows_empty":25}
[{"$nulls":11},"在热门饰品界面，点击饰品，进入开箱界面左图"]
[]
[{"$nulls":10},2,"标题&返回"]
[]
[]
[{"$nulls":10},3,"饰品展示部分"]
[]
[]
[]
[]
[{"$nulls":16},"道具名"]
{"$rows_empty":11}
[{"$nulls":12},"左侧和中间是同一件道具"]
[{"$nulls":11},"左侧：显示损耗成都名字"]
[]
[{"$nulls":11},"中间：显示所选择的抽奖概率"]
[]
[{"$nulls":11},"右侧：固定显示随机道具"]
[]
[]
[]
[]
[]
[{"$nulls":10},4,"概率选择"]
[]
[{"$nulls":11},"1）快捷概率选择"]
[]
[{"$nulls":12},"拖动条上方显示5种系统默认概率按钮，方便玩家快捷调节"]
[]
[{"$nulls":12},0.05]
[{"$nulls":12},0.1]
[{"$nulls":12},0.25]
[{"$nulls":12},0.5]
[{"$nulls":12},0.85,null,"点击选中高亮"]
[]
[{"$nulls":11},"2）拖动条"]
{"$rows_empty":8}
[{"$nulls":10},5,"抽奖"]
[]
[]
[]
[]
[]
[{"$nulls":11},"1）显示该概率的抽奖价钱"]
[]
[]
[{"$nulls":10},6,"磨损程度名字"]
[]
[{"$nulls":11},"1）共6种"]
[]
[{"$nulls":11},"①破损不堪"]
[{"$nulls":11},"②久经沙场"]
[{"$nulls":11},"③崭新出厂"]
[{"$nulls":11},"④战痕累累"]
[{"$nulls":11},"⑤略有磨损"]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"2）可左右滑动选择"]
[]
[{"$nulls":11},"①点击选中高亮"]
[]
[{"$nulls":11},"4）显示内容"]
[]
[{"$nulls":11},"①磨损程度名字"]
[{"$nulls":11},"②价钱"]
[]
[null,"【掉落历史记录】"]
[]
[]
[]
[]
[{"$nulls":16},"低品质颜色"]
[]
[]
[{"$nulls":16},"高品质颜色"]
[]
[]
[]
[]
[{"$nulls":11},"从左到右显示内容"]
[{"$nulls":11},"1）头像"]
[{"$nulls":11},"2）饰品名字"]
[null,"无记录",{"$nulls":9},"3）饰品图标（选中抽奖的饰品）"]
[{"$nulls":11},"4）抽奖价钱"]
[{"$nulls":11},"5）抽奖概率"]
[{"$nulls":11},"6）获得的奖励图标"]
[]
[{"$nulls":11},"7）底图颜色"]
[{"$nulls":12},"同开盲盒记录（通用2种颜色区别品质）"]
[]
[]
[{"$nulls":12},"可上下滑动"]
[]
[]
[]
[null,"【抽奖】"]
[]
[]
[]
[]
[{"$nulls":11},1,"抽奖"]
[]
[]
[{"$nulls":12},"1）点击弹出抽奖动画"]
[]
[{"$nulls":12},"2）奖品动画"]
[{"$nulls":13},"只需显示道具图和品质颜色即可"]
[]
[]
[]
[{"$nulls":12},"3）中奖"]
{"$rows_empty":7}
[{"$nulls":12},"中间的线为中奖道具"]
[]
[{"$nulls":13},"具体动画查看【Z-追梦抽奖】视频"]
{"$rows_empty":8}
[{"$nulls":10},2,"获得奖励弹窗"]
[]
[]
[]
[{"$nulls":11},"1）道具显示"]
[{"$nulls":12},"通用的道具显示图即可"]
{"$rows_empty":13}
[{"$nulls":11},"2）道具价钱"]
[]
[]
[{"$nulls":11},"3）【分解】及【放入背包】按钮，两种颜色不同色"]
[]
[]
[]
[]
[]
[]
[{"$nulls":11},"通用飘字提示"]
[]
[{"$nulls":11},"错误码、系统提示等等"]