Problem Statement: I have a table containing 3 columns(Task#, Duration & Task Priority). I have to sort the Task# Column based on the below requirement.
Note: Working Hours per Resource per Day - 5 Hrs. All resources should be equally assigned with work.
1. Given a set of 4 resources, I have to allocate the below mentioned task to these resources on priority basis.
2. Eg. The Task Sequence should be sorted in such a way that the Priority 1 should be completed on Day1 with 4 Resources working 5 hrs per day.
Input Table:
Task # Duration(Hrs) Task Priority
Task 1 5 1
Task 2 5 1
Task 3 5 1
Task 4 5 1
Task 5 5 2
Task 6 5 2
Task 7 5 2
Task 8 5 2
Task 9 5 3
Task 10 5 3
Task 11 5 3
Task 12 5 3
The sorted output should be
Task# Task Priority Task Duration Resource Day
Task1 1 5 Resource1 Day1
Task5 2 5 Resource1 Day2
Task9 3 5 Resource1 Day3
Task2 1 5 Resource2 Day1
Task6 2 5 Resource2 Day2
Task10 3 5 Resource2 Day3
Task3 1 5 Resource3 Day1
Task7 2 5 Resource3 Day2
Task11 3 5 Resource3 Day3
Task4 1 5 Resource4 Day1
Task8 2 5 Resource4 Day2
Task12 3 5 Resource4 Day3
This task list is dynamic and I might have hundreds of task each having different priorities and duration. Pl suggest a vba solution to this problem.
Thansk
Vijay
Bookmarks