How to do AutoCalculations?

Posted on 2008-11-19
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
    LVL 15

    Accepted Solution


    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

    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

    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

    How did you post it on EE?
    LVL 15

    Expert Comment

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Suggested Solutions

    Prologue Today, the Information Technology Infrastructure Library® (ITIL) is very commonly used in the IT industry for IT Service Management. It is strongly promoted by the service management industry experts. In 1980, the need for ITIL was per…
    Cobalt Digital Marketing began using the Scrum Framework development process in summer 2009.  We hired a consultant to train the teams, observe meetings, and answer questions. He recommended that we begin using one-week sprints for several reason…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    730 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now