Create Planned Target vs Actual S-Curve from MS Project

[@mik1998]

great video tutorial. Do you have tutorial for financial S curve or cost monitoring s curve. Thanks.

[@-LyEngineer-zm4dw]

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!

[@rahulpalakandy]

You have to assign the resources first. Then the work information will show up.

[@nurulsyahira5516]

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]

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

[@hyunjincho5429]

Hi, just wondering.
What was the Earned Value Method you assigned for the tasks?
Does it have any impact on the S-Curve?

[@MartinCarlJamer]

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

[@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]

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

[@feliciafrisca6123]

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

[@avishekkumar749]

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

[@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]

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.

[@daniprasetyo3942]

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]

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

[@majdwehbe3297]

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

[@timothylim-x8x]

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]

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

[@timothylim-x8x]

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

[@GaytriVaghela-i3e]

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

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

[@jmck1960ful]

How do you get the weekly calendar filter to appear?

[@ExcelInsights]

You need to keep clicking the square toggle buttons.

[@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]

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

[@hansontan3149]

I'm having same issue too. Any advice?

[@ExcelInsights]

Hi, have you added resources and their costs?

[@hansontan3149]

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

[@ExcelInsights]

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

[@congcong93]

Hi , why my chart value is all 0 pls help

[@chanont6042]

Good job

[@dannielemilio]

thanks!

[@cllo325]

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

[@ExcelInsights]

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