Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Representative load Profile!

Status
Not open for further replies.

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.
 
Replies continue below

Recommended for you

while not clear as to your objective, investigate the use of pivot tables.
also investigate the statistical functions within excel, perhaps they can provide insight. i would think think that histograms may be of use as well.
-pmover
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor