{"text_format":"1","workbook":"xlsx","n_sheets":3,"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,"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":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,0,9,0],[10,0,14,0],[15,0,34,0]]}
["序号","货品ID","货品名称","单位","规格","产地"]
[1,136396,"芪鹿补血颗粒","盒","7gx9袋","重庆中药二厂"]
[2,139379,"感冒清热颗粒","盒","12g*12袋","重庆中药二厂"]
[3,144423,"健胃消食片","盒","0.8g*32片（无糖型薄膜衣片）","江中药业股份"]
[4,47683,"藿香正气口服液","盒","10mlx10支","太极涪陵药厂"]
[5,104690,"炎可宁胶囊","盒","0.4g*3板*9粒","四川绵阳制药"]
[6,21580,"补肾益寿胶囊","盒","0.3gx60粒","太极涪陵药厂"]
[null,40226,"五子衍宗丸","瓶","120丸(浓缩丸)","四川绵阳制药"]
[null,84174,"六味地黄丸","盒","126丸/瓶(浓缩丸)","重庆中药二厂"]
[null,122482,"蚕蛾公补片","盒","0.23x24片(糖衣)","重庆桐君阁"]
[7,129713,"雅培益力佳SR营养配方粉（香草口味）","罐","400g","上海雅培"]
[null,138553,"雅培全安素全营养配方粉","罐","900g","雅培贸易（上海）"]
[null,146989,"雅培全安素全营养配方粉（礼盒装 ）","罐","1.8千克(900克*2罐)","雅培贸易（上海）"]
[null,148051,"雅培全安素全营养配方粉（红枣味）","罐","900g","荷兰"]
[null,148052,"雅培全安素全营养配方粉","罐","400g","荷兰"]
[8,105219,"七味铁屑丸","瓶","1gx20丸(水丸)","西藏藏医学院"]
[null,105221,"十八味降香丸","盒","18丸(每10丸重6g)(水丸)","西藏藏医学院"]
[null,105224,"五味金色丸","盒","0.25gx48丸(水丸)","西藏藏医学院"]
[null,105226,"二十五味珍珠丸","盒","1gx8丸","西藏藏医学院"]
[null,105227,"三味甘露散","盒","4gx10袋","西藏藏医学院"]
[null,105229,"石榴日轮丸","瓶","0.65gx54丸","西藏藏医学院"]
[null,105230,"十味乳香丸","瓶","0.3gx50丸(水丸)","西藏藏医学院"]
[null,105231,"二十五味珊瑚丸","盒","1gx8丸","西藏藏医学院"]
[null,105232,"十一味维命散","盒","2.4gx10袋","西藏藏医学院"]
[null,105233,"五味石榴丸","瓶","0.25gx40丸","西藏藏医学院"]
[null,105276,"秘诀清凉散","盒","2gx10袋","西藏藏医学院"]
[null,105279,"二十五味松石丸","盒","1gx8丸","西藏藏医学院"]
[null,105293,"十三味菥蓂丸","瓶","0.6gx45丸","西藏藏医学院"]
[null,105315,"常松八味沉香散","盒","1.3gx20袋","西藏藏医学院"]
[null,106918,"十味诃子散","盒","3gx10袋","西藏藏医学院"]
[null,117370,"十五味黑药丸","盒","0.8gx8丸x2板","西藏藏医学院"]
[null,117371,"二十五味鬼臼丸","盒","1gx8丸","西藏藏医学院"]
[null,117372,"清肺止咳丸","盒","0.25gx12丸x3板","西藏藏医学院"]
[null,130350,"七味红花殊胜丸","盒","0.3gx36丸(水丸)(12丸x3板)","西藏藏医学院"]
[null,134407,"石榴健胃散","盒","1.2gx10袋","西藏藏医"]

{"sheet":"奖励政策及处罚","index":1,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[13,13,13,14],[6,0,9,0],[6,7,9,7],[6,9,9,9],[6,10,9,10],[6,11,9,11],[0,0,0,17],[6,15,9,15],[2,18,3,18],[4,18,5,18],[6,18,9,18],[10,18,11,18]]}
["2016年7月金牌品种任务及奖励明细"]
["序号","ID","产品名称","单位","规格","厂家","2016年6月销售","2016年6月销售","2015年6月销售","挑战1","挑战2","挑战3","奖励标准1","奖励标准2","奖励标准3","未完成基础处罚","晒单奖励","活动内容","营运部负责人员"]
[1,null,"藏药系列",null,null,null,22.15,22.15,25.56,211100,277500,333800,0.15,0.2,0.25,0.1,null,"见附表2","何莉莎"]
[2,144423,"健胃消食片","盒","0.8g*32片（无糖型薄膜衣片）","江中药业股份",989,989,{"$error":"#N/A"},1036,1349,1598,0.8,1,1.5,0.5,null,"两盒以上7.5折"]
[3,136396,"芪鹿补血颗粒","盒","7gx9袋","重庆中药二厂",383,383,64,407,551,807,8,10,15,8,"4元/瓶","五盒8折","王四维"]
[4,null,"全安素系列",null,null,null,1000.5,1000.5,40,800,900,1220,15,20,30,10,"1、全安素：单罐（900g）晒单，奖励3元/听，疗程晒单（2罐或以上、1个礼盒按2罐计算），奖励7元/听。2、益力佳：单独晒单，奖励3元/听；联合用药晒单（关联糖尿病类、减肥类、孕妇用药类），奖励7元/听。","全安素买一送4袋，买二送10袋，赠品由厂家提供；全安素900g空罐换购抵扣20元；益力佳买二赠一；"]
[5,84174,"六味地黄丸","盒","126丸/瓶(浓缩丸)","重庆中药二厂",1800,23.4,1743,22.8,25,27.3,2.5,3.5,5,0.08,null,"六盒省25元","陈柳"]
[null,21580,"补肾益寿胶囊","瓶","0.3g*60粒","太极涪陵药厂",1588,null,1703,null,null,null,4,6,9,null,"5元/瓶","买1大盒送1瓶24粒装；买2大盒送3瓶24粒装"]
[null,40226,"五子衍宗丸","瓶","120丸(浓缩丸)","四川绵阳制药",858,null,301,null,null,null,6,9,12,null,null,"买三得四（赠品为补肾强身胶囊），组合ID：9907810，七盒省58元，赠送的原品不计入门店任务"]
[null,122482,"蚕蛾公补片","盒","0.23x24片(糖衣)","重庆桐君阁",424,null,910,null,null,null,8,10,12,null,null,"买一赠一"]
[6,139379,"感冒清热颗粒","盒","12g*12袋","重庆中药二厂",1748,1748,{"$error":"#N/A"},1580,1770,2200,1.5,2,3,1.5,null,null,"杨雯雯"]
[7,47683,"藿香正气口服液","盒","10mlx10支","太极涪陵药厂",33653.1,33653.1,21016.2,17000,19000,21000,0.8,1,1.5,0.8,"1、每天晒单前五名奖励6.6元/单（要求每单数量3盒以上）2、团购红包：一件（含）以上奖励12.88元/单。"]
[8,104690,"炎可宁胶囊","盒","0.4g*3板*9粒","四川绵阳制药",2351,2351,{"$error":"#N/A"},1800,2100,2400,2.5,3.5,5,2.5,null,"两盒省五元","内勤"]
[null,null,"董事长：",null,null,null,"总经理：",null,null,null,null,null,null,"营运部经理：",null,null,null,"制表人：陈柳"]

{"sheet":"任务","index":2,"n_rows":4,"n_cols":44,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,9,0,13],[0,14,0,18],[0,19,0,23],[0,24,0,28],[0,29,0,33],[0,34,0,38],[0,39,0,42],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,8]]}
["序号","门店ID","门店名称","片区","藏药",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,"挑战1","挑战2","挑战3","挑战等级","挑战金额","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量","挑战1","挑战2","挑战3","挑战等级","挑战数量"]
[null,null,null,null,0.15,0.2,0.25,null,null,0.8,1,1.5,null,null,15,20,30,null,null,8,10,15]
[37,399,"高新天久北巷药店","高新片区",1600,2100,2600,null,null,8,10,12,null,null,5,6,8,null,null,5,6,8,null,null,1500,{"$f":"Y4*1.1","v":1650.0000000000002},{"$f":"Y4*1.2","v":1800},null,null,12,14,16,null,null,84,97,115,null,null,16,20,25]