Lottery Enrollment by choice/preference

[yawgoo]

Greetings all,
I am looking for a way to do something similar as (Student Choice), and I have tried to manipulate the macro but it's a bit more complex and beyond my brain power lol.

We have at a sports school for kids ranging from age 3 through adults and given the popularity would like to offer a lottery-style enrollment where the students can register for their preferred classes taking into account their specific age range group and their level of experience. We are hopeful this will save us time, be fair, and be faster than our method of doing it by hand.

Here are some specifics:

• School Total of 1200+ students (with 2000+ applicants)
• A total of 200 +/- classes offered
• Average of 5 students per class
• 5 Age Groups
  • Ages 3 & 4
  • Ages 5 & 6
  • Ages 7 & 8
  • Ages 9 - 12
  • Ages 13+
• 4 Experience Level Groups
  • Level 1
  • Level 2
  • Level 3
  • Level 4

Student Name

Age Group

Experience Group

Class Preference 1

Class Preference 2

Class Preference 3

Class 1

Class 2

Class 3

Class 4

Class 5

Class 6

Class 7

Class 8

Class 9

Class 10

Class 11

Class 12

Class 13

Class 14

Class 15

Ages 3-4

Ages 3-4

Ages 3-4

Ages 3-4

Ages 5-6

Ages 5-6

Ages 5-6

Ages 5-6

Ages 7-8

Ages 7-8

Ages 7-8

Ages 7-8

Ages 7-8

Ages 7-8

Ages 7-8

Level 1

Level 1

Level 2

Level 2

Level 1

Level 1

Level 2

Level 2

Level 1

Level 1

Level 2

Level 2

Level 3

Level 3

Level 4

Abby

3-4

Level 1

Class 1

Class 2

Bobby

5-6

Level 2

Class 7

Class 8

Cindy

7-8

Level 1

Class 9

Class 10

Danny

3-4

Level 2

Class 3

Class 4

Eddie

5-6

Level 1

Class 5

Class 6

Frankie

7-8

Level 1

Class 9

Class 10

Georgie

7-8

Level 1

Class 10

Class 9

Henry

7-8

Level 4

Class 15

Iota

7-8

Level 3

Class 13

Class 14

Jannie

5-6

Level 1

Class 6

Class 5

Kammie

7-8

Level 4

Class 15

Lanny

3-4

Level 1

Class 3

Class 4

Manny

7-8

Level 4

Class 15

Nannie

3-4

Level 1

Class 1

Opie

3-4

Level 1

Class 1

Class 2

Pappi

3-4

Level 1

Class 2

Class 1

Quanni

7-8

Level 4

Class 15

Randy

7-8

Level 1

Class 9

Class 10

Sandy

7-8

Level 4

Class 15

Tammy

7-8

Level 2

Class 11

Class 12

Unise

7-8

Level 3

Class 13

Class 14