G
gottabarra
Hi guys,
I am trying to create a spreadsheet of daily energy use and have th
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 spreadshee
will be used to model an energy usage profile by shifting the peaks to
lower region to create a peak lopping.
Effectively I would like to shift the peak at around 7:00pm of thi
profile to between 1:00am - 5:00am. How can I do this?
Please help!
Effectively, I will have to create an IF(A1:AN>Setpointvalue=you mov
that max data to a time when the data is between 00:00 to 06:00)
Is this possible
+-------------------------------------------------------------------
|Filename: Picture 5.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=876
+-------------------------------------------------------------------
I am trying to create a spreadsheet of daily energy use and have th
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 spreadshee
will be used to model an energy usage profile by shifting the peaks to
lower region to create a peak lopping.
Effectively I would like to shift the peak at around 7:00pm of thi
profile to between 1:00am - 5:00am. How can I do this?
Please help!
Effectively, I will have to create an IF(A1:AN>Setpointvalue=you mov
that max data to a time when the data is between 00:00 to 06:00)
Is this possible
+-------------------------------------------------------------------
|Filename: Picture 5.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=876
+-------------------------------------------------------------------