{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["CRM转换后的数据","码表"],"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":"CRM转换后的数据","index":0,"n_rows":2,"n_cols":48,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["外呼工单ID","问卷问卷名称","完成时间","区域ID","是否有效","房屋房屋名称","客户客户名称","处理人全名","电话","项目ID","区域","项目项目名称","n1","n2","nn3_1","nn3_2","nn3_3","nn3_4","nn3_5","nn3_6","nn3_7","nn3_8","nn3_9","nn3_10","nn3_11","nn3_12","nn3_13","nn3_14","nn3_15","nn3_16","nn3_17","nn3_18","nn3_19","nn3_20","nn3_21","nn3_22","nn3_98","n5","n6","n7","f1","f2","f3","f4","f5","管家认知","其他不满意原话","客户电话原声"]
["外呼工单 ID","问卷: 问卷名称","完成时间","区域ID","是否有效","房屋: 房屋名称","客户: 客户名称","处理人: 全名","电话","项目ID","区域","项目项目名称","Q1、请问您本人目前在本楼盘居住吗-","B1、请您先不考虑碧桂园的销售、规划、房屋质量等方面，仅仅考虑小区的物业管理，也就是综合小区的安全管理、环境清洁、绿化养护、公共设施保养、物业人员表现等...","客服-文明养宠","客服-管家更换频繁","工程-电梯相关","工程-维修效率及质量","工程-设施维护（公共照明、道路、休闲娱乐设施等）","绿化-绿化养护","绿化-绿植品类少","安保-停车管理","安保-噪音管理","安保-门岗通行管理","安保-违章搭建","环境-垃圾清运","环境-环境清洁","环境-四害消杀","环境-园区积水清理","房产相关-房屋质量","房产相关-销售承诺","收费问题（费用高、乱收费等）","人员态度","周边配套及市政规划","停水电气","对物业整体不满","其他","B3、请问您或家人知道您的片区凤凰管家吗-（选择不知道继续提问下一个问题","B4、管家是否有主动联系或拜访过您或家人-（第5个问题选择知道的不需提问此问题","B5. 【访问员：B4只提问B3回答1的被访者】您对现在的管家服务满意吗-","F1.您觉得居住在我们小区还安全吗","F2. 您觉得小区公共卫生干净吗","F3.您觉得我们物业人员的服务态度好吗","F4. 您觉得园区的绿化景观足够舒适、美观吗","F5. 您觉得物业的工程维修服务让您感觉到高效、专业吗","管家认知","其他不满意原话","客户电话原声"]

{"sheet":"码表","index":1,"n_rows":82,"n_cols":5,"rows_kept":82,"cut":false,"hidden":false,"merged":[[3,1,5,1],[6,1,10,1],[11,1,12,1],[13,1,14,1],[15,1,16,1],[17,1,18,1],[19,1,20,1],[21,1,22,1],[23,1,24,1],[25,1,26,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[33,1,34,1],[35,1,36,1],[37,1,38,1],[39,1,40,1],[41,1,42,1],[43,1,44,1],[45,1,46,1],[47,1,48,1],[49,1,50,1],[51,1,52,1],[53,1,54,1],[55,1,56,1],[57,1,58,1],[59,1,61,1],[62,1,66,1],[67,1,71,1],[72,1,76,1],[77,1,81,1],[3,2,5,2],[6,2,10,2],[11,2,12,2],[13,2,14,2],[15,2,16,2],[17,2,18,2],[19,2,20,2],[21,2,22,2],[23,2,24,2],[25,2,26,2],[27,2,28,2],[29,2,30,2],[31,2,32,2],[33,2,34,2],[35,2,36,2],[37,2,38,2],[39,2,40,2],[41,2,42,2],[43,2,44,2],[45,2,46,2],[47,2,48,2],[49,2,50,2],[51,2,52,2],[53,2,54,2],[55,2,56,2],[57,2,58,2],[59,2,61,2],[62,2,66,2],[67,2,71,2],[72,2,76,2],[77,2,81,2]]}
[]
[]
[null,"变量名称","变量描述","值","值描述"]
[null,"n1","Q1. 请问您本人目前在本楼盘居住吗？【单选】",1,"没有在这楼盘居住过或低于1个月1天"]
[null,null,null,2,"在这楼盘居住一个月1天以上15天以下"]
[null,null,null,3,"在这楼盘居住一个月15天或以上"]
[null,"n2","B1. 请您综合考虑小区的管家服务、安全管理、环境清洁、物业人员的服务态度四大方面。您对上个月 ______________（读出楼盘名称）的物业管理...",1,"非常不满意"]
[null,null,null,2,"比较不满意"]
[null,null,null,3,"一般"]
[null,null,null,4,"比较满意"]
[null,null,null,5,"非常满意"]
[null,"nn3_1","不满意方面-B2_1客服-文明养宠",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_2","不满意方面-B2_2客服-管家更换频繁",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_3","不满意方面-B2_3工程-电梯相关",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_4","不满意方面-B2_4工程-维修效率及质量",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_5","不满意方面-B2_5工程-设施维护（公共照明、道路、休闲娱乐设施等）",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_6","不满意方面-B2_6绿化-绿化养护",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_7","不满意方面-B2_7绿化-绿植品类少",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_8","不满意方面-B2_8安保-停车管理",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_9","不满意方面-B2_9安保-噪音管理",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_10","不满意方面-B2_10安保-门岗通行管理",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_11","不满意方面-B2_11安保-违章搭建",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_12","不满意方面-B2_12环境-垃圾清运",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_13","不满意方面-B2_13环境-环境清洁",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_14","不满意方面-B2_14环境-四害消杀",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_15","不满意方面-B2_15环境-园区积水清理",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_16","不满意方面-B2_16房产相关-房屋质量",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_17","不满意方面-B2_17房产相关-销售承诺",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_18","不满意方面-B2_18收费问题（费用高、乱收费等）",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_19","不满意方面-B2_19人员态度",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_20","不满意方面-B2_20周边配套及市政规划",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_21","不满意方面-B2_21停水电气",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_22","不满意方面-B2_22对物业整体不满",0,"否"]
[null,null,null,1,"是"]
[null,"nn3_98","不满意方面-B2_98其他",0,"否"]
[null,null,null,1,"是"]
[null,"n5","B3. 请问您或家人知道您的片区凤凰管家吗？",1,"知道"]
[null,null,null,2,"不知道"]
[null,"n6","B4. 【访问员：B4只提问B3回答2的被访者】管家是否有主动联系或拜访过您或家人？",1,"有"]
[null,null,null,2,"没有"]
[null,null,null,99,"不清楚"]
[null,"n7","B5. 【访问员：B5只提问B3回答1的被访者】您对现在的管家服务满意吗？请用1-5分评价，5分表示非常满意， 4表示比较满意，3 表示一般，2表示比...",1,"非常不满意"]
[null,null,null,2,"比较不满意"]
[null,null,null,3,"一般"]
[null,null,null,4,"比较满意"]
[null,null,null,5,"非常满意"]
[null,"f1","F1.您觉得居住在我们小区还安全吗？请用1-5分评价，5分表示非常满意， 4表示比较满意，3 表示一般，2表示比较不满意， 1 表示非常不满意（若被访...",1,"非常不满意"]
[null,null,null,2,"比较不满意"]
[null,null,null,3,"一般"]
[null,null,null,4,"比较满意"]
[null,null,null,5,"非常满意"]
[null,"f2","F2. 您觉得小区公共卫生干净吗？请用1-5分评价，5分表示非常满意， 4表示比较满意，3 表示一般，2表示比较不满意，1表示非常不满意（若被访者对指...",1,"非常不满意"]
[null,null,null,2,"比较不满意"]
[null,null,null,3,"一般"]
[null,null,null,4,"比较满意"]
[null,null,null,5,"非常满意"]
[null,"f3","F3.您觉得我们物业人员的服务态度好吗？请用1-5分评价，5分表示非常满意， 4表示比较满意，3 表示一般，2表示比较不满意， 1 表示非常不满意",1,"非常不满意"]
[null,null,null,2,"比较不满意"]
[null,null,null,3,"一般"]
[null,null,null,4,"比较满意"]
[null,null,null,5,"非常满意"]