JP6444554B1 - Charge calculation device and charge calculation program - Google Patents

Abstract

An object of the present invention is to flexibly execute calculation processing of charges such as electric power. A determination unit 22 includes: contractor information indicating a location and plan ID for each contractor; plan information indicating charge calculation information for each plan ID; and meter reading information indicating a usage amount for each location. It is determined whether at least one piece of information has been updated. The calculation unit 23 is triggered by the fact that the determination unit 22 determines that it has been updated, and the charge calculation information indicated by the plan information for the plan ID indicated by the contractor information of the target contractor and the contract of the target contractor The fee for the target contractor is calculated using the usage indicated by the meter reading information for the location indicated by the subscriber information. [Selection] Figure 1

Description

  The present invention relates to a technique for calculating a charge such as electric power.

Since the full liberalization of electricity retail, many operators have entered the electricity retail market. Many small-scale electric power utilities existed.
The calculation of the electricity charge for each contractor differs depending on the contract contents. A major electric power company can spend a large amount of money to introduce a comprehensive computer system such as a contract management system and a charge calculation system to appropriately manage contract contents and calculate power charges. On the other hand, it is difficult for a small electric power company to spend a lot of money on a computer system. For this reason, data may be managed partly manually using spreadsheet software or the like. For example, when the contract content changes, the contract content data may be manually updated.

  In the conventional charge calculation system, the calculation of the power charge is performed at a fixed timing such as monthly processing (see Patent Document 1).

JP 2014-093056 A

When a large computer system is in use, such as a major electric power company, the computer system is such that changes in the contract contents are reflected in the calculation process of the power charge at an appropriate timing. Therefore, it is sufficient to calculate the power rate at a fixed timing such as monthly processing.
However, unlike a small electric power company, it does not have a complete computer system, and contract content data may be updated manually. In this case, if the monthly processing is executed before the contract content data is updated, recalculation occurs, which imposes pressure on the usage rate of the computer system and requires processing time. In addition, if there is no mechanism for determining that the contract details have been updated, an erroneous power charge may be calculated using the data before the update.
It is an object of the present invention to make it possible to flexibly execute calculation processing of charges such as electric power.

The fee calculation device according to the present invention is:
At least one of the contractor information indicating the location and plan ID for each contractor, the plan information indicating the charge calculation information for each plan ID, and the meter reading information indicating the usage amount for each location is updated. A determination unit for determining whether or not,
Triggered by the fact that it has been updated by the determination unit, the charge calculation information indicated by the plan information for the plan ID indicated by the contractor information of the target contractor, and the contractor of the target contractor A calculation unit that calculates a charge for the target contractor using the usage indicated by the meter reading information for the location indicated by the information.

  In the present invention, the fee is calculated by using at least one of the contractor information, the plan information and the meter reading information as a trigger. Thereby, a fee is calculated when the contractor information is updated by manual work or the like. Therefore, it is possible to flexibly execute calculation processing of charges such as electric power.

1 is a configuration diagram of a fee calculation apparatus 10 according to Embodiment 1. FIG. Explanatory drawing of the contractor information which the contractor information storage part 31 which concerns on Embodiment 1 memorize | stores. Explanatory drawing of the plan information which the charge plan memory | storage part 32 which concerns on Embodiment 1 memorize | stores. Explanatory drawing of the meter-reading information which the meter-reading information storage part 33 which concerns on Embodiment 1 memorize | stores. Explanatory drawing of the calculation information which the calculation information storage part 34 which concerns on Embodiment 1 memorize | stores. 5 is a flowchart of update processing according to the first embodiment. Explanatory drawing of the contractor individual vote which concerns on Embodiment 1. FIG. 4 is a flowchart of fee calculation processing according to the first embodiment. Explanatory drawing of the charge piece 35 which concerns on Embodiment 1. FIG. The block diagram of the charge calculation apparatus 10 which concerns on the modification 1. FIG. The block diagram of the charge calculation apparatus 10 which concerns on Embodiment 2. FIG.

Embodiment 1 FIG.
*** Explanation of configuration ***
With reference to FIG. 1, the structure of the charge calculation apparatus 10 which concerns on Embodiment 1 is demonstrated.
The fee calculation apparatus 10 is a computer. In the first embodiment, the charge calculation device 10 calculates a power charge. However, the present invention is not limited to this, and the charge calculation device 10 may calculate other charges such as a gas charge and a water charge.

  The fee calculation apparatus 10 includes hardware including a processor 11, a memory 12, a storage 13, and a communication interface 14. The processor 11 is connected to other hardware via a signal line, and controls these other hardware.

  The processor 11 is an IC (Integrated Circuit) that performs processing. The processor 11 is a CPU (Central Processing Unit), a DSP (Digital Signal Processor), or a GPU (Graphics Processing Unit) as specific examples.

  The memory 12 is a storage device that temporarily stores data. As a specific example, the memory 12 is an SRAM (Static Random Access Memory) or a DRAM (Dynamic Random Access Memory).

  The storage 13 is a storage device that stores data. The storage 13 is an HDD (Hard Disk Drive) as a specific example. The storage 13 is an SD (registered trademark, Secure Digital) memory card, CF (CompactFlash, registered trademark), NAND flash, flexible disk, optical disk, compact disk, Blu-ray (registered trademark) disk, DVD (Digital Versatile Disk), or the like. It may be a portable recording medium.

  The communication interface 14 is an interface for communicating with an external device. As a specific example, the communication interface 14 is a port of Ethernet (registered trademark), USB (Universal Serial Bus), or HDMI (registered trademark, High-Definition Multimedia Interface).

The fee calculation apparatus 10 includes an update unit 21, a determination unit 22, and a calculation unit 23 as functional components. The function of each functional component of the fee calculation apparatus 10 is realized by software.
The storage 13 stores a program that realizes the function of each functional component of the fee calculation apparatus 10. This program is read into the memory 12 by the processor 11 and executed by the processor 11. Thereby, the function of each functional component of the fee calculation apparatus 10 is realized.

  The storage 13 realizes the functions of the contractor information storage unit 31, the charge plan storage unit 32, and the meter reading information storage unit 33. The calculation information storage unit 34 is configured on the memory 12 by the processor 11.

  In FIG. 1, only one processor 11 is shown. However, a plurality of processors 11 may be provided, and a plurality of processors 11 may execute programs that realize each function in cooperation with each other.

*** Explanation of operation ***
With reference to FIG. 2 to FIG. 9, the operation of the fee calculation apparatus 10 according to the first embodiment will be described.
The operation of the fee calculation apparatus 10 according to the first embodiment corresponds to the fee calculation method according to the first embodiment. The operation of the fee calculation apparatus 10 according to the first embodiment corresponds to the processing of the fee calculation program according to the first embodiment.

  As a premise for explaining the operation of the fee calculation apparatus 10 according to the first embodiment, information stored in the contractor information storage unit 31, the charge plan storage unit 32, the meter reading information storage unit 33, and the calculation information storage unit 34 will be described. .

With reference to FIG. 2, the contractor information stored in the contractor information storage unit 31 according to the first embodiment will be described.
The contractor information storage unit 31 stores information such as a subscription date, a cancellation date, a location, and a plan ID for each contractor ID. The contractor ID is an identifier of the contractor. The subscription date is the contract start date of the corresponding contract. The cancellation date is the contract termination date of the relevant contract. The location indicates the location where the power meter is installed. The plan ID is an identifier of the contract plan.
Here, there are a plurality of contract plans, and the charge system varies depending on the contract plan.

With reference to FIG. 3, the plan information stored in the charge plan storage unit 32 according to the first embodiment will be described.
The charge plan storage unit 32 stores charge calculation information for each plan ID. In FIG. 3, the charge calculation information stores a basic charge, a unit price, an additional item 1, an additional item 2, and a calculation formula. The basic charge is a charge required regardless of the amount of power used. The metered rate is calculated by multiplying the unit price and power consumption. The unit price may be set for each time period as shown in FIG. For example, different unit prices may be set for midnight hours and other times. The midnight time zone is, for example, from 23:00 to 5:00, and can be set arbitrarily.
Additional item 1 and additional item 2 are charges that are additionally required. As an example, the additional item 1 and the additional item 2 are renewable energy power generation promotion levy. The calculation formula is a calculation formula for calculating a fee for each plan ID using fee calculation information. As a specific example, the calculation formula of the electric power charge is basic charge + usage charge (unit price × use amount) + additional item 1 + additional item 2. Depending on the plan ID, the pay-as-you-go charges differ between midnight and non-midnight hours. For example, in P2, the formula for calculating the power charge is basic charge + metered charge (midnight time zone) + metered charge (other than midnight time zone) + additional item 1 + additional item 2.

With reference to FIG. 4, the meter-reading information which the meter-reading information storage part 33 which concerns on Embodiment 1 memorize | stores is demonstrated.
The meter reading information storage unit 33 stores the meter reading date and the usage amount for each location. The meter reading date is the date when the amount of electric power used is investigated with a meter. The usage amount is a value obtained by subtracting the previous meter reading value from the current meter reading value. That is, the usage amount is a value obtained by subtracting the previously measured meter reading value from the metered value measured on the meter reading date for the same location. The current meter reading value and the previous meter reading value may be stored as the usage amount. Further, the usage amount may indicate a value for each time zone. For example, when the unit price varies depending on the time zone as shown in FIG. 3, for example, the usage amount in the midnight time zone and the usage amount other than the midnight time zone may be separately expressed so that the calculation can be performed according to the time zone. Good.

The calculation information stored in the calculation information storage unit 34 according to the first embodiment will be described with reference to FIG. The calculation information storage unit 34 is information generated in the memory 12 by the contractor information storage unit 31, the charge plan storage unit 32, and the meter reading information storage unit 33 in order for the calculation unit 23 to calculate the power rate. The unit 23 also stores the calculation result.
The calculation unit 23 refers to the plan ID for each contractor ID from the contractor information storage unit 31, refers to the charge calculation information from the calculation plan storage unit 32, refers to the usage amount from the meter reading information storage unit 33, and And the calculation result is stored.

  Operation | movement of the fee calculation apparatus 10 which concerns on Embodiment 1 is demonstrated. The operation of the fee calculation apparatus 10 according to the first embodiment is roughly divided into update processing and fee calculation processing.

The update process according to the first embodiment will be described with reference to FIG.
(Step S11: Contractor information update process)
The update unit 21 acquires the contractor individual document in which the update contents of the contractor information are described, and updates the contractor information stored in the contractor information storage unit 31 based on the contractor individual document.
Specifically, the update unit 21 monitors the area for the contractor individual vote in the memory 12. When the data is written in the area of the contractor individual form, the update unit 21 acquires the written data as the contractor individual form. As shown in FIG. 7, the contractor individual form indicates contract details for a contractor. Specifically, the contractor individual form indicates information such as a contractor ID, a contractor name, a contact address, a location, and a plan ID.
When the updating unit 21 acquires the contractor individual card, the updating unit 21 searches the contractor information storage unit 31 for a record having the contractor ID indicated by the contractor individual card. When the record hits, the updating unit 21 updates the location of the record, the plan ID, and the like to information indicated by the contractor individual vote. On the other hand, when the record does not hit, the updating unit 21 adds the information indicated by the contractor piece to the contractor information storage unit 31.

(Step S12: rate plan acquisition process)
The update unit 21 displays information stored in the rate plan storage unit 32 and accepts input of update contents. When the update content is input, the update unit 21 updates the plan information stored in the rate plan storage unit 32 according to the input update content.
For example, when a new contract plan is set, a record of a new contract plan is added to the rate plan storage unit 32. Further, when the content of the contract plan including the charge calculation information is changed, the record of the contract plan to be changed is updated to the changed content.

(Step S13: Meter reading information update process)
The update unit 21 acquires the usage amount information transmitted by the power transmission and distribution company, and updates the meter reading information stored in the meter reading information storage unit 33 based on the usage amount information. The usage amount information indicates the meter reading date and the usage amount for each location. Meter reading information is transmitted from the power transmission / distribution company periodically or at an arbitrary timing.

With reference to FIG. 8, fee calculation processing according to the first embodiment will be described.
(Step S21: Update determination process)
In the update process, the determination unit 22 includes the contractor information stored in the contractor information storage unit 31, the plan information stored in the rate plan storage unit 32, and the meter reading information stored in the meter reading information storage unit 33. It is determined whether at least one piece of information has been updated.
If any information is updated, the determination unit 22 advances the process to step S22. On the other hand, the determination part 22 performs step S21 again after progress for a fixed time, when neither information is updated.
Note that the case where any information is updated coincides with the case where any information is updated in steps S11 to S13 shown in FIG. Therefore, the update unit 21 is configured to turn on the update flag when the update is determined in steps S11 to S13, and the determination unit 22 is configured to proceed to step S22 if the update flag is on in step S21. May be.
(Step S22: Object identification process)
The calculation unit 23 identifies the contractor affected by the updated information as the target contractor.
Specifically, when the contractor information is updated, the calculation unit 23 specifies the contractor indicated by the contractor ID of the updated record as the target contractor. Further, when the plan information is updated, the calculation unit 23 searches the contractor information storage unit 31 for a record having the plan ID of the updated plan information, and the contract indicated by the contractor ID of the searched record. Identify the contractor as the target contractor. Further, when the meter reading information is updated, the calculation unit 23 searches the contractor information storage unit 31 for a record having the location of the updated meter reading information, and the contractor indicated by the contractor ID of the retrieved record. Is identified as the target contractor.

(Step S23: Charge calculation processing)
The calculation unit 23 includes charge calculation information indicated by the plan information stored in the charge plan storage unit 32 for the plan ID indicated by the contractor information of the target contractor, and meter reading information regarding the location indicated by the contractor information of the target contractor. The charge for the target contractor is calculated using the usage amount indicated by the meter reading information stored in the storage unit 33.
Specifically, the calculation unit 23 calculates the charge for the contractor ID of the target contractor based on the basic charge indicated by the charge calculation information, the metered charge, the additional item 1 and the additional item 2, and the usage indicated by the meter reading information. Substitute into the formula for calculating the electricity rate included in the information. As a specific example, the basic charge is X, the unit price is Y, the additional item 1 is A, the additional item 2 is B, the usage amount is U, and the calculation formula of the power rate is basic rate + usage rate (unit price Y × usage amount U) + additional item 1 + additional item 2 In this case, the power charge is calculated by X + Y × U + A + B. Further, the calculation unit 23 stores the calculated electricity bill in the calculation information storage unit 34 as a calculation result. The calculation information storage unit 34 is transferred to and stored in the storage 13.

  That is, the calculation unit 23 calculates the power charge for the target contractor using the determination that it has been updated and the determination that it is the calculation timing as a trigger.

(Step S24: Charge information output process)
The calculation unit 23 generates a charge piece 35 indicating the power charge calculated based on the calculation information storage unit 34 for each target contractor, and writes it in the memory 12. As shown in FIG. 9, the charge unit 35 is bill data indicating information such as a contractor ID, a contractor name, a location, a plan ID, and a power charge.

*** Effects of Embodiment 1 ***
As described above, the fee calculation apparatus 10 according to the first embodiment calculates a fee by using at least one of the contractor information, the plan information, and the meter reading information as a trigger. Thereby, a fee is calculated when the contractor information is updated by manual work or the like. Therefore, it is possible to flexibly execute calculation processing of charges such as electric power.

  Moreover, the charge calculation apparatus 10 according to the first embodiment calculates only the power charge for the contractor affected by the updated information. Since unnecessary processing is not executed, the processing load is not increased unnecessarily.

For example, even though it is necessary to calculate the electricity rate after updating the contractor information, the contractor information is not updated and the periodic calculation timing is reached. Suppose that the calculation of the electricity charge has been made. Even in this case, by updating the contractor information, the power charges are promptly recalculated based on the updated contractor information. Therefore, when a contractor information is manually updated by a small electric power company or the like, a flexible response is possible.
In particular, power charges are recalculated only for contractors whose contractor information has been updated. Therefore, even if the charge calculation device 10 is configured using hardware with low processing capability, it is possible to calculate the difference in power charge in a short time.

*** Other configurations ***
<Modification 1>
In the first embodiment, each functional component is realized by software. However, as a first modification, each functional component may be realized by hardware. The first modification will be described with respect to differences from the first embodiment.

With reference to FIG. 10, the structure of the charge calculation apparatus 10 which concerns on the modification 1 is demonstrated.
When each functional component is realized by hardware, the fee calculation apparatus 10 includes an electronic circuit 15 instead of the processor 11, the memory 12, and the storage 13. The electronic circuit 15 is a dedicated circuit that realizes the functions of the functional components, the memory 12, and the storage 13.

Examples of the electronic circuit 15 include a single circuit, a composite circuit, a programmed processor, a parallel programmed processor, a logic IC, a GA (Gate Array), an ASIC (Application Specific Integrated Circuit), and an FPGA (Field-Programmable Gate Array). is assumed.
Each functional component may be realized by one electronic circuit 15 or may be realized by distributing each functional component to a plurality of electronic circuits 15.

<Modification 2>
As a second modification, some of the functional components may be realized by hardware, and other functional components may be realized by software.

  The processor 11, the memory 12, the storage 13, and the electronic circuit 15 are called processing circuits. That is, the function of each functional component is realized by the processing circuit.

Embodiment 2. FIG.
The second embodiment is different from the first embodiment in that various data are managed as the table data of the spreadsheet software. In the second embodiment, this different point will be described, and the description of the same point will be omitted.
The table data is data having one or more cells managed by the spreadsheet software, and numerical values or calculation formulas are input to the cells.

With reference to FIG. 11, a configuration of fee calculation apparatus 10 according to the second embodiment will be described.
The fee calculation apparatus 10 is shown in FIG. 1 in that the contractor information storage unit 31, the charge plan storage unit 32, the meter reading information storage unit 33, and the calculation information storage unit 34 are configured by table data of spreadsheet software. Different from the calculation device 10.

  In this case, the calculation formula of the power charge stored in the calculation information storage unit 34 is expressed as a formula in the spreadsheet software. In other words, the calculation formula of the electric power charge is expressed as a mathematical expression configured with reference to the spreadsheet software cell.

As described above, in the fee calculation apparatus 10 according to the second embodiment, the contractor information storage unit 31, the charge plan storage unit 32, the meter reading information storage unit 33, and the calculation information storage unit 34 are represented by the table data of the spreadsheet software. Composed. If it is spreadsheet data of spreadsheet software, it can be easily operated by a user who is not a computer engineer. Therefore, the user can easily change the plan information. Further, it is not necessary to prepare a screen for changing plan information separately, and the fee calculation apparatus 10 can be constructed at a low cost.
In the second embodiment, the calculation unit 23 generates a calculation information storage unit 34 and a charge piece 35, which are calculation results, as a spreadsheet software file.

  Further, in the charge calculation device 10 according to the second embodiment, the calculation formula of the power charge is expressed as a mathematical expression in the spreadsheet software. In the spreadsheet software, the cell name is used as a variable of the formula in the spreadsheet software. By making the cell name a word familiar to the user, a user who is not a computer engineer can understand the contents of the formula. Thereby, even when it is necessary to change the mathematical formula, the user can perform the change work without requesting an external supplier.

10 fee calculation device, 11 processor, 12 memory, 13 storage, 14 communication interface, 15 electronic circuit, 21 update unit, 22 determination unit, 23 calculation unit, 31
Contractor information storage unit, 32 price plan storage unit, 33 meter reading information storage unit, 34 calculation information storage unit.

Claims (6)

At least one of the contractor information indicating the location and plan ID for each contractor, the plan information indicating the charge calculation information for each plan ID, and the meter reading information indicating the usage amount for each location is updated. A determination unit for determining whether or not,
Triggered by the fact that it has been updated by the determination unit, the charge calculation information indicated by the plan information for the plan ID indicated by the contractor information of the target contractor, and the contractor of the target contractor A charge calculation apparatus comprising: a calculation unit that calculates a charge for the target contractor using a usage amount indicated by the meter reading information for a location indicated by the information. The fee calculation apparatus according to claim 1, wherein the calculation unit calculates the fee with a contractor affected by the updated information as the target contractor. The fee calculation apparatus according to claim 1 or 2, wherein the contractor information, the plan information, and the meter reading information are configured as spreadsheet data of spreadsheet software. The charge calculation apparatus according to claim 3, wherein the calculation unit calculates the charge by substituting the charge calculation information and the usage amount into a formula of the spreadsheet software. The charge calculation device according to claim 3 or 4, wherein the calculation unit generates a file of the spreadsheet software indicating the calculated charge for each target contractor. At least one of the contractor information indicating the location and plan ID for each contractor, the plan information indicating the charge calculation information for each plan ID, and the meter reading information indicating the usage amount for each location is updated. Determination processing for determining whether or not,
The charge calculation information indicated by the plan information for the plan ID indicated by the contractor information of the target contractor and the contractor of the target contractor, when triggered by the determination that it has been updated by the determination process A charge calculation program for causing a computer to execute a calculation process for calculating a charge for the target contractor using the usage indicated by the meter reading information for the location indicated by the information.

Images