CN110796336B - Audit project implementation quality monitoring method and equipment based on data analysis - Google Patents
Audit project implementation quality monitoring method and equipment based on data analysis Download PDFInfo
- Publication number
- CN110796336B CN110796336B CN201910882483.5A CN201910882483A CN110796336B CN 110796336 B CN110796336 B CN 110796336B CN 201910882483 A CN201910882483 A CN 201910882483A CN 110796336 B CN110796336 B CN 110796336B
- Authority
- CN
- China
- Prior art keywords
- information
- check object
- spot check
- audit
- attention point
- 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
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/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06395—Quality analysis or management
-
- 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/18—File system types
- G06F16/1805—Append-only file systems, e.g. using logs or journals to store data
- G06F16/1815—Journaling 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
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Educational Administration (AREA)
- Development Economics (AREA)
- Data Mining & Analysis (AREA)
- Game Theory and Decision Science (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses an audit project implementation quality monitoring method and equipment based on data analysis, wherein the method comprises the following steps: decomposing and extracting the acquired field implementation to obtain target focus information; decomposing and extracting the acquired spot check object list to obtain target spot check object information; decomposing and extracting the obtained audit log to obtain actual focus information and actual spot check object information; generating attention point completion condition information according to the attention point matching result; and generating spot check object completion condition information according to the spot check object matching result. The focus completion condition information and spot check object completion condition information clearly reflect the implementation quality of the whole audit project; the monitoring data is automatically calculated by the algorithm after the audit personnel fills the log, so that the monitoring result can be obtained more quickly; the method has the advantages that manual intervention is not needed, and the monitoring result is more real and reliable.
Description
Technical Field
The invention relates to the technical field of auditing, in particular to an auditing project implementation quality monitoring method based on data analysis.
Background
The audit project is a series of audit activities performed on the audited units by auditors according to an audit work plan in order to achieve a given audit goal. The system is generally referred to as various special audit and leaving economic responsibility audit projects in the mode of taking traditional manual audit and on-site audit as main work by the audit departments in the national enterprises and institutions.
The on-site implementation scheme is an instructional file for guiding an auditor to carry out on-site audit work, and comprises the attention points of the audit project and the spot check objects of the audit project; the concern is specific audit contents set by an audit project responsible person according to an audit target, an audit work plan and a pre-audit investigation situation when the audit project responsible person makes an audit project field implementation scheme, and the specific audit contents of the audit work carried out by the audit person; the spot check object refers to a specific audit object after audit sampling when the audit is carried out on the audited unit, and the specific audit object is a specific audit object when the audit staff carries out audit work, and is generally conference data, financial certificates, power consumers and the like;
the existing audit project is subjected to the implementation quality monitoring method, wherein the manual evaluation is performed after the audit project is completed, and hysteresis exists; the evaluation process is to score according to the evaluation index by an expert, and then calculate the score according to a specific algorithm; this method is highly subjective and relies on the experience of the expert; time and effort are wasted and errors or deviations are unavoidable.
Disclosure of Invention
The invention mainly aims to provide an audit project implementation quality monitoring method and equipment based on data analysis, and aims to solve the problems that in the prior art, the audit project implementation quality monitoring method mainly carries out manual evaluation after the completion of the audit project and has hysteresis; and the manual evaluation has strong subjectivity, relies on the experience of an expert, and is time-consuming and labor-consuming, and is difficult to avoid errors or have a bias problem.
The invention provides an audit project implementation quality monitoring method based on data analysis, which is applied to audit project implementation quality monitoring equipment based on data analysis, wherein the monitoring equipment comprises a processor and a memory; the monitoring method comprises the following steps:
acquiring a field implementation, decomposing and extracting the acquired field implementation to obtain target focus information, and storing the target focus information into the memory;
acquiring an spot check object list, decomposing and extracting the acquired spot check object list to obtain target spot check object information, and storing the target spot check object information into the memory;
obtaining an audit log, decomposing and extracting the obtained audit log to obtain actual focus information and actual spot check object information, and storing the actual focus information and the actual spot check object information into the memory;
Matching the actual attention point information with the target attention point information to obtain attention point matching results, and generating attention point completion condition information according to the attention point matching results;
matching the actual spot check object information with the target spot check object information to obtain a spot check object matching result, and generating spot check object completion condition information according to the spot check object matching result.
Preferably, the matching the actual point of interest information with the target point of interest information to obtain a point of interest matching result, and generating the point of interest completion condition information according to the point of interest matching result includes:
obtaining a evidence obtaining table, decomposing and extracting the obtained evidence obtaining table to obtain problem focus information, and storing the problem focus information into a memory;
and matching the problem attention point information with the actual attention point information to obtain a problem attention point matching result, and generating attention point problem situation information according to the problem attention point matching result.
Preferably, the decomposing and extracting the imported field implementation to obtain target point of interest information includes:
Decomposing and extracting the obtained field implementation;
classifying the target focus information obtained after decomposition and extraction according to the field and classifying according to links to obtain a plurality of pieces of target focus information.
Preferably, the matching the actual attention point information with the target attention point information to obtain an attention point matching result, and generating attention point completion condition information according to the attention point matching result, includes:
calculating according to the actual attention point information and the target attention point information to obtain the attention point matching result;
according to the attention point matching result, attention point manpower investment and attention point coverage rate are calculated;
and determining the attention point manpower input and the attention point coverage rate as the attention point completion condition information.
Preferably, the calculation formula of the attention point matching result is as follows, wherein the attention point matching result is obtained by calculating according to actual attention point information and the target attention point information:
wherein PRG dij The target attention point information is obtained by matching the audit log imported for the ith audit member on the d day with the jth target attention point information; a, a j The j-th target attention point information; RG (radio frequency identification) di { } is the set of the actual point of interest information in the audit log imported by the ith audit member on day d; d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, m is the number of the target point of interest information, and D, n and m are both positive integers.
Preferably, the calculating according to the attention point matching result to obtain attention point manpower input and attention point coverage rate includes:
the labor input of the ith audit member to the jth target attention point information in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein k is dij Human input for the jth target attention point information in the audit log imported on any day for the ith audit member;
and calculating the labor investment of the attention point, wherein the calculation formula is as follows:
wherein RLTR Dj The human input for the attention point represents all human inputs for the j-th target attention point information from the day D;
judging whether the target attention point information is inspected or not from the day D to the day j, and acquiring a judging result, wherein the calculating formula of the judging result is as follows:
Wherein when X is Dj When X is equal to or greater than 1, the target point of interest information is examined by day j Dj When=0, it means that the target point of interest information is not examined by the j th day of the D-th day;
calculating the coverage rate of the attention points, wherein the calculation formula is as follows:
wherein FGL D And (3) representing the duty ratio of the inspected target attention point information in all the target attention point information from the day D for the attention point coverage rate.
Preferably, the matching the actual spot check object information with the target spot check object information to obtain a spot check object matching result, and generating spot check object completion condition information according to the spot check object matching result, includes:
calculating according to the actual spot check object information and the target spot check object information to obtain a spot check object matching result;
according to the spot check object matching result, calculating to obtain the spot check object manpower input and the spot check object coverage;
and determining the labor input of the spot check object and the coverage rate of the spot check object as the spot check object completion condition information.
Preferably, the matching the problem focus information with the actual focus information to obtain a problem focus matching result, and generating focus condition information according to the problem focus matching result, includes:
Calculating according to the problem focus information and the actual focus information to obtain a problem focus matching result;
according to the problem focus matching result, the problem focus manpower input and the problem focus point are calculated;
and determining the human input of the attention point of the problem and the attention point number of the problem as the information of the attention point occurrence problem.
Preferably, the calculation formula of the problem focus matching result is as follows:
wherein, WPRG dij The audit log imported for the ith audit member on the d day is matched with the j-th problem concern information to obtain a problem concern matching result; d, d j The j-th question attention point information; WRG di { } is the set of the actual point of interest information in the audit log imported by the ith audit member on day d; d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, s is the number of the problem focus information, and D, n and s are both positive integers.
The invention also provides audit project implementation quality monitoring equipment based on data analysis, which comprises the following steps: a memory, a processor, and a computer program stored on the memory and executable on the processor; the computer program when executed by the processor implements the steps of a method of quality monitoring of an audit item based on data analysis as described in any of the preceding claims.
The technical scheme provided by the invention has at least the following technical effects:
in the process of implementing audit, acquiring an audit project responsible person to import a field implementation scheme and an spot check object list, and acquiring an audit log imported by an auditor; respectively decomposing and extracting to obtain target attention point information, target spot check object information, actual attention point information and actual spot check object information; the 4 kinds of information are the core process data of the audit project; the target point of interest information and the actual point of interest information are matched to obtain point of interest completion information (mainly, the human input of each target point of interest information and the completion coverage of each target point of interest information), and the target spot check object information and the actual spot check object information are matched to obtain spot check object completion information (including the human input of each target spot check object information and the completion coverage of each target spot check object information).
The focus completion condition information and spot check object completion condition information clearly reflect the implementation quality of the whole audit project; the information of the completion condition of the focus and the information of the completion condition of the spot check object can be obtained in real time in the implementation process of the audit project, and the method belongs to in-process monitoring, and compared with the traditional post-monitoring of implementation quality, the method can obtain a monitoring result more quickly, and can adjust the audit project in real time according to the monitoring result, so that the monitoring result has more practical significance; and because the algorithm is automatically calculated, no manual intervention is performed, the monitoring result is more real and reliable, and meanwhile, the manpower and material resources are saved.
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 required in the embodiments or the description of the prior art will be briefly described, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and other drawings may be obtained according to the structures shown in these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a first embodiment of a method for performing quality monitoring on an audit item based on data analysis in accordance with the present invention;
FIG. 2 is a flow chart of a second embodiment of a method for performing quality monitoring on an audit item based on data analysis in accordance with the present invention;
fig. 3 is a flowchart of a third embodiment of a method for implementing quality monitoring for an audit item based on data analysis according to the present invention.
Detailed Description
It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The invention provides an audit project implementation quality monitoring method and equipment based on data analysis.
For clarity of explanation of the principles of the present invention, the terminology commonly found in auditing works is explained first:
Audit item: the audit project is a series of audit activities performed on the audited units by auditors according to an audit work plan in order to achieve a given audit goal. The audit item refers to various special audit and leaving economic responsibility audit items in a mode of taking traditional manual audit and on-site audit as main work by an audit department in a national enterprise.
Audit item implementation: audit project implementation refers to the stage of field implementation of an audit project, and is a process from issuing an audit notice to conducting pre-audit investigation to finishing on the field.
In situ embodiment: the audit item is a compendial file in the execution process, and the content mainly comprises the focus of the audit item.
Attention points: when an audit project responsible person makes an audit project site implementation, specific audit contents are set according to audit targets, audit work plans and pre-audit investigation conditions. The concern points are details of audit contents, and auditors conduct audit work around the concern points.
Spot check object: the checking object refers to the object after checking and sampling when checking the checked unit, and the checking object refers to engineering projects, meeting data, financial certificates, electric users and the like.
Audit log: the work log of the member of the audit project records the audit activity condition and the problem finding condition of the current day, and specifically comprises the audit contents (i.e. the focus) which are actually inspected in the current day and the spot check objects which are inspected.
Evidence obtaining table: the work manuscript for communicating and confirming the found problems with the checked units mainly comprises the detailed description of the found problems, audit judgment and evidence in the audit process. One evidence obtaining table corresponds to one audit content, namely the attention point.
As shown in fig. 1, a first embodiment of a method for implementing quality monitoring on an audit item based on data analysis is applied to an audit item implementing quality monitoring device based on data analysis, where the monitoring device includes a processor and a memory; the monitoring method comprises the following steps:
step S110: and acquiring a field implementation, decomposing and extracting the acquired field implementation to obtain target point of interest information, and storing the target point of interest information in the memory.
Specifically, before the audit project starts to be implemented, the project responsible person guides the field implementation into the monitoring equipment, the processor decomposes and extracts the obtained field implementation to obtain the target attention point information, and text information extraction technology is adopted in the decomposition and extraction, which is the prior art, so that the description is omitted.
Step S120: and acquiring a spot check object list, decomposing and extracting the acquired spot check object list to obtain target spot check object information, and storing the target spot check object information into the memory.
Specifically, before the audit project starts to be implemented, the project responsible person imports the spot check object list into the monitoring equipment, the processor decomposes and extracts the obtained spot check object list to obtain target spot check object information, and the imported spot check object list is a document (excel document) in a standardized table form, so that the decomposition and extraction only needs to carry out simple document analysis.
Step S130: and obtaining an audit log, decomposing and extracting the obtained audit log to obtain actual focus information and actual spot check object information, and storing the actual focus information and the actual spot check object information into the memory.
Specifically, the audit project starts to be implemented, the audit member guides the respective audit logs into the monitoring equipment, the processor decomposes and extracts the obtained audit logs to obtain the actual attention point information and the actual spot check object information, and the decomposition and extraction adopts a text information extraction technology, which is the prior art and is not described in detail.
Step S140: and matching the actual attention point information with the target attention point information to obtain attention point matching results, and generating attention point completion condition information according to the attention point matching results.
Specifically, the attention point matching result is a comparison result of actual attention point information and target attention point information in an audit log imported by an audit member, and the attention point completion condition information refers to the completion condition of each target attention point information (including human input of each target attention point information and completion coverage rate of each target attention point information) obtained by analyzing the comparison result.
Step S150: matching the actual spot check object information with the target spot check object information to obtain a spot check object matching result, and generating spot check object completion condition information according to the spot check object matching result.
Specifically, the spot check object matching result is a comparison result of actual spot check object information and target spot check object information in an audit log imported by an audit member, and the spot check object completion status information refers to the completion status of each target spot check object information (including human input of each target spot check object information and completion coverage rate of each target spot check object information) obtained by analyzing the comparison result.
Through the technical scheme, in the process of implementing the audit, acquiring an on-site implementation scheme and an spot check object list imported by an audit project responsible person and an audit log imported by an auditor; respectively decomposing and extracting to obtain target attention point information, target spot check object information, actual attention point information and actual spot check object information; the 4 kinds of information are the core process data of the audit project; the target point of interest information and the actual point of interest information are matched to obtain point of interest completion information (including human input of each target point of interest information and completion coverage of each target point of interest information), and the target spot check object information and the actual spot check object information are matched to obtain spot check object completion information (including human input of each target spot check object information and completion coverage of each target spot check object information).
The focus completion condition information and the spot check object completion condition information clearly reflect the implementation quality of the whole audit project, the completion coverage rate reflects the completion breadth of the audit content, and the human input reflects the completion depth of the audit content; the information of the completion condition of the focus and the information of the completion condition of the spot check object can be obtained in real time in the implementation process of the audit project, and the method belongs to in-process monitoring, and compared with the traditional post-monitoring of implementation quality, the method can obtain a monitoring result more quickly, and can adjust the audit project in real time according to the monitoring result, so that the monitoring result has more practical significance; and because the algorithm is automatically calculated, no manual intervention is performed, the monitoring result is more real and reliable, and meanwhile, the manpower and material resources are saved.
In a second embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, after step S140, based on the first embodiment, the method includes:
step S210: and acquiring a evidence obtaining table, decomposing and extracting the acquired evidence obtaining table to obtain problem focus information, and storing the problem focus information into a memory.
Specifically, the audit item starts to be implemented, the audit member guides the respective evidence obtaining table into the monitoring device, the processor decomposes and extracts the acquired evidence obtaining table to obtain the problem attention point information, and the decomposition and extraction adopts a text information extraction technology, which is the prior art, so that the description is omitted.
Step S220: and matching the problem attention point information with the actual attention point information to obtain a problem attention point matching result, and generating attention point problem situation information according to the problem attention point matching result.
Specifically, the problem point matching result is a comparison result between the actual point information and the problem point information, and the problem point completion information refers to the completion of each problem point information obtained by analyzing the comparison result (including the manpower input of each problem point information and the number of each problem point information).
Through the technical scheme, quality monitoring can be implemented on the evidence collection table as well, so that a project responsible person can quickly know the problem concern points in the implementation process of the audit project, and targeted processing can be performed.
In a third embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the first embodiment, the decomposing and extracting the imported field implementation in step S110 to obtain target point of interest information includes:
step S310: the imported field implementation is decomposed and extracted.
Step S320: classifying the target focus information obtained after decomposition and extraction according to the field and classifying according to links to obtain a plurality of pieces of target focus information.
According to the technical scheme, the target focus information can be classified according to the fields or links, the focus completion condition information of different fields can be obtained by carrying out subsequent matching operation on the target focus information of different fields, and the focus completion condition information of different links can be obtained by carrying out subsequent matching operation on the target focus information of different links; the variety of the information of the completion condition of the attention point is enriched, and further, the implementation quality monitoring result of the audit project is more accurate and detailed.
In a fourth embodiment of the present invention for implementing a quality monitoring method for an audit item based on data analysis, based on the first embodiment, step S140 includes:
step S410: and calculating according to the actual attention point information and the target attention point information to obtain the attention point matching result.
Specifically, the focus matching result is a comparison result of the actual focus information and the target focus information.
Step S420: and calculating according to the attention point matching result to obtain attention point manpower investment and attention point coverage rate.
Specifically, the attention point manpower input and the attention point coverage rate are key indexes for implementing quality monitoring of the audit project; the coverage rate of the attention points represents the finishing breadth of the audit content, and the manpower investment of the attention points represents the finishing depth of the audit content.
Step S430: and determining the attention point manpower input and the attention point coverage rate as the attention point completion condition information.
Specifically, the information of the completion condition of the attention point comprises two indexes of attention point manpower investment and attention point coverage rate.
According to the technical scheme, the attention point manpower input and the attention point coverage rate are determined to be attention point completion condition information, and the two indexes can accurately reflect the implementation quality of the audit item.
In a fifth embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the fourth embodiment, a calculation formula of the focus matching result is as follows:
wherein PRG dij The target attention point information is obtained by matching the audit log imported for the ith audit member on the d day with the jth target attention point information; a, a j For the j-th target point of interest information, G { } is the set of the point of interest information, and a j ∈G{};RG di { } isA collection of the actual point of interest information in the audit log imported by the ith audit member on day d (one audit log is imported by the audit member every day); d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, m is the number of the target point of interest information, and D, n and m are both positive integers.
In this embodiment, let d=1, m=2, and n=2.
Simultaneously set up: the 1 st target attention point information is contained in the set of the actual attention point information in the audit log of the 1 st audit member, the 2 nd target attention point information is not contained in the set of the actual attention point information in the audit log of the 1 st audit member, the 1 st target attention point information is not contained in the set of the actual attention point information in the audit log of the 2 nd audit member, and the 2 nd target attention point information is contained in the set of the actual attention point information in the audit log of the 2 nd audit member, the 1 st day.
It can be seen that: PRG (PRG) 111 =1,PRG 112 =0,PRG 121 =0,PRG 122 =1。
The attention point matching result can clearly express whether the actual attention point information of any audit member in the audit log uploaded on any day contains any target attention point information.
In a sixth embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the fifth embodiment, step S420 includes:
step S610: the labor input of the ith audit member to the jth target attention point information in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein k is dij And inputting the labor input of the jth target attention point information in the audit log imported on any day for the ith audit member.
Specifically, it is calculated from the fifth embodiment that: k (k) 111 =1,k 112 =0,k 121 =0,k 122 =1。
Step S620: and calculating the labor investment of the attention point, wherein the calculation formula is as follows:
wherein RLTR Dj And the human input for the target attention point indicates all human inputs for the j-th target attention point information from day D.
Specifically, the following can be calculated: RLTR 11 =1, i.e. 1 person unit is added to the 1 st target point of interest information by 1 day (1 person unit here means that 1 audit member includes the target point of interest information in 1 audit log), RLTR 12 =1, i.e., 1 person unit was put into the 2 nd target point of interest information by day 1.
Step S630: judging whether the target attention point information is inspected or not from the day D to the day j, and acquiring a judging result, wherein the calculating formula of the judging result is as follows:
wherein when X is Dj When X is equal to or greater than 1, the target point of interest information is examined by day j Dj When=0, it means that the target point of interest information is not examined by the j th day of the D-th day.
In particular, when RLTR Dj When=0, i.e., the target point of interest information is not input with human power by the day D, it is natural that the target point of interest information is not examined.
From the above, it can be obtained: x is X 11 =1,X 12 =1。
Step S640: calculating the coverage rate of the attention points, wherein the calculation formula is as follows:
wherein FGL D And (3) representing the duty ratio of the inspected target attention point information in all the target attention point information from the day D for the attention point coverage rate.
Specifically, FGL can be calculated from the above 1 =1, meaning that all target point of interest information has been reviewed by day 1.
In a seventh embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the first embodiment, step S150 includes:
step S710: and calculating according to the actual spot check object information and the target spot check object information to obtain a spot check object matching result.
Specifically, the spot check object matching result is a comparison result of the actual spot check object information and the target spot check object information.
Step S720: and calculating according to the spot check object matching result to obtain the spot check object manpower input and the spot check object coverage rate.
Specifically, the manual investment of the spot check object and the coverage rate of the spot check object are key indexes for implementing quality monitoring of an audit project; the coverage rate of the spot check object represents the finishing breadth of the audit content, and the manpower investment of the spot check object represents the finishing depth of the audit content.
Step S730: and determining the labor input of the spot check object and the coverage rate of the spot check object as the spot check object completion condition information.
Specifically, the spot check object completion condition information comprises two indexes of spot check object manpower input and spot check object coverage rate.
According to the technical scheme, the labor input of the spot check object and the coverage rate of the spot check object are determined to be the spot check object completion condition information, and the two indexes can accurately reflect the implementation quality of the audit project.
In an eighth embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the seventh embodiment, in step S710, a calculation formula of the spot check object matching result is as follows:
Wherein PRC dij Matching the audit log imported for the ith audit member on the d day with the j-th target spot check object information to obtain a spot check object matching result; c j For the j-th target spot check object information, C { } is the set of the point of interest information, and b j ∈C{};RC di { } is the collection of the actual spot check object information in the audit log imported by the ith audit member on day d (the audit member imports an audit log every day); d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, g is the number of target spot check object information, and D, n and h are both positive integers.
In this embodiment, let d=1, g=2, and n=2.
Simultaneously set up: the set of the actual spot check object information in the audit log of the 1 st audit member on the 1 st day contains the 1 st target spot check object information, the set of the actual spot check object information in the audit log of the 1 st audit member on the 1 st day does not contain the 2 nd target spot check object information, the set of the actual spot check object information in the audit log of the 2 nd audit member on the 1 st day does not contain the 1 st target spot check object information, and the set of the actual spot check object information in the audit log of the 2 nd audit member on the 1 st day contains the 2 nd target spot check object information.
It can be seen that: PRC (PRC) 111 =1,PRC 112 =0,PRC 121 =0,PRC 122 =1。
The matching result of the spot check object can clearly express whether the actual spot check object information of any one of the audit logs uploaded by any one of the audit members on any one of the days contains any one of the target spot check object information.
In a ninth embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the eighth embodiment, step S720 includes:
step S910: the labor input of the ith audit member to the jth target spot check object information in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein h is dij And inputting the labor input of the jth target spot check object information in the audit log imported on any day for the ith audit member.
Specifically, it is calculated from the eighth embodiment that: h is a 111 =1,h 112 =0,h 121 =0,h 122 =1。
Step S920: and calculating the labor input of the spot check object, wherein the calculation formula is as follows:
wherein, CRLTR Dj And the human input for the spot check object represents all human inputs to the j-th target spot check object information from the day D.
Specifically, the following can be calculated: CRLTR 11 =1, i.e. 1 person unit is added to the 1 st target spot check object information by 1 day (1 person unit here means that 1 audit member includes the target spot check object information in 1 audit log), CRLTR 12 =1, i.e., 1 person unit was added to the 2 nd target spot check object information by day 1.
Step S930: judging whether the target spot check object information is inspected or not from the day D to the day j, and acquiring a judging result, wherein the calculating formula of the judging result is as follows:
wherein, when S Dj When the target spot check object information is checked by the time of the j th day of the day D and the time of S Dj When=0, it means that the target spot check object information is not examined by the j th day of the D-th day.
In particular, when CRLTR Dj When =0, i.e., the j-th target spot check object information is not input with manpower by the D-th day, it is naturally not examined.
From the above, it can be obtained: s is S 11 =1,S 12 =1。
Step S940: calculating the coverage rate of the spot check object, wherein the calculation formula is as follows:
wherein CFGL D And the coverage rate of the spot check object is represented as the duty ratio of the inspected target spot check object information in all the target spot check object information from the day D.
Specifically, CFGL can be calculated from the above 1 =1, meaning that all target spot check object information has been examined by day 1.
In a tenth embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the second embodiment, step S220 includes:
Step S1010: and calculating according to the problem focus information and the actual focus information to obtain a problem focus matching result.
Specifically, the problem focus matching result is a comparison result of the actual focus information and the problem focus information.
Step S1020: and calculating according to the problem attention point matching result to obtain the problem attention point manpower input and the problem attention point number.
Specifically, the problem point of interest human input herein represents human input for certain problem point of interest information, and the problem point of interest is the number of problem point of interest information presented by the audit item.
Step S1030: and determining the human input of the attention point of the problem and the attention point number of the problem as the information of the attention point occurrence problem.
Specifically, the problem point of interest discovery problem condition information comprises two indexes of human input of the problem point of interest and the problem point of interest.
According to the technical scheme, the human input of the problem attention point and the problem attention point are determined to be attention point problem condition information, and the two indexes can accurately reflect the quality of the implementation result of the audit project.
In an eleventh embodiment of the method for implementing quality monitoring on an audit item based on data analysis according to the present invention, based on the tenth embodiment, in step S1010, a calculation formula of the problem focus matching result is as follows:
Wherein, WPRG dij The audit log imported for the ith audit member on the d day is matched with the j-th problem concern information to obtain a problem concern matching result; d, d j For the j-th question point of interest information, WG { } is the set of the point of interest information, and d j ∈WG{};;RG di { } is the collection of the actual point of interest information in the audit log imported by the ith audit member on day d (audit member imports one audit log each day); d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, s is the number of the problem focus information, and D, n and s are both positive integers.
In this embodiment, let d=1, m=2, s=2.
Simultaneously set up: the 1 st concern information is contained in the set of the actual concern information in the 1 st audit log of the 1 st audit member, the 2 nd concern information is not contained in the set of the actual concern information in the 1 st audit log of the 1 st audit member, the 1 st concern information is not contained in the set of the actual concern information in the 2 nd audit log of the 1 st audit member, and the 2 nd concern information is contained in the set of the actual concern information in the 1 st audit log of the 2 nd audit member.
It can be seen that: WPRG 111 =1,WPRG 112 =0,WPRG 121 =0,WPRG 122 =1。
The problem focus matching result can clearly express whether the actual focus information of any audit member in the audit log uploaded on any day contains any problem focus information.
In a twelfth embodiment of the method for monitoring an audit item based on data analysis according to the present invention, based on the eleventh embodiment, step S1020 includes:
step S1210: the labor input of the ith audit member to the information of the jth problem concern point in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein l dij And inputting human input for the information of the j-th problem concern point in the audit log imported on any day for the i-th audit member.
Specifically, it is calculated from the eighth embodiment that: l (L) 111 =1,l 112 =0,l 121 =0,l 122 =1。
Step S1220: and calculating the human input of the attention point of the problem, wherein the calculation formula is as follows:
wherein RLTR Dj For the person concerned with the problemForce input means all human input to the j-th problem point of interest information by day D.
Specifically, the following can be calculated: WRLTR 11 =1, i.e. 1 person unit is added to the 1 st issue focus information by 1 day (1 person unit here means that 1 audit member includes the issue focus information in 1 audit log), WRLTR 12 =1, i.e., indicates that 1 person unit was put into the 2 nd problem focus information by day 1.
Step S1230: calculating the attention point number of the problem, wherein the calculation formula is as follows:
WGS=s;
where WGS is the issue point of interest.
The problem attention points intuitively reflect the problems found in the review process.
In a thirteenth embodiment of the method for implementing quality monitoring on an audit item based on data analysis provided by the invention, based on the first embodiment, the monitoring device further comprises an information input device and a display device; after step S150, it includes:
step S1310: and acquiring a viewing instruction input through the information input device.
Step S1320: and displaying the notice point completion condition information and the spot check object completion condition information on the display device according to the checking instruction.
Through the technical scheme, the result of auditing implementation quality monitoring is displayed.
The invention also provides audit project implementation quality monitoring equipment based on data analysis, which comprises the following steps: a memory, a processor, and a computer program stored on the memory and executable on the processor; the computer program, when executed by the processor, implements the steps of the data analysis-based audit item implementation quality monitoring method described in any of the preceding claims.
The foregoing embodiment numbers of the present invention are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.
From the above description of the embodiments, it will be clear to those skilled in the art that the above-described embodiment method may be implemented by means of software plus a necessary general hardware platform, but of course may also be implemented by means of hardware, but in many cases the former is a preferred embodiment. Based on such understanding, the technical solution of the present invention may be embodied essentially or in a part contributing to the prior art in the form of a software product stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and including several instructions for causing a terminal (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the method according to the embodiments of the present invention.
The embodiments of the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to the above-described embodiments, which are merely illustrative and not restrictive, and many forms may be made by those having ordinary skill in the art without departing from the spirit of the present invention and the scope of the claims, which are to be protected by the present invention.
Claims (6)
1. An audit item implementation quality monitoring method based on data analysis is characterized by being applied to audit item implementation quality monitoring equipment based on the data analysis, wherein the monitoring equipment comprises a processor and a memory; the monitoring method comprises the following steps:
acquiring a field implementation, decomposing and extracting the acquired field implementation to obtain target focus information, and storing the target focus information into the memory;
acquiring an spot check object list, decomposing and extracting the acquired spot check object list to obtain target spot check object information, and storing the target spot check object information into the memory;
obtaining an audit log, decomposing and extracting the obtained audit log to obtain actual focus information and actual spot check object information, and storing the actual focus information and the actual spot check object information into the memory;
matching the actual attention point information with the target attention point information to obtain attention point matching results, and generating attention point completion condition information according to the attention point matching results;
matching the actual spot check object information with the target spot check object information to obtain a spot check object matching result, and generating spot check object completion condition information according to the spot check object matching result;
The matching the actual attention point information with the target attention point information to obtain an attention point matching result, and generating attention point completion condition information according to the attention point matching result, including:
calculating according to the actual attention point information and the target attention point information to obtain the attention point matching result;
according to the attention point matching result, attention point manpower investment and attention point coverage rate are calculated;
determining the attention point manpower input and the attention point coverage rate as the attention point completion condition information;
the calculation formula of the attention point matching result is as follows, wherein the attention point matching result is obtained by calculating according to the actual attention point information and the target attention point information:
wherein PRG dij The target attention point information is obtained by matching the audit log imported for the ith audit member on the d day with the jth target attention point information; a, a j The j-th target attention point information; RG (radio frequency identification) di { } is the set of the actual point of interest information in the audit log imported by the ith audit member on day d; d is the expiration date of an audit item, n is the number of audit members in the audit item, into which the audit log has been imported, m is the number of target focus information, and D, n and m are both positive integers;
The step of calculating the attention point manpower input and the attention point coverage rate according to the attention point matching result comprises the following steps:
the labor input of the ith audit member to the jth target attention point information in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein k is dij Human input for the jth target attention point information in the audit log imported on any day for the ith audit member;
and calculating the labor investment of the attention point, wherein the calculation formula is as follows:
wherein RLTR Dj The human input for the attention point represents all human inputs for the j-th target attention point information from the day D;
judging whether the target attention point information is inspected or not from the day D to the day j, and acquiring a judging result, wherein the calculating formula of the judging result is as follows:
wherein when X is Dj When X is equal to or greater than 1, the target point of interest information is examined by day j Dj When=0, it means that the target point of interest information is not examined by the j th day of the D-th day;
calculating the coverage rate of the attention points, wherein the calculation formula is as follows:
wherein FGL D Coverage for the point of interestRepresenting the duty ratio of the inspected target point of interest information in all the target point of interest information up to the D-th day;
The matching the actual spot check object information with the target spot check object information to obtain a spot check object matching result, and generating spot check object completion condition information according to the spot check object matching result, including:
calculating according to the actual spot check object information and the target spot check object information to obtain a spot check object matching result;
according to the spot check object matching result, calculating to obtain the spot check object manpower input and the spot check object coverage;
determining the labor input of the spot check object and the coverage rate of the spot check object as the spot check object completion condition information;
the calculation formula of the spot check object matching result is as follows, wherein the spot check object matching result is obtained by calculation according to the actual spot check object information and the target spot check object information:
wherein PRC dij Matching the audit log imported for the ith audit member on the d day with the j-th target spot check object information to obtain a spot check object matching result; c j The j-th target spot check object information; RC (resistor-capacitor) di { } is the collection of the actual spot check object information in the audit log imported by the ith audit member on the d day, and the audit member imports an audit log every day; d is the expiration date of an audit item, n is the number of audit members in the audit item, into which the audit log has been imported, g is the number of target spot check object information, and D, n and h are both positive integers;
The step of calculating according to the spot check object matching result to obtain the spot check object manpower input and the spot check object coverage rate comprises the following steps:
the labor input of the ith audit member to the jth target spot check object information in the audit log imported on any day is calculated, and a calculation formula is as follows:
wherein h is dij Human input for the jth target spot check object information in the audit log imported on any day for the ith audit member;
and calculating the labor input of the spot check object, wherein the calculation formula is as follows:
wherein, CRLTR Dj Human input for the spot check object represents all human input for the j-th target spot check object information by the day D;
judging whether the target spot check object information is inspected or not from the day D to the day j, and acquiring a judging result, wherein the calculating formula of the judging result is as follows:
wherein, when S Dj When the target spot check object information is checked by the time of the j th day of the day D and the time of S Dj When=0, it means that the target spot check object information is not examined by the j th day of the D day;
calculating the coverage rate of the spot check object, wherein the calculation formula is as follows:
wherein CFGL D Representing, for the spot check object coverage, the inspected spot check object information in all the target spot check object information by day D The duty ratio of the target spot check object information.
2. A data analysis based audit item implementation quality monitoring method according to claim 1 including, after matching the actual point of interest information with the target point of interest information to obtain a point of interest matching result and generating point of interest completion information from the point of interest matching result:
obtaining a evidence obtaining table, decomposing and extracting the obtained evidence obtaining table to obtain problem focus information, and storing the problem focus information into a memory;
and matching the problem attention point information with the actual attention point information to obtain a problem attention point matching result, and generating attention point problem situation information according to the problem attention point matching result.
3. A data analysis based audit item implementation quality monitoring method according to claim 1 including decomposing and extracting the acquired field embodiments to obtain target point of interest information including:
decomposing and extracting the obtained field implementation;
classifying the target focus information obtained after decomposition and extraction according to the field and classifying according to links to obtain a plurality of pieces of target focus information.
4. A data analysis based audit item implementation quality monitoring method according to claim 2 including matching the issue point of interest information with the actual point of interest information to obtain an issue point of interest matching result and generating issue point of interest occurrence issue condition information based on the issue point of interest matching result, including:
calculating according to the problem focus information and the actual focus information to obtain a problem focus matching result;
according to the problem focus matching result, the problem focus manpower input and the problem focus point are calculated;
and determining the human input of the attention point of the problem and the attention point number of the problem as the information of the attention point occurrence problem.
5. A data analysis based audit item implementation quality monitoring method according to claim 4 wherein the calculation formula for the problem point of interest matching results is:
wherein, WPRG dij The audit log imported for the ith audit member on the d day is matched with the j-th problem concern information to obtain a problem concern matching result; d, d j The j-th question attention point information; WRG di { } is the set of the actual point of interest information in the audit log imported by the ith audit member on day d; d is the expiration date of the audit item, n is the number of audit members in the audit item, into which the audit log has been imported, s is the number of the problem focus information, and D, n and s are both positive integers.
6. An audit item implementation quality monitoring device based on data analysis, comprising: a memory, a processor, and a computer program stored on the memory and executable on the processor; the computer program, when executed by the processor, implements the steps of the data analysis-based audit item implementation quality monitoring method as set forth in any of claims 1 to 5.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910882483.5A CN110796336B (en) | 2019-09-18 | 2019-09-18 | Audit project implementation quality monitoring method and equipment based on data analysis |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910882483.5A CN110796336B (en) | 2019-09-18 | 2019-09-18 | Audit project implementation quality monitoring method and equipment based on data analysis |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110796336A CN110796336A (en) | 2020-02-14 |
CN110796336B true CN110796336B (en) | 2023-09-01 |
Family
ID=69427320
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910882483.5A Active CN110796336B (en) | 2019-09-18 | 2019-09-18 | Audit project implementation quality monitoring method and equipment based on data analysis |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110796336B (en) |
Families Citing this family (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110796335B (en) * | 2019-09-18 | 2023-12-22 | 广东电网有限责任公司审计中心 | Audit project implementation quality monitoring system and equipment based on data analysis |
CN117333141B (en) * | 2023-11-27 | 2024-02-06 | 国网浙江省电力有限公司 | Automatic auditing method, system, equipment and medium for engineering quantity of electric power engineering |
Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10320460A (en) * | 1997-03-14 | 1998-12-04 | Fujitsu Ltd | Inspection support method, system thereby and storage medium storing inspection support program |
JP2005116561A (en) * | 2003-10-02 | 2005-04-28 | Nikon Corp | Method and device for manufacturing template, method and device for detecting position, and method and device for exposure |
JP2008108176A (en) * | 2006-10-27 | 2008-05-08 | Mitsubishi Heavy Ind Ltd | Project schedule generation system |
CN101286903A (en) * | 2008-05-06 | 2008-10-15 | 北京锐安科技有限公司 | Method for enhancing integrity of sessions in network audit field |
JP2009110220A (en) * | 2007-10-30 | 2009-05-21 | Hitachi Ltd | Audit log collection/evaluation system, audit log collection/evaluation method, and collection/evaluation computer |
US8325880B1 (en) * | 2010-07-20 | 2012-12-04 | Convergys Customer Management Delaware Llc | Automated application testing |
CN104463397A (en) * | 2013-11-20 | 2015-03-25 | 上海宝信软件股份有限公司 | Audit project quality control method and system based on template |
CN105354658A (en) * | 2015-10-12 | 2016-02-24 | 国网北京市电力公司 | Data processing method and device |
JP2017059111A (en) * | 2015-09-18 | 2017-03-23 | Necソリューションイノベータ株式会社 | Organization improvement activity support system, information processing apparatus, method and program |
CN109117202A (en) * | 2018-07-11 | 2019-01-01 | 郑州云海信息技术有限公司 | A kind of method and system that audit type configuration item is set |
CN109697550A (en) * | 2018-11-07 | 2019-04-30 | 国网浙江杭州市富阳区供电有限公司 | A kind of distribution plan management of materials and quipment method and system |
Family Cites Families (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JP2006185098A (en) * | 2004-12-27 | 2006-07-13 | Matsushita Electric Ind Co Ltd | Method and apparatus for transmitting check progress information of design review |
US8392708B2 (en) * | 2007-10-30 | 2013-03-05 | Hewlett-Packard Development Company, L. P. | Auditing data integrity |
US20150127430A1 (en) * | 2013-11-04 | 2015-05-07 | Statimate Systems Inc. | Method and system for identifying items and managing a collection of items |
-
2019
- 2019-09-18 CN CN201910882483.5A patent/CN110796336B/en active Active
Patent Citations (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10320460A (en) * | 1997-03-14 | 1998-12-04 | Fujitsu Ltd | Inspection support method, system thereby and storage medium storing inspection support program |
JP2005116561A (en) * | 2003-10-02 | 2005-04-28 | Nikon Corp | Method and device for manufacturing template, method and device for detecting position, and method and device for exposure |
JP2008108176A (en) * | 2006-10-27 | 2008-05-08 | Mitsubishi Heavy Ind Ltd | Project schedule generation system |
JP2009110220A (en) * | 2007-10-30 | 2009-05-21 | Hitachi Ltd | Audit log collection/evaluation system, audit log collection/evaluation method, and collection/evaluation computer |
CN101286903A (en) * | 2008-05-06 | 2008-10-15 | 北京锐安科技有限公司 | Method for enhancing integrity of sessions in network audit field |
US8325880B1 (en) * | 2010-07-20 | 2012-12-04 | Convergys Customer Management Delaware Llc | Automated application testing |
CN104463397A (en) * | 2013-11-20 | 2015-03-25 | 上海宝信软件股份有限公司 | Audit project quality control method and system based on template |
JP2017059111A (en) * | 2015-09-18 | 2017-03-23 | Necソリューションイノベータ株式会社 | Organization improvement activity support system, information processing apparatus, method and program |
CN105354658A (en) * | 2015-10-12 | 2016-02-24 | 国网北京市电力公司 | Data processing method and device |
CN109117202A (en) * | 2018-07-11 | 2019-01-01 | 郑州云海信息技术有限公司 | A kind of method and system that audit type configuration item is set |
CN109697550A (en) * | 2018-11-07 | 2019-04-30 | 国网浙江杭州市富阳区供电有限公司 | A kind of distribution plan management of materials and quipment method and system |
Also Published As
Publication number | Publication date |
---|---|
CN110796336A (en) | 2020-02-14 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110119413B (en) | Data fusion method and device | |
CN109242246B (en) | Scene construction method, emergency drilling method and scene construction system | |
CN110427406A (en) | The method for digging and device of organization's related personnel's relationship | |
CN110796336B (en) | Audit project implementation quality monitoring method and equipment based on data analysis | |
CN113807747A (en) | Enterprise budget management maturity evaluation system | |
CN103942739A (en) | Method for construction of construction project risk knowledge base | |
CN115221380A (en) | Method, system and platform for managing urban construction files in batches | |
CN112000862B (en) | Data processing method and device | |
CN117745141A (en) | Evaluation system and method for electric power professional skill identification practical operation | |
Al-Bahri et al. | Evaluate the role of big data in enhancing strategic decision making for E-governance in E-Oman portal | |
CN110796335B (en) | Audit project implementation quality monitoring system and equipment based on data analysis | |
CN111832912A (en) | Project feasibility management and control method, device and terminal based on risk assessment | |
CN117172795A (en) | Intelligent technical service fee online consultation system | |
Novianti et al. | Assurance information systems design for blockchain-based micro, small and medium enterprises in Indonesia | |
CN115545799B (en) | Information technology service quality evaluation method, device, equipment and medium | |
Jacky et al. | Factors Affecting the Use of Data Analytics in External Auditing. | |
CN112992156B (en) | Power distribution network dispatching identity authentication system based on voiceprint authentication | |
CN115170295A (en) | Enterprise credit risk assessment processing method and device | |
CN114201544A (en) | Early warning analysis method and device for economic contract abnormal data of natural gas enterprise | |
CN114049095A (en) | Infrastructure construction business monitoring method, device, equipment and storage medium | |
Wonoseto et al. | Internal Audit Information System Design in the University:(Case Study at Islamic State University Sunan Kalijaga Yogyakarta) | |
TSE et al. | AI-Powered ESG: Our Chance to Make a Real Difference? | |
Oyoo et al. | An Automated Data Validation Approach to Enterprise Asset Management for Power and Utilities Organizations | |
CN118394711B (en) | Engineering technology file processing method and system based on artificial intelligence model | |
CN116094747B (en) | Factorization-based risk assessment method and system |
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 |