CN112308608B

CN112308608B - Data processing method and device for manufacturing cost of transformer substation, electronic equipment and storage medium

Info

Publication number: CN112308608B
Application number: CN202011180393.0A
Authority: CN
Inventors: 黄欣; 李端姣; 李钦; 郇嘉嘉; 蓝晓东; 张小辉; 季玉华; 李俊芳; 李耀东; 高晓彬; 洪海峰; 赵敏彤; 张丽萍
Original assignee: Guangdong Power Grid Co Ltd
Current assignee: Guangdong Power Grid Co Ltd
Priority date: 2020-10-29
Filing date: 2020-10-29
Publication date: 2023-01-24
Anticipated expiration: 2040-10-29
Also published as: CN112308608A

Abstract

The invention provides a data processing method and device for the cost of a transformer substation, electronic equipment and a storage medium, wherein the method comprises the following steps: performing keyword retrieval on all the bidding text information and extracting and summarizing information corresponding to the keywords to generate a project detail table; analyzing the full life cycle of the project detail table according to the asset equipment full life cycle database to obtain a total pre-calculated value of the full life cycle of the bidding document, and further determining the minimum bidding document; judging whether the deviation percentage of the minimum value standard is smaller than the preset deviation percentage or not; if so, determining and publishing the minimum value bidding document as a target bidding document. Compared with the prior art, the embodiment of the invention considers the whole period of different equipment types and different solutions of the transformer substation, and can evaluate the cost of the transformer substation more comprehensively to obtain a proper management scheme.

Description

Data processing method and device for manufacturing cost of transformer substation, electronic equipment and storage medium

Technical Field

The invention belongs to the technical field of cost management, and particularly relates to a data processing method and device for the cost of a transformer substation, electronic equipment and a storage medium.

Background

Referring to fig. 1, fig. 1 is an overview of the whole life-cycle cost management content of the electric power project, wherein in the implementation stage of the project, the electric power project can be mainly divided into a construction period and an operation period, specifically, the construction period includes: investment decision stage, design stage, bid and tender stage, construction stage and completion acceptance stage; the operation period comprises a warranty stage, an operation and maintenance stage and a dismantling stage. In actual electric power engineering implementation, each stage relates to stage engineering cost, and the most important part of cost management contents is calculation and control of the stage engineering cost, for example, in an investment decision stage, the stage engineering cost is determined through investment estimation, and then whether the investment estimation needs to be reduced or not is determined through economic evaluation of a construction project; and in the design stage, the initial approximate calculation, the expenditure of the precalculated value of the construction drawing and the like are controlled through quota design, design scheme evaluation and optimization.

For a long time, the project cost management mode which is the dominating position in China is the whole process project cost management, and the research on the project cost management mode in the whole life cycle is rarely carried out in China. Particularly in the aspect of transformer substation engineering, the emphasis in the current transformer substation engineering cost management mode in China is the basic construction cost of the transformer substation, and the important link of the engineering cost management, namely the operation and maintenance cost of the transformer substation, is not considered or only roughly considered, and the scope of the operation and maintenance cost and the calculation method of the cost cannot be given. From a long-term perspective, the operation and maintenance cost of the transformer substation is far higher than the basic construction cost, the operation and maintenance cost in the future is greatly influenced by the previous basic construction cost, and the cost of the transformer substation in the whole life cycle is reduced due to the fact that the operation and maintenance cost in the future is greatly reduced by the higher basic construction cost. The construction stage and the future operation and maintenance stage of the transformer substation in China cannot be well connected, the stages are mutually independent, and a complete and coherent cost management system does not exist.

Therefore, a data processing method for the manufacturing cost of the transformer substation is urgently needed to solve the problem that in the prior art, the manufacturing cost of the transformer substation is only considered by the construction cost and is not considered based on the whole cycle of the transformer substation, so that the cost in the life cycle of the transformer substation is high.

Disclosure of Invention

The invention provides a data processing method and device for the cost of a transformer substation, electronic equipment and a storage medium, which are used for solving the technical problem that the cost of the transformer substation in the prior art is higher in the life cycle of the transformer substation due to the fact that only construction cost is considered and the whole cycle of the transformer substation is not considered.

In a first aspect, the present invention provides a method for processing data of manufacturing cost of a substation, the method including the steps of:

step S1: acquiring the character information of the bidding document;

step S2: performing keyword retrieval on the text information, extracting and summarizing information corresponding to the keywords, and generating a project detail table, wherein the project detail table comprises a measure scheme and corresponding initial investment cost;

and step S3: performing full-period analysis on the project detail table according to a pre-constructed asset equipment full-life period database to obtain a total budget value of the full-life period of the bidding document;

and step S4: executing the steps S1-S3 on all the bidding documents to obtain the total budget values of the full life cycles of all the bidding documents, and determining the minimum bidding document corresponding to the minimum total budget value of the full life cycle;

step S5: acquiring a preset deviation percentage, and judging whether the deviation percentage of the minimum value bidding document is smaller than the preset deviation percentage or not; the deviation percentage of the minimum value standard is the ratio of the average cost of the initial investment cost and the historical investment cost corresponding to the measure scheme in the minimum value standard;

step S6: if so, determining and publishing the minimum value bidding document as a target bidding document;

step S7: and if not, discarding the minimum value standard and re-executing the steps S4-S7.

Preferably, the step of building a pre-built asset device full lifecycle database comprises:

traversing all historical projects, recording the project types of the historical projects, the measures corresponding to the project types, the scale of the measures, the initial investment cost and the annual cost corresponding to the measures, and forming a historical project table;

analyzing the historical project table by a function curve fitting method, and determining and recording the implementation cost of each measure of different project types in different scales and different years;

and constructing the asset equipment full life cycle database according to the implementation cost of each measure of the different project types in different scales and different years.

Preferably, the step of analyzing the table of historical items by a function curve fitting method, determining and recording implementation costs of each measure of different item categories in different scales and different years comprises:

determining and recording the ratio of annual cost of each measure to initial investment cost according to the historical item table to form a second historical item table;

determining the ratio of the total annual cost to the initial investment cost of the same measure under different scales according to the historical item table and the second historical item table to form a third historical item table;

and analyzing the third history project table by a function curve fitting method, and determining and recording the implementation cost of each action of different project types at different scales and annual fees.

Preferably, after the step S1, the method further includes:

modifying and sorting the text information and marking a first electronic signature;

the text information is checked and marked with a second electronic signature;

and confirming the text information and marking a third electronic signature.

Preferably, the step S6 includes:

if the deviation percentage of the minimum value bidding document is smaller than the preset deviation percentage, placing the minimum value bidding document in a project group for voting;

when the vote passes, determining and publishing the minimum bidding document as the target bidding document;

when the vote fails, discarding the minimum value bid and re-executing the steps S4-S5.

Preferably, the step S3 includes:

acquiring initial investment cost and annual cost of each item of the project detail table in the asset equipment full life cycle database;

summing the initial investment cost and annual cost of each item of the item list to determine a total maintenance quotation;

acquiring the price of the bidding document;

and summing the bidding price of the bidding document and the total maintenance quotation to obtain a total budget value of the full life cycle of the bidding document.

Preferably, the bidding document comprises an electronic bidding document and a non-electronic bidding document; if the bidding document is a non-electronic bidding document, the step of acquiring the character information of the bidding document comprises the following steps:

collecting picture information in the non-electronic bidding document;

and carrying out character recognition on the picture information to acquire character information of the non-electronic bidding document.

In a second aspect, the present invention further provides a data processing apparatus for manufacturing cost of a substation, the apparatus comprising:

the character information acquisition module is used for acquiring character information of the bidding document;

the project detail table generating module is used for performing keyword retrieval on the text information and extracting and summarizing information corresponding to the keywords to generate a project detail table, and the project detail table comprises a measure scheme and a corresponding initial investment cost;

the budget value evaluation module is used for carrying out full-period analysis on the project detail table according to a pre-constructed asset equipment full-life period database to obtain a total budget value of the full-life period of the bidding document;

the minimum value bidding document determining module is used for executing the character information obtaining module, the project detail table generating module and the budget value evaluating module on all bidding documents to obtain total budget values of all bidding documents in the full life cycle and determining a minimum value bidding document corresponding to the minimum total budget value in the full life cycle;

the judging module is used for acquiring a preset deviation percentage and judging whether the deviation percentage of the minimum standard book is smaller than the preset deviation percentage, wherein the deviation percentage of the minimum standard book is the ratio of the initial investment cost corresponding to the measure scheme in the minimum standard book to the average cost of the historical investment cost;

the target bidding document determining module is used for determining and publishing the minimum bidding document as a target bidding document under the condition that the deviation percentage of the minimum bidding document is smaller than the preset deviation percentage;

and the minimum value bid discarding module is used for discarding the minimum value bid and re-executing the minimum value bid determining module, the judging module, the target bid determining module and the minimum value bid discarding module when the deviation percentage of the minimum value bid is greater than or equal to the preset deviation percentage.

In a third aspect, the present invention provides an electronic device comprising a processor and a memory, wherein the memory stores computer readable instructions, and when the computer readable instructions are executed by the processor, the steps of the method as provided in the first aspect are executed.

In a fourth aspect, the present invention provides a storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method as provided in the first aspect above.

According to the technical scheme, the invention has the following advantages:

the invention provides a data processing method, a system and equipment for the cost of a transformer substation, which are characterized in that keyword retrieval is carried out on bidding document character information, and relevant information corresponding to the keywords is extracted and summarized to generate a project detail table; performing full-period budget value evaluation on each project in the project detail table according to the asset equipment full-life period database to obtain a full-life period total budget value of the bidding document; further determining a minimum value bidding document; judging whether the minimum value standard meets the checking condition or not; and if the minimum value bidding document meets the checking condition, determining and publishing the minimum value bidding document as a target bidding document. Compared with the prior art, the embodiment of the invention considers from the whole period of the transformer substation, can evaluate the cost of the transformer substation more comprehensively to obtain a proper management scheme, and solves the technical problem that the cost in the life cycle of the transformer substation is higher because the construction cost is only considered and the whole period of the transformer substation is not considered in the conventional manufacturing cost method of the transformer substation.

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, it is obvious that the drawings in the following description are only some embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts;

FIG. 1 is a data processing of an overview of the cost of a substation for full lifecycle cost management content of an electrical power project;

FIG. 2 is a flow chart of a first embodiment of a method for processing substation cost data according to the present invention;

FIG. 3 is a flow chart of steps of a second embodiment of a method for processing substation cost data according to the present invention;

FIG. 4 is a flow chart of an embodiment of a method for processing substation cost data according to the present invention;

fig. 5 is a block diagram of a data processing apparatus for converting station cost according to the present invention.

Detailed Description

The embodiment of the invention provides a data processing method, a device, equipment and a storage medium for the cost of a transformer substation, which are used for solving the technical problem that in the prior art, the cost of the transformer substation is only considered by the construction cost and is not considered based on the whole cycle of the transformer substation, so that the cost in the life cycle of the transformer substation is higher.

In order to make the objects, features and advantages of the present invention more obvious and understandable, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is obvious that the embodiments described below are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.

In the first embodiment, please refer to fig. 2, and fig. 2 is a flowchart illustrating a first step of a first method for processing substation cost data according to the first embodiment of the present invention, which specifically includes the following steps:

step S11: acquiring the character information of the bidding document;

in a preferred embodiment, the bidding document includes an electronic bidding document and a non-electronic bidding document; if the bidding document is a non-electronic bidding document, the step of acquiring the character information of the bidding document comprises the following steps:

collecting picture information in the non-electronic bidding document;

In the embodiment of the invention, the acquiring of the text information of the label comprises two types, one is to input the electronic label at the input port in an electronic document mode, and the other is to acquire the text information by performing text recognition on the paper-version label;

in a specific implementation, the paper version label collecting device is usually an OCR recognition unit, and performs character recognition on the image file corresponding to the scanned and generated paper version file to obtain character information of the paper version file.

It should be noted that, because the accuracy of the OCR recognition unit is limited, after the paper document is scanned, a manual checking process may be added to check the text content recognized by the OCR recognition unit.

In a preferred embodiment, after the step S1, the method further includes:

the text information is checked and marked with a second electronic signature;

and confirming the text information and marking a third electronic signature.

It should be noted that, the situation that the characters are not accurate enough may exist in both the case of acquiring the character information of the electronic bidding document in the form of the electronic document and the case of acquiring the character information of the paper-version bidding document in the form of the OCR unit, and therefore, the character information of the bidding document needs to be checked.

In the embodiment of the invention, because the label, especially the paper label, relates to confidential information, the steps of modifying, sorting, auditing and confirming the character information of the paper label need at least more than three controllers to modify, sort, audit and confirm the label, and a corresponding electronic signature label is left behind the file of the OCR identification unit so as to trace to the source; in the electronic data input system, multi-person verification is also performed on the electronic data and an electronic signature tag is left for tracing the source, considering that the electronic data may also have a problem of storage and input errors.

In the specific implementation, the modification, arrangement, audit and confirmation of the text information can be realized by adopting a computer or artificial intelligence mode, at present, a manual check mode is mainly adopted, the text information of the label is conveyed into a controller of a modifying and arranging responsible person to modify and arrange the label and label a first electronic signature, the modified and arranged label is sent into the controller of the examining and arranging responsible person to examine and label a second electronic signature, and then the examined and arranged label is sent into the controller of the confirmed responsible person to examine and determine the label and label a third electronic signature, wherein the first electronic signature, the second electronic signature and the third electronic signature can be names or numbers of the responsible person, and the purpose of labeling the first electronic signature, the second electronic signature and the third electronic signature is to trace the source through the first electronic signature, the second electronic signature and the third electronic signature when a problem occurs in a subsequent label. For the file input by the electronic document, a process of checking is also required, and preferably, the electronic document and the paper document are checked correspondingly.

Step S12: carrying out keyword retrieval on the character information and extracting and summarizing information corresponding to the keywords to generate a data table, wherein the data table comprises a measure scheme and a corresponding initial investment cost;

it should be noted that the data table includes items (device voltage class, device type, device name) each including a keyword, a measure corresponding to the item, an investment cost corresponding to the measure, a total price corresponding to the measure, and the like, and generally, if the measure corresponding to the item is to add a new power device, the data table further includes a service life of the device, a number of the devices, and the like.

In practical applications, because the bidding documents related to each company are not in the same format, there are differences in the arrangement order and content distribution of the input items, and therefore a standard data table needs to be established so that the items of each bidding document can be arranged according to the preset rules. For example: the "equipment voltage class" can only be ten options of "500kV, 220kV, 110kV, ± 160kV, 66kV, 35kV, 20kV, 10kV, 380V, and 380V/220V", and the "equipment type" corresponds to the equipment type in the asset equipment full life cycle database one by one, for example, there is an equipment category called "main transformer", and by retrieving "main transformer", then find the contents of the standard about the quantity, unit price, total price, brand, specific model (for example: converter transformer, grounding transformer for station, oil-immersed transformer, SF6 transformer), etc. and by retrieving the matching result, fill in the preset item detail table in a specific form, as the data table provided in this embodiment is as follows:

step S13: performing full-period analysis on the data table according to a pre-constructed asset equipment full-life period database to obtain a total pre-calculated value of the full-life period of the bidding document;

step S14: executing the steps S11-S13 on all the bidding documents to obtain the total budget values of the full life cycles of all the bidding documents, and determining the minimum bidding document corresponding to the minimum total budget value of the full life cycle;

step S15: acquiring a preset deviation percentage, and judging whether the deviation percentage of the minimum value bidding document is smaller than the preset deviation percentage, wherein the deviation percentage of the minimum value bidding document is the ratio of the initial investment cost corresponding to the measure scheme in the minimum value bidding document to the average cost of the historical investment cost;

the deviation percentage is an average cost deviation degree between the initial input cost and the historical input cost of the current bid item.

In the embodiment of the invention, the total budget value comprises an initial investment cost and a maintenance cost, the initial investment cost is obtained from the standard book and needs to be compared with the initial investment cost of the historical standard book, and the deviation ratio of the initial investment cost to the historical standard book is used as a check condition.

Step S16: if so, determining and publishing the minimum value bidding document as a target bidding document;

in a preferred embodiment, the step S16 includes:

when the vote fails, the minimum value index is discarded and the steps S14-S15 are re-executed.

In the embodiment of the invention, a deviation value is preset before expert discussion or bidding. And if the deviation degree of the bidding document with the minimum total precalculated value is higher than the preset value, discarding and re-confirming S14-S15, and if not, voting next step.

It should be noted that voting is based on quantitative analysis in the early stage, and then assists experts' experience in final evaluation of the project. Although the smaller the deviation ratio is, the better the deviation ratio is, the minimum value cannot be pursued at one step, and besides two criteria of minimum of the checking condition and the total precalculated value, the expert also needs to consider the aspects of environment adaptation condition, technical safety standard reaching condition and the like, and if the defects of environment incompatibility, technical safety substandard and the like exist, the voting is not passed.

In a specific implementation, a general determination method is as follows: placing the bidding document with the minimum total budget value in the project group for voting, and when the voting passes, determining the bidding document with the minimum total budget value as a final bidding document and publishing the final bidding document. When the vote does not pass, the bidding document with the minimum current total budget value is discarded and re-trusted S14-S15.

Step S17: and if not, discarding the minimum value standard and re-executing the steps S14-S17.

The invention provides a data processing method, a system and equipment for the cost of a transformer substation, which comprises the following steps of S11: acquiring character information of the bidding document; step S12: performing keyword retrieval on the text information, extracting and summarizing information corresponding to the keywords, and generating a project detail table, wherein the project detail table comprises a measure scheme and corresponding initial investment cost; step S13: performing full-period analysis on the project detail table according to a pre-constructed asset equipment full-life period database to obtain a total budget value of the full-life period of the bidding document; step S14: executing the steps S11-S13 on all the bidding documents to obtain the total budget values of the full life cycles of all the bidding documents, and determining the minimum bidding document corresponding to the minimum total budget value of the full life cycle; step S15: acquiring a preset deviation percentage, and judging whether the deviation percentage of the minimum value bidding document is smaller than the preset deviation percentage, wherein the deviation percentage of the minimum value bidding document is the ratio of the initial investment cost corresponding to the measure scheme in the minimum value bidding document to the average cost of the historical investment cost; step S16: if so, determining and publishing the minimum value bidding document as a target bidding document; step S17: if not, discarding the minimum value bidding document and re-executing the steps S14-S17. Compared with the prior art, the embodiment of the invention considers the whole period of the transformer substation, can evaluate the cost of the transformer substation more comprehensively to obtain a proper management scheme, and solves the technical problem that the cost of the transformer substation in the life cycle of the transformer substation is higher because the construction cost is only considered and the whole period of the transformer substation is not considered in the cost management method of the transformer substation in the prior art.

In a second embodiment, please refer to fig. 3, where fig. 3 is a flowchart illustrating steps of a second embodiment of a method for processing substation cost data according to the present invention, which specifically includes the following steps:

step S21: acquiring character information of the bidding document;

step S22: carrying out keyword retrieval on the character information and extracting and summarizing information corresponding to the keywords to generate a project detail list, wherein the project detail list comprises a measure scheme and a corresponding initial investment cost;

step S23: acquiring initial investment cost and annual cost of each item of the project detail table in the asset equipment full life cycle database;

in a preferred embodiment, the step of building the asset device full lifecycle database comprises: traversing all historical projects, recording the project types of the historical projects, the measures corresponding to the project types, the scale of the measures, the initial investment cost and the annual cost corresponding to the measures, and forming a historical project table;

in the embodiment of the invention, the asset equipment full life cycle database comprises solution measures of all projects of the transformer substation, service life corresponding to the solution measures, annual maintenance cost and the like, and the following table shows that:

in a specific implementation, the bidding document is composed of a plurality of items, and each item has a plurality of solving measures, including: new construction, replacement, additional installation, partial reconstruction, disassembly, maintenance and the like. Moreover, for the same bidding document, different bidding manufacturers can use different means to meet the bidding document requirements, so that larger price difference exists, and the solution measures of the manufacturers need to be taken into consideration. The method is characterized in that different solutions are different items in the same equipment category and the same voltage level, each item can only select one solution, each solution has different scale, although the solutions are the same due to different scales, the initial investment cost and the later maintenance cost are different, and one solution is selected in each item in the implementation process to achieve the purpose of building the standard book.

In an embodiment of the invention, the asset device full lifecycle database comprises: sub-projects per substation, the size of each sub-project, the initial construction cost of each project, and the total budget expenditure per year for each project. Specifically, the sub-project size of each project may be the amount, total amount, etc. of data quantifiable for a specific project, and the total budget expenditure of each project mainly includes the replacement maintenance cost and the annual maintenance cost, and if there is a project requiring manual work, the labor hour cost.

The human labor time cost accounting method comprises the following steps: the project which needs to involve the human cost is extracted, then the total manual expenditure, namely the total compensation of all the employees, is uniformly distributed on each project, and then the adjustment of the human labor time cost is carried out according to the labor time proportion occupied by the project so as to account the human labor time cost of each project.

For example, if two different control systems are adopted, one control system adopts older hardware, so that the control speed is slower, more labor and time costs are required, and the problems of high maintenance cost and the like possibly exist; the other set adopts newer hardware, the operation speed is faster, the human labor hour cost required to be spent is lower, but additional expenses such as large power consumption and the like can exist, the expenses need to be calculated, and the difference of the total precalculated values among different operation systems can be observed along with the increase of the service life, which does not represent new certain meeting, and the specific implementation life and statistical data need to be evaluated because the additional expenses are required.

in a preferred embodiment, the step of analyzing the table of historical items by function curve fitting, determining and recording the implementation cost of each measure of different item categories in different scales and different years comprises

Determining and recording the ratio of annual cost of each measure to initial investment cost according to the historical project table to form a second historical project table;

in the embodiment of the invention, if the solving measures with the same solving measures and the same scale exist when the existing transformer substation data is obtained for a project, the average value is obtained; if the solving measures with the same solving measures and different scales exist, recording the solving measures respectively, and then carrying out secondary arrangement on the data subjected to the estimation of the full life cycle budget value to form a second historical project table: the raw data in the asset equipment full life cycle database includes the scale of the solution, the cost per year, the initial investment cost and the like, and the second historical project table is as follows:

determining the ratio of the total annual cost and the initial investment cost of the same measure under different scales according to the historical item table and the second historical item table to form a third historical item table;

in the embodiment of the present invention, for the formed second history item table, the same solving measures of different scales in the same item are extracted and combined into a plurality of new sets respectively to form a third history item table, which is as follows:

In the embodiment of the present invention, for the third history item table, the data of the same solution on different scales are further sorted: extracting data of the same solving measure in different scales, establishing a plurality of tables at different time points, wherein the horizontal and vertical coordinates of each table are respectively scale and cost, and fitting by a function curve (the simplest direct connection line or fitting by a quadratic curve and a cubic curve) so as to obtain the implementation cost of each scale and each year corresponding to the solving measure.

It is worth mentioning that, according to the real-time updating requirement, as if some solutions in the same project have too little or no data, the solutions can be actively adopted in the related substation for experimental implementation, so as to obtain the actual data and derive the annual expense data. Or supplementing the expense data of the related items according to a corresponding estimation model such as a theoretical model.

It should be noted that, when constructing the asset device full life cycle database, in the embodiment of the present invention, the data related to the expense is not directly the total expense amount, but the ratio of the expense to the initial cost is used, which can better form the expense evaluation from the whole life cycle, and can avoid the cognitive discrepancy caused by the absolute numerical value.

Constructing the asset equipment full life cycle database according to the implementation cost of each measure of the different project types in different scales and different years;

in the embodiment of the invention, the implementation cost of each measure of different project types in different scales and different years is stored, and the construction of the asset equipment full life cycle database is completed.

Step S24: summing the initial investment cost and annual cost of each item of the item list to determine a total maintenance quotation;

step S25: acquiring the price of the bidding document;

step S26: summing the bidding price of the bidding document and the total maintenance quotation to obtain a total budget value of the full life cycle of the bidding document;

in the embodiment of the invention, the sum of all items in the bidding document is accumulated to obtain the budget value of the spending in the whole life cycle of the bidding document.

Step S27: executing steps S21-S23 on all the bidding documents to obtain total budget values of the full life cycles of all the bidding documents, and determining the minimum bidding document corresponding to the minimum total budget value of the full life cycle;

the method comprises the steps of comparing the total budget value of the full life cycle of each bidding document, wherein the total budget value of the full life cycle of each bidding document comprises bidding price of the bidding document and maintenance price of the bidding document, the bidding price of the bidding document is compared in the prior art, so that the cost cannot be evaluated from the full life cycle, the maintenance cost is far higher than the cost marked by the bidding document, and the cost of the life cycle of the transformer substation is higher. The bidding document with the minimum total budget value is obtained by comparing the total budget values of all the bidding documents in the whole life cycle, and the bidding document with the minimum total budget value is the bidding document and the maintenance cost of the bidding document are considered.

Step S28: acquiring a preset deviation percentage, and judging whether the deviation percentage of the minimum value standard is smaller than the preset deviation percentage; the deviation percentage of the minimum value standard is the ratio of the average cost of the initial investment cost and the historical investment cost corresponding to the measure scheme in the minimum value standard;

step S29: if so, determining and publishing the minimum value bidding document as a target bidding document;

step S30: if not, discarding the minimum value standard and re-executing the steps S27-S30.

In the embodiment of the invention, if the item which does not accord with the checking condition exists in the standard book with the minimum total budget value, the standard book with the minimum total budget value is discarded, S24-S27 is executed again to obtain a new standard book with the minimum total budget value, and whether the standard book accords with the checking condition is judged again until a standard book which can accord with the checking condition is obtained. Therefore, the technical problem that in the prior art, the construction cost of the transformer substation is only considered, and the construction cost is not considered based on the whole period of the transformer substation, so that the expense cost in the life cycle of the transformer substation is high is solved.

The invention provides a data processing method of transformer substation cost, which comprises the steps of searching keywords of text information of a standard book, extracting and summarizing the keywords and information corresponding to the keywords, summarizing the searched keywords and items containing the keywords to obtain an item detail table, evaluating the budget value of each item in the item detail table in a whole period, evaluating the total budget value of all the whole life cycles of the standard book, comparing the total budget values of all the whole life cycles of the standard book to obtain the standard book with the minimum total budget value, checking the standard book with the minimum total budget value, and publishing the standard book with the minimum total budget value meeting the checking condition as a final standard book. Compared with the prior art, the embodiment of the invention considers the whole period of the transformer substation, can evaluate the cost of the transformer substation more comprehensively to obtain a proper management scheme, and solves the technical problem that the cost in the life cycle of the transformer substation is higher because the construction cost is only considered and the cost is not considered based on the whole period of the transformer substation in the conventional cost management method of the transformer substation.

In order to facilitate an understanding of the beneficial effects of the present invention for those skilled in the art, the following is an illustrative description of the invention in the home by way of example.

Referring to FIG. 4, a flow chart of an embodiment of the present invention is shown.

Selecting paper input or electronic data input bidding documents on an input side, if the input paper data is input, transmitting the paper data to an OCR unit through scanning equipment, and entering a manual intervention link after the paper data is scanned; if the input is electronic data, the manual intervention link is directly entered. Wherein, the manual intervention link is provided with three control machines which are respectively used for modification, arrangement, audit and confirmation of electronic data or paper data. After the manual intervention is finished, the text information extracted from the electronic data or the paper data enters a keyword extraction module, and further an item list is generated, wherein the item list has a specific unified structure. And based on an item list with a specific unified structure, combining a full life cycle unit, calculating the total budget value of the full life cycle of the bidding document, sequentially storing the calculation results in a storage, repeating the steps until the judgment module judges that the input is finished, comparing the total budget value through a comparison unit, determining the bidding document with the lowest budget value, and entering a manual intervention link. Specifically, the manual intervention link is provided with at least two voting machines, and the bidding documents passing the voting are transmitted to the publicity unit for publicity.

As shown in fig. 5, the present embodiment further provides a data processing apparatus for manufacturing cost of a substation, including:

the text information acquisition module 101 is used for acquiring text information of the bidding document;

in a preferred embodiment, the bidding document comprises an electronic bidding document and a non-electronic bidding document; the text information obtaining module 101 includes:

the acquisition submodule is used for acquiring picture information in the non-electronic bidding document;

and the recognition submodule is used for carrying out character recognition on the picture information to acquire the character information of the non-electronic bidding document.

In a preferred embodiment, the apparatus further comprises:

the first electronic signature submodule is used for modifying and sorting the text information and marking a first electronic signature;

the second electronic signature submodule is used for auditing the character information and marking a second electronic signature;

and the third electronic signature submodule is used for determining the text information and marking a third electronic signature.

A project detail table generating module 102, configured to perform keyword retrieval on the text information and extract and summarize information corresponding to the keywords, so as to generate a project detail table, where the project detail table includes a measure scheme and a corresponding initial investment cost;

a budget value evaluation module 103, configured to perform a full-period analysis on the project detail table according to a pre-constructed asset device full-life period database, to obtain a total budget value of the full-life period of the bidding document;

in a preferred embodiment, the building of the built asset device full lifecycle database comprises:

the recording module is used for traversing all historical projects, recording the project types of the historical projects, the measures corresponding to the project types, the scale of the measures, the initial investment cost and the annual cost corresponding to the measures, and forming a historical project table;

the analysis module is used for analyzing the historical project table by a function curve fitting method, and determining and recording the implementation cost of each measure of different project types in different scales and different years;

and the construction module is used for constructing the asset equipment full life cycle database according to the implementation cost of each measure of different project types in different scales and different years.

In a preferred embodiment, the analysis module comprises:

the second historical item table forming submodule is used for determining and recording the ratio of annual cost of each measure to initial investment cost according to the historical item table to form a second historical item table;

a third history project table forming submodule for determining the ratio of the total annual cost and the initial investment cost of the same measure under different scales according to the history project table and the second history project table to form a third history project table;

and the implementation cost determination submodule is used for analyzing the third history project table by a function curve fitting method, and determining and recording implementation cost of each measure of different project categories on different scales and annual fees.

In a preferred embodiment, the budget value evaluation module 103 includes:

a maintenance quotation obtaining submodule, which is used for obtaining the initial investment cost and annual cost of each item of the project detail list in the asset equipment full life cycle database;

a total maintenance quotation determining submodule, which is used for summing the initial investment cost and annual cost of each item of the item list and determining the total maintenance quotation;

the price obtaining submodule is used for obtaining the price of the bidding document;

and the summation submodule is used for summing the bidding price of the bidding document and the total maintenance quotation to obtain a total budget value of the full life cycle of the bidding document.

A minimum value bidding document determining module 104, configured to execute the text information obtaining module 101, the project detail table generating module 102, and the budget value evaluating module 103 on all bidding documents, obtain total budget values of all bidding documents in a full life cycle, and determine a minimum value bidding document corresponding to the minimum total budget value in the full life cycle;

the judging module 105 is configured to obtain a preset deviation percentage, and judge whether the deviation percentage of the minimum bidding document is smaller than the preset deviation percentage, where the deviation percentage of the minimum bidding document is a ratio of an initial investment cost corresponding to the measure scheme in the minimum bidding document to an average cost of a historical investment cost;

a target bidding document determining module 106, configured to determine and publish the minimum bidding document as a target bidding document when the deviation percentage of the minimum bidding document is smaller than the preset deviation percentage;

in a preferred embodiment, the target bidding determination module 106 comprises:

the voting submodule is used for placing the minimum value bidding document in a project group for voting if the deviation percentage of the minimum value bidding document is smaller than the preset deviation percentage;

the publishing submodule is used for determining and publishing the minimum bidding document as a target bidding document when the vote passes;

and a re-execution sub-module, configured to discard the minimum value bidding document and re-execute the minimum value bidding document determination module 104 and the judgment module 105 when the vote fails.

A discarding minimum value bidding module 107, configured to discard the minimum value bidding document and re-execute the minimum value bidding document determining module 104, the determining module 105, the target bidding document determining module 106, and the discarding minimum value bidding document module 107 when the deviation percentage of the minimum value bidding document is greater than or equal to the preset deviation percentage.

An embodiment of the present invention further provides an electronic device, which includes a memory and a processor, where the memory stores a computer program, and when the computer program is executed by the processor, the processor executes the steps of the data processing method for manufacturing a substation according to any one of the above embodiments.

The embodiment of the invention also provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by the processor, the data processing method for the manufacturing cost of the transformer substation is implemented as described in any one of the above embodiments.

It can be clearly understood by those skilled in the art that, for convenience and simplicity of description, the specific working process of the apparatus described above may refer to the corresponding process in the foregoing method embodiment, and details are not described herein again.

In the several embodiments provided in the present invention, it should be understood that the disclosed apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one type of logical functional division, and other divisions may be realized in practice, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.

The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.

In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.

The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, and various media capable of storing program codes.

The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.

Claims

1. A data processing method for manufacturing cost of a transformer substation is characterized by comprising the following steps:

step S1: acquiring character information of the bidding document;

step S2: carrying out keyword retrieval on the character information and extracting and summarizing information corresponding to the keywords to generate a project detail list, wherein the project detail list comprises a measure scheme and a corresponding initial investment cost;

the step of pre-building the asset device full lifecycle database comprises:

constructing the asset equipment full life cycle database according to the implementation cost of each measure of different project types in different scales and different years;

step S5: acquiring a preset deviation percentage, and judging whether the deviation percentage of the minimum value standard is smaller than the preset deviation percentage; the deviation percentage of the minimum value standard is the ratio of the average cost of the initial investment cost and the historical investment cost corresponding to the measure scheme in the minimum value standard;

step S6: if yes, determining and publishing the minimum bidding document as a target bidding document;

step S7: if not, discarding the minimum value bidding document and re-executing the steps S4-S7.

2. The method for processing substation cost data according to claim 1, wherein said step of analyzing said historical project table by means of functional curve fitting, determining and recording implementation costs of each measure of different project categories at different scales and different years comprises

3. The method for processing the data of the construction cost of the substation according to claim 2, wherein after the step S1, the method further comprises:

the text information is checked and marked with a second electronic signature;

and confirming the text information and marking a third electronic signature.

4. The method for processing data of substation construction cost according to claim 3, wherein the step S6 comprises:

and when the vote is not passed, discarding the minimum value bidding document and re-executing the steps S4-S5.

5. The substation cost data processing method according to claim 4, wherein the step S3 comprises:

acquiring initial investment cost and annual fee of each item of the project detail table in the asset equipment full life cycle database;

acquiring the price of the bidding document;

6. The method of data processing of substation cost according to claim 5, wherein the ticket comprises an electronic ticket and a non-electronic ticket; if the bidding document is a non-electronic bidding document, the step of acquiring the character information of the bidding document comprises the following steps:

collecting picture information in the non-electronic bidding document;

7. A data processing device of transformer substation cost, characterized in that includes:

the project detail table generation module is used for performing keyword retrieval on the text information and extracting and summarizing information corresponding to the keywords to generate a project detail table, and the project detail table comprises a measure scheme and corresponding initial investment cost;

the construction of the constructed asset device full life cycle database comprises the following steps:

the recording module is used for traversing all historical items, recording item types of the historical items, actions corresponding to the item types, the scale of the actions, initial investment cost and annual cost corresponding to the actions and forming a historical item table;

the construction module is used for constructing the asset equipment full life cycle database according to the implementation cost of each measure of different project types in different scales and different years;

and the discarding minimum value bidding module is used for discarding the minimum value bidding and re-executing the minimum value bidding determining module, the judging module, the target bidding determining module and the discarding minimum value bidding module under the condition that the deviation percentage of the minimum value bidding is greater than or equal to the preset deviation percentage.

8. An electronic device comprising a processor and a memory storing computer readable instructions that, when executed by the processor, perform the method of any one of claims 1-6.

9. A storage medium having a computer program stored thereon, wherein the computer program, when executed by a processor, performs the method according to any of claims 1-6.