It's getting a bit clearer.
Why don't you use another cell (say E13) with the same formula as E12,
except it does not search de las 7 days, but uses the (fixed) first 7 days
of the table.

I may be completely wrong in my assumptions.

You could upload your workbook on http://cjoint.com to make it clearer

HTH
--
AP


"owen080808" a écrit
dans le message de
...

it gets worse before it gets better im afraid...

the formula in E12 is using information of what hour of the year we are
in (obtained from the date input) to look up a table of data for the
whole year, select the last 7 days, averaging the value from the past
week and display it along with std dev etc as a prediction of what will
happen in the coming day.

what i need is for the prediction to use the first seven days from the
table for the year and thereafter use the averaged predictions as input
to the formula for the value in E12 which will hopefully show that with
this 'back referencing' the system will converge upon an optimum supply
meets demand solution

upon explaining it now i am very worried that it may just throw back a
circular argument error at me but i need to try (its rather important
:( ).

i hope this makes it a little clearer and that someone out there has a
suggestion!

thanks
Owen


--
owen080808
------------------------------------------------------------------------
owen080808's Profile:
http://www.excelforum.com/member.php...o&userid=32984
View this thread: http://www.excelforum.com/showthread...hreadid=533155