CN108921496A - A kind of attendance data statistical analysis technique and system - Google Patents
A kind of attendance data statistical analysis technique and system Download PDFInfo
- Publication number
- CN108921496A CN108921496A CN201810563438.9A CN201810563438A CN108921496A CN 108921496 A CN108921496 A CN 108921496A CN 201810563438 A CN201810563438 A CN 201810563438A CN 108921496 A CN108921496 A CN 108921496A
- Authority
- CN
- China
- Prior art keywords
- attendance
- state
- checking
- matrix
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Attendance data statistical analysis technique disclosed by the invention and system, including:Attendance data summarizes, and reads the attendance source data that different attendance checking systems generate using MATLAB software, pre-processes to the attendance source data got, and generate attendance source data matrix;Whole day checking-in state determines, generates all whole day checking-in state matrixes and overtime hours data matrix for participating in attendance personnel according to attendance source data matrix and whole day checking-in state decision rule;Attendance management statistics carries out attendance management statistics to the related data in whole day checking-in state matrix and overtime hours data matrix, and generate attendance management statistical data matrix according to preset attendance management statistical requirements;Attendance data automatically writes data sheet, is automated attendance management statistical data matrix in write-in EXCEL Attendance Sheet by MATLAB program.Through the invention, it can solve enterprise's customization attendance data automation output archive problem, to save human resources.
Description
Technical field
The invention belongs to computer technology applied technical fields, and in particular to a kind of by MATLAB data statistic analysis application
Field is statisticallyd analyze to attendance data.
Background technique
Company's attendance is the work that Human Resource Department must complete.Existing attendance mode has papery to register, and punched-card machine refers to
Line punched-card machine, recognition of face punched-card machine, mobile terminal attendance are checked card, regardless of which kind of mode to carry out attendance using, to attendance data
It is necessary for carrying out analysis.Company man's number according to number scale from tens of people to thousands etc., due to attendance data exception feelings
The more and complicated feature of condition, general each department can be equipped with special timekeeper and carry out attendance data management, to obtain leadership
And all data needed for Human Resource Department, due to the different managerial style of each company, required data and disunity, i.e.,
Make to be that the attendance recorder of included checking-in result is also difficult the statistical analysis demand for meeting company about attendance data.Existing attendance data
Analysis mostly uses EXCEL analysis or artificial treatment, regardless of which kind of mode can all cause waste of human resource using, and exists
Certain human error.How to realize that attendance data automates batch processing, realize the intelligence of attendance data, completes " last
Human resources are saved in the relay of kilometer ", and acquisition authentic data source is supplied to Human Resource Department and relevant departments are when business
It is anxious.The processing of attendance data record belongs to big data processing scope, and the MATLAB software of MathWorks company is in research and production and work
Possess a large number of users in industry production, in data analysis field, which is conventional data analysis professional software, at big data
Managing general step is the processes such as data collection, data cleansing, data analysis modeling.
A kind of attendance data analysis method of patent 201010142057.7 and system disclose a kind of attendance data analysis side
Method, including:Obtain the attendance period in attendance data and at least one wait for attendance point to attendance point information;Based on each described
To attendance point, generate respectively one group it is corresponding to attendance face data;Attendance face is waited for by every group of the attendance data of acquisition and generation
Data are compared, and find out attendance normal data and attendance abnormal data;By the attendance normal data found out and attendance exception number
It is identified according on electronic map platform, generates and shows attendance data figure layer.By the invention, attendance management personnel can be kept away
Exempt to read and handle a large amount of attendance data, substantially increase the working efficiency of attendance management, while but also attendance management more
It is convenient, intuitive.
A kind of intelligent Checking on Work Attendance management analysis method of patent CN201510664730.6 discloses a kind of intelligent Checking on Work Attendance management point
Analysis method, including:Attendance data is acquired by attendance record terminal;It is united according to the Analysis And Evaluation standard of setting to attendance data
Meter marking and intellectual analysis obtain the attendance marking of attendance personnel, attendance rule, anomaly regularity, tend to rule and the state that is on duty;
Evaluation, trend description, rule description and the marking of attendance personnel are exported according to the result of intellectual analysis.The invention can be to attendance
Details is further analyzed and counts, and more comprehensively, Human Resources Department is enable to grasp the psychology element of employee in time in attendance data
Matter and the state being on duty, it is more convenient and effective.
But from above-mentioned patent as it can be seen that the prior art about attendance checking system data processing later period statistics mostly use EXCEL into
Row Screening Treatment, if extracting corresponding data, it is still necessary to which multiple manual operation screening cannot achieve from attendance data to enterprise
The full-automatic office of the dedicated work attendance statistics report output of required customization data, also has part attendance checking system to realize attendance data
Statistics excavate, but still it is impossible to meet the customization of enterprise requirements.
Summary of the invention
To solve the above problems, the present invention carries out modeling analysis using MATLAB software, a kind of attendance data statistics is disclosed
Analysis method and system put forth effort to solve the problems, such as enterprise's customization attendance data automation output archive, save human resources.
Attendance data statistical analysis technique disclosed by the invention, including:
Step 1, attendance data summarize:The attendance source data that different attendance checking systems generate is read using MATLAB software, it is right
The attendance source data got is pre-processed, and generates attendance source data matrix SOURCE_MATRIX;The pretreatment includes
Data are screened, are cleaned, and according to the threshold determination morning and afternoon checking-in state in preset commuter time and plus
Class's hourage;
Step 2, whole day checking-in state determine:According to attendance source data matrix SOURCE_MATRIX and whole day attendance shape
State decision rule generates all whole day checking-in state matrix STATE_MATRIX and overtime hours data for participating in attendance personnel
Matrix H OUR_MATRIX;The whole day checking-in state includes sooner or later, Chi Zheng, Chi Jia, lack late, is positive early, is normal, just plus, just lacking,
Lack it is early, lack just, lack plus, it is absent from duty, add half, add, be not added, going on business;
Step 3, attendance management statistics:According to preset attendance management statistical requirements, to whole day checking-in state matrix
Related data in STATE_MATRIX and overtime hours data matrix HOUR_MATRIX carries out attendance management statistics, and generates
Attendance management statistical data matrix D ATA_MATRIX;
Step 4, attendance data automatically write data sheet:By MATLAB program by attendance management statistical data matrix
In DATA_MATRIX automation write-in EXCEL Attendance Sheet.
As a preferred embodiment, in step 1, the threshold determination morning and afternoon according to the preset commuter time
Checking-in state and overtime hours number, specifically include:
1) obtaining the same day checks card the maximum value and minimum value of time, and differentiation work overtime, leaves early, absence from duty in afternoon, normal swipe shape
State;
2) obtaining the same day checks card time minimum value, distinguishes that late, the morning is absent from duty, normal swipe state;
3) it imports correlation to go on business, ask false entry, same day checking-in state will be changed to go on business or ask for leave.
As a preferred embodiment, it in step 1, to the attendance source data got, completes to pre-process by attendance checking system
And can show that related morning, checking-in state in afternoon need not be pre-processed, it is directly entered step 2.
As a preferred embodiment, in step 2, whole day checking-in state decision rule is:
Assuming that morning checking-in state is respectively to be late, is normal, is absent from duty, ask for leave, go on business, checking-in state in afternoon is respectively early
It moves back, is absent from duty, is normal, overtime work, then whole day checking-in state combination producing is as follows:
Regular working day:
(1) morning is late, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively sooner or later, Chi Zheng,
Chi Jia, four kinds of whole day checking-in states are lacked late, add state late if generated, same day overtime hours number scale is entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(2) morning is normal, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively it is positive it is early, normal,
Four kinds of whole day checking-in states just plus are just lacked, just adds state if generated, same day overtime hours number scale is entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(3) morning is absent from duty, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively lack it is early, lack just,
Lack plus, four kinds of whole day checking-in states absent from duty, lacked plus state if generated, same day overtime hours number scale entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to ask for leave;
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business;
Festivals or holidays and weekend:
(1) morning is late, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, no
Add three kinds of whole day checking-in states;
(2) morning is normal, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, no
Add three kinds of whole day checking-in states;
(3) morning is absent from duty, and checking-in state in afternoon is respectively left early, and/absent from duty, normal/overtime work generates respectively and is not added, adds two kinds
Whole day checking-in state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to be not added;
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business.
As a preferred embodiment, in step 2, the judgement of whole day checking-in state is specifically included:
S21, judge whether the attendance time is vacation or weekend, if so, S22 is executed, if it is not, executing S23;
S22, vacation or weekend attendance are determined according to the morning and checking-in state in afternoon, during obtaining vacation or weekend
Whole day checking-in state;
S23, working day attendance is determined according to the morning and checking-in state in afternoon, obtains whole day attendance between date
State;
S24, the whole day checking-in state respectively obtained according to step S22, S23 are combined into all participation attendance personnel's
Everyone monthly daily whole day checking-in state matrix STATE_MATRIX.
As a preferred embodiment, in step 3, the content of attendance management statistics includes:Holiday overtime is cumulative to be saved
Holiday overtime work number of days;Weekend overtime work is cumulative to obtain weekend overtime work number of days;Working day, which works overtime to add up at night, obtains overtime hours number;Out
Poor number of days is cumulative to obtain number of days of going on business.
As a preferred embodiment, in step 3, attendance management statistics is specifically included:
S31, the statistical data for calculating each people for participating in attendance:Simultaneously containing " adding " by same day whole day checking-in state in every month
And the same day adds up for the case where festivals or holidays, obtains holiday overtime number of days;Same day whole day checking-in state in every month is contained
The case where " adding " and the same day are weekend is added up, and weekend overtime work number of days is obtained;By same day whole day checking-in state in every month
The case where to work overtime at night, adds up, and obtains the hourage worked overtime at night;It is by same day whole day checking-in state in every month
The situation of difference adds up, the number of days gone on business;
S32, the data of all people for participating in attendance are counted, obtains all attendance management systems for participating in attendance personnel
Count matrix D ATA_MATRIX.
As a preferred embodiment, in step S4, attendance data automatically writes data sheet and specifically includes:
S41, Calling MATLAB automatically write function, and the participation in whole day checking-in state matrix A LLDAY_MATRIX is examined
The checking-in state data of diligent personnel, are automatically filled in the position of the checking-in state partial response of EXCEL Attendance Sheet;
S42, Calling MATLAB automatically write function, by the participation in attendance management statistical data matrix D ATA_MATRIX
The attendance management statistical data of the personnel of attendance, attendance management statistical data partial response of the Auto-writing into EXCEL Attendance Sheet
Position.To obtain complete EXCEL Attendance Sheet.
Correspondingly, invention additionally discloses a kind of attendance data statistical analysis system, including processor and memory, memory
It is inside stored with the attendance data statistical analysis program with multiple program modules, described program module includes attendance data cover sheet
Member, whole day checking-in state judging unit, attendance management statistic unit, data sheet automatically generate unit, the attendance data system
Meter analysis program is executed when being run by processor:
Attendance data collection unit:Different attendance checking systems are read using MATLAB software and generate attendance source data, to acquisition
To attendance source data pre-processed, and generate attendance source data matrix SOURCE_MATRIX;The pretreatment includes logarithm
According to being screened and being cleaned, according to the threshold determination morning and afternoon checking-in state and overtime hours in preset commuter time
Number;
Whole day checking-in state judging unit:According to attendance source data matrix SOURCE_MATRIX and whole day checking-in state
Decision rule generates all whole day checking-in state matrix STATE_MATRIX and overtime hours data square for participating in attendance personnel
Battle array HOUR_MATRIX;The whole day checking-in state includes sooner or later, Chi Zheng, Chi Jia, lack late, is positive early, is normal, just plus, just lacking, lack
It is early, lack just, lack plus, it is absent from duty, add half, add, be not added, going on business;
Attendance management statistic unit:According to preset attendance management statistical requirements, to whole day state matrix STATE_
Related data in MATRIX and overtime hours data matrix HOUR_MATRIX carries out company's attendance management statistics, and generates and examine
Diligent management statistics data matrix DATA_MATRIX;
Data sheet automatically generates unit:Attendance management statistical data matrix D ATA_MATRIX is passed through into MATLAB program
Auto-control is written in EXCEL table, generates EXCEL Attendance Sheet.
The system can be used any one of the above attendance data statistical analysis technique and realize attendance data statistical analysis.
Beneficial effect:
(1) present invention can carry out screening cleaning to initial data in pretreatment stage, and can be customized according to enterprise need into
Row threshold value is freely set, and extracts checking-in state.
(2) present invention carries out modeling analysis to attendance data using MATLAB, is suitable for enterprise's attendance and becomes privileged customization, real
The automation output of existing attendance data statistics.
(3) present invention is able to achieve from data and is input to the full-automation that data sheet needed for enterprise generates, and will can thoroughly examine
Diligent member frees from many and diverse statistical work, greatly improves working efficiency.
Detailed description of the invention
Fig. 1 attendance data statisticallys analyze flow diagram.
Specific embodiment
The present invention provides a kind of attendance data statistical analysis technique and system, puts forth effort to solve enterprise's customization attendance data automatic
Change output archive problem, saves human resources.
As shown in Figure 1, attendance data statistical analysis technique disclosed in embodiment, mainly includes:
Step 1, attendance data summarize:Attendance source data is read using MATLAB software, to the attendance source data got
It is pre-processed, and generates attendance source data matrix SOURCE_MATRIX;
Step 2, whole day checking-in state determine:It is generated according to attendance source data matrix and whole day checking-in state decision rule
All whole day checking-in state matrix STATE_MATRIX and overtime hours data matrix HOUR_ for participating in attendance personnel
MATRIX;
Step 3, attendance management statistics:According to associated companies attendance management statistical requirements, to whole day state matrix STATE_
Related data in MATRIX and overtime hours data matrix HOUR_MATRIX carries out company's attendance management statistics, obtains public affairs
National judicial examination duty management statistics data matrix DATA_MATRIX;
Step 4, attendance data auto report completing:The company's attendance management statistical data square that will be calculated in MATLAB
Battle array DATA_MATRIX is written in EXCEL by the automation of MATLAB process control, and generates EXCEL Attendance Sheet.
Correspondingly, a kind of attendance data statistical analysis system is also disclosed in embodiment, mainly include:Attendance data cover sheet
Member, checking-in state judging unit, attendance management statistic unit, data sheet automatically generate multiple program modules such as unit.
Each section is described in detail below:
Attendance data collection unit:The unit mainly obtains attendance source data matrix, attendance source data matrix SOURCE_
MATRIX is the column of N row 5, and wherein N, which is equal to, participates in attendance personnel number, and matrix each column meaning is respectively name A, for each person every day morning
Checking-in state B, the checking-in state C in afternoon, overtime hours number D every night, attendance date E.
Data handled by the unit can derive from different attendance checking systems various data of checking card generated, and this system can be located
The data of checking card of reason mainly include following two:
(1) there are in and out records of repeatedly checking card, the time of checking card has no rule, mixed and disorderly unordered.
For such attendance source data, the present invention carries out data screening and cleaning operation to data first.Threshold on and off duty
Value can carry out freely modifying (each company's work hours and quitting time are possible to different), then according to set on and off duty
The threshold determination morning and afternoon checking-in state and evening overtime hours number of time, specific step is as follows for data prediction:
S1, the maximum value and minimum value for time of checking card on the day of obtaining, distinguish overtime work and (are greater than 19:30) it, leaves early and (is greater than
13:00 and less than 17:30), absence from duty in afternoon is (less than 13:00 or the same day without check card record), normal swipe state (be greater than etc.
In 17:30 and less than 19:30).
S2, time minimum value of checking card on the day of obtaining are distinguished late (greater than 8:30 and less than 12:00), the morning is absent from duty (big
In equal to 12:00 or the same day without swipe the card record), normal swipe state (be less than or equal to 8:30).
S3, importing correlation go on business, ask false entry, and same day checking-in state will be changed to go on business or ask for leave.This system provides
External data introducting interface, input correlation asks for leave title, name and database correlation checking-in state can be realized in the date of asking for leave
Change.
(2) the attendance source data of cleaning has been completed.
Some attendance checking systems itself provide that correlation is gone on business, asking for leave records external introducting interface, and record of just checking card
It is cleaned, and can show the checking-in state in the related morning, afternoon.For such data, generally only need to import data, no
It must carry out automation cleaning operation.
Attendance data aggregation process mainly includes the following steps:
S1, MATLAB read in multiple EXCEL attendance source datas, judge whether source data needs to carry out data cleansing, if
Data cleansing is needed, step S1 is carried out, if you do not need to carrying out data cleansing, MATLAB directly generates all participation attendance personnel
Attendance source data matrix SOURCE_MATRIX, matrix be N row 5 arrange, then execute step S3.
S2, it screened, cleaned using MATLAB software data prediction step according to attendance data collection unit,
All attendance source data matrix SOURCE_MATRIX for participating in attendance personnel are generated based on the data after cleaning, matrix is N row 5
Then column execute step S3.
S3 enters whole day checking-in state judging unit, according to attendance source data matrix and whole day checking-in state decision rule
Obtain all whole day checking-in state matrix STATE_MATRIX for participating in attendance personnel.
Whole day checking-in state judging unit:Mainly according to attendance source data matrix SOURCE_MATRIX and whole day attendance
State decision rule generates all whole day checking-in state matrix STATE_MATRIX for participating in attendance personnel, and (N row H column, wherein N is
Participate in attendance number, H is monthly number of days) and for each person every day overtime work situation data matrix HOUR_MATRIX (N row H column,
Middle N is to participate in attendance number, and H is monthly number of days).
Whole day checking-in state decision rule:Assuming that morning checking-in state is respectively to be late, is normal, is absent from duty, ask for leave, go on business,
Checking-in state in afternoon is respectively to leave early, is absent from duty, is normal, working overtime, then whole day checking-in state combination producing is as follows:
One, regular working day
(1) morning is late, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively sooner or later, Chi Zheng,
Chi Jia, four kinds of whole day checking-in states are lacked late, add state late if generated, same day overtime hours number scale is entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(2) morning is normal, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively it is positive it is early, normal,
Four kinds of whole day checking-in states just plus are just lacked, just adds state if generated, same day overtime hours number scale is entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(3) morning is absent from duty, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively lack it is early, lack just,
Lack plus, four kinds of whole day checking-in states absent from duty, lacked plus state if generated, same day overtime hours number scale entered into HOUR_MATRIX,
Overtime hours number is 0 under his state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to ask for leave.
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business.
Two, festivals or holidays and weekend:
(1) morning is late, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, no
Add three kinds of whole day checking-in states;
(2) morning is normal, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, no
Add three kinds of whole day checking-in states;
(3) morning is absent from duty, and checking-in state in afternoon is respectively left early, and/absent from duty, normal/overtime work generates respectively and is not added, adds two kinds
Whole day checking-in state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to be not added.
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business.
According to whole day checking-in state decision rule, generating whole day checking-in state matrix, steps are as follows:
S1, judge whether the attendance time is vacation or weekend, if so, step S2 is executed, if it is not, executing step S3.
S2, vacation or weekend attendance are determined according to the morning and checking-in state in afternoon, during obtaining vacation or weekend
Whole day checking-in state;
S3, working day attendance is determined according to the morning and checking-in state in afternoon, obtains whole day attendance between date
State;
S4, the whole day checking-in state obtained respectively according to step S2, S3 are combined into everyone all for participating in attendance personnel
Monthly daily whole day checking-in state matrix STATE_MATRIX.
Company's attendance management statistic unit:According to associated companies attendance management statistical requirements and whole day checking-in state matrix
In related checking-in state carry out company's attendance management statistics, generate company's attendance management statistical data matrix D ATA_MATRIX
(column of N row 4).Company's attendance management statistic unit statistics content mainly include:Holiday overtime is cumulative to obtain holiday overtime
Number of days;Weekend overtime work is cumulative to obtain weekend overtime work number of days;Working day, which works overtime to add up at night, obtains overtime hours number;Number of days of going on business is tired
Add to obtain number of days of going on business, the DATA_MATRIX matrix of acquisition is the column of N row 4.Statistic procedure is as follows:
S1, the statistical data for calculating everyone attendance:By same day whole day checking-in state is containing " adding " in every month and the same day is
The case where festivals or holidays, adds up, and obtains holiday overtime number of days;By same day whole day checking-in state in every month containing " adding " and
The case where same day is weekend is added up, and weekend overtime work number of days is obtained;It is to add at night by same day whole day checking-in state in every month
The case where class, is added up (daily overtime hours number), and the hourage worked overtime at night is obtained;By same day whole day attendance in every month
State is to add up the case where going on business, the number of days gone on business.
Everyone statistical data that S2, basis are calculated generates all attendance management systems for participating in attendance personnel of company
Count matrix D ATA_MATRIX.
S3, unit is automatically generated into data sheet.
Data sheet automatically generates unit:It is required according to company report and data and table corresponding relationship, passes through program
It is controlled, realizes filling in for checking-in state part and attendance management statistical data part in Attendance Sheet, it is no longer necessary to artificial
Count write operation, whole office automations.
The step of automatically generating is as follows:
S41, according in the checking-in state data and Attendance Sheet of everyone in whole day checking-in state matrix A LLDAY_MATRIX
The position in EXCEL should be written in the data, and Calling MATLAB automatically writes function, and Auto-writing is examined into EXCEL Attendance Sheet
Diligent status sections;
S42, it should be written according to the data in attendance management statistical data matrix D ATA_MATRIX and Attendance Sheet
Position in EXCEL, Calling MATLAB automatically write function, attendance management statistical data of the Auto-writing into EXCEL Attendance Sheet
Part;
S43, EXCEL Attendance Sheet are completed.
As it can be seen that the present invention, which is able to achieve from data, is input to the full-automation that data sheet needed for enterprise generates, except importing phase
It closes outside initial data, it is without human intervention, easy to operate understandable, timekeeper can be freed from many and diverse statistical work.
Clear, complete description is carried out to the present invention by the technical solution in above embodiments, it is clear that described reality
The embodiment that example is this patent a part is applied, instead of all the embodiments.Based on the embodiments of the present invention, this field is common
Technical staff's every other embodiment obtained without making creative work belongs to the model of this patent protection
It encloses.
Claims (9)
1. a kind of attendance data statistical analysis technique, which is characterized in that including:
Step 1, attendance data summarize:The attendance source data that different attendance checking systems generate is read using MATLAB software, to acquisition
To attendance source data pre-processed, and generate attendance source data matrix SOURCE_MATRIX;The pretreatment includes logarithm
According to being screened, cleaned, and according to the threshold determination morning and afternoon checking-in state in preset commuter time and work overtime small
When number;
Step 2, whole day checking-in state determine:Sentenced according to attendance source data matrix SOURCE_MATRIX and whole day checking-in state
Set pattern then generates all whole day checking-in state matrix STATE_MATRIX and overtime hours data matrix for participating in attendance personnel
HOUR_MATRIX;The whole day checking-in state includes sooner or later, Chi Zheng, Chi Jia, lack late, is positive early, is normal, just plus, just lacking, lack it is early,
Lack just, lack plus, it is absent from duty, add half, add, be not added, going on business;
Step 3, attendance management statistics:According to preset attendance management statistical requirements, to whole day checking-in state matrix STATE_
Related data in MATRIX and overtime hours data matrix HOUR_MATRIX carries out attendance management statistics, and generates attendance pipe
Manage statistical data matrix D ATA_MATRIX;
Step 4, attendance data automatically write data sheet:By MATLAB program by attendance management statistical data matrix D ATA_
In MATRIX automation write-in EXCEL Attendance Sheet.
2. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step 1, the basis is pre-
The threshold determination morning and afternoon checking-in state and overtime hours number in the commuter time first set, specifically include:
1) obtaining the same day checks card the maximum value and minimum value of time, and differentiation work overtime, leaves early, absence from duty in afternoon, normal swipe state;
2) obtaining the same day checks card time minimum value, distinguishes that late, the morning is absent from duty, normal swipe state;
3) it imports correlation to go on business, ask false entry, same day checking-in state will be changed to go on business or ask for leave.
3. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step 1, to what is got
Attendance source data, pretreatment is completed by attendance checking system and can show the related morning, checking-in state in afternoon without progress in advance
Reason, is directly entered step 2.
4. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step 2, whole day attendance shape
State decision rule is:
Setting morning checking-in state is respectively to be late, is normal, is absent from duty, ask for leave, go on business, and checking-in state in afternoon is respectively to leave early, lack
Diligent, normal, overtime work, then whole day checking-in state combination producing mode is as follows:
One, regular working day:
(1) morning is late, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively sooner or later, Chi Zheng, Chi Jia,
Four kinds of whole day checking-in states are lacked late, are added state late if generated, same day overtime hours number scale are entered into HOUR_MATRIX, other shapes
Overtime hours number is 0 under state;
(2) morning is normal, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively it is positive it is early, normal, just plus,
Four kinds of whole day checking-in states are just lacked, just adds state if generated, same day overtime hours number scale is entered into HOUR_MATRIX, other shapes
Overtime hours number is 0 under state;
(3) morning is absent from duty, checking-in state in afternoon be respectively leave early, normally, it is overtime work, absent from duty, generate respectively lack it is early, lack just, lack plus,
Four kinds of whole day checking-in states absent from duty add state if generating and lacking, same day overtime hours number scale are entered HOUR_MATRIX, other shapes
Overtime hours number is 0 under state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to ask for leave;
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business;
Two, festivals or holidays and weekend:
(1) morning is late, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, be not added three
Kind whole day checking-in state;
(2) morning is normal, and checking-in state in afternoon is respectively to leave early, is normally/overtime work, absent from duty, generate respectively plus half plus, be not added three
Kind whole day checking-in state;
(3) morning is absent from duty, and checking-in state in afternoon is respectively left early, and/absent from duty, normal/overtime work generates respectively and is not added, adds two kinds of whole days
Checking-in state;
(4) ask for leave in the morning, and checking-in state in afternoon is to ask for leave, and whole day checking-in state is to be not added;
(5) go on business in the morning, and checking-in state in afternoon is to go on business, and whole day checking-in state is to go on business.
5. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step 2, whole day attendance shape
State judgement specifically includes:
S21, judge whether the attendance time is vacation or weekend, if so, S22 is executed, if it is not, executing S23;
S22, vacation or weekend attendance are determined according to the morning and checking-in state in afternoon, obtains whole day during vacation or weekend
Checking-in state;
S23, working day attendance is determined according to the morning and checking-in state in afternoon, obtains whole day attendance shape between date
State;
S24, the whole day checking-in state respectively obtained according to step S22, S23 are combined into everyone all for participating in attendance personnel
Monthly daily whole day checking-in state matrix STATE_MATRIX.
6. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step 3, attendance management system
The content of meter includes:Holiday overtime is cumulative to obtain holiday overtime number of days;Weekend overtime work is cumulative to obtain weekend overtime work number of days;Work
Make day to work overtime to add up at night to obtain overtime hours number;Number of days of going on business is cumulative to obtain number of days of going on business.
7. work attendance statistics analysis method as described in claim 1, which is characterized in that in step 3, the specific packet of attendance management statistics
It includes:
S31, the statistical data for calculating each people for participating in attendance:Same day whole day checking-in state in every month containing " adding " and is worked as
The case where it is festivals or holidays is added up, and holiday overtime number of days is obtained;Same day whole day checking-in state in every month is contained into " adding "
And the case where same day is weekend is added up, and weekend overtime work number of days is obtained;It is evening by same day whole day checking-in state in every month
The case where upper overtime work, adds up, and obtains the hourage worked overtime at night;Same day whole day checking-in state in every month is gone on business
Situation adds up, the number of days gone on business;
S32, the data of all people for participating in attendance are counted, obtains all attendance management statistical numbers for participating in attendance personnel
According to matrix D ATA_MATRIX.
8. attendance data statistical analysis technique as described in claim 1, which is characterized in that in the step S4, attendance data
Data sheet is automatically write to specifically include:
S41, Calling MATLAB automatically write function, by the participation attendance in whole day checking-in state matrix A LLDAY_MATRIX
The checking-in state data of personnel are automatically filled in the position of the checking-in state partial response of EXCEL Attendance Sheet;
S42, Calling MATLAB automatically write function, by the participation attendance in attendance management statistical data matrix D ATA_MATRIX
Personnel attendance management statistical data, Auto-writing into EXCEL Attendance Sheet attendance management statistical data partial response position
It sets.
9. a kind of attendance data statistical analysis system, which is characterized in that including processor and memory, storage in the memory
There is the attendance data statistical analysis program with multiple program modules, the attendance data statistical analysis program is transported by processor
When row, execute:
Different attendance checking systems are read using MATLAB software and generate attendance source data, and the attendance source data got is located in advance
Reason, and generate attendance source data matrix SOURCE_MATRIX;The pretreatment includes that data are screened and cleaned, according to
The threshold determination morning and afternoon checking-in state and overtime hours number in preset commuter time;
All participation attendance people are generated according to attendance source data matrix SOURCE_MATRIX and whole day checking-in state decision rule
The whole day checking-in state matrix STATE_MATRIX and overtime hours data matrix HOUR_MATRIX of member;The whole day attendance
State includes sooner or later, Chi Zheng, Chi Jia, lack late, is positive early, is normal, just plus, just lacking, lack it is early, lack just, lack plus, it is absent from duty, add half plus,
It is not added, goes on business;
According to preset attendance management statistical requirements, to whole day state matrix STATE_MATRIX and overtime hours data matrix
Related data in HOUR_MATRIX carries out company's attendance management statistics, and generates attendance management statistical data matrix D ATA_
MATRIX;
Attendance management statistical data matrix D ATA_MATRIX is written in EXCEL table by the automation of MATLAB process control, it is raw
At EXCEL Attendance Sheet.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810563438.9A CN108921496A (en) | 2018-06-04 | 2018-06-04 | A kind of attendance data statistical analysis technique and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201810563438.9A CN108921496A (en) | 2018-06-04 | 2018-06-04 | A kind of attendance data statistical analysis technique and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN108921496A true CN108921496A (en) | 2018-11-30 |
Family
ID=64418155
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201810563438.9A Pending CN108921496A (en) | 2018-06-04 | 2018-06-04 | A kind of attendance data statistical analysis technique and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108921496A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109583769A (en) * | 2018-12-03 | 2019-04-05 | 深圳市酷开网络科技有限公司 | Method, equipment and the storage medium of evaluation work efficiency |
CN111898351A (en) * | 2020-08-03 | 2020-11-06 | 上海嗨酷强供应链信息技术有限公司 | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium |
CN112184939A (en) * | 2020-09-03 | 2021-01-05 | 珠海格力电器股份有限公司 | Method and device for judging employee attendance, storage medium and electronic equipment |
CN117495329A (en) * | 2024-01-03 | 2024-02-02 | 齐心商用设备(深圳)有限公司 | Attendance machine data information management method based on Internet of things |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2518665A1 (en) * | 2011-04-28 | 2012-10-31 | Vestas Wind Systems A/S | Renewable energy configurator |
CN104794768A (en) * | 2015-04-24 | 2015-07-22 | 凯拔(中国)科技有限公司 | Attendance checking system and attendance checking method capable of regularly and automatically running attendance checking calculation |
CN105225056A (en) * | 2015-10-14 | 2016-01-06 | 广州市贺氏办公设备有限公司 | A kind of Intelligent Checking on Work Attendance management analysis method |
-
2018
- 2018-06-04 CN CN201810563438.9A patent/CN108921496A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2518665A1 (en) * | 2011-04-28 | 2012-10-31 | Vestas Wind Systems A/S | Renewable energy configurator |
CN104794768A (en) * | 2015-04-24 | 2015-07-22 | 凯拔(中国)科技有限公司 | Attendance checking system and attendance checking method capable of regularly and automatically running attendance checking calculation |
CN105225056A (en) * | 2015-10-14 | 2016-01-06 | 广州市贺氏办公设备有限公司 | A kind of Intelligent Checking on Work Attendance management analysis method |
Non-Patent Citations (3)
Title |
---|
E. REKHA ; P. RAMAPRASAD: "An efficient automated attendance management system based on Eigen Face recognition", <2017 7TH INTERNATIONAL CONFERENCE ON CLOUD COMPUTING, DATA SCIENCE & ENGINEERING - CONFLUENCE> * |
张玉兰等: "高职院校高等数学综合得分模型的构建", 《湘南学院学报》 * |
渠海龙: "虹膜识别技术及其在身份认证中的应用", 《全国硕士学位论文库》 * |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109583769A (en) * | 2018-12-03 | 2019-04-05 | 深圳市酷开网络科技有限公司 | Method, equipment and the storage medium of evaluation work efficiency |
CN111898351A (en) * | 2020-08-03 | 2020-11-06 | 上海嗨酷强供应链信息技术有限公司 | Automatic Excel data importing method and device based on Aviator, terminal equipment and storage medium |
CN112184939A (en) * | 2020-09-03 | 2021-01-05 | 珠海格力电器股份有限公司 | Method and device for judging employee attendance, storage medium and electronic equipment |
CN112184939B (en) * | 2020-09-03 | 2022-03-18 | 珠海格力电器股份有限公司 | Method and device for judging employee attendance, storage medium and electronic equipment |
CN117495329A (en) * | 2024-01-03 | 2024-02-02 | 齐心商用设备(深圳)有限公司 | Attendance machine data information management method based on Internet of things |
CN117495329B (en) * | 2024-01-03 | 2024-05-07 | 齐心商用设备(深圳)有限公司 | Attendance machine data information management method based on Internet of things |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN108921496A (en) | A kind of attendance data statistical analysis technique and system | |
CN104794768A (en) | Attendance checking system and attendance checking method capable of regularly and automatically running attendance checking calculation | |
CN102262678A (en) | System for sampling mass data and managing sampled data | |
CN112734284B (en) | Flow industrial energy consumption optimization decision system and method for improving accuracy of evaluation result | |
CN109508807A (en) | Lottery user liveness prediction technique, system and terminal device, storage medium | |
CN110851494B (en) | Method and system for bill analysis transaction characteristic behavior | |
Martin et al. | Retrieving the resource availability calendars of a process from an event log | |
CN111695836A (en) | Clinical trial online operation management and control integrated system | |
CN111984898A (en) | Label pushing method and device based on big data, electronic equipment and storage medium | |
CN111833018A (en) | Patent analysis method and system for science and technology project | |
CN115423289A (en) | Intelligent plate processing workshop data processing method and terminal | |
Bennett et al. | An example of a good but partially successful OR engagement: Improving outpatient clinic operations | |
CN112506892A (en) | Index traceability management system based on metadata technology | |
CN113342939B (en) | Data quality monitoring method and device and related equipment | |
CN113421168B (en) | Intelligent machining system for mechanical basic parts | |
CN109191083A (en) | Calculation method, system, device and storage medium when a kind of employee chief engineer | |
CN111325572B (en) | Data processing method and device | |
CN106960311A (en) | A kind of acquisition terminal of creation data, collecting statistical system and method | |
Gan et al. | Personalized treatment for opioid use disorder | |
CN115907786A (en) | Supplier portrait construction method based on knowledge graph | |
CN115471215A (en) | Business process processing method and device | |
CN115330219A (en) | Resource scheduling method and device | |
CN114140241A (en) | Abnormity identification method and device for transaction monitoring index | |
CN112308376B (en) | Emergency management method and system based on crowdsourcing preprocessing | |
Spielauer | The Potential of Dynamic Microsimulation in Family Studies: A Review and some Lessons for FAMSIM+ |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181130 |