Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a random scheduler.
I was speaking with a teacher colleague who would like to create an excel sheet which would assign students randomly to six groups, with each group having four students. I thought that I could use the Solver function in conjunction with the RANDOMBETWEEN function to solve this, but to no avail. Any ideas would be greatly appreciated. My approach is outlined below. Sincerely, Tim Maguire Approach: 1) Have a list of 24 students, with a column for the group they are assigned to (number 1-6). 2) The group colmun is generated using the RANDOMBETWEEN function. 3) I use SUMIF statements to calcuate the occurence of each group number calculated using the RANDOMBETWEEN function. 4) I then run solver with the objective of setting each of the SUMIF statements equal to 4. That way I have 6 groups of 4 students. I think, due to the nonlinearity of sub-routines (such as SUMIF) this problem is not solvable. Thus any help is greatly appreciated. -- timjm ------------------------------------------------------------------------ timjm's Profile: http://www.excelforum.com/member.php...o&userid=37463 View this thread: http://www.excelforum.com/showthread...hreadid=571231 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Random Number response | Excel Worksheet Functions | |||
Random Sampling | Excel Discussion (Misc queries) | |||
Generate random numberes using reference to the other cell. | Excel Worksheet Functions | |||
VBA "Rnd" Function: Truly Random? | Excel Discussion (Misc queries) |