MS Project - Manual Percentage on % Complete 1

[alambritis]

Hello Guys,

I am new to the MS Project and I want to manually enter the percentage for each task. I have create new column with text but this is not good because the task indicators doesnt show the tick ? (as it does when a task is marked 100%).

Please advise me how to get this done, thank you,

Andreas

 

[PDQBach]

What you want cannot be done without VBA -- and, even then, it's ugly. (And, given your experience with Project, you don't want to try to use VBA to accomplish this.)

 

[alambritis]

I know that the only way is to use VBA, is it too hard if you can provide me with some logic so I can try?

thank you PDQBach,

 

[PDQBach]

Well ... the VBA is simple.

Let's assume that you have Number11 set up as the field where you want to enter your percentage.

Sub pdq1()
    Dim tsk As Task
    For Each tsk In ActiveProject.Tasks
        If Not tsk Is Nothing Then
            If Not tsk.Summary Then
                tsk.PercentComplete = tsk.Number11
            End If
        End If
    Next
End Sub

But remember that you have to run this every time you make changes to Number11 because the entries are not automatically propagated.

Also, make sure you understand in your own mind what the difference between "% Complete" and "% Work Complete" represent.

 

[JulieInMaine]

Hi alambritis,

I'm not really sure why you want to do this -- but have you considered using the Physical % Complete field?

I'm not sure why you don't think you can manually enter % Complete in the usual field. I'm sure there is something you're thinking of that we aren't seeing.

JUlie

 

[alambritis]

Hello Guys,
Thank you for trying to help me out.

Juile...The physical c% Complete does not show the tick on the task ID when is set to 100%.
% Complete, & work complete combine work duration and are automatically entered when I have a major tasks especially.

What i need to achieve is for all tasks even major, or subtasks to be able to insert a manual percentage and when I insert 100% to have the tick on the left (task ID) or other column with graphical indicatro showing a Tick on the task 100% completed.

It sounds silly to use MS Project and trying to do manual staff, but this is what my boss asked me because he only uses MS Project for tasks management and not budget, gantt charts etc.

The VBA provide by BDQ does not work

Is there any easier way to do this, for example if I have a dropdown menu in a column task status (open, in progress, completed) to have a graphical indicator in another column according to the task status?

Thank you,

Andreas

 

[PDQBach]

What do you mean "it doesn't work"? It worked fine when I tested it.

 

[JulieInMaine]

Andreas,

If you are looking for a tick mark similiar to the blue check box, consider using a flag field (that can be set from a calculation on a number field) and then use a graphic indicator instead of the "yes" or "no" from the flag.

For example in Flag1:
IIf([Number1] = 100, "Yes", "No")

Then set a graphic indicator in the Flag1 field.

You can carry it a bet further with a lookup field (Text1) with the options you note -- and then set the Flag1 field.

I hope this helps.

Julie