Hi guys,

I am trying to create a spreadsheet of daily energy use and have the ability to shift the max values to a period when the values are lower. Effectively I want to shift the peaks to trough regions. The spreadsheet will be used to model an energy usage profile by shifting the peaks to a lower region to create a peak lopping.

Effectively I would like to shift the peak at around 7:00pm of this profile to between 1:00am - 5:00am. How can I do this?
Please help!

Picture 5.png

FINALEnergyCalc.xlsx