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 freelance font une offre moyenne de €72 pour ce travail
Dear copito49, Highly Experienced Team Of Professionals [url removed, login to view] check your PM For Details. Thanks Dhruvika
Excel expert here,provide more details or some examples so that I can make a demo for you ASAP.
Hi I have tried to provide you the best fit. Taken all points into consideration. Have attached a sample of scheduling this. Please check your mail box.
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.