Hi GB,
You like your detail don't you?
Here's a tip based on something a very wise individual once said to me...
"Its better to be approximately correct in time to take evasive action than to be 100% correct after the torpedo has hit..."
First step is to question why your consumption per item is as high as reflected and to identify ways in which to reduce the value WITHOUT time-shifting.
Typically, a water heater's usage is driven the temperature difference between input water and thermostat-controlled output temperature - two options:
1) Install solar water heating or a heat-pump to raise the temperature of the incoming feed
2) Lower the thermostat setting
In your model, I'd focus on the big ticket items (i.e. 1kW+) and create a demand pattern with 30 or even 60 minute intervals - a 15-minute level of granularity is overkill
Next, examine these and flag those items where you actually have some flexibility in when you have to use them. (Typically, most kitchen food-related appliances tend to either be driven by mealtimes and I doubt you'd want to breakfast at 3am or eat dinner at midnight, or - as with refrigerators - need to be on all the time).
Having culled things down to a more manageable list of items that have an elective usage time, sit down with all involved and agree on a more balanced schedule that is "doable" and acceptable to all. In other words, here's where you introduce the more fuzzy-logic to the equations (human objections)...
NB: There are times when being too mechanistic is just not appropriate for the circumstances - this initiative of yours seems to qualify...
Of course, if this Excel project is just a "let me see if this can be done" exercise, then let me wish you luck and leave you with a parting bit of advice - if this is an academic exercise, make sure it remains one and don't fall into the trap of trying to implement it in your home...
Dave
Bookmarks