Method, device, equipment and storage medium for reading quotation content in engineering bidding documents

Abstract

The present invention relates to the field of construction engineering technology, and in particular to a method, device, equipment, and storage medium for reading quotation content in a project bid document. The method comprises obtaining a project bid document of a target project, wherein the project annotation document includes multiple tables; determining the section structure of the target project based on the file structure of the project bid document or the names of the unit projects in the table page to obtain target tables corresponding to each unit project in the target project; matching the page tab of the target table with the table name field of a preset cost table to determine the cost table corresponding to the target table; extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project. The method avoids batch reading errors in the project bid document due to some business data not meeting requirements, effectively improving the efficiency and accuracy of reading the project bid document while reducing the degree of manual participation.

Description

Technical Field

[0001] The present invention relates to the technical field of construction engineering, and in particular to a method, device, equipment and storage medium for reading quotation content in a project tender document. Background Art

[0002] In the construction industry, various software tools can be used to calculate project costs. For example, during the bidding process, tenderers use pricing software to compile a bill of quantities (BOQ). They then export the entire file into a worksheet and provide it to the contractor for price calculation. Once the contractor receives the worksheet, they must import the relevant items from the BOQ into the pricing software one by one. Only after the software intelligently identifies the relevant items can they begin compiling a quote.

[0003] However, the above process requires a lot of manual worksheet importing operations, which is huge and cumbersome. Therefore, a method for reading the quotation content in the engineering bid document that can reduce the manual work and operational complexity is a technical problem that the industry urgently needs to solve. Summary of the Invention

[0004] In view of this, an embodiment of the present invention provides a method, device, equipment and storage medium for reading quotation content in an engineering bid document to solve the problem in the prior art that reading quotation content relies on a large amount of manual operation and has high operational complexity.

[0005] According to a first aspect, an embodiment of the present invention provides a method for reading quotation content in a project bid document, comprising:

[0006] Obtaining a project bidding document for a target project, wherein the project annotation document includes a plurality of tables;

[0007] Determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain target tables corresponding to the respective unit projects in the target project;

[0008] Matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table;

[0009] Based on the cell fields of the cost table, data is extracted from the target table of the corresponding unit project to generate a target cost table corresponding to each unit project.

[0010] The method for reading the quotation content in the engineering bid provided by the embodiment of the present invention analyzes the section structure of the target project and the target table corresponding to each unit project in the target project by utilizing the file structure of the engineering bid file or the name of the unit project in the table page, so that data can be read from the engineering bid file of multiple links to cope with multiple folder structures or large form structures, and the section structure of the entire project and the target table corresponding to each unit project can be intelligently read to avoid corresponding data tables one by one; at the same time, on this basis, the page tab of the target table is matched with the table name field of the preset cost table to obtain the cost table corresponding to the target table, so as to extract data from the target table to obtain the target cost table corresponding to the unit project, and realize the disassembly and identification of the project components and related costs from the engineering bid file, avoiding batch reading errors of the engineering bid file due to some business data not meeting the requirements, and effectively improving the efficiency and accuracy of reading the engineering bid file while reducing the degree of manual participation.

[0011] In some embodiments, determining the section structure of the target project based on the file structure of the project bidding document to obtain a target table corresponding to each unit project in the target project includes:

[0012] Query the file directory of the engineering bidding document to determine the last directory and the directory hierarchy structure;

[0013] If there is only one table in the last-level directory, the section structure is determined based on the directory hierarchy structure;

[0014] It is determined that the final directory is the file directory of the unit project, and the table in the final directory is the target table corresponding to the unit project.

[0015] The method for reading the quotation content in the engineering bid provided by the embodiment of the present invention analyzes the file directory of the engineering bid file in the folder table format to obtain the section structure. In the folder table format, the first layer is the project department engineering level, the last layer is the unit engineering level, and the middle layer is the single project level with a hierarchical structure. When there is only one table in the last-level directory, the section structure and the file directory of the unit project can be obtained, and they are analyzed level by level to improve the accuracy of the obtained section structure and the target project.

[0016] In some implementations, if there is only one table in the last-level directory, determining the section structure based on the directory hierarchy structure includes:

[0017] Using the directory hierarchy structure, determining whether the directory hierarchy of the engineering bid document exceeds a preset length;

[0018] If the directory hierarchy of the engineering bidding document does not exceed the preset length, the bid section structure is determined based on the directory hierarchy structure.

[0019] The method for reading the quotation content in the engineering bid provided by the embodiment of the present invention analyzes the obtained directory hierarchy structure before determining the section structure to determine whether the target hierarchy exceeds the preset length. The section structure is determined only within the preset length to further ensure the accuracy of the determined section structure.

[0020] In some embodiments, determining the section structure of the target project based on the file structure of the project bidding document to obtain a target table corresponding to each unit project in the target project further includes:

[0021] If the final directory includes at least two tables, read the file names of all tables in the final directory;

[0022] Match the file names of all tables in the final directory with the table name field of the preset fee table to determine a matching result;

[0023] If there is a file name matching the table name field of the preset fee table in the file names of all tables in the final directory, all tables in the final directory are merged to determine the target table corresponding to the unit project.

[0024] The method for reading the quotation content in the engineering bid provided by an embodiment of the present invention, if there are at least two tables in the last-level directory, determines whether it is necessary to merge the at least two tables based on the matching results between the table file names and the table fields of the preset cost table, so as to organize the last-level directory into a standard directory structure, thereby ensuring that the target table corresponding to the unit project can be determined, that is, improving the recognition success rate of the target table.

[0025] In some embodiments, determining the section structure of the target project based on the file structure of the project bidding document to obtain a target table corresponding to each unit project in the target project further includes:

[0026] If there is no file name matching the table name field of the preset fee table among the file names of all the tables in the final directory, create folders corresponding to the file names of all the tables in the final directory and move the corresponding tables to the folders with the same names, so as to update the file structure of the engineering bid document;

[0027] The updated file structure is used to determine the section structure of the target project to obtain the target table corresponding to each unit project in the target project.

[0028] The method for reading the quotation content in the engineering bid provided by an embodiment of the present invention, when there is no file name matching the table name field of the preset cost table, organizes the directory structure into a standard directory structure by additionally creating a folder with the same name, so as to further improve the recognition success rate of the target table.

[0029] In some embodiments, determining the section structure of the target project based on the names of the unit projects in the table page of the project bidding document to obtain the target table corresponding to each unit project in the target project includes:

[0030] Determining the list form in the engineering annotation document by using the similarity between the page signature name of each form in the engineering bid document and the name of the list cost table;

[0031] Analyze the cell contents of the list table to determine the names of all unit projects in the target project;

[0032] Determining the bid section structure based on the preset separator in the unit project name;

[0033] Based on the unit project names in all tables in the engineering bidding document, the tables are mapped to the unit projects to obtain the target tables corresponding to the unit projects.

[0034] The method for reading quotation content in a project bid provided by an embodiment of the present invention is designed to first identify the list table, then extract the unit project name from the list table, and then obtain the bid section structure, in the case where multiple tables are set under different tabs of the same table. In this case, the list table is first identified, and then the unit project name is extracted from the list table to obtain the bid section structure. This method is applicable to multi-tab tables, ensuring that the method is applicable to different types of project bid documents.

[0035] In some embodiments, determining the bid section structure based on a preset separator in the unit project name includes:

[0036] Check whether the unit project name contains the preset separator;

[0037] If the unit project name includes the preset separator, the unit project name is decomposed using the preset separator;

[0038] If the unit project name does not include the preset separator, the unit project name that does not include the preset separator is determined to be the section name to determine the section structure.

[0039] The method for reading the quotation content in the engineering bid provided by the embodiment of the present invention uses preset separators to decompose the unit project name to obtain the bid section structure, thereby ensuring the accuracy of the obtained bid section structure.

[0040] In some embodiments, the step of mapping a table to a unit project based on the unit project names in all tables in the project bidding document to obtain a target table corresponding to the unit project includes:

[0041] Analyze the cell contents of all tables in the engineering bid document to determine the unit project name corresponding to each table in the engineering bid document;

[0042] By using the unit project names corresponding to the various tables in the engineering bidding document, the various tables are matched with the unit projects to obtain the target tables corresponding to the unit projects.

[0043] The method for reading quotation content in an engineering bid provided by an embodiment of the present invention analyzes the cell content of all tables in the engineering bid file to obtain the unit project name corresponding to each table, and then matches each table with the unit project to obtain the target table corresponding to the unit project, thereby improving the accuracy of matching between the unit project and the target table.

[0044] In some implementations, matching the page tab of the target table with a table name field of a preset fee table to determine the fee table corresponding to the target table includes:

[0045] Obtaining the table name field and the weight of each preset fee table;

[0046] Segment the page tabs of the target table to obtain fields to be matched;

[0047] Calculate the similarity between the to-be-matched field and the table name field to obtain the field similarity of the table name field;

[0048] Determining the similarity between the target table's tab and the preset fee table based on the product of the field similarity of the table name field and the weight of the table name field;

[0049] The fee table corresponding to the target table is determined based on the similarity.

[0050] The method for reading the quotation content in the engineering bid provided by the embodiment of the present invention sets a corresponding weight for the table name field, and then determines the similarity with the tab and the preset cost table based on the field similarity of the table name field combined with the weight of the table name field. The introduction of the weight of the table name field improves the accuracy of the obtained similarity, thereby improving the accuracy of the cost table corresponding to the determined target table.

[0051] In some embodiments, extracting data from a target table of a corresponding unit project based on a cell field of the cost table to generate a target cost table corresponding to each unit project includes:

[0052] Extracting the contents of the target table and storing them in the form of key-value pairs to generate a target dictionary, where the key of the target dictionary is the column index of the target table and the value of the key is the contents of all cells in the column where the column index is located;

[0053] Matching the column indexes with the cell fields of the expense table corresponding to the target table, respectively, to determine the corresponding relationship between the column indexes and the cell fields;

[0054] The data type of the value of the target dictionary is identified based on the corresponding relationship to extract the value of the target dictionary to generate a target cost table corresponding to the unit project.

[0055] The method for reading quotation content in a project bid provided by an embodiment of the present invention organizes the contents of a target table into a target dictionary before analyzing the contents, which helps to improve the performance of data analysis in subsequent steps.

[0056] According to a second aspect, an embodiment of the present invention further provides a device for reading quotation content in a project bid document, the device comprising:

[0057] An acquisition module, configured to acquire a project bidding document of a target project, wherein the project annotation document includes a plurality of tables;

[0058] a determination module, configured to determine the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain a target table corresponding to each unit project in the target project;

[0059] A matching module, configured to match the page tab of the target table with the table name field of a preset fee table to determine the fee table corresponding to the target table;

[0060] The generating module is used to extract data from the target table of the corresponding unit project based on the cell fields of the cost table to generate the target cost table corresponding to each unit project.

[0061] According to the third aspect, an embodiment of the present invention provides an electronic device, comprising: a memory and a processor, the memory and the processor being communicatively connected to each other, the memory storing computer instructions, and the processor executing the computer instructions to execute the method for reading the quotation content in the engineering bid document described in the first aspect or any one of the embodiments of the first aspect.

[0062] According to the fourth aspect, an embodiment of the present invention provides a computer-readable storage medium, which stores computer instructions, and the computer instructions are used to enable the computer to execute the method for reading the quotation content in the engineering bid document described in the first aspect or any one of the embodiments of the first aspect.

[0063] It should be noted that the corresponding beneficial effects of the device, electronic device and computer-readable storage medium for reading quotation contents in engineering bid documents provided in the embodiments of the present invention can be found in the description of the corresponding beneficial effects of the method for reading quotation contents in engineering bid documents above, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0064] In order to more clearly illustrate the specific embodiments of the present invention or the technical solutions in the prior art, the following briefly introduces the drawings required for use in the specific embodiments or the description of the prior art. Obviously, the drawings described below are some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0065] Figure 1 is a schematic diagram of a presentation format of a project bidding document according to an embodiment of the present invention;

[0066] Figure 2 is a schematic diagram of a presentation format of a project bidding document according to an embodiment of the present invention;

[0067] Figure 3 is a schematic diagram of a method for reading quotation content in a project bid document according to an embodiment of the present invention;

[0068] Figure 4 is a schematic diagram of a method for reading quotation content in a project bid document according to an embodiment of the present invention;

[0069] Figure 5 is a schematic diagram of a method for reading quotation content in a project bid document according to an embodiment of the present invention;

[0070] Figure 6 is a schematic diagram of a method for reading quotation content in a project bid document according to an embodiment of the present invention;

[0071] Figure 7is a schematic diagram of a table name field and a weight of the table name field of a preset fee table according to an embodiment of the present invention;

[0072] Figure 8 is a schematic diagram of similarity calculation according to an embodiment of the present invention;

[0073] Figure 9 is a schematic diagram of column index matching according to an embodiment of the present invention;

[0074] Figure 10 is a schematic diagram of value matching according to an embodiment of the present invention;

[0075] Figure 11 This is a structural block diagram of a device for reading quotation content in a project bid document according to an embodiment of the present invention;

[0076] Figure 12 It is a schematic diagram of the hardware structure of the electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0077] To make the purpose, technical solutions, and advantages of the embodiments of the present invention more clear, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative efforts shall fall within the scope of protection of the present invention.

[0078] In the construction industry, various software tools can be used to calculate project costs. For example, during the bidding process, after using pricing software to compile a bill of quantities, tenderers will export the entire project bid document into a spreadsheet, such as Excel, to maintain confidentiality and maintain software compatibility. This spreadsheet is then provided to the construction party for bill of quantities price calculation.

[0079] Taking the Excel spreadsheet as an example, the Excel spreadsheet to be imported needs to be able to present the overall structure of the bidding section, single item, and unit project, as well as the cost composition of each project. Figure 1 and Figure 2 Currently, the Excel table to be imported presents the bidding structure and cost composition in two forms: (1) Figure 1 The folder structure in the table format: use the folder structure to reflect the project components, and use the sheet tabs in the Excel table to reflect various costs; (2) Figure 2The Excel table in the sheet is stacked in the sheet tab manner, which arranges all components and their costs in sequence. The sheet tab stacking method means that all business tables of all unit projects are included in one Excel table.

[0080] After the construction party obtains the work sheet, it needs to import the relevant contents in the list into the pricing software one by one, and then prepare the quotation after the pricing software identifies the relevant contents. Let's take the Excel sheet as an example to illustrate. The number of manual import operations required is: the number of Excel sheets × the number of sheet tabs.

[0081] In particular, during the bid clearance phase, Party A needs to copy and paste all bid information into a separate Excel spreadsheet in order to compare all bidders' bids. Then, they can use the embedded formulas in the Excel spreadsheet to view the corresponding data. This number of operations requires a multiplication of the number of Excel spreadsheets and the number of sheet tabs.

[0082] For example, if there are 10 unit projects and quotations from 10 bidding units to be checked, it is necessary to check three types of cost tables belonging to three sheet tabs: detailed item list, total price measures, and other items. In this case, the number of repeated copy and pastes required is: 10 × 10 × 3 = 300 times.

[0083] It can be seen that no matter in which form the Excel table is presented, importing the relevant contents in the list into the pricing software one by one requires a lot of manual import and copy-paste operations. The manual operation volume is huge and the process is relatively cumbersome.

[0084] Based on this, an embodiment of the present invention provides a method for reading the quotation content in a project bid document. By automatically analyzing the project bid document, the method obtains the bid section structure of the target project and the target tables corresponding to each unit project. Based on this, the method matches the target table's page tabs with the table name field of a preset cost table to determine the cost table corresponding to the target table, thereby generating the target cost table corresponding to each unit project.

[0085] For the convenience of the following description, the terms involved in the following embodiments are explained as follows:

[0086] (1) Section, single item, unit project: the components of a construction project that are gradually broken down.

[0087] (2) Cost table: The cost composition of the unit project is divided into a list of sub-items, other items, measures items, etc., which can carry detailed quotations for each part.

[0088] (3) Bill of Quantities: The basic cost items for completing the project will be broken down into a bill of quantities.

[0089] (4) Bid evaluation: Party A needs to compare and analyze the bid documents of multiple bidding units during the bid evaluation process and select the best bid proposal for the project.

[0090] According to an embodiment of the present invention, an embodiment of reading the quotation content in an engineering bid is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer-executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described can be executed in an order different from that shown here.

[0091] In this embodiment, a method for reading the quotation content in a project tender document is provided, which can be used in electronic devices such as computers, mobile phones, tablet computers, etc. Figure 3 FIG. 1 is a flow chart of a method for reading quotation content in a project bidding document according to an embodiment of the present invention. Figure 3 As shown, the process includes the following steps:

[0092] S11, obtaining the engineering bidding documents of the target project.

[0093] Wherein, the engineering annotation file includes multiple tables.

[0094] Project bid documents are electronic documents that present the relevant content of the project bid in the form of a spreadsheet. There are no restrictions on how to obtain the project bid document. You can import a folder containing multiple spreadsheets or a single spreadsheet, as long as the electronic device can access the spreadsheet-formatted project bid document.

[0095] S12, determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain the target table corresponding to each unit project in the target project.

[0096] In this embodiment, different methods are used to determine the section structure of the target project for different forms of engineering bidding documents. That is, based on the form of the engineering bidding document, the method for determining the section structure is determined; based on the determination method, the section structure of the target project in the engineering bidding document is determined. Among them, the determination method includes determining the section structure of the target project based on the file structure of the engineering bidding document, and determining the section structure of the target project based on the name of the unit project in the table page. The form of the engineering bidding document includes the form of a folder nested table, that is, the engineering bidding document includes multiple tables, and these tables are respectively located in tables of different levels; or, the form of the engineering bidding document includes a multi-page tab form, that is, all tables of all unit projects are included in one table file.

[0097] The bidding section structure is a component of a construction project that is gradually broken down into sections, items, and unit projects. In related technologies, when the engineering bidding document is presented in the form of a folder set in a worksheet, the construction party's preparation process requires manual establishment of the bidding section structure of the construction project, such as sections, items, and unit projects. Under each bidding section structure, the cost tables are selected one by one and imported into the corresponding worksheet. However, the pricing software can only read the data in one tab of the worksheet at a time. When the engineering bidding document is presented in the form of multiple tabs in a worksheet, the tendering party still needs to manually establish the bidding section structure, such as sections, items, and unit structures, during the inspection process. When importing the cost table under each bidding section structure, it is necessary to set the reading standard of each tab in the cost table, that is, which page and which row of data needs to be imported. This process can read all the tabs in a worksheet at one time, but the overall setting process is cumbersome. Once the data in some tables does not meet the requirements, batch reading errors will occur.

[0098] Based on this, this embodiment automatically reads out the project, single item, unit project and other section structures of the entire engineering project instead of relying solely on manual processing, thereby reducing the degree of manual participation and avoiding possible erroneous operations that may occur when a large number of people are involved in identification.

[0099] For engineering bidding documents in the form of folder-based tables, the section structure can be determined by analyzing its directory structure, and then the target table corresponding to each unit project can be determined based on the table in the last-level directory; for engineering bidding documents in the form of multiple tabs, first query the list table, obtain the section structure based on the list table, and then correspond each table to each unit project to obtain the target table corresponding to each unit project.

[0100] S13, matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table.

[0101] In construction projects, the cost table is the cost composition of the unit project, and the cost table can be divided into types: detailed item list, other items, measures items, etc. The above types of cost tables can carry detailed quotations for each part, and all or part of the cost table types can be selected as the above preset cost table types.

[0102] Through the bid section structure that has been identified and read, the corresponding preset fee table type is matched for each tab, that is, the preset fee table type that the tab best matches, which reduces the degree of manual participation, improves the content reading efficiency, and avoids as much as possible the misoperation caused by manual participation in setting the preset fee table type. Moreover, since the relevant matching is based on the bid section structure in this step, the bid section structure and the preset fee table type have been matched with the tabs in the engineering bid document at this time, which provides convenience for more accurate identification of business data in the tabs in the subsequent process.

[0103] In some embodiments, the matching process may be performed by analyzing and breaking down the tab name based on a pre-trained word segmentation algorithm. The algorithm then determines the pre-set fee table type that best matches the tab, i.e., the fee table category to which the tab belongs, based on similarity and weight values. If the pre-trained intelligent word segmentation algorithm fails to match the tab with a qualifying fee table, the user can manually select a pre-set fee table type that matches the tab.

[0104] Of course, the matching method of the table name field is not limited to the method described above, and other methods can also be used. The specific settings are based on actual needs and are not limited here.

[0105] S14, extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project.

[0106] After obtaining the expense tables corresponding to each target table, column matching and row matching are performed with the target table based on the cell fields in the expense table, thereby extracting data from the target table to generate the target expense tables corresponding to each unit project. The specific implementation of column matching and row matching can use a pre-trained field recognition model, regular expressions, or other methods, and is not limited here.

[0107] The method for reading the quotation content in the engineering bid provided in this embodiment analyzes the section structure of the target project and the target table corresponding to each unit project in the target project by utilizing the file structure of the engineering bid file or the name of the unit project in the table page, so that data can be read from engineering bid files of multiple links to cope with multiple folder structures or large form structures, and the section structure of the entire project and the target table corresponding to each unit project can be intelligently read to avoid corresponding data tables one by one; at the same time, on this basis, the page tab of the target table is matched with the table name field of the preset cost table to obtain the cost table corresponding to the target table, so as to extract data from the target table to obtain the target cost table corresponding to the unit project, and realize the disassembly and identification of the project components and related costs from the engineering bid file, avoiding batch reading errors of the engineering bid file due to some business data not meeting the requirements, and effectively improving the efficiency and accuracy of engineering bid file reading while reducing the degree of manual participation.

[0108] In this embodiment, a method for reading quotation content in a project bid document is provided, which can be used in electronic devices such as computers, mobile phones, tablet computers, etc. In this embodiment, a detailed description is given in the form of a project bid document in the form of a file set table. Figure 4 FIG. 1 is a flow chart of a method for reading quotation content in a project bidding document according to an embodiment of the present invention. Figure 4 As shown, the process includes the following steps:

[0109] S21, obtaining the project bidding documents of the target project.

[0110] Wherein, the engineering annotation file includes multiple tables.

[0111] For details, please see Figure 3 S11 of the illustrated embodiment will not be described in detail here.

[0112] S22, determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain the target table corresponding to each unit project in the target project.

[0113] Specifically, the above S22 includes:

[0114] S221, query the file directory of the engineering bidding document to determine the last directory and the directory hierarchy structure.

[0115] When importing folders, the bidding section structure is analyzed based on the directory hierarchy of the project bidding document. The directory hierarchy supports up to five levels. However, the maximum supported hierarchy level is not limited to five and is determined based on actual needs. This is not a limitation.

[0116] For engineering bid documents in the form of a file package, the first level is the project level, the last level is the unit project level, and the middle level is the individual project level. The project name and individual project name are consistent with the folder name at the corresponding level for easy identification.

[0117] When querying the file directory of a project bid document, the system first checks whether each directory has subdirectories. If no subdirectories exist, it reads all Excel files in that directory, treating each Excel file as a unit project, and returns a bid section structure tree generated based on the current structure. If subdirectories exist, it reads all the bottom-level directories (i.e., the final directory) one by one. Based on this, the directory hierarchy of the project bid document can be obtained.

[0118] S222: If there is only one table in the last-level directory, determine the section structure based on the directory hierarchy structure.

[0119] After the above steps, the final directory of the project bid document is determined, and then whether each final directory contains only one form. Because in this multi-layer folder structure, the final directory is considered a unit project, and each unit project is only allowed to have one form. If there is only one form in the final directory, the bid section structure is generated based on the directory hierarchy.

[0120] In some embodiments, the above S222 includes:

[0121] (1) Using the directory hierarchy structure, determine whether the directory hierarchy of the engineering bidding document exceeds the preset length.

[0122] (2) If the directory hierarchy of the engineering bidding document does not exceed the preset length, the bidding section structure is determined based on the directory hierarchy structure.

[0123] Before determining the bid section structure, it's necessary to determine whether the directory hierarchy meets the requirements. Specifically, determine whether the target hierarchy exceeds a preset length, such as the five levels mentioned above. If the directory hierarchy of the engineering bid document does not exceed the preset length, the bid section structure is generated based on the target hierarchy. If it does, it is considered non-compliant and a reminder can be given to the user, allowing the engineering bid document to be checked.

[0124] In some implementations, in addition to checking whether the target level exceeds a preset length, it is also checked whether all longest file paths exceed the system limit. If so, a reminder is also given to the user.

[0125] Before determining the section structure, the obtained directory hierarchy structure is analyzed to determine whether the target hierarchy exceeds the preset length. The section structure is determined only if it is within the preset length to further ensure the accuracy of the determined section structure.

[0126] S223: Determine that the last-level directory is the file directory of the unit project, and the table in the last-level directory is the target table corresponding to the unit project.

[0127] After the above checks, if all conditions are met, each final-level directory is determined to be the file directory of the unit project, and the table in each final-level directory is the target table corresponding to the unit project. For example, if there are three final-level directories, and each of these three final-level directories contains only one table, then these three final-level directories correspond to three unit projects respectively. Then, the tables in the final-level directories are matched with the unit projects to obtain the target table corresponding to the unit project.

[0128] S224: If the last-level directory includes at least two tables, read the file names of all tables in the last-level directory.

[0129] If one or more of the final directories contain at least two tables, further analysis and file processing of the table file names in all final directories is required. Specifically, the file names of all tables in each final directory are read in sequence for subsequent matching with the expense table.

[0130] S225, matching the file names of all tables in the final directory with the table name field of the preset fee table to determine the matching result.

[0131] The extracted file names are matched against the table name fields of each pre-set fee table. Matching methods include, but are not limited to, utilizing a pre-trained field matching model or performing similarity calculations after text vectorization, etc. After the matching process, the resulting matching results include whether or not a file name in all table file names matches the table name field of the pre-set fee table.

[0132] S226: If the file names of all tables in the final directory contain a file name that matches the table name field of the preset expense table, all tables in the final directory are merged to determine the target table corresponding to the unit project.

[0133] If there is at least one file name among all the file names that matches the table name field of the preset cost table, at least two tables in the last-level directory will be merged into one table, which will be used as the target table corresponding to the unit project.

[0134] In some embodiments, the above S22 further includes:

[0135] (1) If there is no file name matching the table name field of the preset cost table in the file names of all tables in the last-level directory, create folders corresponding to the file names of all tables in the last-level directory and move the corresponding tables to the folders with the same names to update the file structure of the engineering bid document.

[0136] (2) Use the updated file structure to determine the section structure of the target project to obtain the target table corresponding to each unit project in the target project.

[0137] If no file name matches the table name field in the pre-set cost table, the tables will be processed as unit projects. Specifically, a new folder will be created within the final directory, with the name of the new folder using the table's file name in the final directory. The corresponding table will then be moved into this new folder with the same name. This ensures that there is only one table in the final directory. In this case, the creation of the new folder changes the file structure of the project bid document. Therefore, the updated file structure will need to be used to re-determine the target project's section structure to obtain the target tables corresponding to each unit project within the target project.

[0138] If no file name matches the name field of the pre-set expense table, the directory structure is reorganized into a standard directory structure by creating an additional folder with the same name, further improving the recognition success rate of the target table. After the above processing, the table will continue to be checked, such as whether the file has been opened in Excel (in editing mode) and whether the Excel file can be opened and the content can be read correctly.

[0139] After obtaining the bid section structure, the bid section structure and the target table are mapped one-to-one. Among them, the cost table data of the unit project is located in the last folder. During the import process, this data will be read into the software interface and displayed to the user.

[0140] The fee table data in the bid section structure corresponds one-to-one with the tabs in the table. To ensure that the tabs in the target table accurately correspond to the preset fee tables, the page signatures are subsequently broken down using an intelligent word segmentation algorithm, and the fee table that best matches the tab is determined based on the weighted value. If no matching fee table is found, the user can still manually select a matching fee table.

[0141] S23, matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table.

[0142] For details, please see Figure 3 S13 of the illustrated embodiment will not be described in detail here.

[0143] S24 , extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project.

[0144] For details, please see Figure 3 S14 of the illustrated embodiment will not be described in detail here.

[0145] The method for reading the quotation content in the engineering bid provided in this embodiment analyzes the file directory of the engineering bid document in the form of a folder-set table to obtain the bid section structure. In the folder-set table format, the first layer is the project department engineering level, the last layer is the unit engineering level, and the middle layer is the single project level with a hierarchical structure. When there is only one table in the last-level directory, the bid section structure and the file directory of the unit project can be obtained. The level-by-level analysis improves the accuracy of the obtained bid section structure and the target project. If there are at least two tables in the last-level directory, it is determined whether the at least two tables need to be merged based on the matching results of the table file names and the table fields of the preset cost table to organize the last-level directory into a standard directory structure to ensure that the target table corresponding to the unit project can be determined, that is, to improve the recognition success rate of the target table.

[0146] In this embodiment, a method for reading quotation content in a project bid document is provided, which can be used in electronic devices such as computers, mobile phones, tablet computers, etc. In this embodiment, a project bid document is described in detail in the form of multiple tabs. Figure 5 FIG. 1 is a flow chart of a method for reading quotation content in a project bidding document according to an embodiment of the present invention. Figure 5 As shown, the process includes the following steps:

[0147] S31, obtaining the project bidding document of the target project.

[0148] Wherein, the engineering annotation file includes multiple tables.

[0149] For details, please see Figure 3 S11 of the illustrated embodiment will not be described in detail here.

[0150] S32, determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain the target table corresponding to each unit project in the target project.

[0151] Specifically, the above S32 includes:

[0152] S321, using the similarity between the page signature name of each table in the engineering bid document and the name of the bill cost table, determine the bill table in the engineering annotation file.

[0153] For a project bid document, the system first checks its status, such as whether it is currently being edited and whether it can be loaded correctly. If so, it then reads all the checklist pages in the bid document. Specifically, it searches all tables in the bid document to obtain their page names. Using a word segmentation algorithm, it calculates the similarity between each page name and the name of the checklist expense table. It then selects those with a similarity above a preset weight and identifies them as the identified checklist table.

[0154] S322: Analyze the cell contents of the list table to determine the names of all unit projects in the target project.

[0155] The cell contents of the list table obtained in S321 are analyzed, and the unit project names are analyzed in the first three rows of each list table. This is done by examining each cell row and column by row to determine whether its content begins with "Project Name" or whether the cell content in the previous row and column contains "Project Name." Ultimately, all unit project names are obtained. If no unit project name is found, the current file itself is treated as a unit project file.

[0156] S323, determine the section structure based on the preset separator in the unit project name.

[0157] After determining the unit project names, the multiple unit project names are analyzed to obtain the bid section structure. Specifically, unit project names typically include preset delimiters that separate the names into multiple segments. These segments are then used as bid sections, individual items, and specific names. By analyzing the preset delimiters, a tree-like bid section structure is generated.

[0158] In some embodiments, the above S323 includes:

[0159] (1) Check whether the unit project name contains the preset separator.

[0160] (2) If the unit project name contains preset separators, the unit project name is decomposed using the preset separators.

[0161] (3) If the unit project name does not include the preset separator, the unit project name that does not include the preset separator is determined as the section name to determine the section structure.

[0162] If delimiters are included, all unit project names are broken down by the delimiters, generating a tree-like section structure. If delimiters are not used, the section name is the unit project name. Each unit project name is placed directly under the section node, forming the section structure. By breaking down the unit project names using the preset delimiters to generate the section structure, the accuracy of the resulting section structure is guaranteed.

[0163] S324, based on the unit project names in all tables in the project bidding document, the tables are mapped to the unit projects to obtain the target tables corresponding to the unit projects.

[0164] In some embodiments, the above S324 includes:

[0165] (1) Analyze the cell contents of all tables in the engineering bidding document to determine the unit project name corresponding to each table in the engineering bidding document.

[0166] (2) Using the unit project names corresponding to each table in the engineering bidding document, each table is matched with the unit project to obtain the target table corresponding to the unit project.

[0167] After the bid section structure is generated, it is also necessary to establish the relationship between each table in the engineering bid document and the corresponding unit project. To this end, the program sets a dictionary of key-value type, the key name is the unit project name, and the corresponding value is a list. At this time, all tables are traversed again, and the unit project name in the table is read according to the method in S322, and the table is placed in the list of the corresponding key name (unit project name). Finally, all tables will correspond to the corresponding unit project. At this point, the target table corresponding to each unit project is obtained.

[0168] By analyzing the cell contents of all tables in the engineering bidding document, the unit project names corresponding to each table are obtained, and then each table is matched with the unit project to obtain the target table corresponding to the unit project, thereby improving the accuracy of the matching between the unit project and the target table.

[0169] S33, matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table.

[0170] For details, please see Figure 3 S13 of the illustrated embodiment will not be described in detail here.

[0171] S34, extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project.

[0172] For details, please see Figure 3 S14 of the illustrated embodiment will not be described in detail here.

[0173] The method for reading the quotation content in a project bid document provided in this embodiment is suitable for situations where multiple tables are arranged on different tabs of the same table. In this case, the table in the project bid document includes multiple tabs, each tab corresponding to a table. In this case, the list table is first identified, and then the unit project name is extracted from the list table to obtain the bid section structure. This method is applicable to the form of a multi-tab table, ensuring that the method is applicable to different forms of project bid documents.

[0174] In this embodiment, a method for reading the quotation content in a project tender document is provided, which can be used in electronic devices such as computers, mobile phones, tablet computers, etc. Figure 6 FIG. 1 is a flow chart of a method for reading quotation content in a project bidding document according to an embodiment of the present invention. Figure 6 As shown, the process includes the following steps:

[0175] S41, obtaining the project bidding documents of the target project.

[0176] Wherein, the engineering annotation file includes multiple tables.

[0177] For details, please see Figure 3 S11 of the illustrated embodiment will not be described in detail here.

[0178] S42, determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain the target table corresponding to each unit project in the target project.

[0179] For details, please see Figure 4 S22 of the embodiment shown, or Figure 5 S32 of the illustrated embodiment will not be described in detail here.

[0180] S43, matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table.

[0181] Specifically, the above S43 includes:

[0182] S431, obtaining the table name field and the weight of the table name field of each preset fee table.

[0183] Preset cost tables typically include multiple table name fields to accommodate different usage habits. For example, for a sub-item bill table, the corresponding table name fields include "Sub-item Bill of Quantities Pricing Table" and "Distributed Sub-item Works and Unit Price Measure Item Bill of Quantities Pricing Table." Of course, this is just an example; other table name fields can also be used, depending on actual needs.

[0184] Different table name fields correspond to different weights, and the sum of the weights of table name fields belonging to the same preset fee table is 100. For example, Figure 7 A schematic diagram showing the table name fields of 4 preset fee tables and their corresponding weights.

[0185] S432: Segment the page tabs of the target table to obtain fields to be matched.

[0186] Get the tabs in the target table and perform word segmentation on them to obtain multiple fields to be matched. The specific word segmentation method is set according to actual needs and is not limited here.

[0187] S433: Calculate the similarity between the field to be matched and the table name field to obtain the field similarity of the table name field.

[0188] S434 : Determine the similarity between the page tab of the target table and the preset fee table based on the product of the field similarity of the table name field and the weight of the table name field.

[0189] For each tab in the target table, the similarity comparison will be performed with each preset expense table and all table name fields in the preset expense table according to the weight and accumulated. The algorithm for calculating the similarity is to segment the two strings to be compared and obtain a collection of segmented words. Then check the frequency of these segmented words in each string separately, and use the cosine similarity algorithm to calculate the similarity of the two strings. For example, the tab is named "Table 1-5 Unit Engineering Cost Summary Table", and it is matched with "Sub-item List", "Total Price Measures", and "Unit Engineering Cost Summary". For example, Figure 8 The results of similarity calculation are shown.

[0190] S435 , determining the fee table corresponding to the target table based on the similarity.

[0191] After the similarities between the tabs of all target tables and the table name fields of the preset fee table are calculated, the table with the highest similarity is found for each preset fee table from the calculation results, thereby determining the matching relationship between the preset fee table and the tab, that is, obtaining the fee table corresponding to each target table.

[0192] S44, extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project.

[0193] Specifically, the above S44 includes:

[0194] S441 , extract the contents of the target table and store them in the form of key-value pairs to generate a target dictionary.

[0195] The key of the target dictionary is the column index of the target table, and the value of the key is the content of all cells on the column where the column index is located.

[0196] At this point, the section structure and fee table have been intelligently matched with the tabs of the target table in the engineering bid document, and the user is guided to the data row and column identification interface. In this interface, business data will be automatically identified for the data on the corresponding tabs based on different preset fee tables and their corresponding data identification rules. The identification process consists of two parts: column identification and row identification. Column identification is used to identify the correspondence between each column in the target table and the fee table field. Row identification is used to identify whether the data in a row of the target table is a fee table record (or business data) or an invalid row. Users can adjust the system's row and column identification results, and the scope of the adjustment can be to affect only the current unit project or all unit projects in the current project.

[0197] Specifically, the target table's contents are read one by one based on the selected expense table. This process is performed row by row and column by column, and stored in a target dictionary. The key of the target dictionary is the index of each column, and the corresponding value is the contents of all cells in that column, in the form of a list of strings. Furthermore, when reading cell data, necessary processing can be performed, such as removing line breaks and spaces, to increase the accuracy of subsequent analysis.

[0198] S442: Match the column indexes with the cell fields of the expense table corresponding to the target table to determine the corresponding relationship between the column indexes and the cell fields.

[0199] For each fee table, it defines the cell fields and keyword class table used to identify the column. For example, Figure 9 The cell fields of the sub-item list are shown, and the cell fields and their corresponding column identification keywords are as follows: Figure 9 As shown, multiple keywords are separated by commas.

[0200] The goal of this matching is to determine the correspondence between column indexes and fee table fields. Therefore, for each column index, all fields and their corresponding keywords in the current fee table are compared against the column index to determine which field best matches the column index, thereby identifying the field in the fee table to which the column belongs.

[0201] The specific comparison method is: traverse all column indexes, and use the fields of the fee table one by one to calculate the proportion of the column index relative to the current field. When calculating the proportion, start traversing from the first row of the current column (that is, the first cell of the column), determine whether its content contains the identification keyword of the traversed field, and calculate its proportion. The so-called proportion refers to the ratio of the length of the keyword to the character length of the cell content. For example, if the content of the cell is "List Serial Number", when using the "Serial Number" keyword of the "Serial Number" field to calculate the proportion, the proportion of the cell relative to the "Serial Number" field is 2 / 4, that is, 50%; if the cell content is "Serial Number", the proportion is 1. If the cell content does not contain all the keywords specified by the current field, the proportion is 0.

[0202] For each cell, calculate the highest percentage of all keywords in the current field for that cell and use this as the cell's percentage. Once all cells have calculated their percentages for the current field, find the highest percentage value and use it as the column's percentage for the current field. Once all columns have calculated their highest percentages for the current field, find the highest percentage among these percentages. The column with the highest percentage is considered the matching column for the current field. This algorithm continues until all columns have been identified, determining the correspondence between column indexes and cell fields.

[0203] S443: Identify the data type of the target dictionary value based on the corresponding relationship to extract the target dictionary value to generate a target cost table corresponding to the unit project.

[0204] Data type identification defines the conditions that a field in a row must meet, such as "name" must contain at least one character, "quantity" must be a number, etc. The field rules are required to be expressed in the form of regular expressions. Figure 10 As shown, taking the "Sub-item List" as an example, the expense table can contain the following line types: sub-item and list.

[0205] Each value in the current column index is traversed and validated against all row identification rules in the current cost table. For each rule found, the required field value is obtained and validated against the corresponding field rule. If a matching rule is found, the row type is confirmed. If the row does not meet all rules, it is marked as "unrecognized." Rows marked "unrecognized" can be manually adjusted by the user. At this point, the target dictionary values are extracted to generate the target cost table for the unit project.

[0206] The method for reading the quotation content in the engineering bid provided in this embodiment sets a corresponding weight for the table name field. Based on the field similarity obtained for the table name field, the weight of the table name field is combined to determine the similarity between the page tab and the preset fee table. The introduction of the weight of the table name field improves the accuracy of the obtained similarity, thereby improving the accuracy of the fee table corresponding to the target table. Before analyzing the content of the target table, it is first organized into a target dictionary, which helps to improve the performance of data analysis in subsequent steps.

[0207] It should be noted that the above description is for reading a project description document. If two bidding documents or even multiple bidding documents need to be compared simultaneously during the bid clearance process, the section structures of the bidding and bidding documents need to be intelligently matched.

[0208] Intelligent Matching: Both forms read the bid section structure as described above. The matching process follows a hierarchical hierarchy, first matching project items, then individual items and unit projects. A complete match is considered complete when the bid and tender information are completely identical. If some projects cannot be completely matched, a percentage of duplication is set and fuzzy matching is performed. If fuzzy matching is still insufficient, manual matching is performed.

[0209] This method elevates the original manual recognition of table tabs to full-process intelligent machine recognition and intelligent data reading, reducing manual effort throughout the entire process. It can handle a variety of table formats, including folder-based tables and multi-tab formats, covering 90% of the construction industry's pricing Excel spreadsheet possibilities and being suitable for a wide range of scenarios.

[0210] This embodiment also provides a device for reading the quotation content in a project bid document. This device is used to implement the above-mentioned embodiments and preferred embodiments, and the details already described will not be repeated. As used below, the term "module" can refer to a combination of software and / or hardware that implements a predetermined function. Although the devices described in the following embodiments are preferably implemented in software, implementation using hardware, or a combination of software and hardware, is also possible and contemplated.

[0211] This embodiment provides a device for reading the quotation content in a project bidding document, such as Figure 11 As shown, including:

[0212] An acquisition module 51 is used to acquire a project bidding document of a target project, wherein the project annotation document includes a plurality of tables;

[0213] A determination module 52 is configured to determine the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain a target table corresponding to each unit project in the target project;

[0214] A matching module 53 is used to match the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table;

[0215] The generating module 54 is configured to extract data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project.

[0216] In some embodiments, the determination module 52 includes:

[0217] A query unit, configured to query the file directory of the engineering bidding document and determine the last directory and the directory hierarchy structure;

[0218] A first determining unit is configured to determine the bid section structure based on the directory hierarchy structure if there is only one table in the last-level directory;

[0219] The second determining unit is configured to determine that the final directory is a file directory of the unit project, and that a table in the final directory is a target table corresponding to the unit project.

[0220] In some embodiments, the first determining unit includes:

[0221] A first determining subunit is configured to determine, using the directory hierarchy structure, whether the directory hierarchy of the engineering bidding document exceeds a preset length;

[0222] The second determining subunit is configured to determine the bid section structure based on the directory hierarchy structure if the directory hierarchy of the engineering bidding document does not exceed the preset length.

[0223] In some implementations, the determination module 52 further includes:

[0224] A reading unit, configured to read the file names of all tables in the final directory if the final directory includes at least two tables;

[0225] A first matching unit is used to match the file names of all tables in the final directory with the table name field of the preset fee table to determine a matching result;

[0226] A merging unit is used to merge all the tables in the final directory if there is a file name matching the table name field of the preset fee table in the file names of all the tables in the final directory to determine the target table corresponding to the unit project.

[0227] In some implementations, the determination module 52 further includes:

[0228] a creating unit, configured to create folders corresponding to the file names of all the tables in the final directory and move the corresponding tables to the folders with the same names, if no file name matching the table name field of the preset fee table exists among the file names of all the tables in the final directory, so as to update the file structure of the engineering bid document;

[0229] The third determining unit is used to determine the section structure of the target project using the updated file structure to obtain a target table corresponding to each unit project in the target project.

[0230] In some embodiments, the determination module 52 includes:

[0231] a fourth determining unit, configured to determine the list form in the engineering annotation document by using the similarity between the page signature name of each form in the engineering bid document and the name of the list cost table;

[0232] An analysis unit, configured to analyze the cell contents of the list table to determine the names of all unit projects in the target project;

[0233] A fifth determining unit, configured to determine the bid section structure based on a preset separator in the unit project name;

[0234] The corresponding unit is used to correspond the table to the unit project based on the unit project name in all tables in the engineering bidding document, and obtain the target table corresponding to the unit project.

[0235] In some embodiments, the fifth determining unit includes:

[0236] A query subunit, used for querying whether the unit project name contains the preset separator;

[0237] a disassembling subunit, configured to disassemble the unit project name using the preset separator if the unit project name includes the preset separator;

[0238] The third determining subunit is configured to determine, if the unit project name does not include the preset separator, that the unit project name not including the preset separator is a bid section name, so as to determine the bid section structure.

[0239] In some embodiments, the corresponding unit includes:

[0240] An analysis subunit, configured to analyze the cell contents of all tables in the engineering bid document to determine the unit project name corresponding to each table in the engineering bid document;

[0241] The corresponding subunit is used to use the unit project names corresponding to the various tables in the engineering bidding document to correspond the various tables to the unit projects, and obtain the target table corresponding to the unit projects.

[0242] In some embodiments, the matching module 53 includes:

[0243] an acquiring unit, configured to acquire a table name field and a weight of the table name field of each of the preset fee tables;

[0244] A word segmentation unit, used to segment the page tabs of the target table to obtain fields to be matched;

[0245] a calculation unit, configured to calculate a similarity between the to-be-matched field and the table name field to obtain a field similarity of the table name field;

[0246] a fifth determining unit, configured to determine a similarity between the page tab of the target table and the preset fee table based on a product of the field similarity of the table name field and the weight of the table name field;

[0247] A sixth determining unit is configured to determine a fee table corresponding to the target table based on the similarity.

[0248] In some embodiments, the generation module 54 includes:

[0249] an extraction unit, configured to extract the contents of the target table and store them in the form of key-value pairs to generate a target dictionary, wherein the key of the target dictionary is the column index of the target table, and the value of the key is the contents of all cells in the column where the column index is located;

[0250] a second matching unit, configured to match the column indexes with the cell fields of the expense table corresponding to the target table, respectively, to determine a correspondence between the column indexes and the cell fields;

[0251] An identification unit is used to identify the data type of the value of the target dictionary based on the corresponding relationship, so as to extract the value of the target dictionary to generate a target cost table corresponding to the unit project.

[0252] The device for reading the quotation content in the engineering bid in this embodiment is presented in the form of a functional unit, where the unit refers to an ASIC circuit, a processor and memory that executes one or more software or fixed programs, and / or other devices that can provide the above functions.

[0253] The further functional description of each of the above modules is the same as that of the above corresponding embodiments and will not be repeated here.

[0254] An embodiment of the present invention further provides an electronic device having the above Figure 11 The device shown is for reading the quotation content in the engineering bidding document.

[0255] See also Figure 12 , Figure 12 is a structural diagram of an electronic device provided by an optional embodiment of the present invention, such as Figure 12 As shown, the electronic device may include: at least one processor 61, such as a CPU (Central Processing Unit), at least one communication interface 63, a memory 64, and at least one communication bus 62. The communication bus 62 is used to realize the connection and communication between these components. The communication interface 63 may include a display screen (Display), a keyboard (Keyboard), and the optional communication interface 63 may also include a standard wired interface and a wireless interface. The memory 64 may be a high-speed RAM memory (Random Access Memory, volatile random access memory) or a non-volatile memory (non-volatile memory), such as at least one disk memory. The memory 64 may optionally be at least one storage device located away from the aforementioned processor 61. The processor 61 may be combined with Figure 11 In the described apparatus, the memory 64 stores an application program, and the processor 61 calls the program code stored in the memory 64 to execute any of the above method steps.

[0256] The communication bus 62 may be a peripheral component interconnect (PCI) bus or an extended industry standard architecture (EISA) bus. The communication bus 62 may be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 12 Only one thick line is used in the diagram, but this does not mean that there is only one bus or one type of bus.

[0257] Among them, the memory 64 may include volatile memory (English: volatile memory), such as random-access memory (English: random-access memory, abbreviated: RAM); the memory may also include non-volatile memory (English: non-volatile memory), such as flash memory (English: flash memory), hard disk drive (English: hard disk drive, abbreviated: HDD) or solid-state drive (English: solid-state drive, abbreviated: SSD); the memory 64 may also include a combination of the above types of memory.

[0258] The processor 61 may be a central processing unit (CPU), a network processor (NP), or a combination of a CPU and a NP.

[0259] The processor 61 may further include a hardware chip. The hardware chip may be an application-specific integrated circuit (ASIC), a programmable logic device (PLD), or a combination thereof. The PLD may be a complex programmable logic device (CPLD), a field-programmable gate array (FPGA), a generic array logic (GAL), or any combination thereof.

[0260] Optionally, the memory 64 is further configured to store program instructions. The processor 61 may call the program instructions to implement a method for reading the quotation content in a project bid document as shown in any embodiment of the present application.

[0261] An embodiment of the present invention further provides a non-transitory computer storage medium storing computer-executable instructions capable of executing the method for reading the quotation content in the engineering bid document in any of the above-mentioned method embodiments. The storage medium may be a magnetic disk, an optical disk, a read-only memory (ROM), a random access memory (RAM), a flash memory, a hard disk drive (HDD), or a solid-state drive (SSD); the storage medium may also include a combination of the above-mentioned types of memory.

[0262] Although the embodiments of the present invention have been described with reference to the accompanying drawings, those skilled in the art may make various modifications and variations without departing from the spirit and scope of the present invention. Such modifications and variations are all within the scope defined by the appended claims.

Claims

1. A method for reading the quotation content in a project bidding document, characterized in that: The method comprises: Obtaining a project bidding document for a target project, wherein the project bidding document includes a plurality of tables; Determining the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain target tables corresponding to the respective unit projects in the target project; Matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table; Extracting data from the target table of the corresponding unit project based on the cell fields of the cost table to generate a target cost table corresponding to each unit project; The section structure of the target project is determined based on the file structure of the project bidding document to obtain the target table corresponding to each unit project in the target project, including: Query the file directory of the engineering bidding document to determine the last directory and the directory hierarchy structure; If there is only one table in the last-level directory, the section structure is determined based on the directory hierarchy structure; It is determined that the final directory is the file directory of the unit project, and the table in the final directory is the target table corresponding to the unit project.

2. The method according to claim 1, characterized in that If there is only one table in the last-level directory, determining the section structure based on the directory hierarchy structure includes: Using the directory hierarchy structure, determining whether the directory hierarchy of the engineering bid document exceeds a preset length; If the directory hierarchy of the engineering bidding document does not exceed the preset length, the bid section structure is determined based on the directory hierarchy structure.

3. The method according to claim 1, characterized in that Determining the section structure of the target project based on the file structure of the project bidding document to obtain a target table corresponding to each unit project in the target project also includes: If the final directory includes at least two tables, read the file names of all tables in the final directory; Match the file names of all tables in the final directory with the table name field of the preset fee table to determine a matching result; If there is a file name matching the table name field of the preset fee table in the file names of all tables in the final directory, all tables in the final directory are merged to determine the target table corresponding to the unit project.

4. The method according to claim 3, characterized in that The determining of the bid section structure of the target project based on the file structure of the project bidding document to obtain a target table corresponding to each unit project in the target project further includes: If there is no file name matching the table name field of the preset fee table among the file names of all the tables in the final directory, create folders corresponding to the file names of all the tables in the final directory and move the corresponding tables to the folders with the same names, so as to update the file structure of the engineering bid document; The updated file structure is used to determine the section structure of the target project to obtain the target table corresponding to each unit project in the target project.

5. The method according to claim 1, wherein Determining the section structure of the target project based on the names of the unit projects in the table page of the project bidding document to obtain target tables corresponding to the unit projects in the target project includes: Determining the list form in the engineering bid document by using the similarity between the page signature name of each form in the engineering bid document and the name of the list cost table; Analyze the cell contents of the list table to determine the names of all unit projects in the target project; Determining the bid section structure based on the preset separator in the unit project name; Based on the unit project names in all tables in the engineering bidding document, the tables are mapped to the unit projects to obtain the target tables corresponding to the unit projects.

6. The method according to claim 5, characterized in that The determining of the bid section structure based on the preset separator in the unit project name includes: Check whether the unit project name contains the preset separator; If the unit project name includes the preset separator, the unit project name is decomposed using the preset separator; If the unit project name does not include the preset separator, the unit project name that does not include the preset separator is determined to be the section name to determine the section structure.

7. The method according to claim 5, characterized in that The method of mapping the table to the unit project based on the unit project name in all tables in the engineering bidding document to obtain the target table corresponding to the unit project includes: Analyze the cell contents of all tables in the engineering bid document to determine the unit project name corresponding to each table in the engineering bid document; By using the unit project names corresponding to the various tables in the engineering bidding document, the various tables are matched with the unit projects to obtain the target tables corresponding to the unit projects.

8. The method according to claim 1, characterized in that The step of matching the page tab of the target table with the table name field of the preset fee table to determine the fee table corresponding to the target table includes: Obtaining the table name field and the weight of each preset fee table; Segment the page tabs of the target table to obtain fields to be matched; Calculate the similarity between the to-be-matched field and the table name field to obtain the field similarity of the table name field; Determining the similarity between the target table's tab and the preset fee table based on the product of the field similarity of the table name field and the weight of the table name field; The fee table corresponding to the target table is determined based on the similarity.

9. The method according to claim 1, characterized in that The cell fields based on the cost table extract data from the target table of the corresponding unit project to generate a target cost table corresponding to each unit project, including: Extracting the contents of the target table and storing them in the form of key-value pairs to generate a target dictionary, where the key of the target dictionary is the column index of the target table and the value of the key is the contents of all cells in the column where the column index is located; Matching the column indexes with the cell fields of the expense table corresponding to the target table, respectively, to determine the corresponding relationship between the column indexes and the cell fields; The data type of the value of the target dictionary is identified based on the corresponding relationship to extract the value of the target dictionary to generate a target cost table corresponding to the unit project.

10. A device for reading quotation content in a project bidding document, characterized in that: The device comprises: An acquisition module, configured to acquire a project bidding document of a target project, wherein the project bidding document includes a plurality of tables; a determination module, configured to determine the section structure of the target project based on the file structure of the project bidding document or the names of the unit projects in the table page, so as to obtain a target table corresponding to each unit project in the target project; A matching module, configured to match the page tab of the target table with the table name field of a preset fee table to determine the fee table corresponding to the target table; A generating module, configured to extract data from a target table of a corresponding unit project based on the cell fields of the cost table, so as to generate a target cost table corresponding to each unit project; The section structure of the target project is determined based on the file structure of the project bidding document to obtain the target table corresponding to each unit project in the target project, including: Query the file directory of the engineering bidding document to determine the last directory and the directory hierarchy structure; If there is only one table in the last-level directory, the section structure is determined based on the directory hierarchy structure; It is determined that the final directory is the file directory of the unit project, and the table in the final directory is the target table corresponding to the unit project.

11. An electronic device, characterized in that: include: A memory and a processor, wherein the memory and the processor are communicatively connected to each other, the memory stores computer instructions, and the processor executes the method for reading the quotation content in the engineering bid document according to any one of claims 1 to 9 by executing the computer instructions.

12. A computer-readable storage medium, characterized in that The computer-readable storage medium stores computer instructions, and the computer instructions are used to enable a computer to execute the method for reading the quotation content in the engineering bid document according to any one of claims 1 to 9.

Images