Company has 1000 employees. Said company has 20 base domiciles to live [login to view URL] domicile only has a certain number of spots. Each employee can bid up to 20 times for a domicile they want to live in. It goes by seniority. Employee 1 gets first pick ect. As the spreadsheet looks at the bids it moves down the list assigning domiciles based on picks 1-20. I need a spread sheet that will look at all the 1000 employees and based on movement can determine the likely hood of which domicile you will be granted. Further to this, choices you pick can be determined by how much seniority you have. If domicile A has 12 workers and one worker bids it but wants to be ranked 6 or higher if ranked 7 or lower that employee wouldnt be granted it.
21 freelancers are bidding on average $385 for this job
Hello, I'm engineer in statistics with good experience in both theoritical and practical field. And I'm good programmer on VBA Excel. I can do good work for you. I have already worked on a project like yours.