{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["报价单"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"报价单","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,0,4],[0,5,0,6],[1,1,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,2],[28,1,28,6]]}
[null,"你的公司名称",{"$nulls":3},"报价单"]
[null,"公司标语",{"$nulls":3},"日期",{"$f":"TODAY()","v":"2022-06-24"}]
[null,"街道地址",{"$nulls":3},"报价单编号",100]
[null,"邮政编码 省/市/自治区，市/县",{"$nulls":3},"客户 ID","ABC123"]
[null,"电话号码：在此处输入电话号码   传真：在此处输入传真号码"]
[null,"报价单",{"$nulls":3},"报价单有效期至：",{"$f":"TODAY() + 10","v":"2022-07-04"}]
[null,"姓名",{"$nulls":3},"供货方：","姓名"]
[null,"公司名称"]
[null,"街道地址"]
[null,"邮政编码 省/市/自治区，市/县"]
[null,"电话"]
[null,"批注或特殊说明：",null,"无"]
[null,"销售人员","订单编号","装运日期","装运方式","船上交货价","条款"]
[{"$nulls":6},"见票付款"]
[]
[null,"数量","说明"," ","单价","是否应纳税？","金额"]
[null,34,"项目 1",null,{"v":44,"d":"¥44.00"},"二",{"$f":"IFERROR(IF(B17,B17*E17,\"\"), \"\")","v":{"v":1496,"d":"¥1,496.00"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(B18,B18*E18,\"\"), \"\")","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":5},"小计",{"$f":"SUBTOTAL(109,报价单[金额])","v":{"v":1496,"d":"¥1,496.00"}}]
[{"$nulls":5},"税率",{"v":0.086,"d":"8.60%"}]
[{"$nulls":5},"销售税",{"$f":"IFERROR(G23*SUMIF(F17:F21,\"二\",G17:G21), \"\")","v":{"v":128.65599999999998,"d":"¥128.66"}}]
[{"$nulls":5},"其他",0]
[{"$nulls":5},"汇总",{"$f":"IFERROR(报价单[[#Totals],[金额]]+G24+G25, \"\")","v":{"v":1624.656,"d":"¥1,624.66"}}]
[null,"如对此报价单有疑问，请联系“姓名”、“电话号码”、“电子邮件”。"]
[]
[null,"谢谢惠顾！"]