Just to help David, at 8:20, use the formula of =D12-($D$12/COUNT($E$5:$N$5)). You can drag this across, and even beyond what you have, and if you add additional days in Row 5, or change the ideal trend in D12, the formula will adjust the time used automatically. cheers!
Apologies a silly question perhaps. At 5:56. Day 2 Aug 11. If one assumes 1 Day effort equates to 8 hours for 1 person ? Does this mean on that day 7 people are required to meet the tasks recorded? 1+2+1+1+1 ? ?
Hi David, just Hank you for the video and I have a doubt about how to take the efforts estimation I did using Poker Estimation to Burn-down Chart? I am totally confused because most of the numbers you provided here is one right.
That's a great point to bring up Mrudang. When sprint planning, it's usually preferred to break cards down into smaller bits where possible. But if it's not possible, I reckon we could increase the sprint size in this sheet. Just add the columns you want, and make sure to divide the "Ideal trend" cells by the new number of days (i.e. 14 instead of 10), and multiplying them by 1 through 14 instead of 1 through 10 (i.e. /14*1 to /14*14)
Thanks for this interesting video, I have a question the numbers in the day1 column for example (1 corresponds to a working day?). When we have a number 2, does it mean that we need 2 men working during a day1?
Hey Ismail, you are right! The days correspond to working days, and usually there are 10 working days (2 weeks) in a sprint. For the estimates, these are usually estimates on effort required. They can be different per team (whatever the team decides) and could be relative/broad sizings using the Fibonacci sequence (most common, i.e. 1, 2, 3, 5, 8, 13), or based on hours, or people, or anything else you choose.
Dear David thank you so much for your great explanation. Under feature 2, you put three days but you didnt actucally spread three days in this row, you spread only two. You typed the third day but it didnt go through. could you please tell me in other worsd what does it mean minus 2 or any number? Kind regards Guilda.
Hello David! I have a question regarding the Backlog ID and User Stories. What actually goes there? I’m trying to do a burn down for a new system transition and have 100 associates
Oh that is an excellent question 🙂 let me know if I haven't understood correctly, but the ID can be anything you choose - a unique identifier like 001, 002 etc. The user stories are the small chunks of work, that together will make up a feature you want to release. In your case, it might be the individual tasks that make up the overall system transition. If 100 associates is too much for one matrix/chart, you could bundle some together, by team or area, for example.
David thanks for sharing, I purchased the 52 Templates and the Knowledge Worker's Toolbox, this is great stuff. Nice to have one accurate source for this information. This will help me with my PMP Preparation, exam scheduled on 04/20. Do offer one-on-one training in these areas ? Thanks again for sharing! Cecil
Thank you! Good luck for your exam 🙂 (I'm sure you've already seen the 200 Agile questions, but that seems to help people pass) I don't do 1:1 currently but am working on new content all the time 🙂
Great, looking forward to reviewing future material. Yes, I've seen the 200 Agile Qs in 2021, I watched some of your videos on Agile Qs for the PMI-ACP Exam! Very helpful in breaking down the questions, your explanations helped reduce my learning curve. thanks again! Cecil
We could, either by adding the forward and backward pass details manually in each cell, or automatically with a formula. The challenge is that our schedule may not follow activities 1, 2, 3 etc - a path may go 1,4,5 for example. My video on critical path calculations is here ua-cam.com/video/Nui3YvFV64o/v-deo.html
belum pernah nemuin content creator yg mbikin time stamp huhuhu terharuuu thank youuu
Thank you, David! You made it look so easy and interesting.
Even I had enjoyed a lot your instructions are very informative I love it buddy keep up the good work My dear Friend
Just to help David, at 8:20, use the formula of =D12-($D$12/COUNT($E$5:$N$5)). You can drag this across, and even beyond what you have, and if you add additional days in Row 5, or change the ideal trend in D12, the formula will adjust the time used automatically. cheers!
Very nice, thank you! 🙂
@@davidmclachlanproject Welcome David, and thank you for the tutorial. The chart was very helpful for my project. :)
🙏 Thank you
Your video's helped me pass my PMP, Thank you so much
Amazingly detailed tutorial,helped me alot.
Cool! But as long as you've reached the deadline at the agreed time, is this chart really even needed? Just wondering
this is very helpful
why did you divide ideal trend with 1,2,3 and so on. Would it be same for any chart having different number of estimated days?
Apologies a silly question perhaps. At 5:56. Day 2 Aug 11. If one assumes 1 Day effort equates to 8 hours for 1 person ? Does this mean on that day 7 people are required to meet the tasks recorded? 1+2+1+1+1 ? ?
but what if we wanted to update the graph day by day, not at once at the end? how can we do that?
This is for first time I have heard & seen burn down, amazingly explained and learnt it.
You mentioned all the way down to 0 but could not see what was behind your head. Other than that very nice information.
Hi David, just Hank you for the video and I have a doubt about how to take the efforts estimation I did using Poker Estimation to Burn-down Chart? I am totally confused because most of the numbers you provided here is one right.
Hey, When I'm trying to do that keeping the same data, I am getting different data for remaining effort🙄
You saved my day. Amazing explanation.
Thank you so much! That was so helpful to me! God bless you!
Did not get it for my sprints which have 14 days of one of the tasks.
That's a great point to bring up Mrudang. When sprint planning, it's usually preferred to break cards down into smaller bits where possible. But if it's not possible, I reckon we could increase the sprint size in this sheet. Just add the columns you want, and make sure to divide the "Ideal trend" cells by the new number of days (i.e. 14 instead of 10), and multiplying them by 1 through 14 instead of 1 through 10 (i.e. /14*1 to /14*14)
David M. is just the best. I feel like I can tackle anything listening to his encouraging voice. :)
Brilliant David - Just Crisp and Clear :) Please keep doing more videos
Perfect in explanation & details combine with your positive energy!
Thanks for this interesting video, I have a question the numbers in the day1 column for example (1 corresponds to a working day?). When we have a number 2, does it mean that we need 2 men working during a day1?
Hey Ismail, you are right! The days correspond to working days, and usually there are 10 working days (2 weeks) in a sprint. For the estimates, these are usually estimates on effort required. They can be different per team (whatever the team decides) and could be relative/broad sizings using the Fibonacci sequence (most common, i.e. 1, 2, 3, 5, 8, 13), or based on hours, or people, or anything else you choose.
The superb way you have explained, thank you!
Really nice job, exactly what I needed!
Dear David thank you so much for your great explanation.
Under feature 2, you put three days but you didnt actucally spread three days in this row, you spread only two. You typed the third day but it didnt go through.
could you please tell me in other worsd what does it mean minus 2 or any number?
Kind regards
Guilda.
Yes certainly 🙂 the minus numbers will add extra effort (above the estimate). You could also change the estimate and use normal numbers, though 🙂
Thank you David, for the detailed explanation.
Excellent presentation with perfect pace and content. Thank you!
Amazing, unreal, thx so much David. Best wishes on everything you do.
You are a Savior !!! Thank you - very informative and very helpful !
Hello David! I have a question regarding the Backlog ID and User Stories. What actually goes there? I’m trying to do a burn down for a new system transition and have 100 associates
Oh that is an excellent question 🙂 let me know if I haven't understood correctly, but the ID can be anything you choose - a unique identifier like 001, 002 etc. The user stories are the small chunks of work, that together will make up a feature you want to release. In your case, it might be the individual tasks that make up the overall system transition. If 100 associates is too much for one matrix/chart, you could bundle some together, by team or area, for example.
Yes, he is a great mentor.
David thanks for sharing, I purchased the 52 Templates and the Knowledge Worker's Toolbox, this is great stuff. Nice to have one accurate source for this information. This will help me with my PMP Preparation, exam scheduled on 04/20.
Do offer one-on-one training in these areas ?
Thanks again for sharing!
Cecil
Thank you! Good luck for your exam 🙂 (I'm sure you've already seen the 200 Agile questions, but that seems to help people pass) I don't do 1:1 currently but am working on new content all the time 🙂
Great, looking forward to reviewing future material. Yes, I've seen the 200 Agile Qs in 2021, I watched some of your videos on Agile Qs for the PMI-ACP Exam! Very helpful in breaking down the questions, your explanations helped reduce my learning curve.
thanks again!
Cecil
Just amazing 👏 sir
Simple , neat and effective !! Thank You So much !!
Hi, thank you so much for this tutorial. For the ideal trend I used this formula : =D12-($D$12*10/100) at E12 and then dragged this to N12
Nice one Audrey! 👍🙂
Very good
Could you explain the formula pls.. I didn't know how the equation works
Thanks
Very helpful
👏👏
Great video, Can we add actual performance, please tell
We could, either by adding the forward and backward pass details manually in each cell, or automatically with a formula. The challenge is that our schedule may not follow activities 1, 2, 3 etc - a path may go 1,4,5 for example. My video on critical path calculations is here ua-cam.com/video/Nui3YvFV64o/v-deo.html
@@davidmclachlanproject Thank you very much. It is great help
I wish if you could add the template in the download section.
Amazing. Thank you so much.
thank you...very well explained. Helped me alot.
nice job, thanks
thanks for the explanation
thanks
David, thanks a lot 🙌
Thank you
thank you for the lesson!
excellent tutorial
Awesome work
Not to be a stickler but Feature 2's level of effort is not complete.