{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["征订数 反馈明细表","征订信息","征订目标分解"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"征订数 反馈明细表","index":0,"n_rows":152,"n_cols":12,"rows_kept":152}
["客户编码","客户名称","渠道","备注","省份","主管业务","BEAMS AT HOME 4 理想之家","关键句是死亡","受限福尔摩斯机","苏州园林谋杀简史","烟台传：半岛的此在与彼在","秦始皇传"]
["BJ0054","江苏圆周电子商务有限公司（京东商城 北京库）","网站","全品","北京","丁玥"]
["BJ0005","北京当当网信息技术有限公司（当当网北京库","网站","全品","北京","张珊珊"]
[]
["SH001","上海新华传媒连锁有限公司","主渠道","全品","上海","侯爽"]
["SH004","上海天地图书有限公司","二渠道","全品","上海","侯爽"]
["SH033","上海镜湖文化传播有限公司","二渠道","文学","上海","侯爽"]
["SH0050","上海悦悦图书有限公司","二渠道","社科","上海","侯爽"]
["SH024","上海图书公司","二渠道","社科","上海","侯爽"]
["SH035","上海上图书店","二渠道","全品","上海","侯爽"]
["SH002","上海季风图书有限公司","二渠道","全品","上海","侯爽"]
["SH026","上海钟书实业有限公司","二渠道","全品","上海","侯爽"]
["SH007","上海建投书店","二渠道","全品","上海","侯爽"]
["SH019","上海联诚图书有限公司","二渠道","全品","上海","侯爽"]
["gd0001","广东新华发行集团股份有限公司","主道批发","全品","广东","侯爽"]
["gd0023","广州新华出版发行集团股份有限公司物流配送分公司","主道零售","全品","广东","侯爽"]
["gdzh0003","广东省珠海市新华书店","主道零售","全品","广东","侯爽"]
["gdsz0001","深圳市发行（集团）公司采购中心","主道零售","全品","广东","侯爽"]
["gdfs0001","佛山市新华书店","主道零售","全品","广东","侯爽"]
["gdzj0001","湛江市新华书店有限公司","主道零售","全品","广东","侯爽"]
["gd0024","广州新经典发行有限公司","二道批发","全品","广东","侯爽"]
["gd0012","广东诚一文化传播有限公司","二道批发","重点品","广东","侯爽"]
["gd0020","广东方所商贸有限公司","二道零售","全品","广东","侯爽"]
["gd0003","广东学而优图书文化发展有限公司","二道零售","全品","广东","侯爽"]
["gdsz0003","深圳市求实图书有限公司","二道批发","全品","广东","侯爽"]
["gdzh0001","珠海市文华书城有限公司","二道零售","全品","广东","侯爽"]
["gdsz0004","深圳市友谊书城有限公司","二道零售","全品","广东","侯爽"]
["gdfs0003","佛山市东方书城图书有限公司","二道零售","全品","广东","侯爽"]
["gx0001","广西新华文盛图书有限公司","主道批发","全品","广西","侯爽"]
["gx0003","桂林市新华书店有限公司","主道零售","全品","广西","侯爽"]
["gx0004","南宁市新华书店有限责任公司","主道零售","全品","广西","侯爽"]
["gx0006","刀锋书店","二道零售","全品","广西","侯爽"]
["FJ010","福建新华图书发行有限公司","主渠道","全品","福建","侯爽"]
["BJ0101","福州葫芦弟弟电子商务有限公司","网站","全品","福建","侯爽"]
["FJ004","厦门对外图书交流中心","二渠道","全品","福建","侯爽"]
["FJ015","福建良朴","二渠道","重点品","福建","侯爽"]
["FJ003","福建省越洋图书文化城有限公司","二渠道","重点品","福建","侯爽"]
[]
["ZJ004","浙江省新华书店集团有限公司","主渠道","全品","浙江","马威"]
["ZJ019","博库网络有限公司","主渠道","全品","浙江","马威"]
["ZJ001","杭州金典图书有限公司","二渠道","全品","浙江","马威"]
["ZJ002","杭州新视角图书有限公司","二渠道","全品","浙江","马威"]
["ZJ003","杭州翰香图书有限公司（晓风书屋）","二渠道","社科","浙江","马威"]
[]
["BJ0001","新华书店首都发行所（物流中心）","主渠道","全品","北京","付雷"]
["BJ0035","北京人天书店有限公司","馆配","全品","北京","付雷"]
["BJ0014","北京一恒盛辉图书有限公司","二渠道","全品","北京","付雷"]
["BJ0026","北京大地书苑图书发行有限公司","二渠道","全品","北京","付雷"]
["BJ00108","北京锦瑟闻香图书有限公司","二道批发","重点品","北京","付雷"]
["BJ00107","互优网（北京）国际文化有限公司","二渠道","重点品","北京","付雷"]
["BJ0097","中盘图书发行（北京）有限公司","二渠道","重点品","北京","付雷"]
["BJ0045","中信联合发行有限责任公司（首都机场店）","二渠道","重点品","北京","付雷"]
["BJ0071","北京市蔚蓝时代商业管理有限公司 ","二渠道","重点品","北京","付雷"]
["BJ0008","北京涵芬楼书店有限公司","二渠道","全品","北京","付雷"]
["BJ0009","北京三联韬奋图书中心","二渠道","重点品","北京","付雷"]
["BJ0053","北京库布里克书店有限公司","二渠道","重点品","北京","付雷"]
["BJ0010","北京百万庄图书大厦有限公司","二渠道","全品","北京","付雷"]
["BJ00103","北京字里行间文化发展有限公司","二渠道","重点品","北京","付雷"]
["BJ0036","北京万圣书园图书有限责任公司","二渠道","全品","北京","付雷"]
["BJ0048","单向街","二渠道","重点品","北京","付雷"]
["HB004","河北省新华书店有限责任公司图书批销分公司","主道批发","全品","河北","付雷"]
["HB001","石家庄市丛盛图书贸易有限责任公司","二渠道","全品","河北","付雷"]
["HB002","石家庄秋林书城有限公司","二渠道","全品","河北","付雷"]
["HB013","大厂回族自治县伊乡书局有限公司","二渠道","全品","河北","付雷"]
["HB014","河北新经典出版物发行有限公司","二渠道","文学","河北","付雷"]
["HB015","保定新世纪图书大厦有限公司","二渠道","全品","河北","付雷"]
["HB016","北京百尺楼商贸有限公司","二渠道","全品","河北","付雷"]
["H00003","山西尔雅书店有限公司","二渠道","全品","山西","付雷"]
["SX006","山西新华现代出版物连锁有限责任公司","主道批发","全品","山西","付雷"]
["tj0004","天津图书大厦","主渠道","全品","天津","付雷"]
["tj0010","天津市超越世纪图书商贸有限公司","二渠道","社科","天津","付雷"]
["B00002","吉林省新华书店集团长春市有限责任公司","主渠道","全品","吉林","付雷"]
["B00001","吉林省新华书店图书批销中心","主渠道","全品","吉林","付雷"]
["B00005","长春联合图书城有限公司","二渠道","重点品","吉林","付雷"]
["B00011","长春市学人文化传播有限责任公司","二渠道","重点品","吉林","付雷"]
["B00015","吉林出版集团网络图书","二道批发","全品","吉林","付雷"]
["C00010","鞍山市新华书店","主渠道","全品","辽宁","付雷"]
["C00003","沈阳市新华书店","主渠道","全品","辽宁","付雷"]
["C00004","大连市新华书店","主渠道","全品","辽宁","付雷"]
["C00001","辽宁北方出版物配送有限公司","主渠道","全品","辽宁","付雷"]
["C00006","沙河口区八斗书局","二渠道","重点品","辽宁","付雷"]
["A00003","大庆市新华书店萨尔图分店","主渠道","重点品","黑龙江","付雷"]
["A00005","哈尔滨市学府书店","二渠道","重点品","黑龙江","付雷"]
["A0007","大庆油田三合科技书店","二渠道","重点品","黑龙江","付雷"]
["A00009","哈尔滨中央书店","二渠道","重点品","黑龙江","付雷"]
["I00001","内蒙古新华书店图书大厦有限责任公司","主渠道","全品","内蒙古","付雷"]
["AX005","西安市新华书店采购中心","主渠道","全品","陕西","付雷"]
["AX0005","万邦图书城","二渠道","全品","陕西","付雷"]
["AX004","陕西嘉汇汉唐图书发行有限责任公司","二渠道","全品","陕西","付雷"]
["GS001","甘肃省新华书店图书批销中心","主渠道","全品","甘肃","付雷"]
["GS002","甘肃纸中城邦书业有限公司","二渠道","全品","甘肃","付雷"]
["GS006","广场书城事业开发部","二渠道","全品","甘肃","付雷"]
["GS008","兰州书立方文化传播有限公司","二渠道","全品","甘肃","付雷"]
["QH002","西宁三田书城有限责任公司","二渠道","全品","甘肃","付雷"]
["nx003","银川市新华书店","主渠道","全品","宁夏","付雷"]
["NX001","宁夏新华书店图书音像批销中心","主渠道","全品","宁夏","付雷"]
["QH001","青海省新华发行集团图书批销中心","主渠道","全品","青海","付雷"]
["XJ003","新疆乌市文史书店有限责任公司","二渠道","全品","新疆","付雷"]
["XJ001","新疆乌鲁木齐飞行图书有限公司","二渠道","全品","新疆","付雷"]
["XJ004","新疆维吾尔自治区新华书店图书批销中心","主渠道","全品","新疆","付雷"]
["XJ002","乌鲁木齐市新华书店物流配送中心","主渠道","全品","新疆","付雷"]
[]
["cq0001","重庆新华传媒有限公司采购分公司","主渠道","全品","重庆","王秀"]
["cq0004","重庆聚知书店","二渠道","文学","重庆","王秀"]
["cq0015","重庆购书中心有限公司","二渠道","全品","重庆","王秀"]
["cq0007","贵州西西弗文化传播有限公司（重庆分店）","二渠道","全品","重庆","王秀"]
["cq0002","重庆精典书店","二渠道","全品","重庆","王秀"]
["cq0017","重庆新经典发行有限公司","二渠道","重点品","重庆","王秀"]
["yn0001","云南新华书店图书有限公司","主渠道","全品","云南","王秀"]
["yn0003","云南新经爱出版物发行有限公司","二渠道","重点品","云南","王秀"]
["gz0012","贵州省新华书店图书音像有限公司","主渠道","全品","贵州","王秀"]
["gz0002","贵州西西弗文化传播有限公司","二渠道","全品","贵州","王秀"]
["sc0001","新华文轩出版传媒股份有限公司","主渠道","全品","四川","王秀"]
["sc0017","成都天宇图书有限责任公司","二渠道","全品","四川","王秀"]
["sc0006","四川星洋文化有限公司","二渠道","重点品","四川","王秀"]
["sc0012","中盘图书发行成都有限公司","二渠道","全品","四川","王秀"]
["sc0018","四川言几又文化传播有限公司","二渠道","全品","四川","王秀"]
[]
["JS005","江苏省新华书店发行集团物流配送分公司","主渠道","全品","江苏"]
["JS016","诚品书店(苏州工业园区)有限公司","二渠道","全品","江苏"]
["js001","南京先锋书店","二渠道","全品","江苏"]
["js004","大众","二渠道","全品","江苏"]
["JS009","江苏华茂图书文化经营部","二渠道","全品","江苏"]
["js003","南京尚文图书文化有限责任公司","二渠道","全品","江苏"]
["JS015","南京新经典","二渠道","全品","江苏"]
[]
["AH002","安徽新华图书音像连锁有限公司","主渠道","全品","安徽","沙漠"]
["AH003","合肥科华教育书店","二渠道","重点品","安徽","沙漠"]
["JX001","江西省新华书店图书音像批销中心","主渠道","全品","江西","沙漠"]
["JX003","江西省南昌市青苑书店","二渠道","全品","江西","沙漠"]
["J00002","南昌市佳丰书社","二渠道","重点品","江西","沙漠"]
["SD008","山东新华书店集团有限公司图书批销中心","主渠道","全品","山东","沙漠"]
["SD006","青岛市新华书店","主渠道","全品","山东","沙漠"]
["SD001","济南市新华书店","主渠道","全品","山东","沙漠"]
["SD011","济南联合书社","二渠道","重点品","山东","沙漠"]
["E00010","豫浙合作图书部","主渠道","全品","河南","沙漠"]
["E00002","河南省郑州市新华书店有限公司","主渠道","全品","河南","沙漠"]
["E00009","河南省图苑实业发展有限责任公司","二渠道","重点品","河南","沙漠"]
["E00012","郑州翰林图书有限公司","二渠道","全品","河南","沙漠"]
["E00011","河南至诚经典图书有限公司","二渠道","全品","河南","沙漠"]
["F00001","湖北省新华书店(集团）有限公司","主道批发","全品","湖北","沙漠"]
["F00002","武汉新华书店股份有限公司","主道零售","全品","湖北","沙漠"]
["F00003","湖北长江文化广场有限公司","主道零售","全品","湖北","沙漠"]
["F00006","湖北至诚经典发行有限公司","二道批发","全品","湖北","沙漠"]
["F00013","武汉鲜橙文化有限责任公司","二道批发","全品","湖北","沙漠"]
["un0001","湖南省新华书店有限责任公司","主道批发","全品","湖南","沙漠"]
["un0002","湖南诚品文化发展有限公司","二道批发","全品","湖南","沙漠"]
["un0005","长沙连胜书社","二道批发","重点品","湖南","沙漠"]
["un0008","湖南叶洋文化传播有限公司","二道批发","文学","湖南","沙漠"]
["un0010","长沙麓之风图书有限责任公司","二道批发","社科","湖南","沙漠"]
["un0004","湖南弘道文化传播有限公司","馆配","全品","湖南","沙漠"]
[{"$nulls":5},"合计"]

{"sheet":"征订信息","index":1,"n_rows":7,"n_cols":17,"rows_kept":7}
["征订日期","重点书征订目标/备注","预计\n入库时间","图书\n级别","书号","图书名称","定价","作者","CIP","产品线\n大类","产品线\n小类","主题词","首印量","装帧","包册数","供货折扣","编辑部"]
[6.28,null,7.7,null,"978-7-5133-4485-2","BEAMS AT HOME 4 理想之家",{"v":158,"d":"158.00"},"[日] BEAMS 著；郑晓蕾 译","D731.383-49","生活","家居","生活方式－日本－通俗读物",8000,"平装",10,60,"生活风尚"]
[6.28,null,7.6,null," 978-7-5133-4564-4","关键句是死亡",{"v":55,"d":"55.00"},"[英] 安东尼·霍洛维茨 著\n王淑芹 译","I561.45","文学","侦探文学","长篇小说－英国－现代",12000,"平装",10,60,"午夜文库"]
[6.28,null,7.2,null,"978-7-5133-4407-4","受限福尔摩斯机",{"v":45,"d":"45.00"},"梅絮","I247.5","文学","推理小说","侦探小说－中国－当代",7000,"平装",10,60,"午夜文库"]
[6.28,null,7.2,null,"978-7-5133-4563-7","苏州园林谋杀简史",{"v":48,"d":"48.00"},"慢三","I247.5","文学","推理小说","长篇小说－中国－当代",8000,"平装",10,60,"午夜文库"]
[6.28,null,7.6,null,"978-7-5133-4520-0","烟台传：半岛的此在与彼在",{"v":89,"d":"89.00"},"王月鹏","K295.23","历史","传记","文化史－研究－烟台",3000,"精装",10,60,"重大项目办"]
[6.28,null,7.1,null,"978-7-5133-4531-6","秦始皇传",{"v":49,"d":"49.00"},"黄中业","K827-33","历史","传记","秦始皇（前259-前\n210）－传记",5000,"平装",10,60,"综合编室"]

{"sheet":"征订目标分解","index":2,"n_rows":16,"n_cols":8,"rows_kept":16,"merged":[[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,1]]}
["新书征订"]
["书名",null,"BEAMS AT HOME 4 理想之家","关键句是死亡","受限福尔摩斯机","苏州园林谋杀简史","烟台传：半岛的此在与彼在","秦始皇传"]
["首印数",null,8000,12000,7000,8000,3000,5000]
["库存",null,{"$f":"C3*20%","v":1600},2400,1400,1600,600,1000]
["首发数量",null,{"$f":"C3-C4","v":6400},9600,5600,6400,2400,4000]
["业务经理","渠道分解比例"]
["丁月",0.14,{"$f":"C5*B7","v":896},{"$f":"D5*B7","v":1344},{"$f":"B7*E5","v":784},{"$f":"F5*B7","v":896},{"$f":"G5*B7","v":336},{"$f":"H5*B7","v":560}]
["张珊珊",0.15,{"$f":"C5*B8","v":960},{"$f":"D5*B8","v":1440},{"$f":"B8*E5","v":840},{"$f":"F5*B8","v":960},{"$f":"G5*B8","v":360},{"$f":"H5*B8","v":600}]
["王秀",0.12,{"$f":"B9*C5","v":768},{"$f":"D5*B9","v":1152},{"$f":"B9*E5","v":672},{"$f":"F5*B9","v":768},{"$f":"G5*B9","v":288},{"$f":"H5*B9","v":480}]
["马威",0.12,{"$f":"B10*C5","v":768},{"$f":"D5*B10","v":1152},{"$f":"B10*E5","v":672},{"$f":"F5*B10","v":768},{"$f":"G5*B10","v":288},{"$f":"H5*B10","v":480}]
["付雷",{"v":0.1,"d":"0.10"},{"$f":"C5*B11","v":640},{"$f":"D5*B11","v":960},{"$f":"B11*E5","v":560},{"$f":"F5*B11","v":640},{"$f":"G5*B11","v":240},{"$f":"H5*B11","v":400}]
["侯爽",{"v":0.1,"d":"0.10"},{"$f":"B12*C5","v":640},{"$f":"D5*B12","v":960},{"$f":"B12*E5","v":560},{"$f":"F5*B12","v":640},{"$f":"G5*B12","v":240},{"$f":"H5*B12","v":400}]
["江苏",0.08,{"$f":"C5*B13","v":512},{"$f":"D5*B13","v":768},{"$f":"B13*E5","v":448},{"$f":"F5*B13","v":512},{"$f":"G5*B13","v":192},{"$f":"H5*B13","v":320}]
["沙漠",0.08,{"$f":"B14*C5","v":512},{"$f":"B14*D5","v":768},{"$f":"B14*E5","v":448},{"$f":"B14*F5","v":512},{"$f":"G5*B14","v":192},{"$f":"H5*B14","v":320}]
["天猫",0.05,{"$f":"C5*B15","v":320},{"$f":"D5*B15","v":480},{"$f":"B15*E5","v":280},{"$f":"F5*B15","v":320},{"$f":"G5*B15","v":120},{"$f":"H5*B15","v":200}]
["王琪",0.05,{"$f":"B16*C5","v":320},{"$f":"B16*D5","v":480},{"$f":"B16*E5","v":280},{"$f":"B16*F5","v":320},{"$f":"G5*B16","v":120},{"$f":"H5*B16","v":200}]