Find Jobs
Hire Freelancers

Automate Excel Solver Opensolver VBA -- 2

$10-30 USD

Завершено
Опублікований about 8 years ago

$10-30 USD

Оплачується при отриманні
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!
ID проекту: 10038622

Про проект

8 пропозицій(-ї)
Дистанційний проект
Активність 8 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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..
$29 USD за 1 день
4,8 (160 відгуки(-ів))
5,8
5,8
Аватарка користувача
I can do it for you quickly and exactly .
$50 USD за 2 дні(-в)
4,9 (62 відгуки(-ів))
5,2
5,2
Аватарка користувача
Determine to do the job with accuracy ,efficiency and dedication at a given time, and also will meet the expectation for the work done. Thank you.
$23 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I can start working on your project right now. If you are interested please start a chat with me. Kind regards, Sorin
$20 USD за 0 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
Wetumpka, United States
5,0
46
Спосіб оплати верифіковано
На сайті з жовт. 29, 2004

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.