- Local time
- Today, 18:31
- Joined
- Jan 23, 2006
- Messages
- 15,383
Just reading this thread and having same confusion as the others.
It sounds like: (may just be another interpretation)
You have 11 people. Each day you need to assign 1 person to something. So if you want to schedule, say 14 days worth of assignments, you assign person1 to day1, person2 to day2 up to day11. Then on day12 you assign person1, day13 person2, day14 person3.. Then the next round of assignments begins with person4....
This seems like a standard rotation, but what's standard about that?
This also assumes that the number of people is fixed (11). However, if new people enter your resources available list, you can adjust the assignments using the total people in the rotation. Similarly, if your people resource list gets diminished (someone leaves...) then your rotation list must be reduced.
I agree with Pat that defining the problem is most difficult.
I also agree with Doc that you ignored/didn't account for 9/2 (and 9/5), but there may be a rule or 2 that you have not identified in your posts.
Why no vba???
It sounds like: (may just be another interpretation)
You have 11 people. Each day you need to assign 1 person to something. So if you want to schedule, say 14 days worth of assignments, you assign person1 to day1, person2 to day2 up to day11. Then on day12 you assign person1, day13 person2, day14 person3.. Then the next round of assignments begins with person4....
This seems like a standard rotation, but what's standard about that?
This also assumes that the number of people is fixed (11). However, if new people enter your resources available list, you can adjust the assignments using the total people in the rotation. Similarly, if your people resource list gets diminished (someone leaves...) then your rotation list must be reduced.
I agree with Pat that defining the problem is most difficult.
I also agree with Doc that you ignored/didn't account for 9/2 (and 9/5), but there may be a rule or 2 that you have not identified in your posts.
Why no vba???
Last edited: