{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["商業發票","客戶"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"商業發票","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"拖旋玩具",null,null,"123 Main Street","電話：123-555-0123","tailspin@interestingsite.com",null,null,"客戶"]
[{"$nulls":4},"Ocean View, MO 12345","傳真：123-555-0124","www.tailspintoys.com"]
[]
[null,"付款人：","Lilli Allik","電話:",{"$f":"IFERROR(VLOOKUP(帳單名稱,客戶清單[],8,FALSE),\"\")","v":"432-555-0178"},null,"發票號碼：",34567]
[null,"地址：",{"$f":"IFERROR(VLOOKUP(帳單名稱,客戶清單[],3,FALSE),\"\")","v":"345 Cherry Street"},"傳真：",{"$f":"IFERROR(VLOOKUP(帳單名稱,客戶清單[],10,FALSE),\"\")","v":"432-555-0187"},null,"發票日期：",{"$f":"TODAY()","v":"2022-12-12"}]
[null,null,{"$f":"IF(VLOOKUP(帳單名稱,客戶清單[],4,FALSE)<>\"\",VLOOKUP(帳單名稱,客戶清單[],4,FALSE),IF(VLOOKUP(帳單名稱,客戶清單[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(帳單名稱,客戶清單[],5,FALSE),\", \",VLOOKUP(帳單名稱,客戶清單[],6,FALSE),\" \",VLOOKUP(帳單名稱,客戶清單[],7,FALSE)),CONCATENATE(VLOOKUP(帳單名稱,客戶清單[],6,FALSE),\" \",VLOOKUP(帳單名稱,客戶清單[],7,FALSE))))","v":"Suite 123"},"電子郵件：",{"$f":"IFERROR(VLOOKUP(帳單名稱,客戶清單[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"連絡資訊：",{"$f":"IFERROR(VLOOKUP(帳單名稱,客戶清單[],2,FALSE),\"\")","v":"Mike Gragg"}]
[null,null,{"$f":"IF(VLOOKUP(帳單名稱,客戶清單[],4,FALSE)=\"\",\"\",IF(VLOOKUP(帳單名稱,客戶清單[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(帳單名稱,客戶清單[],5,FALSE),\", \",VLOOKUP(帳單名稱,客戶清單[],6,FALSE),\" \",VLOOKUP(帳單名稱,客戶清單[],7,FALSE)),CONCATENATE(VLOOKUP(帳單名稱,客戶清單[],6,FALSE),\" \",VLOOKUP(帳單名稱,客戶清單[],7,FALSE))))","v":"Albany, SD 12345"}]
[null,"日期","項目編號","描述","數量","單價","折扣","合計"]
[null,{"$f":"TODAY()","v":"2022-12-12"},789807,"木塊",4,{"v":10,"d":"NT$10.00"},{"v":2,"d":"NT$2.00"},{"$f":"IF(AND(發票項目[[#This Row],[數量]]<>\"\",發票項目[[#This Row],[單價]]<>\"\"),(發票項目[[#This Row],[數量]]*發票項目[[#This Row],[單價]])-發票項目[[#This Row],[折扣]],\"\")","v":{"v":38,"d":"NT$38.00"}}]
[{"$nulls":7},{"$f":"IF(AND(發票項目[[#This Row],[數量]]<>\"\",發票項目[[#This Row],[單價]]<>\"\"),(發票項目[[#This Row],[數量]]*發票項目[[#This Row],[單價]])-發票項目[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(發票項目[[#This Row],[數量]]<>\"\",發票項目[[#This Row],[單價]]<>\"\"),(發票項目[[#This Row],[數量]]*發票項目[[#This Row],[單價]])-發票項目[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(發票項目[[#This Row],[數量]]<>\"\",發票項目[[#This Row],[單價]]<>\"\"),(發票項目[[#This Row],[數量]]*發票項目[[#This Row],[單價]])-發票項目[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(發票項目[[#This Row],[數量]]<>\"\",發票項目[[#This Row],[單價]]<>\"\"),(發票項目[[#This Row],[數量]]*發票項目[[#This Row],[單價]])-發票項目[[#This Row],[折扣]],\"\")","v":""}]
[{"$nulls":6},"發票小計",{"$f":"SUM(發票項目[合計])","v":{"v":38,"d":"NT$38.00"}}]
[{"$nulls":6},"稅率",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"營業稅",{"$f":"發票小計*營業稅率","v":{"v":3.3819999999999997,"d":"NT$3.38"}}]
[{"$nulls":6},"運費",{"v":5,"d":"NT$5.00"}]
[null,{"$f":"\"支票抬頭請一律填寫\"&UPPER(公司名稱)&\".\"","v":"支票抬頭請一律填寫拖旋玩具."},{"$nulls":4},"實收訂金",{"v":0,"d":"NT$0.00"}]
[null,"總計應付帳款將在 10 天後到期。逾期款項將收取每個月 2% 的利息費用。",{"$nulls":4},"總計",{"$f":"發票小計+營業稅+運費-訂金","v":{"v":46.382,"d":"NT$46.38"}}]

{"sheet":"客戶","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"客戶",{"$nulls":10},"商業發票"]
[null,"公司名稱","連絡資訊","地址","地址2","縣/市","州/省","郵遞區號","電話","電子郵件","傳真"]
[null,"Lilli Allik","Mike Gragg","345 Cherry Street","Suite 123","Albany","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Janine Mendoza","567 Walnut Lane",null,"Moline","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]