aeonrevolution
New Member
- Joined
- Feb 13, 2018
- Messages
- 2
I've been racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from (for argument's sake).
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line. Each job can only be run by one person.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.
I've played around with the idea of using colors to dictate which one the employee gets and pivot tables etc, but I think my lack of knowledge in excel is bringing me here haha.
So, thought I'd come to the experts for advice.
I've n
racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from.
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from (for argument's sake).
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line. Each job can only be run by one person.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.
I've played around with the idea of using colors to dictate which one the employee gets and pivot tables etc, but I think my lack of knowledge in excel is bringing me here haha.
So, thought I'd come to the experts for advice.
I've n
racking my brain trying to figure out how to go about creating a spreadsheet to perform something for me and can't figure out the right angle to approach it from.
So. Here is what I'm trying to do. Numbers are arbitrary to explain.
I have 100 employees listed in seniority order. I have an equal number of jobs for them to pick from.
Each employee picks 5 jobs they wish to do for the next week in order of what they desire.
The highest seniority employee will receive his first choice. The second employee will receive his first choice unless the employee above him picked the same job. If both picked the same job as their first pick then the second employee would receive his second pick.
And so on and so on down the line.
Currently, we do this process by eyeballing it and lots of pencils crossing things off. It usually ends up in numerous errors and having to be second checked.
There must be a way to create a spreadsheet where all you have to do is punch in the employee's picks and then the worksheet will filter it all and spit out which job they will receive.
