Method for judging bid invitation price competitiveness of bill of quantity by adopting total price discrimination

Abstract

The invention relates to the field of data processing systems or methods specially suitable for administrative, commercial, financial, management, supervision or prediction purposes, in particular to a method for judging bidding price competitiveness of a bill of quantity by adopting total price discrimination. The invention discloses a method for discriminating and judging bidding price competitiveness of a bill of quantity by adopting total price. The method is characterized by comprising the following steps of: I, inputting data; iI, analyzing and processing data; and III, outputting data. The method is rapid and accurate in judgment and high in adaptability.

Description

Technical Field

[0001] The present invention relates to the field of data processing systems or methods specifically suitable for administrative, commercial, financial, management, supervisory or forecasting purposes, and in particular to a method for judging the competitiveness of a bidding price for a bill of quantities by using a total price. Background Art

[0002] In recent years, in addition to compliance requirements in the bidding field, the State-owned Assets Supervision and Administration Commission has further put forward requirements on whether the bidding prices are competitive. Currently, there is no effective method for judging price competitiveness. The competitive analysis of the bidding prices of the bill of quantities often relies on manual judgment and empirical estimation, which is time-consuming and error-prone, and can hardly meet the efficient and accurate requirements of modern construction project bidding.

[0003] In the field of engineering bidding, the tenderer needs to conduct an in-depth and detailed evaluation of the rationality and competitiveness of the bill of quantities quotations submitted by the bidders. At present, the common technical means in the industry mostly focus on manual comparison and empirical judgment. These evaluation methods have significant shortcomings, mainly manifested in low efficiency and high error rate. There are also some methods that use specific algorithms to conduct preliminary screening and evaluation of bill of quantities quotations. Although this method has been effective in improving evaluation efficiency, it has limitations such as poor adaptability. Summary of the invention

[0004] In order to overcome the defects of the prior art and provide an evaluation method with fast, accurate and strong adaptability, the present invention discloses a method for judging the competitiveness of the bidding price of the bill of quantities by using the total price.

[0005] The present invention achieves the purpose of the invention through the following technical solutions: A method for judging the competitiveness of bidding price of bill of quantities by using total price, characterized by: implementing the following steps in sequence: I. Data Input: The input data include: quotation data, maximum bid price data, historical bid winning data, bill of quantities details or maximum bid price details; II. Data analysis and processing: II.1 Data Preprocessing: After receiving the bid data reported by the bidders, the total amount of the bids corresponding to each bidder will be parsed into the project cost database. After receiving the historical bid data, the bid list details of the bid winners of the bidding section are parsed into the engineering cost database and automatically precipitated into the comprehensive unit price market price of the bill of quantities as the price source for competitive analysis and matching. After importing the bill of quantities details or the highest bid price limit details, you need to clean the data first, remove the blank lines, invalid bill of quantities details such as those without bill numbers, and store them in the highest bid price limit bill details table; enter the pending matching state; II.2 Data Matching: II.2.1 Setting conditions: According to the bidding sections that need to be competitively analyzed and matched with market prices, set the screening conditions for historical data. The screening conditions are flexibly adjusted according to the actual situation of the project, including factors such as project type, project name, project scale, project category, region, time, calculation method, comprehensive unit price type, etc. Through screening, we can find historical projects with a high degree of similarity to the current bidding project, so as to ensure the accuracy and reliability of the next step of market total price calculation; II.2.2 Select calculation method: The calculation methods include: the average price of all prices, the average price excluding the highest price and the lowest price, the lowest price, etc.; the present invention automatically filters and matches the historical unit prices of each bill of quantities sub-item according to the set screening conditions, and automatically calculates according to the calculation method set by the cost estimator; II.2.3 Automatic matching and manual intervention: For the historical winning bid price details screened and matched by the engineering cost database, the cost engineer will remove the list that does not meet the characteristics of the project or other requirements according to the characteristics of the project, and the removed list will not be included in the calculation; for the sub-items that are not automatically matched to the market price, the cost engineer will implement manual intervention and apply the highest bid limit price to the market price, or manually fill in a market price; II.2.4 Generating market prices: After the matching is completed, the present invention will automatically calculate and generate a new market price; the market price will fully apply the historical bidding price data after market competition, and combine effective screening conditions and the intervention of the cost estimator when similar data is missing to ensure that the price is in line with the market situation; In addition, the present invention also has data tracing and version control functions. For each match and modification, a detailed operation log will be recorded, including the operation time, operator, operation content, etc. In this way, cost engineers can easily trace the change process of historical data to ensure the accuracy and reliability of the data. At the same time, the present invention also supports version control and can save different versions of market price data, which is convenient for cost engineers to compare and analyze; The input data are the data elements needed to complete the analysis; Importing details refers to importing bill of quantities details or maximum bid limit price details, which is a data input operation mode; Setting conditions is the premise of data analysis and processing. By setting different conditions, the matching range can be narrowed down, making the analysis results more accurate. Calculating prices and conducting comparative analysis in data analysis and processing are specific implementation methods; Data output can output the results of comparative analysis to form a report or attachment; In summary, through the steps of matching principle, drop-down selection of calculation method, automatic matching and manual intervention, and generation of new market price after matching, the present invention provides an efficient and accurate market price matching method for cost estimators, which helps to improve the accuracy and efficiency of project cost; II.2.5 Calculate the difference rate to form a conclusion: After the new market price is generated, the difference rate is further calculated to form a conclusion. The difference rate refers to the degree of difference between the current market price and the bidder's quotation, which is an important indicator for evaluating market competitiveness and price rationality; Based on the calculated difference rate, determine whether the project is competitive: as long as there is a bid price that is not higher than the estimated total market price, the project is competitive; if no bid price is lower than the estimated total market price, it is preliminarily determined that the project is not competitive; III. Data Output: Based on the analysis results of the total price screening method, the competitive evaluation results of the bid price are output. The evaluation results will be presented in intuitive forms such as tables and charts, which are convenient for the tenderer to quickly review, understand and conduct in-depth analysis, providing strong support for the tender decision.

[0006] The method of using the total price to screen and judge the competitiveness of the bidding price of the bill of quantities is characterized by: In step I, the input data includes the following four sources: I.1 Receive the bid price data submitted by the bidders of the bidding section, I.2 A professional cost estimator or tenderer shall upload the highest bid price limit data of the tender bill of quantities. I.3 After completing the archiving process of the winning bid data, the historical winning bid data will be automatically transmitted. I.4 Import the tender bill of quantities details or the maximum bid price details; In step III, the evaluation results will be presented in intuitive forms such as tables and charts, which will facilitate the tenderer to quickly review, understand and conduct in-depth analysis, providing strong support for the tender decision.

[0007] In the implementation process of the present invention, the analysis results are obtained by importing details, setting conditions, calculating prices and performing comparative analysis. Specifically: When importing details, import the bidding bill of quantities details or the highest bid limit price details; this step is crucial because it provides basic data for the subsequent market total price calculation of the total price identification method. By importing these details, the present invention can automatically obtain the specific engineering quantity, comprehensive unit price and other information of each project, providing comprehensive data support for subsequent price competitiveness analysis.

[0008] When setting conditions, set the filtering conditions for historical data. The filtering conditions are flexibly adjusted according to the actual situation of the project, including factors such as project type, project scale, region, time, and comprehensive unit price type. Through screening, we can find historical projects with a high degree of similarity to the current bidding project, thereby ensuring the accuracy and reliability of the next step of market total price calculation.

[0009] When calculating the price, the most appropriate market price for the bidding project is calculated. This calculation process is based on a large amount of historical bidding data. Through scientific algorithms and models, a comprehensive analysis of factors such as project volume and comprehensive unit price is conducted to obtain a competitive market total price. This total price reflects the current market's overall valuation of the project and provides an important reference for the bidding unit.

[0010] During comparative analysis, by calculating the difference between the total bid price of each bidding unit and the total market price, we can clearly understand the quotation strategy and market positioning of each unit. By comparing the difference rates of different units, we can evaluate the competitiveness of the project, thereby providing strong support for the decision-making of the bidding unit.

[0011] In addition, we can also use other data resources in the engineering cost database, such as material prices, labor costs, etc., to conduct a more in-depth analysis of the project cost. By mining and analyzing these data, we can discover the changing trends and influencing factors of project costs, and provide more comprehensive cost control suggestions for the bidding unit.

[0012] In today's construction industry, the establishment and use of engineering cost database has become an important technical means. By making full use of the rich historical project bid price data in the engineering cost database, we can conduct in-depth price analysis on the current bidding project and provide strong decision-making support for the bidding unit.

[0013] The present invention proposes a method for judging the price competitiveness of the bill of quantities through the total price screening method. The method uses the powerful data processing and analysis capabilities of computers, and through the total price screening method, uses the effective combination of historical winning bid prices and market prices to achieve accurate evaluation of the bill of quantities quotation, and can quickly and accurately evaluate the bid quotations, thereby helping the tenderer (or project investor) to judge whether the bidder's quotation is competitive, thereby significantly improving the accuracy and efficiency of the evaluation and providing a strong basis for subsequent bidding.

[0014] The method of the present invention is applicable to any bill of quantities bidding project, is not limited to price files generated by various software, and can be applicable to projects in the bidding format of EXCEL or XML.

[0015] The present invention has the following beneficial effects: By deeply analyzing the bid price data of historical projects in the engineering cost database, the present invention can carry out a comprehensive and detailed competitive analysis of bidding quotations. This measure aims to provide accurate market valuations for the majority of bidding units, thereby achieving accurate control of project procurement costs and significantly improving procurement benefits.

[0016] In terms of improving evaluation efficiency, the present invention significantly optimizes the evaluation process of bill of quantities quotation with the help of automated processing and analysis technology, and greatly reduces the complexity of manual operations.

[0017] In terms of accuracy, the use of the total price identification method for in-depth analysis and precise judgment can more accurately evaluate the competitiveness of the bid price, thereby effectively avoiding the errors that may be caused by traditional manual judgment methods. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] Figure 1 It is a flow chart of the present invention. DETAILED DESCRIPTION

[0019] The present invention is further described below by means of specific examples. Example

[0020] A method for judging the competitiveness of bidding price of bill of quantities by using total price, characterized by: implementing the following steps in sequence: I. Data Input: The input data comes from the following four sources: I.1 Receive the bid price data submitted by the bidders of the bidding section, I.2 A professional cost estimator or tenderer shall upload the highest bid price limit data of the tender bill of quantities. I.3 After completing the archiving process of the winning bid data, the historical winning bid data will be automatically transmitted. I.4 Import the tender bill of quantities details or the highest bid price limit details; II. Data analysis and processing: II.1 Data Preprocessing: After receiving the bid data reported by the bidders, the total amount of the bids corresponding to each bidder will be parsed into the project cost database. After receiving the historical bid data, the bid list details of the bid winners of the bidding section are parsed into the engineering cost database and automatically precipitated into the comprehensive unit price market price of the bill of quantities as the price source for competitive analysis and matching. After importing the bill of quantities details or the highest bid price limit details, you need to clean the data first, remove the empty lines, invalid list details such as no list number, and save them in the highest bid price limit list details table; enter the waiting for matching state; II.2 Data Matching: II.2.1 Setting conditions: According to the bidding sections that need to be competitively analyzed and matched with market prices, set the screening conditions for historical data. The screening conditions are flexibly adjusted according to the actual situation of the project, including factors such as project type, project name, project scale, project category, region, time, calculation method, comprehensive unit price type, etc.; through screening, we can find historical projects with a high degree of similarity to the current bidding project, thereby ensuring the accuracy and reliability of the next step of market total price calculation.

[0021] II.2.2 Select calculation method: The calculation methods include: the average price of all prices, the average price excluding the highest and lowest prices, the lowest price, etc.; according to the set filtering conditions, the historical unit prices of each bill of quantities sub-item are automatically filtered and matched, and the system automatically calculates according to the calculation method set by the cost engineer.

[0022] II.2.3 Automatic matching and manual intervention: For the historical winning bid price details screened and matched by the engineering cost database, the cost engineer will remove the list that does not meet the characteristics of the project or other requirements according to the characteristics of the project, and the removed list will not be included in the calculation; for the sub-items that are not automatically matched to the market price, the cost engineer will implement manual intervention and apply the highest bid limit price to the market price, or manually fill in a market price; II.2.4 Generating market prices: After the matching is completed, the new market price will be automatically calculated and generated. The market price will fully apply the historical bidding price data after market competition, and combine effective screening conditions and the intervention of the cost estimator when similar data is missing to ensure that the price is in line with the market situation; In addition, this embodiment also has data tracing and version control functions. For each match and modification, a detailed operation log will be recorded, including the operation time, operator, operation content, etc. In this way, cost engineers can easily trace the changes in historical data to ensure the accuracy and reliability of the data. At the same time, this embodiment also supports version control, which can save different versions of market price data to facilitate cost engineers to compare and analyze.

[0023] The input data are the data elements needed to complete the analysis; Importing details refers to importing bill of quantities details or maximum bid limit price details, which is a data input operation mode; Setting conditions is the premise of data analysis and processing. By setting different conditions, the matching range can be narrowed down, making the analysis results more accurate. Calculating prices and conducting comparative analysis in data analysis and processing are specific implementation methods; Data output can output the results of comparative analysis to form a report or attachment.

[0024] In summary, through the matching principle, drop-down selection of calculation method, automatic matching and manual intervention, and generation of new market price after matching, this embodiment provides cost estimators with an efficient and accurate market price matching method, which helps to improve the accuracy and efficiency of project cost.

[0025] II.2.5 Calculate the difference rate to form a conclusion: After the new market price is generated, the difference rate is further calculated to form a conclusion. The difference rate refers to the degree of difference between the current market price and the bidder's quotation, which is an important indicator for evaluating market competitiveness and price rationality; Based on the calculated difference rate, determine whether the project is competitive: as long as there is a bid price that is not higher than the estimated total market price, the project is competitive; if no bid price is lower than the estimated total market price, it is preliminarily determined that the project is not competitive; III. Data Output: Based on the analysis results of the total price screening method, the competitive evaluation results of the bid price are output. The evaluation results will be presented in intuitive forms such as tables and charts, which are convenient for the tenderer to quickly review, understand and conduct in-depth analysis, providing strong support for the tender decision.

[0026] The flowchart of each module in this embodiment when it is running is as follows Figure 1 shown.

[0027] During the implementation of this embodiment, the analysis results are obtained by importing details, setting conditions, calculating prices and performing comparative analysis. Specifically: When importing details, import the bidding bill of quantities details or the highest bid limit price details; this step is crucial because it provides basic data for the subsequent market total price calculation of the total price identification method. By importing these details, the present invention can automatically obtain the specific engineering quantity, comprehensive unit price and other information of each project, providing comprehensive data support for subsequent price competitiveness analysis.

[0028] When setting conditions, set the filtering conditions for historical data. The filtering conditions are flexibly adjusted according to the actual situation of the project, including factors such as project type, project scale, region, time, and comprehensive unit price type. Through screening, we can find historical projects with a high degree of similarity to the current bidding project, thereby ensuring the accuracy and reliability of the next step of market total price calculation.

[0029] When calculating the price, the most appropriate market price for the bidding project is calculated. This calculation process is based on a large amount of historical bidding data. Through scientific algorithms and models, a comprehensive analysis of factors such as engineering quantity and comprehensive unit price is conducted to obtain a competitive market total price. This total price reflects the overall valuation of the project in the current market and provides an important reference for the bidding unit.

[0030] During comparative analysis, by calculating the difference between the total bid price of each bidding unit and the total market price, we can clearly understand the quotation strategy and market positioning of each unit. By comparing the difference rates of different units, we can evaluate the competitiveness of the project, thereby providing strong support for the decision-making of the bidding unit.

[0031] In addition, other data resources in the engineering cost database, such as material prices, labor costs, etc., can be used to conduct a more in-depth analysis of the project cost. By mining and analyzing these data, we can discover the changing trends and influencing factors of project costs and provide more comprehensive cost control suggestions for the bidding unit.

Claims

1. A method for judging the competitiveness of bidding prices for bill of quantities by using total price, characterized by: Follow the steps below to implement: I. Data Input: The input data include: quotation data, maximum bid price data, historical bid winning data, bill of quantities details or maximum bid price details; II. Data analysis and processing: II.1 Data Preprocessing: After receiving the bid data reported by the bidders, the total amount of the bids corresponding to each bidder will be parsed into the project cost database. After receiving the historical bid data, the bid list details of the bid winners of the bidding section are parsed into the engineering cost database and automatically precipitated into the comprehensive unit price market price of the bill of quantities as the price source for competitive analysis and matching. After importing the bill of quantities details or the highest bid price limit details, the data needs to be cleaned first; II.2 Data Matching: II.2.1 Setting conditions: according to the bidding sections that need to be competitively analyzed and matched with market prices, set the screening conditions of historical data, including project type, project name, project scale, project category, region, time, calculation method, and comprehensive unit price type factors; II.2.2 Select the calculation method: Calculation methods include: the average price of all prices, the average price excluding the highest and lowest prices, the lowest price, etc.; II.2.3 Automatic matching and manual intervention: For the historical winning bid price details screened and matched by the engineering cost database, the cost engineer will remove the list that does not meet the characteristics of the project or other requirements according to the characteristics of the project, and the removed list will not be included in the calculation; for the sub-items that are not automatically matched to the market price, the cost engineer will implement manual intervention and apply the highest bid limit price to the market price, or manually fill in a market price; II.2.4 Generating market price: After the matching is completed, the new market price is calculated and generated; II.2.5 Calculate the difference rate to form a conclusion: After the new market price is generated, the difference rate is further calculated to form a conclusion. The difference rate refers to the degree of difference between the current market price and the bidder's quotation, which is an important indicator for evaluating market competitiveness and price rationality; According to the difference rate calculated by the present invention, it is judged whether the project is competitive: as long as there is a bid price not higher than the estimated total market price, the project is competitive; if there is no bid price lower than the estimated total market price by the present invention, it is preliminarily judged that the project is not competitive; III. Data Output: Based on the analysis results of the total price screening method, the competitive evaluation results of the bidding price are output.

2. The method for judging the competitiveness of the bidding price of the bill of quantities by using the total price as claimed in claim 1 is characterized by: In step I, the input data includes the following four sources: I.1 Receive the bid price data submitted by the bidders of the bidding section, I.2 A professional cost estimator or tenderer shall upload the highest bid price limit data of the tender bill of quantities. I.3 After completing the archiving process of the winning bid data, the historical winning bid data will be automatically transmitted. I.4 Import the tender bill of quantities details or the maximum bid price details; In step III, the evaluation results are presented in the form of tables and charts.

Images