{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1 (2)","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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"}

{"sheet":"Sheet1 (2)","index":0,"n_rows":19,"n_cols":65,"rows_kept":19,"cut":false,"hidden":false,"merged":[[7,61,7,63],[9,54,9,59],[14,54,14,59],[15,54,15,59],[16,54,16,59],[18,54,18,59],[17,54,17,59],[6,49,6,52],[8,54,8,59],[13,54,13,59],[10,54,10,59],[11,54,11,59],[12,54,12,59],[7,54,7,59],[11,31,11,40],[9,31,9,40],[6,41,6,48],[7,41,7,48],[8,41,8,48],[9,41,9,48],[10,41,10,48],[11,41,11,48],[6,31,6,40],[6,13,6,19],[7,31,7,40],[8,31,8,40],[10,31,10,40],[6,26,6,30],[6,20,6,25]]}
[{"$nulls":13},"shouldDays","shouldHours","actualDays","actualHours","nightDays","festivalDays","festivalHours"]
["费用归属","人员类别","薪资分组","公司归属","一级部门","二级部门","三级部门","员工编号","员工姓名","邮箱","入职日期","离职日期","工龄","应出勤天数","应出勤小时","实际出勤天数","实际出勤小时数","节日出勤天数","节日出勤小时","夜班出勤天数","餐补标准","工龄补贴标准","加班费基数","夜班补贴基数","社保缴费基数","公积金缴费基数","基本工资","基础工资","技能工资","保密工资","职位津贴","补贴合计","工龄补贴","职称补贴","环境补贴","租房补贴","交通补贴","餐费补贴","夜班补贴","高温补贴","其他福利补贴","加班费合计","固定加班费","平日加班小时","平日加班费","周末加班小时","周末加班费","节日加班小时","节日加班费","绩效","提成","工资补款","工资扣款","应发工资","个人四金扣款","养老保险","医疗保险","重疾补助","失业保险","住房公积金","计税工资","代扣上月个税","劳务个税","电费","实发工资"]
["管理","正式工","上海组","上海纳琳威","IT部","无","无","N100085","邓夙成","dengsucheng@nalinv.cn","2019-07-01",null,{"$f":"IF(K3=\"\",\"\",DATEDIF(K3,TODAY(),\"Y\"))","v":3},21,168,21,{"$nulls":4},20,100,5500,null,8746,8746,{"$f":"SUM(AB3:AE3)","v":9010},5500,2010,1500,null,{"$f":"SUM(AG3:AO3)","v":720},{"$f":"M3*V3","v":300},{"$nulls":4},{"$f":"P3*U3","v":420},{"$f":"T3*X3","v":0},null,null,{"$f":"AQ3+AS3+AU3+AW3","v":0},null,null,{"$f":"ROUND(W3/174*AR3*1.5,2)","v":0},null,{"$f":"ROUND(W3/174*AT3*2,2)","v":0},null,{"$f":"ROUND(W3/174*AV3*3,2)","v":0},{"$nulls":4},{"$f":"AA3+AF3+AP3+AX3+AY3+AZ3-BA3","v":9730},{"$f":"BD3+BE3+BG3+BH3","v":1530.5},{"$f":"ROUND(Y3*0.08,1)","v":699.7},{"$f":"ROUNDUP(Y3*0.02,1)","v":175},null,{"$f":"ROUNDUP(Y3*0.005,1)","v":43.800000000000004},{"$f":"ROUND(Z3*0.07,0)","v":612},{"$f":"BB3-BC3","v":8199.5},80.38,null,null,{"$f":"BI3-BJ3-BK3-BL3","v":8119.12}]
["生产","正式工","上海组","上海纳琳科","生产制造中心","PET拉膜车间","无","N100219","罗辉","luoyuhui@nalinke.com","2020-06-01",null,{"$f":"IF(K4=\"\",\"\",DATEDIF(K4,TODAY(),\"Y\"))","v":2},21,168,23.5,218,null,null,null,30,100,2590,null,9285,9285,{"$f":"SUM(AB4:AE4)","v":4860},3000,1060,800,null,{"$f":"SUM(AG4:AO4)","v":1205},{"$f":"M4*V4","v":200},{"$nulls":4},{"$f":"P4*U4","v":705},{"$f":"T4*X4","v":0},300,null,{"$f":"AQ4+AS4+AU4+AW4","v":1321.05},null,{"$f":"Q4-O4-AV4-AT4","v":22.5},{"$f":"ROUND(W4/174*AR4*1.5,2)","v":502.37},{"$f":"(P4-N4-R4)*11","v":27.5},{"$f":"ROUND(W4/174*AT4*2,2)","v":818.68},null,{"$f":"ROUND(W4/174*AV4*3,2)","v":0},{"$nulls":4},{"$f":"AA4+AF4+AP4+AX4+AY4+AZ4-BA4","v":7386.05},{"$f":"BD4+BE4+BG4+BH4","v":1625},{"$f":"ROUND(Y4*0.08,1)","v":742.8},{"$f":"ROUNDUP(Y4*0.02,1)","v":185.7},null,{"$f":"ROUNDUP(Y4*0.005,1)","v":46.5},{"$f":"ROUND(Z4*0.07,0)","v":650},{"$f":"BB4-BC4","v":5761.05},79.97,null,null,{"$f":"BI4-BJ4-BK4-BL4","v":5681.08}]
["研发","正式工","南通组","南通纳琳威","设备制造研发","设备服务部","研磨造粒分切生产","N100380","赵清清","zhaoqingqing@nalinv.cn","2021-07-19",null,1,21,168,26,217,{"$nulls":4},100,3000,null,5147,4565,4565,3000,765,800,null,400,100,{"$nulls":5},0,300,null,1750,null,9,{"$f":"ROUND(W5/174*AR5*1.5,2)","v":232.76},32,{"$f":"ROUND(W5/174*AT5*2,2)","v":1103.45},8,{"$f":"ROUND(W5/174*AV5*3,2)","v":413.79},{"$nulls":4},{"$f":"AA5+AF5+AP5+AX5+AY5+AZ5-BA5","v":6715},{"$f":"BD5+BE5+BF5+BG5+BH5","v":916.4},{"$f":"ROUND(Y5*0.08,2)","v":411.76},{"$f":"ROUND(Y5*0.02,1)","v":102.9},10,{"$f":"ROUND(Y5*0.005,2)","v":25.74},{"$f":"ROUNDUP(Z5*0.08,0)","v":366},5798.6,0,null,86,5712.6]
["生产","正式工","南通组","南通纳科达","生产制造中心","TPU涂布进口线","无","N100084","王为乐","wangweile@nalinwei.cn","2016-10-01",null,6,21,168,24,272,1,15,null,null,100,2280,null,12745,9509,6630,3000,1130,1500,1000,900,600,{"$nulls":5},0,300,null,2404.48,null,{"$f":"Q6-O6-AV6-AT6","v":71},{"$f":"ROUND(W6/174*AR6*1.5,2)","v":1395.52},{"$f":"(P6-N6-R6)*11","v":22},{"$f":"ROUND(W6/174*AT6*2,2)","v":576.54999999999995},{"$f":"R6*11","v":11},{"$f":"ROUND(W6/174*AV6*3,2)","v":432.41},4799,null,null,null,{"$f":"AA6+AF6+AP6+AX6+AY6+AZ6-BA6","v":14733.48},{"$f":"BD6+BE6+BF6+BG6+BH6","v":2109.23},{"$f":"ROUND(Y6*0.08,2)","v":1019.6},{"$f":"ROUND(Y6*0.02,1)","v":254.9},10,{"$f":"ROUND(Y6*0.005,2)","v":63.73},{"$f":"ROUNDUP(Z6*0.08,0)","v":761},12624.25,584.4,null,82,11957.85]
[{"$nulls":13},"目前手动导入",{"$nulls":6},"固定部分：基数标准",{"$nulls":5},"基本工资 = 基础工资 + 技能工资 + 保密工资 + 职位津贴",{"$nulls":4},"补贴合计 = 工龄补贴 + 职称补贴 + 环境补贴 + 租房补贴 + 交通补贴 + 餐费补贴 + 高温补贴 + 夜班补贴 + 其他福利补贴",{"$nulls":9},"加班费合计 = 固定加班费 + 平日加班费 + 周末加班费 + 节日加班费",{"$nulls":7},"目前手动导入",null,null,null,"应发工资 = 基本工资 + 补贴合计 + 加班费合计 + 绩效 + 提成 + 工资补款 - 工资扣款",{"$nulls":6},"计税工资 = 应发工资 - 个人四金扣款",null,null,null,"实发工资 = 计税工资 - 代扣上月个税 - 劳务个税 - 电费"]
[{"$nulls":31},"工龄补贴：= 工龄 × 工龄补贴标准，根据入职日期计算，比如计算6月薪资时，工龄日期统计截至到6月30日为满1年，100元/年，5年500元封顶",{"$nulls":9},"固定加班费：金额固定",{"$nulls":12},"个人四金扣款 = 养老保险 + 医疗保险 + 重疾补助 + 失业保险 + 住房公积金",{"$nulls":6},"目前手动导入"]
[{"$nulls":31},"餐费补贴：= 实际出勤天数 × 餐补标准",{"$nulls":9},"平日加班费 = 加班费基数/174*平日加班小时 *1.5，四舍五入保留2位小数",{"$nulls":12},"上海组 = 养老保险 + 医疗保险 + 失业保险 + 住房公积金"]
[{"$nulls":31},"夜班补贴：= 夜班天数 × 夜班补贴标准",{"$nulls":9},"周末加班费 = 加班费基数/174*周末加班小时 *2，四舍五入保留2位小数",{"$nulls":12},"养老保险 = 社保缴费基数 * 8%，四舍五入保留1位小数"]
[{"$nulls":31},"固定补贴：职称补贴、环境补贴、租房补贴、交通补贴",{"$nulls":9},"节日加班费 = 加班费基数/174*节日加班小时 *3，四舍五入保留2位小数",{"$nulls":12},"医疗保险 = 社保缴费基数 * 2%，进位保留1位小数"]
[{"$nulls":31},"目前手动导入：高温补贴、其他福利补贴",{"$nulls":9},"目前手动导入：平日加班小时，周末加班小时，节日加班小时",{"$nulls":12},"失业保险 = 社保缴费基数 * 0.5%，进位保留1位小数"]
[{"$nulls":54},"住房公积金 = 公积金缴费基数 * 7%，四舍五入到元"]
[{"$nulls":54},"南通组 = 养老保险 + 医疗保险 + 重疾补助 + 失业保险 + 住房公积金"]
[{"$nulls":54},"养老保险 = 社保缴费基数 * 8%，四舍五入保留2位小数"]
[{"$nulls":44},"174：月平均工作小时",{"$nulls":9},"医疗保险 = 社保缴费基数 * 2%，四舍五入保留1位小数"]
[{"$nulls":54},"重疾补助 = 10元/月/人"]
[{"$nulls":54},"失业保险 = 社保缴费基数 * 0.5%，四舍五入保留2位小数"]
[{"$nulls":44},"21.75：月平均工作日",{"$nulls":9},"住房公积金 = 公积金缴费基数 * 8%，进位到元"]

{"sheet":"Sheet1","index":1,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"10月","天","小时"]
[{"$nulls":6},18,144,null,"配置"]
[]
[{"$nulls":6},30,330,null,"工厂手动填写"]
[]
[{"$nulls":5},"加班",{"$f":"G10-G8","v":12},{"$f":"H10-H8","v":186},null,"自动计算"]
[]
[]
[{"$nulls":5},"节日加班",3,30,null,"手动填写"]
[]
[{"$nulls":5},"周末加班",{"$f":"G12-G15","v":9},{"$f":"G17*11","v":99},null,null,"按11小时"]
[]
[{"$nulls":5},"平日加班",null,{"$f":"H10-H8-H15-H17","v":57}]
[{"$nulls":13},"一人有多个薪资组"]