random allocation

hi there everyone, i was hoping for some help here. I have 13 departments and 121 employees and want to assign them departments (which have fixed spots) for a month randomize department for the given employees , I have been doing this manually and would like to use excel to automate the process...

I am totally lost.. pls help.. I have a list of Loan types: and a list of Home Loan products: What I need to do is have 1 single Product link to multiple Loan types, but each Product may not have all 6 Loan types.. For example, Product 1 (2nd List) could have Interest only and Fixed Rate and...

Hello there and thank you for taking the time to read my post. I am looking for some assistance with a 'fixture list' type table for job comparisons Please see the attached Excel example which I have manually put together. The list of Jobs could be in the 100's if not thousands and I, therefore...

Hello, I have this problem. With a table like this (75 rows): <tbody> Station 1 Station 2 Station 3 Station 4 Station 5 Station 6 Person 1 Person 2 </tbody> I need to assign turns to each person so they can go through all stations. The maximum people per station can be 14...

Hi I have 100 students in my class and there's an article that I want them to submit. Also I want 5 of the students to evaluate each other's articles. All the students have a unique number. Can someone please suggest a formula for the same? PS I don't want any student to evaluate his or her own...

Hello, I have a list of 1000 vehicles with VIN numbers in column A. I would like to assign each VIN a random name from the following names available: <tbody> Winter Motor Company ALL PRO MOTORS AMERICAS AUTO AUCTION Dallas Auto Auction MANHEIM DALLAS FORT WORTH MANHEIM MINNEAPOLIS...

I have a problem, and I think I best can solve it with a VBA code. So I really hope for some good ideas….....I try to explain Basically i try to allocate persons to courses (groups) given a set of restrictions. The following just to give an example and explain the variables: <tbody> Persons...

I am attempting to build an employee attrition model to better understand the impact on an organization. In my worksheet are the following data: column A: employee name, column B: job title, column C: random number and column D: identification of the attrited employees. In column C, I have...

I want to use a spreadhseet to create random teams for a project. Here's the scenario: -1200 possible team members listed in column A -500 teams listed in column B -4 people on each team ready to be populated in columns C-F -End goal is to have every team member makes it on at least 2 teams...

Hi Guys! I have an Excel sheet with a list of names in column A row 1-39 and then dates in B, C, D etc representing days of the week. Each of the Names puts an "A" to show they are available to work that day. This info is pulled through to a allocation sheet where we select the names from...