智能工资管理系统.xlsx

工资管理系统考勤表考勤统计表税率表工资明细表银行发放表工资条批量打印系统设置使用说明员工明细查询其他奖励扣款使用说明1、查询和刷新功能需要VBA支持，WPS用户需要安装插件，下载地址如下。链接:https://pan.baidu.com/s/1hPgSq1Bf22mlVm9gyOfUdA密码:9dw72、需要开启宏后使用，依次点击【开发工具】选项卡-【宏安全性】-【低】密码:9dw7第4页，共87页考勤表2019年出勤休假事假病假旷工迟到严重迟到003月√●△╋×※◇姓名五六日一二三四五六日一二三四五六日一二三四五六日一二三四五六日备注12345678910111213141516171819202122232425262728293031出勤休假事假病假旷工迟到张三√√√√√√●☆×△◇※8110111张四√△△●√●╋2221000张五0000000李六0000000可我看0000000你好0000000就的00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000本月应出勤24严重迟到主页第5页，共87页0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000第6页，共87页00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000第7页，共87页法定假日123年份序符号类型名20191√出勤√20202●休假●20103△事假△4╋病假╋5×旷工×6※迟到※7◇严重迟到◇2017120182201932020420215202262023720248202592026102043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100编号姓名部门应出勤天数实出勤天数缺勤天数旷工天数病假天数D0001张三生产部2481610D0002张四生产部2422201D0003张五生产部2402400D0004李六生产部2402400D0005可我看2402400D0006你好2402400D0007就的2402400事假天数迟到次数严重迟到次数考勤扣款合计日工资1115746.61333.33200916.7441.670001999.9283.330003000125000000000000主页编...