+ Reply to Thread
Results 1 to 6 of 6

Project timeline calculation

  1. #1
    Registered User
    Join Date
    02-22-2009
    Location
    MORRISTOWN, NJ
    MS-Off Ver
    MICROSOFT 365
    Posts
    60

    Project timeline calculation

    I'm having trouble calculating the start and finish dates (columns H and I) on the attached spreadsheet. I appreciate any help in the calculation of these two columns. Thanks.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Project timeline calculation

    looking at some o your range names, they have #Reff errors in them. this is causing #ref errors in col I, whic looks like it feeds into H

    Take a look at ranges HH and Strt and see if you can fix the #Ref erros inthem and see if that fixes your problem?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    02-22-2009
    Location
    MORRISTOWN, NJ
    MS-Off Ver
    MICROSOFT 365
    Posts
    60

    Re: Project timeline calculation

    Honestly, I worked on this spreadsheet with another person over a year ago, and completely forgot everything, and could not even begin to fix any errors. What I'm looking to do is:
    1. Taking the assumption of the amount of time in Process Hours (Column G) and assuming I work an 8 hour day
    2. Making the assumption I begin the project on July 1, 2012 and must complete the first State (California, Row 3), when would I finish?
    3. This finish date +1 (the next business day) I would be able to start the next state (New York, Row 4), until I finish the entire project.

    Thank you.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Project timeline calculation

    ok, this may take a few back and forth, but lets see how this works for you. test it and let me know if we are getting close
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-22-2009
    Location
    MORRISTOWN, NJ
    MS-Off Ver
    MICROSOFT 365
    Posts
    60

    Re: Project timeline calculation

    The finish dates in your attachment are moving backwards in time instead of forwards... meaning, if I started project 1 for California on July 1, 2012 and it takes me 149+ process hours to complete, the finish date cannot be in June, 2012 (the month before) because we're moving forward from July 1st start date.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Project timeline calculation

    sorry, stupid mistake on my part.

    the formulas in I should be...
    =WORKDAY(H3,G3-(Start-End),Table1[Holidays])
    i had them as...
    =WORKDAY(H3,G3/(Start-End),Table1[Holidays])

+ Reply to Thread

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