• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to create a tool in excel to allocate resources based on their hours availibility

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 -
PersonWeek NoHours 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
 
Back
Top