The Range Estimate add-on allows to set an estimate range for every issue - you can put Optimistic and Pessimistic estimate values. Actually, the add-on interprets the Original Estimate as the Optimistic value, so there is no need to duplicate the values when you start using the add-on with existing issues. For every issue, you can see how the logged time compares with the estimate range
The Range Estimate add-on also provides a set of JQL functions to help you with statistics and reporting
To start using the add-on you don't have to do much. Just
The Range Estimate add-on provides a set of useful JQL functions which you can use to
You can benefit from creating a set of gadgets on your dashboards to track the time spent vs estimates. You can also subscribe to a filter to get an email every time the time spent on the issue is about to go over the Pessimistic Estimate. Lets see some examples
This set of gadgets on the dashboard below splits all the issues in the project by groups. On the left you can see how the Range Estimate JQL functions are used to configure these gadgets
Another example of effective usage of the JQL functions is filter subscriptions. Create a filter like this
statusCategory != Done and issue in spentInEstimationRange()
and subscribe to it.
You will get emails with the list of issues which are not yet completed, but the logged time is already between the Optimistic and Pessimistic estimate. This is the flag to pay close attention to these issues before it is too late - the time spent on these could get out of control pretty soon.