Find Jobs
Hire Freelancers

Excel Solver VBA

£20-250 GBP

Completed
Posted almost 7 years ago

£20-250 GBP

Paid on delivery
I have an excel spreadsheet with solver set up to optimise the number of points a fantasy football (soccer) team scores by selecting players according to constraints. This works fine other than one constraint that I can't seem to get to work. I would like the solver to be able to output more than one line up (e.g. the most optimal line up, second optimal line up etc.) in a timely manner up to 100+ results and put the teams into a new worksheet. I believe the solution to this is write a loop VBA code but I am uncertain. I would also like to add a constraint so that a specific player(s) of my choosing will only be selected in no more than a certain % of teams.
Project ID: 14297412

About the project

20 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
Awarded to:
User Avatar
Dear , I have experience with Solver & VBA .Could help you to make it done in a short time
£83 GBP in 2 days
4.6 (13 reviews)
3.9
3.9
20 freelancers are bidding on average £120 GBP for this job
User Avatar
Hello Sir, My name is Jay and I am #1 Excel VBA programming expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). About Me - I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required in advance, please pay me once the job is 100% complete. Also I will provide you with a sample work before you may please consider awarding me the project. Thanks, Jay
£150 GBP in 3 days
5.0 (782 reviews)
8.6
8.6
User Avatar
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
£140 GBP in 3 days
4.9 (373 reviews)
8.1
8.1
User Avatar
Hi, I’ve read your proposal regarding Football Prediction Model By Excel Solver. I am highly qualified for this project and would like to see the Excel file to estimate my work. I am a guru in Excel, and I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Application including preparation of dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts. More on that, I develop financial modules including business valuation methodology & ratios (INPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE, SPV FVC, sensitive analysis, correlation, and regression, etc.)Therefore, I can help you design, build or modify spreadsheets in Excel to deliver professional analysis and reliable functionality suited to your needs.
£250 GBP in 3 days
4.9 (92 reviews)
7.2
7.2
User Avatar
Dataentry; Database; Data processing; Scraping; Datawarehouse management; Monitoring protocols; Management of corporate information databases; Market analysis; Record linkage; PDF to Excel; PDF to Word; VBA; Acces; Macro; Statistical databases integration, Trasform PDF data to csv, Excel, stata, spss format.
£150 GBP in 3 days
4.9 (149 reviews)
6.7
6.7
User Avatar
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. Lets discuss more online on chat. Thanks, Abhinav
£122 GBP in 1 day
4.9 (167 reviews)
6.5
6.5
User Avatar
Hello. I have extensive experience in Excel, Coding and Data processing.I can do your project in less than a Day according to your description with full delivery and without error. I would also complete your project with the highest precision and quality.
£90 GBP in 1 day
4.9 (141 reviews)
6.2
6.2
User Avatar
we have expertise in this domain(web scraping , Excel VBA , data processing , data entry). Client satisfaction is our main motto for long term relationship.
£80 GBP in 3 days
5.0 (45 reviews)
6.3
6.3
User Avatar
- Have done similar gaming solution for Soccer based on the logic needed by User, Horse Racing - Identifying the best horse based on calculations Gaming Solution - Identifying the best player in an online game Based on parameters. All above are Freelancer projects that I have done. - - 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.
£100 GBP in 5 days
4.6 (51 reviews)
6.1
6.1
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
£99 GBP in 1 day
4.6 (52 reviews)
5.8
5.8
User Avatar
Sir, I reviewed your job description and am very interested to work with you. I can complete with fast and accurately. Please consider my bid. Thanks........Shariful
£155 GBP in 2 days
5.0 (45 reviews)
5.4
5.4
User Avatar
Hi, I’ve 5 years of experience of MS Excel especially with pivot tables, charts, advance formulas and VBA codes. Do let me know of further details.
£111 GBP in 3 days
4.5 (37 reviews)
5.3
5.3
User Avatar
Hi! I can help you. Is VBA a requirement? I can use C#/Python which could provide better and faster results. Please PM for details. Regards, Usama
£80 GBP in 1 day
5.0 (2 reviews)
3.7
3.7
User Avatar
Hi, I'm a statistical engineer, check my profile and don't hesitate to contact me, I have a set of skills that can provide value to your work . I'm not an intermediate, I'm working on my own. I have created some high level complex Excel Workbooks and VBA Macros of several processes in my career . I can analyze your data with a greater accuracy. I will provide a quality output and want to business with you for a long period.
£90 GBP in 3 days
5.0 (2 reviews)
2.9
2.9
User Avatar
A proposal has not yet been provided
£132 GBP in 5 days
5.0 (2 reviews)
2.2
2.2
User Avatar
Hi, I will work as per your direction. I ensure you the accuracy of my work. I am ready to start working. I am waiting for your response to start working. Thanks
£100 GBP in 3 days
5.0 (2 reviews)
0.7
0.7

About the client

Flag of UNITED KINGDOM
Kent, United Kingdom
5.0
5
Payment method verified
Member since May 24, 2016

Client Verification

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.