Estimate to Complete

Have you ever come across a situation, where even in Agile-Scrum, project you want to understand,

1. What got accomplished, and what is yet to be accomplished (the size)?
2. What would it take to complete it, everything else remaining constant (Effort / Schedule)?
3. Can there be some tentative estimation about work, if we include some approximation to elaboration, technical debt and defects?

I get that in Agile-Scrum, it is the capacity and velocity that drives the work, schedule and cost; however, if we leave aside what Agile Literature details say or do not say about it, I believe internally even all of us will be interested in knowing these questions. As these are not governance, or management questions, rather these are “Self-Awareness” questions, to keep ourselves honest about our true progress.

To help myself, I created a simple tool to answer these questions, and few more. I call it as “Self-Awareness about Estimate to Complete”. If you are interested in it, please feel free to download the Excel and PDF files. The PDF details the working of this tool. The best part is it does not require any registration, and it does not transmit any of your data. Your data remains with you.

What is in it for me? Well, all I want is your feedback on accuracy of the tool. That is, if it were accurate enough for you? If you feel like, then share the deviation (not the data, only the % deviation number) between estimated and actual number; though even this is not binding.

Please feel free to reach out to me, should you come across any hurdle in using this tool. Enjoy.

Link to the tool - Excel Tool
Link to Guide - How to use it guide