displaying the % of the baseline

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.

hello,
i want to show the data on the left hand side of the view i.e. the table, not the Gant chart side,, and what i would llike to show is the % of the Baseline that should have been achieved by the current date.
by this i mean, if an activity is 10 days long and is planned to start on the 10th,, then the baseline will show 0% if the actual date is the 9th,, however,, if the actual date (time-now) is the 15th and the activity has NOT progressed in any way then the actual % will be 0% and the planned will be 50%,,
i use this as a visual on my plans to show slippage
many thanks

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.

And what happens if the baseline start is the 10th and it starts on the 8th? IT SHOWS AS STARTING EARLY, THE PLANNED % IS STILL GOING TO BE 0%, THE BASELILNE BAR WILL BE TO THE RIGHT OF THE ACTUAL BAR

And what happens if the resource is allocated at 10% and the task can start late but still be finished on time (or early!)? WOULD YOU RATHER HAVE RESOURCE STOOD AROUND ON AN OFFSHORE INSTALLATION AT $$ PER DAY JUST SO YOU CAN START AN ACTIVITY WITH A FULL TEAM?? I WOULD ASK MYSELF SOME SERIOUS QUESTIONS IF I HAD AGREED A SCHEDULE WHERE TASKS CAN START LATE WITH 10% OF THE WORK FORCE AND STILL FINISH EARLY,, DO YOU HAVE TO STAND INFRONT OF PROJECT MANAGEMENT OFTEN

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

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



DONT WORRY ABOUT YOUR HELP WITH THE PLANNED PERCENTAGE QUESTION

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

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.

Darren,

your a legend,, thank you very much for your help,, all works perfectly now.

many thanks and have a good weekend

Jon

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

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

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).

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).

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.