A project data processing method and system

Abstract

The present invention discloses a project data processing method and system, which relates to the field of big data technology, in order to solve the problem of high project delay losses in existing project management methods. The method includes: obtaining project progress data of each project in a project list; determining the expected completion status of the project list according to a first remaining time and a second remaining time, and classifying the projects according to the expected completion status to obtain project groups of different levels; sorting the projects in the project groups of different levels to obtain an initial project sorting scheme; monitoring the initial project sorting scheme according to a safety threshold, adjusting the safety time of the projects whose target difference is less than the safety threshold, and obtaining a target project sorting scheme; allocating the projects in the target project sorting scheme to complete the project. The project data processing method provided by the present invention is used to increase the risk control of the project and reduce the delay losses of the project.

Description

Technical Field

[0001] The present invention relates to the field of big data technology, and in particular to a project data processing method and system. Background Art

[0002] Project management refers to the effective management of all work involved in a project through planning, scheduling, organization, leadership, and control in order to achieve the project's goals. Existing project management only sorts projects according to a single indicator such as project duration or project delay loss, and then processes the sorted projects in order. However, if there are a large number of parallel projects and some of them are overdue or about to expire, sorting by a single indicator will easily increase the number of delayed projects and project delay losses. Summary of the invention

[0003] The object of the present invention is to provide a project data processing method and system for increasing the risk control of projects and reducing the losses caused by project delays.

[0004] In order to achieve the above object, the present invention provides the following technical solutions:

[0005] In a first aspect, the present invention provides a project data processing method, comprising:

[0006] Obtain project progress data for each project in the project list; the project progress data includes project safety time, project node date and project remaining duration;

[0007] Determine the expected completion status of the project list according to the first remaining time and the second remaining time, classify the projects according to the expected completion status, and obtain project groups of different levels; the first remaining time is the difference between the second remaining time and the project safety time; the second remaining time is the difference between the project node date and the remaining duration of the project;

[0008] Sorting the projects in the project groups of different levels to obtain an initial project sorting scheme;

[0009] The initial project ranking scheme is monitored according to the safety threshold, and the safety time of the projects whose target difference is less than the safety threshold is adjusted to obtain a target project ranking scheme; the target difference is the difference between the number of the first remaining time less than zero and the number of the second remaining time less than zero in the initial project ranking scheme;

[0010] Allocate the projects in the target project ranking plan to complete the projects.

[0011] Compared with the prior art, in the project data processing method provided by the present invention, the importance of the project is quantified by the project safety time, and then the expected completion status of the project list is determined by the first remaining time and the second remaining time calculated according to the project safety time, the project node date and the remaining project period, and the projects are graded according to the expected completion status to obtain project groups of different levels; then the projects in the project groups of different levels are sorted to obtain an initial project sorting scheme; considering the importance of the project, the sorting scheme can ensure that as many important projects as possible are completed first within a limited time, increase the risk control of the project, and ensure that important projects are completed on schedule as much as possible when some projects cannot be completed, monitor the initial project sorting scheme according to the safety threshold, adjust the project safety time of the project with a target difference less than the safety threshold, and obtain a target project sorting scheme, and by monitoring and adjusting the project safety time, the arrangement of the project safety time can be made more reasonable, avoiding the situation where too many projects cannot be completed after reserving the project safety time, and effectively reducing the project delay loss in multiple parallel projects.

[0012] In a second aspect, the present invention provides a project data processing system, comprising:

[0013] A project progress data acquisition module is used to acquire the project progress data of each project in the project list; the project progress data includes project safety time, project node date and project remaining duration;

[0014] A level classification module is used to determine the expected completion status of the project list according to the first remaining time and the second remaining time, and to classify the projects according to the expected completion status to obtain project groups of different levels; the first remaining time is the difference between the second remaining time and the project safety time; the second remaining time is the difference between the project node date and the remaining duration of the project;

[0015] A sorting module, used for sorting the projects in the project groups of different levels to obtain an initial project sorting scheme;

[0016] A monitoring module is used to monitor the initial project sorting scheme according to a safety threshold, adjust the safety time of the project whose target difference is less than the safety threshold, and obtain a target project sorting scheme; the target difference is the difference between the number of the first remaining time less than zero and the number of the second remaining time less than zero in the initial project sorting scheme;

[0017] The output module is used to allocate the projects in the target project sorting scheme to complete the projects.

[0018] Compared with the prior art, the beneficial effects of the project data processing system provided by the present invention are the same as the beneficial effects of the project data processing method described in the above technical solution, which will not be elaborated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0020] Figure 1 A flow chart of a project data processing method provided by the present invention;

[0021] Figure 2 A flow chart of the level classification provided by the present invention;

[0022] Figure 3 A flow chart of the feedback mechanism provided by the present invention;

[0023] Figure 4 A schematic diagram of the structure of a project data processing system provided by the present invention. DETAILED DESCRIPTION

[0024] In order to facilitate the clear description of the technical solutions of the embodiments of the present invention, in the embodiments of the present invention, the words "first", "second" and the like are used to distinguish the same items or similar items with substantially the same functions and effects. For example, the first threshold and the cycle threshold are only used to distinguish different thresholds, and do not limit their order. Those skilled in the art can understand that the words "first", "second" and the like do not limit the quantity and execution order, and the words "first", "second" and the like do not necessarily limit them to be different.

[0025] It should be noted that, in the present invention, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in the present invention should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0026] In the present invention, "at least one" means one or more, and "plurality" means two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, the combination of a and b, the combination of a and c, the combination of b and c, or the combination of a, b and c, where a, b, c can be single or multiple.

[0027] Project management refers to the effective management of all work involved in a project through planning, scheduling, organization, leadership, and control in order to achieve the project's goals. This process covers the entire process from the investment decision to the end of the project, including planning, organization, command, coordination, control, and evaluation. Existing project management usually uses a single indicator to prioritize projects, which may result in important projects not being completed, increasing losses.

[0028] To solve the above problems, this application provides a project data processing method and system. In multiple parallel projects, each project has multiple time points. How to determine the priority order of the projects according to the completion status and unfinished losses of each project and how to determine the notification intensity can increase the risk control of the project and minimize the project delay losses, which has become the focus of project data analysis and processing. The following is an explanation with reference to the accompanying drawings.

[0029] Figure 1 A flowchart of a project data processing method provided by the present invention, the project data processing method comprises the following steps:

[0030] Step 101: Obtain project progress data for each project in the project list;

[0031] Project progress data includes project safety time, project node date, project safety node date, project remaining duration and project delay loss;

[0032] Among them, the project node date represents the actual time from today to the required delivery date of the project. The project safety time represents the time that needs to be reserved for completing the project before the required delivery date of the project, that is, how many days in advance the project needs to be completed, that is, the number of days the leader requires to be completed in advance. The longer the project safety time, the more important the project is. The project safety node date is the difference between the project node date and the project safety time. The remaining project period represents how many days are left to complete the project. The project delay loss represents the amount of loss caused by the project if it is not completed on the project node date. Among them, the project delay loss and project safety time are pre-stored in the database. The remaining project period and project node date can be entered by the project leader according to the actual situation.

[0033] For example, the list of items is shown in Table 1:

[0034] Table 1 Item List

[0035]

[0036] Step 102: determining the expected completion status of the project list according to the first remaining time and the second remaining time, and classifying the projects according to the expected completion status to obtain project groups of different levels;

[0037] The first remaining time is the difference between the second remaining time and the project safety time, that is, the difference between the project safety node date and the remaining duration of the project, that is, how much time is left until the date when the leader requires the project to be completed; the second remaining time is the difference between the project node date and the remaining duration of the project, that is, how much surplus time the project actually has.

[0038] See also Figure 2 , step 102 specifically includes:

[0039] Traverse the first remaining time of each item in the project list, and determine whether the project list contains any item with a first remaining time less than zero; if the project list does not contain any item with a first remaining time less than zero, sort the items in the project list based on the project sorting scheme prediction model, or sort them in ascending order according to the absolute value of the first remaining time or the second remaining time.

[0040] If the project list contains projects with a first remaining time less than zero, then the second remaining time of each project with a first remaining time less than zero is traversed, and it is determined whether each project with the first remaining time less than zero contains a project with a second remaining time less than zero; if each project with a first remaining time less than zero contains a project with a second remaining time less than zero, then the expected completion status of the project list is determined as the first expected completion status; if each project with a first remaining time less than zero does not contain a project with a second remaining time less than zero, then the expected completion status of the project list is determined as the second expected completion status; the first expected completion status is the situation where the probability of completion of all projects in the project list is less than 100%, that is, the project list contains projects that are expected to be unable to be completed on schedule, and the second expected completion status is the situation where the probability of completion of all projects in the project list is equal to 100%, that is, the projects in the project list are expected to be completed on schedule;

[0041] When the expected completion status of the project list is the first expected completion status, the project whose first remaining time is less than zero and whose second remaining time is less than zero is saved in the first-level project group; the project whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero is saved in the third-level project group; the project whose first remaining time and second remaining time are both greater than or equal to zero is saved in the second-level project group;

[0042] When the expected completion status of the project list is the second expected completion status, the projects whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero are saved in the second-level project group; the projects whose first remaining time and second remaining time are both greater than or equal to zero are saved in the first-level project group to obtain different-level project groups; the processing priority of the third-level project group is higher than that of the second-level project group, and the processing priority of the second-level project group is higher than that of the first-level project group. The projects in the third-level project group are projects that can actually be completed but cannot be completed in advance. That is, although they have not exceeded the actual processing deadline, they will be overdue if they are not processed. Such level classification can ensure that the projects that can actually be completed can be completed on schedule.

[0043] Exemplarily, in the above steps, first check whether there are any projects that cannot be completed on the project safety node day arranged by the leader. If not, sort the projects in the project list based on the project sorting scheme prediction model, or sort them in order from small to large according to the first remaining time or the second remaining time. If there are, determine whether it cannot be completed in reality. If so, that is, if it cannot be completed in reality, save the project to the first-level project group, and arrange the projects that cannot be completed on the project safety node day arranged by the leader but can be completed on the actual project node day in the third-level project group with the highest priority, and the others are saved in the second-level project group in the middle echelon; if not, that is, they can all be completed in reality, then configure the second-level project group and the first-level project group in the front echelon, and finally sort them roughly according to the third-level project group, the second-level project group, and the first-level project group, and the internal sorting of each echelon is sorted according to the method of step 103.

[0044] Step 103: sorting the items in the item groups of different levels to obtain an initial item sorting scheme;

[0045] As an optional method, the projects in the project groups of different levels in step 103 can be arranged from small to large according to the absolute value of the first remaining time or the second remaining time. For example, when the expected completion status of the project list is the first expected completion status, the projects in the third-level project group are arranged in the order of the absolute value of the second remaining time from small to large, the projects in the second-level project group are arranged in the order of the absolute value of the second remaining time from small to large, and the projects in the first-level project group are arranged in the order of the absolute value of the second remaining time from small to large, so as to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority;

[0046] Outputting the initial project ranking scheme in the order of the project ranking scheme corresponding to the third level, the project ranking scheme corresponding to the second level, and the project ranking scheme corresponding to the first level;

[0047] When the expected completion status of the project list is the second expected completion status, the projects in the second-level project group are arranged in ascending order of the second remaining time, and the projects in the first-level project group are arranged in ascending order of the second remaining time, to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority;

[0048] The initial project ranking scheme is output in the order of the project ranking scheme corresponding to the second level and the project ranking scheme corresponding to the first level.

[0049] As another optional method, the projects in the project groups of different levels in step 103 may be sorted according to a convolutional neural network method. Specifically, the projects in the project groups of different levels are sorted to obtain an initial project sorting scheme including:

[0050] First, training samples are obtained, wherein the training samples include project progress data training samples and project sequencing scheme training samples;

[0051] According to formula (1):

[0052] E = ax + by + cz + dw + fv (1)

[0053] Assigning weights to the project progress data training samples to obtain the weighted project progress data training samples;

[0054] Among them, E is the training sample of project progress data after weight assignment, a is the weight of project safety time, x is the training sample of project safety time, b is the weight of project node day, y is the training sample of project node day, c is the weight of project remaining duration, z is the training sample of project remaining duration, d is the weight of project delay loss, w is the training sample of project delay loss, f is the weight of project safety node day, and v is the training sample of project safety node day; weight assignment can be performed according to demand, for example, the weight of project safety time is higher than the weight of other parameters, or the weight of project delay loss is higher than the weight of other parameters. The training samples of project ranking schemes are multiple preferred schemes.

[0055] The initial convolutional neural network model is trained according to the project progress data training samples and project sorting scheme training samples after weight assignment to obtain a trained project sorting scheme prediction model.

[0056] Then, the project progress data is preprocessed to obtain preprocessed project progress data; the preprocessing includes but is not limited to data cleaning, format conversion and standardization processing to ensure the consistency of the data and suitability for subsequent processing, that is, the project safety time, project safety node date, project node date, project remaining duration, and project delay loss are processed into a format that can be processed by the convolutional neural network.

[0057] The preprocessed project progress data is input into the trained project sequencing prediction model to obtain a predicted project sequencing plan; the predicted project sequencing plan is a plurality of project sequencing plans within a preset time unit, and the preset time unit can be one year, half a year, one quarter, one month or one week.

[0058] The total value of project delay losses of each forecast project ranking scheme is obtained based on the project delay losses;

[0059] The predicted project ranking scheme with the smallest total value of project delay loss is determined as the initial project ranking scheme. The projects are ranked in the first-level project group, the second-level project group, and the third-level project group according to the initial project ranking scheme.

[0060] As another optional method, the items in the project list may be sorted as a whole according to the initial project sorting scheme, that is, the project sorting scheme prediction model may be used to sort all the items in the project list together, or the project list may be first divided into first-level project groups, second-level project groups, and third-level project groups, and then the project sorting scheme prediction model may be used to sort the items in the first-level project groups, second-level project groups, and third-level project groups respectively.

[0061] In addition, the project ranking scheme prediction model also includes activation functions and dropout regularization techniques to prevent the model from overfitting during the training process.

[0062] As another possible approach, projects in project groups of different levels or all projects in a project list are sorted by enumeration to obtain multiple plans, and the project with the lowest total value of delay loss is determined as the initial project sorting plan.

[0063] Step 104: The initial project ranking scheme is monitored according to the safety threshold, and the safety time of the projects whose target difference is less than the safety threshold is adjusted to obtain a target project ranking scheme; the target difference is the difference between the number of the first remaining time less than zero and the number of the second remaining time less than zero in the initial project ranking scheme;

[0064] This application provides two feedback mechanisms. The first feedback mechanism is to monitor the target difference, and the second feedback mechanism is to monitor the number of times the project safety time is reduced. For details, see Figure 3 , this application provides a feedback mechanism to monitor the initial project sorting scheme. At the beginning, it is first determined whether the target difference is less than the safety threshold. If it is not less than, the initial project sorting scheme is the target project sorting scheme; if it is less than, the project safety time is reduced by a preset percentage Then, re-sort the projects according to the reduced project safety time, that is, jump to step 101 and execute steps 101 to 103. After obtaining a new initial project sorting scheme, continue to determine whether the new target difference in the new initial project sorting scheme is less than the safety threshold. If it is less, jump to the project safety time reduction preset percentage If it is not less than, determine whether the number of times the project safety time is reduced is greater than the cycle threshold. If not, the final initial project sorting scheme is the target project sorting scheme; if so, determine whether the project with the first remaining time less than 0 and other projects with the first remaining time not less than 0 are related projects. If not, the final initial project sorting scheme is the target project sorting scheme, or sort the projects in the project list from small to large according to the absolute value of the second remaining time to output the target project sorting scheme. If they are related projects, determine whether this group of related projects has a project with the second remaining time less than 0. If so, save this group of related projects to the first-level project group. If not, merge these related projects into one project, combine all their data indicators, and jump to step 101 to execute steps 101 to 103.

[0065] As an optional method, before step 104, the following steps may also be included:

[0066] Traverse the first remaining time and the second remaining time of each project in the initial project sorting scheme, and determine whether the first remaining time and the second remaining time of each project are less than zero. If the first remaining time is less than zero, according to formula (2):

[0067] (2)

[0068] The number of first remaining time less than zero in the initial project sorting scheme is obtained by counting; if the first remaining time is not less than 0, the first remaining time of the next project is determined.

[0069] in, To traverse to When the first remaining time is less than zero, For the projects, The value of is 1, 2, 3... n; n is the total number of projects in the initial project processing plan, n is greater than 0, The value is 0;

[0070] If the second remaining time is less than zero, according to formula (3):

[0071] (3)

[0072] The number of second remaining times in the initial project sorting scheme is obtained by counting; if the second remaining time is not less than 0, the second remaining time of the next project is determined.

[0073] in, To traverse to When the second remaining time is less than zero, The value is 0;

[0074] According to formula (4):

[0075] (4)

[0076] Calculate the target difference; where, is the target difference.

[0077] As an optional method, the first feedback mechanism is a specific step of step 104: judging whether the target difference in the initial project ranking scheme is less than the safety threshold; if the target difference is less than the safety threshold, according to formula (5):

[0078] (5)

[0079] Reduce the project safety time and calculate the new project safety time based on the reduced project safety time;

[0080] in, To reduce the project safety time, The preset percentage of the project safety time reduction, such as 5%, 6%, etc.; The number of times the project safety time is reduced; is a positive integer; The safety threshold is 3% or 4% of the total number of projects. It can be 5%. When the target difference is less than 3% of the total number of projects, the project safety time is reduced by 5% each time, and the process jumps to step 101.

[0081] Determine a new project ranking scheme based on the new project safety time, that is, loop through steps 101 to 103, and continue to determine whether the target difference of the new project ranking scheme is less than the safety threshold, until the target difference of the new project ranking scheme is equal to the safety threshold, and obtain the target project ranking scheme and the number of times the project safety time is reduced. If the number of times the project safety time is reduced exceeds the loop threshold, the target project ranking scheme is outputted in order from small to large according to the absolute value of the second remaining time.

[0082] In other words, the project safety time arranged by the leader should be reasonable, so that there should not be many projects that cannot be completed within the time arranged by the leader. This should only account for about 3% of the total projects. If most of the projects set by the leader cannot be completed, the project safety time should be reduced and the above method should be run again. However, after multiple adjustments, if the proportion of projects that cannot be completed by the leader is still too large, the order should be directly sorted according to the actual situation.

[0083] As an optional method, the method further includes determining a new project ranking scheme according to the new project safety time, and continuously judging whether the target difference of the new project ranking scheme is less than the safety threshold until the target difference of the new project ranking scheme is equal to the safety threshold. After obtaining the target project ranking scheme and the number of times the project safety time is reduced, the method further includes:

[0084] According to the number of times the project safety time is reduced, the warning information is sent to the target user according to the preset rules; the preset rules are that the higher the number of times the project safety time is reduced, the higher the number of target users sent, and the higher the authority of the target user. The authority can be a job level. Exemplarily, the rules for sending warning information can be shown in Table 2.

[0085] Table 2 Warning information personnel notification table

[0086]

[0087] The more times the above-mentioned project safety time is reduced, the more unreasonable the project safety time designated by the representative leader is, and the greater the adjustment range designated by the representative leader is, and the more leaders or leaders of higher levels should be informed.

[0088] As an optional method, the second feedback mechanism is specifically as follows: determining a new project ranking scheme according to the new project safety time, continuing to judge whether the target difference of the new project ranking scheme is less than the safety threshold, until the target difference of the new project ranking scheme is equal to the safety threshold, and then further comprising:

[0089] Determine whether, in the project sorting scheme corresponding to the number of times the project safety time is reduced being greater than the cycle threshold, the project with the first remaining time less than zero is a related project with other projects with the first remaining time greater than or equal to zero;

[0090] If there are related projects, and the related projects include projects whose second remaining time is less than zero, then the related projects including the projects whose second remaining time is less than zero are saved in the first-level project group;

[0091] If there are related projects, and the related projects do not contain a project whose second remaining time is less than zero, the related projects are merged to obtain a merged project; the merged project includes the first project and the second project; the first remaining time and the second remaining time of the merged project are taken as the relative average value according to the ratio of the project node days;

[0092] Specifically, according to formula (6):

[0093] G0=(I1 / (I1+I2)×G1+I2 / (I1+I2)×G2) (6)

[0094] Calculate the first remaining time of the merged project;

[0095] Wherein, G0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, G1 is the first remaining time of the first project, and G2 is the first remaining time of the second project;

[0096] For example, if item 1 and item 3 in Table 1 are related items, then the first remaining time of the combined items may be: (20 / (20+30))×8+(30 / (20+30))×27=19.4.

[0097] According to formula (7):

[0098] Q0=(I1 / (I1+I2)×Q1+I2 / (I1+I2)×Q2)(7)

[0099] Calculate the second remaining time of the combined project;

[0100] Among them, Q0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, Q1 is the second remaining time of the first project, and Q2 is the second remaining time of the second project;

[0101] For example, if item 1 and item 3 in Table 1 are related items, then the second remaining time of the combined items may be: (20 / (20+30))×13+(30 / (20+30))×28=22.

[0102] According to the calculated first remaining time of the merged project and the second remaining time of the merged project, the project list containing the merged project is re-sorted to obtain a target project sorting scheme. In this way, a new project is generated and the process jumps to step 101 to start the loop. Each time a project is merged, only two projects are merged. In other words, the present invention merges related projects and re-loops after the number of times the project safety time is reduced exceeds the loop threshold, thereby changing the difference between the original number of first remaining times less than 0 and the number of second remaining times less than 0, thereby improving the rationality of the project scheme adjustment.

[0103] Step 105: Allocate the projects in the target project ranking scheme to complete the projects.

[0104] Compared with the prior art, in the project data processing method provided by the present invention, the importance of the project is quantified by the project safety time, and then the expected completion of the project list is determined by the first remaining time and the second remaining time calculated according to the project safety time, the project node date and the remaining duration of the project, and the project is graded according to the expected completion to obtain project groups of different levels; and then the projects in the project groups of different levels are sorted to obtain an initial project sorting scheme; considering the importance of the project, the sorting scheme can ensure that as many important projects as possible are completed first within a limited time, increase the risk control of the project, so that when some projects cannot be completed, important projects are completed on schedule as much as possible, and the initial project sorting scheme is monitored according to the safety threshold, and the project safety time with a target difference less than the safety threshold is adjusted to obtain a target project sorting scheme, and by monitoring and adjusting the project safety time, the arrangement of the project safety time can be made more reasonable, avoiding the situation where too many projects cannot be completed after reserving the project safety time, and effectively reducing the project delay loss in multiple parallel projects. Through the feedback mechanism, the project plan can be reasonably adjusted. Generally, projects with large losses need to be completed relatively early to have a better sense of project security. Even if it is necessary to give up small projects in order to complete the projects with large losses as early as possible, it is necessary to ensure that the large projects can be completed smoothly. This is the core idea of ​​this application.

[0105] The embodiment of the present invention can divide the functional modules according to the above method example. For example, each functional module can be divided according to each function, or two or more functions can be integrated into one processing module. The above integrated module can be implemented in the form of hardware or in the form of software functional modules. It should be noted that the division of modules in the embodiment of the present invention is schematic and is only a logical function division. There may be other division methods in actual implementation.

[0106] In the case of dividing each functional module into corresponding functional modules, Figure 4 FIG. 1 shows a schematic diagram of the structure of a project data processing system provided by the present invention. Figure 4 As shown, the system includes:

[0107] The project progress data acquisition module 401 is used to acquire the project progress data of each project in the project list; the project progress data includes the project safety time, the project node date and the remaining duration of the project;

[0108] A level classification module 402 is used to determine the expected completion status of the project list according to the first remaining time and the second remaining time, and to classify the projects according to the expected completion status to obtain project groups of different levels; the first remaining time is the difference between the second remaining time and the project safety time; the second remaining time is the difference between the project node date and the remaining duration of the project;

[0109] A sorting module 403 is used to sort the projects in the project groups of different levels to obtain an initial project sorting scheme;

[0110] Monitoring module 404, used to monitor the initial project sorting scheme according to the safety threshold, adjust the safety time of the projects whose target difference is less than the safety threshold, and obtain the target project sorting scheme; the target difference is the difference between the number of the first remaining time less than zero and the number of the second remaining time less than zero in the initial project sorting scheme;

[0111] The output module 405 is used to allocate the projects in the target project sorting scheme to complete the projects.

[0112] Optionally, the level classification module 402 includes:

[0113] A first remaining time or not less than 0 judging unit, used for traversing the first remaining time of each item in the item list, and judging whether the item list contains an item whose first remaining time is less than zero;

[0114] A unit for judging whether the second remaining time is less than 0 is used to, if the project list contains a project with a first remaining time less than zero, traverse the second remaining time of each project with a first remaining time less than zero, and judge whether each project with the first remaining time less than zero contains a project with a second remaining time less than zero; if each project with a first remaining time less than zero contains a project with a second remaining time less than zero, determine the expected completion status of the project list as the first expected completion status; if each project with a first remaining time less than zero does not contain a project with a second remaining time less than zero, determine the expected completion status of the project list as the second expected completion status; the first expected completion status is the situation where the probability of completion of all projects in the project list is less than 100%, and the second expected completion status is the situation where the probability of completion of all projects in the project list is equal to 100%;

[0115] A first expected completion status level classification unit is used to save, when the expected completion status of the project list is the first expected completion status, projects whose first remaining time is less than zero and whose second remaining time is less than zero into the first level project group; save projects whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero into the third level project group; and save projects whose first remaining time and second remaining time are both greater than or equal to zero into the second level project group;

[0116] The second expected completion status level classification unit is used to save the projects whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero into the second level project group when the expected completion status of the project list is the second expected completion status; save the projects whose first remaining time and second remaining time are both greater than or equal to zero into the first level project group to obtain project groups of different levels; the processing priority of the third level project group is higher than the processing priority of the second level project group, and the processing priority of the second level project group is higher than the processing priority of the first level project group.

[0117] Optionally, the sorting module 403 is specifically used for:

[0118] When the expected completion status of the project list is the first expected completion status, the projects in the third-level project group are arranged in ascending order according to the absolute value of the second remaining time, the projects in the second-level project group are arranged in ascending order according to the absolute value of the second remaining time, and the projects in the first-level project group are arranged in descending order according to the absolute value of the second remaining time, to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority;

[0119] Outputting the initial project ranking scheme in the order of the project ranking scheme corresponding to the third level, the project ranking scheme corresponding to the second level, and the project ranking scheme corresponding to the first level;

[0120] When the expected completion status of the project list is the second expected completion status, the projects in the second-level project group are arranged in ascending order according to the absolute value of the second remaining time, and the projects in the first-level project group are arranged in ascending order according to the absolute value of the second remaining time, so as to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority;

[0121] The initial project ranking scheme is output in the order of the project ranking scheme corresponding to the second level and the project ranking scheme corresponding to the first level.

[0122] Optionally, the project progress data also includes project delay losses; the sorting module 403 may also be used to:

[0123] Preprocessing the project progress data to obtain preprocessed project progress data;

[0124] Input the preprocessed project progress data into the trained project sequencing prediction model to obtain a predicted project sequencing plan;

[0125] The total value of project delay losses of each forecast project ranking scheme is obtained based on the project delay losses;

[0126] The predicted project sorting scheme with the smallest total value of project delay losses is determined as the initial project sorting scheme.

[0127] Optionally, the project progress data also includes a project safety node day, which is the difference between the project node day and the project safety time. The system also includes: a project sequencing scheme prediction model training module, including:

[0128] A training sample acquisition unit, used to acquire training samples, wherein the training samples include project progress data training samples and project sequencing scheme training samples;

[0129] According to the formula:

[0130] E=ax+by+cz+dw+fv

[0131] A weight assignment unit, used to assign weights to the project progress data training samples to obtain the project progress data training samples after weight assignment;

[0132] Among them, E is the training sample of project progress data after weight assignment, a is the weight of project safety time, x is the training sample of project safety time, b is the weight of project node day, y is the training sample of project node day, c is the weight of project remaining duration, z is the training sample of project remaining duration, d is the weight of project delay loss, w is the training sample of project delay loss, f is the weight of project safety node day, and v is the training sample of project safety node day;

[0133] The training unit is used to train the initial convolutional neural network model according to the project progress data training samples and the project sorting scheme training samples after weight assignment, so as to obtain a trained project sorting scheme prediction model.

[0134] Optionally, the system further includes a target difference calculation module, which is used to:

[0135] Traverse the first remaining time and the second remaining time of each project in the initial project sorting scheme, and determine whether the first remaining time and the second remaining time of each project are less than zero. If the first remaining time is less than zero, according to the formula:

[0136] ;

[0137] Count the number of initial project sorting solutions where the first remaining time is less than zero;

[0138] in, To traverse to When the first remaining time is less than zero, For the projects, The value of is 1, 2, 3... n; n is the total number of projects in the initial project processing plan, and n is greater than 0; The value is 0;

[0139] If the second remaining time is less than zero, according to the formula:

[0140] ;

[0141] Count and obtain the number of the second remaining time in the initial project sorting scheme;

[0142] in, To traverse to When the second remaining time is less than zero, The value is 0;

[0143] According to the formula:

[0144] ;

[0145] Calculate the target difference;

[0146] in, is the target difference.

[0147] Optionally, the monitoring module 404 may specifically include:

[0148] The safety threshold judgment unit is used to judge whether the target difference in the initial project sorting scheme is less than the safety threshold. If the target difference is less than the safety threshold, according to the formula:

[0149] ;

[0150] The new project safety time determination unit is used to reduce the project safety time and calculate the new project safety time according to the reduced project safety time; wherein, To reduce the project safety time, The percentage of reduction in project safety time; The number of times the project safety time is reduced; is a positive integer; Project safety time in the initial project ranking scheme;

[0151] The loop unit is used to determine a new project sorting scheme based on the new project safety time, and continue to judge whether the target difference of the new project sorting scheme is less than the safety threshold, until the target difference of the new project sorting scheme is equal to the safety threshold, to obtain the target project sorting scheme and the number of times the project safety time is reduced.

[0152] Optionally, the system further includes an early warning module, which is used to:

[0153] According to the number of times the project safety time is reduced, a warning message is sent to the target user according to a preset rule; the preset rule is that the higher the number of times the project safety time is reduced, the higher the number of target users sent, and the higher the authority of the target user.

[0154] Optionally, the system further includes an associated project processing module, which is used to:

[0155] Determine whether, in the project sorting scheme corresponding to the number of times the project safety time is reduced being greater than the cycle threshold, the project with the first remaining time less than zero is a related project with other projects with the first remaining time greater than or equal to zero;

[0156] If there are related projects, and the related projects include a project whose second remaining time is less than zero, the related projects including the project whose second remaining time is less than zero are determined as the first level;

[0157] If there are related projects, and the related projects do not contain a project whose second remaining time is less than zero, the related projects are merged to obtain a merged project; the merged project includes the first project and the second project;

[0158] According to the formula:

[0159] G0=(I1 / (I1+I2)×G1+I2 / (I1+I2)×G2);

[0160] Calculate the first remaining time of the merged project;

[0161] Wherein, G0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, G1 is the first remaining time of the first project, and G2 is the first remaining time of the second project;

[0162] According to the formula:

[0163] Q0=(I1 / (I1+I2)×Q1+I2 / (I1+I2)×Q2);

[0164] Calculate the second remaining time of the combined project;

[0165] Among them, Q0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, Q1 is the second remaining time of the first project, and Q2 is the second remaining time of the second project;

[0166] The project list including the merged project is re-sorted according to the calculated first remaining time of the merged project and the second remaining time of the merged project to obtain a target project sorting scheme.

[0167] In the above embodiments, all or part of the embodiments may be implemented by software, hardware, firmware or any combination thereof. When implemented by software, all or part of the embodiments may be implemented in the form of a computer program product. The computer program product includes one or more computer programs or instructions. When the computer program or instruction is loaded and executed on a computer, the process or function described in the embodiment of the present invention is executed in whole or in part. The computer may be a general-purpose computer, a special-purpose computer, a computer network, a terminal, a user device or other programmable device. The computer program or instruction may be stored in a computer-readable storage medium or transmitted from one computer-readable storage medium to another computer-readable storage medium. For example, the computer program or instruction may be transmitted from one website, computer, server or data center to another website, computer, server or data center by wired or wireless means. The computer-readable storage medium may be any available medium that a computer can access or a data storage device such as a server or data center that integrates one or more available media. The available medium may be a magnetic medium, such as a floppy disk, a hard disk, or a tape; it may also be an optical medium, such as a digital video disc (DVD); it may also be a semiconductor medium, such as a solid state drive (SSD).

[0168] Although the present invention is described herein in conjunction with various embodiments, in the process of implementing the claimed invention, those skilled in the art may understand and implement other variations of the disclosed embodiments by viewing the drawings, the disclosure, and the appended claims. In the claims, the word "comprising" does not exclude other components or steps, and "one" or "an" does not exclude multiple situations. A single processor or other unit may implement several functions listed in a claim. Certain measures are recorded in different dependent claims, but this does not mean that these measures cannot be combined to produce good results.

[0169] Although the present invention has been described in conjunction with specific features and embodiments thereof, it is apparent that various modifications and combinations may be made thereto without departing from the spirit and scope of the present invention. Accordingly, this specification and the accompanying drawings are merely exemplary illustrations of the present invention as defined by the appended claims and are deemed to cover any and all modifications, variations, combinations or equivalents within the scope of the present invention. Obviously, those skilled in the art may make various modifications and variations to the present invention without departing from the spirit and scope of the present invention. Thus, the present invention is intended to include such modifications and variations if they fall within the scope of the claims of the present invention and their equivalents.

Claims

1. A project data processing method, characterized in that: include: Obtain project progress data for each project in the project list; the project progress data includes project safety time, project node date and project remaining duration; Determine the expected completion status of the project list according to the first remaining time and the second remaining time, classify the projects according to the expected completion status, and obtain project groups of different levels; the first remaining time is the difference between the second remaining time and the project safety time; the second remaining time is the difference between the project node date and the remaining duration of the project; Sorting the projects in the project groups of different levels to obtain an initial project sorting scheme; The initial project ranking plan is monitored according to the safety threshold, and the safety time of the project whose target difference is less than the safety threshold is adjusted to obtain the target project ranking plan; The target difference is the difference between the number of items with a first remaining time less than zero and the number of items with a second remaining time less than zero in the initial item sorting scheme; The initial project ranking scheme is monitored according to the safety threshold, and the safety time of the project whose target difference is less than the safety threshold is adjusted to obtain the target project ranking scheme, which includes: Determine whether the target difference in the initial project sorting scheme is less than the safety threshold. If the target difference is less than the safety threshold, then according to the formula: ； Reduce the project safety time, and calculate the new project safety time based on the reduced project safety time; where: To reduce the project safety time, The percentage of reduction in project safety time; The number of times the project safety time is reduced; is a positive integer; Project safety time in the initial project ranking scheme; Determine a new project ranking scheme according to the new project safety time, and continue to determine whether the target difference of the new project ranking scheme is less than the safety threshold, until the target difference of the new project ranking scheme is equal to the safety threshold, and obtain the target project ranking scheme and the number of times the project safety time is reduced; Allocate the projects in the target project ranking plan to complete the projects.

2. The project data processing method according to claim 1, characterized in that: Determining the expected completion status of the project list according to the first remaining time and the second remaining time, and classifying the projects according to the expected completion status to obtain project groups of different levels includes: Traversing the first remaining time of each item in the item list, and determining whether the item list contains an item whose first remaining time is less than zero; If the project list contains projects with a first remaining time less than zero, then the second remaining time of each project with a first remaining time less than zero is traversed, and it is determined whether each project with the first remaining time less than zero contains a project with a second remaining time less than zero; if each project with a first remaining time less than zero contains a project with a second remaining time less than zero, then the expected completion status of the project list is determined as the first expected completion status; if each project with a first remaining time less than zero does not contain a project with a second remaining time less than zero, then the expected completion status of the project list is determined as the second expected completion status; the first expected completion status is the situation where the probability of completion of all projects in the project list is less than 100%, and the second expected completion status is the situation where the probability of completion of all projects in the project list is equal to 100%; When the expected completion status of the project list is the first expected completion status, the project whose first remaining time is less than zero and whose second remaining time is less than zero is saved in the first-level project group; the project whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero is saved in the third-level project group; the project whose first remaining time and second remaining time are both greater than or equal to zero is saved in the second-level project group; When the expected completion status of the project list is the second expected completion status, the projects whose first remaining time is less than zero and whose second remaining time is greater than or equal to zero are saved in the second-level project group; the projects whose first remaining time and second remaining time are both greater than or equal to zero are saved in the first-level project group to obtain project groups of different levels; the processing priority of the third-level project group is higher than that of the second-level project group, and the processing priority of the second-level project group is higher than that of the first-level project group.

3. The project data processing method according to claim 2, characterized in that: The step of sorting the projects in the project groups of different levels to obtain an initial project sorting scheme comprises: When the expected completion status of the project list is the first expected completion status, the projects in the third-level project group are arranged in ascending order according to the absolute value of the second remaining time, the projects in the second-level project group are arranged in ascending order according to the absolute value of the second remaining time, and the projects in the first-level project group are arranged in descending order according to the absolute value of the second remaining time, to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority; Outputting the initial project ranking scheme in the order of the project ranking scheme corresponding to the third level, the project ranking scheme corresponding to the second level, and the project ranking scheme corresponding to the first level; When the expected completion status of the project list is the second expected completion status, the projects in the second-level project group are arranged in ascending order according to the absolute value of the second remaining time, and the projects in the first-level project group are arranged in ascending order according to the absolute value of the second remaining time, so as to obtain a project ranking scheme corresponding to each level; the higher the ranking, the higher the priority; The initial project ranking scheme is output in the order of the project ranking scheme corresponding to the second level and the project ranking scheme corresponding to the first level.

4. The project data processing method according to claim 2, characterized in that: The project progress data also includes project delay losses; the process of sorting the projects in the project groups of different levels to obtain an initial project sorting scheme includes: Preprocessing the project progress data to obtain preprocessed project progress data; Input the preprocessed project progress data into the trained project sequencing prediction model to obtain a predicted project sequencing plan; The total value of project delay losses of each forecast project ranking scheme is obtained based on the project delay losses; The predicted project sorting scheme with the smallest total value of project delay losses is determined as the initial project sorting scheme.

5. The project data processing method according to claim 4, characterized in that: The project progress data also includes a project safety node day, which is the difference between the project node day and the project safety time. The preprocessing of the project progress data to obtain the preprocessed project progress data also includes: Acquire training samples, wherein the training samples include project progress data training samples and project sequencing scheme training samples; According to the formula: E=ax+by+cz+dw+fv; Assigning weights to the project progress data training samples to obtain the weighted project progress data training samples; Among them, E is the training sample of project progress data after weight assignment, a is the weight of project safety time, x is the training sample of project safety time, b is the weight of project node day, y is the training sample of project node day, c is the weight of project remaining duration, z is the training sample of project remaining duration, d is the weight of project delay loss, w is the training sample of project delay loss, f is the weight of project safety node day, and v is the training sample of project safety node day; The initial convolutional neural network model is trained according to the project progress data training samples and project sorting scheme training samples after weight assignment to obtain a trained project sorting scheme prediction model.

6. The project data processing method according to claim 1, characterized in that: The initial project ranking scheme is monitored according to the safety threshold, and the safety time of the project whose target difference is less than the safety threshold is adjusted, and before obtaining the target project ranking scheme, the following further comprises: Traverse the first remaining time and the second remaining time of each project in the initial project sorting scheme, and determine whether the first remaining time and the second remaining time of each project are less than zero. If the first remaining time is less than zero, according to the formula: ； Count the number of initial project sorting solutions where the first remaining time is less than zero; in, To traverse to When the first remaining time is less than zero, For the projects, The value of is 1, 2, 3... ; is the total number of projects in the initial project treatment plan; The value is 0; If the second remaining time is less than zero, according to the formula: ； Count and obtain the number of the second remaining time in the initial project sorting scheme; in, To traverse to When the second remaining time is less than zero, The value is 0; According to the formula: ； Calculate the target difference; in, is the target difference.

7. The project data processing method according to claim 1, characterized in that: Determining a new project ranking scheme according to the new project safety time, and continuing to determine whether the target difference of the new project ranking scheme is less than the safety threshold until the target difference of the new project ranking scheme is equal to the safety threshold, and obtaining the target project ranking scheme and the number of times the project safety time is reduced also includes: According to the number of times the project safety time is reduced, a warning message is sent to the target user according to a preset rule; the preset rule is that the higher the number of times the project safety time is reduced, the higher the number of target users sent, and the higher the authority of the target user.

8. The project data processing method according to claim 1, characterized in that: The method of determining a new project ranking scheme according to the new project safety time and continuing to judge whether the target difference of the new project ranking scheme is less than the safety threshold until the target difference of the new project ranking scheme is equal to the safety threshold also includes: Determine whether, in the project sorting scheme corresponding to the number of times the project safety time is reduced being greater than the cycle threshold, the project with the first remaining time less than zero is a related project with other projects with the first remaining time greater than or equal to zero; If there are related projects, and the related projects include projects whose second remaining time is less than zero, then the related projects including the projects whose second remaining time is less than zero are saved in the first-level project group; If there are related projects, and the related projects do not contain a project whose second remaining time is less than zero, the related projects are merged to obtain a merged project; the merged project includes the first project and the second project; According to the formula: G0=(I1 / (I1+I2)×G1+I2 / (I1+I2)×G2) Calculate the first remaining time of the merged project; Wherein, G0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, G1 is the first remaining time of the first project, and G2 is the first remaining time of the second project; According to the formula: Q0=(I1 / (I1+I2)×Q1+I2 / (I1+I2)×Q2) Calculate the second remaining time of the combined project; Among them, Q0 is the first remaining time of the merged project, I1 is the project node date of the first project, I2 is the project node date of the second project, Q1 is the second remaining time of the first project, and Q2 is the second remaining time of the second project; The project list including the merged project is re-sorted according to the calculated first remaining time of the merged project and the second remaining time of the merged project to obtain a target project sorting scheme.

9. A project data processing system, characterized in that: include: A project progress data acquisition module is used to acquire the project progress data of each project in the project list; the project progress data includes project safety time, project node date and project remaining duration; A level classification module is used to determine the expected completion status of the project list according to the first remaining time and the second remaining time, and to classify the projects according to the expected completion status to obtain project groups of different levels; the first remaining time is the difference between the second remaining time and the project safety time; the second remaining time is the difference between the project node date and the remaining duration of the project; A sorting module, used for sorting the projects in the project groups of different levels to obtain an initial project sorting scheme; A monitoring module is used to monitor the initial project sorting scheme according to the safety threshold, adjust the safety time of the project whose target difference is less than the safety threshold, and obtain the target project sorting scheme; The target difference is the difference between the number of items with a first remaining time less than zero and the number of items with a second remaining time less than zero in the initial item sorting scheme; The monitoring module includes: a safety threshold judgment unit, which is used to judge whether the target difference in the initial project sorting scheme is less than the safety threshold. If the target difference is less than the safety threshold, according to the formula: ； The new project safety time determination unit is used to reduce the project safety time and calculate the new project safety time according to the reduced project safety time; wherein, To reduce the project safety time, The percentage of reduction in project safety time; The number of times the project safety time is reduced; is a positive integer; Project safety time in the initial project ranking scheme; The loop unit is used to determine a new project sorting scheme according to the new project safety time, and continue to judge whether the target difference of the new project sorting scheme is less than the safety threshold, until the target difference of the new project sorting scheme is equal to the safety threshold, and obtain the target project sorting scheme and the number of times the project safety time is reduced: The output module is used to allocate the projects in the target project sorting scheme to complete the projects.

Images