I need help to create an Excel VBA script that produces an amount of possible combinations with certain criteria regarding salaries and points.
I will provide a list in excel that will include 3 columns: name, salary, and points. This script should generate from 1 to 150 outcomes while picking 6 names but staying between $37,000 and $50,000 total salary. The outcomes need to sort by highest possible points first.
If this project is successful, there will be other similar projects for you to bid on.
The total salary for each 6 name combination cannot exceed $50,000 and go no lower than $37,000.
A name cannot be used more than once in the same output.
I would like the ability to select how many outputs to generate, from 1 to 150.
I will provide the list to the winning bidder. I want this to be something that I can easily run on my own as I add new names and salaries. This needs to be finished by Thursday, Feb 23 or Friday Feb 24 2017 at the latest.
38 freelanceria on tarjonnut keskimäärin 98 $ tähän työhön
Hi, I am an Excel VBA expert and can handle the project requirements. Also, I have been involved in some similar projects earlier. Shall try to make the solution user friendly. Let me know. Regards, Arul
PLease provide the spreadsheet as it is not clear what "points" is. IF I take the 2 constraints of 50,000 and 37000 only, then it is possible to generate infinite number of salaries.