Тёмный

Create S-Curve for Planned Target vs Actual Work from MS Project 

Excel Insights
Подписаться 8 тыс.
Просмотров 50 тыс.
50% 1

Опубликовано:

 

26 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 56   
@DeepakKumar-gt6tg
@DeepakKumar-gt6tg 7 месяцев назад
very informative and helped in creating S curve. Thanks for in depth explanation!
@leumntv9741
@leumntv9741 Год назад
Wow! So love this channel. Thank you very much for sharing this tutorial
@ExcelInsights
@ExcelInsights Год назад
Glad you liked it!
@christang9406
@christang9406 8 месяцев назад
Thanks sir, i managed to create the curve as instructed. I forgot to make the work baseline in the beginning. and the tick options.. Thank you!
@ba177ba18
@ba177ba18 5 месяцев назад
Clear and straight to the point. Thank you. Liked and subbed
@dcpowered
@dcpowered Год назад
This is perfect! Just what i was looking for! Great explanations!
@ExcelInsights
@ExcelInsights Год назад
Great!
@parthachakraborty48
@parthachakraborty48 5 месяцев назад
Wonderful explanation
@shaikaarifilahi8423
@shaikaarifilahi8423 Год назад
thanks for the information, but while I am generating the s curve report (baseline cumulative work VS Cumulative actual work), I am getting values 0 in the pivot table. unable to generate the s curve. would you pls help me with that?
@jongski18
@jongski18 Год назад
You should do resource loading to your schedule to be able to generate values.
@nisarkhan2619
@nisarkhan2619 Год назад
same problem i am facing and don’t know how to do resource loading in existing project file
@OrleansMakuza
@OrleansMakuza Год назад
Great Tutorial - Thanks!
@ExcelInsights
@ExcelInsights Год назад
Glad it was helpful!
@imamhandoyo3930
@imamhandoyo3930 4 месяца назад
Thank you ...helpful a lot
@shyam1027
@shyam1027 Год назад
This is truly outstanding and precise explanation! . Is it possible to assess or forecast the future rate of work by S-curve?
@ExcelInsights
@ExcelInsights Год назад
Excel can do this by means of regression analysis. However, it requires that your dates are evenly separated.
@warrenjames5658
@warrenjames5658 Год назад
Hi Excel Insights. Thank you for the awesome video. Can you kindly compile a video on EVM analysis. Computing EV, PV and AC. Thank you
@ExcelInsights
@ExcelInsights Год назад
Hi, There is a templated report in MS Project that already does this.
@MuhammadZubair-jl4nn
@MuhammadZubair-jl4nn Год назад
Sir, Thanks for guidance. please prepare one more video to guide us that how we can create "critical task report" in progress tab.
@filipefigueiredo85
@filipefigueiredo85 Год назад
That's a great tutorial. Is possible to build the same chart but considering only Material Resource type?
@ruigamito
@ruigamito Год назад
Hi! Many thanks for the video. Is it posible to do this curve for a daily calendar?
@ExcelInsights
@ExcelInsights Год назад
Yes, you just need to continue collapsing the Excel data to daily. However, daily curves tend to be not as smooth looking as weekly curves.
@syafeeqahsofi5326
@syafeeqahsofi5326 3 месяца назад
Hi sir, from available fields from visual reports, i dont have baseline cumulative work and cumulative work to add to selected fields.. what to do sir..?
@ammadkhan5380
@ammadkhan5380 8 месяцев назад
I'm having 0 for all fields (actual work, cumulative work) in graph report, I have set baseline. Need help
@omarmneimneh-bj3vs
@omarmneimneh-bj3vs 22 дня назад
I have same , please advise
@giacomov83
@giacomov83 Год назад
Thanks a lot. Could you please clarify how to show different bars for baseline and actual/planned?
@ExcelInsights
@ExcelInsights Год назад
Hi, do you mean you want to show the chart as a bar/column chart instead of a line chart? Because if yes, then that is not an S-Curve anymore. Did I understand your question correctly?
@giacomov83
@giacomov83 Год назад
@@ExcelInsights sorry..I was meaning the view in tracking Gantt with bar charts of planned Vs baseline..that is how normally tracking Gantt displays the Gantt chart! Solved!
@muhammadzulhilmanmazlan9450
@muhammadzulhilmanmazlan9450 Месяц назад
why the value is zero for both baseline and actual? is it because I didn't enter the resources? please help
@ExcelInsights
@ExcelInsights Месяц назад
Try declaring as Baseline1. Then, use Baseline1 Cumulative in the report
@narscalixto9029
@narscalixto9029 11 месяцев назад
Hello, do you have the same for Primavera P6?
@nurdiyana2945
@nurdiyana2945 3 месяца назад
do i need to complete all the actual start and finish date to generate the report? because i have set the baseline but the date are not complete yet as the project is ongoing, when i generate the report all the cummulative value in excel is 0
@ExcelInsights
@ExcelInsights 3 месяца назад
Hi, here's a video if the project is still ongoing: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4XjJ8lbAw14.htmlsi=lfH7AV4-EVHUFWfR
@danishaiman5952
@danishaiman5952 Год назад
hi,urgent may i ask why my baseline cumulative is all 0 ? but mu actual cumulative has the value
@ExcelInsights
@ExcelInsights Год назад
Did u declare baseline?
@lynnettekm1661
@lynnettekm1661 Год назад
@@ExcelInsights I am having the same issue...My values are all 0...The Chart is completely empty with no histogram
@pepenator79
@pepenator79 Год назад
Same thing happens in my case@@lynnettekm1661
@hargovindbhatt8284
@hargovindbhatt8284 Год назад
@Excellnsights i have same issue to show all 0 in the data set and no histogram has shown..
@adedigbaafeezadedayo2324
@adedigbaafeezadedayo2324 10 месяцев назад
I'm having similar problem. .it keeps bringing 0
@amirulh166
@amirulh166 11 месяцев назад
What represent number for baseline and actual cumulative work? what does the work number mean?
@ExcelInsights
@ExcelInsights 11 месяцев назад
This is auto calculated based on the dates (both the initial and actual) you enter in the Gantt chart.
@oootoob
@oootoob Год назад
This can be done directly in Project using reports. But how can you show work completed as a percentage rather than hours?
@pmodepartment
@pmodepartment 9 месяцев назад
Sir, how can it change the value from work hours to percentage value based on % complete column in gantt chart ?
@ExcelInsights
@ExcelInsights 9 месяцев назад
During the export part, look for the % column you are looking for
@chanont6042
@chanont6042 Год назад
Thx sir good job
@ExcelInsights
@ExcelInsights Год назад
Thank you!
@abimazran7351
@abimazran7351 9 месяцев назад
how to show weightage in MIP??
@muhammadamirin5088
@muhammadamirin5088 4 месяца назад
Why my filter dont have monthly to drag like vdeo
@kornvisanuthongrat5656
@kornvisanuthongrat5656 Год назад
Thank you for shared the good thing!! But i have some issue, In visual report field picker, it doesn't show Baseline Cumulative Work and also no Cumulative Actual Work. Please feedback me how to make it appear. hope you can help __/\__ (I'm use MSP version 2010 )
@ExcelInsights
@ExcelInsights Год назад
This was a problem with Project 2010 (and actually other programs too had many problems during the launch of 2010 versions that Microsoft released what we call "Service Pack 1" that fixed many issues in the 2010 versions.) I cannot find the link to it anymore. Maybe you can be lucky and find the "Service Pack 1" update or get the more recent versions of MS Project.
@kornvisanuthongrat5656
@kornvisanuthongrat5656 Год назад
@@ExcelInsights Thank you for your reply sir, I will try to get the update version. ^^
@redstoneengineeringandcons3301
Hi Excel Insights, how to extract the manpower histogram? Kindly share the link kung may video na kayo regarding dito. Salamat
@ExcelInsights
@ExcelInsights Год назад
Do you mean histogram per week Yung buckets?
@junegalsim
@junegalsim 4 месяца назад
Pagawa sana ako ng scurve
@DfFg-qh5ub
@DfFg-qh5ub 7 месяцев назад
Weekly calender is field