IF OR Fuction

Submitted by jithin on
Planning, Scheduling & Programming Discussion

Member for

21 years 8 months
Member for 21 years 8 months
Submitted by Rafael Davila on Wed, 2022-05-25 18:28
Permalink

  • That activity time has elapsed or that some effort has been performed does not mean some volume of work has been done.
  • Using elapsed time to calculate progress of work is usually wrong even in the most simple of job as things rarely happen exactly as planned.

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Wed, 2022-05-25 16:24
Permalink

glad I could help but my formula was correct based on what you had

you had  A<D

NOT A>D or B<D

was not excalty sure I but I did think your paramaters were incorrect to begin with but that was not what you asked

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Wed, 2022-05-25 16:18
Permalink

glad I could help wants exactly sure what you were trying to do.

Member for

14 years 7 months
Member for 14 years 7 months
Submitted by jithin on Wed, 2022-05-25 14:44
Permalink

Thanks Zoltan and Rodel,

That did help.

 

Rafel,

 

The weightage per activity is already given based on the resource requirement and its 7X7 job. So the duration consumed X by the weightage/ activity gives me the planned %.

 

Thanks

Jithin

Member for

21 years 8 months
Member for 21 years 8 months
Submitted by Rafael Davila on Wed, 2022-05-25 12:09
Permalink

And what about non-work days such as vacations?

And what about multiple resouces with different calendars?

And what about shiftwork on same activity?

Unless activities are duration type such as concrete curing status and updating is a matter of volume of work. Statusing and updating activities that perform volume of work without considering volume of work is not a good idea.


Member for

19 years
Member for 19 years
Submitted by Rodel Marasigan on Tue, 2022-05-24 14:18
Permalink

Zoltan furmula is correct with minor correction in case A > D or B < D or A=D.

=IF(B3<=$D$2,1,IF(A3<=$D$2,($D$2-A3+1)/(B3-A3+1),0))

Member for

16 years 3 months
Member for 16 years 4 months
Submitted by Zoltan Palffy on Tue, 2022-05-24 13:16
Permalink

Based on what you had here it is 

Item Duration % CompleteToday = (D)ABC28-May-2223-May-2228-May-22100% 25-May-221-Jun-2250% 

 

=IF(B3=$D$2,1,IF(A3<$D$2,($D$2-A3+1)/(B3-A3+1)))