SharePoint/Excel Employee-Office Matching System
Budget: $250 – $750 USD
I’m looking for a matching system I can use on sharepoint or excel or Microsoft forms . Something that allows people to access and I don’t have to individually type the responses . Here is what I am looking for : Custom order request I would like to us microsoft forms , excel or sharepoint to create a matching survey Where 20 employees(changable) pick their desired office location. I would like for them to have the ability to rank the offices and select at least two or three Then the office locations (30 locations but changeable) Rank the personnel. THen based on the rankings people are provided with their top two offices they can work with. While allowing the office to pick who they want to work with .They will then be assigned a primary, secondary and third office based on ranking . How does it work? The matching algorithm is “applicant-proposing “meaning it attempts to place an applicant (Applicant A) into the office indicated as most preferred on Applicant A’s rank order list. If Applicant A cannot be matched to this first choice program (because the office doesn’t also prefer Applicant A), an attempt is then made to place Applicant A into the second choice office and so on, until Applicant A obtains a tentative match, or all of Applicant A’s choices have been exhausted (meaning Applicant A cannot be tentatively matched to any program on the ROL).What does tentative match mean? Applicant A will be tentatively matched to a program if the program also ranks Applicant A on its rank order list, and either:the program has an unfilled position (making room for the tentative match to Applicant A) orthe program is filled but Applicant A is more preferred by the program than another applicant (Applicant B) already tentatively matched. In such a case, Applicant B is “bumped” from the tentative match with the program to make room for Applicant A.What happens to an applicant whose tentative match is “bumped”? The matching algorithm will return to Applicant B’s rank order list and attempt to tentatively match Applicant B at the next most preferred position on Applicant B’s list. The attempt to find another tentative match for Applicant B is done in the same manner as outlined for Applicant A.When does a tentative match become final? When all applicants’ rank order lists have been considered, the matching algorithm is complete and all tentative matches become final . Could you tell me if it can be done and if so how much? I need it to be on microsoft products so sharepoint or forms or excel something I can send the staff to fill out.