Are you able to add earned value to this dashboard?
@ProjectManagementMastery4 күн бұрын
Not sure I understand your request...
@peterjames80464 күн бұрын
@@ProjectManagementMastery EV, CPI, SPI and so on. EV=Earned Value - CPI=Cost Performance Index - SPI=Schedule Performance Index -Does that help
@ProjectManagementMastery4 күн бұрын
Yes got that but I struggle to see why you would want this in a task list. This s more suited to a moving Schedule like this: kzbin.info/www/bejne/iIbGfqqqrauHmqM
@peterjames80464 күн бұрын
@@ProjectManagementMastery That is very good, What i was looking for thinking of is with a Task list, %complete and Cost - Can you get EV from the dashboard above most of what i get as a WBS these days is in Excel. I would like if possible to get earned value from the Dashboard above or you may have another one that could or would be mor suitable. - PS, I did like your EV video
@ProjectManagementMastery3 күн бұрын
Yes I think that would be the ultimate to have EV, something to think about. I simplify those task lists usually so by using the % completion you have implied the Earned Value but you would problably need to keep track of time spent for the picture to be complete...
@muslim_success7 күн бұрын
If multiple people wok on a same task then how to add that into the recourse column? Thanks
@ProjectManagementMastery7 күн бұрын
Thanks for he comment! You either duplicate the task, or you add more Resource columns. As we speak Excel does not allow "3D" input.
@muslim_success7 күн бұрын
@@ProjectManagementMastery got it. Is it not possible to add more people's names in the resource column with a comma? I.e: Zack, Noah? Thanks a lot
@ProjectManagementMastery7 күн бұрын
This is actually a good idea... You would need to remove the Data Validation on those cells. Also the Resource Charts might get a bit messed up. Unless you create a Resource called "Zach and Noah" and keep the Validation. they will show on the chart... But you made me think about other options for multi resources, so thanks for that :-)
@OilfieldSchool7 күн бұрын
Keep going on this knowledge, we need more so we motivate this content
@ProjectManagementMastery7 күн бұрын
Thank you, I will
@irshadmurad8 күн бұрын
Learning a lot from your videos
@ProjectManagementMastery8 күн бұрын
Thank you that's the idea :-)
@lpaone0116 күн бұрын
Thank you very much. I purchased a PM template, and it is so professional. Saved me hours of work and watching your video helped me understand the functionality.
@ProjectManagementMastery16 күн бұрын
Thanks for the feedback, good to know the video helps!
@nomads636821 күн бұрын
Ok got it but what is the use of it as MS project and P6 can do it in a second 😮
@ProjectManagementMastery21 күн бұрын
$125 / month that is the use
@kieranbyrne85677927 күн бұрын
Thank you very Good
@ProjectManagementMastery27 күн бұрын
Welcome 😊
@dolene_wright28 күн бұрын
Hi! I am struggling with my Xlookup formula. I do have it available but the result keep on saying #VALUE after i input formula.
@ProjectManagementMastery28 күн бұрын
Hello! It's hard for me to assess without seeing your formula. If you Google #value for Xlookup it might give you tips on why it fails...
@lisay5302Ай бұрын
This is great!
@ProjectManagementMasteryАй бұрын
Thanks for the feedback!
@selambelachew5602Ай бұрын
followed the tutorial, done it and I like it. Thanks
@ProjectManagementMasteryАй бұрын
Great job! I'm glad you made sense of my rambling!
@curtisj.7040Ай бұрын
Ben, how do I add or create a chart for the total completed tasks by Resources throughout the year?
@ProjectManagementMasteryАй бұрын
Hi there, sorry dont really get what you want to do...
@diananagy4808Ай бұрын
thank you for this detailed tutorial. it's a useful learning resource. a quick question: I've been trying to play around with formulas to customize this to my needs, but i'm stuck and i was wondering if you would consider sharing a solution. What i would like to do is have the MONTH as an additional variable. I'm interested in seeing the TO DO's and IN PROGRESS only, but for current month & next month. Or maybe you already have another tutorial including this time dimension? thanks in advance for your help.
@ProjectManagementMasteryАй бұрын
@diananagy4808 This is actually a great idea to reduce clutter on the Board. You Just need to add another column (say X) in the Data Entry that you would set to "Y" if the month of the date is in the current or next month. and then you can just change the Kanban Search criteria to add this as another condition to show the task on the Board like this (AND (D5="Y",X5= "Y") ... Should work!
@nickvandernetАй бұрын
Brilliant, thank you. That was very good.
@ProjectManagementMasteryАй бұрын
Thank for the feedback!
@divya1115Ай бұрын
I am trying to ge the work left populated as guided by you, bit its not just happening, not sure where Am I going wrong 😢
@ProjectManagementMasteryАй бұрын
Hi - It's hard to assess without seeing hat you're doing but the work left is (total work) less (total work * Completion %) =H12-(H12*J12)...
@batsaikhanbatmunkh6547Ай бұрын
thank you for the wonderful tutorial. Finish day calculation formula was not correct in my guess. Because if WORKDAY(J6-1,C6)-1 is sunday then it is become weekend. How about =IF(Weekend_work="No",WORKDAY(J6-1,C6),J6+C6).
@ProjectManagementMasteryАй бұрын
Cheers! Yes that rings a bell, I think there is another comment on this. THhe latest version has =IF(Weekend_work="N",WORKDAY(J6,C6)-1,J6+C6-1) and the note in the instructions. "Please note that when a task completes a Friday night - and there is no weekend work, the system puts the completion date on a Sunday night. This is to allow the Gantt chart to calculate properly the After Date - as in fact it positions itself the day before the next working day."
@jayprox4887Ай бұрын
Hi, I follow as per your video and have error (#name?). =IFS(J11=1,"Completed",ISBLANK(F11),"",I11<$D$16,"Late",J11=0,"Not Started",J11>0,"In progress") Please help😃
@ProjectManagementMasteryАй бұрын
@jayprox4887 Hi! Well that's odd, I just copied that in a blank excel and it works... Are you sure you have a recent version of Excel that can use IFS...???
@jayprox4887Ай бұрын
@@ProjectManagementMastery oh i see..i used excel 2010....thanks for the reply
@ProjectManagementMasteryАй бұрын
You can still do it with embedded several IF though...
@ProjectManagementMasteryАй бұрын
@jayprox4887 This is what Gemini gave me =IF(J11=1,"Completed",IF(ISBLANK(F11),"",IF(I11<$D$16,"Late",IF(J11=0,"Not Started","In progress"))))
@jayprox4887Ай бұрын
@@ProjectManagementMastery Thank you so much Sir
@Vishwesh2680Ай бұрын
Thank you sir, very good insight. I am wondering how did you get Late value. I have added the formula, however it seems Late is not coming up
@ProjectManagementMasteryАй бұрын
Hi - Late is calculated based on the task deadline and today's date. Check today's date is correct.
@arndtbergmeister7375Ай бұрын
Great video, like it very much. One thing for the high prio pie chart. I would prefer to combine time spent and work left (eq 100%) instead of a combination of total work and time spent, whichs ends up with more than 100%.
@ProjectManagementMasteryАй бұрын
@arndtbergmeister7375 Thanks for the tip and for the way you brought it, wish everyone was like you on the web! You are right, the Time spent vs Total work can be improved, I'm thinking more with % Completion then for a quick visual...
@joanbrodbeck3919Ай бұрын
Thank you Ben and yes I stuck it out till then end and built a resource file from you instructions. Very easily understood tutorial
@ProjectManagementMasteryАй бұрын
@joanbrodbeck3919 Wow thanks for the feedback and very well done!
@hanzelmalasaga31222 ай бұрын
I did not get the work required and the work left huhu
@ProjectManagementMastery2 ай бұрын
Not sure what you mean...
@ShubhamYadav-nk7rh2 ай бұрын
Sir, Thank you once again for this video. A few days back, I followed your video to create an HR Dashboard. That helped a lot. Now, taking the help from this video, I created a Resource Utility/Optimisation Tracker. The concept of Start and End buttons is a great idea, has helped me a lot to create a day-wise project/task tracker sheet for each individual candidate. Thanks again Sir. Best wishes . Namaste 🙏
@ProjectManagementMastery2 ай бұрын
@ShubhamYadav-nk7rh Thanks for the feedback and well done for applying it!
@JohnOji-o8z2 ай бұрын
Nice Stuff !
@ProjectManagementMastery2 ай бұрын
Thanks for the visit
@kwezizabo62402 ай бұрын
This is really cool.. Please do send
@ProjectManagementMastery2 ай бұрын
Thanks for the comment. Check your email!
@ShubhamYadav-nk7rh2 ай бұрын
Sir, thank you so much for this tutorial. I followed the video step by step and could make a decent dashboard. Really grateful for this.
@ProjectManagementMastery2 ай бұрын
@ShubhamYadav-nk7rh Thanks, It is very rewarding for me to hear feedback like yours!
@crazystats84012 ай бұрын
Great product 👍👍
@ProjectManagementMastery2 ай бұрын
Thanks, I love it too but I'm biased!
@garethcardus52443 ай бұрын
Can you link this dashboard or one of the other task activity ones to the project dashboard and then subsequently the program dashboard
@ProjectManagementMastery3 ай бұрын
That would be nice, but this would give us one of those 2 challenges: either too many tabs or external links which are often / always causing problems. Unless we have the project dashboard and the task list on one tab? In any case food for thoughts, (and while we're at it integrating the risk and issue lists!)
@garethcardus52443 ай бұрын
Thanks Ben, all your videos have been so useful
@ProjectManagementMastery3 ай бұрын
Glad you like them!
@susiwest3 ай бұрын
Thanks Ben. So helpful :)
@ProjectManagementMastery3 ай бұрын
Thanks for the feedback :-)
@DRSmicks3 ай бұрын
The look of the colored tab is great, but the true power of a task list would be the ability to drag and drop the task from stage to stage and this appears to instead need users to both enter new tasks and change the status on the 'Step 1' white tab instead of where you'd want to stay viewing.
@ProjectManagementMastery3 ай бұрын
Excel allows you to do things you would normally need to have a software to develop. Of course it is not perfect, specially when you do not want to have macros or VBA, but the things you can do "for free" are amazing, I find new uses everyday.
@Yun695413 ай бұрын
Hello, I want to buy this template
@ProjectManagementMastery3 ай бұрын
@Yun69541 Hi. I do not have it in my shop yet but I can give you what i have if you contact me here and mention you want the template 996-22 < link removed >
@moniquelevendal47043 ай бұрын
Thank you very informative , just a question i do i minimise the gap between the series 4 point data lables?
@ProjectManagementMastery3 ай бұрын
@moniquelevendal4704 Thank you! If you right click on the series and select Format Data series, it will give you the option to change the Gap Width...
@KhalidAl-Hadrami-vp3qq3 ай бұрын
can I get the Excel template ?
@ProjectManagementMastery3 ай бұрын
Not sure what you mean, this is MS project!
@irshadmurad4 ай бұрын
Very nice
@ProjectManagementMastery4 ай бұрын
Thank you sir!
@rashmiambale4284 ай бұрын
Hi Ben, I have a corporate udemy and i am unable to find your course.
@ProjectManagementMastery4 ай бұрын
@rashmiambale428 Hi there, I am not part of the corporate accounts, my course is only to be purchased.
@crazystats84014 ай бұрын
Oh my.... INSANE!!
@ivankulola58474 ай бұрын
I found this insight particularly valuable, especially the aspect of considering the interviewer's perspective. This is something we often do subconsciously after years of being interviewed but don't explicitly think about. This has reminded me of the importance of tailoring my preparation based on who I believe the interviewer will be. Knowing the interview stage, whether it's an HR screening, a technical interview with my future line manager, or a meeting with the head of programs or country director, usually helps prepare more effectively. Good Stuff!
@ProjectManagementMastery4 ай бұрын
Sometimes they don't even tell you who is interviewing so it's good practice to ask them at the beginning of the IV!
@miniab43484 ай бұрын
This is so great. thanks for sharing this.
@ProjectManagementMastery4 ай бұрын
Thanks for the feedback!
@pablojuancortez4 ай бұрын
Looking for something like this for our R&D team, thanks for sharing!
@ProjectManagementMastery4 ай бұрын
Any time!
@A.Moh61484 ай бұрын
Many Thanks for you❤
@ProjectManagementMastery4 ай бұрын
@f.ssaleh5073 A pleasure thank you!
@Sh3ll8344 ай бұрын
I'm loving this!!! Is it possible to group the colours together?
@ProjectManagementMastery4 ай бұрын
@Sh3ll834 Thanks! If you are talking about the boards color yes you can as they are hardcoded. To group the other colors you just need to change them in the Cond formatting.
@agapenilo43754 ай бұрын
This is a great tutorial, however, i got lost when you started the Calculation sheet, and entered the calculations, (timestamp 29:59 - 30:04, i tried understanding it but i was unable to, may you please help with that?😢😢
@ProjectManagementMastery4 ай бұрын
@agapenilo4375 You ask so nicely it's hard to say no. I think you are referring to this formula? "=COUNTIFS(Task_name,"<>""",Completion,"=0")" In this I check 2 things, first that there is no blank (<>"") in the task column, meaning we have a task in there, and there is another condition is that the task has not started, which translates into Completion% = 0%
@agapenilo43754 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@agapenilo43754 ай бұрын
@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔
@ProjectManagementMastery4 ай бұрын
@agapenilo4375 I know it can be frustrating when we see a problem like this. If you want to email me what you have here, or if you get in touch I can send you a sample
@daivenotoole83004 ай бұрын
Thank you Sir...Very helpful
@ProjectManagementMastery4 ай бұрын
Thanks for your comment!
@daivenotoole83004 ай бұрын
Insightful for presentation.🙏
@ProjectManagementMastery4 ай бұрын
@daivenotoole8300 Yes it does not look lie Excel too much
@jubilantakku69934 ай бұрын
Great Content
@ProjectManagementMastery4 ай бұрын
Thank you!
@ProjectManagementMastery4 ай бұрын
Thank you!
@divad1214ify4 ай бұрын
I'm curious what this would look like if you wanted to include multiple projects on the same tab with core tasks tracked below each project. I'm always on the lookout for a dashboard that allows for a higher level of project tracking that still allows me to capture some key tasks under each project. Love this tutorial!
@ProjectManagementMastery4 ай бұрын
@divad1214ify You must be a medium of some sorts, I have a Program Dashboard coming up next week that works on a high level picking up data from a Project Dashboards like this one; kzbin.info/www/bejne/jYipqIN9prNopqs
@divad1214ify4 ай бұрын
@@ProjectManagementMastery Love it! Keep me posted when its up! Great work
@anafrican8074 ай бұрын
I am the biggest fan and beneficiary of your teachings... Is it possible to show us how you built the report from scratch. It is always helpful and more informative if you do these dashboards from a blank page
@ProjectManagementMastery4 ай бұрын
I hear you, I have so many template ideas in my head that I sometimes take a shortcut and don't start my demo from scratch as it takes more time. But I will keep that in mind thanks for the feedback!
@crazystats84014 ай бұрын
Looks great. Not in your shop yet??
@ProjectManagementMastery4 ай бұрын
No didn't get around to it yet. And I'm trying to motivate you to build it yourself!.. But it will be there soon.
@Varunrthd4 ай бұрын
Yes please!
@ProjectManagementMastery4 ай бұрын
@Varunrthd Hi. The template is not very well polished but if you use this link and ask for template 35, I can give you what I have. tinyurl.com/5az8kntd
@dhmacher5 ай бұрын
"Aww, that's not a gantt chart, that's just a... whooah, that's pretty clever!" Very nice, thanks!
@ProjectManagementMastery5 ай бұрын
Glad you liked it!
@harshalshelar5 ай бұрын
i dont get in your project sheet under weeks for a particular who is under multiple projects his requirement for every project we have to change everytime ? , in your video you have assumed some percentage for once initially
@ProjectManagementMastery5 ай бұрын
I don't think I understand your question but you can allocate a different availability over time for a specific resource.
@harshalshelar5 ай бұрын
Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome
@ProjectManagementMastery5 ай бұрын
You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.
@harshalshelar5 ай бұрын
@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?
@ProjectManagementMastery5 ай бұрын
In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.