CN117893150B - A method and system for compiling power grid project cost, electronic equipment and storage medium - Google Patents
A method and system for compiling power grid project cost, electronic equipment and storage mediumInfo
- Publication number
- CN117893150B CN117893150B CN202311740737.2A CN202311740737A CN117893150B CN 117893150 B CN117893150 B CN 117893150B CN 202311740737 A CN202311740737 A CN 202311740737A CN 117893150 B CN117893150 B CN 117893150B
- Authority
- CN
- China
- Prior art keywords
- data
- project
- engineering quantity
- information
- cost
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
-
- 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
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Strategic Management (AREA)
- Human Resources & Organizations (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Health & Medical Sciences (AREA)
- Entrepreneurship & Innovation (AREA)
- General Business, Economics & Management (AREA)
- Water Supply & Treatment (AREA)
- Computational Linguistics (AREA)
- Primary Health Care (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Artificial Intelligence (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Public Health (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a method, a system, a device and a storage medium for compiling power grid project cost, wherein the method comprises the steps of determining a cost data assembly base according to power grid project information, determining project assembly summary table templates according to the cost data assembly base and first preset information, carrying out matching classification on first engineering quantity investment lifting table data according to the project assembly summary table templates, generating project data input table data, checking the generated data, and analyzing the project data input table data based on the checked project data input table data to obtain a project cost result. Determining a summary table template through the power grid project information and the first preset information, carrying out matching classification on the data according to the summary table template to generate project data input table data, and carrying out inspection, analysis and calculation on the data to obtain a manufacturing cost result; the embodiment of the application can reduce the workload of manual data programming, improve the programming efficiency and improve the accuracy of data programming. The application can be widely applied to the technical field of engineering cost.
Description
Technical Field
The present invention relates to the field of engineering costs, and in particular, to a method and system for compiling a power grid project cost, an electronic device, and a storage medium.
Background
The business scope of the power grid company covers various places such as cities, industrial areas and villages, so that the volume of a power distribution network of the power grid company is huge, when the power distribution network is overhauled in a standing way and the construction cost is compiled, the volume of data processed by a processor during the construction cost is huge due to the large volume of the power distribution network, the volume of the data processed by the processor is also huge, the conventional scheme mainly relies on the processor to compile and collect the data manually, the working strength is high, a great amount of time and energy are occupied by the processor, the construction cost is low in accuracy and the data compiling efficiency is low.
Disclosure of Invention
The embodiment of the application mainly aims to provide a power grid project cost compiling method and system, electronic equipment and a storage medium, so as to realize efficient and accurate cost compiling.
In order to achieve the above object, an aspect of an embodiment of the present application provides a method for compiling a power grid project, the method including:
Acquiring power grid project information, and determining a power grid project cost data assembly library according to the power grid project information, wherein the power grid project information comprises a high-voltage overhead line, a low-voltage overhead line, a high-voltage cable line, a low-voltage cable line, a cable pit, a cable duct, a top pipe, a column distribution transformer and a box transformer;
Determining a project component summary table template according to the power grid project cost data component library and first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a master material;
Acquiring first engineering quantity fund providing table data, and determining a project data entry table according to the first engineering quantity fund providing table data and the project component summary table template, wherein the first engineering quantity fund providing table data represents the consolidated engineering quantity fund providing table data;
And if the project data is checked to be passed, executing a second operation to obtain a manufacturing cost result, otherwise, returning to the step of acquiring the first project data and determining project data entry form data according to the first project data and the project component summary form until the check is passed.
In some embodiments, the determining project data entry form data from the first engineering quantity funding form data and the project component summary form template specifically includes:
Acquiring a first instruction, extracting the first engineering quantity fund raising table data according to the first instruction, determining first data information, and determining second data information according to the project component summary table template, wherein the first data information comprises a plurality of sub-item names of the first engineering quantity fund raising table, the second data information comprises an assembly type name, a construction quota, equipment and a main material name of the project component summary table template, and the first instruction represents a data summary instruction;
Sequentially matching the first data information with the second data information, and if the matching is successful, marking the engineering quantity fund list data corresponding to the first data information which is successfully matched;
And acquiring a second instruction, writing the marked data in the first engineering quantity fund raising table data into the project component summary table template to obtain project data entry table data, wherein the second instruction characterizes the data output instruction.
In some embodiments, the verifying the project data entry form according to the first engineering quantity funding table data specifically includes:
obtaining a third instruction, summing the first engineering quantity fund providing table data according to the third instruction to obtain a first summation value, and summing the project data entry table data according to the third instruction to obtain a second summation value, wherein the third instruction characterizes a data inspection instruction;
and calculating a difference value according to the first summation value and the second summation value, comparing the difference value with a preset condition, if the difference value meets the preset condition, determining that the test passes, generating first information, otherwise, determining that the test does not pass, and executing a first operation, wherein the first information represents that the table data is accurate.
In some embodiments, the performing a first operation specifically includes:
Marking the first summation value according to a preset color, marking the second summation value according to the preset color, and sending the second information, wherein the second information represents a table data error.
In some embodiments, the performing the second operation results in a cost result, specifically including:
Acquiring first data, wherein the first data characterizes the item data entry form data which passes the inspection;
And carrying out statistical analysis operation on the first data through cost software to obtain a cost result, wherein the cost result comprises project cost investment and equipment material detail.
In some embodiments, the method further comprises:
Acquiring second engineering quantity fund-providing table data, and acquiring the first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a main material, and the second engineering quantity fund-providing table data represents unordered engineering quantity fund-providing table data;
Determining third data information according to the second engineering quantity fund raising table data, matching the third data information with the first preset information, and obtaining the first engineering quantity fund raising table data according to the third data information successfully matched, wherein the first engineering quantity fund raising table data represent the sorted engineering quantity fund raising table data, and the third data information comprises a plurality of subentry names of the second engineering quantity fund raising table.
In some embodiments, the method further comprises:
responding to a data compiling request, and displaying a first interface, wherein the first interface comprises a first component, a second component and a third component;
in response to a first operation on the first component, the first component generates a first instruction;
Responsive to a second operation on the second component, the second component generates a second instruction;
in response to a third operation on the third component, the third component generates a third instruction.
To achieve the above object, another aspect of the embodiments of the present application provides a power grid project cost compiling system, the system including:
The system comprises a first module, a second module, a third module and a fourth module, wherein the first module is used for acquiring power grid project information and determining a power grid project cost data assembly library according to the power grid project information, and the power grid project information comprises a high-voltage overhead line, a low-voltage overhead line, a high-voltage cable line, a low-voltage cable line, a cable pit, a cable bank, a jacking pipe, an on-column distribution transformer and a box transformer;
The second module is used for determining a project component summary table template according to the power grid project cost data component library and first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a master material;
The third module is used for acquiring first engineering quantity fund-providing table data and determining a project data entry form according to the first engineering quantity fund-providing table data and the project component summary table template, wherein the first engineering quantity fund-providing table data represents the consolidated engineering quantity fund-providing table data;
And a fourth module, configured to perform a test operation on the project data entry form according to the first engineering quantity fund-raising table data, if the test is passed, perform the first operation to obtain a cost result, otherwise, return to the step of obtaining the first engineering quantity fund-raising table data, and determine project data entry form data according to the first engineering quantity fund-raising table data and the project component summary table template until the test is passed.
To achieve the above object, another aspect of the embodiments of the present application provides an electronic device, including a memory and a processor, where the memory stores a computer program, and the processor implements the method described above when executing the computer program.
To achieve the above object, another aspect of the embodiments of the present application proposes a computer-readable storage medium storing a computer program which, when executed by a processor, implements the method described above.
The method and the device for compiling the power grid project cost, the electronic equipment and the storage medium have the advantages that the power grid project cost data assembly library is determined through the power grid project information, the project assembly summary table template is determined according to the power grid project cost data assembly library and the first preset information, the first engineering quantity investment lifting table data are matched and classified according to the project assembly summary table template, project data entry table data are obtained, the obtained project data entry table data are verified, analysis and calculation are carried out based on the project data entry table data passing the verification, and the project cost result is obtained. Constructing a power grid project cost assembly library and a project assembly summary table template according to the power grid project cost assembly library and the project assembly summary table template, matching, classifying and counting the acquired project quantity resource-providing table data to generate project data input table data, reducing the workload of manual data programming and improving the programming efficiency; and checking the generated project data entry form data, analyzing the project data entry form data based on the checked project data entry form data to obtain the project cost result, and improving the accuracy of data compiling.
Drawings
FIG. 1 is a schematic flow chart of steps of a method for compiling a project cost of a power grid according to an embodiment of the present invention;
FIG. 2 is a schematic flow chart of steps for generating a project data entry form in a method for compiling a project cost of a power grid according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart of a step of data arrangement in a method for compiling a power grid project cost according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a step of verifying a generated project data entry form in a method for compiling a project cost of a power grid according to an embodiment of the present invention;
FIG. 5 is a schematic flow chart of steps for calculating a cost result in a method for compiling a cost of a power grid project according to an embodiment of the present invention;
FIG. 6 is a flow chart of steps for component response in a method for compiling a power grid project cost according to an embodiment of the present invention;
FIG. 7 is a schematic flow chart of steps of a specific embodiment according to an embodiment of the present invention;
FIG. 8 is a block diagram of a system for compiling a project cost of a power grid according to an embodiment of the present invention;
fig. 9 is a block diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with embodiments of the application, but are merely examples of apparatuses and methods consistent with aspects of embodiments of the application as detailed in the accompanying claims.
It is to be understood that the terms "first," "second," and the like, as used herein, may be used to describe various concepts, but are not limited by these terms unless otherwise specified. These terms are only used to distinguish one concept from another. For example, the first information may also be referred to as second information, and similarly, the second information may also be referred to as first information, without departing from the scope of embodiments of the present application. The words "if", as used herein, may be interpreted as "when" or "in response to a determination", depending on the context.
The terms "at least one", "a plurality", "each", "any" and the like as used herein, at least one includes one, two or more, a plurality includes two or more, each means each of the corresponding plurality, and any one means any of the plurality.
Unless defined otherwise, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this application belongs. The terminology used herein is for the purpose of describing embodiments of the application only and is not intended to be limiting of the application.
The distribution network of the power grid company is widely distributed due to the expansion of the service operation range of the distribution network, in actual life, the operation range of the distribution network covers places such as cities, industrial areas and villages, and along with the long-time operation of the distribution network and the change of terminal power utilization users, unsafe states such as high-load operation or aging of operation equipment and the like can occur in the distribution network, so that the distribution network in the unsafe state needs to be overhauled by the power grid company, the equipment, network structure, equipment state and other data of the existing distribution network need to be compiled according to the overhauled items, the cost calculation is carried out according to the data after the data are compiled, the quantity of the distribution network which needs to be overhauled by the items is quite large, the data quantity which needs to be compiled and the cost calculation is quite large, the related personnel still adopt a manual mode to carry out data compilation and cost calculation, the work such as collection, statistics and the like of related data is carried out manually, the cost calculation of pedestrians is high, the working intensity is low, the data efficiency is easy to cause fatigue of related personnel, the data compilation efficiency is further reduced, and the accuracy of the data compilation is lowered.
For example, related technicians perform a stand overhaul on a power distribution network in a certain area, and need to manually collect power distribution network data in the area, including the number of power distribution devices, state information of each power distribution device, a power distribution network structure and the like, then manually count, classify and fill in the collected power distribution network data to obtain form data after data programming, and then perform cost calculation according to the programmed data to obtain project cost results of the power distribution network in the area, wherein the data programming efficiency is low and the accuracy is not high.
In view of this, an embodiment of the present application provides a method and a system for compiling a project cost of a power grid, an electronic device, and a medium, where the method determines a project cost data assembly library according to project cost information of the power grid, determines a project assembly summary table template according to the project cost data assembly library and first preset information, performs matching classification on an obtained first project amount resource extraction table according to the project assembly summary table template to obtain project data entry table data, performs inspection on the obtained project data entry table data, and performs analysis and calculation on the project data entry table data passing inspection to obtain a cost result. Determining project component summary table templates according to the project information of the power grid and the first preset information, carrying out matching classification on the acquired project quantity investment lifting tables according to the summary table templates to obtain project data input table data, reducing the workload of manual data compiling and improving the data compiling efficiency, checking the obtained project data input table data, analyzing and calculating based on the project data input table data passing the detection to obtain a manufacturing cost result, and improving the accuracy of data compiling and manufacturing cost data.
The embodiment of the application provides a power grid project cost compiling method, and relates to the technical field of project cost. The method for compiling the power grid project cost can be applied to a terminal, a server and software running in the terminal or the server. In some embodiments, the terminal may be, but not limited to, a smart phone, a tablet computer, a notebook computer, a desktop computer, a smart speaker, a smart watch, a vehicle terminal, etc., the server may be configured as an independent physical server, may be configured as a server cluster or a distributed system formed by a plurality of physical servers, may be configured as a cloud server for providing cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communication, middleware services, domain name services, security services, CDNs, and basic cloud computing services such as big data and artificial intelligence platforms, and the server may be a node server in a blockchain network, and the software may be an application for implementing a method for compiling a power grid project cost, etc., but is not limited to the above form.
The application is operational with numerous general purpose or special purpose computer system environments or configurations. Such as a personal computer, a server computer, a hand-held or portable device, a tablet device, a multiprocessor system, a microprocessor-based system, a set top box, a programmable consumer electronics, a network PC, a minicomputer, a mainframe computer, a distributed computing environment that includes any of the above systems or devices, and the like. The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
FIG. 1 is an alternative flow chart of a grid project cost formulation method provided by an embodiment of the present application, where the method of FIG. 1 may include, but is not limited to, the following steps.
Step S101, acquiring power grid project information, and determining a power grid project cost data assembly library according to the power grid project information, wherein the power grid project information comprises a high-voltage overhead line, a low-voltage overhead line, a high-voltage cable line, a low-voltage cable line, a cable pit, a cable duct, a top pipe, a column distribution transformer and a box transformer;
Step S102, determining a project component summary table template according to a power grid project cost data component library and first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a master material;
Step S103, acquiring first engineering quantity fund-providing table data, and determining an item data entry table according to the first engineering quantity fund-providing table data and an item component summary table template, wherein the first engineering quantity fund-providing table data represents the consolidated engineering quantity fund-providing table data;
And step S104, performing inspection operation on the project data entry form according to the first engineering quantity data of the resource list, if the inspection is passed, executing the first operation to obtain a manufacturing cost result, otherwise, returning to the step of obtaining the first engineering quantity data of the resource list, and determining the project data entry form data according to the first engineering quantity data of the resource list and the project component summary list template until the inspection is passed.
The method comprises the steps S101 to S104, which are shown in the embodiment of the application, of obtaining the types of lines in a power distribution network and the construction lengths of different types of lines, obtaining the information of matched facilities or power distribution equipment corresponding to the different types of lines, building a cost data component library of different types according to the obtained information, preliminarily classifying the existing power distribution network information by the cost data component library, obtaining corresponding data input form data according to the built cost data component library of different types in a construction and repair network, increasing the construction and maintenance cost of the different types of components, changing equipment and main material data information in maintenance, manufacturing a combined component summary template of major repair projects according to the added data information and the existing component library, obtaining the combined component summary template, distributing and summarizing uncorded data according to the template, matching uncorded data with various information in the template, writing the data into the matched cost items, compiling the data, obtaining corresponding data input form data according to the subsequent cost data calculation, verifying the corresponding data of the established items, verifying the data input form data according to the established items, verifying the accuracy of the data input form data, and verifying the fact that the data is not satisfied, and the data is accurately compiled after the data is calculated, and the requirements of the data is accurately compiled are met, and the data is calculated, and the requirements of the data is accurately compiled is calculated after the data is calculated, and the requirements of the data is calculated, and the data is not compiled.
In step S101 of some embodiments, the creation of the project component library may be performed by collecting information of the existing power distribution network. The project component library can also be established by analyzing historical data in a database of the power grid company, and the project component library is not limited to the project component library.
Referring to fig. 2, in some embodiments, step S103 may include, but is not limited to, steps S210 to S230:
Step S210, acquiring a first instruction, extracting data of a first engineering quantity fund raising table according to the first instruction, determining first data information, and determining second data information according to a project component summary table template, wherein the first data information comprises a plurality of sub-item names of the first engineering quantity fund raising table, the second data information comprises an assembly type name, a construction quota, equipment and a main material name of the project component summary table template, and the first instruction characterizes the data summary instruction;
step S220, sequentially matching the first data information with the second data information, and if the matching is successful, marking the engineering quantity fund list data corresponding to the successfully matched first data information;
Step S230, a second instruction is obtained, the marked data in the first engineering quantity fund raising table data is written into a project component summary table template to obtain project data entry table data, and the second instruction characterizes the data output instruction.
In step S210 of some embodiments, a project assembly summary table template is obtained in step S102, and the project assembly summary table template includes equipment, materials and corresponding data for repairing a standing distribution network, and after receiving an instruction for data summary, the data of the project assembly summary table is extracted according to terms for subsequent matching entry, and illustratively, the project assembly summary table template includes data of 1KV and below, and the project assembly summary table template includes various assembly names, construction quota, equipment and main material data, and the data of the project assembly summary table is extracted according to terms of 1KV and below, cable lines, cable pipes and box transformer substation for subsequent matching entry.
In step S220 of some embodiments, after extracting the data in the project-amount-providing table by terms, matching the extracted terms item by item with all terms in the project-assembly summary table template until the matching is successful, marking the terms of the project-amount-providing table and the terms in the project-assembly summary table template that are successfully matched, then extracting the next item data in the project-amount-providing table, repeatedly performing the operations of matching with all terms in the project-assembly summary table template and marking the terms that are successfully matched until all the data in the project-amount-providing table are matched and marked.
In step S230 of some embodiments, after all the data in the engineering quantity fund list are matched and marked, a data output instruction is received, the data in the engineering quantity fund list is written into the corresponding item in the project assembly summary table template according to the marked matching result, and the project data entry form is generated according to the project assembly summary table template written with the data, and in some embodiments, the obtained project data entry form may also be sent to a database for storage or printout.
The data compiling of the power distribution network data is realized by generating the project data entry form, and meanwhile, corresponding cost data is correspondingly summarized and counted in the project data entry form, so that a foundation is provided for subsequent cost result calculation.
Referring to fig. 3, before step S210 in some embodiments, the method for compiling a power grid project cost further includes steps S201 to S202:
step S201, acquiring second engineering quantity fund-providing table data and first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a main material, and the second engineering quantity fund-providing table data represents the unordered engineering quantity fund-providing table data;
Step S202, third data information is determined according to the second engineering quantity fund raising table data, the third data information is matched with the first preset information, the first engineering quantity fund raising table data is obtained according to the third data information which is successfully matched, the first engineering quantity fund raising table data represent the sorted engineering quantity fund raising table data, and the third data information comprises a plurality of sub-item names of the second engineering quantity fund raising table.
In step S201 of some embodiments, original engineering quantity data is collected and extracted from the design and investment providing table, the engineering quantity data comprises component data of various types for design, construction cost data, equipment data and material data required for construction, the data correspond to data items in the project cost data component library determined in step S101, and therefore, the collected and extracted original engineering quantity data can be arranged according to the data items in the project cost data component library to obtain the engineering quantity and investment providing table for subsequent data programming and cost result calculation.
In step S202 of some embodiments, the original engineering quantity data is extracted into data items, the extracted data items are matched with the data items of the project cost data component library in step S101, whether the data items in the original engineering quantity data are consistent with the data items of the project cost data component library is determined, the original engineering quantity data are sorted according to the data items which are determined to be consistent, and engineering quantity data are obtained for subsequent data compiling and cost result calculation.
Referring to fig. 4, in some embodiments, step S104 may include, but is not limited to, steps S301 to S302:
Step S301, a third instruction is obtained, the first engineering quantity data of the investment providing table are summed according to the third instruction to obtain a first summation value, and project data input form data are summed according to the third instruction to obtain a second summation value, wherein the third instruction characterizes a data inspection instruction;
Step S302, calculating a difference value according to the first summation value and the second summation value, comparing the difference value with a preset condition, determining that the difference value passes the inspection and generating first information if the difference value meets the preset condition, otherwise, determining that the inspection does not pass the inspection and executing first operation, wherein the first information represents that the table data are accurate.
In step S301 of some embodiments, after the project data entry form is generated in step S201 to step S203, the entry form needs to be checked to determine the accuracy of the data in the generated form, because the project data entry form is generated by summarizing the project data entry form data, the project data entry form can be checked according to the project data entry form, firstly, each project data in the project data entry form is statistically summed to obtain a summation value, then, the project data in the generated project data entry form is statistically summed to obtain another summation value, and whether the data of the generated project data entry form is accurate can be determined through the two summation values.
In step S302 of some embodiments, the two summation values obtained in step S301 are subjected to difference comparison, if the result of the difference comparison between the two summation values is 0, it is indicated that the data in the generated project data entry form is consistent with the data in the project data entry form, the data in the generated project data entry form is determined to be accurate, the calculation of the subsequent cost result can be performed, and if the result of the difference comparison between the two summation values is not 0, it is indicated that the data in the generated project data entry form is inconsistent with the data in the project data entry form, the data error of the generated project data entry form is determined, and the processing personnel is required to review and re-perform the data compilation on the project data entry form with the data error.
Referring to fig. 5, in some embodiments, step S104 may further include, but is not limited to, steps S303 to S304:
Step S303, acquiring first data, wherein the first data represents project data entry form data which passes the inspection;
And step S304, carrying out statistical analysis operation on the first data through cost software to obtain a cost result, wherein the cost result comprises project cost investment and equipment material detail.
In step S303 of some embodiments, the item data entry table corresponding to the sum value difference value comparison result of 0 in step S302 is obtained, and then the item data entry table is imported into the cost calculation software, and data transmission can be performed in a wired or wireless manner.
In step S304 of some embodiments, after the project data entry form with accurate data determined by data inspection is imported into the cost calculation software in step S303, statistical analysis is performed on the data in the project data entry form by the cost calculation software, so as to obtain a cost result corresponding to the entry form data, and a technician can perform subsequent operations such as evaluation on the power distribution network of the project overhaul according to the obtained cost result.
In step S104 of some embodiments, step S305 is further included:
step S305, marking the first summation value according to the preset color, marking the second summation value according to the preset color, and sending second information, wherein the second information represents the data error of the table.
In step S305 of some embodiments, the summation value difference value comparison is performed in step S302, the project data entry form with the summation value difference value comparison result of 0 is imported into the cost calculation software to perform cost result calculation, the project data entry form with the summation value difference value comparison result of not 0 is marked according to the preset color, meanwhile, for facilitating the examination of technicians, the project data entry form is marked by the preset color, and then prompt information is sent to the technicians to prompt.
Referring to fig. 6, the method for compiling a power grid project cost further includes steps S401 to S404:
Step S401, responding to a data compiling request, displaying a first interface, wherein the first interface comprises a first component, a second component and a third component;
step S402, responding to a first operation of a first component, and generating a first instruction by the first component;
step S403, in response to a second operation on the second component, the second component generates a second instruction;
in step S404, the third component generates a third instruction in response to a third operation on the third component.
In step S401 of some embodiments, a technician sends a data compiling request, after the cost compiling system receives the data compiling request, the data waiting for compiling is obtained through a data interface, and a first interface is displayed, wherein a plurality of components corresponding to different operations are arranged in the first interface, the components can be classified according to functions and divided into different functional areas, the technician can operate the different components according to actual application requirements, and the corresponding components respond to operations of the technician to execute preset operations in the components.
In step S402 of some embodiments, a first operation is performed on a first component in the first section interface, the first component generates a first instruction, performs a data summarizing operation on acquired data, extracts feature information such as a data name, matches the feature information with a fabricated summary table template, and marks successfully matched data.
In step S403 of some embodiments, a second operation is performed on a second component in the first interface, the second component generates a second instruction, performs a data output operation on the acquired data, performs matching on all the acquired data, marks successfully matched data, writes the marked data into a summary table template, and performs entry according to a matching result to generate project data entry table data.
In step S404 of some embodiments, a third operation is performed on a third component in the first interface, the third component generates a third instruction, a data inspection operation is performed on the acquired data, the generated project data entry form data is acquired, the acquired data is summed to determine the total amount of data to be programmed, then the generated project data entry form data is summed to determine the total amount of data to be programmed, the difference value between the two summation results is calculated, the accuracy of the data programming result is inspected, and whether omission occurs.
The following describes and illustrates the embodiments of the present invention in detail with reference to specific application examples:
Referring to fig. 7, fig. 7 is a schematic diagram of a method for compiling a manufacturing cost of a power grid project according to an embodiment of the present application. In the embodiment of the application, firstly, information of a power grid overhaul project is collected, a power grid overhaul project cost data component library comprising 10kV overhead lines, 1kV and below overhead lines, 10kV cable lines, 1kV and below cable lines, cable ducts, cable pipes, top pipes, on-column distribution transformers and box transformer categories is built according to the characteristics of the power grid overhaul project, then, the names of various components in the component library, construction quota, equipment and main material data information are determined from the built power grid overhaul project cost data component library, project component assembly table templates are made according to the obtained names of various components, construction quota, equipment and main material data information, then, engineering project design data are collected, the names of various components in the data are checked to be consistent with the names of various components in the power grid overhaul project cost data component library, the construction quota, the equipment and the main material data information, project data are obtained according to the data kept consistent, then, the names of the various components in the engineering quantity extraction tables are accurately matched with the project data in the project template, the project item assembly table names are written in the data table, the project item assembly table is accurately matched with the data table entry table, and the project item is accurately completed, the project item is recorded in the data table entry table is completed, the method comprises the steps of obtaining a second summation value of data in a corresponding project data entry form of a first summation value of data of a corresponding project data entry form of a project data collection form, comparing the first summation value with the second summation value, determining the project data entry form with zero difference comparison result as accurate data, importing the project data entry form into cost calculation software, carrying out statistical analysis on the project data entry form through the cost calculation software to obtain a project cost result, determining the project data entry form with the difference comparison result not being 0 as incorrect data, marking the two summation values by adopting red, sending prompt information to technicians, collecting and sorting the project data entry form again to obtain a new project data collection form, and carrying out data compiling and cost calculation.
The method and the device for compiling the power grid project cost, the electronic equipment and the storage medium have the advantages that the power grid project cost data assembly library is determined through power grid project information, the project assembly summary table template is determined according to the power grid project cost data assembly library and first preset information, the first engineering quantity investment table data is matched and classified according to the project assembly summary table template, the matched and classified first engineering quantity investment table is written into the project assembly summary table template to generate project data input table data, the data accuracy of the generated project data input table data is checked according to the first engineering quantity investment table, and analysis and calculation are carried out on the checked project data input table data to obtain a project cost result. Constructing a power grid project cost assembly library and a project assembly summary table template according to the power grid project cost assembly library and the project assembly summary table template, matching, classifying and counting the acquired project quantity resource-providing table data to generate project data input table data, reducing the workload of manual data programming and improving the programming efficiency; and checking the generated project data entry form data, analyzing the project data entry form data based on the checked project data entry form data to obtain the project cost result, and improving the accuracy of data compiling.
Referring to fig. 8, the embodiment of the application further provides a system for compiling a power grid project cost, which can implement the method for compiling a power grid cost, and the system comprises:
The system comprises a first module, a second module, a third module and a fourth module, wherein the first module is used for acquiring power grid project information and determining a power grid project cost data assembly library according to the power grid project information, and the power grid project information comprises a high-voltage overhead line, a low-voltage overhead line, a high-voltage cable line, a low-voltage cable line, a cable pit, a cable bank, a jacking pipe, an on-column distribution transformer and a box transformer;
The second module is used for determining a project component summary table template according to the power grid project cost data component library and first preset information, wherein the first preset information comprises an assembly type name, a construction quota, equipment and a master material;
The third module is used for acquiring first engineering quantity fund-providing table data and determining a project data entry form according to the first engineering quantity fund-providing table data and the project component summary table template, wherein the first engineering quantity fund-providing table data represents the consolidated engineering quantity fund-providing table data;
And a fourth module, configured to perform a test operation on the project data entry form according to the first engineering quantity fund-raising table data, if the test is passed, perform the first operation to obtain a cost result, otherwise, return to the step of obtaining the first engineering quantity fund-raising table data, and determine project data entry form data according to the first engineering quantity fund-raising table data and the project component summary table template until the test is passed.
It can be understood that the content in the above method embodiment is applicable to the system embodiment, and the functions specifically implemented by the system embodiment are the same as those of the above method embodiment, and the achieved beneficial effects are the same as those of the above method embodiment.
The embodiment of the application also provides electronic equipment, which comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the power grid project cost compiling method when executing the computer program. The electronic equipment can be any intelligent terminal including a tablet personal computer, a vehicle-mounted computer and the like.
It can be understood that the content in the above method embodiment is applicable to the embodiment of the present apparatus, and the specific functions implemented by the embodiment of the present apparatus are the same as those of the embodiment of the above method, and the achieved beneficial effects are the same as those of the embodiment of the above method.
Referring to fig. 9, fig. 9 illustrates a hardware structure of an electronic device according to another embodiment, the electronic device includes:
The processor 901 may be implemented by a general purpose CPU (central processing unit), a microprocessor, an application specific integrated circuit (ApplicationSpecificIntegratedCircuit, ASIC), or one or more integrated circuits, etc. for executing related programs, so as to implement the technical solution provided by the embodiments of the present application;
The memory 902 may be implemented in the form of read-only memory (ReadOnlyMemory, ROM), static storage, dynamic storage, or random access memory (RandomAccessMemory, RAM), among others. The memory 902 may store an operating system and other application programs, and when the technical solutions provided in the embodiments of the present disclosure are implemented by software or firmware, relevant program codes are stored in the memory 902, and the processor 901 invokes the method for compiling a power grid project cost according to the embodiments of the present disclosure;
An input/output interface 903 for inputting and outputting information;
the communication interface 904 is configured to implement communication interaction between the device and other devices, and may implement communication in a wired manner (e.g. USB, network cable, etc.), or may implement communication in a wireless manner (e.g. mobile network, WIFI, bluetooth, etc.);
a bus 905 that transfers information between the various components of the device (e.g., the processor 901, the memory 902, the input/output interface 903, and the communication interface 904);
wherein the processor 901, the memory 902, the input/output interface 903 and the communication interface 904 are communicatively coupled to each other within the device via a bus 905.
Furthermore, the embodiment of the application also discloses a computer program product or a computer program, and the computer program product or the computer program is stored in a computer readable storage medium. The computer program may be read from a computer readable storage medium by a processor of a computer device, the processor executing the computer program causing the computer device to perform the method as described above. Similarly, the content in the above method embodiment is applicable to the present storage medium embodiment, and the specific functions of the present storage medium embodiment are the same as those of the above method embodiment, and the achieved beneficial effects are the same as those of the above method embodiment.
The embodiment of the application also provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program which realizes the power grid project cost compiling method when being executed by a processor.
It can be understood that the content of the above method embodiment is applicable to the present storage medium embodiment, and the functions of the present storage medium embodiment are the same as those of the above method embodiment, and the achieved beneficial effects are the same as those of the above method embodiment.
The memory, as a non-transitory computer readable storage medium, may be used to store non-transitory software programs as well as non-transitory computer executable programs. In addition, the memory may include high-speed random access memory, and may also include non-transitory memory, such as at least one magnetic disk storage device, flash memory device, or other non-transitory solid state storage device. In some embodiments, the memory optionally includes memory remotely located relative to the processor, the remote memory being connectable to the processor through a network. Examples of such networks include, but are not limited to, the internet, intranets, local area networks, mobile communication networks, and combinations thereof.
The embodiment of the application provides a power grid project construction method, a power grid project construction system, electronic equipment and a storage medium, which are characterized in that a power grid project construction data assembly library is established through power grid project information, a project assembly summary template is produced according to the power grid project construction data assembly library, the project assembly summary template comprises the information of names, construction quota, equipment and main materials of various types of assemblies, engineering quantity investment tables are collected and arranged, the engineering quantity investment tables are matched with the project assembly summary template, the engineering quantity investment tables are written into the project assembly summary template according to the matching result, project data entry tables are generated, the data accuracy check is carried out on the generated project data entry tables according to the engineering quantity investment tables, the project data entry tables which pass the accuracy check are imported into cost calculation software according to the engineering project construction data assembly template, the project assembly library is built according to the established project assembly summary template, the engineering quantity investment tables are subjected to data construction according to the project assembly summary template, the artificial data are reduced, the working quantity is compiled, the project data entry accuracy check is improved, the project data entry accuracy check is carried out according to the engineering quantity investment tables, and the data entry accuracy check is improved, and the data is calculated according to the project data entry accuracy check table.
The embodiments described in the embodiments of the present application are for more clearly describing the technical solutions of the embodiments of the present application, and do not constitute a limitation on the technical solutions provided by the embodiments of the present application, and those skilled in the art can know that, with the evolution of technology and the appearance of new application scenarios, the technical solutions provided by the embodiments of the present application are equally applicable to similar technical problems.
It will be appreciated by persons skilled in the art that the embodiments of the application are not limited by the illustrations, and that more or fewer steps than those shown may be included, or certain steps may be combined, or different steps may be included.
The above described apparatus embodiments are merely illustrative, wherein the units illustrated as separate components may or may not be physically separate, i.e. may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
Those of ordinary skill in the art will appreciate that all or some of the steps of the methods, systems, functional modules in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof.
The terms "first," "second," "third," "fourth," and the like in the description of the application and in the above-described figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the application described herein may be implemented in sequences other than those illustrated or otherwise described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
In the several embodiments provided by the present application, 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 above-described division of units is merely a logical function division, and there may be another division manner in actual implementation, for example, a plurality of units or components may be combined or may be integrated into another system, or some features may be omitted, or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described above as separate components may or may not be physically separate, and components shown as units may or may not be physical units, may be located in one place, or may be distributed over a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including multiple instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method of the various embodiments of the present application. The storage medium includes various media capable of storing programs, such as a U disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory RAM), a magnetic disk, or an optical disk.
The preferred embodiments of the present application have been described above with reference to the accompanying drawings, and are not thereby limiting the scope of the claims of the embodiments of the present application. Any modifications, equivalent substitutions and improvements made by those skilled in the art without departing from the scope and spirit of the embodiments of the present application shall fall within the scope of the claims of the embodiments of the present application.
Claims (8)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311740737.2A CN117893150B (en) | 2023-12-15 | 2023-12-15 | A method and system for compiling power grid project cost, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311740737.2A CN117893150B (en) | 2023-12-15 | 2023-12-15 | A method and system for compiling power grid project cost, electronic equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117893150A CN117893150A (en) | 2024-04-16 |
| CN117893150B true CN117893150B (en) | 2025-08-22 |
Family
ID=90649728
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311740737.2A Active CN117893150B (en) | 2023-12-15 | 2023-12-15 | A method and system for compiling power grid project cost, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117893150B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118485048A (en) * | 2024-06-11 | 2024-08-13 | 中国气象局气象发展与规划院 | Form processing method, form processing device, electronic equipment, medium and program product |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109359952A (en) * | 2018-11-13 | 2019-02-19 | 国网四川省电力公司经济技术研究院 | Method and system for reviewing bill of quantities for power transmission and transformation projects |
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | Power grid engineering cost editing and list application system based on construction drawing budget management |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US11625660B2 (en) * | 2020-08-26 | 2023-04-11 | Oracle International Corporation | Machine learning for automatic extraction and workflow assignment of action items |
-
2023
- 2023-12-15 CN CN202311740737.2A patent/CN117893150B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109472642A (en) * | 2018-11-09 | 2019-03-15 | 国网湖南省电力有限公司 | Power grid engineering cost editing and list application system based on construction drawing budget management |
| CN109359952A (en) * | 2018-11-13 | 2019-02-19 | 国网四川省电力公司经济技术研究院 | Method and system for reviewing bill of quantities for power transmission and transformation projects |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117893150A (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109784758B (en) | Engineering quality supervision early warning system and method based on BIM model | |
| CN117893150B (en) | A method and system for compiling power grid project cost, electronic equipment and storage medium | |
| CN117875948B (en) | Equipment-based power grid overhaul event determination method, device, equipment and medium | |
| CN110472866A (en) | A method and device for quality inspection and analysis of work order | |
| CN103677815A (en) | Method for generating program to automatically test electrical performance of spacecraft low-frequency cable | |
| CN110427675B (en) | Data detection method for three-dimensional design review | |
| CN109359748A (en) | Management method, terminal and the computer readable storage medium of Maintenance plan | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN118172202A (en) | Digital quality management method for the whole process of construction engineering | |
| CN112836988A (en) | Method, system and equipment for evaluating risk level of gas polyethylene pipeline | |
| CN103247087A (en) | City distribution network graphical intelligent anti-misoperation system and method of system | |
| CN111611665B (en) | An intelligent substation design method based on three-dimensional modular design | |
| CN113919427A (en) | Electric power equipment archive data management method and system | |
| CN113961716A (en) | Knowledge graph generation method and system for vulnerability analysis of power monitoring system | |
| CN119917490A (en) | Master data integration method, system, device and storage medium based on index weighting | |
| CN118734024A (en) | A water and electricity pipeline monitoring method, system, equipment and medium based on BIM | |
| CN116010349B (en) | Metadata-based data checking method and device, electronic equipment and storage medium | |
| CN111709484A (en) | Method, device, computer equipment and storage medium for grid-connected acceptance of new energy station | |
| CN101201787A (en) | Debugging system and method of software program | |
| CN112446619B (en) | Distribution network emergency repair processing method and device | |
| CN114741308B (en) | Front-end verification processing method, device and medium | |
| CN117875881B (en) | Distribution project data generation method, system, electronic equipment and storage medium | |
| CN114880891A (en) | Intelligent power distribution network construction system and method based on standard digital model | |
| CN114781842A (en) | A kind of scaffolding construction matching method and system | |
| CN113127375A (en) | Automatic test system for software development type tasks of working platform |
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 | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20250721 Address after: 510000 Guangdong Province Guangzhou City Yuexiu District Dongfeng East Road No. 753 East Tower Room 3407 Applicant after: Guangdong Aibo Electric Power Design Institute (Group) Co.,Ltd. Country or region after: China Address before: 510000 Guangdong Province Guangzhou City Hejing Road 84, Room 203, Liwan District Applicant before: Guangdong Jianfeng Electric Power Design Institute Co.,Ltd. Country or region before: China |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |