2025excel自动标识法定节假日

2025年自动化考勤表 - Sheet1 Unnamed: 0 考勤表 星期姓名备注： 出勤：√ 迟到：△ 缺勤× 事假：S 病假：B Unnamed: 2 三1Unnamed: 3 四2Unnamed: 4 五3Unnamed: 5 六4Unnamed: 6 日5Unnamed: 7 一6Unnamed: 8 二7Unnamed: 9 三8Unnamed: 10 四9Unnamed: 11 五10Unnamed: 12 六11Unnamed: 13 日12Unnamed: 14 一13Unnamed: 15 二14Unnamed: 16 三15Unnamed: 17 四16Unnamed: 18 五17Unnamed: 19 六18Unnamed: 20 日19Unnamed: 21 一20Unnamed: 22 二21Unnamed: 23 三22Unnamed: 24 四23Unnamed: 25 五24Unnamed: 26 六25Unnamed: 27 日26Unnamed: 28 一27U

2025年自动统计工装发放登记表 - Sheet1 Unnamed: 0 Unnamed: 1 日期2020-10-18 00:00:002020-10-19 00:00:002020-10-22 00:00:002020-10-22 00:00:002020-10-22 00:00:002020-10-23 00:00:00Unnamed: 2 工装发放自动统计表 Work clothes distribution registration form姓名员工1员工2员工3员工4员工5员工6Unnamed: 3 部门生产部生产部行政部行政部生产部总办Unnamed: 4 类型春秋装春秋装春秋装春秋装春秋装春秋装Unnamed: 5 上装尺码MLSXLMSUnnamed: 6 颜色灰灰深蓝深蓝灰深蓝Unnamed: 7 件数111111Unnamed: 8 下装尺码LLLXLMLUnnamed: 9 颜色灰灰黑深蓝灰黑Unnamed: 10

2025年自动生成工资条 - 工资表 工 资 表 姓名姓名1姓名2姓名3姓名4姓名5合计Unnamed: 1 在职岗位Unnamed: 2 出勤天数2830303030Unnamed: 3 实出勤天数3032263030Unnamed: 4 月工资5000500050005000500025000Unnamed: 5 加班天数224Unnamed: 6 加班工资357.142857142857333.3333333333330000000000000000000000690.47619047619Unnamed: 7 全勤奖0Unnamed: 8 其它奖金0Unnamed: 9 应发工资5357.142857142865333.33333333333500050005000000000000000000000025690.4761904762Unnamed: 10 缺勤天数44Unnamed: 11 缺勤扣款00666.6666666666670000000000000000000006

2025年自动计算工资表 - Sheet1 Unnamed: 0 工资表（单位：人民币元） 工号1230612307123081230912310123111231212313123141231512316123171231812319123201232112322123231232412325合计Unnamed: 2 姓名Unnamed: 3 入职日期Unnamed: 4 底薪3000300030003000300030003000300030003000300030003000300030003000300051000Unnamed: 5 岗位工资50050050010008008018028038048058068078089736Unnamed: 6 综合补贴1001001001011021031041051061071081091101111466Unnamed: 7 出差补助000000000000000000000Unnamed: 8 工资代扣社保基数00000000000000000000

2025年自动统计考勤表-通用版 - Sheet1 Unnamed: 0 考勤表-自动统计表 部门名称： 日期 岗位代码： 出勤 √ 事假 U 病假 〇 年休 N 婚丧假 Δ 产假 Φ 陪产假 P 工伤 G 其他 Z（含迟到、早退等） 考勤员签字： 部门负责人签字： 主管经理签字:Unnamed: 2 Unnamed: 3 时间上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午Unnamed: 4 1一 Unnamed: 5 2二Unnamed: 6 3三Unname

2025年自动计算实用工资表 - Sheet1 Unnamed: 0 自动计算工资发放表 2019年3月1日-2019年3月15日序号12345678910111213制表：Unnamed: 2 用人项目机构合计Unnamed: 3 聘用人员姓名张明审核：Unnamed: 4 工作天数2525Unnamed: 5 每日薪金200200Unnamed: 6 其他扣除200Unnamed: 7 实发薪金48000000000000004800Unnamed: 8 领取人签名批准：Unnamed: 9 备注Sheet3

2025年自动统计考勤表 - Sheet1 Unnamed: 0 自 动 统 计 考 勤 表 部门：序号注：Unnamed: 2 姓名√ 出勤□ 值班各部门应于每月3日前将本考勤表送至人力资源部Unnamed: 3 时间上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午上午下午Unnamed: 4 1√√√√√√√√√√√√√√√√√√√√√√√√√√√√O 事假Unnamed: 5 2√√√√√√√√√√√√√√√√√√√√√√√√√√√√▲ 产假Unnamed: 6 3√√√√√√√√√√√√√√√√√√√√√√√√√√√√Unnamed: 7 4√√√√√√√√√√√√√√√√√√√√

2025年自动统计考勤表 - Sheet1 Unnamed: 0 自 动 统 计 考 勤 表 2019-03-04 16:24:49序号123456789101112131415考勤员：注：Unnamed: 2 姓名各部门应于每月5日前将本考勤表送至办公室Unnamed: 3 1√√√√√√√√√√√√√√√√√√√√√√√√√√√√√√Unnamed: 4 2√√√√√√√√√√√√√√√√√√√√√√√√√√√√√√迟到：◆Unnamed: 5 3√√√√√√√√√√√√√√√√√√√√√√√√√√√√√√Unnamed: 6 4√√√√√√√√√√√√√√√√√√√√√√√√√√√√√√Unnamed: 7 5√2025excel自动标识法定节假日

2025年自动化幼儿园学生登记表 - Sheet1 Unnamed: 0 Unnamed: 1 序 号123456789101112Unnamed: 2 幼儿园学生登记分析表姓名幼儿1幼儿2幼儿3幼儿4幼儿5幼儿6幼儿7幼儿8幼儿9幼儿10幼儿11幼儿12Unnamed: 3 年级托班中班大班小班托班中班中班托班小班托班中班托班Unnamed: 4 班级2班2班1班2班1班2班3班1班3班1班2班2班Unnamed: 5 性别女男女女男女女男男女女男Unnamed: 6 身份证号码13020820140201002813020820140201002813020820140201002813020820140201002813020820140201002813020820140201002813020820140201002813020820140201002813020820140201002813020820140201002

2025年自动计算收支表 - 日报表 自动计算收支表 项目现金现金小计：银行银行小计合计Unnamed: 1 序号112Unnamed: 2 类型出纳银行银行Unnamed: 3 期初结存余额000Unnamed: 4 本日收入交款人Unnamed: 5 科目名称Unnamed: 6 金额000Unnamed: 7 备注Unnamed: 8 本日支出领款人Unnamed: 9 科目名称Unnamed: 10 金额000Unnamed: 11 备注Unnamed: 12 期末结存余额000000

2025年自动计算工资表-临时工 - Sheet1 Unnamed: 0 自动计算工资表-临时工 2019-05-01 00:00:00序号123456789101112131415制表：Unnamed: 2 用人项目机构合计Unnamed: 3 聘用人员姓名张明xxxxxxxxxxxxxxxxxxxxxxxxxxxx审核：Unnamed: 4 工作天数252525252525252525252525252525375Unnamed: 5 每日薪金2002002002002002002002002002002002002002002003000Unnamed: 6 其他扣除200200200200200200200200200200200200200200200Unnamed: 7 考勤扣款505050505050505050505050505050Unnamed: 8 实发薪金47504750475047504750475047504750475047504750475047504750475071250Unnamed

2025年自动计算出入库明细表（带公式） - Sheet1 Unnamed: 0 出入库统计表—明细表单位： 盘点时间：序号1234567891011121314151617181920212223242526Unnamed: 1 物品名称合计Unnamed: 2 编号Unnamed: 3 规格Unnamed: 4 单位Unnamed: 5 单价Unnamed: 6 原始库存0Unnamed: 7 出库数量0Unnamed: 8 入库数量0Unnamed: 9 结余库存00000000000000000000000000Unnamed: 10 总价00000000000000000000000000Unnamed: 11 盘点人Sheet2 Sheet3

2025年自动计算账目明细表 - 四月份 账目明细表 编码合计Unnamed: 1 时间Unnamed: 2 办事人员Unnamed: 3 收入明细Unnamed: 4 收入费用0Unnamed: 5 支出明细Unnamed: 6 支出费用0Unnamed: 7 利润0五月份 五月份账目明细表 编码0001120000114000011500001160000117合计Unnamed: 1 时间2013.4.12013.4.22013.4.32013.4.42013.4.5Unnamed: 2 办事人员张某李某胡某小阳Unnamed: 3 收入明细收到XX公司的服务费收到张某的退款Unnamed: 4 收入费用1000090010900Unnamed: 5 支出明细购买原材料购买办公用品Unnamed: 6 支出费用59912341833Unnamed: 7 利润9067Unnamed: 8 如左边

2025年自动计算出入库明细表（带公式） - Sheet1 出入库明细表 单位： 盘点时间：序号1234567891011121314151617181920212223242526Unnamed: 1 物品名称合计Unnamed: 2 编号Unnamed: 3 规格Unnamed: 4 单位Unnamed: 5 单价Unnamed: 6 原始库存0Unnamed: 7 出库数量0Unnamed: 8 入库数量0Unnamed: 9 结余库存00000000000000000000000000Unnamed: 10 总价00000000000000000000000000Unnamed: 11 盘点人Sheet2 Sheet3

2025年自动计算收入支出明细表 - Sheet1 收入支出明细表 序 号123456789101112131415合计Unnamed: 1 日期Unnamed: 2 收入项目明细Unnamed: 3 金额0Unnamed: 4 备注Unnamed: 5 Unnamed: 6 序 号123456789101112131415合计Unnamed: 7 日期Unnamed: 8 支出项目明细Unnamed: 9 金额0Unnamed: 10 备注Sheet2 Sheet3

2025年自动统计幼儿园学位预定表 - Sheet1 Unnamed: 0 Unnamed: 1 幼儿园学位预定统计表序号12注：本表由招生负责人填写，财务部存档。Unnamed: 2 日期2021-01-05 00:00:002021-01-05 00:00:00Unnamed: 3 宝宝姓名姓名1姓名2Unnamed: 4 性别男女Unnamed: 5 年龄34Unnamed: 6 2已定人数预定班级托班小班Unnamed: 7 班主任鹿老师张老师Unnamed: 8 1已交费已交学位费□是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否 □是 □否2025excel自动标识法定节假日

2025年自动计算库存盘点表 - Sheet1 Unnamed: 0 Unnamed: 1 可视化库存盘点表 Warehouse inventory物料号C-0001C-0002C-0003C-0004C-0005C-0006C-0007C-0008C-0009C-0010C-0011C-0012Unnamed: 2 品名A产品B产品C产品 D产品 E产品F产品G产品H产品I产品J产品K产品L产品Unnamed: 3 货位A-2517-3A-2517-1A-1103-1B-1101-1C-1102-2D-1110-1D-1110-2D-1110-3D-1110-4D-1110-5D-1110-6D-1110-7Unnamed: 4 单位台台台台台台台台台台台台Unnamed: 5 账面情况期初数量30151053153015105315Unnamed: 6 本期入库2520351013525203510135Unnamed: 7 本期出库10253013101310253013101

2025年自动生成日期统计考勤表 - Sheet1 Unnamed: 0 Unnamed: 1 人事考勤统计表（自动） Personnel attendance sheet序号123Unnamed: 2 姓名张三刘五李四Unnamed: 3 21√√√Unnamed: 4 32√√√Unnamed: 5 43√差迟Unnamed: 6 54√差差Unnamed: 7 65√差√Unnamed: 8 日6病√√Unnamed: 9 17事差√Unnamed: 10 28差迟√Unnamed: 11 39差病√Unnamed: 12 2020410差病√Unnamed: 13 年511事×√Unnamed: 14 12612√×Unnamed: 15 月日13迟Unnamed: 16 114√事Unnamed: 17 215×事Unnamed: 18 员工总数316迟Unnamed: 19 417差Unnamed: 20 3518迟Unnamed: 21 619迟Unnamed: 22 日20Unnamed: 23 正常12

2025年自动考勤表 - Sheet1 考勤表 部门：姓名甲乙丙丁戊己庚辛壬癸甲乙丙丁戊己庚辛备注： 出勤：√ 迟到：迟 旷工：× 请假：假 休假：休Unnamed: 1 1√√√√√√√√√√√√√√√√√√Unnamed: 2 2√√√√√√√√√√√√√√√√√√Unnamed: 3 3√√√√√√√√√√√√√√√√√√Unnamed: 4 4迟迟迟迟迟迟迟迟迟迟迟迟迟迟迟迟迟迟Unnamed: 5 5√√√√√√√√√√√√√√√√√√Unnamed: 6 6√√√√√√√√√√√√√√√√√√Unnamed: 7 7√√√√√√√√√√√√

2025年自动统计考勤表 - Sheet1 Unnamed: 0 Unnamed: 1 自动统计考勤表 Automatic statistics of attendance shee序号12345678910111213141516171819202122232425Unnamed: 2 姓名姓名1姓名2Unnamed: 3 1√√Unnamed: 4 2√√Unnamed: 5 3√√Unnamed: 6 4√√Unnamed: 7 5√√Unnamed: 8 6.0Unnamed: 9 7.0Unnamed: 10 8差Unnamed: 11 9差Unnamed: 12 10√√迟Unnamed: 13 11√√Unnamed: 14 12√√迟Unnamed: 15 13.0Unnamed: 16 14.0Unnamed: 17 15√√Unnamed: 18 16√迟病Unnamed: 19 17√√病Unnamed: 20 18√√Unnamed: 21 19√√Unnamed: 22 20.0Unnamed: 23 21婚Unna