{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["說明","人事薪資資料庫","薪資統計","巨集"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":13,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"巨集","index":3,"reason":"part_missing"}],"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":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[8,1,8,7],[0,0,0,7],[10,1,10,7],[11,1,11,7],[2,0,2,7],[4,0,4,7],[9,0,9,7],[3,1,3,7],[5,1,5,7],[6,1,6,7],[7,0,7,5]]}
["薪資管理"]
[]
["操作指引："]
[null,"您可按垂直捲軸，依序往下捲動各項內容，或依您所需選按各項按鈕。"]
["模式目的："]
[null,"(1).登錄企業人事薪資記錄。"]
[null,"(2).編製人事薪資統計表。"]
["應用時機："]
[null,"以列表方式登錄企業機構的人事薪資資料並以樞鈕分析進行薪資彙算作業。"]
["模式使用："]
[null,"(1).請於『人事薪資資料庫』工作表內輸入資料。"]
[null,"(2).按『薪資統計』鈕進行薪資彙算。。"]

{"sheet":"人事薪資資料庫","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"員工編號","員工姓名","單位別","部門別","職 等","職 位","底 薪","津 貼","薪 資"]
[null,"F2328","王辭修","臺北分公司","業務部","高級專員","副 理",58000,6000,{"$f":"+H3+I3","v":64000}]
[null,"L8424","何玉霖","臺中分公司","總務部","二級管理師","組 長",38000,4000,42000]
[null,"M2543","吳新樺","高雄分公司","財務部","一級管理師","襄 理",50000,5000,55000]
[null,"A1886","李金進","總管理處","資訊室","一級工程師","系統分析師",46000,3000,49000]
[null,"A1264","李麥克","臺中分公司","資訊室","高級專員","經 理",68000,7000,75000]
[null,"S2106","林日富","總管理處","會計部","一級管理師","主辦會計",34000,3500,37500]
[null,"I4524","林修文","高雄分公司","業務部","一級管理師","主 任",42000,4000,46000]
[null,"T1136","林誼信","臺北分公司","生產部","高級作業員","品質分析員",28000,2000,30000]
[null,"T1126","金維行","總管理處","財務部","高級專員","經 理",58000,7000,65000]
[null,"A2268","張家福","臺北分公司","資訊室","一級工程師","資料庫管理師",44000,4000,48000]
[null,"T1126","許方澄","臺北分公司","生產部","初級作業員","作業員",20000,2000,22000]
[null,"A1866","程邦制","臺中分公司","資訊室","二級工程師","程式設計師",38000,3000,41000]
[null,"B4326","趙容曜","高雄分公司","業務部","一級管理師","課 長",40000,4500,44500]
[null,"C1434","汪醫華","臺北分公司","資訊室","高級專員","副 理",59000,6000,65000]
[null,"K6512","李上希","臺中分公司","業務部","二級管理師","組 長",39000,4000,43000]
[null,"F4319","乘証翁","高雄分公司","總務部","一級管理師","襄 理",51000,5000,56000]
[null,"A1765","鄭一紅","總管理處","財務部","一級工程師","系統分析師",47000,3000,50000]
[null,"S106","林中清","臺北分公司","生產部","高級專員","經 理",69000,7000,76000]
[null,"J7612","黃頻詳","臺中分公司","會計部","一級管理師","主辦會計",35000,3500,38500]
[null,"T5412","張其明","高雄分公司","業務部","一級管理師","主 任",43000,4000,47000]
[null,"L6154","方市意","總管理處","資訊室","高級作業員","品質分析員",29000,2000,31000]
[null,"P2019","林書方","臺北分公司","業務部","高級專員","經 理",59000,7000,66000]
[null,"V5410","汪身位","臺中分公司","總務部","一級工程師","資料庫管理師",45000,4000,49000]
[null,"X1923","蔣意離","高雄分公司","財務部","初級作業員","作業員",21000,2000,23000]
[null,"F4120","趙小然","總管理處","生產部","二級工程師","程式設計師",39000,3000,42000]
[null,"M4927","楊少康","臺北分公司","會計部","一級管理師","課 長",41000,4500,45500]
[null,"D4138","李慎風","臺中分公司","資訊室","高級專員","副 理",60000,6000,66000]
[null,"H1822","周權華","高雄分公司","業務部","二級管理師","組 長",40000,4000,44000]
[null,"F6152","花聯樺","總管理處","總務部","一級管理師","襄 理",52000,5000,57000]
[null,"K8127","吳壹深","臺北分公司","財務部","一級工程師","系統分析師",48000,3000,51000]
[null,"L9182","彭務實","臺中分公司","生產部","高級專員","經 理",70000,7000,77000]
[null,"D4130","程益力","高雄分公司","會計部","一級管理師","主辦會計",36000,3500,39500]
[null,"H1171","向華強","總管理處","業務部","一級管理師","主 任",44000,4000,48000]
[null,"H9822","劉雪華","臺北分公司","資訊室","高級作業員","品質分析員",30000,2000,32000]
[null,"V5241","胡為庸","臺中分公司","業務部","高級專員","經 理",60000,7000,67000]
[null,"G7261","張季行","高雄分公司","總務部","一級工程師","資料庫管理師",46000,4000,50000]
[null,"F8326","程銳靈","總管理處","財務部","初級作業員","作業員",22000,2000,24000]
[null,"U8172","葉紹秋","臺北分公司","生產部","二級工程師","程式設計師",40000,3000,43000]
[null,"V5401","魏資則","臺中分公司","會計部","一級管理師","課 長",42000,4500,46500]

{"sheet":"薪資統計","index":2,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"部門別"]
[null,"單位別","資料","生產部","財務部","會計部","業務部","資訊室","總務部","總計"]
[null,"高雄分公司","加總項目:底 薪",0,71000,36000,165000,0,97000,369000]
[null,null,"加總項目:津 貼",0,7000,3500,16500,0,9000,36000]
[null,"臺中分公司","加總項目:底 薪",70000,0,77000,99000,166000,83000,495000]
[null,null,"加總項目:津 貼",7000,0,8000,11000,16000,8000,50000]
[null,"臺北分公司","加總項目:底 薪",157000,48000,41000,117000,133000,0,496000]
[null,null,"加總項目:津 貼",14000,3000,4500,13000,12000,0,46500]
[null,"總管理處","加總項目:底 薪",39000,127000,34000,44000,75000,52000,371000]
[null,null,"加總項目:津 貼",3000,12000,3500,4000,5000,5000,32500]
[null,"加總項目:底 薪 的加總",null,266000,246000,188000,425000,374000,232000,1731000]
[null,"加總項目:津 貼 的加總",null,24000,22000,19500,44500,33000,22000,165000]