Project Status in roject center

B

Ben Howard

Hi Arun,

The two fields displayed are enterprise custom fields, with a formula
attached. Each formula looks at another Enterprise custom field, so four
fields are used in total, Project Scheudule status, Schedule Status, Project
Cost Status and Cost status

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

Costs Status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No Baseline",IIf([Cost
Variance]>[Baseline Cost]*0.15,"1_ 15%+ Over Budget",IIf([Cost
Variance]>[Baseline Cost]*0.01 And [Cost Variance]<=[Baseline Cost]*0.15,"2_
1% to 15% Over Budget","3_ On Budget")))

and then Project Cost Staus = [cost status]

You'll need to baseline the projects to use the formula, and then use the
Graphical indicators for the Project Cost and Project Schedule status to
display the traffic light colours, eg Equals 1_15%+ Over Budget displays the
Red stop light image.

The enterprise fields then need to be made visible in a view.

Try this on a new project, others will need republishing in order to get the
view to work.

Note that you can obviously make your own formulas, just search the newgroup
and you'll find the most commonly used ones.
 
A

Arun

Thank you Ben.

Ben Howard said:
Hi Arun,

The two fields displayed are enterprise custom fields, with a formula
attached. Each formula looks at another Enterprise custom field, so four
fields are used in total, Project Scheudule status, Schedule Status, Project
Cost Status and Cost status

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

Costs Status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No Baseline",IIf([Cost
Variance]>[Baseline Cost]*0.15,"1_ 15%+ Over Budget",IIf([Cost
Variance]>[Baseline Cost]*0.01 And [Cost Variance]<=[Baseline Cost]*0.15,"2_
1% to 15% Over Budget","3_ On Budget")))

and then Project Cost Staus = [cost status]

You'll need to baseline the projects to use the formula, and then use the
Graphical indicators for the Project Cost and Project Schedule status to
display the traffic light colours, eg Equals 1_15%+ Over Budget displays the
Red stop light image.

The enterprise fields then need to be made visible in a view.

Try this on a new project, others will need republishing in order to get the
view to work.

Note that you can obviously make your own formulas, just search the newgroup
and you'll find the most commonly used ones.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



Arun said:
Hi,
I am using Project Server 2007.How can I get the prject status like
"Project Schedule Status", "Project Cost Status" in Project Center. As in the
followingscreen shot.

http://office.microsoft.com//search/redir.aspx?AssetID=ES102032161033&CTT=5&Origin=HA101656451033

Thanks ,
Arun
Click to expand...
Click to expand...
 
A

Arun

Hi Ben,
Is it possible to get step by step guide for this. Because I set the
baseline for the project and added the baseline start, baseline finish
columns to the project then I added a new column Project Status with Text
field, it showing value '3_ On Schedule' . eventhough the date passed...

Thanks,
Arun

Ben Howard said:
Hi Arun,

The two fields displayed are enterprise custom fields, with a formula
attached. Each formula looks at another Enterprise custom field, so four
fields are used in total, Project Scheudule status, Schedule Status, Project
Cost Status and Cost status

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

Costs Status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No Baseline",IIf([Cost
Variance]>[Baseline Cost]*0.15,"1_ 15%+ Over Budget",IIf([Cost
Variance]>[Baseline Cost]*0.01 And [Cost Variance]<=[Baseline Cost]*0.15,"2_
1% to 15% Over Budget","3_ On Budget")))

and then Project Cost Staus = [cost status]

You'll need to baseline the projects to use the formula, and then use the
Graphical indicators for the Project Cost and Project Schedule status to
display the traffic light colours, eg Equals 1_15%+ Over Budget displays the
Red stop light image.

The enterprise fields then need to be made visible in a view.

Try this on a new project, others will need republishing in order to get the
view to work.

Note that you can obviously make your own formulas, just search the newgroup
and you'll find the most commonly used ones.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



Arun said:
Hi,
I am using Project Server 2007.How can I get the prject status like
"Project Schedule Status", "Project Cost Status" in Project Center. As in the
followingscreen shot.

http://office.microsoft.com//search/redir.aspx?AssetID=ES102032161033&CTT=5&Origin=HA101656451033

Thanks ,
Arun
Click to expand...
Click to expand...
 
A

Arun

Hi Ben,
It is working fine. It is only showing for subtasks like task leve
2,3,etc. How can I get it for Top level tasks and whole project?

Thanks ,Arun

Ben Howard said:
Hi Arun,

The two fields displayed are enterprise custom fields, with a formula
attached. Each formula looks at another Enterprise custom field, so four
fields are used in total, Project Scheudule status, Schedule Status, Project
Cost Status and Cost status

Schedule status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No
Baseline",IIf(DateDiff("d",[Baseline Finish],[Finish])>10,"1_ 10+ Days
Late",IIf(DateDiff("d",[Baseline Finish],[Finish])>=1 And
DateDiff("d",[Baseline Finish],[Finish])<=10,"2_ 1 to 10 Days Late","3_ On
Schedule")))

and then Project Schedule status = [schedule status]

Costs Status =
IIf(ProjDateValue([Baseline Finish])=4294967295,"4_ No Baseline",IIf([Cost
Variance]>[Baseline Cost]*0.15,"1_ 15%+ Over Budget",IIf([Cost
Variance]>[Baseline Cost]*0.01 And [Cost Variance]<=[Baseline Cost]*0.15,"2_
1% to 15% Over Budget","3_ On Budget")))

and then Project Cost Staus = [cost status]

You'll need to baseline the projects to use the formula, and then use the
Graphical indicators for the Project Cost and Project Schedule status to
display the traffic light colours, eg Equals 1_15%+ Over Budget displays the
Red stop light image.

The enterprise fields then need to be made visible in a view.

Try this on a new project, others will need republishing in order to get the
view to work.

Note that you can obviously make your own formulas, just search the newgroup
and you'll find the most commonly used ones.
--
Thanks, Ben.
http://appleparkltd.spaces.live.com/



Arun said:
Hi,
I am using Project Server 2007.How can I get the prject status like
"Project Schedule Status", "Project Cost Status" in Project Center. As in the
followingscreen shot.

http://office.microsoft.com//search/redir.aspx?AssetID=ES102032161033&CTT=5&Origin=HA101656451033

Thanks ,
Arun
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Graphical (Iconinc) view for Project Schedule status 1
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0
Misaligned and Wrong Title Headings in Project Center View 1
Project Server 2007 Status report template 3
MY Tasks will not pass non hourly info with Dec update 1
Project server 2007 Program Managment 1
Email field in Project Center view 9
Problem with the RAG Status in Project 0

Top