Python-based engineering quantity bill accuracy verification method

Abstract

A Python-based engineering quantity bill accuracy verification method comprises, with a Python library, an application software data import unit, a data export unit and a comparison unit in a PC serveas verification tools, the following steps: S1, determining a quantity bill excel file of which the accuracy needs to be verified in a predetermined field; S2, converting the engineering quantity bill excel file into a Data Frame and a list; S3, splitting the engineering quantity bill project name and the engineering quantity bill project feature description bill item by item; S4, finding out anengineering quantity bill of which the engineering quantity bill project name is not matched with the engineering quantity bill project feature description; and S5, exporting the unmatched engineeringquantity bill in the form of an excel file. The work efficiency is improved, and the compiling quality of an engineering quantity bill is improved. Meanwhile, the professional risk avoiding capability of a cost consulting enterprise is enhanced. Based on the above, the method has a good application prospect.

Description

technical field [0001] The invention relates to the technical field of bill of quantities verification application technology, in particular to a method for verifying the accuracy of bills of quantities based on Python. Background technique [0002] The bill of quantities refers to a detailed list indicating the names and corresponding quantities of sub-items, measures, and other items of a construction project, as well as fees and value-added tax items. Cost consulting is an integral part of engineering consulting, mainly responsible for the investment control of the project to ensure that the project cost is controllable. Cost consulting companies deal with the bill of quantities every day, and the bill of quantities is the main output document of the cost consulting company. In reality, each bill of quantities document consists of hundreds or even thousands of bills of quantities. Due to the large quantity of the bill of quantities, there will be many errors in the comp...

AI Technical Summary

Problems solved by technology

[0005] In order to overcome the disadvantages of low efficiency and omissions in the manual verification of the bill of quantities in the prior art, the present invention provides a Python-based technology, through the use of the Python library, and under the joint action of all relevant application units, it can Slice the content of the comparison analysis, and then complete the item-by-item comparison to find out the problematic bill of quantities, thereby improving the work efficiency of engineers and improving the quality of the bill of quantities. A Python-based bill of quantities accuracy check method

Images