Automate Excel Solver Opensolver VBA

Completed Posted Mar 18, 2016 Paid on delivery
Completed Paid on delivery

This project should be rather easy for someone that knows excel, vba, and automating solver (open solver add-in, [url removed, login to view]).

I have a model I am happy with.

The model produces a set of selections from a data set on the same sheet.

Currently I run the solver, manually copy the results to another "Results" sheet, manually change a couple constraints (as well as modify the data set based on the initial first results)... then I run the model again, manually copy results to the other "Results" sheet again, change constraints, run, copy, and so on about 30-100 times. Once I have completed the process, there are some duplicate results on the "Results" sheet I have copied the results to which I find manually to remove any duplicate sets.

Also, sometimes (rarely) opensolver gives an error dialog box that says constraints could not be met, I ignore those results, don't copy, and move on to the next part of the process.

I would like automate all of the above.

We can discuss more on chat before you start.

I have opensolver addin permanently installed.

[url removed, login to view]

Here are some code references that don't make sense to me, but should to you:

[url removed, login to view]

[url removed, login to view]

I am available for chat and any questions you have during your build, and I am very easy to work with, check my feedback. I pay right after completion... and VERY rarely will bother you after I make sure everything works. Again, check my feedback.

I really do not want to spend more than $20-$25, unless I have worked with you. I will have more projects on this spreadsheet if you do a good job.

I think you should be able to complete this job quickly, it's not hard if you know your stuff.

I will provide the spreadsheet after I have a quick chat and selected you.

Thanks!

Excel Visual Basic

Project ID: #9980900

About the project

4 proposals Remote project Active Mar 18, 2016

Awarded to:

tonycoyle

I've written many Excel automation tools, some exceedingly complex. many follow your outline (do X, copy a selection of results data to another tab) repeated multiple times. I assume from your description you wou More

$25 USD in 2 days
(0 Reviews)
0.0

4 freelancers are bidding on average $25 for this job

bytessolution

Greetings. I specialize in provide solutions for Business Administration, Data Base management, Key Performance Indicators design, Supply Chain Planning and Project Management for commercial and industrial companies. More

$25 USD in 2 days
(2 Reviews)
2.8