1. A method for controlling automatic pricing of a construction engineering quantity list is characterized by being realized by the following steps:

(1) reading an item list file: importing a bidding document list into a computer system, collecting the item codes related to each line in the item list document by the system, extracting the first 9 bits from the item code field of 12-bit numbers to obtain item feature codes, reading item feature description characters corresponding to the item feature codes in the bidding document into a feature array by the system on the basis, wherein one element in the array corresponds to one line of characters in the database item feature descriptions, and inquiring the database to obtain a rule line corresponding to the element; by analogy, rule rows corresponding to elements related to the project feature codes are obtained respectively; meanwhile, the system intelligently compares and analyzes the completeness and the normalization of the item characteristic description and the item characteristic value in the bidding document list, and if the characteristic value is not available, manual additional recording is carried out;

(2) generating a characteristic value identification string: determining the elements in the feature array by using the feature names in the rule rows;

judging by using the key word string of the characteristic value in the row, if the key word appears in the element, stringing the key word into the characteristic value identification string from the tail part and skipping the rest key words, otherwise, judging the next key word; repeatedly executing the same operation in the rows one by one according to the item names, and obtaining a characteristic value identification string by one rule row;

(3) query subdirectory quota number: identifying the string according to the project characteristic code and the characteristic value, and inquiring a sub-category quota number from the database;

(4) and outputting a result: summarizing and outputting the quota numbers and names of all the subdirectories, and generating a project amount list with the quota subdirectories; the list is automatically read by pricing software, so that rapid and accurate list pricing is realized.

Background

In the prior art, project characteristics specified in the appendix of 'project amount bill calculation specification' are used and combined with the proposed project practice, and the bill project characteristic description is determined by construction workers. The engineering quantity list calculation specification has no normative requirement on the completeness of project characteristics, so that the problems that the project characteristic description of the engineering quantity list is not normative and the project characteristic description cannot accurately reflect the constituent elements of the list project and the like due to different cognition of construction workers in engineering practice are caused, the problems that project characteristics (values) are lacked, missed and repeated are caused in typical examples, quota subdirectories collected by the same sub-project are not uniform, the cognitive contradiction of a tenderer and a bidder on the engineering price is caused, the behavior of back-to-back checking price of both sides is generated, and huge social time cost and economic cost waste are caused.

The project characteristic and the project characteristic value description of the project inventory are the basis for distinguishing project inventory projects, are the premise for determining comprehensive unit price and are the basis for fulfilling contractual obligations. At present, the project characteristic description of the bid document project quantity list is inaccurate in engineering practice, so that bid price lack, missing and bid evaluation processes cannot reasonably evaluate bid price, and meanwhile, price claims and contract disputes caused by the inaccurate characteristic description of the project commonly exist in a project implementation stage and a settlement stage. Therefore, at present, the development of an automatic pricing system for construction engineering quantity lists is urgently needed, the problem of disordered construction prices in construction engineering bidding is solved, and the operation and the use are convenient.

Disclosure of Invention

Aiming at the problem of inaccurate engineering price caused by non-standard bidding documents in the current construction engineering, the invention aims to solve the problems of inaccurate control price and bidding price caused by incomplete description of project characteristics and project characteristic values of the bidding document project quantity list and false collection of quota subdistricts in the engineering bidding practice, and provides an identification system capable of automatically checking the integrity and accuracy of the construction engineering project quantity list, completing automatic pricing and reducing settlement disputes in project bidding and implementation stages.

The technical scheme for realizing the aim of the invention is as follows:

the method is based on value theory and engineering price composition, combines design specifications and construction processes, establishes a maximum theoretical set of project characteristics and project characteristic values, and forms a complete project characteristic and characteristic value standard database; matching the existing rating database according to the project characteristic and characteristic value standard database to form a complete project characteristic (value) -rating sub-target association database; according to project feature description information in an existing bidding document and in combination with a complete project feature library of the system, maximum retrieval and intelligent matching of complete/incomplete project feature (value) information are achieved, missing information described by the project feature (value) is found out, information supplement is conducted on project features and project feature values of a bidding project amount list, quota subdirectories of each project are accurately collected, and a bidder or bidder is guided to achieve rapid and accurate bidding/bidding quotation documentation.

The invention relates to a concrete method for controlling the automatic pricing of a construction engineering quantity list, which comprises the following steps:

1) reading an item list file: importing a bidding document list into a computer system, collecting the item codes related to each line in the item list document by the system, extracting the first 9 bits from the item code field of 12-bit numbers to obtain item feature codes, reading item feature description characters corresponding to the item feature codes in the bidding document into a feature array by the system on the basis, wherein one element in the array corresponds to one line of characters in the database item feature descriptions, and inquiring the database to obtain a rule line corresponding to the element; by analogy, rule rows corresponding to elements related to the project feature codes are obtained respectively; meanwhile, the system intelligently compares and analyzes the completeness and the normalization of the item characteristic description and the item characteristic value in the bidding document list, and if the characteristic value is not available, manual additional recording is carried out.

2) Generating a characteristic value identification string: the elements that appear in the feature array are identified by the feature name in the rule row. Judging by using the key word string of the characteristic value in the line, if the key word appears in the element, entering the key word into the characteristic value identification string from the tail part and skipping the rest key words, otherwise, judging the next key word. The same operation is repeatedly performed in the row by the item name. A rule row may result in a feature value identification string.

3) Query subdirectory quota number: and identifying the string according to the project characteristic code and the characteristic value, and inquiring the database to obtain the sub-quota number.

4) And outputting a result: and summarizing and outputting the quota numbers and names of all the subdirectories, and generating a project amount list with the quota subdirectories. The list is automatically read by pricing software, so that rapid and accurate list pricing is realized.

The core content of the basic database of the invention is as follows:

basic contents of the basic database: the basic database is established by taking project codes, project NAMEs, measurement units, project characteristic descriptions (NAME 1-n), project characteristic VALUEs (VALUE1-n), quota numbers, quota NAMEs, expanded calculation dimensions, plus columns (characteristic VALUE identification strings) and extraction lines (rule lines and character string sets for retrieval) as main contents.

Establishing principles of a basic database: on the premise of realizing the unified requirement naming of the national specifications of project codes, project NAMEs and measurement units, from the aspects of VALUE theory and project price composition, complete project characteristic description and project characteristic VALUEs are formed by exhaustion in a range of 1-n through project characteristic description (NAME 1-n) and project characteristic VALUEs (VALUE1-n) according to 'construction project amount list pricing specification' GB50500-2013, the current construction project quota and by combining design specifications and construction processes. The brain intelligence activity of a human is simulated through the form of a decision tree, and a correct and unique path from project characteristics to a quota subdirectory (quota code) is solidified in excel text (core). The item feature description (NAME 1-n) and the item feature VALUE (VALUE1-n) are in one-to-one correspondence, and correspond to the sub-category quota number. Through the complete content of the database, the assignment and description of the leakage-free characteristics of each work content contained in the existing construction project can be realized.

Database reading principle: in the establishment of the database, by carrying out user-defined entry rules such as extraction, splicing, skipping, digital segmentation processing, merging and the like on listed item feature descriptions and item feature values, the standardization and normalization of data information in the database are ensured, and simultaneously effective and retrievable specification information for software language identification of customized development, namely, an additional column (feature value identification string) and extraction rows (rule row and character string set for retrieval) are formed, and the detailed details are shown in an embodiment list and description.

Digital segmentation processing principle: case 1 left open right closed multiple stages. If the number of the segments is 3 (20 m is less than or equal to 20m, 20m is greater than or equal to 40m, 40m is greater than or equal to 60m), the characteristic value extraction in the extraction row operation is (60,40 and 20), the characteristic value extraction in the column operation is simplified into 20 in the column operation (20 m is less than or equal to 40m), the characteristic value extraction is simplified into 40 in the column operation (40 m is less than or equal to 40m), and the characteristic value extraction is simplified into 60 in the column operation (40 m is less than or equal to 60 m); case 2, open to the right multiple segments. If the situation 1 is added by one segment (>60m), the characteristic value in the extraction row operation is extracted as (>60,60,40,20), and the characteristic value in the addition column operation (>60m) is simplified as (> 60); case 3 two stages. If 20m is less than or equal to and greater than 20m, the characteristic value is extracted to be (> 20, 20).

The invention is mainly applied to the project bidding stage, on the basis of the established database, the characteristic value is extracted by importing the bidding document list, searching and comparing the bidding document list with the database by a computer, the quota sub-numbers of each sub-item are accurately applied, the corresponding sub-quota numbers are found, and on the basis, the quotation numbers are read by pricing software to finish accurate quotation. The method aims to assist the tenderers and bidders to complete item feature (value) description in the tendering engineering quantity list and ensure the accuracy of each item unit price.

The invention has the advantages that: by importing the bidding project list, the system automatically collects project feature codes, generates a feature value identification string, obtains sub-quota numbers by inquiring in a database, and imports the sub-quota number list into pricing software to obtain the total bidding price. In the bid evaluation stage, the system can avoid the lack of bid quotations and missing items and reasonably determine bid price in the bid evaluation process, and simultaneously in the project implementation stage and the settlement stage, the system is more accurate and avoids price claim and contract dispute caused by inaccurate feature description of project projects. The whole bid evaluation process is more accurate and efficient, and the operation and the use are convenient. The method solves the problems of inaccurate control price and bid quotation caused by incomplete description of project characteristics and project characteristic values of a bid document project quantity list and false extraction of quota subdirectories in the engineering bid practice.

Drawings

FIG. 1 is a block diagram of a network module of the construction work volume list bid decision support system according to the present invention;

FIG. 2 is a flow chart of an automatic set sub-algorithm of the present invention;

FIG. 3 is a flow chart of a feature value identification string generation sub-algorithm module of the present invention;

FIG. 4 is a block diagram of an automatic trepanning module according to the present invention;

FIG. 5 is a schematic representation of the operation of the fetch line of the present invention;

fig. 6 is a schematic diagram illustrating the operation of the additional column of the present invention.

Detailed Description

For better illustration of the present invention, the following embodiments are illustrated in conjunction with the flow chart of the attached drawings:

example 1

Firstly, the following bid-inviting engineering quantity list is imported into a bid decision support system for intelligent reading.

1. System intelligent analysis

The system intelligently extracts the first 9 bits (010502001) in the 12-bit digital item code field in the bidding engineering quantity list to obtain the item code corresponding to the basic database, reads the item feature description in the bidding engineering quantity list into a feature array, and one element in the feature array corresponds to one line of characters in the item feature description in the basic database. Inquiring a rule row corresponding to the element from a database; by analogy, rule rows corresponding to elements related to the project feature codes are obtained respectively; meanwhile, the system intelligently compares and analyzes the completeness and the normalization of the item characteristic description and the item characteristic value in the bidding document list, and if the characteristic value is not available, manual additional recording is carried out.

2. The rules found are listed in the following table: and inquiring a rule row from the rule base according to the item codes.

3. Generating a feature value identification string

The element that appears in the feature array is determined by the name of the feature in the rule row. Judging by using the key word string of the characteristic value in the row, if the key word appears in the element, stringing the key word into the characteristic value identification string from the tail part and skipping the rest key words, otherwise, judging the next key word; the same operation is repeatedly executed in the lines one by one according to the item names, and a characteristic value identification string can be obtained by one rule line.

Example (c): in the encoding range of the '010502001' project, the system performs intelligent loop extraction and generates a characteristic value identification string as shown in the attached figure 3:

(1) premixed concrete C25 "

(2) Fixed pump "

(3) Composite steel formwork steel support 4.6m "

(4) 'split bolt hole-plugging'

Secondly, identifying strings through characteristic values and inquiring quota subdirectories in a basic database

(1) "premixed concrete C25" → 5-11H 8021055780210559 → cast-in-place concrete rectangular column traded for [ premixed concrete C25 ]

(2) 'fixed pump' → 5-87 → fixed pump for pumping concrete

(3) 'composite steel template steel support 4.6 m' → 5-220+5-226 → cast-in-place concrete template rectangular column composite template steel support actual height (m):4.6

(4) 'counter-pulling bolt eye-plugging' → 5-254R 0.3, J0.3 → cast-in-place concrete template counter-pulling bolt eye-plugging increase expense cylindrical surface manual work 0.3, machinery 0.3

Thirdly, outputting the result

The system intelligently outputs the quota numbers and names of all the subdivisions according to the steps, and generates a project amount list with the quota subdivisions, namely 'comprehensive unit price analysis of branch items and unit price measure list', which is as follows:

the system automatically reads the project characteristics (values) of each sub-item in the existing bidding project quantity list, checks the completeness of the project characteristic description (values) in the existing file, provides an audit report of the missing item, repeated item and error of the project characteristic description of each sub-item in the existing file, adjusts the completeness of the project characteristic description of the existing bidding project quantity list according to the audit report, and achieves one-key set of correct quota subdirectories of each sub-item through a matching database of the project characteristics (values) and the quota subdirectories of the system to generate the project quantity list with the quota subdirectories. The list is automatically read by pricing software commonly used in the building field, so that quick and accurate list pricing is realized.

Example 2

Taking the excavation of the features of the stone project, one column (feature value identification string) and one extraction line (rule line, character string set for search) will be described.

1. Description of operations for extraction line:

rule 1: and extracting project feature description. As illustrated by the black dashed line in fig. 5. In the first column of item feature descriptions from the left, each item needs to start a new line and is filled in the name0, and then is successively filled in the names 1 and name2.

Rule 2: and extracting the characteristic value. As illustrated by the solid black line. And sequentially splicing, Chinese comma and separating, wherein if the characteristic value quality inspection characters have inclusion relations, the long spelling is before, and the short spelling is after, and the long spelling is filled in the corresponding value0 and value1.

Rule 3: skipping over the single entry. If there is only a single item feature value under a certain [ item feature description ], i.e. no divergence to the right, the item feature description is skipped, as illustrated by the black dashed line.

Rule 4: skipping the number. If the feature value is a digital segment, skip, as solid black line.

Rule 5: and (5) merging and storing. All the lines are merged and stored in one file according to the coding sequence of the items.

2. Description of the operation of the additional column

Rule 1 splicing. And splicing all the characteristic values corresponding to the quota numbers in sequence. As illustrated by the black dashed line in fig. 6.

Rule 2 skip. If there is only a single feature value under a certain [ item feature description ], i.e. no bifurcation to the right, then the feature value is skipped and no concatenation is taken. As illustrated by the solid black line.

Rule 3 filename. The data with the same first 4 bits are stored in the same sheet or file, and the sheet or file is named by the 4-bit code.

The present application relates to the following terms:

1. bidding project inventory BQ for listing

The tenderer is compiled according to the national standard, the tendering file, the design file and the actual situation of the construction site, and issues a project amount list for bidding quotation along with the tendering file, including the description and the table.

2. Priced engineering quantity bill of lading BQ

The bid document that forms part of the contract document has a price indicated therein, is mathematically incorrectly corrected (if any), and contains a list of work quantities, including descriptions and tables thereof, that the contractor has confirmed.

3. Item coding item code

And the Arabic numeral identifiers of the names of the project and measure project lists are divided into parts.

The item code is represented by twelve digits (the supplemental items are represented by eleven digits). One to nine bits are unified codes, wherein one bit and two bits are professional engineering codes, three bits and four bits are appendix classification sequence codes, five bits and six bits are subsection engineering sequence codes, seven bits, eight bits and nine bits are subsection engineering sequence codes, and ten bits, eleven bits and twelve bits are list project name sequence codes.

4. Item feature item description

And the essential characteristics of the values of the project and the measure project of the subsection project are formed.