Create Planned Target vs Actual S-Curve from MS Project

Поделиться
HTML-код
  • Опубликовано: 10 сен 2024

Комментарии • 31

  • @user-jv1ch8rx7v
    @user-jv1ch8rx7v 4 месяца назад

    Good day, Engr. What if the data in the cumulative work and baseline cumulative work is not accumulating?

  • @-LyEngineer-zm4dw
    @-LyEngineer-zm4dw 9 месяцев назад

    Thanks for sharing!
    I followed all the steps but in the Excel File the data of Baseline Cumulative Work and Cumulative Actual Work didn't show any data or numbers. Could you please advise how to fix this?
    Appreciate your reply!

  • @majdwehbe3297
    @majdwehbe3297 Год назад

    I am not finding the baseline cumulative work when editing the template in the available fields, how to add it?

  • @avishekkumar749
    @avishekkumar749 4 месяца назад

    Can we create the S curve with the Material resource instead of Work?

  • @daniprasetyo3942
    @daniprasetyo3942 3 месяца назад

    Hi bro, could you help me, i have followed your way but i have some problems. First when i adjust the date to be late on week for example, following task will be adjusted automatically shorter one week. So that, the cumulative will be same after all. What makes this thing happen? Thank in advance

    • @ExcelInsights
      @ExcelInsights  3 месяца назад

      Do you mean: if you adjust a task, the next task should stay in place, or be pushed?
      If stay in place, you need to disconnect the link between the task.
      If need to push forward, create a link between the task. If the second task does not move, right click on the second task and remove any Constraint

  • @benpienaar2310
    @benpienaar2310 11 месяцев назад

    Hi Donny. When creating the visual report, a different progress update (previous month) is being generated in excel and calculates wrong percentages. Please advise.

    • @ExcelInsights
      @ExcelInsights  11 месяцев назад

      Not sure what exactly is going on there but when you are in the part where you check fields to export, you can try to check everything that has "cumulative" on it and see if any of them reflects the current month/updates.

  • @user-ih5qf9oj6f
    @user-ih5qf9oj6f 7 месяцев назад

    Hi, can i get some help.
    Actually i just need to show my target % vs actual %
    I've been searching 100 videos, and none have done so. is microsoft project unable to do such simple task? im abit frustrated

    • @ExcelInsights
      @ExcelInsights  7 месяцев назад

      Hi Timothy, do you want to show this in the S-Curve report?

    • @user-ih5qf9oj6f
      @user-ih5qf9oj6f 7 месяцев назад

      hi, nope, i actualy want to show this on the column. i got a sample (PDF) but im not sure how to recreate it. @@ExcelInsights

  • @feliciafrisca6123
    @feliciafrisca6123 11 месяцев назад

    Hi, I have done creating the S curve, however, my baseline accumulative was 0 and the accumulative work was fine. Is there any missing step that I should do? Thanks

    • @ExcelInsights
      @ExcelInsights  10 месяцев назад

      Hi, did you declare a baseline when you initially created your Gantt chart?

    • @feliciafrisca6123
      @feliciafrisca6123 10 месяцев назад

      @@ExcelInsights hi Yes, I already set the baseline, then I change start and finish into baseline start and baseline finish

  • @dannielemilio
    @dannielemilio 3 месяца назад

    thanks!

  • @nurulsyahira5516
    @nurulsyahira5516 8 месяцев назад

    Thanks for sharing! Do we need to key in the cost to generate the data? I followed your tutorial but it did not work. Hope you can assist with this. Thank you.

    • @nurulsyahira5516
      @nurulsyahira5516 8 месяцев назад

      I already at resources in the programme (Resource Type - Cost) but I still cant generate the report

  • @chanont6042
    @chanont6042 Год назад

    Good job

  • @GaytriVaghela-i3e
    @GaytriVaghela-i3e Год назад

    How does the data come in an excel sheet? and how the project calculates the data based on dates or costs?

    • @ExcelInsights
      @ExcelInsights  Год назад

      Hi, how it was exported to Excel is in the video.
      Not sure about your second question: do you mean how Project calculates cost?
      You may want to watch other videos in the playlist to see how you should enter the cost of each resource yourself.
      You cannot create an S-Curve with dates.

  • @congcong93
    @congcong93 8 месяцев назад

    Hi , why my chart value is all 0 pls help

  • @suddenlee5874
    @suddenlee5874 Год назад

    The data that was generated in excel for both baseline cumulative work and cumulative actual work was 0 for me, what am I missing?

    • @gerhardhough8138
      @gerhardhough8138 Год назад +1

      I have the same problem, did you manage to resolve? Do you need the cost for the activities before it will generate?

    • @hansontan3149
      @hansontan3149 Год назад

      I'm having same issue too. Any advice?

    • @ExcelInsights
      @ExcelInsights  Год назад

      Hi, have you added resources and their costs?

    • @hansontan3149
      @hansontan3149 Год назад

      @@ExcelInsights I'm sorry, not sure how to do that.

    • @ExcelInsights
      @ExcelInsights  Год назад

      Try this ruclips.net/video/ANwKuLFF-5I/видео.html

  • @jmck1960ful
    @jmck1960ful Год назад

    How do you get the weekly calendar filter to appear?

    • @ExcelInsights
      @ExcelInsights  Год назад +1

      You need to keep clicking the square toggle buttons.

  • @cllo325
    @cllo325 Год назад

    Hi , my msp hang when ever i clicked on the "visual report "tab🙃

    • @ExcelInsights
      @ExcelInsights  Год назад

      If this only happens in that specific task, you need to repair/reinstall your MS Project