• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • Last Modified:

How to do AutoCalculations?

How do I best setup project to autocalculate based on the following situation.

I have a Bridge Engineer (BE) and a Safety Engineer SE).    I can assume that every hour of bridge engineering needs 15 minutes of safety review.  

I want my safety Engineer hours to auto calculate and auto fill based on Bridge Engineer Effort.  

WBS.      Task                                Assigned       Duration
1.0          Build Bridge 1                  BE                  4h
2.0          Build Bridge 2                  BE                  8h
3.0          Safety Inspection            SE                  3h (***Autocalc)

How to set that up in MS Project?
0
tmonteit
Asked:
tmonteit
  • 3
  • 2
1 Solution
 
dbase118Commented:
tmonteit,

You can not customize the defaul duration field to include a formula. Anything you do would need to be done in a custom duration field which you can add easily enough. I have not been able to come up with a formula that will add all the durations of fields assigned to the Bridge Engineer and then multiply by .25 to get total hours. What I did come up with was a way to calculate the safety time on a per line basis using the calculated field. However, it would still need to be manually transferred to the default duration field for the individual safety checks.  If this looks like it might be a solution, let me know.

Otherwise maybe someone else will chime in with some more ideas.


Project-Sample.JPG
0
 
tmonteitAuthor Commented:
Good answer and Wow!  how did you put that graphic in?  My questions would be much more effective if I could simply snagit in images?
0
 
dbase118Commented:
For the graphic I just did a screen capture (PRINT SCREEN) and pasted into MS Paint then saved as a .JPG

Hope it helped
0
 
tmonteitAuthor Commented:
How did you post it on EE?
0
 
dbase118Commented:
There should be a little check box under the comment box that says attach file. If you check that  it will show you the accepted file types. Then you can click add file and browse to the file you saved in one of those formats.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now