Ship section precision management system and management method based on Excel VBA

Abstract

The present application relates to the field of ship section precision management, and in particular to a ship section precision management system and method based on Excel VBA. The precision management system comprises: a local storage module for locally storing, retaining and calling relevant data; an event capture module for capturing user operations in the main table worksheet; a hyperlink association module for generating hyperlinks in the main table worksheet that bind corresponding precision files; an automatic scoring module for automatically scoring construction teams in the main table worksheet; and a statistics module for updating special statistics tables based on the main table worksheet. The ship section precision management system based on Excel VBA constructs a full-process management and control platform according to the ideas of data association, automatic processing, scientific evaluation and safe storage, and can realize one-key data retrieval, automatic scoring and traceability, and full-dimension statistical analysis, thereby improving data statistical efficiency and providing complete data support for quality control and performance evaluation.

Description

Technical Field

[0001] This invention relates to the field of ship section accuracy management, and specifically to a ship section accuracy management system and management method based on ExcelVBA. Background Technology

[0002] The level of precision management of ship sections directly determines the construction quality, production efficiency, and cost, and is a key indicator for measuring the core competitiveness of shipyards.

[0003] Currently, small and medium-sized shipbuilding enterprises generally rely on manual labor in the section accuracy management process, including manual recording, manual scoring, and manual statistics. This results in problems such as scattered data, highly subjective scoring results, and insufficient data accumulation.

[0004] Therefore, a new technical solution is needed in this field to solve the above problems. Summary of the Invention

[0005] To improve or solve the technical problems of existing segment accuracy management, which relies heavily on manual labor and suffers from data dispersion and inconsistent scoring standards, this invention provides a ship segment accuracy management system based on Excel VBA. The ship segment accuracy management system uses Excel as its base and is implemented using VBA programming language. The accuracy management system includes: a local storage module for locally storing, retaining, and retrieving relevant data, including a main worksheet, specialized statistical tables, and accuracy files; an event capture module for capturing user operations in the main worksheet; a hyperlink module for generating hyperlinks in the main worksheet that bind to the corresponding accuracy files in response to the user's first operation in the main worksheet; an automatic scoring module for automatically scoring construction teams in the main worksheet in response to the user's second operation in the main worksheet; and a statistics module for updating the specialized statistical tables based on the main worksheet.

[0006] In the Excel VBA-based ship section precision management system of this invention, a local centralized storage mode is adopted. This avoids the data security risks and additional service costs associated with cloud uploads and solves the data loss problem caused by distributed storage, ensuring the security of precision data storage. The hyperlink module generates hyperlinks to corresponding precision files in the main worksheet, enabling one-click retrieval and quick access to various precision data. It supports rapid querying of historical data and cross-scenario reuse, solving the problems of tedious and time-consuming manual statistics and searches. The automatic scoring module automatically scores construction teams based on user operations in the main worksheet, such as question input, achieving an objective, unified, and quantifiable scoring process, providing complete data support for quality control and performance evaluation. The statistics module updates specialized statistical tables based on the main worksheet, enabling the collection of various core management indicators and forming a long-term, systematic data accumulation, providing data support for process improvement, production plan adjustments, and management of outsourcing teams. Through the above settings, the ExcelVBA-based ship section precision management system of this invention constructs a full-process control platform based on the principles of data association, automatic processing, scientific evaluation, and secure storage. It can realize one-click data retrieval, automatic scoring and traceability, and full-dimensional statistical analysis, improve data statistical efficiency, ensure data authenticity, provide complete data support for quality control and performance evaluation, and save software and labor costs. It provides a low-cost and replicable digital transformation solution for precision management for small and medium-sized ship enterprises.

[0007] Furthermore, the local storage module includes a main folder and a "launched" folder, where the precision files are stored. The hyperlink association module includes: a first response unit, used to respond to user modifications of the ship number, section number, or project number by obtaining the modified ship number, section number, and project number; a hyperlink generation unit, used to obtain the basic path based on the modified ship number, section number, and project number, and concatenate the main folder path and the launched folder path to generate the corresponding hyperlink path; a matching unit, used to traverse the main folder and the launched folder, and match the precision files corresponding to the hyperlink paths using regular expressions; and an automatic binding unit, used to bind the hyperlink paths to the matched precision files. Through the above settings, the local storage module stores precision files, and combined with the first response unit, hyperlink generation unit, matching unit, and automatic binding unit of the hyperlink association module, it can achieve intelligent and automated generation of precision file hyperlinks, solving the problems of time-consuming and error-prone manual searching and locating, and significantly improving the efficiency and accuracy of data retrieval.

[0008] Furthermore, the hyperlink association module also includes a manual binding unit, which binds the hyperlink path to a precision file manually selected by the user. The precision management system also includes a data verification and format standardization module, which performs real-time verification, format standardization, and anomaly alerts on the entered data. Through these settings, the manual binding unit provides a flexible manual supplementation mechanism for scenarios where automatic matching fails, ensuring that users obtain valid hyperlinks regardless of whether automatic matching succeeds or fails. The data verification and format standardization module performs real-time verification, format standardization, and anomaly alerts on the entered data, ensuring the standardization, accuracy, and completeness of the data from the source, and avoiding management deviations caused by input errors.

[0009] Furthermore, the automatic scoring module includes: a second response unit, used to pop up a "three-level menu scoring" window in the main worksheet in response to the user double-clicking the selection result column of the main worksheet; a self-check unit, used to indicate that the self-check has passed in the inspection result column of the main worksheet when the user selects self-check in the "three-level menu scoring" window; a problem addition unit, used to concatenate all problem items in the selection result column of the main worksheet in response to the user adding or modifying problems in the "three-level menu scoring" window; an automatic scoring unit, which calculates the score in the score column of the main worksheet according to the preset deduction rules and all problem items in the selection result column; and a judgment unit, which displays "pass" or "fail" in the inspection result column of the main worksheet according to the score in the score column and the preset threshold. Through the above settings, users can complete problem recording through simple operations such as double-clicking and checking. The system automatically calculates the score and determines whether the problem passes or fails based on the preset deduction rules and the problem, achieving objectivity, uniformity, and quantification in the scoring process, avoiding the subjective arbitrariness and tedious calculations of manual scoring, and providing efficient and accurate decision-making basis for quality control.

[0010] Furthermore, the automatic scoring module also includes a modification identification unit. When the inspection result column of the main worksheet displays "fail," the modification identification unit indicates "unmodified" in the modification status column of the main worksheet. After the user corrects the problem, it indicates "modified" in the modification status column and "passed twice" in the inspection result column. Through these settings, the entire process of discovering, rectifying, and reviewing quality issues is fully recorded, distinguishing between first-time and second-time passes. This objectively reflects the actual quality level of the construction team and encourages the team to proactively rectify problems.

[0011] Furthermore, it also includes an analysis module and an automatic save and export module. The analysis module is used to generate visual statistical charts and ranking lists based on the specific statistical tables; the automatic save and export module is used to synchronize the real-time collected high-precision data to a dedicated folder for the corresponding ship number. Through the above settings, the analysis module can automatically generate visual statistical charts and ranking lists based on the specific statistical tables, providing managers with clear performance comparisons and trend insights, supporting decisions such as process improvement and plan adjustments.

[0012] To improve or solve the technical problems of existing segment accuracy management, which relies heavily on manual labor and suffers from scattered data and inconsistent scoring standards, this invention provides a ship segment accuracy management method based on Excel VBA. The ship segment accuracy management method uses any of the aforementioned Excel VBA-based ship segment accuracy management systems. The accuracy management method includes: capturing user operations in the main worksheet; responding to a first user operation in the main worksheet, generating a hyperlink in the main worksheet that binds to the corresponding accuracy file; responding to a second user operation in the main worksheet, automatically scoring the construction teams in the main worksheet; and updating the specialized statistical table based on the main worksheet. Through the above settings, this method can achieve one-click retrieval of accuracy data, automatic quantification of team scores, and dynamic statistics of core indicators, fundamentally solving the common problems in ship segment management such as difficulty in data retrieval, subjective and inefficient scoring, and cumbersome and delayed statistics.

[0013] Furthermore, the step of generating a hyperlink bound to the corresponding precision file in the main worksheet in response to the user's first operation in the main worksheet includes: in response to the user modifying the ship number, section number, or project number, obtaining the modified ship number, section number, and project number; obtaining the basic path based on the modified ship number, section number, and project number, and concatenating the main folder path and the launched folder path to generate the corresponding hyperlink path; traversing the main folder and the launched folder, and matching the precision file corresponding to the hyperlink path using regular expressions; when a corresponding precision file is matched, binding the hyperlink path to the matched precision file; when no corresponding precision file is matched, binding the hyperlink path to the precision file manually selected by the user. Through the above settings, by responding to modifications of key information such as ship number, section number, and project number, multiple folder paths are automatically concatenated and intelligently matched; simultaneously, automatic efficiency and manual flexibility are perfectly combined, ensuring that the user can obtain a valid hyperlink regardless of whether the automatic matching is successful or not.

[0014] Furthermore, the step of automatically scoring the construction team in the main worksheet in response to the user's second operation in the main worksheet includes: in response to the user double-clicking the selection result column of the main worksheet, a "three-level menu scoring" form pops up in the main worksheet; in response to the user selecting self-check in the "three-level menu scoring" form, the self-check is marked as passed in the inspection result column of the main worksheet; in response to the user adding or modifying questions in the "three-level menu scoring" form, all question items are concatenated in the selection result column of the main worksheet; the score is calculated in the score column of the main worksheet according to the preset deduction rules and all question items in the selection result column; based on the score in the score column and the preset threshold, the pass or fail is displayed in the inspection result column of the main worksheet; when the inspection result column of the main worksheet shows fail, the modification status column of the main worksheet indicates no modification, and after the user corrects the question, the modification status column indicates modification, and the inspection result column indicates "passed twice". Through the above settings, a series of logics are integrated, including automatic identification, problem splicing, automatic scoring, threshold judgment, modification status tracking, and second pass identification. This not only realizes the full automation and quantification of the scoring process, but also establishes a complete quality closed-loop management process from problem discovery, unmodified identification, rectification, modified identification, and second pass. This objectively reflects the actual quality level of the construction team and promotes the team's initiative in rectification.

[0015] Furthermore, after updating the specific statistical table based on the main worksheet, the process further includes: synchronizing the real-time collected precision data to the corresponding ship number's dedicated folder when closing the main worksheet; and generating visual statistical charts and ranking lists based on the specific statistical tables. Through these settings, the generated visual charts and ranking lists present management indicators in an intuitive and easy-to-understand manner, providing managers with powerful data analysis and visualization tools, and effectively supporting long-term data accumulation, process improvement, and production decisions.

[0016] In summary, compared with the prior art, the present invention has the following beneficial effects: (1) It avoids the data security risks and additional service costs brought about by cloud uploading, and can solve the data loss problem caused by decentralized storage, thus ensuring the storage security of accurate data; (2) The built-in standardized scoring logic realizes the objective and unified accuracy scoring, provides a scientific and accurate numerical basis for the accuracy ranking of construction teams, improves the fairness and impartiality of performance evaluation, and thus stimulates the enthusiasm and initiative of construction teams. (3) It can accumulate and analyze precision data, identify high-frequency precision problems, and facilitate process personnel to optimize, reduce the overall precision problem rate, and improve the quality of segment construction; as the amount of data continues to accumulate, it can gradually form a knowledge base for ship segment precision management that is exclusive to the enterprise, provide data support for process improvement and process optimization in the workshop, further reduce the incidence of various precision problems, and improve the quality of segment construction; at the same time, while ensuring construction quality, it can steadily increase the output of segments, gradually approach the balance point of quality and quantity, and realize the transformation from experience-driven to data-driven management mode. Attached Figure Description

[0017] The preferred embodiments of the present invention are described below with reference to the accompanying drawings, in which: Figure 1 This is a schematic diagram of an embodiment of the ship section accuracy management system based on ExcelVBA of the present invention; Figure 2 This is a data flow diagram of an embodiment of the ship section accuracy management system based on ExcelVBA of the present invention; Figure 3 This is a schematic diagram of the main worksheet in the ship section accuracy management system based on Excel VBA of this invention; Figure 4 This is a schematic diagram of manually adding hyperlinks in the ship section accuracy management system based on Excel VBA of this invention; Figure 5 This is a schematic diagram of the "three-level menu scoring" form in the ship section accuracy management system based on ExcelVBA of this invention; Figure 6 This is a schematic diagram of the deduction rules in the ship section accuracy management system based on ExcelVBA of this invention; Figure 7 This is a schematic diagram of the problem deviation value statistics table in the ship section accuracy management system based on Excel VBA of this invention; Figure 8 This is a schematic diagram of the ranking list in the ship section accuracy management system based on ExcelVBA of this invention; Figure 9 This is a schematic diagram illustrating the problem occurrence rate in the ship section accuracy management system based on ExcelVBA of this invention; Figure 10 This is a schematic diagram of the ship number file in the ship section accuracy management system based on ExcelVBA of this invention; Figure 11 This is a schematic diagram of automatic saving and exporting in the ship section precision management system based on ExcelVBA of this invention; Figure 12This is a simplified schematic diagram of the ship section accuracy management method based on Excel VBA of the present invention; Figure 13 This is a schematic diagram of the automatic scoring in the ship section accuracy management method based on ExcelVBA of the present invention; Figure 14 This is a schematic diagram of hyperlink generation in the ship section accuracy management method based on ExcelVBA of this invention.

[0018] List of reference numerals in the attached diagram: 1. Local storage module; 2. Event capture module; 3. Hyperlink association module; 4. Automatic scoring module; 5. Statistics module; 6. Analysis module; 7. Automatic save and export module; 8. Data validation and format standardization module. Detailed Implementation

[0019] Preferred embodiments of the present invention will now be described with reference to the accompanying drawings. Those skilled in the art should understand that these embodiments are merely illustrative of the technical principles of the present invention and are not intended to limit the scope of protection of the present invention.

[0020] It should be noted that in the description of this invention, terms such as "upper," "lower," "left," "right," "inner," and "outer," indicating directional or positional relationships, are based on the directional or positional relationships shown in the accompanying drawings. These are merely for ease of description and do not indicate or imply that the device or element must have a specific orientation, or be constructed and operated in a specific orientation; therefore, they should not be construed as limitations on this invention. Furthermore, the terms "first" and "second" are used for descriptive purposes only and should not be construed as indicating or implying relative importance.

[0021] Furthermore, it should be noted that, in the description of this invention, unless otherwise explicitly specified and limited, the terms "installation," "setting," and "connection" should be interpreted broadly. For example, they can refer to a fixed connection, a detachable connection, or an integral connection; they can refer to a direct connection, an indirect connection through an intermediate medium, or a connection within two components. Those skilled in the art can understand the specific meaning of the above terms in this invention according to the specific circumstances.

[0022] The level of precision management for ship sections directly determines construction quality, production efficiency, and cost, and is a key indicator for measuring a shipyard's core competitiveness. Currently, small and medium-sized shipbuilding enterprises in China generally face the following four prominent problems in their section precision management: 1. Inefficient data management and prominent data silos. Core documents such as accuracy reports, daily inspection records, self-inspection forms, and correction feedback drawings are scattered across multiple platforms and folders, making cross-scenario retrieval difficult and requiring frequent manual statistics and searches. In a specific production activity, collecting and organizing data related to segmented accuracy over 11 days took 4 days. The collected data could not be effectively consolidated, and new statistical needs required data searches to be conducted again, resulting in significant additional time consumption and a substantial reduction in the efficiency of accuracy management.

[0023] 2. There is no unified standard for accuracy reports, and the scoring results are highly subjective. The current system for scoring ship section accuracy lacks a unified, quantitative standard that aligns with actual production practices. Different inspectors apply inconsistent criteria to the same type of accuracy problem, leading to chaotic recording methods and inconsistent classification standards. Data on similar problems cannot be combined for statistical analysis due to differing descriptions, hindering comparative analysis and failing to provide a basis for subsequent process improvements. The lack of unified scoring criteria for accuracy problems of varying degrees of deviation results in a lack of objective data for ranking construction teams, making fair and impartial performance evaluations difficult. First-pass yield is a core indicator of shipbuilding quality, directly reflecting production progress and quality control. The problem stems from the current lack of unified problem classification standards and scoring criteria, leading to biased first-pass yield statistics that fail to objectively reflect the actual quality level of each construction team.

[0024] 3. Insufficient data accumulation and lack of decision-making basis. The company has not established a long-term system for accumulating and analyzing precision data. Core management indicators in the segmented manufacturing process lack accumulation, such as the frequency of precision issues, the distribution of various deviation values, and the first-pass yield of construction teams. These indicators lack fixed and efficient statistical channels. Decisions regarding process improvement, production plan adjustments, and human resource optimization lack accurate and comprehensive data support, information flow is incomplete, and statistical results are disconnected from actual production applications.

[0025] 4. Significant security risks and high costs associated with digital transformation. The decentralized storage of precision data is prone to data loss or damage due to storage media failures or human error. Meanwhile, the cost of purchasing professional ship precision management software on the market remains high. Customized mini-program development not only requires large upfront investment but also poses security risks for cloud data storage. Furthermore, the costs of subsequent system maintenance and upgrades continue to increase, making it a major obstacle for small and medium-sized shipbuilding enterprises to promote digital transformation.

[0026] To improve or solve the technical problems of existing segment accuracy management, which relies heavily on manual labor and suffers from data dispersion and inconsistent scoring standards, this invention provides a ship segment accuracy management system based on Excel VBA. This system uses Excel as its foundation and is implemented using VBA programming language. The accuracy management system includes: a local storage module for storing, retaining, and retrieving relevant data locally, including a main worksheet, specialized statistical tables, and accuracy files; an event capture module for capturing user operations in the main worksheet; a hyperlink module for generating hyperlinks to the corresponding accuracy files in the main worksheet in response to the user's first operation; an automatic scoring module for automatically scoring construction teams in the main worksheet in response to the user's second operation; and a statistics module for updating specialized statistical tables based on the main worksheet.

[0027] Figure 1 This is a schematic diagram of an embodiment of the ship section accuracy management system based on ExcelVBA of the present invention. Figure 2 This is a data flow diagram illustrating an embodiment of the ship section accuracy management system based on Excel VBA of the present invention. Figure 1 and Figure 2 As shown, in one or more embodiments, the ship section accuracy management system based on ExcelVBA of the present invention includes a local storage module, an event capture module, a hyperlink association module, an automatic scoring module, and a statistics module.

[0028] See also Figure 1 and Figure 2 In one or more embodiments, the local storage module is used to store, retain, and retrieve relevant data, including a main worksheet, specialized statistical tables, and accuracy files. Each project number corresponds to a project folder, and each project folder includes a main folder and a launched folder. Each vessel has its own dedicated folder, which is placed within either the main folder or the launched folder depending on whether it has been launched. Accuracy files are stored in these dedicated folders. Specifically, the main folder stores accuracy files for unfinished launched sections, while the launched folder stores accuracy files for completed launched sections, distinguishing between project progress and construction status. Accuracy files include accuracy reports, daily inspection records, self-inspection forms, and corrected drawings. The main worksheet is used to associate different types and levels of accuracy files, enabling one-click retrieval and quick access to various accuracy files. The specialized statistical tables are used to compile core management indicators, including the frequency of accuracy issues, the distribution of various deviation values, the first-pass yield rate, average score, and number of full marks for each section and construction team.

[0029] Figure 3This is a schematic diagram of the main worksheet in the ship section accuracy management system based on Excel VBA of this invention. (See diagram below.) Figure 3 As shown, in one or more embodiments, the main worksheet has a first area and a second area. The first area identifies basic information, and the second area identifies process information. Specifically, the basic information includes: date, ship number, specialty, inspection items, inspection procedures, planned time, factory location, construction unit, inspection supervisor, inspector, and inspection results. The inspection results column indicates incomplete, self-inspection passed, passed, second pass, and failed. The process information includes selection results, score, modification status, corrected return drawing, self-inspection form status, self-inspection form, project number, and accuracy report. The selection results column indicates self-inspection, full score, and problem summary; the score column indicates self-inspection and score; the modification status indicates empty, modified, and not modified; the self-inspection form status indicates empty and submitted; and the accuracy report file displays a hyperlink or no link. Furthermore, the event capture module is used to capture user operations in the main worksheet. Specifically, when a user enters or modifies data in the main worksheet, the operation is captured through the Worksheet_Change and Worksheet_BeforeDoubleClick events. Worksheet_Change is used to respond to data changes, and Worksheet_BeforeDoubleClick is used to capture double-click actions.

[0030] Figure 4 This is a schematic diagram illustrating the manual addition of hyperlinks in the ship section accuracy management system based on Excel VBA of this invention. For example... Figures 1 to 4 As shown, in one or more embodiments, the hyperlink association module is used to generate hyperlinks bound to the corresponding precision files in the main table worksheet in response to a user's first operation. The first operation refers to modifying the ship number, section number, or project number. Specifically, the hyperlink association module includes a first response unit, a hyperlink generation unit, a matching unit, and an automatic binding unit. The first response unit is used to obtain the modified ship number, section number, and project number in response to the user's modification of the ship number, section number, or project number. Exemplarily, the determined order of the three is project number, ship number, section number. Alternatively, other suitable orders, such as ship number, section number, and project number, can be used according to usage needs.

[0031] See also Figures 1 to 4The hyperlink generation unit is used to obtain the basic path based on the modified ship number, section number, and project number, and then concatenate the main folder path and the launched folder path to generate the corresponding hyperlink path. Specifically, the basic path is automatically obtained based on the project number. When searching by ship number, it is determined whether the ship has been launched. Then, the path of the precision file in the main folder or the launched folder is obtained based on the section number. These paths are concatenated step by step. Furthermore, a matching table between the project number and the basic path is established, and the corresponding basic path is searched in the matching table based on the project number. For example, the hyperlink path is: \\192.168.2.102\12Quality Management Department Encrypted\Precision Management\New Energy Container Ship Precision Welding Report (73M)\Launched\800135-73m LNG Section Welding Post-Report\73M(0135)1C1 Welding Post-Report 3.15pdf.pdf; where \\192.168.2.102\12Quality Management Department Encrypted\Precision Management\New Energy Container Ship Precision Welding Report (73M) is the base path, determined according to the project number; "Launched\800135-73m LNG Section Welding Post-Report" is determined according to the ship number; and 73M(0135)1C1 Welding Post-Report 3.15pdf is the path to the precision file of the section number we are looking for, determined according to the section number. After the path is concatenated, only the file with the PDF extension is bound.

[0032] See also Figures 1 to 4 The matching unit is used to traverse the main folder and the "launched" folder, using regular expressions to match the files corresponding to the hyperlink paths. Specifically, the matching unit's search order is as follows: first, it matches the project folder by project number; then, it traverses and searches the main folder in ascending order by ship number. If the main folder does not contain the file (for some ships, the inspection process has been completed, and the file will be placed in the "launched" folder), it traverses and searches the "launched" folder; finally, it matches by segment number. Segment numbers include at least three categories: ordinary segment numbers, segment numbers with additional identifiers on basic segment numbers, and sub-segment numbers identified by prefix letters. Ordinary segment numbers are independent, complete segment identifiers, such as 1C1 and 1A1. Segment numbers with additional identifiers on basic segment numbers have an identifier appended after the basic segment number, such as 1B1 and 1B1 base, where 1B1 is the basic segment number and 1B1 base is the segment number with additional identifiers on the basic segment number. Sub-segment numbers identified by prefix letters are S-type segment numbers, with the format S + number + S\P, such as S1S. The matching unit obtains the segment number, determines its type based on the string characteristics of the segment number, and executes the corresponding matching strategy.

[0033] When the segment number is a regular segment number or a basic classification number, a regular expression with word boundary constraints is constructed to match the segment number as an independent semantic unit, preventing it from being misidentified as part of other segment number strings, thus matching the corresponding precision file. Its general regular expression pattern is: ^.*\d{4}.*\bX\b.*\.pdf$. Where: \d{4} matches a four-digit ship number; X represents a placeholder for the segment number string, which is replaced with the actual segment number during execution; \b is a word boundary metacharacter used to limit the segment number to word boundaries to prevent mismatches (e.g., preventing "1B1" from matching "1B1 base"). When the segment number is a base segment number with an additional identifier, a regular expression without word boundary constraints is constructed to match the complete string "1B1 base", thereby correctly identifying precision files containing the additional identifier. Its general regular expression pattern is: ^.*\d{4}.*X additional identifier.*\.pdf$. Where: \d{4} matches a four-digit ship number; X additional identifier represents a placeholder string for the segment number and its additional identifier, which is replaced with the complete segment number (e.g., "1B1 base") during actual execution; this pattern does not use \b word boundaries to ensure that it can match complete filenames containing the additional identifier.

[0034] When the segment number is a sub-segment number identified by a prefix letter, the core number or identifier in the segment number is extracted, and a first suffix (e.g., "S") and a second suffix (e.g., "P") are generated respectively. The corresponding suffix is ​​then matched for precision files in the same or different folder paths. The general regular expression pattern is: ^.*\d{4}.*\bN[SP]\b.*\.pdf$. Where: \d{4} matches a four-digit ship number; N represents the core number placeholder extracted from the segment number; [SP] represents the character set, which is replaced with "S" and "P" twice during the actual matching; \b is a word boundary, ensuring that the suffix character is matched as an independent unit.

[0035] See also Figures 1 to 4 The automatic binding unit is used to bind the hyperlink path to the matched precision file. Furthermore, it includes a segmentation judgment unit to determine whether the segment number is of type S. When the segment number is of type S, the core segment number is extracted and matched with either an "S" or "P" suffix, where "S" indicates starboard and "P" indicates port. When the segment number is not of type S, the complete segment number is matched. Furthermore, it includes a manual binding unit, which binds the hyperlink path to a precision file manually selected by the user.

[0036] When a user modifies the ship number, segment number, or project number, the system first retrieves the ship number, segment number, or project number for the current row. Then, it uses GetProjectBasePath (the base path retrieval module) to obtain the base path and concatenates it with the main folder path (format: base path + "800" + 4-digit ship number + fixed suffix) and the path of the launched folder (format: base path + "launched\" + ship number folder). Next, it checks if the segment number is of type S. If it is, it extracts the core segment number and matches it with either "S" or "P" suffixes. If the segment number is not of type S, it matches the complete segment number. Then, it calls FindTargetPDF (the folder traversal and regular expression matching module) to traverse the main folder and the launched folder, using regular expressions (VBScript.RegExp) to match the PDF precision filename. If a matching PDF precision file is found, it calls AddHyperlinkToCell (the hyperlink binding module) to bind the hyperlink to the precision report file column. The PDF automatically opens when the user clicks on it. If not found, the accuracy report file column displays "No Link" (constant NO_LINK_TEXT). In this case, the user can double-click the accuracy report file column. The Worksheet_BeforeDoubleClick event calls the ManualAddHyperlink.ManualAddHyperlink procedure, which pops up a file selection dialog box (FileDialog). After the user manually selects the PDF accuracy file, the binding is completed using AddHyperlinkToCell (manually adding a hyperlink).

[0037] Furthermore, it includes a data validation and format standardization module to achieve real-time validation of entered data, format standardization, and anomaly alerts. Specifically, the data validation and format standardization module includes a filtering unit, a mandatory field validation unit, and a data conflict determination unit. The filtering unit filters newly added or modified precision records in the main worksheet in real time, automatically extracting key information such as segment numbers, construction teams, and inspection results; the mandatory field validation and data conflict determination unit limits the entry format, unifying the data format across the entire platform through a standardized entry process, reducing human error at the source. Furthermore, the data validation and format standardization module also includes a date background color cycle unit, a name standardization unit, and a color matching unit. The date background color cycle unit automatically cycles through a different background color every seven days for easy and quick location of time nodes. The name standardization unit uses a dropdown selection method for inspectors, standardizing the inspector format. The color matching unit matches the corresponding color for different options. For example, in the inspection result column, "Self-inspection passed", "passed" and "passed twice" are matched in green, and "failed" is matched in red; in the score column, "self-inspection" is matched in blue, "100" is matched in green, a score of 80 or above is matched in yellow, and a score below 80 is matched in orange; in the modification status column, "modified" is matched in green, and "not modified" is matched in red.

[0038] Figure 5 This is a schematic diagram of the "three-level menu scoring" form in the ship section accuracy management system based on ExcelVBA of this invention. Figure 6 This is a schematic diagram of the deduction rules in the ship section accuracy management system based on Excel VBA of this invention. For example... Figure 5 and Figure 6 As shown, the three-level menu scoring form includes a first-level category, a second-level category, a third-level item, "Add", "Selected Items", "Remove", "Clear", "OK", "Cancel", and "Self-Check". The first-level category is the segment number, such as segment 1C2, segment S, segment B, etc.; the second-level category is the problem type, with each segment number corresponding to a different problem type, such as bulkhead misalignment, short length, and poor leveling in segment 1C2; the third-level item is the degree of deviation, such as bulkhead misalignment ≥5mm, ≥10mm, etc., indicating the degree of deviation through specific data. The first three columns of the three-level menu scoring form correspond to the first three columns of the deduction details. Clicking "Add" adds the selected problem to the selected items; clicking "Remove" removes the problem from the selected items; clicking "Clear" clears all problems in the selected items; clicking "OK" marks the problems in the selected items in the selection results column; clicking "Cancel" closes the "Three-Level Menu Scoring" form; clicking "Self-Check" marks the self-check passed in the inspection results column of the main worksheet, the self-check in the selection results column, and the self-check in the score column.

[0039] See also Figure 5 and Figure 6In one or more embodiments, the automatic scoring module is used to automatically score the construction team in the main worksheet in response to a second operation by the user in the main worksheet. Specifically, the automatic scoring module includes a second response unit, a self-checking unit, a problem adding unit, an automatic scoring unit, and a judgment unit. The second response unit is used to pop up a "three-level menu scoring" window in the main worksheet in response to the user double-clicking the selection result column of the main worksheet; the self-checking unit is used to mark the self-check as passed in the inspection result column of the main worksheet when the user selects self-check in the "three-level menu scoring" window; the problem adding unit is used to concatenate all problem items in the selection result column of the main worksheet in response to the user adding or modifying problems in the "three-level menu scoring" window, i.e., displaying all problem items in the selection result column; the automatic scoring unit, based on preset deduction rules and the selection result column... All issues are scored in the score column of the main worksheet. For example, if you select "Contour accuracy ≥10mm" and "Outer panel short ruler ≥5mm" in section B, 10 points are deducted for contour accuracy ≥10mm and 5 points for outer panel short ruler ≥5mm. Subtracting 10 points from the full score of 100 and then subtracting 5 points, the score is 85 points, which is recorded in the score column of the main worksheet. The deduction details also show the last selection time of the item and the total number of selections for the month. The judgment unit displays "Pass" or "Fail" in the inspection result column of the main worksheet based on the score in the score column and the preset threshold. Furthermore, it includes a modification identification unit. When the inspection result column of the main worksheet shows "Fail," it indicates "Not Modified" in the modification status column of the main worksheet. After the user corrects the issue, it indicates "Modified" in the modification status column and "Passed Again" in the inspection result column. Specifically, user correction refers to the user modifying the inspection result column of the main worksheet and uploading the corrected return image. When a user double-clicks the "Corrected Return Image" column, they are automatically redirected to the "Add Image" window, which opens automatically in the "Corrected Return Image" column. The added image is automatically saved as a cell within the document and stored locally. Deleting the original file does not affect the viewing of the added image. Simultaneously, the "Status" column is automatically updated to "Modified," and the "Second Pass" message is displayed in the "Inspection Result" column. The deduction values ​​are determined based on the degree of deviation in the Level 3 items; the greater the deviation in the Level 3 items, the higher the deduction. Figure 6Taking the deduction rules for Section B as an example, Section B, a primary category, includes eight issues in the secondary category: flatness, bilge misalignment, short outer panel dimensions, structural point misalignment, central arching, poor leveling, poor verticality, and poor bilge leveling. Each issue has four deviation levels in the tertiary category: ≥5mm, ≥10mm, ≥15mm, and ≥20mm. For the flatness issue, a deviation ≥5mm results in a deduction of 5 points; ≥10mm, 10 points; ≥15mm, 15 points; and ≥20mm, 40 points. The deduction rules for other issues are similar: for the short outer panel dimensions issue, a deviation ≥5mm results in a deduction of 5 points; ≥10mm, 10 points; ≥15mm, 15 points; and ≥20mm, 40 points.

[0040] Specifically, when a user double-clicks to select a result column, the Worksheet_BeforeDoubleClick event retrieves the current row number and displays the "Level 3 Menu Scoring" form; when adding a question, the user selects a category using lstLevel1_Click and lstLevel2_Click, and clicks cmdAdd_Click to add the question to the right-hand list; if the first-level categories are inconsistent, the system will display a prompt; the user can select a list item from the selected items and click cmdRemove_Click to remove the item, or click cmdClearList_Click to clear all items; the user can directly click the "Self-Check" button (cmdSelfCheck_Click), and the system will set the check result column to self-check passed, the selected result to self-check, and the score to self-check; if the user does not select any questions and clicks OK directly (cmdOK_Click and the list is empty), the system will set the check result to pass, the selected result to full score, and the score to 100. If you select a question and click "OK," the system will concatenate all question items into the selection results and call `modOperations.CalculateScoreUnified` (the automatic calculation module) to calculate the total score and write it as the score. If the total score is below 60, the system will automatically set the test result to "Fail" and change the status indicator to "Unmodified." If the total score is 60 or higher, the system will automatically set the test result to "Pass." When the user uploads a corrected screenshot in the main worksheet, the status indicator will automatically change to "Modified," and the test result indicator will automatically change to "Passed on Second Attempt."

[0041] Figure 7 This is a schematic diagram of the problem deviation value statistics table in the ship section accuracy management system based on Excel VBA of this invention. Figure 8 This is a schematic diagram of the ranking list in the ship section accuracy management system based on Excel VBA of this invention. Figure 9This is a schematic diagram illustrating the problem occurrence rate in the ship section accuracy management system based on ExcelVBA of this invention. Figure 10 This is a schematic diagram of the ship number file in the ship section accuracy management system based on ExcelVBA of this invention. Figure 11 This is a schematic diagram illustrating the automatic saving and exporting process in the ship section precision management system based on Excel VBA of this invention. For example... Figures 7 to 11 As shown, in one or more embodiments, the statistics module is used to update the special worksheet based on the main worksheet. The special statistics table includes columns such as segment, core issue, total number of times, details, number of times, and company, etc. Figure 9 Taking the deviation value statistics of segment B as an example, the specialized statistical table can automatically calculate the frequency of accuracy problems and the distribution of various deviation values, as well as core management indicators such as the first-pass rate, average score, and number of full marks for each segment / construction team. Furthermore, it includes an analysis module to generate visual statistical charts and ranking lists based on the specialized statistical table, thereby building a long-term, systematic data accumulation system. This supports year-on-year and month-on-month analysis of manufacturing for each construction team and type of segment, providing a visual data foundation for enterprises to explore the "quality and quantity balance point," and providing data support for process improvement, production plan adjustment, and management of outsourcing teams. Specifically, the statistical charts include a self-inspection quantity table, a full-mark quantity table, an average score ranking table, a first-pass rate ranking table, and a detailed deviation data statistical table for each segment (including the detailed occurrence frequency of the problem and the company's occurrence frequency), and can generate pivot charts for different needs.

[0042] See also Figures 7 to 11The system also includes an automatic save and export module, comprising an automatic save unit, a synchronization unit, an error logging and retry unit, a reading ranking export unit, and an automatic refresh unit. The automatic save unit synchronizes real-time collected accuracy data to a dedicated folder corresponding to the ship number. The synchronization unit automatically creates a standardized template file when no corresponding file exists, synchronizing all real-time data including ship construction progress, accuracy inspection results, and scores. When the user closes the main workbook, the Workbook_BeforeClose event is automatically triggered. The system intercepts the close operation, performs data synchronization first, and then actually closes the file. The system uses the FilterTargetRows module to traverse all rows of the main workbook, filtering for newly added or modified records based on the creation date and last modification time, storing them in the dictionary targetRows. For each record, the ImportRowData module extracts the corresponding external contractor name from the dedicated folder based on the ship number (GetCompanyNameFromShareFolder) and generates a ship number filename according to the following rules: XNJC + 4-digit ship number + 73-meter LNG ship accuracy control inspection record table - + company name + .xlsm. If the target file does not exist, the template file will be copied and created automatically; open the ship number file and find the corresponding line by segment number; if the segment number is of type S (such as S1S), write two lines: S + number + S and S + number + P respectively; otherwise, write a single line. If the segment number already exists and the content is different, a pop-up window will ask whether to overwrite.

[0043] The error logging and retry unit records the import time and reason for failure when data import fails, and attempts to re-import. When an exception occurs during the ImportRowData (calling module) call (such as no matching file in the dedicated folder, missing template, file opening failure, etc.), the system will call RecordFailedImport (error logging module) to write the failure information to the "Auto-import Failed Content Table". When the workbook is closed, RetryFailedImports (retry module) checks the "Pending Retry" record and pops up a retry, skip, and cancel pop-up window for the user to choose from. Retry: Re-call ImportRowData (calling module) to attempt import; Skip: Update the status to "User Skipped"; Cancel: Cancel the close operation, allowing the user to handle it manually. When the import is successful, the failure information is removed from the "Auto-import Failed Content Table"; when the import still fails, the pending retry status is maintained.

[0044] The monthly ranking export unit automatically exports core statistical data to a monthly ranking file, achieving standardized and automated data output. This significantly reduces repetitive manual export, organization, and archiving, improving data flow efficiency. The monthly ranking file is generated by CreateFourTables_Final (the export module) and is typically triggered when: the user manually runs the Main_All_Final one-click process, or it is automatically invoked when the workbook is closed. The statistical logic is as follows: iterate through all rows of the main worksheet and compile the problem deviation value statistics table (e.g., ...). Figure 7 ), ranking list (such as Figure 8 ), problem occurrence rate (e.g.) Figure 9 The five statistical tables generated are recorded in Sheet3. The SortCoreProByCount (sorting module) is used to sort the high-frequency problems and automatically adjust the table format (column width, border, and header background color).

[0045] The dedicated folder contains the ship number template and a real-time overview of the ship's inspection. The automatic refresh unit updates the ship number file every time it is opened, updating information such as the current stage of the section inspection process and displaying the ship's construction team, the specific person in charge of each section, the surveyor, the score, the pass status, and problem details below. The Workbook_Open event is automatically triggered each time the ship number file is opened. The AutoUpdateFromSharedFile (paste module) is called to load the latest on-site inspection details image from the dedicated folder based on the ship number and paste it into the ship number file; the table format is automatically improved (line breaks, adaptive row height, borders). This ensures that the latest construction progress and on-site inspection information are displayed every time the ship number file is opened. The information displayed below, such as the construction team, section manager, surveyor, score, pass status, and problem details, has already been written to the corresponding columns (columns A~H: section number, inspector, inspection date, inspection result, problem description, score, construction team, synchronization time) via InsertSectionData (write module) when the main worksheet is synchronized to the ship number file.

[0046] Figure 12 This is a simplified schematic diagram of the ship section accuracy management method based on Excel VBA of the present invention. Figure 13 This is a schematic diagram of the automatic scoring in the ship section accuracy management method based on ExcelVBA of this invention. Figure 14 This is a schematic diagram illustrating the hyperlink generation in the ship section accuracy management method based on Excel VBA of this invention. (See diagram below.) Figures 12 to 14As shown, this invention provides a method for managing the accuracy of ship sections based on Excel VBA. Using the aforementioned Excel VBA-based ship section accuracy management system, the system establishes a main folder, a launched folder, a main worksheet, and specific statistical tables. The accuracy management method includes: Step S1: Capture user operations in the main worksheet; specifically, when the user enters or modifies data in the main worksheet, the operation is captured through the Worksheet_Change and Worksheet_BeforeDoubleClick events.

[0047] Step S2, in response to the user's first operation in the main worksheet, generates a hyperlink in the main worksheet to bind the corresponding precision file; wherein, the first operation refers to modifying the ship number, section number, or project number, each project number corresponds to a project folder, each project folder includes a main folder and a launched folder, each ship has its own dedicated folder, which is placed within the main folder or the launched folder depending on whether it has been launched. The precision file is stored in the dedicated folder. Step S2 includes: Step S21: In response to the user modifying the ship number, section number, or project number, obtain the modified ship number, section number, and project number; when the user modifies the ship number, section number, or project number, the Worksheet_Change event calls the ManualAddHyperlink.AutoGenerateHyperlink procedure to obtain the project number, ship number, and section number in sequence.

[0048] Step S22: Based on the modified ship number, section number, and project number, obtain the base path, and concatenate the main folder path and the launched folder path to generate the corresponding hyperlink path. Specifically, first, based on the ship number, section number, and project number of the current row, use the GetProjectBasePath module to obtain the base path based on the project number. Then, determine whether it has been launched based on the ship number. Finally, obtain the path of the precision file in the main folder or the launched folder based on the section number. Concatenate the base path, whether it has been launched, and the path of the precision file in sequence, and then bind the PDF extension. The path format of the main folder is: base path + "800" + 4-digit ship number + fixed extension; the path format of the launched folder is: base path + "launched\" + ship number folder. The base path is the project number path. Step S23: Determine whether the segment number is of type S; Step S231: When the segment number is of type S, extract the core segment number and match it with either "S" or "P" suffix to form a new hyperlink path, which is used to distinguish between port and starboard; where the suffix "S" is for starboard and the suffix "P" is for port. Step S232: When the segment number is not of type S, match the complete segment number and the concatenated path is the hyperlink path.

[0049] Step S24: Traverse the main folder and the launched folder, and use regular expressions to match the precision files corresponding to the hyperlink paths; specifically, first match the project folders by project number, then traverse the main folder, then traverse and search the main folders in ascending order by ship number. If the main folder does not have the file, traverse and search the launched folders, and then match by segment number.

[0050] Step S241: Call the FindTargetPDF module to traverse the main folder and the "already submerged" folder; Step S242: Use regular expressions (VBScript.RegExp) to match hyperlink paths and corresponding precision files; the precision files are in PDF format and named according to predetermined naming rules. Specifically, obtain the segment number, determine its type based on the string characteristics of the segment number, and execute the corresponding matching strategy. When the segment number is a regular segment number, a regular expression with word boundary constraints is constructed to match the segment number as an independent semantic unit, preventing it from being misidentified as part of other segment number strings, thus matching the corresponding precision file. When the segment number is a basic segment number, a regular expression with word boundary constraints is constructed to match precision files that only contain the basic segment number "1B1" as an independent unit, while excluding files whose filenames contain the additional identifier "base". When the segment number is a basic segment number with an additional identifier, a regular expression without word boundary constraints is constructed to match the complete string "1B1 base", thus correctly identifying precision files containing the additional identifier. When the segment number is a subclass segment number identified by a prefix letter, the core numbers or identifiers in the segment number are extracted, and a first suffix (e.g., "S") and a second suffix (e.g., "P") are generated respectively. Precision files with the corresponding suffixes are matched in the same or different folder paths.

[0051] Step S25: Determine whether a matching precision file has been found; Step S251: When a corresponding precision file is matched, the hyperlink path is bound to the matched precision file; Step S252: When no matching precision file is found, display "No link" in the precision report file column; Step S253: Manually add a precision file by binding the hyperlink path to the precision file manually selected by the user; specifically, the user double-clicks the precision report file column, a file selection dialog box pops up, and the user manually selects a PDF precision file; Step S26: Bind the hyperlink to the accuracy report file column so that the accuracy file will be opened automatically when the user clicks it.

[0052] Step S3, in response to the user's second operation in the main worksheet, automatically scores the construction teams in the main worksheet; the second operation can be adding or modifying data in the main worksheet. It can be understood that self-inspection by the construction team and inspection by the quality control team generally involve adding operations, while rework by the construction team generally involves modifying operations. Step S3 includes: Step S31: In response to the user double-clicking the selection result column of the main worksheet, a "Three-Level Menu Rating" form pops up in the main worksheet; the "Three-Level Menu Rating" includes first-level category, second-level category, third-level item, "Add", selected item, "Remove", "Clear", "OK", "Cancel", and "Self-Check".

[0053] In step S32, in response to the user selecting self-test in the "Three-level menu rating" form, the self-test is marked as passed in the inspection result column of the main worksheet; correspondingly, the self-test is displayed in both the selection result column and the score column of the main worksheet, and colored marks are added to the inspection result column and the score column.

[0054] Step S33: In response to the user adding or modifying questions in the "Three-Level Menu Rating" form, all question items are concatenated in the selection result column of the main worksheet. Specifically, during form initialization, question categories are loaded from the "Data Source" worksheet. When adding a question, the user selects a category using lstLevel1_Click and lstLevel2_Click, and adds the question item to the right-hand list by clicking cmdAdd_Click. If the first-level categories are inconsistent, the system displays a prompt. The user can select a list item and click cmdRemove_Click to remove the item, or click cmdClearList_Click to clear all items. It's understandable that adding questions is generally done by the quality inspection team during inspections, while modifying questions is generally done by the construction team during rework. When adding a question, it's possible to select nothing, meaning no questions are added, so the selection result column displays "full marks" and the score column displays "100". Modifying a question involves deleting questions from the selection result column or modifying the degree of deviation.

[0055] Step S34: Based on the preset deduction rules and all question items in the selected results column, calculate the score in the score column of the main worksheet. Specifically, if you click "OK" after selecting a question, the system will concatenate all question items into the selected results column and call the modOperations.CalculateScoreUnified module to calculate the total score and write it into the score. When a question is empty, a perfect score is indicated in the selected results column, and 100 points are indicated in green in the score column. Understandably, if the selected results column is modified, step S34 needs to be re-executed. Furthermore, the deduction rules display the last selection time of the item and the total number of selections for the month.

[0056] Step S35: Based on the score in the score column and the preset threshold, display "Pass" or "Fail" in the inspection result column of the main worksheet. Specifically, when the total score is below 60, the inspection result is automatically set to "Fail," and the modification status is marked as "Unmodified." When the total score is greater than or equal to 60, the inspection result is automatically set to "Pass." "Pass" is matched in green, "Fail" in red, and "Unmodified" in red.

[0057] Step S36: When the inspection result column in the main worksheet displays "Failed," the modification status column in the main worksheet indicates "Unmodified." After the user corrects the issue, the score is automatically recalculated, and the modification status column indicates "Modified," while the inspection result column indicates "Passed on Second Attempt." "Modified" matches green, and "Passed on Second Attempt" matches green. Specifically, when the user double-clicks the "Corrected Image Return" column, the window for adding an image automatically redirects and opens to the "Corrected Image Return" column. The added image is automatically saved to a cell and stored locally in the document. Deleting the original file does not affect viewing the added image content.

[0058] Step S37: Synchronize the real-time collected accuracy data to the dedicated folder corresponding to the ship number. If the corresponding file does not exist, a standardized template file will be automatically created. The synchronized content includes all real-time data such as ship construction progress, accuracy inspection results, and scores. The dedicated folder contains the ship number template and a real-time inspection overview of the ship. Each time the ship number file is opened, it is automatically updated, including the current stage of the section inspection process, and displays the ship's construction team, the specific person in charge of each section, the surveyor, the score, the pass status, and problem details. Furthermore, if synchronization fails, the import time and reason for failure are recorded, and the data can be imported again.

[0059] Step S4: Update the special statistics table based on the main worksheet. The special statistics table includes columns such as segment, core issue, total number of times, details, number of times, and company, for example... Figure 8 Taking the deviation value statistics of section B as an example, the special statistical table can automatically calculate the frequency of accuracy problems and the distribution of various deviation values, as well as core management indicators such as the first pass rate, average score, and number of full marks for each section / construction team.

[0060] Step S5: Generate visualized statistical charts and ranking lists based on the specific statistical tables. This process establishes a long-term, systematic data accumulation system, supporting year-on-year and month-on-month analysis for various construction teams and different types of segmented manufacturing. It provides a visualized data foundation for enterprises to explore the "quality and quantity balance point," and offers data support for process improvement, production plan adjustments, and outsourcing team management. Specifically, the statistical charts include a self-inspection quantity table, a full-score quantity table, an average score ranking table, a first-pass rate ranking table, and a detailed segmented deviation data statistical table (including the detailed occurrence frequency of the problem and the company's occurrence frequency). Pivot charts can also be generated for different needs.

[0061] The technical solution of the present invention has been described above with reference to the preferred embodiments shown in the accompanying drawings. However, it will be readily understood by those skilled in the art that the scope of protection of the present invention is obviously not limited to these specific embodiments. Without departing from the principles of the present invention, those skilled in the art can make equivalent changes or substitutions to the relevant technical features, and the technical solutions after such changes or substitutions will all fall within the scope of protection of the present invention.

Claims

1. A ship section accuracy management system based on Excel VBA, characterized in that, The precision management system, based on Excel and implemented using VBA programming language, includes: The local storage module is used to store, retain, and retrieve relevant data locally. The relevant data includes the main table worksheet, special statistical tables, and precision files. The event capture module is used to capture user operations in the main table worksheet; The hyperlink association module is used to generate a hyperlink in the main table worksheet that binds to the corresponding precision file in response to the user's first operation in the main table worksheet. An automatic scoring module is used to automatically score construction teams in the main worksheet in response to a second operation by the user in the main worksheet. The statistics module is used to update the specific statistics table based on the main table worksheet; The local storage module includes a main folder and a "submerged" folder, and the precision file is stored in the main folder and the "submerged" folder. The hyperlink association module includes: The first response unit is used to respond to the user's modification of the ship number, section number, or project number, and to obtain the modified ship number, section number, or project number. The hyperlink generation unit is used to obtain the basic path based on the modified ship number, segment number and project number, and concatenate the main folder path and the launched folder path to generate the corresponding hyperlink path. The matching unit is used to traverse the main folder and the already downloaded folders, and use regular expressions to match the precision files corresponding to the hyperlink paths; An automatic binding unit is used to bind the hyperlink path to the matching precision file; The automatic scoring module includes: The second response unit is used to respond to the user double-clicking the selection result column of the main table worksheet and pop up a "three-level menu rating" form in the main table worksheet; The self-test unit is used to indicate that the self-test has passed in the test result column of the main worksheet when the user selects self-test in the "three-level menu rating" form; The question addition unit is used to concatenate all question items in the selection result column of the main worksheet when the user adds or modifies a question in the "three-level menu rating" form. The automatic scoring unit calculates the score in the score column of the main worksheet based on the preset deduction rules and all the question items in the selected result column; The judgment unit displays "pass" or "fail" in the inspection result column of the main worksheet based on the score in the score column and the preset threshold.

2. The ship section accuracy management system based on Excel VBA according to claim 1, characterized in that, The hyperlink association module also includes a manual binding unit, which is used to bind the hyperlink path to a precision file manually selected by the user; the precision management system also includes a data verification and format standardization module, which is used to perform real-time verification, format standardization, and anomaly alerts on the data input content.

3. The ship section accuracy management system based on Excel VBA according to claim 1, characterized in that, The automatic scoring module also includes a modification identification unit. When the inspection result column of the main worksheet shows "failed", the modification identification unit marks "not modified" in the modification status column of the main worksheet. After the user corrects the problem, the modification status column marks "modified" and the inspection result column marks "passed on the second attempt".

4. The ship section accuracy management system based on Excel VBA according to claim 1, characterized in that, It also includes an analysis module and an automatic save and export module. The analysis module is used to generate visual statistical charts and ranking lists based on the special statistical table. The automatic save and export module is used to synchronize the real-time collected precision data to the dedicated folder of the corresponding ship number.

5. A method for managing the accuracy of ship sections based on Excel VBA, characterized in that, Using the ExcelVBA-based ship section accuracy management system according to any one of claims 1-4, the accuracy management method includes: Capture user actions in the main table worksheet; In response to the user's first operation in the main table worksheet, a hyperlink bound to the corresponding precision file is generated in the main table worksheet. In response to a second user action in the main worksheet, the construction team is automatically rated in the main worksheet. Update the special statistics table based on the main table worksheet; The step of generating a hyperlink bound to the corresponding precision file in the main table worksheet in response to a user's first operation in the main table worksheet includes: In response to a user modifying the ship number, section number, or project number, obtain the modified ship number, section number, and project number; Based on the modified ship number, section number, and project number, obtain the basic path, and concatenate the main folder path and the launched folder path to generate the corresponding hyperlink path. Traverse the main folder and the already downloaded folders, and use regular expressions to match the precision files corresponding to the hyperlink paths; When a matching precision file is found, the hyperlink path is bound to the matching precision file; When no matching precision file is found, the hyperlink path is bound to the precision file manually selected by the user. The step of automatically scoring the construction team in the main worksheet in response to a second user operation in the main worksheet includes: In response to the user double-clicking the selection result column of the main table, a "Three-level menu rating" form pops up in the main table. When a user selects self-test in the "Three-Level Menu Rating" form, the self-test is marked as passed in the test result column of the main worksheet; In response to a user adding or modifying a question in the "Three-Level Menu Rating" form, all question items are concatenated in the selection results column of the main worksheet; Based on the preset deduction rules and all the question items in the selection result column, the score is calculated in the score column of the main worksheet; Based on the score in the score column and the preset threshold, the pass or fail result column in the main worksheet is displayed. When the inspection result column of the main worksheet shows "failed", the modification status column of the main worksheet indicates that it has not been modified. After the user corrects the problem, the modification status column indicates that it has been modified, and the inspection result column indicates "passed on the second attempt".

6. The method for ship section accuracy management based on Excel VBA according to claim 5, characterized in that, After updating the special statistics table based on the main worksheet, the method further includes: When the main worksheet is closed, the real-time collected precision data is synchronized to the dedicated folder for the corresponding ship number; based on the special statistical table, visual statistical charts and ranking lists are generated.

Images