{"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,"Contoso, Ltd",{"$nulls":4},"雅洲信託"]
[null,"7554 桃園縣",{"$nulls":4},"12209 台北市"]
[null,"富國路42號",{"$nulls":4},"忠孝東路四段32號"]
[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},"離岸價格/國貿條規",null,null,"描述"]
[null,"無",{"$nulls":3},"運費預付",null,null,{"$f":"IFERROR(INDEX(tblFOBTerms[],MATCH(F15,tblFOBTerms[離岸價格/國貿條規],0),2),\"\")","v":"目的地"}]
{"$rows_empty":7}
[null,"數量",null,"描述",{"$nulls":6},"單價",null,"金額"]
[null,1,null,"成令紙張",{"$nulls":6},{"v":150,"d":"NT$150.00"},null,{"$f":"IF(AND(K24<>\"\",B24<>\"\"),B24*K24,\"\")","v":{"v":150,"d":"NT$150.00"}}]
[null,5,null,"桌子，地面固定式",{"$nulls":6},{"v":2750,"d":"NT$2,750.00"},null,{"v":13750,"d":"NT$13,750.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":13900,"d":"NT$13,900.00"}}]
[{"$nulls":10},"稅率",null,{"v":0.075,"d":"NT$0.08"}]
[{"$nulls":10},"稅",null,{"$f":"TaxRate*Subtotal","v":{"v":1042.5,"d":"NT$1,042.50"}}]
[{"$nulls":10},"其他",null,{"v":0,"d":"NT$0.00"}]
[{"$nulls":10},"總計",null,{"$f":"SUM(Other,TotalTax,Subtotal)","v":{"v":14942.5,"d":"NT$14,942.50"}}]
[]
[]
[]
[]
[]
[]
[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 所提出的條款"]
[]
[]
["離岸價格/國貿條規","意義",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},"離岸價格/國貿條規不得空白","關"]
[{"$nulls":5},"包裹數目不得空白","開"]