Estimated Hour

[w0www]

Some times its necessary known the load for next week to do a plan. The issues of next week only have estimated hours.

Can be interesting generate a report with time estimated vs time dedicated.

[dhanasingh]

how do we know the issues for next week ? by start date ? or by due date ? or by both ?
So you want 2 reports ?

• plan for next week
• actual vs estimated hours

[w0www]

I think by start date. "Due data" only fill when the issue has done.

Yes 2 reports.

• Plan for next week/month. Considering start date and estimated hours we can know if one user has free hours (considering a 8h/day spain workday, but this could be set in a variable.)
• Result for last week/month. Considering start date and time dedicated vs start date and time estimated. We can know if a user have had a free hours or a lot of work and is necessary other person.

One example: We have 3 issues done the last month. One issue estimated in 100h, other issue estimated 25 hours and other estimated in 25hours. (150hours)

The 150 hours are assigned to a one user.

If i want see plan for next month i have to see that one user work 20 days * 8 hours, in total 160hours. I can see that the user need 10 hours more of workload to complete the month.

If i want see plan for last month:

i see, for example, that the user has needed 160 hours to end 150 estimated hours. I have a problem to estimate the work.

Or i see, for example, that the user has needed 140 hours to end 150 estimated hours. The user is more efficient and for this the bussiness won 10 hours more. And the user had 10 free hours that could have been exploited.

Or i see for example that the user has needed 100 hours to end 150 estimated hours. As the first example i have a problem to estimate the work althout in this case the bussines not lost money.

[dhanasingh]

I have put some excel models, please see the attachment and see if this is what you are looking for