# Designing A Random Seating Arrangement

Nov 24, 2008Designing a Random Seating Arrangement

I have been given a Task of Designing a layout for seating arrangement for an Exam....

I would know the Total Number of Students appearing for the exams and their respective roll nos...

I would also be given the No of Rows and No of Columns that can be accomodated in the Examination Hall to form a Matrix...

Considering that I have around 65 students appearing for the exam and there are 10 Rows and 7 Columns to accomodate students in excess of 65..

So I need to have a mechanism which can give me the Roll Nos allocated from 1 to 65 randomly in the Matrix...in such a way that the Roll Nos don't get repeated as well as they are not in series next to each other...

In Deciding the Size of Matrix providing the No of Rows and No of Columns if possible...

Ex:-

Lets say Sheet1, Column A has a Heading Roll No and all the Roll Nos from 1 to 65 and Column B has all the Names..

Then I would like to have a code which can generate the Matrix Size in C2 which captures from the Max(A:A) and a Matrix Generated in the Sheet2 from the Starting Point being cell B2 till end...as the cell A1 would contain text as Row/Column and from cell $A2 till end will display Row Nos i.e. Row-1,Row-2,Row3 etc.. and cell B$1 and the entire 1st Row would have headings as Column-1,Column-2,Column-3 etc..

Is this possible as these exams are held every week and its a tedious task to Manually design a Random Seating arrangement as well as the Matrix...