2024excel表格工资表函数公式大全
2024年工资表-工资单-工资条 - 工资表 Unnamed: 0 职员工资表职工号152455615245571524558152455915245601524561152456215245631524564152456515245661524567152456815245691524570Unnamed: 1 姓名新发明1新发明2新发明3新发明4新发明5新发明6新发明7新发明8新发明9新发明10新发明11新发明12新发明13新发明14新发明15Unnamed: 2 部门人事部人事部财务部财务部教务部招生部教务部人事部人事部财务部财务部教务部招生部人事部财务部Unnamed: 3 入职日期2004-11-03 00:00:002005-07-27 00:00:002003-06-28 00:00:002002-08-15 00:00:002005-07-11 00:00:002007-10-12 00:00
2024年工资表-工资单 - Sheet1 Unnamed: 0 Unnamed: 1 工号员工姓名基本工资请 假社保公积金应发工资实发工资发放日期工号员工姓名基本工资请 假社保公积金应发工资实发工资发放日期Unnamed: 2 1250101张三5000200800800066881250103赵丽500020080080006688Unnamed: 3 员工工资单部门绩效工资旷 工个 税应扣工资员工工资单部门绩效工资旷 工个 税应扣工资Unnamed: 4 财务部2000100624506688员工签字财务部2000100624506688员工签字Unnamed: 5 44166岗位加班工资迟到早退罚 款代扣工资44166岗位加班工资迟到早退罚 款代
2024年工资表-工资自动计算 - Sheet1 Unnamed: 0 基本工资表 公司名称：员工编号BH-001BH-002BH-003BH-004BH-005BH-006BH-007BH-008BH-009BH-010BH-011BH-012BH-013BH-014BH-015BH-016BH-017BH-018BH-019合计Unnamed: 2 员工姓名大大1大大2大大3大大4大大5大大6大大7大大8大大9大大10大大11大大12大大13大大14大大15大大16大大17大大18大大19Unnamed: 3 基本工资300030003000300030003000400040004000400050005000500050005000500050005000500079000Unnamed: 4 岗位工资100020001000300010002000100030001000200010003000100020001000300030002000100034000Unnamed: 5
2024年自动工资条—工资表 - Sheet1 Unnamed: 0 工 资 条—自 动 编制单位：序号1工 资 条—自 动编制单位：序号2工 资 条—自 动编制单位：序号3工 资 条—自 动编制单位：序号4Unnamed: 2 姓名可可姓名皮皮姓名姓名Unnamed: 3 基本工资2000基本工资3000基本工资基本工资Unnamed: 4 考勤 天数28考勤 天数27考勤 天数考勤 天数Unnamed: 5 应发工资工 资2000应发工资工 资2892应发工资工 资应发工资工 资Unnamed: 6 绩效奖金1500绩效奖金2500绩效奖金绩效奖金Unnamed: 7 津贴补助1000津贴补助1000津贴补助津贴补助Unnamed: 8 加班费1500加班费1200加班费加班费Unnamed: 9 合 计
2024年工资表（工资条自动生成） - 工资表 Unnamed: 0 Unnamed: 1 工 资 表公司名称：编号512901512902512903512904合计Unnamed: 2 姓 名张三李四小周小赵Unnamed: 3 部门财务部人事部技术部工程部Unnamed: 4 基本工资800080006000500027000Unnamed: 5 出勤天数25282729109Unnamed: 6 加班工资3005003005001600Unnamed: 7 应发工资奖金300100300100800Unnamed: 8 加班工资100100100100400Unnamed: 9 合计870087006700570029800Unnamed: 10 应扣工资缺勤天数21115Unnamed: 11 考勤扣款100100200Unnamed: 12 业务罚款150200350Unnamed: 13 合计2501000200550Unnamed
2024工资表&工资单exce表格 - 工资表 Unnamed: 0 Unnamed: 1 员工工资表公司名称：员工工号101001101002101003101004101005101006101007101008101009101010合计Unnamed: 2 科技技术有限公司姓名员工1员工2员工3员工4员工5员工6员工7员工8员工9员工10Unnamed: 3 部门部门1部门2部门3部门4部门5部门6部门7部门8部门9部门10Unnamed: 4 基本工资300030004000350050003000300040003500500037000Unnamed: 5 加班工资500500100015005005005001000
2025年薪资工资表-工资条 - 工资数据源 Unnamed: 0 工资表工号G25431G25432G25433G25434G25435G25436G25437Unnamed: 1 姓名琳琳芳芳呵呵甜甜朱朱婷婷柳林Unnamed: 2 出勤26262626262626Unnamed: 3 入职日期2020-01-01 00:00:002020-02-01 00:00:002020-03-05 00:00:002020-01-01 00:00:002020-02-01 00:00:002020-03-05 00:00:002020-01-01 00:00:00Unnamed: 4 基本工资3000300030003000300030003000Unnamed: 5 绩效500500500500500500500Unnamed: 6 全勤100100100100100100100Unnamed: 7 奖金2981114410282746Unnamed: 8 加班7005001000280.62216.58Unnamed: 9 应发
2025年员工工资表(工资条) - Sheet1 Unnamed: 0 Unnamed: 1 员工工资表(工资条)序号12345678910序号1序号2序号3序号4序号5Unnamed: 2 姓名张三李四王三李倩吴曦张三李四王三李倩吴曦姓名张三姓名李四姓名王三姓名李倩姓名吴曦Unnamed: 3 部门生产部行政部企划部销售部企划部生产部行政部企划部销售部企划部部门生产部部门行政部部门企划部部门销售部部门企划部Unnamed: 4 职务主管文职策划员销售员策划员主管文职策划员销售员策划员职务主管职务文职职务策划员职务销售员职务策划员Unnamed: 5 出勤天数222827282628.629.430.2000000000000033131.8出勤天数22出勤天数22024excel表格工资表函数公式大全
2025年工资表-工资结算 - Sheet1 Unnamed: 0 工 资 表 序号123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117Unnamed: 2 姓 名Unnamed: 3 基本工资Unnamed: 4 加班费Unnamed: 5 养老保险Unnamed: 6 失业保险Unnamed: 7 医疗保险Unnamed: 8 工伤保险Unnamed: 9 生育保险Unnamed: 10 公积金Unnamed: 11 考勤扣款Unnamed: 12 应发工资00......
2025年工资表工资条（自动计算） - Sheet1 Unnamed: 0 Unnamed: 1 工资表/工资条姓名李梅周丽丽财务：姓名Unnamed: 2 实际出勤2526实际出勤Unnamed: 3 应出天数2626应出天数Unnamed: 4 应发工资基本工资25002500应发工资基本工资Unnamed: 5 出勤工资24042500出勤工资Unnamed: 6 考核工资00考核工资Unnamed: 7 奖金00工资条（自动计算）奖金Unnamed: 8 应发工资24042500经理：应发工资Unnamed: 9 扣款项目旷工天数00扣款项目旷工天数Unnamed: 10 旷工扣款00旷工扣款Unnamed: 11 罚款050罚款Unnamed: 12 其他00其他Unnamed: 13 扣款小计05000000000000000000000000扣款小计Unnamed
2025年工资表-工资条 - 工资数据源 Unnamed: 0 工资表工号G25431G25432G25433G25434G25435G25436G25437Unnamed: 1 姓名琳琳芳芳呵呵甜甜朱朱婷婷柳林Unnamed: 2 岗位部长部长员工员工员工部长组长Unnamed: 3 入职日期2019-03-01 00:00:002019-03-02 00:00:002019-03-03 00:00:002019-03-04 00:00:002019-03-05 00:00:002019-03-06 00:00:002019-03-07 00:00:00Unnamed: 4 基本工资9000800070005000420090006000Unnamed: 5 工龄补贴6469564986162981114410Unnamed: 6 全勤70070090010007005001000Unnamed: 7 奖金2981114410282746Unnamed: 8 加班7005001000280.62
2025年职员工资表-工资条 - 工资表 工 资 表 姓名姓名1姓名2姓名3姓名4姓名5Unnamed: 1 职位Unnamed: 2 职位级别Unnamed: 3 出 勤天数2830303030Unnamed: 4 实出勤3032263030合计Unnamed: 5 职位奖金Unnamed: 6 月工资5000500050005000500025000Unnamed: 7 绩效 补贴2002003004005001600Unnamed: 8 其它补贴0Unnamed: 9 加班 天数224Unnamed: 10 加班 工资357.142857142857333.3333333333330000000000000000000000690.47619047619Unnamed: 11 全勤奖0Unnamed: 12 绩效奖金0Unnamed: 13 其他 补助0Unnamed: 14 应发 工资5557.142857142865533.33333333333
2025年美容美发店工资表-工资条 - 工资表 Unnamed: 0 美容美发店工资表序号1234567891011121314151617181920Unnamed: 1 姓名王紫菲审美成童子可Unnamed: 2 岗位店长美容师美容师Unnamed: 3 基本工资220018001800Unnamed: 4 本月业绩额33548124500254000Unnamed: 5 业绩提成3354.81245025400Unnamed: 6 手工费1254230898Unnamed: 7 工龄工资100100100Unnamed: 8 全勤奖5050Unnamed: 9 奖励000Unnamed: 10 缺勤扣款650Unnamed: 11 惩罚扣款000Unnamed: 12 应发工资6958.8139302824800000000000000000工资条 Unnamed: 0 工 资 条序号1序号2序号3Unnamed: 1 姓名王紫菲姓名
2025年工资表-工资条 - 工资表 Unnamed: 0 1.02.03.04.05.06.07.08.09.010.011.012.013.014.015.016.017.018.019.020.021.022.023.024.025.026.027.028.029.030.031.032.033.034.035.036.037.038.039.040.041.042.043.044.045.046.047.048.049.050.051.052.053.054.055.056.057.058.059.060.061.062.063.064.065.066.067.068.069.070.071.072.073.074.075.076.077.078.079.080.081.082.083.084.085.086.087.088.089.090.091.092.093.094.095.096.097.098.099.0100.0101.0102.0103.0104.0105.0106.0107.0108.0109.0110.0111.0112.0113.0114.0115.0116.0117.0118.0
2025年工资表-工资结算 - Sheet1 Unnamed: 0 Unnamed: 1 工 资 表序号123456789Unnamed: 2 编号TT001-2TT001-3TT001-4TT001-5TT001-6TT001-7TT001-8TT001-9TT001-10合计Unnamed: 3 姓名王小虎谢东三邓晓三建明有樊千钧徐芳裕华王晓燕何通远Unnamed: 4 班组二一班二一班二一班二一班二一班二一班二一班二一班二一班Unnamed: 5 岗位小组长上工小组长上工小组长上工小组长上工小组长Unnamed: 6 白班天数151515151515151515Unnamed: 7 夜班天数151515151515151515135Unnamed: 8 缺勤情况病假111418Unnamed: 9 事假1214Unnamed: 10 旷工1315Unnamed: 11 其它0Unname
2025年工资表-工资条 - 工资源 Unnamed: 0 Unnamed: 1 儿有限公司12月工资表序号1234567891011合 计Unnamed: 2 公司公司1公司1公司1公司1公司1公司6公司7公司8公司9公司10Unnamed: 3 部门售后部售后部项目部售后部客服部客服部售后部行政部售后部客服部Unnamed: 4 姓 名姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10Unnamed: 5 应 发 工 资基本工资80008001800280038004800580068007800880098010Unnamed: 6 工龄工资Unnamed: 7 绩效工资Unnamed: 8 全勤奖金Unnamed: 9 职务津贴Unnamed: 10 岗位津贴Unnamed: 11 通讯补贴Unnamed: 12 合 计 金 2024excel表格工资表函数公式大全
2024年工资表-工资表模板 - Sheet1 Unnamed: 0 Unnamed: 1 工资表员工编号H-001H-002H-003H-004H-005H-006H-007H-008H-009H-010合计所属月份Unnamed: 2 姓名12345678910Unnamed: 3 所属部门财务部技术部销售部人事部产品部财务部技术部销售部人事部产品部Unnamed: 4 岗位岗位1岗位2岗位3岗位4岗位5岗位6岗位7岗位8岗位9岗位10Unnamed: 5 本月应出勤天数30303030303030303030300发放月份Unnamed: 6 实际出勤天数28282930292828293029288Unnamed: 7 应发工资基本工资500060007000900050006000700080006000700066000Unnamed: 8 岗位工资3003003003003003003003003003003
2025年智能工资表-工资条 - 生成工资条 Unnamed: 0 工 资 表序号1234567891011121314Unnamed: 1 姓名姓名1姓名2姓名3姓名4姓名5姓名6姓名7姓名8姓名9姓名10姓名11姓名12姓名13姓名14Unnamed: 2 出勤天数Unnamed: 3 加班费Unnamed: 4 绩效Unnamed: 5 全勤Unnamed: 6 奖金200176200200200200200200112113114115Unnamed: 7 补贴300176200200200200200300168169170171Unnamed: 8 其它100Unnamed: 9 月薪60006000600060006000600060006000600060006000600060006000Unnamed: 10 应付工资60006500635264006000640064006500640065006280628262846286Unnamed: 11 缺勤扣款1801
工资表-工资单查询 - Sheet1 Unnamed: 0 Unnamed: 1 工资表-工资单查询编号12345678合计本月用人数：8人Unnamed: 2 工号D1567D1568D1569D1570D1571D1572D1573D1574Unnamed: 3 姓名王丽郓城小丽小李乐乐莉莉小伞文文Unnamed: 4 入职日期2013-05-07 00:00:002013-05-08 00:00:002013-05-09 00:00:002013-05-10 00:00:002013-05-11 00:00:002013-05-12 00:00:002013-05-13 00:00:002013-05-14 00:00:00Unnamed: 5 基本工资5000300050005001500250035004500538015Unnamed: 6 出勤天数2626252627282930217Unnamed: 7 奖励补100100100100100100100100800Unnamed: 8 加
2025年人事管理工资表（工资条打印） - Sheet1 Unnamed: 0 Unnamed: 1 工资表（含工资条）姓名姓名Unnamed: 2 实际出勤实际出勤Unnamed: 3 应出天数应出天数Unnamed: 4 银行卡号Unnamed: 5 开户行Unnamed: 6 应发工资基本工资应发工资基本工资Unnamed: 7 出勤工资出勤工资Unnamed: 8 考核工资考核工资Unnamed: 9 奖金工资条（自动计算）奖金Unnamed: 10 应发工资应发工资Unnamed: 11 扣款项目旷工天数扣款项目旷工天数Unnamed: 12 旷工扣款旷工扣款Unnamed: 13 罚款罚款Unnamed: 14 其他其他Unnamed: 15 扣款小计00000000000000000000000扣款小计Unnamed: 16 结余工资00000000000000
