{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["使用說明","Application","D4015","setting"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"使用說明","index":0,"n_rows":83,"n_cols":18,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14]]}
["日商瑞穗銀行 臺北分行 / 臺中分行 / 高雄分行"]
["Excel  D4015-Bill of Exchange 匯票 使用説明"]
[]
[null,"使用前注意事項以及設定步驟："]
[null,"     1. 初次使用時，必須啟用 Microsoft Excel 巨集功能。"]
[null,"     2. Microsoft Excel 2013 (含) 以後的設定步驟："]
[null,null,null,"開啟 \"檔案\" 選單"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"選擇 \"選項\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"進入 \"信任中心設定\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"\"啟用所有巨集\" 功能"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"D4015 Bill of Exchange 匯票 的填寫方式："]
[null,"     1. 下方 Sheet \"Application\" 為申請書內容的填寫區域。"]
[null,"     2. 按下「清除申請資料」按鈕可以清除前次填寫的申請書資料內容。"]
[null,"     3. 資料內容只需要填寫",null,null,null,null," 顏色部份即可。"]
[null,"     4. 填寫完畢後，填寫的資料會自動帶進 D4015 匯票表單中。"]
[null,"     5. 按下「預覽押匯申請書列印結果」以及「預覽匯票列印結果」按鈕後即可預覽成品內容。"]
[]
[]
[null,"注意事項："]
[null,"     1. 本 E-Form 申請書僅支援 Microsoft Office 2013 (含) 以後的版本。"]
[null,"     2. 本 E-Form 申請書有使用巨集功能，需要將巨集設定啟用之後才能使用完整功能。"]
[null,"         ※ MS Office 版本為 2003 請參考下方 Help2003 Sheet 內的巨集設定說明。"]
[null,"         ※ MS Office 版本為 2007 或更高，請參考下方 Help2007 Sheet 內的巨集設定說明。"]
[]
[null,null,"若有任何疑問請逕洽敝行負責    貴公司之營業/服務人員"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20200601,"版"]

{"sheet":"Application","index":1,"n_rows":33,"n_cols":24,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,2,31,4],[31,5,31,11],[30,5,30,11],[24,10,24,11],[25,10,25,11],[27,7,27,10],[26,11,26,13],[28,2,28,4],[28,5,28,11],[20,5,20,11],[19,5,19,11],[13,2,13,4],[19,2,19,4],[20,2,20,4],[16,2,16,4],[4,2,4,4],[4,5,4,11],[32,5,32,11],[2,1,2,18],[11,2,11,4],[9,2,9,4],[9,5,9,16],[10,2,10,4],[3,2,3,4],[3,5,3,11],[11,5,11,11],[29,2,29,4],[29,5,29,11],[16,5,16,11],[32,2,32,4],[13,5,13,11]]}
[]
[]
[null," 填 寫 匯 票 內 容"]
[null,1,"匯票編號 (Bill of Exchange NO.)",null,null,null,null,null,null,null,null,null,"請輸入匯票編號 (Bill of Exchange NO.) (如無，可不用填寫)"]
[null,2,"匯票日期",null,null,null,null,null,null,null,null,null,"請輸入申請日期，輸入格式為  YYYY/MM/DD (如無，可不用填寫)"]
[]
[]
[]
[]
[null,3,"匯票金額"]
[null,"3-1","幣別",null,null,null,null,null,null,null,null,null,"請選擇幣別代碼。例：USD, JPY, EUR"]
[null,"3-2","金額",null,null,null,null,null,null,null,null,null,"請輸入金額數字"]
[]
[null,4,"L/C ISSUING BANK 開狀行",null,null,null,null,null,null,null,null,null,"請輸入開狀銀行名稱 (最長可以輸入129個英文字長度)"]
[3]
[]
[null,5,"REIMBURSING BANK 求償行",null,null,null,null,null,null,null,null,null,"請輸入求償銀行名稱 (不明時免填)"]
[]
[]
[null,6,"L/C NO.信用狀號碼",null,null,null,null,null,null,null,null,null,"請輸入 L/C NO. 信用狀號碼"]
[null,7,"ISSUING DATE 開狀日",null,null,null,null,null,null,null,null,null,"請輸入日期，輸入格式為  YYYY/MM/DD"]
[]
[null,null,null,null,null,null,"1. AT","SIGHT",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$23,1,IF(T24,2,IF(T25,3,IF(T26,4,IF(T27,5,IF(T28,6,\"\"))))))","v":""},null,null,{"$f":"IF($T$23,1,0)","v":0}]
[null,8,"TENOR 付款期限",null,null,null,"2. AT",null,"DAYS AFTER SIGHT",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($U$23=1,$H$23,IF($U$23=2,$H$24,IF($U$23=3,$H$25,IF($U$23=4,$H$26,IF($U$23=5,$H$27,IF($U$23=6,$H$28,\"\"))))))","v":""},null,null,{"$f":"IF($T$24,1,0)","v":0}]
[null,null,null,null,null,null,"3. AT",null,"DAYS AFTER B/L DATE",null,{"$f":"IF($U$23=3,IF($F$33=\"\",\"\",$F$33),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF($U$23=2,$I$24,IF($U$23=3,$I$25,IF($U$23=4,$I$26,IF($U$23=5,$I$27,\"\"))))","v":""},null,null,{"$f":"IF($T$25,1,0)","v":0}]
[null,null,null,null,null,null,"4. AT",null,"DAYS FROM B/L DATE",null,{"$f":"IF($U$23=4,IF($F$33=\"\",\"\",$F$33),\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"\"AT  \"&$U$24&\"  \"&$U$25","v":"AT    "},null,null,{"$f":"IF($T$26,1,0)","v":0}]
[null,null,null,null,null,null,"5. AT",null,"DAYS  AFTER  SHIPMENT  DATE",null,null,{"$f":"IF($U$23=5,IF($F$33=\"\",\"\",$F$33),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF($U$23=3,$U$26&\"  \"&TEXT($K$25,\"[$-409]mmmm d, yyyy;@\"),IF($U$23=4,$U$26&\"  \"&TEXT($K$26,\"[$-409]mmmm d, yyyy;@\"),IF($U$23=5,$U$26&\"  \"&TEXT($L$27,\"[$-409]mmmm d, yyyy;@\"),$U$26)))","v":"AT    "},null,null,{"$f":"IF($T$27,1,0)","v":0}]
[null,null,null,null,null,null,"6. AT",null,null,null,null,"(自行輸入)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($T$28,1,0)","v":0}]
[null,9,null,null,null,null,null,null,null,null,null,null,"請輸入匯票付款人 (最長可以輸入60個英文字長度)",null,null,null,null,null,null,{"$f":"IF($X$29<=1,TRUE,FALSE)","v":true},null,null,null,{"$f":"SUM(X23:X28)","v":0}]
[null,null,"匯票Bill of Exchange付款人",null,null,null,null,null,null,null,null,null,"如需要輸入付款人詳細資料如地址等，"]
[null,null,null,null,null,null,null,null,null,null,null,null,"請在左邊分兩行輸入。"]
[null,10,"BENEFICIARY 申請人名稱",null,null,null,null,null,null,null,null,null,"請輸入申請人名稱 (最長可以輸入60個英文字長度)"]
[null,11,"DATE OF B/L 裝運日",null,null,null,null,null,null,null,null,null,"請輸入日期，輸入格式為  YYYY/MM/DD"]

{"sheet":"D4015","index":2,"n_rows":51,"n_cols":24,"rows_kept":51,"cut":false,"hidden":false,"merged":[[13,22,13,26],[26,8,26,13],[7,7,7,8],[13,13,13,19],[17,18,19,26],[17,8,18,16],[19,8,20,16],[7,9,7,22],[15,7,15,8],[15,9,15,26],[5,7,5,16],[30,7,30,16],[21,8,21,16],[17,7,18,7],[0,0,22,0],[0,1,22,1],[0,2,22,2],[0,3,22,3],[0,5,22,5],[1,8,1,13],[9,7,11,26],[3,9,3,10],[3,12,3,20],[3,23,3,26],[25,0,47,0],[25,1,47,1],[25,2,47,2],[25,3,47,3],[25,5,47,5],[34,7,36,26],[38,13,38,19],[38,22,38,26],[28,9,28,10],[28,12,28,20],[28,23,28,26],[32,7,32,8],[32,9,32,22],[40,7,40,8],[40,9,40,26],[50,4,50,27],[49,12,49,13],[42,18,44,26],[42,8,43,16],[44,8,45,16],[46,8,46,16],[42,7,43,7],[49,6,49,8]]}
["Pay to The Order of","ANY BANK or BANKER","Value or Collection","MIZUHO BANK, LTD",null,"AUTHORIZED SIGNATURE"]
[null,null,null,null,null,null,null,"NO.",{"$f":"IF(Application!$F$4=\"\",\"\",Application!$F$4)","v":""},null,null,null,null,null,null,null,null,"BILL OF EXCHANGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAIWAN"]
[null,null,null,null,null,null,null,"AMOUNT:",null,{"$f":"IF(Application!$F$11=\"\",\"\",Application!$F$11)","v":""},null,null,{"$f":"IF(Application!$F$12=\"\",\"\",Application!$F$12)","v":""},null,null,null,null,null,null,null,null,null,"DATE",{"$f":"IF(Application!$F$5=\"\",\"\",Application!$F$5)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(Application!$U$27=\"\",\"\",Application!$U$27)","v":"AT    "},null,null,null,null,null,null,null,null,null," OF THIS FIRST BILL OF EXCHANGE (SECOND BEING UNPAID)"]
[]
[null,null,null,null,null,null,null,"PAY TO",null,"MIZUHO BANK, LTD.",null,null,null,null,null,null,null,null,null,null,null,null,null,"OR ORDER"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(M4=\"\",\"\",IF(M4=0,\"\",\"The Sum of \"&VLOOKUP(J4,setting!$A$1:$B$13,2,FALSE)&SpellNumber(M4)&\" Value Received\"))","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,"DRAWN UNDER L/C NO.",null,null,null,null,null,{"$f":"IF(Application!$F$20=\"\",\"\",Application!$F$20)","v":""},null,null,null,null,null,null,null,"DATED",{"$f":"IF(Application!$F$21=\"\",\"\",Application!$F$21)","v":""}]
[]
[null,null,null,null,null,null,null,"ISSUED BY",null,{"$f":"IF(Application!$F$14=\"\",\"\",Application!$F$14)","v":""}]
[]
[null,null,null,null,null,null,null,"TO",{"$f":"IF(Application!$F$29=\"\",\"\",LEFT(Application!$F$29,60))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(Application!$F$32=\"\",\"\",LEFT(Application!$F$32,60))","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Application!$F$30=\"\",\"\",Application!$F$30)","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(Application!$F$31=\"\",\"\",Application!$F$31)","v":""}]
[]
[]
[]
["Pay to The Order of","ANY BANK or BANKER","Value or Collection","MIZUHO BANK, LTD",null,"AUTHORIZED SIGNATURE"]
[null,null,null,null,null,null,null,"NO.",{"$f":"IF(I2=0,\"\",I2)","v":""},null,null,null,null,null,null,null,null,"BILL OF EXCHANGE",null,null,null,null,null,{"$f":"IF(X2=0,\"\",X2)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAIWAN"]
[null,null,null,null,null,null,null,"AMOUNT:",null,{"$f":"IF(J4=0,\"\",J4)","v":""},null,null,{"$f":"M4","v":""},null,null,null,null,null,null,null,null,null,"DATE",{"$f":"IF(X4=0,\"\",X4)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H6=0,\"\",H6)","v":"AT    "},null,null,null,null,null,null,null,null,null," OF THIS SECOND BILL OF EXCHANGE (FIRST BEING UNPAID)"]
[]
[null,null,null,null,null,null,null,"PAY TO",null,"MIZUHO BANK, LTD.",null,null,null,null,null,null,null,null,null,null,null,null,null,"OR ORDER"]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H10=0,\"\",H10)","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,"DRAWN UNDER L/C NO.",null,null,null,null,null,{"$f":"IF(N14=0,\"\",N14)","v":""},null,null,null,null,null,null,null,"DATED",{"$f":"IF(W14=0,\"\",W14)","v":""}]
[]
[null,null,null,null,null,null,null,"ISSUED BY",null,{"$f":"IF(J16=0,\"\",J16)","v":""}]
[]
[null,null,null,null,null,null,null,"TO",{"$f":"IF(I18=0,\"\",I18)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(S18=0,\"\",S18)","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(H20=0,\"\",H20)","v":""},{"$f":"IF(I20=0,\"\",I20)","v":""}]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(I22=0,\"\",I22)","v":""}]
[]
[]
[null,null,"(D4015) Electronic Application",null,null,null,20200601]
[null,null,null,"Note: ","使用此申請書時，本人/本公司同意不更動除填記欄位以外之申請書內容及文字，若更動該申請書內容或文字而造成  貴行損失時願負一切責任。"]

{"sheet":"setting","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["USD","US Dollars",null,"USD"]
["JPY","Japanese Yen",null,"JPY"]
["EUR","Euro",null,"EUR"]
["TWD","New Taiwan Dollars",null,"SGD"]
["SGD","Singapore Dollars",null,"HKD"]
["HKD","Hong Kong Dollars",null,"CNY"]
["CNY","Renminbi",null,"CAD"]
["CAD","Canadian Dollars",null,"GBP"]
["GBP","Pounds Sterling",null,"CHF"]
["CHF","Swiss Francs",null,"AUD"]
["AUD","Australian Dollars",null,"NZD"]
["NZD","New Zealand Dollars",null,"INR"]
["INR","Indian Rupees"]