Friday, May 04, 2012 8:24 PM
I'm trying to customize a view in project pro 2010, and can't quite figure out how to get this done
How can I calculate 2 different costs for a task based on 2 different work estimates with the same resource?
task low work high work low cost high cost
task1 40hrs 80hrs $4000 $8000
task 2 18hrs 32hrs $1800 $3200
The resource does not change rates - but the task duration is ranged (low - high) because the requirements are still being firmed up.
I have created custom fields for these, but cant figure out a formula that works. Any help would be greatly appreciated.
Friday, May 04, 2012 9:01 PM
A few questions. Your example shows low work and high work yet you talk about task duration ranging from low to high. For reference, duration and work are two separate entities in Project. Duration is the working time between the task start and finish. Work on the other hand is the amount of estimated effort to accomplish the task. If a single resource is assigned to a given task full time then the work and duration are equal, but in most plans, resources are not necessarily assigned full time by themselves. There may be multiple resources or a single resource may only work part time. For example, due to various factors the duration of a task may increase but the work remains constant, or, the duration may be the same but the work changes. So, what is you scenario?
If your plan is a simple structure of one resource assigned full time to each task, then a factor can be used to generate the two cost values. What field contains your "low work" and what field contains your "high work"?
You can probably get what you want. It may be simple or it may be more complex. We just need to know more about your plan.
Friday, May 04, 2012 11:13 PM
Sorry for the confusion - I was referring to effort, and for the purposes of my example you could assume I was talking about effort (work) for a single resource. I am not referring to duration by any means - just looking to calculate ( rate x effort ) for multiple efforts for the same task to come up with cost for a low estimate and a high estimate.
As a further example, I have tasks that are fixed 40 hour tasks (no low/highrange), and I have tasks that are 40 to 80 or 40 to 60 hour tasks (depending on additional discovery). If I can get the simple case figured out, I'm confident I can extend it to multiple resources and rates.
I am not looking to do a simple +/- %20 type of estimate, I have a firm grip on that type of calculation. As for the fields used, I created new custom fields, but just can't get at the resource rates to do the math in a formula.
I hope this makes more sense. Thanks for your response.
Saturday, May 05, 2012 1:14 AM
Perhaps the problem is you are trying to use the standard rate in a formula in a custom field in a task view and the Standard Rate is only available for custom fields in a resource view (e.g. Resource Sheet). However, you can get the standard rate value indirectly.
In a sample file I set up four custom fields, Text1 and Text2 to be the "high work" and "low work" value in hours respectively. I then put a formula in Cost1 & Cost2 to calculate the "high cost" and "low cost" as follows:
Cost2 = [text2]*[Cost]/[Work]*60
Does that help?
- Marked As Answer by Mark Egan Monday, May 07, 2012 7:26 PM
Saturday, May 05, 2012 1:24 AM
I'll give this a try. I'm sure this is heading me in the right direction - needing to be in a resource view to get at the rates.
Thanks again for your help.
Saturday, May 05, 2012 2:44 AM
You're welcome and thanks for the feedback. If this answered your question, please mark it as so.
- Edited by John - Project Saturday, May 05, 2012 2:45 AM