考勤表(自动汇总)

使用说明1.表格编辑前提示输入密码，请输入密码后在进行操作；2.本表格不允许插入、删除行、列3.表格编辑完毕后，请重新下拉并按顺序排列“项目编号”；4.表格编辑完毕后，请提前预览，根据实际页码，选择打印页数范围，以免造成纸张浪费；5.表格中灰色区域为自动生成部分，请勿进行编辑操作，否则会出现预设公式错误；6.请勿修改表格中预设值及数据，用下拉框选择的方式进行编辑，否则会出现编辑错误及计算结果不准确等。4.表格编辑完毕后，请提前预览，根据实际页码，选择打印页数范围，以免造成纸张浪费；5.表格中灰色区域为自动生成部分，请勿进行编辑操作，否则会出现预设公式错误；年月天12345678910111213141516171819202122232425262728293031周二元旦周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四调休年休事假病假工伤婚假丧假产假平时法定双休1000000000000000200000000000000030000000000000004000000000000000500000000000000060000000000000007000000000000000800000000000000090000000000000001000000000000000011000000000000000120000000000000001300000000000000014000000000000000150000000000000001600000000000000017000000000000000180000000000000001900000000000000020000000000000000公休调整员工签名当月共计姓名项目编码未入职旷工出勤公休请休假1考勤表2019已离职加班31XXXX部门/项目制表人：项目经理审核：行政部复核：总经理审核：第4页年月天12345678910111213141516171819202122232425262728293031周二元旦周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四调休年休事假病假工伤婚假丧假产假平时法定双休公休调整员工签名当月共计姓名项目编码未入职旷工出勤公休请休假1考勤表2019已离职加班31XXXX部门/项目2100000000000000022000000000000000230000000000000002400000000000000025000000000000000260000000000000002700000000000000028000000000000000290000000000000003000000000000000031000000000000000320000000000000003300000000000000034000000000000000350000000000000003600000000000000037000000000000000380000000000000003900000000000000040000000000000000制表人：项目经理审核：行政部复核：总经理审核：第5页年月天12345678910111213141516171819202122232425262728293031周二元旦周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四调休年休事假病假工伤婚假丧假产假平时法定双休公休调整员工签名当月共计姓名项目编码未入职旷工出勤公休请休假1考勤表2019已离职加班31XXXX部门/项目4100000000000000042000000000000000430000000000000004400000000000000045000000000000000460000000000000004700000000000000048000000000000000490000000000000005000000000000000051000000000000000520000000000000005300000000000000054000000000000000550000000000000005600000000000000057000000000000000580000000000000005900000000000000060000000000000000制表人：项目经理审核：行政部复核：总经理审核：第6页年月天12345678910111213141516171819202122232425262728293031周二元旦周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四调休年休事假病假工伤婚假丧假产假平时法定双休公休调整员工签名当月共计姓名项目编码未入职旷工出勤公休请休假1考勤表2019已离职加班31XXXX部门/项目6100000000000000062000000000000000630000000000000006400000000000000065000000000000000660000000000000006700000000000000068000000000000000690000000000000007000000000000000071000000000000000720000000000000007300000000000000074000000000000000750000000000000007600000000000000077000000000000000780000000000000007900000000000000080000000000000000制表人：项目经理审核：行政部复核：总经理审核：第7页年月天12345678910111213141516171819202122232425262728293031周二元旦周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四周五周六周日周一周二周三周四调休年休事假病假工伤婚假丧假产假平时法定双休公休调整员工签名当月共计姓名项目编码未入职旷工出勤公休请休假1考勤表2019已离职加班31XXXX部门/项目81000000000000000820000000000000008300000000000000084000000000000000850000000000000008600000000000000087000000000000000880000000000000008900000000000000090000000000000000910000000000000009200000000000000093000000000000000940000000000000009500000000000000096000000000000000970000000000000009800000000000000099000000000000000100000000000000000制表人：项目经理审核：行政部复核：总经理审核：第8页