Results 1 to 4 of 4

Calculate Duration & Resources

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    07-16-2007
    Location
    GA
    MS-Off Ver
    Office 365 - Version 2403
    Posts
    1,059

    Question Calculate Duration & Resources

    Hi,

    I have a project that we're hoping to start this week or next week & complete by 12/20/12

    My basic scenario is:

    -- Through the WBS (to the left), I may have 300 items to complete & I have an Average Duration that could change in Cell BH 62
    -- Based on Average Duration & Quantity, seeking functions that can calculate the Estimated Workdays Needed, then break that down to Estimated Hours & then the # of Individuals
    Needed
    -- I think once I have the above, I can graph out a forecast


    Please see example file.

    Thanks for the assistance.
    Attached Files Attached Files
    MyCon
    -- Using Latest Version of Excel

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1