linear programming excel solver -
when scheduling appointments 3 different students regarding 3-4 necessary meetings (dean, own supervisor, student council , career coach) using excel solver come accross several issues , can't seem find solution.
each student can go 1 meeting per timeslot , each meeting can focus on 1 student @ same time. 2 of 3 students first have see dean, whilst 1 first has talk with supervisor. have see them before can go other meetings.
student 1 needs see dean, own supervisor , student council. needs first go dean before others. student 2 needs see 4 , first needs go own supervisor. student 3 needs see dean , student council , first needs see dean.
how can use excel solver find optimal time slot allocation each student? can't seem make work..
Comments
Post a Comment