Power grid review business intelligent management system and device based on VBA technology, and storage medium

Abstract

The invention belongs to the field of office systems, particularly relates to a VBA technology-based power grid review business intelligent management system and equipment and a storage medium, and aims to solve the problems of complexity and low efficiency in the traditional manual management process. The tool is based on the Microsoft Office VBA programming technology, the system is mainly composed of an input end, a data processing module and an output end, the input end comprises a data year module, a work category module, a keyword module and the like, the data processing module conducts preprocessing and calculation, and the output end provides automatic management of review files and daily work related content. Through the digital and intelligent means, the technical innovation of the method is embodied in that the digital twinning technology of the review process is initiated, and the three stages of preparation before review, process control and tracking after review are converted into programmable logic; the efficiency and quality of review work are effectively improved, the problem of insufficient professionals is solved, and the management process of the power grid project is optimized.

Description

Technical Field

[0001] This invention belongs to the field of office systems, and in particular relates to an intelligent management system, device and storage medium for power grid review business based on VBA technology. Background Technology

[0002] With the rapid development of power grid construction, the review work for various engineering projects has gradually increased. The large amount of documents and data that need to be processed during the review process has placed enormous pressure on traditional manual management. Traditional review management has the following shortcomings: scattered storage of documents leads to version confusion, for example, the preliminary design plan of a 220kV substation once required rework due to a version error; manual statistics are time-consuming, with the compilation of review reports for one year requiring the workload of two people per week; and there is a lack of standardized tools for collaboration among flexible team members. In particular, power grid engineering reviews involve multiple stages, including pre-review, review, and post-review, with a large number of complex documents, making manual processing not only inefficient but also prone to errors. Therefore, in summary, the current document management for power grid engineering project reviews suffers from inefficiency. Summary of the Invention

[0003] The purpose of this invention is to address the inefficiency in the management of review documents for existing power grid engineering projects. It provides an intelligent management system for power grid review operations based on VBA technology, comprising:

[0004] Input module, data processing module, database, file generation module, and notification module;

[0005] The input module is used to receive review business document data;

[0006] The data processing module is used to clean and standardize the received review business document data in sequence, and store the standardized data into the database.

[0007] The output module is used to call data from the database to generate review documents;

[0008] The notification module is used to send the review documents generated by the output module to the reviewers.

[0009] Furthermore, the output module includes: a review preparation unit, a review execution unit, a review summary and feedback unit, and a daily work unit;

[0010] The review documents include: documents for the review preparation phase, documents for the review execution phase, documents for the review summary and feedback phase, and daily work documents;

[0011] The review preparation unit is used to call data from the database and generate documents for the review preparation phase.

[0012] The review execution unit is used to call data from the database and generate files for the review execution phase.

[0013] The review summary and feedback unit is used to call data from the database and generate documents for the review summary and feedback phase.

[0014] The daily work unit is used to call data from the database and generate files for daily work.

[0015] A computer storage medium, characterized in that the storage medium stores at least one instruction, which is loaded and executed by a processor to implement the aforementioned intelligent management system for power grid review business based on VBA technology.

[0016] An automatic detection device for damage to power transmission corridors in mountainous areas based on remote sensing image data is disclosed. The device includes a processor and a memory. The memory stores at least one instruction, which is loaded and executed by the processor to implement a power grid review business intelligent management system based on VBA technology.

[0017] The beneficial effects of this invention are as follows:

[0018] First, it significantly improves review efficiency. Through VBA automation technology, the system automates the entire process from data cleaning and standardization to document generation and submission. This completely solves the pain points of scattered documents and time-consuming statistics in traditional manual management.

[0019] Second, strengthen process standardization and data quality. The data processing module ensures the integrity and consistency of data in the database through a unified cleaning (duplicate removal, format correction) and standardization (unified units, time format) process; the file generation module relies on preset templates to fill in files, avoiding the arbitrariness of manual operation, and all files conform to format specifications, achieving full traceability.

[0020] Third, the system of this invention also integrates the functions of automatic generation of attendance and payroll documents, reducing manual calculation costs. The automatic push of daily communication reports (including to-do lists and emergency reminders) enables real-time information synchronization. Intelligent reminders (overdue pop-ups and schedule blocking) prevent task delays, improve overall collaboration efficiency by 60%, and significantly reduce the workload of experts and managers. Attached Figure Description

[0021] Figure 1 This is a schematic diagram of an intelligent management system architecture for power grid review business based on VBA technology according to the present invention;

[0022] Figure 2 This is a schematic diagram of the three-stage review process of the present invention;

[0023] Figure 3This is a schematic diagram of the business intelligent management process of the present invention. Detailed Implementation

[0024] Specific implementation method one: Combining Figures 1 to 3 This invention is described.

[0025] Input module, data processing module, database, file generation module, and notification module;

[0026] The input module is used to receive review business document data;

[0027] One embodiment of the input module for receiving review business document data is as follows: the input module is used to receive the design requirement document for power grid review business;

[0028] One example of the design requirements document is as follows: The design requirements document for a new substation project includes:

[0029] Project Background and Needs Analysis: The existing 110kV power grid structure can no longer meet the ever-increasing demand for electricity, and there are significant gaps in the capacity of existing substations and the transmission capacity of lines. It has been decided to build a new 220kV smart substation (hereinafter referred to as "the new station") in the load center area.

[0030] Site selection: meet the following conditions: (1) close to the load center, effectively shortening the 10kV outgoing line distance; (2) convenient transportation, facilitating the transportation of large equipment; (3) stable geological conditions, with a uniform hard plastic clay layer as determined by exploration, and the foundation bearing capacity meets the requirements; (4) slightly higher terrain, with smooth drainage, and not threatened by floods; (5) maintain sufficient safe distance and noise protection distance from surrounding residential areas, schools and other sensitive points; (6) comply with urban planning requirements and reserve land for power facilities.

[0031] Another embodiment of the review business document data is an input module used to receive design schemes from various units;

[0032] The three embodiments of the design schemes designed by each unit are as follows:

[0033] Option 1: Conventional Outdoor GIS Solution

[0034] The layout combines outdoor GIS equipment with indoor switchgear. The overall plan follows a three-column layout, from north to south: the 220kV outdoor GIS equipment area, the main transformer and 110kV outdoor GIS equipment area, and the 10kV indoor power distribution equipment building and auxiliary facilities area.

[0035] The 220kV side adopts a double busbar connection, with two incoming lines constructed in this phase and two outgoing lines reserved for future expansion. Outdoor GIS switchgear with a rated voltage of 252kV and a rated short-circuit breaking current of 50kA is selected, arranged in a "I"-shaped double-row configuration to save space. The 110kV side also adopts a double busbar connection, with six outgoing lines in this phase. The main transformer in this phase consists of two 180MVA three-phase three-winding on-load tap-changing transformers (SZ11-180000 / 220), with space reserved for a third main transformer. The main transformer foundation includes a pebble layer and an emergency oil tank, and is equipped with a water spray fire extinguishing system. The 10kV side adopts a single busbar segmented connection, equipped with 40 KYN28A-12 type switchgear units, located in the indoor distribution building, effectively improving the operating environment. Reactive power compensation is provided by four 6Mvar capacitor banks.

[0036] Option 2: Full Indoor GIS Solution

[0037] The building adopts a fully indoor layout, integrating all electrical equipment into a single multi-story building. The first floor houses the 10kV switch room, main control room, and fire protection facilities; the second floor houses the 220kV and 110kV GIS rooms and secondary equipment rooms; the main transformer is housed separately in a closed transformer room on one side of the building, isolated from other parts by solid walls and equipped with a dedicated transport channel. This layout completely eliminates the impact of outdoor equipment on the urban landscape.

[0038] The 220kV side adopts a double busbar connection, with two incoming lines and two outgoing lines reserved for future construction in this phase. Indoor GIS switchgear with a rated voltage of 252kV and a rated short-circuit breaking current of 50kA is selected. Both the 220kV and 110kV sides use indoor GIS. The main transformer adopts a fully enclosed structure with a built-in forced air cooling system for heat dissipation. The 10kV switchgear is located indoors.

[0039] Option 3: Modular Prefabricated Construction Solution

[0040] Modular construction is adopted. The entire station is divided into several functional modules: 220kV GIS prefabricated module, 110kV GIS prefabricated module, main transformer equipment (outdoor), 10kV prefabricated switch station, and secondary equipment prefabricated module (integrated power supply, communication and monitoring systems are all built-in).

[0041] Both the 220kV and 110kV main electrical lines utilize GIS equipment. The main transformers are conventionally installed outdoors, but their integrated monitoring units (oil chromatography, winding temperature measurement, etc.) are pre-installed. The 10kV distribution equipment is installed entirely within one or more prefabricated steel structure switchgear compartments, which are equipped with fire protection, lighting, and HVAC systems. The functional areas are connected via prefabricated cable trenches or buried conduits.

[0042] The data processing module is used to clean and standardize the received review business document data in sequence, and store the standardized data into the database.

[0043] One embodiment of the received review business document data undergoing sequential cleaning and standardization processing is as follows:

[0044] The data processing module is used to process the received review business document data into a unified device name and store the data after unified device name into the database.

[0045] One embodiment of the unified equipment name is to standardize "main transformer" and "main transformer" to "main transformer";

[0046] The output module is used to call data from the database to generate review documents;

[0047] One embodiment of the output module being used to generate review documents by calling data from the database is as follows:

[0048] The output module is used to retrieve data from the database to generate a summary file of design schemes.

[0049] One embodiment of generating the design scheme summary file is as follows:

[0050] Step 1: Using a predefined SQL query statement and the current project number as the key index, extract all core design data for the project from the cleaned and standardized database tables. This includes: the final overall layout plan, equipment selection and configuration parameters for each voltage level (e.g., main transformer model SZ11-180000 / 220 and its technical parameters, 220kV GIS layout, 10kV switchgear model and quantity), and design details for auxiliary facilities such as lightning protection grounding and civil engineering.

[0051] Step Two: Following the preset logical structure, reorganize and populate these unstructured text and numerical data into a pre-made Word document template. This template defines the document's chapter structure, heading styles, and reserved spaces for figures and tables. The script automatically lists the six conditions for "Site Selection," clearly describes the three-column plan for "Overall Layout," and presents the technical parameters of major equipment in a neat list format, thus automatically generating a complete and formatted draft of the "Detailed Project Design Scheme."

[0052] Step 3: Use a VBA script to start the file association retrieval and packaging program.

[0053] Based on the project type and number, automatically search for all related files in the specified directory on the server.

[0054] The documents include: the final version of CAD drawings provided by the design unit (the system will automatically convert them into PDF format for viewing), professional calculation and analysis reports (such as short-circuit current calculation and lightning protection calculation), and the manufacturer's technical specifications and drawings for the main equipment.

[0055] Automatically move or copy all the above files to the corresponding target folder.

[0056] Step four: The script uses a file system object (FileSystemObject) to compress all folders and their contents into a single compressed file, completing the physical integration of the summary file. This results in the "Design Scheme Summary File".

[0057] The notification module is used to send the review files generated by the output module to the reviewers.

[0058] One embodiment of the notification module being used to send the review documents generated by the output module to the reviewers is...

[0059] The notification module is used to send the summary file of design schemes generated by the output module to the reviewers;

[0060] One example of sending the generated design scheme summary file to the reviewers is as follows:

[0061] By calling the function to send DingTalk messages, the generated design scheme summary file is sent to the DingTalk robot, which then automates the transmission of the design scheme summary file to the reviewers.

[0062] Specific Implementation Method Two: The difference between this implementation method and Specific Implementation Method One is that...

[0063] The output module includes: a review preparation unit, a review execution unit, a review summary and feedback unit, and a daily work unit;

[0064] The review documents include: documents for the review preparation phase, documents for the review execution phase, documents for the review summary and feedback phase, and daily work documents;

[0065] The review preparation unit is used to call data from the database and generate documents for the review preparation phase.

[0066] The review execution unit is used to call data from the database and generate files for the review execution phase.

[0067] The review summary and feedback unit is used to call data from the database and generate documents for the review summary and feedback phase.

[0068] The daily work unit is used to call data from the database and generate files for daily work.

[0069] The other steps and parameters are the same as in Specific Implementation Method 1.

[0070] Specific Implementation Method Three: The difference between this implementation method and Specific Implementation Method One is that...

[0071] The review business document data includes: scheme distribution record data, notification and arrangement document data, design scheme data, meeting minutes data, meeting attendance sheet data, review opinion distribution record data, work summary document data, attendance document data, payroll document data, and communication report document data; etc., power grid review documents.

[0072] Program distribution record data: This includes textual data such as record files containing review information, distribution dates, and participants;

[0073] Notification and arrangement documents include: textual content data such as the review time, content, and participants;

[0074] Design data includes design documents for power grid construction projects, which record textual content such as project technical details, design concepts, and implementation plans.

[0075] The meeting minutes data includes textual content such as the key points of discussion, decision-making matters, responsible persons, and time nodes.

[0076] The data on the distribution of review comments includes: the textual content of all reviewers' comments;

[0077] The power grid review meeting attendance sheet is a form used to record the attendance of participants. The attendance sheet includes textual data such as the participant's name, organization, position, and attendance time.

[0078] The work summary document data includes textual content such as summarizing the effectiveness and results of the review activities, as well as subsequent action plans;

[0079] The attendance data includes: expert ID / name, affiliated unit, review project name, expected arrival time (start of meeting / review phase), actual arrival time, departure time, number of late arrivals / early departures, on-duty hours (accurate to the minute), leave type and approval status, etc.

[0080] The payroll data includes: expert name, ID number, bank account number, review project name, work cycle, daily working hours, daily wage standard, complexity coefficient, performance bonus, social security / tax withholding amount, total payable amount, and net pay amount, etc.

[0081] The data in the news report document includes: publication time, type, publisher, main content, key data, attachments, and other text content data.

[0082] The input module is used to receive review business document data in the following ways: receiving existing documents or manually inputting them; the specific process is as follows:

[0083] Input methods include file uploads: review data is obtained by receiving uploaded files (such as Excel files, CSV files, etc.). The files contain specific review information, such as year, job category, keywords, etc.

[0084] Manual input: The interface created through VBA programming allows users to manually input various types of data required for review, such as text boxes, drop-down menus, and other manual input operations;

[0085] The other steps and parameters are the same as in one of the specific implementation methods one or two.

[0086] Specific Implementation Method Four: This implementation method differs from Specific Implementation Methods One through Four in that...

[0087] The data processing module is used to organize the received review business document data and store the organized data in the database; the specific process is as follows:

[0088] Step 1: Clean the received review business document data using VBA scripts to obtain cleaned review business document data; the specific process is as follows:

[0089] VBA was used to process the data in the original review business documents, removing null values, duplicate data, and data with incorrect formats.

[0090] Use VBA scripts to uniformly process dates and numbers that do not conform to the format; obtain cleaned review business document data;

[0091] Step 2: Standardize the cleaned review business document data to obtain standardized data; the specific process is as follows:

[0092] Standardize the data from different sources or formats in the cleaned review business documents to ensure that all data conforms to consistent standards.

[0093] For example, unify the unit (e.g., unify "ten thousand yuan" to "yuan" or unify the equipment name (e.g., normalize "main transformer" and "transformer" to "transformer") or unify different time formats to a standard format.

[0094] For example, the design proposals submitted by various departments can be compiled into a report with a unified format.

[0095] Step 3: Store the standardized data in the database;

[0096] The other steps and parameters are the same as those in one of the specific implementation methods one to three.

[0097] Specific Implementation Method Five: The difference between this implementation method and Specific Implementation Methods One to Four is that...

[0098] The review preparation unit is used to retrieve data from the database and generate documents for the review preparation phase; the specific process is as follows:

[0099] The documents for the review preparation phase include: scheme distribution records, notification and arrangement documents, and a summary document of design schemes;

[0100] Use VBA scripts to retrieve plan distribution record data from the database and populate it into a pre-designed plan distribution record template to obtain the plan distribution records.

[0101] Use VBA scripts to retrieve notification and schedule file data from the database, populate it into a pre-designed notification and schedule file template, and obtain the notification and schedule file.

[0102] Use VBA scripts to call design scheme data from the database, populate it into a pre-designed design scheme summary template, and obtain a design scheme summary file.

[0103] The program distribution record is a record file that includes review information, distribution date, participants, etc.

[0104] The review documents include statistical reports, review documents, expert recommendation forms, etc.

[0105] The specific process for generating statistical reports is as follows:

[0106] Step A1: Connect to the review database using a VBA script, obtain the data source using OLEDBConnection, and execute the stored procedure, Annual Statistics_Electricity Review, to dynamically generate the electricity review data for the current year based on the current year.

[0107] Step A2: Add a new worksheet to the existing workbook and name it "Annual Summary". Use a VBA script to automatically add a pivot table for later data visualization.

[0108] Step A3: Configure a pivot table using VBA script, using the "Project Type" field as the row field, the "Quarter" field as the column field, and the "Processing Time" field as the data field, and calculate the average processing time. Display the average processing time for different project types and quarters in the pivot table.

[0109] Step A4: Obtain the annual summary pivot table through the above steps, and generate a complete annual statistical report.

[0110] The specific process for generating review documents is as follows:

[0111] Step B1: Use a VBA script to retrieve the project type (such as "New Substation" or "Line Renovation") from cell B2 of worksheet Sheet1, as the basis for determining subsequent steps.

[0112] Step B2: Based on the obtained project type, the script determines the project type and loads the corresponding review template. For example, if the project type is "New Substation Construction", the template file "New Substation Construction Review Item.xml" is loaded; if the project type is "Line Renovation", the template file "Line Renovation Review Item.xml" is loaded.

[0113] The specific process for generating the expert recommendation form is as follows:

[0114] Create an expert database using VBA scripts and store the experts and their areas of expertise.

[0115] Examples of experts and their areas of expertise include: Expert "Engineer Zhang" specializes in "primary substations," and Expert "Engineer Li" specializes in "line structures." This step provides a list of recommended experts for the project review process, which will be used in subsequent reviews.

[0116] The other steps and parameters are the same as those in one of the specific implementation methods one to four.

[0117] Specific Implementation Method Six: The difference between this implementation method and Specific Implementation Methods One to Five is that...

[0118] The review execution unit is used to call data from the database and generate files for the review execution phase; the specific process is as follows:

[0119] The documents for the review execution phase include: meeting minutes and records of review comments issued;

[0120] Use VBA scripts to retrieve meeting minutes data from the database, populate it into a pre-designed meeting minutes template, and obtain the meeting minutes file.

[0121] Use a VBA script to retrieve review comment distribution record data from the database, populate it into a pre-designed review comment distribution record template, and obtain the review comment distribution record.

[0122] Use a VBA script to call the meeting attendance table data in the database, populate it into a pre-designed meeting attendance table template, and obtain the meeting attendance table.

[0123] In addition, when generating the record of review comments, a dispute detection step is required. The specific process is as follows:

[0124] Use VBA scripts to extract negative words from review comments;

[0125] The negative words include words such as "does not conform" and "does not meet";

[0126] Based on negative words, the dispute index is calculated as: negative word frequency × clause importance coefficient;

[0127] The importance coefficient of the clauses is obtained based on expert scores; the frequency of negative words is the frequency of negative words in the review comments;

[0128] When the dispute index is greater than 0.7, the project review process is automatically triggered; the project review process is the review process in the review business; other steps and parameters are the same as those in one of the specific implementation methods one to five.

[0129] Specific Implementation Method Seven: The difference between this implementation method and Specific Implementation Methods One through Six is ​​that...

[0130] The review summary and feedback unit is used to call data from the database and generate documents for the review summary and feedback phase.

[0131] The specific process is as follows: Documents for the review, summary, and feedback phase include: a work summary document;

[0132] Use a VBA script to retrieve work summary file data from the database, populate it into a pre-designed work summary file template, and obtain the work summary file.

[0133] The work summary documents include: a summary document of the review activities' effectiveness, a cross-year comparative analysis document, and other documents;

[0134] When generating a work summary document summarizing the effectiveness of review activities, it is necessary to generate a review case library. The specific process for generating the review case library is as follows:

[0135] The TF-IDF algorithm is used to extract project feature words, which are then used to generate 3D labels (technical issues / management issues / design flaws).

[0136] Establish a case similarity calculation model:

[0137]

[0138] Calculate the similarity between the cases in the database and the cases in this project, and include the cases with similarity higher than the threshold as cases in the review case library;

[0139] When generating a year-on-year comparative analysis document in a work summary file, a radar chart needs to be generated. The specific process for generating a radar chart is as follows:

[0140] Step C1: Use the ExecuteSQL function in VBA script to query the review data in the database and obtain data from the past three years. The VBA script dynamically calculates the current year minus 1, 2, and 3 to obtain the data for the corresponding year, and then transposes and stores this data into a data matrix array.

[0141] Step C2: Transpose the acquired three years of data to ensure the data is suitable for subsequent chart display. The data for each year is transposed using the Application.WorksheetFunction.Transpose function and stored sequentially in the corresponding positions of the data matrix (1 to 3) array.

[0142] Step C3: Create a new chart object in the "Analysis" worksheet and set it to radar chart type (xlRadarMarkers). Then, loop through the three years of data stored in the data matrix array and add them as series data for the chart to generate a radar chart comparing the years, visually displaying the data change trend.

[0143] The other steps and parameters are the same as those in any of the specific implementation methods one to six.

[0144] Specific Implementation Method Eight: The difference between this implementation method and Specific Implementation Methods One to Seven is that...

[0145] The documents for routine work include: attendance records, payroll records, and news reports;

[0146] Use VBA scripts to call attendance file data from the database and populate it into a pre-designed attendance file template to obtain the attendance file;

[0147] Use a VBA script to retrieve payroll data from the database and populate it into a pre-designed payroll template to obtain the payroll file.

[0148] Use a VBA script to retrieve communication report file data from the database, populate it into a pre-designed communication report file template, and obtain the communication report file.

[0149] The communication reports include daily automated files;

[0150] When you need to generate an automatic daily report file in a newsletter:

[0151] Step D1: Use a VBA script to dynamically obtain the current date using the Format(Date, "yyyy-mm-dd") function and generate the daily report title "Work Overview".

[0152] Next, the function to retrieve the number of pending documents is called, and this information is added to the daily report content. Then, the function to retrieve urgent projects is called to retrieve the number of currently urgent review projects, and this information is added to the daily report content.

[0153] Step D2: Combine the daily report title, number of pending documents, and number of urgent review projects into a single daily report summary, formatted according to a specific format. Share this summary via vbCrLf, ensuring each information point is clearly visible within the report.

[0154] Step D3: By calling the function to send a DingTalk message, the generated daily report content is sent to the DingTalk robot, thus automating the delivery of the daily report. This step ensures that relevant personnel receive the daily work overview report in a timely manner.

[0155] Includes: daily document processing volume statistics, overdue task list (including overdue days), and reminders for the review meeting the following day.

[0156] Intelligent reminder system: Document processing deadline reminder (pop-up window when deadline is less than 3 days), automatic blocking of related schedules (preventing the creation of new review tasks when the daily report is not completed).

[0157] The other steps and parameters are the same as those in any of the specific implementation methods one to seven.

[0158] Specific Implementation Method Nine: This implementation method is a computer storage medium that stores at least one instruction. The at least one instruction is loaded and executed by a processor to implement the aforementioned intelligent management system for power grid review business based on VBA technology.

[0159] It should be understood that the instructions include any computer program product, software, or computerized method corresponding to any method described in this invention; the instructions can be used to program a computer system or other electronic device. The computer storage medium may include a readable medium on which instructions are stored, and may include, but is not limited to, magnetic storage media, optical storage media; magneto-optical storage media include read-only memory (ROM), random access memory (RAM), erasable programmable memory (e.g., EPROM and EEPROM), and flash memory layers, or other types of media suitable for storing electronic instructions. Other steps and parameters are the same as in any one of embodiments one through eight.

[0160] Specific Implementation Method 10: This implementation method is an automatic detection device for damage to power transmission corridors in mountainous areas based on remote sensing image data. The device includes a processor and a memory. It should be understood that this includes any device described in this invention that includes a processor and a memory. The device may also include other units and modules that perform display, interaction, processing, control, and other functions through signals or instructions.

[0161] The memory stores at least one instruction, which is loaded and executed by the processor to implement the aforementioned intelligent management system for power grid review business based on VBA technology.

[0162] Those skilled in the art will understand that at least one stored instruction constitutes a computer program product corresponding to a method or system. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code. The solutions in the embodiments of this application can be implemented using various computer languages, such as the object-oriented programming language Java and the interpreted scripting language JavaScript.

[0163] This application is described with reference to flowchart illustrations and / or block diagrams of methods, systems, and computer program products according to embodiments of this application, and can also be used with corresponding devices. It should be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0164] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0165] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0166] The advantages of this invention over the prior art are:

[0167] First, it significantly improves review efficiency. Through VBA automation technology, the system automates the entire process from data cleaning and standardization to document generation and submission. This completely solves the pain points of scattered documents and time-consuming statistics in traditional manual management.

[0168] Second, strengthen process standardization and data quality. The data processing module ensures the integrity and consistency of data in the database through a unified cleaning (duplicate removal, format correction) and standardization (unified units, time format) process; the file generation module relies on preset templates to fill in files, avoiding the arbitrariness of manual operation, and all files conform to format specifications, achieving full traceability.

[0169] Third, the system of this invention also integrates the functions of automatic generation of attendance and payroll documents, reducing manual calculation costs. The automatic push of daily communication reports (including to-do lists and emergency reminders) enables real-time information synchronization. Intelligent reminders (overdue pop-ups and schedule blocking) prevent task delays, improve overall collaboration efficiency by 60%, and significantly reduce the workload of experts and managers.

[0170] The application of the technical reagents in this invention is reflected in:

[0171] ① It pioneered digital twin technology for the review process, transforming the three stages of pre-review preparation, process control, and post-review tracking into programmable logic;

[0172] ② Develop an expert collaboration engine based on VBA to solve the problem of dynamic management of flexible teams;

[0173] ③ Construct a knowledge graph for power grid review to achieve intelligent association between standard provisions and engineering cases. In actual tests at Jixi Power Supply Company, this reduced review preparation time by 68%, decreased the rate of omitted comments to 1.2%, and shortened the average project review cycle by 40%.

[0174] This system can be directly integrated into existing Office environments and features three main functions: automatically generating industry-standard review checklists, real-time visual display of review progress, and intelligent prediction of common design flaws. It effectively improves the efficiency and quality of review work, addresses the shortage of professional personnel, and optimizes the management process for power grid projects.

[0175] The above description is merely of preferred embodiments of the present invention. It should be understood that the present invention is not limited to the specific embodiments described above. Although the present invention has been disclosed above with reference to preferred embodiments, it is not intended to limit the present invention. Any person skilled in the art can make some modifications or alterations to the above-disclosed technical content to create equivalent embodiments without departing from the scope of the present invention. Any simple modifications, equivalent substitutions, and improvements made to the above embodiments without departing from the scope of the present invention, based on the technical essence of the present invention, and within the spirit and principles of the present invention, shall still fall within the protection scope of the present invention.

Claims

1. A power grid review business intelligent management system based on VBA technology, characterized in that, include: Input module, data processing module, database, file generation module, and notification module; The input module is used to receive review business document data; The data processing module is used to clean and standardize the received review business document data in sequence, and store the standardized data into the database. The output module is used to call data from the database to generate review documents; The notification module is used to send the review documents generated by the output module to the reviewers.

2. The intelligent management system for power grid review business based on VBA technology according to claim 1, characterized in that, The output module includes: a review preparation unit, a review execution unit, a review summary and feedback unit, and a daily work unit; The review documents include: documents for the review preparation phase, documents for the review execution phase, documents for the review summary and feedback phase, and daily work documents; The review preparation unit is used to call data from the database and generate documents for the review preparation phase. The review execution unit is used to call data from the database and generate files for the review execution phase. The review summary and feedback unit is used to call data from the database and generate documents for the review summary and feedback phase. The daily work unit is used to call data from the database and generate files for daily work.

3. The intelligent management system for power grid review business based on VBA technology according to claim 2, characterized in that, The review business document data includes: scheme distribution record data, notification and arrangement document data, design scheme data, meeting minutes data, review opinion distribution record data, work summary document data, attendance document data, salary document data, and communication report document data.

4. The intelligent management system for power grid review business based on VBA technology according to claim 3, characterized in that, The data processing module is used to organize the received review business document data and store the organized data in the database; the specific process is as follows: Step 1: Clean the received review business document data using VBA scripts to obtain the cleaned review business document data. Step 2: Standardize the cleaned review business document data to obtain standardized data; Step 3: Store the standardized data in the database.

5. The intelligent management system for power grid review business based on VBA technology according to claim 4, characterized in that, The review preparation unit is used to call data from the database and generate documents for the review preparation phase. The specific process is as follows: The documents for the review preparation phase include: scheme distribution records, notification and arrangement documents, and a summary document of design schemes; Use VBA scripts to retrieve plan distribution record data from the database and populate it into a pre-designed plan distribution record template to obtain the plan distribution records. Use VBA scripts to retrieve notification and schedule file data from the database, populate it into a pre-designed notification and schedule file template, and obtain the notification and schedule file. Use VBA scripts to call design scheme data from the database, populate it into a pre-designed design scheme summary template, and obtain a design scheme summary file.

6. The intelligent management system for power grid review business based on VBA technology according to claim 5, characterized in that, The review execution unit is used to call data from the database and generate files for the review execution phase. The specific process is as follows: The documents for the review execution phase include: meeting minutes and records of review comments issued; Use VBA scripts to retrieve meeting minutes data from the database, populate it into a pre-designed meeting minutes template, and obtain the meeting minutes file. Use a VBA script to retrieve review comment distribution record data from the database, populate it into a pre-designed review comment distribution record template, and obtain the review comment distribution record.

7. The intelligent management system for power grid review business based on VBA technology according to claim 6, characterized in that, The review summary and feedback unit is used to call data from the database and generate documents for the review summary and feedback phase. The specific process is as follows: Documents for the review, summary, and feedback phase include: a work summary document; Use a VBA script to retrieve work summary file data from the database, populate it into a pre-designed work summary file template, and obtain the work summary file.

8. The intelligent management system for power grid review business based on VBA technology according to claim 7, characterized in that, The documents for routine work include: attendance records, payroll records, and news reports; Use VBA scripts to call attendance file data from the database and populate it into a pre-designed attendance file template to obtain the attendance file; Use a VBA script to retrieve payroll data from the database and populate it into a pre-designed payroll template to obtain the payroll file. Use a VBA script to retrieve communication report file data from the database, populate it into a pre-designed communication report file template, and obtain the communication report file.

9. A computer storage medium, characterized in that, The storage medium stores at least one instruction, which is loaded and executed by a processor to implement a power grid review business intelligent management system based on VBA technology as described in any one of claims 1 to 8.

10. A smart management device for power grid review business based on VBA technology, characterized in that, The device includes a processor and a memory, the memory storing at least one instruction, which is loaded and executed by the processor to implement a power grid review business intelligent management system based on VBA technology as described in any one of claims 1 to 8.

Images