multiplying a smaller array with consecutive sub arrays of a larger array

    Hi,


    I'm trying to find out if excel can choose consecutive sub arrays from a larger array.


    If, for example, the electricity price changes every hour, and my washing machine uses a certain amount of electricity for 3 consecutive hours, how do I find the best time to turn my washing machine on.


    I have array with the electricity prices for every hour (lenght 24) of a certain day and one with the usage of my washing machine (lenght 3).


    I want to find the minimum of the product of the last array with every sub array of length 3 of the first array. Normally I'd use matlab, but it's not available at work.


    I don't know anything about excel, can excel even do this kind of stuff?


    Thanks!

    Re: multiplying a smaller array with consecutive sub arrays of a larger array


    This is a kind of home work what you are asking for..
    we can just let you to the path you have to walk the way on your own if possible you can hire a developer who can do this for you..

    Re: multiplying a smaller array with consecutive sub arrays of a larger array


    I think there was a little lost in translation, there :)


    If still unanswered when I get back on a computer, I'll have a look at your problem later...

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login