Incresing date incrimentaly

O

owen080808

Hello all, this forum has been really helpful so far, but i have a new
problem;

I have a worksheet that claculates lots of different things for a
single day, i have a second sheet which im using to compare some of the
things the first is calculating, but i dont want to have to manually
copy information from each cell to the right cell on the other sheet.

what im looking for is some kind of function (i assume it will have to
be logic based) which will tell me what the results of a cell would be
when the date is increased by one day

eg;

=E12 IF (date value+1),E12,""

where E12 would be the information i want to show, i cant seem to make
IF statements function in this way so any help would be much
appreciated, i basically need a formula which will incrimentally
increase the date value.

hope someone can help
thanks in advance

Owen
 
O

owen080808

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

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

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

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

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

thanks
Owe
 
A

Ardus Petus

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" <[email protected]> a écrit
dans le message de
news:eek:[email protected]...
 
O

owen080808

Ok thanks for the suggestion,

i put the file up (it is quite large) at
http://cjoint.com/?epwj1CpJy6

what im trying to do, now that you can see the workbook is have the
information from the calculations sheet fed into the information
feedback sheet in the electrical/thermal demand sections. What then
happens is the learning adjustments are used to make predictions. this
all works at the moment.

I now want to compare the data from the calculations sheet to what
would happen if the predictions could be fed back into the supply
sections of the information feedback sheet, so i set up the sheet for
case study 1 power data, with the aim of being able to show (and
eventually graph) the list from the calculations sheet next to what
would happen if it used to predictions to converge on a solution.

i hope this helps, its getting a bit beyond me now

if you could solve this one, you would be my god!

cheers
Owen
 
Top