Demand workload automatic generation method

Abstract

The invention discloses a demand workload automatic generation method, and relates to the technical field of operator business, and the method comprises the steps: pre-defining a standardized Excel table used for estimating or recording workload as a reference workload template; according to actual requirements, removing useless fields in the benchmark workload template, reserving necessary fields, and generating an Excel template for subsequent workload data entry and processing; recording the workload data in a sheet page of the Excel template; traversing all necessary field data in a sheet page under the Excel template and temporarily storing the necessary field data; performing grouping statistics, self-adaptive disassembly and calculation according to different necessary fields of the temporary storage data to generate corresponding workload instructions; and for different sub-functions under the same demand, summarizing workload instructions of the sub-functions, and combining the workload instructions into workload instruction documents corresponding to different demands. According to the invention, the generation of the required redundant workload can be solved, the efficiency of manually counting the required workload is greatly improved, and the labor cost is effectively saved.

Description

Technical Field

[0001] The present invention relates to the technical field of operator services, and in particular to a method for automatically generating demand workload. Background Art

[0002] With the continuous development of the communications industry, enterprises need to understand the cost required to complete various tasks. Workload statistics can provide basic data for cost accounting and understand the work status of each supporting manufacturer in order to make reasonable resource allocation and project planning. According to the clear workload definition and statistical standards, ensure that all personnel involved in the statistics understand and follow the unified rules and choose the appropriate statistical methods. However, manual recording will result in omissions and errors in data, so the use of professional workload automatic statistical methods can not only improve the accuracy of statistics, but also greatly reduce the cost of manual statistics. Summary of the invention

[0003] In order to solve the problem of redundant and error-prone demand workload generation, the present invention provides a method for automatically generating demand workload to solve the redundant workload generation of demand, improve the efficiency of manual demand workload statistics, and save labor costs.

[0004] The present invention provides a method for automatically generating required workload, and the technical solution adopted to solve the above technical problems is as follows:

[0005] A method for automatically generating required workload, comprising the following steps:

[0006] S1. Predefine a standardized Excel table for estimating or recording workload as a benchmark workload template;

[0007] S2. According to actual needs, remove useless fields from the benchmark workload template, retain necessary fields, and generate an Excel template for subsequent workload data entry and processing;

[0008] S3. Enter the workload data in the sheet page of the Excel template;

[0009] S4, traverse all necessary field data in the sheet page under the Excel template and temporarily store them;

[0010] S5. Perform grouping statistics, adaptive disassembly and calculation according to different necessary fields of the temporarily stored data to generate corresponding workload descriptions;

[0011] S6. For different sub-functions under the same requirement, summarize their workload descriptions and merge them into workload description documents corresponding to different requirements.

[0012] Optionally, the Excel template generated by executing step S2 includes the following necessary fields: function module, sub-function, function point count item name, modification type, AFP, estimated workload, and preliminary review workload.

[0013] Optionally, the function modules, sub-functions, function point count item names, modification types, AFPs, estimated workloads, and preliminary review workloads involved are written into the Excel template in the form of columns, where:

[0014] The column where the function module is located is used to fill in the requirement name, and you can choose whether to merge cells;

[0015] The column where the sub-function is located is used to fill in the specific required function points;

[0016] The column where the function point count item name is located is used to fill in the specific function point description. This column description contains keywords that are dynamically configured through the configuration file and are used for subsequent function point statistics.

[0017] The column where the modification type is located is used to fill in whether the current function point belongs to the new addition or modification, using the system enumeration value;

[0018] The column where AFP is located is used to fill in the workload value corresponding to the fixed type;

[0019] The column where the estimated workload is located is used to fill in the total workload value after aggregation, and the cells in the column need to be merged;

[0020] The column where the preliminary review workload is located is used to fill in the user-defined preliminary review workload value, and the cells in the column need to be merged.

[0021] Further optionally, based on multiple required workloads, the Excel template includes multiple sheet pages;

[0022] Before executing step S4, first check whether the Excel template contains one or multiple sheet pages:

[0023] If it is a sheet page, directly traverse the sheet page, convert the workload data of the sheet page into a built-in entity class and temporarily store it in the system running memory;

[0024] If there are multiple sheet pages, the multiple sheet pages are looped through, the workload data of each sheet page is converted into a built-in entity class and grouped and temporarily stored in the system running memory.

[0025] Further optionally, based on the principle that one required workload corresponds to one sheet page, step S5 is executed to generate a corresponding number of workload description documents according to the number of sheet pages.

[0026] Further optionally, the specific steps of executing step S5 to generate the workload description document are as follows:

[0027] a) Obtain the data temporarily stored in the system running memory and group the data once by sub-function options;

[0028] b) Based on the grouping result of step a), select and perform secondary grouping again according to the modification type;

[0029] c) Based on the grouping result of step b), dynamically match keywords according to the function point count item name, and create a key-value pair Map data type for storing data;

[0030] d) Determine whether the Map contains the matched keyword. If not, create a new key-value pair, use the matched keyword as the key, and store the estimated workload as the value in the current Map. If it does, obtain the estimated workload corresponding to the matched keyword and accumulate the estimated workload values.

[0031] e) Based on step d), loop through the Map key-value pairs, calculate the weight ratio according to the estimated workload value of the current function point and the total estimated workload, multiply the calculated weight by the total preliminary review workload to obtain the preliminary review workload value of the current function point, and generate the corresponding workload description;

[0032] f) When there are multiple sets of data temporarily stored in the system running memory, steps a) to e) are repeatedly executed for each set of data.

[0033] Preferably, the workload description documents involved include two formats: text document and word document.

[0034] Preferably, after executing step S6, the workload description document is packaged according to demand, and the packaged workload description document is sent to the front-end page for manual download by the user.

[0035] Compared with the prior art, the method for automatically generating required workload of the present invention has the following beneficial effects:

[0036] 1. The present invention can solve the problem of redundant workload generation of demand, greatly improve the efficiency of manual demand workload statistics, and effectively save labor costs;

[0037] 2. The present invention embodies the characteristics of automation, standardization and high efficiency, which helps to improve the accuracy and efficiency of demand workload estimation. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Attached Figure 1 It is a flow chart of the method of embodiment 1 of the present invention. DETAILED DESCRIPTION

[0039] In order to make the technical solution, the technical problem solved and the technical effect of the present invention more clearly understood, the technical solution of the present invention is clearly and completely described below in conjunction with specific embodiments.

[0040] Embodiment 1:

[0041] Combined with Figure 1 This embodiment proposes a method for automatically generating required workload, which includes the following steps:

[0042] S1. Predefine a standardized Excel spreadsheet for estimating or recording workload as a benchmark workload template.

[0043] S2. According to actual needs, remove useless fields in the benchmark workload template, retain necessary fields, and generate an Excel template for subsequent workload data entry and processing.

[0044] The Excel template for this step contains the following necessary fields: Function Module, Sub-Function, Function Point Count Item Name, Modification Type, AFP (Application Function Points), Estimated Workload, and Initial Review Workload. All necessary fields are written into the Excel template in columns, where:

[0045] The column where the function module is located is used to fill in the requirement name, and you can choose whether to merge cells;

[0046] The column where the sub-function is located is used to fill in the specific required function points;

[0047] The column where the function point count item name is located is used to fill in the specific function point description. This column description contains keywords that are dynamically configured through the configuration file and are used for subsequent function point statistics.

[0048] The column where the modification type is located is used to fill in whether the current function point belongs to the new addition or modification, using the system enumeration value;

[0049] The column where AFP is located is used to fill in the workload value corresponding to the fixed type;

[0050] The column where the estimated workload is located is used to fill in the total workload value after aggregation, and the cells in the column need to be merged;

[0051] The column where the preliminary review workload is located is used to fill in the user-defined preliminary review workload value, and the cells in the column need to be merged.

[0052] S3. Enter the workload data in the sheet page of the Excel template.

[0053] It should be added that, based on multiple required workloads, the Excel template includes multiple sheet pages.

[0054] S4. Detect whether the Excel template contains one or more sheet pages:

[0055] If it is a sheet page, directly traverse the sheet page, convert the workload data of the sheet page into a built-in entity class and temporarily store it in the system running memory;

[0056] If there are multiple sheet pages, the multiple sheet pages are looped through, the workload data of each sheet page is converted into a built-in entity class and grouped and temporarily stored in the system running memory.

[0057] S5. Based on the principle that one required workload corresponds to one sheet page, group statistics, adaptive disassembly and calculation are performed according to different necessary fields of the temporarily stored data, and the workload description of the corresponding number is generated according to the number of sheet pages, including:

[0058] a) Obtain the data temporarily stored in the system running memory and group the data once by sub-function options;

[0059] b) Based on the grouping result of step a), select and perform secondary grouping again according to the modification type;

[0060] c) Based on the grouping result of step b), dynamically match keywords according to the function point count item name, and create a key-value pair Map data type for storing data;

[0061] d) Determine whether the Map contains the matched keyword. If not, create a new key-value pair, use the matched keyword as the key, and store the estimated workload as the value in the current Map. If it does, obtain the estimated workload corresponding to the matched keyword and accumulate the estimated workload values.

[0062] e) Based on step d), loop through the Map key-value pairs, calculate the weight ratio according to the estimated workload value of the current function point and the total estimated workload, multiply the calculated weight by the total preliminary review workload to obtain the preliminary review workload value of the current function point, and generate the corresponding workload description;

[0063] f) When there are multiple sets of data temporarily stored in the system running memory, steps a) to e) are repeatedly executed for each set of data.

[0064] S6. For different sub-functions under the same requirement, summarize their workload descriptions and merge them into workload description documents corresponding to different requirements. The workload description documents include two formats: text document and word document.

[0065] After executing step S6, the workload description document is packaged according to the requirements, and the packaged workload description document is sent to the front-end page for manual download by the user.

[0066] In summary, the method for automatically generating demand workload of the present invention can solve the problem of redundant workload generation of demand, greatly improve the efficiency of manual demand workload statistics, and effectively save labor costs.

[0067] The above specific examples are used to explain the principles and implementation methods of the present invention in detail. These examples are only used to help understand the core technical content of the present invention. Based on the above specific embodiments of the present invention, any improvements and modifications made by technicians in this technical field without departing from the principles of the present invention should fall within the scope of patent protection of the present invention.

Claims

1. A method for automatically generating required workload, characterized in that: The steps include: S1. Predefine a standardized Excel table for estimating or recording workload as a benchmark workload template; S2. According to actual needs, remove useless fields from the benchmark workload template, retain necessary fields, and generate an Excel template for subsequent workload data entry and processing; S3. Enter the workload data in the sheet page of the Excel template; S4, traverse all necessary field data in the sheet page under the Excel template and temporarily store them; S5. Perform grouping statistics, adaptive disassembly and calculation according to different necessary fields of the temporarily stored data to generate corresponding workload descriptions; S6. For different sub-functions under the same requirement, summarize their workload descriptions and merge them into workload description documents corresponding to different requirements.

2. A method for automatically generating required workload according to claim 1, characterized in that: The Excel template generated by executing step S2 contains the following necessary fields: function module, sub-function, function point count item name, modification type, AFP, estimated workload, and preliminary review workload.

3. A method for automatically generating required workload according to claim 2, characterized in that: The function module, sub-function, function point count item name, modification type, AFP, estimated workload and preliminary review workload are written into the Excel template in the form of columns, where: The column where the function module is located is used to fill in the requirement name, and you can choose whether to merge cells; The column where the sub-function is located is used to fill in the specific required function points; The column where the function point count item name is located is used to fill in the specific function point description. This column description contains keywords that are dynamically configured through the configuration file and are used for subsequent function point statistics. The column where the modification type is located is used to fill in whether the current function point belongs to the new addition or modification, using the system enumeration value; The column where AFP is located is used to fill in the workload value corresponding to the fixed type; The column where the estimated workload is located is used to fill in the total workload value after aggregation, and the cells in the column need to be merged; The column where the preliminary review workload is located is used to fill in the user-defined preliminary review workload value, and the cells in the column need to be merged.

4. A method for automatically generating required workload according to claim 3, characterized in that: Based on multiple required workloads, the Excel template includes multiple sheet pages; Before executing step S4, first check whether the Excel template contains one or multiple sheet pages: If it is a sheet page, directly traverse the sheet page, convert the workload data of the sheet page into a built-in entity class and temporarily store it in the system running memory; If there are multiple sheet pages, the multiple sheet pages are looped through, the workload data of each sheet page is converted into a built-in entity class and grouped and temporarily stored in the system running memory.

5. A method for automatically generating required workload according to claim 4, characterized in that: Based on the principle that one required workload corresponds to one sheet page, step S5 is executed to generate a corresponding number of workload description documents according to the number of sheet pages.

6. A method for automatically generating required workload according to claim 5, characterized in that: The specific steps of executing step S5 to generate a workload description document are as follows: a) Obtain the data temporarily stored in the system running memory and group the data once by sub-function options; b) Based on the grouping result of step a), select and perform secondary grouping again according to the modification type; c) Based on the grouping result of step b), dynamically match keywords according to the function point count item name, and create a key-value pair Map data type for storing data; d) Determine whether the Map contains the matched keyword. If not, create a new key-value pair, use the matched keyword as the key, and store the estimated workload as the value in the current Map. If it does, obtain the estimated workload corresponding to the matched keyword and accumulate the estimated workload values. e) Based on step d), loop through the Map key-value pairs, calculate the weight ratio according to the estimated workload value of the current function point and the total estimated workload, multiply the calculated weight by the total preliminary review workload to obtain the preliminary review workload value of the current function point, and generate the corresponding workload description; f) When there are multiple sets of data temporarily stored in the system running memory, steps a) to e) are repeatedly executed for each set of data.

7. A method for automatically generating required workload according to claim 1, characterized in that: The workload description document includes two formats: text document and word document.

8. The method for automatically generating required workload according to claim 1, characterized in that: After executing step S6, the workload description document is packaged according to the requirements, and the packaged workload description document is sent to the front-end page for manual download by the user.

Images