I have a project of scheduling candidates across three cities where I have to assign candidates a particular date and time as per their preferred choice of city.
Assumption:
I have with me two sets of data:
1) Detail of test centres where a single city can have multiple LABS (Centre Code). For eg. in Barcelona city there are 9 labs; LAB1 can accomodate maximum 11 candidates in a particular date and time, 11 candidates on 2nd jan 10:00. I will be having this data as a matrix as shown in the attached file (Capacity Matrix).
2) Candidate information will be available as a single list as shown in the attached file(List-1)
Aim:
The aim is to assign a particular candidate(identified here with unique application id) a specific date and time in his/her first preferred city at a particular Centre Code.
Also, I want to limit giving schedule in a particular city to ONLY 80% of its capacity; for eg Boston can have maximum 81 candidates; so I need to stop giving schedule to candidates in Boston once the "number of candidates scheduled reaches 81*0.80=64.8~65; after 65 candidates have been given Boston, stop and move on to the next city and the same process is followed.
Output:
The result should be populated as shown in "candidate schedule" of the attached file.
Assumption:
I have with me two sets of data:
1) Detail of test centres where a single city can have multiple LABS (Centre Code). For eg. in Barcelona city there are 9 labs; LAB1 can accomodate maximum 11 candidates in a particular date and time, 11 candidates on 2nd jan 10:00. I will be having this data as a matrix as shown in the attached file (Capacity Matrix).
2) Candidate information will be available as a single list as shown in the attached file(List-1)
Aim:
The aim is to assign a particular candidate(identified here with unique application id) a specific date and time in his/her first preferred city at a particular Centre Code.
Also, I want to limit giving schedule in a particular city to ONLY 80% of its capacity; for eg Boston can have maximum 81 candidates; so I need to stop giving schedule to candidates in Boston once the "number of candidates scheduled reaches 81*0.80=64.8~65; after 65 candidates have been given Boston, stop and move on to the next city and the same process is followed.
Output:
The result should be populated as shown in "candidate schedule" of the attached file.