CN109784689A - A kind of power grid infrastructure project method for processing report data - Google Patents
A kind of power grid infrastructure project method for processing report data Download PDFInfo
- Publication number
- CN109784689A CN109784689A CN201811624605.2A CN201811624605A CN109784689A CN 109784689 A CN109784689 A CN 109784689A CN 201811624605 A CN201811624605 A CN 201811624605A CN 109784689 A CN109784689 A CN 109784689A
- Authority
- CN
- China
- Prior art keywords
- data
- clause
- charge
- expense
- power grid
- 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.)
- Granted
Links
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to a kind of power grid infrastructure project method for processing report data, belong to infrastructure project processing technology field, solve the problems, such as that the prior art generates clearing report and needs a large amount of manual interventions, obtains result inaccuracy.This method comprises the following steps: according to power grid infrastructure project expense item standard, obtaining the calculation method of charge clause and each charge clause that this infrastructure project is related to；Using charge clause as keyword, search obtains this infrastructure project and includes the file set of above-mentioned expense, and obtains the corresponding data of each charge clause in file set；Data check rule base is constructed, the corresponding data of each charge clause are verified, if do not passed through, alarm driving amendment passes through until all charge clauses verify；The corresponding data of each charge clause by verifying are calculated according to the calculation method, generate power grid infrastructure project statement.This method can intelligently, efficiently and accurately help user to provide budget needed for the completion of projects report, be not necessarily to manual intervention.
Description
Technical field
The present invention relates to infrastructure project processing technology field more particularly to a kind of power grid infrastructure project report data processing sides
Method.
Background technique
Currently, the establishment of power grid infrastructure project budget needed for the completion of projects report, generally uses hand weaving method.Due to power grid base
It is more to build the unit that construction scale of projects is huge, business is wide, is related to, even if using automatic establishment report method, it is also desirable to carry out
A large amount of manual interventions, heavy workload, difficulty is high, and error-prone.
Current power grid infrastructure project budget needed for the completion of projects auto report completing tool, mainly include two classes: one kind is according to knot
It calculates report, turn solid inventory, account etc. and actually occurs data, automatically generate statement data, the problem is that, need basis
During practice of construction situations such as change attestation, timely adjustment of budgetary estimation, and maintenance variation one by one in systems, it is ensured that clearing system
Consistent with budgetary estimate system just to provide accurate statement, practical application difficulty is big.And another kind of it is to give an written reply budgetary estimate system
Foundation provides statement using total value allocation way, i.e., is kept accounts architectural engineering expense and installing engineering according to the clearing authorization amount of money
Take, and shares in the architectural engineering and installing engineering of detail by budgetary estimate project and accounting, the problem is that, to give an written reply budgetary estimate
It is frequently present of as final accounts project, but in Process of Engineering Construction and needs the case where adjusting, therefore detail is taken in final statement
It can not really reflect present case with possibly, and by the way of total value pro rata distribution, lead to final accounts engineering detail expense number
It is untrue according to possibility, and then the money value that turns in statement is caused not to be bonded reality.
Summary of the invention
In view of above-mentioned analysis, the embodiment of the present invention is intended to provide a kind of power grid infrastructure project method for processing report data,
A large amount of manual interventions, acquisition result inaccuracy are needed to solve the problems, such as that the prior art generates clearing report.
On the one hand, the embodiment of the invention provides a kind of power grid infrastructure project method for processing report data, including walk as follows
It is rapid:
According to power grid infrastructure project expense item standard, the charge clause and each expense that this infrastructure project is related to are obtained
With the calculation method of clause；
Using charge clause as keyword, search obtains this infrastructure project and includes the file set of above-mentioned expense, and obtains text
Part is concentrated the corresponding data of each charge clause of All Files and is stored；
Data check rule base is constructed, the corresponding data of each charge clause of storage are verified, if verification is obstructed
It crosses, then issues alarm driving amendment for unacceptable charge clause, pass through until all charge clauses verify；
The corresponding data of each charge clause by verifying are calculated according to the calculation method, according to prefabricated report
Table template carries out format rendering to calculated result, generates power grid infrastructure project statement, and save, determining after display preservation
Calculate report and storing path.
Above-mentioned technical proposal has the beneficial effect that: automatic identification and can construct budgetary estimate settlement data (charge clause pair
The data answered) with the corresponding relationship of standards system (charge clause), realize that electricity power engineering builds pre- regulator system and bill of quantities
The automatic integration of standard, and budgetary estimate data, settlement data, detail account data, turn money data etc. are carried out according to Standard Rate system
Parsing, conversion, verify, collect, sharing, can intelligently, efficiently and accurately help user to provide budget needed for the completion of projects report, true
Manual intervention can be reduced while protecting lean management during statement is provided.
It is described according to power grid infrastructure project expense item standard in another embodiment based on the above method, obtain this
The calculation method of charge clause and each charge clause that secondary infrastructure project is related to, includes the following steps:
It extracts in the pre- rule of electricity power engineering construction and bill of quantities normative document and is related to the keyword of expense, obtain this
The calculating of higher level's expense item is calculated in each charge clause of all charges clauses that infrastructure project is related to according to junior's expense item
Formula；
Classified automatically to all charge clauses that this infrastructure project is related to according to default class condition, obtains budgetary estimate
Summarize class, architectural engineering class, installing engineering class, equipment purchasing class and other class charge clauses；
Participle matching is carried out to above-mentioned every a kind of charge clause, deletes duplicate charge clause, and carry out to remaining clause
Applicability is verified, and not applicable charge clause is deleted.
The beneficial effect of above-mentioned technical proposal is: electricity power engineering being built pre- regulator system and has been carried out with bill of quantities standard
It is whole to close, form unified charge clause system.Classification multi-zone supervision charge clause system, formation cover budgetary estimate and summarize, build
Engineering, installing engineering, equipment purchasing, five major class of other fees Standard Rate clause.
Further, described that participle matching is carried out to above-mentioned every a kind of charge clause, deletes duplicate charges clause and to surplus
Remaining clause carries out applicability verification, deletes not applicable charge clause, includes the following steps:
Based on general computer participle matching algorithm and power grid infrastructure project terminology bank, it is to close that semantic term similar, which is arranged,
Keyword carries out participle matching to above-mentioned every a kind of charge clause, deletes semantic duplicate charge clause；
Using this non-power grid infrastructure project term as keyword, applicability verification is carried out to remaining clause by exclusive method,
Delete the charge clause of significant discomfort.
The beneficial effect of above-mentioned further scheme is: carrying out intelligent Matching to charge clause, deletes repetition, significant discomfort is used
Clause.
Further, described using charge clause as keyword, search obtains the file that this infrastructure project includes above-mentioned expense
Collection, and obtain the corresponding data of each charge clause of All Files in file set and store, include the following steps:
Using charge clause as keyword, search obtains the All Files collection that this infrastructure project includes above-mentioned expense, including
Budgetary estimate tables of data, settlement data table, outbound list, equipment acceptance inventory, Item Detail account, project authorize message file；
Successively retrieving above-mentioned file set includes establishment base period price differential, basic reserve fund, special item expense, dynamic expense
With the sentence of, price differential reserve fund, obtains budgetary estimate and summarize the corresponding data of class charge clause；
Successively retrieving above-mentioned file set includes main production building, Master Communications building, relay bungalow, fixed series compensation dress
Set control room, high voltage controllable reactors thyristor valve chamber, controllable series compensator control room, static passive compensation device crystalline substance lock
Tubular valve chamber, power distribution equipment building, main transformer system, fire water pump house, the valve chamber that drenches with rain, framework and Equipment Foundations, high pressure reactance
Device system, series compensation system, water system building, fire-fighting system, auxiliary production building, complex building, area's property of standing build, are special
Structures, area's greening of standing cost sentence, obtain the corresponding data of installing engineering class charge clause；
Successively retrieve above-mentioned file set include main transformer system, power distribution equipment, reactive compensation, control and direct current system,
Station power use system, cable and ground connection, communication and telecontrol system, whole station debugging, maintenance and repair equipment, testing equipment, dispatch from foreign news agency of standing
Source, the outer cost communicated of standing sentence, obtain the corresponding data of installing engineering class charge clause；
It successively retrieves above-mentioned file set and includes power distribution equipment, high voltage reactor, series compensation dress outside power distribution equipment within doors, room
It sets, secondary capacitor, low tension reactor, static passive compensation device, relay protection, on-line monitoring system, whole station cable, whole station
The sentence of the cost of ground connection obtains the corresponding data of equipment purchasing class charge clause；
Matching process is segmented by general purpose computer to the corresponding data of above-mentioned each charge clause to match, and is deleted different
The data of cause, and remaining data is manually verified, the data of irregularity are deleted, budgetary estimate tables of data, the knot of structuring are formed
Calculate tables of data, detail account tables of data, outbound forms data table, equipment acceptance inventory tables of data.
The beneficial effect of above-mentioned further scheme is: intelligently parsing simultaneously verifies project file data, it is ensured that the infrastructure project
Original budgetary estimate tables of data, settlement data table, detail account tables of data, outbound forms data table, equipment acceptance inventory tables of data it is correct
Property.
Further, budgetary estimate tables of data, settlement data table, the detail account tables of data, outbound forms data for forming structuring
Table, equipment acceptance inventory tables of data, include the following steps:
According to expense item title and number, the corresponding data of each charge clause are extracted, each expense item is obtained
Budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance data；
To each expense item, by budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance data
Data add label respectively, and by budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance Data Data
It is exported in the form of bivariate table respectively, forms budgetary estimate tables of data, settlement data table, the detail account tables of data, outbound list of structuring
Tables of data, equipment acceptance inventory tables of data；
According to the label, gauge outfit is uniformly added for above-mentioned each tables of data.
The beneficial effect of above-mentioned further scheme is: according to the incidence relation with standard clause, automatic identification is simultaneously converted general
Calculate the expense items such as clearing, formed project data after conversion (the budgetary estimate data of each expense item, settlement data, detail account data,
Outbound data and equipment acceptance data).
Further, the building data check rule base verifies the corresponding data of each charge clause of storage, packet
Include following steps:
Data check condition is set according to demand, and the data check rule is stored into data check rule base；
The budgetary estimate tables of data of structuring, settlement data table, detail account tables of data, outbound forms data table, equipment acceptance is clear
Data in volume tables of data are successively verified according to verification condition, to verify unacceptable data issue alarm driving user into
Row modification uploads the corresponding correct data of charge clause.
The beneficial effect of above-mentioned further scheme is: the authenticity of automatic Verification all data, accuracy, integrality, conjunction
Rule property.
Further, the data check condition successively includes:
The amount of money of higher level's expense item is not equal to the amount of money of junior's expense item；
Architectural engineering amount of money when architectural engineering expense aggregate value is not equal to auditing for construction completion account；
Installing engineering amount of money when installing engineering expense aggregate value is not equal to auditing for construction completion account；
Architectural engineering expense summarizes the amount of money not equal to the building part-to-item project amount list counts amount of money；
Installing engineering expense summarizes the amount of money not equal to the installation part-to-item project amount list counts amount of money；
Final production total assets of transferring are equal to clearing authorization value.
The beneficial effect of above-mentioned further scheme is: building data check rule base.Above-mentioned data check condition is invention
Rule of the people by great mass of data investigation and Test Summary, directly application can shorten the development time.
Further, the generation power grid infrastructure project statement, includes the following steps:
According to actually occurring, the corresponding data of each charge clause collect summarizing；
Summarize rear data according to expense item type and classify to collecting, obtains budgetary estimate and summarize class, architectural engineering class, peace
Engineering, equipment purchasing class and other corresponding data of class expense are filled, power grid infrastructure project statement one is generated；
Merge rule according to same expense item to summarize rear data and classify to collecting, obtains with Standard Rate project and be
The budgetary estimate data of benchmark, turn money device data, first for material and device data, other fees data at settlement data, generate power grid
Infrastructure project statement two；
Data in power grid infrastructure project statement one and power grid infrastructure project statement two are further summarized
Analysis obtains data after Macro or mass analysis, generates power grid infrastructure project statement three.
The beneficial effect of above-mentioned further scheme is: being collected, is summarized to all kinds of project data, automatically formed completion and determine
Calculate report.Method is simple, Yi Shixian.
Further, the further Macro or mass analysis, comprising: data in power grid infrastructure project statement two are directed to, according to
Budgetary estimate data, settlement data, first calculate Finished engineering final accounts data for material and device data；According to budgetary estimate data, clearing number
According to, first for material and device data, Finished engineering final accounts internal control target data is calculated；According to settlement data, other fees data,
It calculates capital construction investment to be spread out and shares detailed data；According to settlement data, turn money device data, calculates and transfer asset data；According to
Settlement data extracts and transfers assets-building construction data；According to money device data is turned, extracts transfer assets-installation machinery and set
Standby data；According to settlement data, turn money device data, calculates Finished engineering financial final accounts data；And according to other fees number
According to extraction other fees detailed data；
The power grid infrastructure project statement three, comprising: Finished engineering final accounts list, Finished engineering final accounts internal control mesh
Mark contrast table, capital construction investment to be spread out share detail list, transfer assets summary table, transfer assets-building construction list, transfer money
Production-installation machinery equipment list, Finished engineering financial final accounts table and other fees detail list.
The beneficial effect of above-mentioned further scheme is: by collecting, summarizing, share, automatically generating to form above-mentioned every report
Table detailed data.
Further, further include following steps:
Scientific access is carried out to the data in power grid infrastructure project statement one, two, three, and calculate total tax difference y and
Share the tax difference y of each expense of architectural engineeringi
Y=x1+x4-x2-x5-x3-x6
yi=y (x3i/x3)
In formula, x1Indicate architectural engineering expense volume containing tax in detail account tables of data, x2It indicates to build work in detail account tables of data
Journey takes income tax amount, x3Indicate that the Party B of architectural engineering expense is total, x4Indicate that installing engineering expense contains tax in detail account tables of data
Volume, x5Indicate installing engineering expense income tax amount in detail account tables of data, x6Indicate that the Party B of installing engineering expense is total, x3iIt indicates to divide
The Party B for spreading out each expense of architectural engineering is total；
Expense item in power grid infrastructure project statement one, two, three is shown by name.
The beneficial effect of above-mentioned further scheme is: having the function of science access, so that data result is more intuitive, and can
Automatically calculate total tax difference and share each expense of architectural engineering tax it is poor, automatically generate budget needed for the completion of projects report.
It in the present invention, can also be combined with each other between above-mentioned each technical solution, to realize more preferred assembled schemes.This
Other feature and advantage of invention will illustrate in the following description, also, certain advantages can become from specification it is aobvious and
It is clear to, or understand through the implementation of the invention.The objectives and other advantages of the invention can by specification, claims with
And it is achieved and obtained in specifically noted content in attached drawing.
Detailed description of the invention
Attached drawing is only used for showing the purpose of specific embodiment, and is not to be construed as limiting the invention, in entire attached drawing
In, identical reference symbol indicates identical component.
Fig. 1 is the step schematic diagram of 1 power grid infrastructure project method for processing report data of the embodiment of the present invention；
Fig. 2 is the calculating that the embodiment of the present invention 2 obtains charges clause and each charge clause that this infrastructure project is related to
The step schematic diagram of method；
Fig. 3 is 2 pairs of the embodiment of the present invention step schematic diagrames for obtaining the corresponding data of each charge clause；
Whether Fig. 4 is reasonable for the building of the embodiment of the present invention 2 data check rule base, the corresponding data of each charge clause of verification
Step schematic diagram；
Fig. 5 is the step schematic diagram that the embodiment of the present invention 2 generates power grid infrastructure project statement.
Specific embodiment
Specifically describing the preferred embodiment of the present invention with reference to the accompanying drawing, wherein attached drawing constitutes the application a part, and
Together with embodiments of the present invention for illustrating the principle of the present invention, it is not intended to limit the scope of the present invention.
Embodiment 1
A specific embodiment of the invention, discloses a kind of power grid infrastructure project method for processing report data, such as Fig. 1 institute
Show, includes the following steps:
S1. according to power grid infrastructure project expense item standard, the charge clause that this infrastructure project is related to is obtained, and each
The calculation method of charge clause.
S2. using charge clause as keyword, search obtains this infrastructure project and includes the file set of above-mentioned expense, and obtains
It the corresponding data of each charge clause of All Files and is stored in file set.Preferably, the data include budgetary estimate data, detail number
According to and settlement data.
S3. data check rule base is constructed, the corresponding data of each charge clause of storage are verified, if verification is not
Pass through, then issues alarm driving amendment for unacceptable charge clause, pass through until all charge clauses verify.
S4. the corresponding data of each charge clause by verifying are calculated according to the calculation method, according to prefabricated
Report template, format rendering is carried out to calculated result, power grid infrastructure project statement is generated, and saves, after display saves
Statement and storing path.
Compared with prior art, power grid infrastructure project method for processing report data provided in this embodiment being capable of automatic identification
And the corresponding relationship of budgetary estimate settlement data and standards system is constructed, realize that electricity power engineering builds pre- regulator system and bill of quantities mark
Quasi- automatic integration, and budgetary estimate data, settlement data, detail account data, turn money data etc. are carried out according to Standard Rate system
It parses, convert, verify, collect, share, intelligence efficiently and accurately helps user to provide budget needed for the completion of projects report, is ensuring final accounts
During report is provided while lean management, manual intervention is reduced.
Embodiment 2
It optimizes on the basis of embodiment 1, as shown in Fig. 2, step S1 can be further refined as following steps:
S11. it extracts in the pre- rule of electricity power engineering construction and bill of quantities normative document and is related to the keyword of expense, obtain
Higher level's expense item is calculated according to junior's expense item in each charge clause of all charges clauses that this infrastructure project is related to
Calculation formula；
S12. classified automatically to all charge clauses that this infrastructure project is related to according to default class condition, obtained
Budgetary estimate summarizes class, architectural engineering class, installing engineering class, equipment purchasing class and other class charge clauses；
S13. participle matching is carried out to above-mentioned every a kind of charge clause, deletes duplicate charge clause, and to remaining clause
Applicability verification is carried out, not applicable charge clause is deleted.
Preferably, budgetary estimate summarizes class, including establishment base period price differential, basic reserve fund, special item expense, dynamic are taken
With, price differential reserve fund etc..
Preferably, architectural engineering class, including mainly produce building, Master Communications building, relay bungalow, fixed series compensation dress
Set control room, high voltage controllable reactors thyristor valve chamber, controllable series compensator control room, static passive compensation device crystalline substance lock
Tubular valve chamber, power distribution equipment building, main transformer system, fire water pump house, the valve chamber that drenches with rain, framework and Equipment Foundations, high pressure reactance
Device system, series compensation system, water system building, fire-fighting system, auxiliary production building, complex building, area's property of standing build, are special
Structures, stand area greening etc. cost.
Preferably, installing engineering class, including main transformer system, power distribution equipment, reactive compensation, control and direct current system,
Station power use system, cable and ground connection, communication and telecontrol system, whole station debugging, maintenance and repair equipment, testing equipment, dispatch from foreign news agency of standing
Source, outer communication etc. of standing cost.
Preferably, equipment purchasing class, including power distribution equipment, power distribution equipment, high voltage reactor, series compensation dress outside room within doors
It sets, secondary capacitor, low tension reactor, static passive compensation device, relay protection, on-line monitoring system, whole station cable, whole station
The cost of ground connection etc..
Preferably, other class charge clauses, including the requisition of construction place and cleaning expense, project construction management expense, project are built
If technical service fee, Operational preparation take.
Through the above scheme, to seek unity of standard, standardized administration, compacting completion of works final account management basis.
Preferably, step S13 can be further refined as following steps:
S131. based on general computer participle matching algorithm and power grid infrastructure project terminology bank, the semantic similar art of setting
Language is keyword, carries out participle matching to above-mentioned every a kind of charge clause, deletes semantic duplicate charge clause；
S132. using this non-power grid infrastructure project term as keyword, applicability is carried out to remaining clause by exclusive method
It verifies, deletes the charge clause of significant discomfort.
Preferably, as shown in figure 3, step S2 can be further refined as following steps:
S21. using charge clause as keyword, search obtains the All Files collection that this infrastructure project includes above-mentioned expense,
Message file is authorized including budgetary estimate tables of data, settlement data table, outbound list, equipment acceptance inventory, Item Detail account, project.One
As in the case of, above-mentioned file be EXCEL format.
S22. successively retrieving above-mentioned file set includes establishment base period price differential, basic reserve fund, special item expense, dynamic
The sentence of expense, price differential reserve fund obtains budgetary estimate and summarizes the corresponding data of class charge clause.
S23. above-mentioned file set is successively retrieved to include main production building, Master Communications building, relay bungalow, fix to connect and mend
Repay device control room, high voltage controllable reactors thyristor valve chamber, controllable series compensator control room, static passive compensation device
Thyristor valve chamber, power distribution equipment building, main transformer system, fire water pump house, the valve chamber that drenches with rain, framework and Equipment Foundations, high pressure
Reactor system, series compensation system, water system building, fire-fighting system, auxiliary production building, complex building, area's property of standing build,
Exceptional structure, area's greening of standing cost sentence, obtain the corresponding data of installing engineering class charge clause.
S24. successively retrieving above-mentioned file set includes main transformer system, power distribution equipment, reactive compensation, control and direct current system
System, station power use system, cable and ground connection, communication and telecontrol system, whole station debugging, maintenance and repair equipment, testing equipment are stood outside
Power supply, the outer cost communicated of standing sentence, obtain the corresponding data of installing engineering class charge clause.
S25. above-mentioned file set is successively retrieved to mend comprising power distribution equipment, high voltage reactor, series connection outside power distribution equipment within doors, room
Repay device, secondary capacitor, low tension reactor, static passive compensation device, relay protection, on-line monitoring system, whole station cable,
The sentence of the cost of whole station ground connection obtains the corresponding data of equipment purchasing class charge clause.
S26. matching process is segmented by general purpose computer to the corresponding data of above-mentioned each charge clause to match, delete
Inconsistent data, and remaining data is manually verified, the data of irregularity are deleted, the budgetary estimate data of structuring are formed
Table, settlement data table, detail account tables of data, outbound forms data table, equipment acceptance inventory tables of data.Structuring represents each data
With location information, can be realized by programming, skilled artisans appreciate that.
Budgetary estimate tables of data, including budgetary estimate table, building part summary sheet, installation section summary sheet, other fees table at long last.Knot
Calculate tables of data, including clearing summary sheet, architectural engineering accounts summary, building part-to-item project amount list counts table, installation
Engineering cost summary sheet, installation part-to-item project amount list counts table.Outbound list, i.e. the outbound list letter of this infrastructure project
Breath.Equipment acceptance inventory, i.e. the equipment acceptance inventory information of this infrastructure project.Item Detail account, i.e. this infrastructure project
Detail account information.Project authorizes message file, i.e. the project of this infrastructure project authorizes information.
Preferably, in step S26, budgetary estimate tables of data, settlement data table, the detail account tables of data, outbound of structuring are formed
Forms data table, equipment acceptance inventory tables of data, include the following steps:
S261. according to expense item title and number, the corresponding data of each charge clause is extracted, each expense is obtained
Budgetary estimate data, settlement data, detail account data, outbound data and the equipment acceptance data of project.
S262. to each expense item, by budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance
Data Data adds label respectively, and by budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance data
Data are exported in the form of bivariate table respectively, are formed the budgetary estimate tables of data of structuring, settlement data table, detail account tables of data, are gone out
Library forms data table, equipment acceptance inventory tables of data.
S263. according to the label, gauge outfit is uniformly added for above-mentioned each tables of data.
Preferably, as shown in figure 4, step S3 can be further refined as following steps:
S31., data check condition is set according to demand, and the data check rule is stored to data check rule base
In.
S32. the budgetary estimate tables of data of structuring, settlement data table, detail account tables of data, outbound forms data table, equipment are tested
The data received in inventory tables of data are successively verified according to verification condition, are used unacceptable data sending alarm driving is verified
Family is modified, and the corresponding correct data of charge clause is uploaded.Correct untrue, inaccurate, imperfect, irregularity knot
Fruit.
Preferably, data check condition successively includes:
1) amount of money of higher level's expense item is not equal to the amount of money of junior's expense item；
2) architectural engineering amount of money when architectural engineering expense aggregate value is not equal to auditing for construction completion account；
3) installing engineering amount of money when installing engineering expense aggregate value is not equal to auditing for construction completion account；
4) the architectural engineering accounts summary amount of money is not equal to the building part-to-item project amount list counts table amount of money；
5) the installing engineering expense summary sheet amount of money is not equal to the installation part-to-item project amount list counts table amount of money；
6) final production total assets of transferring are equal to clearing authorization value.
Preferably, as shown in figure 5, in step S4, generation power grid infrastructure project statement can be further refined as follows
Step:
S41. according to actually occurring, the corresponding data of each charge clause collect summarizing.
S42. summarize rear data according to expense item type and classify to collecting, obtain budgetary estimate and summarize class, architectural engineering
Class, installing engineering class, equipment purchasing class and other corresponding data of class expense generate power grid infrastructure project statement
One.Specifically, power grid infrastructure project statement model one is established, is divided using database SQL function, such as GROUP BY
Group, SUM are counted, and DIVIDE carries out Computation for apportionment, are quickly obtained using batch processing mode as a result, generating power grid infrastructure project
Statement one.It is subsequent directly to inquire data in power grid infrastructure project statement one, without calculating again.This implementation,
High 10 times of JAVA program computational efficiency or more is used than tradition.
S43. merge rule according to same expense item to summarize rear data and classify to collecting, obtain with Standard Rate item
Budgetary estimate data, settlement data, turn money device data, first on the basis of mesh are generated for material and device data, other fees data
Power grid infrastructure project statement two.Specifically, power grid infrastructure project statement model two is established, using above-mentioned batch processing side
Formula generates power grid infrastructure project statement two.
S44. data in power grid infrastructure project statement one and power grid infrastructure project statement two are carried out further
Macro or mass analysis obtains data after Macro or mass analysis, power grid infrastructure project statement model three is established, using above-mentioned batch processing mode
Generate power grid infrastructure project statement three.
Preferably, in step S44, the further Macro or mass analysis can be further refined as following steps:
S441. for data in power grid infrastructure project statement two, according to budgetary estimate data, settlement data, first for material
And device data, calculate Finished engineering final accounts data；
S442. Finished engineering final accounts internal control mesh is calculated for material and device data according to budgetary estimate data, settlement data, first
Mark data；
S443. it according to settlement data, other fees data, calculates capital construction investment to be spread out and shares detailed data；
S444. it according to settlement data, turn money device data, calculates and transfers asset data；
S445. it according to settlement data, extracts and transfers assets-building construction data；
S446. it according to money device data is turned, extracts and transfers assets-installation machinery device data；
S447. according to settlement data, turn money device data, Finished engineering financial final accounts data are calculated；And
S448. according to other fees data, other fees detailed data is extracted.
Specific formula for calculation those skilled in the art can pass through the pre- rule of inquiry electricity power engineering construction and bill of quantities standard
File obtains.
Preferably, power grid infrastructure project statement three includes Finished engineering final accounts list, Finished engineering final accounts internal control
Targeted contrast table, capital construction investment to be spread out share detail list, transfer assets summary table, transfer assets-building construction list, transfer
Assets-installation machinery equipment list, Finished engineering financial final accounts table and other fees detail list.
Preferably, power grid infrastructure project method for processing report data further includes following steps:
S5. scientific access is carried out to the data in power grid infrastructure project statement one, two, three, and calculate total tax difference y with
And share the tax difference y of each expense of architectural engineeringi
Y=x1+x4-x2-x5-x3-x6
yi=y (x3i/x3)
In formula, x1Indicate architectural engineering expense volume containing tax in detail account tables of data, x2It indicates to build work in detail account tables of data
Journey takes income tax amount, x3Indicate that the Party B of architectural engineering expense is total, x4Indicate that installing engineering expense contains tax in detail account tables of data
Volume, x5Indicate installing engineering expense income tax amount in detail account tables of data, x6Indicate that the Party B of installing engineering expense is total, x3iIt indicates to divide
The Party B for spreading out each expense of architectural engineering is total.
S6. the expense item in power grid infrastructure project statement one, two, three is shown by name.
Tax difference involved in above-mentioned steps S5 calculates and methodology can be further refined as following steps:
S51. architectural engineering expense volume containing tax+installing engineering expense volume containing tax in value 1=detail account tables of data；Wherein, it builds
Building engineering cost volume containing tax is that the monomer engineering subject is " engineering cost-architectural engineering expenditure " and material in detail account tables of data
It is encoded to empty quantity column aggregate value, installing engineering expense volume containing tax is that the monomer engineering subject is " work in detail account tables of data
Cheng Chengben-installing engineering expenditure " or " engineering cost-is in installation equipment " and COM code is empty quantity column aggregate value.
S52. architectural engineering expense income tax amount+installing engineering expense income tax amount in value 2=detail account tables of data.Wherein, it builds
Building engineering cost income tax amount is that subject is " engineering cost-architectural engineering expenditure " and object in the monomer engineering in detail account tables of data
Material is encoded to empty income tax amount column aggregate value, and installing engineering expense income tax amount is the monomer engineering subject in detail account tables of data
For " engineering cost-installing engineering expenditure " or " engineering cost-is in installation equipment " and COM code is that empty income tax amount column close
Evaluation.
S53. value 3=value 1- value 2, i.e., architectural engineering expense and installing engineering expense is free of tax volume in detail account tables of data.
S54. the Party B of value 4=architectural engineering expense it is total+Party B of installing engineering expense adds up to.
S55. tax difference 5=value 3- value 4.
S56. share each charge clause of architectural engineering tax difference=value 5* (Party B of charge clause is total/architectural engineering
Party B it is total).
S57. share each charge clause of installing engineering tax difference=value 5* (Party B of charge clause is total/installing engineering
Party B it is total).
Compared with Example 1, power grid infrastructure project method for processing report data provided in this embodiment is determined providing completion
It calculates and is more automated on report, is scientific, more efficiently improve statement working efficiency and lean management level.
It will be understood by those skilled in the art that realizing all or part of the process of above-described embodiment method, meter can be passed through
Calculation machine program is completed to instruct relevant hardware, and the program can be stored in computer readable storage medium.Wherein, institute
Stating computer readable storage medium is disk, CD, read-only memory or random access memory etc..
The foregoing is only a preferred embodiment of the present invention, but scope of protection of the present invention is not limited thereto,
In the technical scope disclosed by the present invention, any changes or substitutions that can be easily thought of by anyone skilled in the art,
It should be covered by the protection scope of the present invention.
Claims (10)
1. a kind of power grid infrastructure project method for processing report data, which comprises the steps of:
According to power grid infrastructure project expense item standard, the charge clause and each expense item that this infrastructure project is related to are obtained
The calculation method of money；
Using charge clause as keyword, search obtains this infrastructure project and includes the file set of above-mentioned expense, and obtains file set
The corresponding data of middle each charge clause of All Files simultaneously store；
Data check rule base is constructed, the corresponding data of each charge clause of storage are verified, if verification does not pass through,
Alarm driving amendment is issued for unacceptable charge clause, is passed through until all charge clauses verify；
The corresponding data of each charge clause by verifying are calculated according to the calculation method, according to prefabricated report mould
Plate carries out format rendering to calculated result, generates power grid infrastructure project statement, and save, the final accounts report after display preservation
Table and storing path.
2. power grid infrastructure project method for processing report data according to claim 1, which is characterized in that described according to power grid
Infrastructure project expense item standard obtains the calculation method of charge clause and each charge clause that this infrastructure project is related to,
Include the following steps:
It extracts in the pre- rule of electricity power engineering construction and bill of quantities normative document and is related to the keyword of expense, obtain this capital construction
The calculating for calculating higher level's expense item according to junior's expense item in each charge clause of all charges clauses that engineering is related to is public
Formula；
Classified automatically to all charge clauses that this infrastructure project is related to according to default class condition, obtains budgetary estimate and summarize
Class, architectural engineering class, installing engineering class, equipment purchasing class and other class charge clauses；
Participle matching is carried out to above-mentioned every a kind of charge clause, deletes duplicate charge clause, and carry out to remaining clause applicable
Property verify, delete not applicable charge clause.
3. power grid infrastructure project statement automatic generation method power grid infrastructure project report data according to claim 2
Processing method, which is characterized in that described that participle matching is carried out to above-mentioned every a kind of charge clause, deletes duplicate charges clause
And applicability verification is carried out to remaining clause, deletes not applicable charge clause, include the following steps:
Based on general computer participle matching algorithm and power grid infrastructure project terminology bank, it is key that semantic term similar, which is arranged,
Word carries out participle matching to above-mentioned every a kind of charge clause, deletes semantic duplicate charge clause；
Using this non-power grid infrastructure project term as keyword, applicability verification is carried out to remaining clause by exclusive method, is deleted
The charge clause of significant discomfort.
4. power grid infrastructure project method for processing report data described in one of -3 according to claim 1, which is characterized in that it is described with
Charge clause is keyword, and search obtains this infrastructure project and includes the file set of above-mentioned expense, and obtains in file set and own
The corresponding data of each charge clause of file simultaneously store, and include the following steps:
Using charge clause as keyword, search obtains the All Files collection that this infrastructure project includes above-mentioned expense, including budgetary estimate
Tables of data, settlement data table, outbound list, equipment acceptance inventory, Item Detail account, project authorize message file；
Successively retrieving above-mentioned file set includes establishment base period price differential, basic reserve fund, special item expense, activity charge, valence
The sentence of poor reserve fund obtains budgetary estimate and summarizes the corresponding data of class charge clause；
Successively retrieving above-mentioned file set includes main production building, Master Communications building, relay bungalow, fixed series compensation device control
Room processed, high voltage controllable reactors thyristor valve chamber, controllable series compensator control room, static passive compensation device thyristor valve
Room, power distribution equipment building, main transformer system, fire water pump house, the valve chamber that drenches with rain, framework and Equipment Foundations, high voltage reactor system
System, series compensation system, water system building, fire-fighting system, auxiliary production building, complex building, area's property of standing are built, special are constructed
Object, area's greening of standing cost sentence, obtain the corresponding data of installing engineering class charge clause；
Successively retrieving above-mentioned file set includes main transformer system, power distribution equipment, reactive compensation, control and direct current system, use of standing
Electric system, cable and ground connection, communication and telecontrol system, whole station debugging, maintenance and repair equipment, external power of standing, are stood at testing equipment
The sentence of the cost of outer communication obtains the corresponding data of installing engineering class charge clause；
Successively retrieve above-mentioned file set include within doors power distribution equipment, power distribution equipment outside room, high voltage reactor, series compensation device,
Secondary capacitor, low tension reactor, static passive compensation device, relay protection, on-line monitoring system, whole station cable, whole station connect
The sentence of the cost on ground obtains the corresponding data of equipment purchasing class charge clause；
Matching process is segmented by general purpose computer to the corresponding data of above-mentioned each charge clause to match, and is deleted inconsistent
Data, and remaining data is manually verified, the data of irregularity are deleted, budgetary estimate tables of data, the clearing number of structuring are formed
According to table, detail account tables of data, outbound forms data table, equipment acceptance inventory tables of data.
5. power grid infrastructure project method for processing report data according to claim 4, which is characterized in that the formation structure
Budgetary estimate tables of data, settlement data table, detail account tables of data, outbound forms data table, the equipment acceptance inventory tables of data of change, including such as
Lower step:
According to expense item title and number, the corresponding data of each charge clause are extracted, the general of each expense item is obtained
Count evidence, settlement data, detail account data, outbound data and equipment acceptance data；
To each expense item, by budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance Data Data
Label is added respectively, and budgetary estimate data, settlement data, detail account data, outbound data and equipment acceptance Data Data are distinguished
It is exported in the form of bivariate table, forms budgetary estimate tables of data, settlement data table, the detail account tables of data, outbound forms data of structuring
Table, equipment acceptance inventory tables of data；
According to the label, gauge outfit is uniformly added for above-mentioned each tables of data.
6. power grid infrastructure project method for processing report data according to claim 5, which is characterized in that the building data
Rule base is verified, the corresponding data of each charge clause of storage are verified, are included the following steps:
Data check condition is set according to demand, and the data check rule is stored into data check rule base；
By the budgetary estimate tables of data of structuring, settlement data table, detail account tables of data, outbound forms data table, equipment acceptance inventory number
It is successively verified according to the data in table according to verification condition, is repaired to unacceptable data sending alarm driving user is verified
Change, uploads the corresponding correct data of charge clause.
7. power grid infrastructure project method for processing report data according to claim 6, which is characterized in that the data check
Condition successively includes:
The amount of money of higher level's expense item is not equal to the amount of money of junior's expense item；
Architectural engineering amount of money when architectural engineering expense aggregate value is not equal to auditing for construction completion account；
Installing engineering amount of money when installing engineering expense aggregate value is not equal to auditing for construction completion account；
Architectural engineering expense summarizes the amount of money not equal to the building part-to-item project amount list counts amount of money；
Installing engineering expense summarizes the amount of money not equal to the installation part-to-item project amount list counts amount of money；
Final production total assets of transferring are equal to clearing authorization value.
8. the power grid infrastructure project method for processing report data according to one of claim 5-7, which is characterized in that the life
At power grid infrastructure project statement, include the following steps:
According to actually occurring, the corresponding data of each charge clause collect summarizing；
Summarize rear data according to expense item type and classify to collecting, obtains budgetary estimate and summarize class, architectural engineering class, erector
Journey class, equipment purchasing class and other corresponding data of class expense generate power grid infrastructure project statement one；
Merge rule according to same expense item to summarize rear data and classify to collecting, obtain on the basis of Standard Rate project
Budgetary estimate data, settlement data, turn money device data, first for material and device data, other fees data, generate power grid capital construction
Final account of project report two；
Further Macro or mass analysis is carried out to data in power grid infrastructure project statement one and power grid infrastructure project statement two,
Data after acquisition Macro or mass analysis, generate power grid infrastructure project statement three.
9. power grid infrastructure project method for processing report data according to claim 8, which is characterized in that the further remittance
Bulk analysis, comprising: for data in power grid infrastructure project statement two, according to budgetary estimate data, settlement data, first for material and
Device data calculates Finished engineering final accounts data；According to budgetary estimate data, settlement data, first for material and device data, calculating is completed
Work final account of project internal control target data；According to settlement data, other fees data, calculates capital construction investment to be spread out and share detail number
According to；According to settlement data, turn money device data, calculates and transfer asset data；According to settlement data, extracts and transfer assets-house
Building data；According to money device data is turned, extracts and transfer assets-installation machinery device data；It is set according to settlement data, turn money
Standby data, calculate Finished engineering financial final accounts data；And according to other fees data, extract other fees detailed data:
The power grid infrastructure project statement three, comprising: Finished engineering final accounts list, Finished engineering final accounts internal control target pair
Share detail list than table, capital construction investment to be spread out, transfer assets summary table, transfer assets-building construction list, transfer assets-
Mechanical equipment list, Finished engineering financial final accounts table and other fees detail list are installed.
10. power grid infrastructure project method for processing report data according to claim 8, which is characterized in that further include as follows
Step:
Scientific access is carried out to the data in power grid infrastructure project statement one, two, three, and calculates total tax difference y and shares
To the tax difference y of each expense of architectural engineeringi
Y=x1+x4-x2-x5-x3-x6
yi=y (x3i/x3)
In formula, x1Indicate architectural engineering expense volume containing tax in detail account tables of data, x2Indicate architectural engineering expense in detail account tables of data
Income tax amount, x3Indicate that the Party B of architectural engineering expense is total, x4Indicate installing engineering expense volume containing tax in detail account tables of data, x5
Indicate installing engineering expense income tax amount in detail account tables of data, x6Indicate that the Party B of installing engineering expense is total, x3iExpression is shared
The Party B of each expense of architectural engineering is total；
Expense item in power grid infrastructure project statement one, two, three is shown by name.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811624605.2A CN109784689B (en) | 2018-12-28 | 2018-12-28 | Power grid infrastructure project report data processing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811624605.2A CN109784689B (en) | 2018-12-28 | 2018-12-28 | Power grid infrastructure project report data processing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109784689A true CN109784689A (en) | 2019-05-21 |
| CN109784689B CN109784689B (en) | 2022-03-15 |
Family
ID=66498550
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811624605.2A Active CN109784689B (en) | 2018-12-28 | 2018-12-28 | Power grid infrastructure project report data processing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109784689B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110826845A (en) * | 2019-09-16 | 2020-02-21 | 远光软件股份有限公司 | Multidimensional combination cost allocation device and method |
| CN111275409A (en) * | 2020-02-28 | 2020-06-12 | 国网上海市电力公司 | Power grid overhaul audit data processing system and processing method |
| CN111598717A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | System and method for rapidly calculating rough calculation project construction miscellaneous fee |
| CN111813829A (en) * | 2020-06-30 | 2020-10-23 | 平安国际智慧城市科技股份有限公司 | Data resolution method, device, electronic equipment and storage medium |
| CN112330097A (en) * | 2020-10-15 | 2021-02-05 | 远光软件股份有限公司 | Project completion settlement method and device and electronic equipment |
| CN113836201A (en) * | 2021-09-23 | 2021-12-24 | 国网冀北电力有限公司经济技术研究院 | Method and device for splitting settlement data of power grid production technical improvement project under data driving |
| CN117172714A (en) * | 2023-09-20 | 2023-12-05 | 公诚管理咨询有限公司 | Safety production fee checking method and system applied to communication engineering and electronic equipment |
Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
| CN106920068A (en) * | 2017-01-19 | 2017-07-04 | 国家电网公司 | Electricity power engineering pricing management of the one kind based on big data and " internet+" |
| CN107491907A (en) * | 2017-10-19 | 2017-12-19 | 国家电网公司 | Cost for Electric Power Engineering control and analysis and system |
| CN107578150A (en) * | 2017-08-18 | 2018-01-12 | 国网浙江省电力公司湖州供电公司 | The automatic budget needed for the completion of projects method of power system engineering |
| CN107689016A (en) * | 2017-11-24 | 2018-02-13 | 中科院合肥技术创新工程院 | A kind of electricity power engineering cost historical data fusion method using data analysis technique |
| CN107833022A (en) * | 2017-11-24 | 2018-03-23 | 国网内蒙古东部电力有限公司 | Power network technology innovation project final account for completed project management method based on bill of quantities |
| CN107861943A (en) * | 2017-10-20 | 2018-03-30 | 中国地质大学（武汉） | A kind of method of the rapid extraction useful data from document sets |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN107871212A (en) * | 2017-11-24 | 2018-04-03 | 国网内蒙古东部电力有限公司 | A kind of Analysis of Engineering Construction Cost method based on bill of quantities data and data model analysis technology |
| CN107958043A (en) * | 2017-11-24 | 2018-04-24 | 中科院合肥技术创新工程院 | A kind of electricity power engineering budget inventory automatic generation method |
| CN108154314A (en) * | 2018-01-19 | 2018-06-12 | 国家电网公司 | Engineering project budget needed for the completion of projects method and terminal device |
| CN108364193A (en) * | 2018-01-25 | 2018-08-03 | 广州建衡工程咨询有限公司 | A kind of construction project cost auditing method and system |
| CN108595399A (en) * | 2018-04-16 | 2018-09-28 | 北京航空航天大学 | The artificial intelligence generation method of digital aircraft simulation study scientific and technical research budget table |
| CN108694512A (en) * | 2018-05-30 | 2018-10-23 | 国网山东省电力公司经济技术研究院 | A kind of power grid analysis of prices data in-depth processing system and method |
-
2018
- 2018-12-28 CN CN201811624605.2A patent/CN109784689B/en active Active
Patent Citations (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103744831A (en) * | 2013-12-16 | 2014-04-23 | 远光软件股份有限公司 | Compilation method and device for multi-dimensional report |
| CN104077665A (en) * | 2014-07-10 | 2014-10-01 | 国家电网公司 | Power grid project manufacturing cost analysis data collecting system and method |
| CN106920068A (en) * | 2017-01-19 | 2017-07-04 | 国家电网公司 | Electricity power engineering pricing management of the one kind based on big data and " internet+" |
| CN107578150A (en) * | 2017-08-18 | 2018-01-12 | 国网浙江省电力公司湖州供电公司 | The automatic budget needed for the completion of projects method of power system engineering |
| CN107491907A (en) * | 2017-10-19 | 2017-12-19 | 国家电网公司 | Cost for Electric Power Engineering control and analysis and system |
| CN107861943A (en) * | 2017-10-20 | 2018-03-30 | 中国地质大学（武汉） | A kind of method of the rapid extraction useful data from document sets |
| CN107871004A (en) * | 2017-11-14 | 2018-04-03 | 国家电网公司 | A kind of power distribution network analysis of prices management system |
| CN107833022A (en) * | 2017-11-24 | 2018-03-23 | 国网内蒙古东部电力有限公司 | Power network technology innovation project final account for completed project management method based on bill of quantities |
| CN107689016A (en) * | 2017-11-24 | 2018-02-13 | 中科院合肥技术创新工程院 | A kind of electricity power engineering cost historical data fusion method using data analysis technique |
| CN107871212A (en) * | 2017-11-24 | 2018-04-03 | 国网内蒙古东部电力有限公司 | A kind of Analysis of Engineering Construction Cost method based on bill of quantities data and data model analysis technology |
| CN107958043A (en) * | 2017-11-24 | 2018-04-24 | 中科院合肥技术创新工程院 | A kind of electricity power engineering budget inventory automatic generation method |
| CN108154314A (en) * | 2018-01-19 | 2018-06-12 | 国家电网公司 | Engineering project budget needed for the completion of projects method and terminal device |
| CN108364193A (en) * | 2018-01-25 | 2018-08-03 | 广州建衡工程咨询有限公司 | A kind of construction project cost auditing method and system |
| CN108595399A (en) * | 2018-04-16 | 2018-09-28 | 北京航空航天大学 | The artificial intelligence generation method of digital aircraft simulation study scientific and technical research budget table |
| CN108694512A (en) * | 2018-05-30 | 2018-10-23 | 国网山东省电力公司经济技术研究院 | A kind of power grid analysis of prices data in-depth processing system and method |
Non-Patent Citations (6)
| Title |
|---|
| 于瑞华: "XBRL财务报告分析及元素定位提取探讨", 《黑龙江八一农垦大学学报》 * |
| 刘东炜: "电力行业基建信息化管理系统设计与实现", 《中国优秀博硕士学位论文全文数据库(硕士)信息科技辑》 * |
| 刘磊: "信息化视角下水电站基建工程财务竣工决算系统的构建――基于Oracle EBS财务系统与Oracle BI系统", 《中国管理信息化》 * |
| 李丹阳: "电力行业ERP基建财务管控系统的设计与实施", 《中国优秀博硕士学位论文全文数据库(硕士)》 * |
| 柴忠信: "《电力基本建设项目竣工决算报告编制方法》", 30 September 2007, 中国电力出版社 * |
| 江高潮: "MIS系统在电力基建工程项目中的应用", 《中国电力教育》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110826845A (en) * | 2019-09-16 | 2020-02-21 | 远光软件股份有限公司 | Multidimensional combination cost allocation device and method |
| CN111275409A (en) * | 2020-02-28 | 2020-06-12 | 国网上海市电力公司 | Power grid overhaul audit data processing system and processing method |
| CN111598717A (en) * | 2020-03-27 | 2020-08-28 | 广联达科技股份有限公司 | System and method for rapidly calculating rough calculation project construction miscellaneous fee |
| CN111813829A (en) * | 2020-06-30 | 2020-10-23 | 平安国际智慧城市科技股份有限公司 | Data resolution method, device, electronic equipment and storage medium |
| CN112330097A (en) * | 2020-10-15 | 2021-02-05 | 远光软件股份有限公司 | Project completion settlement method and device and electronic equipment |
| CN113836201A (en) * | 2021-09-23 | 2021-12-24 | 国网冀北电力有限公司经济技术研究院 | Method and device for splitting settlement data of power grid production technical improvement project under data driving |
| CN117172714A (en) * | 2023-09-20 | 2023-12-05 | 公诚管理咨询有限公司 | Safety production fee checking method and system applied to communication engineering and electronic equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109784689B (en) | 2022-03-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109784689A (en) | A kind of power grid infrastructure project method for processing report data | |
| CN102637203B (en) | Method for processing electric quantity data and monitoring master station for automatic electric energy metering systems | |
| CN105573997A (en) | Method and device for determining electric larceny suspect user | |
| CN111415094A (en) | Engineering cost progress management control system and method based on big data | |
| CN104933631A (en) | Power distribution network operation online analysis and evaluation system | |
| KR101791902B1 (en) | The apparatus and method of distributed energy resource for vitalizing transactive energy | |
| CN104834984A (en) | Electric power transaction supervision risk early warning system based on unified and interconnected electric power market | |
| US20150227992A1 (en) | Building Optimization Platform And Web-Based Invoicing System | |
| Mahmoudi et al. | Transmission and energy storage–expansion planning in the presence of correlated wind farms | |
| CN109064126A (en) | Hydroelectric project metrical information management method based on quality driving | |
| CN102054234B (en) | Method for checking reserve capacity of power system based on random optimal power flow | |
| CN117252490A (en) | Carbon emission accounting method, system and device based on special transformer acquisition terminal | |
| CN106786533A (en) | The acquisition methods and device of electric dispatching plan data | |
| Liu et al. | Operation safety risk assessment of water distribution networks based on the combined weighting method (CWM) | |
| Tian | Grid-connected energy storage systems: benefits, planning and operation | |
| CN111091455B (en) | Integrated tax source management system for house, land and tax collection | |
| Li et al. | Performance Monitoring of African Micro-Grids: Good Practices and Operational Data | |
| Han et al. | Optimal operations of energy storage systems in multi‐application scenarios of grid ancillary services based on electricity price forecasting | |
| CN115860429B (en) | Pipe network construction management method and system based on label two-dimension code | |
| Zhang et al. | Power Supply Enterprise Electricity Charge Centralized Accounting System Based on MVC Architecture | |
| CN117117924B (en) | Energy storage capacity configuration method, device and equipment considering clear market income | |
| CN116739396A (en) | Intelligent evaluation service platform for new energy projects | |
| Rajeev et al. | Pre-implementation assessment for introducing direct load control strategies in the residential electricity sector | |
| Blazevic et al. | Wind Farm Energy Production in Bosnia and Herzegovina: Levelized Cost of Energy. | |
| Hofer et al. | Damage Scenario and Economic Losses Estimation of Historical Earthquakes Occurred in Northeastern Italy |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |