{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"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,"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":"Sheet1","index":0,"n_rows":7,"n_cols":72,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,69,4,69],[3,63,4,63],[3,59,4,59],[3,60,4,60],[3,55,4,55],[3,56,4,56],[3,64,4,64],[3,57,4,57],[3,58,4,58],[2,70,4,70],[2,71,4,71],[3,65,4,65],[3,66,4,66],[3,67,4,67],[3,68,4,68],[2,54,2,69],[3,54,4,54],[3,48,4,48],[3,37,3,43],[3,44,3,47],[3,49,4,49],[3,62,4,62],[3,61,4,61],[2,48,2,53],[3,28,4,28],[3,29,4,29],[3,30,4,30],[3,51,4,51],[3,31,4,31],[3,50,4,50],[3,52,4,52],[3,53,4,53],[5,44,5,47],[2,36,2,44],[3,36,4,36],[3,22,4,22],[3,34,4,34],[3,35,4,35],[5,37,5,43],[2,27,2,35],[3,19,4,19],[3,32,4,32],[3,33,4,33],[3,27,4,27],[3,26,4,26],[3,23,4,23],[3,24,4,24],[3,25,4,25],[3,20,4,20],[3,2,4,2],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,11,4,11],[3,18,4,18],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[5,0,5,1],[5,7,5,10],[2,0,4,0],[2,1,4,1],[3,3,4,3],[3,21,4,21],[3,16,4,16],[3,17,4,17],[2,2,2,26],[3,7,3,10]]}
[]
[]
["序号","药店名称","单店信息  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"店长信息",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"品规信息",null,null,null,null,null,"门店销售情况",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"备注","零售经营存在的问题及建议"]
[null,null,"所属公司","开业时间","停业时间","停业原因","所属年份","药店类型(按年销售额划分：A\\B\\C\\D)",null,null,null,"本月正式员工人数（不含促销，含返聘人员，人）","促销员数量（人）","营业总面积㎡（=实际自营面积+分租面积）","其中自有店面面积㎡","月租金（元）","其中：自由门面折旧费（元）","其中：租赁费（元）","是否是自有门面（是填1）","药品超市(是填1)","医保药店(是填1)","经营中药(是填1)","中药样板店(是填1)","中医药店(是填1)","中医人数（人）","药店营业地址","药店电话（门市）","店长姓名","性别","店长电话(手机)","店长入司时间","店长任职时间","所学专业","职称/执业资格","政治面貌","店长出生年月日","是否是特病定点药房(是填1)","药店类型(按地理位置划分为：A\\B\\C\\D\\E\\F\\G）",null,null,null,null,null,null,"药店类型(按营业面积划分为：A\\B\\C\\D\\E)",null,null,null,"T类品规数","A类品规数","B类品规数","C类品规数","其他类品规数","商品线长度","日均客流量（人）","日均客单价  （元/人）","月盈亏平衡点销售额（元）","月坪效（元/平方米）","现有会员总数量（人）","其中：有效会员总数量（人）","本月会员销售额（元）","本年会员销售累计（元）","本年会员销售占比（%）","本月会员销售毛利额","本月日均会员客单价","本月店外销售（元）","本年店外销售累计（元）","其中：提货卡销售（元）","本月降低租金额（元）","本年累计降低租金额（元）"]
[null,null,null,null,null,null,null,"A特大型店：年销售500我万元（含）以上(是填1)","B大型店：年销售200（含）-500万元(是填1)","C中型店：年销售100（含）-200万元(是填1)","D小型店：年销售100万元以下的门店(是填1)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A类店：商业中心店(是填1)","B类店：区域中心店(是填1)","C类店：主干道店(是填1)","D类店：社区店(是填1)","E类店：店中店(是填1)","F类店：专业店(是填1)","G类店：城乡结合部店(是填1)","A特大型店：营业面积500平方米（含）以上(是填1)","B大型店：营业面积在300（含）-500平方米之间(是填1)","C中型店：营业面积在100（含）-300平方米之间(是填1)","D小型店：营业面积100平方米以下(是填1)"]
["填报说明",null,null,"格式：2013年6月26日","格式：2013年6月26日",null,"09年后新增药房所属年份以集团考核文件为准，迁址后仍计入考核当年，分别选填08年存量店、09年店、10年店、11年店、12年店、13年店，关闭店","药店类型按年销售额划分四选一",null,null,null,"只填数字","只填数字","只填数字","只填数字","包括自有门面折旧费，只填数字","只填数字","只填数字","是填1，不是则不填","是填1，不是则不填","是填1，不是则不填","是填1，不是则不填","是填1，不是则不填","是填1，不是则不填","只填数字","详细地址，与营业执照保持一致","要填写区号",null,null,null,"格式：2013年6月26日","店长在该店任职的时间是从什么时候开始的？格式：2013年6月26日","有专业填写专业，无则不填",null,"党员、预备党员、团员等，群众则不填","格式：2013年6月26日","特殊疾病指定购药点（可买药报账）。","药店类型按地理位置划分为七选一",null,null,null,null,null,null,"药店类型按营业面积划分四选一",null,null,null,"只填数字","只填数字","只填数字","只填数字","只填数字","以6个月内实际动销所有经营产品品规总数计算，含配方饮片（可以在单品销售汇总中查询6个月动销的品种，或者在进销存中查询6个月的进销存减去未动销的品种）","平均每日客流量，只填数字","日均客单价=日均销售总金额÷日均成交总笔数，只填数字\n","只填数字","月坪效=当月销售额÷门店实际营业面积（不含分租面积）\n","累计办理的会员总数量,只填数字","有效会员，指本年产生过消费的会员，只填数字","只填数字","只填数字","会员销售占比=会员累计销售/销售累计*100%",null,"本月日均会员客单价=日均会员销售总金额÷日均成交总笔","店外销售：指店长或店员在外面联系的销售，只填数字","只填数字","当月店长或店员在外面联系的提货卡销售金额","月降阻金额：指在2013年末门面月租金基础上减少的房屋租金，只填数字","只填数字",null,"根据实际经营情况，合理化建议，门店建议填在门店栏，公司建议填在公司合计栏"]
[null,"一环路南一段店","四川太极大药房","2011-08-15",null,null,"11年存量店",null,null,null,1,4,0,176,166,22774.799999999999,null,22775,null,1,1,1,null,null,6,"四川省成都市武侯区一环路南一段1号附16.17号","028-62358061","陈杨","女",13880285609,"2011-07-01","2015-05-22","药学",null,"团员","1992-09-13",null,null,null,null,1,null,null,null,null,null,1,null,353,220,113,51,1910,2101,64,47.9,140000,539.6,3141,2853,46119.94,222578.36,0.4758,165.28,23.2,0,0,0,3520,14080]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}