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


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

What is the formula in E12?

How is it related to today's date?

TIA
--
AP

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

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


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

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

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

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


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

The upload to cjoint did not work. Maybe your file is over 500Kb
Could you zip it?

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

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


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

Forget cjoint.
Mail it to

Regards,
--
AP

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

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


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