{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["工資源","結果"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":17,"n_cols":24,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,0,13,3],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[1,0,1,23],[2,0,2,23],[4,5,4,8],[4,9,4,12],[4,14,4,21],[4,13,5,13],[4,22,5,22],[4,23,5,23]]}
[]
["********有限責任公司"]
["2019年（09）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[1,null,26,2,3000,500,200,100,0,0,{"$f":"ROUND(((E7/$U$4)*D7),2)","v":230.77},0,0,{"$f":"ROUND((E7*M7%+F7+G7+H7+I7+J7+K7+L7),2)","v":1030.77},{"$f":"ROUND((($U$4-C7)*E7/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N7-5000-Q7)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O7:V7)","v":0},{"$f":"ROUND((N7-W7),2)","v":1030.77}]
[2,null,26,0,0,1000,0,0,0,0,0,0,0,1000,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N8-5000-Q8)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,1000]
[3,null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N9-5000-Q9)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,0]
[4,null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N10-5000-Q10)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,0]
[5,null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N11-5000-Q11)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,0]
[6,null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N12-5000-Q12)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,0]
[7,null,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(MAX((N13-5000-Q13)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},0,0]
["合  計",null,null,null,{"$f":"ROUND((SUM(E7:E13)),2)","v":3000},1500,200,100,0,0,230.77,0,null,{"$f":"ROUND((SUM(N7:N13)),2)","v":2030.77},0,0,0,0,0,0,0,0,0,2030.77]
[]
["公司審批：",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,"日  期:"]

{"sheet":"結果","index":1,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[14,23,15,23],[19,23,20,23],[24,23,25,23],[29,23,30,23],[34,23,35,23],[14,22,15,22],[19,22,20,22],[24,22,25,22],[29,22,30,22],[34,22,35,22],[19,13,20,13],[24,13,25,13],[29,13,30,13],[34,13,35,13],[39,13,40,13],[37,0,37,23],[39,5,39,8],[39,9,39,12],[39,14,39,21],[41,0,41,3],[39,0,40,0],[39,1,40,1],[39,2,40,2],[39,3,40,3],[39,22,40,22],[39,23,40,23],[29,5,29,8],[29,9,29,12],[29,14,29,21],[32,0,32,23],[34,5,34,8],[34,9,34,12],[34,14,34,21],[29,0,30,0],[34,0,35,0],[29,1,30,1],[34,1,35,1],[29,2,30,2],[34,2,35,2],[29,3,30,3],[34,3,35,3],[22,0,22,23],[24,5,24,8],[24,9,24,12],[24,14,24,21],[27,0,27,23],[24,0,25,0],[24,1,25,1],[24,2,25,2],[24,3,25,3],[14,5,14,8],[14,9,14,12],[14,14,14,21],[17,0,17,23],[19,5,19,8],[19,9,19,12],[19,14,19,21],[14,0,15,0],[19,0,20,0],[14,1,15,1],[19,1,20,1],[14,2,15,2],[19,2,20,2],[14,3,15,3],[19,3,20,3],[14,13,15,13],[7,0,7,23],[9,5,9,8],[9,9,9,12],[9,14,9,21],[12,0,12,23],[9,0,10,0],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,13,10,13],[9,22,10,22],[9,23,10,23],[1,0,1,23],[2,0,2,23],[4,5,4,8],[4,9,4,12],[4,14,4,21],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,13,5,13],[4,22,5,22],[4,23,5,23]]}
[]
["********有限責任公司"]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[1,null,26,2,3000,500,200,100,0,0,{"$f":"ROUND(((E7/$U$4)*D7),2)","v":230.77},0,0,{"$f":"ROUND((E7*M7%+F7+G7+H7+I7+J7+K7+L7),2)","v":1030.77},{"$f":"ROUND((($U$4-C7)*E7/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N7-5000-Q7)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O7:V7)","v":0},{"$f":"ROUND((N7-W7),2)","v":1030.77}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[2,null,26,0,0,1000,0,0,0,0,{"$f":"ROUND(((E12/$U$4)*D12),2)","v":0},0,0,{"$f":"ROUND((E12*M12%+F12+G12+H12+I12+J12+K12+L12),2)","v":1000},{"$f":"ROUND((($U$4-C12)*E12/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N12-5000-Q12)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O12:V12)","v":0},{"$f":"ROUND((N12-W12),2)","v":1000}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[3,null,26,0,0,0,0,0,0,0,{"$f":"ROUND(((E17/$U$4)*D17),2)","v":0},0,0,{"$f":"ROUND((E17*M17%+F17+G17+H17+I17+J17+K17+L17),2)","v":0},{"$f":"ROUND((($U$4-C17)*E17/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N17-5000-Q17)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O17:V17)","v":0},{"$f":"ROUND((N17-W17),2)","v":0}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[4,null,26,0,0,0,0,0,0,0,{"$f":"ROUND(((E22/$U$4)*D22),2)","v":0},0,0,{"$f":"ROUND((E22*M22%+F22+G22+H22+I22+J22+K22+L22),2)","v":0},{"$f":"ROUND((($U$4-C22)*E22/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N22-5000-Q22)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O22:V22)","v":0},{"$f":"ROUND((N22-W22),2)","v":0}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[5,null,26,0,0,0,0,0,0,0,{"$f":"ROUND(((E27/$U$4)*D27),2)","v":0},0,0,{"$f":"ROUND((E27*M27%+F27+G27+H27+I27+J27+K27+L27),2)","v":0},{"$f":"ROUND((($U$4-C27)*E27/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N27-5000-Q27)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O27:V27)","v":0},{"$f":"ROUND((N27-W27),2)","v":0}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[6,null,26,0,0,0,0,0,0,0,{"$f":"ROUND(((E32/$U$4)*D32),2)","v":0},0,0,{"$f":"ROUND((E32*M32%+F32+G32+H32+I32+J32+K32+L32),2)","v":0},{"$f":"ROUND((($U$4-C32)*E32/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N32-5000-Q32)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O32:V32)","v":0},{"$f":"ROUND((N32-W32),2)","v":0}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
[7,null,26,0,0,0,0,0,0,0,{"$f":"ROUND(((E37/$U$4)*D37),2)","v":0},0,0,{"$f":"ROUND((E37*M37%+F37+G37+H37+I37+J37+K37+L37),2)","v":0},{"$f":"ROUND((($U$4-C37)*E37/$U$4),2)","v":0},0,0,0,0,0,0,{"$f":"ROUND(MAX((N37-5000-Q37)*{0.03;0.1;0.2;0.25;0.3;0.35;0.45}-{0;210;1410;2660;4410;7160;15160},0),2)","v":0},{"$f":"SUM(O37:V37)","v":0},{"$f":"ROUND((N37-W37),2)","v":0}]
["2018年（08）月份工資發放明細表"]
["部門:   財務部",null,null,null,null,null,null,null,null,null,null,null,null,"單位：元",null,null,null,"本月應出勤天數:",null,null,26,"天"]
["序\n號","姓名","考    勤","加班","工資","各種津貼",null,null,null,"其  它",null,null,null,"應發 工資","扣    減",null,null,null,null,null,null,null,"扣款 合計","實發工資"]
[null,null,null,null,"基本工資","績效\n津貼","特殊崗位津貼","駐外     補貼","其它   補貼","工齡 工資","加班 工資","其它 應發","工齡工資",null,"請假 扣款","水電費","社會 保險","伙食費","個人 借支","其它 扣款","工會 會費","個人稅"]
["合  計",null,null,null,{"$f":"ROUND((SUM(E7:E37)),2)","v":3000},1500,200,100,0,0,230.77,0,null,{"$f":"ROUND((SUM(N7:N37)),2)","v":2030.77},0,0,0,0,0,0,156,0,0,2030.77]
[]
["公司審批：",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,"日  期:"]