software

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,quot;quot;

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: www.excelforum.com/member.php...oamp;userid=32984
View this thread: www.excelforum.com/showthread...hreadid=533155What is the formula in E12?

How is it related to today's date?

TIA
--
AP

quot;owen080808quot; gt; a
écrit dans le message de
news
gt;
gt; Hello all, this forum has been really helpful so far, but i have a new
gt; problem;
gt;
gt; I have a worksheet that claculates lots of different things for a
gt; single day, i have a second sheet which im using to compare some of the
gt; things the first is calculating, but i dont want to have to manually
gt; copy information from each cell to the right cell on the other sheet.
gt;
gt; what im looking for is some kind of function (i assume it will have to
gt; be logic based) which will tell me what the results of a cell would be
gt; when the date is increased by one day
gt;
gt; eg;
gt;
gt; =E12 IF (date value 1),E12,quot;quot;
gt;
gt; where E12 would be the information i want to show, i cant seem to make
gt; IF statements function in this way so any help would be much
gt; appreciated, i basically need a formula which will incrimentally
gt; increase the date value.
gt;
gt; hope someone can help
gt; thanks in advance
gt;
gt; Owen
gt;
gt;
gt; --
gt; owen080808
gt; ------------------------------------------------------------------------
gt; owen080808's Profile:
www.excelforum.com/member.php...oamp;userid=32984
gt; View this thread: www.excelforum.com/showthread...hreadid=533155
gt;

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: www.excelforum.com/member.php...oamp;userid=32984
View this thread: www.excelforum.com/showthread...hreadid=533155It'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 cjoint.com to make it clearer

HTH
--
APquot;owen080808quot; gt; a écrit
dans le message de
news
gt;
gt; it gets worse before it gets better im afraid...
gt;
gt; the formula in E12 is using information of what hour of the year we are
gt; in (obtained from the date input) to look up a table of data for the
gt; whole year, select the last 7 days, averaging the value from the past
gt; week and display it along with std dev etc as a prediction of what will
gt; happen in the coming day.
gt;
gt; what i need is for the prediction to use the first seven days from the
gt; table for the year and thereafter use the averaged predictions as input
gt; to the formula for the value in E12 which will hopefully show that with
gt; this 'back referencing' the system will converge upon an optimum supply
gt; meets demand solution
gt;
gt; upon explaining it now i am very worried that it may just throw back a
gt; circular argument error at me but i need to try (its rather important
gt; ).
gt;
gt; i hope this makes it a little clearer and that someone out there has a
gt; suggestion!
gt;
gt; thanks
gt; Owen
gt;
gt;
gt; --
gt; owen080808
gt; ------------------------------------------------------------------------
gt; owen080808's Profile:
www.excelforum.com/member.php...oamp;userid=32984
gt; View this thread: www.excelforum.com/showthread...hreadid=533155
gt;

Ok thanks for the suggestion,

i put the file up (it is quite large) at
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: www.excelforum.com/member.php...oamp;userid=32984
View this thread: www.excelforum.com/showthread...hreadid=533155The upload to cjoint did not work. Maybe your file is over 500Kb
Could you zip it?

quot;owen080808quot; gt; a
écrit dans le message de
news
gt;
gt; Ok thanks for the suggestion,
gt;
gt; i put the file up (it is quite large) at
gt; cjoint.com/?epwj1CpJy6
gt;
gt; what im trying to do, now that you can see the workbook is have the
gt; information from the calculations sheet fed into the information
gt; feedback sheet in the electrical/thermal demand sections. What then
gt; happens is the learning adjustments are used to make predictions. this
gt; all works at the moment.
gt;
gt; I now want to compare the data from the calculations sheet to what
gt; would happen if the predictions could be fed back into the supply
gt; sections of the information feedback sheet, so i set up the sheet for
gt; case study 1 power data, with the aim of being able to show (and
gt; eventually graph) the list from the calculations sheet next to what
gt; would happen if it used to predictions to converge on a solution.
gt;
gt; i hope this helps, its getting a bit beyond me now
gt;
gt; if you could solve this one, you would be my god!
gt;
gt; cheers
gt; Owen
gt;
gt;
gt; --
gt; owen080808
gt; ------------------------------------------------------------------------
gt; owen080808's Profile:
www.excelforum.com/member.php...oamp;userid=32984
gt; View this thread: www.excelforum.com/showthread...hreadid=533155
gt;
Forget cjoint.
Mail it to

Regards,
--
AP

quot;owen080808quot; gt; a
écrit dans le message de
news
gt;
gt; Ok thanks for the suggestion,
gt;
gt; i put the file up (it is quite large) at
gt; cjoint.com/?epwj1CpJy6
gt;
gt; what im trying to do, now that you can see the workbook is have the
gt; information from the calculations sheet fed into the information
gt; feedback sheet in the electrical/thermal demand sections. What then
gt; happens is the learning adjustments are used to make predictions. this
gt; all works at the moment.
gt;
gt; I now want to compare the data from the calculations sheet to what
gt; would happen if the predictions could be fed back into the supply
gt; sections of the information feedback sheet, so i set up the sheet for
gt; case study 1 power data, with the aim of being able to show (and
gt; eventually graph) the list from the calculations sheet next to what
gt; would happen if it used to predictions to converge on a solution.
gt;
gt; i hope this helps, its getting a bit beyond me now
gt;
gt; if you could solve this one, you would be my god!
gt;
gt; cheers
gt; Owen
gt;
gt;
gt; --
gt; owen080808
gt; ------------------------------------------------------------------------
gt; owen080808's Profile:
www.excelforum.com/member.php...oamp;userid=32984
gt; View this thread: www.excelforum.com/showthread...hreadid=533155
gt;