Ask a Question Sign up for Free 83 Experts currently online. Ask Questions for Free!

Formula to Update Percent Complete - Microsoft Project Developer

Hello again, My client wish to remove the subjectivity of the percent complete field. I have set up an Enterprise Outline Code that is a drop-down with the 0, 50 and 100 percent complete. I have set it up on the timesheet at the assignement level so that the resource ...

Results 1 to 4 of 4

  1. #1

    Formula to Update Percent Complete

    Hello again,

    My client wish to remove the subjectivity of the percent complete
    field. I have set up an Enterprise Outline Code that is a drop-down
    with the 0, 50 and 100 percent complete. I have set it up on the
    timesheet at the assignement level so that the resource can choose 0,
    50 or 100% complete. I would like to create a formula that once the
    update is accepted by the PM the real % complete is updated according
    to what the resource chose in the Enterprise Outline Code Number 1
    drop-down.

    Any ideas on this? I have tried several formulas but am wondering if
    this is a macro function that would need to be written.

    Any direction would be greatly appreciated.

    Thanks,

    Scot

    scot.milroy@cibc.ca
  2. #2

    Re: Formula to Update Percent Complete

    Hi,

    Since you can only have formulas in Custom fields, Percent Complete cannot
    hold a formula; you need a VBA procedure to update it.
    You are aware that this will also update Actual Work, aren't you?
    HTH

    --
    Jan De Messemaeker
    Microsoft Project Most Valuable Professional
    http://users.online.be/prom-ade/
    +32-495-300 620
    <ca> schreef in bericht
    news:googlegroups.com... 


    Jan
  3. #3

    Re: Formula to Update Percent Complete

    Scot,
    You can create a VBA script to run on open. Check to make sure the
    enterprise outline code has a value and is greater than zero. Then set the
    % work complete equal to the enterprise outline code.

    Private Sub Project_Open(ByVal pj As Project)
    For Each objTask In ThisProject.Tasks
    If objTask.Summary = False Then
    If objTask.EnterpriseOutlineCode1 <> "0" And
    objTask.EnterpriseOutlineCode1 <> "" Then
    objTask.PercentWorkComplete =
    objTask.EnterpriseOutlineCode1
    End If
    End If
    Next
    End Sub

    You may want to simply tell the resources to only enter 0% ,50% or 100%. I
    always tell my clients' resources to enter it this way (or 0,25,50,75,100)
    and they are glad since it is easier than figuring out if they are 10% or
    15% complete. The very rare variation can be easily changed by the PM.


    --
    Ed Morrison
    msProjectExperts
    "We wrote the books on Project Server"
    http://www.msprojectexperts.com
    FAQ - http://www.projectserverexperts.com



    <ca> wrote in message
    news:googlegroups.com... 


    Ed
  4. #4

    Re: Formula to Update Percent Complete

    ca wrote:
     

    this does not 'remove subjectivity' at all. The number the resource picks
    from the drop down is still subjective and in fact it is even more
    subjective than them editing Percent complete directly because it makes
    them round up or down to only three values. further this is going to serve
    to alienate your PMs since it strongly implies that the updates accepted
    and vetted by the PMs are not real.

    If you want to remove subjectivity from the process stop using Percent
    complete at all and start using Actual Work per time period and remaining
    work as your method for updating assignments. have your resources enter
    the number of hours they worked each day and at the end of the week have
    them enter a new Remaining work value that acts as an updated and revised
    estimate for how much more work there is to do on that assignment. This
    goes much father in removing subjetivity from the process.
     



    --
    Brian K - Project MVP
    http://www.projectified.com
    --
    Senior Trainer - Electronic Arts
    --
    QuantumPM Associate
    http://www.quantumpm.com
    Brian

Similar Threads

  1. Building a complete solution using InfoPath
    By Karen in forum Microsoft InfoPath
    Replies: 3
    Last Post: 09-08, 11:03 PM
  2. Physical % Complete in 2002
    By Margy in forum Microsoft Project
    Replies: 1
    Last Post: 08-01, 02:39 AM
  3. Shift complete schedule to the right
    By Varun in forum Microsoft Project
    Replies: 1
    Last Post: 07-17, 06:13 PM
  4. actual finish date and physical%complete
    By K. in forum Microsoft Project
    Replies: 0
    Last Post: 07-10, 08:05 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100