Hi all,
History: The Department I work for is converting its paper personnel files into electronic format.
Problem: We have 9000 files to prepare with an August 22 deadline. We are working in 6 hour shifts per workday. 6 hours/day; 5days/week. I need to predict the number of overtime hours we will need based on the number of files already complete, known hours remaining and known hours elapsed. We will continue the 6 hours/day in addition to the overtime. The project began June 12. Attached is the dataset I've compiled. The data is updated daily.
Here is the forecast formula I've used but it doesn't appear to be correct.
=FORECAST(C4,F4:F54,(IF(I4:I54>=1,I4:I54)))
Can someone please tell me where I'm going wrong?
Thank you
Bookmarks