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: 9926270

Informację o projekcie

23 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
Przyznano:
Awatar Użytkownika
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 w 3 dni
4,8 (1 opinia)
1,4
1,4
23 freelancers are bidding on average $93 SGD for this job
Awatar Użytkownika
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 w 0 dzień
4,9 (302 opinii)
7,5
7,5
Awatar Użytkownika
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 w 2 dni
4,9 (86 opinii)
6,4
6,4
Awatar Użytkownika
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 w 1 dzień
4,8 (118 opinii)
5,6
5,6
Awatar Użytkownika
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 w 3 dni
4,9 (55 opinii)
5,4
5,4
Awatar Użytkownika
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 w 6 dni
4,8 (60 opinii)
5,6
5,6
Awatar Użytkownika
Hi, We are experts in VBA. We had done lot of works in automation. Kindly message us for discussion. Regards, Pal
$56 SGD w 4 dni
5,0 (23 opinii)
4,8
4,8
Awatar Użytkownika
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 w 1 dzień
4,9 (32 opinii)
4,6
4,6
Awatar Użytkownika
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 w 3 dni
4,4 (38 opinii)
4,6
4,6
Awatar Użytkownika
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 w 3 dni
4,9 (19 opinii)
4,0
4,0
Awatar Użytkownika
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 w 5 dni
5,0 (25 opinii)
4,0
4,0
Awatar Użytkownika
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 w 3 dni
5,0 (16 opinii)
3,9
3,9
Awatar Użytkownika
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 w 3 dni
4,9 (6 opinii)
2,4
2,4
Awatar Użytkownika
Your examples do not look right. While your are talking about keeping the count <= limit, your examples actually overshoot the limits.
$150 SGD w 2 dni
4,8 (2 opinii)
1,9
1,9
Awatar Użytkownika
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 w 2 dni
5,0 (2 opinii)
1,2
1,2
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ń
4,2 (2 opinii)
1,5
1,5
Awatar Użytkownika
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 w 5 dni
5,0 (1 opinia)
0,6
0,6
Awatar Użytkownika
A proposal has not yet been provided
$56 SGD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
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 w 3 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$155 SGD w 3 dni
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga SINGAPORE
Singapore, Singapore
0,0
0
Zweryfikowana metoda płatności
Członek od gru 28, 2015

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.