Team overload with Due date

Ofcourse v-yulgu-msft

The main task was to split all JIRA task's Remanaining Estimate hours by the time, evaluating Effective worker hours for the day . Everything is working fine, but I noticed if there are a big overload for a assignee that formula splits hours not looking at Due date. And it shows for how long worker will have job, but  don't show what days/week/ month he will have overload. For this, we need to evaluate the Due date:

• if task have a due date 2018 12 31,  there won't be any splitted hours after this date. All hours left for this day will be put in Due Date day (this is solved by Solutinion 2)
• and if there is Effective hours till this day, it will spit hours (this is the problem)

If you can look at Tasks sheet in pibx file, the issue like GND-476, IND-378, VND-237, VND-240.

They have all Remainiging Estimate hours in Due Date date, but here is Effective hours before thease dates, so thease hours should be spited for thease dates.

For Example IND-378 (Remaining Estimate hours - 8,25, Due Date -2018-12-11).

We See that there is 2018-12-10 overldoad - 0 hours (it'hasn't any task's spited for this date), so it should put some of IND-378 hours, for this date.

For IND-378 it should be:

• 2018-12-10 - 5 hours (max of Effective hours)
• 2018-12-11 - 3,25 (left hours for this task (8,25-5 h))

For ADASLI the task's should be spited like that:

I hope it's more clear what I want, if you have any questions don't hesitate to ask.