Custom VBA for calculating nutritional requirements

$30-250 SGD

进行中

已发布

大约 8 年前

$30-250 SGD

货到付款

In short: I need a VBA code which will calculate combinations (Excel already can do this via the COMBIN function) AND display all possible combinations in an output column (Excel cant seem to do this) Example: Each day, it is recommended that we consume 10,000 units of Vitamin A and 3,000 units of Vitamin B 12. So I want to find out what is the MINIMUM amount of fruits I need to eat to satisfy my Vitamin A and Vitamin B 12 requirements. I also cannot exceed the recommended units. So for example, I cant overdose and eat more than 15,000 units of Vitamin A, which is more than the recommended 10,000 units of Vitamin A. TWO CONDITIONS (VBA Code should be able to accept more than 2 conditions, I used 2 conditions here as an illustration) for output answer: 1. Less than or equal to 10,000 units of Vitamin A 2. Less than or equal to 3,000 units Vitamin B VARIABLES (3 are listed here as examples, in reality I have about 200 types of fruits): 1. Mango – 2000 units of Vitamin A, 200 units of Vitamin B 12 2. Apple – 100 units of Vitamin A, 800 units of Vitamin B 12 3. Watermelon - 300 units of Vitamin A, 500 units of Vitamin B 12 The VBA Code will run and then display ALL POSSIBLE PERMUTATIONS that satisfy the TWO CONDITIONS. For example: Mango Watermelon Apple Combination 1 5 4 0 Combination 2 3 1.2 4 Combination 3 Combination 4 And so on

Excel

项目 ID: 9926270

关于此项目

22提案

远程项目

活跃8 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

颁发给：

@npltg

Thank you that you described the project good enough to understand exactly what you want. I think it is an easy project so my bid is low. It can be done easily and fast. All you will have to do is to click a button and a new spreadsheet will appear having all the correct fruit combinations. Your file has to be turn into a macro-enabled excel file. In case you don't want me to change the original file this can be done in a different way. All you will have to do is to press a key combination (example: ctrl+a) and the result will appear on the original file on a second sheet. If you choose the second option, then you have to make by yourself some changes in an excel startup file, following my instructions. Also you will be able to run this code (using : ctrl+a) from any other excel file that have similar data Thank you Nikos Pitsiladis

$46 SGD 在3天之内

4.8

(2条评论)

1.3

22威客以平均价$90 SGD来参与此工作竞价

@ParisPallas

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).

$100 SGD 在6天之内

5.0

(636条评论)

8.6

@Teloquence

EXCEL/VBA expert at you service. Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

$250 SGD 在0天之内

4.9

(330条评论)

7.7

@MohsanEijaz

I have experience in MS Excel, VBA Programming, XML, MS Work, Google Docs, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz

$56 SGD 在3天之内

5.0

(96条评论)

6.9

@cugamelover

I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I've done a lot of similar work. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please let me know the details. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/

$120 SGD 在2天之内

4.8

(179条评论)

7.2

@kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 65 projects, almost 60+ are complex VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.

$55 SGD 在3天之内

4.9

(83条评论)

6.1

@expertatwork

Hey there... Yes, we can write VBA that can project number of fruit combinations for Vitamins....Please reply.. We can discuss further and hopefully get it started soon... Thank you..

$48 SGD 在1天之内

4.8

(155条评论)

5.9

@archanaoswal

I have excellent command on MS Excel. I have completed complex projects in Excel before involving Userforms, Macros, formulas, graphs etc. For instance - Build a reservation system - Build a complex shift allowance calendar and calculator You can see the reviews of the same in my profile

$80 SGD 在2天之内

4.8

(81条评论)

5.9

@sorinacho88

A proposal has not yet been provided

$56 SGD 在2天之内

5.0

(72条评论)

5.6

@surekash7096

I have the expertise in Excel & scripting in VBA and can do this task quickly and accurately, as per specification. Ready to start work immediately.

$56 SGD 在1天之内

4.6

(65条评论)

5.3

@agragaurav

Your examples do not look right. While your are talking about keeping the count <= limit, your examples actually overshoot the limits.

$150 SGD 在2天之内

4.9

(11条评论)

5.0

@d2imatrix

Hi, We are experts in VBA. We had done lot of works in automation. Kindly message us for discussion. Regards, Pal

$56 SGD 在4天之内

4.9

(24条评论)

4.9

@teeares

I have created many macros. I am sure that I can get a solution for this. However, please clarify whether the consumption of Vitamin A & Vitamin B12 should be less than or equal to 10,000 & 3000 respectively or exactly equal to those figures. I think it shpuld be the latter

$155 SGD 在3天之内

4.5

(50条评论)

5.0

@prabakarm23

I have 6 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details

$166 SGD 在5天之内

5.0

(48条评论)

4.6

@serdaryalcin

Hi, I can do it. But I can do it only with integers. If we go with decimals like example 2, the results would be way much. Is it a homework. If it is so, I will not accept if I am awarded. Regards,

$70 SGD 在3天之内

5.0

(25条评论)

4.6

@Mufaddalsaifee

Hi There, I can develop a VBA code for you which will calculate nutrient needs . Previously i have developed a code which will paste email ids in CC everytime if email is sent and also if email having attachment is arrived then it will save it into specific folder. i am expert in Macro programming in outlook and Excel. please share the details with me. i have also developed one script which checks the date of antivirus and if last update date was 30 days before then system get shutdown with message to connect with support team. Please provide me opportunity to work with you. Thanks, Mufaddal

$41 SGD 在3天之内

4.9

(26条评论)

4.5

@tandonshailendra

Please specify the max and min limit of Vitamin A and Vitamin B12 in the combination in the excel sheet I am proficient in Excel Macro, Pivot table, dashboard, functions and formulas. About Myself Good Day!. Let me introduce myself for building your confidence in me. Worked at Sr. position with experience of marketing, Service, Production and IT Excel Expert Group Member Access Expert Group Member Worked on Macro, VB, Pivot, User Form Proficiency in Office tools ,SAP, AutoCAD, 3DMax, Coral, Qualification- Mechanical Engineer Available on Skype Some Projects: Developed complete ERP system for Marketing in DB4 (earlier to Access) SAP implementation as Key Coordinator Community Survey (Near 10 Million Data compilation) in Excel Industrial Project Report in Excel Multilingual Kazien Sheet in Excel with VB Offer Preparation in Access Project Planner in Excel Very Large Database Analysis Completed few Contests at Freelancer For Details of my Work 1. Please see my profile 2. Please see Services offered by me. If you initiate dialog, I can submit samples of my work. It will be pleasure working for you. I believe in Customer Delight.

$36 SGD 在1天之内

3.9

(9条评论)

3.5

@haseriki2001

I believe i am the best candidate for this project because i have more than enough hands on experience in entering and processing data using Microsoft Excel/VBA. I also pay good attention to speed, details and accuracy when working with data

$41 SGD 在5天之内

5.0

(1条评论)

0.6

@Pranavvinod

Hi Team, With many years of experience on Excel & VBA, I believe I can take up this work and complete the same with in the stipulated time and quality. Please feel free to reach out to me on +919916503991, if you have any queries. Regards, Pranav

$70 SGD 在3天之内

0.0

(0条评论)

0.0

@federsolutions

Dear Employer, Greetings from Feder solutions! We are a team of technology professionals based out of Germany and India. Our team boasts diverse skill sets including expert level excel skills. I have clearly understood your requirements. I am confident we can write the necessary code and deliver the file in the format you require. Please note, that we can commence work immediately. Kindly revert with your queries and I will be happy to respond. Thanks and Regards, Rani Ramakrishnan, Feder Solutions Note: Bid Value is negotiable

$83 SGD 在3天之内