displaying the % of the baseline

In Format, Bar Styles make a new style on a new line at the top of the list.

Give it any name like "Baseline % Planned Complete".

Select the shapes and colours for the bar and the ends of the bar.

Select for Normal Tasks.

Put it on Row 2

Make it start at Start10 and finish at Finish10.



For Milestones, make another Bar Style on the next line under the first

Give it any name like "Baseline % Planned Complete".

Select the shapes and colours for the bar, but in this case only the left hand end

Select for Milestone Tasks.

Put it on Row 2.

Make it start at Start10 and finish at Start10.



Put a formula in Start10.

[baseline start]

Put a formula in finish10:



IIf([Baseline Start]>[Status Date],[Baseline Start],IIf([Baseline Finish]<[Status Date],[Baseline Finish],[Status Date]))



Put a formula in a spare number field, Number10:



IIf([Baseline Finish]<[Status Date] Or [Baseline Finish]=[Status Date],100,IIf([Baseline Start]>[Status Date],0,IIf([Baseline Start]<[Status Date] And [Baseline Finish]>[Status Date],ProjDateDiff([Baseline Start],[Status Date])/[Baseline Duration])*100))



Put a formula in a spare text field, Text10:



[Number10] & "%"



Format the Bar Styles to put the Number10 text on the end of the bars.

1. Set up a formula to put a date in Start7 that represents "Start" plus "number-of-%WorkComplete-days".



Assuming a 10 work day duration, a %WorkComplete of ...

10% would calc "number-of-%WorkComplete-days" as 1 day;

20% would calc "number-of-%WorkComplete-days" as 2 days,

etc.



1a. Display the Start7 column

1b. RightMouseButton on the column header and select "Customize fields..." from the context menu popup

1c. In the Customize fields popup click on the "Formula" button

1d. In the Formula popup paste the following formula:



projdateadd([Start],(ProjDateDiff([Start],[Finish])*[% Work Complete]/100))



This will

A. take the Start date of the task

B. calculate the number of project work days [thus we’ll ignore weekends, etc.] in minutes [Project’s internal calculations are always done in minutes]

C. calculate the percent of those minutes that have elapsed based on the %WorkComplete [you could also choose %Complete]

D. Add that calculation to the Start date

E. Put the result in Start7





2. Set up the Gantt chart to display the information.



2a. View > Gantt

2b. Format > Bar Styles

2c. Locate the "Progress" row

2d. Click on the cell on that row that is underneath "To". (If it wasn’t changed by someone else, it should be showing "Complete Through")

2e. Select Start7 (the field we calculated above).

Lewis, thank you.

How ever, what i wanted show on the gantt chart is not the text but the base line progress on the bar similar to percentage complete (Actual).

Let’s assume that your calculation puts the % in the Number1 field.



View > Gantt

Format > Bar styles



In the popup:

Click on the row labelled "task"

Click on the tab labelled "text"

Click to the right of the position label(left, right, top, bottom, as appropriate) and select "Number1"

Click on OK

Can some one help me how to display that perecentage on the Gannt chart

Early start: ok, 0%.



Partial allocation: sheesh, we’re just trying to help people here. I have no way of knowing how your individual resources and team resources are going to be assigned or how you handle overtime or any of a dozen other questions.



You, after all, are the one who said an activity "is 10 days long" and there’s no way anyone would interpret that as meaning that a resource (or a team of resources) is assigned 100% to that task for that duration.



But you’re probably right about one thing: I guessed you had already looked around this site and found that the various equations used by others weren’t applicable in your case. If they were, you wouldn’t have posed your question. Since you did pose your question, it seems quite reasonable to ask for clarification.



Have a nice "next life" because this one clearly isn’t going well for you.

Jon,



Did you not get Niek’s formula to work?



The Custom Field, Number12 I think in his example, should display what you’re after.



Regards,



Darren

And what happens if the baseline start is the 10th and it starts on the 8th?



And what happens if the resource is allocated at 10% and the task can start late but still be finished on time (or early!)?



And how do you plan to incorporate Slack in your equation?



As I said earlier: please give us the equation you want used.

1. Do you mean in the lefthand side of the display (the grid) or the righthand side of the display (the Gantt chart)?



2. Please give us the equation using the field names like "Baseline start", "Actual Start", etc.