{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["月总结和月计划","竞争对手登记表","单品打造计划","部门人员工作总结","时间管理大事记事本","淘抢购方案"],"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":"月总结和月计划","index":0,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,8],[2,9,2,16],[3,2,3,4],[3,9,3,12],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[31,7,31,8],[32,7,32,8],[33,7,33,8],[34,7,34,8],[35,0,35,1],[35,2,35,8],[35,9,35,16],[36,0,36,1],[36,2,36,8],[36,9,36,16],[37,0,37,1],[37,2,37,8],[37,9,37,16],[38,0,38,1],[38,2,38,8],[38,9,38,16],[3,0,4,0],[5,0,12,0],[14,0,34,0],[3,1,4,1],[5,1,12,1],[14,1,18,1],[19,1,22,1],[24,1,28,1],[29,1,33,1],[3,5,4,5],[5,5,12,5],[3,6,4,6],[5,6,12,6],[3,7,4,7],[5,7,12,7],[3,8,4,8],[5,8,12,8],[3,13,4,13],[5,13,12,13],[3,14,4,14],[5,14,12,14],[3,15,4,15],[5,15,12,15],[3,16,4,16],[5,16,12,16],[0,0,1,16],[13,9,34,16]]}
["   XXX公司 （成大事者，不拘小“结”）"]
[]
[null,"天猫-XXX旗舰店---2016年6月月度工作计划",{"$nulls":7},"天猫-xxxx旗舰店---2015年5月月度工作 总结 "]
["序号","店铺","6月1日——6月30日",null,null,"预计销售","成交人数","客单价","费用占比","5月1日——5月30日",null,null,null,"实际销售","成交人数","客单价","费用占比(实际）"]
[null,null,"项目","费用预计","特殊备注",{"$nulls":4},"项目","申请费用","实际费用","费用使用率"]
[1,"xxxx旗舰店\n\n有其它费用，直接插入行","直通车推广费用",55000,null,1208750,{"$f":"F6/H6","v":29481.7073170732},41,{"$f":"D12/F6","v":0.0612202688728025},"直通车推广费用",50000,50254.5,{"$f":"L6/K6","v":1.00509},2029615.98,51328,39.54,{"$f":"L12/N6","v":0.0289681302174217}]
[null,null,"钻展\n聚划算使用",10000,{"$nulls":5},"钻展",10000,2292.68,0.229268]
[null,null,"售后费用",3500,{"$nulls":5},"售后费用",3000,1618.2,0.5394]
[null,null,"xx佣金",0,{"$nulls":5},"刷单佣金",0,0,{"$error":"#DIV/0!"}]
[null,null,"营销返现费用",500,{"$nulls":5},"营销返现费用",2000,377.8,0.1889]
[null,null,"短信费用",5000,{"$nulls":5},"短信费用",5000,4251,0.8502]
[null,null,"费用预估消耗",{"$f":"SUM(D6:D11)","v":74000},{"$nulls":5},"费用总和",{"$f":"SUM(K6:K11)","v":70000},{"$f":"SUM(L6:L11)","v":58794.18},0.839916857142857]
[null,null,"资金申请",{"$f":"SUM(D6:E11)","v":74000}]
[2,null,"6月01日-6月30日工作安排","第一周","第二周","第三周","第四周","费用/流量/销售额合计",null,"根据公司实际实情，可以是左边的数据进行核对，亦可以是对这个月和下个月的展望！或者建议，意见！"]
["常规流量配比","直通车","周费用",10000,10000,13000,13000,{"$f":"D15+E15+F15+G15","v":46000}]
[null,null,"流量",{"$f":"D15/D17","v":5555.55555555556},5263.15789473684,6842.1052631579,7222.22222222222,24883.0409356725]
[null,null,"CPC点击费用",1.8,1.9,1.9,1.8]
[null,null,"ROI",1.2,1.2,1.2,1.2]
[null,null,"销售额",{"$f":"(D15+E15+F15+G15)*1.2","v":55200},null,null,null,55200]
[null,"钻展","周费用",0,0,0,0]
[null,null,"流量",0,0,{"$f":"F20/F22","v":0},0,{"$f":"D21+E21+F21+G21","v":0}]
[null,null,"CPC点击费用",0,0,0.8,0.8]
[null,null,"ROI",0,0,1,1]
[null,null,"销售额",{"$f":"(D20+E20+F20+G20)*1","v":0},null,null,null,0]
[null,"淘宝客","日均流量",200,200,200,300,900]
[null,null,"客单价",50,50,50,50]
[null,null,"日均销售额",500,280,280,280]
[null,null,"月佣金比例",0.07,0.07,0.07,0.07,{"$f":"D28+E28+F28+G28","v":0.28}]
[null,null,"月销售额",35000,null,null,null,35000]
[null,"自然搜索","日均流量",8000,8000,8000,10000,34000]
[null,null,"转化率",0.09,0.11,0.115,0.09]
[null,null,"客单价",47,47,47,47]
[null,null,"日均销售额",{"$f":"D30*D31*D32","v":33840},41360,43240,42300]
[null,null,"月销售额",{"$f":"(D33+E33+F33+G33)*7","v":1125180},null,null,null,{"$f":"D34+E34+F34+G34","v":1125180}]
[null,"销售额合计",null,{"$f":"D19+D24+D29+D34","v":1215380},0,0,0]
["第一周工作重点\n（6.1-6.7）\n记重点，不记流水账，流水账自行登记",null,"1.66大促活动\n2.淘抢购、淘金币、聚划算 6月份的计划",{"$nulls":6},"对应周总结，简明扼要"]
["第二周工作重点\n\n（6.08-6.14）",null,"1.6月14日 淘抢购品牌抢活动\n2.618大促活动\n3.",{"$nulls":6},"对应周总结，简明扼要"]
["第三周工作重点\n（6.15-6.22）",null,"1.聚划算品牌团的工作安排\n2.做好下个月淘金币、聚划算、淘抢购活动的准备\n",{"$nulls":6},"对应周总结，简明扼要"]
["第四周工作重点\n（6.23-6.30）",null,"1.淘抢购单品的活动\n2.报名店铺其他活动",{"$nulls":6},"对应周总结，简明扼要"]

{"sheet":"竞争对手登记表","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3],[4,5,10,9]]}
[null,"空调竞争对手产品聚划算统计"]
["开始时间","持续时间","序号","产品","聚划算价","一口价 ","准备库存数","销售时间中间节点","节点销量","最终销量","店铺名称","宣传点","链接地址"]
["2014-05-17",null,1,"海尔",2999,3999,{"$f":"844+19","v":863},"2014-05-18T15:25:00",844,1017,"海尔官方旗舰店","海尔大1.5匹变频空调","http://detail.ju.taobao.com/home.htm?spm=608.7117297.all1.20.m7oATU&item_id=37875799428&id=10000002723770"]
[null,null,2000]
[null,null,2001,null,null,"2016年版的《年度运营计划表》，被人挖坑，说没有竞争对手表等！\n也很多商家，向我索要“直通车”“钻展”“淘宝客”“售后登记分析表”“运营数据日报表”“周报表”“月报表”等等所有的表格……\n\n这里特别说明一下：\n如果亲稍微用心，这些表格都是可以轻易的自已制作出来。\n并抓住重要的数据去梳理！\n\n比如有了这个登记表，你可以从各种纬度去分析了解对手！"]
[null,null,2002]
[null,null,2003]
[null,null,2004]
[null,null,2005]
[null,null,2006]
[null,null,2007]

{"sheet":"单品打造计划","index":2,"n_rows":27,"n_cols":24,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,0,8,0],[10,0,12,0],[13,0,15,0],[0,5,1,6],[0,17,1,19],[26,4,31,19]]}
[null,"目标","xxxxxxxxx",null,null,"理想成本",{"$nulls":11},"理想利润"]
[null,"时间","xxxxxxxx"]
[null,"营销简案","包数","单包价目前成本","成本","理想包价","理想成本","运费","猫点扣费","支付宝成交金额","送与各种金额","实收销售金额","总销售额","售卖单包价","利润","预估数量","盈亏","利润","数量","盈亏","广告天数","日费用","营销广告总费","备注"]
["第一个月","正常送试用装",64,0.8,{"$f":"C4*D4","v":51.2},0.7,{"$f":"C4*F4","v":44.8},7,{"$f":"J4*0.025","v":1.95},78,{"$f":"4*D4","v":3.2},{"$f":"J4-K4","v":74.8},{"$f":"J4*P4","v":0},{"$f":"L4/C4","v":1.16875},{"$f":"L4-H4-E4-I4","v":14.65},null,{"$f":"P4*O4","v":0},{"$f":"L4-G4-H4-I4","v":21.05},null,{"$f":"S4*R4","v":0},null,null,null,"最终目销销售顶点价格"]
[null,"买一送一",64,0.8,51.2,0.7,44.8,14,1.95,78,{"$f":"64*D5","v":51.2},26.8,0,0.41875,-40.35,null,0,-33.95,null,0]
[null,"半价",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"J6/2","v":39},39,187200,0.609375,-21.15,2400,-50760,-14.75,2400,-35400,15,1000,{"$f":"U6*V6","v":15000}]
[null,0.65,64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"J7*0.65","v":50.7},27.3,0,0.4265625,-32.85,null,0,-26.45,null,0,null,null,null,"ＸＸＸ 待定"]
[null,"减30",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"30","v":30},48,140400,0.75,-12.15,1800,-21870,-5.75,1800,-10350,7,1000,7000]
[null,"减20送试用装",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"20+4*D9","v":23.2},54.8,117000,0.85625,-5.35000000000001,1500,-8025.00000000001,1.05,1500,1575,8,800]
["第二个月","减20送试用装",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"20+4*D10","v":23.2},54.8,577200,0.85625,-5.35000000000001,{"$f":"8900-P9","v":7400},-39590,1.05,{"$f":"8900-S9","v":7400},7770,30,600,18000,"日常"]
["第三个月","68减5送试用装",64,0.8,51.2,0.7,44.8,7,1.7,68,{"$f":"5+4*D11","v":8.2},59.8,408000,0.934375,-0.100000000000006,6000,-600.000000000035,6.3,6000,37800,20,600,12000,"日常活动"]
[null,null,64,0.8,51.2,0.7,44.8,7,1.95,78,null,78,0,1.21875,17.85,null,0,24.25,null,0,null,null,null,"活动参插1-2场"]
[null,"78减10",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"10","v":10},68,124800,1.0625,7.85,1600,12560,14.25,1600,22800,10,500,{"$f":"U13*V13","v":5000},"日常"]
["第四个月","78元减10",64,0.8,51.2,0.7,44.8,7,1.95,78,{"$f":"4*D14","v":3.2},74.8,202800,1.16875,14.65,2600,38090,21.05,2600,54730,10,500,5000,"日常"]
[null,null,64,0.8,51.2,0.7,44.8,7,1.95,78,null,78,0,1.21875,17.85,null,0,24.25,null,0,null,null,null,"活动参插1-2场"]
[null,"68减5送试用装",64,0.8,51.2,0.7,44.8,7,1.7,68,{"$f":"5+4*D16","v":8.2},59.8,340000,0.934375,-0.100000000000006,5000,-500.000000000029,6.3,5000,31500,20,600,12000,"日常活动"]
["第五个月","78元减5送试用装",64,0.8,51.2,0.7,44.8,7,1.95,78,8.2,69.8,390000,1.090625,9.65,5000,48250,16.05,5000,80250,30,400,12000,"日常"]
[null,null,64,0.8,51.2,0.7,44.8,7,1.95,78,null,78,0,1.21875,17.85,null,0,24.25,null,0,null,null,null,"活动参插1-2场"]
["第六个月","78元减5送试用装",64,0.8,51.2,0.7,44.8,7,1.95,78,8.2,69.8,780000,1.090625,9.65,10000,96500,16.05,3500,56175,30,400,{"$f":"U19*V19","v":12000},"日常"]
[{"$nulls":11},0,0,{"$error":"#DIV/0!"},0,null,0,0,null,0,null,null,null,"活动参插1-2场"]
[{"$nulls":11},0,0,{"$error":"#DIV/0!"},0,null,0,0,null,0]
[{"$nulls":11},0,0,{"$error":"#DIV/0!"},0,null,0,0,null,0]
[null,"合计",{"$nulls":10},{"$f":"SUM(M4:M22)","v":3267400},null,null,43300,74054.9999999998,null,{"$f":"SUM(S4:S22)","v":36800},246850,null,null,98000]
[]
[null,"利润比例",{"$nulls":14},{"$f":"Q23/M23","v":0.0226648099406255},null,null,{"$f":"T23/M23","v":0.0755493664687519}]
[]
[{"$nulls":4},"很多运营，都会告诉老板，我们要亏本营销，我们要长远营销。\n\n有多少运营，有去真心的帮老板计算一下，要亏到几个月才能盈利？\n\n以上内容，是一个比较正常的方案，在执行过程中，做了微调！\n\n【并且，另有配套的销售方案一起使用！】 如果你够聪明，营销简案那一列，可以分析得出来一些味道，请根据自已的产品情况，去分析制作！ 并注意【理想成本】\n\n此方案为15年9月版开始，最终的执行结果为：前期二个月亏损10W左右，后一个月回本，第四个月营利，并保持大词销量排位前5位！并维持至今，打开各种资源端口！"]

{"sheet":"部门人员工作总结","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,5,0,12],[2,0,13,0],[2,1,13,1],[15,2,20,7]]}
["2016月6月6日 - 6月11日 ",{"$nulls":4},"请每周五下午16点前，发送到各自的项目经理邮箱"]
["职位","姓名","系号","登记日期","重点项目内容","内容细节（越详细越好）","对应联络人","开始时间","预计完成时间","实际完成时间","完成进度","自我改善区","备注"]
["XXX负责人","XXX",1,"6月6","淘抢购、淘金币、聚划算的活动报名","xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx","小二/美工","2016-04-11","2016-04-16"]
[{"$nulls":5},"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
[{"$nulls":5},"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
[{"$nulls":5},"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
[{"$nulls":5},"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
[{"$nulls":5},"xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx"]
[null,null,2,"6月8","旗舰店店铺宝贝主题的修改",null,"总监/美工","2016-04-11","2016-04-16"]
[null,null,3,"6月9","ＸＸＸ的推广","做详细的推广计划","总监/小二/美工","2016-04-11","2016-04-16"]
[null,null,4,"6月10","XXX的上新和推广","做详细的推广计划","总监/小二/美工","2016-04-08","2016-04-16"]
[null,null,6,"6月11","监督其他人员的工作",null,"总监/小二/美工","2016-04-08","2016-04-14"]
[]
[]
[]
[null,null,"一个团队，时间管理是非常，非常重要！\n一个好的管理者，从上面的周工作总结，可以对比得出，谁在撒谎，谁在玩弄时间，谁没有认真做事情！\n\n往下衍生，自然有《下周工作计划》与上表一致！"]

{"sheet":"时间管理大事记事本","index":4,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,1,21,3]]}
["星期日 ","星期一","星期二","星期三","星期四","星期五","星期六"]
["2016-02-28","2016-02-29","2016-03-01","2016-03-02","2016-03-03","2016-03-04","2016-03-05"]
[]
["2016-03-06","2016-03-07","2016-03-08","2016-03-09","2016-03-10","2016-03-11","2016-03-12"]
[]
["2016-03-13","2016-03-14","2016-03-15","2016-03-16","2016-03-17","2016-03-18","2016-03-19"]
[]
["2016-03-20","2016-03-21","2016-03-22","2016-03-23","2016-03-24","2016-03-25","2016-03-26"]
[]
["2016-03-27","2016-03-28","2016-03-29","2016-03-30","2016-03-31","2016-04-01","2016-04-02"]
[]
[]
[]
[]
[null,"再次强调，时间管理的重要性！\n懂得用上表的人，恭喜你！"]

{"sheet":"淘抢购方案","index":5,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,5,16,9]]}
[]
[]
[]
[]
[]
[{"$nulls":5},"亲，别那么懒！\n认真的思考一下自已！\n\n了解活动的基本规则！\n了解活动平台的玩法！\n了解你们自已！！！\n\n别天天在群里叫：为什么我的产品过不了活动\n为什么这么好的产品，小二都不审核！\n\n也别太相信那些天天说包过活动的！"]