doyel kayal
New Member
I need to build an automated tool in excel to allocate the weekly tasks to resources based on their hour availibility.
Each resource does have fixed 40 hours each week and each task requires 3 hours to complete.
Refer the following table -
Note that, For week 36 the input is fixed (Given). From next week onwards hours availibility is being calculated.
Now while assiging the task in week 37 it wil initially be assign to A as it has the maximum hours avaialble( A rank is created based on the initial hours). Once it assigns 3 hours will be deducted from his hours and rank will be recalculated based on this update.
How to create a dynamic column such that every time this rank is calculated and taskes are assigned to the max hours availlable resources automatically
Each resource does have fixed 40 hours each week and each task requires 3 hours to complete.
Refer the following table -
Person | Week No | Hours at the beginning of the week( available time) |
A | 36 | 39 |
B | 36 | 38 |
C | 36 | 39 |
D | 36 | 40 |
A | 37 | 43 |
B | 37 | 42 |
C | 37 | 41 |
D | 37 | 40 |
Note that, For week 36 the input is fixed (Given). From next week onwards hours availibility is being calculated.
Now while assiging the task in week 37 it wil initially be assign to A as it has the maximum hours avaialble( A rank is created based on the initial hours). Once it assigns 3 hours will be deducted from his hours and rank will be recalculated based on this update.
How to create a dynamic column such that every time this rank is calculated and taskes are assigned to the max hours availlable resources automatically