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

Ταυτότητα εργασίας: 9926270

Σχετικά με την εργασία

23 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 8 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο 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

(1 αξιολόγηση)

1,4

23 freelancers δίνουν μια μέση προσφορά $93 SGD για αυτή τη δουλειά

@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

(302 αξιολογήσεις)

7,5

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

(86 αξιολογήσεις)

6,4

@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

(118 αξιολογήσεις)

5,6

@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

(55 αξιολογήσεις)

5,4

@paris2785

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 ημέρες

4,8

(60 αξιολογήσεις)

5,6

@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 ημέρες

5,0

(23 αξιολογήσεις)

4,8

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

(32 αξιολογήσεις)

4,6

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

(38 αξιολογήσεις)

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

(19 αξιολογήσεις)

4,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

(25 αξιολογήσεις)

4,0

@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

(16 αξιολογήσεις)

3,9

@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 ημέρες

4,9

(6 αξιολογήσεις)

2,4

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

(2 αξιολογήσεις)

1,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 ημέρες

5,0

(2 αξιολογήσεις)

1,2

@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 ημέρα

4,2

(2 αξιολογήσεις)

1,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

@sorinacho88

A proposal has not yet been provided

$56 SGD σε 2 ημέρες

0,0

(0 αξιολογήσεις)

0,0

@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 ημέρες