Project Management - Predecessors

[deckerp]

I am working on a tabel that tracks project activities.

In that table every task has its starting date & time, estimated hours needed to complete it and the calculated finish date & time.

Generally, the activities are written in approxiamte order of start time.
However, some of them are not due to start before other activities are completed. Therefore I need to be able to tell an activity that it should not start before activity X is finished. The best would be to have 5 cells next to it, and to input the ID of the predecent activities.

Who can solve this? Thanks.

 

[scottylad2]

For the question you submitted you were given an answer by both smitty and I that was an adequate response the the question you posted on THIS thread. You've since added in other elements that are identical to another post thats being answered by someone else. If you want proper responses, don't double ask the same query and always try and explain fully with a mock up of what you have already and expected results.

You put a link to your project and its the same link as in the other post. If your not getting an answer you understand your maybe not phrasing your question in a way thats easily understood

 

[deckerp]

thanks

 

[deckerp]

For the question you submitted you were given an answer by both smitty and I that was an adequate response the the question you posted on THIS thread. You've since added in other elements that are identical to another post thats being answered by someone else. If you want proper responses, don't double ask the same query and always try and explain fully with a mock up of what you have already and expected results.

You put a link to your project and its the same link as in the other post. If your not getting an answer you understand your maybe not phrasing your question in a way thats easily understood

The If function descibed above wont work (cause there are hundreds of tasks and not just the one above the line).

Your suggestion doesnt work either:
- I am using excel 2003 with only 3 conditional formating available.
- This is a project management. I stated that I need assign activities start dates according to predessors. This can not be handled by coloring activities that with the status "completed". Imagine tasks A, B, C are done.
Task D, E not started, cause they are awaiting F, J, K, L to be finished. And L cannot be started before J,K are done.

Maybe you have another idea? Would be great.

 

[Smitty]

<S><S><S>I'm going to ask that you stick to your </S></S></S>Original Post.

EDIT: reopened at the OP's request. The posts are closely related, but apparently differ in what he needs from each.

 

[deckerp]

Hello, I try to reformulate the desired outcome.<o></o>
<o></o>
I would like excel to ammend the start date & start times of the actitivies when there are predessors. It should look at the range of the predessors start dates & times and look up the max start date & time. from there on recalculate the estimated start date & time for each activitiy.


<o></o>
The Parameters (eg: Working hours and bank holidays) are defined in another sheet called “Proj.Par”:<o></o>
<o></o>

Excel Workbook
	O	P
4	Working hours
5	Start of day	8:00
6	End of day	17:00
7	Start break	12:00
8	End break	13:00
Proj.Par

__ the S5:S71 is a defined name called “BankHolidays” (F3)<o></o>

Excel Workbook
	R	S
4	Bank Holidays
5	Neujahr	Fr, 01.01.10
6	Heilige Drei Knige	Mi, 06.01.10
7	Karfeitag	Fr, 02.04.10
8	Ostersonntag	So, 04.04.10
9	Ostermontag	Mo, 05.04.10
10	Maifeiertag	Sa, 01.05.10
11	Christi Himmelfahrt	Do, 13.05.10
12	Pfingstsonntag	So, 23.05.10
13	Pfingstmontag	Mo, 24.05.10
14	Fronleichnam	Do, 03.06.10
15	Tag der dt. Einheit	So, 03.10.10
16	Allerheiligen	Mo, 01.11.10
17	1. Weihnachtsfeiertag	Sa, 25.12.10
18	2. Weihnachtsfeiertag	So, 26.12.10
Proj.Par

The present sheet is called “Activities”. Below the table:<o></o>
<o></o>

Excel Workbook
	A	D	E	F	G	H	J	K	L	M	N	O
5	WBS	Task Activity	Predessors				Estim. hours	Estim. Days	Estim. Start		Estim. Finish
6	1	Task 1					02:00	0,25	Mi, 10.02.2010	08:00	Mi, 10.02.2010	10:00
7	2	Task 2					01:30	0,19	Mi, 10.02.2010	10:00	Mi, 10.02.2010	11:30
8	3	Task 3					32:00	4,00	Mi, 10.02.2010	11:30	Di, 16.02.2010	11:30
9	4	Task 4					00:30	0,06	Di, 16.02.2010	11:30	Di, 16.02.2010	12:00
10	5	Task 5	8	9	15		08:00	1,00	Di, 16.02.2010	13:00	Mi, 17.02.2010	12:00
11	6	Task 6					02:00	0,25	Mi, 17.02.2010	13:00	Mi, 17.02.2010	15:00
12	7	Task 7	3	5			02:30	0,31	Mi, 17.02.2010	15:00	Do, 18.02.2010	08:30
13	8	Task 8					02:00	0,25	Do, 18.02.2010	08:30	Do, 18.02.2010	10:30
14	9	Task 9					02:30	0,31	Do, 18.02.2010	10:30	Do, 18.02.2010	14:00
15	10	Task 10	11	15			08:00	1,00	Do, 18.02.2010	14:00	Fr, 19.02.2010	14:00
16	11	Task 11					08:00	1,00	Fr, 19.02.2010	14:00	Mo, 22.02.2010	14:00
17	12	Task 12					16:00	2,00	Mo, 22.02.2010	14:00	Mi, 24.02.2010	14:00
18	13	Task 13					08:00	1,00	Mi, 24.02.2010	14:00	Do, 25.02.2010	14:00
19	14	Task 14	3	13	16	4	08:00	1,00	Do, 25.02.2010	14:00	Fr, 26.02.2010	14:00
20	15	Task 15					08:00	1,00	Fr, 26.02.2010	14:00	Mo, 01.03.2010	14:00
21	16	Task 16					08:00	1,00	Mo, 01.03.2010	14:00	Di, 02.03.2010	14:00
22	17	Task 17					08:00	1,00	Di, 02.03.2010	14:00	Mi, 03.03.2010	14:00
Activities

Cell Formulas
Range	Formula
A7	=+A6+1
A8	=+A7+1
A9	=+A8+1
A10	=+A9+1
A11	=+A10+1
A12	=+A11+1
A13	=+A12+1
A14	=+A13+1
A15	=+A14+1
A16	=+A15+1
A17	=+A16+1
A18	=+A17+1
A19	=+A18+1
A20	=+A19+1
A21	=+A20+1
A22	=+A21+1
N6	=IF($D6="","",WORKDAY(L6,CEILING((M6+J6-Proj.Par!$P$5-(M6>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N7	=IF($D7="","",WORKDAY(L7,CEILING((M7+J7-Proj.Par!$P$5-(M7>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N8	=IF($D8="","",WORKDAY(L8,CEILING((M8+J8-Proj.Par!$P$5-(M8>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N9	=IF($D9="","",WORKDAY(L9,CEILING((M9+J9-Proj.Par!$P$5-(M9>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N10	=IF($D10="","",WORKDAY(L10,CEILING((M10+J10-Proj.Par!$P$5-(M10>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N11	=IF($D11="","",WORKDAY(L11,CEILING((M11+J11-Proj.Par!$P$5-(M11>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N12	=IF($D12="","",WORKDAY(L12,CEILING((M12+J12-Proj.Par!$P$5-(M12>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N13	=IF($D13="","",WORKDAY(L13,CEILING((M13+J13-Proj.Par!$P$5-(M13>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N14	=IF($D14="","",WORKDAY(L14,CEILING((M14+J14-Proj.Par!$P$5-(M14>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N15	=IF($D15="","",WORKDAY(L15,CEILING((M15+J15-Proj.Par!$P$5-(M15>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N16	=IF($D16="","",WORKDAY(L16,CEILING((M16+J16-Proj.Par!$P$5-(M16>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N17	=IF($D17="","",WORKDAY(L17,CEILING((M17+J17-Proj.Par!$P$5-(M17>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N18	=IF($D18="","",WORKDAY(L18,CEILING((M18+J18-Proj.Par!$P$5-(M18>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N19	=IF($D19="","",WORKDAY(L19,CEILING((M19+J19-Proj.Par!$P$5-(M19>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N20	=IF($D20="","",WORKDAY(L20,CEILING((M20+J20-Proj.Par!$P$5-(M20>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N21	=IF($D21="","",WORKDAY(L21,CEILING((M21+J21-Proj.Par!$P$5-(M21>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
N22	=IF($D22="","",WORKDAY(L22,CEILING((M22+J22-Proj.Par!$P$5-(M22>=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7))/(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8),1)-1,BankHolidays))
O6	=IF(D6="","",MROUND(M6+J6-(NETWORKDAYS(L6,N6,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M6)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M6+J6-(NETWORKDAYS(L6,N6,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M6)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O7	=IF(D7="","",MROUND(M7+J7-(NETWORKDAYS(L7,N7,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M7)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M7+J7-(NETWORKDAYS(L7,N7,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M7)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O8	=IF(D8="","",MROUND(M8+J8-(NETWORKDAYS(L8,N8,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M8)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M8+J8-(NETWORKDAYS(L8,N8,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M8)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O9	=IF(D9="","",MROUND(M9+J9-(NETWORKDAYS(L9,N9,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M9)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M9+J9-(NETWORKDAYS(L9,N9,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M9)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O10	=IF(D10="","",MROUND(M10+J10-(NETWORKDAYS(L10,N10,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M10)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M10+J10-(NETWORKDAYS(L10,N10,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M10)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O11	=IF(D11="","",MROUND(M11+J11-(NETWORKDAYS(L11,N11,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M11)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M11+J11-(NETWORKDAYS(L11,N11,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M11)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O12	=IF(D12="","",MROUND(M12+J12-(NETWORKDAYS(L12,N12,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M12)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M12+J12-(NETWORKDAYS(L12,N12,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M12)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O13	=IF(D13="","",MROUND(M13+J13-(NETWORKDAYS(L13,N13,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M13)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M13+J13-(NETWORKDAYS(L13,N13,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M13)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O14	=IF(D14="","",MROUND(M14+J14-(NETWORKDAYS(L14,N14,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M14)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M14+J14-(NETWORKDAYS(L14,N14,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M14)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O15	=IF(D15="","",MROUND(M15+J15-(NETWORKDAYS(L15,N15,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M15)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M15+J15-(NETWORKDAYS(L15,N15,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M15)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O16	=IF(D16="","",MROUND(M16+J16-(NETWORKDAYS(L16,N16,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M16)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M16+J16-(NETWORKDAYS(L16,N16,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M16)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O17	=IF(D17="","",MROUND(M17+J17-(NETWORKDAYS(L17,N17,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M17)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M17+J17-(NETWORKDAYS(L17,N17,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M17)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O18	=IF(D18="","",MROUND(M18+J18-(NETWORKDAYS(L18,N18,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M18)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M18+J18-(NETWORKDAYS(L18,N18,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M18)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O19	=IF(D19="","",MROUND(M19+J19-(NETWORKDAYS(L19,N19,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M19)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M19+J19-(NETWORKDAYS(L19,N19,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M19)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O20	=IF(D20="","",MROUND(M20+J20-(NETWORKDAYS(L20,N20,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M20)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M20+J20-(NETWORKDAYS(L20,N20,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M20)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O21	=IF(D21="","",MROUND(M21+J21-(NETWORKDAYS(L21,N21,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M21)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M21+J21-(NETWORKDAYS(L21,N21,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M21)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
O22	=IF(D22="","",MROUND(M22+J22-(NETWORKDAYS(L22,N22,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M22)*(Proj.Par!$P$8-Proj.Par!$P$7)-(M22+J22-(NETWORKDAYS(L22,N22,BankHolidays)-1)*(Proj.Par!$P$6-Proj.Par!$P$5+Proj.Par!$P$7-Proj.Par!$P$8)+(M22)*(Proj.Par!$P$8-Proj.Par!$P$7)<=Proj.Par!$P$8)*(Proj.Par!$P$8-Proj.Par!$P$7),"0:01"))
K6	=(J6*24)/8
K7	=(J7*24)/8
K8	=(J8*24)/8
K9	=(J9*24)/8
K10	=(J10*24)/8
K11	=(J11*24)/8
K12	=(J12*24)/8
K13	=(J13*24)/8
K14	=(J14*24)/8
K15	=(J15*24)/8
K16	=(J16*24)/8
K17	=(J17*24)/8
K18	=(J18*24)/8
K19	=(J19*24)/8
K20	=(J20*24)/8
K21	=(J21*24)/8
K22	=(J22*24)/8
L7	=IF($D7="","",WORKDAY(N6,(O6=Proj.Par!$P$6)+0,BankHolidays))
L8	=IF($D8="","",WORKDAY(N7,(O7=Proj.Par!$P$6)+0,BankHolidays))
L9	=IF($D9="","",WORKDAY(N8,(O8=Proj.Par!$P$6)+0,BankHolidays))
L10	=IF($D10="","",WORKDAY(N9,(O9=Proj.Par!$P$6)+0,BankHolidays))
L11	=IF($D11="","",WORKDAY(N10,(O10=Proj.Par!$P$6)+0,BankHolidays))
L12	=IF($D12="","",WORKDAY(N11,(O11=Proj.Par!$P$6)+0,BankHolidays))
L13	=IF($D13="","",WORKDAY(N12,(O12=Proj.Par!$P$6)+0,BankHolidays))
L14	=IF($D14="","",WORKDAY(N13,(O13=Proj.Par!$P$6)+0,BankHolidays))
L15	=IF($D15="","",WORKDAY(N14,(O14=Proj.Par!$P$6)+0,BankHolidays))
L16	=IF($D16="","",WORKDAY(N15,(O15=Proj.Par!$P$6)+0,BankHolidays))
L17	=IF($D17="","",WORKDAY(N16,(O16=Proj.Par!$P$6)+0,BankHolidays))
L18	=IF($D18="","",WORKDAY(N17,(O17=Proj.Par!$P$6)+0,BankHolidays))
L19	=IF($D19="","",WORKDAY(N18,(O18=Proj.Par!$P$6)+0,BankHolidays))
L20	=IF($D20="","",WORKDAY(N19,(O19=Proj.Par!$P$6)+0,BankHolidays))
L21	=IF($D21="","",WORKDAY(N20,(O20=Proj.Par!$P$6)+0,BankHolidays))
L22	=IF($D22="","",WORKDAY(N21,(O21=Proj.Par!$P$6)+0,BankHolidays))
M7	=IF(D7="","",IF(O6>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O6=Proj.Par!$P$7,Proj.Par!$P$8,O6)))
M8	=IF(D8="","",IF(O7>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O7=Proj.Par!$P$7,Proj.Par!$P$8,O7)))
M9	=IF(D9="","",IF(O8>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O8=Proj.Par!$P$7,Proj.Par!$P$8,O8)))
M10	=IF(D10="","",IF(O9>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O9=Proj.Par!$P$7,Proj.Par!$P$8,O9)))
M11	=IF(D11="","",IF(O10>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O10=Proj.Par!$P$7,Proj.Par!$P$8,O10)))
M12	=IF(D12="","",IF(O11>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O11=Proj.Par!$P$7,Proj.Par!$P$8,O11)))
M13	=IF(D13="","",IF(O12>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O12=Proj.Par!$P$7,Proj.Par!$P$8,O12)))
M14	=IF(D14="","",IF(O13>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O13=Proj.Par!$P$7,Proj.Par!$P$8,O13)))
M15	=IF(D15="","",IF(O14>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O14=Proj.Par!$P$7,Proj.Par!$P$8,O14)))
M16	=IF(D16="","",IF(O15>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O15=Proj.Par!$P$7,Proj.Par!$P$8,O15)))
M17	=IF(D17="","",IF(O16>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O16=Proj.Par!$P$7,Proj.Par!$P$8,O16)))
M18	=IF(D18="","",IF(O17>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O17=Proj.Par!$P$7,Proj.Par!$P$8,O17)))
M19	=IF(D19="","",IF(O18>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O18=Proj.Par!$P$7,Proj.Par!$P$8,O18)))
M20	=IF(D20="","",IF(O19>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O19=Proj.Par!$P$7,Proj.Par!$P$8,O19)))
M21	=IF(D21="","",IF(O20>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O20=Proj.Par!$P$7,Proj.Par!$P$8,O20)))
M22	=IF(D22="","",IF(O21>=Proj.Par!$P$6,Proj.Par!$P$5,IF(O21=Proj.Par!$P$7,Proj.Par!$P$8,O21)))

Excel Workbook
Name	Refers To
BankHolidays	=Proj.Par!$S$5:$S$71
Workbook Defined Names

<!--[endif]-->

 

[deckerp]

anyone wants to help finding a solution?

 

[deckerp]

still no reply ? Is this not possible then ?

 

[deckerp]

I really need to finish this -- otherwise have to abandon the idea of setting priorities to activities. who knows a solution please?