{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["使用說明","Application","Beneficiary","Account","Form","camera"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,14],[1,0,1,14],[29,12,29,13]]}
["日商瑞穗銀行 臺北分行 / 臺中分行 / 高雄分行"]
["Excel G7010-新臺幣匯款申請書 使用説明"]
[]
[null,"事前設定作業 :"]
[null,"     1. 請先在下方 Beneficiary Sheet 內填寫/建立 收款人資料。"]
[null,"     2. 總共可以建立 200 筆常用的收款人資料。"]
[null,"     3. 請先在下方 Account Sheet 內填寫/建立 常用扣款帳號資訊。"]
[null,"     4. 總共可以建立 20 筆常用的扣款帳號資訊。"]
[null,"     5. 收款人資料以及常用扣款帳號資訊填寫完成後請記得儲存。"]
[]
[null,"每次匯款時之匯出匯款申請書的填寫方式："]
[null,"     1. 下方 Application Sheet 為申請書內容的填寫區域。"]
[null,"     2. 按下「清除申請人資料」按鈕可以清除前次的匯款申請人資料。"]
[null,"     3. 按下「清除匯款資料」按鈕可以清除前次的匯款金額資料。"]
[null,"     4. 資料內容只需要填寫",null,null,null,null,null," 顏色部份即可。"]
[null,"     5. 收款人的部分，只需要填寫 Beneficiary Sheet (收款人資料) 內的 代號 即可。"]
[null,"     6. 扣款帳號的部分，只需要填寫 Account Sheet (扣款帳號資訊) 內的 代號 即可。"]
[null,"     7. 填寫完畢後，按下「預覽列印匯款申請書」按鈕後即可預覽成品內容。"]
[null,"     8. 請將列印出來的三頁申請書成品以傳真交或是直接正本交付給本行即可。"]
[]
[null,"注意事項："]
[null,"     1. 本 E-Form 申請書僅支援 Microsoft Office 2013 (含) 以後的版本。"]
[null,"     2. 本 E-Form 申請書有使用巨集功能，需要設定巨集安全性為 \"中\" 或是 \"低\" "]
[null,"        之後才能使用完整功能。"]
[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,20190902,null,"版"]

{"sheet":"Application","index":1,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[30,1,32,2],[17,1,17,2],[29,3,29,5],[19,1,24,2],[20,4,23,4],[27,3,27,5],[29,1,29,2],[25,1,25,2],[28,1,28,2],[10,4,12,4],[28,3,28,5],[15,1,15,6],[16,1,16,2],[16,3,16,5],[18,1,18,2],[25,3,25,5],[28,6,29,6],[26,3,26,5],[26,6,27,6],[26,1,26,2],[27,1,27,2],[18,3,18,5],[17,3,17,5],[9,1,13,2],[2,1,2,6],[4,1,4,2],[4,3,4,6],[5,1,5,2],[5,3,5,6],[3,1,3,2],[3,4,3,6],[8,3,8,6],[6,1,6,2],[6,3,6,6],[7,1,7,2],[8,1,8,2],[7,3,7,6]]}
[]
[]
[null,"匯款申請人資料"]
[null,"傳真指示扣帳 ( 否:0 / 是:1 )",null,null,"← 請填入 ( 0:否 或是 1:是 )  [僅限與本行簽訂電話傳真交易授權書者適用]"]
[null,"匯款人姓名"]
[null,"統一編號/身分證字號"]
[null,"連絡電話",null,null,null,null,null,null,null,null,null,null,null,"【小提醒】"]
[null,"代理人",null,null,null,null,null,null,null,null,null,null,null,"匯款金額超過 TWD30,000 時"]
[null,"代理人身分證字號",null,null,null,null,null,null,null,null,null,null,null,"請記得填寫代理人相關資訊欄位"]
[null,"受理分行 (Branch)",null,"請填入代號"]
[null,null,null,null,null,null,"1. 臺北分行 Taipei Branch",null,null,1,"96978630","臺北",{"$f":"VLOOKUP(E11,$J$11:$L$13,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"2. 臺中分行 Taichung Branch",null,null,2,"28425252","臺中",{"$f":"VLOOKUP(E11,$J$11:$L$13,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"3. 高雄分行 Kaohsiung Branch",null,null,3,"86893726","高雄"]
[]
[]
[null,"匯款資料"]
[null,"匯款日期 ( 西元 年月日)",null,null,null,null,"( 例：2012/06/20 )"]
[null,"收款人 (請輸入代號)",null,null,null,null,"( 例：M001 ) 請參考 Sheet \"Beneficiary\""]
[null,"匯款金額 (新臺幣NT$)",null,null,null,null,"(註：目前單筆匯款金額上限為新臺幣五仟萬元整)"]
[null,"匯款種類",null,"請填入代號",null,null,"1. 跨行"]
[null,null,null,null,null,null,"2. 公庫",null,null,null,{"$f":"IF(E21=5,TRUE,IF(D19>50000000,FALSE,TRUE))","v":true}]
[null,null,null,null,null,null,"3. 同業"]
[null,null,null,null,null,null,"4. 證券"]
[null,null,null,null,null,null,"5. 票券"]
[null,null,null,null,null,null,"6. 自行"]
[null,"此筆匯款 備註(附言)"]
[null,"本金扣款帳號 (請輸入代號)",null,null,null,null,"( 例：A01 ) 請參考 Sheet \"Account\""]
[null,"本金扣款帳號=>",null,{"$f":"IF(ISERROR(VLOOKUP($D$27,Account!$A$3:$C$22,2,FALSE)),\"尚未設定扣款帳號資訊\",IF(VLOOKUP($D$27,Account!$A$3:$C$22,2,FALSE)=0,\"尚未設定扣款帳號資訊\",VLOOKUP($D$27,Account!$A$3:$C$22,2,FALSE)))","v":"尚未設定扣款帳號資訊"}]
[null,"手續費 (新臺幣NT$)",null,null,null,null,"(非必填欄位，如不了解 手續費金額，請和本行服務人員聯絡，由本行服務人員協助填寫)"]
[null,"金資手續費 (新臺幣NT$)"]
[null,"手續費是否也由本金扣款帳號扣除？  (預設手續費由本金扣款帳號內扣除)",null,null,null,null,"1. 是"]
[null,null,null,null,null,null,"2. 否"]

{"sheet":"Beneficiary","index":2,"n_rows":202,"n_cols":10,"rows_kept":202,"cut":false,"hidden":false,"merged":[]}
[null,null,"收款人資料檔"]
["代號","收款人帳號","收款人戶名","收款銀行名稱 (解款行庫)","收款行分支單位(分行)","解款行代號","備註"]
["M001",null,null,null,null,null,null,null,null,{"$f":"LEN(B3)","v":0}]
["M002",null,null,null,null,null,null,null,null,{"$f":"LEN(B4)","v":0}]
["M003",null,null,null,null,null,null,null,null,0]
["M004",null,null,null,null,null,null,null,null,0]
["M005",null,null,null,null,null,null,null,null,0]
["M006",null,null,null,null,null,null,null,null,0]
["M007",null,null,null,null,null,null,null,null,0]
["M008",null,null,null,null,null,null,null,null,0]
["M009",null,null,null,null,null,null,null,null,0]
["M010",null,null,null,null,null,null,null,null,0]
["M011",null,null,null,null,null,null,null,null,0]
["M012",null,null,null,null,null,null,null,null,0]
["M013",null,null,null,null,null,null,null,null,0]
["M014",null,null,null,null,null,null,null,null,0]
["M015",null,null,null,null,null,null,null,null,0]
["M016",null,null,null,null,null,null,null,null,0]
["M017",null,null,null,null,null,null,null,null,0]
["M018",null,null,null,null,null,null,null,null,0]
["M019",null,null,null,null,null,null,null,null,0]
["M020",null,null,null,null,null,null,null,null,0]
["M021",null,null,null,null,null,null,null,null,0]
["M022",null,null,null,null,null,null,null,null,0]
["M023",null,null,null,null,null,null,null,null,0]
["M024",null,null,null,null,null,null,null,null,0]
["M025",null,null,null,null,null,null,null,null,0]
["M026",null,null,null,null,null,null,null,null,0]
["M027",null,null,null,null,null,null,null,null,0]
["M028",null,null,null,null,null,null,null,null,0]
["M029",null,null,null,null,null,null,null,null,0]
["M030",null,null,null,null,null,null,null,null,0]
["M031",null,null,null,null,null,null,null,null,0]
["M032",null,null,null,null,null,null,null,null,0]
["M033",null,null,null,null,null,null,null,null,0]
["M034",null,null,null,null,null,null,null,null,0]
["M035",null,null,null,null,null,null,null,null,0]
["M036",null,null,null,null,null,null,null,null,0]
["M037",null,null,null,null,null,null,null,null,0]
["M038",null,null,null,null,null,null,null,null,0]
["M039",null,null,null,null,null,null,null,null,0]
["M040",null,null,null,null,null,null,null,null,0]
["M041",null,null,null,null,null,null,null,null,0]
["M042",null,null,null,null,null,null,null,null,0]
["M043",null,null,null,null,null,null,null,null,0]
["M044",null,null,null,null,null,null,null,null,0]
["M045",null,null,null,null,null,null,null,null,0]
["M046",null,null,null,null,null,null,null,null,0]
["M047",null,null,null,null,null,null,null,null,0]
["M048",null,null,null,null,null,null,null,null,0]
["M049",null,null,null,null,null,null,null,null,0]
["M050",null,null,null,null,null,null,null,null,0]
["M051",null,null,null,null,null,null,null,null,0]
["M052",null,null,null,null,null,null,null,null,0]
["M053",null,null,null,null,null,null,null,null,0]
["M054",null,null,null,null,null,null,null,null,0]
["M055",null,null,null,null,null,null,null,null,0]
["M056",null,null,null,null,null,null,null,null,0]
["M057",null,null,null,null,null,null,null,null,0]
["M058",null,null,null,null,null,null,null,null,0]
["M059",null,null,null,null,null,null,null,null,0]
["M060",null,null,null,null,null,null,null,null,0]
["M061",null,null,null,null,null,null,null,null,0]
["M062",null,null,null,null,null,null,null,null,0]
["M063",null,null,null,null,null,null,null,null,0]
["M064",null,null,null,null,null,null,null,null,0]
["M065",null,null,null,null,null,null,null,null,0]
["M066",null,null,null,null,null,null,null,null,{"$f":"LEN(B68)","v":0}]
["M067",null,null,null,null,null,null,null,null,0]
["M068",null,null,null,null,null,null,null,null,0]
["M069",null,null,null,null,null,null,null,null,0]
["M070",null,null,null,null,null,null,null,null,0]
["M071",null,null,null,null,null,null,null,null,0]
["M072",null,null,null,null,null,null,null,null,0]
["M073",null,null,null,null,null,null,null,null,0]
["M074",null,null,null,null,null,null,null,null,0]
["M075",null,null,null,null,null,null,null,null,0]
["M076",null,null,null,null,null,null,null,null,0]
["M077",null,null,null,null,null,null,null,null,0]
["M078",null,null,null,null,null,null,null,null,0]
["M079",null,null,null,null,null,null,null,null,0]
["M080",null,null,null,null,null,null,null,null,0]
["M081",null,null,null,null,null,null,null,null,0]
["M082",null,null,null,null,null,null,null,null,0]
["M083",null,null,null,null,null,null,null,null,0]
["M084",null,null,null,null,null,null,null,null,0]
["M085",null,null,null,null,null,null,null,null,0]
["M086",null,null,null,null,null,null,null,null,0]
["M087",null,null,null,null,null,null,null,null,0]
["M088",null,null,null,null,null,null,null,null,0]
["M089",null,null,null,null,null,null,null,null,0]
["M090",null,null,null,null,null,null,null,null,0]
["M091",null,null,null,null,null,null,null,null,0]
["M092",null,null,null,null,null,null,null,null,0]
["M093",null,null,null,null,null,null,null,null,0]
["M094",null,null,null,null,null,null,null,null,0]
["M095",null,null,null,null,null,null,null,null,0]
["M096",null,null,null,null,null,null,null,null,0]
["M097",null,null,null,null,null,null,null,null,0]
["M098",null,null,null,null,null,null,null,null,0]
["M099",null,null,null,null,null,null,null,null,0]
["M100",null,null,null,null,null,null,null,null,0]
["M101",null,null,null,null,null,null,null,null,0]
["M102",null,null,null,null,null,null,null,null,0]
["M103",null,null,null,null,null,null,null,null,0]
["M104",null,null,null,null,null,null,null,null,0]
["M105",null,null,null,null,null,null,null,null,0]
["M106",null,null,null,null,null,null,null,null,0]
["M107",null,null,null,null,null,null,null,null,0]
["M108",null,null,null,null,null,null,null,null,0]
["M109",null,null,null,null,null,null,null,null,0]
["M110",null,null,null,null,null,null,null,null,0]
["M111",null,null,null,null,null,null,null,null,0]
["M112",null,null,null,null,null,null,null,null,0]
["M113",null,null,null,null,null,null,null,null,0]
["M114",null,null,null,null,null,null,null,null,0]
["M115",null,null,null,null,null,null,null,null,0]
["M116",null,null,null,null,null,null,null,null,0]
["M117",null,null,null,null,null,null,null,null,0]
["M118",null,null,null,null,null,null,null,null,0]
["M119",null,null,null,null,null,null,null,null,0]
["M120",null,null,null,null,null,null,null,null,0]
["M121",null,null,null,null,null,null,null,null,0]
["M122",null,null,null,null,null,null,null,null,0]
["M123",null,null,null,null,null,null,null,null,0]
["M124",null,null,null,null,null,null,null,null,0]
["M125",null,null,null,null,null,null,null,null,0]
["M126",null,null,null,null,null,null,null,null,0]
["M127",null,null,null,null,null,null,null,null,0]
["M128",null,null,null,null,null,null,null,null,0]
["M129",null,null,null,null,null,null,null,null,0]
["M130",null,null,null,null,null,null,null,null,{"$f":"LEN(B132)","v":0}]
["M131",null,null,null,null,null,null,null,null,0]
["M132",null,null,null,null,null,null,null,null,0]
["M133",null,null,null,null,null,null,null,null,0]
["M134",null,null,null,null,null,null,null,null,0]
["M135",null,null,null,null,null,null,null,null,0]
["M136",null,null,null,null,null,null,null,null,0]
["M137",null,null,null,null,null,null,null,null,0]
["M138",null,null,null,null,null,null,null,null,0]
["M139",null,null,null,null,null,null,null,null,0]
["M140",null,null,null,null,null,null,null,null,0]
["M141",null,null,null,null,null,null,null,null,0]
["M142",null,null,null,null,null,null,null,null,0]
["M143",null,null,null,null,null,null,null,null,0]
["M144",null,null,null,null,null,null,null,null,0]
["M145",null,null,null,null,null,null,null,null,0]
["M146",null,null,null,null,null,null,null,null,0]
["M147",null,null,null,null,null,null,null,null,0]
["M148",null,null,null,null,null,null,null,null,0]
["M149",null,null,null,null,null,null,null,null,0]
["M150",null,null,null,null,null,null,null,null,0]
["M151",null,null,null,null,null,null,null,null,0]
["M152",null,null,null,null,null,null,null,null,0]
["M153",null,null,null,null,null,null,null,null,0]
["M154",null,null,null,null,null,null,null,null,0]
["M155",null,null,null,null,null,null,null,null,0]
["M156",null,null,null,null,null,null,null,null,0]
["M157",null,null,null,null,null,null,null,null,0]
["M158",null,null,null,null,null,null,null,null,0]
["M159",null,null,null,null,null,null,null,null,0]
["M160",null,null,null,null,null,null,null,null,0]
["M161",null,null,null,null,null,null,null,null,0]
["M162",null,null,null,null,null,null,null,null,0]
["M163",null,null,null,null,null,null,null,null,0]
["M164",null,null,null,null,null,null,null,null,0]
["M165",null,null,null,null,null,null,null,null,0]
["M166",null,null,null,null,null,null,null,null,0]
["M167",null,null,null,null,null,null,null,null,0]
["M168",null,null,null,null,null,null,null,null,0]
["M169",null,null,null,null,null,null,null,null,0]
["M170",null,null,null,null,null,null,null,null,0]
["M171",null,null,null,null,null,null,null,null,0]
["M172",null,null,null,null,null,null,null,null,0]
["M173",null,null,null,null,null,null,null,null,0]
["M174",null,null,null,null,null,null,null,null,0]
["M175",null,null,null,null,null,null,null,null,0]
["M176",null,null,null,null,null,null,null,null,0]
["M177",null,null,null,null,null,null,null,null,0]
["M178",null,null,null,null,null,null,null,null,0]
["M179",null,null,null,null,null,null,null,null,0]
["M180",null,null,null,null,null,null,null,null,0]
["M181",null,null,null,null,null,null,null,null,0]
["M182",null,null,null,null,null,null,null,null,0]
["M183",null,null,null,null,null,null,null,null,0]
["M184",null,null,null,null,null,null,null,null,0]
["M185",null,null,null,null,null,null,null,null,0]
["M186",null,null,null,null,null,null,null,null,0]
["M187",null,null,null,null,null,null,null,null,0]
["M188",null,null,null,null,null,null,null,null,0]
["M189",null,null,null,null,null,null,null,null,0]
["M190",null,null,null,null,null,null,null,null,0]
["M191",null,null,null,null,null,null,null,null,0]
["M192",null,null,null,null,null,null,null,null,0]
["M193",null,null,null,null,null,null,null,null,0]
["M194",null,null,null,null,null,null,null,null,{"$f":"LEN(B196)","v":0}]
["M195",null,null,null,null,null,null,null,null,0]
["M196",null,null,null,null,null,null,null,null,0]
["M197",null,null,null,null,null,null,null,null,0]
["M198",null,null,null,null,null,null,null,null,0]
["M199",null,null,null,null,null,null,null,null,0]
["M200",null,null,null,null,null,null,null,null,0]

{"sheet":"Account","index":3,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,null,"帳號資料檔"]
["代號","帳號","備註"]
["A01"]
["A02"]
["A03"]
["A04"]
["A05"]
["A06"]
["A07"]
["A08"]
["A09"]
["A10"]
["A11"]
["A12"]
["A13"]
["A14"]
["A15"]
["A16"]
["A17"]
["A18"]
["A19"]
["A20"]

{"sheet":"Form","index":4,"n_rows":88,"n_cols":29,"rows_kept":88,"cut":false,"hidden":false,"merged":[[65,0,73,0],[70,1,71,6],[70,7,71,16],[68,2,69,2],[65,14,65,16],[65,17,65,18],[34,1,37,1],[34,2,35,2],[33,1,33,2],[33,3,33,6],[33,7,33,8],[33,9,33,11],[33,12,33,13],[33,14,33,16],[51,18,51,20],[39,17,39,18],[34,17,34,18],[51,5,51,7],[51,8,51,13],[51,15,51,17],[48,20,48,21],[38,1,39,6],[38,7,39,16],[73,12,73,16],[76,1,76,3],[76,4,77,16],[77,1,77,3],[66,3,67,16],[73,1,73,5],[73,6,73,11],[22,2,22,4],[19,4,19,5],[30,13,30,14],[31,5,31,17],[43,17,43,20],[36,17,37,18],[36,19,37,28],[71,19,71,28],[66,19,66,28],[67,19,67,28],[41,12,41,16],[48,15,48,16],[48,4,48,6],[43,4,43,5],[43,6,43,7],[45,2,45,4],[46,2,46,4],[43,11,43,12],[74,1,74,16],[75,3,75,13],[70,17,70,18],[71,17,71,18],[66,1,69,1],[66,2,67,2],[72,1,72,3],[72,4,72,11],[72,12,72,13],[68,17,69,18],[75,1,75,2],[86,27,86,28],[86,1,86,6],[86,7,86,8],[87,1,88,28],[78,4,78,17],[79,4,79,17],[80,4,80,17],[81,4,81,17],[83,4,83,17],[84,10,84,12],[78,1,78,2],[82,4,82,17],[84,4,84,9],[5,0,13,0],[42,1,42,28],[57,1,57,6],[57,7,57,8],[48,9,48,13],[48,17,48,19],[14,17,14,18],[14,19,14,24],[22,17,22,18],[5,19,5,28],[51,2,51,4],[26,1,27,28],[30,5,30,12],[38,19,38,28],[39,19,39,28],[40,12,40,13],[51,21,51,28],[57,27,57,28],[38,17,38,18],[33,0,41,0],[36,3,37,16],[16,1,16,3],[16,4,17,16],[17,1,17,3],[68,19,69,28],[66,17,66,18],[70,19,70,28],[58,1,59,28],[65,1,65,2],[65,3,65,6],[65,7,65,8],[68,3,69,16],[62,5,62,12],[62,13,62,14],[63,5,63,17],[67,17,67,18],[65,19,65,28],[63,19,63,21],[63,23,63,24],[65,9,65,11],[65,12,65,13],[25,1,25,6],[2,5,2,12],[2,13,2,14],[3,5,3,17],[5,7,5,8],[13,1,13,5],[19,2,19,3],[19,6,19,7],[25,7,25,8],[14,1,14,16],[10,7,11,16],[6,17,6,18],[5,12,5,13],[5,14,5,16],[5,17,5,18],[5,9,5,11],[21,2,21,4],[15,1,15,2],[12,1,12,3],[7,17,7,18],[6,1,9,1],[8,3,9,16],[19,13,19,16],[10,17,10,18],[19,11,19,12],[19,8,19,10],[11,19,11,28],[18,1,18,28],[10,1,11,6],[18,32,18,39],[6,3,7,16],[8,17,9,18],[8,19,9,28],[5,1,5,2],[8,2,9,2],[6,2,7,2],[5,3,5,6],[15,3,15,13],[13,12,13,16],[10,19,10,28],[12,4,12,11],[13,6,13,11],[11,17,11,18],[12,12,12,13],[1,17,1,18],[1,21,1,22],[1,24,1,25],[1,27,1,28],[2,17,2,18],[2,21,2,22],[2,24,2,25],[31,23,31,24],[31,26,31,27],[6,19,6,28],[7,19,7,28],[29,17,29,18],[29,21,29,22],[29,24,29,25],[29,27,29,28],[25,27,25,28],[2,27,2,28],[3,19,3,21],[3,23,3,24],[3,26,3,27],[19,24,19,28],[19,17,19,20],[30,17,30,18],[30,21,30,22],[30,24,30,25],[30,27,30,28],[31,19,31,21],[63,26,63,27],[34,19,34,28],[47,1,47,28],[48,2,48,3],[43,2,43,3],[48,22,48,28],[35,17,35,18],[48,7,48,8],[34,3,35,16],[36,2,37,2],[43,24,43,28],[35,19,35,28],[33,17,33,18],[33,19,33,28],[46,17,46,18],[41,1,41,5],[43,8,43,10],[40,1,40,3],[40,4,40,11],[41,6,41,11],[43,13,43,16]]}
[null,{"$f":"IF(Application!D4=1,\"☑\",\"☐\")","v":"☐"},"傳真指示扣帳 (請勾選。僅限與本行簽訂電話傳真交易授權書者適用)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"匯款",null,null,{"$f":"IF(Application!E21=1,\"☑\",\"☐\")","v":"☐"},"跨行",null,{"$f":"IF(Application!E21=2,\"☑\",\"☐\")","v":"☐"},"公庫",null,{"$f":"IF(Application!E21=3,\"☑\",\"☐\")","v":"☐"},"同業"]
[null,null,null,null,null," 日 商 瑞 穗 銀 行",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Application!M11),\"臺北\",Application!M11)","v":"臺北"},null,"分行",null,"種類",null,null,{"$f":"IF(Application!E21=4,\"☑\",\"☐\")","v":"☐"},"證券",null,{"$f":"IF(Application!E21=5,\"☑\",\"☐\")","v":"☐"},"票券",null,{"$f":"IF(Application!E21=6,\"☑\",\"☐\")","v":"☐"},"自行"]
[null,null,null,null,null,"  Mizuho Bank, Ltd.       匯 款 申 請 書  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Application!D17=\"\",\"\",YEAR(Application!D17))","v":""},null,null,"年",{"$f":"IF(Application!D17=\"\",\"\",MONTH(Application!D17))","v":""},null,"月",{"$f":"IF(Application!D17=\"\",\"\",DAY(Application!D17))","v":""},null,"日"]
[]
["第\n一\n聯\n\n預\n金\n課\n存\n查\n聯","解款行庫\n(收款行)",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE))","v":{"$error":"#N/A"}},null,null,null,"分支\n單位",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE))","v":{"$error":"#N/A"}},null,null,"解款行\n代　號",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE))","v":{"$error":"#N/A"}},null,null,"手續費",null,{"$f":"IF(Application!D29=\"\",\"\",Application!D29)","v":""}]
[null,"收\n款\n人","帳號",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"代理人",null,{"$f":"IF(Application!D8=\"\",\"\",Application!D8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"身分證字號",null,{"$f":"IF(Application!D9=\"\",\"\",Application!D9)","v":""}]
[null,null,"戶名",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"備註(附言)",null,{"$f":"IF(Application!D26=\"\",\"\",Application!D26)","v":""}]
[]
[null,"匯  款  金  額",null,null,null,null,null,{"$f":"IF(Application!D19=\"\",\"\",Application!D19)","v":""},null,null,null,null,null,null,null,null,null,"存戶簽章",null,"(左列帳戶原留印鑑)"]
[]
[null,"匯款人姓名:",null,null,{"$f":"IF(Application!D5=\"\",\"\",Application!D5)","v":""},null,null,null,null,null,null,null,"電 話:"]
[null,"身分證字號/統一編號:",null,null,null,null,{"$f":"IF(Application!D6=\"\",\"\",Application!D6)","v":""},null,null,null,null,null,{"$f":"IF(Application!D7=\"\",\"\",Application!D7)","v":""}]
[null,"為辦理匯款茲授權　貴行自下列存款帳號扣款作為匯款金額"]
[null,"帳號：",null,{"$f":"IF(VLOOKUP(Application!$D$27,Account!$A$3:$C$22,2,FALSE)=0,\"\",VLOOKUP(Application!$D$27,Account!$A$3:$C$22,2,FALSE))","v":{"$error":"#N/A"}}]
[null,"＊扣款金額：",null,null,{"$f":"IF(Application!E32=1,Application!D19+Application!D29+Application!D30,Application!D19)","v":0}]
[]
[null,"說明:存戶同意　貴行上述帳號內扣款金額作為本匯款申請書所載匯款金額及手續費用合計數之全部或一部，倘上述帳號內存款不足扣款金額時，貴行得不予扣款。"]
[null,"入"]
[null,"力"]
[null,"認"]
[null,"證"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"證",null,null,null,"印","照"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"印",null,null,null,"鑑","合"]
[null," (G7010) Electronic Application",null,null,null,null,null,{"$f":"使用說明!M30","v":20190902},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-1"]
[null," Note: 使用此申請書時，本人/本公司同意不更動除填記欄位以外之申請書內容及文字，若更動該申請書內容或文字而造成  貴行損失時\n      願負一切責任。"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"匯款",null,null,{"$f":"IF(Application!E21=1,\"☑\",\"☐\")","v":"☐"},"跨行",null,{"$f":"IF(Application!E21=2,\"☑\",\"☐\")","v":"☐"},"公庫",null,{"$f":"IF(Application!E21=3,\"☑\",\"☐\")","v":"☐"},"同業"]
[null,null,null,null,null," 日 商 瑞 穗 銀 行",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Application!M11),\"臺北\",Application!M11)","v":"臺北"},null,"分行",null,"種類",null,null,{"$f":"IF(Application!E21=4,\"☑\",\"☐\")","v":"☐"},"證券",null,{"$f":"IF(Application!E21=5,\"☑\",\"☐\")","v":"☐"},"票券",null,{"$f":"IF(Application!E21=6,\"☑\",\"☐\")","v":"☐"},"自行"]
[null,null,null,null,null,"  Mizuho Bank, Ltd.       匯 款 申 請 書  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Application!D17=\"\",\"\",YEAR(Application!D17))","v":""},null,null,"年",{"$f":"IF(Application!D17=\"\",\"\",MONTH(Application!D17))","v":""},null,"月",{"$f":"IF(Application!D17=\"\",\"\",DAY(Application!D17))","v":""},null,"日"]
[]
["第\n二\n聯\n\n匯\n款\n存\n查\n聯","解款行庫\n(收款行)",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE))","v":{"$error":"#N/A"}},null,null,null,"分支\n單位",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE))","v":{"$error":"#N/A"}},null,null,"解款行\n代　號",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE))","v":{"$error":"#N/A"}},null,null,"手續費",null,{"$f":"IF(Application!D29=\"\",\"\",Application!D29)","v":""}]
[null,"收\n款\n人","帳號",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"代理人",null,{"$f":"IF(Application!D8=\"\",\"\",Application!D8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"身分證字號",null,{"$f":"IF(Application!D9=\"\",\"\",Application!D9)","v":""}]
[null,null,"戶名",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"備註(附言)",null,{"$f":"IF(Application!D26=\"\",\"\",Application!D26)","v":""}]
[]
[null,"匯  款  金  額",null,null,null,null,null,{"$f":"IF(Application!D19=\"\",\"\",Application!D19)","v":""}]
[]
[null,"匯款人姓名:",null,null,{"$f":"IF(Application!D5=\"\",\"\",Application!D5)","v":""},null,null,null,null,null,null,null,"電 話:"]
[null,"身分證字號/統一編號:",null,null,null,null,{"$f":"IF(Application!D6=\"\",\"\",Application!D6)","v":""},null,null,null,null,null,{"$f":"IF(Application!D7=\"\",\"\",Application!D7)","v":""}]
[]
[null,"入"]
[null,"力"]
[null,"認","收 款 人"]
[null,"證","匯 款 人"]
[null,"說明:存戶同意　貴行上述帳號內扣款金額作為本匯款申請書所載匯款金額及手續費用合計數之全部或一部，倘上述帳號內存款不足扣款金額時，貴行得不予扣款。"]
[null,"承"]
[null,"認"]
[null,"認"]
[null,"證"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"金資匯款：",null,null,null,null,null,null,"申請課："]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"主",null,null,"係",null,null,null,"主",null,null,null,"係"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"管",null,null,null,null,null,null,"管"]
[null," (G7010) Electronic Application",null,null,null,null,null,{"$f":"H26","v":20190902},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-2"]
[null," Note: 使用此申請書時，本人/本公司同意不更動除填記欄位以外之申請書內容及文字，若更動該申請書內容或文字而造成  貴行損失時\n      願負一切責任。"]
[]
[]
[]
[null,null,null,null,null," 日 商 瑞 穗 銀 行",null,null,null,null,null,null,null,{"$f":"IF(ISERROR(Application!M11),\"臺北\",Application!M11)","v":"臺北"},null,"分行"]
[null,null,null,null,null,"  Mizuho Bank, Ltd.       匯 款 申 請 書  ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Application!D17=\"\",\"\",YEAR(Application!D17))","v":""},null,null,"年",{"$f":"IF(Application!D17=\"\",\"\",MONTH(Application!D17))","v":""},null,"月",{"$f":"IF(Application!D17=\"\",\"\",DAY(Application!D17))","v":""},null,"日"]
[]
["第\n三\n聯\n\n收\n據\n存\n查\n聯","解款行庫\n(收款行)",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE))","v":{"$error":"#N/A"}},null,null,null,"分支\n單位",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE))","v":{"$error":"#N/A"}},null,null,"解款行\n代　號",null,{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE))","v":{"$error":"#N/A"}},null,null,"手續費",null,{"$f":"IF(Application!D29=\"\",\"\",Application!D29)","v":""}]
[null,"收\n款\n人","帳號",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"代理人",null,{"$f":"IF(Application!D8=\"\",\"\",Application!D8)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"身分證字號",null,{"$f":"IF(Application!D9=\"\",\"\",Application!D9)","v":""}]
[null,null,"戶名",{"$f":"IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"備註(附言)",null,{"$f":"IF(Application!D26=\"\",\"\",Application!D26)","v":""}]
[]
[null,"匯  款  金  額",null,null,null,null,null,{"$f":"IF(Application!D19=\"\",\"\",Application!D19)","v":""}]
[]
[null,"匯款人姓名:",null,null,{"$f":"IF(Application!D5=\"\",\"\",Application!D5)","v":""},null,null,null,null,null,null,null,"電 話:"]
[null,"身分證字號/統一編號:",null,null,null,null,{"$f":"IF(Application!D6=\"\",\"\",Application!D6)","v":""},null,null,null,null,null,{"$f":"IF(Application!D7=\"\",\"\",Application!D7)","v":""}]
[null,"為辦理匯款茲授權　貴行自下列存款帳號扣款作為匯款金額"]
[null,"帳號：",null,{"$f":"IF(VLOOKUP(Application!$D$27,Account!$A$3:$C$22,2,FALSE)=0,\"\",VLOOKUP(Application!$D$27,Account!$A$3:$C$22,2,FALSE))","v":{"$error":"#N/A"}}]
[null,"＊扣款金額：",null,null,{"$f":"IF(Application!E32=1,Application!D19+Application!D29+Application!D30,Application!D19)","v":0}]
[]
[null,"說明：",null,"一、","跨行匯款係經由電腦作業匯至他行庫，如遇電腦故障或連線中斷等因素，可"]
[null,null,null,null,"能無法當日完成匯款。匯款人同意　貴行得由　貴行往來行庫辦理匯款事宜。"]
[null,null,null,"二、","匯款申請人應填寫要項請填寫正確，倘發生錯誤應自負責任，因而遭退匯時，"]
[null,null,null,null,"本行並得加收退匯匯費。"]
[null,null,null,"三、","如有查詢、更正、退匯時，請持本聯來行洽辦。"]
[null,null,null,"四、","本筆匯款請匯款人自行通知收款人。"]
[null,null,null,"五、","本收據印花稅總繳統一編號",null,null,null,null,null,{"$f":"IF(ISERROR(Application!M12),\"96978630\",Application!M12)","v":"96978630"}]
[]
[null," (G7010) Electronic Application",null,null,null,null,null,{"$f":"H26","v":20190902},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-3"]
[null," Note: 使用此申請書時，本人/本公司同意不更動除填記欄位以外之申請書內容及文字，若更動該申請書內容或文字而造成  貴行損失時\n      願負一切責任。"]

{"sheet":"camera","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,"收款人帳號"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,2,FALSE)))","v":""}]
[null,"收款人戶名"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,3,FALSE)))","v":""}]
[null,"收款銀行名稱 (解款行庫)"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,4,FALSE)))","v":""}]
[null,"收款行分支單位"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,5,FALSE)))","v":""}]
[null,"解款行代號"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,6,FALSE)))","v":""}]
[null,"備註"]
[null,{"$f":"IF(ISERROR(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,7,FALSE)),\"\",IF(VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,7,FALSE)=0,\"\",VLOOKUP(Application!$D$18,Beneficiary!$A$3:$G$202,7,FALSE)))","v":""}]