Based on Last Mail

SI No Client feed Back mails Work status Working Hours Remarks

01. The data is not correct. Completed

Attached the data of 11 September. You can see all values in left pop up are wrong?

02. The ceiling is not correct Completed

First rename it to Ceiling (remove quarterly hour).

The value I entered was 20kWh.

Consumption Statistics
Average Daily Consumption: 3448.66 kWh
Maximum Consumption: 93.80 kWh
Minimum Consumption: 0.00 kWh
This data also don't is accurate?

03 New Chart Structure On Going 1 Day We have completed backend, and we show it in chart.
1 Main Chart > Usage > like now But the fact is when we are going to filter hourly it has
2. 2nd Charts > Pricing > We remove this from main chart and put it in a new chart called Pricing
no perfect output and need to add horizontal scrollbar
 3. Ceiling/usage Chart and we are not sure that it is possible or not. We have
For now, I would like to suggest to leave this chart and add another chart need time to maintain data because have some
It should look like this > see my red line.
performance issue.
Horizontal day (with filter (year/quarter/Month, Week, Day) > If selected day we see the hour rate.
Vertical The ceiling with values.
Line Chart

What this will do is show us at which time/day we are over the ceiling and below the ceiling

04. Sorting On Going 1 Day 1 Date Summary - Done

1 Date Summary 2 Analysis result - Done
2 Analysis result (please make the fonts smaller font-size: 1.0rem;) 3 Usage Chart - Running
3 Usage Chart 4 Pricing Chart - Running
4 Pricing Chart 5 Ceiling Chart - Running
5 Ceiling Chart 6 Solar Chart – New Added but not mention in
6 Solar Chart previous mail.
7.Asset Chart 7.Asset Chart - New Added but not mention in
8 Average consumption analysis > 24 rows previous mail.

8 Average consumption analysis > 24 rows – Done

(Already Deployed)

05. Duplicate Records: 8 Completed

Show me the fields?

06. 24 hours. Pending 8 Hours Backend done but JS part remaining, just need to show
I miss the data to see the highest Energy Consumption in 24 hours. in chart. We have need time.
This is essential, we use it later for Asset.

07. Average consumption analysis On Going 8 Hours We have performed AVG and already Deployed.
Please increase to 24 rows
Please increase to 24 rows – Wait for client reply

08. Ask them this. Pending 8 Hours This is a new task, and wasn’t mention in first mail.
We want people to calculate their energy profit.
 Add a table with this key data in chart 1 We have already asking a question about the formula
If the user changes value USAGE/ NEW Unit price they can calculate their profit
of calculation – Wait for client Reply
Maybe jquery > real time or with a button.

If we button we need to store this data right?

09. Overview Completed

We only need 1 line. Peak Start > Off Peak Start. It will save space.

10. Assets Pending 2 Day We have asked for explanation from client and Assets
Solar Panels part is a new task. It is not simple task. We have need
2 Assets will be main (solar and battery) and selected on the result page.
time and formula is not clear. Seeking for clarification.
1 Solar there will be 9/10 types of solar
Orientation
1 East/West
2 South/South
3 etc.

We as admin upload quarter data of the 9 Orientations so 9x 35040 rows

For other assets like battery, EV, heatpump it is simple formula.

The user select it from the Solar tab

I.E.
1 East/West
 2 He enters amount of solar panel. I.e. 40
3 The power of the Solar Panel I.e. 400 Watts
4 Peak price/Off peak price

Based on the formula in DB we can generate new charts

EastWest table: 40*400 is 1600Power (times value of the EastWest table.)
> Please tell me if it is clear.

Solar should like usage have a separate chart for calculation.

But we think it would also be good to include the values in the Usage chart.

Asset Chart
On the Asset chart user can add
Solar > After submit a new chart will be generated with
Lines
- Usage Off Peak
- Usage Peak
- Usage Total
- Solar Off Peak
- Solar Peak
- Solar Total

11. Assets Battery Pending 2 Day Seeking for clarification, not clear perfectly.
Higest Energy consumption in 24 hours: 5000 kwh
Amount of KWH left on the ceiling to charge 3000 kwh
Example 1 ( Hourly usage)
Suppose that in this example the highest KWH usage in 24 hours is here > example 1
It means that we can recharge the battery in the timestamps when usage is below
Because their are 2 peaks it is possible to start charging before the Peak 1, Before Peak 2.
Sometimes there is 1 big peak, sometimes 2 small peak.

Companies want to keep using energy, so they consider buying a battery.

Because now they come over the ceiling and their power is cut off.

Let's say the Peak in the chart is 5000 kwh (over the CEILING)
Ceiling: 500KWH
For example 8 hours where this company is using more power then Allowed
Allowed Usage: 8x 500 KWh = 4000 KWH
Used in PEAK USAGE: 6000 KWH
Meaning they need a battery of 2000 KWH right?

Wrong!
IT depends on the ceiling.
Suppose the time between the previous PEAK USAGE and this PEAK USAGE is 16 hours.
In this 16 hours they use 400KWH per hour
The Battery can be max. charged 16 hours * 100KWH (left on ceiling) is 1600 KWH
The maximum Battery they can buy is 1600 KWH, because their ceiling doesn't allow more.

To calculate the max battery we first need

1 the highest peak in 24 hours. (best would be 2 examples ,but let's start with 1_
2. the time when the last peak ended.
3 the total where we can charge the battery.

F.e.
8 september 2023 01;00 - Ceiling. 500 KWH, Usage 400KWH / Battery 0 KWH chaging 100 KWH
8 september 2023 02:00 - Ceiling. 500 KWH, Usage 420KWH / Battery 1000 KWH + 80 KWH
etc.,

Lines
- Usage Off Peak OLD
- Usage Peak OLD
- Usage Total OLD
- Usage Off Peak NEW
- Usage Peak NEW
- Usage Total NEW
 - Battery charged line

12. Other assets simple Pending Duration in No

1 Day per square
problem, just it is depending on previous task.
Name 1 Day Others assets not mention.
Type
Power Task Name 1 2 3 4 5 6 7 8

13. Other asset complicated Part 2 of the Part 2 of the project

>> We will do this in part 2 of the project. project
New Chart Structure

Sorting

The Highest Energy Consumption

Average Consumption Analysis

Profit Calculator

Assets (Solar Panels)

Assets Battery

Other Assets Simple

Part 2 Of The Project And QA

Go Live

Total Duration of the Project Based on Last Mail 8

Days