{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["录入表","1","2","3","Model"],"not_rendered":{"charts":0,"images":1,"macros":1,"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":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,11]]}
["外贸客户跟进表   客户基本信息录入"]
["序号","公司名","客户类型","公司网址","国家","等级","联系人","电邮","电话","价格敏感度","客户来源","备注记录"]
[1,"MEDPRO S.R.L","Wholesaler","www.aaaa.com","Italy","☆☆☆☆☆","Rimond","rimond@aaaaa.com","+39 954 639 899","High","来源1","这个公司bla bla bla…"]
[2,"BLANCO ROSA","Distributor","www.bbbbb.com","Spain","☆☆☆☆","Luis","vazquez@bbbbb.com","+34 954 639 899","Low","来源2","这个客人bla bla bla"]
[3,"Cepretek","Importer, Distributor","www.cccccc.com","Germany","☆☆☆","Cristina","cristina.f@cccccc.com","+49 954 639 899","Medium","来源3","风急天高猿啸哀，渚清沙白鸟飞回。"]
[4,"NORTHEN SAFETY","Importer","www.dddddd.com","United States","☆☆☆☆☆","Harry Porter","harry@dddddd.com","+1 954 639 899","High","来源4","无边落木萧萧下，不尽长江滚滚来。"]
[5,"LAKELAND INC","Manufacturer, importer","www.eeeeee.com","United States","☆☆☆☆☆","Dwyane Wade","dwade@eeeeee.com","+1 954 639 899","High","来源5","万里悲秋常作客，百年多病独登台。"]
[6,"ProSlim Ltd","Distributor","www.ffff.com","UK","☆☆","David","david@ffffffff.com","+49 954 639 899","Low","来源6","艰难苦恨繁霜鬓，潦倒新停浊酒杯。"]
[]
[]
[]
[]
[]
[]
["说明："]
[]
["1. 上面信息录入表内的数据区域单元格都是左对齐的，加了右缩近。视图取消了显示网格线，如果你不习惯可以通过视图 - 勾选网格线来恢复显示。"]
["2. 点击公司名，通过表间超链接，跳转到具体的客户公司跟进详情记录页面（页面名为数字，数字数值为序号值）。跟进详情记录表界面点击左上方的金色小人，可以回到本录入表。"]
["3. 空白的 Model 表千万不要删除！也不要移动它在表之间的位置（保持默认位置处于最后一个表）！否则无法自动创建跟进详情表格。"]
["4. 留了3行已录入基本信息但尚未生成详情跟进记录表的，供熟悉操作和练手。"]
[]
["操作方法："]
["比如此时要添加一个名为4的客户跟进详情表。鼠标点击序号4，然后再去点击那个长按钮，会自动生成详情表4。生成表5同样操作。"]
["自动生成的同时会在录入表的当前行的公司名单元格上，自动添加到跟进记录表的链接。"]

{"sheet":"1","index":1,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[[26,1,26,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[14,1,14,4],[0,0,0,5],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[6,1,6,5]]}
[{"$f":"录入表!B3","v":"MEDPRO S.R.L"}]
["客 户 序 号",{"$f":"录入表!A3","v":1},null,null,"处于录入表位置",{"$f":"\"第\"&(B2+2)&\"行\"","v":"第3行"}]
["公 司 网 站",{"$f":"录入表!D3","v":"www.aaaa.com"},null,null,"国       家",{"$f":"录入表!E3","v":"Italy"}]
["客 户 类 型",{"$f":"录入表!C3","v":"Wholesaler"},null,null,"电       话",{"$f":"录入表!I3","v":"+39 954 639 899"}]
["电 子 邮 件",{"$f":"录入表!H3","v":"rimond@aaaaa.com"},null,null,"客 户 来 源",{"$f":"录入表!K3","v":"来源1"}]
["等 级 评 估",{"$f":"录入表!F3","v":"☆☆☆☆☆"},null,null,"价 格 敏 感 度",{"$f":"录入表!J3","v":"High"}]
["背 景 记 录",{"$f":"录入表!L3","v":"这个公司bla bla bla…"}]
[]
["跟 进 日 期","跟 进 情 况",null,null,null,"客 户 意 见 反 馈"]
["2008-06-14","客人反馈PE围裙的系带容易断裂，已经向工厂反映"]
["2008-06-15","工厂决定改变刀模，使得系带更宽，同时注意围裙厚度，保证不会轻易断裂",null,null,null,"客户已同意此解决方案，要求寄送新样品"]
["2008-06-21","新的围裙样品已寄出，已告知DHL单号"]
["2008-06-26","客户确认新样品，下周发PO"]
["2008-07-05","新PO收到，PI已发。注意此单纸箱为白箱，内袋为蓝黑双色不干胶。"]
["2008-07-07","客户确认包装无误。"]
["2008-07-08","定金到账，生产计划已安排，包装预计11号到位。"]
["2008-08-02","通知客户货快生产完毕，及时确认货代信息。",null,null,null,"客户告知已更换货代，给了联系方式。"]
["2008-08-03","单证已联系货代订舱事宜，船期8月9号。长荣船。"]
["2008-08-05","货已到仓库，收到货物照片，外箱完好无污损。"]
["2008-08-07","货物已进港区，等待装船。"]
["2008-08-09","已开船。给客户已发shipment advise."]
["2008-08-16","已拿到提单，COPY件已发给客户。",null,null,null,"客户回复3天内付款。"]
["2008-08-18","收到客户水单，已交给单证。"]
["2008-08-19","尾款到账，已认款。"]
["2008-08-19","已寄送清关单据，随附一份新版Catalog"]
["2008-08-28","提醒客户船即将到港，尽早安排相关工作。"]
["2008-08-28","发送邮件，询问客户对货物的意见。",null,null,null,"客户反馈OK，准备下周下新PO。"]

{"sheet":"2","index":2,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[19,1,19,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[26,1,26,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[6,1,6,5],[0,0,0,5],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3]]}
[{"$f":"录入表!B4","v":"BLANCO ROSA"}]
["客 户 序 号",{"$f":"录入表!A4","v":2},null,null,"处于录入表位置","第4行"]
["公 司 网 站",{"$f":"录入表!D4","v":"www.bbbbb.com"},null,null,"国       家",{"$f":"录入表!E4","v":"Spain"}]
["客 户 类 型",{"$f":"录入表!C4","v":"Distributor"},null,null,"电       话",{"$f":"录入表!I4","v":"+34 954 639 899"}]
["电 子 邮 件",{"$f":"录入表!H4","v":"vazquez@bbbbb.com"},null,null,"客 户 来 源",{"$f":"录入表!K4","v":"来源2"}]
["等 级 评 估",{"$f":"录入表!F4","v":"☆☆☆☆"},null,null,"价 格 敏 感 度",{"$f":"录入表!J4","v":"Low"}]
["背 景 记 录",{"$f":"录入表!L4","v":"这个客人bla bla bla"}]
[]
["跟 进 日 期","跟 进 情 况",null,null,null,"客 户 意 见 反 馈"]

{"sheet":"3","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,1,6,5],[0,0,0,5],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[19,1,19,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[26,1,26,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4]]}
[{"$f":"录入表!B5","v":"Cepretek"}]
["客 户 序 号",{"$f":"录入表!A5","v":3},null,null,"处于录入表位置",{"$f":"\"第\"&(B2+2)&\"行\"","v":"第5行"}]
["公 司 网 站",{"$f":"录入表!D5","v":"www.cccccc.com"},null,null,"国       家",{"$f":"录入表!E5","v":"Germany"}]
["客 户 类 型",{"$f":"录入表!C5","v":"Importer, Distributor"},null,null,"电       话",{"$f":"录入表!I5","v":"+49 954 639 899"}]
["电 子 邮 件",{"$f":"录入表!H5","v":"cristina.f@cccccc.com"},null,null,"客 户 来 源",{"$f":"录入表!K5","v":"来源3"}]
["等 级 评 估",{"$f":"录入表!F5","v":"☆☆☆"},null,null,"价 格 敏 感 度",{"$f":"录入表!J5","v":"Medium"}]
["背 景 记 录",{"$f":"录入表!L5","v":"风急天高猿啸哀，渚清沙白鸟飞回。"}]
[]
["跟 进 日 期","跟 进 情 况",null,null,null,"客 户 意 见 反 馈"]

{"sheet":"Model","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,1,6,5],[0,0,0,5],[2,1,2,3],[3,1,3,3],[4,1,4,3],[5,1,5,3],[19,1,19,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[26,1,26,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4]]}
[]
["客 户 序 号",null,null,null,"处于录入表位置"]
["公 司 网 站",null,null,null,"国       家"]
["客 户 类 型",null,null,null,"电       话"]
["电 子 邮 件",null,null,null,"客 户 来 源"]
["等 级 评 估",null,null,null,"价 格 敏 感 度"]
["背 景 记 录"]
[]
["跟 进 日 期","跟 进 情 况",null,null,null,"客 户 意 见 反 馈"]