Sedang Disiapkan

Excel Expert required (math degree would help)

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..

Kemahiran: Excel, Matematik

Lihat lagi: need expert excel help, looking for excel expert, looking for an excel expert, expert in excel help, excel expert 2016, be expert in excel, be an expert in excel, excel vba expert required, excel expert required, required excel expert karachi, excel expert required saudi arabia, excel java example, math expert needed, linux expert required, excel pricing example, vsto excel vbnet example add

Tentang Majikan:
( 1 ulasan ) San Diego, United States

ID Projek: #10107699

36 pekerja bebas membida secara purata $374 untuk pekerjaan ini

$300 USD dalam 2 hari
(249 Ulasan)
7.6
seaanddream

Hi, my name is Sevinc. I read your "Excel Expert required" project descriptions carefully before bidding. I checked your attachment, and additional explanations as well... I got what you need, have already configured Lagi

$525 USD dalam 10 hari
(239 Ulasan)
7.4
bouslimi1979

Sir/Madam, I m an Excel/VBA coder. Your requirements can't be done using a formula as you mention, it can be done by a set of VBA macro. I still have some confusions understanding your project description, this is why Lagi

$333 USD dalam 7 hari
(195 Ulasan)
7.3
priyal1997

Dear Sir/Madam, I’m happy to help you on this task. I’ve read your brief and happy to discuss the project in more detailed. I am highly qualified for this project and have already done lots of similar advanced excel f Lagi

$400 USD dalam 3 hari
(179 Ulasan)
6.7
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$300 USD dalam 3 hari
(231 Ulasan)
6.9
prameswara

Hello Sir Im excel VBA and formula Expert :) i can do anything in excel Sir :) please ping me if u interested Sir :). i already read your description but for more clear about your project please ping me Sir :) Th Lagi

$250 USD dalam 4 hari
(301 Ulasan)
6.9
ACMAuk

I am MSc Statistics and Chartered Management Accountant from CIMA-UK, having 6 years of experience in financial modeling and forecasting & feasibility models. Further I am an expert in using MS Excel, and can help y Lagi

$400 USD dalam 10 hari
(147 Ulasan)
6.6
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best rega Lagi

$450 USD dalam 5 hari
(178 Ulasan)
6.7
Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 62 works on Freelancer where I got Lagi

$300 USD dalam 10 hari
(123 Ulasan)
6.2
bizwizz

Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have b Lagi

$500 USD dalam 2 hari
(20 Ulasan)
5.9
javed1705

HI I HAVE ALREADY DONE THIS FOR YOU PLEASE GET BACK TO ME .................................................................................................................................................... Lagi

$263 USD dalam 10 hari
(72 Ulasan)
5.9
atifdar

Hi, I've checked the CSV & read the instructions, I think i can do it in low cost for you Feel free to discuss Thanks

$250 USD dalam 8 hari
(59 Ulasan)
5.9
Yknox

Hello I'm interesting your project very well I'm a Good VBA, Java, Excel, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Tha Lagi

$552 USD dalam 10 hari
(22 Ulasan)
5.8
antonparfeniuk

A proposal has not yet been provided

$250 USD dalam 7 hari
(51 Ulasan)
5.2
royalcalif

I Can Start Immediately ***PM me for more Information and Sample*** Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I as Lagi

$250 USD dalam 5 hari
(46 Ulasan)
5.0
teeares

The way I would approach this problem is to get all the possible combinations of the 148 players taken 8 at a time. Then from these combinations, remove the combinations which do not meet the position requirements and Lagi

$555 USD dalam 10 hari
(50 Ulasan)
4.9
rajafaizan

Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely Lagi

$250 USD dalam 7 hari
(28 Ulasan)
4.5
rinabuoy13

Hello there, I am an experienced vba and excel developers. I have applied excel, vba and other programming languages such c# in a number of engineering projects. I also have experiences with mathematics, optimisati Lagi

$388 USD dalam 7 hari
(33 Ulasan)
4.4
ZhangDaLong

Hi, client. I am a C++ programmer and mathematician. Saying honestly I am not skilled at using Excel utility. But manipulating Excel data(csv file) is no problem for me. As far as your requirement is clear, surely Lagi

$300 USD dalam 3 hari
(16 Ulasan)
3.8
gsanggara

Hello, I am interesting to your project and placed bid for your consideration. With my experience in excel formulas, template's and macro. I have read thru project desc & I am confident that I will able to complete you Lagi

$250 USD dalam 3 hari
(15 Ulasan)
3.5