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

{"sheet":"报价单","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[10,1,10,5]]}
[]
[null,"公司地址",null,null,"日期",{"$f":"TODAY()","v":"2019-03-27"}]
[null,"市/自治区，市/县，街道地址，邮政编码",null,null,"报价单编号",1234]
[null,"电话：在此处输入电话号码   传真：在此处输入传真号码",null,null,"客户 ID","ABC123"]
[null,"报价单"]
[null,"客户姓名",null,null,"报价单有效期至：",{"$f":"F2+30","v":"2019-04-26"}]
[null,"公司名称",null,null,"供货方：","姓名"]
[null,"省/市/自治区，市/县，街道地址，邮政编码"]
[null,"电话/传真号码"]
[null,"备注或特殊说明"]
[null,"无"]
[null,"销售人员","订单编号","装运日期","离岸价分","条款"]
[{"$nulls":5},"见票付款"]
[]
[null,"数量","描述","单价","应纳税？","金额"]
[null,{"v":1234,"d":"1,234"},"物品 1",{"v":12.34,"d":"¥12.34"},"是",{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":{"v":15227.56,"d":"¥15,227.56"}}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":""}]
[{"$nulls":5},{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":""}]
[]
[{"$nulls":4},"小计",{"$f":"SUM(SaleItems_Table[金额])","v":{"v":15227.56,"d":"¥15,227.56"}}]
[null,"如对此报价单有疑问，请联系： ",null,null,"税率",{"v":0.086,"d":"8.60%"}]
[null,"输入联系人的详细信息",null,null,"销售税",{"$f":"IFERROR(Tax_Rate*SUMIF(SaleItems_Table[应纳税？],\"是\",SaleItems_Table[金额]), \"\")","v":{"v":1309.5701599999998,"d":"¥1,309.57"}}]
[{"$nulls":4},"其他"]
[null,"谢谢惠顾！",null,null,"汇总",{"$f":"SUM(F22,F24,F25)","v":{"v":16537.13016,"d":"¥16,537.13"}}]