Question

Locked

Random population of Excel matrix

By John Gordon ·
I have 100 assignments to be reviewed and 23 reviewers. Each assignment must be reviewed by 3 separate reviewers. How can I randomly allocate the assignments to the reviewers such that each assignment is reviewed 3 times and each reviewer has an equal workload?

I do not want any subset of reviewers to review the same subset of assigments hence the requirement for random allocations.

I have heard that Excel can do this but can't figure it out myself.

Any suggestions?

Thanks

John

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Software Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums