CN114240044A - Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project - Google Patents

Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project Download PDF

Info

Publication number
CN114240044A
CN114240044A CN202111340534.5A CN202111340534A CN114240044A CN 114240044 A CN114240044 A CN 114240044A CN 202111340534 A CN202111340534 A CN 202111340534A CN 114240044 A CN114240044 A CN 114240044A
Authority
CN
China
Prior art keywords
plan
investment
progress
project
power grid
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202111340534.5A
Other languages
Chinese (zh)
Inventor
马莉
周明
卢生炜
武强
周蠡
柯方超
唐学军
孙利平
张雪霏
贺兰菲
熊川羽
熊一
王巍
李智威
高晓晶
张赵阳
王琪鑫
陈然
明月
邹雨馨
廖爽
郭婷
廖晓红
周秋鹏
李俊卿
彭云
熊建武
陈东
丁锐
刘成伟
于乐
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
State Grid Hubei Electric Power Co Ltd
China Power Engineering Consultant Group Central Southern China Electric Power Design Institute Corp
Economic and Technological Research Institute of State Grid Hubei Electric Power Co Ltd
Original Assignee
State Grid Hubei Electric Power Co Ltd
China Power Engineering Consultant Group Central Southern China Electric Power Design Institute Corp
Economic and Technological Research Institute of State Grid Hubei Electric Power Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by State Grid Hubei Electric Power Co Ltd, China Power Engineering Consultant Group Central Southern China Electric Power Design Institute Corp, Economic and Technological Research Institute of State Grid Hubei Electric Power Co Ltd filed Critical State Grid Hubei Electric Power Co Ltd
Priority to CN202111340534.5A priority Critical patent/CN114240044A/en
Publication of CN114240044A publication Critical patent/CN114240044A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0631Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G06Q10/06312Adjustment or analysis of established resource schedule, e.g. resource or task levelling, or dynamic rescheduling
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/04Forecasting or optimisation specially adapted for administrative or management purposes, e.g. linear programming or "cutting stock problem"
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/103Workflow collaboration or project management
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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
    • G06Q40/00Finance; Insurance; Tax strategies; Processing of corporate or income taxes
    • G06Q40/12Accounting
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/06Energy or water supply
    • YGENERAL 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
    • Y04INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
    • Y04SSYSTEMS 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/00Systems supporting electrical power generation, transmission or distribution
    • Y04S10/50Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Tourism & Hospitality (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • Health & Medical Sciences (AREA)
  • Game Theory and Decision Science (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Public Health (AREA)
  • Water Supply & Treatment (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Educational Administration (AREA)
  • Technology Law (AREA)
  • Data Mining & Analysis (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a method for monitoring the collaborative execution condition of an investment plan and a capital plan of a power grid infrastructure project, which comprises the following steps: acquiring the construction period of the power grid infrastructure project and the corresponding construction period schedule node and the relative completion time of each construction period schedule node according to the engineering data of the power grid infrastructure project, and generating a milestone schedule; calculating the cost generated by each construction period plan progress node, and generating an investment plan by combining a milestone progress plan; acquiring contract data of a power grid infrastructure project, and generating a fund plan according to a payment time point and a contract payment proportion agreed in the contract data and a milestone progress plan; acquiring field construction data of a power grid infrastructure project, and judging the current actual project progress of the power grid infrastructure project according to the field construction data; acquiring the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan; and adjusting the investment plan and the fund plan.

Description

Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project
Technical Field
The invention belongs to the technical field of budget settlement of power grid infrastructure projects, and particularly relates to a method for monitoring the cooperative execution condition of an investment plan and a capital plan of a power grid infrastructure project.
Background
In the prior art, the establishment, the investment execution and the investment adjustment of an investment plan lack scientific quantitative tools and means, and the management target of 'scientific establishment, accurate execution and good adjustment' of the investment plan is difficult to realize.
Generally, when a member of the development department of a prefecture company makes an annual investment plan for a project, the member makes an investment plan according to the scale of the project and the planning period based on the experience of the past completed projects. The compilation of annual investment plans is usually influenced by the experience of compilation personnel, and the data dimension cannot meet the change requirement of project construction conditions. When the actual completion condition of the project is greatly different from the plan, the establishment personnel need to dynamically adjust the investment plan and reasonably correct the completion condition of the investment.
After the investment plan is issued, financial staff can conduct financial budget annual investment compilation according to the issued project investment and is used for guiding the payment settlement of funds in the project construction process. The project fund management of the financial department is to schedule monthly budget of the fund according to a fund plan (reported by construction units) of the engineering construction department, and perform the current month plan and the next month payment process.
In actual work, an investment plan, budget management and a fund plan are operated in respective working modules according to respective mastered information and management resources, and related departments cannot cooperate with each other, so that data reported from bottom to top are difficult to effectively link and balance with each other.
Disclosure of Invention
The invention aims to solve the defects of the background technology, and provides a method for monitoring the cooperative execution condition of the investment plan and the capital plan of the power grid infrastructure project, which improves the reasonability and accuracy of issuing the project investment plan and compiling the budget capital plan, is beneficial to timely and effectively adjusting the investment plan and the budget capital plan, enables the investment plan to be matched with the project budget capital, and is effectively linked and linked, and continuously improves the control level of the power grid investment plan.
The technical scheme adopted by the invention is as follows: a method for monitoring the collaborative execution condition of an investment plan and a capital plan of a power grid infrastructure project comprises the following steps:
s1, acquiring construction periods of the power grid infrastructure projects and corresponding construction period plan progress nodes and relative completion time of each construction period plan progress node according to the engineering data of the power grid infrastructure projects, and generating milestone progress plans; the milestone progress plan is used for representing project progress set according to monthly degrees;
s2, calculating the cost generated by each construction period plan progress node, and generating an investment plan by combining the milestone progress plan; the investment plan is used for representing budget information set according to monthly degrees;
s3, acquiring contract data of the power grid infrastructure project, and generating a fund plan according to the payment time point and the contract payment proportion agreed in the contract data and the milestone progress plan; the fund plan is used for representing monthly predicted payment information;
s4, acquiring the site construction data of the power grid infrastructure project, and judging the current actual project progress of the power grid infrastructure project according to the site construction data; acquiring the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan; generating a progress dynamic monitoring condition according to the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan, and updating the milestone progress plan of the power grid infrastructure project;
s5, acquiring the actual investment situation in the power grid infrastructure project and comparing the actual investment situation with the investment plan; acquiring actual fund use conditions in a power grid infrastructure project, comparing the actual fund use conditions with a fund plan, and generating a dynamic cost monitoring condition according to a comparison result;
and S6, adjusting the investment plan and the fund plan according to the dynamic progress monitoring condition and the dynamic cost monitoring condition.
In the above technical solution, step S1 specifically includes the following steps:
constructing a milestone progress prediction model: setting reasonable construction periods, planned schedule nodes and relative completion time of power transmission and transformation projects of different types and volumes according to the regulations of 'national power grid power transmission and transformation project schedule management methods'; constructing a sample set and training a milestone progress prediction model through the sample set, wherein single sample information comprises the project type and the volume of the power transmission and transformation project input by the model, and the corresponding reasonable construction period, the planned progress node and the relative completion time of the power transmission and transformation project serving as a model training label; the milestone progress prediction model has the input of the project type and the volume of the newly-built power transmission and transformation project and the output of the milestone progress prediction model is the construction period, the progress node and the relative completion time of each process of the newly-built power transmission and transformation project;
acquiring the project type, the project size and the start time of the power grid infrastructure project according to the project data of the power grid infrastructure project, inputting the project type, the project size and the start time as a milestone progress prediction model which is trained, and outputting the construction period of the power grid infrastructure project and the corresponding construction period plan progress node and the relative completion time of each construction period plan progress node by the milestone progress prediction model; and arranging the construction period of each process of the power grid infrastructure project, the corresponding construction period planned progress node and the relative completion time of the construction period planned progress node of each process according to the month degree to form a milestone progress plan.
In the above technical solution, in step S2, the budget information set by month degree in the investment plan includes a construction monthly investment amount, an installation monthly investment amount, an equipment monthly investment amount, and other cost investment amounts, wherein:
building cost monthly investment amount is calculated as an approximate building cost monthly investment control coefficient/a monthly construction progress predicted value in a civil engineering stage;
the monthly investment of installation cost is the estimated installation cost and the investment control coefficient of installation cost/the predicted value of monthly construction progress in the equipment installation stage;
the equipment cost monthly investment amount is estimated to calculate equipment cost investment control coefficient/equipment arrival stage monthly construction progress predicted value;
the estimated construction cost refers to all required construction costs predicted according to the engineering data of the power grid infrastructure project, the estimated installation cost refers to all required installation costs predicted according to the engineering data of the power grid infrastructure project, and the estimated equipment cost refers to all required equipment costs predicted according to the engineering data of the power grid infrastructure project; the construction cost investment control coefficient refers to the proportion of the construction cost corresponding to a certain process in the milestone plan in the approximate calculation construction cost, and the monthly construction progress predicted value in the civil engineering stage refers to the number of months of the process corresponding to the certain process; the installation cost investment control coefficient refers to the proportion of installation cost corresponding to a certain process in the milestone plan in the approximate calculation installation cost, and the monthly construction progress predicted value in the equipment installation stage refers to the number of months of the process corresponding to the certain process; the equipment cost investment control coefficient refers to the proportion of equipment cost corresponding to a certain process in the milestone plan in the estimated equipment cost, and the monthly construction progress predicted value in the equipment arrival stage refers to the number of months of the process corresponding to the certain process;
other cost investment amounts are divided or counted once per month between planned start-up and production according to the characteristics of construction site expropriation and detail cost generation of the power grid infrastructure project;
the investment plan is used for representing the working procedures of the power grid infrastructure project executed in each month and corresponding monthly construction investment amount, monthly installation investment amount, monthly equipment investment amount and other expense investment amount.
In the above technical solution, in step S2, the project data of the power grid infrastructure project is input into the project cost prediction model, and the estimated construction cost, the estimated installation cost, and the estimated equipment cost are obtained through calculation; the construction cost investment control coefficient, the installation cost investment control coefficient and the equipment cost investment control coefficient corresponding to each process are manually set; and acquiring a civil engineering stage monthly construction progress predicted value, an equipment installation stage monthly construction progress predicted value, a debugging stage monthly construction progress predicted value and an equipment arrival stage monthly construction progress predicted value corresponding to each process through a milestone plan.
In the above technical solution, in step S3, a fund plan is generated according to the contract types corresponding to each process in the milestone plan, the payment proportion and payment time agreed in the contract templates corresponding to the contracts of different types, and the predicted contract amount; contract categories include equipment procurement fees, construction fees, installation fees, and other fees; the fund plan is used for representing the procedures of the power grid infrastructure project executed each month and the proportion and the amount of purchase fee, construction fee, installation fee and other fee payment agreed in the corresponding contract template.
In the above technical solution, in step S4, the power grid infrastructure project milestone progress plan is updated according to the monthly updated power grid infrastructure project progress reports.
In the technical scheme, in the step S4, the actual project milestone progress is obtained according to the video monitoring, the remote sensing image and the 3DGIS data of the construction site of the power grid infrastructure project; and updating the milestone schedule of the power grid infrastructure project.
In the above technical solution, in step S5, the dynamic cost monitoring condition is generated by the visual model software: firstly, acquiring actual investment condition data and fund use condition data, and inputting the actual investment condition data and the initial investment plan and fund plan into a visualization model in a form; the visual model automatically cleans data, identifies the data types of all columns and automatically establishes the corresponding relation among all forms; selecting absolute time, monthly condition of an investment plan, actual monthly condition of investment, monthly condition of a capital plan and actual monthly condition of capital use as display objects and setting a comparison mode; the visualization model automatically extracts data of the display object from the form and associates the data according to the comparison mode, so that the dynamic cost monitoring condition is output.
In the above technical solution, in step S6, different time points are selected, where the time point before is the actually occurring schedule and cost, and the time point after is the planned schedule and cost; and (3) according to the dynamic cost monitoring condition and the dynamic progress monitoring condition, recomposing an investment plan and a fund plan based on the updated milestone progress plan of the power grid infrastructure project: according to the actual occurrence of the subentry contract cost and the actual occurrence of the construction progress, monthly investment plan adjustment is carried out, and annual investment plan adjustment is summarized; according to the payment condition and payment time sequence of the contract project which is not paid or is not executed, monthly fund plan adjustment is carried out, and the execution condition of annual fund plan is summarized
The invention has the beneficial effects that: constructing a milestone progress plan by an artificial intelligence prediction analysis technology; reasonably predicting a power grid infrastructure project investment plan and a capital plan including the itemized cost and the construction progress by combining the milestone progress plan progress information; meanwhile, a monthly investment plan and a capital plan are cooperatively worked out based on the project progress, and an annual investment plan and a capital plan are scientifically calculated. By tracking the construction progress of the capital construction project, the dynamic monitoring and adjustment are carried out on the project investment plan and the fund plan with the great difference between the actual completion situation and the milestone plan according to the actual execution situation, the dynamic deviation correction of the project investment plan and the fund plan is realized, and the timely data support is provided for the investment plan management and the fund budget management.
Drawings
FIG. 1 is a schematic flow diagram of the present invention;
FIG. 2 is a Power BI initial interface for an embodiment;
FIG. 3 is a source data form of an embodiment;
FIG. 4 is a diagram of model import data, according to an embodiment;
FIG. 5 is a schematic diagram of data processing according to an embodiment;
FIG. 6 is a schematic diagram of data modeling according to an embodiment;
FIG. 7 is a diagram of a visualization pane of a particular embodiment;
FIG. 8 is a field selection diagram of an embodiment;
FIG. 9 is a schematic illustration of investment plan monitoring according to an embodiment;
FIG. 10 is a schematic view of a dynamic cost monitoring scenario according to an embodiment;
FIG. 11 is a schematic view of a dynamic cost monitoring scenario according to an embodiment.
Detailed Description
The invention will be further described in detail with reference to the following drawings and specific examples, which are not intended to limit the invention, but are for clear understanding.
As shown in fig. 1, the invention relates to a method for monitoring the collaborative execution of an investment plan and a capital plan of a power grid infrastructure project, which is characterized in that: the method comprises the following steps:
s1, acquiring construction periods of the power grid infrastructure projects and corresponding construction period plan progress nodes and relative completion time of each construction period plan progress node according to the engineering data of the power grid infrastructure projects, and generating milestone progress plans; the milestone progress plan is used for representing project progress set according to monthly degrees;
s2, calculating the cost generated by each construction period plan progress node, and generating an investment plan by combining the milestone progress plan; the investment plan is used for representing budget information set according to monthly degrees;
s3, acquiring contract data of the power grid infrastructure project, and generating a fund plan according to the payment time point and the contract payment proportion agreed in the contract data and the milestone progress plan; the fund plan is used for representing monthly predicted payment information;
s4, acquiring the site construction data of the power grid infrastructure project, and judging the current actual project progress of the power grid infrastructure project according to the site construction data; acquiring the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan; generating a progress dynamic monitoring condition according to the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan;
s5, acquiring the actual investment situation in the power grid infrastructure project and comparing the actual investment situation with the investment plan; acquiring actual fund use conditions in a power grid infrastructure project, comparing the actual fund use conditions with a fund plan, and generating a dynamic cost monitoring condition according to a comparison result;
and S6, adjusting the investment plan and the fund plan according to the dynamic progress monitoring condition and the dynamic cost monitoring condition.
The step S1 specifically includes the following steps:
constructing a milestone progress prediction model: setting reasonable construction periods, planned schedule nodes and relative completion time of power transmission and transformation projects of different types and volumes according to the regulations of 'national power grid power transmission and transformation project schedule management methods'; constructing a sample set and training a milestone progress prediction model through the sample set, wherein single sample information comprises the project type and the volume of the power transmission and transformation project input by the model, and the corresponding reasonable construction period, the planned progress node and the relative completion time of the power transmission and transformation project serving as a model training label; the milestone progress prediction model has the input of the project type and the volume of the newly-built power transmission and transformation project and the output of the milestone progress prediction model is the construction period, the progress node and the relative completion time of each process of the newly-built power transmission and transformation project;
acquiring the project type, the project size and the start time of the power grid infrastructure project according to the project data of the power grid infrastructure project, inputting the project type, the project size and the start time as a milestone progress prediction model which is trained, and outputting the construction period of the power grid infrastructure project and the corresponding construction period plan progress node and the relative completion time of each construction period plan progress node by the milestone progress prediction model; and arranging the construction period of each process of the power grid infrastructure project, the corresponding construction period planned progress node and the relative completion time of the construction period planned progress node of each process according to the month degree to form a milestone progress plan.
The milestone schedule planning should fully consider the working time and progress condition in the early stage of the project, strictly follow the basic construction program and reasonably make the scheduled start time. The schedule mainly comprises the following important node time information: the previous stage of the project can be researched and approved, and the environment can be assessed (if necessary), and the water can be protected (if necessary); design and supervision bidding at the early stage of engineering, primary design approval, first material bidding, construction bidding, fire design auditing (or filing), and the like; the method comprises the steps of starting up, building (foundation), installing (tower assembling), debugging (stringing), fire control acceptance, environment protection acceptance (as required), water conservation acceptance (as required), production and the like in the engineering construction stage.
The reasonable construction period of the power transmission and transformation project construction is scientifically and reasonably formulated by combining the factors such as voltage grade, climate conditions, process requirements, external environment, equipment supply and the like. Reasonable construction period of conventional new construction: 110(66) kilovolt project 10-13 months, 220, 330 kilovolt project 13-16 months, 500 kilovolt project 15-18 months, 750 kilovolt project 16-19 months. The annual daily average temperature is lower than 5 ℃ in the area with more than 90 days, and the construction period can be correspondingly increased by 3 months. For construction projects exceeding the planned construction period, the capital construction management departments of all levels of units need to strengthen warning supervision, and projects exceeding a certain time limit are regarded as projects with overlong construction periods.
Firstly, according to a conventional newly-built power transmission and transformation project reasonable construction period specified by a state network, inputting the start time through a milestone progress prediction model to form the completion time and completion time of each progress node, and considering certain factors which can increase the influence on the construction period: each item can be adjusted according to actual conditions. The project milestone plan of the 220kV newly-built substation is shown in the table 1.
Figure BDA0003351733500000081
Figure BDA0003351733500000091
In the step S2, based on the construction progress prediction, the conversion relationship between the physical quantity and the value quantity is considered, four costs are distinguished, and a newly-opened project investment completion prediction model is constructed. The budget information set by month degree in the investment plan comprises a construction monthly investment amount, an installation monthly investment amount, an equipment monthly investment amount and other cost investment amounts, wherein:
building cost monthly investment amount is calculated as an approximate building cost monthly investment control coefficient/a monthly construction progress predicted value in a civil engineering stage;
the monthly investment of installation cost is the estimated installation cost and the investment control coefficient of installation cost/the predicted value of monthly construction progress in the equipment installation stage;
the equipment cost monthly investment amount is estimated to calculate equipment cost investment control coefficient/equipment arrival stage monthly construction progress predicted value;
the estimated construction cost refers to all required construction costs predicted according to the engineering data of the power grid infrastructure project, the estimated installation cost refers to all required installation costs predicted according to the engineering data of the power grid infrastructure project, and the estimated equipment cost refers to all required equipment costs predicted according to the engineering data of the power grid infrastructure project; the construction cost investment control coefficient refers to the proportion of the construction cost corresponding to a certain process in the milestone plan in the approximate calculation construction cost, and the monthly construction progress predicted value in the civil engineering stage refers to the number of months of the process corresponding to the certain process; the installation cost investment control coefficient refers to the proportion of installation cost corresponding to a certain process in the milestone plan in the approximate calculation installation cost, and the monthly construction progress predicted value in the equipment installation stage refers to the number of months of the process corresponding to the certain process; the equipment cost investment control coefficient refers to the proportion of equipment cost corresponding to a certain process in the milestone plan in the estimated equipment cost, and the monthly construction progress predicted value in the equipment arrival stage refers to the number of months of the process corresponding to the certain process;
other cost investment amounts are divided or counted once per month between planned start-up and production according to the characteristics of construction site expropriation and detail cost generation of the power grid infrastructure project;
the investment plan is used for representing the working procedures of the power grid infrastructure project executed in each month and corresponding monthly construction investment amount, monthly installation investment amount, monthly equipment investment amount and other expense investment amount.
In step S2, an investment plan compiling module is adopted to input the project data of the power grid infrastructure project into a project cost forecasting model, and the approximate calculation building cost, the approximate calculation installation cost and the approximate calculation equipment cost are obtained through calculation; the construction cost investment control coefficient, the installation cost investment control coefficient and the equipment cost investment control coefficient corresponding to each process are manually set; the investment plan compiling module obtains a civil engineering stage monthly construction progress predicted value, an equipment installation stage monthly construction progress predicted value, a debugging stage monthly construction progress predicted value and an equipment arrival stage monthly construction progress predicted value corresponding to each process through the milestone plan, and then calculates and obtains an investment plan and outputs the investment plan based on the approximate calculation building cost, the approximate calculation installation cost, the approximate calculation equipment cost, the building cost investment control coefficient, the installation cost investment control coefficient and the equipment cost investment control coefficient corresponding to each process.
And (4) calculating investment according to the project initial setting, and decomposing the plan expense table according to the detail of equipment expense, building expense, installation expense and other expenses. The decomposition of the estimated cost of the project of the 220kV newly-built substation is shown in the table 2.
Table 2220 kV newly-built substation engineering approximate calculation cost decomposition
Figure BDA0003351733500000101
Figure BDA0003351733500000111
In order to strengthen the consideration of the relevant factors of other professions, realize the forecast and the compilation of the monthly investment plan of the project, improve the compilation depth of the investment plan, and arrange the project milestone plan progress by the milestone progress forecasting model according to the factors of the project construction property, the construction process, the material purchase and the like. And (4) constructing a project monthly investment plan by reasonably predicting the construction investment itemized cost and the construction (monthly) progress. And (4) making an investment plan according to the project investment and the milestone planned progress. The investment plan of the 220kV newly-built substation is shown in Table 3.
Table 3220 kV newly-built substation project investment plan
Figure BDA0003351733500000112
Figure BDA0003351733500000121
In step S3, a fund plan is generated based on the contract types corresponding to the respective processes in the milestone plan, the payment ratios and payment time points agreed in the contract templates corresponding to the different types of contracts, and the predicted contract amount; contract categories include equipment procurement fees, construction fees, installation fees, and other fees. And the fund plan compiling module calculates and outputs the fund plan according to the input milestone plan and contract template capturing required time node data, project types and appointed amount data. The fund plan is used for representing the procedures of the power grid infrastructure project executed each month and the proportion and the amount of purchase fee, construction fee, installation fee and other fee payment agreed in the corresponding contract template. The capital plan for the 220kV new substation is shown in table 4.
Capital plan of new substation with 4220 kV meter
Figure BDA0003351733500000122
Figure BDA0003351733500000131
Figure BDA0003351733500000141
In step S4, the actual project milestone schedule is obtained according to the monthly updated power grid infrastructure project schedule or according to the video monitoring, remote sensing images and 3DGIS data of the power grid infrastructure project construction site, and the power grid infrastructure project milestone schedule is updated. And if the actual project milestone progress is delayed, the initial power grid infrastructure project milestone progress plan is continued to form an updated power grid infrastructure project milestone progress plan. On the contrary, if the actual project milestone progress is advanced, an updated power grid infrastructure project milestone progress plan is formed according to the actual advanced progress and the initial power grid infrastructure project milestone progress plan.
And monitoring the construction period condition of the project according to the programming time point and the 10 th month of 2021 year. The monitoring conditions are shown in table 5.
Meter 5220 kV newly-built substation engineering milestone plan and actual progress
Figure BDA0003351733500000142
Figure BDA0003351733500000151
The 220kV transformer substation project is started in 2021 at 6 months, the monitoring time point is 10 months in 2021, and the progress of the current project is found to be approximately consistent with the planned progress through the auxiliary monitoring of a field progress model in the monitoring time. At present, the construction progress node is constructed in civil engineering for about 4 months. In 10 months 2021, the contracts of the construction and the equipment of the project are tendered, the initial setting of the project is roughly 9659 ten thousand yuan, and the contract cost is 8500 ten thousand yuan. The contract fee breakdown table and the payment conditions are shown in table 6.
TABLE 6 item contract fee decomposition and Payment Condition
Figure BDA0003351733500000152
Figure BDA0003351733500000161
The project contract cost is compared to the approximated cost with an investment balance of about 12%.
In step S5, the dynamic charge monitoring condition is generated by the visualization model software: firstly, acquiring actual investment condition data and fund use condition data, and inputting the actual investment condition data and the initial investment plan and fund plan into a visualization model in a form; the visual model automatically cleans data, identifies the data types of all columns and automatically establishes the corresponding relation among all forms; selecting absolute time, monthly condition of an investment plan, actual monthly condition of investment, monthly condition of a capital plan and actual monthly condition of capital use as display objects and setting a comparison mode; the visualization model automatically extracts data of the display object from the form and associates the data according to the comparison mode, so that the dynamic cost monitoring condition is output.
In this embodiment, Power BI is used as the visualization model software and as the processing tool for dynamic monitoring visualization.
The method comprises the steps of utilizing Power BI to conduct visualization model making, firstly, needing to import corresponding data information, and enabling the Power BI to support data source import of multiple forms such as Excel, SOL server, text/CSV and Web. After the original data is imported, the Power BI can utilize a Query editor (Power Query) embedded in the Power BI to perform data processing and cleaning on the original data, and a user can perform self-defined setting in the process according to the self requirement. After the data processing is finished, the processed data table is formally imported into the Power BI, the Power BI also automatically generates the corresponding relation between the table and the table, and the step is also modeling. After that, the user can select visual objects of various visualizations such as stacking bar graphs, partition graphs, card graphs and matrixes and specify data fields to be displayed, and the Power BI automatically extracts data from the imported data source table and associates the data to form a visualization model.
The specific embodiment takes a generation process of a cost dynamic monitoring condition of a certain 220kV substation as an example for explanation:
(1) power BI is opened as shown in FIG. 2.
(2) Inputting initial investment plan and fund plan compiling data of a certain 220kV transformer substation and investment and fund condition data of a monitoring point of the certain 220kV transformer substation. The data information is shown in fig. 3.
(3) After the original data is imported as shown in fig. 4, the Power BI can automatically clean the data to ensure that the imported data file is correct and usable, and can automatically identify each column of data categories to facilitate subsequent data modeling. As shown in FIG. 5, Power BI automatically identifies a column of data format for filling in dates as "dates" and a column of data format for filling in investment proportions as "percentages".
(4) After the data processing is completed, the data table will be automatically imported into Power BI, and the corresponding relationship between the tables is automatically established, as shown in fig. 6. This step is the key to achieving the dynamic effect of the Power BI visualization model.
(5) After all the steps are finished, the visual model can be built. Firstly, a proper visual object is selected in a visualization pane, and a partition map and a line map are mainly selected as the visual object to be modeled.
(6) After selecting the desired visualization object, the data field desired to be presented can be selected in the "fields" column, as shown in FIG. 7. As shown in fig. 8, the absolute time, the monthly condition of the investment planning, and the monitored actual monthly condition of the investment are selected as display contents. The Power BI will automatically extract data from the imported data source table and associate the data to form a visualization model, as shown in FIG. 9. Performing the relevant operations as described above may form a dynamic monitoring situation for the cost, for example, for a certain 220kV substation, as shown in fig. 10.
In this embodiment, only one monitoring point, i.e., 10 months in 2021, is selected for comparison and display, and for data having a plurality of monitoring points, the data import and field selection may be performed according to the steps described in (2) and (5) above. And because the Power BI can automatically generate the corresponding relation between the tables, the finally formed report can be subjected to detailed data query by clicking related data points. As shown in fig. 11, an effect diagram for querying data information of 7 months 2021 is shown.
In step S6, selecting different time points, wherein the time points before are actual progress and cost, and the time points after are planned progress and cost; and according to the dynamic cost monitoring condition and the dynamic progress monitoring condition, recomposing an investment plan and a fund plan based on the updated milestone progress plan of the power grid infrastructure project. The method of recomposing the investment and fund plans and the method of steps S2 and S3. And acquiring the residual construction plan content according to the actually generated subentry contract cost and the actual construction progress, decomposing the content according to the investment cost, respectively calculating the investment cost which is possibly generated every month, carrying out monthly investment plan adjustment, and summarizing annual investment plan adjustment. And respectively calculating the amount of the contractual payment which can be generated every month according to the payment condition and the payment time sequence of the contractual item which is not paid or executed, adjusting the monthly fund plan, and summarizing the execution condition of the annual fund plan.
Selecting 10 months in 2021 as a time point, distinguishing four expenses based on the actual progress of the project and the investment cost schedule, namely an original investment plan, and considering the conversion relation between the physical quantity and the value quantity, and constructing an investment plan execution condition dynamic monitoring model, wherein the investment plan execution condition dynamic monitoring model is used for reflecting the investment plan adjusted in real time based on the current construction progress, and is shown in table 7.
Dynamic monitoring model for project investment plan of meter 7220 kV newly-built substation
Figure BDA0003351733500000181
Figure BDA0003351733500000191
And obtaining a capital planning model of the new start project according to payment conditions and payment time sequences of different types of projects based on time nodes in monthly investment planning results in the upgraded power grid infrastructure project investment planning module, as shown in table 8.
Table 8220 kV newly-built transformer substation engineering fund plan collaborative dynamic monitoring model
Figure BDA0003351733500000192
Figure BDA0003351733500000201
The dynamic monitoring model of the investment plan and the fund plan execution condition is dynamically changed and can be adjusted in real time. According to the different selected time points, the actual occurring schedule and cost before the time point and the plan schedule and cost after the time point can be selected by investment planning personnel according to the requirement to carry out planning.
Those not described in detail in this specification are within the skill of the art.

Claims (9)

1. A method for monitoring the collaborative execution condition of an investment plan and a capital plan of a power grid infrastructure project is characterized by comprising the following steps: the method comprises the following steps:
s1, acquiring construction periods of the power grid infrastructure projects and corresponding construction period plan progress nodes and relative completion time of each construction period plan progress node according to the engineering data of the power grid infrastructure projects, and generating milestone progress plans; the milestone progress plan is used for representing project progress set according to monthly degrees;
s2, calculating the cost generated by each construction period plan progress node, and generating an investment plan by combining the milestone progress plan; the investment plan is used for representing budget information set according to monthly degrees;
s3, acquiring contract data of the power grid infrastructure project, and generating a fund plan according to the payment time point and the contract payment proportion agreed in the contract data and the milestone progress plan; the fund plan is used for representing monthly predicted payment information;
s4, acquiring the site construction data of the power grid infrastructure project, and judging the current actual project progress of the power grid infrastructure project according to the site construction data; acquiring the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan; generating a progress dynamic monitoring condition according to the deviation of the actual project progress of the power grid infrastructure project and the milestone progress plan, and updating the milestone progress plan of the power grid infrastructure project;
s5, acquiring the actual investment situation in the power grid infrastructure project and comparing the actual investment situation with the investment plan; acquiring actual fund use conditions in a power grid infrastructure project, comparing the actual fund use conditions with a fund plan, and generating a dynamic cost monitoring condition according to a comparison result;
and S6, adjusting the investment plan and the fund plan according to the dynamic progress monitoring condition and the dynamic cost monitoring condition.
2. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 1, wherein: step S1 specifically includes the following steps:
constructing a milestone progress prediction model: setting reasonable construction periods, planned schedule nodes and relative completion time of power transmission and transformation projects of different types and volumes according to the regulations of 'national power grid power transmission and transformation project schedule management methods'; constructing a sample set and training a milestone progress prediction model through the sample set, wherein single sample information comprises the project type and the volume of the power transmission and transformation project input by the model, and the corresponding reasonable construction period, the planned progress node and the relative completion time of the power transmission and transformation project serving as a model training label; the milestone progress prediction model has the input of the project type and the volume of the newly-built power transmission and transformation project and the output of the milestone progress prediction model is the construction period, the progress node and the relative completion time of each process of the newly-built power transmission and transformation project;
acquiring the project type, the project size and the start time of the power grid infrastructure project according to the project data of the power grid infrastructure project, inputting the project type, the project size and the start time as a milestone progress prediction model which is trained, and outputting the construction period of the power grid infrastructure project and the corresponding construction period plan progress node and the relative completion time of each construction period plan progress node by the milestone progress prediction model; and arranging the construction period of each process of the power grid infrastructure project, the corresponding construction period planned progress node and the relative completion time of the construction period planned progress node of each process according to the month degree to form a milestone progress plan.
3. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 2, wherein: in step S2, the budget information set by month in the investment plan includes the construction fee-month investment amount, the installation fee-month investment amount, the equipment month fee-month investment amount, and other fee investment amounts, wherein:
building cost monthly investment amount is calculated as an approximate building cost monthly investment control coefficient/a monthly construction progress predicted value in a civil engineering stage;
the monthly investment of installation cost is the estimated installation cost and the investment control coefficient of installation cost/the predicted value of monthly construction progress in the equipment installation stage;
the equipment cost monthly investment amount is estimated to calculate equipment cost investment control coefficient/equipment arrival stage monthly construction progress predicted value;
the estimated construction cost refers to all required construction costs predicted according to the engineering data of the power grid infrastructure project, the estimated installation cost refers to all required installation costs predicted according to the engineering data of the power grid infrastructure project, and the estimated equipment cost refers to all required equipment costs predicted according to the engineering data of the power grid infrastructure project; the construction cost investment control coefficient refers to the proportion of the construction cost corresponding to a certain process in the milestone plan in the approximate calculation construction cost, and the monthly construction progress predicted value in the civil engineering stage refers to the number of months of the process corresponding to the certain process; the installation cost investment control coefficient refers to the proportion of installation cost corresponding to a certain process in the milestone plan in the approximate calculation installation cost, and the monthly construction progress predicted value in the equipment installation stage refers to the number of months of the process corresponding to the certain process; the equipment cost investment control coefficient refers to the proportion of equipment cost corresponding to a certain process in the milestone plan in the estimated equipment cost, and the monthly construction progress predicted value in the equipment arrival stage refers to the number of months of the process corresponding to the certain process;
other cost investment amounts are divided or counted once per month between planned start-up and production according to the characteristics of construction site expropriation and detail cost generation of the power grid infrastructure project;
the investment plan is used for representing the working procedures of the power grid infrastructure project executed in each month and corresponding monthly construction investment amount, monthly installation investment amount, monthly equipment investment amount and other expense investment amount.
4. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 3, wherein: step S2, inputting the project data of the power grid infrastructure project into a project cost prediction model, and calculating to obtain an approximate calculation building cost, an approximate calculation installation cost and an approximate calculation equipment cost; the construction cost investment control coefficient, the installation cost investment control coefficient and the equipment cost investment control coefficient corresponding to each process are manually set; and acquiring a civil engineering stage monthly construction progress predicted value, an equipment installation stage monthly construction progress predicted value, a debugging stage monthly construction progress predicted value and an equipment arrival stage monthly construction progress predicted value corresponding to each process through a milestone plan.
5. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 2, wherein: in step S3, a fund plan is generated according to the contract types corresponding to the respective processes in the milestone plan, the payment ratios and payment time agreed in the contract templates corresponding to the contracts of different types, and the predicted contract amount; contract categories include equipment procurement fees, construction fees, installation fees, and other fees; the fund plan is used for representing the procedures of the power grid infrastructure project executed each month and the proportion and the amount of purchase fee, construction fee, installation fee and other fee payment agreed in the corresponding contract template.
6. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 2, wherein: in step S4, the power grid infrastructure project milestone schedule is updated according to the monthly updated power grid infrastructure project schedule.
7. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 2, wherein: in the step S4, acquiring actual project milestone progress according to video monitoring, remote sensing images and 3DGIS data of a power grid infrastructure project construction site; and updating the milestone schedule of the power grid infrastructure project.
8. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 1, wherein: in step S5, the dynamic charge monitoring condition is generated by the visualization model software: firstly, acquiring actual investment condition data and fund use condition data, and inputting the actual investment condition data and the initial investment plan and fund plan into a visualization model in a form; the visual model automatically cleans data, identifies the data types of all columns and automatically establishes the corresponding relation among all forms; selecting absolute time, monthly condition of an investment plan, actual monthly condition of investment, monthly condition of a capital plan and actual monthly condition of capital use as display objects and setting a comparison mode; the visualization model automatically extracts data of the display object from the form and associates the data according to the comparison mode, so that the dynamic cost monitoring condition is output.
9. The method for monitoring the collaborative execution of the power grid infrastructure project investment plan and the capital plan according to claim 8, wherein: in step S6, selecting different time points, wherein the time points before are actual progress and cost, and the time points after are planned progress and cost; and (3) according to the dynamic cost monitoring condition and the dynamic progress monitoring condition, recomposing an investment plan and a fund plan based on the updated milestone progress plan of the power grid infrastructure project: according to the actual occurrence of the subentry contract cost and the actual occurrence of the construction progress, monthly investment plan adjustment is carried out, and annual investment plan adjustment is summarized; according to the payment condition and the payment time sequence of the contract items which are not paid or are not executed, monthly fund plan adjustment is carried out, and the execution condition of the annual fund plan is summarized.
CN202111340534.5A 2021-11-12 2021-11-12 Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project Pending CN114240044A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202111340534.5A CN114240044A (en) 2021-11-12 2021-11-12 Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202111340534.5A CN114240044A (en) 2021-11-12 2021-11-12 Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project

Publications (1)

Publication Number Publication Date
CN114240044A true CN114240044A (en) 2022-03-25

Family

ID=80749432

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202111340534.5A Pending CN114240044A (en) 2021-11-12 2021-11-12 Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project

Country Status (1)

Country Link
CN (1) CN114240044A (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115600992A (en) * 2022-11-09 2023-01-13 江苏海纳宝川智能科技有限公司(Cn) Project management method based on prediction algorithm
CN116071023A (en) * 2023-02-24 2023-05-05 中国水利水电第三工程局有限公司 Project performance management method and system
CN116739530A (en) * 2023-08-08 2023-09-12 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials
CN117689475A (en) * 2023-12-27 2024-03-12 北汽蓝谷信息技术有限公司 Digital management and control system method and system for equity investment business
CN117892951A (en) * 2024-01-10 2024-04-16 重庆信科通信建设监理咨询有限公司 Engineering investment control method, computer equipment and storage medium

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN115600992A (en) * 2022-11-09 2023-01-13 江苏海纳宝川智能科技有限公司(Cn) Project management method based on prediction algorithm
CN116071023A (en) * 2023-02-24 2023-05-05 中国水利水电第三工程局有限公司 Project performance management method and system
CN116739530A (en) * 2023-08-08 2023-09-12 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials
CN116739530B (en) * 2023-08-08 2023-12-29 国网浙江省电力有限公司宁波供电公司 Intelligent settlement method and settlement device for power grid materials
CN117689475A (en) * 2023-12-27 2024-03-12 北汽蓝谷信息技术有限公司 Digital management and control system method and system for equity investment business
CN117892951A (en) * 2024-01-10 2024-04-16 重庆信科通信建设监理咨询有限公司 Engineering investment control method, computer equipment and storage medium

Similar Documents

Publication Publication Date Title
CN114240044A (en) Method for monitoring collaborative execution condition of investment plan and capital plan of power grid infrastructure project
Li et al. How to peak carbon emissions of provincial construction industry? Scenario analysis of Jiangsu Province
Conejo et al. Investment in electricity generation and transmission
Bakirtzis et al. Generation expansion planning by MILP considering mid-term scheduling decisions
Lee Cost-benefit analysis, LCOE and evaluation of financial feasibility of full commercialization of biohydrogen
Lee et al. Enhancing renewable and sustainable energy development based on an options-based policy evaluation framework: Case study of wind energy technology in Taiwan
CN115329448B (en) BIM-based fabricated building construction cost control method and system
Gjorgiev et al. Nexus-e: A platform of interfaced high-resolution models for energy-economic assessments of future electricity systems
CN110942204A (en) New power grid capital construction project annual planning model construction method and system
CN107909280A (en) A kind of electricity power engineering managing and control system and its control method based on bill of quantities
CN113837730B (en) Three-rate-in-one-based multidimensional collaborative management and control system for project of main grid of power grid infrastructure
CN110991985A (en) Project progress data processing method
Qi et al. The China-in-global energy model
Siniak et al. Building information modeling for housing renovation-example for ukraine
CN104112174A (en) Project regulating and controlling method and system of nuclear power plant
Yan et al. Dynamic control of integrated project management system based on engineering projects
Klemm et al. Optimization of Sustainable Urban Energy Systems: Model Development and Application
Katz et al. Variable renewable energy grid integration studies: A guidebook for practitioners
CN113935646A (en) Management and control method and management and control system for power grid operation and inspection project
Balasubramanian et al. Techno-economic evaluation methodology for hydrogen energy systems
Guerra-Fernandez et al. Electric power grid and natural gas network operations and coordination
Schlenzig et al. MESAP-III: An information and decision support system for energy and environmental planning
Mauritzen et al. Increasing or diversifying risk? Tail correlations, transmission flows and prices across wind power areas
Wang Problems in the Whole Process of Management and Control of Construction Cost and Cost Management Strategies
Zhang et al. Exploring the construction of an all-round cost management system for investment control in university engineering construction

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