Find Jobs
Hire Freelancers

Custom VBA for calculating nutritional requirements

$30-250 SGD

W trakcie realizacji
Opublikowano około 8 lat temu

$30-250 SGD

Płatne przy odbiorze
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
Identyfikator projektu: 9948609

Informację o projekcie

3 ofert
Zdalny projekt
Aktywny 8 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
3 freelancers are bidding on average $93 SGD for this job
Awatar Użytkownika
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 w 1 dzień
3,9 (9 opinii)
3,5
3,5
Awatar Użytkownika
HI I AM A CHARTERED ACCOUNTANT AND I HAVE FOUR YEARS EXPERIENCE IN ACCOUNTING AND TAXATION
$111 SGD w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
function, and program code
$133 SGD w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga INDIA
India
0,0
0
Członek od sty 7, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.