F
Fernie
I currently have an Excel sheet that i update on a daily basis. I have
to update this sheet with the previous days figures in order to
calculate our business target for the current day and for the rest of
the week. I cannot remember how tow do this calculation!
What i have to work it out at the moment is the following...
Our Traget is 80.00% and we have to maintain this each day and have to
end on 80.00% for the week.
In cell E9 to E14 these have Mon - Saturdays figures which are imput
daily. Cell E15 has the total / average for the days / week so far.
I imput the previous days figures in the table each day, if on the
previous day we had not meet 80.00% that we have to achieve a higher %
for the current day, In order to calculate what cell E15 needs to be
for the current day and for the rest of the week i had our target set
in H2 and was able to incease this number in that cell to change the
values in the cells E9 to E14 in order to get a a new target for the
current day and to achieve our 80.00% for the week.
However like i said i cannot remember how i did this in the first
place.
If you need any more info please let me know.
I hope that this makes sense.
Many Thanks
Fernie
to update this sheet with the previous days figures in order to
calculate our business target for the current day and for the rest of
the week. I cannot remember how tow do this calculation!
What i have to work it out at the moment is the following...
Our Traget is 80.00% and we have to maintain this each day and have to
end on 80.00% for the week.
In cell E9 to E14 these have Mon - Saturdays figures which are imput
daily. Cell E15 has the total / average for the days / week so far.
I imput the previous days figures in the table each day, if on the
previous day we had not meet 80.00% that we have to achieve a higher %
for the current day, In order to calculate what cell E15 needs to be
for the current day and for the rest of the week i had our target set
in H2 and was able to incease this number in that cell to change the
values in the cells E9 to E14 in order to get a a new target for the
current day and to achieve our 80.00% for the week.
However like i said i cannot remember how i did this in the first
place.
If you need any more info please let me know.
I hope that this makes sense.
Many Thanks
Fernie