Planned vs Actual Formula

This is great....

Though we need some tweaks.

> Values in plan effort is in days and should be converted to hours (multiplied to 8 hours).
> Is there a way we can avoid showing #VALUE!?
> Black Widow utilisation doesn't match as expected. For June, Black Widow has been allocated for Project YA for total hours of 24 (3 days x 8 hours - for week June 30) and worked for the same project for 40 hours. So, variance that should reflect is 16 hours which is overutilised.

Hi,
1) Multiplication with 8 hour in a day for the plan effort in summary sheet
2) #Value are generated due to data in Plan Effort sheet i observed that some cells are showing blank but having " " (i.e (Space) i have to be identified and remove manually by Replace command .
3) I have corrected the formula to match u r requirement .
Punnam