Automating EB Consumption Charges Calculation for Multiple Domestic Connections Using UiPath

Automating EB Consumption Charges Calculation for Multiple Domestic Connections Using UiPath

Use Case Description

Mr. B. Bhuvaneswaran, a resident of Kancheepuram, Tamil Nadu, owns five houses across the city, each equipped with a Domestic Electricity Board (EB) connection. To manage his energy consumption and financial planning, Mr. Bhuvaneswaran records the electricity units consumed by each house every 10 days in an Excel file named TNEB.xlsx. He seeks a solution to automate the calculation of the Net amount for each house based on the recorded consumption units and the total amount for all EB connections. This would enable him to allocate his budget effectively. To assist him, an RPA bot can be developed using UiPath that reads the data from the TNEB.xlsx file, inputs the consumed units into the Tamil Nadu Electricity Board’s tariff calculator website (https://www.tnebnet.org/awp/tariffMaster), calculates the respective tariffs, and updates the Excel file with the Net amount for each house and the Total amount of all the EB connections. This automation will provide Mr. Bhuvaneswaran with the necessary financial insights, ensuring that he remains informed about his electricity expenses and can plan his budget accordingly.

Objective:
Automate the process of calculating the Net amount for electricity consumption for each of Mr. B. Bhuvaneswaran’s houses and the total amount for all connections using data from an Excel file and the TNEB tariff calculator website.

Prerequisites:

  1. UiPath Studio installed.
  2. Excel file (TNEB.xlsx) with columns:

| House Id. | Tariff Check | Billing cycle | Consumed Units | Net Amount |

101 | DOMESTIC | Bi-monthly | 400 |
102 | DOMESTIC | Bi-monthly | 300 |
103 | DOMESTIC | Bi-monthly | 500 |
104 | DOMESTIC | Bi-monthly | 200 |
105 | DOMESTIC | Bi-monthly | 100 |

  1. Access to the TNEB tariff calculator website: https://www.tnebnet.org/awp/tariffMaster.

AS-IS WORKFLOW, TO-BE WORKFLOW

Other information about the use case

Industry categories for this use case: Customer Service, Other Sector

Skill level required: Intermediate

UiPath Products that were used: UiPath Studio

Other applications that were used: Excel, Browser (Edge/Chrome/Firefox).

Other resources: -

What is the top ROI driver for this use case?: Improve customer experience