CN114724158A - Engineering quantity auditing method and system, electronic equipment and storage medium - Google Patents
Engineering quantity auditing method and system, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN114724158A CN114724158A CN202210424995.9A CN202210424995A CN114724158A CN 114724158 A CN114724158 A CN 114724158A CN 202210424995 A CN202210424995 A CN 202210424995A CN 114724158 A CN114724158 A CN 114724158A
- Authority
- CN
- China
- Prior art keywords
- information
- calculation
- cells
- calculation book
- dimensional array
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 49
- 238000004364 calculation method Methods 0.000 claims abstract description 141
- 238000012545 processing Methods 0.000 claims description 39
- 238000004590 computer program Methods 0.000 claims description 11
- 238000006243 chemical reaction Methods 0.000 claims description 8
- 230000005856 abnormality Effects 0.000 claims description 7
- 229910000831 Steel Inorganic materials 0.000 abstract description 5
- 239000010959 steel Substances 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 6
- 238000004891 communication Methods 0.000 description 5
- 238000012550 audit Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 4
- 238000010276 construction Methods 0.000 description 2
- 206010063385 Intellectualisation Diseases 0.000 description 1
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000000463 material Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000002787 reinforcement Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method and a system for auditing engineering quantity, electronic equipment and a storage medium. The method comprises the following steps: the engineering quantity calculation books with different format styles are defined into different areas including a part information area and a part attribute area after the characteristic information is identified; a steel bar calculation area, a steel strand calculation area, a concrete calculation area, a list hanging area, a list calculation area and the like; the data in different calculation areas are automatically classified according to different attribute information, so that the data can be compared with the form data identified in the PDF drawing one by one according to rows and columns, the difference between the calculation data of the calculation book and the data of the drawing is automatically checked, automatic auditing is realized, meanwhile, the difference items are annotated to the corresponding calculation areas of the calculation book in different problem types, the annotations are automatically fed back to auditors, and complete intelligent auditing is realized.
Description
Technical Field
The invention belongs to the field of engineering quantity auditing, and particularly relates to an engineering quantity auditing method, an engineering quantity auditing system, electronic equipment and a storage medium.
Background
With the fact that the existing information technologies such as artificial intelligence, internet of things and cloud computing are widely applied to the field of infrastructure engineering construction, engineering quantity calculation electronization, design drawing electronization and the like provide necessary basic conditions for intellectualization of engineering quantity audit. The intelligent engineering quantity auditing method includes the steps that firstly, data area splitting is conducted on an engineering quantity calculation book, the whole book of calculation book files are split into different areas, and different attributes are given to the data in the different areas through the characteristics of the data in the areas; and then identifying and segmenting the engineering scale of the PDF drawing, and intelligently comparing the engineering scale with different areas decomposed by the calculation book, thereby finding out the calculation deviation.
At present, the engineering quantity calculation book is limited by the fact that formats, styles and formats are all not uniform, so that the proportion of intelligent audit is low, and popularization and application of the technology are greatly limited; most of the current methods still adopt a manual checking mode, so that the efficiency is low.
Disclosure of Invention
In order to solve the technical problems, the invention provides a technical scheme of a method and a system for examining and verifying the engineering quantity, an electronic device and a storage medium, so as to solve the technical problems.
The invention discloses a method for auditing the engineering quantity in a first aspect, which comprises the following steps:
step S1, reading a complete PDF file based on the PDF file uploaded by the user;
step S2, splitting the PDF file of the specific page number according to the name, number and page number of the album filled in the project calculation book index information column;
step S3, carrying out picture conversion on the split PDF page;
step S4, recognizing all tables in the picture:
step S5, determining a specific table to be processed according to a business rule in all the tables; obtaining an effective table according to a table identification rule;
step S6, outputting the information of the effective table into a two-dimensional array;
s7, analyzing the information of the calculation book to be checked, matching the information of the calculation book with the information in the two-dimensional array of the effective table, and comparing data if the information of the calculation book is consistent with the information in the two-dimensional array of the effective table;
step S8, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing;
and step S9, comparing the numerical values of the cells which are in common weight in the calculation book and the drawing, wherein if the numerical values are not consistent, the data of the calculation book has an abnormality.
According to the method of the first aspect of the present invention, in the step S9, if there is an abnormality in the data of the calculation book, the method further includes: and performing system automatic annotation on the common duplication cells of the calculation book, wherein the annotation content is 'not in accordance with the drawing'.
According to the method of the first aspect of the present invention, in step S6, the specific method for outputting the information of the valid table as a two-dimensional array includes:
s6.1, initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table;
s6.2, extracting the content of the current cell from the first cell of the effective table; the last cell of the first row is taken and stored into the two-dimensional array;
s6.3, taking out the first cell in the second row, sequentially taking out the last row in the second row, and storing the last row in the two-dimensional array;
and S6.4, calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
According to the method of the first aspect of the present invention, in step S6, the method for calculating the absolute position of the valid table in the picture includes:
step S6.4.1, calculating the pixel position of the effective table in the picture;
step S6.4.2, calculating the coordinate value of each cell based on the pixel position of the effective table;
and S6.4.3, adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
According to the method of the first aspect of the present invention, in the step S7, the information of the application of the calculation book is matched with the information in the two-dimensional array of the valid table, and if the information of the application of the calculation book is consistent with the information in the two-dimensional array of the valid table, the method of performing data comparison includes:
analyzing the part name, the station number, the position, the type of the butt strap, the structural form and the angle of the bridge of the calculation book to be audited, matching the station number and the position of the calculation book with the station number and the position in the two-dimensional array of the effective table, and comparing data if the station number and the position of the calculation book are consistent with the station number and the position in the two-dimensional array of the effective table.
According to the method of the first aspect of the present invention, in step S8, the checking unit that the unit names of the calculation book and the drawing are the same, and the calculating method of the numerical value of the unit that is the same in the calculation book and the drawing includes:
and according to the calculation information of the first large column of the part in the calculation book and the consistent row information in the drawing, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing.
According to the method of the first aspect of the present invention, in the step S5, the table identification rule includes:
the identified table must have a table name with a number of rows > 2 and a number of columns > 2.
The second aspect of the present invention discloses a system for examining and verifying engineering quantity, which comprises:
the first processing module is configured to read a complete PDF file based on the PDF file uploaded by a user;
the second processing module is configured to split the PDF file needing specific page numbers according to the album name, the picture number code and the drawing page number filled in the engineering quantity calculation book index information column;
the third processing module is configured to perform picture conversion on the split PDF page;
the fourth processing module is configured to identify all tables in the picture;
a fifth processing module, configured to determine a specific table to be processed according to a business rule in all the tables; the specific table includes: a valid table, an annotation table, and a figure sheet basic information table;
a sixth processing module configured to output information of the valid table as a two-dimensional array;
the seventh processing module is configured to analyze the information of the calculation book to be audited, apply the information of the calculation book to match with the information in the two-dimensional array of the effective table, and if the information of the calculation book is consistent with the information in the two-dimensional array of the effective table, perform data comparison;
the eighth processing module is configured to check the cells with the names of the cells of the calculation book and the drawing as the co-weight cells and calculate the numerical value of the co-weight cells in the calculation book and the drawing;
and the ninth processing module is configured to compare the numerical values of the cells which are in common weight in the calculation book and the drawing, and if the numerical values are not consistent, the data of the calculation book has an exception.
According to the system of the second aspect of the present invention, the ninth processing module is configured to, if there is an abnormality in the data of the calculation book, further include: and performing system automatic annotation on the common duplication cells of the calculation book, wherein the annotation content is 'not in accordance with the drawing'.
According to the system of the second aspect of the present invention, the sixth processing module is configured to output the information of the valid table as a two-dimensional array specifically includes:
initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table;
taking out the content of the current cell from the first cell of the effective table; obtaining the last cell of the first row and storing the last cell into the two-dimensional array;
taking out the first cell of the second row, sequentially taking out the last row of the second row, and storing the last row into the two-dimensional array;
and calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
According to the system of the second aspect of the present invention, the sixth processing module is configured to calculate the absolute position of the valid table in the picture by:
calculating the pixel position of the effective table in the picture;
calculating coordinate values of each cell based on the pixel positions of the effective table;
and adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
According to the system of the second aspect of the present invention, the seventh processing module is configured to match the information of the application computer book with the information in the two-dimensional array of the valid table, and if the information of the application computer book is consistent with the information in the two-dimensional array of the valid table, performing data comparison includes:
analyzing the part name, the station number, the position, the type of the butt strap, the structural form and the angle of the bridge of the calculation book to be audited, matching the station number and the position of the calculation book with the station number and the position in the two-dimensional array of the effective table, and comparing data if the station number and the position of the calculation book are consistent with the station number and the position in the two-dimensional array of the effective table.
According to the system of the second aspect of the present invention, the eighth processing module is configured such that the check unit cell names of the calculation book and the drawing are the unit cells of the same weight, and the method of calculating the numerical value of the unit cell of the same weight in the calculation book and the drawing includes:
and according to the calculation information of the first large column of the part in the calculation book and the consistent row information in the drawing, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing.
According to the system of the second aspect of the present invention, the fifth processing module is configured to identify the rule by the table including:
the identified table must have a table name with a number of rows > 2 and a number of columns > 2.
A third aspect of the invention discloses an electronic device. The electronic device includes a memory and a processor, the memory stores a computer program, and the processor implements the steps in the engineering quantity auditing method according to any one of the first aspect of the disclosure when executing the computer program.
A fourth aspect of the invention discloses a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by a processor, performs the steps in a method for checking a work volume according to any one of the first aspect of the present disclosure.
According to the scheme provided by the invention, auditing is not limited by the limitation of the style and the format of the engineering quantity calculation book, the system can respectively identify according to the service rule according to the characteristics of different areas of the calculation book, and the identified data is classified and stored. Disassembling the calculation book into different units or calculation areas; comparing the characteristic values or characteristic data of different calculation areas with the table data identified by the PDF drawing in sequence row by row; the document is annotated automatically to the data that the contrast appears unusually, saves the time of manpower contrast completely, and automatic, intelligent audit efficiency promotes several times.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and other drawings can be obtained by those skilled in the art without creative efforts.
FIG. 1 is a flow chart of a method for auditing a project volume according to an embodiment of the invention;
FIG. 2 is a diagram of all tables in a picture according to an embodiment of the present invention;
FIG. 3 is a block diagram of an engineering quantity auditing system according to an embodiment of the present invention;
fig. 4 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, 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 with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The invention discloses a method for auditing the engineering quantity in a first aspect. Fig. 1 is a flowchart of an engineering volume auditing method according to an embodiment of the present invention, as shown in fig. 1, the method includes:
step S1, reading a complete PDF file based on the PDF file uploaded by the user;
step S2, splitting the PDF file of the specific page number according to the name, number and page number of the album filled in the project calculation book index information column;
step S3, carrying out picture conversion on the split PDF page;
step S4, recognizing all tables in the picture:
step S5, determining a specific table to be processed according to a business rule in all the tables; and obtaining the effective table according to the table identification rule.
Step S6, outputting the information of the effective table into a two-dimensional array;
s7, analyzing the information of the calculation book to be checked, matching the information of the calculation book with the information in the two-dimensional array of the effective table, and comparing data if the information of the calculation book is consistent with the information in the two-dimensional array of the effective table;
step S8, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing;
and step S9, comparing the numerical values of the cells which are in common weight in the calculation book and the drawing, wherein if the numerical values are not consistent, the data of the calculation book has an abnormality.
In some embodiments, in the step S9, if there is an abnormality in the data of the calculation book, the method further includes: and performing system automatic annotation on the co-duplication cells of the calculation books, wherein the annotation content is 'not in accordance with the drawing', the color of the annotation is red, and the rgb value: (250,100,0).
In step S1, based on the PDF file uploaded by the user, a complete PDF file is read.
Specifically, based on a PDF file uploaded by a user, a complete PDF file is read by PDF.
In step S2, the PDF file requiring a specific page number is divided according to the album name, the drawing number code, and the drawing page number filled in the engineering-quantity computation book index information column.
Specifically, a PDF (portable document format) file needing a specific page number is split by using a pdftk tool according to the name of the album, the number code of the drawing and the page number of the drawing filled in the engineering quantity calculation book index information column and is stored on a file server.
In step S3, the split PDF page is subjected to picture conversion.
Specifically, the split PDF pages are subjected to image conversion by using a graphismatick tool, and the converted image format is PNG.
In step S4, all tables in the picture are identified.
Specifically, the PNG picture is identified by ocr identification technology to identify all tables in the picture.
Step S5, determining a specific table to be processed according to a business rule in all the tables; and obtaining the effective table according to the table identification rule.
In some embodiments, the table identification rule comprises:
the identified table must have a table name with a number of rows > 2 and a number of columns > 2.
Specifically, in all the tables, a specific table to be processed is determined according to a business rule; as shown in fig. 2, there are three tables identified by step four, and fig. 2 shows: table (1) -pile foundation availability table; table (2) -comment table, table (3) -drawing page basic information; the identified table must have a table name, for example, the pile foundation valid table in table 1, the number of rows is greater than or equal to 2 and the number of columns is greater than or equal to 2, and the valid table is determined to be the pile foundation valid table in table 1 according to the rule, as shown in table 1.
TABLE 1
In step S6, the information of the valid table is output as a two-dimensional array.
In some embodiments, in the step S6, the specific method for outputting the information of the valid table into a two-dimensional array includes:
s6.1, initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table;
s6.2, extracting the content of the current cell from the first cell of the effective table; obtaining the last cell of the first row and storing the last cell into the two-dimensional array;
s6.3, taking out the first cell of the second row, sequentially taking out the last row of the second row, and storing the last row in the two-dimensional array;
and S6.4, calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
The method for calculating the absolute position of the effective table in the picture comprises the following steps:
step S6.4.1, calculating the pixel position of the effective table in the picture;
s6.4.2, calculating the coordinate value of each cell based on the pixel position of the effective table;
and S6.4.3, adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
Specifically, the specific method for outputting the information of the valid table into a two-dimensional array includes:
step S6.1, initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table, wherein the maximum column number of table 1 in the table 1 is 10;
s6.2, starting from the 'station number' of the first cell of the effective table, taking out the 'station number' of the content of the current cell; up to the last cell' concrete (m) of the first row3) ', and storing in said two-dimensional array;
s6.3, taking out the first cell-0 in the second row, sequentially (thinning to the name of each cell) taking out the last column C30:203.66.5 in the second row, and storing the two-dimensional array;
and S6.4, calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
Step S6.4.1, calculating the pixel positions of the effective table in the picture, wherein the pixel positions of four corners of the table 1-pile foundation material quantity table are respectively: upper left (X:954, Y:395), upper right (X:1472, Y:395), lower right (X:1472, Y:700), lower left (X:954, Y: 700);
step S6.4.2, calculating the coordinate values of each cell to be the upper left (X:391, Y:58), the upper right (X:443, Y:58), the lower right (X:443, Y:76) and the lower left (X:391, Y:76) based on the pixel position of the effective table;
and S6.4.3, adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
In step S7, the information of the calculation book to be audited is analyzed, the information of the calculation book is applied to match with the information in the two-dimensional array of the valid table, and if the information of the calculation book is consistent with the information in the two-dimensional array of the valid table, data comparison is performed.
In some embodiments, in the step S7, the information of the application calculation book is matched with the information in the two-dimensional array of the valid tables, and if the information is consistent, the method for performing data comparison includes:
analyzing the part name, the station number (pier number, pier station number and station body number), the position, the butt strap type, the bridge structure type and the angle of the calculation book to be audited, matching the station number and the position of the calculation book with the station number and the position in the two-dimensional array of the effective table, and comparing data if the station number and the position of the calculation book are consistent with those of the two-dimensional array of the effective table.
Specifically, the data of the pile foundation tab of the pending calculation book comprises: header area-table name: pile foundation engineering quantity table and construction unit: yyyyy, premise office-xxxxxx corporation;
as shown in table 2, data area: part information-part name; attribute-number, pile length (m) of phi 1.2m, pile length (m) of phi 1.8m, pile length (m) of phi 1.4m, reinforcement calculation area-reinforcement number, specification type, diameter (mm), single root length (cm), number, total length (m), unit weight (kg/m), total weight (kg); in other calculation areas, the pile length of the pile foundation is 1.2m, the pile length of the pile foundation is 1.8m, and the pile length of the pile foundation is 1.4 m; list hanging area-ribbed steel bar (HRB400) (kg) total, pile diameter 1.2m (m) total, pile diameter 1.8m (m) total, pile diameter 1.4m (m) total; retrieving information-album number, page number; and the value of each cell corresponding to the data region (not to mention the values of the cells here).
TABLE 2
Analyzing the name of the part of the calculation book, such as a left small pile number 0-1 pile foundation, and analyzing into a platform number: position 0: left panel; when the platform number and the position information of the matched drawing sheet 1-pile foundation engineering sheet are consistent, the platform number and the position information are judged to be data which are mutually compared;
in step S8, the cell names of the calculation book and the drawing are checked as the cells of common length and common weight, and the numerical values of the cells of common length and common weight in the calculation book and the drawing are calculated.
In some embodiments, in step S8, the checking unit names of the calculation book and the drawing are co-long and co-heavy units, and the calculating the value of the co-long and co-heavy units in the calculation book and the drawing includes:
and according to the calculation information of the first large column of the part in the calculation book and the consistent row information in the drawing, checking that the cell names of the calculation book and the drawing are the cells with the same length and the same weight, and calculating the numerical value of the cells with the same length and the same weight in the calculation book and the drawing.
Specifically, according to the steel bar number, specification type and diameter information of the position in the calculation book and the line information consistent with those in the drawing, the unit cell names of the calculation book and the drawing are checked to be the unit cells with common length and common weight, the numerical values of the unit cells with common length and common weight in the calculation book and the drawing are calculated, the common length numerical value in the calculation book is 319.97, and the value in the drawing table 1 is 1919.8; the total weight value is 7391, the value in the drawing table 1 is 7391.2, and the values of the total length and total weight cells of the calculated area of the steel bars are checked in sequence in each row.
In summary, the scheme provided by the invention can be used for auditing without being limited by the limitation of the style and the format of the engineering quantity calculation book, the system can respectively identify according to the service rules according to the characteristics of different areas of the calculation book, and the identified data is classified and stored. Disassembling the calculation book into different units or calculation areas; comparing the characteristic values or characteristic data of different calculation areas with the table data identified by the PDF drawing in sequence row by row; the document is annotated automatically to the data that the contrast appears unusually, saves the time of manpower contrast completely, and automatic, intelligent audit efficiency promotes several times.
The invention discloses a second aspect of the engineering quantity auditing system. FIG. 3 is a block diagram of an engineering quantity auditing system according to an embodiment of the present invention; as shown in fig. 3, the system 100 includes:
the second aspect of the present invention discloses a system for examining and verifying engineering quantity, which comprises:
the first processing module 101 is configured to read a complete PDF file based on a PDF file uploaded by a user;
the second processing module 102 is configured to split the PDF file requiring a specific page number according to the album name, the drawing number code and the drawing page number filled in the engineering quantity calculation book index information column;
a third processing module 103 configured to perform image conversion on the split PDF page;
a fourth processing module 104 configured to identify all tables in the picture;
a fifth processing module 105, configured to determine, in all the tables, a specific table to be processed according to a business rule; the specific table includes: a valid table, a comment table, and a figure sheet basic information table;
a sixth processing module 106 configured to output information of the valid table as a two-dimensional array;
a seventh processing module 107, configured to analyze information of the computation book to be audited, apply the information of the computation book to match with information in the two-dimensional array of the valid table, and if the information of the computation book is consistent with the information in the two-dimensional array of the valid table, perform data comparison;
an eighth processing module 108, configured to check the cells with the cell names of the calculation book and the drawing as the co-weighted cells, and calculate the numerical values of the co-weighted cells in the calculation book and the drawing;
a ninth processing module 109 configured to compare the numerical values of the cells of the computing book and the drawing that are co-extensive, and if the numerical values are not consistent, the data of the computing book has an exception.
According to the system of the second aspect of the present invention, the ninth processing module 109 is configured to, if there is an exception in the data of the calculation book, further include: and performing system automatic annotation on the common duplication cells of the calculation book, wherein the annotation content is 'not in accordance with the drawing'.
According to the system of the second aspect of the present invention, the sixth processing module 106 is configured to output the information of the valid table into a two-dimensional array specifically includes:
initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table;
taking out the content of the current cell from the first cell of the effective table; the last cell of the first row is taken and stored into the two-dimensional array;
taking out the first cell of the second row, sequentially taking out the last row of the second row, and storing the last row into the two-dimensional array;
and calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
According to the system of the second aspect of the present invention, the sixth processing module 106 is configured to calculate the absolute position of the valid table in the picture by:
calculating the pixel position of the effective table in the picture;
calculating coordinate values of each cell based on the pixel positions of the effective table;
and adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
According to the system of the second aspect of the present invention, the seventh processing module 107 is configured to match the information of the application computer book with the information in the two-dimensional array of the valid table, and if the information of the application computer book is consistent with the information in the two-dimensional array of the valid table, performing data comparison includes:
analyzing the part name, the station number, the position, the type of the butt strap, the structural form and the angle of the bridge of the calculation book to be audited, matching the station number and the position of the calculation book with the station number and the position in the two-dimensional array of the effective table, and comparing data if the station number and the position of the calculation book are consistent with the station number and the position in the two-dimensional array of the effective table.
According to the system of the second aspect of the present invention, the eighth processing module 108 is configured to check that the cell names of the calculation book and the drawing are the cells in common duplication, and the method for calculating the numerical value of the cells in common duplication in the calculation book and the drawing comprises:
and according to the calculation information of the first large column of the part in the calculation book and the consistent row information in the drawing, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing.
According to the system of the second aspect of the present invention, the fifth processing module 105 is configured to identify the rule by the table including:
the identified table must have a table name with a number of rows > 2 and a number of columns > 2.
A third aspect of the invention discloses an electronic device. The electronic device comprises a memory and a processor, the memory stores a computer program, and the processor implements the steps of the engineering quantity auditing method of any one of the first aspects of the disclosure when executing the computer program.
Fig. 4 is a block diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 4, the electronic device includes a processor, a memory, a communication interface, a display screen, and an input device, which are connected by a system bus. Wherein the processor of the electronic device is configured to provide computing and control capabilities. The memory of the electronic equipment comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the electronic device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, an operator network, Near Field Communication (NFC) or other technologies. The display screen of the electronic equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the electronic equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the electronic equipment, an external keyboard, a touch pad or a mouse and the like.
It will be understood by those skilled in the art that the structure shown in fig. 4 is only a partial block diagram related to the technical solution of the present disclosure, and does not constitute a limitation of the electronic device to which the solution of the present application is applied, and a specific electronic device may include more or less components than those shown in the drawings, or combine some components, or have a different arrangement of components.
A fourth aspect of the invention discloses a computer-readable storage medium. The computer readable storage medium has stored thereon a computer program which, when executed by the processor, implements the steps of a method for auditing a project amount according to any one of the first aspect of the present disclosure.
It should be noted that the technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, however, as long as there is no contradiction between the combinations of the technical features, the scope of the present description should be considered. The above examples only express several embodiments of the present application, and the description thereof is more specific and detailed, but not to be construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A project amount auditing method is characterized by comprising the following steps:
step S1, reading a complete PDF file based on the PDF file uploaded by the user;
step S2, splitting the PDF file of the specific page number according to the name, number and page number of the album filled in the project calculation book index information column;
step S3, carrying out picture conversion on the split PDF page;
step S4, identifying all tables in the picture;
step S5, determining a specific table to be processed according to a business rule in all the tables, and obtaining an effective table according to a table identification rule;
step S6, outputting the information of the effective table into a two-dimensional array;
s7, analyzing the information of the calculation book to be checked, matching the information of the calculation book with the information in the two-dimensional array of the effective table, and comparing data if the information of the calculation book is consistent with the information in the two-dimensional array of the effective table;
step S8, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing;
and step S9, comparing the numerical values of the cells which are in common weight in the calculation book and the drawing, wherein if the numerical values are not consistent, the data of the calculation book has an abnormality.
2. A project amount auditing method according to claim 1, characterized in that in step S9, if there is an abnormality in the data of the computer book, the method further comprises: and performing system automatic annotation on the common duplication cells of the calculation book, wherein the annotation content is 'not in accordance with the drawing'.
3. The method for auditing engineering quantities according to claim 2, wherein in the step S6, the specific method for outputting the information of the valid table into a two-dimensional array includes:
s6.1, initializing an empty two-dimensional array, and determining the maximum column number of each row of data of the effective table;
s6.2, extracting the content of the current cell from the first cell of the effective table; obtaining the last cell of the first row and storing the last cell into the two-dimensional array;
s6.3, taking out the first cell in the second row, sequentially taking out the last row in the second row, and storing the last row in the two-dimensional array;
and S6.4, calculating the absolute position of the effective table in the picture, and storing the absolute position into the two-dimensional array.
4. A method for auditing project quantity according to claim 3, wherein in the step S6, the method for calculating the absolute position of the effective table in the picture comprises:
step S6.4.1, calculating the pixel position of the effective table in the picture;
step S6.4.2, calculating the coordinate value of each cell based on the pixel position of the effective table;
and S6.4.3, adding the pixel positions of the picture and the coordinate values of each cell to obtain the absolute positions of the cells in the picture.
5. A method for auditing project volumes according to claim 1, wherein in step S7, the information of the application calculation book is matched with the information in the two-dimensional array of the valid tables, and if they are consistent, the method for data comparison comprises:
analyzing the part name, the station number, the position, the type of the butt strap, the structural form and the angle of the bridge of the calculation book to be audited, matching the station number and the position of the calculation book with the station number and the position in the two-dimensional array of the effective table, and comparing data if the station number and the position of the calculation book are consistent with the station number and the position in the two-dimensional array of the effective table.
6. The method for auditing project quantities according to claim 1, wherein in step S8, the check unit names of the calculation book and the drawing are the cells in common weight, and the method for calculating the numerical value of the cells in common weight in the calculation book and the drawing comprises:
and according to the calculation information of the first large column of the part in the calculation book and the consistent row information in the drawing, checking the cells with the names of the cells of the calculation book and the drawing as the cells with the same weight, and calculating the numerical value of the cells with the same weight in the calculation book and the drawing.
7. The project amount auditing method according to claim 1, characterized in that in step S5, the table identification rule includes:
the identified table must have a table name with a number of rows > 2 and a number of columns > 2.
8. A system for auditing quantities of work, the system comprising:
the first processing module is configured to read a complete PDF file based on the PDF file uploaded by a user;
the second processing module is configured to split the PDF file of which the specific page number is required according to the name of the album, the number code of the drawing and the page number of the drawing which are filled in the engineering quantity calculation book index information column;
the third processing module is configured to perform picture conversion on the split PDF page;
the fourth processing module is configured to identify all tables in the picture;
a fifth processing module, configured to determine a specific table to be processed according to a business rule in all the tables; the specific table includes: a valid table, an annotation table, and a figure sheet basic information table;
a sixth processing module configured to output information of the valid table as a two-dimensional array;
the seventh processing module is configured to analyze the information of the calculation book to be audited, apply the information of the calculation book to match with the information in the two-dimensional array of the effective table, and if the information of the calculation book is consistent with the information in the two-dimensional array of the effective table, perform data comparison;
the eighth processing module is configured to check the cells with the names of the cells of the calculation book and the drawing as the co-weight cells and calculate the numerical value of the co-weight cells in the calculation book and the drawing;
and the ninth processing module is configured to compare numerical values of cells which are in common weight in the calculation book and the drawing, and if the numerical values are not consistent, the data of the calculation book has an exception.
9. An electronic device, characterized in that the electronic device comprises a memory and a processor, the memory stores a computer program, and the processor implements the steps of a project amount auditing method according to any one of claims 1-7 when executing the computer program.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the steps of a method of auditing quantities of a project according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210424995.9A CN114724158A (en) | 2022-04-21 | 2022-04-21 | Engineering quantity auditing method and system, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210424995.9A CN114724158A (en) | 2022-04-21 | 2022-04-21 | Engineering quantity auditing method and system, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114724158A true CN114724158A (en) | 2022-07-08 |
Family
ID=82246499
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210424995.9A Pending CN114724158A (en) | 2022-04-21 | 2022-04-21 | Engineering quantity auditing method and system, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114724158A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116976840A (en) * | 2023-07-28 | 2023-10-31 | 北京梦诚科技有限公司 | Multi-person collaborative engineering quantity calculation book auditing method and system |
| CN117391332A (en) * | 2023-09-07 | 2024-01-12 | 中铁一局集团有限公司 | Engineering quantity calculation list hanging method, device, computer equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | The editing of electricity power engineering cost and inventory application system based on working drawing budget management |
| CN112017019A (en) * | 2020-07-10 | 2020-12-01 | 苏宁云计算有限公司 | Automatic reimbursement method and device based on PDF semantic extraction analysis, computer equipment and storage medium |
| CN112699635A (en) * | 2021-03-24 | 2021-04-23 | 杭州品茗安控信息技术股份有限公司 | Data entry method and related device for engineering cost software |
| CN112862446A (en) * | 2021-02-22 | 2021-05-28 | 上海市城市建设设计研究总院（集团）有限公司 | BIM (building information modeling) intelligent engineering quantity list generation method based on feature recognition |
| CN113326797A (en) * | 2021-06-17 | 2021-08-31 | 上海电气集团股份有限公司 | Method for converting form information extracted from PDF document into structured knowledge |
| CN113505669A (en) * | 2021-06-29 | 2021-10-15 | 万翼科技有限公司 | Form extraction method and device in engineering drawing, electronic equipment and storage medium |
| CN113762097A (en) * | 2021-08-18 | 2021-12-07 | 合肥联宝信息技术有限公司 | Automatic document auditing method and device and computer readable storage medium |
-
2022
- 2022-04-21 CN CN202210424995.9A patent/CN114724158A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | The editing of electricity power engineering cost and inventory application system based on working drawing budget management |
| CN112017019A (en) * | 2020-07-10 | 2020-12-01 | 苏宁云计算有限公司 | Automatic reimbursement method and device based on PDF semantic extraction analysis, computer equipment and storage medium |
| CN112862446A (en) * | 2021-02-22 | 2021-05-28 | 上海市城市建设设计研究总院（集团）有限公司 | BIM (building information modeling) intelligent engineering quantity list generation method based on feature recognition |
| CN112699635A (en) * | 2021-03-24 | 2021-04-23 | 杭州品茗安控信息技术股份有限公司 | Data entry method and related device for engineering cost software |
| CN113326797A (en) * | 2021-06-17 | 2021-08-31 | 上海电气集团股份有限公司 | Method for converting form information extracted from PDF document into structured knowledge |
| CN113505669A (en) * | 2021-06-29 | 2021-10-15 | 万翼科技有限公司 | Form extraction method and device in engineering drawing, electronic equipment and storage medium |
| CN113762097A (en) * | 2021-08-18 | 2021-12-07 | 合肥联宝信息技术有限公司 | Automatic document auditing method and device and computer readable storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 付欢 等: "基于BIM的工程量计算与计价方法", 《土木工程与管理学报》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116976840A (en) * | 2023-07-28 | 2023-10-31 | 北京梦诚科技有限公司 | Multi-person collaborative engineering quantity calculation book auditing method and system |
| CN116976840B (en) * | 2023-07-28 | 2024-03-15 | 北京梦诚科技有限公司 | Multi-person collaborative engineering quantity calculation book auditing method and system |
| CN117391332A (en) * | 2023-09-07 | 2024-01-12 | 中铁一局集团有限公司 | Engineering quantity calculation list hanging method, device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114724158A (en) | Engineering quantity auditing method and system, electronic equipment and storage medium | |
| CN111506498A (en) | Automatic generation method and device of test case, computer equipment and storage medium | |
| CN110990390B (en) | Data cooperative processing method, device, computer equipment and storage medium | |
| CN112036295B (en) | Bill image processing method and device, storage medium and electronic equipment | |
| CN108985066A (en) | Intelligent contract security vulnerability detection method, device, terminal and storage medium | |
| CN110209630A (en) | DXF file information processing method, device, computer equipment and storage medium | |
| CN113590823A (en) | Contract approval method and device, storage medium and electronic equipment | |
| CN112949443A (en) | Table structure identification method and device, electronic equipment and storage medium | |
| CN111651552A (en) | Structured information determination method and device and electronic equipment | |
| CN114049631A (en) | Data labeling method and device, computer equipment and storage medium | |
| CN115758451A (en) | Data labeling method, device, equipment and storage medium based on artificial intelligence | |
| CN115730605A (en) | Data analysis method based on multi-dimensional information | |
| US10643022B2 (en) | PDF extraction with text-based key | |
| CN113283231B (en) | Method for acquiring signature bit, setting system, signature system and storage medium | |
| CN113505273A (en) | Data sorting method, device, equipment and medium based on repeated data screening | |
| CN112818937A (en) | Excel file identification method and device, electronic equipment and readable storage medium | |
| WO2024001308A1 (en) | Template-based batch generation method and apparatus for infrared thermal image analysis reports | |
| CN116860747A (en) | Training sample generation method and device, electronic equipment and storage medium | |
| CN111427544A (en) | Software requirement document generation method and device, storage medium and electronic equipment | |
| CN111444235A (en) | Django-based data serialization method and device, computer equipment and storage medium | |
| CN114861614A (en) | Method and device for filling data, electronic equipment and medium | |
| CN101971171A (en) | Method and apparatus for the page-by-page provision of an electronic document as a computer graphic | |
| CN110110280B (en) | Curve integral calculation method, device and equipment for coordinates and storage medium | |
| CN113807901A (en) | Electronic invoice detection method, terminal equipment and storage medium | |
| CN112434157A (en) | Document multi-label classification method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20220708 |