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

{"sheet":"报价单","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"merged":[[1,1,1,5],[2,1,2,5],[3,1,3,5],[14,1,14,5]]}
[]
[null,"报价单"]
[null,"Noa Vidal 设计",{"$nulls":4},"   "]
[null,"像您一样独一无二的珠宝"]
[null,"公司地址",null,null,"日期",{"$f":"TODAY()","v":"2023-04-02"}]
[null,"华盛顿州西雅图主街 123 号，邮编 12345",null,null,"报价单编号",1234]
[null,"电话号码：(123) 456-7890   传真：(123) 456-7891",null,null,"客户 ID","ABC123"]
[null,"报价对象"]
[null,"Chetana Hegde",null,null,"报价单有效期至",{"$f":"F5+30","v":"2023-05-02"}]
[null,"14K 珠宝",null,null,"准备人","Sam"]
[null,"纽约州奥尔巴尼市西克莫街 321 号，邮编 54321"]
[null,"(000) 123-4567"]
[null,"备注或特殊说明"]
[]
[null,"无"]
[]
[null,"销售人员","订单编号","装运日期","离岸价格地点","条款"]
[null,"Sam",1000985,"2023-01-10","装运码头","见票付款"]
[]
[null,"数量","说明","单价","是否应纳税？","金额"]
[null,{"v":120,"d":"120 "},"金链",{"v":33.3,"d":"¥33.30"},"是",{"$f":"IFERROR(IF(OR(SaleItems_Table[[#This Row],[数量]]=\"\",SaleItems_Table[[#This Row],[单价]]=\"\"),\"\",SaleItems_Table[[#This Row],[数量]]*SaleItems_Table[[#This Row],[单价]]),\"\")","v":{"v":3995.9999999999995,"d":"¥3,996.00"}}]
[{"$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":3995.9999999999995,"d":"¥3,996.00"}}]
[null,"如对此报价单有疑问，请联系： ",null,null,"税率",{"v":0.086,"d":"8.60%"}]
[null,"Sam，电话: (123) 456-7890。",null,null,"销售税",{"$f":"IFERROR(Tax_Rate*SUMIF(SaleItems_Table[是否应纳税？],\"是\",SaleItems_Table[金额]), \"\")","v":{"v":343.65599999999995,"d":"¥343.66"}}]
[{"$nulls":4},"其他"]
[null,"谢谢惠顾！",null,null,"汇总",{"$f":"SUM(F27:F30)","v":{"v":4339.741999999999,"d":"¥4,339.74"}}]