{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["office2007(及以上版本)使用说明","封面","报价单录入","报价单查询","报价单记录","客户资料","产品资料"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":13,"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":"office2007(及以上版本)使用说明","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["请照如下步骤设置您的Excel2007(及以上版本)："]
["1、在左上角点击“选项”按钮"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2、点选“启用此内容”后单击“确定”按钮"]

{"sheet":"封面","index":1,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[[4,0,4,11],[0,0,3,11],[5,0,18,11]]}
[]
[]
[]
[]
["报价单管理系统"]

{"sheet":"报价单录入","index":2,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[[1,1,1,11],[2,4,2,9],[3,4,3,5],[3,6,3,7],[3,8,3,9],[4,3,4,10],[5,4,5,5],[5,6,5,7],[5,8,5,9],[6,3,6,10],[7,6,7,9],[8,4,8,9],[9,4,9,5],[9,6,9,7],[9,8,9,9],[10,3,10,10],[11,4,11,5],[11,7,11,9],[12,4,12,5],[12,7,12,9],[14,8,14,9],[14,13,15,14],[4,13,5,14],[14,2,15,3]]}
[]
[null,"XXX进出口有限公司报价单"]
[null,null,null,"地址：",123]
[null,null,null,"联系人：","ad4a6d464d去",null,"联系电话/传真：",null,"xxxxxxxxxxx"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"以下区域为录入参考数据，不纳入打印范围："]
[null,null,null,"报价单编码：","95590t5950t90594 ",null,"报价日期：",null,"2020-05-15"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"客户等级",{"$f":"VLOOKUP(E8,客户资料!A:H,6,FALSE)","v":"C"}]
[null,null,null,"询价公司代码：","A03",null,null,null,null,null,null,null,null,"我方联络人",{"$f":"VLOOKUP(E8,客户资料!A:H,7,FALSE)","v":"钱xx"}]
[null,null,null,"地址：",{"$f":"VLOOKUP(E8,客户资料!A:H,3,FALSE)","v":"地址-xxx"},null,null,null,null,null,null,null,null,"备注",{"$f":"VLOOKUP(E8,客户资料!A:H,8,FALSE)","v":"公司正常"}]
[null,null,null,"联系人：",{"$f":"VLOOKUP(E8,客户资料!A:H,4,FALSE)","v":"赵xx"},null,"联系电话/传真：",null,{"$f":"VLOOKUP(E8,客户资料!A:H,5,FALSE)","v":"xxx-xxx-xxx"}]
[]
[null,null,null,"询价时间：",null,null,"交货方式："]
[null,null,null,"运输方式：",null,null,"报价备注："]
[]
[null,null,"报价单明细：",null,null,null,null,"订单合计",{"$f":"SUM(K18:K27)","v":{"$error":"#N/A"}}]
[]
[null,null,"序号","产品编号","产品名称","规格","型号","货币","单价","数量","总价",null,null,"成本","备注"]
[null,null,1,"ASD001",{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,4,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,7,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,5,FALSE))","v":{"$error":"#N/A"}},2000,{"$f":"IF(J18=\"\",0,I18*J18)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D18=\"\",\"\",VLOOKUP(D18,产品资料!A:H,8,FALSE))","v":{"$error":"#N/A"}}]
[null,null,2,"ASD002",{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,4,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,7,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,5,FALSE))","v":{"$error":"#N/A"}},200,{"$f":"IF(J19=\"\",0,I19*J19)","v":{"$error":"#N/A"}},null,null,{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D19=\"\",\"\",VLOOKUP(D19,产品资料!A:H,8,FALSE))","v":{"$error":"#N/A"}}]
[null,null,3,"ASD003",{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,2,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,3,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,4,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,7,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,5,FALSE))","v":{"$error":"#N/A"}},10,{"$error":"#N/A"},null,null,{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,6,FALSE))","v":{"$error":"#N/A"}},{"$f":"IF(D20=\"\",\"\",VLOOKUP(D20,产品资料!A:H,8,FALSE))","v":{"$error":"#N/A"}}]
[null,null,4,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D21=\"\",\"\",VLOOKUP(D21,产品资料!A:H,8,FALSE))","v":""}]
[null,null,5,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D22=\"\",\"\",VLOOKUP(D22,产品资料!A:H,8,FALSE))","v":""}]
[null,null,6,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D23=\"\",\"\",VLOOKUP(D23,产品资料!A:H,8,FALSE))","v":""}]
[null,null,7,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D24=\"\",\"\",VLOOKUP(D24,产品资料!A:H,8,FALSE))","v":""}]
[null,null,8,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D25=\"\",\"\",VLOOKUP(D25,产品资料!A:H,8,FALSE))","v":""}]
[null,null,9,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D26=\"\",\"\",VLOOKUP(D26,产品资料!A:H,8,FALSE))","v":""}]
[null,null,10,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,2,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,3,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,4,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,7,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,5,FALSE))","v":""},null,0,null,null,{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D27=\"\",\"\",VLOOKUP(D27,产品资料!A:H,8,FALSE))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,产品资料!A:H,6,FALSE))","v":""},{"$f":"IF(D28=\"\",\"\",VLOOKUP(D28,产品资料!A:H,8,FALSE))","v":""}]

{"sheet":"报价单查询","index":3,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[[1,1,1,2],[1,3,1,10],[1,13,1,15],[2,3,2,10],[3,4,3,5],[3,6,3,7],[3,8,3,9],[3,13,3,15],[4,3,4,10],[4,13,4,15],[5,4,5,9],[6,4,6,9],[7,4,7,5],[7,6,7,7],[7,8,7,9],[8,3,8,10],[9,4,9,5],[9,7,9,9],[10,4,10,5],[10,7,10,9],[12,8,12,9],[12,2,13,3]]}
[]
[null,"LOGO",null,"XXX进出口有限公司报价单"]
[]
[null,null,null,"报价单编码：",{"$f":"IF(ISNA(VLOOKUP(N5,报价单记录!A:A,1,FALSE)),\"无此报价单信息\",VLOOKUP(N5,报价单记录!A:A,1,FALSE))","v":"xxxx-001"},null,"报价日期：",null,{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,2,FALSE))","v":"2018-02-01"},null,null,null,null,"待查询报价单编码："]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"xxxx-001"]
[null,null,null,"询价公司：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,3,FALSE))","v":"公司-201"}]
[null,null,null,"地址：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,4,FALSE))","v":"地址-301"}]
[null,null,null,"联系人：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,5,FALSE))","v":"赵xx"},null,"联系电话/传真：",null,{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,6,FALSE))","v":"xxx-xxx-xxx"}]
[]
[null,null,null,"询价时间：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,7,FALSE))","v":"2018-01-20"},null,"交货方式：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,8,FALSE))","v":"当面交易"}]
[null,null,null,"运输方式：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,9,FALSE))","v":"海运"},null,"报价备注：",{"$f":"IF(E4=\"无此报价单信息\",\"\",VLOOKUP(E4,报价单记录!A:J,10,FALSE))","v":0}]
[]
[null,null,"报价单明细：",null,null,null,null,"订单合计：",{"$f":"SUM(K16:K25)","v":19980}]
[]
[null,null,"序号","产品编号","产品名称","规格","型号","货币","单价","数量","总价"]
[null,null,1,{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),12))","v":"产品编号--1"},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),13))","v":"A产品"},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),14))","v":"50*50"},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),15))","v":"型号-001"},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),16))","v":"美元"},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),17))","v":9.99},{"$f":"IF(E4=\"无此报价单信息\",\"\",INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0),18))","v":2000},{"$f":"IF(J16=\"\",0,I16*J16)","v":19980}]
[null,null,2,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=2,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+1,18),\"\"))","v":""},{"$f":"IF(J17=\"\",0,I17*J17)","v":0}]
[null,null,3,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=3,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+2,18),\"\"))","v":""},0]
[null,null,4,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=4,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+3,18),\"\"))","v":""},0]
[null,null,5,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=5,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+4,18),\"\"))","v":""},0]
[null,null,6,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=6,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+5,18),\"\"))","v":""},0]
[null,null,7,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=7,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+6,18),\"\"))","v":""},0]
[null,null,8,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=8,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+7,18),\"\"))","v":""},0]
[null,null,9,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=9,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+8,18),\"\"))","v":""},0]
[null,null,10,{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,12),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,13),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,14),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,15),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,16),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,17),\"\"))","v":""},{"$f":"IF(E4=\"无此报价单信息\",\"\",IF(COUNTIF(报价单记录!$A:$A,报价单查询!$E$4)>=10,INDEX(报价单记录!$A:$R,MATCH($E$4,报价单记录!$A:$A,0)+9,18),\"\"))","v":""},0]

{"sheet":"报价单记录","index":4,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["报价单编码","报价日期","询价公司","地址","联系人","联系电话","询价时间","交货方式","运输方式","报价备注","产品批次","产品编号","产品名称","规格","型号","货币","单价","数量"]
["xxxx-001","2018-02-01","公司-201","地址-301","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,1,"产品编号--1","A产品","50*50","型号-001","美元",9.99,2000]
["xxxx-002","2018-02-01","公司-202","地址-302","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,2,"产品编号--2","B产品","40*50","型号-002","美元",199.99,200]
["xxxx-003","2018-02-01","公司-203","地址-303","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,3,"产品编号--3","C产品","10*40","型号-003","美元",19.99,10]
["xxxx-004","2018-02-01","公司-204","地址-304","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,4,"产品编号--4","B产品","40*50","型号-004","美元",199.99,200]
["xxxx-005","2018-02-01","公司-205","地址-305","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,5,"产品编号--5","C产品","10*40","型号-005","美元",19.99,10]
["xxxx-006","2018-02-01","公司-206","地址-306","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,6,"产品编号--6","B产品","40*50","型号-006","美元",199.99,200]
["xxxx-007","2018-02-01","公司-207","地址-307","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,7,"产品编号--7","C产品","10*40","型号-007","美元",19.99,10]
["xxxx-008","2018-02-01","公司-208","地址-308","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,8,"产品编号--8","B产品","40*50","型号-008","美元",199.99,200]
["xxxx-009","2018-02-01","公司-209","地址-309","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,9,"产品编号--9","C产品","10*40","型号-009","美元",19.99,10]
["xxxx-010","2018-02-01","公司-210","地址-310","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,10,"产品编号--10","C产品","10*40","型号-010","美元",19.99,10]
["xxxx-011","2018-02-01","公司-211","地址-311","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,1,"产品编号--11","A产品","50*50","型号-011","美元",9.99,2000]
["xxxx-012","2018-02-01","公司-212","地址-312","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,2,"产品编号--12","B产品","40*50","型号-012","美元",199.99,200]
["xxxx-013","2018-02-01","公司-213","地址-313","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,3,"产品编号--13","C产品","10*40","型号-013","美元",19.99,10]
["xxxx-014","2018-02-01","公司-214","地址-314","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,1,"产品编号--14","A产品","50*50","型号-014","美元",9.99,2000]
["xxxx-015","2018-02-01","公司-215","地址-315","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,2,"产品编号--15","B产品","40*50","型号-015","美元",199.99,200]
["xxxx-016","2018-02-01","公司-216","地址-316","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,3,"产品编号--16","C产品","10*40","型号-016","美元",19.99,10]
["xxxx-017","2018-02-01","公司-217","地址-317","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,1,"产品编号--17","A产品","50*50","型号-017","美元",9.99,2000]
["xxxx-018","2018-02-01","公司-218","地址-318","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,2,"产品编号--18","B产品","40*50","型号-018","美元",199.99,200]
["xxxx-019","2018-02-01","公司-219","地址-319","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,3,"产品编号--19","C产品","10*40","型号-019","美元",19.99,10]
["xxxx-020","2018-02-01","公司-220","地址-320","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,1,"产品编号--20","A产品","50*50","型号-020","美元",9.99,2000]
["xxxx-021","2018-02-01","公司-221","地址-321","赵xx","xxx-xxx-xxx","2018-01-20","当面交易","海运",null,2,"产品编号--21","B产品","40*50","型号-021","美元",199.99,200]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,1,"ASD001",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2000]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,2,"ASD002",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},200]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,3,"ASD003",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},10]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,1,"ASD001",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2000]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,2,"ASD002",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},200]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,3,"ASD003",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},10]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,1,"ASD001",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2000]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,2,"ASD002",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},200]
["编码-001","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,3,"ASD003",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},10]
["95590t5950t90594 ","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,1,"ASD001",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},2000]
["95590t5950t90594 ","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,2,"ASD002",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},200]
["95590t5950t90594 ","2020-05-15",null,"地址-xxx","赵xx","xxx-xxx-xxx",null,null,null,null,3,"ASD003",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},10]

{"sheet":"客户资料","index":5,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["客户代码","客户名称","地址","联系人","联系电话/传真","客户等级","我方联络人","备注"]
["A01","张xx","地址-xxx","赵xx","xxx-xxx-xxx","A","钱xx","公司正常"]
["A02","张xx","地址-xxx","赵xx","xxx-xxx-xxx","B","钱xx","公司正常"]
["A03","张xx","地址-xxx","赵xx","xxx-xxx-xxx","C","钱xx","公司正常"]
["A04","张xx","地址-xxx","赵xx","xxx-xxx-xxx","D","钱xx","公司正常"]
["A05","张xx","地址-xxx","赵xx","xxx-xxx-xxx","E","钱xx","公司正常"]

{"sheet":"产品资料","index":6,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["商品代码","商品名称","规格","尺寸","单价","成本","计价货币","备注"]
["xxx-501","A产品","50*50","xxx",9.99,7.99,"美元","无备注"]
["xxx-502","B产品","40*50","xxx",199.99,197.99,"美元","无备注"]
["xxx-503","C产品","10*40","xxx",19.99,17.99,"美元","无备注"]