Create Planned Target vs Actual S-Curve from MS Project

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024

ความคิดเห็น • 31

  • @-LyEngineer-zm4dw
    @-LyEngineer-zm4dw 10 หลายเดือนก่อน

    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!

  • @nurulsyahira5516
    @nurulsyahira5516 9 หลายเดือนก่อน

    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 9 หลายเดือนก่อน

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

  • @MartinCarlJamer
    @MartinCarlJamer 6 หลายเดือนก่อน

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

  • @avishekkumar749
    @avishekkumar749 5 หลายเดือนก่อน

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

  • @majdwehbe3297
    @majdwehbe3297 ปีที่แล้ว

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

  • @daniprasetyo3942
    @daniprasetyo3942 4 หลายเดือนก่อน

    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  4 หลายเดือนก่อน

      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 ปีที่แล้ว

    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  ปีที่แล้ว

      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.

  • @feliciafrisca6123
    @feliciafrisca6123 ปีที่แล้ว

    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  ปีที่แล้ว

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

    • @feliciafrisca6123
      @feliciafrisca6123 ปีที่แล้ว

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

  • @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.

  • @timothylim-x8x
    @timothylim-x8x 8 หลายเดือนก่อน

    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  8 หลายเดือนก่อน

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

    • @timothylim-x8x
      @timothylim-x8x 8 หลายเดือนก่อน

      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

  • @congcong93
    @congcong93 9 หลายเดือนก่อน +1

    Hi , why my chart value is all 0 pls help

  • @dannielemilio
    @dannielemilio 4 หลายเดือนก่อน

    thanks!

  • @jmck1960ful
    @jmck1960ful ปีที่แล้ว

    How do you get the weekly calendar filter to appear?

    • @ExcelInsights
      @ExcelInsights  ปีที่แล้ว +1

      You need to keep clicking the square toggle buttons.

  • @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 th-cam.com/video/ANwKuLFF-5I/w-d-xo.html

  • @chanont6042
    @chanont6042 ปีที่แล้ว

    Good job

  • @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