Calculate work load based on Spent time rather than estimated time

[shuozhifenxi]

Hi,

Could you add a choice to calculate work load based on spent time rather than estimated time please?

Thank you.

[JostBaron]

Hi!

What is the use case for this? Do you want to know the workload your team had in the past, displayed in the same tabular manner?

If there is a good use case for this, I'll implement it.

Regards,
Jost

[CodeInsider]

Well, the usecase for this could be, to see how many load is on each user. For example, a user had added 4 hours for this day, but this time has been assigned to some issues he wasn't responsible but he have to spent some time for a quick test or something like that. Someone else try to give this user another ticket with 5 hours. The limit per day is 8 hours. In this case the user would have 5 hours as estimated hours, but 9 hours (estimated + spent hours) for example, which would be over the limit of 8 hours.

[JostBaron]

Would it be an acceptable solution to define that the workload for a day is the sum of the booked time and the estimated time for that day? That won't be very hard to implement, but it could yield quite a big performance penalty...

[CodeInsider]

Well this would be good.

Hm, maybe you can try it. I can take a look over it if you want. Maybe I could find some way to improve it afterwards?

[jcasamada]

Hi,

I also think It would be useful to calculate the future workload considering the estimated time less the spent time on the assigned issues (and delivery dates obviously). In the current version as I understood is calculated on the %done of the assigned issues, estimated time and delivery date...but the real world is that engineers report the spent time but not the %done (which is actually very difficult to decide). Is there anything I'm missing?

Thx!

[pcocheril]

Hi,

I agree with jcasamada. I also would prefer the workload to be calculated considering the time spent and not the %done.
Is there any chance this could be implemented ?

Thanks in advance !

[LGrione]

Hi,
Further to the above discussion, we also prefer to have the workload calculated considering spent_time instead% done.
We had a look at the code list_user.rb in \plugins\redmine_workload\lib, and we identified the computation at line 12:
return issue.estimated_hours*((100.0 - issue.done_ratio)/100.0)

How can be addressed the data 'hours' in 'time_entries' table?
We believe that issue can be fixed with this modification.