{"text_format":"2","workbook":"xlsx","n_sheets":4,"sheets":["双11活动安排","联合单品聚划算计划","双11活动方案","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"双11活动安排","index":0,"n_rows":38,"n_cols":60,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,59],[26,0,37,0],[21,0,22,0],[23,0,25,0],[26,1,26,2],[5,3,6,3],[7,3,9,3],[5,0,16,0],[34,1,37,2],[21,1,21,2],[22,1,22,2],[27,1,30,2],[31,1,32,2],[33,1,33,2],[4,20,4,21],[5,1,15,1],[23,1,23,2],[4,9,4,10],[25,1,25,2],[24,1,24,2],[18,1,18,2],[19,1,19,2],[18,0,20,0],[20,1,20,2],[18,60,20,60],[1,0,1,5],[2,0,2,5],[3,0,3,5],[16,1,16,2],[17,1,17,2]]}
["分销部双11活动计划安排"]
["今年双11淘宝类目无活动计划，故C店流量需自主争取；"]
["双11期间，我部计划投放46w营销推广费用为各位争取资源；"]
["严格要求参与活动店铺具备自主推广能力：直通车及淘宝客推广（此将作为参与双12活动的必要考核条件）"]
["部门","项目","子项目","细则","负责人","活动时间/截止时间",16,17,18,"19~21（假）",null,22,23,24,25,26,27,28,29,30,"1~7（假）",null,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,1,2,3,4,5,6,7,8,9,10,11,12,13,14]
["总部","预热","9月乐活","各分公司挑选主推产品及核心分销商参与活动，积累产品人力流量与销量","陈惠娟","9.15-18"]
[null,null,"9月我是品牌",null,"姚文琳、陈美蓉","9.20-25"]
[null,null,"10月天天特价","主推商品、核心分销商参与活动，向爆款迈进","陈惠娟","10.10-17"]
[null,null,"10月品牌清仓",null,"陈惠娟","10.10-17"]
[null,null,"10月换季管家",null,"陈美蓉","10.18-20"]
[null,null,"10月P4P活动","爆款形成，开启直通车推广，参与P3P活动","陈美蓉","10.14-17"]
[null,null,"10月我是品牌","我是品牌活动从10月份活动开始除了考量“日均流量、\n近三十天新增会员数、近三十天的二次访问率”，还会加入“成交金额”这一个权重指数，必须选出高转化率的商品\n","姚文琳","10.20-24"]
[null,null,"不定时增加","关注帮派动态，与类目保持密切联系；随时争取各项资源，参与各项活动"]
[null,null,"激活品牌站","关注送集分宝，转发送淘公仔/增加品牌站粉丝，互动增加粘性","姚文琳"]
[null,null,"双11商品团","双11当天聚划算单品团争取（各分公司核心分销商及直营店铺）","分销/各分公司","10.10"]
[null,null,"加大自主推广","核心分销商均设有直通车及淘宝客推广任务，加大爆款推出","姚文琳、陈美蓉"]
[null,"双11活动方案",null,"1元抢50现金，11元专区，折扣为主导","文琳",10.1]
["分公司","货品计划",null,"确定双11主推货品及次主推货品；活动商品","各分公司",10.1]
["总部/分公司","页面设计",null,"活动前后各个时间段的POP设计定稿","总部",10.14]
[null,"钻展资源抢占",null,"双11前后钻展资源抢占","总部",10.14]
[null,"活动页面",null,"活动承接页面设定","总部",10.14]
["总部/分公司","售后保障",null,"针对双11活动期间的后勤保障安排","各分公司",10.27]
[null,"投诉处理",null,"双11活动结束后投诉订单处理工作","各分公司",10.3]
["总部/分公司","商品信息准确性",null,"系统的商品尺码、颜色排查，确定订单正常流转","总部/各分公司",10.14]
[null,"分销价格一致性",null,"解决问题：系统抓取的采购价并非完全是供销后台的采构架","总部/各分公司",10.15]
[null,"新经销订单流转",null,"更换新的经销下单，系统升级，完全自动流转","总部",10.8]
["总部/分公司","发货保障",null,"保障分销订单正常发货","各分公司"]
[null,"仓库人员、设备、物料安排",null,"1、培训储备人员：打单、发货人员2-3个，需做好人员培训安排，备用候补人员要在双十一前实际操作，确保可以正常打单发货","各分公司",11.2]
[null,null,null,"2）培训新仓分组发货注意事项及人员安排","各分公司",10.199999999999999]
[null,null,null,"3）缺货，异常订单，超重订单，售后等问题需做好人员培训","各分公司",10.3]
[null,null,null,"4）沟通物料准备问题：打印机、电脑、扫描枪、快递面单、包装袋、售后卡需备齐","各分公司",10.25]
[null,"快递安排",null,"1）各仓与快递公司沟通好双十一取件人员安排，全天保证有2-3人在仓库收快件","各分公司",10.25]
[null,null,null,"2）规划好不同快递包裹放置区域以及取件人员的取件行为","各分公司",10.25]
[null,"仓库突发情况预案",null,"突发情况：突发断电，电网等情况，需要做好备案，确保能正常发货。","各分公司",10.25]
[null,"仓库发货",null,"1、物料设备摆放：发货区将长条桌，电脑、扫描枪、打印机设备，面单、包装袋等事先规划好","各分公司",11.11]
[null,null,null,"2、发货注意事项提示：各仓需在发货区域写大字报，提示发货注意事项","各分公司",11.11]
[null,null,null,"3、11月9-10确认好各仓人员安排：前期培训储备人员到仓库全天候待命，仓库总负责人11月10号之前做好人员分组岗位安排","各分公司",11.11]
[null,null,null,"发放快递单号：\n1）设置快件发件区，打单员将校验一致的订单打包好统一放在该区域\n2）快递员必须在指定区域取件，防止取件杂乱\n3）核单员在快递员离开时需当面核对正确面单数量及取件数量，做到出库单和出库货品数量保持一致。","各分公司",11.11]

{"sheet":"联合单品聚划算计划","index":1,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,0,2,5],[2,7,2,13],[4,0,9,0],[4,1,9,1],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,12,7,12],[5,13,7,13],[5,14,7,14],[8,7,10,7],[8,8,10,8],[8,9,10,9],[8,10,10,10],[8,11,10,11],[8,12,10,12],[8,13,10,13],[8,14,10,14]]}
["双11期间单品团计划"]
[]
["流量预计",{"$nulls":6},"销量预计",{"$nulls":6},"参选 理由"]
["序号","流量分类","流量来源","预计流量（UV）\n","预计单品转化率\n","预计单品销量",null,"参选商家","商家链接","产品类型","商品链接","单价","预计成交数量","金额","参选 理由"]
[1,"店铺流量","聚划算",1000000,0.05,{"$f":"D5*E5","v":50000}]
[null,null,"店铺自然流量",30000,1.4999999999999999E-2,{"$f":"D6*E6","v":450}]
[null,null,"店铺提前预热",30000,0.02,600]
[null,null,"活动EDM群发",5000,0.01,50]
[null,null,"短信营销",5000,0.01,50]
[null,null,"邮件群发",5000,0.01,50]
[2,"投放资源","麦麦钻展资源（暂定）",150000,0.01,{"$f":"D11*E11","v":1500}]
[3,"其他资源","待定"]
["合计",null,null,{"$f":"SUM(D5:D11)","v":1225000},{"$f":"SUM(E5:E11)","v":0.12499999999999999},{"$f":"SUM(F5:F11)","v":52700}]

{"sheet":"双11活动方案","index":2,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":true,"merged":[[14,6,14,7],[2,1,2,7],[3,1,4,1],[3,2,4,2],[3,3,3,6],[3,7,4,7]]}
[]
[]
[null,"分销部指标-1250万"]
[null,"账号","销售占比",{"$nulls":4},"突破值"]
[null,null,null,"9月","10月","11月","12月"]
[null,"361度分销平台",{"$f":"H6/H14","v":9.1999999999999998E-2},300000,250000,300000,300000,{"$f":"SUM(D6:G6)","v":1150000}]
[null,"361度品牌分销1（山西）",{"$f":"H7/H14","v":0.224},600000,500000,1000000,700000,{"$f":"SUM(D7:G7)","v":2800000}]
[null,"361度品牌分销2（石家庄）",{"$f":"H8/H14","v":0.16},400000,200000,1000000,400000,2000000]
[null,"361度品牌分销3（郑州）",{"$f":"H9/H14","v":5.6000000000000001E-2},150000,150000,300000,100000,700000]
[null,"361度品牌分销4（济南）",{"$f":"H10/H14","v":0.25600000000000001},600000,600000,1200000,800000,3200000]
[null,"361度品牌分销5（武汉）",{"$f":"H11/H14","v":0.16},300000,200000,1000000,500000,2000000]
[null,"361度品牌分销6（广州）",{"$f":"H12/H14","v":5.1999999999999998E-2},150000,100000,200000,200000,650000]
[null,"361度品牌分销7（柳州州）",{"$nulls":5},0]
[null,"合计",1,{"$f":"SUM(D6:D12)","v":2500000},2000000,{"$f":"SUM(F6:F13)","v":5000000},3000000,{"$f":"SUM(H6:H13)","v":12500000}]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}