Formula to show how many days project is delayed

[Leo R]

We are using Project 2003.

I would like to know what formula can I use to calculate the number of days
the project is delayed? I have to prepare a report for management which
should include this information.

Thank you in advance for your help.

 

[Jan De Messemaeker]

Hi,

Is this Project Server/PWA or just plain Project?
Seems like Project to me but why post in the Server Newsgroup?
First and foremost, in any version, did you save or Set a beseline before
entering actual values?
If not you do not have a refere,nce and measuring delay is not possible.
If you have, look at the Finish Variance field.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Leo R]

Hi Jan,

This is in Project Server. I have created a set of views for Management and
export the info via excel when ever they need the reports. Some have already
baselined their projects. Others have not. Nevertheless, I have to show
whether they are delayed, on schedule, and if delayed - by how many days.

They are supposed to have their projects baselined once Management had
approved their project plan.

 

[John Sitka]

For each project make the last task a milestone.
Set the deadline of that milestone. In project this will look like a diamond that represets
the planned finish and the green arrow that represents your completion dealine.
This part dosen't really hit the PWA it's just to help explain what is going on.

Create an Enterprise Custom "Project" Field (ecpfd_CustomerDeadline) of type Date this is your Deadline it is setable In the
Project -> Project Information menu.
This is a reference as Jan pointed out, not a baseline type but still a single value reference.

Create an Enterprise Custom "Project" Field (ecpfn_DeadlineVariance) of type Number this will be the Variance between your Planned
Completion Date and the Deadline
set this value to a Formula.
IIf([Enterprise Project Date1]=ProjDateValue("NA"),0,Cint(DateDiff("d",[Project Finish],[Enterprise Project Date1])))

This value after it is calculated within the Project software can then be used in any view to explain the Date Difference between
the planned Finish and the Contractual Deadline. It is easy to set this up as a conditional Graphical indicator which shows Green
for early, Blue for "day for day" or zero variance and red for late, or any other million different schemes.

Buy naming the last task a milestone in each Project the same thing (ie. Done") you can use a Macro like this

Sub WriteProjectDeadlineToFinalMilestone()
' this macro depends on accurate naming of the final task
' easy to adjust, tough to ensure maintain

Dim T As Task
Dim TS As Tasks
Set TS = ActiveProject.Tasks
For Each T In TS
If Not T Is Nothing Then
If Trim(T.Name) = "Done" Then
T.Deadline = ActiveProject.ProjectSummaryTask.EnterpriseProjectDate1
End If
End If
Next T
End Sub

Then you can set the Deadline from Project->Project information
namly the
ecpfd_CustomerDeadline which is the ActiveProject.ProjectSummaryTask.EnterpriseProjectDate1.
Once that value is set click the Macro to write that value to move the last tasks deadline (little Green arrow).

All this gets done in the Enterprise Global.

The variance always has to be calculated during a change event in Project Pro.
The ecpfd_CustomerDeadline (ActiveProject.ProjectSummaryTask.EnterpriseProjectDate1) can be editable via
PWA.

EnterpriseProjectDate1 is true in my case as it was the first Enterprise Project Date I utilized
because it answered the most loaded, vauge and important question within the Enterprise
"How is it going?"