erdem_ustun
New Member
- Joined
- Jun 19, 2018
- Messages
- 12
Hello there ,
I have a rotation problem at the workplace where I work.
I'd appreciate it if you run.
There are 6 employees.
<tbody>
</tbody>
There are 3 locations.
<tbody>
</tbody>
Creates a team of 2 employees
A team(2 employees) will work together at each location with rotation.
Employees will rotate within themselves
Any employee other than himself will be teamed up with the order of 5 other people.
At the same time, this team will also be rotating at the work places.
Every day, teams and work places will change every day except weekends.
How can I make the time schedule of employees and locations on a monthly basis.
Every employee has worked with everyone and everywhere at an equal rate.
I create employees and locations with permutations with vba , but I don't know how to assign them on the calendar.
with all respect
I have a rotation problem at the workplace where I work.
I'd appreciate it if you run.
There are 6 employees.
| Name of Employees |
| Emp1 |
| Emp2 |
| Emp3 |
| Emp4 |
| Emp5 |
| Emp6 |
<tbody>
</tbody>
There are 3 locations.
| Locations |
| Loc1 |
| Loc2 |
| Loc3 |
<tbody>
</tbody>
Creates a team of 2 employees
A team(2 employees) will work together at each location with rotation.
Employees will rotate within themselves
Any employee other than himself will be teamed up with the order of 5 other people.
At the same time, this team will also be rotating at the work places.
Every day, teams and work places will change every day except weekends.
How can I make the time schedule of employees and locations on a monthly basis.
Every employee has worked with everyone and everywhere at an equal rate.
I create employees and locations with permutations with vba , but I don't know how to assign them on the calendar.
with all respect
Last edited:
