CN111062747A - Electric power transaction retail package management system and method with user-defined income mode - Google Patents
Electric power transaction retail package management system and method with user-defined income mode Download PDFInfo
- Publication number
- CN111062747A CN111062747A CN201911254477.1A CN201911254477A CN111062747A CN 111062747 A CN111062747 A CN 111062747A CN 201911254477 A CN201911254477 A CN 201911254477A CN 111062747 A CN111062747 A CN 111062747A
- Authority
- CN
- China
- Prior art keywords
- user
- package
- module
- agent
- calculation
- 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
Links
- 238000000034 method Methods 0.000 title description 8
- 238000007726 management method Methods 0.000 claims abstract description 63
- 238000004364 calculation method Methods 0.000 claims description 121
- 230000005611 electricity Effects 0.000 claims description 66
- 238000013523 data management Methods 0.000 claims description 30
- 238000013507 mapping Methods 0.000 claims description 22
- 238000012550 audit Methods 0.000 claims description 15
- 238000012423 maintenance Methods 0.000 claims description 14
- 238000012795 verification Methods 0.000 claims description 13
- 239000000284 extract Substances 0.000 claims description 11
- 230000007246 mechanism Effects 0.000 claims description 9
- 230000008901 benefit Effects 0.000 claims description 5
- 230000000694 effects Effects 0.000 claims description 5
- 238000012546 transfer Methods 0.000 description 7
- 238000011161 development Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002146 bilateral effect Effects 0.000 description 1
- 230000002860 competitive effect Effects 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market data
- G06Q30/0206—Price or cost determination based on market factors
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Finance (AREA)
- Marketing (AREA)
- Theoretical Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Game Theory and Decision Science (AREA)
- Data Mining & Analysis (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Primary Health Care (AREA)
- Tourism & Hospitality (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a self-defined income mode electric power transaction retail package management system and a self-defined income mode electric power transaction retail package management method, and belongs to the technical field of electric power market retail package management and settlement systems. The invention can realize the self-defined generation of retail service packages between the power selling company and the users, can efficiently and accurately settle and charge the signed packages, meets the business requirements of the power selling company and the users, breaks through the single structure of the packages, enriches the package categories facing the users, helps the power selling company to increase the user stickiness and increases the flexibility of the retail market.
Description
Technical Field
The invention belongs to the technical field of electric power market trading systems, and relates to an electric power trading retail package management system and method with a user-defined income mode.
Background
In the electricity-selling side market, an electricity-selling company serves as a financial intermediary to purchase electricity from a competitive wholesale market and then sell the electricity to consumers, businesses and the like in a retail market. The retail package offered by the current electricity selling companies mainly comprises: price difference income type, agency service type, energy contract management type, ladder type and the like, wherein the package is similar to a telecommunication charge package, the package is single in type, and a charge template is fixed, so that the method has the advantages of easiness in selection and settlement. However, with the deepening and expanding of the degree and range of market openness of the electricity selling side in China, the independent option of the electricity selling company for the power consumer is gradually released, and the flexible requirements of the user cannot be met by a single package type in the past. How to realize the self-defined signing of the retail service package between the electricity selling company and the agent user, the fee calculation template is flexibly generated according to the electricity utilization characteristics of the user, and the self-defined package can be accurately and efficiently settled and charged, which is a problem to be solved urgently.
Disclosure of Invention
The invention aims to solve the defects of the prior art and provides a power transaction retail package management system and method with a custom income mode. The invention can realize the custom generation of the retail service package between the power selling company and the user, can efficiently and accurately settle and charge the signed package, meets the business requirements of the power selling company and the user, breaks through the single structure of the package, enriches the package for the user category, helps the power selling company to increase the user viscosity, increases the flexibility of the retail market, and promotes the further development of the electric power retail market.
In order to achieve the purpose, the technical scheme adopted by the invention is as follows:
a self-defined income mode electric power transaction retail package management system mainly comprises a user login module 101, a package template management module 102, a first display module 103, a historical data management module 104, a second display module 105, a self-defined package optional content management module 106, a self-defined package generation module 107, a self-defined package trial calculation module 108, a third display module 109, a self-defined package audit module 110, a self-defined package settlement module 111 and a fourth display module 112.
The user login module 101 is used for inputting login information by the user login system, allowing the user to login the system after verification is passed, and not allowing the user to login the system otherwise; the categories of users include electricity selling companies, agent users and electricity trading institutions; the agent user refers to a user who has signed an agent contract with an electric power selling company; the electric power transaction mechanism serves as a system administrator and is used for auditing the contents of the retail service package generated by the agent user and the power selling company, wherein the contents include contract types, agent service fee calculation formulas and signing periods.
The package template management module 102 is connected with the user login module 101 and is used for selecting the existing retail service package template of the system to sign a retail service contract by the agent user and the power selling company; the package template preset by the system comprises a price difference income type package, a contract energy management type package, an agent service type package and a step charging type package; after the package template is selected, the corresponding retail service package can be generated only by filling key information in the package template, wherein the key information comprises the monthly electricity consumption of the agent user and the monthly transaction electricity consumption of the agent user.
The first display module 103 is connected to the package template management module 102 and the user login module 101, and is configured to display a package template preset by the system and detailed contents of each template.
The historical data management module 104 is connected with the user login module 101 and is used for managing and maintaining historical fee calculation information of the power selling company and the agent user; wherein, the historical accounting information refers to the data in the user historical settlement list provided by the settlement part of the trading center; the historical data management module 104 analyzes and extracts the cell contents after acquiring the proxy user historical accounting list through a third-party system, establishes a mapping relation among data names, variable names and specific numerical values, maintains and manages the obtained mapping relation according to actual use requirements, and finally obtains a parameter dictionary of the proxy user accounting list.
The second display module 105 is connected to the historical data management module 104 and the user login module 101, and is configured to visualize historical fee calculation data of the agent user, and provide operation functions of querying and counting related data according to keywords including month, account number, account name, and data name.
The user-defined package optional content management module 106 is connected with the user login module 101 and the historical data management module 104 and is used for managing user-defined package optional content; the package optional content comprises calculation parameters, operation symbols, condition symbols, relation symbols and logic symbols; the calculation parameter refers to a user calculation fee parameter selected from a parameter dictionary maintained by the historical data management module 104; the operation sign means that the operation sign comprises addition, subtraction, multiplication and division mathematical operation signs; the conditional notation refers to a conditional expression keyword; the relational symbols refer to relational expression keywords; a logical symbol refers to a logical expression key.
The user-defined package generation module 107 is connected with the user login module 101 and the user-defined package optional content management module 106, and is used for generating a user-defined package; the power selling company selects the package optional content maintained by the user-defined package optional content management module 106 to customize a personalized and targeted agent service fee calculation formula according to the electricity utilization characteristics of the agent user.
The user-defined package trial calculation module 108 is connected with the user login module 101 and the user-defined package generation module 107, and is used for trial calculation of the package proxy service fee calculation formula customized by the user-defined package generation module to ensure the correctness of formula editing; the custom package trial calculation module 108 analyzes the expression of the calculation formula, extracts the calculation parameters, the operation symbols, the condition symbols, the relationship symbols and the logic symbols in the formula, obtains the actual values of the calculation parameters through the mapping relationship of the parameter dictionary, and finally calculates the result of the calculation formula.
The third display module 109 is connected to the user login module 101 and the custom package generation module 107, and is configured to display the custom package signed by the power selling company and the agent user and the detailed content thereof, and provide the operation functions of querying and counting related data according to the keywords including month, account number, account name and package name.
The custom package auditing module 110 is connected with the user login module 101, the custom package trial calculation module 108 and the fourth display module 109, and is used for auditing custom packages signed by the electric power selling company and the user by the user in the transaction center; the user of the transaction center logs in the custom package auditing module 110, checks the detailed content of the custom package, calls the custom package trial calculation module 108 to calculate the result of the agent service fee calculation formula, and confirms whether the custom package passes through the calculation result.
The custom package settlement module 111 is connected with the user login module 101 and the third display module 109, and is used for an electric power selling company to obtain the fee calculation information of the agent user in the current settlement market, and then settle the agent service fee according to the signed custom package to generate a fee calculation basis.
The fourth display module 112 is connected to the user login module 101 and the custom package settlement module 111, and is configured to display a calculation result of a custom package signed by the electricity selling company and the agent user in a current settlement market, and provide an operation function of querying and counting related data according to keywords including month, account number, account name and package name.
A self-defined income mode electric power transaction retail package management method adopts the electric power transaction retail package management system of the self-defined income mode, and comprises the following steps:
the first step is as follows: user login: the user inputs login information through the user login module 101, and the user is allowed to log in the system after the verification is passed, otherwise, the user is not allowed to log in the system; the user category comprises an electricity selling company, an agent user and an electric power transaction mechanism; the agent advocacy refers to a user who has signed an agent relationship with an electric power selling company; the electric power transaction mechanism is used as a system administrator and used for controlling the start and completion of each step, including the management and maintenance of historical fee calculation information, the management and maintenance of package optional contents and self-ordering package audit.
The second step is that: historical accounting information management and maintenance: a system administrator logs in the historical data management module 104, acquires all historical accounting lists of users who sign agency relations with the power selling company through a third-party system, and analyzes each display field and the actual numerical value thereof in the lists, wherein the display fields comprise settlement months, settlement account numbers and actual electricity consumption; then, a mapping relation among the data name, the variable name and the specific numerical value is established, and the data is stored in a database according to the established mapping relation, so that the management and the maintenance are convenient.
The third step: managing and maintaining package optional contents: a system administrator logs in the user-defined package optional content management module 106 and selects a required parameter name from the mapping relation established by the historical data management module 104 according to the settlement rule of the power selling company in the market, wherein the parameter name comprises the actual power consumption of the user, the monthly transaction electric quantity of the user and the daily transaction electric quantity of the user; optional operation symbols, condition symbols, relationship symbols and logic symbols are then set.
The fourth step: and (3) generating a custom package: the operator of the electricity selling company logs in the custom package generating module 107, checks the selectable content of the current custom package, then compiles a targeted agent service fee calculation formula according to the electricity consumption characteristics of the agent user, and simultaneously generates a custom package contract.
The fifth step: and (4) trial calculation of the user-defined package: an operator of the power selling company logs in the custom package trial calculation module 108 to check and trial calculate the formula edited in the custom package generation module 107; the verification content comprises the following steps: calculating the correctness of formula editing and the reasonability of formula editing; after the verification, the operator of the power selling company extracts the historical calculation cost information of the agent user from the historical data management module 104, substitutes the historical data into a formula for trial calculation, analyzes the calculation result and judges whether the custom package can meet the requirement of the agent user and simultaneously maximizes the benefits of both parties; while the custom package content is presented on the third display module 109.
And a sixth step: and (4) self-defining package audit: the system administrator logs in the custom package auditing module 110 to audit the custom package contract signed by the power selling company and the agent user, and the custom package contract takes effect formally after the audit is passed and is used for calculating the agent service fee in the next month.
The seventh step: self-defined package settlement: the operator of the electricity selling company logs in the custom package settlement module 111, selects the agent user needing settlement and then enters the settlement market, calculates the agent service fee of the current settlement market of the agent user according to the signed custom package contract content, generates a settlement list as a charging proof according to the calculation result, and displays the calculation result on the fourth display module 112.
The package template in the package template management module 102 is pre-entered into the transaction system of the invention, and the package template content comprises: the price difference profit type, the price difference profit + proportion division forming, the contract energy management type, the proxy service type-1 (with constraint according to the electricity), the proxy service type-2 (with constraint according to the electricity, the price difference profit + proportion division forming), the proxy service type-3 (free service), the proxy service type-4 (without constraint according to the electricity), the proxy service type-5 (without constraint according to the electricity, the price difference profit + proportion division forming) and the step charging type are totally 9 types.
The structure of the package management system of the present invention is not limited to the above description, and for example, the package management system may further include an archive data storage module for storing an agent service fee accounting list of an agent user of the power selling company, customized package content information of the power selling company, and the like.
The invention has the beneficial effects that: the package management system for generating and settling the self-defined package of the electricity selling company is simple and convenient to operate and high in flexibility, and can customize an exclusive proxy contract according to user attributes and electricity utilization characteristics, meet the user requirements and enhance the user viscosity. By adopting the system, a trading center system administrator can obtain a user historical accounting bill, analyze the content of the bill to generate a custom parameter dictionary, maintain corresponding operation symbols, condition symbols, relationship symbols and logic symbols according to settlement rules, and finally form optional content of a custom package contract. The power selling company can select corresponding calculation parameters from the optional content of the self-defined package contract according to the user attribute and the power utilization characteristic, then select corresponding operation symbols, condition symbols, relationship symbols and logic symbols, write a representative and high-flexibility proxy service fee calculation formula, and can use historical fee calculation data to check the formula correctness; and after the system administrator passes the verification, the settlement can be carried out according to the signed custom contract.
The system effectively supports the contract signing of the Yunnan retail service, obtains remarkable application effect since the development of the Yunnan retail market, and serves more than 110 electric power users together by 80000 electric power company agents as late as 2019 in 10 months. The number of the agent users accounts for more than 90% of the proportion of large industrial users and general industrial and commercial users in Yunnan province, and the improvement of the Yunnan electric power market is effectively promoted.
Drawings
FIG. 1 is a schematic diagram of the system architecture of the present invention.
FIG. 2 is a schematic flow diagram of the process of the present invention.
Fig. 3 is a flow of calculation of a proxy service fee calculation formula.
Fig. 4 is a proxy service fee calculation formula calculation logic.
In the figure: the system comprises a 101 user login module, a 102 package template management module, a 103 first display module, a 104 historical data management module, a 105 second display module, a 106 user-defined package optional content management module, a 107 user-defined package generation module, a 108 user-defined package trial calculation module, a 109 third display module, a 110 user-defined package audit module, a 111 user-defined package settlement module and a 112 fourth display module.
Detailed Description
The following further describes a specific embodiment of the present invention with reference to the drawings and technical solutions.
As shown in fig. 1, a retail package management system for electric power transaction in a custom profit model includes:
the user login module 101 is used for inputting login information by the user login system, allowing the user to login the system after verification is passed, and not allowing the user to login the system; the categories of users include electricity selling companies, agent users and electricity trading institutions; the agent user mainly refers to a user who has signed an agent contract with an electric power selling company; the electric power transaction mechanism is used as a system manager and is used for auditing the contents of retail service packages generated by agent users and electric power selling companies, such as contract types, agent service fee calculation formulas, signing periods and the like.
The package template management module 102 is connected with the user login module 101 and is used for the user and the power selling company to select the existing retail service package template of the system to sign a retail service contract. The package template preset by the system mainly comprises the following main flows: price difference income type package, contract energy management type package, agency service type package and step charging type package. After the template is selected, a corresponding retail service package can be generated only by filling key information in the template, wherein the key information comprises: the electricity consumption of the user in the current month, the transaction electricity of the user in the current month and the like.
And the first display module 103 is connected to the package template management module 102 and is configured to display the package templates preset by the system and the detailed contents of each template.
And the historical data management module 104 is connected with the user login module 101 and is used for managing and maintaining the historical fee calculation information of the agent users of the power selling companies. Wherein the historical settlement information refers to data in a user historical settlement list provided by the settlement part of the trading center. The historical data management module 104 analyzes and extracts the cell contents after acquiring the proxy user historical accounting list through a third-party system, establishes a mapping relation among data names, variable names and specific numerical values, maintains and manages the mapping relation according to actual use requirements, and finally obtains a parameter dictionary of the user accounting list.
And the second display module 105 is connected with the user login module 101 and the historical data management module 104, and is used for visualizing the historical fee calculation data of the agent user and providing related data operation functions of querying and counting according to keywords such as month, account number, account name and data name.
And the custom package optional content management module 106 is connected with the user login module 101 and connected with the historical data management module 104 and is used for managing the custom package optional content. The package optional content comprises calculation parameters, operation symbols, condition symbols, relation symbols and logic symbols. The calculation parameters refer to user calculation cost parameters selected from a parameter dictionary maintained by the historical data management module 104; the operation sign refers to mathematical operation signs such as addition, subtraction, multiplication, division and the like; the condition symbol refers to a conditional expression keyword such as if, else, etc.; the relationship symbols refer to < (less), > (greater) and! Relational expression keywords such as ═ (not equal); the logical symbols refer to the logical expression keys of | | (or), & & (and), etc.
And the custom package generation module 107 is connected with the user login module 101 and connected with the custom package optional content management module 106, and is used for generating a custom package. The power selling company selects the package optional content maintained by the user-defined package optional content management module 106 to customize a personalized and targeted agent service fee calculation formula according to the electricity utilization characteristics of the agent user.
And the custom package trial calculation module 108 is connected with the user login module 101 and connected with the custom package generation module 107, and is used for trial calculation of the package proxy service fee calculation formula customized by the custom package generation module to ensure the correctness of formula editing. The custom package trial calculation module 108 analyzes the expression of the calculation formula, extracts the calculation parameters, the operation symbols, the condition symbols, the relationship symbols and the logic symbols in the formula, obtains the actual values of the calculation parameters through the mapping relationship of the parameter dictionary, and finally calculates the result of the calculation formula.
And the third display module 109 is connected with the user login module 101, connected with the custom package generation module 107, and configured to display the custom package signed by the power selling company and the agent user and the detailed content thereof, and provide related data operation functions such as query and statistics according to keywords such as month, account number, account name, package name, and the like.
And the custom package auditing module 110 is connected with the user login module 101, the custom package trial calculation module 108 and the fourth display module 109, and is used for auditing custom packages signed by the electric power selling company and the user by the user in the transaction center. The user of the transaction center logs in the custom package auditing module 110, checks the detailed content of the custom package, calls the custom package trial calculation module 108 to calculate the result of the agent service fee calculation formula, and confirms whether the custom package passes through the calculation result.
And the custom package settlement module 111 is connected with the user login module 101, is connected with the third display module 109, and is used for the electricity selling company to obtain the fee calculation information of the agent user in the current settlement market, and then settle the agent service fee according to the signed custom package to generate a fee calculation basis.
And a fourth display module 112, connected to the user login module 101, and connected to the custom package settlement module 111, for displaying the calculation result of the custom package signed by the electricity selling company and the agent user in the current settlement market, and providing the function of querying and counting the related data according to the keywords such as month, account number, account name, package name, and the like.
A package management method for generating and settling a user-defined package of an electric power selling company is adopted, and the package management system for generating and settling the user-defined package of the electric power selling company comprises the following steps:
the first step is as follows: user login: the user inputs login information through the user login module 101, and the user is allowed to log in the system after the verification is passed, otherwise, the user is not allowed to log in the system; the user category comprises an electricity selling company, an agent user and an electric power transaction mechanism; the agent advocacy refers to a user who has signed an agent relationship with an electric power selling company; the electric power transaction mechanism is used as a system administrator for controlling the start and completion of each step, such as the management and maintenance of historical fee calculation information, the management and maintenance of package optional contents, self-set package audit and the like.
The second step is that: historical accounting information management and maintenance: the system administrator logs in the historical data management module 104, acquires all historical accounting lists of users who sign agency relations with the power selling companies through the third-party system, and then analyzes each display field and the actual numerical value thereof in the lists. Such as Settlement month-201910, Settlement house number-XXXXXXXX, actual power usage-XXXX, etc. Then, a mapping relation among the data name, the variable name and the specific numerical value is established, and then the data is stored in a database according to the established mapping relation, so that management and maintenance are facilitated.
The third step: managing and maintaining package optional contents: the system administrator logs in the custom package optional content management module 106, and selects a required parameter name from the mapping relationship established by the historical data management module 104 according to the settlement rules of the power selling company in the market, for example: actual electricity consumption of the user, monthly transaction electricity of the user, daily transaction electricity of the user and the like; optional operation symbols, condition symbols, relationship symbols and logic symbols are then set.
The fourth step: and (3) generating a custom package: the operator of the electricity selling company logs in the custom package generation module 107, checks the selectable content of the current custom package, and then, according to the electricity utilization characteristics of the agent user, for example: the user concentrates on electricity consumption in peak time period, the contract performance rate of the user is low, and the like, a targeted agent service fee calculation formula is compiled, and a custom package contract is generated at the same time.
The fifth step: and (4) trial calculation of the user-defined package: the operator of the power selling company logs in the custom package trial calculation module 108 to check and trial calculate the formula edited in the custom package generation module 107. The verification content comprises the following steps: and calculating the correctness of formula editing and the reasonability of formula editing. After the verification, the operator of the power selling company extracts the historical calculation cost information of the agent user from the historical data management module 104, substitutes the historical data into a formula for trial calculation, analyzes the calculation result and judges whether the custom package can meet the requirements of the agent user and simultaneously maximizes the benefits of both parties. While the custom package content is presented on the third display module 109.
And a sixth step: and (4) self-defining package audit: the system administrator logs in the custom package auditing module 110 to audit the custom package contract signed by the power selling company and the agent user, and the custom package contract takes effect formally after the audit is passed and is used for calculating the agent service fee in the next month.
The seventh step: self-defined package settlement: the operator of the electricity selling company logs in the custom package settlement module 111, selects the agent user needing settlement and then enters the settlement market, calculates the agent service fee of the current settlement market of the agent user according to the signed custom package contract content, generates a settlement list as a charging proof according to the calculation result, and displays the calculation result on the fourth display module 112.
When the system and the method are applied, the system and the method can be used for services such as management and settlement of retail packages at the electricity selling side, and are not particularly limited.
The flow chart of the application example of the invention is shown in figure 2.
Usually, the power transaction system administrator logs in the system and extracts the monthly calculation fee list of the agent user of the power selling company to the third party system through the historical data management module 104, wherein the unit of the electric quantity in the list is kWh, and the unit of the electricity price is yuan/kWh. And finally, storing the data into a database according to the established mapping relation so as to be convenient for management and maintenance. In the settling market, the power transaction system administrator can also obtain the monthly calculation fee list of the power selling company proxy user from the third-party system through the historical data management module 104 so as to enable the power selling company to perform normal settlement.
The calculation formula of part of the parameters in the list is as follows:
(1) electricity charge f for ith day trade contracti, day-ahead contractComprises the following steps:
fi, day-ahead contract＝pi, day-ahead contract×min(qi, day-ahead contract,qi, practice before day) (1.1)
In the formula: p is a radical ofi, day-ahead contractThe day-ahead transaction of the ith day of the userEasy contract price, qi, day-ahead contractTrading volume of electricity q for the ith day of the useri, practice before dayThe actual electricity consumption amount of the user on the ith day.
(2) Negative deviation electric quantity of day-to-day transaction
Comprises the following steps:
(3) negative deviation electricity fee for ith day transaction
Comprises the following steps:
in the formula: user daily transaction deviation electric quantity examination price pDeviation before the day0.03 yuan/kwh.
(4) User monthly and daily transaction electric charge fSettlement before the dayComprises the following steps:
in the formula: i is the total days of the month.
(5) User daily transaction monthly accumulated settlement electric quantity qSettlement before the dayComprises the following steps:
(6) monthly contract electric quantity q of userMonthly contractFor the sum of monthly intra-provincial transaction electricity, i.e.
qMonthly contract＝qBilateral negotiation+qContinuous hanging plate+qPrior assignment+qAfter-the-fact transfer(1.6)
In the formula: i is the total days in the month; q. q.sBilateral negotiationFor bilateral negotiationTransaction electric quantity; q. q.sContinuous hanging plateTrading traffic electricity for continuous listing transaction; q. q.sPrior assignmentThe transaction electric quantity is formed for the prior transfer transaction; q. q.sAfter-the-fact transferAnd (4) forming transaction electric quantity for the subsequent transfer transaction.
(7) Monthly contract electric quantity price p of userMonthly contractComprises the following steps:
in the formula: p is a radical ofBilateral negotiationTrading contract prices for both sides; p is a radical ofContinuous hanging plateTrading contract prices for successive branding; p is a radical ofPrior assignmentContract prices for prior transfers; p is a radical ofAfter-the-fact transferContract prices are traded for subsequent transfer.
(8) Monthly contract electric charge f for userMonthly contractComprises the following steps:
f＝pmonthly contract×min(qMonthly contract,qPractice of the moon-qSettlement before the day) (1.8)
In the formula: q. q.sPractice of the moonThe actual monthly electricity consumption of the user.
(9) Monthly positive deviation electricity quantity of user
Comprises the following steps:
(10) monthly positive deviation electricity charge for users
Comprises the following steps:
in the formula:
for the monthly degree of the userPositive deviation electricity prices.
(11) Negative offset electric quantity of user
Comprises the following steps:
(12) user monthly negative deviation electricity charge
Comprises the following steps:
in the formula:
the monthly negative offset electricity prices are for the user.
After the user list data is maintained, the power transaction system administrator logs in the system, selects a required parameter name from the mapping relation established by the historical data management module 104 as a calculation parameter according to the settlement rule of the power selling company in the market through the user-defined package optional content management module 106, and then sets an optional operation symbol, a condition symbol, a relation symbol and a logic symbol. The calculation parameters, the operation symbols, the condition symbols, the relation symbols and the logic symbols together form the optional content of the user-defined package. Calculating parameters as a subset of a user fee parameter mapping set; the operation sign comprises: addition, subtraction, multiplication, division, etc.; conditional symbols include if (if), else (else), etc.; the relationship symbol includes: greater than (>), less than (<), and not equal to (| >), etc.; logical symbols refer to or (| |), and (& &), etc.
After the maintenance of the optional content of the custom package is finished, the operator of the power selling company logs in the system and edits the agent service fee calculation formula of the custom package through the custom package generation module 107. By combining the calculation parameters, the operation symbols, the condition symbols, the relationship symbols and the logic symbols, a highly flexible calculation formula can be edited according to the user attributes, the electricity consumption characteristics and the user requirements, and the specific contents of the package are displayed on the third display module 109 after the editing is completed.
After the user-defined package is edited, the operator of the power selling company extracts the historical calculation cost data of the user according to the mapping relation of the calculation parameters through the user-defined package trial calculation module 108, substitutes the historical calculation cost data into the formula for trial calculation, and ensures the correctness and the rationality of the agent service cost calculation formula, wherein the calculation flow is shown in fig. 3. Execution flow of if statement: firstly, judging the value of a condition expression in parentheses after a keyword if, if the value of the expression is logical true (not 0), executing an if body, and then executing other statements after the if body; otherwise, if the value of the expression is logic false (0), the if body is not executed, and other statements after the if body are directly executed, where the specific logic is as shown in fig. 4. After the trial calculation is completed and the formula is confirmed to be accurate, the electricity selling company can analyze whether the formula can meet the requirements of the users and maximize the benefits of the two parties by calculating the agency service usage of the users at different periods.
After the power selling company confirms that the formula is correct, a self-defined package contract is submitted for a system administrator to check. The system administrator logs in the system, and checks the custom package contract submitted by the power selling company through the custom package checking module 110, and the custom package contract takes effect formally after the checking is passed and is used for calculating the agent service fee in the next month.
After the settlement of the electricity selling company is started, an operator of the electricity selling company logs in the custom package settlement module 111, selects an agent user needing settlement and then enters a settlement market, calculates the agent service cost of the current settlement market of the agent user according to the signed custom package contract content, generates a settlement list as a charging voucher according to the calculation result, and displays the result in the fourth display module 112.
Claims (2)
1. The electric power transaction retail package management system with the user-defined income mode is characterized by mainly comprising a user login module (101), a package template management module (102), a first display module (103), a historical data management module (104), a second display module (105), a user-defined package optional content management module (106), a user-defined package generation module (107), a user-defined package trial calculation module (108), a third display module (109), a user-defined package audit module (110), a user-defined package settlement module (111) and a fourth display module (112);
the user login module (101) is used for inputting login information by the user login system, allowing the user to login the system after verification is passed, and not allowing the user to login the system; the categories of users include electricity selling companies, agent users and electricity trading institutions; the agent user refers to a user who has signed an agent contract with an electric power selling company; the electric power transaction mechanism is used as a system manager and is used for auditing the contents of the retail service package generated by the agent user and the power selling company, wherein the contents comprise contract types, agent service fee calculation formulas and signing periods;
the package template management module (102) is connected with the user login module (101) and is used for selecting the existing retail service package template of the system to sign a retail service contract by the agent user and the power selling company; the package template preset by the system comprises a price difference income type package, a contract energy management type package, an agent service type package and a step charging type package; after the package template is selected, only the key information in the package template needs to be filled in to generate a corresponding retail service package, wherein the key information comprises the monthly electricity consumption of the agent user and the monthly transaction electricity consumption of the agent user;
the first display module (103) is connected with the package template management module (102) and the user login module (101) and is used for displaying package templates preset by the system and detailed contents of the templates;
the historical data management module (104) is connected with the user login module (101) and is used for managing and maintaining historical fee calculation information of the power selling companies and the agent users; wherein, the historical accounting information refers to the data in the user historical settlement list provided by the settlement part of the trading center; the historical data management module (104) analyzes and extracts the cell contents after acquiring the proxy user historical settlement list through a third-party system, establishes the mapping relation among data names, variable names and specific numerical values, maintains and manages the obtained mapping relation according to actual use requirements, and finally obtains a parameter dictionary of the proxy user settlement list;
the second display module (105) is connected with the historical data management module (104) and the user login module (101) and is used for visualizing the historical fee calculation data of the agent user and providing the operation functions of inquiring and counting related data according to keywords comprising the month, the user number, the user name and the data name;
the user-defined package optional content management module (106) is connected with the user login module (101) and the historical data management module (104) and is used for managing user-defined package optional content; the package optional content comprises calculation parameters, operation symbols, condition symbols, relation symbols and logic symbols; the calculation parameters refer to user calculation cost parameters selected from a parameter dictionary maintained by the historical data management module (104); the operation sign means that the operation sign comprises addition, subtraction, multiplication and division mathematical operation signs; the conditional notation refers to a conditional expression keyword; the relational symbols refer to relational expression keywords; the logical symbol refers to a logical expression keyword;
the user-defined package generation module (107) is connected with the user login module (101) and the user-defined package optional content management module (106) and is used for generating the user-defined package; the power selling company selects the package optional content maintained by the user-defined package optional content management module (106) to customize a personalized and targeted agent service fee calculation formula according to the electricity utilization characteristics of the agent user;
the user-defined package trial calculation module (108) is connected with the user login module (101) and the user-defined package generation module (107) and is used for trial calculation of the package proxy service fee calculation formula customized by the user-defined package generation module and ensuring the correctness of formula editing; the user-defined package trial calculation module (108) analyzes the expression of the calculation formula, extracts calculation parameters, operation symbols, condition symbols, relationship symbols and logic symbols in the formula, obtains actual numerical values of the calculation parameters through the mapping relation of the parameter dictionary, and finally calculates the result of the calculation formula;
the third display module 109 is connected with the user login module (101) and the custom package generation module (107), and is used for displaying the custom package signed by the power selling company and the agent user and the detailed content thereof, and providing the operation functions of searching and counting related data according to keywords including month, account number, account name and package name;
the custom package auditing module (110) is connected with the user login module (101), the custom package trial calculation module (108) and the fourth display module 109 and is used for auditing custom packages signed by the electric power selling company and the user by the user in the transaction center; a user of the transaction center logs in a self-defined package auditing module (110), checks the detailed content of the self-defined package, calls a self-defined package trial calculation module (108) to calculate the result of a proxy service fee calculation formula, and confirms whether the self-defined package passes or not according to the calculation result;
the custom package settlement module (111) is connected with the user login module (101) and the third display module 109 and is used for an electric power selling company to obtain the fee calculation information of the agent user in the current settlement market, and then settlement is carried out on the agent service fee according to the signed custom package to generate a fee calculation basis;
and the fourth display module (112) is connected with the user login module (101) and the custom package settlement module (111) and is used for displaying the calculation result of the custom package signed by the power selling company and the agent user in the current settlement market and providing the operation functions of searching and counting related data according to keywords including month, account number, account name and package name.
2. A self-defined income mode electric power transaction retail package management method, which adopts the self-defined income mode electric power transaction retail package management system of claim 1, characterized by comprising the following steps:
the first step is as follows: user login: the user inputs login information through the user login module (101), and the user is allowed to log in the system after the user passes the verification, otherwise, the user is not allowed to log in the system; the user category comprises an electricity selling company, an agent user and an electric power transaction mechanism; the agent advocacy refers to a user who has signed an agent relationship with an electric power selling company; the electric power transaction mechanism is used as a system administrator and used for controlling the start and completion of each step, including the management and maintenance of historical fee calculation information, the management and maintenance of package optional contents and self-set package audit;
the second step is that: historical accounting information management and maintenance: a system administrator logs in a historical data management module (104), acquires historical accounting lists of all users signing a proxy relationship with a power selling company through a third-party system, and analyzes each display field and actual numerical values thereof in the lists, wherein the display fields comprise settlement months, settlement house numbers and actual electricity consumption; then, establishing a mapping relation among the data name, the variable name and the specific numerical value, and storing the data into a database according to the established mapping relation for convenient management and maintenance;
the third step: managing and maintaining package optional contents: a system administrator logs in a user-defined package optional content management module (106), and selects a required parameter name from a mapping relation established by a historical data management module (104) according to an electric power selling company settlement rule in the market, wherein the parameter name comprises the actual electric power consumption of a user, monthly transaction electric quantity of the user and daily transaction electric quantity of the user; then setting selectable operation symbols, condition symbols, relation symbols and logic symbols;
the fourth step: and (3) generating a custom package: an operator of an electric power selling company logs in a user-defined package generating module (107), checks the selectable content of the current user-defined package, then compiles a targeted agent service fee calculation formula according to the electricity utilization characteristics of agent users, and simultaneously generates a user-defined package contract;
the fifth step: and (4) trial calculation of the user-defined package: an operator of the power selling company logs in a custom package trial calculation module (108) to check and trial calculate the formula edited in the custom package generation module (107); the verification content comprises the following steps: calculating the correctness of formula editing and the reasonability of formula editing; after the verification is passed, an operator of the power selling company extracts the historical calculation fee information of the agent user from the historical data management module (104), substitutes the historical data into a formula for trial calculation, analyzes the calculation result and judges whether the custom package can meet the requirement of the agent user and simultaneously maximizes the benefits of both parties; meanwhile, the self-defined package content is displayed on a third display module (109);
and a sixth step: and (4) self-defining package audit: a system administrator logs in a custom package auditing module (110) to audit a custom package contract signed by an electric power selling company and an agent user, and the custom package contract takes effect formally after the audit is passed and is used for calculating the agent service fee in the next month;
the seventh step: self-defined package settlement: the operator of the electricity selling company logs in the custom package settlement module (111), selects an agent user needing settlement and then enters a settlement market, calculates the agent service fee of the current settlement market of the agent user according to the signed custom package contract content, generates a settlement list as a charging proof according to the calculation result, and displays the calculation result on the fourth display module (112).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911254477.1A CN111062747A (en) | 2019-12-10 | 2019-12-10 | Electric power transaction retail package management system and method with user-defined income mode |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911254477.1A CN111062747A (en) | 2019-12-10 | 2019-12-10 | Electric power transaction retail package management system and method with user-defined income mode |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111062747A true CN111062747A (en) | 2020-04-24 |
Family
ID=70300407
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911254477.1A Pending CN111062747A (en) | 2019-12-10 | 2019-12-10 | Electric power transaction retail package management system and method with user-defined income mode |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111062747A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112261601A (en) * | 2020-10-20 | 2021-01-22 | 北京思特奇信息技术股份有限公司 | Mobile tariff ordering method and system based on user self-customization |
| CN112950322A (en) * | 2021-03-11 | 2021-06-11 | 昆明电力交易中心有限责任公司 | Power retail package recommendation method and system based on collaborative filtering optimization |
| CN112950316A (en) * | 2021-03-02 | 2021-06-11 | 昆明电力交易中心有限责任公司 | Electric retail package vector representation method based on fine adjustment BERT model |
| CN112967110A (en) * | 2021-03-22 | 2021-06-15 | 昆明电力交易中心有限责任公司 | Income settlement system and method for flexibly setting retail packages by self-adaptive electricity selling company |
| CN113379541A (en) * | 2021-05-24 | 2021-09-10 | 昆明电力交易中心有限责任公司 | Comprehensive settlement system and method for loss and benefit of electric power retail |
| CN113505338A (en) * | 2021-07-20 | 2021-10-15 | 昆明电力交易中心有限责任公司 | Electric power retail package purchase electric quantity intelligent adjusting device under electric power market environment |
| CN113506141A (en) * | 2021-07-21 | 2021-10-15 | 昆明电力交易中心有限责任公司 | Standardized electric power retail package settlement system and method |
| CN113570426A (en) * | 2021-07-20 | 2021-10-29 | 昆明电力交易中心有限责任公司 | Electric power transaction system and method based on standard retail package |
| CN113743743A (en) * | 2021-08-12 | 2021-12-03 | 广州汇电云联互联网科技有限公司 | Method and device for screening transaction combinations of electricity selling companies |
| CN113744052A (en) * | 2021-08-12 | 2021-12-03 | 广州汇电云联互联网科技有限公司 | Method, device and system for online settlement and application of electric charge settlement transaction contract |
| CN117521898A (en) * | 2023-11-10 | 2024-02-06 | 国网山东省电力公司营销服务中心(计量中心) | Electric charge settlement optimization method and system based on association analysis |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105933126A (en) * | 2016-04-14 | 2016-09-07 | 北京思特奇信息技术股份有限公司 | Package generation method and system of C2B2C mode |
| CN110210971A (en) * | 2019-05-31 | 2019-09-06 | 大连理工大学 | A kind of power retailing transaction system and method coupling wholesale market |
| CN110321606A (en) * | 2019-06-20 | 2019-10-11 | 昆明电力交易中心有限责任公司 | Long-term electricity transaction market settlement analogue system and method in one kind |
-
2019
- 2019-12-10 CN CN201911254477.1A patent/CN111062747A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105933126A (en) * | 2016-04-14 | 2016-09-07 | 北京思特奇信息技术股份有限公司 | Package generation method and system of C2B2C mode |
| CN110210971A (en) * | 2019-05-31 | 2019-09-06 | 大连理工大学 | A kind of power retailing transaction system and method coupling wholesale market |
| CN110321606A (en) * | 2019-06-20 | 2019-10-11 | 昆明电力交易中心有限责任公司 | Long-term electricity transaction market settlement analogue system and method in one kind |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112261601A (en) * | 2020-10-20 | 2021-01-22 | 北京思特奇信息技术股份有限公司 | Mobile tariff ordering method and system based on user self-customization |
| CN112950316A (en) * | 2021-03-02 | 2021-06-11 | 昆明电力交易中心有限责任公司 | Electric retail package vector representation method based on fine adjustment BERT model |
| CN112950316B (en) * | 2021-03-02 | 2023-09-29 | 昆明电力交易中心有限责任公司 | Fine adjustment BERT model-based power retail package vector representation method |
| CN112950322A (en) * | 2021-03-11 | 2021-06-11 | 昆明电力交易中心有限责任公司 | Power retail package recommendation method and system based on collaborative filtering optimization |
| CN112950322B (en) * | 2021-03-11 | 2023-09-26 | 昆明电力交易中心有限责任公司 | Collaborative filtering optimization-based power retail package recommendation method and system |
| CN112967110B (en) * | 2021-03-22 | 2023-07-04 | 昆明电力交易中心有限责任公司 | Revenue settlement system and method for flexibly setting retail packages by self-adaptive electricity selling company |
| CN112967110A (en) * | 2021-03-22 | 2021-06-15 | 昆明电力交易中心有限责任公司 | Income settlement system and method for flexibly setting retail packages by self-adaptive electricity selling company |
| CN113379541A (en) * | 2021-05-24 | 2021-09-10 | 昆明电力交易中心有限责任公司 | Comprehensive settlement system and method for loss and benefit of electric power retail |
| CN113379541B (en) * | 2021-05-24 | 2023-05-02 | 昆明电力交易中心有限责任公司 | Comprehensive settlement system and method for retail power consumption and damage |
| CN113570426B (en) * | 2021-07-20 | 2023-06-13 | 昆明电力交易中心有限责任公司 | Electric power transaction system and method based on standard retail package |
| CN113570426A (en) * | 2021-07-20 | 2021-10-29 | 昆明电力交易中心有限责任公司 | Electric power transaction system and method based on standard retail package |
| CN113505338A (en) * | 2021-07-20 | 2021-10-15 | 昆明电力交易中心有限责任公司 | Electric power retail package purchase electric quantity intelligent adjusting device under electric power market environment |
| CN113505338B (en) * | 2021-07-20 | 2023-11-24 | 昆明电力交易中心有限责任公司 | Intelligent electric quantity adjusting device for electric retail package purchase under electric power market environment |
| CN113506141A (en) * | 2021-07-21 | 2021-10-15 | 昆明电力交易中心有限责任公司 | Standardized electric power retail package settlement system and method |
| CN113506141B (en) * | 2021-07-21 | 2024-01-23 | 昆明电力交易中心有限责任公司 | Standardized power retail package settlement system and method |
| CN113743743A (en) * | 2021-08-12 | 2021-12-03 | 广州汇电云联互联网科技有限公司 | Method and device for screening transaction combinations of electricity selling companies |
| CN113744052A (en) * | 2021-08-12 | 2021-12-03 | 广州汇电云联互联网科技有限公司 | Method, device and system for online settlement and application of electric charge settlement transaction contract |
| CN113743743B (en) * | 2021-08-12 | 2024-07-23 | 广州汇电云联互联网科技有限公司 | Screening method and device for transaction combination of electricity selling company |
| CN117521898A (en) * | 2023-11-10 | 2024-02-06 | 国网山东省电力公司营销服务中心(计量中心) | Electric charge settlement optimization method and system based on association analysis |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111062747A (en) | Electric power transaction retail package management system and method with user-defined income mode | |
| US7949555B2 (en) | Tariff generation, invoicing and contract management | |
| US20030055664A1 (en) | Method and system for the management of structured commodity transactions and trading of related financial products | |
| CN111198873B (en) | Data processing method and device | |
| CN107507103A (en) | A kind of computational methods and device of the clearing of Electricity retail market marketization electricity | |
| WO2021114674A1 (en) | Method and apparatus for determining strategy for medium- and long-term purchase and sale of electricity | |
| CN107730398A (en) | The recommendation method, apparatus and storage medium of electricity consumption charging mode | |
| AU2001267953A1 (en) | Tariff generation, invoicing and contract management | |
| CN109325537A (en) | Power utilization management method and device, computer equipment and storage medium | |
| CN114331716A (en) | Energy storage type load aggregator participation interactive transaction method | |
| CN104137475B (en) | Method and apparatus for charging | |
| CN116342130A (en) | Intelligent settlement service system for small amount of pre-charge electric charge | |
| CN103959319A (en) | Configurable billing with subscriptions having conditional components | |
| CN115277271A (en) | Charging management method of hybrid cloud under micro-service architecture | |
| CN113011964A (en) | Group integrated product management method and device | |
| Yin et al. | Research on the development of domestic and foreign electricity sales markets serving the construction of electricity retail markets | |
| CN112364058B (en) | Auditing method and device for commodity price configuration | |
| Zhu et al. | Research on the Application Mode of Smart Contract Technology in Targeted Payment | |
| CN116644915A (en) | Engineering project management flow system and method | |
| Lin et al. | Design and Application of Customer Services Business Middle Platform for Opening Service Capabilities of Electric Power Marketing | |
| Dietz et al. | PacifiCorp’s Integration Bus Is Helping To Implement Retail Access | |
| Li et al. | Design and Application of Error Clearing Method for Electricity Retail Market Based on Minimization Method | |
| Guohui et al. | Research on Payment, Clearing and Settlement System Based on Electric Vehicle Intelligent Networking Platform | |
| TWM604012U (en) | Environmental and social external performance evaluation module | |
| Ahmed et al. | UTILITIES, ENVIRONMENTAL EFFICIENCY, AND CORPORATE RESPONSIBILITY SURROUNDING INNOVATIVE RATE DESIGN |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230609 Address after: No.73 Tuodong Road, Guandu District, Kunming, Yunnan 650011 Applicant after: KUNMING ELECTRIC POWER TRANSACTION CENTER CO.,LTD. Address before: 116024 No. 2 Ling Road, Ganjingzi District, Liaoning, Dalian Applicant before: DALIAN University OF TECHNOLOGY Applicant before: KUNMING ELECTRIC POWER TRANSACTION CENTER CO.,LTD. |