Hi Avais
this is not easy to do in Excel .. basically the only ways i can think of
a
1. rather than deleting the first promised date and placing the value in the
second, leave it in the first place and just change the font to light grey
or whatever, then you can see what is the currently promised date and also
the earlier promises
2. everytime you change the schedule take a copy of it first and date & time
it ....then you have a history as to the progress of the production
3. use project management software - not sure if any excel gantt chart
add-ins allow you to "baseline" the data, but you might like to investigate
the use of Project 2002 / 2003 where you can keep 11 baselines & 11 interim
plans (copies) of your project and compare your current plan against these
baselines/interims... however, there are other things to take into
consideration before i would say that a project schduling tool like MS
Project would be your best option - if you're interested in knowing more
about this, please post back.
--
Cheers
JulieD
check out
www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Avais" wrote in message
m...
Hi,
I run a manufacturing production sheet in Excel 2002 to plan
production.
I have approx 500 rows of orders. I have columns labelled Mon, Tue,
Wed, Thu, Fri. Each day I sit with my supervisors and try to agree
which orders we will complete and on which day. Once agreed I will
place the order £'s value along the row under a day the supervisor has
promised, eg.
Mon Tue Wed Thu Fri
Order1-Hammer £2
Order2-Wrench £5
Order3-Screw £5
etc..etc.
The problem I have is that as each day goes by, my supervisors 'delay'
their promises and I have to move their commited date forward by a
day. eg.
Mon Tue Wed Thu Fri
Order1-Hammer £2
Order2-Wrench £5
Order3-Screw £5
etc..etc.
What I need excel to do is 'COUNT' how many times the supervisor broke
his promise and I had to change the production date. In the example
above all 3 orders were changed once each.
I need excel to somehow remember the the change!
I appreciate your help in advance because I know this is going to be a
real nightmare of a job!!
Thanks,
Avais