Закрыт

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)

Навыки: Visual Basic, Обработка данных, Excel, Visual Basic для приложений

Показать больше: 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

О работодателе:
( 9 отзыв(-а, -ов) ) Atlantic beach, United States

ID проекта: #28232036

30 фрилансеров(-а) готовы выполнить эту работу в среднем за $132

(305 отзывов(-а))
7.8
(143 отзывов(-а))
6.7
(63 отзывов(-а))
6.6
(91 отзывов(-а))
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 Больше

$70 USD за 1 день
(69 отзывов(-а))
5.4
writingapp

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

$60 USD за 1 день
(72 отзывов(-а))
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 Больше

$40 USD за 7 дней(-я)
(44 отзывов(-а))
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 Больше

$100 USD за 3 дней(-я)
(8 отзывов(-а))
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 за 3 дней(-я)
(37 отзывов(-а))
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 Больше

$50 USD за 1 день
(16 отзывов(-а))
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 Больше

$30 USD за 1 день
(6 отзывов(-а))
3.7
(5 отзывов(-а))
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 Больше

$50 USD за 1 день
(6 отзывов(-а))
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. Больше

$56 USD за 1 день
(3 отзывов(-а))
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 Больше

$130 USD за 4 дней(-я)
(3 отзывов(-а))
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 Больше

$100 USD за 2 дней(-я)
(2 отзывов(-а))
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 Больше

$278 USD за 5 дней(-я)
(0 отзывов(-а))
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 Больше

$33 USD за 2 дней(-я)
(0 отзывов(-а))
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 Больше

$70 USD за 1 день
(0 отзывов(-а))
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 за 2 дней(-я)
(0 отзывов(-а))
0.0