{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["发票","设置"],"not_rendered":{"images":1,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"发票","index":0,"n_rows":50,"n_cols":13,"rows_kept":50,"merged":[[6,1,6,3],[6,6,6,8],[7,1,7,3],[7,6,7,8],[11,1,11,3],[11,5,11,6],[14,1,14,3],[14,5,14,6],[14,8,14,12],[23,3,23,8],[24,3,24,8],[25,3,25,8],[26,3,26,8],[27,3,27,8],[28,3,28,8],[29,3,29,8],[30,3,30,8],[31,3,31,8],[32,3,32,8],[33,3,33,8],[34,3,34,8],[35,3,35,8],[48,1,48,12],[49,1,49,12]]}
[]
[]
[null,"卖方",{"$nulls":4},"买方"]
[null,"康浦有限公司",{"$nulls":4},"图形设计学院"]
[null,"河北省承德市第一大街 567 号",{"$nulls":4},"江苏省盐城市第一大街 2345 号"]
[null,"邮政编码 12345",{"$nulls":4},"邮政编码 12345"]
[null,8885550104,{"$nulls":4},5095550192]
[null,8885550105,{"$nulls":4},5095550193]
[]
[]
[null,"销售人",{"$nulls":3},"订单号",null,null,"日期",null,"包装",null,"承运人"]
[null,"郭爱明",{"$nulls":3},123,null,null,"2012-01-01",null,1,null,"USPS"]
[]
[null,"付款条款",{"$nulls":3},"FOB/国际贸易术语",null,null,"说明"]
[null,"无",{"$nulls":3},"运费预付",null,null,{"$f":"IFERROR(INDEX(tblFOBTerms[],MATCH(F15,tblFOBTerms[FOB/国际贸易术语],0),2),\"\")","v":"目的地"}]
{"$rows_empty":7}
[null,"数量",null,"说明",{"$nulls":6},"单价",null,"金额"]
[null,1,null,"纸令",{"$nulls":6},{"v":15,"d":"¥15.00"},null,{"$f":"IF(AND(K24<>\"\",B24<>\"\"),B24*K24,\"\")","v":{"v":15,"d":"¥15.00"}}]
[null,5,null,"挂台式，落地式",{"$nulls":6},{"v":275,"d":"¥275.00"},null,{"v":1375,"d":"¥1,375.00"}]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":12},""]
[{"$nulls":10},"小计",null,{"$f":"SUM(M24:M36)","v":{"v":1390,"d":"¥1,390.00"}}]
[{"$nulls":10},"税率",null,{"v":0.075,"d":"8%"}]
[{"$nulls":10},"税款",null,{"$f":"TaxRate*Subtotal","v":{"v":104.25,"d":"¥104.25"}}]
[{"$nulls":10},"其他",null,{"v":0,"d":"¥0.00"}]
[{"$nulls":10},"总计",null,{"$f":"SUM(Other,TotalTax,Subtotal)","v":{"v":1494.25,"d":"¥1,494.25"}}]
[]
[]
[]
[]
[]
[]
[null,"合同条款"]
[null,"请在此处列明特定的合同条款。"]
[null,"您也可使用此行。"]

{"sheet":"设置","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"merged":[[1,0,1,6]]}
[]
["本术语是依据 2011 年 1 月 1 日更新的第八版国际贸易术语 Incoterms 2010。"]
[]
[]
["FOB/国际贸易术语","含义",null,"承运人",null,"条件格式规则","开/关"]
["DAT","目的地或目的港的集散站交货 (1)",null,"USPS",null,"买方公司名不能为空","开"]
["DAP","目的地交货 (1)",null,"FedEx",null,"买方公司地址不能为空","开"]
["DDP","完税后交货 (1)",null,"UPS",null,"买方公司所在省市及邮编不能为空","开"]
["EXW","工厂交货 (1)",null,"其他",null,"买方公司电话不能为空","开"]
["装运点","装运点",{"$nulls":3},"买方公司传真不能为空","关"]
["运费到付","目的地",{"$nulls":3},"卖方公司名称不能为空","开"]
["运费预付","目的地",{"$nulls":3},"卖方公司地址不能为空","开"]
[{"$nulls":5},"卖方公司所在省市及邮编不能为空","开"]
[{"$nulls":5},"卖方公司电话不能为空","开"]
[{"$nulls":5},"卖方公司传真不能为空","关"]
[{"$nulls":5},"订单号不能为空","开"]
[{"$nulls":5},"销售人员不能为空","开"]
[{"$nulls":5},"承运人不能为空","关"]
[{"$nulls":5},"付款条款不能为空","关"]
[{"$nulls":5},"FOB/ 国际贸易术语不能为空","关"]
[{"$nulls":5},"包装编号（#)不能为空","开"]