{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["门店整体情况表"],"not_rendered":{"external_links":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"门店整体情况表","index":0,"n_rows":55,"n_cols":10,"rows_kept":55,"merged":[[0,0,0,9],[2,0,2,9],[16,0,16,9],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,0,28,9],[29,2,29,4],[29,7,29,9],[30,2,30,4],[30,7,30,9],[31,2,31,4],[31,7,31,9],[32,2,32,4],[32,7,32,9],[33,2,33,4],[33,7,33,9],[34,2,34,4],[34,7,34,9],[35,2,35,4],[35,7,35,9],[36,2,36,4],[36,7,36,9],[37,2,37,4],[37,7,37,9],[38,0,38,4],[38,5,38,9],[39,0,46,4],[39,5,46,9],[47,0,47,4],[47,5,47,9],[48,0,53,4],[48,5,53,9],[54,0,58,9]],"flags":["formulas_cached_only"]}
["四川太极大药房片区负责人周报表"]
["片区名称：双流片                                   片长：郑红艳                                     填报周期：2014年3月10日——2014年3月16日","双流清泰路店"]
["1、片区品种本周动销情况"]
["门店ID","门店名称","90天动销率","上周动销品种个数","本周动销品种个数","90天未动销品种数量","90天动销品种总数量","90天未动销品种中\n本周处理数量","门店本月效期品种数量","本周效期品种\n销售数量"]
[733,"双流清泰路店",{"v":0.6912999999999999,"d":"69.13%"},728,759,518,1160,45,60,12]
{"$rows_empty":11}
["2、片区本周基本营业情况"]
["本周销售额","上周销售额","增长比",null,"本周来客数","上周来客数","增长比","本周客单价","上周客单价","增长比"]
[15688.14,12280.3,{"v":0.2775,"d":"28%"},null,309,281,{"v":0.09960000000000001,"d":"10%"},50.8,43.7,{"v":0.1624,"d":"16%"}]
{"$rows_empty":9}
["3、片区销售数据分析"]
["日期","本周最高营业额","原因分析",null,null,"日期(最低值时日期）","本周最低营业额","原因分析"]
[20140317,4499.7,"3月13日销售额最高，因为那天给顾客预定几种贵重药品，再加上响应公司健康生活，做幸福女人的活动，促使顾客用泰康人寿消费，另一方面计生用品也是这里的畅销品种。",null,null,20140312,1431.39,"今日是3月12日植树节，人群基于做公益活动，再加上天气比较好春游的比较多"]
{"$rows_empty":7}
["4、存在问题及解决措施",{"$nulls":4},"5、需片公司解决的问题"]
["1、门店规划不完善\n2、中药饮片不足\n3、货柜玻璃有损坏",{"$nulls":4},"1、中药铺货\n2、配备中药打粉机\n3、冰箱配备铺上冷柜药品"]
{"$rows_empty":7}
["6、上周工作内容",{"$nulls":4},"7、本周工作计划"]
["1、规划店堂布局\n2、日常工作处理\n",{"$nulls":4},"1、完善店堂布局\n2、中药上货问题\n3、完善门店人员配置"]
[]
[]
[]
[]
[]
["备注：\n1、每周星期二下班前发送到营运部邮箱内；\n2、数据采集从上周星期一到本周星期日的销售；\n3、销售要求：（动销率在“查询门店动销率”功能里查）\n60%以上的动销率 9个/天\n40%-60%的销售7个/天\n30%-40%的销售5个/天；\n4、如何计算：90天没有动销的品种（在公司品种明细分析里查询）、动销品种个数（在指定品种查询里进行查询并分析）；\n6、效期品种按门店每月登记的效期品种数为准，每周在指定品种里讲货品ID导进去进行查询动销个数；\n7、“90天未动销品种中本周处理数量”可以通过门店销售途径、门店间相互调拨、片区间相互协商调拨\n"]