|
Make peak values move to low value region - Peak Lopping - HELP!
1 Attachment(s)
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! Effectively, I will have to create an IF(A1:ANSetpointvalue=you move that max data to a time when the data is between 00:00 to 06:00) Is this possible? |
| All times are GMT +1. The time now is 11:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com