+ Reply to Thread
Results 1 to 2 of 2

Create the s curve based on dates

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2016
    Posts
    19

    Create the s curve based on dates

    Dear Seniors,

    I am working on Project Planning, I need to create the Progress curve for our Project based on Weight Factor every month.

    I need to create the Plan and actual curve based on the dates defined in particular activities. Once the activity progress is calculated every month based on cut off date then it will sum product with corresponding WF to get the progress achieved every month. Presently I am calculating the values every month and pasting the values in Chart data every month. I had created the S Curve and attached here.

    Now my objective is to automatically calculate the values for the entire cut off date at one time (From Project Start to End). i.e I don't want to do any manual work in the Chart. I will update only the actual Dates in the file, then the curves need to get automatically updated.

    1) I don't want to calculate the progress for individual activities, I would like to calculate the overall progress directly and I need your help to do the same.

    2) When I change the Cut off date, then the previous values needs to become static.

    I hope to get your support to solve my problem soon.

    Thanks and Regards
    R. Vadivelan
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Create the s curve based on dates

    Please clarify what you are changing. Is it J2 on Rev_0?

    Are you trying to generate the numbers in B32:S34 on the Curve sheet automatically, and if so how do the ones you currently show relate to any numbers/dates on the REV_0 sheet?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Based on col dates create col of dates for the first day of that same month and year
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-28-2011, 09:32 PM
  2. [SOLVED] CREATE A SUM BASED ON DATES
    By Gordon.Ferguson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 PM
  3. CREATE A SUM BASED ON DATES
    By Gordon.Ferguson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 06:05 AM
  4. CREATE A SUM BASED ON DATES
    By Gordon.Ferguson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. CREATE A SUM BASED ON DATES
    By Gordon.Ferguson in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

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