{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["薪資資料","薪資單","設定所得支出明細","臨櫃轉檔"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":6,"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":3,"n_cols":27,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,8]]}
["功能"]
["說明：\n1. 請先至「設定所得支出明細」工作表，設定收入支出項目後，再至「薪資資料」工作表建檔。\n2.「薪資資料」工作表，＊為必要欄位，並依序建檔，序號須連續不得中斷，並不可任意增刪欄位。\n3.「實際入帳金額」=所得-支出-領現金額，全部輸入完成後請按下「轉換MyB2B薪資單格式」，並將輸出檔案(salary.txt)上傳MyB2B。MyB2B會檢核金額正確性，如金額不符，則無法上傳。\n4.如無法上傳MyB2B，可按下「匯至臨櫃轉檔」按鈕，再至「臨櫃轉檔」工作表輸出檔案(obtdta.txt)至臨櫃辦理。"]
["*序號","*薪資單日期(YYYMM)\n(Ex:09901)","*員工ID","*員工帳號","*員工姓名","*實際入帳金額","領現金額","員工Email(50)","員工存摺備註\n(最多5個中文字)","保留欄位\n(誤刪)","保留欄位\n(誤刪)","薪資單備註\n(最多500個中文字,可用\"半形;\"換行)","*本薪","伙食津貼","加班費","A","B","C","代扣勞保費","代扣公保","代扣農保","代扣健保費","代扣所得稅","員工本月自提退休金",1,2,3]

{"sheet":"薪資單","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,5],[8,1,8,2],[8,4,8,5],[9,1,9,2],[9,4,9,5],[6,1,6,2],[6,4,6,5],[7,1,7,2],[7,4,7,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[5,1,5,2],[5,4,5,5],[4,1,4,2],[4,4,4,5]]}
["薪資單"]
["109 年 09 月"]
["姓名：測試"]
["收入",null,null,"支出"]
["本薪",500]
[]
["收入備註",null,null,"支出備註"]
["收入合計",{"$f":"SUM(B5:B7)","v":500},null,"支出合計",{"$f":"SUM(E5:E7)","v":0}]
[null,null,null,"領現金額"]
[null,null,null,"實際入帳金額",500]
["薪資單備註"]

{"sheet":"設定所得支出明細","index":2,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["*所得/支出欄位明細最多可輸入8個全型中文"]
["其它所得1：","A",null,"其他支出1：","1"]
["其它所得2：","B",null,"其他支出2：","2"]
["其它所得3：","C",null,"其他支出3：","3"]
["其它所得4：",null,null,"其他支出4："]
["其它所得5：",null,null,"其他支出5："]
["其它所得6：",null,null,"其他支出6："]
["其它所得7：",null,null,"其他支出7："]
["其它所得8：",null,null,"其他支出8："]
["其它所得9：",null,null,"其他支出9："]
["其它所得10：",null,null,"其他支出10："]
["其它所得11：",null,null,"其他支出11："]
["其它所得12：",null,null,"其他支出12："]
["其它所得13：",null,null,"其他支出13："]
["其它所得14：",null,null,"其他支出14："]
["其它所得15：",null,null,"其他支出15："]

{"sheet":"臨櫃轉檔","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,5,1,6],[2,5,2,6]]}
["Etabs薪資轉帳媒體格式編輯(obtdta.txt)"]
["5位公司代號\nex:　00100",null,"實際交易日期\nex:　20110501",null,"總筆數合計",{"$f":"DCOUNTA(B5:B1005,B5,B5:B1005)-COUNTIF(C6:C1005,\"=0\")","v":0}]
["入帳代碼","2","資料種類代碼　","900","總金額合計",{"$f":"SUM(C6:C1005)","v":0}]
["\n注意：\n1.請輸入5位公司代號和\n   實際交易日期。\n2.資料完成後，\n   請按[臨櫃轉檔]。","交易序號(ex:1,2,3...)","實際入帳金額\n(單位:元)","員工帳號","員工ID","員工存摺備註","員工姓名"]
["匯出範例","1",50000,"00150123XXXX","A12345XXXX","一月份薪資","張三"]
[]
[""]