none
simple weight of tasks - not by duration RRS feed

  • Question

  • i would like % complete to be rolled up / computed by a weight assigned to each task, not duration.

    simple example:

    i am paid $100,000 total for a contract.

    the contract consists of two sub tasks, $50,000 each.

    the tasks have different duration amount.

    i would like to be able to enter a completion % for each sub task, and have the main task be figured by $ percentage instead of duration.

    i am the only resource, and am looking for the simplest solution.

    thanks

    Monday, August 20, 2012 12:37 PM

Answers

All replies

  • Hi,

    Let's see if this suits you.

    Insert 3 custom Fields

    Number1, rename as input pct comp (for instance)

    Number 2 rename as Calculated % comp

    Cost1 rename as Completed Cost

    and I suppose total cost for the task is in the cost field

    Then do the following customizations ( formula)

    Cost1 = Cost * Number1 / 100

    for summary rows, use Sum

    Number2 = 100*Cost1/Cost

    For Summary Rows, use formula

    Greetings,

    Monday, August 20, 2012 12:58 PM
    Moderator
  • sorry, i am lost after renaming the fields.
    Monday, August 20, 2012 3:08 PM
  • Hi,

    So you never used a formula in Project? Let's try to go ahead

    I suppose you're in the Customize Fields form since you say you renamed the fields.

    When the cost1 field selected, click the word formula

    In the formula window write [Cost]*[Number1]/100

    OK

    When back in the Custom Fields form, below Calculation for Task and Group Summary rows select Sum

    Analogous for Number2

    Greetings,

    Monday, August 20, 2012 4:31 PM
    Moderator
  • ok i believe that is done. now what am i supposed to do with the new fields?
    Monday, August 20, 2012 4:54 PM
  • Hi,

    As said, I suppose the ask cost is in the Cost field

    The number1 field has to receive your % Complete

    Number2 will nos show your % Complete for summary tasks.

    Greetings,

    Monday, August 20, 2012 5:25 PM
    Moderator