Excel VBA macro calling Solver for simple optimization

Imekamilika Ilichapishwa Miaka 7 iliyopita Kulipwa wakati wa kujifungua

€8-30 EUR

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

Write a macro that calls the Solver for an optimization.

Solver params:

- maximise one cell

- by changing 20 cells

- constraints

sum of the 20 cells =1

one max value for each modified cell

one min value for each midified cell

The example spreadsheet will be provided

This is a very small project for anyone used to Excel VBA and Excel Solver

Excel Visual Basic

Kitambulisho cha Mradi: #12201032

Kuhusu mradi

13 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya Taisho
Taisho

Hello, I can prepare such Solver through VBA macro optimization. I made macros like this, to select the most profitable option with Solver in my past projects. Regards

€17 EUR kwa siku 2
(Maoni 55)
4.9

13 wafanyakazi huru wanazabuni wastani wa €21 kwa kazi hii

Picha ya Profaili ya schoudhary1553
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 o Zaidi

€30 EUR kwa siku 1
(Maoni 315)
7.8
Picha ya Profaili ya paris2785
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled (VBA) Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach y Zaidi

€30 EUR kwa siku 3
(Maoni 204)
7.3
Picha ya Profaili ya ksriniravi
ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporti Zaidi

€30 EUR kwa siku 1
(Maoni 184)
6.8
Picha ya Profaili ya macroPOL
macroPOL

Hello, I am Excel and VBA expert. Can you provide example file? I can start now. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

€29 EUR kwa siku 1
(Maoni 95)
6.0
Picha ya Profaili ya The24CarrotsInc
The24CarrotsInc

A proposal has not yet been provided

€10 EUR kwa siku 1
(Maoni 69)
5.8
Picha ya Profaili ya ksinghrajeev
ksinghrajeev

Hi, Please provide the sample file and I will do it for you. Let me know if you have question. Thanks Rajeev

€30 EUR kwa siku 2
(Maoni 14)
4.1
Picha ya Profaili ya yh2013
yh2013

I have the required expertise for developing your project. Check developed projects and reviews of my portafolio.

€14 EUR kwa siku 3
(Maoni 11)
3.7
Picha ya Profaili ya vw896424vw
vw896424vw

- good in excel vba, formulas, functions, and excel solver optimization solutioning - ensure data accuracy and deliver on time

€14 EUR kwa siku 1
(Maoni 3)
1.4
Picha ya Profaili ya iftekhertalukder
iftekhertalukder

Hello, I am able to do the work on your project ensuring accuracy and meeting all your requirements and deadline. Send me the project details to complete the project soon. For a big project; I have a team of ten member Zaidi

€13 EUR kwa siku 1
(Maoni 1)
0.5
Picha ya Profaili ya vurititeja128
vurititeja128

Hi this Ravi. I am working in testing from last 5 years. I use the excel macros every day to day work. till now I created different types excel VBA macros. I would like work with you if you are interested. please let Zaidi

€12 EUR kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya Aikipanda
Aikipanda

1-click to solve the linear programming problem after change each modified cell, using vba for backend work, will keep flexibility to identify all the conditions (if more than 20 cells in future, will still work withou Zaidi

€19 EUR kwa siku 1
(Maoni 0)
0.0
Tuma Mradi Kama huu