| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Make peak values move to low value region - Peak Lopping - HELP!
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find values before plot peak? | Charts and Charting in Excel | |||
| How to Calculate Peak and Off Peak Hours | Excel Programming | |||
| Calculation of peak and off peak hours | Excel Programming | |||
| How do I convert peak-peak voltage to rms voltage in Excel? | Excel Programming | |||
| Calculation of peak / off peak hrs v2 | Excel Programming | |||
Threaded Mode
