CN113781011A - Verification method and system for project cost of power distribution network - Google Patents
Verification method and system for project cost of power distribution network Download PDFInfo
- Publication number
- CN113781011A CN113781011A CN202111125924.0A CN202111125924A CN113781011A CN 113781011 A CN113781011 A CN 113781011A CN 202111125924 A CN202111125924 A CN 202111125924A CN 113781011 A CN113781011 A CN 113781011A
- Authority
- CN
- China
- Prior art keywords
- standard
- assembly
- assemblies
- matched
- matching
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 29
- 238000012795 verification Methods 0.000 title abstract description 11
- 230000000712 assembly Effects 0.000 claims abstract description 199
- 238000000429 assembly Methods 0.000 claims abstract description 199
- 238000012986 modification Methods 0.000 claims abstract description 21
- 230000004048 modification Effects 0.000 claims abstract description 21
- 238000012550 audit Methods 0.000 claims abstract description 11
- 239000000463 material Substances 0.000 claims description 7
- 238000010276 construction Methods 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 4
- 238000011161 development Methods 0.000 description 3
- 239000000203 mixture Substances 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 1
- 238000012552 review Methods 0.000 description 1
- 229920006395 saturated elastomer Polymers 0.000 description 1
- 238000007619 statistical method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
-
- 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—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Economics (AREA)
- Human Resources & Organizations (AREA)
- Tourism & Hospitality (AREA)
- Health & Medical Sciences (AREA)
- Marketing (AREA)
- Entrepreneurship & Innovation (AREA)
- Theoretical Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Operations Research (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a verification method and a verification system for the construction cost of a power distribution network project, which comprises the steps of obtaining data of the power distribution network project, and obtaining the contribution data of the power distribution network project according to a preset contribution template; matching with a standard assembly in a preset cost rule base; if the success is successful, setting the standard component; if the operation is unsuccessful, setting the operation as a non-standard component; counting the modification times of the standard component, and modifying the standard component into a non-standard component when the modification times of the standard component are greater than or equal to a preset threshold value; comparing the occupation ratio of the non-standard component with a preset standard ratio, and judging that the examination is passed when the occupation ratio is greater than or equal to the preset standard ratio; and when the current distribution network project is smaller than the preset standard ratio, judging that the current distribution network project is unreasonable and the audit is not passed. The invention can input the assemblies in batch and correctly and embody the marks of the non-standard assemblies by matching the mode of inputting the assemblies, can improve the examination efficiency of the examiners and better support the experts to finish the examination and analysis work.
Description
Technical Field
The invention relates to the technical field of verification of construction cost of a power distribution network, in particular to a verification method and a verification system of construction cost of a power distribution network.
Background
With the rapid development of the current power industry, the power grid construction tends to the development in the digital direction more and more, but the technical review development is influenced by the problems of shortage of cost auditors, saturated service volume and the like at present.
The problems in the existing industry mainly include the problem of insufficient auditing precision caused by mismatching of the number of construction cost auditors and workload and the problem of insufficient auditing timeliness caused by large quantity of distribution network projects and tight auditing time, and in order to promote efficient auditing of the distribution network projects, a method and a system for intelligently and quickly constructing a distribution network are urgently needed, so that the manual construction cost and the automatic construction cost are compared, and the auditing efficiency is improved.
The traditional manual engineering mode is adopted at present, and a user needs to manually input assemblies in an assembly library into an engineering during engineering, so that the concepts such as intelligent matching and the like do not exist. However, the auditor has no way to check whether the composition of each assembly is reasonable, and has no alternative benchmarking projects to compare user projects and find differences; technical personnel can only carry out engineering by entering the assembly from different assembly libraries provided by software or adding a custom assembly, and the assembly does not have a uniform source and cannot restrict the consistency of entry of the assembly.
Disclosure of Invention
The invention aims to provide a method and a system for auditing the engineering cost of a power distribution network, which solve the technical problems that the difference between a standard assembly and a non-standard assembly cannot be accurately confirmed and the statistical analysis result is not accurate in the conventional method.
On the one hand, the utility model provides a method of examining and verifying distribution network engineering cost, includes:
acquiring data of a power distribution network project, and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project;
matching the assemblies in the contribution data with standard assemblies in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part;
counting the number of times of modification of the standard component, and modifying the standard component into a non-standard component when the number of times of modification of the standard component is greater than or equal to a preset threshold value;
counting the non-standard components to obtain the ratio of the non-standard components, comparing the ratio of the non-standard components with a preset standard ratio, and when the ratio of the non-standard components is greater than or equal to the preset standard ratio, judging that the current power distribution network project is reasonable and passing the audit; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit.
Preferably, the preset cost rule base comprises:
an assembly list to record a plurality of levels of standard assemblies, the plurality of levels of standard assemblies being ordered from high to low by level;
the standard assembly of each level is used for recording the number of the standard assembly of the level, the name of the standard assembly of the level and the project characteristics of the standard assembly of the level, and the standard assembly of each level at least comprises a plurality of standard assemblies;
each standard assembly is used for recording the number of the standard assembly, the name of the standard assembly and the project characteristics of the standard assembly.
Preferably, the matching the assemblies in the funding data with the standard assemblies in the preset cost rule base comprises:
comparing the number of the assembly in the contribution data with the number of the standard assembly in the cost rule base;
if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful;
and if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, judging that fuzzy judgment is needed.
Preferably, the performing the fuzzy judgment includes:
acquiring the name of an assembly in the contribution data;
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the feature values are included in the item features of the standard assemblies, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the project feature of the standard assembly, setting the assembly in the funding data to be the first standard assembly in the lowest level standard assembly.
Preferably, the performing the fuzzy judgment further includes:
matching the name of an assembly in the funding data with the name of a standard assembly in a hierarchical standard assembly that is above the lowest hierarchical standard assembly when none of the standard assemblies is matched;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the feature values are included in the item features of the standard assemblies, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the item feature of the name item, setting an assembly in the funding data to be the first standard assembly in the upper level standard assembly.
Preferably, the performing the fuzzy judgment further includes:
when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of an assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the highest-level standard assembly when the feature value is not included in the project feature of the standard assembly;
when there is no match to any of the standard assemblies, the match is determined to be unsuccessful.
Preferably, the counting the number of modifications of the standard component includes:
when any one of the assembly information, the list information, the quota personnel and machine information, the main material information, the mix proportion material information, the equipment information, the earthwork system information, the one-time expense and the annotation information in the standard component is modified, the number of times of one modification is recorded.
Preferably, the counting the non-standard components to obtain the percentage value of the non-standard components includes:
and recording the total numerical value of the non-standard part, and calculating the ratio of the total numerical value of the non-standard part in the total sum of the standard part and the non-standard part to obtain the ratio of the non-standard part.
On the other hand, a verification system of the project cost of the power distribution network is also provided, which is used for realizing the verification method of the project cost of the power distribution network, and comprises the following steps:
the data acquisition module is used for acquiring data of the power distribution network project and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project;
the matching module is used for matching the assembly in the contribution data with a standard assembly in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part;
the counting module is used for counting the modification times of the standard part, and modifying the setting of the standard part into a non-standard part when the modification times of the standard part are greater than or equal to a preset threshold value;
the auditing module is used for counting the non-standard components to obtain the proportion of the non-standard components, comparing the proportion of the non-standard components with a preset standard proportion, and when the proportion of the non-standard components is greater than or equal to the preset standard proportion, judging that the current power distribution network project is reasonable and the auditing is passed; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit.
Preferably, the matching module is further configured to compare the number of the assembly in the funding data with the number of the standard assembly in the cost rule base;
if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful;
if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, judging that fuzzy judgment is needed;
when the fuzzy judgment is needed, acquiring the name of the assembly in the funding data;
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in funding data to be a first standard assembly in the lowest level standard assembly when the feature value is not included in an item feature of the standard assembly;
matching the name of an assembly in the funding data with the name of a standard assembly in a hierarchical standard assembly that is above the lowest hierarchical standard assembly when none of the standard assemblies is matched;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the previous level of standard assemblies when the feature value is not included in the project feature of the standard assembly;
when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of an assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the highest-level standard assembly when the feature value is not included in the project feature of the standard assembly;
when there is no match to any of the standard assemblies, the match is determined to be unsuccessful.
In summary, the embodiment of the invention has the following beneficial effects:
according to the method and the system for auditing the construction cost of the power distribution network project, the assemblies can be accurately input into the project in batches in a mode of matching and inputting the assemblies, the marks of non-standard assemblies can be embodied, the auditing efficiency of auditors can be greatly improved, and experts can be better supported to finish the auditing and analyzing work.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is within the scope of the present invention for those skilled in the art to obtain other drawings based on the drawings without inventive exercise.
Fig. 1 is a schematic main flow chart of an auditing method for project cost of a power distribution network in an embodiment of the invention.
Fig. 2 is a logic diagram of an auditing method for power distribution network project cost in the embodiment of the invention.
FIG. 3 is a schematic diagram of an interface of a cost rule base according to an embodiment of the present invention.
FIG. 4 is a diagram illustrating a modified state of the standard component according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be described in further detail with reference to the accompanying drawings.
Fig. 1 and fig. 2 are schematic diagrams illustrating an embodiment of an auditing method for project cost of a power distribution network according to the present invention. In this embodiment, the method comprises the steps of:
acquiring data of a power distribution network project, and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project; that is to say, the data of the power distribution network project is led into a preset cost rule base serving as a judgment standard through a preset template, the rule base reflects a detail data list of an assembly level, a functional entry for leading in a contribution template Excel is provided, and codes/names in the Excel are matched with assemblies in the cost rule base, so that the codes/names can be automatically matched with the assemblies in the cost rule base to be displayed together with list details under sub items of the assemblies, and manual entry is not needed.
Matching the assemblies in the contribution data with standard assemblies in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part; that is to say, the following steps are performed.
In a specific embodiment, the preset cost rule base includes:
an assembly list to record a plurality of levels of standard assemblies, the plurality of levels of standard assemblies being ordered from high to low by level; can be understood as a hierarchical list. The standard assembly of each level is used for recording the number of the standard assembly of the level, the name of the standard assembly of the level and the project characteristics of the standard assembly of the level, and the standard assembly of each level at least comprises a plurality of standard assemblies; each standard assembly is used for recording the number of the standard assembly, the name of the standard assembly and the project characteristics of the standard assembly; it can be understood that the corresponding names, item features and numbers are recorded for the assemblies of each level in the list; wherein, each sub-layer is provided with a plurality of standard assemblies, and the number of the standard assembly, the name of the standard assembly and the project characteristics of the standard assembly are recorded.
Further, with the above-mentioned cost rule base (matching criteria), specific matching operations can be performed, and the specific matching process is as follows:
firstly, comparing the number of the assembly in the contribution data with the number of the standard assembly in the cost rule base; if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful; and if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, judging that fuzzy judgment is needed. The sub-process can be understood as an accurate matching process, the number of the assembly in the EXCEL table is accurately matched with the number of the assembly in the cost rule base, and if the matching of the assembly code is successful, the assembly is regarded as an accurate matching assembly; otherwise, fuzzy matching (fuzzy judgment) is carried out.
Secondly, when the fuzzy judgment is needed, the name of the assembly in the funding data is obtained; this process can be understood as fuzzy matching by name, and the specific process is as follows:
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level; whether the column of the name in the imported EXCEL table contains the name of the minimum chapter classification (regarded as the first-last level) under the cost rule base or not is judged, and the attribute item can be known to represent the minimum first level through the definition of the cost rule base;
when only one standard assembly is matched, judging that the matching is successful; when only one assembly is classified under the chapters meeting the conditions, the assembly is considered to be successfully matched, and the assembly is imported;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the project feature of the standard assembly, setting the assembly in the funding data to be the first standard assembly in the lowest level standard assembly. That is, a plurality of assemblies exist under the chapter classification meeting the condition, at this time, the name column in the EXCEL is continuously matched with the assemblies under the chapter classification meeting the condition at present, and whether the name column contains the feature value in the project feature of the assembly meeting the condition is judged; if yes, leading in the traversed first qualified assembly by default; if not, the first assembly meeting the chapter classification under the condition is imported.
Again, when none of the lowest level standard assemblies match any of the standard assemblies, matching the name of the assembly in the funding data with the name of a standard assembly in a level standard assembly that is above the lowest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the feature values are included in the item features of the standard assemblies, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the item feature of the name item, setting an assembly in the funding data as a first standard assembly in the upper-level standard assembly;
in particular, when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of the assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the project characteristics of the standard assembly do not contain the characteristic value, the assembly in the investment data is set as the first standard assembly in the highest level standard assembly, that is, if the 'name' column does not contain the name of the minimum chapter classification (regarded as the first-last level) under the 'cost rule base', whether the 'name' column in the imported EXCEL contains the name of the direct parent-level classification (regarded as the second-last level) of each minimum chapter under the 'cost rule base' is judged, the subsequent judgment is consistent with the execution judgment rule of the first-last level, the description is not repeated, and the name matching is carried out according to the rule until the first level.
When there is no match to any of the standard assemblies (match to the top level, no higher level further up), it is determined that the match is not successful.
The automatic import of the assembly can be realized through the matching rules, the assembly which is recorded through precise/fuzzy matching is a standard assembly, and the subsequent modification mark aiming at the standard assembly can be embodied in software.
As shown in fig. 3, a specific interface of one of the levels in the cost rule base is displayed, which is not used to record various information of the level, such as list, number, name, and item characteristics of the level, but is mainly used to calibrate various standards and characteristics of the standard assembly, match the data of the assembly to be matched, and if the matched standard assembly is found, the non-standard assembly which cannot be matched is also called a custom assembly. Specifically, the imported assembly is matched with a cost rule base, and engineering data is updated, wherein an assembly view interface is correspondingly mounted under an assembly directory corresponding to the interface according to a chapter where the matched assembly is located;
fuzzy matching Assembly A remark on an Assembly that adds a description "the Assembly is a similar Assembly identified by software! "; through the remark instruction information, the number of similar assemblies in the engineering quantity interface can be counted. Unmatched: putting the corresponding data under the section of 'unmatched'; data import in "assembly view" interface: matching the assembly: the column of 'calculation formula' reads the column data of 'quantity' in the quotation table; and other data correspondingly reads the data of the assembly in the cost rule base.
Unmatched (equivalent to custom assembly): "number" corresponds to the read "assembly number"; reading the quantity corresponding to the calculation formula; the "item name" corresponds to reading the "name".
Counting the number of times of modification of the standard component, and modifying the standard component into a non-standard component when the number of times of modification of the standard component is greater than or equal to a preset threshold value; aiming at the standard assembly automatically formed by importing the Excel financing template, the standard assembly is changed into a non-standard assembly after being modified for the second time, and meanwhile, specific modified contents need to be provided in software, so that the non-standard rate can be conveniently counted, and examiners can be better assisted to examine whether the project is regular or not.
When the standard assemblies and the following list and consumption data are adjusted, a non-standard mark appears, and the specific modification content is as follows:
if the above contents are adjusted, the added "revision" mark is marked on the assembly, and the corresponding "revision" record appears in the software, so that the specific revision record can be clearly seen, and the style is shown in fig. 4.
Specifically, when any one of the assembly information, the list information, the quota human-machine information, the main material information, the mix proportion material information, the equipment information, the earthwork information, the one-time fee and the annotation information in the standard component is modified, the number of times of one modification is recorded.
Counting the non-standard components to obtain the ratio of the non-standard components, comparing the ratio of the non-standard components with a preset standard ratio, and when the ratio of the non-standard components is greater than or equal to the preset standard ratio, judging that the current power distribution network project is reasonable and passing the audit; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit. That is, the assemblies with non-standard marks in the software can be counted to obtain the specific proportion of the specific non-standard assemblies, whether the current project is reasonable or not is judged, if the non-standard rate is too low, the direct audit is not passed, and the specific detail information of the project does not need to be checked further. The two projects can be directly compared, one reference project is taken as a benchmark in software, the comparison project and the reference project are compared, and consumption of different assemblies, lists, quota, main materials, equipment and the like is specifically marked.
In a specific embodiment, the total numerical value of the non-standard component is recorded, and the ratio of the total numerical value of the non-standard component in the total sum of the standard component and the non-standard component is calculated to obtain the ratio of the non-standard component.
The invention also provides a verification system of the project cost of the power distribution network, which is used for realizing the verification method of the project cost of the power distribution network and comprises the following steps:
the data acquisition module is used for acquiring data of the power distribution network project and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project;
the matching module is used for matching the assembly in the contribution data with a standard assembly in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part;
the counting module is used for counting the modification times of the standard part, and modifying the setting of the standard part into a non-standard part when the modification times of the standard part are greater than or equal to a preset threshold value;
the auditing module is used for counting the non-standard components to obtain the proportion of the non-standard components, comparing the proportion of the non-standard components with a preset standard proportion, and when the proportion of the non-standard components is greater than or equal to the preset standard proportion, judging that the current power distribution network project is reasonable and the auditing is passed; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit.
The matching module is also used for comparing the number of the assembly in the funding data with the number of the standard assembly in the cost rule base;
if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful;
if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, judging that fuzzy judgment is needed;
when the fuzzy judgment is needed, acquiring the name of the assembly in the funding data;
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in funding data to be a first standard assembly in the lowest level standard assembly when the feature value is not included in an item feature of the standard assembly;
matching the name of an assembly in the funding data with the name of a standard assembly in a hierarchical standard assembly that is above the lowest hierarchical standard assembly when none of the standard assemblies is matched;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the previous level of standard assemblies when the feature value is not included in the project feature of the standard assembly;
when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of an assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the highest-level standard assembly when the feature value is not included in the project feature of the standard assembly;
when there is no match to any of the standard assemblies, the match is determined to be unsuccessful.
In summary, the embodiment of the invention has the following beneficial effects:
according to the method and the system for auditing the construction cost of the power distribution network project, the assemblies can be accurately input into the project in batches in a mode of matching and inputting the assemblies, the marks of non-standard assemblies can be embodied, the auditing efficiency of auditors can be greatly improved, and experts can be better supported to finish the auditing and analyzing work.
The above disclosure is only for the purpose of illustrating the preferred embodiments of the present invention, and it is therefore to be understood that the invention is not limited by the scope of the appended claims.
Claims (10)
1. A method for auditing the project cost of a power distribution network is characterized by comprising the following steps:
acquiring data of a power distribution network project, and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project;
matching the assemblies in the contribution data with standard assemblies in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part;
counting the number of times of modification of the standard component, and modifying the standard component into a non-standard component when the number of times of modification of the standard component is greater than or equal to a preset threshold value;
counting the non-standard components to obtain the ratio of the non-standard components, comparing the ratio of the non-standard components with a preset standard ratio, and when the ratio of the non-standard components is greater than or equal to the preset standard ratio, judging that the current power distribution network project is reasonable and passing the audit; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit.
2. The method of claim 1, wherein the predetermined cost rule base comprises:
an assembly list to record a plurality of levels of standard assemblies, the plurality of levels of standard assemblies being ordered from high to low by level;
the standard assembly of each level is used for recording the number of the standard assembly of the level, the name of the standard assembly of the level and the project characteristics of the standard assembly of the level, and the standard assembly of each level at least comprises a plurality of standard assemblies;
each standard assembly is used for recording the number of the standard assembly, the name of the standard assembly and the project characteristics of the standard assembly.
3. The method of claim 2, wherein matching the assemblies in the funding data to standard assemblies in a pre-established cost rule base comprises:
comparing the number of the assembly in the contribution data with the number of the standard assembly in the cost rule base;
if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful;
if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, fuzzy judgment is carried out.
4. The method of claim 3, wherein said making the ambiguity determination comprises:
acquiring the name of an assembly in the contribution data;
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the feature values are included in the item features of the standard assemblies, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the project feature of the standard assembly, setting the assembly in the funding data to be the first standard assembly in the lowest level standard assembly.
5. The method of claim 4, wherein the performing the ambiguity determination further comprises:
matching the name of an assembly in the funding data with the name of a standard assembly in a hierarchical standard assembly that is above the lowest hierarchical standard assembly when none of the standard assemblies is matched;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the feature values are included in the item features of the standard assemblies, setting the assemblies in the funding data as the first standard assemblies matched with the features; when the feature value is not included in the item feature of the name item, setting an assembly in the funding data to be the first standard assembly in the upper level standard assembly.
6. The method of claim 5, wherein the performing the ambiguity determination further comprises:
when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of an assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the highest-level standard assembly when the feature value is not included in the project feature of the standard assembly;
when there is no match to any of the standard assemblies, the match is determined to be unsuccessful.
7. The method of claim 6, wherein said counting the number of modifications to said standard comprises:
when any one of the assembly information, the list information, the quota personnel and machine information, the main material information, the mix proportion material information, the equipment information, the earthwork system information, the one-time expense and the annotation information in the standard component is modified, the number of times of one modification is recorded.
8. The method of claim 7, wherein the counting the non-standard components to obtain the percentage of the non-standard components comprises:
and recording the total numerical value of the non-standard part, and calculating the ratio of the total numerical value of the non-standard part in the total sum of the standard part and the non-standard part to obtain the ratio of the non-standard part.
9. An auditing system for project cost of a power distribution network for implementing the method of any one of claims 1-8, comprising:
the data acquisition module is used for acquiring data of the power distribution network project and converting the data of the power distribution network project according to a preset funding template to obtain funding data of the power distribution network project;
the matching module is used for matching the assembly in the contribution data with a standard assembly in a preset cost rule base; if the matching is successful, setting the assembly in the funding data as a standard component; if the matching is unsuccessful, setting the assembly in the funding data as a non-standard part;
the counting module is used for counting the modification times of the standard part, and modifying the setting of the standard part into a non-standard part when the modification times of the standard part are greater than or equal to a preset threshold value;
the auditing module is used for counting the non-standard components to obtain the proportion of the non-standard components, comparing the proportion of the non-standard components with a preset standard proportion, and when the proportion of the non-standard components is greater than or equal to the preset standard proportion, judging that the current power distribution network project is reasonable and the auditing is passed; and when the occupation ratio of the non-standard component is smaller than a preset standard ratio, judging that the current power distribution network project is unreasonable, and not passing the audit.
10. The system of claim 9, wherein the matching module is further configured to compare the number of assemblies in the funding data to the number of standard assemblies in the cost rule base;
if the number of the assembly in the contribution data is the same as the number of the standard assembly in the cost rule base, the matching is judged to be successful;
if the number of the assembly in the contribution data is different from the number of the standard assembly in the cost rule base, judging that fuzzy judgment is needed;
when the fuzzy judgment is needed, acquiring the name of the assembly in the funding data;
matching the names of the assemblies in the funding data with the names of the standard assemblies in the standard assemblies at the lowest level;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in funding data to be a first standard assembly in the lowest level standard assembly when the feature value is not included in an item feature of the standard assembly;
matching the name of an assembly in the funding data with the name of a standard assembly in a hierarchical standard assembly that is above the lowest hierarchical standard assembly when none of the standard assemblies is matched;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the previous level of standard assemblies when the feature value is not included in the project feature of the standard assembly;
when none of the standard assemblies are matched in the upper level standard assembly, continuing to match the name of an assembly in the funding data with the standard assembly name in the upper level standard assembly of the upper level standard assembly until the highest level standard assembly is matched;
when the name of an assembly in the funding data matches the name of a standard assembly in the highest level standard assembly;
when only one standard assembly is matched, judging that the matching is successful;
when a plurality of standard assemblies are matched, carrying out feature matching on the feature values of the assemblies in the funding data and the item features of the plurality of matched standard assemblies, and when the item features of the standard assemblies contain the feature values, setting the assemblies in the funding data as the first standard assemblies matched with the features; setting an assembly in the funding data to be the first of the standard assemblies in the highest-level standard assembly when the feature value is not included in the project feature of the standard assembly;
when there is no match to any of the standard assemblies, the match is determined to be unsuccessful.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111125924.0A CN113781011A (en) | 2021-09-26 | 2021-09-26 | Verification method and system for project cost of power distribution network |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111125924.0A CN113781011A (en) | 2021-09-26 | 2021-09-26 | Verification method and system for project cost of power distribution network |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113781011A true CN113781011A (en) | 2021-12-10 |
Family
ID=78853313
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111125924.0A Pending CN113781011A (en) | 2021-09-26 | 2021-09-26 | Verification method and system for project cost of power distribution network |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113781011A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117273966A (en) * | 2023-06-13 | 2023-12-22 | 华腾建信科技有限公司 | Dynamic engineering financial accounting method, device, equipment and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372781A (en) * | 2016-08-26 | 2017-02-01 | 国家电网公司 | Standard power grid project information provision template |
| CN107767077A (en) * | 2017-11-13 | 2018-03-06 | 国网安徽省电力有限公司 | Distribution mass cost compilation method |
| CN111598732A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Construction project cost auditing system and method |
| CN112307101A (en) * | 2020-10-24 | 2021-02-02 | 上海东方投资监理有限公司 | Project pricing auditing method, device, computer equipment and system |
-
2021
- 2021-09-26 CN CN202111125924.0A patent/CN113781011A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106372781A (en) * | 2016-08-26 | 2017-02-01 | 国家电网公司 | Standard power grid project information provision template |
| CN107767077A (en) * | 2017-11-13 | 2018-03-06 | 国网安徽省电力有限公司 | Distribution mass cost compilation method |
| CN111598732A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | Construction project cost auditing system and method |
| CN112307101A (en) * | 2020-10-24 | 2021-02-02 | 上海东方投资监理有限公司 | Project pricing auditing method, device, computer equipment and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117273966A (en) * | 2023-06-13 | 2023-12-22 | 华腾建信科技有限公司 | Dynamic engineering financial accounting method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN100378757C (en) | Injection molding cost estimation system | |
| CN1971566A (en) | Tracking usage of data elements in electronic business communications | |
| CN112163553B (en) | Material price accounting method, device, storage medium and computer equipment | |
| CN111127068B (en) | Automatic pricing method and device for engineering quantity list | |
| CN110728422A (en) | Building information model, method, device and settlement system for construction project | |
| CN109033173B (en) | Data processing method and device for generating multidimensional index data | |
| CN113722790A (en) | BIM technology-based model engineering quantity statistical method | |
| CN113781011A (en) | Verification method and system for project cost of power distribution network | |
| CN112860769A (en) | Energy planning data management system | |
| AU2021102904A4 (en) | A BIM-Based Optimization Method of Construction Cost and Construction Duration-Cost of Prefabricated Construction Project | |
| CN113592538B (en) | Project cost approximate calculation method and system | |
| CN114493266A (en) | Intelligent quality control method and system for engineering cost achievement | |
| CN113886373A (en) | Data processing method and device and electronic equipment | |
| CN116415199B (en) | Business data outlier analysis method based on audit intermediate table | |
| CN113409001A (en) | Method for controlling automatic pricing of construction engineering quantity list | |
| CN112966946A (en) | Method and device for generating material balance index system framework | |
| CN116126790A (en) | Railway engineering archive archiving method and device, electronic equipment and storage medium | |
| CN115309705A (en) | Data integration classification system and method for automatically identifying basic data elements of urban information model platform | |
| Živkovič et al. | The impact of details in the class diagram on software size estimation | |
| CN113592537B (en) | Soil remediation engineering cost approximate calculation method, device and computer system | |
| CN111831382A (en) | Data entry method, device, equipment and medium for engineering cost software | |
| CN115438036B (en) | Data redundancy processing system and method for unified index database of power grid | |
| CN109977269B (en) | Data self-adaptive fusion method for XML file | |
| CN117892703B (en) | Implementation method and system for automatic association input function of physical and chemical forms | |
| CN112308608B (en) | Data processing method and device for manufacturing cost of transformer substation, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |