Closed

Build an excel combinations table with rules for fantasy football -- 2

I am looking for someone to build an excel combinations table calculator for fantasy football lineups. This will require expert knowledge in excel and VBA to complete. The table will need to generate to combination possibilities of 100 players.

1. one player will need to be selected from the players CPT pool and five players from the FLEX pool for each combination. Players can only be included in the lineup once.

2. lineups must not have a combined salary above $50,000 (Only show $50,000 and less) This should reduce the number of possible combinations.

3. The output combinations should be summarized on the combinations results tab in the example provided.

Column A is for the CPT player

Column B - F Are for Flex Players

Column G should combine the salaries of the players in the lineup

Column H should combine the Players average score

4. One player form the CPT and five players from the FLEX pool make up a line up - These are located on the tab called Data Set in Column E.

5. Name + ID (Column B on the Data Set Tab) will be used on the Combination results tab output in cells as shown in the example.

6. At least on player for each team will need to be included in each lineup. Do not need lineups that have all players from one team. column H on the Data Set tab has the teams. This will need to allow for any combination of 32 teams not just the two teams shown. ( I know this is very tough to do and may not be achievable, if it is I will add a bonus)

Skills: Visual Basic, Data Processing, Excel, Visual Basic for Apps

See more: build excel pivot table, aspnet build excel pivot table, build excel pivot table text file, fantasy football league rules word document forum, fantasy football 2009 excel draft board, fantasy football 2009 excel draft kits, ten team fantasy football draft order excel, free fantasy football draft board excel, fantasy football draft board excel, build fantasy football website, excel fantasy football draft, excel fantasy football draft board project, excel spreadsheet fantasy football, excel spreadsheets fantasy football draft, export fantasy football excel, fantasy football blank draft board excel, fantasy football draft board excel spreadsheet

About the Employer:
( 9 reviews ) Atlantic beach, United States

Project ID: #28232036

30 freelancers are bidding on average $132 for this job

(305 Reviews)
7.8
(143 Reviews)
6.7
(63 Reviews)
6.6
(91 Reviews)
6.4
ilkecokay

Nice project! Takes me back to Math 101. 1 221 759 combinations for FLEX player, with no filters. Add 1 captain from a pool of 45 captains, makes a total of 54.979.155 combinations. Since their combined salary has a li More

$70 USD in 1 day
(69 Reviews)
5.4
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 1 day

$60 USD in 1 day
(72 Reviews)
5.6
BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - • Macros • Formulae • VBA • User forms Willing to share a sample o More

$40 USD in 7 days
(44 Reviews)
5.0
tushchak0716

Hi greetings from Tushar!! I am interested in taking up your project. I am a spreadsheet automation expert having hands on experience of working with excel functions and excel VBA scripts, google sheet functions and g More

$100 USD in 3 days
(8 Reviews)
4.6
maguirrer

Hello, I can help you to create the macro to get all possible combinations for the players, please send me a message with more details and I can start working on it inmediately

$47 USD in 3 days
(37 Reviews)
4.3
yesubabu10203

Hi . This is Yesu ,I am Working as VBA/Python developer for 5 years I work on automations of [login to view URL] [login to view URL] [login to view URL] [login to view URL] Point [login to view URL] [login to view URL](limited) We use Macros,VBScripts,API's,Selenium, for process I can More

$50 USD in 1 day
(16 Reviews)
3.7
Mohilm007

-----------------I CAN START RIGHT AWAY 100% ACCURACY-------------------------------- Hello sir, I have read your project details . I can Automated Data Analysis via Excel spreadsheet by maintaining 100% accuracy of More

$30 USD in 1 day
(6 Reviews)
3.7
(5 Reviews)
2.6
globalgo

Excel VBA expert. Hello, sir, I can do it in a half of day. I read your project carefully and I can help you. I am Excel VBA expert. and I have 10+years experience in c, c++,etc. u can see my review. please chat with More

$50 USD in 1 day
(6 Reviews)
2.1
Mdkhanasif

Dear Contact Person, I have vast experience in VBA projevt, CPT presentasion. collecting information, data entry and excel formatting. I am looking for more opportunities to put my skills and experiences above others. More

$56 USD in 1 day
(3 Reviews)
2.1
chnsci

Greetings, I think here you are looking for someone to build an excel combinations table with rules for fantasy football. I have seen the attached file and understood your project description. I am an expert in Vis More

$130 USD in 4 days
(3 Reviews)
1.8
afikrifadzil

Hi, appreciate if you took the time to review my proposal. New to this platform but I am very familiar with MS Excel and have experienced completing few projects. I am used with Excel VBA, Macros, Userform and other f More

$100 USD in 2 days
(2 Reviews)
0.9
kobinur1

Hi, i run an Excel consultant firm in israel for 10 years. i can help you with providing solution for business cases and process automation for various industries. my team is agile and with vast experience of system de More

$278 USD in 5 days
(0 Reviews)
0.0
ipavkexcloud

I've done it and here's the full pseudo code algorithm. It uses Excel commands, formulas, and VBA. WARNING: if there are ~45 players per team, you will get over FIVE BILLION (45*44*43*42*41*40) combinations with just 2 More

$33 USD in 2 days
(0 Reviews)
0.0
DrKEWatson

Hey, I have already finished the code for your project. I do automation and data analysis like this all the time. I actually already started. I should be done in the next hour. It is just an iteration macro attached t More

$70 USD in 1 day
(0 Reviews)
0.0
khamishamz8

I am interested in this job. I have a vast experience in data editing , research writing and content writing. I look forwad to working with you. Thank you. Stay safe

$140 USD in 2 days
(0 Reviews)
0.0