J
Jim Aksel
I have a multi task project with fixed duration tasks. The tasks are linked,
many occurr in parallel, others are single. On any one day, I cannot state
precisely how many tasks are on going. It could be 1 task, 2, or as many as
12. This varies by day throughout the project duration. No work or resources
assigned just yet. Tasks are various durations, generally 3 days to 10 days.
I need to be able to select several tasks and assign a resource to them.
The trick - regardless of the number of tasks selected, the amount of work
assigned on any day is: 8/(Number of tasks that are selected that have to be
worked that day).
Example: Resource1 should be assigned to 11 tasks -- 2 may be working today
(4 hours each today), tomorrow is the same 2 plus one more task (8/3) is
2.667 hours/task. Then on day 3 there is only 1 task so he is assigned a full
8 hours for that day to the one task.
I am off to VBA aren't I?
many occurr in parallel, others are single. On any one day, I cannot state
precisely how many tasks are on going. It could be 1 task, 2, or as many as
12. This varies by day throughout the project duration. No work or resources
assigned just yet. Tasks are various durations, generally 3 days to 10 days.
I need to be able to select several tasks and assign a resource to them.
The trick - regardless of the number of tasks selected, the amount of work
assigned on any day is: 8/(Number of tasks that are selected that have to be
worked that day).
Example: Resource1 should be assigned to 11 tasks -- 2 may be working today
(4 hours each today), tomorrow is the same 2 plus one more task (8/3) is
2.667 hours/task. Then on day 3 there is only 1 task so he is assigned a full
8 hours for that day to the one task.
I am off to VBA aren't I?