Formula on Actual Vs Plan

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • Re: Formula on Actual Vs Plan
    ... > but however on a given day when I analyse the Project schedule (say ... > with my plan I will be 50% in Actual but if on the 28th day I am still ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Progress Lines
    ... If the project is updated properly, you are always on today's date: late work delayed until it restarts, early work pulled forward to when it actually started, hence progress line redundant. ... project schedule were we are. ... "Rod Gill" wrote: ... > The message was checked by ESET Smart Security. ...
    (microsoft.public.project)
  • Re: progress %
    ... and there will be no such thing as progress. ... You can only analyse what you can measure, and you can only measure what ... Hours and Dollars and you can count the pigeons. ... so I the cost fields are empty... ...
    (microsoft.public.project)
  • Re: Progress Lines
    ... I don't use the progress lines to indicate what work is done and what work ... project schedule were we are. ... By updating as recommended above, all work for next week needs to be done ... The message was checked by ESET Smart Security. ...
    (microsoft.public.project)
  • Re: Progress Lines
    ... What does the zig-zag progress line show the client, ... project schedule were we are. ...
    (microsoft.public.project)