Inside the Project Info tab and consumption section, you will see the options to add the Utility rate and create a consumption profile for the lead.
The 3rd option in the list is "Spreadsheet interval data" which the user can use to add consumption information of a user that is in a spreadsheet/excel file
On clicking on Spreadsheet interval data you will be taken to the Consumption profile page of the lead.
Depending on the content of the file select the
Interval (Time duration of each recording)
60 mins
30 mins
15 mins
Unit (the measure of reading)
kWh
Wh
kW
W
Interval start date (The date from when the readings start)
Based on the selection the Date and time are updated, now copy the data in your file onto the sheet and click on Generate
You can visualize the consumption of the user on an hour level not only at an overall year but also for individual seasons on a weekday and weekend.
On scrolling down you can also see the average monthly and year long consumption broken down by months.
In the Future profile section, you can further add heavy appliances to see the increase in consumption ( Check the future profile article for a detailed understanding of how to use)
