Research and development project data processing method and research and development project management system

Abstract

The present application relates to the field of enterprise management, and provides a research and development project data processing method and a research and development project management system. A first research and development corresponding relation between a candidate research and development project and a candidate research and development expense is inputted into an expense association module; then on the basis of the first research and development corresponding relation, a candidate research and development expense corresponding to a target research and development project, unit man-hour information corresponding to the target research and development project, and total man-hour information corresponding to the unit man-hour information are obtained; subsequently, the ratio of the unit man-hour information to the total man-hour information is determined, and a target research and development expense is determined on the basis of the ratio and the candidate research and development expense; and finally, the target research and development expense is stored in a newly-built data table. Thus, the association between an expense management module and a research and development management module is improved, the accuracy of measuring a research and development project expense and the traceability of underlying data between modules are improved at the same time, and the working efficiency of enterprise management is improved.

Description

R&D project data processing method and R&D project management system Technical Field

[0001] The present application relates to the field of enterprise management, and in particular to a research and development project data processing method and a research and development project management system. Background Art

[0002] With the development of Internet technology, digital and information management has become an important manifestation of corporate management level and core competitiveness, and is also an important guarantee for corporate compliance in the information age.

[0003] However, in the existing technology, most management systems used by enterprises have poor correlation between different data modules, and the data are independent of each other. A large amount of manpower and time costs are required to invest in data correlation between modules, which makes the enterprise work efficiency low.

[0004] Summary of the Invention

[0005] The main purpose of the embodiments of this application is to propose a R&D project data processing method and an R&D project management system, thereby improving the correlation between the expense management module and the R&D management module, improving the accuracy of measuring R&D project expenses and the traceability of underlying data between modules.

[0006] To achieve the above objectives, a first aspect of an embodiment of the present application provides a method for processing R&D project data, comprising:

[0007] Connect the project management system and the financial management system, obtain candidate R&D projects from the project management system, and obtain candidate R&D expenses from the financial management system;

[0008] Constructing a first data table in the database based on candidate R&D projects, and constructing a second data table in the database based on candidate R&D expenses;

[0009] In response to a request sent by a user terminal for entering a first R&D correspondence relationship between a candidate R&D project and a candidate R&D expense, associating the candidate R&D project with the candidate R&D expense from a database;

[0010] In response to a request sent by a user terminal for querying the R&D expenses of a target R&D project, obtaining candidate R&D expenses corresponding to the target R&D project, as well as unit man-hour information corresponding to the target R&D project and total man-hour information corresponding to the unit man-hour information from a database;

[0011] Determine the ratio between unit man-hour information and total man-hour information, and determine the target R&D expenses based on the ratio and candidate R&D expenses;

[0012] Create a data table in the database, store the target R&D expenses in the data table, and send the target R&D expenses to the user end.

[0013] Furthermore, in some embodiments, in response to a request sent by a user terminal for entering a first R&D correspondence between candidate R&D projects and candidate R&D expenses, constructing a third data table in a database for associating the first data table with the second data table includes:

[0014] In response to a request sent by a user terminal for entering a first R&D correspondence relationship between candidate R&D projects and candidate R&D expenses, creating an empty data table in a database;

[0015] In the empty data table, define the associated fields corresponding to the candidate R&D projects and the associated fields corresponding to the candidate R&D expenses;

[0016] The associated data in the request is stored in the associated fields corresponding to the empty data table to obtain a third data table.

[0017] Furthermore, in some embodiments, before determining the ratio between the unit working hour information and the total working hour information, the R&D project data processing method further includes:

[0018] In response to a request sent by the user terminal for entering a second R&D correspondence relationship between candidate R&D projects and candidate R&D personnel, the candidate R&D projects and candidate R&D personnel are associated from a database.

[0019] Furthermore, in some embodiments, the candidate R&D expenses include employee labor expenses, the unit man-hour information includes employee R&D man-hours, and the total man-hour information includes employee total man-hours.

[0020] Furthermore, in some embodiments, obtaining candidate R&D expenses corresponding to the target R&D project, as well as unit man-hour information corresponding to the target R&D project and total man-hour information corresponding to the unit man-hour information, from the database according to the third data table includes:

[0021] Obtain target R&D personnel corresponding to the target R&D project from the database;

[0022] According to the first R&D corresponding relationship and the second R&D corresponding relationship, the employee labor cost, employee R&D working hours and employee total working hours corresponding to the target R&D personnel are obtained from the database.

[0023] Furthermore, in some embodiments, before determining the ratio between the unit working hour information and the total working hour information, the R&D project data processing method further includes:

[0024] In response to a request sent by the user terminal for entering a third R&D correspondence between candidate R&D projects and candidate R&D institutions, the candidate R&D projects and candidate R&D institutions are associated from a database.

[0025] Furthermore, in some embodiments, the candidate R&D expenses include equipment depreciation expenses, the unit man-hour information includes sub-project man-hours, and the total man-hour information includes total project man-hours.

[0026] Furthermore, in some embodiments, obtaining candidate R&D expenses corresponding to the target R&D project, as well as unit man-hour information corresponding to the target R&D project and total man-hour information corresponding to the unit man-hour information, from the database according to the third data table includes:

[0027] Obtain the target R&D institution corresponding to the target R&D project from the database;

[0028] According to the first R&D corresponding relationship and the third R&D corresponding relationship, the equipment depreciation expenses corresponding to the target R&D institution, the sub-project working hours and the total project working hours are obtained from the database.

[0029] Furthermore, in some embodiments, the R&D project data processing method further includes:

[0030] In response to a request for modifying the target R&D expenses sent by the user, querying and modifying the target R&D expenses from a database to obtain the target modified R&D expenses;

[0031] Based on the first R&D correspondence, the second R&D correspondence, and the third R&D correspondence, the target modified R&D expenses are obtained from the database and automatically recalculated to obtain new target R&D expenses;

[0032] Send the modification success information to the user end.

[0033] Furthermore, in some embodiments, the R&D project data processing method further includes:

[0034] In response to a request sent by the user to add the employee's interval date working hours to the second R&D correspondence, querying the database for a project completion date of the target R&D project;

[0035] When the project completion date is greater than or equal to the employee's interval date working hours, the employee's interval date working hours are added to the second R&D correspondence relationship and a corresponding association is made in the database;

[0036] When the project completion date is less than the employee's interval date working hours, it is prohibited to add the employee's interval date working hours to the second R&D correspondence.

[0037] To achieve the above objectives, a second aspect of the embodiments of the present application provides a research and development project management system, including:

[0038] R&D management module, which is used to obtain and confirm R&D management information; wherein, R&D management information includes: R&D organization information and R&D project information;

[0039] The expense management module is used to obtain R&D expense information and execute the R&D project management method as described above based on the R&D expense information.

[0040] Furthermore, in some embodiments, the R&D project management system further includes: a standardization management module, which is used to obtain standardized product information and match corresponding R&D project information according to the standardized product information.

[0041] Furthermore, in some embodiments, the R&D project management system further includes: an intellectual property management module, which is used to obtain intellectual property information and match corresponding intellectual property information according to the R&D project information.

[0042] Furthermore, in some embodiments, the R&D project management system also includes: a data analysis module, which is used to obtain data from the R&D management module, data from the expense management module, data from the standardization management module, and data from the intellectual property management module and perform dynamic analysis; wherein the results of the dynamic analysis are displayed in a graphical form on the interactive interface.

[0043] Furthermore, in some embodiments, the R&D project management system further includes: a rights management module, which is used to obtain the user level and set or modify the corresponding management rights according to the user level.

[0044] Furthermore, in some embodiments, the R&D management module includes:

[0045] R&D institution management module, which is used to obtain and confirm R&D institution information;

[0046] R&D project management module, which is used to obtain and confirm R&D project information;

[0047] R&D file management module, the R&D file management module is used to match R&D project information and archive R&D project files.

[0048] Furthermore, in some embodiments, the intellectual property management module further includes: a patent management module, the patent management module being used to obtain patent information and match corresponding R&D project information according to the patent information;

[0049] Trademark management module, which is used to obtain trademark information and match corresponding R&D project information based on the trademark information;

[0050] Copyright management module, copyright is used to obtain copyright information and match corresponding R&D project information based on copyright information.

[0051] Among them, the copyright management module includes the software copyright management module and other copyright management modules. The software copyright management module is used to obtain software copyright information and match the corresponding R&D project information based on the software copyright information; the other copyright management module is used to obtain other copyright information and match the corresponding R&D project information based on other copyright information.

[0052] The embodiments of the present application have the following beneficial effects: the present application enters a first R&D correspondence between candidate R&D projects of an external project management system and candidate R&D expenses of an external financial management system into the expense association module, and then obtains the candidate R&D expenses corresponding to the target R&D project according to the first R&D correspondence, as well as the unit working hour information corresponding to the target R&D project and the total working hour information corresponding to the unit working hour information, and then determines the ratio between the unit working hour information and the total working hour information, and determines the target R&D expenses based on the ratio and the candidate R&D expenses, and finally stores the target R&D expenses in a newly created data table, thereby improving the correlation between the expense management module and the R&D management module, while also improving the accuracy of measuring R&D project expenses and the traceability of underlying data between modules, thereby improving the work efficiency of enterprise management. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] FIG1 is a flow chart of a research and development project management method provided in an embodiment of the present application;

[0054] FIG2 is a flowchart of step S103 in FIG1 provided in an embodiment of the present application;

[0055] FIG3 is a flowchart before step S105 in FIG1 provided by an embodiment of the present application;

[0056] FIG4 is a flowchart of step S104 in FIG1 provided in an embodiment of the present application;

[0057] FIG5 is a flowchart before step S105 in FIG1 provided by an embodiment of the present application;

[0058] FIG6 is a flowchart of step S104 in FIG1 provided in an embodiment of the present application;

[0059] FIG7 is an optional flowchart of a R&D project management method provided in another embodiment of the present application;

[0060] FIG8 is an optional flowchart of a R&D project management method provided in another embodiment of the present application;

[0061] FIG9 is a schematic diagram of the architecture of a research and development project management system provided in an embodiment of the present application;

[0062] FIG10 is a schematic diagram of the hardware structure of the electronic device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0063] In order to make the purpose, technical solutions and advantages of this application more clear, the following further describes this application in detail with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain this application and are not intended to limit this application.

[0064] It should be noted that although the device schematics illustrate functional module divisions and the flowcharts illustrate logical sequences, in certain circumstances, the steps shown or described may be performed in a sequence that differs from the module divisions in the device or the sequence in the flowcharts. The terms "first," "second," and so on, in the specification, claims, and drawings, are used to distinguish similar items and are not necessarily used to describe a specific sequence or precedence.

[0065] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as commonly understood by technical personnel in the technical field of this application. The terms used herein are only for the purpose of describing the embodiments of this application and are not intended to limit this application.

[0066] First, let’s analyze some of the terms used in this application:

[0067] ERP stands for Enterprise Resource Planning (ERP). Based on information technology, it targets a company's entire business process, including operations, production, sales, procurement, inventory, logistics, and settlement. By integrating all internal and external operational management information and resources, it aims to achieve unified management, coordinated control, and efficient utilization of enterprise resources. ERP systems are dedicated to improving a company's operational efficiency and decision-making capabilities, thereby achieving its strategic goals.

[0068] PLM, or Product Lifecycle Management, is a targeted management system for product information from conception to market withdrawal. It helps companies establish a unified platform for product R&D, design, process collaboration, and R&D project management, improving R&D efficiency and enhancing product quality. On this basis, businesses can gradually expand, achieving full product lifecycle management across initial planning, R&D, design, production, manufacturing, and maintenance.

[0069] API stands for Application Programming Interface. It's a set of specifications that define how software components communicate with each other. An API can be thought of as a bridge between different software programs, allowing them to share data and functionality, enabling integration and interaction.

[0070] The R&D project data processing method and R&D project management system provided in the embodiments of the present application relate to the field of enterprise management.

[0071] Based on this, the embodiments of the present application provide a R&D project data processing method and R&D project management system. By calculating the allocation of each project for an employee's interval salary, personal bonus, and stock bonus based on the employee's number of R&D projects, total attendance hours, and the R&D hours set for each project, the employee's R&D salary and the individual cost set for each project are obtained. This allows the R&D expense data to be associated with the corresponding R&D project data, improving the correlation between the expense management module and the R&D management module, while also improving the accuracy of measuring R&D project expenses and the traceability of the underlying data between modules.

[0072] It should be noted that the R&D project data processing method and R&D project management system provided in the embodiments of the present application can be applied to a terminal, can be applied to a server, and can also be software running on a terminal or a server. In some embodiments, the terminal can be a smart phone, a tablet computer, a laptop computer, a desktop computer, etc.; the server can be configured as an independent physical server, or as a server cluster or distributed system composed of multiple physical servers, or as a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN, and big data and artificial intelligence platforms; the software can be an application that implements a R&D project data processing method and an R&D project management system, etc., but is not limited to the above forms.

[0073] The present application can be used in many general or special computer system environments or configurations. For example: personal computers, server computers, handheld or portable devices, tablet devices, multiprocessor systems, microprocessor-based systems, set-top boxes, programmable consumer electronics, network PCs, minicomputers, mainframe computers, distributed computing environments including any of the above systems or devices, and the like. The present application can be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, and the like that perform specific tasks or implement specific abstract data types. The present application can also be practiced in distributed computing environments in which tasks are performed by remote processing devices connected via a communication network. In a distributed computing environment, program modules can be located in local and remote computer storage media, including storage devices.

[0074] It should also be noted that in each specific embodiment of the present application, when it comes to the need to perform relevant processing based on data related to user identity or characteristics such as user information, user behavior data, user historical data, and user location information, the user's permission or consent will be obtained first. Moreover, the collection, use, and processing of these data will comply with relevant laws, regulations, and standards. In addition, when the embodiment of the present application needs to obtain the user's sensitive personal information, the user's separate permission or consent will be obtained through a pop-up window or by jumping to a confirmation page. After clearly obtaining the user's separate permission or consent, the necessary user-related data for enabling the normal operation of the embodiment of the present application will be obtained.

[0075] Please refer to FIG. 1 , which is an optional flowchart of a R&D project management method provided in an embodiment of the present application, which may include but is not limited to steps S101 to S105 .

[0076] Step S101: Connecting to a project management system and a financial management system, obtaining candidate R&D projects from the project management system, and obtaining candidate R&D expenses from the financial management system;

[0077] Specifically, by obtaining APIs of the project management system and the financial management system, a request for obtaining candidate R&D projects is initiated to the project management system, and a request for obtaining candidate R&D expenses is initiated to the financial management system.

[0078] It should be noted that the project management system can be an external PLM system or an internal project management module; the financial management system can be an external ERP system or an internal financial management module.

[0079] It should also be noted that when the project management system is an external PLM system or the financial management system is an external ERP system, it is also necessary to perform interface data verification on the external system, including the following steps:

[0080] Step A: Design several test cases including boundary conditions, abnormal conditions and other issues, and then verify the data returned by the API by checking the returned data type, data length, or whether certain fields exist.

[0081] Step B: Compare the data returned by the API with the expected results. The comparison includes field comparison and data comparison of the same batch of data. When the data in the corresponding fields of some data in the same batch of data is null or empty, mark the null or empty value as a warning, obtain the data returned by the corresponding API again, and then perform manual comparison.

[0082] Step C: Check whether the data returned by the API is logically consistent.

[0083] Specifically, if the API returns a list, ensure that each item in the list conforms to the expected format.

[0084] Step S102: constructing a first data table in the database based on the candidate R&D projects, and constructing a second data table in the database based on the candidate R&D expenses;

[0085] Specifically, a first empty data table is created in the database, and corresponding fields are defined in the first empty data table according to the field attributes of the candidate R&D projects. Then, the candidate R&D projects are batch inserted into the first empty data table through SQL instructions to complete the construction of the first data table; a second empty data table is created in the database, and corresponding fields are defined in the second empty data table according to the field attributes of the candidate R&D expenses. Then, the candidate R&D expenses are batch inserted into the second empty data table through SQL instructions to complete the construction of the second data table.

[0086] Step S103: In response to a request sent by the user terminal for entering a first R&D correspondence relationship between candidate R&D projects and candidate R&D expenses, constructing a third data table in the database for associating the first data table with the second data table;

[0087] It should be noted that, according to the first R&D correspondence data in the request, a third data table for associating the first data table with the second data table is constructed in the database.

[0088] Step S104: In response to the request sent by the user terminal for querying the R&D expenses of the target R&D project, candidate R&D expenses corresponding to the target R&D project, as well as unit man-hour information corresponding to the target R&D project and total man-hour information corresponding to the unit man-hour information are obtained from the database;

[0089] Furthermore, it should be noted that the candidate R&D expenses include employee labor expenses, the unit working hour information includes employee R&D working hours, and the total working hour information includes the total working hours of employees.

[0090] Furthermore, the candidate R&D expenses may include equipment depreciation expenses, the unit man-hour information may include sub-project man-hours, and the total man-hour information may include total project man-hours.

[0091] Step S105: determining the ratio between the unit man-hour information and the total man-hour information, and determining the target R&D expense based on the ratio and the candidate R&D expense;

[0092] Furthermore, it should be noted that the ratio between unit working hours information and total working hours information includes: the employee ratio between employee R&D working hours and employee total working hours, and the project ratio between project working hours and total project working hours.

[0093] It should also be noted that the total R&D expenses include: target R&D expenses, direct investment expenses, intangible asset amortization expenses, design expenses, equipment commissioning expenses and experimental expenses, external R&D expenses and other expenses.

[0094] Step S106 , creating a data table in the database, storing the target R&D expenses in the data table, and sending the target R&D expenses to the user end.

[0095] Furthermore, it should be noted that a project R&D expense data table is created in the database, and the target R&D expense is stored in the project R&D expense data table. After successful storage, the target R&D expense is sent to the user end.

[0096] Please refer to Figure 2, which is a flowchart of step S103 in Figure 1 provided in an embodiment of the present application. In some embodiments, step S103 may also include but is not limited to step S201.

[0097] Step S201: In response to a request sent by a user terminal for entering a first R&D correspondence relationship between candidate R&D projects and candidate R&D expenses, an empty data table is created in a database;

[0098] Specifically, in response to a request sent by the user terminal for entering a first R&D correspondence between candidate R&D projects and candidate R&D expenses, an empty data table is created in the database, and then the R&D project data table and the R&D expense data table are queried from the database, and the candidate project ID number of the R&D project data table and the candidate expense ID number of the R&D expense data table are obtained.

[0099] Step S202: defining associated fields corresponding to candidate R&D projects and associated fields corresponding to candidate R&D expenses in an empty data table;

[0100] Specifically, according to the field attributes of the candidate project ID number and the candidate expense ID number, the associated fields corresponding to the candidate R&D project and the associated fields corresponding to the candidate R&D expense are defined in the empty data table.

[0101] Step S203: Store the associated data in the request into the associated fields corresponding to the empty data table to obtain a third data table.

[0102] Specifically, based on the first R&D correspondence data in the request, the candidate project number and the candidate expense number are correspondingly associated, and the association information is stored in the third empty data table as a foreign key between the R&D project data table and the R&D expense data table, completing the construction of the third data table.

[0103] Please refer to FIG. 3 , which is a flowchart before step S105 in FIG. 1 provided in an embodiment of the present application. In some embodiments, the process before step S105 may also include but is not limited to step S301 .

[0104] Step S301 : in response to a request sent by a user terminal for entering a second R&D correspondence relationship between a candidate R&D project and a candidate R&D personnel, associating the candidate R&D project with the candidate R&D personnel from a database.

[0105] It should be noted that in response to the request sent by the user terminal for entering the second R&D correspondence between candidate R&D projects and candidate R&D personnel, a project R&D personnel association data table is created in the database, and according to the second R&D correspondence, the project ID and R&D personnel ID in the second R&D correspondence are written into the project R&D personnel association data table.

[0106] Please refer to FIG. 4 , which is a flowchart of step S104 in FIG. 1 provided in an embodiment of the present application. In some embodiments, step S104 may also include but is not limited to step S401 and step S402 .

[0107] Step S401: Obtain target R&D personnel corresponding to the target R&D project from the database;

[0108] Step S402: According to the first R&D correspondence relationship and the second R&D correspondence relationship, the employee labor costs, employee R&D working hours and employee total working hours corresponding to the target R&D personnel are obtained from the database.

[0109] It should be noted that employee labor expenses include: employee wages and employee bonuses. Employee wages are calculated based on the employee's range wage, employee R&D work hours, and employee total work hours. Employee R&D wages are calculated based on employee bonuses, employee R&D work hours, and employee total work hours.

[0110] Specifically, suppose there are k target R&D personnel, and the total working hours of the target R&D personnel on any date is t i The R&D hours corresponding to this date are t ij , where i represents the date, j represents the number of R&D projects in which the R&D personnel participated, and t i represents the total working hours of employees on date i, t ij represents the R&D hours of the R&D personnel on the R&D project they participated in on date i (i and j are both positive integers), the employee's interval salary is S, the year-end bonus is M, and the equity bonus is G;

[0111] Then the total R&D salary of the target project P: P = ∑ k S×(∑ i ∑ j t ij ) / (∑i t i );

[0112] The total year-end bonus for the target project is N: N = ∑ k M×(∑ i t ij ) / (∑ i ∑ j t ij );

[0113] Then the total equity bonus of the target project L: L = ∑ k G×(∑ i t ij ) / (∑ i ∑ j t ij ).

[0114] Please refer to Figure 5, which is an optional flowchart before step S103 in Figure 1 provided by an embodiment of the present application. In some embodiments, the process before step S105 may also include but is not limited to step S501.

[0115] Step S501 : in response to a request sent by a user terminal for entering a third R&D correspondence relationship between a candidate R&D project and a candidate R&D institution, associating the candidate R&D project with the candidate R&D institution from a database.

[0116] It should be noted that in response to the request sent by the user terminal for entering the third R&D correspondence between the candidate R&D projects and the candidate R&D institutions, a project R&D institution association data table is created in the database, and according to the third R&D correspondence, the project ID and R&D institution ID in the third R&D correspondence are written into the project R&D institution association data table.

[0117] Please refer to Figure 6, which is a flowchart of step S104 in Figure 1 provided in an embodiment of the present application. In some embodiments, step S104 may also include but is not limited to step S601 and step S602.

[0118] Step S601: Obtain the target R&D institution corresponding to the target R&D project from the database;

[0119] Step S602: According to the first R&D correspondence relationship and the third R&D correspondence relationship, the equipment depreciation expenses, project hours and total project hours corresponding to the target R&D institution are obtained from the database.

[0120] Specifically, suppose there are k target R&D personnel, and the total working hours of the target R&D personnel on any date is t i The R&D hours corresponding to this date are t ij , where i represents the date, j represents the number of R&D projects in which the R&D personnel participated, and ti represents the total working hours of employees on date i, t ij represents the R&D hours of the R&D personnel in the R&D project they participated in on date i (i and j are both positive integers), and the equipment depreciation cost is Q;

[0121] Then the depreciation cost of the target project R: R=Q×(∑ k ∑ j t ijk ) / (∑ k ∑ i ∑ j t ijk ).

[0122] It should also be noted that in the actual project process, the target project depreciation cost R also needs to take into account the number of times the equipment is used, the equipment purchase date, the current depreciation date, the number of depreciation periods, etc. Therefore, a neural network model needs to be used for regression fitting, as follows:

[0123] Step a: Obtain project depreciation data, which includes equipment purchase date, current depreciation date, number of depreciation periods, total employee hours, R&D hours, equipment depreciation expenses, and equipment usage times;

[0124] Step b: performing data preprocessing according to the project depreciation data to obtain project depreciation preprocessing data;

[0125] Specifically, in the data preprocessing process, the project depreciation data is first processed for missing values ​​and outliers, and then the text data in the project depreciation data is binary-featured through the one-hot encoding method to obtain the project depreciation feature data. Finally, the project depreciation feature data is standardized to obtain the project depreciation preprocessed data.

[0126] Step c: Divide the project depreciation preprocessed data into project depreciation training data and project depreciation test data;

[0127] Step d: training the project depreciation training data on a neural network model to obtain a neural network training model;

[0128] Specifically, the input layer of the neural network model is the equipment purchase date, the current depreciation date, the number of depreciation periods, the total employee working hours, the R&D working hours, the equipment depreciation expenses and the number of times the equipment is used; the output layer of the neural network model is the target project depreciation expense R, and its hidden layer is two layers, the first hidden layer has 64 neurons and the second layer has 10 neurons, the activation function of the first hidden layer is ReLU, and the activation function of the second hidden layer is Sigmoid, the loss function of the neural network is binary cross entropy, and its optimization iterator is stochastic gradient descent.

[0129] Step e: Testing and optimizing the neural network training model using the project depreciation test data to obtain a project neural network prediction model;

[0130] Specifically, during the testing process, the model performance was improved by adjusting the model's hyperparameters, and the SHAP value was used to explain the model's prediction results;

[0131] Step f: Use the project neural network prediction model to predict the target project depreciation data and obtain the actual target project depreciation cost R'.

[0132] Please refer to Figure 7, which is an optional flowchart of a R&D project management method provided by another embodiment of the present application. In some embodiments, the R&D project management method may also include but is not limited to step S701, step S702 and step S703.

[0133] Step S701: In response to a request for modifying the target R&D expenses sent by the user, query and modify the target R&D expenses from a database to obtain the modified target R&D expenses;

[0134] Specifically, in response to a request for modifying the target R&D expenses sent by the user terminal, the data to be modified in the target R&D expenses is queried from the database according to the modification data in the request and the data is overwritten to obtain the target modified R&D expenses.

[0135] Step S702: Based on the first R&D correspondence, the second R&D correspondence, and the third R&D correspondence, the target modified R&D expenses are obtained from the database and automatically recalculated to obtain a new target R&D expense;

[0136] Specifically, based on the first R&D correspondence, the second R&D correspondence and the third R&D correspondence, each time data is obtained or the R&D hours are filled in and reviewed and approved, the server obtains the target modified R&D expenses from the database and recalculates based on the modified data in the target modified R&D expenses to obtain new target R&D expenses.

[0137] Step S703: Send the modification success information to the user terminal.

[0138] Please refer to Figure 8, which is an optional flowchart of a R&D project management method provided by another embodiment of the present application. In some embodiments, the R&D project management method may also include but is not limited to step S801, step S802 and step S803.

[0139] Step S801: In response to a request sent by the user to add the employee's interval date working hours to the second R&D correspondence, query the database for the project completion date of the target R&D project;

[0140] Specifically, in response to the request sent by the user to add the employee interval date working hours to the second R&D correspondence, the project completion date of the target R&D project is queried in the first data table according to the project ID to be associated with the request.

[0141] Step S802: When the project completion date is greater than or equal to the employee's interval date working hours, the employee's interval date working hours are added to the second R&D correspondence relationship, and a corresponding association is made in the database;

[0142] Specifically, when the project completion date is greater than or equal to the employee interval date working hours, for example, the project completion date is December 30, 2023, and the employee interval date working hours are the interval date working hours of December 29, 2023, then the employee interval date working hours can be added to the second R&D corresponding relationship, and a corresponding association can be made in the database.

[0143] Step S803: When the project completion date is less than the employee interval date working hours, it is prohibited to add the employee interval date working hours to the second R&D corresponding relationship.

[0144] Specifically, when the project completion date is greater than or equal to the employee interval date working hours, for example, the project completion date is December 30, 2023, and the employee interval date working hours are the interval date working hours of January 1, 2024, the employee interval date working hours cannot be added to the second R&D correspondence relationship, and the corresponding association cannot be made in the database.

[0145] It should also be noted that when the project completion date is less than the employee interval date working hours, the project completion date can be extended so that the project completion date is greater than or equal to the employee interval date working hours, and then the employee interval date working hours can be added to the second R&D correspondence and a corresponding association can be made in the database.

[0146] Please refer to FIG9 , which is a schematic diagram of the architecture of a research and development project management system provided in an embodiment of the present application. This embodiment of the present application also provides a research and development project management system 900 that can implement the above-mentioned research and development project management method. The research and development project management system 900 includes:

[0147] R&D management module 901, which is used to obtain and confirm R&D management information; wherein the R&D management information includes: R&D organization information and R&D project information;

[0148] It should be noted that the R&D management module 901 in the above embodiment may also include:

[0149] R&D institution management module, which is used to obtain and confirm R&D institution information;

[0150] Furthermore, it should be noted that R&D organization information includes: R&D organizational structure information, R&D equipment information, and R&D personnel information. Based on the R&D organizational structure information, an R&D organizational structure table is created in the database. The fields in the R&D organizational structure table include department name, department code, status, and creation time.

[0151] Furthermore, based on the R&D equipment information, an R&D equipment information table is created in the database, wherein the fields of the R&D equipment information include serial number, equipment purchase time, asset code, asset name, specification model, depreciation period, initial original value and creation time.

[0152] Furthermore, based on the R&D equipment information, a R&D personnel information table is created in the database, where the fields of R&D personnel information include: name, employee number, department code, department name, R&D personnel type, date of employment, date of resignation, gender, nationality, certificate type, certificate number, highest academic degree, major name, school name, contact address and contact information.

[0153] R&D project management module, which is used to obtain and confirm R&D project information;

[0154] Furthermore, it should be noted that, based on the R&D project information, an R&D project information table is created in the database, where the fields in the R&D project information include project number, project name, R&D personnel, R&D project start time, project type, department, R&D team members, funding budget and project progress.

[0155] It should also be noted that the data processing flow of the R&D project management module includes five process R&D links. First, the user initiates the process node of the R&D project plan in the module and fills in the mutual planning information. Then it flows to the process node of the project review, and organizes a review meeting based on the process node to confirm the specific plan of the R&D project. Then it flows to the process node of the project resolution to start the project, and then it flows to the process node of the project R&D process. When the project R&D is completed, it finally enters the process node of the project acceptance.

[0156] Specifically, the data fields of the process R&D link include: R&D work overview, attachments, current link review status, review submitter, review submission time, review opinion, reviewer and final review time.

[0157] An expense management module 902 is used to obtain R&D expense information and execute the R&D project management method described in the above embodiment based on the R&D expense information;

[0158] Standardization management module 903, which is used to obtain standardized product information and match corresponding R&D project information according to the standardized product information;

[0159] Furthermore, it should be noted that a standardized product information table is created in the database based on the standardized product information, wherein the fields in the standardized product information include year, product name, field, advancement, associated R&D number and associated R&D project.

[0160] Data analysis module 904 is used to obtain data from the R&D management module, the expense management module, the standardization management module, and the intellectual property management module and perform dynamic analysis; the results of the dynamic analysis are displayed in a graphical form on the interactive interface;

[0161] The permission management module 905 is used to obtain the user level and set or modify the corresponding management permissions according to the user level, including the left menu permissions and project data permissions. That is, based on the above correspondence, the R&D personnel can only view their own corresponding projects.

[0162] Intellectual property management module 906, which is used to obtain intellectual property information and match the corresponding intellectual property information according to the R&D project information;

[0163] It should be noted that the intellectual property management module 906 in the above embodiment may also include:

[0164] A patent management module, which is used to obtain the patent information and match the corresponding R&D project information according to the patent information;

[0165] Furthermore, it should be noted that patent information is created in the database based on the patent information, wherein the fields in the patent information include patent name, applicant, application / publication number, application date, patent type, country of publication, patent validity, inventor, abstract, current legal status, and agency.

[0166] A trademark management module, configured to obtain the trademark information and match the corresponding R&D project information according to the trademark information;

[0167] Furthermore, it should be noted that trademark information is created in the database based on the trademark information, wherein the fields in the trademark information include trademark pattern, trademark name, international classification, status, trademark application registration number, application date, registration announcement date, and trademark content.

[0168] The copyright management module is used to obtain the copyright information and match the corresponding R&D project information according to the copyright information.

[0169] It should be noted that the copyright management module in the above embodiment may also include:

[0170] A software copyright management module, the software copyright management module is used to obtain the software copyright information and match the corresponding R&D project information according to the software copyright information;

[0171] Furthermore, it should be noted that software copyright information is created in the database based on the software copyright information, wherein the fields in the software copyright information include the full name of the software, the abbreviation of the software, the version number, the registration number, the development completion date, the first release date, the registration date, and the method of obtaining rights.

[0172] Other copyright management modules, the other copyright management modules are used to obtain the other copyright information and match the corresponding R&D project information according to the other copyright information.

[0173] The R&D file management module 907 is used to match R&D project information and archive R&D project files.

[0174] Furthermore, it should be noted that other copyright information is created in the database based on other copyright information, wherein the fields in the other copyright information include registration number, work / product name, work category, author, copyright owner, creation completion date, and registration date.

[0175] It should also be noted that the R&D project management system includes search, new addition, modification, deletion, import, and export functions; the deletion, import, and export functions can all perform batch transactions; the search function includes searching from any dimension including name, employee number, department name, project number, project name, and time.

[0176] The present application also provides an electronic device comprising a memory and a processor. The memory stores a computer program, and the processor executes the computer program to implement the aforementioned R&D project data processing method and R&D project management system. The electronic device can be any smart terminal, including a tablet computer and an in-vehicle computer.

[0177] Please refer to FIG10 , which illustrates a hardware structure of an electronic device according to another embodiment. The electronic device includes:

[0178] The processor 1001 can be implemented as a general-purpose CPU (Central Processing Unit), a microprocessor, an application-specific integrated circuit (ASIC), or one or more integrated circuits, and is used to execute relevant programs to implement the technical solutions provided in the embodiments of the present application;

[0179] The memory 1002 can be implemented in the form of a read-only memory (ROM), a static storage device, a dynamic storage device, or a random access memory (RAM). The memory 1002 can store one or more application programs or data, and can also include one or more operating systems (such as Harmony OS TM, RTOS TM, Unix TM, Linux TM, RTLinux TM, etc.). When the technical solutions provided in the embodiments of this specification are implemented through software or firmware, the relevant program codes are stored in the memory 1002, and are called by the processor 1001 to execute a method for processing R&D project data and a R&D project management system according to the embodiments of this application.

[0180] Input / output interface 1003, used to implement information input and output;

[0181] Communication interface 1004, used to implement communication interaction between this device and other devices, which can be achieved through wired means (such as USB, network cable, etc.) or wireless means (such as mobile network, WiFi, Bluetooth, etc.);

[0182] Bus 1005 , which transmits information between various components of the device (e.g., processor 1001 , memory 1002 , input / output interface 1003 , and communication interface 1004 );

[0183] The processor 1001 , the memory 1002 , the input / output interface 1003 and the communication interface 1004 are connected to each other in communication within the device via the bus 1005 .

[0184] An embodiment of the present application also provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the above-mentioned R&D project data processing method and R&D project management system.

[0185] The memory 1002 is a non-transient computer-readable storage medium that can be used to store non-transient software programs and non-transient computer executable programs. In addition, the memory 1002 may include a high-speed random access memory and may also include a non-transient memory, such as at least one disk storage device, a flash memory device, or other non-transient solid-state storage device. In some embodiments, the memory may optionally include a memory remotely arranged relative to the processor, and these remote memories may be connected to the processor via a network. Examples of the above-mentioned network include, but are not limited to, the Internet, an intranet, a local area network, a mobile communication network, and combinations thereof.

[0186] The embodiments described in the embodiments of this application are intended to more clearly illustrate the technical solutions of the embodiments of this application and do not constitute a limitation on the technical solutions provided in the embodiments of this application. Technical personnel in this field will know that with the evolution of technology and the emergence of new application scenarios, the technical solutions provided in the embodiments of this application are also applicable to similar technical problems.

[0187] Those skilled in the art will understand that the technical solutions shown in the figures do not constitute a limitation on the embodiments of the present application, and may include more or fewer steps than shown in the figures, or a combination of certain steps, or different steps.

[0188] Those skilled in the art will appreciate that all or some of the steps in the methods, systems, and functional modules / units in the devices disclosed above may be implemented as software, firmware, hardware, or appropriate combinations thereof.

[0189] The terms "first," "second," "third," "fourth," etc. (if any) in the specification of the present application and the above-mentioned drawings are used to distinguish similar objects and are not necessarily used to describe a specific order or sequential sequence. It should be understood that the numbers used in this way are interchangeable where appropriate, so that the embodiments of the present application described herein can be implemented in a sequence other than those illustrated or described herein. In addition, the terms "including" and "having," as well as any variations thereof, are intended to cover non-exclusive inclusions, e.g., a process, method, system, product, or apparatus comprising a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or that are inherent to these processes, methods, products, or apparatus.

[0190] It should be understood that in this application, "at least one (item)" means one or more, and "plurality" means two or more. "And / or" is used to describe the association relationship of associated objects, indicating that three relationships may exist. For example, "A and / or B" can mean: only A exists, only B exists, and A and B exist at the same time, where A and B can be singular or plural. The character " / " generally indicates that the previous and next associated objects are in an "or" relationship. "At least one of the following items" or similar expressions refers to any combination of these items, including any combination of single items or plural items. For example, at least one of a, b or c can mean: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", where a, b, c can be single or multiple.

[0191] In the several embodiments provided in this application, it should be understood that the disclosed systems and methods can be implemented in other ways. For example, the system embodiments described above are merely illustrative. For example, the division of the above units is merely a logical function division. In actual implementation, there may be other division methods, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0192] The units described above as separate components may or may not be physically separate, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed across multiple network units. Some or all of these units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0193] In addition, the functional units in the various embodiments of the present application may be integrated into a single processing unit, or each unit may exist physically separately, or two or more units may be integrated into a single unit. The aforementioned integrated units may be implemented in the form of hardware or software functional units.

[0194] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application is essentially or the part that contributes to the prior art or all or part of the technical solution can be embodied in the form of a software product, which is stored in a storage medium and includes multiple instructions for enabling a computer device (which can be a personal computer, server, or network device, etc.) to perform all or part of the steps of the methods of various embodiments of the present application. The aforementioned storage medium includes: a USB flash drive, a random access memory (RAM), a read-only memory (ROM), an electrically erasable programmable read only memory (EEPROM), a flash memory or other memory technology, an optical drive (CD-ROM), a digital versatile disk (DVD) or other optical disk storage, a magnetic cassette, a tape, a magnetic disk, a magnetic disk storage or other magnetic storage device, or any other medium that can be used to store the desired information and can be accessed by a computer.

[0195] The preferred embodiments of the present invention are described above with reference to the accompanying drawings, but are not intended to limit the scope of the present invention. Any modifications, equivalent substitutions, and improvements made by a person skilled in the art without departing from the scope and essence of the present invention shall be within the scope of the present invention.

Claims

1. A method for processing R & D project data, which is applied to a server, characterized in that, it includes: Connect to the project management system and the financial management system, obtain candidate R & D projects from the project management system, and obtain candidate R & D expenses from the financial management system; Construct a first data table in the database according to the candidate R & D projects, and construct a second data table in the database according to the candidate R & D expenses; In response to a request sent by the client for entering a first R & D correspondence relationship between the candidate R & D projects and the candidate R & D expenses, construct a third data table in the database for associating the first data table and the second data table; In response to a request sent by the client for querying the R & D expenses of a target R & D project, obtain the candidate R & D expenses corresponding to the target R & D project from the database according to the third data table, as well as the unit working hour information corresponding to the target R & D project and the total working hour information corresponding to the unit working hour information; Determine the ratio between the unit working hour information and the total working hour information, and determine the target R & D expenses according to the ratio and the candidate R & D expenses; Create a target data table in the database, store the target R & D expenses in the target data table, and send the target R & D expenses to the client.

2. The R & D project data processing method according to claim 1, characterized in that, the step of constructing a third data table in the database for associating the first data table and the second data table in response to a request sent by the client for entering a first R & D correspondence relationship between the candidate R & D projects and the candidate R & D expenses includes: In response to a request sent by the client for entering a first R & D correspondence relationship between the candidate R & D projects and the candidate R & D expenses, create an empty data table in the database; Define an association field corresponding to the candidate R & D project and an association field corresponding to the candidate R & D expenses in the empty data table; Store the association data in the request into the association fields corresponding to the empty data table to obtain the third data table.

3. The R & D project data processing method according to claim 1, characterized in that, before determining the ratio between the unit working hour information and the total working hour information, the R & D project data processing method further includes: In response to a request sent by the client for entering a second R & D correspondence relationship between the candidate R & D projects and candidate R & D personnel, associate the candidate R & D projects with the candidate R & D personnel from the database.

4. The R & D project data processing method according to claim 3, characterized in that, the candidate R & D expenses include employee labor expenses, the unit working hour information includes employee R & D working hours, the total working hour information includes employee total working hours, and the step of obtaining the candidate R & D expenses corresponding to the target R & D project from the database according to the third data table, as well as the unit working hour information corresponding to the target R & D project and the total working hour information corresponding to the unit working hour information includes: Obtain the target R & D personnel corresponding to the target R & D project from the said database; According to the first R & D correspondence and the second R & D correspondence, obtain the employee labor cost, the employee R & D working hours and the total employee working hours corresponding to the target R & D personnel from the database.

5. The R & D project data processing method according to claim 1, characterized in that, before determining the ratio between the unit working hour information and the total working hour information, the R & D project data processing method further includes: In response to a request sent by the client for entering a third R & D correspondence between the candidate R & D project and the candidate R & D institution, associate the candidate R & D project with the candidate R & D institution from the database.

6. The R & D project data processing method according to claim 5, characterized in that, the candidate R & D cost includes equipment depreciation cost, the unit working hour information includes sub - project working hours, the total working hour information includes total project working hours, and obtaining the candidate R & D cost corresponding to the target R & D project, the unit working hour information corresponding to the target R & D project and the total working hour information corresponding to the unit working hour information from the database according to the third data table includes: Obtain the target R & D institution corresponding to the target R & D project from the database; According to the first R & D correspondence and the third R & D correspondence, obtain the equipment depreciation cost, the sub - project working hours and the total project working hours corresponding to the target R & D institution from the database.

7. The R & D project data processing method according to claim 3 or 5, characterized in that, further includes: In response to a request sent by the client to modify the target R & D cost, query and modify the target R & D cost from the database to obtain the target modified R & D cost; Based on the first R & D correspondence, the second R & D correspondence and the third R & D correspondence, obtain the target modified R & D cost from the database and automatically recalculate to obtain a new target R & D cost; Send a modification success message to the client.

8. The R & D project data processing method according to claim 3 or 5, characterized in that, further includes: In response to a request sent by the client to add the employee interval date working hours to the second R & D correspondence, query the project closing date of the target R & D project from the database; When the project closing date is greater than or equal to the employee interval date working hours, add the employee interval date working hours to the second R & D correspondence and perform corresponding association in the database; When the project closing date is less than the employee interval date working hours, prohibit adding the employee interval date working hours to the second R & D correspondence.

9. A R & D project management system, characterized in that, includes: A R & D management module, which is used to obtain R & D management information and confirm the R & D management information; wherein, the R & D management information includes: R & D institution information and R & D project information; A cost management module, which is used to obtain R & D cost information and execute the R & D project data processing method as described in any one of claims 1 to 8 according to the R & D cost information.

10. The R & D project management system according to claim 9, wherein, it further includes: A standardization management module, which is used to obtain standardized product information and match the corresponding R & D project information according to the standardized product information; An intellectual property management module, the R & D management module is used to obtain intellectual property information and match the corresponding intellectual property information according to the R & D project information; A data analysis module, which is used to obtain the data of the R & D management module, the data of the cost management module, the data of the standardization management module and the data of the intellectual property management module and perform dynamic analysis; wherein the result of the dynamic analysis is displayed in a chart form on the interaction interface; A permission management module, which is used to obtain the user level and set or modify the corresponding management permissions according to the user level.

11. The R & D project management system according to claim 10, wherein, the intellectual property management module includes: A patent management module, which is used to obtain patent information and match the corresponding R & D project information according to the patent information; A trademark management module, which is used to obtain trademark information and match the corresponding R & D project information according to the trademark information; A copyright management module, the copyright is used to obtain copyright information and match the corresponding R & D project information; wherein, the copyright management module includes a software copyright management module and other copyright management modules. The software copyright management module is used to obtain software copyright information and match the corresponding R & D project information according to the software copyright information; the other copyright management modules are used to obtain other copyright information and match the corresponding R & D project information according to the other copyright information.

12. The R & D project management system according to claim 9, wherein, the R & D management module includes: An R & D institution management module, which is used to obtain the R & D institution information and confirm the R & D institution information; An R & D project management module, which is used to obtain the R & D project information and confirm the R & D project information; An R & D archive management module, which is used to match the R & D project information and file the R & D project archives.

Images