Suoritettu

Excel VBA, All possible combinations given certain criteria -- 3

I need help to create an Excel VBA script that produces an amount of possible combinations with certain criteria regarding salaries and points.

I will provide a list in excel that will include 3 columns: name, salary, and points. This script should generate from 1 to 150 outcomes while picking 6 names but staying between $37,000 and $50,000 total salary. The outcomes need to sort by highest possible points first.

If this project is successful, there will be other similar projects for you to bid on.

Criteria:

The total salary for each 6 name combination cannot exceed $50,000 and go no lower than $37,000.

A name cannot be used more than once in the same output.

I would like the ability to select how many outputs to generate, from 1 to 150.

I will provide the list to the winning bidder. I want this to be something that I can easily run on my own as I add new names and salaries. This needs to be finished by Thursday, Feb 23 or Friday Feb 24 2017 at the latest.

Taidot: Excel

Näytä lisää: all possible combinations given a constraint, vba read data excel project, vba picture size excel, vba word powerpoint excel thumbnail image, vba populate msproject excel, vba provider access excel, add vba creator microsoft excel, excel project vba import, vba front end excel spreadsheet, vba export contacts excel, vba project data excel, vba create xml excel, access vba open format excel spreadsheet, vba excel project beginning, vba links website excel, update vba excel project, vba write xml excel, vba word output excel file, vba access similar excel, vba split separate excel

Tietoa työnantajasta:
( 1 arvostelu ) Chicago, United States

Projektin tunnus: #13169340

Myönnetty käyttäjälle:

cgullapalli

Hi, I am good at Excel combination algorithm and building useful scripts for my clients. I just checked the description you have provided regarding the project and would be a pleasure to assist you on your proje Lisää

$100 USD 2 päivässä
(686 Arvostelua)
0.0

37 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

$55 USD 3 päivässä
(13 arvostelua)
0.0
abupabuya

hi sir i had very high and fresh quality list may be u interested of it [login to view URL] 240,000 email list [login to view URL] [login to view URL] 200,000 email list htt Lisää

$150 USD 3 päivässä
(21 arvostelua)
0.0
draco77

Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, write VBA code to create some kind of optimized list meeting given criteria. Is that sounds about right? I have an extens Lisää

$40 USD 2 päivässä
(16 arvostelua)
0.0
stanleyw12

Hi Sir Your job is simple. Let me help you with this.

$30 USD 1 päivässä
(0 arvostelua)
0.0
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format Lisää

$50 USD 1 päivässä
(10 arvostelua)
0.0
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . Recipes Mana Lisää

$30 USD 1 päivässä
(52 arvostelua)
0.0
vivirain

Hi there, I'm interested in the job and can help get it done within 1 day. Feel free to contact me an discuss more details. Look forward to hearing from you soon. Best Regards, VL

$80 USD 1 päivässä
(10 arvostelua)
0.0
JLQ006

Hi, I am an excel expert specializing in VBA macro. I can finish the job in a day. Thanks and best regards, John

$111 USD 1 päivässä
(16 arvostelua)
0.0
deepbluetech

Hi, I am an Excel VBA expert and can handle the project requirements. Also, I have been involved in some similar projects earlier. Shall try to make the solution user friendly. Let me know. Regards, Arul

$150 USD 3 päivässä
(167 arvostelua)
0.0
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macr Lisää

$88 USD 2 päivässä
(62 arvostelua)
0.0
vsprybhanu

Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I can complete your job by Thursday 23rd Feb. I have excellent knowledge and experience of Manipulating Data from Multiple S Lisää

$120 USD 2 päivässä
(43 arvostelua)
0.0
rafeemd

I have sound experience (5+ years) in Excel/MS Access/Data Entry and Visual Basic for Applications development and ability to learn new task quickly. I am efficient and Trustworthy.

$110 USD 3 päivässä
(2 arvostelua)
0.0
sonarkaushik

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

$99 USD 2 päivässä
(42 arvostelua)
0.0
alfredltk

I am experienced in IT Infrastructure management and integration, business analysis and troubleshooting. I have been working in Excel VBA and formula helping multiple colleagues in different companies, so as to autom Lisää

$55 USD 3 päivässä
(0 arvostelua)
0.0
nevo1234

Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel free to contact me over Lisää

$111 USD 3 päivässä
(12 arvostelua)
0.0
zolibara

Hello, I have great experience in creating VBA macros that process big excel lists, filter them based on certain criteria, sort them, and so on. I can show you some of my work. Thank you if you chose me. Best regard Lisää

$50 USD 2 päivässä
(6 arvostelua)
0.0
VladimirLilenko

A proposal has not yet been provided

$50 USD 2 päivässä
(11 arvostelua)
0.0
CarlosRocha001

A proposal has not yet been provided

$100 USD 2 päivässä
(0 arvostelua)
0.0
mzdesmag

Dear client i can provide complete solution on your project as i have executed it before. My commitment lies in honesty, integrity, ethical code of conduct, efficiency and speedy respond, i love to work hard to meet Lisää

$30 USD 1 päivässä
(1 arvostelu)
0.0
HaykDag

Hello, I can write a macrc code by vba for your excel as you want. I can do it about in 2 hours if it intested you can send me the file and you will give me the job when I send you the finished work.

$55 USD 1 päivässä
(5 arvostelua)
0.0