I need something that can optimise/maximise the points scored of a data-set of players under certain constraints. I imagine this could be completed using java, R etc.
For example, from the datasheet attached, I'd like to know the selection of players (team) that result in the maximum amount of points under the constraints:
- Maximum salary = 50000
- Maximum number of players from one team = 6
- Must have 1 goalkeeper, 2 defenders, 2 midfielders, 2 forwards and 1 utility (could be another defender, midfielder or forward). This is more complex given that some players can fill both the midfield or forward positions (see data sheet)
I'd also like to be able to easily edit these constraints for different datasheets. For example, I may want to change the salary to 100, max number of players from each team to 4, and have it select 1 G, 3D, 3M, 1F and 3 utility.
An option to select how many teams it produces is necessary too. For example, I may want it to produce the the top 10 optimal teams
The end result will be some sort of smooth interface where I can easily load an excel file such as the attached file, adjust the constraints how I want them and have the software return the optimal selections in the format of the output file attached
Hello
My name is Ahmed, i'm a top rated freelancer.
i worked over 200 projects and over 500 hours doing java projects.
plus i passed freelancer java exam with top 20% plus i got 2 java certificate 1Z0-803 and 1Z0-804 with 3+ years experience.
small overview of feedback on my profile
"you want to get your projects completed with quality? Hire Ahmed. Highly recommended."
"Thoroughly satisfied with Ahmed, and would recommend him to anyone looking for an excellent java developer!"
"Highly recommended. Very smart and well experience"
looking forward to work with you Regards
I can do this project in either C# or html&javascript. html would have the advantage of being cross platform and would give you the ability to publish in the future.
We have domain and technical expertise in algorithm development with C/C++/Java for different target platform. We are using R with both C++ (Rcpp) and Java (rJava). I've gone through your problem statement. Can we discuss over chat?
Hey,
I reviewed the two spreadsheets you shared and also the requirements description. This is basically a constrained combination generation problem that can be modeled as a LPP. I can create a setup in excel that will allow you to easily import the files, define the constraints and then generate the combinations on click of a button. I am an excel expert and can assure you I would be able to create the model exactly as you may have envisioned.
Please drop a message to me if you would like me to work on this project for you and we may discuss the next steps.
Look forward to hear from you and thank you for considering my bid
Best Regards,
Rishi
(Automyze Consulting)