Attendance data statistical analysis method and system

Abstract

The invention discloses an attendance data statistical analysis method and system. The attendance data statistical analysis method includes: collecting attendance data, using the MATLAB software to read attendance source data generated by different attendance systems, pre-processing the obtained attendance source data, and generating an attendance source data matrix; determining an all-day attendance status, and generating an all-day attendance status matrix and an overtime hour data matrix of all attendance personnel according to the attendance source data matrix and the all-day attendance status determination rule; performing attendance management statistics, performing attendance management statistics on related data in the all-day attendance status matrix and the overtime hour data matrix according to a preset attendance management statistical requirement, and generating an attendance management statistical data matrix; an automatically writing the attendance data into a data report, and automatically writing the attendance management statistical data matrix into an EXCEL time sheet through an MATLAB program. The method can solve the problem of automatic output archiving of thecustomized attendance data of enterprises, and can save human resources.

Description

technical field [0001] The invention belongs to the technical field of computer technology application, and in particular relates to the field of statistical analysis of MATLAB data applied to the statistical analysis of attendance data. Background technique [0002] Company attendance is a job that must be done by the HR department. Existing attendance methods include paper sign-in, clock-in machine, fingerprint clock-in machine, face recognition clock-in machine, and mobile terminal attendance clock-in. No matter which method is used for attendance, it is necessary to analyze the attendance data. The number of people in the company ranges from dozens to thousands of people according to the size of the company. Due to the many and complex characteristics of abnormal attendance data, generally each department will be equipped with a dedicated attendance officer to manage the attendance data, in order to obtain the leadership and human resources department. Due to the differ...

AI Technical Summary

Problems solved by technology

[0005] However, it can be seen from the above patents that in the prior art, EXCEL is mostly used for screening and processing the post-statistics of the data processing of the attendance system. If the corresponding data is extracted, multiple manual operations are still required. Fully automated office with special attendance statistical report output, and some attendance systems realize statistical mining of attendance data, but still cannot meet the customization requirements of enterprises

Images