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

Ditutup Dipasang 3 tahun yang lalu Dibayar saat pengiriman
Ditutup Dibayar saat pengiriman

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 Pemrosesan Data Excel Visual Basic untuk Aplikasi

ID Proyek: #28232036

Tentang proyek

29 proposal Proyek online Aktif 3 tahun yang lalu

29 freelancer rata-rata menawar $133 untuk pekerjaan ini

writingapp

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

$60 USD dalam 1 hari
(238 Ulasan)
6.7
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 Lebih banyak

$70 USD dalam 1 hari
(93 Ulasan)
6.0
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 Lebih banyak

$40 USD dalam 7 hari
(67 Ulasan)
5.4
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 Lebih banyak

$100 USD dalam 3 hari
(16 Ulasan)
4.8
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 dalam 3 hari
(46 Ulasan)
4.5
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 Lebih banyak

$50 USD dalam 1 hari
(15 Ulasan)
3.8
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 Lebih banyak

$30 USD dalam 1 hari
(6 Ulasan)
3.6
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 Lebih banyak

$130 USD dalam 4 hari
(9 Ulasan)
2.8
try25

hello

$140 USD dalam 7 hari
(0 Ulasan)
0.0
mdebrahim1704

i am BSc in computer science and engineering and i hope i am perfect for this project .So Give me this opportunity . Thank you sir .

$150 USD dalam 3 hari
(0 Ulasan)
0.0
kamil79930

Hello There. Besides VBA you need an Algorithm expert as the combinations are pretty high. I have done Algorithm Certification from Stanford Online. I recently completed a Word VBA project for one client on Fiverr. Tru Lebih banyak

$50 USD dalam 5 hari
(0 Ulasan)
0.0
thinnguyen6x8

I have won 2nd methematic prize national olympic. I’m very good at VBA excel. I want to send demo file to Your Email ?

$60 USD dalam 7 hari
(0 Ulasan)
0.0
mohamedagoble37

hello, I offer my services in the short term. I am an Excel expert and work harder. I can help you to create your 32 teams combinations from your data and instructions, in a relatively short time. please pay particula Lebih banyak

$250 USD dalam 2 hari
(0 Ulasan)
0.0
HeruAJ

hello there, i have read carefully your project details and i am intereted in taking it. i am new here but i am very familiar with ms. excel and macro. please message me to discuss more. thanks, moel since there Lebih banyak

$111 USD dalam 5 hari
(0 Ulasan)
0.0
insimpec

Interesting project! The logic is actually quite simple, where the challenging part is the amount of data. With 100 players from CPT or Flex, the number of possible combination can go up to 493,952,256 (without salary Lebih banyak

$100 USD dalam 1 hari
(0 Ulasan)
0.0
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 Lebih banyak

$278 USD dalam 5 hari
(0 Ulasan)
0.0
PROFMQS

Hi I have an interesting background in excel and VBA. I'll be ready to provide the needed service. Looking forward to your reply. Best regards! Yassine.

$250 USD dalam 7 hari
(1 Ulasan)
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 dalam 2 hari
(0 Ulasan)
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 Lebih banyak

$70 USD dalam 1 hari
(0 Ulasan)
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 Lebih banyak

$33 USD dalam 2 hari
(0 Ulasan)
0.0