This project should be rather easy for someone that knows excel, vba, and automating solver (open solver add-in, [login to view URL]).
I have a model I am happy with.
The model produces a set of selections (a group) from a data set on the same sheet.
Currently I run the solver, manually copy the results (the group) 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.
I have another workbook that does something similar I can show as an example. I can also make a quick video to explain exactly what I am trying to accomplish.
We can discuss more on chat before you start.
SECOND Part:
I also need a separate macro on it's own workbook that will remove all duplicate results. Brief explanation - I will have a bunch of other results along with the results you are producing above that I would like to paste all in a separate workbook, and remove duplicate groups.
I have opensolver addin permanently installed.
[login to view URL]
Here are some code references that don't make sense to me, but should to you:
[login to view URL]
[login to view URL]
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-$30. 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!
Hi Dave. I'm pretty sure I can leverage the code I produced before to automate step 1...
For step 2, I'll modify the 'equivalence' function I wrote for the previous exercise... some tweaks will likely be needed (obviously there is a new source...) , but I'm pretty certain we can build a composite results set with no duplicates.
$30 USD за 1 день
5,0 (2 відгуки(-ів))
1,7
1,7
8 фрілансерів(-и) готові виконати цю роботу у середньому за $27 USD
Hey there.. thanks for detailed description,..Yes, please make a video that will make things easier to grasp....Please reply.. We can discuss further and hopefully get it started soon... Thank you..