CN116976840B - Multi-person collaborative engineering quantity calculation book auditing method and system - Google Patents
Multi-person collaborative engineering quantity calculation book auditing method and system Download PDFInfo
- Publication number
- CN116976840B CN116976840B CN202310944853.XA CN202310944853A CN116976840B CN 116976840 B CN116976840 B CN 116976840B CN 202310944853 A CN202310944853 A CN 202310944853A CN 116976840 B CN116976840 B CN 116976840B
- Authority
- CN
- China
- Prior art keywords
- file
- checked
- auditing
- auditor
- state
- 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.)
- Active
Links
- 238000004364 calculation method Methods 0.000 title claims abstract description 139
- 238000000034 method Methods 0.000 title claims abstract description 51
- 238000010276 construction Methods 0.000 claims abstract description 80
- 238000012550 audit Methods 0.000 claims description 24
- 238000012545 processing Methods 0.000 claims description 19
- 238000004590 computer program Methods 0.000 claims description 11
- 239000000463 material Substances 0.000 claims description 5
- 230000008520 organization Effects 0.000 claims description 5
- 230000001960 triggered effect Effects 0.000 claims description 5
- 238000004806 packaging method and process Methods 0.000 claims description 4
- 238000013461 design Methods 0.000 description 9
- 238000004891 communication Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 5
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000012552 review Methods 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000013507 mapping Methods 0.000 description 1
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/101—Collaborative creation, e.g. joint development of products or services
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/16—File or folder operations, e.g. details of user interfaces specifically adapted to file systems
-
- 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
- G06Q50/00—Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
- G06Q50/08—Construction
Abstract
The invention provides a multi-person collaborative engineering quantity calculation book auditing method and system. The method comprises the following steps: dividing the calculation book into independent files; establishing an association relationship between an independent file, a construction drawing and page numbers to form a file to be checked; dividing the auditing state of the file to be audited, and making auditing rights of the file to be audited for different auditors according to the auditing state; when the file to be checked is opened, according to the association relation, the associated construction drawing is automatically opened, and the associated page number is switched to be checked; and by changing the auditing state of the file to be audited, pushing the file to be audited after changing the auditing state to different auditors for auditing according to a predefined auditing flow. According to the scheme provided by the invention, the difficulty of searching the drawing by the auditor is eliminated, and the multi-level auditor can carry out problem annotation on the same to-be-checked calculation book at the same time.
Description
Technical Field
The invention belongs to the field of engineering quantity calculation, and particularly relates to a multi-person collaborative engineering quantity calculation book auditing method and system.
Background
When the construction industry works out the 0# list, the construction unit firstly gives the starting requirement of the 0# list working out work and provides a corresponding working template, then the construction unit calculates the engineering quantity according to the construction drawing and the engineering quantity calculation rule, the calculated result of the engineering quantity needs to be checked for correctness and rationality through the supervision unit, the engineering consultation unit and the audit unit entrusted by the construction unit, and the engineering quantity list is summarized after passing through the multiparty audit, so that the project 0# list is formed and used as the basic basis of metering payment.
The technical scheme adopted at present is that an Excel file is adopted as a data carrier for construction unit engineering quantity calculation, the Excel file is submitted to a supervision unit, an engineering consultation unit and an auditing unit for correctness auditing, an auditing person informs the construction unit of auditing opinions in the form of telephone, weChat or short message, and the construction unit is submitted to the auditing person again for auditing after being modified according to the opinions.
Disadvantages of the prior art
(1) The auditing of the auditor is based on the construction drawing, but the excel file and the construction drawing are completely independent files, the auditor needs to open the construction drawing to inquire the drawing content matched with the construction drawing according to the current calculation book content during auditing, one construction project engineering quantity calculation book is up to 500-1000 pages, the construction drawing is up to 20 pages, and a great amount of time is consumed for correspondingly carrying out calculation books and the construction drawing every time the construction drawing is close to 200 pages.
(2) The auditor needs to repeatedly audit the document submitted after modification, and the repeated workload is high;
(3) and a plurality of auditors need to wait for the audit of the previous auditor to be sequentially carried out after the previous auditor is completely audited, and the audit period is long. And 2-3 auditing periods are needed for each level of auditor, 6-9 months are needed for supervision, consultation and auditing of all auditing, and the finalization work of the item 0# list is seriously influenced, so that the later metering payment work cannot be normally carried out. The problem communication between the auditor and the submitter needs to be realized by means of the communication software of a third party, and the audit and modification record can not be recorded and stored;
(4) because a large number of identical designs exist in the engineering construction drawing, the identical designs mean that the engineering quantity is also equal, an auditor needs to check the correctness of the calculation book one by one engineering part, the identical designs need to be checked repeatedly, and a great amount of time is wasted, for example, a bridge has 1000 pile foundations, the pile diameter is 1.0m, the pile length is 10m, the pile diameter is 1.5m, the pile length is 20m, the pile diameter is 2.0m, the pile length is 30m, the pile diameter is 2.5, the pile length is 40m, the pile diameter is 3.0m, the pile length is 50m, 5 types of designs are required, and the auditor needs to check the pile foundations with the number of 1 to the pile foundations with the number of 1000 in the traditional mode.
Disclosure of Invention
In order to solve the technical problems, the invention provides a technical scheme of a multi-person collaborative engineering quantity calculation book auditing method, so as to solve the technical problems.
The invention discloses a multi-person collaborative engineering quantity calculation book auditing method, which comprises the following steps:
s1, dividing a calculation book into independent files; establishing an association relationship between the independent file, the construction drawing and page numbers to form a file to be checked;
s2, dividing the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
s3, according to the auditing state, auditing authorities of files to be audited are carried out on different auditors;
s4, when the auditor opens the file to be audited, automatically opening the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number, and switching to the associated page number to be audited by the auditor;
and S5, the auditor pushes the file to be audited after changing the auditing state to different auditors for auditing according to a predefined auditing flow by changing the auditing state of the file to be audited.
According to the method of the first aspect of the present invention, in the step S1, the method for establishing the association relationship between the independent file and the construction drawing and the page number includes:
a unique file code is given to the independent file, MD5 code and page number information of an electronic version construction drawing are obtained, and an association relationship between the file code and the MD5 code and page number of the construction drawing is established;
the method for forming the file to be audited comprises the following steps: and packaging the independent file, the construction drawing, the file code, the construction drawing MD5 code and the record file of the association relation between the page numbers into a file to be checked.
According to the method of the first aspect of the present invention, in the step S2, the auditing state includes:
pending status: the file to be checked is not checked by the organization where the checker is located;
status in audit: the file to be checked is checked by a checking person;
submitted state: the file to be checked is checked by the auditor and submitted to a subordinate auditor;
state to be modified: the file to be checked is checked by an auditor and is refused to be modified;
the checked state: and the auditing flow of the file to be audited is totally finished.
According to the method of the first aspect of the present invention, in the step S3, the method for making auditing rights of documents to be audited for different auditors according to the auditing status includes:
for the file to be checked in the state to be checked, the auditor can not open and only see the basic information of the calculation book; the basic information includes: calculating book name, presenter time and version submitted;
for a file to be checked in the checking state, a checker can check the content of the calculation book and the content of the construction drawing, and can insert checking notes into the calculation book and mark whether the calculation book is correct or not and whether a marking component is correct or not;
for the submitted state, the state to be modified, and the checked file of the checked state, the auditor can check the contents of the calculation book and the contents of the construction drawing, but cannot insert audit notes into the calculation book, mark whether the calculation book is correct, and mark whether the member is correct.
According to the method of the first aspect of the present invention, in the step S4, the method for auditing by the auditor includes:
when the file to be checked is checked repeatedly for a plurality of times, adding version numbers according to the submitting time to distinguish; and comparing each submission with the contents of the historical version of the calculation book table according to the positions in sequence, retrieving the changed text contents and cell formats, and identifying the differences.
According to the method of the first aspect of the present invention, in the step S4, the method for auditing by the auditor includes:
when a plurality of component data are contained in a calculation book of a document to be checked, the component data are used in a plurality of different calculation books at the same time, when one component data is marked as "correct" in the calculation book for the first time, the component data will be marked as "correct" when viewed in all calculation books using the component data.
According to the method of the first aspect of the present invention, in the step S4, the method for auditing by the auditor includes:
the data structure content in question in the calculation book of the file to be audited comprises: calculating the quantity content, the material items, the specification model, the list sub-items, the calculation formula and the figure number; and (3) carrying out problem marking in an annotation inserting mode, and when the problem marking is triggered, selecting row and column numbers of cells of a calculation book table by a mouse, endowing a unique problem code and binding with the file code.
The invention discloses a multi-person collaborative engineering quantity calculation book auditing system, which comprises:
a first processing module configured to divide the computing book into separate files; establishing an association relationship between the independent file, the construction drawing and page numbers to form a file to be checked;
the second processing module is configured to divide the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
the third processing module is configured to conduct auditing authorities of files to be audited on different auditors according to the auditing state;
the fourth processing module is configured to automatically open the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number when the auditor opens the file to be audited, and switch to the associated page number for auditing by the auditor;
and the fifth processing module is configured to push the files to be checked after the checking state is changed to different auditors for checking by the auditors through changing the checking state of the files to be checked according to a predefined checking flow.
A third aspect of the invention discloses an electronic device. The electronic device comprises a memory and a processor, the memory storing a computer program, the processor implementing the steps in a multi-person collaborative engineering quantity calculation book auditing method of any one of the first aspects of the present disclosure when executing the computer program.
A fourth aspect of the invention discloses a computer-readable storage medium. A computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps in a multi-person collaborative engineering quantity calculation book auditing method of any one of the first aspects of the present disclosure.
In summary, the proposal provided by the invention,
(1) when the auditor switches the content of the calculation book, the construction drawing changes along with the content of the calculation book, so that the difficulty of the auditor in searching the drawing is eliminated;
(2) the multi-level auditors can annotate the problems of the same to-be-audited computer book at the same time, classify and display the annotations according to different auditors, and enable the auditors and the submitters to reply to the problems in the software for communication and support the documents exported as work records to be in a specified format for archiving;
(3) for the re-submitted modification file, the content modified by the calculation staff can be identified, so that the auditing range can be reduced by the auditing person during review, and the auditing efficiency can be improved;
(4) and for the calculated components which are checked and considered to be correct, the software automatically identifies the same components in other files to be checked and automatically identifies the components to be correct, so that the repeated confirmation of the same data to be correct is avoided, and the check data quantity is reduced.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are needed in the description of the embodiments or the prior art will be briefly described, and it is obvious that the drawings in the description below are some embodiments of the present invention, and other drawings can be obtained according to the drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a method for auditing a multi-person collaborative engineering quantity calculation book according to an embodiment of the invention;
FIG. 2 is a block diagram of a multi-person collaborative engineering quantity calculation book auditing system according to an embodiment of the invention;
fig. 3 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are only some embodiments of the present invention, not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
The invention discloses a multi-person collaborative engineering quantity calculation book auditing method. Fig. 1 is a flowchart of a method for auditing a multi-user collaborative engineering quantity calculation book according to an embodiment of the present invention, as shown in fig. 1, the method includes:
s1, dividing a calculation book into independent files; establishing an association relationship between the independent file, the construction drawing and page numbers to form a file to be checked;
s2, dividing the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
s3, according to the auditing state, auditing authorities of files to be audited are carried out on different auditors;
s4, when the auditor opens the file to be audited, automatically opening the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number, and switching to the associated page number to be audited by the auditor;
and S5, the auditor pushes the file to be audited after changing the auditing state to different auditors for auditing according to a predefined auditing flow by changing the auditing state of the file to be audited.
In step S1, dividing a computer book into independent files; and establishing an association relation between the independent file, the construction drawing and the page number to form a file to be checked.
In some embodiments, in the step S1, the method for establishing the association relationship between the independent file and the construction drawing and the page number includes:
a unique file code is given to the independent file, MD5 code and page number information of an electronic version construction drawing are obtained, and an association relationship between the file code and the MD5 code and page number of the construction drawing is established;
the method for forming the file to be audited comprises the following steps: and packaging the independent file, the construction drawing, the file code, the construction drawing MD5 code and the record file of the association relation between the page numbers into a file to be checked.
In step S2, the auditing state of the file to be audited is divided according to the mode that the auditor operates the file to be audited.
In some embodiments, in the step S2, the auditing state includes:
pending status: the file to be checked is not checked by the organization where the checker is located;
status in audit: the file to be checked is checked by a checking person;
submitted state: the file to be checked is checked by the auditor and submitted to a subordinate auditor;
state to be modified: the file to be checked is checked by an auditor and is refused to be modified;
the checked state: and the auditing flow of the file to be audited is totally finished.
And step S3, according to the auditing state, auditing authorities of the files to be audited are carried out on different auditors.
In some embodiments, in the step S3, the method for making auditing rights of the document to be audited for different auditors according to the auditing status includes:
for the file to be checked in the state to be checked, the auditor can not open and only see the basic information of the calculation book; the basic information includes: calculating book name, presenter time and version submitted;
for a file to be checked in the checking state, a checker can check the content of the calculation book and the content of the construction drawing, and can insert checking notes into the calculation book and mark whether the calculation book is correct or not and whether a marking component is correct or not;
for the submitted state, the state to be modified, and the checked file of the checked state, the auditor can check the contents of the calculation book and the contents of the construction drawing, but cannot insert audit notes into the calculation book, mark whether the calculation book is correct, and mark whether the member is correct.
And S4, when the auditor opens the file to be audited, automatically opening the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number, and switching to the associated page number to be audited by the auditor.
In some embodiments, in the step S4, the method for auditing by the auditor includes:
when the file to be checked is checked repeatedly for a plurality of times, adding version numbers according to the submitting time to distinguish; and comparing each submission with the contents of the historical version of the calculation book table according to the positions in sequence, retrieving the changed text contents and cell formats, and identifying the differences.
The method for auditing by the auditor comprises the following steps:
when a plurality of component data are contained in a calculation book of a document to be checked, the component data are used in a plurality of different calculation books at the same time, when one component data is marked as "correct" in the calculation book for the first time, the component data will be marked as "correct" when viewed in all calculation books using the component data.
The method for auditing by the auditor comprises the following steps:
the data structure content in question in the calculation book of the file to be audited comprises: calculating the quantity content, the material items, the specification model, the list sub-items, the calculation formula and the figure number; and (3) carrying out problem marking in an annotation inserting mode, and when the problem marking is triggered, selecting row and column numbers of cells of a calculation book table by a mouse, endowing a unique problem code and binding with the file code.
Specifically, when the auditor opens the file to be audited, according to the association relationship between the file code and the MD5 code and page number of the construction drawing, the auditor automatically opens the associated construction drawing and switches to the associated page number for auditing.
The data dimension of the audit is a calculation book, and when one calculation book is opened, the calculation book is displayed in the following areas:
calculating book attributes, calculating book self attributes and hanging navigation tree nodes;
a calculation book table is presented in an excel table mode by the position row and the calculation amount content column;
calculating drawing document md5 information associated with a book, wherein a unique drawing document can be obtained by the drawing md 5;
the calculation book contains a plurality of component data.
When specific calculation content in the calculation book is clicked, calculating a view area according to the specific page of the drawing file corresponding to the calculation content and the relative area coordinates of the content in the page number, and carrying out linkage display.
In summary, the proposal provided by the invention,
(1) after the engineering quantity calculation result is finished, respectively endowing a calculation book and a construction drawing with unique file codes, recording the corresponding relation between the calculation book codes and the construction drawing codes, distributing the calculation book and the construction drawing files to all auditors with approval authority, and when the auditors open the calculation book content, realizing switching calculation books according to the code mapping relation between the calculation book and the construction drawing, wherein the construction drawing follows switching display;
(2) by comparing characters of the content of the computer book, retrieving the changed text content and cell format, providing a difference item identifier between two versions, rapidly positioning the modification item, and avoiding repeated auditing during review;
(3) the multi-stage auditor can carry out problem annotation on the same to-be-audited computer book at the same time, the annotation content is bound with the code of the computer book, the annotation content is searched through the code of the computer book, the real-time display of the annotation problem is realized, and after the audit is finished, the name of the computer book, the auditor and the audit opinion form an audit record according to a fixed format through the code corresponding relation between the code of the computer book and the audit annotation;
(4) the method comprises the steps of combining the identical calculation book content of data into one component by carrying out data comparison on position information, structural design information and engineering quantity information in the calculation book, and automatically identifying identical auditing results by all identical components in the system after one component is audited; for example, a bridge has 1000 pile foundations, the pile diameter is 1.0m, the pile length is 10m, the pile diameter is 1.5m, the pile length is 20m, the pile diameter is 2.0m, the pile length is 30m, the pile diameter is 2.5, the pile length is 40m, the pile diameter is 3.0m, the pile length is 50m, 5 types of designs are adopted, after the designs are combined into a component, each design type corresponds to one component, 5 design types correspond to 5 components, and an auditor can complete the audit of the content of the part only by 5 time units.
The invention discloses a multi-person collaborative engineering quantity calculation book auditing system. FIG. 2 is a block diagram of a multi-person collaborative engineering quantity calculation book auditing system according to an embodiment of the invention; as shown in fig. 2, the system 100 includes:
a first processing module 101 configured to divide the calculation book into independent files; establishing an association relationship between the independent file, the construction drawing and page numbers to form a file to be checked;
the second processing module 102 is configured to divide the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
a third processing module 103, configured to make auditing rights of the file to be audited for different auditors according to the auditing state;
a fourth processing module 104, configured to automatically open the associated construction drawing according to the association relationship between the independent file and the construction drawing and the page number when the auditor opens the file to be audited, and switch to the associated page number for auditing by the auditor;
and the fifth processing module 105 is configured to push the file to be checked after changing the checking state to different auditors for checking by changing the checking state of the file to be checked according to a predefined checking flow.
According to the system of the second aspect of the present invention, the first processing module 101 is specifically configured such that the method for establishing the association relationship between the independent file and the construction drawing and the page number includes:
a unique file code is given to the independent file, MD5 code and page number information of an electronic version construction drawing are obtained, and an association relationship between the file code and the MD5 code and page number of the construction drawing is established;
the method for forming the file to be audited comprises the following steps: and packaging the independent file, the construction drawing, the file code, the construction drawing MD5 code and the record file of the association relation between the page numbers into a file to be checked.
The system according to the second aspect of the present invention, the second processing module 102 is specifically configured to, the audit state includes:
pending status: the file to be checked is not checked by the organization where the checker is located;
status in audit: the file to be checked is checked by a checking person;
submitted state: the file to be checked is checked by the auditor and submitted to a subordinate auditor;
state to be modified: the file to be checked is checked by an auditor and is refused to be modified;
the checked state: and the auditing flow of the file to be audited is totally finished.
According to the system of the second aspect of the present invention, the third processing module 103 is specifically configured to, according to the auditing status, make the auditing authority of the document to be audited for different auditors, where the method includes:
for the file to be checked in the state to be checked, the auditor can not open and only see the basic information of the calculation book; the basic information includes: calculating book name, presenter time and version submitted;
for a file to be checked in the checking state, a checker can check the content of the calculation book and the content of the construction drawing, and can insert checking notes into the calculation book and mark whether the calculation book is correct or not and whether a marking component is correct or not;
for the submitted state, the state to be modified, and the checked file of the checked state, the auditor can check the contents of the calculation book and the contents of the construction drawing, but cannot insert audit notes into the calculation book, mark whether the calculation book is correct, and mark whether the member is correct.
The system according to the second aspect of the present invention, the fourth processing module 104 is specifically configured to perform the method for auditing by the auditor, including:
when the file to be checked is checked repeatedly for a plurality of times, adding version numbers according to the submitting time to distinguish; and comparing each submission with the contents of the historical version of the calculation book table according to the positions in sequence, retrieving the changed text contents and cell formats, and identifying the differences.
The method for auditing by the auditor comprises the following steps:
when a plurality of component data are contained in a calculation book of a document to be checked, the component data are used in a plurality of different calculation books at the same time, when one component data is marked as "correct" in the calculation book for the first time, the component data will be marked as "correct" when viewed in all calculation books using the component data.
The method for auditing by the auditor comprises the following steps:
the data structure content in question in the calculation book of the file to be audited comprises: calculating the quantity content, the material items, the specification model, the list sub-items, the calculation formula and the figure number; and (3) carrying out problem marking in an annotation inserting mode, and when the problem marking is triggered, selecting row and column numbers of cells of a calculation book table by a mouse, endowing a unique problem code and binding with the file code.
Specifically, when the auditor opens the file to be audited, according to the association relationship between the file code and the MD5 code and page number of the construction drawing, the auditor automatically opens the associated construction drawing and switches to the associated page number for auditing.
The data dimension of the audit is a calculation book, and when one calculation book is opened, the calculation book is displayed in the following areas:
calculating book attributes, calculating book self attributes and hanging navigation tree nodes;
a calculation book table is presented in an excel table mode by the position row and the calculation amount content column;
calculating drawing document md5 information associated with a book, wherein a unique drawing document can be obtained by the drawing md 5;
the calculation book contains a plurality of component data.
When specific calculation content in the calculation book is clicked, calculating a view area according to the specific page of the drawing file corresponding to the calculation content and the relative area coordinates of the content in the page number, and carrying out linkage display.
A third aspect of the invention discloses an electronic device. The electronic device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps in the multi-person collaborative engineering quantity calculation book auditing method of any one of the first aspect of the disclosure when executing the computer program.
Fig. 3 is a block diagram of an electronic device according to an embodiment of the present invention, and as shown in fig. 3, the electronic device includes a processor, a memory, a communication interface, a display screen, and an input device connected through a system bus. Wherein the processor of the electronic device is configured to provide computing and control capabilities. The memory of the electronic device includes 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 the operating system and computer programs in the non-volatile storage media. The communication interface of the electronic device is used for conducting wired or wireless communication with an external terminal, and the wireless communication can be achieved 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, can also be keys, a track ball or a touch pad arranged on the shell of the electronic equipment, and can also be an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the structure shown in fig. 3 is merely a structural diagram of a portion related to the technical solution of the present disclosure, and does not constitute a limitation of the electronic device to which the present application is applied, and that a specific electronic device may include more or less components than those shown in the drawings, or may combine some components, or have different component arrangements.
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 of a method for auditing a multi-person collaborative engineering quantity calculation book according to any one of the first aspects of the present disclosure.
Note that the technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be regarded as the scope of the description. The foregoing examples represent only a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the claims appended hereto.
Claims (5)
1. The method for auditing the engineering quantity calculation books by a plurality of persons is characterized by comprising the following steps:
s1, dividing a calculation book into independent files; establishing an association relationship between the independent file, the construction drawing and the page number to form a file to be checked;
s2, dividing the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
s3, according to the auditing state, auditing authorities of files to be audited are carried out on different auditors;
s4, when the auditor opens the file to be audited, automatically opening the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number, and switching to the associated page number to be audited by the auditor;
s5, the auditor pushes the file to be audited after changing the auditing state to different auditors for auditing according to a predefined auditing flow by changing the auditing state of the file to be audited;
in the step S2, the auditing state includes:
pending status: the file to be checked is not checked by the organization where the checker is located;
status in audit: the file to be checked is checked by a checking person;
submitted state: the file to be checked is checked by the auditor and submitted to a subordinate auditor;
state to be modified: the file to be checked is checked by an auditor and is refused to be modified;
the checked state: the auditing flow of the file to be audited is totally finished;
in the step S3, the method for performing the auditing rights of the document to be audited for different auditors according to the auditing state includes:
for the file to be checked in the state to be checked, the auditor can not open and only see the basic information of the calculation book; the basic information includes: calculating book name, presenter time and version submitted;
for a file to be checked in the checking state, a checker can check the content of the calculation book and the content of the construction drawing, and can insert checking notes into the calculation book and mark whether the calculation book is correct or not and whether a marking component is correct or not;
for the files to be checked of the submitted state, the state to be modified and the checked state, the auditor can check the content of the calculation book and the content of the construction drawing, but can not insert audit notes into the calculation book, mark whether the calculation book is correct or not and mark whether the component is correct or not;
in the step S4, the method for auditing by the auditor includes:
when the file to be checked is checked repeatedly for a plurality of times, adding version numbers according to the submitting time to distinguish; meanwhile, each submission is sequentially compared with the contents of the historical version of the calculation book table according to the position, the changed text contents and the cell format are retrieved, and different parts are identified;
in the step S4, the method for auditing by the auditor includes:
when a plurality of component data are contained in a calculation book of a file to be checked, the component data are simultaneously used in a plurality of different calculation books, when one component data is marked as 'correct' in the calculation book for the first time, the component data are marked as 'correct' when being checked in all calculation books using the component data;
in the step S4, the method for auditing by the auditor includes:
the data structure content in question in the calculation book of the file to be audited comprises: calculating the quantity content, the material items, the specification model, the list sub-items, the calculation formula and the figure number; and (3) carrying out problem marking in an annotation inserting mode, and when the problem marking is triggered, selecting row and column numbers of cells of the calculation book table by a mouse, endowing a unique problem code and binding with the file code.
2. The method according to claim 1, wherein in the step S1, the method for establishing the association relationship between the independent file and the construction drawing and the page number includes:
a unique file code is given to the independent file, MD5 code and page number information of an electronic version construction drawing are obtained, and an association relationship between the file code and the MD5 code and page number of the construction drawing is established;
the method for forming the file to be audited comprises the following steps: and packaging the independent file, the construction drawing, the file code, the construction drawing MD5 code and the record file of the association relation between the page numbers into a file to be checked.
3. An engineering quantity calculation book auditing system for multi-person collaboration, the system comprising:
a first processing module configured to divide the computing book into separate files; establishing an association relationship between the independent file, the construction drawing and the page number to form a file to be checked;
the second processing module is configured to divide the auditing state of the file to be audited according to the mode that the auditor operates the file to be audited;
the auditing state includes:
pending status: the file to be checked is not checked by the organization where the checker is located;
status in audit: the file to be checked is checked by a checking person;
submitted state: the file to be checked is checked by the auditor and submitted to a subordinate auditor;
state to be modified: the file to be checked is checked by an auditor and is refused to be modified;
the checked state: the auditing flow of the file to be audited is totally finished;
the third processing module is configured to conduct auditing authorities of files to be audited on different auditors according to the auditing state;
the auditing authority of the file to be audited for different auditors comprises the following steps:
for the file to be checked in the state to be checked, the auditor can not open and only see the basic information of the calculation book; the basic information includes: calculating book name, presenter time and version submitted;
for a file to be checked in the checking state, a checker can check the content of the calculation book and the content of the construction drawing, and can insert checking notes into the calculation book and mark whether the calculation book is correct or not and whether a marking component is correct or not;
for the files to be checked of the submitted state, the state to be modified and the checked state, the auditor can check the content of the calculation book and the content of the construction drawing, but can not insert audit notes into the calculation book, mark whether the calculation book is correct or not and mark whether the component is correct or not;
the fourth processing module is configured to automatically open the associated construction drawing according to the association relation among the independent file, the construction drawing and the page number when the auditor opens the file to be audited, and switch to the associated page number for auditing by the auditor;
the auditing by the auditor comprises the following steps:
when the file to be checked is checked repeatedly for a plurality of times, adding version numbers according to the submitting time to distinguish; meanwhile, each submission is sequentially compared with the contents of the historical version of the calculation book table according to the position, the changed text contents and the cell format are retrieved, and different parts are identified;
the auditing by the auditor comprises the following steps:
when a plurality of component data are contained in a calculation book of a file to be checked, the component data are simultaneously used in a plurality of different calculation books, when one component data is marked as 'correct' in the calculation book for the first time, the component data are marked as 'correct' when being checked in all calculation books using the component data;
the auditing by the auditor comprises the following steps:
the data structure content in question in the calculation book of the file to be audited comprises: calculating the quantity content, the material items, the specification model, the list sub-items, the calculation formula and the figure number; the method comprises the steps that problem marking is carried out in an annotation inserting mode, when the problem marking is recorded and triggered, a mouse selects row and column numbers of cells of a calculation book form, a unique problem code is given, and the unique problem code is bound with a file code;
and the fifth processing module is configured to push the files to be checked after the checking state is changed to different auditors for checking by the auditors through changing the checking state of the files to be checked according to a predefined checking flow.
4. An electronic device comprising a memory and a processor, the memory storing a computer program, the processor implementing the steps in a multi-person collaborative engineering quantity calculation book auditing method of any one of claims 1-2 when the computer program is executed.
5. A computer readable storage medium, characterized in that the computer readable storage medium has stored thereon a computer program which, when executed by a processor, implements the steps of a multi-person collaborative engineering quantity calculation book auditing method according to any one of claims 1-2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310944853.XA CN116976840B (en) | 2023-07-28 | 2023-07-28 | Multi-person collaborative engineering quantity calculation book auditing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310944853.XA CN116976840B (en) | 2023-07-28 | 2023-07-28 | Multi-person collaborative engineering quantity calculation book auditing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116976840A CN116976840A (en) | 2023-10-31 |
| CN116976840B true CN116976840B (en) | 2024-03-15 |
Family
ID=88482727
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310944853.XA Active CN116976840B (en) | 2023-07-28 | 2023-07-28 | Multi-person collaborative engineering quantity calculation book auditing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116976840B (en) |
Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504741A (en) * | 2009-02-18 | 2009-08-12 | 路桥集团国际建设股份有限公司 | Intelligent metering management system and method for construction engineering |
| JP2011060296A (en) * | 2010-09-17 | 2011-03-24 | Intertrust Technologies Corp | Method for managing use of electronic content |
| CN103646315A (en) * | 2013-12-16 | 2014-03-19 | 国家电网公司 | Method and device for data processing in electricity bureau engineering project workflow |
| CN105512406A (en) * | 2015-12-10 | 2016-04-20 | 国网山东省电力公司经济技术研究院 | Electronic drawing and engineering quantity associating system and method |
| CN109064126A (en) * | 2018-07-18 | 2018-12-21 | 长江勘测规划设计研究有限责任公司 | Hydroelectric project metrical information management method based on quality driving |
| CN109885904A (en) * | 2019-01-29 | 2019-06-14 | 杭州凌望建筑科技有限公司 | Multidimensional mould based on BIM examines construction collaborative platform |
| CN110188999A (en) * | 2019-05-15 | 2019-08-30 | 广州智企信息技术有限公司 | DMS digital production management system |
| CN111210104A (en) * | 2019-12-11 | 2020-05-29 | 中兵勘察设计研究院有限公司 | Construction drawing digital combined collaborative inspection system and method based on cloud platform |
| CN111401008A (en) * | 2020-03-09 | 2020-07-10 | 网易（杭州）网络有限公司 | Document auditing system, document auditing method and device |
| CN114724158A (en) * | 2022-04-21 | 2022-07-08 | 北京梦诚科技有限公司 | Engineering quantity auditing method and system, electronic equipment and storage medium |
| CN116151897A (en) * | 2022-12-29 | 2023-05-23 | 英思达(广州)科技有限公司 | BIM model-based manufacturing cost management method, system, medium and equipment |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2015073708A1 (en) * | 2013-11-14 | 2015-05-21 | Intralinks, Inc. | Litigation support in cloud-hosted file sharing and collaboration |
| US20170329942A1 (en) * | 2016-05-12 | 2017-11-16 | Markany Inc. | Method and apparatus of drm systems for protecting enterprise confidentiality |
-
2023
- 2023-07-28 CN CN202310944853.XA patent/CN116976840B/en active Active
Patent Citations (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101504741A (en) * | 2009-02-18 | 2009-08-12 | 路桥集团国际建设股份有限公司 | Intelligent metering management system and method for construction engineering |
| JP2011060296A (en) * | 2010-09-17 | 2011-03-24 | Intertrust Technologies Corp | Method for managing use of electronic content |
| CN103646315A (en) * | 2013-12-16 | 2014-03-19 | 国家电网公司 | Method and device for data processing in electricity bureau engineering project workflow |
| CN105512406A (en) * | 2015-12-10 | 2016-04-20 | 国网山东省电力公司经济技术研究院 | Electronic drawing and engineering quantity associating system and method |
| CN109064126A (en) * | 2018-07-18 | 2018-12-21 | 长江勘测规划设计研究有限责任公司 | Hydroelectric project metrical information management method based on quality driving |
| CN109885904A (en) * | 2019-01-29 | 2019-06-14 | 杭州凌望建筑科技有限公司 | Multidimensional mould based on BIM examines construction collaborative platform |
| CN110188999A (en) * | 2019-05-15 | 2019-08-30 | 广州智企信息技术有限公司 | DMS digital production management system |
| CN111210104A (en) * | 2019-12-11 | 2020-05-29 | 中兵勘察设计研究院有限公司 | Construction drawing digital combined collaborative inspection system and method based on cloud platform |
| CN111401008A (en) * | 2020-03-09 | 2020-07-10 | 网易（杭州）网络有限公司 | Document auditing system, document auditing method and device |
| CN114724158A (en) * | 2022-04-21 | 2022-07-08 | 北京梦诚科技有限公司 | Engineering quantity auditing method and system, electronic equipment and storage medium |
| CN116151897A (en) * | 2022-12-29 | 2023-05-23 | 英思达(广州)科技有限公司 | BIM model-based manufacturing cost management method, system, medium and equipment |
Non-Patent Citations (3)
| Title |
|---|
| Ken T.Trotman Tim D.Baure Kerry A. Humphreys.Group judgment and decision making in auditing: Past and future research.Accounting, Organizations and Society.2015,56-72. * |
| 贺燕 ; 贺芸 ; 徐敏 ; .档案数字化工作业务流程优化.电脑编程技巧与维护.2017,(第06期),19-20、25. * |
| 闫玉 ; 魏志友 ; 聂标涛 ; 于超 ; 巨杨妮 ; .基于三维产品模型的车用发动机服务性资料管理系统.客车技术与研究.2016,(第02期),59-62. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116976840A (en) | 2023-10-31 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Mani et al. | In search of pollution havens? Dirty industry in the world economy, 1960 to 1995 | |
| Al-Assaf et al. | The textbook of total quality in healthcare | |
| Maybury | New directions in question answering | |
| Wan et al. | Resource-based theory and corporate diversification: Accomplishments and opportunities | |
| CN109948134A (en) | A kind of report automatic generation method, system and electronic equipment and storage medium | |
| CN107145480B (en) | Method for compiling XBRL report based on Word | |
| Brandl et al. | Nicebook: supporting natural note taking | |
| JP2005508552A (en) | Memory system for data objects | |
| CN101739452A (en) | Data exchange interface and realizing method thereof | |
| US20150301706A1 (en) | Identifiable tabbing for bookmarks in electronic books | |
| US7370060B2 (en) | System and method for user edit merging with preservation of unrepresented data | |
| CN109658215A (en) | Transaction account calculation method, device and computer readable storage medium | |
| CN100465882C (en) | Method and system of establishing culture sensitive control element for global application | |
| CN106021207A (en) | A patent writing system and method | |
| CN109597979A (en) | Inventory table generation method, device, computer equipment and storage medium | |
| Dasarathy | Image data compression: block truncation coding | |
| CN107798459A (en) | Parameter values computational methods, device, storage medium and computer equipment | |
| CN114724158A (en) | Engineering quantity auditing method and system, electronic equipment and storage medium | |
| CN116976840B (en) | Multi-person collaborative engineering quantity calculation book auditing method and system | |
| CN111612379A (en) | Audit scheme automatic generation method and device | |
| Chavez et al. | Services make the repository | |
| Singh et al. | Personalized information access in a wiki using structured tagging | |
| US8775408B2 (en) | Document element indexing system | |
| Li et al. | The Research of Multimedia Complex Intelligent System in Financial Reporting Mode | |
| Gen et al. | Genetic algorithms and manufacturing systems design |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |