Hi,
I know this may be a bit tough but here goes my problem anyway...
I had an establishment problem that I am looking for an excel solution.
Say we have 3 departments. DeptA, DeptB and DeptC in a school. To accept
students for the first classes each have various capacities. Say DeptA can
accept 24 students while DeptB can only accept 20 and DeptC 22. When
applying to the school, the candidates present 2 criteria + an exam result
to be used by the admin to classify them to the depts.
- Past school average (a number, max 10): say variable SA
- School entrance examination result (a score max 10): say variable ER
- Priority of dept for students (students need to give top priority and a
second choice): say variables P1 and P2

The formula to evaluate each student success sub total is:
SA*0.50 + ER*0.35

For the first choice Dept (P1) this sub total is to ve multipled by 0.10
For the second choice Dept (P2) this total is to be multipliesd by 0.05

Two marks will come out for each candiadate. Mark for the First Choice and a
mark for the Second Choice. Thus two lists for the Dept candidacy. One for
the first choice and one for the second.
All applicants are then sorted according to thouse marks. First they are
tried to fill in the candidacy needs of the depts according to the first
choices list. If not all depts are filled then the second choice lists are
taken into account students with most successfull totals gets the places.

How can I use excel macro's to solve this problem?
Thank in advance
Martyn



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.715 / Virus Database: 471 - Release Date: 04.07.2004