{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["硬标签+行为","选项-人群分类对应表","空间需求看板 - 软数据"],"not_rendered":{"charts":0,"images":23,"macros":0,"external_links":0,"defined_names":2,"comments":1,"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":202,"n_cols":29,"rows_kept":202,"cut":false,"hidden":false,"merged":[[2,0,2,1],[23,0,23,1],[5,0,8,0],[163,0,169,0],[170,0,180,0],[181,0,184,0],[185,0,188,0],[189,0,195,0],[196,0,201,0],[5,1,7,1],[24,1,28,1],[29,1,34,1],[35,1,40,1],[41,1,44,1],[45,1,49,1],[50,1,55,1],[56,1,59,1],[60,1,65,1],[67,1,70,1],[71,1,72,1],[73,1,74,1],[75,1,77,1],[78,1,79,1],[81,1,82,1],[84,1,89,1],[90,1,95,1],[101,1,102,1],[113,1,115,1],[116,1,117,1],[122,1,124,1],[125,1,128,1],[131,1,133,1],[137,1,138,1],[139,1,140,1],[143,1,145,1],[146,1,147,1],[151,1,152,1],[153,1,155,1],[157,1,158,1],[27,6,28,6],[29,6,30,6],[31,6,34,6],[35,6,36,6],[37,6,40,6],[50,6,51,6],[52,6,55,6],[56,6,57,6],[58,6,59,6],[163,7,169,7],[170,7,180,7],[181,7,184,7],[185,7,188,7],[189,7,195,7],[196,7,201,7],[106,8,110,8],[24,15,28,15],[29,15,34,15],[35,15,40,15],[41,15,44,15],[45,15,49,15],[50,15,55,15],[56,15,59,15],[24,16,28,16],[24,17,28,17],[24,18,28,18],[29,18,34,18],[35,18,40,18],[41,18,44,18],[45,18,49,18],[50,18,55,18],[56,18,59,18],[60,18,65,18],[67,18,70,18],[71,18,72,18],[73,18,74,18],[75,18,77,18],[78,18,79,18],[81,18,82,18],[84,18,89,18],[90,18,95,18],[101,18,102,18],[113,18,115,18],[116,18,117,18],[122,18,124,18]]}
[" "]
["标签分类","标签项","父题序号","父题选项序号","相关性系数（k）","匹配父题中的选项","题干前提","对应父题","示例","分子值(a)","分母值(b)","百分比(c)","人数权重(d)","相关性系数（k）","偏离值(e)","标准分(f)","标准分计算公式","计算思路","算法文字描述","后台数据库表及字段","备注"]
["1. 整体画像"]
["性别","男","F00047","F00047-FA001",1,"男",null,"用户画像：性别",{"$nulls":5},1,{"$nulls":4},"直接匹配"]
[null,"女","F00047","F00047-FA002",1,"女",null,"用户画像：性别",{"$nulls":5},1,{"$nulls":4},"直接匹配"]
["生命周期","一代居","F00059","F00059-FA001",0.3,"单身",null,"用户画像：家庭结构",{"$nulls":5},0.3,{"$nulls":4},"直接匹配",null,"选项文案作处理"]
[null,null,"F00059","F00059-FA002",0.3,"未婚,有男女朋友",null,"用户画像：家庭结构",{"$nulls":5},0.3,{"$nulls":4},"直接匹配"]
[null,null,"F00059","F00059-FA003",0.3,"已婚无娃",null,"用户画像：家庭结构",{"$nulls":5},0.3,{"$nulls":4},"直接匹配"]
[null,"两代居","F00059","F00059-FA004",1,"已婚有娃",null,"用户画像：家庭结构",{"$nulls":5},1,{"$nulls":4},"直接匹配"]
["职业阶段",null,"F00076","F00076-FA001",null,"学生：通勤",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配",null,"无法直接匹配到具体职业"]
[null,null,"F00076","F00076-FA002",null,"学生：住校",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
[null,null,"F00076","F00076-FA003",null,"在家办公、自由职业",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
[null,null,"F00076","F00076-FA004",null,"上班族",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
[null,null,"F00076","F00076-FA005",null,"待业无业在家",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
[null,null,"F00076","F00076-FA006",null,"全职太太/先生",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
[null,null,"F00076","F00076-FA007",null,"退休在家",null,"用户画像：职业阶段",{"$nulls":10},"直接匹配"]
["城市-上海","上海",null,null,1,null,null,"测试者设备地理位置信息",{"$nulls":5},1]
["城市-环沪","苏州",null,null,1,null,null,"测试者设备地理位置信息",{"$nulls":5},1]
[null,"杭州",null,null,1,{"$nulls":8},1]
[null,"无锡",null,null,1,{"$nulls":8},1]
[null,"宁波",null,null,1,{"$nulls":8},1]
[]
[]
["2. 行为兴趣"]
[null,"看影视","F00074","F00074-FA009",0.2,"影视","户内"," ",null,"a1","b1","c1","d1",0.2,"e1","f","百分比  c1=a1/b1\n\n人数权重 d1=c1/sum(c1: c5)\n\n相关性系数 k值为手工输入\n\n偏离值 e1=c1-min(c1: c5)\n\n标准分 \nf=min(c1: c5)+e1*k1+e2*k2+e3*k3+e4*k4+e5*k5","标准分值的计算使用的是 线性回归方程式，\nY=A1X1+A2X2+A3X3+...+C（常数）","分子值：该选项的总点击数\n\n分母值：该选项所在测试总的收回数量\n\n人数权重：该选项在所有相关选项总数中的占比\n\n相关性系数：CNC人工给到的冷启动数字，系数需要做成配置表，方便后期人工调整\n\n偏离值：该选项百分比与最小百分比值的差值\n\n标准分：产品前端用作可视化的数值",null,"分母待处理、权重待定、未知"]
[null,null,"F00080","F00080-FA010",0.2,"影视","户内","套内行为场景：占时最久",null,"a2","b2","c2","d2",0.2,"e2"]
[null,null,"F00072","F00072-FA012",0.2,"影视 ","户内","空间配行为：临窗空间",null,"a3","b3","c3","d3",0.2,"e3"]
[null,null,"F00088","F00088-FA009",0.2,"影视","公区","公区行为场景：单个行为场景",null,"a4","b4","c4","d4",0.2,"e4"]
[null,null,"F00053","F00053-FA001",0.2,"影视 ",null,"公区空间配行为：客厅",null,"a5","b5","c5","d5",0.2,"e5"]
[null,"阅读","F00074","F00074-FA013",0.17,"阅读 ","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,0.17,{"$nulls":6},"分母待处理、权重待定、未知"]
[null,null,"F00085","F00085-FA001",{"$f":"1-E30-E32-E33-E34-E35","v":0.16},"茶艺+咖啡+阅读","户内","公区行为场景：行为场景混生",null,"a3",null,null,null,{"$f":"1-N30-N32-N33-N34-N35","v":0.16}]
[null,null,"F00088","F00088-FA006",0.17,"阅读 ","公区","公区行为场景：单个行为场景",null,"a4",null,null,null,0.17]
[null,null,"F00085","F00085-FA001",0.16,"茶艺+咖啡+阅读 ",null,"公区行为场景：行为场景混生",null,"a5",null,null,null,0.16]
[null,null,"F00122","F00122-FA005",0.17,"阅读 ",null,"公区空间配行为：大堂",null,"a6",null,null,null,0.17]
[null,null,"F00053","F00053-FA008",0.17,"阅读 ",null,"公区空间配行为：客厅",null,"a7",null,null,null,0.17]
[null,"喝咖啡","F00074","F00074-FA031\n",0.18,"咖啡制作","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,0.18]
[null,null,"F00085","F00085-FA001",{"$f":"1-E36-E38-E39-E41-E40","v":0.14},"茶艺+咖啡+阅读 ",null,"公区行为场景：行为场景混生",null,"a2",null,null,null,{"$f":"1-N36-N38-N39-N41-N40","v":0.14}]
[null,null,"F00088","F00088-FA002",0.18,"咖啡","公区","公区行为场景：单个行为场景",null,"a3",null,null,null,0.18,{"$nulls":6},"是否合并，及权重"]
[null,null,"F00088","F00088-FA002",0.18,"咖啡",null,"公区行为场景：单个行为场景",null,"a4",null,null,null,0.18]
[null,null,"F00085","F00085-FA001",0.14,"茶艺+咖啡+阅读 ",null,"公区行为场景：行为场景混生",null,"a5",null,null,null,0.14]
[null,null,"F00122","F00122-FA004",0.18,"咖啡 ",null,"公区空间配行为：大堂",null,"a6",null,null,null,0.18]
[null,"小憩","F00074","F00074-FA010",0.3,"睡眠","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,0.3,{"$nulls":6},"无此数据源，是否选择睡眠一项"]
[null,null,"F00072","F00072-FA001",null,"睡眠","户内","空间配行为：临窗空间"]
[null,null,"F00074","F00074-FA010",0.3,"睡眠","公区","套内行为场景：单个行为场景",null,"a2",null,null,null,0.3]
[null,null,"F00072","F00072-FA001",0.3,"睡眠","公区","空间配行为：临窗空间",null,"a3",null,null,null,0.3]
[null,"玩电脑游戏","F00080","F00080-FA003",{"$f":"1-E47-E48-E49-E50","v":0.1},"打游戏","套内","套内行为场景：占时最久",null,"a1",null,null,null,{"$f":"1-N47-N48-N49-N50","v":0.1},{"$nulls":6},"多项数据源的合并处理、权重待定"]
[null,null,"F00053","F00053-FA002",0.3,"打游戏（电脑）","公区","空间配行为：客厅",null,"a2",null,null,null,0.3]
[null,null,"F00074","F00074-FA015",0.3,"打游戏（电脑)","户内","套内行为场景：单个行为场景",null,"a3",null,null,null,0.3]
[null,null,"F00126","F00126-FA003",0.15,"电脑 ","户内","周末套内行为场景：占时最久",null,"a4",null,null,null,0.15]
[null,null,"F00072","F00072-FA014",0.15,"电脑 ","户内","空间配行为：临窗空间",null,"a5",null,null,null,0.15]
[null,"平板塑形","F00074","F00074-FA030",0.18,"瑜伽","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,0.18,{"$nulls":6},"无数据源、其他题健身与瑜伽选项"]
[null,null,"F00085","F00085-FA003",0.17,"瑜伽+健身+跑步",null,"公区行为场景：行为场景混生",null,"a2",null,null,null,0.17]
[null,null,"F00088","F00088-FA004",0.18,"瑜伽","公区","公区行为场景：单个行为场景",null,"a3",null,null,null,0.18]
[null,null,"F00085","F00085-FA003",{"$f":"1-E51-E53-E55-E56-E52","v":0.17},"瑜伽+健身+跑步",null,"公区行为场景：行为场景混生",null,"a4",null,null,null,{"$f":"1-N51-N53-N55-N56-N52","v":0.17}]
[null,null,"F00123","F00123-FA003",0.15,"健身 ",null,"公共空间配行为：露台",null,"a5",null,null,null,0.15]
[null,null,"F00080","F00080-FA002",0.15,"健身",null,"套内行为场景：占时最久",null,"a6",null,null,null,0.15]
[null,"插花","F00126","F00074-FA025",{"$f":"1-E58-E59-E60","v":0.15},"手工","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,{"$f":"1-N58-N59-N60","v":0.15},{"$nulls":6},"无数据源、其他题养植物选项"]
[null,null,"F00085","F00085-FA002",0.2,"桌游+手工+花艺",null,"公区行为场景：行为场景混生",null,"a2",null,null,null,0.2]
[null,null,"F00085","F00085-FA002",0.2,"桌游+手工+花艺","公区","公区行为场景：行为场景混生",null,"a3",null,null,null,0.2]
[null,null,"F00122","F00122-FA006",0.45,"花艺",null,"公区空间配行为：大堂",null,"a4",null,null,null,0.45]
[null,"工作学习","F00074","F00074-FA012",0.1,"工作","户内","套内行为场景:单个行为场景\n",null,"a1",null,null,null,0.1,{"$nulls":6},"是否拆分"]
[null,null,"F00072","F00072-FA013",0.1,"工作 ","户内","空间配行为：临窗空间",null,"a2",null,null,null,0.1]
[null,null,"F00072","F00072-FA002",0.1,"书桌","户内","空间配行为：临窗空间",null,"a3",null,null,null,0.1]
[null,null,"F00072","F00072-FA014",{"$f":"1-E61-E62-E63-E65-E66","v":0.5},"电脑","户内","空间配行为：临窗空间",null,"a4",null,null,null,{"$f":"1-N61-N62-N63-N65-N66","v":0.5}]
[null,null,"F00126","F00126-FA006",0.1,"工作","户内","周末套内行为场景：占时最久",null,"a5",null,null,null,0.1]
[null,null,"F00072","F00072-FA013",0.1,"工作","户内","空间配行为：客厅",null,"a6",null,null,null,0.1]
[null,"打扫清洁","F00126","F00126-FA005",1,"收拾打扫","户内","周末套内行为场景：占时最久",null,"a1",null,null,null,1,{"$nulls":6},"收纳是否合并"]
[null,"喝酒","F00088","F00088-FA012",0.25,"酒吧 转换得来","公区","公区行为场景：单个行为场景",null,"a1",null,null,null,0.25]
[null,null,"F00123","F00123-FA004",0.25,"酒吧 ","公区","公区空间配行为：露台",null,"a2",null,null,null,0.25]
[null,null,"F00072","F00072-FA006",0.25,"酒吧 ","公区","空间配行为：临窗空间",null,"a3",null,null,null,0.25]
[null,null,"F00072","F00072-FA006",0.25,"酒吧 ","户内","空间配行为：临窗空间",null,"a4",null,null,null,0.25]
[null,"喝茶","F00085","F00085-FA001",0.25,"茶艺+咖啡+阅读 ","公区","公区行为场景：行为场景混生",null,"a2",null,null,null,0.25]
[null,null,"F00072","F00072-FA007",0.5,"茶艺 ","户内","空间配行为：临窗空间",null,"a3",null,null,null,0.5]
[null,"睡觉","F00126","F00126-FA007",0.3,"睡眠 ","户内","周末套内行为场景：占时最久",null,"a1",null,null,null,0.3]
[null,null,"F00072","F00072-FA001",0.3,"睡眠","户内","空间配行为：临窗空间",null,"a2",null,null,null,0.3]
[null,"冥想","F000126","F00126-FA007",0.2,"睡眠 ","户内","周末套内行为场景：占时最久",null,"a1",null,null,null,0.2]
[null,null,"F00074","F00074-FA010",0.2,"睡眠","户内","套内行为场景:单个行为场景\n",null,"a2",null,null,null,0.2]
[null,null,"F00072","F00072-FA001",0.2,"睡眠 ","户内","空间配行为：临窗空间",null,"a3",null,null,null,0.2]
[null,"跑步","F00085","F00085-FA003",0.4,"瑜伽+健身+跑步","户内","公区行为场景：行为场景混生",null,"a1",null,null,null,0.4]
[null,null,"F00085","F00085-FA003",0.4,"瑜伽+健身+跑步 ","公区","公区行为场景：行为场景混生",null,"a2",null,null,null,0.4]
[null,"打篮球","F00122","F00122-FA009",0.5,"健身","公区","公区空间配行为：大堂",null,"a1",null,null,null,0.5]
[null,"打乒乓","F00088","F00088-FA008",0.5,"乒乓球 ","公区","公区行为场景：单个行为场景",null,"a1",null,null,null,0.5]
[null,null,"F00122","F00122-FA007",0.5,"乒乓球","公区","公区空间配行为：大堂",null,"a2",null,null,null,0.5]
[null,"游泳","F00123","F00123-FA002",1,"游泳 ","公区","公共空间配行为：露台",null,"a1",null,null,null,1]
[null,"大器械","F00074","F00074-FA020",0.1,"健身","户内","套内行为场景：单个行为场景",null,"a1",null,null,null,0.1]
[null,null,"F00080","F00080-FA002",0.1,"健身 ","户内","套内行为场景：占时最久",null,"a2",null,null,null,0.1]
[null,null,"F00085","F00085-FA003",0.05,"瑜伽+健身+跑步 ","公区","公区行为场景：行为场景混生",null,"a3",null,null,null,0.05]
[null,null,"F00088","F00088-FA005",0.1,"健身 ","公区","公区行为场景：单个行为场景",null,"a4",null,null,null,0.1]
[null,null,"F00085","F00085-FA003",0.05,"瑜伽+健身+跑步 ","公区","公区行为场景混生",null,"a5",null,null,null,0.05,{"$nulls":12},"a1","b1","权重"]
[null,null,"F00122","F00122-FA009",0.1,"健身 ","公区","公区空间配行为：大堂",null,"a6",null,null,null,0.1,{"$nulls":12},50,100,{"$f":"AA90/AB90","v":0.5}]
[null,"小器械","F00074","F00074-FA020",0.1,"健身 ","户内","套内行为场景:单个行为场景\n",null,"a1",null,null,null,0.1,{"$nulls":12},"a2","b2","权重"]
[null,null,"F00080","F00080-FA002",0.1,"健身 ","户内","套内行为场景：占时最久",null,"a2",null,null,null,0.1,{"$nulls":12},70,200,{"$f":"AA92/AB92","v":0.35}]
[null,null,"F00085","F00085-FA003",0.05,"瑜伽+健身+跑步 ","户内","公区行为场景：行为场景混生",null,"a3",null,null,null,0.05]
[null,null,"F00088","F00088-FA005",0.1,"健身 ","公区","公区行为场景：单个行为场景",null,"a4",null,null,null,0.1,{"$nulls":12},"原始值"]
[null,null,"F00085","F00085-FA003",0.05,"瑜伽+健身+跑步 ","公区","公区行为场景：行为场景混生",null,"a5",null,null,null,0.05]
[null,null,"F00122","F00122-FA009",0.1,"健身","公区","公区空间配行为：大堂",null,"a6",null,null,null,0.1]
[null,"失眠","F00073","F00073-FA004",null,"影视+睡眠","户内","套内行为场景：行为场景混生"]
[null,"养猫","F00072","F00072-FA008",0.5,"宠物","户内","空间配行为：临窗空间",null,"a1",null,null,null,0.5,{"$nulls":6},"目前无数据来源"]
[null,"养狗","F00072","F00072-FA008",0.5,"宠物","户内","空间配行为：临窗空间",null,"a1",null,null,null,0.5]
[null,"养冷血动物","F00072","F00072-FA008",0.5,"宠物","户内","空间配行为：临窗空间",null,"a1",null,null,null,0.5]
[null,"养哺乳动物","F00072","F00072-FA008",0.5,"宠物 ","户内","空间配行为：临窗空间",null,"a1",null,null,null,0.5]
[null,"洗澡美容","F00053","F00053-FA006",0.5,"盆浴 ",null,"空间配行为：客厅",{"$nulls":5},0.5]
[null,null,"F00072","F00072-FA003",0.5,"盆浴 ","户内","空间配行为：临窗空间",{"$nulls":5},0.5]
[null,"托管游戏","F00072","F00072-FA008",0.5,"宠物 ","户内","空间配行为：临窗空间",{"$nulls":5},0.5]
[null,"遛狗遛猫","F00053","F00072-FA008",0.5,"宠物 ","户内","空间配行为：临窗空间",{"$nulls":5},0.5]
[null,"洗干熨衣","F00057"]
[null,"做陶艺","F00074","F00074-FA025",0.5,"手工 ","户内","套内行为场景:单个行为场景",{"$nulls":5},0.5]
[null,"做模型","F00074","F00074-FA025",0.5,"手工 ","户内","套内行为场景:单个行为场景",{"$nulls":5},0.5]
[null,"做布艺","F00085","F00085-FA002",0.5,"桌游+手工+花艺 ","公区","公区行为场景：行为场景混生",{"$nulls":5},0.5]
[null,"做首饰","F00074","F00074-FA025",0.5,"手工 ","户内","套内行为场景:单个行为场景",{"$nulls":5},0.5]
[null,"画布作画","F00074","F00074-FA023",1,"绘画 ","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"数字做插画","F00074","F00074-FA023",1,"绘画 ","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"直播"]
[null,"唱歌","F00074","F00074-FA024",0.1,"玩乐器 ","户内","套内行为场景:单个行为场景",{"$nulls":5},0.1]
[null,null,"F00126","F00126-FA008",0.1,"听音乐 ","户内","周末套内行为场景：占时最久",{"$nulls":5},0.1]
[null,null,"F00088","F00088-FA010",0.8,"KTV ","公区","公区行为场景：单个行为场景",{"$nulls":5},0.8]
[null,"美妆","F00074","F00074-FA014",0.5,"美妆 ","户内","套内行为场景:单个行为场景\n",{"$nulls":5},0.5]
[null,null,"F00072","F00072-FA009",0.5,"美妆 ","户内","空间配行为：临窗空间",{"$nulls":5},0.5]
[null,"玩乐器","F00074","F00074-FA024",1,"玩乐器 ","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"收藏","F00074","F00074-FA008",1,"展示 ","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"收纳","F00074","F00074-FA011",1,"收纳 ","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"玩体感游戏","F00080","F00080-FA003",0.5,"打游戏 ","户内","套内行为场景：占时最久",{"$nulls":5},0.5]
[null,"玩桌游","F00088","F00088-FA001",0.5,"桌游 ","公区","公区行为场景：单个行为场景",{"$nulls":5},0.5]
[null,null,"F00085","F00085-FA002",0.25,"桌游+手工+花艺 ","公区","公区行为场景：行为场景混生",{"$nulls":5},0.25]
[null,null,"F00085","F00085-FA002",0.25,"桌游+手工+花艺 ","户内","公区行为场景：行为场景混生",{"$nulls":5},0.25]
[null,"美容护肤","F00074","F00074-FA014",0.25,"美妆","户内","套内行为场景:单个行为场景",{"$nulls":5},0.25]
[null,null,"F00072","F00072-FA009",0.25,"美妆","户内","空间配行为：临窗空间",{"$nulls":5},0.25]
[null,null,"F00107","F00107-FA007",0.25,"美妆","户内","ECS原型配行为：魔方showbox",{"$nulls":5},0.25]
[null,null,"F00122","F00122-FA002",{"$f":"1-E128-E127-E126","v":0.25},"美容美发","公区","公区空间配行为：大堂",{"$nulls":5},{"$f":"1-N128-N127-N126","v":0.25}]
[null,"洗漱",null,null,1,"洗漱",{"$nulls":7},1]
[null,"淋浴","F00057","F00057-FA002",1,"淋浴","户内","行为场景PK：盆浴vs淋浴",{"$nulls":5},1]
[null,"泡澡","F00074","F00074-FA006",0.3,"盆浴","户内","套内行为场景:单个行为场景",{"$nulls":5},0.3]
[null,null,"F00053","F00053-FA006",0.3,"盆浴","户内","空间配行为：客厅",{"$nulls":5},0.3]
[null,null,"F00057","F00057-FA001",0.5,"盆浴","户内","行为场景PK：盆浴vs淋浴",{"$nulls":5},0.5]
[null,"湿蒸","F00123","F00123-FA002",0.5,"游泳","公区","公共空间配行为：露台",{"$nulls":5},0.5]
[null,"桑拿","F00123","F00123-FA002",0.5,"游泳","公区","公共空间配行为：露台",{"$nulls":5},0.5]
[null,"spa ","F00123","F00123-FA002",0.5,"游泳","公区","公共空间配行为：露台",{"$nulls":5},0.5]
[null,"做中餐","F00074","F00074-FA007",0.4,"烹饪","户内","套内行为场景:单个行为场景",{"$nulls":5},0.4]
[null,null,"F00080","F00080-FA005",0.4,"烹饪","户内","套内行为场景：占时最久",{"$nulls":5},0.4]
[null,"做西餐","F00074","F00074-FA007",0.4,"烹饪","户内","套内行为场景:单个行为场景",{"$nulls":5},0.4]
[null,null,"F00080","F00080-FA005",0.4,"烹饪","户内","套内行为场景：占时最久",{"$nulls":5},0.4]
[null,"烧烤"]
[null,"烘培","F00074","F00074-FA029",1,"烘培","户内","套内行为场景:单个行为场景",{"$nulls":5},1]
[null,"就餐","F00053","F00053-FA005",0.3,"就餐","户内","空间配行为：客厅",{"$nulls":5},0.3]
[null,null,"F00074","F00074-FA016",0.3,"就餐","户内","套内行为场景:单个行为场景",{"$nulls":5},0.3]
[null,null,"F00072","F00072-FA005",0.3,"就餐","户内","空间配行为：临窗空间",{"$nulls":5},0.3]
[null,"仪容仪表","F00074","F00074-FA005",0.3,"更衣","户内","套内行为场景:单个行为场景",{"$nulls":5},0.3]
[null,null,"F00107","F00107-FA008",0.3,"更衣","户内","ECS原型配行为：魔方showbox",{"$nulls":5},0.3]
[null,"收包裹"]
[null,"收生鲜"]
[null,"追星"]
[null,"种菜","F00074","F00074-FA002",0.3,"养植物","户内","套内行为场景:单个行为场景",{"$nulls":5},0.3]
[null,null,"F00123","F00123-FA005",0.5,"农场","公区","公共空间配行为：露台",{"$nulls":5},0.5]
[null,"种花","F00074","F00074-FA002",0.3,"养植物","户内","套内行为场景:单个行为场景",{"$nulls":5},0.3]
[null,null,"F00122","F00122-FA006",0.2,"花艺","公区","公区空间配行为：大堂",{"$nulls":5},0.2]
[null,null,"F00123","F00123-FA005",{"$f":"1-E155-E154","v":0.5},"农场","公区","公共空间配行为：露台",{"$nulls":5},{"$f":"1-N155-N154","v":0.5}]
[null,"微聚会"]
[null,"聚会","F00074","F00074-FA028",0.5,"聚会","户内","套内行为场景:单个行为场景",{"$nulls":5},0.5]
[null,null,"F00053","F00053-FA007",0.5,"聚会","户内","空间配行为：客厅",{"$nulls":5},0.5]
[]
[]
[]
[]
["材质","玻璃",null,null,null,"玻璃",null,"软装偏好什么样的材质",{"$nulls":10},"直接匹配"]
[null,"绸缎",null,null,null,"绸缎",{"$nulls":12},"直接匹配"]
[null,"金属",null,null,null,"金属",{"$nulls":12},"直接匹配"]
[null,"棉麻",null,null,null,"棉麻",{"$nulls":12},"直接匹配"]
[null,"木质",null,null,null,"木质",{"$nulls":12},"直接匹配"]
[null,"皮革",null,null,null,"皮革",{"$nulls":12},"直接匹配"]
[null,"石材",null,null,null,"石材",{"$nulls":12},"直接匹配"]
["单品偏好","餐桌",null,null,null,"餐桌",null,"家具单品最重视什么",{"$nulls":10},"直接匹配"]
[null,"茶几",null,null,null,"茶几",{"$nulls":12},"直接匹配"]
[null,"床",null,null,null,"床",{"$nulls":12},"直接匹配"]
[null,"电视柜",null,null,null,"电视柜",{"$nulls":12},"直接匹配"]
[null,"电视机",null,null,null,"电视机",{"$nulls":12},"直接匹配"]
[null,"沙发",null,null,null,"沙发",{"$nulls":12},"直接匹配"]
[null,"收纳柜",null,null,null,"收纳柜",{"$nulls":12},"直接匹配"]
[null,"书桌",null,null,null,"书桌",{"$nulls":12},"直接匹配"]
[null,"衣柜",null,null,null,"衣柜",{"$nulls":12},"直接匹配"]
[null,"椅子",null,null,null,"椅子",{"$nulls":12},"直接匹配"]
[null,"浴缸",null,null,null,"浴缸",{"$nulls":12},"直接匹配"]
["色调偏好","冷色系",null,null,null,"冷色系",null,"软装偏好什么色调",{"$nulls":10},"直接匹配"]
[null,"暖色系",null,null,null,"暖色系",{"$nulls":12},"直接匹配"]
[null,"主冷色系+辅暖色系",null,null,null,"主冷色系+辅暖色系",{"$nulls":12},"直接匹配"]
[null,"主暖色系+辅冷色系",null,null,null,"主暖色系+辅冷色系",{"$nulls":12},"直接匹配"]
["色相偏好","黑",null,null,null,"黑",null,"软装偏好什么色相",{"$nulls":10},"直接匹配"]
[null,"科技蓝",null,null,null,"科技蓝",{"$nulls":12},"直接匹配"]
[null,"明亮色系",null,null,null,"明亮色系",{"$nulls":12},"直接匹配"]
[null,"优雅粉",null,null,null,"优雅粉",{"$nulls":12},"直接匹配"]
["精装关注点","材质",null,null,null,"材质",null,"你最在乎厨房橱柜的哪些方面",{"$nulls":10},"直接匹配"]
[null,"工艺",null,null,null,"工艺",{"$nulls":12},"直接匹配"]
[null,"价格",null,null,null,"价格",{"$nulls":12},"直接匹配"]
[null,"品牌",null,null,null,"品牌",{"$nulls":12},"直接匹配"]
[null,"颜色",null,null,null,"颜色",{"$nulls":12},"直接匹配"]
[null,"造型",null,null,null,"造型",{"$nulls":12},"直接匹配"]
[null,"质量",null,null,null,"质量",{"$nulls":12},"直接匹配"]
["空间特性偏好","便利性",null,null,null,"便利性",null,"你重视套内空间的哪些特性",{"$nulls":10},"直接匹配"]
[null,"空间舒展",null,null,null,"空间舒展",{"$nulls":12},"直接匹配"]
[null,"美观+舒适",null,null,null,"美观+舒适",{"$nulls":12},"直接匹配"]
[null,"收纳性",null,null,null,"收纳性",{"$nulls":12},"直接匹配"]
[null,"舒适",null,null,null,"舒适",{"$nulls":12},"直接匹配"]
[null,"颜值",null,null,null,"颜值",{"$nulls":12},"直接匹配"]

{"sheet":"选项-人群分类对应表","index":1,"n_rows":138,"n_cols":36,"rows_kept":138,"cut":false,"hidden":false,"merged":[[1,6,1,11],[1,0,2,0],[1,1,2,1],[3,1,7,1],[8,1,13,1],[14,1,19,1],[20,1,23,1],[24,1,28,1],[29,1,34,1],[35,1,38,1],[39,1,44,1],[46,1,49,1],[50,1,51,1],[52,1,53,1],[54,1,56,1],[57,1,58,1],[60,1,61,1],[63,1,68,1],[69,1,74,1],[80,1,81,1],[92,1,94,1],[95,1,96,1],[101,1,103,1],[104,1,107,1],[110,1,112,1],[116,1,117,1],[118,1,119,1],[122,1,124,1],[125,1,126,1],[130,1,131,1],[132,1,134,1],[136,1,137,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[6,14,7,14],[8,14,9,14],[10,14,13,14],[14,14,15,14],[16,14,19,14],[29,14,30,14],[31,14,34,14],[35,14,36,14],[37,14,38,14],[85,15,89,15],[3,22,7,22],[8,22,13,22],[14,22,19,22],[20,22,23,22],[24,22,28,22],[29,22,34,22],[35,22,38,22],[3,23,7,23],[3,24,7,24],[3,25,7,25],[8,25,13,25],[14,25,19,25],[20,25,23,25],[24,25,28,25],[29,25,34,25],[35,25,38,25],[39,25,44,25],[46,25,49,25],[50,25,51,25],[52,25,53,25],[54,25,56,25],[57,25,58,25],[60,25,61,25],[63,25,68,25],[69,25,74,25],[80,25,81,25],[92,25,94,25],[95,25,96,25],[101,25,103,25]]}
[" "]
["标签分类","标签项","父题序号","对应父题","父题选项序号","匹配父题中的选项","人群分类",{"$nulls":7},"题干前提","示例","分子值(a)","分母值(b)","百分比(c)","人数权重(d)","相关性系数（k）","偏离值(e)","标准分(f)","标准分计算公式","计算思路","算法文字描述","后台数据库表及字段","备注"]
[{"$nulls":6},"A","B","C","D","E","F"]
[null,"看影视","F00074"," ","F00074-FA009","影视",1,1,null,null,1,1,null,null,"户内",null,"a1","b1","c1","d1",0.2,"e1","f","百分比  c1=a1/b1\n\n人数权重 d1=c1/sum(c1: c5)\n\n相关性系数 k值为手工输入\n\n偏离值 e1=c1-min(c1: c5)\n\n标准分 \nf=min(c1: c5)+e1*k1+e2*k2+e3*k3+e4*k4+e5*k5","标准分值的计算使用的是 线性回归方程式，\nY=A1X1+A2X2+A3X3+...+C（常数）","分子值：该选项的总点击数\n\n分母值：该选项所在测试总的收回数量\n\n人数权重：该选项在所有相关选项总数中的占比\n\n相关性系数：CNC人工给到的冷启动数字，系数需要做成配置表，方便后期人工调整\n\n偏离值：该选项百分比与最小百分比值的差值\n\n标准分：产品前端用作可视化的数值",null,"分母待处理、权重待定、未知"]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA010","影视",1,1,null,null,1,1,null,null,"户内",null,"a2","b2","c2","d2",0.2,"e2"]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA012","影视 ",1,1,null,null,1,1,null,null,"户内",null,"a3","b3","c3","d3",0.2,"e3"]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA009","影视",1,1,null,null,1,1,null,null,"公区",null,"a4","b4","c4","d4",0.2,"e4"]
[null,null,"F00053","公区空间配行为：客厅","F00053-FA001","影视 ",1,1,null,null,1,1,{"$nulls":4},"a5","b5","c5","d5",0.2,"e5"]
[null,"阅读","F00074","套内行为场景：单个行为场景","F00074-FA013","阅读 ",1,null,null,null,1,null,null,null,"户内",null,"a1",null,null,null,0.17,{"$nulls":6},"分母待处理、权重待定、未知"]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA001","茶艺+咖啡+阅读",1,null,null,null,1,null,null,null,"户内",null,"a3",null,null,null,{"$f":"1-U9-U11-U12-U13-U14","v":0.16}]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA006","阅读 ",1,null,null,null,1,null,null,null,"公区",null,"a4",null,null,null,0.17]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA001","茶艺+咖啡+阅读 ",1,null,null,null,1,{"$nulls":5},"a5",null,null,null,0.16]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA005","阅读 ",1,null,null,null,1,{"$nulls":5},"a6",null,null,null,0.17]
[null,null,"F00053","公区空间配行为：客厅","F00053-FA008","阅读 ",1,null,null,null,1,{"$nulls":5},"a7",null,null,null,0.17]
[null,"喝咖啡","F00074","套内行为场景：单个行为场景","F00074-FA031\n","咖啡制作",1,1,null,null,null,1,null,null,"户内",null,"a1",null,null,null,0.18]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA001","茶艺+咖啡+阅读 ",1,1,null,null,null,1,{"$nulls":4},"a2",null,null,null,{"$f":"1-U15-U17-U18-U20-U19","v":0.14}]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA002","咖啡",1,1,null,null,null,1,null,null,"公区",null,"a3",null,null,null,0.18,{"$nulls":6},"是否合并，及权重"]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA002","咖啡",1,1,null,null,null,1,{"$nulls":4},"a4",null,null,null,0.18]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA001","茶艺+咖啡+阅读 ",1,1,null,null,null,1,{"$nulls":4},"a5",null,null,null,0.14]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA004","咖啡 ",1,1,null,null,null,1,{"$nulls":4},"a6",null,null,null,0.18]
[null,"小憩","F00074","套内行为场景：单个行为场景","F00074-FA010","睡眠",1,1,null,null,1,null,null,null,"户内",null,"a1",null,null,null,0.3,{"$nulls":6},"无此数据源，是否选择睡眠一项"]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA001","睡眠",1,1,null,null,1,null,null,null,"户内"]
[null,null,"F00074","套内行为场景：单个行为场景","F00074-FA010","睡眠",1,1,null,null,1,null,null,null,"公区",null,"a2",null,null,null,0.3]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA001","睡眠",1,1,null,null,1,null,null,null,"公区",null,"a3",null,null,null,0.3]
[null,"玩电脑游戏","F00080","套内行为场景：占时最久","F00080-FA003","打游戏",1,1,null,null,1,null,null,null,"套内",null,"a1",null,null,null,{"$f":"1-U26-U27-U28-U29","v":0.1},{"$nulls":6},"多项数据源的合并处理、权重待定"]
[null,null,"F00053","空间配行为：客厅","F00053-FA002","打游戏（电脑）",1,1,null,null,1,null,null,null,"公区",null,"a2",null,null,null,0.3]
[null,null,"F00074","套内行为场景：单个行为场景","F00074-FA015","打游戏（电脑)",1,1,null,null,1,null,null,null,"户内",null,"a3",null,null,null,0.3]
[null,null,"F00126","周末套内行为场景：占时最久","F00126-FA003","电脑 ",1,1,null,null,1,null,null,null,"户内",null,"a4",null,null,null,0.15]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA014","电脑 ",1,1,null,null,1,null,null,null,"户内",null,"a5",null,null,null,0.15]
[null,"平板塑形","F00074","套内行为场景：单个行为场景","F00074-FA030","瑜伽",1,null,1,1,{"$nulls":4},"户内",null,"a1",null,null,null,0.18,{"$nulls":6},"无数据源、其他题健身与瑜伽选项"]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步",1,null,1,1,{"$nulls":6},"a2",null,null,null,0.17]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA004","瑜伽",1,null,1,1,{"$nulls":4},"公区",null,"a3",null,null,null,0.18]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步",1,null,1,1,{"$nulls":6},"a4",null,null,null,{"$f":"1-U30-U32-U34-U35-U31","v":0.17}]
[null,null,"F00123","公共空间配行为：露台","F00123-FA003","健身 ",1,null,1,1,{"$nulls":6},"a5",null,null,null,0.15]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA002","健身",1,null,1,1,{"$nulls":6},"a6",null,null,null,0.15]
[null,"插花","F00126","套内行为场景：单个行为场景","F00074-FA025","手工",1,{"$nulls":7},"户内",null,"a1",null,null,null,{"$f":"1-U37-U38-U39","v":0.15},{"$nulls":6},"无数据源、其他题养植物选项"]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA002","桌游+手工+花艺",1,{"$nulls":9},"a2",null,null,null,0.2]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA002","桌游+手工+花艺",1,{"$nulls":7},"公区",null,"a3",null,null,null,0.2]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA006","花艺",1,{"$nulls":9},"a4",null,null,null,0.45]
[null,"工作学习","F00074","套内行为场景:单个行为场景\n","F00074-FA012","工作",1,1,null,null,null,1,null,null,"户内",null,"a1",null,null,null,0.1,{"$nulls":6},"是否拆分"]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA013","工作 ",1,1,null,null,null,1,null,null,"户内",null,"a2",null,null,null,0.1]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA002","书桌",1,1,null,null,null,1,null,null,"户内",null,"a3",null,null,null,0.1]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA014","电脑",1,1,null,null,null,1,null,null,"户内",null,"a4",null,null,null,{"$f":"1-U40-U41-U42-U44-U45","v":0.5}]
[null,null,"F00126","周末套内行为场景：占时最久","F00126-FA006","工作",1,1,null,null,null,1,null,null,"户内",null,"a5",null,null,null,0.1]
[null,null,"F00072","空间配行为：客厅","F00072-FA013","工作",1,1,null,null,null,1,null,null,"户内",null,"a6",null,null,null,0.1]
[null,"打扫清洁","F00126","周末套内行为场景：占时最久","F00126-FA005","收拾打扫",1,{"$nulls":7},"户内",null,"a1",null,null,null,1,{"$nulls":6},"收纳是否合并"]
[null,"喝酒","F00088","公区行为场景：单个行为场景","F00088-FA012","酒吧 转换得来",{"$nulls":8},"公区",null,"a1",null,null,null,0.25]
[null,null,"F00123","公区空间配行为：露台","F00123-FA004","酒吧 ",{"$nulls":8},"公区",null,"a2",null,null,null,0.25]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA006","酒吧 ",{"$nulls":8},"公区",null,"a3",null,null,null,0.25]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA006","酒吧 ",{"$nulls":8},"户内",null,"a4",null,null,null,0.25]
[null,"喝茶","F00085","公区行为场景：行为场景混生","F00085-FA001","茶艺+咖啡+阅读 ",{"$nulls":8},"公区",null,"a2",null,null,null,0.25]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA007","茶艺 ",{"$nulls":8},"户内",null,"a3",null,null,null,0.5]
[null,"睡觉","F00126","周末套内行为场景：占时最久","F00126-FA007","睡眠 ",null,null,1,1,1,null,null,null,"户内",null,"a1",null,null,null,0.3]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA001","睡眠",null,null,1,1,1,null,null,null,"户内",null,"a2",null,null,null,0.3]
[null,"冥想","F000126","周末套内行为场景：占时最久","F00126-FA007","睡眠 ",{"$nulls":8},"户内",null,"a1",null,null,null,0.2]
[null,null,"F00074","套内行为场景:单个行为场景\n","F00074-FA010","睡眠",{"$nulls":8},"户内",null,"a2",null,null,null,0.2]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA001","睡眠 ",{"$nulls":8},"户内",null,"a3",null,null,null,0.2]
[null,"跑步","F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步",null,null,1,1,null,1,null,null,"户内",null,"a1",null,null,null,0.4]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步 ",null,null,1,1,null,1,null,null,"公区",null,"a2",null,null,null,0.4]
[null,"打篮球","F00122","公区空间配行为：大堂","F00122-FA009","健身",null,null,1,{"$nulls":5},"公区",null,"a1",null,null,null,0.5]
[null,"打乒乓","F00088","公区行为场景：单个行为场景","F00088-FA008","乒乓球 ",{"$nulls":8},"公区",null,"a1",null,null,null,0.5]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA007","乒乓球",{"$nulls":8},"公区",null,"a2",null,null,null,0.5]
[null,"游泳","F00123","公共空间配行为：露台","F00123-FA002","游泳 ",null,null,1,{"$nulls":5},"公区",null,"a1",null,null,null,1]
[null,"大器械健身","F00074","套内行为场景：单个行为场景","F00074-FA020","健身",null,null,1,{"$nulls":5},"户内",null,"a1",null,null,null,0.1]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA002","健身 ",null,null,1,{"$nulls":5},"户内",null,"a2",null,null,null,0.1]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步 ",null,null,1,{"$nulls":5},"公区",null,"a3",null,null,null,0.05]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA005","健身 ",null,null,1,{"$nulls":5},"公区",null,"a4",null,null,null,0.1]
[null,null,"F00085","公区行为场景混生","F00085-FA003","瑜伽+健身+跑步 ",null,null,1,{"$nulls":5},"公区",null,"a5",null,null,null,0.05,{"$nulls":12},"a1","b1","权重"]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA009","健身 ",null,null,1,{"$nulls":5},"公区",null,"a6",null,null,null,0.1,{"$nulls":12},50,100,{"$f":"AH69/AI69","v":0.5}]
[null,"小器械健身","F00074","套内行为场景:单个行为场景\n","F00074-FA020","健身 ",{"$nulls":8},"户内",null,"a1",null,null,null,0.1,{"$nulls":12},"a2","b2","权重"]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA002","健身 ",{"$nulls":8},"户内",null,"a2",null,null,null,0.1,{"$nulls":12},70,200,{"$f":"AH71/AI71","v":0.35}]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步 ",{"$nulls":8},"户内",null,"a3",null,null,null,0.05]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA005","健身 ",{"$nulls":8},"公区",null,"a4",null,null,null,0.1,{"$nulls":12},"原始值"]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA003","瑜伽+健身+跑步 ",{"$nulls":8},"公区",null,"a5",null,null,null,0.05]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA009","健身",{"$nulls":8},"公区",null,"a6",null,null,null,0.1]
[null,"失眠","F00073","套内行为场景：行为场景混生","F00073-FA004","影视+睡眠",{"$nulls":8},"户内"]
[null,"养猫","F00072","空间配行为：临窗空间","F00072-FA008","宠物",1,null,null,null,1,1,null,null,"户内",null,"a1",null,null,null,0.5,{"$nulls":6},"目前无数据来源"]
[null,"养狗","F00072","空间配行为：临窗空间","F00072-FA008","宠物",{"$nulls":8},"户内",null,"a1",null,null,null,0.5]
[null,"养冷血动物","F00072","空间配行为：临窗空间","F00072-FA008","宠物",{"$nulls":8},"户内",null,"a1",null,null,null,0.5]
[null,"养哺乳动物","F00072","空间配行为：临窗空间","F00072-FA008","宠物 ",{"$nulls":8},"户内",null,"a1",null,null,null,0.5]
[null,"美容护肤","F00053","空间配行为：客厅","F00053-FA006","盆浴 ",null,null,null,1,{"$nulls":10},0.5]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA003","盆浴 ",null,null,null,1,{"$nulls":4},"户内",{"$nulls":5},0.5]
[null,"托管游戏","F00072","空间配行为：临窗空间","F00072-FA008","宠物 ",{"$nulls":8},"户内",{"$nulls":5},0.5]
[null,"遛狗遛猫","F00053","空间配行为：临窗空间","F00072-FA008","宠物 ",{"$nulls":8},"户内",{"$nulls":5},0.5]
[null,"洗干熨衣","F00057",{"$nulls":8},1]
[null,"做陶艺","F00074","套内行为场景:单个行为场景","F00074-FA025","手工 ",{"$nulls":8},"户内",{"$nulls":5},0.5]
[null,"做模型","F00074","套内行为场景:单个行为场景","F00074-FA025","手工 ",null,1,{"$nulls":6},"户内",{"$nulls":5},0.5]
[null,"做布艺","F00085","公区行为场景：行为场景混生","F00085-FA002","桌游+手工+花艺 ",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,"做首饰","F00074","套内行为场景:单个行为场景","F00074-FA025","手工 ",{"$nulls":8},"户内",{"$nulls":5},0.5]
[null,"画布作画","F00074","套内行为场景:单个行为场景","F00074-FA023","绘画 ",{"$nulls":8},"户内",{"$nulls":5},1]
[null,"数字做插画","F00074","套内行为场景:单个行为场景","F00074-FA023","绘画 ",{"$nulls":8},"户内",{"$nulls":5},1]
[null,"直播",{"$nulls":5},1,null,1]
[null,"唱歌","F00074","套内行为场景:单个行为场景","F00074-FA024","玩乐器 ",{"$nulls":8},"户内",{"$nulls":5},0.1]
[null,null,"F00126","周末套内行为场景：占时最久","F00126-FA008","听音乐 ",{"$nulls":8},"户内",{"$nulls":5},0.1]
[null,null,"F00088","公区行为场景：单个行为场景","F00088-FA010","KTV ",{"$nulls":8},"公区",{"$nulls":5},0.8]
[null,"美妆","F00074","套内行为场景:单个行为场景\n","F00074-FA014","美妆 ",null,null,null,1,{"$nulls":4},"户内",{"$nulls":5},0.5]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA009","美妆 ",null,null,null,1,{"$nulls":4},"户内",{"$nulls":5},0.5]
[null,"玩乐器","F00074","套内行为场景:单个行为场景","F00074-FA024","玩乐器 ",{"$nulls":8},"户内",{"$nulls":5},1]
[null,"收藏","F00074","套内行为场景:单个行为场景","F00074-FA008","展示 ",null,1,{"$nulls":6},"户内",{"$nulls":5},1]
[null,"收纳","F00074","套内行为场景:单个行为场景","F00074-FA011","收纳 ",null,1,null,1,{"$nulls":4},"户内",{"$nulls":5},1]
[null,"玩体感游戏","F00080","套内行为场景：占时最久","F00080-FA003","打游戏 ",{"$nulls":8},"户内",{"$nulls":5},0.5]
[null,"玩桌游","F00088","公区行为场景：单个行为场景","F00088-FA001","桌游 ",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA002","桌游+手工+花艺 ",{"$nulls":8},"公区",{"$nulls":5},0.25]
[null,null,"F00085","公区行为场景：行为场景混生","F00085-FA002","桌游+手工+花艺 ",{"$nulls":8},"户内",{"$nulls":5},0.25]
[null,"美容护肤","F00074","套内行为场景:单个行为场景","F00074-FA014","美妆",{"$nulls":8},"户内",{"$nulls":5},0.25]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA009","美妆",{"$nulls":8},"户内",{"$nulls":5},0.25]
[null,null,"F00107","ECS原型配行为：魔方showbox","F00107-FA007","美妆",{"$nulls":8},"户内",{"$nulls":5},0.25]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA002","美容美发",{"$nulls":8},"公区",{"$nulls":5},{"$f":"1-U107-U106-U105","v":0.25}]
[null,"洗漱",null,null,null,"洗漱",null,null,null,1,{"$nulls":10},1]
[null,"淋浴","F00057","行为场景PK：盆浴vs淋浴","F00057-FA002","淋浴",null,null,1,{"$nulls":5},"户内",{"$nulls":5},1]
[null,"泡澡","F00074","套内行为场景:单个行为场景","F00074-FA006","盆浴",null,null,null,1,1,null,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00053","空间配行为：客厅","F00053-FA006","盆浴",null,null,null,1,1,null,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00057","行为场景PK：盆浴vs淋浴","F00057-FA001","盆浴",null,null,null,1,1,null,null,null,"户内",{"$nulls":5},0.5]
[null,"湿蒸","F00123","公共空间配行为：露台","F00123-FA002","游泳",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,"桑拿","F00123","公共空间配行为：露台","F00123-FA002","游泳",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,"spa ","F00123","公共空间配行为：露台","F00123-FA002","游泳",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,"做中餐","F00074","套内行为场景:单个行为场景","F00074-FA007","烹饪",{"$nulls":8},"户内",{"$nulls":5},0.4]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA005","烹饪",{"$nulls":8},"户内",{"$nulls":5},0.4]
[null,"做西餐","F00074","套内行为场景:单个行为场景","F00074-FA007","烹饪",null,null,1,{"$nulls":5},"户内",{"$nulls":5},0.4]
[null,null,"F00080","套内行为场景：占时最久","F00080-FA005","烹饪",null,null,1,{"$nulls":5},"户内",{"$nulls":5},0.4]
[null,"烧烤"]
[null,"烘培","F00074","套内行为场景:单个行为场景","F00074-FA029","烘培",{"$nulls":8},"户内",{"$nulls":5},1]
[null,"就餐","F00053","空间配行为：客厅","F00053-FA005","就餐",null,null,1,null,1,1,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00074","套内行为场景:单个行为场景","F00074-FA016","就餐",null,null,1,null,1,1,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00072","空间配行为：临窗空间","F00072-FA005","就餐",null,null,1,null,1,1,null,null,"户内",{"$nulls":5},0.3]
[null,"仪容仪表","F00074","套内行为场景:单个行为场景","F00074-FA005","更衣",null,null,1,1,null,1,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00107","ECS原型配行为：魔方showbox","F00107-FA008","更衣",null,null,1,1,null,1,null,null,"户内",{"$nulls":5},0.3]
[null,"收包裹"]
[null,"收生鲜"]
[null,"追星",{"$nulls":8},1]
[null,"种菜","F00074","套内行为场景:单个行为场景","F00074-FA002","养植物",{"$nulls":8},"户内",{"$nulls":5},0.3]
[null,null,"F00123","公共空间配行为：露台","F00123-FA005","农场",{"$nulls":8},"公区",{"$nulls":5},0.5]
[null,"种花","F00074","套内行为场景:单个行为场景","F00074-FA002","养植物",{"$nulls":4},1,null,null,null,"户内",{"$nulls":5},0.3]
[null,null,"F00122","公区空间配行为：大堂","F00122-FA006","花艺",{"$nulls":4},1,null,null,null,"公区",{"$nulls":5},0.2]
[null,null,"F00123","公共空间配行为：露台","F00123-FA005","农场",{"$nulls":4},1,null,null,null,"公区",{"$nulls":5},{"$f":"1-U134-U133","v":0.5}]
[null,"微聚会",{"$nulls":9},1]
[null,"聚会","F00074","套内行为场景:单个行为场景","F00074-FA028","聚会",null,1,{"$nulls":6},"户内",{"$nulls":5},0.5]
[null,null,"F00053","空间配行为：客厅","F00053-FA007","聚会",null,1,{"$nulls":6},"户内",{"$nulls":5},0.5]

{"sheet":"空间需求看板 - 软数据","index":2,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,0,7,0],[8,0,18,0],[19,0,22,0],[23,0,26,0],[27,0,33,0],[34,0,39,0],[1,4,7,4],[8,4,18,4],[19,4,22,4],[23,4,26,4],[27,4,33,4],[34,4,39,4],[1,7,39,7]]}
[null,null,"原题对应选项","父题序号","来源","示例","匹配方式","算法","后台数据库表及字段","备注"]
["材质","玻璃",null,null,"软装偏好什么样的材质",null,"玻璃","直接匹配"]
[null,"绸缎",{"$nulls":4},"绸缎"]
[null,"金属",{"$nulls":4},"金属"]
[null,"棉麻",{"$nulls":4},"棉麻"]
[null,"木质",{"$nulls":4},"木质"]
[null,"皮革",{"$nulls":4},"皮革"]
[null,"石材",{"$nulls":4},"石材"]
["单品偏好","餐桌",null,null,"家具单品最重视什么",null,"餐桌"]
[null,"茶几",{"$nulls":4},"茶几"]
[null,"床",{"$nulls":4},"床"]
[null,"电视柜",{"$nulls":4},"电视柜"]
[null,"电视机",{"$nulls":4},"电视机"]
[null,"沙发",{"$nulls":4},"沙发"]
[null,"收纳柜",{"$nulls":4},"收纳柜"]
[null,"书桌",{"$nulls":4},"书桌"]
[null,"衣柜",{"$nulls":4},"衣柜"]
[null,"椅子",{"$nulls":4},"椅子"]
[null,"浴缸",{"$nulls":4},"浴缸"]
["色调偏好","冷色系",null,null,"软装偏好什么色调",null,"冷色系"]
[null,"暖色系",{"$nulls":4},"暖色系"]
[null,"主冷色系+辅暖色系",{"$nulls":4},"主冷色系+辅暖色系"]
[null,"主暖色系+辅冷色系",{"$nulls":4},"主暖色系+辅冷色系"]
["色相偏好","黑",null,null,"软装偏好什么色相",null,"黑"]
[null,"科技蓝",{"$nulls":4},"科技蓝"]
[null,"明亮色系",{"$nulls":4},"明亮色系"]
[null,"优雅粉",{"$nulls":4},"优雅粉"]
["精装关注点","材质",null,null,"你最在乎厨房橱柜的哪些方面",null,"材质"]
[null,"工艺",{"$nulls":4},"工艺"]
[null,"价格",{"$nulls":4},"价格"]
[null,"品牌",{"$nulls":4},"品牌"]
[null,"颜色",{"$nulls":4},"颜色"]
[null,"造型",{"$nulls":4},"造型"]
[null,"质量",{"$nulls":4},"质量"]
["空间特性偏好","便利性",null,null,"你重视套内空间的哪些特性",null,"便利性"]
[null,"空间舒展",{"$nulls":4},"空间舒展"]
[null,"美观+舒适",{"$nulls":4},"美观+舒适"]
[null,"收纳性",{"$nulls":4},"收纳性"]
[null,"舒适",{"$nulls":4},"舒适"]
[null,"颜值",{"$nulls":4},"颜值"]