Hi
I am trying to help my colleague solve a simple problem on allocation. In the spreadsheet shown in the image below, each of the students has three choices of classes – A, B and C. Each class has a max capacity. The challenge is to allocate students to their lowest choice subject to the...