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)