考勤系统自动生成工资单表

,员工基本信息一览表,序号工号姓名性别身份证号码部门职务主管工衣尺码工鞋尺码入职日期本人电话家庭地址紧急联系人关系联系电话状态,1.0100001.0员工1离职,2.0100002.0员工2,3.0100003.0员工3,4.0100004.0员工4,5.0100005.0员工5,6.0100006.0员工6,7.0100007.0员工7,8.0100008.0员工8,9.0100009.0员工9,10.0100010.0员工10,11.0100011.0员工11,12.0100012.0员工12,13.0100013.0员工13,14.0100014.0员工14,15.0100015.0员工15,16.0100016.0员工16,17.0100017.0员工17,18.0100018.0员工18,19.0100019.0员工19,20.0100020.0员工20,21.0100021.0员工21,22.0100022.0员工22,23.0100023.0员工23,24.0100024.0员工24,25.0100025.0员工25,26.0100026.0员工26,27.0100027.0员工27,考勤表,日期：2020.0年1.0月,43831.043832.043833.043834.043835.043836.043837.043838.043839.043840.043841.043842.043843.043844.043845.043846.043847.043848.043849.043850.043851.043852.043853.043854.043855.043856.043857.043858.043859.043860.043861.0,序号工号姓名 日期,部门1.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.0出勤,天数休息,天数夜班,天数,考勤表,日期：2020.0年月,43831.043832.043833.043834.043835.043836.043837.043838.043839.043840.043841.043842.043843.043844.043845.043846.043847.043848.043849.043850.043851.043852.043853.043854.043855.043856.043857.043858.043859.043860.043861.0,序号工号姓名 日期,部门6.07.09.011.012.013.014.015.016.017.018.019.020.023.024.025.026.027.028.029.030.031.0出勤,天数休息,天数夜班,天数,100001.0员工1旷,100002.0员工2事,100003.0员工3病,100004.0员工4年,100005.0员工5其,6.0100006.0员工6,7.0100007.0员工7,100008.0员工8,9.0100009.0员工9,100010.0员工10,11.0100011.0员工11,12.0100012.0员工12,13.0100013.0员工13,14.0100014.0员工14,15.0100015.0员工15,16.0100016.0员工16,17.0100017.0员工17,18.0100018.0员工18,19.0100019.0员工19,20.0100020.0员工20,100021.0员工21,100022.0员工22,23.0100023.0员工23,24.0100024.0员工24,25.0100025.0员工25,26.0100026.0员工26,27.0100027.0员工27,自动生成工资条,1.0100001.0员工11800.0540.0200.0651.724137931827.586206897-116.7816091953902.52873563413.668045977234.15172413819.03235.70896552,100002.0员工21800.0540.0200.0651.724137931827.586206897-29.19540229893990.11494253422.952183908239.40689655219.03308.75586207,100003.0员工31801.0540.3201.0652.086206897828.045977011-12.42068965524010.01149425425.061218391240.60068965520.03324.34958621