Find Jobs
Hire Freelancers

Build a spreadsheet to generate all possible teams using combination.

$30-250 USD

Closed
Posted almost 7 years ago

$30-250 USD

Paid on delivery
Create an excel spreadsheet to generate all possible teams of 8 players from a pool of 60 players divided under 5 categories ( A, B, C, D,E). Constraints are as follows: 1. Each player is assigned a price and total cost of each team must be less than or =50 [login to view URL] must have at least 1 player from each category but can have 3 players from A,B,C and 2 players from D and E for a total of 8 players for the team.
Project ID: 13861686

About the project

26 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average $116 USD for this job
User Avatar
Hello I am Excel Expert and VBA Developer Also math geek I can create for you desirable team generator If interested contact me Thanks & Regards
$61 USD in 1 day
5.0 (199 reviews)
8.2
8.2
User Avatar
Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir
$250 USD in 5 days
4.9 (334 reviews)
7.9
7.9
User Avatar
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply
$200 USD in 3 days
4.9 (335 reviews)
8.0
8.0
User Avatar
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.
$150 USD in 3 days
4.9 (389 reviews)
7.6
7.6
User Avatar
Give me more details, expert here to do this for you you can check my reviews, lets discuss Regards Usltan
$250 USD in 3 days
4.9 (230 reviews)
7.0
7.0
User Avatar
It looks like you want to generate NBA lineups for DraftKings or something like that. I have considerable experience generating optimal NBA, MLB, and NFL lineups. When you ask for "all possible teams" you think you'll get a reasonable number of them and then you'll just sort by the team's total value. It doesn't work like that. In fact there are millions if not billions of possible teams. Excel won't be able to generate them all because it's too slow (you'd need to let it works for weeks each time you run it), and even if it did you wouldn't be able to sort such huge lists in Excel due to its limitation of the number of rows (1 million or so). Actually what you need is a program that will OPTIMIZE the lineups, not generate all (billions) of them. The program will find any number of the BEST possible lineups, already sorted, and it will do that within seconds, not weeks. I can write such a program for you. I did that before. Here are a couple of similar projects I've done: https://www.freelancer.com/projects/Translation/Fantasy-Basketball-Program/ https://www.freelancer.com/projects/Excel/Elo-Rating-Sports-Prediction-Model/ Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better.
$250 USD in 5 days
4.8 (171 reviews)
7.0
7.0
User Avatar
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 regards
$150 USD in 3 days
5.0 (260 reviews)
7.0
7.0
User Avatar
Hi, I am Imran from Pakistan, I am ready to start right now and try to complete as soon as possible. I have great skills for related to Job, you can check my profile for my client review etc for your complete satisfaction. I have also good experience for Website designing, product listing for various forum, magenta, word press, PDF branding (like designing, Branding, editable PDF & conversion etc), web research and searching, Adobe Photoshop/ Corel graphic designing. I have ALISON certified for MS Excel, Excel & Formula, Powerpoint, Word & office 2010. 10 year computer operator and Administrator in an organization. My Freelancer profile and portfolio also show my experience. I am really interested in this project so please give me chance, I hope it will be nice experience for both of us. I will provide you best service in lowest budget with complete accuracy. ready to start now. I have very cooperative nature person and I always give preference to clients satisfaction Regards
$30 USD in 1 day
4.9 (177 reviews)
6.5
6.5
User Avatar
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We can do this for you quickly and with great quality as per your budget.. We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think is fair. Please do give me a shot. Awaiting your response. Thanks!
$50 USD in 2 days
4.9 (112 reviews)
6.5
6.5
User Avatar
I am an Excel expert. Please share the data of players. I will create all possible team combinations with given constraints.
$100 USD in 1 day
5.0 (145 reviews)
6.3
6.3
User Avatar
- From a list of 60 players categorized into A, B, C, D and E having cost criteria and the number of players selection from one category, can provide a logic to have combinations of playeers using Excel. - Have good expertise in Excel VBA programming. - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Data extraction using API. - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on recent projects. Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables. - Stocks Portfolio - Showing client portfolio stocks with various indicators, Momentum indicators based on portfolio.
$130 USD in 4 days
4.7 (49 reviews)
6.0
6.0
User Avatar
Hi; I have read your job specification and I am pleased to submit my proposal. I am a VBA coder with over ten years experience in developing Excel macros. I can provide reference projects on request. Your questions are welcomed. Regards Zenon
$66 USD in 1 day
4.9 (32 reviews)
5.6
5.6
User Avatar
Hello, I can create a macro and find some logic to achieve the desired result. If you are interested please open a chat with me. Kind regards, Sorin
$50 USD in 3 days
5.0 (57 reviews)
5.3
5.3
User Avatar
I have the expertise in Excel VBA and can do this task, as per requirements, quickly and accurately. Ready to start work immediately.
$100 USD in 2 days
4.6 (65 reviews)
5.3
5.3
User Avatar
I'm working in a IMIS department ZTBL having a great experience of excel and use excel , word , ppt on daily basis I found myself to be the best for this project feel free to contact thanks regards Shezy
$75 USD in 3 days
4.9 (27 reviews)
4.4
4.4
User Avatar
Will do this one for a good review! Professional work, in time, with ZERO errors, for sure! We aim to be your one stop solution for ALL IT needs, and provide a 100% SATISFACTION GUARANTEE. We do not charge you, if you are unsatisfied, due to any reason, with our work. Will accept the lowest amount, you think fair. Please do give me a shot. Awaiting your response. Thanks!
$50 USD in 1 day
4.9 (14 reviews)
4.3
4.3
User Avatar
A proposal has not yet been provided
$94 USD in 3 days
4.7 (12 reviews)
4.2
4.2
User Avatar
Dear Sir, Have you got a data in your excel file ? If you already got a data can you send a file to me. If you don't a excel file. I will create it and send a data for you review. You only paid to me when I complete your project and data is ok. Thanks Phong
$66 USD in 2 days
4.7 (8 reviews)
3.8
3.8
User Avatar
Hello, my name is Rumesh. I noticed your advertisement about the project and think I would make an excellent candidate for it. I read through the job details extremely careful and I'm absolutely confident that I can do the project very well.                          THE BID PROPOSAL I will complete your job under your guidance and supervision with 100% accuracy. Why you should hire me… :- * Because I have better experiences in data entry including copy typing, MS-office ,data compiling, data processing  and of cause other manually typing works. *I am ready to work even with the lowest budget. * I'm always responsible and put my effort to hand-over the final project before the proposed date. *Revisions are always welcome until you are satisfying. *Although I handover you the completed project, if you think it wouldn't impressed you and I scammed you, don’t worry inform me, I would ready to refund your total cost honestly. Besides, I have attached some samples of my past works very similar to what you are seeking, you can check them also from here:- www.freelancer.com/u/rumesh402.html So I would like to invite you, please review my resume and contact me.                                your sincerely,                                        Rumesh
$30 USD in 0 day
4.2 (9 reviews)
2.6
2.6
User Avatar
Dear sir, As a Mathematican with 10+ year experience in Excel, I could be a good fit. Actually, last year, I did a very similar work: using Excel generate all possible team using 8+ constraints. For your work, we just input 60 players to a 5-column table. Then Click Run, within 5 seconds all possible teams will be generate bellow or in another sheet. I'll complete it with 100% accuracy within 18 hours from now. Kind regards, Francis T.
$100 USD in 1 day
5.0 (2 reviews)
1.8
1.8

About the client

Flag of UNITED STATES
Southampton, United States
0.0
0
Member since Feb 11, 2012

Client Verification

Other jobs from this client

Need 100+ CPA leads a day
$30-250 USD
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.