Automate Excel Solver Opensolver VBA
$10-30 USD
货到付款
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!
项目ID: #9980900
关于项目
有4名威客正在参与此工作的竞标,均价$25/小时
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. 更多