Hi Friends!
Could some help me on this formula?
I need to complete a task say from 1-Jun-05 to 30-Jun-05 i.e 30 days,
but however on a given day when I analyse the Project schedule (say
today), I find out that on the 9th day i.e 9-Jun-05 on actual progress
I have completed only 4% of the Job, Hence what should be my forecasted
days to complete the job a 100% in actual, now putting it in a
mathematical sense:
100% = 30days (Plan)
4% = 9days (Actual & when the plan is 30%)
Hence 96% = ? (How may days in Forecast)

I want the formula to be dynamic, such that on the 15 day if I catch up
with my plan I will be 50% in Actual but if on the 28th day I am still
say 65% in Actual then what would be the forcasted days or total days
to still complete my work a 100% in actual

Any help would be very appreciated
Regards
Edward