Time of use pricing

[kevin1]

@reuben.sterling, @dchurco,

If you really want TOU calculations today, you can do in Excel and downloaded Sense data. Pretty straightforward. Sample spreadsheet here:

• Fill in in the Grid lookup table with pricing
• Download your hourly data from Sense for Total Usage via the Web App.
• Add the last four calculated columns
• Use a pivot table to filter and a sum hourly cost for whatever period you want to.

Simple Version of TOU (Time of Use) in Excel

Are you using a simple TOU electric rate plan from your utility and want closer estimated $$ numbers from Sense ? Here’s a simple example in Excel based on Southern California Edison’s rate structure: Multi-tab spreadsheet for a single grid and double grid (winter/summer) starting here: 1-hour data from Jan 01, 2019 to Jan 01, 2020.xlsx (200.6 KB)