Predicting Date problem

[mag\(\)\(\)]

Hi All,
I have a small problem you may be able to help me with...........here
goes.......
I am trying to predict the committed date using the None grey areas of my
spreadsheet. If the section is greyed out then op is complete.
Underneath the 100,110,120 etc you will see op name then op times (in days)
above the grey bar. Using these times and dates I need to predict the
delivery date if op isn't greyed out?
So the top line if we continue to manufacture parts at the times the top
line would be ready for delivery 8/10/05
=today()+c5+c6+c7+c8+c9+c10+c11=9/10/05

today() being 3/10/05

Does the above make sense?


Sheet looks something like this....

100 110 120 140 150 160 170 180 190 200
CLAT IDENT CLAT 6MILL DRESS R/UP MLAT CTEST FV PACK Ship
2 0.5 2 2 0.5 0.5 1 0.5 0.5 0.5 2
Qty Due Committed date
4-Sep 6-Sep 7-Sep 9-Sep 11-Sep 11-Sep 12-Sep 13-Sep 13-Sep 14-Sep
16-Sep 2 ????
?????
?????
4-Sep 6-Sep 7-Sep 9-Sep 11-Sep 11-Sep 12-Sep 13-Sep 13-Sep 14-Sep
16-Sep 2
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct
7-Oct 2
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct
7-Oct 2
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct
7-Oct 2
23-Oct 25-Oct 26-Oct 28-Oct 30-Oct 30-Oct 31-Oct 1-Nov 1-Nov 2-Nov
4-Nov 1
23-Oct 25-Oct 26-Oct 28-Oct 30-Oct 30-Oct 31-Oct 1-Nov 1-Nov 2-Nov
4-Nov 3
13-Nov 15-Nov 16-Nov 18-Nov 20-Nov 20-Nov 21-Nov 22-Nov 22-Nov 23-Nov
25-Nov 1
13-Nov 15-Nov 16-Nov 18-Nov 20-Nov 20-Nov 21-Nov 22-Nov 22-Nov 23-Nov
25-Nov 2
23-Nov 25-Nov 26-Nov 28-Nov 30-Nov 30-Nov 1-Dec 2-Dec 2-Dec 3-Dec
5-Dec 1
4-Dec 6-Dec 7-Dec 9-Dec 11-Dec 11-Dec 12-Dec 13-Dec 13-Dec 14-Dec
16-Dec 2
21-Dec 23-Dec 24-Dec 26-Dec 28-Dec 28-Dec 29-Dec 30-Dec 30-Dec 31-Dec
2-Jan 2






Thanx in Advance...............

mag()()

 

[mag\(\)\(\)]

100 110 120 140 150 160 170 180 190
200
CLAT IDENT CLAT 6MILL DRESS R/UP MLAT CTEST FV PACK Ship
2 0.5 2 2 0.5 0.5 1
0 .5 0 .5 0 .5 2

Comitted date
4-Sep 6-Sep 7-Sep 9-Sep 11-Sep 11-Sep 12-Sep 13-Sep 13-Sep 14-Sep 16-Sep
???
4-Sep 6-Sep 7-Sep 9-Sep 11-Sep 11-Sep 12-Sep 13-Sep 13-Sep 14-Sep 16-Sep
???
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct 7-Oct
???
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct 7-Oct
???
25-Sep 27-Sep 28-Sep 30-Sep 2-Oct 2-Oct 3-Oct 4-Oct 4-Oct 5-Oct 7-Oct
???
23-Oct 25-Oct 26-Oct 28-Oct 30-Oct 30-Oct 31-Oct 1-Nov 1-Nov 2-Nov 4-Nov
???
23-Oct 25-Oct 26-Oct 28-Oct 30-Oct 30-Oct 31-Oct 1-Nov 1-Nov 2-Nov 4-Nov
???
13-Nov 15-Nov 16-Nov 18-Nov 20-Nov 20-Nov 21-Nov 22-Nov 22-Nov 23-Nov
25-Nov ???
13-Nov 15-Nov 16-Nov 18-Nov 20-Nov 20-Nov 21-Nov 22-Nov 22-Nov 23-Nov
25-Nov ???
23-Nov 25-Nov 26-Nov 28-Nov 30-Nov 30-Nov 1-Dec 2-Dec 2-Dec 3-Dec 5-Dec
???
4-Dec 6-Dec 7-Dec 9-Dec 11-Dec 11-Dec 12-Dec 13-Dec 13-Dec 14-Dec 16-Dec
???
21-Dec 23-Dec 24-Dec 26-Dec 28-Dec 28-Dec 29-Dec 30-Dec 30-Dec 31-Dec
2-Jan ???

The above may be easier to read than the last one.

Sorry about the format but it's the first timne I have posted to this group.

mag()()