Excel VBA macro calling Solver for simple optimization
€8-30 EUR
Paiement à la livraison
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
Nº du projet : #12201032
À propos du projet
Décerné à:
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
13 freelances font une offre moyenne de 21 € pour ce travail
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 Plus
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 Plus
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.
Hi, Please provide the sample file and I will do it for you. Let me know if you have question. Thanks Rajeev
I have the required expertise for developing your project. Check developed projects and reviews of my portafolio.
- good in excel vba, formulas, functions, and excel solver optimization solutioning - ensure data accuracy and deliver on time
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 Plus
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 Plus
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 Plus