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

$30-250 USD

已完成

已发布

大约 7 年前

$30-250 USD

货到付款

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.

Excel

项目 ID: 13169340

关于此项目

36提案

远程项目

活跃7 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@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 project. I will work with full dedication to give you the best output within the desired timeframe. I look forward to hear from you. Looking forward to discuss in the chat. and a long term relationship ahead. Wishing you a great day ahead. https://www.freelancer.com/u/cgullapalli.html#/profile-reviews Regards, Chandra

$100 USD 在2天之内

5.0

(1099条评论)

8.3

36威客以平均价$98 USD来参与此工作竞价

@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 Graduate with an MBA degree. If you see I am among niche bidders who 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. Pay me only when your job is 100% done. Also I will provide you with a sample work before you consider awarding me the project. Thanks, Jay

$200 USD 在3天之内

5.0

(838条评论)

9.0

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

$155 USD 在3天之内

4.9

(454条评论)

8.3

@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, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, dynamic dashboard, and graphs. Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards.

$200 USD 在3天之内

4.9

(93条评论)

7.5

@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天之内

5.0

(173条评论)

7.4

@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 deliver as soon as possible. Thanks

$199 USD 在3天之内

4.8

(92条评论)

7.1

@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天之内

5.0

(44条评论)

6.6

@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. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$150 USD 在3天之内

4.9

(115条评论)

6.3

@VladimirLilenko

A proposal has not yet been provided

$50 USD 在2天之内

4.9

(106条评论)

6.4

@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 macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls(e.g. number of outputs) if necessary. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards

$88 USD 在2天之内

4.9

(64条评论)

5.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 Sheets, Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I will give you access to enter records as many as you want and program will update it automatically. So, you can handle this program easily. I have done mostly this type of job where data manipulation is required. Please check my portfolio to see my work. Ready to start please reply soon. Thanks, Virendra

$120 USD 在2天之内

4.8

(98条评论)

5.8

@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. with thanks and regards

$99 USD 在2天之内

4.6

(43条评论)

5.6

@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天之内

4.5

(50条评论)

5.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 extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Best regards, Rafael Ps. This could be one of my first projects on Freelancer.com, so give me the chance to proof that i'm really good business partner.

$40 USD 在2天之内

4.9

(16条评论)

4.5

@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 the deadlines and take a project to the next level. Do not hesitate to contact me to discuss your project in details and determine how my skills will positively contribute to you. Let my service makes a positive and lasting impression.

$30 USD 在1天之内

4.9

(7条评论)

4.3

@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 the web site chat for further details your description is not clear - especially how are the names been picked? random? brgds. Itay

$111 USD 在3天之内

5.0

(12条评论)

4.3

@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天之内

4.9

(11条评论)

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天之内

5.0

(18条评论)

3.8

@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 further on this Thanks Note-please check my profile for past projects and reviews.

$45 USD 在3天之内

5.0

(7条评论)

3.5

@fb57e1f6608abfb

Hi, I have ~4+ years of experience of creating and operating low to very high complexity of Excel/VBA/SQL,SAS, Powerpoint based tools/processes, reports. I can assure you of high quality and on-time deliverable from my side as that is the sole criteria from my side to work and deliver. Hope to hear back from you soon :) #CustomerFirst Best Regards, Rohit Ahuja

$88 USD 在0天之内

5.0

(7条评论)

3.5

@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 regards, Zoltan

$50 USD 在2天之内