Randomly assign codes to cells

Bit of a complicated one and I have no real idea if it can even be done. I have a spreadsheet of students (213 of them) and the classes they take during different periods (i.e. column one is the list of students, then the columns afterwards are Monday P1, Monday P2 and so on). There is a two week timetable too.

Some periods don't have any data in, because they have a free period, but I need to randomly assign two specific study periods (using an ICT suite) per student.

However, there can only be a certain number of kids in the study period due to the lack of computers! I essentially want to allocate two study sessions per row (i.e. per student), but without having 86 students attending one study session (for example), and only four in the second. I fear that there are too many variables and I'll have to do it the old fashioned slow way.

Any ideas how it could be done?

I did try the following:

Please Login or Register  to view this content.

but this doesn't work (my first attempt at a macro!). I've attached the file as I'm not sure if I've made sense!

Hello Gemsie,

What is the maximum allowable number of students per study session?
What is an ICT suite?

Hello Gemsie,,

I must admit i find this confusing. Mostly because I don't understand the abbreviations used. The CIT seems to used only on Mondays during period 6. The entries in these columns like "12C/El1", "12C/So1", "13D/Dr1", and "13D/Ph1" appear to the grade, group, and class. Does that mean the student should studying these subjects during the free period in the CIT?

Hi guys,

Why not assign A,B,C,...Etc, to all those fancy Codes, for ease of following the logic, and then change it back again?

Hello Gemsie,

It would help me to see an example of the output. Just a single student example would do.

Hello Gemsie,

We're a fine pair. Can you show me what a 2 week period for a single student would look like with the ICT periods added in?

Hello Gemsie,

Okay, the one I've attached has been done by hand, showing three students. I've entered two ICT sessions into their timetable.

If you attached an example workbook to your last post, it failed to attach.

Hello Gemsie,

Now they both show up. Sometimes there is a lag in the forum updating the posts. Thanks for reposting it.

Hello Gemsie,

It seems to me this would need to rotate evenly among the students. that is each student would be assigned to ICT once per week. The ones don't assigned in week 1 would be given priority in week 2. Does that make sense?