CN113947273A - Multi-path distribution network cost accounting system based on big data - Google Patents

Multi-path distribution network cost accounting system based on big data Download PDF

Info

Publication number
CN113947273A
CN113947273A CN202110557936.4A CN202110557936A CN113947273A CN 113947273 A CN113947273 A CN 113947273A CN 202110557936 A CN202110557936 A CN 202110557936A CN 113947273 A CN113947273 A CN 113947273A
Authority
CN
China
Prior art keywords
cost
module
output end
data
input end
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
CN202110557936.4A
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 Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
Hengshui Power Supply Co of State Grid Hebei Electric Power Co Ltd
Original Assignee
State Grid Corp of China SGCC
State Grid Hebei Electric Power Co Ltd
Hengshui Power Supply Co of State Grid Hebei 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 Corp of China SGCC, State Grid Hebei Electric Power Co Ltd, Hengshui Power Supply Co of State Grid Hebei Electric Power Co Ltd filed Critical State Grid Corp of China SGCC
Priority to CN202110557936.4A priority Critical patent/CN113947273A/en
Publication of CN113947273A publication Critical patent/CN113947273A/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/0637Strategic management or analysis, e.g. setting a goal or target of an organisation; Planning actions based on goals; Analysis or evaluation of effectiveness of goals
    • 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
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • 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
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0202Market predictions or forecasting for commercial activities
    • 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
    • G06Q30/00Commerce
    • G06Q30/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0201Market modelling; Market analysis; Collecting market data
    • G06Q30/0206Price or cost determination based on market factors
    • 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/06Asset management; Financial planning or analysis
    • 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/00Systems or methods specially adapted for specific business sectors, e.g. utilities or tourism
    • G06Q50/06Electricity, gas or water supply

Abstract

The invention discloses a cost accounting system of a multi-path distribution network based on big data, which comprises the cost accounting system, wherein the cost accounting system comprises a central processing unit, the output end of the central processing unit is electrically connected with the input end of a communication module, the input end of the central processing unit is electrically connected with the output end of the communication module, the output end of the communication module is in signal connection with the input end of a big data analysis platform, and the input end of the communication module is in signal connection with the output end of the big data analysis platform. According to the multi-path distribution network cost accounting system based on the big data, through the arrangement of the big data analysis platform and the data analysis module, project cost data of the same type of distribution network can be obtained through the big data analysis platform, then the project cost data is compared and analyzed with the project cost data, and finally cost accounting is carried out through the cost accounting module, so that timely and effective management and decision making can be conveniently carried out on the cost accounting process.

Description

Multi-path distribution network cost accounting system based on big data
Technical Field
The invention relates to the technical field of distribution network cost accounting, in particular to a multi-path distribution network cost accounting system based on big data.
Background
Big data, a term that refers to large or complex data sets for which traditional data processing applications are inadequate to handle; given the same total data size, the subsequent analysis of each small data set yields much additional information and data relationships than if the individual small data sets were analyzed individually.
At present, the cost accounting of the construction of the distribution network is carried out by manually controlling by using electronic forms, the cost control in the real sense cannot be realized by the mode, because many bugs exist in the link of manual operation, and the cost accounting of the distribution network needs more data support.
Disclosure of Invention
Technical problem to be solved
Aiming at the defects of the prior art, the invention provides a big data-based multi-path distribution network cost accounting system.
(II) technical scheme
In order to achieve the purpose, the invention provides the following technical scheme: a cost accounting system of a multi-path distribution network based on big data comprises a cost accounting system, wherein the cost accounting system comprises a central processing unit, the output end of the central processing unit is electrically connected with the input end of a communication module, the input end of the central processing unit is electrically connected with the output end of the communication module, the output end of the communication module is in signal connection with the input end of a big data analysis platform, the input end of the communication module is in signal connection with the output end of the big data analysis platform, the input end of the big data analysis platform is in signal connection with the output end of a local area similar distribution network project database, the input end of the big data analysis platform is in signal connection with the output end of a domestic and foreign similar distribution network project database, the output end of the central processing unit is electrically connected with the input end of a display module, and the output end of the central processing unit is electrically connected with the input end of a storage module, the input end of the central processing unit is electrically connected with the output end of the storage module. .
Preferably, the input end of the central processing unit is electrically connected with the output end of the parameter information input module.
Preferably, the output end of the central processing unit is electrically connected with the input end of the cost accounting module, and the input end of the central processing unit is electrically connected with the output end of the cost accounting module.
Preferably, the input end of the central processing unit is electrically connected with the output end of the data analysis module, and the output end of the central processing unit is electrically connected with the input end of the data analysis module.
Preferably, the input end of the data analysis module is electrically connected with the output end of the data acquisition unit, and the input end of the cost accounting system is electrically connected with the output end of the power module.
Preferably, the data acquisition unit comprises an investment period cost statistic module, an operation and maintenance cost statistic module and a scrapping period cost statistic module.
Preferably, the investment period cost statistic module is used for carrying out statistic calculation on one-time investment expenses in each early period of design, equipment purchase, construction and the like.
Preferably, the operation and maintenance and overhaul cost statistic module is used for calculating material cost, construction cost, labor cost and the like involved in distribution network inspection, overhaul, technical improvement and overhaul and equipment fault maintenance work, and meanwhile, the operation and maintenance and overhaul cost statistic module also comprises the power selling profit loss caused by power failure and indirect loss brought to social production life.
Preferably, the scrapping period cost statistic module is used for carrying out statistic calculation on the net value and the disassembly cost of the scrapped asset.
Preferably, the algorithm in the cost accounting module is
Figure 100002_DEST_PATH_IMAGE002
Wherein CI is the cost of the input period, CM is the cost of operation and maintenance, and CD is the cost of the abandonment period.
(III) advantageous effects
Compared with the prior art, the invention provides a multi-path distribution network cost accounting system based on big data, which has the following beneficial effects:
according to the multi-path distribution network cost accounting system based on the big data, through the arrangement of the big data analysis platform and the data analysis module, project cost data of the same type of distribution network can be obtained through the big data analysis platform, then the project cost data is compared and analyzed with the project cost data, and finally cost accounting is carried out through the cost accounting module, so that timely and effective management and decision making can be conveniently carried out on the cost accounting process.
Drawings
FIG. 1 is a schematic diagram of the system of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, a cost accounting system of a multi-path distribution network based on big data comprises a cost accounting system, the cost accounting system comprises a central processing unit, an output end of the central processing unit is electrically connected with an input end of a communication module, an input end of the central processing unit is electrically connected with an output end of the communication module, an output end of the communication module is in signal connection with an input end of a big data analysis platform, an input end of the communication module is in signal connection with an output end of a big data analysis platform, an input end of the big data analysis platform is in signal connection with an output end of a local area homogeneous distribution network project database, an input end of the big data analysis platform is in signal connection with an output end of a domestic and foreign homogeneous distribution network project database, an output end of the central processing unit is electrically connected with an input end of a display module, an output end of the central processing unit is electrically connected with an input end of a storage module, an input end of the central processing unit is electrically connected with an output end of the storage module, the input end of the central processing unit is electrically connected with the output end of the parameter information input module, the output end of the central processing unit is electrically connected with the input end of the cost accounting module, the input end of the central processing unit is electrically connected with the output end of the cost accounting module, and the algorithm in the cost accounting module is
Figure DEST_PATH_IMAGE002A
Wherein CI is the cost of input period, CM is the maintenance cost of operation, CD is the cost of abandonment period, central processing unit's input is connected with data analysis module's output electricity, central processing unit's output is connected with data analysis module's input electricity, data analysis module's input is connected with data acquisition unit's output electricity, data acquisition unit includes input period cost statistics module, operation maintenance cost statistics module and abandonment period cost statistics module, input period cost statistics module is for designing, each prophase disposable input class expense such as equipment purchase and construction is counted and calculated, operation maintenance cost statistics module is for joining in marriage net tour, overhaul, technical improvement overhaul, the material cost that involves in the equipment trouble repair work, overhaul work is carried out to the netThe system comprises a power supply module, a scrapping period cost counting module, a cost accounting system and a power supply module, wherein the power supply module is used for carrying out statistics and calculation on net value and disassembly cost of scrapped assets;
in the cost accounting, personnel need to predict the electricity sales, so as to make reference for the cost accounting of the personnel, the electricity sales prediction analysis is an important market prediction technical means for managing the electricity demand side, the accurate electricity sales prediction is beneficial to a company to make an effective operation plan, whether the electricity sales can be accurately predicted or not is greatly influenced on the annual operation management and the annual economic benefit of the electric power company, the electricity sales data is influenced by factors such as temperature and GDP (general data processing), especially high-temperature weather, in order to analyze the normal trend change rule of the electricity sales, the influence of high-temperature factors needs to be eliminated, the influence analysis method of the high-temperature on the electricity sales is eliminated, the influence of the high-temperature on the electricity sales can be calculated, and the trend of the electricity sales after the high-temperature influence is eliminated, and the basic idea is divided into four steps: firstly, selecting quarterly GDP acceleration data of each province, and obtaining monthly GDP data of each province by using a linear interpolation method; secondly, selecting monthly average highest temperature and GDP acceleration data of each province, calculating upper and lower confidence intervals of the monthly average highest temperature and the GDP data by using a box type graph, thirdly, giving out a confidence interval of the electricity selling quantity acceleration based on a polynomial regression algorithm, judging whether target monthly electricity quantity homonymy acceleration of each province is in the confidence interval, if not, considering that the electricity selling quantity of the province is influenced by high temperature, and fourthly, for province companies influenced by the high temperature, obtaining an influence change value of the electricity selling quantity by subtracting the upper limit value of the confidence interval from the actual electricity quantity of a target month, wherein the influence change value of the high temperature on the electricity selling quantity is caused by the abnormity of the GDP and the temperature, and the influence change value of the GDP and the high temperature is calculated, wherein the highest temperature: generally means the average maximum monthly temperature of each province, and is obtained by the maximum temperature balance of local cities of each province, wherein a box type chart is shown: the box chart, also called box chart, is a statistical chart for displaying a set of data dispersion data, named by the shape of box, is also commonly used in various fields, commonly used in quality management, and utilizes five statistics in data: the data are described by the minimum value, the first quartile, the median, the third quartile and the maximum value, so that whether the data have information such as symmetry, distribution dispersion and the like can be seen, and abnormal values in the data can be visually and clearly identified, and polynomial fitting is performed: polynomial fitting refers to approximately describing or comparing the functional relationship between coordinates represented by a group of discrete points on a plane by using a continuous curve, and is a method for approximating discrete data by using an analytical expression, and a confidence interval: the confidence interval is an estimation interval of a general parameter constructed by the sample statistic, statistically, the confidence interval of a probability sample is an interval estimation of a certain general parameter of the sample, and the confidence curve shows the degree that the true value of the parameter has a certain probability to fall around the measurement result;
the specific process is as follows:
1. data range description:
the data used by the method provided by the invention comprises the electricity selling quantity data of residents in the first, second and third industries of each province and urban and rural areas as well as GDP acceleration and highest temperature data.
GDP data interpolation:
GDP acceleration rate original data are quarterly data, influence characteristics of monthly high temperature on electricity sales are to be drawn, and therefore GDP data are processed through a linear interpolation method.
The specific algorithm process is as follows:
note the book
Figure DEST_PATH_IMAGE004
Is data to be processed, wherein
Figure DEST_PATH_IMAGE006
Is a date. Such as
Figure DEST_PATH_IMAGE008
Is the spontaneous self-power consumption in 2016 (10 months).
For the treatment to beData of
Figure DEST_PATH_IMAGE010
Removing data which is to be judged whether to be an abnormal value, performing box separation, and determining the upper boundary and the lower boundary thereof, namely:
Figure DEST_PATH_IMAGE012
(2)
Figure DEST_PATH_IMAGE014
(3)
wherein
Figure DEST_PATH_IMAGE016
The mean value is represented by the average value,
Figure DEST_PATH_IMAGE018
the upper quartile is represented as the number of quartiles,
Figure DEST_PATH_IMAGE020
the lower quartile is indicated.
And judging whether the data to be processed is in the limit, and if the data to be processed is not in the limit, judging that the data to be processed is an abnormal value. After the outliers are identified, the average values to be processed for the previous months are used for the replacement.
2. And (3) curve fitting:
selecting a main network load characteristic curve and a photovoltaic power generation power characteristic curve of an electric power company under different weather types, wherein the different weather types mainly comprise sunny days and rainy days. Firstly, an expression of a main grid load characteristic curve and a photovoltaic power generation characteristic curve is obtained based on a curve fitting method. The method comprises the following specific steps:
2.1 Curve fitting method
Data point recording
Figure DEST_PATH_IMAGE022
Wherein
Figure DEST_PATH_IMAGE024
Figure DEST_PATH_IMAGE026
Means one day
Figure DEST_PATH_IMAGE028
The time of each measurement point can be taken as
Figure DEST_PATH_IMAGE030
Figure DEST_PATH_IMAGE032
Is referred to as
Figure 183880DEST_PATH_IMAGE026
The value of the time of day. Using fitting of data points to a polynomial expression of
Figure DEST_PATH_IMAGE034
Estimating coefficients in a polynomial model by a least squares algorithm
Figure DEST_PATH_IMAGE036
For a linear model, the least squares formulation is:
Figure DEST_PATH_IMAGE038
(4)
whereinnFor the number of data pieces, the formula (4) is simplified to obtain:
Figure DEST_PATH_IMAGE040
(5)
respectively record
Figure DEST_PATH_IMAGE042
Then there is
Figure DEST_PATH_IMAGE044
Then coefficient matrix
Figure DEST_PATH_IMAGE046
(6)
2.2 fitting Main network load characteristic Curve
If the main network characteristic load data point is obtained
Figure DEST_PATH_IMAGE047
Wherein
Figure DEST_PATH_IMAGE049
Figure 412605DEST_PATH_IMAGE026
Means one day
Figure DEST_PATH_IMAGE051
The time of each measurement point can be taken as
Figure DEST_PATH_IMAGE052
Figure 254659DEST_PATH_IMAGE032
Is referred to as
Figure 649868DEST_PATH_IMAGE026
The main network load value at the time is obtained as follows
Figure 526557DEST_PATH_IMAGE051
Data for curve fitting:
Figure DEST_PATH_IMAGE054
and (3) solving curve parameters by using a least square algorithm, wherein the function relation between the main network load characteristic curve and time under a typical weather type is as follows:
Figure DEST_PATH_IMAGE055
(7)
here, the
Figure DEST_PATH_IMAGE057
For the main network load value under typical weather types,
Figure DEST_PATH_IMAGE059
the time of day values of the points are measured.
Figure DEST_PATH_IMAGE060
Are parameters of the curve model.
2.3 fitting photovoltaic power generation power characteristic curve
If the photovoltaic power generation power data point is obtained
Figure DEST_PATH_IMAGE062
Wherein
Figure 473654DEST_PATH_IMAGE049
Figure 803004DEST_PATH_IMAGE026
Means one day
Figure 1904DEST_PATH_IMAGE051
The time of each measurement point can be taken as
Figure 670783DEST_PATH_IMAGE052
Figure DEST_PATH_IMAGE064
Is referred to as
Figure 788780DEST_PATH_IMAGE026
The photovoltaic power generation power value at the moment is obtained as follows
Figure 543110DEST_PATH_IMAGE051
Data for curve fitting:
Figure DEST_PATH_IMAGE066
and (3) solving curve parameters by using a least square algorithm, wherein the function relation between the main network load characteristic curve and time under a typical weather type is as follows:
Figure DEST_PATH_IMAGE068
(8)
here, the
Figure DEST_PATH_IMAGE070
Is the photovoltaic power generation power value under the typical weather type,
Figure 404755DEST_PATH_IMAGE059
the time of day values of the points are measured.
Figure DEST_PATH_IMAGE072
Are parameters of the curve model.
3. Area integration method based on solving theoretical value of electricity sold and theoretical value of electricity generated
Processing the main network load characteristic curve and the photovoltaic power generation characteristic curve under different weather types and different time periods by using an area integration method to respectively obtain the power selling theoretical value and the power generating capacity theoretical value under different weather types and different time periods, wherein the process is as follows:
3.1 calculating the theoretical value of the electricity sold in different weather types and different time periods
If main network load curve data points on a certain sunny day are obtained
Figure 928141DEST_PATH_IMAGE047
Wherein
Figure 437880DEST_PATH_IMAGE049
Figure 679505DEST_PATH_IMAGE026
Means one day
Figure 954629DEST_PATH_IMAGE051
The time of the individual measuring points is,
Figure 660417DEST_PATH_IMAGE051
is a positive integer multiple of 24, and can be taken as
Figure 995583DEST_PATH_IMAGE052
Figure 724505DEST_PATH_IMAGE032
Is referred to as
Figure 865636DEST_PATH_IMAGE026
The value of the mains network load at the moment. Through the step 2, the expression of the major network characteristic load under the typical weather type is obtained as the formula (7), and the theoretical value of the power sold in sunny days
Figure DEST_PATH_IMAGE074
Can be calculated by the following formula:
Figure DEST_PATH_IMAGE076
(9)
similarly, based on the main network load characteristic curve in rainy days, the theoretical value of the electricity selling quantity in rainy days can be calculated to be
Figure DEST_PATH_IMAGE078
The time range of the peak of the fine day is 11 am to 13 pm, then
Figure DEST_PATH_IMAGE080
Then, the theoretical value of the electricity sold in the peak two hours in a sunny day is calculated by the following area integral formula:
Figure DEST_PATH_IMAGE082
(10)
the ratio of the theoretical value of the electricity sold in cloudy days to the theoretical value of the electricity sold in sunny days is recorded as
Figure DEST_PATH_IMAGE084
The ratio of the theoretical value of the electricity sold in two hours at the peak in sunny days to the theoretical value of the electricity sold in sunny days is
Figure DEST_PATH_IMAGE086
3.2 calculating theoretical values of power generation amount in different weather types and different time periods
If the photovoltaic power generation power data point of a certain sunny day is obtained
Figure 550564DEST_PATH_IMAGE047
Wherein
Figure 322211DEST_PATH_IMAGE049
Figure 272850DEST_PATH_IMAGE026
Means one day
Figure 217672DEST_PATH_IMAGE051
The time of each measurement point can be taken as
Figure 570156DEST_PATH_IMAGE052
Figure 512704DEST_PATH_IMAGE064
Is referred to as
Figure 950639DEST_PATH_IMAGE026
The photovoltaic power value at the moment. Through the step 2, the expression of the photovoltaic power generation power under the typical weather type is obtained and is shown as the formula (8), and the theoretical value of the power generation amount in sunny days
Figure DEST_PATH_IMAGE088
Can be calculated by the following formula:
Figure DEST_PATH_IMAGE090
(11)
similarly, based on the photovoltaic power generation power data in rainy days, the theoretical value of the generated energy in rainy days can be calculated to be
Figure DEST_PATH_IMAGE092
The time range of the peak of the fine day is 11 am to 13 pm, then
Figure 495889DEST_PATH_IMAGE080
Then, the theoretical value of the power generation amount at two hours of the peak in a sunny day is calculated by the following area formula:
Figure DEST_PATH_IMAGE094
(12)
the ratio of the theoretical value of the generated energy in cloudy days to the theoretical value of the generated energy in sunny days is recorded as
Figure DEST_PATH_IMAGE096
The ratio of the theoretical value of the power generation capacity in two hours at the peak in a sunny day to the theoretical value of the power generation capacity in the sunny day is
Figure DEST_PATH_IMAGE098
4. Calculating the load permeability in the sunny day and the peak two hours in the sunny day
The load permeability on a sunny day and two hours on the sunny day is calculated, and the method comprises the following specific steps:
4.1, monthly electricity sales data and spontaneous electricity consumption of the power company after data preprocessing are obtained, and load permeability of the monthly distributed photovoltaic power supply is calculated by using a formula (1).
4.2 calculate the average electricity selling quantity in sunny days and two hours of peak hours in sunny days
Obtaining electricity selling amount of a month
Figure DEST_PATH_IMAGE100
And the ratio of the theoretical value of the electricity sold in rainy days to the theoretical value of the electricity sold in sunny days
Figure DEST_PATH_IMAGE102
And the number of days appearing in a certain sunny day in the area is acquired from the weather website
Figure DEST_PATH_IMAGE104
Days of occurrence in cloudy or rainy days
Figure DEST_PATH_IMAGE106
Day, thereinKFor a certain number of days in a month, the calculation formula of the average electricity sales amount in a sunny day is as follows:
Figure DEST_PATH_IMAGE108
(13)
the ratio of the theoretical value of the electricity sold in two hours at the peak of sunny days to the theoretical value of the electricity sold in sunny days is utilized
Figure DEST_PATH_IMAGE110
The average electricity selling amount of two hours at peak on sunny day can be calculated
Figure DEST_PATH_IMAGE112
The following formula:
Figure DEST_PATH_IMAGE114
(14)
4.3 calculating average spontaneous self-electricity consumption at sunny days and two hours at peak of sunny days
Acquiring the self-electricity consumption in a month
Figure DEST_PATH_IMAGE116
And the ratio of the theoretical value of the generated energy in cloudy and rainy days to the theoretical value of the generated energy in sunny days
Figure 155410DEST_PATH_IMAGE102
The ratio of the spontaneous self-power consumption in rainy days to the spontaneous self-power consumption in sunny days is also taken as
Figure 331176DEST_PATH_IMAGE102
The number of days of the region appearing in the sunny day is acquired from the weather website
Figure 256407DEST_PATH_IMAGE104
Days of occurrence in cloudy or rainy days
Figure 480715DEST_PATH_IMAGE106
Day, therein
Figure DEST_PATH_IMAGE118
Is the number of days of the month. Then, the calculation formula of the average spontaneous power consumption in a sunny day is as follows:
Figure DEST_PATH_IMAGE120
(15)
the ratio of the theoretical value of the generated energy in two hours at the peak of a sunny day to the theoretical value of the generated energy in the sunny day
Figure 604529DEST_PATH_IMAGE110
As the ratio of the spontaneous power consumption in two hours at the peak in a sunny day to the spontaneous power consumption in a sunny day, the average spontaneous power consumption in two hours at the peak in a sunny day can be calculated
Figure DEST_PATH_IMAGE122
The following formula:
Figure DEST_PATH_IMAGE124
(16)
4.4 calculating the load permeability of the distributed photovoltaic power supply in sunny days and two hours in sunny days respectively
The average selling electricity quantity and the average spontaneous electricity consumption quantity in a sunny day and two hours in a sunny day are respectively calculated through the steps, and then the formula of the load permeability in the sunny day is as follows:
Figure DEST_PATH_IMAGE126
(17)
wherein
Figure DEST_PATH_IMAGE128
Is the average spontaneous self-electricity consumption in fine days,
Figure DEST_PATH_IMAGE130
is the average electricity selling amount in fine days.
The load permeability at the peak of two hours in a sunny day is as follows:
Figure DEST_PATH_IMAGE132
(18)
wherein
Figure 13513DEST_PATH_IMAGE122
The average spontaneous self-power consumption in two hours at the peak of a sunny day,
Figure 494216DEST_PATH_IMAGE112
is the average electricity selling amount in two hours in a sunny day.
The specific algorithm involved in the method is as follows:
1) least square algorithm
Two variables were studied in our study
Figure DEST_PATH_IMAGE134
When the data are related, a series of paired data can be obtained
Figure DEST_PATH_IMAGE136
The data are plotted in an x-y rectangular coordinate system, and if the points are found to be near a curve, the equation for the curve can be made as follows:
Figure DEST_PATH_IMAGE138
(19)
wherein the content of the first and second substances,
Figure 584532DEST_PATH_IMAGE060
is any real number.
Needs to be determined for establishing the curve equation
Figure 766115DEST_PATH_IMAGE060
Using the principle of least squares, i.e. actual values
Figure 955788DEST_PATH_IMAGE032
And the calculated value obtained by using the formula 1
Figure DEST_PATH_IMAGE140
The square of the difference of (a) and (b) is taken as an optimization basis, and when the difference between the two is the minimum, we consider the curve equation as the best fit equation of the data. I.e. min
Figure DEST_PATH_IMAGE142
. Order:
Figure DEST_PATH_IMAGE144
(20)
by substituting formula (12) for formula (13)
Figure DEST_PATH_IMAGE146
(21)
If it is at the same time
Figure DEST_PATH_IMAGE148
At a minimum, the function can be matched
Figure 980244DEST_PATH_IMAGE148
Calculating a deviation guide, order
Figure 546355DEST_PATH_IMAGE148
To pair
Figure 910340DEST_PATH_IMAGE060
Is equal to 0, i.e.
Figure DEST_PATH_IMAGE150
Get k equations
Figure DEST_PATH_IMAGE152
Figure DEST_PATH_IMAGE154
Figure DEST_PATH_IMAGE158
Will this
Figure DEST_PATH_IMAGE160
The final set of equations is as follows:
(22)
equation (22) can be converted into equation (6), i.e., a parameter matrix can be obtained
Figure DEST_PATH_IMAGE162
As shown in the following formula
Figure DEST_PATH_IMAGE046A
We can get the regression equation we need.
In the regression process, the regression equation may not pass through exactly all of the data points
Figure 582499DEST_PATH_IMAGE136
To determine the quality of the regression equation, the correlation coefficient can be usedRMaking a judgment on the correlation coefficientRCloser to 1 indicates better fit of the regression equation, where:
Figure DEST_PATH_IMAGE165
(23)
wherein the content of the first and second substances,
Figure 969618DEST_PATH_IMAGE028
is the sample volume.
2) Linear interpolation method
Linear interpolation refers to a method of determining an unknown quantity between two known quantities using a straight line connecting the two known quantities.
Let us assume that two known quantities of coordinates are known to us
Figure DEST_PATH_IMAGE167
,
Figure DEST_PATH_IMAGE169
To obtain
Figure DEST_PATH_IMAGE171
At a certain position in the interval
Figure DEST_PATH_IMAGE173
The value on the straight line. Firstly, determining a straight line equation according to two points as follows:
Figure DEST_PATH_IMAGE175
simplifying to obtain:
Figure DEST_PATH_IMAGE177
(24)
wherein
Figure DEST_PATH_IMAGE179
Then, to
Figure 526370DEST_PATH_IMAGE171
Any point of the interval
Figure DEST_PATH_IMAGE181
Is the interpolation of
Figure 479282DEST_PATH_IMAGE181
Into equation (24):
Figure DEST_PATH_IMAGE183
to sum up, the multi-path distribution network cost accounting system based on the big data can acquire the project cost data of the similar distribution network through the big data analysis platform by setting the big data analysis platform and the data analysis module, then carries out contrastive analysis with the project cost data, and finally carries out cost accounting through the cost accounting module, thereby facilitating the implementation of timely and effective management and decision-making on the cost accounting process.
The related modules involved in the system are all hardware system modules or functional modules combining computer software programs or protocols with hardware in the prior art, and the computer software programs or the protocols involved in the functional modules are all known in the technology of persons skilled in the art, and are not improvements of the system; the improvement of the system is the interaction relation or the connection relation among all the modules, namely the integral structure of the system is improved, so as to solve the corresponding technical problems to be solved by the system.
Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.

Claims (10)

1. A big data-based multi-path distribution network cost accounting system comprises a cost accounting system and is characterized in that: the cost accounting system comprises a central processing unit, the output end of the central processing unit is electrically connected with the input end of the communication module, the input end of the central processing unit is electrically connected with the output end of the communication module, the output end of the communication module is in signal connection with the input end of the big data analysis platform, the input end of the communication module is in signal connection with the output end of a big data analysis platform, the input end of the big data analysis platform is in signal connection with the output end of a local homogeneous distribution network project database, the input end of the big data analysis platform is in signal connection with the output end of the domestic and foreign similar power distribution network project database, the output end of the central processing unit is electrically connected with the input end of the display module, the output end of the central processing unit is electrically connected with the input end of the storage module, and the input end of the central processing unit is electrically connected with the output end of the storage module.
2. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the input end of the central processing unit is electrically connected with the output end of the parameter information input module.
3. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the output end of the central processing unit is electrically connected with the input end of the cost accounting module, and the input end of the central processing unit is electrically connected with the output end of the cost accounting module.
4. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the input end of the central processing unit is electrically connected with the output end of the data analysis module, and the output end of the central processing unit is electrically connected with the input end of the data analysis module.
5. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the input end of the data analysis module is electrically connected with the output end of the data acquisition unit, and the input end of the cost accounting system is electrically connected with the output end of the power supply module.
6. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the data acquisition unit comprises an investment period cost statistic module, an operation maintenance cost statistic module and a scrapping period cost statistic module.
7. The big-data-based multi-path distribution network cost accounting system according to claim 6, wherein: the investment period cost statistic module is used for carrying out statistic calculation on one-time investment type expenses in each early period of design, equipment purchase, construction and the like.
8. The big-data-based multi-path distribution network cost accounting system according to claim 6, wherein: the operation and maintenance cost statistic module is used for calculating material cost, construction cost, labor cost and the like related to distribution network inspection, maintenance, technical improvement and overhaul and equipment fault maintenance work, and meanwhile, the operation and maintenance cost statistic module also comprises the loss of electricity selling profits caused by power failure and indirect loss brought to social production life.
9. The big-data-based multi-path distribution network cost accounting system according to claim 6, wherein: and the scrapping period cost counting module is used for counting and calculating the net value and the disassembly cost of the scrapped assets.
10. The big-data-based multi-path distribution network cost accounting system according to claim 1, wherein: the algorithm in the cost accounting module is
Figure DEST_PATH_IMAGE002
Wherein CI is the cost of the input period, CM is the cost of operation and maintenance, and CD is the cost of the abandonment period.
CN202110557936.4A 2021-05-21 2021-05-21 Multi-path distribution network cost accounting system based on big data Pending CN113947273A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202110557936.4A CN113947273A (en) 2021-05-21 2021-05-21 Multi-path distribution network cost accounting system based on big data

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202110557936.4A CN113947273A (en) 2021-05-21 2021-05-21 Multi-path distribution network cost accounting system based on big data

Publications (1)

Publication Number Publication Date
CN113947273A true CN113947273A (en) 2022-01-18

Family

ID=79327332

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202110557936.4A Pending CN113947273A (en) 2021-05-21 2021-05-21 Multi-path distribution network cost accounting system based on big data

Country Status (1)

Country Link
CN (1) CN113947273A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114677180A (en) * 2022-04-12 2022-06-28 国网甘肃省电力公司兰州供电公司 Power engineering fund budget evaluation system

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104504619A (en) * 2015-01-05 2015-04-08 国家电网公司 Temperature/ economic growth factor considered monthly total electricity consumption predication method
CN104809591A (en) * 2015-05-11 2015-07-29 东北电力大学 Electric power construction engineering supervision mechanism based on big data
CN107392411A (en) * 2017-06-05 2017-11-24 国网浙江省电力公司经济技术研究院 A kind of distribution power equipment Cost accounting method theoretical based on life cycle cost
CN109816161A (en) * 2019-01-14 2019-05-28 中国电力科学研究院有限公司 A kind of power distribution network operation computer-aided decision support System and its application method
CN109840721A (en) * 2019-03-12 2019-06-04 中采商学(苏州)管理咨询有限公司 Cost model system based on online data management under a kind of big data
CN110782279A (en) * 2019-10-16 2020-02-11 国网山西省电力公司经济技术研究院 Asset cost accounting method and system for main equipment of power distribution network
CN111275282A (en) * 2019-12-14 2020-06-12 华能安源发电有限责任公司 Real-time cost analysis and resource allocation optimization system and method for thermal power plant
CN112686555A (en) * 2020-12-31 2021-04-20 国电南瑞科技股份有限公司 Comprehensive analysis method, device and system for regional power distribution network

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN104504619A (en) * 2015-01-05 2015-04-08 国家电网公司 Temperature/ economic growth factor considered monthly total electricity consumption predication method
CN104809591A (en) * 2015-05-11 2015-07-29 东北电力大学 Electric power construction engineering supervision mechanism based on big data
CN107392411A (en) * 2017-06-05 2017-11-24 国网浙江省电力公司经济技术研究院 A kind of distribution power equipment Cost accounting method theoretical based on life cycle cost
CN109816161A (en) * 2019-01-14 2019-05-28 中国电力科学研究院有限公司 A kind of power distribution network operation computer-aided decision support System and its application method
CN109840721A (en) * 2019-03-12 2019-06-04 中采商学(苏州)管理咨询有限公司 Cost model system based on online data management under a kind of big data
CN110782279A (en) * 2019-10-16 2020-02-11 国网山西省电力公司经济技术研究院 Asset cost accounting method and system for main equipment of power distribution network
CN111275282A (en) * 2019-12-14 2020-06-12 华能安源发电有限责任公司 Real-time cost analysis and resource allocation optimization system and method for thermal power plant
CN112686555A (en) * 2020-12-31 2021-04-20 国电南瑞科技股份有限公司 Comprehensive analysis method, device and system for regional power distribution network

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN114677180A (en) * 2022-04-12 2022-06-28 国网甘肃省电力公司兰州供电公司 Power engineering fund budget evaluation system

Similar Documents

Publication Publication Date Title
CN110362894B (en) Distribution line and transformer comprehensive loss reduction and energy saving calculation analysis method and system
Wu et al. An integrated decision-making model for sustainable photovoltaic module supplier selection based on combined weight and cumulative prospect theory
CN110659273B (en) Data abnormity monitoring and repairing method of distributed big data acquisition platform
CN110097297A (en) A kind of various dimensions stealing situation Intellisense method, system, equipment and medium
CN107123982B (en) Power distribution network reliability economic benefit analysis method based on equipment transaction
JP2009089594A (en) Temporal-spatial load analysis system of power facility utilizing inspection data and calculation method of load
CN111539604A (en) Enterprise rework and production recovery index measuring and monitoring method based on electric power data
CN110739686A (en) distribution room line loss management method and system based on summary chart anomaly analysis
CN111738573A (en) Health evaluation method based on electric energy meter full life cycle data
CN116165597A (en) Nuclear deviation least square method-based electric energy meter misalignment online detection method
WO2023023901A1 (en) Method for predicting medium- and long-term centralized bidding clearing price in electricity market
CN113947273A (en) Multi-path distribution network cost accounting system based on big data
CN111967684B (en) Metering asset active distribution method based on big data analysis
CN106709623B (en) Power grid marketing inspection risk control method based on risk calculation model
CN117010946A (en) Thermal power plant production and operation cost accounting system and application method thereof
CN109949101B (en) Big data concept-based cigarette material cost analysis method
CN115905319B (en) Automatic identification method and system for abnormal electricity fees of massive users
CN114140176B (en) Adjustable capacity prediction method and device for load aggregation platform
CN111127186A (en) Application method of customer credit rating evaluation system based on big data technology
CN116384622A (en) Carbon emission monitoring method and device based on electric power big data
CN114862363A (en) Evaluation analysis method based on substation project cost data analysis
CN111915443A (en) System and method for realizing intelligent investment product combination analysis and calculation processing
CN112001551A (en) Method for predicting electricity sales amount of power grid in city based on electricity information of large users
CN112611997A (en) Online verification method and system for hitching relation of platform area gateway table
CN110490480A (en) A kind of newly-built transmission line of electricity economic benefit quantitative estimation method

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