Method and product suitable for rapid output of international engineering BOQ quotation data

Abstract

The invention discloses a method and a product suitable for rapid output of international engineering BOQ quotation data, and aims to solve the problems that a bidding quotation process in the prior art is large in workload, easy to make mistakes and low in efficiency, and an Excel function is relatively high in threshold and inconvenient to operate. According to the content of each Sheet page, the Sheet page is defined as an invalid page, a summary page or a list page; when a formula exists in the original BOQ file, analyzing a formula reference relationship between cells, determining BOQ in a list page data row, recording an address of the BOQ, creating a BOQ object and associating the BOQ object with the address, and generating a corresponding calculation formula; performing pricing on the BOQ objects to obtain a comprehensive unit price of the BOQ, and calculating a BOQ combined price and a summarized total price according to a corresponding calculation formula; according to the method, the BOQ file with the final quotation data and the original BOQ file are subjected to one-to-one mapping of the cells, so that rapid output of the quotation data is realized, the bidding work efficiency of international engineering is effectively improved, and the error probability is reduced.

Description

Technical Field

[0001] The present application relates to the technical field of international engineering bidding and quotation, and in particular to a method and product suitable for outputting BOQ quotation data for international engineering. Background Art

[0002] During the bidding stage of international projects, most project owners will provide a bill of quantities (BOQ) file, usually in PDF format or Excel format with formula links. The BOQ items usually consist of thousands or even tens of thousands of items. Bidders are required to fill in the BOQ bid unit price, total price, and total price data, and strictly follow the format of the original file, otherwise they may not be able to make a substantive response to the bidding documents. The BOQ bid unit price is composed of direct costs and indirect cost allocations, and needs to be obtained through a relatively complex price combination process.

[0003] At present, the common practice in the industry for bidding and quoting international projects is that the bidder imports the BOQ file in Excel format (or Excel format converted from PDF) provided by the owner into the quotation software, assembles the price of the BOQ in the quotation software, and uses the report generation function of the software to export the Excel file with price information, and links the exported file with the original Excel file by manually editing the formula, so as to output the price data such as the bidding unit price, total price and summary total price to the owner's BOQ file. However, this method is labor-intensive, error-prone, inefficient, and has a high threshold for using Excel functions and is inconvenient to operate. Summary of the invention

[0004] This application provides a method and product suitable for the rapid output of BOQ quotation data for international projects, aiming to solve the problems of the existing bidding and quotation process, which is heavy workload, prone to errors, low efficiency, high threshold for using Excel functions, and inconvenient operation.

[0005] First, a method for quickly outputting BOQ quotation data for international projects, the method comprising:

[0006] Step S1, read in all Sheet pages of the BOQ file, and define each Sheet page as an invalid page, a summary page or a list page according to its content; wherein the invalid page is a Sheet page irrelevant to the calculation and output of quotation data; the list page is a Sheet page containing a BOQ list; the summary page is a Sheet page containing BOQ total price summary information, and the summary page not only contains the BOQ total price summary information of a specific sub-project or the entire project, but also allows the summary to be made to the upper level in a multi-level project structure;

[0007] Step S2, when there are formulas in the original BOQ file, the relationship between Sheet pages is generated by analyzing the formula reference relationship between cells, confirming the data reference relationship between the list page and the summary page, and confirming the data reference relationship between summary pages of different levels in a multi-level project structure; when there are no formulas in the original BOQ file, the relationship between Sheet pages is generated by manually specifying the relationship;

[0008] Step S3, determine the BOQ in the data row of the list page, record its address, create a BOQ object and associate it with the address, and generate a corresponding calculation formula; identify the data row type related to data reference and summary, and generate a corresponding calculation formula according to the logical relationship between each data row; when there is a calculation formula in the original BOQ file, directly use the existing calculation formula of the original BOQ file; determine the summary items in the data row of the summary page, and generate a corresponding calculation formula according to the data reference relationship between the list page or the next-level summary page;

[0009] Step S4, repeating step S3 until the data row type determination and calculation formula generation of all list pages and summary pages, as well as the summary page and its next-level summary page are completed; when the formula exists in the original BOQ file, skip the part of generating the corresponding calculation formula in the above step S3, and directly use the existing formula;

[0010] Step S5, group the prices of any BOQ objects to obtain the comprehensive unit price of the BOQ, and fill the comprehensive unit price into the BOQ unit price data column; calculate the BOQ total price and the summary total price according to the corresponding calculation formula;

[0011] Step S6, repeating step S5 until the price combination of all BOQ objects in all Sheet pages is completed, and the unit price, total price data, and summary total price data of all BOQs are obtained;

[0012] Step S7, mapping the BOQ file with the final quotation data to the original BOQ file in a one-to-one manner, and linking the data, thus completing the rapid output of the BOQ quotation data.

[0013] In the above scheme, further optionally, the step S3 specifically includes: finding any list page, determining the BOQ in the data row by automatic identification combined with manual modification, recording the address of the BOQ, generating an actual data object for the identified BOQ, and establishing a corresponding relationship between the BOQ object and the address, and generating a corresponding calculation formula in the total price column corresponding to the BOQ row; wherein the total price calculation formula is: total price = unit price × project quantity.

[0014] In the above scheme, optionally, step S3 also includes: according to specific keywords, identifying the data row type related to data reference and aggregation by regular expression matching, and generating corresponding calculation formulas according to the logical relationship between each data row.

[0015] In the above scheme, further optionally, it also includes: when the data row type is to go to the next page, the logic of automatically generating the corresponding calculation formula is to find the previous data row A of the type to go to the next page, and sum the cells of all the valence columns from row A+1 to the previous row of the current row;

[0016] When the data row type is "Continue from previous page", the logic of automatically generating the corresponding calculation formula is to find the cell in the price column of the previous data row type "Continue to next page" and take the value of the cell in the price column; if there is no such cell, an error message will be given;

[0017] When the data row type is transfer to summary page, the logic of automatically generating the corresponding calculation formula is to find the previous data row A of transfer to next page type, or transfer to summary page B, and sum all the cells in the value column from row A+1 or B+1 to the previous row of the current row.

[0018] The above scheme may optionally also include: in the summary page corresponding to the list page or the lower-level summary page, identifying the summary item data row, and automatically generating the summary item calculation formula logic by, in accordance with the order of the summary items in the summary page from front to back, taking the values ​​of the total price column cells of the row where the data row of the type of transfer summary page is located in the associated list page or lower-level summary page.

[0019] In the above solution, optionally, the step S7 also includes: to ensure efficiency, the link data only links cells filled with data and automatically generated formulas.

[0020] In the second aspect, a device suitable for quickly outputting BOQ quotation data for international projects, the device comprises an original table sample module and a price group module; wherein:

[0021] The original form sample module is used to receive the original BOQ file, and is responsible for the identification and display of the owner's BOQ data, the generation and maintenance of association relationships, the automatic generation of corresponding calculation formulas, the display and maintenance of the Sheet page level, and the output of the final quotation;

[0022] The price grouping module is used to group prices according to the identified BOQ, and fill the calculated BOQ unit price into the cell of the corresponding address in the original table sample module according to the association relationship.

[0023] In the above scheme, further optionally, it includes:

[0024] The original table sample module supports analyzing the cell reference relationship between existing calculation formulas in the original BOQ file, and intuitively displays the logical relationship between the list page and the summary page and its parent summary page in the form of a tree, with the list page as a child node and its summary page as a parent node. The summary page node allows the existence of a parent summary page node, and supports multi-layer nesting;

[0025] The original table module also supports formula calculations between cells. When the price combination module fills the unit price of a BOQ into the cell of the corresponding address in the original table, the original table module will be automatically recalculated to update the total price related to the BOQ and the values ​​of the related data references and summary cells.

[0026] The BOQ data row in the original table sample module and the BOQ object row in the price combination module support mutual jump and positioning;

[0027] The original table sample module supports viewing the corresponding calculation formula automatically generated in a specified cell, and can analyze the source relationship of the cell reference and display it intuitively. Clicking the source cell address can quickly jump, and supports quick modification of the automatically generated corresponding calculation formula;

[0028] The original table sample module supports automatic linking of cell data in the original table sample module with cell data at corresponding positions in the original BOQ file by using the secondary development interface provided by Excel when the quotation data is output.

[0029] In a third aspect, a computer program product comprises a computer program / instruction, which implements the steps of the method described above when executed by a processor.

[0030] Compared with the prior art, this application has at least the following beneficial effects:

[0031] Based on further analysis and research of existing technical problems, this application recognizes that in the current bidding quotation for international projects, bidders need to link the exported files with the original Excel format files using formulas. The reason for using the link method is that the original BOQ file is relatively special in terms of paging and data typesetting. The format of the original BOQ file cannot be completely restored by generating reports through software. In addition, some Excel files with formula links provided by owners are encrypted, and data can only be filled in or linked on the original Excel files, otherwise the bidding process cannot be completed normally. However, this method is labor-intensive, error-prone, inefficient, and has a high threshold for using Excel functions and is inconvenient to operate.

[0032] This application changes the traditional method of only importing BOQ data, and instead imports all row and column information of the original BOQ file into the software, establishes an association between BOQ data and group price data within the software, and automatically fills in the BOQ unit price calculation results. At the same time, by analyzing the logical relationship between data rows and between each Sheet page in the BOQ file, it automatically generates a summary calculation formula, or directly uses an existing calculation formula, thereby realizing the automatic generation of all BOQ quotation data. Since the imported BOQ file is completely consistent with the original BOQ file in terms of rows and columns, the quotation data can be quickly output directly through a one-to-one mapping of cell data, thereby effectively improving the bidding efficiency of international projects and reducing the probability of errors.

[0033] When there is no calculation formula in the original BOQ file, the existing technology requires manual editing of the calculation formula in Excel, which is a lot of work. This application automatically generates calculation formulas based on the logical relationship between data rows within the Sheet page and the reference relationship between the Sheet pages, which greatly improves work efficiency and reduces the probability of errors caused by manual operations.

[0034] Due to the "bidirectional relationship" of one-to-one mapping of cells adopted in this application, the trouble of searching data through Excel functions in the prior art is avoided, and the time for data linking is greatly shortened. BRIEF DESCRIPTION OF THE DRAWINGS

[0035] Figure 1 A flowchart of a method for quickly outputting BOQ quotation data for international projects provided in the first embodiment of the present application.

[0036] Figure 2 A flowchart of a method for quickly outputting BOQ quotation data for international projects provided in the second embodiment of the present application.

[0037] Figure 3 A schematic diagram of presenting each Sheet page in a tree structure is provided for one embodiment of the present application. DETAILED DESCRIPTION

[0038] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.

[0039] In the description of the present application: unless otherwise specified, expressions such as “include”, “comprising”, “having”, etc. also mean “not limited to” (certain units, components, materials, steps, etc.).

[0040] At present, the common practice in the industry for bidding and quoting international projects is that the bidder imports the BOQ file in Excel format (or Excel format converted from PDF) provided by the owner into the quotation software, assembles the price of the BOQ in the quotation software, and uses the report generation function of the software to export the Excel file with price information, and uses the exported file to link the original Excel file using formulas, so as to output the price data such as the bidding unit price, total price and summary total price to the owner's BOQ file. The reason why the link method is needed in this process is that the original BOQ file is relatively special in terms of paging and data layout. The format of the original BOQ file cannot be completely restored by generating reports through software, and some Excel files with formula links provided by owners are encrypted, so data can only be filled in or linked on the original Excel file, otherwise the bidding process cannot be completed normally.

[0041] The bidding and quotation process in the prior art has the following problems:

[0042] (1) Importing the owner's Excel BOQ file only imports the BOQ data in the file without any format information. After importing, it has no relationship with the source file. This is a one-way process. After completing the price combination, you need to manually establish the corresponding relationship between the data rows and the source file.

[0043] (2) When formula linking is performed in Excel software, the row association relationship between the exported Excel file and the original BOQ Excel file needs to be manually processed, which is labor-intensive and prone to errors. Once the formula linking is completed, the exported Excel file cannot add or subtract rows, and is not easy to modify and adjust;

[0044] (3) If a more flexible method is adopted to allow the exported Excel file to still be linked to the original BOQ file after a certain degree of editing (such as adding or deleting rows) in the later stage, Excel functions (such as vLookup) are generally used to achieve data matching by searching by number in the specified area. This method has a high threshold for use, and the calculation time is long when linking the data, which affects work efficiency;

[0045] (4) If there is no calculation formula in the owner's bill of quantities Excel file, the bidder needs to compile the formula by himself, which requires manual operation. For large projects, there are usually dozens or even hundreds of sheets, and each row and each page in each sheet needs to be processed one by one, which is a huge workload;

[0046] (5) The traditional method requires data aggregation, formula linking and data checking in Excel, but the sheet organization method of Excel cannot intuitively reflect the logical relationship between the data on the sheet pages. When a project has dozens or even hundreds of sheet pages, the operation is extremely inconvenient.

[0047] The present application aims to provide a method to solve the many drawbacks of the prior art and realize the rapid output of BOQ quotation data, thereby effectively improving the bidding efficiency of international projects and reducing the probability of errors.

[0048] In one embodiment, reference Figure 1 , provides a method suitable for quickly outputting BOQ quotation data for international projects, and the method specifically includes steps S1 to S7.

[0049] Step S1, read in all Sheet pages of the BOQ file, and define each Sheet page as an invalid page, summary page or list page according to its content; wherein, an invalid page is a Sheet page that is irrelevant to the calculation and output of quotation data; a list page is a Sheet page containing a BOQ list; a summary page is a Sheet page containing BOQ total price summary information, and the summary page not only contains the BOQ total price summary information of a specific sub-project or the entire project, but also in a multi-level project structure, the summary page allows summary to the upper level.

[0050] Step S2, when there are formulas in the original BOQ file, the relationship between the Sheet pages is generated by analyzing the formula reference relationship between cells, confirming the data reference relationship between the list page and the summary page, and confirming the data reference relationship between summary pages of different levels in a multi-level project structure; when there are no formulas in the original BOQ file, the relationship between the Sheet pages is generated by manual specification.

[0051] Step S3, determine the BOQ in the data row of the list page, record its address, create a BOQ object and associate it with the address, and generate a corresponding calculation formula; identify the data row type related to data reference and summary, and generate a corresponding calculation formula based on the logical relationship between each data row; when there is a calculation formula in the original BOQ file, directly use the existing calculation formula of the original BOQ file; determine the summary items in the data row of the summary page, and generate a corresponding calculation formula based on the data reference relationship between the list page or the next-level summary page.

[0052] Step S4, repeat step S3 until the data type determination and corresponding calculation formula generation of all list pages and summary pages, as well as the summary page and its next-level summary page are completed; when the formula exists in the original BOQ file, skip the part of generating the corresponding calculation formula in the above step S3 and directly use the existing formula.

[0053] Step S5, group the prices of any BOQ objects to obtain the comprehensive unit price of the BOQ, and fill the comprehensive unit price into the BOQ unit price data column; calculate the BOQ total price and the summary total price according to the corresponding calculation formula.

[0054] Step S6, repeat step S5 until the group price of all BOQ objects in all Sheet pages is completed, and the unit price, total price data, and summary total price data of all BOQs are obtained.

[0055] Step S7, mapping the BOQ file with the final quotation data to the original BOQ file in a one-to-one manner, and linking the data, thus completing the rapid output of the BOQ quotation data.

[0056] This application changes the traditional method of only importing BOQ data, and instead imports all row and column information of the original BOQ file into the software, establishes an association between BOQ data and group price data within the software, and automatically fills in the BOQ unit price calculation results. At the same time, by analyzing the logical relationship between data rows and between each Sheet page in the BOQ file, a summary calculation formula is automatically generated, thereby realizing the automatic generation of all BOQ quotation data. Since the imported BOQ file is completely consistent with the original BOQ file in terms of rows and columns, the quotation data can be quickly output directly through a one-to-one mapping of cell data.

[0057] In this embodiment, the specific process for quickly outputting BOQ quotation data for international projects is as follows:

[0058] 1. Read all Sheet pages of BOQ file, and define Sheet pages as invalid pages (InvalidPage), summary pages (SummaryPage) or list pages (BOQ Page) according to the content of each page. Pages that are not related to quotation data calculation and output are judged as invalid pages, those containing BOQ lists are judged as list pages, and those containing BOQ price summary information are judged as summary pages. Summary pages can also continue to summarize to the upper level.

[0059] 2. If there are formulas in the original BOQ file, the formula reference relationship between cells is automatically analyzed, and the relationship between Sheet pages is automatically generated, that is, the summary page corresponding to the list page and the parent summary page of the summary page (if any) are found. If there are no formulas in the original BOQ file, the relationship between Sheet pages is generated by manual specification.

[0060] 3. Find a certain list page, determine the BOQ in the data row through automatic recognition combined with manual modification, record the address of the BOQ (Sheet page and row number), generate an actual data object for the identified BOQ, and establish a corresponding relationship between the BOQ object and its address. At the same time, automatically generate a calculation formula in the "Total Price" column corresponding to the BOQ row. The logic is: Total Price = Unit Price * Project Quantity, and retain 2 decimal places.

[0061] 4. In the list page of step 3, the data row types related to data reference and summary are identified by regular expression matching based on specific keywords, and the calculation formula is automatically generated based on the logical relationship between the data rows. See the table below for details:

[0062]

[0063]

[0064] 5. Similarly, on the summary page corresponding to the list page (or lower-level summary page) in step 4, identify the "Summary Item" data row as follows:

[0065]

[0066] 6. If there is already a calculation formula in the original BOQ file, skip the step of automatically generating the corresponding calculation formula in the above steps and directly use the existing calculation formula in the original BOQ file.

[0067] 7. Repeat steps 3 and 4 to complete the generation of BOQ association relationships and the automatic generation of corresponding calculation formulas in all list pages.

[0068] 8. Group the price for any BOQ object to get the comprehensive unit price of BOQ, find the "unit price" data column in the address where BOQ is located, automatically fill in the comprehensive unit price, and automatically calculate the BOQ total price and the total price according to the generated formula.

[0069] 9. Repeat step 8 to obtain the unit price, total price data, and summary total price data of all BOQ data rows in all Sheet pages.

[0070] 10. Map the BOQ file with the final quotation data obtained in step 9 to the original BOQ file on a one-to-one basis, and link the data (to ensure efficiency, only link the cells filled with data and automatically generated formulas), thus completing the rapid output of the BOQ quotation data.

[0071] Through the method for quickly outputting BOQ quotation data for international projects provided in the above embodiment, the present application achieves:

[0072] ① The problem of losing the data association relationship with the original BOQ file after importing BOQ data in the existing technology has been changed, and the "one-way relationship" has been changed to a "two-way relationship" with one-to-one mapping of cell data.

[0073] ② In the case where there is no calculation formula in the original BOQ file, the existing technology requires manual editing of the calculation formula in Excel, which is a large workload. This application automatically generates calculation formulas based on the logical relationship between data rows within the Sheet page and the reference relationship between the Sheet pages, which greatly improves work efficiency and reduces the probability of errors caused by manual operations.

[0074] ③ Due to the "bidirectional relationship" of one-to-one mapping of cells adopted in this application, the trouble of data search through Excel functions in the prior art is avoided, which greatly shortens the time of data linking.

[0075] ④ The various Sheet pages in the existing Excel technology are presented in an intuitive tree structure, which intuitively reflects the data reference relationship between the various Sheet pages. Data search and positioning are more convenient and faster than in Excel, which can better improve the user experience. Figure 3 , Figure 3 The relationship between each Sheet page (i.e. invalid page, list page and summary page) is intuitively displayed in a tree structure. In the figure, "3.PMU_CC3_EPROS_TA3_1" represents the root node of the Excel file, that is, the node that organizes all the Sheet pages in the Excel file; "Pricing Schedule", "ACC3.1", "ACC3.4.1", "ACC3.4.2", and "ACC3.5" represent invalid pages; "Collection CC3" represents the upper-level summary page; "Collection CC3.1", "Collection CC3.2", etc. represent the lower-level summary page of the "Collection CC3" summary page; "Collection CC3.2.1" is the lower-level summary page of "Collection CC3.2"; "CC3.2", "CC3.2.1", etc. represent the list page; Figure 3 It brings together the invalid pages, summary pages and list pages mentioned in this application, and intuitively displays the tree structure relationship between list pages and summary pages, as well as summary pages at different levels.

[0076] In one embodiment, a device suitable for quickly outputting BOQ quotation data for international projects is also provided, the device comprising an original table sample module and a price combination module; wherein:

[0077] The original form module is used to receive the original BOQ file and is responsible for the identification and display of the owner's BOQ data, the generation and maintenance of association relationships, the automatic generation of calculation formulas, the display and maintenance of the Sheet page level, and the output of the final quotation;

[0078] The price grouping module is used to group prices based on the identified BOQ, and fill in the calculated BOQ unit price into the cell of the corresponding address in the original table sample module based on the association relationship.

[0079] In one embodiment, the original table sample module supports analyzing the cell reference relationship between the existing calculation formulas in the original BOQ file, and intuitively displays the logical relationship between the list page and the summary page and its parent summary page in the form of a tree, with the list page as a child node and its summary page as a parent node. The summary page node allows the existence of a parent summary page node, and supports multi-layer nesting;

[0080] The original table module also supports formula calculation between cells. When the price combination module fills the unit price of a BOQ into the cell of the corresponding address in the original table, the original table module will be automatically recalculated to update the total price related to the BOQ and the values ​​of the related data references and summary cells.

[0081] In order to facilitate data checking and verification during actual operation, the BOQ data rows in the original table sample module and the BOQ object rows in the price group module support mutual jump and positioning;

[0082] The original table module supports viewing the automatically generated calculation formula in a specified cell, analyzing the source relationship of the cell reference, and intuitively displaying it. Clicking the source cell address can quickly jump to it, and supports quick and convenient modification of the automatically generated calculation formula.

[0083] The original sample module supports automatic linking of the cell data in the original sample module with the cell data at the corresponding position of the original BOQ file by using the secondary development interface provided by Excel when outputting quotation data.

[0084] In one embodiment, a computer program product is also provided, including a computer program / instruction, which implements the steps of the above-mentioned embodiment method when executed by a processor.

[0085] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

Claims

1. A method for quickly outputting BOQ quotation data for international projects, characterized in that: include: Step S1, read in all Sheet pages of the BOQ file, and define each Sheet page as an invalid page, a summary page or a list page according to its content; wherein the invalid page is a Sheet page irrelevant to the calculation and output of quotation data; the list page is a Sheet page containing a BOQ list; the summary page is a Sheet page containing BOQ total price summary information, and the summary page not only contains the BOQ total price summary information of a specific sub-project or the entire project, but also allows the summary to be made to the upper level in a multi-level project structure; Step S2, when there are formulas in the original BOQ file, the relationship between Sheet pages is generated by analyzing the formula reference relationship between cells, confirming the data reference relationship between the list page and the summary page, and confirming the data reference relationship between summary pages of different levels in a multi-level project structure; when there are no formulas in the original BOQ file, the relationship between Sheet pages is generated by manually specifying the relationship; Step S3, determine the BOQ in the data row of the list page, record its address, create a BOQ object and associate it with the address, and generate a corresponding calculation formula; identify the data row type related to data reference and summary, and generate a corresponding calculation formula according to the logical relationship between each data row; when there is a calculation formula in the original BOQ file, directly use the existing calculation formula of the original BOQ file; determine the summary items in the data row of the summary page, and generate a corresponding calculation formula according to the data reference relationship between the list page or the next-level summary page; Step S4, repeating step S3 until the data types of all list pages and summary pages, as well as the summary page and its next-level summary page are determined and the corresponding calculation formulas are generated; when the formula exists in the original BOQ file, skip the part of generating the corresponding calculation formula in the above step S3 and directly use the existing formula; Step S5, group the prices of any BOQ objects to obtain the comprehensive unit price of the BOQ, and fill the comprehensive unit price into the BOQ unit price data column; calculate the BOQ total price and the summary total price according to the corresponding calculation formula; Step S6, repeating step S5 until the price combination of all BOQ objects in all Sheet pages is completed, and the unit price, total price data, and summary total price data of all BOQs are obtained; Step S7, mapping the BOQ file with the final quotation data to the original BOQ file in a one-to-one manner, and linking the data, thus completing the rapid output of the BOQ quotation data.

2. The method for rapid output of BOQ quotation data for international projects according to claim 1 is characterized in that: The step S3 specifically includes: Find any list page, identify the BOQ in the data row through automatic identification combined with manual modification, record the address of the BOQ, generate the actual data object from the identified BOQ, and establish the corresponding relationship between the BOQ object and the address, and generate the corresponding calculation formula in the total price column corresponding to the BOQ row; Among them, the formula for calculating the total price is: total price = unit price × project volume.

3. The method for rapid output of BOQ quotation data for international projects according to claim 1 is characterized in that: The step S3 further comprises: Based on specific keywords, regular expression matching is used to identify the data row types related to data reference and aggregation, and the corresponding calculation formula is generated based on the logical relationship between the data rows.

4. The method for quickly outputting BOQ quotation data for international projects according to claim 3 is characterized in that: Also includes: When the data row type is "roll to next page", the logic of automatically generating the corresponding calculation formula is to find the previous data row A of "roll to next page" type and sum the cells of all the valence columns from row A+1 to the previous row of the current row; When the data row type is "Continue from previous page", the logic of automatically generating the corresponding calculation formula is to find the cell in the price column of the previous data row type "Continue to next page" and take the value of the cell in the price column; If not, an error message is given; When the data row type is transfer to summary page, the logic of automatically generating the corresponding calculation formula is to find the previous data row A of transfer to next page type, or transfer to summary page B, and sum all the cells in the value column from row A+1 or B+1 to the previous row of the current row.

5. The method for rapid output of BOQ quotation data for international projects according to claim 3 is characterized in that: Also includes: In the summary page corresponding to the list page or the lower-level summary page, the summary item data row is identified, and the logic of automatically generating the summary item calculation formula is to take the values ​​of the total price column cells of the row where the data row of the type of transfer summary page is located in the associated list page or the lower-level summary page in turn according to the order of the summary items in the summary page from front to back.

6. The method for rapid output of BOQ quotation data for international projects according to claim 1 is characterized in that: The step S7 also includes: to ensure efficiency, the link data only links cells filled with data and automatically generated formulas.

7. A device suitable for fast output of BOQ quotation data for international projects, characterized in that: The device comprises an original table sample module and a price combination module; wherein, The original form sample module is used to receive the original BOQ file, and is responsible for the identification and display of the owner's BOQ data, the generation and maintenance of association relationships, the automatic generation of corresponding calculation formulas, the display and maintenance of the Sheet page level, and the output of the final quotation; The price grouping module is used to group prices according to the identified BOQ, and fill the calculated BOQ unit price into the cell of the corresponding address in the original table sample module according to the association relationship.

8. The device for rapid output of BOQ quotation data for international projects according to claim 7 is characterized in that: include: The original table sample module supports analyzing the cell reference relationship between existing calculation formulas in the original BOQ file, and intuitively displays the logical relationship between the list page and the summary page and its parent summary page in the form of a tree, with the list page as a child node and its summary page as a parent node. The summary page node allows the existence of a parent summary page node, and supports multi-layer nesting; The original table module also supports formula calculations between cells. When the price combination module fills the unit price of a BOQ into the cell of the corresponding address in the original table, the original table module will be automatically recalculated to update the total price related to the BOQ and the values ​​of the related data references and summary cells. The BOQ data row in the original table sample module and the BOQ object row in the price combination module support mutual jump and positioning; The original table sample module supports viewing the corresponding calculation formula automatically generated in a specified cell, and can analyze the source relationship of the cell reference and display it intuitively. Clicking the source cell address can quickly jump, and supports quick modification of the automatically generated corresponding calculation formula; The original table sample module supports automatic linking of cell data in the original table sample module with cell data at corresponding positions in the original BOQ file by using the secondary development interface provided by Excel when the quotation data is output.

9. A computer program product comprising a computer program / instructions, characterized in that When the computer program / instructions are executed by a processor, the steps of the method according to claim 1 are implemented.

Images