% Complete acting funny

Home Forums Microsoft Project Discussion Forum % Complete acting funny

Viewing 8 reply threads
  • Author
    Posts
    • #479133
      bobc455
      Member

      Trying to figure out why my % complete is acting goofy.

      For example on a task with:
      Duration = 3w
      Work = 18h
      Constraint type = ASAP
      Predecessor task 100% complete
      Effort Driven = Yes
      Task Type = Fixed Duration

      I am getting the following % complete values:
      Actual work % complete
      6 Hours 5%
      9 Hours 8%
      16 Hours 13%
      18 Hours 100%

      The thing that brought this to my attention was that I tried to click the 50% complete button and it jumped right to 100%.

      I am able to cure this by deleting the hours (=0) then moving them back to 18, but I’m trying to figure out how this got “corrupted” like that in the first place. I’ve seen it happen a few times before as well and haven’t been able to put my finger on the cause.

      Thanks!

      -Bob C.

    • #479159
      Avatar photoJohn Riopel
      Participant

      Is the task in the past, meaning the start and end dates are in the past of the current date? The % complete button are progressing duration complete, work complete can be different than duration complete.

    • #479166
      bobc455
      Member

      Hi John!

      No – the example task I’m working on is a 3-week task which started before Christmas and will probably be done the end of this week.

      Thanks!

      -Bob C.

    • #479167
      bobc455
      Member

      What confuses me is that the % complete values it seems to be using would be accurate if I had about 120 hours of work on the task (i.e. 100% for the 3 weeks duration). But since I only have 18 hours of work for the task, I would think that when I enter Actual Work = 9 hours it should mark the task 50% complete (or vice versa if I mark the task 50% complete it should fill in 9 hours in the Actual Work column).

      For what it’s worth, I am not using Project Server but I am using a “resources” file for tracking resource utilization across all projects.

      -Bob C.

    • #479182

      Bob C.
      I think the confusion your seeing is based on the way we (people) think of % complete and the way MS Project actually calculates it. As per MS:

      “The % Complete fields contain the current status of a task, expressed as the percentage of the task’s duration that has been completed. You can enter percent complete, or you can have Project calculate it for you based on actual duration.”

      Typically, we think of a 40 hour task that takes 1 week for example. In this case work effort is pretty much tied 1-1 with, and drives duration. As a result, %complete seems to work as our expectation of how it works. In your case however, you have 18 hours of work spread over 3 weeks so our expectation that %complete is based on hours of work completed doesn’t align with how MSP actually calculates it (which is duration based). As a result, %Complete numbers seem to make no sense. As you mentioned, if you increase the hours to match 100% allocation for 3 weeks, the %Complete now presents numbers you expected to see.

      See if this MSP posting helps explain it further:
      https://support.microsoft.com/en-us/office/percent-complete-fields-84ec5068-4a34-497c-97eb-e12b6dc47cc5

      Hope this helps.

    • #479201
      bobc455
      Member

      Hey Daryl-

      Oh wow! I’ve been using MS project almost 15 years now, and I always assumed that % complete was tied to actual work and not just duration. I’m sure it was happening to me before, but I’m in a new environment which is heavily R&D (and therefore heavily multitasking) so it’s probably more noticeable to me now.

      It seems the only other option I have is to check the “Edits to total task % complete will be spread to the status date” box, which is unchecked by default. At least that’s what I think the article refers to. I still won’t get a clean representation of hours spent on the job so far versus % complete shown, but it will be a little closer (and at least now I understand why I’ll be seeing a discrepancy). And the good news is that the discrepancy really won’t have a huge impact on resources since it’s really just a reporting thing and I’ll be cognizant of this as I am looking at resource usage / availability across departments.

      If I was really brave I’d start playing around with different work contours in this situation but I think I’ll find other ways to obtain my excitement…

      Thanks!

      -Bob C.

    • #483897
      ashelybrown
      Participant

      I think the confusion your seeing is based on the way we (people) think of % complete and the way MS Project actually calculates it. As per MS:

      “The % Complete fields contain the current status of a task, expressed as the percentage of the task’s duration that has been completed. You can enter percent complete, or you can have Project calculate it for you based on actual duration.”

      Typically, we think of a 40 hour task that takes 1 week for example. In this case work effort is pretty much tied 1-1 with, and drives duration. As a result, %complete seems to work as our expectation of how it works. In your case however, you have 18 hours of work spread over 3 weeks so our expectation that %complete is based on hours of work completed doesn’t align with how MSP actually calculates it (which is duration based). As a result, %Complete numbers seem to make no sense. As you mentioned, if you increase the hours to match 100% allocation for 3 weeks, the %Complete now presents numbers you expected to see.
      _______________________________
      https://www.gametables4less.com/

    • #483983
      bobc455
      Member

      Hi Ashley!

      Yes it’s weird for sure, but even if I enter some % complete value directly (for example 62%), the % complete jumps to 100%. So when it says “You can enter percent complete” even when I do that it doesn’t function as I’d expect.

      Anyhow I’m just working around it, for my purposes either a task is complete or it isn’t so I’m just fudging stuff and coping.

      Thanks!

      -Bob C.

    • #496191
      WileyPerez
      Participant

      Thanks for the information.

Viewing 8 reply threads
  • You must be logged in to reply to this topic.