Can a set up a production chart in excel, there may be over run s.

[Guest]

I would like to set up a production chart in Excel, what formulas do I enter?
The jobs could over run so this will alter the daily production sheets. I
want to be able to alter one job run and then it will rearrange the following
jobs. Can this be done and if so how do I do it? I am running mms office
excel 2003. I hope some one out there can solve my problem, I do hope its
possible too. I work for a printing company with no production sysytem at
all!! What I would like to do is to set up a daily, weekly and monthly
production sheet for jobs to be worked on. We have three departments, repro,
printing and finishing. I thought of colour coding each area, only so they
know what they are doing. I do know how to do formulas, i just not sue
whether this can be achieved in excel. I have designed balance sheet and
used hyperlinks before, this is a new one on me though. Any help will be
very gratefully appreciated.

Many thanks

Carole

 

[Tushar Mehta]

I am not sure if this will do it for you, but check out Gantt charts
such as

Floating bars in charts
http://www.tushar-mehta.com/excel/newsgroups/floating_bars/index.html

and

Gantt (Project) chart
http://www.tushar-mehta.com/excel/software/ganttchart/index.html

You can also find more information on Gantt charts by searching google.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions