Take data from an excel spreadsheet, manipulate the data to show all possible combinations of team of 6 years with the following criteria.
Combined salary must be greater the 25,000 but less than 50,000
There must be 1 QB, 1-2 RB, 1-2 WR and a total of 6 players
There can only be one CPT, all others are FLEX (Position.1)
Each 6 team roster can not have the same team member IE Chris Carson cant be both a CPT and FLEX position on the same team.
There must be at least one player from each team
I need all team combinations output to a csv/excel file in the following format, one team/line with the following headers on the top line.
CPTPosition1(CPT first to the left), NAME, ID, POSITION, DEPTH, TEAMABB, FLEX1 SAME INFO, FLEX2 SAME INFO, TEAM TOTAL POINTS, TEAM TOTAL SALARY
Line 2 would have the second team
I expect the code to have clear explanations the purpose of each line in case I need to modify/debug it in the future. Thank you
Hello there,
I have read your project description and I can your team combinations output to a csv/excel file in the format you want and satisfying those conditions.
Please send a private message so we can discuss further details
$77 USD në 3 ditë
5,0 (7 përshtypje)
2,7
2,7
3 freelancers are bidding on average $151 USD for this job
Hello,
I am an Excel Expert. I am efficient in Microsoft office tools & also have experience in sorting data, categorizing items, removing duplicates, working with functions or formulas, comparing sheets for unique data, amalgamation of two spreadsheets etc.
I can work on any kind of excel related project. I have the ability to focus on the tasks given and also possess excellent english communication skills. I look forward to working with you soon.
Regards Bharat