{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["員工資訊","薪資單計算機","個別薪資單"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"員工資訊","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["員工資訊"]
["公司名稱"]
["員工編號","員工姓名","時薪","課稅狀況","免稅扣除額","所得稅","縣市課稅 (依據扣除額)","社會安全稅","健保費","扣繳總額","保險扣除額","其他定期扣除額","定期扣除總額 (不包括課稅)"]
[1,"劉小龍",{"v":100,"d":"$100.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[所得稅]+Table1[縣市課稅 (依據扣除額)]+Table1[社會安全稅]+Table1[健保費]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":200,"d":"$200.00"},{"v":400,"d":"$400.00"},{"$f":"Table1[保險扣除額]+Table1[其他定期扣除額]","v":{"v":600,"d":"$600.00"}}]
[2,"徐文彬",{"v":130,"d":"$130.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[所得稅]+Table1[縣市課稅 (依據扣除額)]+Table1[社會安全稅]+Table1[健保費]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":200,"d":"$200.00"},{"v":520,"d":"$520.00"},{"$f":"Table1[保險扣除額]+Table1[其他定期扣除額]","v":{"v":720,"d":"$720.00"}}]
[3,"林麗音",{"v":100,"d":"$100.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[所得稅]+Table1[縣市課稅 (依據扣除額)]+Table1[社會安全稅]+Table1[健保費]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":200,"d":"$200.00"},0,{"$f":"Table1[保險扣除額]+Table1[其他定期扣除額]","v":{"v":200,"d":"$200.00"}}]

{"sheet":"薪資單計算機","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["薪資單計算機"]
[{"$nulls":9},"結束日期：",{"v":39113,"d":"3911300.00%"}]
[{"$f":"員工資訊!$A$3","v":"公司名稱"}]
["員工編號","員工姓名","正常工作時數","假期時數","病假時數","加班時數","加班工資率","稅前工資","課稅與扣除額 ","其他扣除額","稅後工資"]
[1,{"$f":"VLOOKUP(A5,Table1[],2,FALSE)","v":"劉小龍"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,Table1[],3,FALSE)*(Table2[正常工作時數]+Table2[假期時數]+Table2[病假時數])+Table2[加班時數]*Table2[加班工資率])","v":{"v":5600,"d":"$5,600.00"}},{"$f":"VLOOKUP(A5,Table1[],10,FALSE)*Table2[稅前工資]+Table1[定期扣除總額 (不包括課稅)]","v":{"v":2730.8,"d":"$2,730.80"}},{"v":20,"d":"$20.00"},{"$f":"Table2[稅前工資]-Table2[[課稅與扣除額 ]]-Table2[其他扣除額]","v":{"v":2849.2,"d":"$2,849.20"}}]
[2,{"$f":"VLOOKUP(A6,Table1[],2,FALSE)","v":"徐文彬"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,Table1[],3,FALSE)*(Table2[正常工作時數]+Table2[假期時數]+Table2[病假時數])+Table2[加班時數]*Table2[加班工資率])","v":{"v":5200,"d":"$5,200.00"}},{"$f":"VLOOKUP(A6,Table1[],10,FALSE)*Table2[稅前工資]+Table1[定期扣除總額 (不包括課稅)]","v":{"v":2698.6000000000004,"d":"$2,698.60"}},{"v":52,"d":"$52.00"},{"$f":"Table2[稅前工資]-Table2[[課稅與扣除額 ]]-Table2[其他扣除額]","v":{"v":2449.3999999999996,"d":"$2,449.40"}}]
[3,{"$f":"VLOOKUP(A7,Table1[],2,FALSE)","v":"林麗音"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"$20.00"},{"$f":"(VLOOKUP(A7,Table1[],3,FALSE)*(Table2[正常工作時數]+Table2[假期時數]+Table2[病假時數])+Table2[加班時數]*Table2[加班工資率])","v":{"v":5240,"d":"$5,240.00"}},{"$f":"VLOOKUP(A7,Table1[],10,FALSE)*Table2[稅前工資]+Table1[定期扣除總額 (不包括課稅)]","v":{"v":2193.8200000000006,"d":"$2,193.82"}},{"v":20,"d":"$20.00"},{"$f":"Table2[稅前工資]-Table2[[課稅與扣除額 ]]-Table2[其他扣除額]","v":{"v":3026.1799999999994,"d":"$3,026.18"}}]

{"sheet":"個別薪資單","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"(員工資訊!$A$3)","v":"公司名稱"}]
[null,null,"期間：",{"$f":"薪資單計算機!$K$2","v":{"v":39113,"d":"3911300.00%"}},"員工姓名",{"$f":"IFERROR(VLOOKUP(H3,Table1[],2),\"\")","v":"劉小龍"},"員工編號",1]
[]
[null,null,"課稅狀況",{"$f":"IFERROR(VLOOKUP(H3,Table1[],4),\"\")","v":1},"免稅扣除額",{"$f":"IFERROR(VLOOKUP(H3,Table1[],5,FALSE),\"\")","v":4},"工作時數",{"$f":"IFERROR(VLOOKUP(H3,Table2[],3,FALSE),\"\")","v":50}]
[null,null,"時薪",{"$f":"IFERROR(VLOOKUP(H3,Table1[],3,FALSE),\"\")","v":{"v":100,"d":"$100.00"}},"加班工資率",{"$f":"IFERROR(VLOOKUP(H3,Table2[],7,FALSE),\"\")","v":0},"病假時數",{"$f":"IFERROR(VLOOKUP(H3,Table2[],5,FALSE),\"\")","v":1}]
[null,null,"社會安全稅",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],8,FALSE),\"\")*H9,\"\")","v":{"v":352.8,"d":"$352.80"}},"縣市課稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],7,FALSE),\"\")*H9,\"\")","v":{"v":1568.0000000000002,"d":"$1,568.00"}},"假期時數",{"$f":"IFERROR(VLOOKUP(H3,Table2[],4,FALSE),\"\")","v":5}]
[null,null,"健保費 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],9,FALSE),\"\")*H9,\"\")","v":{"v":81.2,"d":"$81.20"}},"所得稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],6,FALSE),\"\")*H9,\"\")","v":{"v":128.8,"d":"$128.80"}},"加班時數",{"$f":"IFERROR(VLOOKUP(H3,Table2[],6,FALSE),\"\")","v":0}]
[null,null,"保險扣除額",{"$f":"IFERROR(VLOOKUP(H3,Table1[],11,FALSE),\"\")","v":{"v":200,"d":"$200.00"}},"其他定期扣除額",{"$f":"IFERROR(VLOOKUP(H3,Table1[],12,FALSE),\"\")","v":{"v":400,"d":"$400.00"}},"稅前工資",{"$f":"IFERROR(VLOOKUP(H3,Table2[],8,FALSE),\"\")","v":{"v":5600,"d":"$5,600.00"}}]
[null,null,"課稅與定期扣除總額 ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":2730.8,"d":"$2,730.80"}},"其他扣除額",{"$f":"IFERROR(VLOOKUP(H3,Table2[],10,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"課稅與扣除總額 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table2[],9,FALSE),\"\")+F10,\"\")","v":{"v":2750.8,"d":"$2,750.80"}}]
[{"$nulls":6},"稅後工資",{"$f":"IFERROR(VLOOKUP(H3,Table2[],11,FALSE),\"\")","v":{"v":2849.2,"d":"$2,849.20"}}]
[]
[]
[null,null,{"$f":"(員工資訊!$A$3)","v":"公司名稱"}]
[null,null,"期間：",{"$f":"薪資單計算機!$K$2","v":{"v":39113,"d":"3911300.00%"}},"員工姓名",{"$f":"IFERROR(VLOOKUP(H15,Table1[],2),\"\")","v":"徐文彬"},"員工編號",2]
[]
[null,null,"課稅狀況",{"$f":"IFERROR(VLOOKUP(H15,Table1[],4),\"\")","v":1},"免稅扣除額",{"$f":"IFERROR(VLOOKUP(H15,Table1[],5,FALSE),\"\")","v":4},"工作時數",{"$f":"IFERROR(VLOOKUP(H15,Table2[],3,FALSE),\"\")","v":40}]
[null,null,"時薪",{"$f":"IFERROR(VLOOKUP(H15,Table1[],3,FALSE),\"\")","v":{"v":130,"d":"$130.00"}},"加班工資率",{"$f":"IFERROR(VLOOKUP(H15,Table2[],7,FALSE),\"\")","v":0},"病假時數",{"$f":"IFERROR(VLOOKUP(H15,Table2[],5,FALSE),\"\")","v":0}]
[null,null,"社會安全稅",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],8,FALSE),\"\")*H21,\"\")","v":{"v":327.6,"d":"$327.60"}},"縣市課稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],7,FALSE),\"\")*H21,\"\")","v":{"v":1456.0000000000002,"d":"$1,456.00"}},"假期時數",{"$f":"IFERROR(VLOOKUP(H15,Table2[],4,FALSE),\"\")","v":0}]
[null,null,"健保費 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],9,FALSE),\"\")*H21,\"\")","v":{"v":75.4,"d":"$75.40"}},"所得稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],6,FALSE),\"\")*H21,\"\")","v":{"v":119.6,"d":"$119.60"}},"加班時數",{"$f":"IFERROR(VLOOKUP(H15,Table2[],6,FALSE),\"\")","v":0}]
[null,null,"保險扣除額",{"$f":"IFERROR(VLOOKUP(H15,Table1[],11,FALSE),\"\")","v":{"v":200,"d":"$200.00"}},"其他定期扣除額",{"$f":"IFERROR(VLOOKUP(H15,Table1[],12,FALSE),\"\")","v":{"v":520,"d":"$520.00"}},"稅前工資",{"$f":"IFERROR(VLOOKUP(H15,Table2[],8,FALSE),\"\")","v":{"v":5200,"d":"$5,200.00"}}]
[null,null,"課稅與定期扣除總額 ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":2698.6000000000004,"d":"$2,698.60"}},"其他扣除額",{"$f":"IFERROR(VLOOKUP(H15,Table2[],10,FALSE),\"\")","v":{"v":52,"d":"$52.00"}},"課稅與扣除總額 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table2[],9,FALSE),\"\")+F22,\"\")","v":{"v":2750.6000000000004,"d":"$2,750.60"}}]
[{"$nulls":6},"稅後工資",{"$f":"IFERROR(VLOOKUP(H15,Table2[],11,FALSE),\"\")","v":{"v":2449.3999999999996,"d":"$2,449.40"}}]
[]
[]
[null,null,{"$f":"(員工資訊!$A$3)","v":"公司名稱"}]
[null,null,"期間：",{"$f":"薪資單計算機!$K$2","v":{"v":39113,"d":"3911300.00%"}},"員工姓名",{"$f":"IFERROR(VLOOKUP(H27,Table1[],2),\"\")","v":"林麗音"},"員工編號",3]
[]
[null,null,"課稅狀況",{"$f":"IFERROR(VLOOKUP(H27,Table1[],4),\"\")","v":1},"免稅扣除額",{"$f":"IFERROR(VLOOKUP(H27,Table1[],5,FALSE),\"\")","v":4},"工作時數",{"$f":"IFERROR(VLOOKUP(H27,Table2[],3,FALSE),\"\")","v":52}]
[null,null,"時薪",{"$f":"IFERROR(VLOOKUP(H27,Table1[],3,FALSE),\"\")","v":{"v":100,"d":"$100.00"}},"加班工資率",{"$f":"IFERROR(VLOOKUP(H27,Table2[],7,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"病假時數",{"$f":"IFERROR(VLOOKUP(H27,Table2[],5,FALSE),\"\")","v":0}]
[null,null,"社會安全稅",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],8,FALSE),\"\")*H33,\"\")","v":{"v":330.12,"d":"$330.12"}},"縣市課稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],7,FALSE),\"\")*H33,\"\")","v":{"v":1467.2,"d":"$1,467.20"}},"假期時數",{"$f":"IFERROR(VLOOKUP(H27,Table2[],4,FALSE),\"\")","v":0}]
[null,null,"健保費 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],9,FALSE),\"\")*H33,\"\")","v":{"v":75.98,"d":"$75.98"}},"所得稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],6,FALSE),\"\")*H33,\"\")","v":{"v":120.52,"d":"$120.52"}},"加班時數",{"$f":"IFERROR(VLOOKUP(H27,Table2[],6,FALSE),\"\")","v":2}]
[null,null,"保險扣除額",{"$f":"IFERROR(VLOOKUP(H27,Table1[],11,FALSE),\"\")","v":{"v":200,"d":"$200.00"}},"其他定期扣除額",{"$f":"IFERROR(VLOOKUP(H27,Table1[],12,FALSE),\"\")","v":0},"稅前工資",{"$f":"IFERROR(VLOOKUP(H27,Table2[],8,FALSE),\"\")","v":{"v":5240,"d":"$5,240.00"}}]
[null,null,"課稅與定期扣除總額 ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":2193.82,"d":"$2,193.82"}},"其他扣除額",{"$f":"IFERROR(VLOOKUP(H27,Table2[],10,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"課稅與扣除總額 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table2[],9,FALSE),\"\")+F34,\"\")","v":{"v":2213.8200000000006,"d":"$2,213.82"}}]
[{"$nulls":6},"稅後工資",{"$f":"IFERROR(VLOOKUP(H27,Table2[],11,FALSE),\"\")","v":{"v":3026.1799999999994,"d":"$3,026.18"}}]
[]
[]
[]
[null,null,{"$f":"(員工資訊!$A$3)","v":"公司名稱"}]
[null,null,"期間：",{"$f":"薪資單計算機!$K$2","v":{"v":39113,"d":"3911300.00%"}},"員工姓名",{"$f":"IFERROR(VLOOKUP(H40,Table1[],2),\"\")","v":""},"員工編號"]
[]
[null,null,"課稅狀況",{"$f":"IFERROR(VLOOKUP(H40,Table1[],4),\"\")","v":""},"免稅扣除額",{"$f":"IFERROR(VLOOKUP(H40,Table1[],5,FALSE),\"\")","v":""},"工作時數",{"$f":"IFERROR(VLOOKUP(H40,Table2[],3,FALSE),\"\")","v":""}]
[null,null,"時薪",{"$f":"IFERROR(VLOOKUP(H40,Table1[],3,FALSE),\"\")","v":""},"加班工資率",{"$f":"IFERROR(VLOOKUP(H40,Table2[],7,FALSE),\"\")","v":""},"病假時數",{"$f":"IFERROR(VLOOKUP(H40,Table2[],5,FALSE),\"\")","v":""}]
[null,null,"社會安全稅",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],8,FALSE),\"\")*H46,\"\")","v":""},"縣市課稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],7,FALSE),\"\")*H46,\"\")","v":""},"假期時數",{"$f":"IFERROR(VLOOKUP(H40,Table2[],4,FALSE),\"\")","v":""}]
[null,null,"健保費 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],9,FALSE),\"\")*H46,\"\")","v":""},"所得稅 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],6,FALSE),\"\")*H46,\"\")","v":""},"加班時數",{"$f":"IFERROR(VLOOKUP(H40,Table2[],6,FALSE),\"\")","v":""}]
[null,null,"保險扣除額",{"$f":"IFERROR(VLOOKUP(H40,Table1[],11,FALSE),\"\")","v":""},"其他定期扣除額",{"$f":"IFERROR(VLOOKUP(H40,Table1[],12,FALSE),\"\")","v":""},"稅前工資",{"$f":"IFERROR(VLOOKUP(H40,Table2[],8,FALSE),\"\")","v":""}]
[null,null,"課稅與定期扣除總額 ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"其他扣除額",{"$f":"IFERROR(VLOOKUP(H40,Table2[],10,FALSE),\"\")","v":""},"課稅與扣除總額 ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"稅後工資",{"$f":"IFERROR(VLOOKUP(H40,Table2[],11,FALSE),\"\")","v":""}]