A method and system for structuring list and quotation documents

Abstract

The present application provides a method and system for structuring a list and quotation file, wherein the bidding end configures a bidding list table and uploads the bidding list table to the bidding and procurement trading platform; the bidding end downloads the bidding list table from the bidding and procurement trading platform, fills the bidding list table with quotation data to obtain a bidding quotation table, and uploads the bidding quotation table to the bidding document preparation platform; the bidding document preparation platform generates a TBS bidding encryption file based on the bidding quotation table, and uploads the bidding encryption file to the bidding and procurement trading platform. The above method is adopted to realize the data structuring of irregular lists, i.e., non-national standard lists, which is conducive to data extraction and calculation by the bid opening and evaluation system.

Description

Technical Field

[0001] The present invention relates to the field of computer data processing, and in particular to a method and system for structuring a list and quotation file. Background Art

[0002] In the process of electronic bidding or corporate procurement, it is often necessary to list some detailed lists. These detailed lists are roughly divided into two categories: engineering cost lists with national standards and irregular lists without national standards. At present, most software on the market has realized the data structuring and application of national standard type lists (i.e., engineering cost lists), but irregular lists without national standards cannot be flexibly structured, or even unstructured. In the prior art, it is unstructured and directly uses a complete file to reflect the list / details, such as a completed Excel file or a word or PDF file; if it is structured, the bidders can edit the fields of the corresponding list / details in the specific business system through specific business, and then apply it to other application systems according to the specific definition.

[0003] During the application, it was found that the unstructured complete files could not meet the needs of subsequent applications, such as: it was impossible to automatically check the list / detail data, it was impossible to automatically calculate the list / detail score, etc.; the structured list / detail fields that clearly defined the corresponding business could not meet all business scenarios, and it was impossible to customize the structured data required by all business scenarios indefinitely, resulting in the structuring of irregular lists / detail data without national standard types during the application process, which was limited in subsequent applications and could not meet the demands of all business scenarios. Therefore, how to structure the irregular non-national standard non-engineering cost lists and documents to meet the business scenario needs of data extraction and calculation in the bid opening and evaluation system has become an urgent problem to be solved. Summary of the invention

[0004] In view of this, the purpose of the present invention is to provide a method and system for structuring lists and quotation documents, so as to realize the data structuring of irregular lists, i.e. non-national standard lists, which is conducive to data extraction and calculation by the bid opening and evaluation system.

[0005] In a first aspect, an embodiment of the present application provides a method for structuring a list and quotation document, which is applied to a system for structuring a list and quotation document, wherein the system includes a bidding end, a bidding and procurement transaction platform, a bidding end, and a bidding document preparation platform, and the method includes:

[0006] The bidding terminal configures a bidding list table and uploads the bidding list table to the bidding and procurement transaction platform;

[0007] The bidding end downloads the bidding list from the bidding and procurement transaction platform, fills the bidding list with quotation data to obtain a bidding quotation table, and uploads the bidding quotation table to the bidding document preparation platform;

[0008] The bidding document preparation platform generates a TBS bidding encryption file based on the bidding quotation form, and uploads the bidding encryption file to the bidding and procurement transaction platform.

[0009] Optionally, the configuration bidding list table includes:

[0010] Obtaining bidding list data, and importing the bidding list data into or creating a new editing worksheet;

[0011] Specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation;

[0012] Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area;

[0013] Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column;

[0014] The tender list table is constructed based on a worksheet in which the tender list data area locking is completed, the quotation column marking is completed, and the bidding quotation area column locking is completed.

[0015] Optionally, the method further comprises:

[0016] The bidding end constructs a calculation formula using at least part of the bidding list columns and at least part of the bidding quotation columns as calculation parameters;

[0017] The bidding end configures the calculation formula in the bidding list table.

[0018] Optionally, generating a TBS bid encryption file based on the bid quotation form includes:

[0019] Determining whether the bidding quotation table matches the bidding list table;

[0020] If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

[0021] In a second aspect, an embodiment of the present application provides a system for structuring a list and quotation document, the system comprising a bidding end, a bidding and procurement transaction platform, a bidding end, and a bidding document preparation platform;

[0022] The bidding terminal is used to configure a bidding list and upload the bidding list to the bidding and procurement transaction platform;

[0023] The bidding terminal is used to download the bidding list from the bidding and procurement transaction platform, fill the bidding list with quotation data to obtain a bidding quotation table, and upload the bidding quotation table to the bidding document preparation platform;

[0024] The bidding document preparation platform is used to generate a TBS bidding encryption file based on the bidding quotation form, and upload the bidding encryption file to the bidding and procurement transaction platform.

[0025] Optionally, the configuration bidding list table includes:

[0026] Obtaining bidding list data, and importing the bidding list data into or creating a new editing worksheet;

[0027] Specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation;

[0028] Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area;

[0029] Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column;

[0030] The tender list table is constructed based on a worksheet in which the tender list data area locking is completed, the quotation column marking is completed, and the bidding quotation area column locking is completed.

[0031] Optionally, the bidding terminal is also used for:

[0032] Constructing a calculation formula using at least part of the tender list columns and at least part of the tender price columns as calculation parameters;

[0033] The calculation formula is configured in the bidding list table.

[0034] Optionally, generating a TBS bid encryption file based on the bid quotation form includes:

[0035] Determining whether the bidding quotation table matches the bidding list table;

[0036] If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

[0037] The technical solution provided by this application includes but is not limited to the following beneficial effects:

[0038] This application configures and uploads the bidding list table through the bidding end, downloads and fills the quotation data on the bidding end, and then uploads it to the bidding document preparation platform. The entire process realizes the rapid transmission and processing of the list and quotation documents. Since the bidding document preparation platform can automatically generate TBS bidding encryption files, manual operations are reduced and work efficiency is improved. This application is applicable to the data structuring of irregular lists (non-national standard lists), and non-standardized list data is converted into a structured data format through a unified processing flow. Data standardization helps subsequent data analysis, processing and application, and improves the availability and accuracy of data. The structured data format enables the bid opening and evaluation system to more easily extract and calculate the required data. Accurate data extraction and efficient calculation are important foundations for ensuring that the bid opening and evaluation process is fair, equitable and open. In addition, the TBS bidding encryption file generated by this method has good compatibility with the bidding and procurement transaction platform. This helps to ensure the smooth upload, download and parsing of the bidding documents, and avoids operational obstacles caused by incompatible file formats. The structured list and quotation files make each link in the bidding and procurement process clearer and more transparent, which helps to enhance the trust of all parties in the bidding and procurement process and improve the fairness and fairness of the entire process. In summary, the method and system have the beneficial effects of improving data processing efficiency, realizing data standardization, facilitating data extraction and calculation, enhancing system compatibility, and promoting transparency in the bidding and procurement process. It can realize the data structuring of irregular lists, i.e. non-national standard lists, and is conducive to data extraction and calculation in the bid opening and evaluation system.

[0039] In order to make the above-mentioned objects, features and advantages of the present invention more obvious and easy to understand, preferred embodiments are given below and described in detail with reference to the accompanying drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0040] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0041] Figure 1A flowchart of a method for structuring a list and quotation document provided in the first embodiment of the present invention is shown;

[0042] Figure 2 A flowchart of a method for configuring a bidding list table provided in the first embodiment of the present invention is shown;

[0043] Figure 3 A flow chart of a calculation formula configuration method provided by Embodiment 1 of the present invention is shown;

[0044] Figure 4 A flow chart of a method for generating a TBS bidding encryption file provided in the first embodiment of the present invention is shown;

[0045] Figure 5 A schematic diagram of the structure of a list and quotation document structuring system provided by the second embodiment of the present invention is shown. DETAILED DESCRIPTION

[0046] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. The components of the embodiments of the present invention generally described and shown in the drawings here can be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the drawings is not intended to limit the scope of the claimed invention, but merely represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without making creative work belong to the scope of protection of the present invention.

[0047] Embodiment 1

[0048] To facilitate understanding of this application, Figure 1 The flowchart of a method for structuring a list and quotation document provided in the first embodiment of the present invention is shown to describe the contents of the first embodiment of the present application in detail.

[0049] See also Figure 1 As shown, Figure 1 A flowchart of a method for structuring a list and quotation document provided in Embodiment 1 of the present invention is shown, wherein the method is applied to a system for structuring a list and quotation document, the system comprising a bidding terminal, a bidding and procurement transaction platform, a bidding terminal and a bidding document preparation platform, and the method comprises steps S101 to S103:

[0050] S101: The bidding end configures a bidding list table and uploads the bidding list table to the bidding and procurement transaction platform.

[0051] Specifically, at the beginning of the bidding activity, the bidder (usually the project demander or purchaser) needs to prepare a detailed bidding list. This list lists the detailed specifications, quantities, technical requirements and other information of all items, services or projects to be purchased. The bidding end (i.e. the bidder's system or platform) is responsible for configuring this bidding list to ensure that it accurately reflects the bidder's needs.

[0052] After configuration is completed, the tendering end uploads the tender list to the tendering and procurement trading platform. The tendering and procurement trading platform is a neutral platform or system used to process and manage information exchange and document storage throughout the bidding process. After uploading, the tender list becomes public information for all potential bidders to view and download.

[0053] S102: The bidding end downloads the bidding list form from the bidding and procurement transaction platform, fills the bidding list form with quotation data to obtain a bidding quotation form, and uploads the bidding quotation form to the bidding document preparation platform.

[0054] Specifically, the bidder (i.e., potential supplier or contractor) accesses the bidding and procurement trading platform through the bidding terminal (i.e., the bidder's system or platform) and downloads the bidding list, or manually uploads the bidding list. After downloading, the bidder can carefully study the bidding list to understand the specific needs and expectations of the bidder.

[0055] The bidder lists a price for each item in the tender list based on its own costs, profit expectations and market conditions. These price quotes are entered into the tender list to form a tender quotation sheet. The tender quotation sheet lists in detail the bidder's price for each item, as well as other terms and conditions that may be included. After completing the tender quotation sheet, the bidder uploads it back to the tender document preparation platform.

[0056] S103: The bidding document preparation platform generates a TBS bidding encryption file based on the bidding quotation form, and uploads the bidding encryption file to the bidding and procurement transaction platform.

[0057] Specifically, the bidding document preparation platform uses the bidding document preparation tool to generate encrypted TBS and then uploads it to the bidding and procurement transaction platform for the tenderer and other relevant parties to view and evaluate, and use in the subsequent bid evaluation and decision-making process. These quotation documents usually contain key information such as the bidder's quotation, helping the tenderer make the best choice.

[0058] The quotation document generation method provided in this application can realize the informatization and standardization of bidding activities, improve efficiency, reduce human errors, and ensure the transparency and fairness of the process.

[0059] In an alternative embodiment, see Figure 2 As shown, Figure 2 A flowchart of a method for configuring a bidding list table provided in the first embodiment of the present invention is shown, wherein the configuration of the bidding list table includes steps S201 to S205:

[0060] S201: Acquire bidding list data, and import the bidding list data into or create a new editing worksheet.

[0061] Specifically, import the edited Excel list file (file format: *.xls or *.xlsx) containing the bidding list data or directly edit the list data in the WPS spreadsheet to import the bidding list data into the worksheet.

[0062] S202: specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation.

[0063] Specifically, the bidding end specifies several bidding list columns in the worksheet, and the bidding end identifies the bidding column name, data start row and data end row of each bidding list column based on preset identification rules.

[0064] The bidding end specifies several bid quotation columns in the worksheet, selects the columns in the worksheet where the bidding list data has been specified, and the bidding end identifies the column names of the quotation items in each bid quotation column based on the preset identification rules, and checks each column as a quotation column.

[0065] You can also manually adjust the quotation column through the bidding end. If the quotation column is automatically calculated by setting the formula in Excel, you can manually lock the quotation column (that is, do not allow editing of the quotation, only allow automatic calculation).

[0066] The automatic identification rules for each bidding list column include the automatic identification rules for bidding column names and the automatic identification rules for the start and end rows of data. The automatic identification rules for bidding column names are: extract the first row of non-horizontally merged cells in each bidding list column whose values ​​cannot be empty as the bidding column name. The automatic identification rules for the start and end rows of data are: extract the next row of the column name as the start row of data, and extract the last row with data in the selected column as the end row of data.

[0067] The automatic identification rule of each bid quotation column includes the automatic identification rule of the quotation column name. The automatic identification rule of the quotation column name is: extract the first row of non-horizontally merged cells in each bid quotation column whose values ​​cannot be empty as the quotation column name.

[0068] S203: Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area.

[0069] Specifically, the data start row and the data end row of each bidding list column, and the area between the data start row and the data end row are determined as the bidding list data area in the worksheet. Select the cells in the bidding list data area to lock them, so that the cells in the bidding list data area cannot be edited.

[0070] S204: Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column.

[0071] Specifically, the rows in the column where the bid column name of each bid quotation column is located, and the rows corresponding to the data start row and data end row of each bidding list column, and the area between the data start row and data end row are determined as bid quotation area columns in the worksheet, and the quotation column is specified at the same time. The data designated as the quotation column is the column used for calculation in the bid evaluation system; the bid quotation area column is marked "locked", that is, the bidder does not need to quote, and the quotation data in this column is automatically calculated through other quotations, and there is no need to manually fill in the quotation data in this column.

[0072] You can also manually adjust the position of the quotation column or lock the quotation column according to business needs. Furthermore, if the quotation column is set with an automatic calculation formula, it can be automatically calculated according to the column value set in the formula, without manually filling in the quotation. For this situation, you can set it to "lock" (that is, it cannot be edited, and the result can only be automatically calculated according to the column set in the formula).

[0073] S205: Constructing the bidding list table based on the worksheet that completes locking of the bidding list data area, marking of the quotation column, and locking of the bidding quotation area column.

[0074] Specifically, save the file data of the worksheet that has completed locking the bidding list data area, completing the quotation column marking, and completing locking the bidding quotation area column, save the structured data set in S203 and S204 in json format and compress it into an Excel file, and save all the piece data in a sqlite file and compress it into the Excel file to obtain the bidding list table.

[0075] In an alternative embodiment, see Figure 3 As shown, Figure 3A flowchart of a calculation formula configuration method provided in the first embodiment of the present invention is shown, wherein the method further includes steps S301 to S302:

[0076] S301: The bidding end constructs a calculation formula using at least part of the bidding list columns and at least part of the bidding quotation columns as calculation parameters.

[0077] S302: The bidding end configures the calculation formula in the bidding list table.

[0078] Specifically, the bidding end selects a calculation formula that needs to calculate the list score in a business system, and selects the parameters required in the formula, where the selected parameters are the data columns specified in step S202. The step of setting the list calculation formula can flexibly display whether this step exists according to business needs. When the business needs it, this step is displayed and the selection of the list score calculation formula in this step is flexible and configurable. The calculation formula of the corresponding list score category is configured in an independent calculation rule engine system, and the corresponding calculation formula and its calculation rule description can be displayed here. The parameters used in the calculation formula are a single column of data, and the selectable column data is the data column specified in step S202.

[0079] In an alternative embodiment, see Figure 4 As shown, Figure 4 A flowchart of a method for generating a TBS bidding encryption file provided by the first embodiment of the present invention is shown, wherein the method for generating the TBS bidding encryption file based on the bidding quotation table includes steps S401 to S402:

[0080] S401: Determine whether the bidding quotation table matches the bidding list table.

[0081] S402: If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

[0082] Specifically, the bidding end submits the quoted bid quotation sheet in the form of an Excel file to the bidding and procurement trading platform. The bidding and procurement trading platform automatically identifies whether the json file of the bid Excel quotation file is the quotation file of the corresponding bidding list table. When the quotation file is generated after verification, a sqlite file storing all the data of the Excel quotation file, the list and the quotation is compressed into a TBS bidding encryption file to obtain a TBS format quotation file.

[0083] Each tender list table is pre-configured with a unique table ID. When the tender list table is downloaded for editing and after editing, the table ID does not change, that is, the table ID of the tender quotation table of the tender list table obtained after editing does not change, and should be the same as the table ID of the tender list table. Therefore, when judging whether the tender quotation table matches the tender list table, it is specifically judged whether the table ID of the tender quotation table is the same as the table ID of the tender list table. If they are the same, it means that the tender quotation table matches the tender list table; otherwise, if they are not the same, it means that the tender quotation table does not match the tender list table. If they do not match, the tender quotation table will not be stored.

[0084] The quotation document generation method provided in this application can realize the structured processing of the bill of quantities, non-engineering cost list, and irregular list without national standards, and realize the generation of quotation documents based on the above list data.

[0085] Embodiment 2

[0086] Embodiment 2 of the present invention provides a system for structuring a list and quotation file, see Figure 5 As shown, Figure 5 The schematic diagram of the structure of a list and quotation document structuring system provided by the second embodiment of the present invention is shown, wherein the system includes a bidding terminal 501, a bidding and procurement transaction platform 502, a bidding terminal 503 and a bidding document preparation platform 504:

[0087] The bidding terminal is used to configure a bidding list and upload the bidding list to the bidding and procurement transaction platform;

[0088] The bidding terminal is used to download the bidding list from the bidding and procurement transaction platform, fill the bidding list with quotation data to obtain a bidding quotation table, and upload the bidding quotation table to the bidding document preparation platform;

[0089] The bidding document preparation platform is used to generate a TBS bidding encryption file based on the bidding quotation form, and upload the bidding encryption file to the bidding and procurement transaction platform.

[0090] In an optional implementation scheme, the configuration bidding list includes:

[0091] Obtaining bidding list data, and importing the bidding list data into or creating a new editing worksheet;

[0092] Specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation;

[0093] Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area;

[0094] Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column;

[0095] The tender list table is constructed based on a worksheet in which the tender list data area locking is completed, the quotation column marking is completed, and the bidding quotation area column locking is completed.

[0096] In an optional embodiment, the bidding terminal is also used for:

[0097] Constructing a calculation formula using at least part of the tender list columns and at least part of the tender price columns as calculation parameters;

[0098] The calculation formula is configured in the bidding list table.

[0099] In an optional implementation scheme, a TBS bid encryption file is generated based on the bid quotation form, including:

[0100] Determining whether the bidding quotation table matches the bidding list table;

[0101] If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

[0102] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working process of the system and device described above can refer to the corresponding process in the aforementioned method embodiment, and will not be repeated here.

[0103] The list and quotation document structuring system provided in the embodiment of the present invention can be specific hardware on the device or software or firmware installed on the device. The system provided in the embodiment of the present invention has the same implementation principle and technical effects as the aforementioned method embodiment. For the sake of brief description, the parts not mentioned in the system embodiment can refer to the corresponding contents in the aforementioned method embodiment. Those skilled in the art can clearly understand that for the convenience and simplicity of description, the specific working processes of the systems, devices and units described above can all refer to the corresponding processes in the aforementioned method embodiment, and will not be repeated here.

[0104] In the embodiments provided by the present invention, it should be understood that the disclosed systems and methods can be implemented in other ways. The system embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some communication interface, device or unit, which can be electrical, mechanical or other forms.

[0105] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0106] In addition, each functional unit in the embodiment provided by the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

[0107] If the functions are implemented in the form of software functional units and sold or used as independent products, they can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product. The computer software product is stored in a storage medium, including several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk, etc., which can store program codes.

[0108] It should be noted that similar numbers and letters represent similar items in the following figures. Therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. In addition, the terms "first", "second", "third", etc. are only used to distinguish the description and are not to be understood as indicating or implying relative importance.

[0109] Finally, it should be noted that the above-described embodiments are only specific implementations of the present invention, which are used to illustrate the technical solutions of the present invention, rather than to limit them. The protection scope of the present invention is not limited thereto. Although the present invention is described in detail with reference to the above-described embodiments, those skilled in the art should understand that any person skilled in the art can still modify the technical solutions described in the above-described embodiments within the technical scope disclosed by the present invention, or can easily think of changes, or perform equivalent replacements on some of the technical features thereof; and these modifications, changes or replacements do not make the essence of the corresponding technical solutions deviate from the spirit and scope of the technical solutions of the embodiments of the present invention. They should all be covered within the protection scope of the present invention. Therefore, the protection scope of the present invention shall be subject to the protection scope of the claims.

Claims

1. A method for structuring a list and quotation document, characterized in that: Applied to a list and quotation document structuring system, the system includes a bidding end, a bidding and procurement transaction platform, a bidding end and a bidding document preparation platform, and the method includes: The bidding terminal configures a bidding list table and uploads the bidding list table to the bidding and procurement transaction platform; The bidding end downloads the bidding list from the bidding and procurement transaction platform, fills the bidding list with quotation data to obtain a bidding quotation table, and uploads the bidding quotation table to the bidding document preparation platform; The bidding document preparation platform generates a TBS bidding encryption file based on the bidding quotation form, and uploads the bidding encryption file to the bidding and procurement transaction platform.

2. The method according to claim 1, characterized in that The configuration bidding list includes: Obtaining bidding list data, and importing the bidding list data into or creating a new editing worksheet; Specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation; Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area; Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column; The tender list table is constructed based on a worksheet in which the tender list data area locking is completed, the quotation column marking is completed, and the bidding quotation area column locking is completed.

3. The method according to claim 2, characterized in that The method further comprises: The bidding end constructs a calculation formula using at least part of the bidding list columns and at least part of the bidding quotation columns as calculation parameters; The bidding end configures the calculation formula in the bidding list table.

4. The method according to claim 1, characterized in that: The step of generating a TBS bidding encryption file based on the bidding quotation form includes: Determining whether the bidding quotation table matches the bidding list table; If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

5. A system for structuring list and quotation documents, characterized in that: The system includes a bidding terminal, a bidding and procurement transaction platform, a bidding terminal and a bidding document preparation platform; The bidding terminal is used to configure a bidding list and upload the bidding list to the bidding and procurement transaction platform; The bidding terminal is used to download the bidding list from the bidding and procurement transaction platform, fill the bidding list with quotation data to obtain a bidding quotation table, and upload the bidding quotation table to the bidding document preparation platform; The bidding document preparation platform is used to generate a TBS bidding encryption file based on the bidding quotation form, and upload the bidding encryption file to the bidding and procurement transaction platform.

6. The system according to claim 5, characterized in that The configuration bidding list includes: Obtaining bidding list data, and importing the bidding list data into or creating a new editing worksheet; Specifying a number of tender list columns and a number of bid quotation columns in the worksheet, identifying the tender column name, the data start row and the data end row of each tender list column, and the bid column name of each bid quotation; Determine the tender list data area in the worksheet based on the tender list column name, data start row and data end row of each tender list column, and lock the tender list data area; Determine the bid quotation area column and the quotation column in the worksheet based on the bid column name of each bid quotation, mark the quotation column, and lock the bid quotation area column, wherein the quotation column is a column used for calculation, and the bid quotation area column is a column calculated by each quotation column; The tender list table is constructed based on a worksheet in which the tender list data area locking is completed, the quotation column marking is completed, and the bidding quotation area column locking is completed.

7. The system according to claim 6, characterized in that The bidding terminal is also used for: Constructing a calculation formula using at least part of the tender list columns and at least part of the tender price columns as calculation parameters; The calculation formula is configured in the bidding list table.

8. The system according to claim 5, characterized in that Generating a TBS bidding encryption file based on the bidding quotation table includes: Determining whether the bidding quotation table matches the bidding list table; If the bid quotation form matches the tender list form, a TBS bid encryption file is generated based on the bid quotation form.

Images