Evaluation method and device for resources occupied by employees, equipment and storage medium
Through cross-verification of attendance and management system data, the effective working hours of employees are determined and the cost is calculated, and the problem of low data confidence in the existing technology is solved, accurate cost calculation and low cost investment are achieved, and suitable for existing systems. .
Patent Information
- Application Number
- CN202411324387.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-23
- Publication Date
- 2025-01-14
AI Technical Summary
When calculating employee operation costs, the confidence of the working hours data recorded by the attendance record and management system is not high, resulting in large cost calculation errors, increasing hardware costs and data processing complexity, affecting employee work experience.
By obtaining data from attendance systems and management systems, cross-validation is performed to determine the effective working hours of employees, and calculating employee costs based on cost data, reducing hardware costs and data processing complexity and improving data confidence.
It improves the calculation accuracy of employee operating costs, reduces cost investment, adapts to existing systems, and does not need to change personnel systems or employee habits, and improves the confidence of data.
Smart Images

Figure CN119313202A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data processing technology, and in particular to a method, device, equipment and storage medium for evaluating employee resource occupation. Background Art
[0002] At present, most enterprises and institutions have set up employee attendance systems to record employees' daily working hours. According to the industry and work content of the enterprises and institutions, most enterprises and institutions also set up management systems for work content. For example, for software development companies, the company uses project management systems to record and manage all software projects, including management data of each software project at each corresponding stage, such as project research stage, design stage, coding and development stage, testing stage, deployment and maintenance stage, etc.
[0003] In order to understand the company's operation and the occupation of resources by employees (such as the capital cost required for the company's operation, the human cost for management, etc.). For capital costs, the company will regularly calculate the company's operating costs. Usually, the company's financial department will develop a cost calculation table based on various data such as work content and personnel situation. Among them, a relatively simple calculation method is to comprehensively consider all situations and finally develop a person / hour cost base based on employees. Therefore, you only need to count the employee's working hours to calculate the operating costs. There are usually the following options for obtaining employee working hours:
[0004] 1. Count the employee's working hours through the employee's attendance record to calculate the operating cost of an employee. However, since the attendance record can only reflect the length of time on duty, but not the actual working hours of the employee, the error of this calculation method is too large.
[0005] Second, weaken the attendance system, weaken the concept of attendance and working hours, and use the employee working hours data recorded by the management system to calculate the employee's operating costs. Among them, the working hours data can be employee declaration data, or it can be the length of time monitored by the management system based on the employee's online status in the system. However, this method still has certain problems. For example, the working hours data recorded in the management system lacks control data verification, and the confidence level is not high, resulting in low confidence in the calculated cost data. In order to solve this problem, the project management system needs to be customized and the measurement capabilities of the project management system need to be strengthened, so it cannot be applied to general management systems.
[0006] 3. Fine-tune the measurement of working hours, collect employees' scattered time data in various dimensions, form a working hours data portrait based on employee dimensions, and design data indicators to measure the rationality and saturation of employees' working hours. For example, set up gates, access control, cameras, etc. to collect employees' movement trajectories in non-office areas within the company, and use software to analyze the movement trajectories to determine the non-working time, and then obtain a more accurate working time. However, the disadvantages of this processing method are obvious: first, it will bring additional hardware cost overhead, and secondly, because hashed data will generate additional aggregation analysis and processing requirements, it is necessary to integrate the data into the data warehouse to form a wide table (common operation in the industry), and special software is required to clean and analyze the data, so the investment in material and manpower is high; more importantly, the collection of various data requires the cooperation of employees, which brings additional burdens to employees' daily work and brings bad work experience to employees. Summary of the invention
[0007] In view of the technical problems existing in the prior art, the present invention proposes an evaluation method, device, equipment and storage medium for employee resource occupation, so as to improve data confidence and reduce costs.
[0008] In order to solve the above technical problem, according to one aspect of the present invention, the present invention provides a method for evaluating employee resource usage, comprising the following steps:
[0009] Get employee attendance data from the attendance system;
[0010] Acquire the employee's work time data on the work project from the management system, wherein the work time data at least includes the employee's work project and the work time;
[0011] Cross-validate each employee's attendance data and working time data to obtain the employee's effective working hours; and
[0012] The cost data of each employee is calculated based on the cost data and the effective working hours of each employee; wherein the employee's cost data is used as an evaluation record data of the resources occupied by the employee.
[0013] Optionally, when an employee has only one work item, the step of cross-verifying the employee's attendance data and working time data includes:
[0014] Calculate the employee's attendance time based on the punch-in time in the employee's attendance data;
[0015] Comparing the employee's attendance hours with the employee's working hours in the employee's working hours data;
[0016] In response to the difference between the attendance time and the working time in the working time data being less than a threshold, taking the attendance time as the effective working time;
[0017] In response to the difference between the attendance time and the working time in the working time data being greater than or equal to a threshold, when the attendance time is less than the working time in the working time data, the working time in the working time data is corrected to the attendance time, and the attendance time is used as the effective working time; when the attendance time is greater than the working time in the working time data, a notification for supplementary working time is generated.
[0018] Optionally, when an employee has multiple work items, the step of cross-verifying the employee's attendance data and working time data includes:
[0019] Calculate the employee's attendance time based on the punch-in time in the employee's attendance data;
[0020] Calculate the sum of working hours of all work items to get the total working hours;
[0021] Comparing the employee's attendance hours with the employee's total working hours;
[0022] In response to the difference between the attendance time and the total working time being less than a threshold, taking the attendance time as the effective working time;
[0023] In response to the difference between the attendance time and the total working time being greater than or equal to a threshold, when the attendance time is less than the total working time, the attendance time is used as the effective working time, and the proportion of the working time of each project is calculated based on the working time of multiple projects; the product of the proportion of the working time of each project and the attendance time is calculated as the corrected working time of each project; and
[0024] When the attendance time is greater than the total working time, a notification for supplementary working time will be generated.
[0025] Optionally, after cross-verifying the attendance data and working time data of each employee, the following steps are further included:
[0026] Conduct reasonableness analysis on the working hours of employees’ work projects;
[0027] When the working hours do not meet the reasonableness conditions, mark the corresponding items and revise the working hours; and
[0028] A working time record sheet is generated based on the original working time data, the items marked by rationality analysis and the corresponding revised working hours, and the working time record sheet is used as another evaluation record data of employee occupation of resources.
[0029] Optionally, the working time data also includes the employee's role information in the project and project progress information. When the number of projects in the employee's working time data is one, the step of analyzing the rationality of the working time includes:
[0030] Obtaining corresponding standard working hours based on the employee's role information and project progress information in the project;
[0031] Compare the employee's working hours with the stated standard working hours; and
[0032] In response to the difference between the working hours and the standard working hours being within a preset threshold range, it is determined that the employee's working hours meet rationality conditions; in response to the difference between the working hours and the standard working hours exceeding the preset threshold range, it is determined that the employee's working hours do not meet rationality conditions.
[0033] Optionally, the working time data also includes information about the role of the employee in the project and project progress information. When the number of projects in the working time data of the employee is multiple, the step of analyzing the rationality of the working time includes:
[0034] Determine the corresponding standard working hours based on the employee's role in each project and the current progress;
[0035] The project with the longest standard working hours is regarded as the employee's main project, and the remaining projects are regarded as the employee's secondary projects;
[0036] The standard working time of each project is used as the maximum estimated time of the corresponding project, zero is used as the minimum estimated time of the secondary project, and the minimum difference between the standard working time of the main project and the standard working time of the secondary project is used as the minimum estimated time of the main project, so as to obtain the estimated working time range of each project;
[0037] Compare the number of hours employees work on each project to the corresponding estimated work range; and
[0038] In response to the working hours of a project being within the range of estimated working hours, it is determined that the working hours of the employee on the project meet the rationality condition; in response to the working hours of a project being beyond the range of estimated working hours, it is determined that the working hours of the employee on the project do not meet the rationality condition.
[0039] Optionally, when there are multiple items in the employee's working time data, the method further includes:
[0040] Compare working hours across multiple projects;
[0041] In response to the difference between the working hours of the multiple projects exceeding a threshold, a rationality analysis is performed on the working hour of each project, wherein the rationality analysis includes the following steps:
[0042] Obtain the working hours of multiple employees on the same project at the current progress, and calculate the average working hours of the project at the current progress;
[0043] Compare the number of hours employees work on each project to the average length of said projects;
[0044] In response to the difference being within a preset difference threshold range, it is determined that the employee's working hours on the project meet rationality conditions; in response to the difference exceeding the preset difference threshold range, it is determined that the employee's working hours on the project do not meet rationality conditions.
[0045] Optionally, the step of correcting the working time includes: multiplying the working time by a correction factor to obtain a corrected working time.
[0046] According to another aspect of the present invention, the present invention also provides an evaluation device for employee resource occupation, comprising: a data acquisition module, a verification module and a resource evaluation module, wherein the data acquisition module is configured to obtain employee attendance data from the attendance system; obtain employee working time data on work projects from the management system, and the working time data at least includes the employee's work projects and working hours; the verification module is configured to cross-verify each employee's attendance data and working time data to obtain the employee's effective working hours; the resource evaluation module calculates each employee's cost data based on the cost data and each employee's effective working hours; wherein the employee's cost data is a kind of evaluation record data of employee resource occupation.
[0047] According to another aspect of the present invention, the present invention further provides an electronic device, including a processor and a memory, wherein a computer program instruction set is stored in the memory, and when the processor executes the computer program instruction set in the memory, the aforementioned employee resource occupation evaluation method is implemented.
[0048] According to another aspect of the present invention, the present invention further provides a computer-readable storage medium, on which a computer program instruction set is stored, and when the computer program instruction set is executed by a processor, the aforementioned employee resource occupancy evaluation method is implemented.
[0049] According to another aspect of the present invention, the present invention further provides a computer program product, which includes a computer program instruction set, and when the computer program instruction set is executed by a processor, the above-mentioned method for evaluating employee resource occupation is implemented.
[0050] The embodiments of the present invention improve the confidence of data by cross-validating, analyzing and correcting existing data. It does not require additional hardware such as data acquisition equipment, nor does it require customization of the existing management system, so the cost investment is low and the compatibility with the existing system is good. It is not invasive to the existing system and will not change the existing personnel system and the daily habits of employees. BRIEF DESCRIPTION OF THE DRAWINGS
[0051] The preferred embodiments of the present invention will be further described in detail below with reference to the accompanying drawings, wherein:
[0052] Figure 1 is a flow chart of a method for evaluating employee resource occupation according to an embodiment of the present invention;
[0053] Figure 2 is a flow chart of a method for cross-verifying attendance data and working time data of an employee according to an embodiment of the present invention;
[0054] Figure 3 is a flow chart of a method for cross-verifying attendance data and working time data of an employee according to another embodiment of the present invention;
[0055] Figure 4 is a flow chart of a method for rationality analysis of working hours according to an embodiment of the present invention;
[0056] Figure 5 is a flow chart of a method for rationality analysis of working hours according to another embodiment of the present invention;
[0057] Figure 6 is a flow chart of a method for rationality analysis of working hours according to yet another embodiment of the present invention;
[0058] Figure 7 is a principle block diagram of an evaluation device for employee resource occupation according to an embodiment of the present invention;
[0059] Figure 8 is a block diagram of an apparatus for evaluating employee resource occupancy according to an embodiment of the present invention; and
[0060] Fig. 9 It is a schematic diagram of the hardware structure principle of an electronic device according to an embodiment of the present invention. DETAILED DESCRIPTION
[0061] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0062] In the following detailed description, reference may be made to the various specification drawings that are part of the present application and are used to illustrate specific embodiments of the present application. In the accompanying drawings, similar reference numerals describe substantially similar components in different figures. The various specific embodiments of the present application are described below in sufficient detail so that a person of ordinary skill in the art with relevant knowledge and skills in the art can implement the technical solutions of the present application. It should be understood that other embodiments may also be used or structural, logical or electrical changes may be made to the embodiments of the present application.
[0063] See also Figure 1 , Figure 1 The present invention is a flow chart of a method for evaluating employee resource occupation according to an embodiment of the present invention, wherein the method comprises the following steps:
[0064] Step S11, obtaining employee attendance data from the attendance system.
[0065] Step S12, obtaining the employee's work time data on the work project from the management system, wherein the work time data includes the employee's work project and the work time.
[0066] Step S13, cross-validating the attendance data and working time data of each employee and correcting the working time to obtain the effective working time.
[0067] Step S14, calculating the cost data of each employee based on the cost data and the effective working hours of each employee; wherein the cost data of the employee is a kind of evaluation record data of the resources occupied by the employee.
[0068] The attendance system records an attendance data table, for example, one attendance data table is recorded every day, wherein a time data is recorded for each employee, and the time data includes the time of going to work and the time of leaving get off work. In step S11, the attendance system is accessed to request the attendance data, and the time of going to work and the time of leaving work of each employee can be obtained.
[0069] According to the company's business operations, the projects in the management system have corresponding management matters, usually including the project name, progress stage, the name of one or more employees who follow up the project, and the role of each employee in the project. Different roles are responsible for different content. For example, project leader, external liaison personnel, process supervisor, etc. For software development business, the project management system records all software projects, including the management data of each software project in each corresponding stage, such as project research stage, design stage, coding and development stage, testing stage, deployment and maintenance stage, etc. During the work process, employees fill in their working hours for each project in the management system every day, so the management system maintains the working time data of each employee, for example, in units of days, an employee working time data table is generated every day, and each employee corresponds to a working time record, each record includes the employee's name or number, the name of the project he is engaged in, project progress information (such as software project stage), the employee's role in the project, and the working hours of the project on that day, etc. Of course, each employee may be used as a unit, and each employee may generate an employee working time data table, with one working time record corresponding to each day, and each record includes time information (in days), the name of the project engaged in, project progress information (such as software project phase), the role in the project, and the working hours in the project on that day, etc. In step S12, the working time data of the project engaged in by the employee is read from the management system.
[0070] In order to accurately obtain the effective working hours of employees, in step S13, the attendance data and working time data of each employee are cross-validated. Figure 2 , Figure 2 1 is a flow chart of a method for cross-validating attendance data and working time data of an employee according to an embodiment of the present invention. In this embodiment, there is only one item in the working time data of the employee, and the method includes the following steps:
[0071] Step 131a, calculating the employee's attendance duration t1 based on the punch-in time in the employee's attendance data.
[0072] Step 132a, calculating the difference Δt1 between the attendance time t1 and the working time t2 in the working time data.
[0073] Step 133a, determine whether the absolute value of the difference △t is greater than or equal to the threshold T1. If the absolute value of the difference △t1 is less than the threshold T1, it means that the two time durations recorded by the two systems for the employee are not much different. Then in step S134a, the current attendance time t1 or the working time t2 in the working time data is confirmed as the effective working time. If the absolute value of the difference △t1 is greater than or equal to the threshold T1, it means that the two time durations recorded by the two systems are too different for the employee. The current attendance time t1 cannot be used as a valid working time, then execute step S135a.
[0074] Step S135a, determine whether the difference △t is greater than zero. If the difference is greater than zero, it means that the attendance time t1 is greater than the working time t2 in the working time data, then in step S136a, generate a notification of supplementary working time; if the difference is less than zero, it means that the working time t2 in the working time data is greater than the attendance time t1, then in step S137a, correct the working time in the working time data to the attendance time, and use the attendance time as the effective working time.
[0075] See also Figure 3 , Figure 3 1 is a flow chart of a method for cross-validating attendance data and working time data of an employee according to another embodiment of the present invention. In this embodiment, there are multiple items in the working time data of the employee, and the method includes the following steps:
[0076] Step 131b, calculating the employee's attendance duration t1 based on the punch-in time in the employee's attendance data.
[0077] Step 132b, calculating the sum of the working hours of all work items to obtain the total working time t3;
[0078] Step 133b, calculating the difference Δt2 between the attendance time t1 and the total working time t3.
[0079] Step 134b, determine whether the absolute value of the difference △t2 is greater than or equal to the threshold T1. If the absolute value of the difference △t2 is less than the threshold T1, it means that the two time lengths recorded by the two systems for the employee are not much different. Then in step S135b, confirm the current attendance time t1 as the effective working time. If the absolute value of the difference △t2 is greater than or equal to the threshold T1, it means that the two time lengths recorded by the two systems are too different. The current attendance time t1 cannot be used as a valid working time, then execute step S136b.
[0080] Step S136b, determine whether the difference △t2 is greater than zero. If the difference is greater than zero, it means that the attendance time t1 is greater than the total working time t3. In step S137b, generate a notice of supplementary working time. If the difference △t2 is less than zero, it means that the total working time t3 is greater than the attendance time t1. In step S138b, take the attendance time as the effective working time. Then execute step S139b.
[0081] Step S139b, calculating the proportion of the working time of each project based on the working time of multiple projects.
[0082] Step S1310b, calculate the product of the proportion of working hours for each project and the attendance hours as the corrected working hours for each project.
[0083] After cross-validation of the data from the two systems, relatively accurate effective working hours of employees can be obtained, so relatively accurate cost data of each employee can be calculated in step S14.
[0084] In one embodiment, the calculation unit of cost data is, for example, RMB / person / day, so the effective working hours obtained above can be converted into days based on the number of full attendance hours per day, and then multiplied by the cost data to obtain the employee's cost for the day. The calculation unit of cost data can also be RMB / person / hour. When calculating the cost, the effective working hours can be directly multiplied by the cost data to obtain the employee's cost for the day. After obtaining the cost data for one day, the cost data for one week, one month, one year, etc. can be obtained by accumulation. The cost data serves as a kind of resource occupation assessment record data for the employee.
[0085] When the working hours of the projects in the management system are filled in manually, there are human factors. In one embodiment, in order to eliminate the influence of human factors, after cross-validating the attendance data and working time data of each employee, it further includes the step of rationality analysis of the working hours of the employee's work project. If the working hours do not meet the rationality conditions, mark the corresponding project, and correct the working hours, and then generate a working time record sheet based on the original working time data, the project marked by the rationality analysis, and the corresponding corrected working hours, and use the working time record sheet as another evaluation record data of employee resource occupation. The working time record sheet can be provided to other departments for other purposes, such as performance evaluation. Among them, when correcting the working hours, the working hours are multiplied by the correction factor to obtain the corrected working hours, and the correction factor has different values according to the specific scenario.
[0086] See also Figure 4 , Figure 4 The flowchart of the method for rationality analysis of working hours according to one embodiment of the present invention is as follows. When the number of items in the employee's working time data is one, the method for rationality analysis of working hours includes the following steps:
[0087] Step S151, based on the employee's role information and project progress information in the project, obtain the corresponding standard working time T t When an employee's role is determined at a certain stage of a project (i.e. the progress of the project), there is a fixed standard working time T corresponding to it. t For example, during the software development phase, a development role employee's working hours per day should be full attendance hours, such as 8 hours.
[0088] Step S152, calculating the employee's working hours t and the standard working hours T tThe working time t is the original working time in the working time data.
[0089] Step S153, determine whether the difference △t3 is less than the threshold value T2. If the difference △t3 is less than the threshold value T2, it means that the difference between the two is not large. Then, in step S154, determine that the employee's working hours meet the rationality condition. If the difference △t3 is greater than or equal to the threshold value T2, it means that the difference between the two is too large. Then, in step S155, determine that the employee's working hours do not meet the rationality condition. For example, when the employee's working hours t is greater than the standard working hours T t Moreover, the difference △t3 between the two exceeds the threshold value T2, indicating that the working hours reported by the employee are unreasonable. At this time, the employee's working hours t are multiplied by the correction factor α. In one embodiment, since the employee has only one work item on that day, the correction factor α = T t / 8. That is, the corrected working time t'=t*T t / 8. If the employee's working hours t are less than the standard working hours T t And if the difference △t3 between the two exceeds the threshold T2, the current project of the employee will be marked.
[0090] See also Figure 5 , Figure 5 1 is a flow chart of a method for analyzing the rationality of working hours according to another embodiment of the present invention. In this embodiment, there are multiple items in the employee's working time data, and the method for analyzing the rationality of working hours includes the following steps:
[0091] Step S251, determining corresponding standard working hours based on the employee's role information and project progress information in the project.
[0092] Step S252, determine the estimated working time range for each project. In this embodiment, the project with the longest standard working time is taken as the main project of the employee, and the remaining projects are taken as the secondary projects of the employee. The standard working time of each project is taken as the maximum estimated time of the corresponding project, 0 is taken as the minimum estimated time of the secondary project, and the difference between the standard working time of the main project and the standard working time of the secondary project is taken as the minimum estimated time of the main project, thereby obtaining the estimated working time range for each project. When there are multiple secondary projects, the minimum difference between the standard working time of the main project and the standard working time of the secondary project is taken as the minimum estimated time of the main project.
[0093] Step S253, taking a project as an analysis object.
[0094] Step S254, determines whether the working hours of the project are within the estimated working hours. If the working hours of the project are within the estimated working hours, then in step S255, determines whether the working hours of the employee on the project meet the rationality conditions. If the working hours of the project exceed the estimated working hours, then in step S256, determines whether the working hours of the employee on the project do not meet the rationality conditions.
[0095] Step S257, determine whether there are still items that have not been analyzed. If so, return to step S253. If not, it means that the rationality analysis is completed, and the process ends.
[0096] For example, Table 1 is the raw working hours data of an employee:
[0097] Table 1
[0098] Project Name (Progress Information) A(R&D stage) B (Testing Phase) Employee roles Development Development Original working hours 2 6 Standard working hours 8 2
[0099] Based on the data in Table 1 above, it is determined that the estimated working hours of the employee on the two projects A and B are in the range of [6, 8] and [0, 2] respectively. By comparing the original working hours of the employee with the estimated working hours range, it can be seen that both projects are beyond the estimated working hours range, which means that the working hours reported by the employee are unreasonable, where the working hours of Project A are too short and the working hours of Project B are too long.
[0100] For example, Table 2 is the original working hours data of another employee:
[0101] Table 2
[0102] Project Name (Progress Information) A(R&D stage) B (Testing Phase) C(R&D stage) Employee roles Development Development Development Original working hours 2 1 5 Standard working hours 8 2 8
[0103] Based on the data in Table 2 above, project A or C is randomly selected as the main project, and the rest are selected as secondary projects. In this embodiment, project C is selected as the main project. For projects A, B and C, 8, 2 and 8 are respectively selected as the maximum estimated duration of their respective estimated working time ranges, and 0 is selected as the minimum estimated duration of projects A and B. For project A, 8-8=0 is selected as the minimum estimated duration of project C. Therefore, the estimated working time ranges of projects A, B and C are [0, 8], [0, 2] and [0, 8] respectively. By comparing the original working hours of the employee with their respective estimated working time ranges, it can be seen that the original working hours of all projects are within their respective estimated working time ranges, indicating that the working hours declared by the employee are reasonable.
[0104] For example, Table 3 is the original working hours data of another employee:
[0105] Table 3
[0106] Project Name (Progress Information) A(R&D stage) B (Testing Phase) C(R&D stage) Employee roles Development Development Development Original working hours 1 3 4 Standard working hours 8 2 8
[0107] Similarly, the estimated working hours ranges for projects A, B, and C are [0, 8], [0, 2], and [0, 8], respectively. By comparing the original working hours of the employee with their respective estimated working hours ranges, it can be seen that the original working hours of project B exceeded the estimated working hours range, indicating that the working hours reported by the employee for the project are unreasonable.
[0108] See also Figure 6 , Figure 6 1 is a flow chart of a method for analyzing the rationality of working hours according to another embodiment of the present invention. The number of items in the employee's working time data is multiple, and the method includes the following steps:
[0109] Step S351, obtaining the working hours of employees in multiple projects.
[0110] Step S352: compare the working hours of multiple projects. For example, calculate the difference between two working hours respectively, and take the maximum difference as the difference between the working hours of the projects.
[0111] Step S353, determine whether the difference between the working hours of the projects exceeds the threshold. If the difference between the working hours of the projects exceeds the threshold, perform a rationality analysis and execute step S354. If the difference between the working hours of the projects does not exceed the threshold, do not perform a rationality analysis and end.
[0112] Step S354, obtaining the working hours of multiple employees on the same project at the current progress.
[0113] Step S355, calculating the average duration of each project.
[0114] Step S356: taking a project of the employee as an analysis object.
[0115] Step S357, comparing the difference between the employee's working hours on the current project and the average working hours of the project.
[0116] Step S358, determine whether the difference between the working hours of the current project and the average duration of the project is within the preset difference threshold range. If the difference between the working hours of the current project and the average duration of the project is within the preset difference threshold range, it means that the working hours of the current project are not much different from the average duration of the project. Then, in step S359, determine that the working hours of the employee on the project meet the rationality condition. If the difference between the working hours of the current project and the average duration of the project exceeds the preset difference threshold range, it means that the working hours of the current project are too different from the average duration of the project. Then, in step S3510, determine that the working hours of the employee on the project do not meet the rationality condition.
[0117] Step S3511, determine whether there are any items that have not been analyzed. If so, return to step S356. If not, end the processing flow.
[0118] In this embodiment, rationality analysis is performed only when an employee works long hours on multiple projects, thereby reducing the amount of data processing. In addition, when performing rationality analysis, the average working hours of other employees are referenced to determine whether the employee's working hours on one or some projects are reasonable through horizontal comparison.
[0119] After analyzing and finding that the working hours on one or some projects are unreasonable, the excessive working hours are corrected. In one embodiment, different projects have corresponding standard working hours corresponding to different roles at different stages of progress, and the correction factor α is set to be standard working hours / full attendance hours. For example, as shown in Table 4. According to the above method, it is determined that the working hours of project B are too long, and its correction factor α is calculated to be 2 / 8, so the corrected working hours t=6*2 / 8=1.5 hours.
[0120] Table 4
[0121] Project Name (Progress Information) A(R&D stage) B (Testing Phase) Employee roles Development Development Standard working hours 8 2 Original working hours 2 6 Correction duration 2 1.5
[0122] In another embodiment, the correction factor may also be a preset fixed value, which is determined according to the project, current progress and corresponding role. Figure 4 For Project B, the correction factor for the development employee during the testing phase can be set to 0.5, so the employee's working hours on Project B can be corrected to 6*0.5=3 hours.
[0123] In order to simplify the explanation process of rationality analysis, the aforementioned embodiment uses the original working time data that has passed cross-validation. However, according to the previous cross-validation process, it is known that the original working time data may be revised after the cross-validation process. If the original working time data is revised during the cross-validation process, the working time data used in the rationality analysis should be the revised data. Referring to Table 5, when the employee's attendance time is 8 hours, and the project work time in the management system is 10 hours, it is corrected during the cross-validation to obtain the corrected attendance time, which is 3.2 and 4.8 respectively; and then after rationality analysis, project A does not need to be corrected, and project B needs to be corrected, and the final correction is 4.8*2 / 8=1.2.
[0124] Table 5
[0125]
[0126]
[0127] After completing the rationality analysis, a work time record sheet is generated based on the analysis results, which includes the original work time data, the revised working hours, the analysis results, and the marking content of certain items. The work time record sheet can be a separate data sheet, or it can be obtained by adding content to the work time data sheet of the original management system. As shown in Table 6:
[0128] Table 6
[0129]
[0130] Table 6 can be used as another type of evaluation record data for employee resource utilization. It can be provided to relevant departments (such as finance department, administrative department, management decision-making department, etc.) together with cost data. These data can be used to calculate costs, profits, improve management systems, evaluate employee value, etc.
[0131] From the foregoing description, it can be seen that the present invention has a high degree of confidence in the data through cross-validation, analysis and correction of existing data; the present invention makes full use of existing hardware resources, does not require additional hardware such as data acquisition equipment, and does not require customization of the existing management system, so the cost investment is low and the compatibility with the existing system is good; it is not invasive to the existing system and will not change the existing personnel system and the daily habits of employees.
[0132] The present invention also provides an evaluation device for employee resource occupation, see Figure 7 , Figure 7 1 is a principle block diagram of an evaluation device for employee resource occupation according to an embodiment of the present invention. The evaluation device 100 for employee resource occupation in this embodiment includes a data acquisition module 11, a verification module 12 and a resource evaluation module 13, wherein the data acquisition module 11 is configured to obtain employee attendance data from the attendance system 200; obtain employee working time data on work items from the management system 300, and the working time data at least includes the employee's work items and working hours; the verification module 12 cross-validates each employee's attendance data and working time data to obtain the employee's effective working hours; the resource evaluation module 13 calculates each employee's cost data based on the cost data and each employee's effective working hours; wherein the employee's cost data is a kind of evaluation record data for employee resource occupation.
[0133] When an employee has only one work item, the verification module 12 performs the steps of cross-verifying the attendance data and working time data of each employee, including: calculating the attendance time of the employee based on the punch-in time in the employee's attendance data; comparing the attendance time of the employee with the working time in the employee's working time data; in response to the difference between the attendance time and the working time in the working time data being less than a threshold, taking the attendance time as the effective working time; in response to the difference between the attendance time and the working time in the working time data being greater than or equal to a threshold, when the attendance time is less than the working time in the working time data, correcting the working time in the working time data to the attendance time, and taking the attendance time as the effective working time; when the attendance time is greater than the working time in the working time data, generating a notification for supplementary working time. When an employee has multiple work items, the verification module 12 performs the steps of cross-verifying the attendance data and working time data of each employee, including: calculating the attendance time of the employee based on the punch-in time in the employee's attendance data; calculating the sum of the working hours of all work items to obtain the total working hours; comparing the attendance time of the employee with the total working hours of the employee; in response to the difference between the attendance time and the total working hours being less than a threshold, taking the attendance time as the effective working time; in response to the difference between the attendance time and the total working hours being greater than or equal to a threshold, when the attendance time is less than the working hours in the working time data, taking the attendance time as the effective working time, and calculating the proportion of the working hours of each project based on the working hours of multiple projects; calculating the product of the proportion of the working hours of each project and the attendance time as the revised working time of each project; and generating a notification of supplementary working hours when the attendance time is greater than the total working hours.
[0134] Preferably, the employee resource occupation evaluation device also includes a rationality analysis module 14, which is connected to the verification module 12. After cross-verification by the verification module 12, the rationality analysis is also performed on the working hours of the employee's work items; when the working hours do not meet the rationality conditions, the corresponding items are marked and the working hours are corrected; and a working time record sheet is generated based on the original working time data, the items marked by the rationality analysis and the corresponding corrected working hours, and the working time record sheet is used as another evaluation record data for the employee's resource occupation.
[0135] In one embodiment, the working time data also includes the employee's role information and project progress information in the project. When the number of projects in the employee's working time data is one, the rationality analysis module 14 performs a rationality analysis on the working hours in the following steps: obtaining the corresponding standard working hours based on the employee's role information and project progress information in the project; comparing the employee's working hours with the standard working hours; and in response to the difference between the working hours and the standard working hours meeting a preset threshold range, determining that the employee's working hours meet rationality conditions; in response to the difference between the working hours and the standard working hours exceeding a preset threshold range, determining that the employee's working hours do not meet rationality conditions.
[0136] In another embodiment, the working time data also includes the role information and project progress information of the employee in the project. When the number of projects in the working time data of the employee is multiple, the step of the rationality analysis module 14 performing rationality analysis on the working time includes: determining the standard working time of the employee in the corresponding progress of each current project based on the standard working time of the role in the specific project stage of the project; taking the project with the longest standard working time as the main project of the employee, and the remaining projects as the secondary projects of the employee; taking the standard working time of each project as the maximum estimated time of the corresponding project, taking 0 as the minimum estimated time of the secondary project, and taking the minimum difference between the standard working time of the main project and the standard working time of the secondary project as the minimum estimated time of the main project, thereby obtaining the estimated working time range of each project; comparing the working time of each project of the employee with the corresponding estimated working time range; and in response to the working time of a project being within the estimated working time range, determining that the working time of the employee for the project meets the rationality condition; in response to the working time of a project exceeding the estimated working time range, determining that the working time of the employee for the project does not meet the rationality condition.
[0137] In another embodiment, when there are multiple projects in the employee's working time data, the rationality analysis module 14 first compares the working hours of multiple projects; in response to the difference between the working hours of multiple projects exceeding a threshold, the working hours of each project are subjected to rationality analysis, and the steps of rationality analysis include: obtaining the working hours of multiple employees of the same project in the current progress, and calculating the average duration of the project in the current progress; comparing the difference between the working hours of each project of the employee and the average duration of the project; in response to the difference being within a preset difference threshold range, determining that the working hours of the employee on the project meet the rationality condition; in response to the difference exceeding the preset difference threshold range, determining that the working hours of the employee on the project do not meet the rationality condition.
[0138] When correcting the working time, the rationality analysis module 14 multiplies the working time by a correction factor to obtain a corrected working time.
[0139] Figure 8 1 is a block diagram of an employee resource occupation evaluation device according to an embodiment of the present invention. In this embodiment, the employee resource occupation evaluation device 100 includes a backend processing module 120 and an interactive interface 110 at the front end. The structure of the backend processing module 120 is as follows: Figure 7 In order to facilitate users to view the generated evaluation data, an interactive interface 110 for interacting with users is provided. In one embodiment, the front end provides a BI dashboard, through which a data visualization scheme can be generated, and the evaluation data can be displayed in various dimensions and various visual forms, such as charts, schematic diagrams of various graphics, etc.
[0140] See also Fig. 9 , Fig. 9 It is a schematic diagram of the hardware structure principle of an electronic device according to an embodiment of the present invention. The electronic device can be implemented as a server or other various terminal devices, such as a desktop personal computer, a tablet computer, a laptop computer, a mobile phone, etc., including a processor 601 and a memory 602. The memory 602 stores a program instruction set. When the processor 601 executes the program instruction set on the memory 602, the aforementioned employee resource occupation evaluation method is implemented.
[0141] Specifically, the processor 601 may include a central processing unit (CPU), or an application specific integrated circuit (ASIC), or may be configured to implement one or more integrated circuits of the embodiment of the present invention.
[0142] The memory 602 may include a large capacity memory for data or instructions. By way of example and not limitation, the memory 602 may include a hard disk drive (HDD), a floppy disk drive, a flash memory, an optical disk, a magneto-optical disk, a magnetic tape, or a universal serial bus (USB) drive or a combination of two or more of these. In appropriate cases, the memory 602 may include a removable or non-removable (or fixed) medium. In appropriate cases, the memory 602 may be inside or outside the integrated gateway disaster recovery device. In a specific embodiment, the memory 602 is a non-volatile solid-state memory.
[0143] The memory may include a read-only memory (ROM), a random access memory (RAM), a magnetic disk storage medium device, an optical storage medium device, a flash memory device, an electrical, optical or other physical / tangible memory storage device. Therefore, generally, the memory includes one or more tangible (non-transitory) computer-readable storage media (e.g., a memory device) encoded with software including computer-executable instructions, and when the software is executed (e.g., by one or more processors), it is operable to perform the employee-occupied resource evaluation method provided by the present invention.
[0144] In one example, the electronic device may further include a communication interface 603 and a bus 604. The processor 601, the memory 602, and the communication interface 603 are connected via the bus 604 and communicate with each other.
[0145] The communication interface 603 is mainly used to implement communication between various modules, devices, units and / or equipment in the embodiment of the present invention.
[0146] Bus 604 includes hardware, software or both, and the components of online data flow billing equipment are coupled to each other. For example, but not limitation, bus may include accelerated graphics port (AGP) or other graphics bus, enhanced industrial standard architecture (EISA) bus, front side bus (FSB), hypertransport (HT) interconnection, industrial standard architecture (ISA) bus, infinite bandwidth interconnection, low pin count (LPC) bus, memory bus, micro channel architecture (MCA) bus, peripheral component interconnection (PCI) bus, PCI-Express (PCI-X) bus, serial advanced technology attachment (SATA) bus, video electronics standard association local (VLB) bus or other suitable bus or two or more of these combinations. In appropriate cases, bus 604 may include one or more buses. Although the embodiment of the present invention describes and shows a specific bus, the present invention considers any suitable bus or interconnection.
[0147] The present invention also provides a computer-readable storage medium having computer program instructions stored thereon, which can be executed by a processor to implement any of the employee resource occupation evaluation methods in the aforementioned embodiments. The computer-readable storage medium can be any tangible medium that contains or stores computer-executable instructions for use by or in combination with an instruction execution system, device, and apparatus. The storage medium can be a transient computer-readable storage medium or a non-transient computer-readable storage medium. Non-transient computer-readable storage media may include, but are not limited to, magnetic storage devices, optical storage devices, and / or semiconductor storage devices. Examples of such storage devices include magnetic disks, optical disks based on CD, DVD, or Blu-ray technology, and persistent solid-state memories such as flash memory, solid-state drives, and the like.
[0148] The present invention also provides a computer program product, which includes a set of computer program instructions, and when the set of computer program instructions is executed by a processor, any of the employee resource occupation evaluation methods in the aforementioned embodiments is implemented. The computer program product includes but is not limited to application installation packages published on websites and application stores, application plug-ins, and small programs that can be run in certain applications.
[0149] It should be clear that the present invention is not limited to the specific configuration and processing described above and shown in the figures. For the sake of simplicity, a detailed description of the known method is omitted here. In the above embodiments, several specific steps are described and shown as examples. However, the method process of the present invention is not limited to the specific steps described and shown, and those skilled in the art can make various changes, modifications and additions, or change the order between the steps after understanding the spirit of the present invention.
[0150] The above embodiments are only used to illustrate the present invention, but not to limit the present invention. Ordinary technicians in the relevant technical field can make various changes and modifications without departing from the scope of the present invention. Therefore, all equivalent technical solutions should also fall within the scope of the present invention.
Claims
1. A method for evaluating employee resource usage, characterized in that: include: Get employee attendance data from the attendance system; Acquire the employee's work time data on the work project from the management system, wherein the work time data at least includes the employee's work project and the work time; Cross-validate each employee's attendance data and working time data to obtain the employee's effective working hours; and The cost data of each employee is calculated based on the cost data and the effective working hours of each employee; wherein the employee's cost data is used as an evaluation record data of the resources occupied by the employee.
2. The method for evaluating employee resource usage according to claim 1, characterized in that: When an employee has only one work item, the steps of cross-verifying the employee's attendance data and working time data include: Calculate the employee's attendance time based on the punch-in time in the employee's attendance data; Comparing the employee's attendance hours with the employee's working hours in the employee's working hours data; In response to the difference between the attendance time and the working time in the working time data being less than a threshold, taking the attendance time as the effective working time; In response to the difference between the attendance time and the working time in the working time data being greater than or equal to a threshold, when the attendance time is less than the working time in the working time data, the working time in the working time data is corrected to the attendance time, and the attendance time is used as the effective working time; when the attendance time is greater than the working time in the working time data, a notification for supplementary working time is generated.
3. The method for evaluating employee resource usage according to claim 1, characterized in that: When an employee has multiple work items, the steps of cross-verifying the employee's attendance data and working time data include: Calculate the employee's attendance time based on the punch-in time in the employee's attendance data; Calculate the sum of working hours of all work items to get the total working hours; Comparing the employee's attendance hours with the employee's total working hours; In response to the difference between the attendance time and the total working time being less than a threshold, taking the attendance time as the effective working time; In response to the difference between the attendance time and the total working time being greater than or equal to a threshold, when the attendance time is less than the total working time, the attendance time is used as the effective working time, and the proportion of the working time of each project is calculated based on the working time of multiple projects; the product of the proportion of the working time of each project and the attendance time is calculated as the corrected working time of each project; and When the attendance time is greater than the total working time, a notification for supplementary working time will be generated.
4. The method for evaluating employee resource usage according to any one of claims 1 to 3, characterized in that: After cross-verifying each employee's attendance data and working time data, it also includes: Conduct reasonableness analysis on the working hours of employees’ work projects; When the working hours do not meet the reasonableness conditions, mark the corresponding items and revise the working hours; and A working time record sheet is generated based on the original working time data, the items marked by rationality analysis and the corresponding revised working hours, and the working time record sheet is used as another evaluation record data of employee occupation of resources.
5. The method for evaluating employee resource usage according to claim 4, characterized in that: The working time data also includes the employee's role information and project progress information in the project. When the number of projects in the employee's working time data is one, the steps of analyzing the rationality of the working time include: Obtaining corresponding standard working hours based on the employee's role information and project progress information in the project; Compare the employee's working hours with the stated standard working hours; and In response to the difference between the working hours and the standard working hours being within a preset threshold range, it is determined that the employee's working hours meet rationality conditions; in response to the difference between the working hours and the standard working hours exceeding the preset threshold range, it is determined that the employee's working hours do not meet rationality conditions.
6. The method for evaluating employee resource usage according to claim 4, characterized in that: The working time data also includes the employee's role information in the project and the project progress information. When the employee's working time data includes multiple projects, the steps of analyzing the rationality of the working time include: Determine the corresponding standard working hours based on the employee's role in each project and the current progress; The project with the longest standard working hours is regarded as the employee's main project, and the remaining projects are regarded as the employee's secondary projects; The standard working time of each project is used as the maximum estimated time of the corresponding project, zero is used as the minimum estimated time of the secondary project, and the minimum difference between the standard working time of the main project and the standard working time of the secondary project is used as the minimum estimated time of the main project, so as to obtain the estimated working time range of each project; Compare the number of hours employees work on each project to the corresponding estimated work range; and In response to the working hours of a project being within the range of estimated working hours, it is determined that the working hours of the employee on the project meet the rationality condition; in response to the working hours of a project being beyond the range of estimated working hours, it is determined that the working hours of the employee on the project do not meet the rationality condition.
7. The method for evaluating employee resource usage according to claim 4, characterized in that: When there are multiple items in the employee's working time data, it further includes: Compare working hours across multiple projects; In response to the difference between the working hours of the multiple projects exceeding a threshold, a rationality analysis is performed on the working hours of each project, the rationality analysis comprising the following steps: Obtain the working hours of multiple employees on the same project at the current progress, and calculate the average working hours of the project at the current progress; Compare the number of hours employees work on each project to the average length of said projects; In response to the difference being within a preset difference threshold range, it is determined that the employee's working hours on the project meet rationality conditions; in response to the difference exceeding the preset difference threshold range, it is determined that the employee's working hours on the project do not meet rationality conditions.
8. The method for evaluating employee resource usage according to claim 4, characterized in that: The step of correcting the working time includes: multiplying the working time by a correction factor to obtain a corrected working time.
9. An evaluation device for employee resource usage, characterized in that: include: A data acquisition module configured to acquire employee attendance data from an attendance system; Acquire the employee's work time data on the work project from the management system, wherein the work time data at least includes the employee's work project and the work time; A verification module, configured to cross-verify the attendance data and working time data of each employee to obtain the effective working time of the employee; as well as The resource evaluation module calculates the cost data of each employee based on the cost data and the effective working hours of each employee; wherein the employee's cost data is a kind of evaluation record data of the resources occupied by the employee.
10. An electronic device comprising a processor and a memory, wherein a computer program instruction set is stored in the memory, wherein: When the processor executes the computer program instruction set on the memory, the method for evaluating employee occupied resources according to any one of claims 1 to 8 is implemented.
11. A computer-readable storage medium having a computer program instruction set stored thereon, characterized in that: When the computer program instruction set is executed by a processor, the method for evaluating employee resource occupation according to any one of claims 1 to 8 is implemented.
12. A computer program product comprising a set of computer program instructions, characterized in that: When the computer program instruction set is executed by a processor, the method for evaluating employee resource occupation according to any one of claims 1 to 8 is implemented.