Engineering cost bidding and tendering data management method and system

Abstract

The invention relates to a project cost bidding and tendering data management method and system. The method comprises the steps of obtaining a bidding list EXCEL file and a tendering list EXCEL file; analyzing the bid invitation list EXCEL file and the bidding list EXCEL file, and identifying single project names and unit project names in the bid invitation list EXCEL file and the bidding list EXCEL file from multiple dimensions; performing similarity matching on the single project names of the bidding unit and the bidding unit; binding the single project names of the bidding unit and the bidding unit according to a similarity matching result; performing similarity matching on unit project names subordinate to the bound single project names of the bidding unit and the bidding unit; and binding the unit project names of the bidding unit and the bidding unit and the detailed list data subordinate to the unit project names according to a similarity matching result.

Description

Technical Field

[0001] The present application relates to the technical field of engineering cost data management, and in particular to an engineering cost bidding data management method and system. Background Art

[0002] In the traditional bidding process, the bidding documents are often in the form of cost attachments in EXCEL format. After the attachments are uploaded, the cost list details are not parsed and stored, resulting in a large amount of raw data not being used. It is also not convenient for bid comparison. If there is no structured list detail data, the bid analysis of the bill of quantities often relies on manual judgment. This method is time-consuming and error-prone, and it is difficult to meet the efficiency and accuracy requirements of modern construction project bidding. Summary of the invention

[0003] In order to at least to some extent overcome the problem in the related art that manual judgment of list detail data in bidding documents is prone to errors and inefficient, the present application provides a method and system for engineering cost bidding data management.

[0004] The scheme of this application is as follows:

[0005] According to a first aspect of an embodiment of the present application, a method for managing engineering cost bidding data is provided, comprising:

[0006] Obtain the tender list EXCEL file and bid list EXCEL file;

[0007] Parse the tender list EXCEL file and the bid list EXCEL file, and identify the single project name and unit project name in the tender list EXCEL file and the bid list EXCEL file from multiple dimensions;

[0008] Carry out similarity matching between the names of individual projects of the tendering unit and the bidding unit;

[0009] Bind the names of individual projects of the tendering unit and the bidding unit according to the similarity matching results;

[0010] Carry out similarity matching on the unit project names under the single project names that have been bound between the tendering unit and the bidding unit;

[0011] Based on the similarity matching results, the unit project names of the bidding unit and the bidding unit, as well as the detailed list data under the unit project names are bound.

[0012] Preferably, parsing the tender list EXCEL file and the bid list EXCEL file includes:

[0013] Read the file names and folder names of the tender list EXCEL file and the bid list EXCEL file;

[0014] Identify the names of each sheet in the tender list EXCEL file and the bid list EXCEL file, and extract corresponding data from different sheet tabs;

[0015] Parse the table data in the tender list EXCEL file and the bid list EXCEL file, and identify the relevant fields containing the single project name, unit project name and list details.

[0016] Preferably, the method further comprises:

[0017] Format the parsed data and convert it into a structured data form;

[0018] Identify and classify information in structured data that includes individual project names and unit project names.

[0019] Preferably, the method further comprises:

[0020] Perform integrity and consistency checks on parsed data.

[0021] Preferably, the names of individual projects and unit projects in the tender list EXCEL file and the bid list EXCEL file are identified from multiple dimensions, including:

[0022] Determine whether the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the single project name or unit project name field;

[0023] If the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file shall be used as the single project name or unit project name;

[0024] If the file names or folder names of the tender list EXCEL file and the bid list EXCEL file do not contain the single project name or unit project name field, determine whether the sheet page signature names of the tender list EXCEL file and the bid list EXCEL file contain the single project name or unit project name field;

[0025] If the sheet page signature of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the sheet page signature of the tender list EXCEL file and the bid list EXCEL file will be used as the single project name or unit project name;

[0026] If the sheet page signatures of the tender list EXCEL file and the bid list EXCEL file do not contain the field of the single project name or the unit project name, determine whether there are relevant fields of the single project name or the unit project name in the table data in the tender list EXCEL file and the bid list EXCEL file;

[0027] If there are relevant fields for the names of individual projects or unit projects in the table data in the tender list EXCEL file and the bid list EXCEL file, the relevant fields for the names of individual projects or unit projects in the table data in the tender list EXCEL file and the bid list EXCEL file will be used as the names of individual projects or unit projects.

[0028] Preferably, similarity matching is performed on the names of individual projects of the tendering unit and the bidding unit, including:

[0029] Calculate the similarity between the name of the current single project of the bidding unit and the names of all single projects of the bidding unit;

[0030] If there is only one result with the highest name similarity, the single project name of the tendering unit with the highest name similarity will be bound to the current single project name of the tendering unit;

[0031] If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit;

[0032] Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data;

[0033] If there is only one result with the highest data similarity, the single project name corresponding to the candidate data with the highest data similarity is bound to the current single project name of the bidding unit;

[0034] If there are multiple results with the highest data similarity, the detailed list data of the current single project of the bidding unit will be bound to the project node;

[0035] Traverse the names of all individual projects of the bidding unit.

[0036] Preferably, similarity matching is performed on the unit project names under the single project names bound between the tendering unit and the bidding unit, including:

[0037] Among the unit project names under the bound single project name, calculate the name similarity between the current unit project name of the bidding unit and all the unit project names of the bidding unit;

[0038] If there is only one result with the highest name similarity, the unit project name of the bidding unit with the highest name similarity will be bound to the current unit project name of the bidding unit;

[0039] If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit;

[0040] Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data;

[0041] If there is only one result with the highest data similarity, the unit engineering name corresponding to the candidate data with the highest data similarity is bound to the current unit engineering name of the bidding unit;

[0042] If there are multiple results with the highest data similarity, the detailed list data under the current unit project of the bidding unit will be bound to the project node;

[0043] Traverse all the unit project names under all the single project names of the bidding unit.

[0044] Preferably, the method further comprises:

[0045] Send the list details data bound to the project node to the management personnel.

[0046] According to a second aspect of an embodiment of the present application, there is provided a project cost bidding data management system, comprising:

[0047] Processor and memory;

[0048] The processor and the memory are connected via a communication bus:

[0049] Wherein, the processor is used to call and execute the program stored in the memory;

[0050] The memory is used to store a program, and the program is used to execute at least one of the methods for managing engineering cost bidding data as described above.

[0051] The technical solution provided by this application may have the following beneficial effects:

[0052] The engineering cost bidding data management method in the present application includes: obtaining a bidding list EXCEL file and a bidding list EXCEL file; parsing the bidding list EXCEL file and the bidding list EXCEL file, identifying the single project names and unit project names in the bidding list EXCEL file and the bidding list EXCEL file from multiple dimensions; performing similarity matching on the single project names of the bidding unit and the bidding unit; binding the single project names of the bidding unit and the bidding unit according to the similarity matching results; performing similarity matching on the unit project names under the single project names that the bidding unit and the bidding unit have bound; binding the unit project names of the bidding unit and the bidding unit, as well as the list detail data under the unit project names according to the similarity matching results.

[0053] This technical solution can automatically identify and extract inventory data without manual input and review, greatly shortening the inventory data processing time. Automatically matching single project names, unit project names, and inventory details avoids the inefficient process of manual item-by-item comparison and verification. By calculating similarity to match the corresponding project names, the inconsistency caused by manual intervention is reduced, especially when the name expressions are inconsistent or there are synonyms, effective matching can be performed through algorithms. After the data is automatically bound, the data of all relevant inventory items is more unified, reducing the risk of data omissions or errors. Automatic completion of bid clearance analysis, especially the comparison of the bill of quantities, greatly reduces dependence on manual labor.

[0054] It should be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

[0055] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.

[0056] Figure 1 It is a flowchart of a method for managing engineering cost bidding data provided by an embodiment of the present application;

[0057] Figure 2 This is a schematic diagram of a folder of a tender list EXCEL file and a bid list EXCEL file provided by an embodiment of the present application;

[0058] Figure 3 It is a schematic diagram of a single project name or a unit project name identified according to the file name or the folder name of a tender list EXCEL file and a bid list EXCEL file, provided by an embodiment of the present application;

[0059] Figure 4It is a schematic diagram of the signature names of each sheet page in a bidding list EXCEL file and a tender list EXCEL file provided by an embodiment of the present application;

[0060] Figure 5 It is a schematic diagram of a single project name or a unit project name identified according to the sheet page signature in the tender list EXCEL file and the bid list EXCEL file provided by an embodiment of the present application;

[0061] Figure 6 It is a schematic diagram of table data of a tender list EXCEL file and a bid list EXCEL file provided by an embodiment of the present application;

[0062] Figure 7 It is a schematic diagram of a single project name or a unit project name identified according to table data in a tender list EXCEL file and a bid list EXCEL file provided by an embodiment of the present application;

[0063] Figure 8 It is a flow chart of performing similarity matching on unit project names under the single project names bound between the bidding unit and the bidding unit, provided by an embodiment of the present application;

[0064] Fig. 9 It is a schematic diagram of a single project name or a unit project name identified according to an EXCEL file of a bidding list provided by an embodiment of the present application;

[0065] Fig.10 This is a schematic diagram of raw bidding data provided by an embodiment of the present application;

[0066] Fig.11 It is a structural diagram of a construction cost bidding data management system provided by an embodiment of the present application.

[0067] Reference numerals: processor-21; memory-22. DETAILED DESCRIPTION

[0068] Exemplary embodiments will be described in detail herein, examples of which are shown in the accompanying drawings. When the following description refers to the drawings, the same numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with the present application. Instead, they are merely examples of devices and methods consistent with some aspects of the present application as detailed in the appended claims.

[0069] Figure 1 This is a flow chart of a method for managing engineering cost bidding data provided by an embodiment of the present application, referring to Figure 1, a method for managing engineering cost bidding data, comprising:

[0070] S11: Obtain the tender list EXCEL file and the bid list EXCEL file;

[0071] The tender list EXCEL file refers to the tender unit's list EXCEL file, and the bid list EXCEL file refers to the tender unit's list EXCEL file. Tendering and bidding is a form of comprehensive economic responsibility system to promote competition in the field of capital construction. Generally, several construction units participate in the project bidding, and the tendering unit (construction unit) is selected based on merit.

[0072] S12: parsing the tender list EXCEL file and the bid list EXCEL file, and identifying the names of individual projects and unit projects in the tender list EXCEL file and the bid list EXCEL file from multiple dimensions;

[0073] It should be noted that the project is the highest level concept, which refers to the implementation plan of the entire construction project, including multiple individual projects. The project usually includes the scope, budget, schedule, etc. of the entire construction, and is an overall engineering task.

[0074] A single project is a part of a project, which refers to a separate construction project, which can be part of the entire building, such as civil engineering, installation engineering, decoration engineering, etc. Each single project is a complete work unit, usually with independent work content and goals.

[0075] A unit project is the smallest engineering unit that is further divided in a single project. A unit project usually refers to a part of a project divided by function or structure, such as a structural part of a building, or an installation system. A unit project is the smallest unit for specific operations and management during the construction process.

[0076] That is, a project is composed of multiple individual projects, each of which can contain multiple unit projects, and the unit projects contain detailed list data.

[0077] S13: Perform similarity matching on the names of individual projects of the tendering unit and the bidding unit;

[0078] S14: Binding the names of the individual projects of the tendering unit and the bidding unit according to the similarity matching result;

[0079] S15: performing similarity matching on the unit project names under the single project names bound to the tendering unit and the bidding unit;

[0080] S16: Binding the unit project names of the tendering unit and the bidding unit, as well as the list detail data under the unit project names, according to the similarity matching result.

[0081] It should be noted that the analysis of the tender list EXCEL file and the bid list EXCEL file includes:

[0082] Read the file names and folder names of the tender list EXCEL file and the bid list EXCEL file;

[0083] The folders of tender list EXCEL file and bid list EXCEL file are as follows Figure 2 shown.

[0084] Identify the names of each sheet in the tender list EXCEL file and the bid list EXCEL file, and extract corresponding data from different sheet tabs;

[0085] Identify the signatures of each sheet in the tender list EXCEL file and the bid list EXCEL file. Figure 4 shown.

[0086] Parse the table data in the tender list EXCEL file and the bid list EXCEL file, and identify the relevant fields containing the single project name, unit project name and list details.

[0087] The table data in the tender list EXCEL file and the bid list EXCEL file are as follows Figure 6 shown.

[0088] In this embodiment, multi-dimensional data recognition is used to improve the accuracy of data recognition, and key information can be extracted through multiple dimensions such as file name, sheet page signature, table data, etc., to ensure that no data is missed. Automatic recognition and parsing of EXCEL files avoids the inefficiency and errors of manually checking the contents of files one by one.

[0089] Preferably, the method further comprises:

[0090] Format the parsed data and convert it into a structured data form;

[0091] Identify and classify information in structured data that includes individual project names and unit project names.

[0092] The parsed data is converted into a unified structured format, such as a database table structure, through an algorithm to facilitate subsequent processing. The data containing the names of individual projects and unit projects is identified and classified for subsequent similarity matching.

[0093] Preferably, the method further comprises:

[0094] Perform integrity and consistency checks on parsed data.

[0095] Data integrity check is used to ensure that the parsed data is not missing and the necessary data items have been extracted.

[0096] Data consistency check is used to check whether the data in different files are consistent and eliminate possible errors.

[0097] Based on this, the names of individual projects and unit projects in the tender list EXCEL files and bid list EXCEL files are identified from multiple dimensions, including:

[0098] Determine whether the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the single project name or unit project name field;

[0099] like Figure 3 As shown, if the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file is used as the single project name or unit project name;

[0100] If the file names or folder names of the tender list EXCEL file and the bid list EXCEL file do not contain the single project name or unit project name field, determine whether the sheet page signature names of the tender list EXCEL file and the bid list EXCEL file contain the single project name or unit project name field;

[0101] like Figure 5 As shown, if the sheet page signature of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the sheet page signature of the tender list EXCEL file and the bid list EXCEL file is taken as the single project name or unit project name;

[0102] If the sheet page signatures of the tender list EXCEL file and the bid list EXCEL file do not contain the field of the single project name or the unit project name, determine whether there are relevant fields of the single project name or the unit project name in the table data in the tender list EXCEL file and the bid list EXCEL file;

[0103] like Figure 7 As shown, if there are relevant fields for the name of a single project or the name of a unit project in the table data in the tender list EXCEL file and the bid list EXCEL file, the relevant fields for the name of a single project or the name of a unit project in the table data in the tender list EXCEL file and the bid list EXCEL file are used as the name of the single project or the name of the unit project.

[0104] This technical solution identifies the steps of single project names and unit project names from multiple dimensions to ensure that key information is obtained from different angles. If the file name or folder name contains the name of a single project or a unit project, the field is directly used as the identification information. If the sheet name contains the field of the single project or unit project name, it is extracted from the sheet name. If the first two methods fail to identify, the relevant fields are extracted from the table data. Through a multi-dimensional recognition method, the relevant project names can be extracted more accurately to ensure that they are not missed. And under different file structures and formats, the system can still automatically identify and process data.

[0105] It should be noted that the similarity matching of the names of individual projects of the tendering units and the bidding units includes:

[0106] Calculate the similarity between the name of the current single project of the bidding unit and the names of all single projects of the bidding unit;

[0107] If there is only one result with the highest name similarity, the single project name of the tendering unit with the highest name similarity will be bound to the current single project name of the tendering unit;

[0108] If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit;

[0109] Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data;

[0110] If there is only one result with the highest data similarity, the single project name corresponding to the candidate data with the highest data similarity is bound to the current single project name of the bidding unit;

[0111] If there are multiple results with the highest data similarity, the detailed list data of the current single project of the bidding unit will be bound to the project node;

[0112] Traverse the names of all individual projects of the bidding unit.

[0113] In this embodiment, a similarity algorithm can be used to automatically match the name of a single project, and multiple similarity matching of names and data can ensure high accuracy of the matching results.

[0114] Similarly, refer to Figure 8 , perform similarity matching on the unit project names under the single project names that have been bound between the tendering unit and the bidding unit, including:

[0115] Among the unit project names under the bound single project name, calculate the name similarity between the current unit project name of the bidding unit and all the unit project names of the bidding unit;

[0116] If there is only one result with the highest name similarity, the unit project name of the bidding unit with the highest name similarity will be bound to the current unit project name of the bidding unit;

[0117] If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit;

[0118] Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data;

[0119] If there is only one result with the highest data similarity, the unit engineering name corresponding to the candidate data with the highest data similarity is bound to the current unit engineering name of the bidding unit;

[0120] If there are multiple results with the highest data similarity, the detailed list data under the current unit project of the bidding unit will be bound to the project node;

[0121] Traverse all the unit project names under all the single project names of the bidding unit.

[0122] The principle of similarity matching of unit project names under the single project names bound between the tendering unit and the bidding unit is basically the same as that of similarity matching of the single project names of the tendering unit and the bidding unit, which will not be elaborated here.

[0123] It should be noted that the method also includes:

[0124] Send the list details data bound to the project node to the management personnel.

[0125] The list details data bound to the project node are the list details data that cannot be matched to the unique corresponding name by the system. Such list details data need to be manually analyzed and the binding relationship corrected, so in this embodiment, the list details data bound to the project node are sent to the management personnel for manual processing.

[0126] based on Figure 8 and Fig. 9 The technical solution is exemplified as follows:

[0127] Figure 8 It is a schematic diagram of a single project name or a unit project name identified according to an EXCEL file of a bidding list provided by an embodiment of the present application. Fig. 9This is a schematic diagram of raw bidding data provided by an embodiment of the present application, from Fig. 9 It can be seen that the unit project names of the bidding quotation are not standardized. Only some unit projects can clearly identify their corresponding unit projects in the bidding list. Most unit projects cannot be bound by name. Different single projects with the same unit project name use serial numbers such as "_1" and "_2". Even if you look at it manually, you cannot find the correct unit project by name. You can only find the correct unit project by analyzing the specific list details. This comparison is time-consuming and laborious. Through the powerful computing power of computers, you can quickly bind the bidding list and the unit project of the bidding quotation.

[0128] Step 1: Take the unit project name identified by the bid quotation, such as "outdoor and other civil engineering projects" and compare it with the unit project name in the bidding list one by one. When comparing, compare it with the unit project in the bidding list or the single item in the bidding list + the unit project name. After all the comparisons, calculate the similarity of each unit project. If there is only one piece of data with the highest similarity (outdoor and other civil engineering projects), then the unit project will establish a binding relationship with the unit project in the bidding list.

[0129] Step 2: After the first step, some unit projects have multiple data with the same similarity. For example, the matching result of "

Civil Engineering

Civil Engineering

[0130] In summary, this technical solution can automatically identify and extract inventory data without manual input and review, greatly shortening the inventory data processing time. Automatically matching individual project names, unit project names, and inventory details avoids the inefficient process of manual item-by-item comparison and verification. By calculating the similarity to match the corresponding project names, the inconsistency caused by manual intervention is reduced, especially when the name expressions are inconsistent or there are synonyms, effective matching can be performed through algorithms. After the data is automatically bound, the data of all relevant inventory items is more unified, reducing the risk of data omissions or errors. Automatic completion of bid clearance analysis, especially the comparison of the bill of quantities, greatly reduces dependence on manual labor.

[0131] Embodiment 2

[0132] A project cost bidding data management system, referring to Fig.10 ,include:

[0133] Processor 21 and memory 22;

[0134] The processor 21 and the memory 22 are connected via a communication bus:

[0135] The processor 21 is used to call and execute the program stored in the memory 22;

[0136] The memory 22 is used to store a program, and the program is used to execute at least one of the above engineering cost bidding data management methods.

[0137] It can be understood that the same or similar parts of the above embodiments can be referenced to each other, and the contents not described in detail in some embodiments can refer to the same or similar contents in other embodiments.

[0138] It should be noted that, in the description of this application, the terms "first", "second", etc. are only used for descriptive purposes and cannot be understood as indicating or implying relative importance. In addition, in the description of this application, unless otherwise specified, the meaning of "plurality" refers to at least two.

[0139] Any process or method description in a flowchart or otherwise described herein may be understood to represent a module, segment or portion of code that includes one or more executable instructions for implementing the steps of a specific logical function or process, and the scope of the preferred embodiments of the present application includes alternative implementations in which functions may not be performed in the order shown or discussed, including performing functions in a substantially simultaneous manner or in the reverse order depending on the functions involved, which should be understood by technicians in the technical field to which the embodiments of the present application belong.

[0140] It should be understood that the various parts of the present application can be implemented by hardware, software, firmware or a combination thereof. In the above-mentioned embodiments, multiple steps or methods can be implemented by software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented by hardware, as in another embodiment, it can be implemented by any one of the following technologies known in the art or their combination: a discrete logic circuit having a logic gate circuit for implementing a logic function for a data signal, a dedicated integrated circuit having a suitable combination of logic gate circuits, a programmable gate array (PGA), a field programmable gate array (FPGA), etc.

[0141] A person skilled in the art may understand that all or part of the steps in the method for implementing the above-mentioned embodiment may be completed by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, which, when executed, includes one or a combination of the steps of the method embodiment.

[0142] In addition, each functional unit in each embodiment of the present application may be integrated into a processing module, or each unit may exist physically separately, or two or more units may be integrated into one module. The above-mentioned integrated module may be implemented in the form of hardware or in the form of a software functional module. If the integrated module is implemented in the form of a software functional module and sold or used as an independent product, it may also be stored in a computer-readable storage medium.

[0143] The storage medium mentioned above can be a read-only memory, a magnetic disk or an optical disk, etc.

[0144] In the description of this specification, the description with reference to the terms "one embodiment", "some embodiments", "example", "specific example", or "some examples" means that the specific features, structures, materials or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In this specification, the schematic representation of the above terms does not necessarily refer to the same embodiment or example. Moreover, the specific features, structures, materials or characteristics described may be combined in any one or more embodiments or examples in a suitable manner.

[0145] Although the embodiments of the present application have been shown and described above, it can be understood that the above embodiments are exemplary and cannot be understood as limitations on the present application. Ordinary technicians in this field can change, modify, replace and modify the above embodiments within the scope of the present application.

Claims

1. A method for managing engineering cost bidding data, characterized in that: include: Obtain the tender list EXCEL file and bid list EXCEL file; Parse the tender list EXCEL file and the bid list EXCEL file, and identify the single project name and unit project name in the tender list EXCEL file and the bid list EXCEL file from multiple dimensions; Carry out similarity matching between the names of individual projects of the tendering unit and the bidding unit; Bind the names of individual projects of the tendering unit and the bidding unit according to the similarity matching results; Carry out similarity matching on the unit project names under the single project names that have been bound between the tendering unit and the bidding unit; Based on the similarity matching results, the unit project names of the bidding unit and the bidding unit, as well as the detailed list data under the unit project names are bound.

2. The method according to claim 1, characterized in that Parse the tender list EXCEL file and bid list EXCEL file, including: Read the file names and folder names of the tender list EXCEL file and the bid list EXCEL file; Identify the names of each sheet in the tender list EXCEL file and the bid list EXCEL file, and extract corresponding data from different sheet tabs; Parse the table data in the tender list EXCEL file and the bid list EXCEL file, and identify the relevant fields containing the single project name, unit project name and list details.

3. The method according to claim 2, characterized in that The method further comprises: Format the parsed data and convert it into a structured data form; Identify and classify information in structured data that includes individual project names and unit project names.

4. The method according to claim 2, characterized in that: The method further comprises: Perform integrity and consistency checks on parsed data.

5. The method according to claim 2, characterized in that: Identify the names of individual projects and unit projects in the tender list EXCEL files and bid list EXCEL files from multiple dimensions, including: Determine whether the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the single project name or unit project name field; If the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the file name or the folder name of the tender list EXCEL file and the bid list EXCEL file shall be used as the single project name or unit project name; If the file names or folder names of the tender list EXCEL file and the bid list EXCEL file do not contain the single project name or unit project name field, determine whether the sheet page signature names of the tender list EXCEL file and the bid list EXCEL file contain the single project name or unit project name field; If the sheet page signature of the tender list EXCEL file and the bid list EXCEL file contains the field of single project name or unit project name, the sheet page signature of the tender list EXCEL file and the bid list EXCEL file will be used as the single project name or unit project name; If the sheet page signatures of the tender list EXCEL file and the bid list EXCEL file do not contain the field of the single project name or the unit project name, determine whether there are relevant fields of the single project name or the unit project name in the table data in the tender list EXCEL file and the bid list EXCEL file; If there are relevant fields for the names of individual projects or unit projects in the table data in the tender list EXCEL file and the bid list EXCEL file, the relevant fields for the names of individual projects or unit projects in the table data in the tender list EXCEL file and the bid list EXCEL file will be used as the names of individual projects or unit projects.

6. The method according to claim 1, characterized in that Similarity matching is performed on the names of individual projects of the tendering unit and the bidding unit, including: Calculate the similarity between the name of the current single project of the bidding unit and the names of all single projects of the bidding unit; If there is only one result with the highest name similarity, the single project name of the tendering unit with the highest name similarity will be bound to the current single project name of the tendering unit; If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit; Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data; If there is only one result with the highest data similarity, the single project name corresponding to the candidate data with the highest data similarity is bound to the current single project name of the bidding unit; If there are multiple results with the highest data similarity, the detailed list data of the current single project of the bidding unit will be bound to the project node; Traverse the names of all individual projects of the bidding unit.

7. The method according to claim 1, characterized in that Similarity matching is performed on the unit project names under the single project names that have been bound between the tendering unit and the bidding unit, including: Among the unit project names under the bound single project name, calculate the name similarity between the current unit project name of the bidding unit and all the unit project names of the bidding unit; If there is only one result with the highest name similarity, the unit project name of the bidding unit with the highest name similarity will be bound to the current unit project name of the bidding unit; If there are multiple results with the highest name similarity, obtain the detailed list data with the highest name similarity as candidate data, and obtain the detailed list data of the current single project of the bidding unit; Calculate the data similarity between the list detail data of the current single project of the bidding unit and all the candidate data; If there is only one result with the highest data similarity, the unit engineering name corresponding to the candidate data with the highest data similarity is bound to the current unit engineering name of the bidding unit; If there are multiple results with the highest data similarity, the detailed list data under the current unit project of the bidding unit will be bound to the project node; Traverse all the unit project names under all the single project names of the bidding unit.

8. The method according to any one of claims 6 or 7, characterized in that: The method further comprises: Send the list details data bound to the project node to the management personnel.

9. A construction cost bidding data management system, characterized in that: include: Processor and memory; The processor and the memory are connected via a communication bus: Wherein, the processor is used to call and execute the program stored in the memory; The memory is used to store a program, and the program is at least used to execute a method for managing engineering cost bidding data as described in any one of claims 1-8.

Images