CN107705055A - Power network technology innovation project backlog control method based on bill of quantities - Google Patents

Abstract

The invention relates to a method for managing reserves of power grid technical upgrading projects based on bill of quantities, and solves the defect that there is no use of bill of quantities to realize reserve management of technical upgrading projects as compared with the prior art. The invention comprises the following steps: initializing basic data; generating project proposals and data import; examining and approving project proposals; The invention imports the cost list based on the bill of engineering quantity into the project reserve information, and can realize the project reserve management of the power grid technical transformation project according to the bill of engineering quantity pricing mode.

Description

Reserve management method for power grid technical upgrading project based on bill of quantities

technical field

The invention relates to the technical field of data processing, in particular to a method for managing reserves of power grid technical renovation projects based on bill of quantities.

Background technique

Power grid technical upgrading project reserve management is an important part of the whole process management of power grid technical upgrading project, and it is the basis and guarantee of project quality and cost control, which will directly affect the economic benefits of power construction enterprises. At present, due to the large amount of reserve management information data, many sources and channels, and frequent changes in the technical transformation project of the power grid, there are difficulties in statistical analysis of reserve projects in the process of technical transformation control of the power grid, update lags, information gaps between reserves and budgets, bidding, etc. Deviation and other issues, it is difficult to efficiently and reasonably control the progress and cost of the entire power grid technical transformation project. In addition, most reserve projects still have manual methods such as paper application, screening, review and query of technical upgrading projects, and there is no corresponding power grid technical upgrading project reserve management computer system to track and control the reserve status of various technical upgrading projects .

As a brand-new pricing method, the bill of quantities adopts comprehensive unit price and carries out cost budget at market price, which clearly and detailedly reflects the physical consumption and other related expenses of technical upgrading projects, including labor, materials, machinery, and management fees It has the characteristics of separation of quantity and price and separate risks, which is convenient for contract price adjustment.

Then, how to realize the tracking and control of the reserves of various technical renovation projects based on the bill of quantities has become an urgent technical problem to be solved.

Contents of the invention

The purpose of the present invention is to solve the defect in the prior art that there is no use of the bill of quantities to realize the reserve management of the technical renovation project, and to provide a method for managing the reserve of the technical renovation project of the power grid based on the bill of quantities to solve the above problems.

In order to achieve the above object, the technical scheme of the present invention is as follows:

The reserve management method of power grid technical upgrading project based on the bill of quantities includes the following steps:

Basic data initialization, importing various basic databases of power grid technical upgrading project reserve projects into the basic data management database, including the standard library of the bill of quantities, the cost quota database of technical upgrading projects, the main material library and equipment library, the project reserve library, and the basis for project establishment Libraries, business process files;

Generating project proposals and importing data, filling in technical transformation workload and project budget, generating project proposals and importing data;

Approval of the project proposal, through the work order information, to approve the proposal and fill in the comments for the submitted project work order, and report it for price verification after approval;

Check the price and fee of the power grid technical transformation project, and conduct price and fee check and issue a price and fee check opinion for the submitted project proposal and the status of the project proposal is approved;

The method of checking the price and fee is: select the work order information, check the price and fill in the comments for the submitted project work order and the work order status has been approved by the city company; if the cost list data is correct, fill in the check opinion, Select to pass the verification and save; if the cost sheet data is incorrect, fill in the correct standard value or modification opinion in the red box of the corresponding data, and select not to pass the verification;

Review the cost of the technical transformation project of the power grid, conduct a cost review of the technical transformation project on the project proposal, issue and report the cost review opinion, and form a formal project reserve.

The technical transformation workload and project budget described above are for non-feasibility research projects, which include the following steps: import basic project information, including project name, project start and end time, whether there is a budget, whether there is a list of equipment to be dismantled, the project Category, professional subdivision, voltage level, compiler, compilation time, review, review time, approval and approval time; the project name includes the voltage level, and ends with the designation of renovation, replacement or construction;

If the non-feasibility study project is budgetable, import the budget data after the project workload is completed; project category includes power grid primary system, secondary system and others; professional subdivision includes power transmission, power transformation and power distribution;

If there is a list of equipment to be removed, add a new list of equipment, or directly import the equipment to be removed or import it from the PMS, and automatically generate the main information such as the current status of the equipment and existing problems;

List of equipment to be dismantled; including "importing dismantling equipment" and "importing from PMS" two imported lists of equipment to be dismantled;

Edit the detailed information of each equipment in the dismantled equipment list, including the line to which it belongs, equipment name, equipment type, voltage level, equipment model, date of commissioning, quantity, unit of measurement, existing problems, technical implementation plan, and equipment operation , safety evaluation, cycle cost evaluation, performance evaluation;

Import implementation necessary materials, project plans and non-calculated calculation tables,

Quantitative analysis of non-measurable calculation tables,

The reference formula for quantitative analysis is: actual investment cost of similar projects * correction coefficient of project investment scale * inflation rate, where, correction coefficient of project investment scale = length of investment line or variable capacity of this project / length of investment line or variable capacity of similar projects capacitance;

Inflation rate = 1+ the sum of CPI in each year between similar projects and this project, and the inflation rate is 110% as the standard.

The generating project proposal and importing data include the following steps:

Generate a project proposal and define that the project proposal includes the total project investment, total equipment and materials, where the total project investment is the sum of equipment and material purchase fees, construction engineering fees, installation engineering fees, and other expenses, and the total equipment and materials are determined by the quantity × unit acquisition, two valid digits after the decimal point are reserved;

Import Data,

Export the project work order, export the project summary list and the project proposal and cost list of each project according to the query conditions. The query conditions include basic information, equipment information to be dismantled, evaluation and identification information, and drawings;

The export format is divided into excel and system .data format, the excel format is used for user viewing, and the .data format is used for internal circulation in the system; when the export format is selected as the system format, select to export multiple files by "professional segmentation, unit", And distribute it; when exporting by unit, you can choose to export multiple data files of the corresponding unit by city or county; when you choose to subdivide by specialty, export the corresponding data file according to the specific subdivision; When not selected, a single data file is uniformly exported; the export results are divided into upper reporting and lower approval respectively imported into project work orders;

Import the project work order, select the data file generated by the system, analyze the work order information in the data, and select and load the required work order information.

Beneficial effect

Compared with the prior art, the reserve management method of power grid technical transformation project based on the bill of quantities of the present invention solves the difficulty in statistical analysis of reserve items, update lag, information between reserve and budget, bidding, etc. in the process of power grid technical transformation management and control There are problems such as deviation.

The invention imports the cost list based on the bill of quantities into the project reserve information, and can realize the project reserve management of the power grid technical transformation project according to the bill of quantities valuation mode, including project proposal filling, approval, price verification, cost review and approval, Realize the rapid import of cost list, automatic generation and export of statistical analysis, improve the efficiency and accuracy of reserve management, and can effectively avoid problems caused by large project data, multiple source channels, frequent changes, etc. , It is conducive to the unification and standardization of project reserve management, and it is convenient to track the progress and capital consumption of power grid technical transformation projects in the entire technical transformation control process, and provide a strong guarantee for the smooth progress of power grid technical transformation projects.

Description of drawings

Fig. 1 is a method sequence diagram of the present invention.

detailed description

In order to have a further understanding and understanding of the structural features of the present invention and the achieved effects, the preferred embodiments and accompanying drawings are used for a detailed description, as follows:

As shown in Figure 1, the method for managing power grid technical renovation project reserves based on the bill of quantities of the present invention includes the following steps:

The first step is to initialize the basic data. Import various basic databases of power grid technical transformation project reserve projects into the basic data management database, including the standard database of the bill of quantities, the cost quota database of technical transformation projects, the main material database and equipment database, the project reserve database, the project basis database, and the business process document.

The second step is the generation of project proposals and data import. Fill in the technical transformation workload and project budget, generate project proposals and import data. Among them, filling in the technical transformation workload and project budget includes the following steps:

According to the definition of power grid technical transformation project, the projects below 2 million are non-feasibility projects. The filling steps of non-feasibility research projects are as follows:

A. Import the basic information of the project, including project name, project start and end time, whether there is a budget, whether there is a list of equipment to be dismantled, project category, professional subdivision, voltage level, preparation personnel, preparation time, review, review time, approval and approval Time; the project name includes the voltage level and ends with the designation of renovation, replacement or construction;

If the non-feasibility study project is budgetable, import the budget data after the project workload is completed; the project category includes power grid primary system, secondary system and others; professional subdivision includes power transmission, power transformation and power distribution.

B. If there is a list of equipment to be removed, add a new list of equipment, or directly import the equipment to be removed or import it from PMS, and automatically generate the main information such as the current status of the equipment and existing problems;

List of equipment to be dismantled; including "importing dismantling equipment" and "importing from PMS".

C. Edit the detailed information of each equipment in the dismantled equipment list, including the line to which it belongs, equipment name, equipment type, voltage level, equipment model, date of commissioning, quantity, unit of measurement, existing problems, technical implementation plan, equipment Operation status, safety evaluation, cycle cost evaluation, performance evaluation.

D. Import necessary material for implementation, project plan and uncalculated calculation table.

E. Quantitative analysis of non-measurable calculation tables,

The reference formula for quantitative analysis is: actual investment cost of similar projects * correction coefficient of project investment scale * inflation rate, where, correction coefficient of project investment scale = length of investment line or variable capacity of this project / length of investment line or variable capacity of similar projects capacitance;

Inflation rate = 1+ the sum of CPI in each year between similar projects and this project, and the inflation rate is 110% as the standard.

Among them, generating project proposals and importing data includes the following steps:

(1) Generate a project proposal and define that the project proposal includes the total project investment, equipment and materials. Among them, the total project investment is the sum of equipment and material purchase fees, construction engineering fees, installation engineering fees, and other expenses, equipment and materials The total is obtained by quantity × unit, and there are two valid figures after the decimal point.

(2) import data,

A. Export the project work order, export the project summary list and the project proposal and cost list of each project according to the query conditions. The query conditions include basic information, equipment information to be dismantled, evaluation and identification information, and drawings;

The export format is divided into excel and system .data format, the excel format is used for user viewing, and the .data format is used for internal circulation in the system; when the export format is selected as the system format, select to export multiple files by "professional segmentation, unit", And distribute it; when exporting by unit, you can choose to export multiple data files of the corresponding unit by city or county; when you choose to subdivide by specialty, export the corresponding data file according to the specific subdivision; When not selected, a single data file is uniformly exported; the export results are divided into upper reporting and lower approval respectively imported into project work orders;

B. Import the project work order, select the data file generated by the system, analyze the work order information in the data, and select and load the required work order information.

The third step is the approval of the project proposal. , Through the work order information, approve the proposal and fill in the comments for the submitted project work order, and report it for price verification after approval.

The fourth step is to check the price and fee of the technical transformation project of the power grid. For the submitted project proposal and the status of the project proposal is approved, the price and fee will be checked and the price and fee check opinion will be issued.

The method of checking the price and fee is: select the work order information, check the price and fill in the comments for the submitted project work order and the work order status has been approved by the city company; if the cost list data is correct, fill in the check opinion, Select pass the verification and save it; if the cost sheet data is incorrect, fill in the correct standard value or modification opinion in the red box of the corresponding data, and choose not to pass the verification.

The fifth step is to review the cost of the technical transformation project of the power grid, conduct a technical transformation project cost review on the project proposal, issue the cost review opinion and report it, and form a formal project reserve.

The basic principles, main features and advantages of the present invention have been shown and described above. Those skilled in the art should understand that the present invention is not limited by the above-mentioned embodiments. What are described in the above-mentioned embodiments and the description are only the principles of the present invention. Variations and improvements, which fall within the scope of the claimed invention. The scope of protection required by the present invention is defined by the appended claims and their equivalents.

Claims (3)

1. A method for managing power grid technical renovation project reserves based on bill of quantities, characterized in that, comprising the following steps: 11) Basic data initialization, importing various basic databases of power grid technical upgrading project reserve projects into the basic data management database, including the bill of quantities standard database, technical upgrading project cost quota database, main material database and equipment database, project reserve database, Project basis library, business process documents; 12) Generation of project proposals and data import, fill in the workload of technical transformation and project budget, generate project proposals and import data; 13) Examination and approval of project proposals, through the work order information, review and fill in the proposals for the submitted project work orders, and submit the report for price verification after approval; 14) Check the price and fee of the technical transformation project of the power grid, and conduct price and fee check and issue a price and fee check opinion for the submitted project proposal and the status of the project proposal is approved; The method of checking the price and fee is: select the work order information, check the price and fill in the comments for the submitted project work order and the work order status has been approved by the city company; if the cost list data is correct, fill in the check opinion, Select to pass the verification and save; if the cost sheet data is incorrect, fill in the correct standard value or modification opinion in the red box of the corresponding data, and select not to pass the verification; 15) Review the cost of the power grid technical transformation project, review the project proposal for the technical transformation project cost, issue and report the cost review opinion, and form a formal project reserve. 2. The method for managing power grid technical renovation project reserves based on bill of quantities according to claim 1, characterized in that the technical renovation workload and project budget are filled in for non-feasibility projects, and it includes the following steps : 21) Import the basic information of the project, including project name, project start and end time, whether there is a budget, whether there is a list of equipment to be dismantled, project category, professional subdivision, voltage level, preparation personnel, preparation time, review, review time, approval and approval Time; the project name includes the voltage level and ends with the designation of renovation, replacement or construction; If the non-feasibility study project is budgetable, import the budget data after the project workload is completed; project category includes power grid primary system, secondary system and others; professional subdivision includes power transmission, power transformation and power distribution; 22) If there is a list of equipment to be removed, add a new list of equipment, or directly import the equipment to be removed or import it from the PMS, and automatically generate the main information such as the current status of the equipment and existing problems; List of equipment to be dismantled; including "importing dismantling equipment" and "importing from PMS" two imported lists of equipment to be dismantled; 23) Edit the detailed information of each equipment in the dismantled equipment list, including the line to which it belongs, equipment name, equipment type, voltage level, equipment model, date of commissioning, quantity, unit of measurement, existing problems, technical implementation plan, equipment Operation status, safety evaluation, cycle cost evaluation, performance evaluation; 24) Import the implementation necessary materials, project plans and non-calculated calculation tables, 25) Quantitative analysis of non-measurable calculation tables, The reference formula for quantitative analysis is: actual investment cost of similar projects * correction coefficient of project investment scale * inflation rate, where, correction coefficient of project investment scale = length of investment line or variable capacity of this project / length of investment line or variable capacity of similar projects capacitance; Inflation rate = 1+ the sum of CPI in each year between similar projects and this project, and the inflation rate is 110% as the standard. 3. the method for managing power grid technical upgrading project reserves based on bill of quantities according to claim 1, characterized in that, said generating project proposal and importing data comprises the following steps: 31) Generate a project proposal and define that the project proposal includes the total project investment, total equipment and materials, where the total project investment is the sum of equipment and material purchase fees, construction engineering fees, installation engineering fees, and other expenses, and the total equipment and materials Obtained by quantity × unit, with two valid digits after the decimal point; 32) import data, 321) Export the project work order, export the project summary list and the project proposal and cost list of each project according to the query conditions. The query conditions include basic information, information on equipment to be removed, evaluation and identification information, and drawings; The export format is divided into excel and system .data format, the excel format is used for user viewing, and the .data format is used for internal circulation in the system; when the export format is selected as the system format, select to export multiple files by "professional segmentation, unit", And distribute it; when exporting by unit, you can choose to export multiple data files of the corresponding unit by city or county; when you choose to subdivide by specialty, export the corresponding data file according to the specific subdivision; When not selected, a single data file is uniformly exported; the export results are divided into upper reporting and lower approval respectively imported into project work orders; 322) Import the project work order, select the data file generated by the system, analyze the work order information existing in the data, and select and load the required work order information.