{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["ES1實體_踢退","ES1邏輯_警語","ES3實體_踢退","ES3邏輯_警語_踢退"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"ES1實體_踢退","index":0,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
["【企業ESG資料檔案格式】(ES1)之欄位實體檢核"]
["項次","欄位名稱","說明","檢核訊息"]
[1,"交易代碼","A,C,D"]
[2,"總行代號","金融機構代號（不可為本中心所配賦之虛擬代號）","項目2:欄位不符定義"]
[3,"資料提供來源","1,2","項目3:欄位不符定義"]
[4,"客戶問卷填寫或銀行內部資料建檔年月","YYYMM。","項目4:欄位不符定義"]
[5,"企業統編","八碼統編號或虛擬統編。","項目5:欄位不符定義"]
[6,"過去一年年度","YYY。","項目6:欄位不符定義"]
[7,"過去一年營業收入","新台幣千元，0-9999999999","項目7:欄位不符定義"]
[8,"過去一年資產總額","新台幣千元，0-9999999999","項目8:欄位不符定義"]
[9,"上述財務資料屬性","1,2,3,4,9。","項目9:欄位不符定義"]
[10,"空白","備用欄位"]
[11,"過去一年直接溫室氣體排放量(範疇一)","單位：噸之二氧化碳當量。0~9999999999","項目11:欄位不符定義"]
[12,"(範疇一)第三方驗證","Y,N,SPACE。","項目12:欄位不符定義"]
[13,"過去一年能源間接溫室氣體排放量(範疇二)","單位：噸之二氧化碳當量。0~9999999999","項目13:欄位不符定義"]
[14,"(範疇二)第三方驗證","Y,N,SPACE。","項目14:欄位不符定義"]
[15,"過去一年其他間接溫室氣體排放量(範疇三)","單位：噸之二氧化碳當量。0~9999999999","項目15:欄位不符定義"]
[16,"(範疇三) 第三方驗證","Y,N,SPACE。","項目16:欄位不符定義"]
[17,"部分盤查之邊界說明"]
[18,"盤查邊界涵蓋範圍占營收比","SPACE,000.0~100.0","項目18:欄位不符定義"]
[19,"盤查邊界涵蓋範圍占資產比","SPACE,000.0~100.0","項目19:欄位不符定義"]
[20,"空白","備用欄位。","項目20:欄位不符定義"]
[21,"金融機構自行推估溫室氣體排放量","單位：噸之二氧化碳當量。0~9999999999","項目21:欄位不符定義"]
[22,"溫室氣體排放量推估方法","A,B,C,D,Z,SPACE。","項目22:欄位不符定義"]
[23,"空白","備用欄位。"]
[24,"過去一年全公司用電總度數","單位:度數。0~99999999999","項目24:欄位不符定義"]
[25,"過去一年全公司用水總度數","單位:度數。0~99999999999","項目25:欄位不符定義"]
[26,"過去一年使用再生能源","Y,N,SPACE。","項目26:欄位不符定義"]
[27,"過去一年外購再生能源度數","單位:度數。0~99999999999","項目27:欄位不符定義"]
[28,"過去一年自產再生能源度數","單位:度數。0~99999999999","項目28:欄位不符定義"]
[29,"取得能源管理系統驗證","Y,N,SPACE。","項目29:欄位不符定義"]
[30,"再生能源憑證(RECs)截至去年底累積購買量","單位：張。0~99999999","項目30:欄位不符定義"]
[31,"空白","備用欄位。"]
[32,"E1公司近三年內進行節能採購？","Y,N,SPACE。","項目32:欄位不符定義"]
[33,"E2公司針對節能有進行控管並訂定量化指標？","Y,N,SPACE。","項目33:欄位不符定義"]
[34,"E3公司對於碳排減量有進行採購或轉型計畫？","Y,N,SPACE。","項目34:欄位不符定義"]
[35,"E4公司近三年無環境污染等裁罰事項？(已完成改善並經裁罰單位認可，不在此限)","Y,N,SPACE。","項目35:欄位不符定義"]
[36,"E5公司針對綠能建置有進行投資或明確計畫？","Y,N,SPACE。","項目36:欄位不符定義"]
[37,"E6公司針對廢棄物資源循環利用，或促進原物料永續使用等循環經濟行為？","Y,N,SPACE。","項目37:欄位不符定義"]
[38,"空白","備用欄位。"]
[39,"S1公司近三年無鄰居檢舉事件？","Y,N,SPACE。","項目39:欄位不符定義"]
[40,"S2公司近三年無勞工裁罰事項發生？","Y,N,SPACE。","項目40:欄位不符定義"]
[41,"S3公司近三年曾有公益或相關採購？","Y,N,SPACE。","項目41:欄位不符定義"]
[42,"S4公司聘用弱勢族群或提供學生實習計畫？","Y,N,SPACE。","項目42:欄位不符定義"]
[43,"S5公司投資ESG相關綠色金融商品？","Y,N,SPACE。","項目43:欄位不符定義"]
[44,"空白","備用欄位。"]
[45,"G1公司有依照規定繳稅？","Y,N,SPACE。","項目45:欄位不符定義"]
[46,"G2公司無漏開發票等故意事項？","Y,N,SPACE。","項目46:欄位不符定義"]
[47,"G3公司近三年無逃漏裁罰事項發生？","Y,N,SPACE。","項目47:欄位不符定義"]
[48,"G4公司近三年皆有盈餘？","Y,N,SPACE。","項目48:欄位不符定義"]
[49,"G5公司有定期召開董事會並說明財務狀況？","Y,N,SPACE。","項目49:欄位不符定義"]
[50,"G6公司有定期與股東或關係人說明營運狀況？","Y,N,SPACE。","項目50:欄位不符定義"]
[51,"G7公司有編製永續報告書？","Y,N,SPACE。","項目51:欄位不符定義"]
[52,"空白","備用欄位。"]

{"sheet":"ES1邏輯_警語","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[18,0,20,0],[0,0,0,6],[12,1,13,1],[12,3,13,3],[12,6,13,6],[3,0,17,0]],"flags":["formulas_cached_only"]}
["【企業ESG資料檔案格式】(ES1)之「各欄位間邏輯檢核表」"]
["檢核分類","檢核\n編號","訊息","檢核說明","檢核條件（if）","檢核限制（then）","檢核訊息"]
["過去一年年度","1-1",null,"「過去一年年度」應為「客戶問卷填寫或銀行內部資料建檔年月」之前一年",null,"(6)=(4)YYY-1","項目6：「過去一年年度」應為「客戶問卷填寫或銀行內部資料建檔年月」之前一年"]
["過去一年溫室氣體排放","2-1","W","若資料提供來源為銀行內部建檔，則溫室氣體排放量範疇一、二、三應以9填滿","(3)=2","(11)=9999999999 ","項目11：資料提供來源為銀行內部建檔，溫室氣體排放量範疇一、二、三應以9填滿。"]
[null,"2-2","W","若資料提供來源為銀行內部建檔，則溫室氣體排放量範疇一、二、三應以9填滿","(3)=2","(13)=9999999999 ","項目13：資料提供來源為銀行內部建檔，溫室氣體排放量範疇一、二、三應以9填滿。"]
[null,"2-3","W","若資料提供來源為銀行內部建檔，則溫室氣體排放量範疇一、二、三應以9填滿","(3)=2","(15)=9999999999 ","項目15：資料提供來源為銀行內部建檔，溫室氣體排放量範疇一、二、三應以9填滿。"]
[null,"2-4","W","若資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證不應等於Y","(3)=2","(12)≠Y","項目12：資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證應不可等於Y。"]
[null,"2-5","W","若資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證不應等於Y","(3)=2","(14)≠Y","項目14：資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證應不可等於Y。"]
[null,"2-6","W","若資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證不應等於Y","(3)=2","(16)≠Y","項目16：資料提供來源為銀行內部建檔，則溫室氣體排放第三方驗證應不可等於Y。"]
[null,"2-7","W","若有填報過去一年直接溫室氣體排放量(範疇一)，則應填報是否經第三方驗證","(11)≠9999999999","(12)≠Space","項目12：若有填報過去一年直接溫室氣體排放量(範疇一)，則應填報是否經第三方驗證"]
[null,"2-8","W","若有填報過去一年能源間接溫室氣體排放量(範疇二)，則應填報是否經第三方驗證","(13)≠9999999999","(14)≠Space","項目14：若有填報過去一年能源間接溫室氣體排放量(範疇二)，則應填報是否經第三方驗證"]
[null,"2-9","W","若有填報過去一年其他間接溫室氣體排放量(範疇三)，則應填報是否經第三方驗證","(15)≠9999999999","(16)≠Space","項目16：若有填報過去一年其他間接溫室氣體排放量(範疇三)，則應填報是否經第三方驗證"]
[null,"2-10","W","盤查邊界涵蓋範圍占比不應同時為營收及資產占比","(18)>0","(19)=(000.0, space)","項目18,19：盤查邊界涵蓋範圍不應同時為營收及資產占比"]
[null,null,"W",null,"(19)>0","(18)=(000.0, space)"]
[null,"2-11","W","若資料提供來源為銀行內部建檔，則金融機構自行推估溫室氣體排放量應有值","(3)=2","(21)≠9999999999","項目21：資料提供來源為銀行內部建檔，則「金融機構自行推估溫室氣體排放量」應有值"]
[null,"2-12","W","若資料提供來源為銀行內部建檔，則溫室氣體排放量推估方法應有值","(3)=2","(22)≠空白","項目22：資料提供來源為銀行內部建檔，則「溫室氣體排放量推估方法」應有值"]
[null,"2-13","W","若資料提供來源為企業提供問卷，則金融機構自行推估溫室氣體排放量應為無資料(填十個9)","(3)=1","(21)=9999999999","項目21：資料提供來源為企業提供問卷，則「金融機構自行推估溫室氣體排放量」請填十個9"]
[null,"2-14","W","若資料提供來源為企業提供問卷，則溫室氣體排放量推估方法應空白","(3)=1","(22)=空白","項目22：資料提供來源為企業提供問卷，則「溫室氣體排放量推估方法」應空白"]
["能源管理","3-1","W","過去一年有外購/自產再生能源度數，則過去一年使用再生能源應等於Y","(27)>0 or (28)>0","(26)=Y ","項目26：若過去一年有外購/自產再生能源度數，則過去一年使用再生能源應等於Y"]
[null,"3-2","W","過去一年有使用再生能源，則過去一年外購/自產再生能源度數其中一欄應大於0","(26)=Y and (28)=0","(27)>0 ","項目27：若過去一年有使用再生能源，則過去一年外購/自產再生能源度數其中一欄應大於0"]
[null,"3-2","W","過去一年有使用再生能源，則過去一年外購/自產再生能源度數其中一欄應大於0","(26)=Y and (27)=0 ","(28)>0","項目28：若過去一年有使用再生能源，則過去一年外購/自產再生能源度數其中一欄應大於0"]

{"sheet":"ES3實體_踢退","index":2,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,3]],"flags":["formulas_cached_only"]}
["【自評經濟活動適用/符合永續經濟活動認定參考指引(第二版)之情形檔案】(ES3)之欄位實體檢核"]
["項次","欄位名稱","說明","檢核訊息"]
[1,"交易代碼","A,C,D"]
[2,"總行代號","金融機構代號","項目2:欄位不符定義"]
[3,"客戶問卷填寫年月","YYYMM。","項目3:欄位不符定義"]
[4,"企業統編","八碼統編號或虛擬統編。","項目4:欄位不符定義"]
[5,"衡量期間","YYY","項目5:欄位不符定義"]
[6,"空白","備用欄位。"]
[7,"經濟活動項目類別","A,B,C","項目7:欄位不符定義"]
[8,"營運經濟活動/個別專案項目適用本指引之代號","A01~A03；C01~C09；E01~03；F01~F07；H01~H07\nZ01~Z18(不含Z05、Z06 、Z07、 Z10)\nXXX","項目8:欄位不符定義"]
[9,"營運經濟活動/個別專案項目細項補充說明"]
[10,"營運經濟活動/個別專案項目永續程度自評結果","Y,T,N,X","項目10:欄位不符定義"]
[11,"營運經濟活動過去一年占全部營收之比重","0~100, Space","項目11:欄位不符定義"]
[12,"營運經濟活動/個別專案項目是否符合﹝條件一﹞","Y,N,Space","項目12:欄位不符定義"]
[13,"符合﹝條件一﹞之環境目的","A,B,C,D,E,F,Space","項目13:欄位不符定義"]
[14,"營運經濟活動/個別專案項目是否符合﹝條件二﹞","Y,N,Space","項目14:欄位不符定義"]
[15,"營運經濟活動/個別專案項目不符合條件二之項目","A,B,C,D,E,F,Space","項目15:欄位不符定義"]
[16,"營運經濟活動/個別專案項目是否符合﹝條件三﹞","Y,N,Space","項目16:欄位不符定義"]
[17,"營運經濟活動/個別專案項目是否有轉型計畫","Y,N,Space","項目17:欄位不符定義"]
[18,"空白","備用欄位。"]

{"sheet":"ES3邏輯_警語_踢退","index":3,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,6],[6,0,10,0],[2,0,5,0],[11,0,22,0]],"flags":["formulas_cached_only"]}
["【自評經濟活動適用/符合永續經濟活動認定參考指引(第二版)之情形檔案】(ES3)之「各欄位間邏輯檢核表」"]
["檢核\n分類","檢核\n編號","訊息","檢核說明","檢核條件（if）","檢核限制（then）","檢核訊息"]
["經濟活動營收占比","1-1","W","經濟活動之營收占比有值，則項目類別應為營運經濟活動。","(11)≠Space ","(7)=A or C","項目7：第11欄營收占比有值，則項目類別應為A營運經濟活動或C無任何營運經濟活動或個別專案項目適用本指引。","114.5.29調整"]
[null,"1-2","W","經濟活動項目類別為營運經濟活動，有適用本指引之代號，則營收占比應有值","(7)=A","(11)≠Space","項目11：第7欄為A營運經濟活動，則營收占比應有值。"]
[null,"1-3","W","經濟活動項目類別為個別專案項目，營收占比應空白","(7)=B ","(11)=Space","項目11：第7欄為B個別專案項目，則營收占比應為空白。"]
[null,"1-4","W","若第7欄為A營運經濟活動，則所有營運經濟活動(含不適用本指引)之營收占比加總必須等於100%","(7)=A and (11)≠Space","Σ(11)=100","項目11：截至目前過去一年比重加總數為XX，加上本項後已超過100；本中心仍先予進檔，但請再確認資料正確性。"]
["是否符合條件之判斷","2-1","W","若屬支持型經濟活動，則直接符合條件一。","(8)=Z01~Z18","(12)=Y","項目12：屬支持型經濟活動，則直接符合條件一。"]
[null,"2-2","W","有符合條件一，則符合條件一之環境目的應有值。","(12)=Y","(13)≠Space","項目13：第12欄有符合條件一，則本欄應填符合之環境目的項目。"]
[null,"2-3","W","有填符合條件一之環境目的，則必定符合條件一。","(13)≠Space","(12)=Y","項目12：第13欄有填符合環境目的項目，則本欄應為符合Y。"]
[null,"2-4","W","條件二不符合，則條件二不符合項目應有值。","(14)=N","(15)≠Space","項目15：第14欄不符合條件二，則本欄應填報不符合項目。"]
[null,"2-5","W","有填不符合條件二之環境目的，則條件二應不符合。","(15)≠Space","(14)=N","項目14：第15欄有填不符合環境目的之一，則本欄應為不符合N。"]
["永續程度自評結果判斷","3-1","E","永續自評結果為不適用，則經濟活動類別應為C","(10)=X","(7)=C","項目7:永續自評結果為不適用，則經濟活動類別應為C:無任何營運經濟活動或個別專案項目適用本指引。"]
[null,"3-2","E","若無任何營運經濟活動或個別專案項目適用本指引，則適用本指引之代號應等於XXX。","(7)=C","(8)=XXX","項目8：第7欄=C無任何營運經濟活動或個別專案項目適用本指引，則本欄適用本指引之代號應填報XXX"]
[null,"3-3","W","永續自評結果為不適用，則適用本指引之代號應為XXX","(10)=X","(8)=XXX","項目8：永續自評結果為X不適用，則本欄適用本指引之代號應為XXX"]
[null,"3-4","E","適用本指引之代號不適用，則永續自評結果應為不適用","(8)=XXX","(10)=X","項目10：第8欄適用本指引代號為XXX不適用，則本欄永續自評結果應為X不適用"]
[null,"3-5","W","符合條件一，條件二及條件三，則永續自評結果應為符合","(12)=Y and (14)=Y and (16)=Y","(10)=Y ","項目10：條件一，條件二及條件三皆符合，則永續自評結果應為符合。"]
[null,"3-6","W","條件一，條件二或條件三至少有一項不符合，且有轉型計畫，則永續自評結果應為轉型中。","((12)=N or (14)=N or (16)=N) and(17)=Y","(10)=T","項目10：條件一，條件二或條件三至少有一項不符合，且17欄=Y有轉型計劃，則永續自評結果應為T轉型中。"]
[null,"3-7","W","條件一，條件二或條件三至少有一項不符合，且無轉型計畫，則永續自評結果應為不符合。","((12)=N or (14)=N or (16)=N) and(17)=N","(10)=Ｎ","項目10：條件一，條件二或條件三至少有一項不符合，且17欄=N無轉型計劃，則永續自評結果應為N不符合。"]
[null,"3-8","W","永續自評結果符合，則應符合條件一､條件二及條件三","(10)=Y and (14)=Y and (16)=Y","(12)=Y","項目12：永續自評結果為符合，且條件二及條件三符合，則條件一應符合。"]
[null,"3-9","W","永續自評結果符合，則應符合條件一､條件二及條件三","(10)=Y and (12)=Y and (16)=Y","(14)=Y ","項目14：永續自評結果為符合，且條件一及條件三符合，則條件二應符合。"]
[null,"3-10","W","永續自評結果符合，則應符合條件一､條件二及條件三","(10)=Y and (12)=Y and (14)=Y  ","(16)=Y","項目16：永續自評結果為符合，且條件一及條件二符合，則條件三應符合。"]
[null,"3-11","W","條件一，條件二及條件三皆符合，則是否有轉型計畫應為空白","(12)=Y and (14)=Y and (16)=Y ","(17)=space","項目17：條件一､二､三皆符合，則是否有轉型計畫應為空白"]
[null,"3-12","W","條件一､二､三有任一項不符合，則應填報是否有轉型計畫。","((12)=N or (14)=N or (16)=N)","(17)≠Space","項目17：因有任一條件不符合，則本欄應填報是否有轉型計劃Y/N。","114.5.29調整"]