Find Jobs
Hire Freelancers

Automate Excel Solver Opensolver VBA -- 2

$10-30 USD

Concluído
Publicado há aproximadamente 8 anos

$10-30 USD

Pago na entrega
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 do Projeto: 10038622

Sobre o projeto

8 propostas
Projeto remoto
Ativo há 8 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
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 em 1 dia
5,0 (2 avaliações)
1,7
1,7
8 freelancers estão ofertando em média $27 USD for esse trabalho
Avatar do Usuário
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 em 1 dia
4,8 (160 avaliações)
5,8
5,8
Avatar do Usuário
I can do it for you quickly and exactly .
$50 USD em 2 dias
4,9 (62 avaliações)
5,2
5,2
Avatar do Usuário
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 em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
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 em 0 dia
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
Wetumpka, United States
5,0
46
Método de pagamento verificado
Membro desde out. 29, 2004

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.