How to do AutoCalculations?

Posted on 2008-11-19
Medium Priority
Last Modified: 2013-11-15
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?
Question by:tmonteit
  • 3
  • 2
LVL 15

Accepted Solution

dbase118 earned 2000 total points
ID: 23014257

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.


Author Comment

ID: 23056950
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?
LVL 15

Expert Comment

ID: 23061944
For the graphic I just did a screen capture (PRINT SCREEN) and pasted into MS Paint then saved as a .JPG

Hope it helped

Author Comment

ID: 23061947
How did you post it on EE?
LVL 15

Expert Comment

ID: 23068595
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.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I worked at a US software company that used offshore contractors for ten years and offshore employees for three years. We had a positive experience and you can too.   When I interviewed people for positions in the US, I would tell them that we wor…
Learn how ViaSat reduced average response times for IT incidents from 10 minutes to 30 seconds.
Simple Linear Regression
Starting up a Project

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question