Intelligent auxiliary management method, system, medium and equipment for spare parts such as nuclear power plant

Abstract

The invention relates to an intelligent auxiliary management method and system for spare parts such as a nuclear power plant, a medium and equipment. Identifying the state of the spare part work order, and screening based on the state of the spare part work order to obtain a spare part work order list; classifying the equal spare part work orders to obtain equal spare part work orders of different management classification types; performing statistical counting and purchase progress classified statistics on the spare part work orders of different management classification types to obtain statistical data and corresponding summarized lists and classified statistical data tables; generating a visual display chart based on the statistical data and the progress classification statistical data table, and generating a form which can be exported according to each management classification; and setting data items which can be configured individually, generating a management mail and an attachment according to the data items, and sending the mail and the attachment. According to the invention, a classification list for auxiliary management can be automatically provided for spare part demand management manual intervention, automatic updating is carried out to focus on development of work order and spare part businesses concerned by management, and the spare part management efficiency is remarkably improved.

Description

Technical Field

[0001] This invention relates to the technical field of spare parts management in nuclear power plants, and more specifically, to an intelligent auxiliary management method, system, medium, and equipment for spare parts in nuclear power plants. Background Technology

[0002] Conducting maintenance and testing of nuclear power plant equipment according to the program and defect management requirements is a necessary condition for safe and reliable operation. Spare parts demand management is carried out to deal with situations where equipment maintenance cannot be carried out as planned due to insufficient spare parts inventory. There are more than 600,000 pieces of equipment of various types in nuclear power plants, and there are more than 160,000 potential replacement spare parts among the equipment components. Preventive maintenance is to carry out equipment maintenance regularly according to the maintenance program and management requirements, generating about 50,000 major overhaul work orders and 30,000 routine maintenance work orders each year. The procurement and consumption of spare parts are in the tens of thousands. Due to the limitations of warehouse storage space and financial costs, demand management and procurement replenishment adopt a batch and dynamic operation mode.

[0003] During the preparation of routine equipment maintenance work orders, after the preparing engineer confirms that the spare parts inventory cannot meet the needs of the maintenance work order, they reserve the required spare parts in the maintenance work order or describe the required spare parts in the demand feedback task and set it to the "awaiting spare parts" status. The spare parts engineer then reviews the list, initiates the procurement, tracks the delivery, and removes the work order from the "awaiting spare parts" status. Due to the different reasons for the missing spare parts, the importance and priority of the work, the spare parts engineer needs to verify a large amount of offline data to create a classified tracking form. Throughout the entire process, the manual verification of data, updating of forms, transmission of information, and real-time tracking updates are tedious and repetitive, greatly consuming the spare parts staff's energy and resulting in low work efficiency. Summary of the Invention

[0004] The technical problem to be solved by this invention is to provide an intelligent auxiliary management method, system, medium and equipment for spare parts in nuclear power plants, etc., in view of the problems existing in the prior art.

[0005] The technical solution adopted by this invention to solve its technical problem is: to construct an intelligent auxiliary management method for spare parts in nuclear power plants, etc., comprising: Step S11: Obtain the data information of work orders and reserved spare parts, and organize the data information to form a big data management database; Step S12: Identify the status of spare parts work orders based on the data in the big data management database, and filter the data based on the status of the spare parts work orders to obtain a list of spare parts work orders. Step S13: Classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types; Step S14: Statistically count the spare parts work orders of different management classification types to obtain statistical data and corresponding summary lists; Step S15: Perform procurement progress classification statistics on the spare parts work orders of different management classification types, and generate a progress classification statistics table; Step S16: Generate a visual display chart based on the statistical data and the progress classification statistical data table, and generate a form that can be exported according to each management category; Step S17: Set up customizable data items, generate management emails and attachments based on the data items, and send them.

[0006] In the intelligent auxiliary management method for spare parts in nuclear power plants according to the present invention, step S12, which involves identifying the status of spare parts work orders based on data in the big data management database and filtering data based on the status of the spare parts work orders to obtain a list of spare parts work orders, includes: Based on the data in the big data management database, identify the status of spare parts work orders and obtain the work order status of all spare parts work orders. Extract spare parts work orders with the target work order status; In the spare parts work orders with the target work order status, delete the spare parts work orders with the first work order status. Delete spare parts work orders whose system status is set to the preset status; The remaining spare parts work orders are summarized to generate the spare parts work order list.

[0007] In the intelligent auxiliary management method for spare parts in nuclear power plants according to the present invention, step S13 involves classifying the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types, including: Obtain the priority and equipment importance of each spare parts work order in the spare parts work order list; The spare parts work orders in the spare parts work order list are classified according to their priority and the importance of the equipment, so as to obtain spare parts work orders of different management classification types.

[0008] In the intelligent auxiliary management method for spare parts in nuclear power plants described in this invention, the spare parts work orders of different management classification types include: spare parts A, spare parts B, spare parts with code, spare parts with replacement, spare parts transferred to overhaul, spare parts with preventive maintenance, spare parts with PM and other expired parts; The step of classifying the spare parts work orders in the spare parts work order list according to their priority and the importance of the equipment, to obtain the spare parts work orders of different management classification types, includes: If the priority of the spare parts work order is level three or four, and the management objective of the corresponding spare parts procurement application is to sign a purchase order within 40 days, then the management classification type of the spare parts work order is spare parts A. If the priority of the spare parts work order is other than level three or four, and the procurement application management objective for the corresponding spare parts is to sign a purchase order within 90 days, then the type of the spare parts work order is spare parts B. If the spare parts work order requires the spare parts engineer to first complete the code creation and spare parts reservation for the maintenance work order before entering the spare parts A or spare parts B process, then the type of the spare parts work order is equal code. If the spare parts work order is for a spare parts that the supplier has indicated is no longer in production or has been upgraded, and the feasibility of its application in the field needs to be verified, then after the alternative demonstration is completed, the code is created, and the spare parts are reserved in the maintenance work order, it needs to enter the spare parts A or spare parts B process. In this case, the type of the spare parts work order is alternative. If the spare parts work order refers to a situation where the field equipment has not experienced a defect, but selective maintenance is carried out based on internal or external feedback or technical decisions / management action plans, then the type of such spare parts work order is feedback-based spare parts. If the spare parts work order is purchased before the overhaul shutdown time window and implemented during the overhaul window, then the type of the spare parts work order is "transfer to overhaul". If the work order type of the aforementioned spare parts work order is NPRV or NSRV, then the management classification type of the spare parts work order is preventive maintenance and other spare parts. If the spare parts work order is for PM spare parts, and the current date has exceeded the preset expiration date of the PM work order, then the management classification type of the spare parts work order is PM spare parts overdue. If the spare parts work order is not of the type listed in the above spare parts management classification, then the type of the spare parts work order is "other".

[0009] In the intelligent auxiliary management method for spare parts such as nuclear power plants described in this invention, the statistical data in step S14 includes: the total number of spare parts, the overdue data of spare parts, the data of PM spare parts, the overdue data of PM spare parts, and the code data. The summary list includes: a list of total number of spare parts, a list of overdue spare parts, a list of PM spare parts, a list of PM spare parts that have expired, and a list of spare parts with corresponding codes.

[0010] In the intelligent auxiliary management method for spare parts such as those used in nuclear power plants described in this invention, the procurement progress of the spare parts work orders of different management classification types in step S15 includes: procurement application pending approval, procurement application pending sub-itemization, pending procurement inquiry, procurement clarification, pending ordering, ordered but not delivered, transported but not delivered, delivered but to be inspected, discrepancies to be handled, and all accepted.

[0011] In the intelligent auxiliary management method for spare parts in nuclear power plants described in this invention, the visualization charts in step S16 include: a six-month trend chart of spare parts for the unit and a trend chart of internal control targets for spare parts.

[0012] This invention also provides an intelligent auxiliary management system for spare parts in nuclear power plants, etc., comprising: The data acquisition unit is used to acquire data information of work orders and reserved spare parts, and to organize the data information to form a big data management database. The work order filtering unit is used to identify the status of spare parts work orders based on the data in the big data management database, and to filter the data based on the status of the spare parts work orders to obtain a list of spare parts work orders. The work order classification unit is used to classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types. The work order data statistics unit is used to statistically count spare parts work orders of different management classification types to obtain statistical data and corresponding summary lists. The work order progress classification unit is used to classify and statistically analyze the procurement progress of spare parts work orders of different management classification types and generate a progress classification statistics table. The chart visualization unit is used to generate visualization charts based on the statistical data and the progress classification statistical data table, and to generate forms that can be exported according to each management category; The management configuration unit is used to set customizable data items, generate management emails and attachments based on the data items, and send them.

[0013] The present invention also provides a storage medium storing a computer program adapted for loading by a processor to execute the steps of the intelligent auxiliary management method for spare parts in nuclear power plants, etc., as described above.

[0014] The present invention also provides an electronic device, including a memory and a processor, wherein the memory stores a computer program, and the processor executes the steps of the intelligent auxiliary management method for spare parts such as nuclear power plants as described above by calling the computer program stored in the memory.

[0015] The intelligent auxiliary management method, system, medium, and equipment for spare parts in nuclear power plants implementing the present invention have the following beneficial effects: They include: acquiring data information on work orders and reserved spare parts and constructing a big data management database; identifying the status of spare parts work orders and filtering data based on the status to obtain a list of spare parts work orders; classifying spare parts work orders to obtain spare parts work orders of different management categories; statistically counting spare parts work orders of different management categories to obtain statistical data and corresponding summary lists; classifying and statistically analyzing the procurement progress of spare parts work orders of different management categories to generate a progress classification statistical data table; generating visual display charts based on the statistical data and progress classification statistical data table, and generating forms that can be exported according to each management category; setting customizable data items and generating and sending management emails and attachments based on the data items. This invention can automatically provide auxiliary management classification lists for manual intervention in spare parts demand management and automatically update them to focus on promoting the development of work orders and spare parts business of management concern, significantly improving the efficiency of spare parts management. Attached Figure Description

[0016] The present invention will be further described below with reference to the accompanying drawings and embodiments. In the accompanying drawings: Figure 1 This is a flowchart illustrating the intelligent auxiliary management method for spare parts in nuclear power plants and other applications provided by this invention. Figure 2 This is a visual representation chart provided by the present invention; Figure 3 This is a schematic diagram of the email configuration operation interface provided by the present invention; Figure 4 This is a logic block diagram of the intelligent auxiliary management system for spare parts in nuclear power plants and other applications provided by the present invention. Detailed Implementation

[0017] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort are within the scope of protection of the present invention.

[0018] To address the existing problems in the tracking and management of spare parts, this invention provides an intelligent auxiliary management method and system for spare parts in nuclear power plants, which improves efficiency and quality.

[0019] refer to Figure 1In a preferred embodiment, the intelligent auxiliary management method for spare parts in nuclear power plants includes steps S11, S12, S13, S14, S15, S16, and S17. The steps are as follows: Step S11: Obtain the data information of work orders and reserved spare parts, and organize the data information to form a big data management database.

[0020] In this embodiment of the invention, work order and reserved spare parts data can be directly obtained from the SAP system (Simplified Chinese SAP system), and the obtained data can be organized into a big data management database, thereby providing a data foundation for subsequent intelligent auxiliary management of spare parts. The work order and reserved spare parts data includes, but is not limited to: notification number, work order number, function location, work order description, work order type, work order status, main work center, priority, system conditions, version, material code, material description, reserved number, reserved line item number, reserved / purchase requisition, required quantity, required date, number of availability checks, availability, inventory quantity, current order quantity, reserved quantity, reorder point, delivery quantity, purchase requisition, line number, etc.

[0021] Step S12: Identify the status of spare parts work orders based on the data in the big data management database, and filter the data based on the status of spare parts work orders to obtain a list of spare parts work orders.

[0022] In some embodiments, step S12, identifying the status of spare parts work orders based on data in the big data management database and filtering data based on the status of spare parts work orders to obtain a list of spare parts work orders, includes: identifying the status of spare parts work orders based on data in the big data management database to obtain the work order status of all spare parts work orders; extracting spare parts work orders with target work order status; deleting spare parts work orders with the work order status of the first work order status (here, the first work order status is a specific work order status) from the spare parts work orders with the target work order status; deleting spare parts work orders with the system status of a preset status; and summarizing the remaining spare parts work orders to generate a list of spare parts work orders. Optionally, in this embodiment of the invention, the target work order status is PRWD HOLD status, the specific work order status is PC status or REJ status; and the preset status is CLSD status or TECO status.

[0023] Specifically, the main purpose of this step is to determine the management scope and status of spare parts work orders, such as those for equipment maintenance. Specifically: First, identify the status of all spare parts work orders from the big data management database; next, extract spare parts work orders whose [work order status] includes the PRWDHOLD status; then, exclude work orders whose [work order status] includes PC status and REJ status; further exclude work orders whose [system status] is CLSD status and TECO status; finally, filter out the spare parts work orders that meet the criteria and form a spare parts work order list.

[0024] Step S13: Classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types.

[0025] In some embodiments, step S13, classifying the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types, includes: obtaining the priority and equipment importance of each spare parts work order in the spare parts work order list; classifying the spare parts work orders in the spare parts work order list according to the priority and equipment importance of each spare parts work order to obtain spare parts work orders of different management classification types.

[0026] Optionally, in this embodiment of the invention, spare parts work orders of different management classification types include: spare parts A, spare parts B, spare parts with code, spare parts for replacement, spare parts for major overhaul, spare parts for preventive maintenance (i.e., PM spare parts), PM spare parts overdue, and others. That is, spare parts work orders are classified according to the priority of the work order and the importance of the equipment, thereby dividing the spare parts work orders in the spare parts work order list into eight categories: spare parts A, spare parts B, spare parts with code, spare parts for replacement, spare parts for major overhaul, spare parts for preventive maintenance, PM spare parts overdue, and others.

[0027] In some embodiments, spare parts work orders in the spare parts work order list are classified according to their priority and the importance of the equipment, resulting in different management classification types for spare parts work orders. These include: if a spare parts work order has a priority level of three or four, and the management objective for its corresponding spare parts procurement request is to sign a purchase order within 40 days, then the management classification type of this spare parts work order is spare parts A; if a spare parts work order has a priority level other than three or four, and the management objective for its corresponding spare parts procurement request is to sign a purchase order within 90 days, then the management classification type of this spare parts work order is spare parts B; if a spare parts work order requires a spare parts engineer to first complete code creation and spare parts reservation for the repair work order before entering the spare parts A or spare parts B process, then the management classification type of this spare parts work order is code; if a spare parts work order is for a supplier that reports that the required spare parts are discontinued or upgraded, and the feasibility of its field application needs to be verified. If a work order requires the completion of alternative verification, code creation, and spare parts reservation for maintenance, and then proceeds to either Spare Part A or Spare Part B, the type of the spare part work order is "Alternative." If the spare part work order pertains to selective maintenance based on internal / external feedback or technical decisions / management action plans even though the equipment on-site has no defects, the type of the spare part work order is "Feedback Spare Part." If the spare part work order pertains to procurement before the overhaul downtime window and is implemented during the overhaul window, the management classification type of the spare part work order is "Transfer to Overhaul." If the work order type of the spare part work order is NPRV or NSRV, the management classification type of the spare part work order is "Preventive Maintenance Spare Part." If the spare part work order pertains to PM spare parts and the current date has exceeded the preset expiration date of the PM work order, the management classification type of the spare part work order is "PM Spare Part Expiration." If the spare part work order pertains to a type other than the above spare part management classification types, the type of the spare part work order is "Other."

[0028] Spare Parts A: Spare Parts work orders with a priority level of 3 or 4 require a purchase order to be signed within 40 days for the corresponding missing spare parts. In this category, data in the Spare Parts Alert menu that is not in a closed tab, specifically data for Spare Parts A under the [Spare Parts Category], is automatically counted by department corresponding to the main work center. "Not in a closed tab" refers to tabs other than those that are closed.

[0029] Spare Parts B: Spare parts work orders with priority levels other than 3 and 4. The purchase request for the corresponding missing spare parts must be signed within 90 days. In this category, the data in the spare parts warning menu that is not in the closed tab, and the data in [Spare Parts Category] that is Spare Parts B, will have the number of [work orders] automatically counted according to the department corresponding to the main work center.

[0030] Parts coding: Only after the spare parts engineer completes the part code creation and spare parts reservation for the maintenance work order can the spare parts work order enter the spare parts A or spare parts B process. Without a spare parts code, the procurement process cannot proceed. In this category, data in the spare parts warning menu that is not in a closed tab, and data with the [Spare Parts Category] set to the spare parts code, will have the number of [work orders] automatically counted according to the department corresponding to the main work center.

[0031] Replacement: Suppliers report that the spare parts needed for equipment maintenance are discontinued or upgraded. A technical verification is required to ensure the replacement product remains suitable for the field system and equipment. Only after the replacement code is created and the spare part is reserved in the maintenance work order can the replacement work order enter the "Waiting for Spare Parts A" or "Waiting for Spare Parts B" process. In this category, data in the "Waiting for Spare Parts" warning menu that is not in a closed tab, under "[Waiting for Spare Parts Category]," represents replacement data. The number of "[Work Orders]" is automatically counted according to the department corresponding to the main work center.

[0032] Feedback and Spare Parts: Spare parts work orders are for situations where the field equipment has not yet experienced a defect, but selective maintenance is required based on internal or external feedback, technical decisions, or management actions. In this category, data in the spare parts alert menu that is not in a closed tab, under [Spare Parts Category], represents feedback and spare parts data. The number of [work orders] is automatically counted by the department corresponding to the main work center.

[0033] Major Overhaul: Each unit needs to undergo refueling according to the planned schedule. Maintenance of some equipment requires shutting down the nuclear reactor or steam generator system, which needs to be scheduled within the major overhaul shutdown window. Related spare parts must be purchased and delivered before the corresponding window, and work orders for these spare parts are required. In this category, data in the spare parts warning menu that is not in a closed tab, under "[Spare Parts Category]", represents data transitioning to major overhaul. The number of [work orders] is automatically calculated according to the department corresponding to the main work center.

[0034] PM and other spare parts: Preventive maintenance work orders are issued periodically according to the pre-set maintenance cycle of preventive maintenance. The work order type is NPRV or NSRV. These work orders are generally generated one to two years in advance. Spare parts procurement applications are automatically triggered according to the spare parts demand list and spare parts procurement strategy of the associated maintenance plan. If the spare parts have not arrived three months before the implementation plan expires, the spare parts work order type is PM (i.e., preventive maintenance) and the quantity of [work orders] is automatically counted according to the work order type. PM and other spare parts expired: If the spare parts work order type is NPRV or NSRV and the current date has exceeded the preset expiration date of the PM work order, then the spare parts work order type is PM and other spare parts expired. Other: Maintenance work orders that do not include a description of the spare parts management category. Within this category, data in the spare parts alert menu that is not on a closed tab, where [Spare Parts Category] is "Other," will have the number of [Work Orders] automatically counted according to the department corresponding to the main work center.

[0035] Step S14: Statistically count spare parts work orders of different management categories to obtain statistical data and corresponding summary lists.

[0036] In some embodiments, in step S14, the statistical data includes: the total number of spare parts, the overdue data of spare parts, the data of PM spare parts, the overdue data of PM spare parts, and the data of the corresponding codes. The summary list includes: a list of the total number of spare parts, a list of overdue spare parts, a list of PM spare parts, a list of PM spare parts, and a list of the corresponding codes.

[0037] In this step, spare parts work orders of different management categories after classification are statistically counted. Specifically, spare parts work orders with unclosed early warning tasks are statistically counted according to their relevant management categories, and a time-based statistical data table (i.e., a summary list) is automatically generated. The specific statistical count is as follows: Total number of spare parts: Data in the spare parts warning menu that is not closed. The number of [work orders] is automatically counted according to the department corresponding to the main work center, and a list that can be exported is compiled (i.e., the total number of spare parts list).

[0038] Overdue spare parts: Data in the spare parts warning menu that is not on the closed tab, and data in the [Overdue] field that is not empty, will automatically count the number of [work orders] according to the department corresponding to the main work center, and summarize and export a list (i.e., the list of overdue spare parts).

[0039] PM and other spare parts: Data in the spare parts warning menu that is not on the closed tab. The [Work Order Type] field is “NPRV” / “NSRV”. The number of [Work Orders] is automatically counted according to the department corresponding to the main work center, and a list that can be exported is summarized (i.e. PM and other spare parts list).

[0040] PM and other spare parts expired: In the spare parts warning menu, on the non-closed tabs and in the PM and other spare parts data list, determine the data where [current date] > [expiration date], count the number of [work orders] according to the department corresponding to the main work center, and summarize the exportable list (i.e. PM and other spare parts expired list).

[0041] Identification Code: Data in the [Work Order Description] section of the spare parts warning menu that contains identification codes will be automatically counted according to the department corresponding to the main work center, and a list that can be exported (i.e., identification code list) will be compiled.

[0042] Step S15: Perform procurement progress classification statistics on spare parts work orders of different management classification types, and generate a progress classification statistics table.

[0043] In some embodiments, in step S15, the procurement progress of spare parts work orders of different management classification types includes: procurement application pending approval, procurement application pending sub-itemization, pending procurement inquiry, procurement clarification, pending ordering, ordered but not delivered, transported but not delivered, delivered but to be inspected, discrepancies to be handled, and all accepted.

[0044] Specifically, in this step, the procurement progress of missing spare parts for all completed spare parts work orders is classified and statistically analyzed, divided into: procurement application pending approval → procurement application pending order allocation → pending procurement inquiry → procurement clarification → pending ordering → ordered but not delivered → goods not delivered → goods delivered but pending acceptance → discrepancies pending handling → all accepted, and a progress classification statistical data table (i.e., statistical data table for each node) is automatically generated.

[0045] Regarding the progress of the aforementioned spare parts work orders, the following nodes require attention or handling of any anomalies: Pending Projects: Data on tabs not closed in the Spare Parts Warning Menu. In the Pending Projects list, the number of [work orders] is automatically counted according to the department corresponding to the main work center, and a list that can be exported is compiled.

[0046] Project approval overdue: In the spare parts warning menu, for data on tabs that are not closed, if the processing conclusion is procurement and there is a DM project application submission date and [procurement application approval date] is empty, and [current date] - DM project application submission date > 7 days, the number of [work orders] will be automatically counted according to the department corresponding to the main work center, and a list that can be exported will be compiled.

[0047] Pending Orders: Data in the spare parts warning menu that is not on a closed tab. If there is a value for [Modified Purchase Request - Line Number] corresponding to the work order number, then use [Modified Purchase Request - Line Number]. If there is no value, then use [Purchase Request - Line Number] to filter the purchase node as Pending Orders in the "Full Procurement Process Visualization" function. The number of [Work Orders] will be automatically counted according to the department corresponding to the main work center, and a list that can be exported will be compiled.

[0048] Overdue Orders: For data in the spare parts alert menu that is not on a closed tab, the number of [work orders] will be automatically calculated according to the department corresponding to the main work center, and a list that can be exported will be compiled. For spare parts A: [order creation date] - [purchase application approval date] > 40 days; for non-spare parts A: [order creation date] - [purchase application approval date] > 90 days.

[0049] Pending Delivery: For data in the spare parts warning menu that is not on a closed tab, if there is a value in [Modified Purchase Request - Line Number] corresponding to the work order number, then use [Modified Purchase Request - Line Number]; if there is no value, then use [Purchase Request - Line Number] to filter the data with the purchase node as "Ordered but Not Delivered" in the "Full Procurement Process Visualization" window, automatically count the number of [Work Orders] by the department corresponding to the main work center, and summarize and export a list.

[0050] Overdue delivery: If the [Modified Purchase Request - Line Number] corresponding to the pending delivery list has a value, then use [Modified Purchase Request - Line Number]; if it has no value, then use [Purchase Request - Line Number] to determine whether it is overdue in the [Overdue Undelivered Orders], automatically count the number of [Work Orders] according to the department corresponding to the main work center, and summarize and export the list.

[0051] Pending Acceptance: For data in the spare parts warning menu that is not on a closed tab, if there is a value in [Modified Procurement Request - Line Number] corresponding to the work order number, then use [Modified Procurement Request - Line Number]; if there is no value, then use [Procurement Request - Line Number] to filter the procurement node as "Delivery Pending Acceptance" in the "Full Procurement Process Visualization" window, automatically count the number of [work orders] according to the department corresponding to the main work center, and summarize and export a list.

[0052] Overdue for acceptance: In the pending acceptance list, both [Quantity of Accepted Items] and [Quantity of Discrepancies] are 0, and MvT [Movement Type of Spare Parts in Warehousing Process] is "103", and [Current Date] - Latest [Input Date] > Specified Deadline (C / R: 21, S / P / T: 45). The number of [Work Orders] will be automatically counted according to the department corresponding to the main work center, and a list that can be exported will be compiled.

[0053] If the [Acceptance Method] is "C", then the specified period is 21; if the [Acceptance Method] is "R", then the specified period is 21; if the [Acceptance Method] is "S", then the specified period is 45; if the [Acceptance Method] is "P", then the specified period is 45; if the [Acceptance Method] is "T", then the specified period is 45.

[0054] This week's newly added spare parts A: Data in the spare parts warning menu that is not in the closed tab. The spare parts A data for the current day is compared with the spare parts A data for last Sunday. The number of [work orders] is automatically counted according to the department corresponding to the main work center, and a list that can be exported is compiled.

[0055] Step S16: Generate a visualization chart based on statistical data and progress classification statistical data tables, and generate a form that can be exported according to each management category.

[0056] In some embodiments, in step S16, the visualization charts include: a six-month trend chart of spare parts for the unit and a six-month trend chart of internal control targets for spare parts.

[0057] Specifically, based on the set management indicators, visual charts are generated from the statistical data of steps S14 to S15 (e.g., Figure 2 (As shown), and automatically generates forms that can be exported according to each management category. Among them, the visually displayable charts include: a six-month trend chart of spare parts A and a target trend chart of spare parts content.

[0058] The trend chart for spare parts A in the unit over six months is as follows: In the spare parts warning menu, the data in the [Spare Parts Category] of the non-closed tabs is spare parts A. The number of [Work Orders] is automatically counted according to the department corresponding to the main work center, and a list can be exported. The trend chart for 26 weeks over six months is calculated (supplementary parts A that are not in this week are counted using the data at the time of each Sunday, and this week's data is counted using the current data). The default is to display the data for 26 weeks, but the time can be selected to adjust.

[0059] The target trend charts for spare parts can be divided into departmental internal control target trend charts and section internal control target trend charts. The departmental internal control target trend chart includes both departmental internal control targets and actual targets. Similarly, the section internal control targets include both section internal control targets and actual targets.

[0060] 1. Department: Departmental internal control objective: Configure in "Custom Configuration - Spare Parts Requirement Warning"; Actual objective: Based on the data in the spare parts warning menu (excluding closed tabs) of the [Main Work Center] filter, count the number of work orders. For details on the relationship between the Main Work Center and departments, please refer to the [Main Work Center Relationship File] table.

[0061] 2. Department: Internal control objective of each department: Configure a bar chart corresponding to the department in "Custom Configuration - Spare Parts Requirement Warning" to show the internal control completion status of each department under that department.

[0062] Actual goal: Filter the data in the [Spare Parts Master List] according to the [Main Work Center] to automatically count the number of [Work Orders] and summarize them into an exportable list.

[0063] Step S17: Set up customizable data items, generate management emails and attachments based on the data items, and send them.

[0064] Specifically, in this step, the corresponding management email can be generated by configuring the email format and content, and then sent to the corresponding spare parts requirement manager to help provide a classification list for focused promotion and improve the efficiency of spare parts management.

[0065] Specifically, such as Figure 3 As shown, clicking "Send Email" will bring up Outlook. Match the following setting: "Custom Configuration - Spare Parts Requirement Alerts - Email Content Settings". 1. Email displays metrics and their order (drag the icon to the right of the metric name up or down to move the metric's position). 2. For the indicator display field, whether the data is inserted into the body of the email in table format, or as an attachment, the attachment list will be checked again to see if the work order status includes "PRWD HOLD" and whether the specific work order status and the deleted system status are the default status. If so, it will be in the attachment list; otherwise, it will be directly updated to "completed and closed" and will not be reflected in the attachment. Click the icon to the right of the indicator name, select the field, and if "Insert into email body display" is checked, the detailed content corresponding to the indicator will be displayed in the body of the email; otherwise, it will be an attachment.

[0066] refer to Figure 4 , Figure 4 The present invention provides an intelligent auxiliary management system for spare parts in nuclear power plants and other applications.

[0067] Specifically, such as Figure 4 As shown, the intelligent auxiliary management system for spare parts in this nuclear power plant includes: The data acquisition unit 401 is used to acquire data information of work orders and reserved spare parts, and to organize the data information to form a big data management database.

[0068] The work order filtering unit 402 is used to identify the status of spare parts work orders based on data in the big data management database, and to filter the data based on the status of spare parts work orders to obtain a list of spare parts work orders.

[0069] The work order classification unit 403 is used to classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types.

[0070] The work order data statistics unit 404 is used to count spare parts work orders of different management categories and obtain statistical data and corresponding summary lists.

[0071] The work order progress classification unit 405 is used to classify and statistically analyze the procurement progress of spare parts work orders of different management classification types, and generate a progress classification statistical data table.

[0072] The chart visualization unit 406 is used to generate visualization charts based on statistical data and progress classification statistical data tables, and to generate forms that can be exported according to each management category.

[0073] The management configuration unit 407 is used to set customizable data items, generate management emails based on the data items, and send them.

[0074] Specifically, the specific coordination and operation processes between the various units in the intelligent auxiliary management system for spare parts such as nuclear power plants can be referred to the aforementioned intelligent auxiliary management method for spare parts such as nuclear power plants, and will not be repeated here.

[0075] This invention automatically retrieves maintenance work orders from the SAP system, automatically calculates and checks whether the inventory meets the spare parts requirements of the corresponding work orders, automatically establishes a spare parts work order management ledger, automatically classifies work orders based on keywords, work order type, procurement progress, etc. in the work order description, and automatically generates management emails in a personalized and adjustable manner. It provides a classification list to focus on key tasks to assist manual intervention in spare parts demand management, reduces the energy and workload of spare parts staff, and significantly improves the efficiency of spare parts management.

[0076] Furthermore, an electronic device of the present invention includes a memory and a processor; the memory is used to store a computer program; the processor is used to execute the computer program to implement the intelligent auxiliary management method for spare parts in nuclear power plants, as described above. Specifically, according to embodiments of the present invention, the processes described above with reference to the flowchart can be implemented as computer software programs. For example, embodiments of the present invention include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the methods shown in the flowchart. In such embodiments, when the computer program is downloaded, installed, and executed by an electronic device, it performs the functions defined in the methods of the embodiments of the present invention. The electronic device of the present invention can be a terminal such as a laptop, desktop computer, tablet computer, or smartphone, or it can be a server.

[0077] Furthermore, one type of storage medium of the present invention stores a computer program thereon, which, when executed by a processor, implements the intelligent auxiliary management method for spare parts in nuclear power plants, etc., as described above. Specifically, it should be noted that the storage medium described above in the present invention can be a computer-readable signal medium or a computer-readable storage medium, or any combination of the two. A computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, device, or any combination thereof. More specific examples of a computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer disk, a hard disk, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fiber, portable compact disk read-only memory (CD-ROM), optical storage device, magnetic storage device, or any suitable combination thereof. In the present invention, a computer-readable storage medium can be any tangible medium containing or storing a program that can be used by or in conjunction with an instruction execution system, device, or apparatus. In the present invention, a computer-readable signal medium can include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code. The transmitted data signal can take various forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination thereof. The computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium, which can send, propagate, or transmit a program for use by or in connection with an instruction execution system, apparatus, or device. The program code contained on the computer-readable medium can be transmitted using any suitable medium, including but not limited to: wires, optical fibers, RF (radio frequency), etc., or any suitable combination thereof.

[0078] The aforementioned computer-readable medium may be included in the aforementioned electronic device; or it may exist independently and not assembled into the electronic device.

[0079] The various embodiments in this specification are described in a progressive manner, with each embodiment focusing on its differences from other embodiments. Similar or identical parts between embodiments can be referred to interchangeably. For the apparatus disclosed in the embodiments, since they correspond to the methods disclosed in the embodiments, the description is relatively simple; relevant parts can be referred to the method section.

[0080] Those skilled in the art will further recognize that the units and algorithm steps of the various examples described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of both. To clearly illustrate the interchangeability of hardware and software, the components and steps of the various examples have been generally described in terms of functionality in the foregoing description. Whether these functions are implemented in hardware or software depends on the specific application and design constraints of the technical solution. Those skilled in the art can use different methods to implement the described functions for each specific application, but such implementations should not be considered beyond the scope of this invention.

[0081] The steps of the methods or algorithms described in conjunction with the embodiments disclosed herein can be implemented directly by hardware, a software module executed by a processor, or a combination of both. The software module can be located in random access memory (RAM), main memory, read-only memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, removable disk, CD-ROM, or any other form of storage medium known in the art.

[0082] The above embodiments are only for illustrating the technical concept and features of the present invention, and are intended to enable those skilled in the art to understand the content of the present invention and implement it accordingly. They do not limit the scope of protection of the present invention. All equivalent changes and modifications made within the scope of the claims of the present invention should fall within the scope of the claims of the present invention.

Claims

1. A method for intelligent auxiliary management of spare parts in nuclear power plants, etc., characterized in that, include: Step S11: Obtain the data information of work orders and reserved spare parts, and organize the data information to form a big data management database; Step S12: Identify the status of spare parts work orders based on the data in the big data management database, and filter the data based on the status of the spare parts work orders to obtain a list of spare parts work orders. Step S13: Classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types; Step S14: Statistically count the spare parts work orders of different management classification types to obtain statistical data and corresponding summary lists; Step S15: Perform procurement progress classification statistics on the spare parts work orders of different management classification types, and generate a progress classification statistics table; Step S16: Generate a visual display chart based on the statistical data and the progress classification statistical data table, and generate a form that can be exported according to each management category; Step S17: Set up customizable data items, generate management emails and attachments based on the data items, and send them.

2. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 1, is characterized in that, In step S12, the status of spare parts work orders is identified based on the data in the big data management database, and data is filtered based on the status of the spare parts work orders to obtain a list of spare parts work orders, including: Based on the data in the big data management database, identify the status of spare parts work orders and obtain the work order status of all spare parts work orders. Extract spare parts work orders with the target work order status; In the spare parts work orders with the target work order status, delete the spare parts work orders with the first work order status. Delete spare parts work orders whose system status is set to the preset status; The remaining spare parts work orders are summarized to generate the spare parts work order list.

3. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 1, is characterized in that, In step S13, the spare parts work orders in the spare parts work order list are classified to obtain spare parts work orders of different management classification types, including: Obtain the priority and equipment importance of each spare parts work order in the spare parts work order list; The spare parts work orders in the spare parts work order list are classified according to their priority and the importance of the equipment, so as to obtain spare parts work orders of different management classification types.

4. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 3, is characterized in that, The different management classification types of spare parts work orders include: spare parts A, spare parts B, spare parts with code, spare parts for replacement, spare parts transferred to overhaul, spare parts for preventive maintenance, spare parts for PM that are overdue, and others; The step of classifying the spare parts work orders in the spare parts work order list according to their priority and the importance of the equipment, to obtain the spare parts work orders of different management classification types, includes: If the priority of the spare parts work order is level three or four, and the management objective of the corresponding spare parts procurement application is to sign a purchase order within 40 days, then the management classification type of the spare parts work order is spare parts A. If the priority of the spare parts work order is other than level three or four, and the management objective of the corresponding spare parts procurement application is to sign a purchase order within 90 days, then the management classification type of the spare parts work order is spare parts B. If the spare parts work order requires the spare parts engineer to first complete the code creation and spare parts reservation for the maintenance work order before entering the spare parts A or spare parts B process, then the management classification type of the spare parts work order is equal code. If the spare parts work order is for a spare parts that the supplier has indicated is no longer in production or has been upgraded, and the feasibility of its application in the field needs to be verified, then after the alternative demonstration is completed, the code is created, and the spare parts are reserved in the maintenance work order, it needs to enter the spare parts A or spare parts B process. In this case, the type of the spare parts work order is alternative. If the spare parts work order refers to a situation where the field equipment has not experienced a defect, but selective maintenance is carried out based on internal or external feedback or technical decisions / management action plans, then the type of such spare parts work order is feedback-based spare parts. If the spare parts work order is purchased before the overhaul shutdown time window and implemented during the overhaul window, then the management classification type of the spare parts work order is "transfer to overhaul". If the work order type of the aforementioned spare parts work order is NPRV or NSRV, then the management classification type of the spare parts work order is preventive maintenance and other spare parts. If the spare parts work order is for PM spare parts, and the current date has exceeded the preset expiration date of the PM work order, then the management classification type of the spare parts work order is PM spare parts overdue. If the spare parts work order is not of the type listed in the above spare parts management classification, then the type of the spare parts work order is "other".

5. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 1, is characterized in that, In step S14, the statistical data includes: total number of spare parts, overdue data of spare parts, PM spare parts data, PM spare parts overdue data, and code data. The summary list includes: a list of total number of spare parts, a list of overdue spare parts, a list of PM spare parts, a list of PM spare parts that have expired, and a list of spare parts with corresponding codes.

6. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 1, is characterized in that, In step S15, the procurement progress of spare parts work orders of different management classification types includes: procurement application pending approval, procurement application pending sub-order, pending procurement inquiry, procurement clarification, pending order, ordered but not delivered, transported but not delivered, delivered but to be inspected, discrepancies to be handled, and all accepted.

7. The intelligent auxiliary management method for spare parts in nuclear power plants, etc., according to claim 1, is characterized in that, In step S16, the visualization charts include: a six-month trend chart of spare parts for the unit and a six-month trend chart of internal control targets for spare parts.

8. An intelligent auxiliary management system for spare parts in nuclear power plants, etc., characterized in that, include: The data acquisition unit is used to acquire data information of work orders and reserved spare parts, and to organize the data information to form a big data management database. The work order filtering unit is used to identify the status of spare parts work orders based on the data in the big data management database, and to filter the data based on the status of the spare parts work orders to obtain a list of spare parts work orders. The work order classification unit is used to classify the spare parts work orders in the spare parts work order list to obtain spare parts work orders of different management classification types. The work order data statistics unit is used to statistically count spare parts work orders of different management classification types to obtain statistical data and corresponding summary lists. The work order progress classification unit is used to classify and statistically analyze the procurement progress of spare parts work orders of different management classification types and generate a progress classification statistics table. The chart visualization unit is used to generate visualization charts based on the statistical data and the progress classification statistical data table, and to generate forms that can be exported according to each management category; The management configuration unit is used to set customizable data items, generate management emails and attachments based on the data items, and send them.

9. A storage medium, characterized in that, The storage medium stores a computer program adapted for loading by a processor to execute the steps of the intelligent auxiliary management method for spare parts in nuclear power plants, as described in any one of claims 1 to 7.

10. An electronic device, characterized in that, It includes a memory and a processor, wherein the memory stores a computer program, and the processor executes the steps of the intelligent auxiliary management method for spare parts in nuclear power plants as described in any one of claims 1 to 7 by calling the computer program stored in the memory.

Images