+ Reply to Thread
Results 1 to 7 of 7

'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60 jobs

  1. #1
    Registered User
    Join Date
    01-15-2019
    Location
    washington, DC
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    5

    'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60 jobs

    at a loss here as to how to accomplish this task w/o manually doing it. I basically have a list of 200+ candidates. Ther are 60 jobs available, and the hiring managers have ranked hi to low (1 to 5) as to who they prefer for their particular job. whats the best way to capture this info so that we can then see where we need to intervene--ie make decisions if two jobs like the same candidate at the same rank?

    thank you in advance for all your help.
    d

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,244

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Valued Forum Contributor PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    989

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    Attach a Excel sample containing data.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Click the * to say thanks.

  4. #4
    Registered User
    Join Date
    01-15-2019
    Location
    washington, DC
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    5

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    Thank you for the quick responses. I do not have a sample as yet, so maybe I will come back when I have something to show. For now, I was more looking for guidance on how to setup an sheet that would reflect a decision matrix with inputs for Rank (1 through 5) and project.

  5. #5
    Valued Forum Contributor PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    Romania
    MS-Off Ver
    2016
    Posts
    989

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    You add the raw data into a sheet containing all the data like: Job, Manager, Candidate and Rank. Then in a output data you could create some dropdowns for rank and manager to return the candidate and then, in separate rows or columns you could return the job/jobs. doing so, you will find the candidates that had a specific rank for multiple jobs. A sample would help a lot

  6. #6
    Registered User
    Join Date
    01-15-2019
    Location
    washington, DC
    MS-Off Ver
    MS Office 365 ProPlus
    Posts
    5

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    here is the table that I have created. I'm wondering if there is an easy way to show this information so that selections can be made. Basically, there are 60 projects available and for each project, the project lead has ranked up to 5 possible candidates (1 being the most preferred). is there sort of a decision matrix, or algorithm of sorts that would provide the best outcome so that each job gets the best match? any other suggestions on presentation would be greatly appreciated as I learn to use the table.

    Thank you in advance.
    Attached Files Attached Files

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,301

    Re: 'matching' table to capture 200 candidates that have been ranked (from 1 to 5) for 60

    is there sort of a decision matrix, or algorithm of sorts that would provide the best outcome so that each job gets the best match?
    I believe that is beyond the scope of Excel. I feel that once you find the answer you could then come back, with a small manually completed sample (say 10 candidates and 3 jobs), and we may be able to automate the process using formulas/code so that it could be applied to the larger data base.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1