Käynnissä

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

About the Employer:
( 1 review ) 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ä
(355 arvostelua)
7.2

38 freelanceria on tarjonnut keskimäärin 98 $ tähän työhön

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Lisää

200 $ USD 3 päivässä
(399 arvostelua)
7.8
180 $ USD 2 päivässä
(246 arvostelua)
7.6
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ä
(159 arvostelua)
7.0
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Let us discuss more details so that I can estimate cost and time better. I have completed more than 300 projects. Plea Lisää

150 $ USD 3 päivässä
(103 arvostelua)
6.1
schoudhary1553

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

155 $ USD 3 päivässä
(109 arvostelua)
6.2
DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I can create a VBA macro able to simulate all possible combinatios according to the criteria. I can guarantee an excellent job and deli Lisää

199 $ USD 3 päivässä
(64 arvostelua)
6.4
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 do ne 100 works on Freelancer where majo Lisää

200 $ USD 3 päivässä
(74 arvostelua)
5.8
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ä
(59 arvostelua)
5.7
wsh2

Goal Seeking project due Feb 23. Greetings from Easton PA, USA.. {smile} Highly experienced (25+ years) MsEXCEL Business System, Programming, and Database expert with Guru / Mentor level technical credentials at Lisää

114 $ USD 3 päivässä
(27 arvostelua)
5.7
100 $ USD 1 päivässä
(81 arvostelua)
5.9
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ä
(39 arvostelua)
5.5
abupabuya

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

150 $ USD 3 päivässä
(21 arvostelua)
4.8
axiomswb

I have expertise in excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Thank you..

50 $ USD 1 päivässä
(14 arvostelua)
4.9
dgled

I create all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards. I am a specialist in financial reports, budget, costing reports, inventories, Lisää

200 $ USD 3 päivässä
(13 arvostelua)
4.7
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ä
(33 arvostelua)
4.3
teeares

PLease provide the spreadsheet as it is not clear what "points" is. IF I take the 2 constraints of 50,000 and 37000 only, then it is possible to generate infinite number of salaries.

100 $ USD 3 päivässä
(46 arvostelua)
4.8
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ä
(17 arvostelua)
4.1
50 $ USD 1 päivässä
(12 arvostelua)
3.9
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ä
(7 arvostelua)
3.2
sambestsolutions

Hi I am an Engineering undergraduate with exceptional skills in mathematics. I am well experience in using excel for maths related calculations and data analysis. I can do this for you. Please message to discuss furth Lisää

45 $ USD 3 päivässä
(3 arvostelua)
2.6