I need a macro in excel to solve this problem (numbers are not exact):
- We have 1000 students that have to take 3 out of 8 oral tests in an evening (15 minutes each test). There are test A, test B, test C, test D, ..., test F
- We have teachers to do the tests. Every teacher is only prepared to make a kind of test. (one teacher will only be able to make test A, other test B, .....)
- From the excel list of students and tests that are going to do, we have to assign students to teachers.
- Tests for the students should be located as near as possible during the day
- Teachers should be occupied all the time until there are no more tests to do.
- We have to take into account the some students may appear to do the test, we will have to register them in real time a assign teachers for the test they choose to do
4 pekerja bebas membida secara purata €72 untuk pekerjaan ini
Hi there copito49. I have experience with this kind of project and can design an Excel project to fit your requirements. Please see the sample uploaded onto my profile Portfolio thanks.