This is for daily fantasy sports. I'm looking for a formula in excel that can give me a specific set of information.
I need to be able to input a set of data (I will provide the data) that will include thes three things: player names, player prices and player projected scores. I need to be able to have excel look at that data, and take the 8 players that project the most points without going over 50k total price for the lineup. Lastly, it needs to be able to sort by player position. Because per set, I can only play 1 point that is a point guard, only 1 that is a shooting guard, only 1 small forward, 1 power forward, 1 center, and additionally, 1 extra guard (point or shooting), 1 extra forward (small or power), and 1 extra utility player (meaning any position).
I'll need to be able to just copy paste the data set of all the players (and I can give you an example of what that would look like), and have it spit me out the 50 top lineups given the data set.
I assume this type of formula shouldn't take long for an expert in excel, but I'm willing to pay very well for this type of spreadsheet. I've included a sample data set in the uploaded files.
For the price, I was thinking around $400, this number is negotiable. Let me know
The price is not such an issue as I am looking to higher someone who is qualified and won't make any mistakes. I need to be sure that the spreadsheet does exactly what I need it to, so take care in your proposal to ensure I believe you are qualified.
Edit: I wanted to make things slightly more clear in case they were confusing at all.
I am looking for the spreadsheet to output 50 sets of data.
Each data set will include players from a specific possibility of positions. Those positions will be listed as "PG", "SG", "SF", "PF", "C", "G", "F", "U".
G = any player either PG or SG
F = any player either SF or PF
U = any player in the data set.
I want to be able to copy and paste the data (I will provide player name's, player price's, player projected scores, and player positions), and have the spreadsheet create 50 different sets of data beginning with the set of 8 players with the highest projected score --While staying under the total of 50,000 total spent on their price. Then the 2nd set of 8 players will be the 2nd highest projected score (while remaining under the 50,000 price), and so on to the 3rd set and 4th set.
Each set must obey the same rules -- Must be 1 PG, 1 SG, 1 SF, 1 PF, 1 C, 1 G, 1 F, 1 U. And must be under 50,000.
The game info column does not matter, you can ignore that..