kokonut
Electrical
- Oct 15, 2003
- 10
I'm working on a project (in microsoft excel) to develop electrical load profiles for non-metered consumers to help with the load management and peak shaving decision making.
So far, I have developed daily profiles based on available data and grouped the profiles by weekdays and weekends for each month.
The problem I have is that I need to get a representative profile each for the weekdays and weekends of each month. Averaging the data may not give a true picture of the reality.
Are there any ideas on what statistical (or other) manipulations I may employ to get a meaningful representation. I'm talking about 20 profiles and 8 profiles for weekdays and weekends per month.
Hope someone can help.
So far, I have developed daily profiles based on available data and grouped the profiles by weekdays and weekends for each month.
The problem I have is that I need to get a representative profile each for the weekdays and weekends of each month. Averaging the data may not give a true picture of the reality.
Are there any ideas on what statistical (or other) manipulations I may employ to get a meaningful representation. I'm talking about 20 profiles and 8 profiles for weekdays and weekends per month.
Hope someone can help.