Available total hours in work load bar.
Scenario:
The Iteration dates are 18th May 2012 to 15th June 2012.
One user is allocated to the project with no date restriction for 25%.
The user work for 8 hours and ends his day @ 5:00 PM
The current time is 18th May 2012 3:30PM when I load the plan it says 38.5 hours available. Not able to understand how this was calculated.
There are 19 days left in the Iteration if we exclude the last day and week ends.
Which means 19 * (8 * 0.25) =38 hours.
If we include last day as well then there will 20 days left in the Iteration
Which means 20 * (8 * 0.25) = 40 hours.
As of now (18th May 3:30 PM) 6.5 hours for the day is done which means
40 - 6.5 =33.5 hours.
It should have been 33.5 hours or 38 hours.
How come it is 38.5 hours?
The Iteration dates are 18th May 2012 to 15th June 2012.
One user is allocated to the project with no date restriction for 25%.
The user work for 8 hours and ends his day @ 5:00 PM
The current time is 18th May 2012 3:30PM when I load the plan it says 38.5 hours available. Not able to understand how this was calculated.
There are 19 days left in the Iteration if we exclude the last day and week ends.
Which means 19 * (8 * 0.25) =
If we include last day as well then there will 20 days left in the Iteration
Which means 20 * (8 * 0.25) = 40 hours.
As of now (18th May 3:30 PM) 6.5 hours for the day is done which means
40 - 6.5 =
It should have been 33.5 hours or 38 hours.
How come it is 38.5 hours?
Accepted answer
Hi Aditya,
Where do we mention this 25% allocation done for a project? which template are you using?
Currently i am facing a problem in my scrum template - where all the plan-items show accumulated time till the plan end date - irrespective of the due-date and estimate provided. Even the closed tasks - accumulation time is shown as till plan end-date.
Is this a scheduler problem? Please let me know if you would like to see the process config source
Thanks.
Where do we mention this 25% allocation done for a project? which template are you using?
Currently i am facing a problem in my scrum template - where all the plan-items show accumulated time till the plan end date - irrespective of the due-date and estimate provided. Even the closed tasks - accumulation time is shown as till plan end-date.
Is this a scheduler problem? Please let me know if you would like to see the process config source
Thanks.
2 other answers
The plan will consider it as 20 days as we need to include the last day as well. By default the iteration dates also have time part, this needs to adjusted based on the project.
The dates will be stored in Server locale and 12:00 PM means noon and 12:00 AM means start of the day.
If the last day also needs to be considered then something like 5:00 PM needs to be specified.
So it will 20 * (8/4) = 40 hours.
For 18th May there are 6.5 hours spent for the day. For this plan it will be 6.5/4 = 1.625 hours spent and not 6.5 hours spent. We need to apply the allocation percentages on the today as well.
We always round off to quater of an hours so it will 1.5 hours spent for the date.
That mains available hours in 40 - 1.5 = 38.5 hours.
That is how the available hours is calculated as 38.5 hours.
So it will 20 * (8/4) = 40 hours.
For 18th May there are 6.5 hours spent for the day. For this plan it will be 6.5/4 = 1.625 hours spent and not 6.5 hours spent. We need to apply the allocation percentages on the today as well.
We always round off to quater of an hours so it will 1.5 hours spent for the date.
That mains available hours in 40 - 1.5 = 38.5 hours.
That is how the available hours is calculated as 38.5 hours.