Hello,
I am fairly new to using Solver in VBA, hence the question.
I have a subroutine which implements an algorithm to print the final results (10 values in 10 different cells). The results depend on 6 assumed parameters within the algorithm. I was planning to use Solver to optimize on these assumed parameters, in order to arrive at the exact results (10 values) I want to achieve. From my understanding, Solver can be used in Excel if the cells referenced in 'Set Objective' have a formula. Can we also use Solver if the cells referenced in 'Set Objective' do not have a formula but are the results from a subroutine in excel VBA.
I would be using the following logic:
1. 'SolverAdd' to add the 6 parameters and set constraints on them.
2. Use the algorithm (instead of a cell formula) to arrive at the results (10 values). Compare with the required results I am hoping to achieve.
3. Use solver to change the 6 parameters.
4. Iterate between 2 and 3 to get the required results.
It would be great if someone can let me know whether this can be done using Solver, OR if there is a different tool in Excel that I can make use of. Any suggestions are appreciated.
Thank you,
VJ
I am fairly new to using Solver in VBA, hence the question.
I have a subroutine which implements an algorithm to print the final results (10 values in 10 different cells). The results depend on 6 assumed parameters within the algorithm. I was planning to use Solver to optimize on these assumed parameters, in order to arrive at the exact results (10 values) I want to achieve. From my understanding, Solver can be used in Excel if the cells referenced in 'Set Objective' have a formula. Can we also use Solver if the cells referenced in 'Set Objective' do not have a formula but are the results from a subroutine in excel VBA.
I would be using the following logic:
1. 'SolverAdd' to add the 6 parameters and set constraints on them.
2. Use the algorithm (instead of a cell formula) to arrive at the results (10 values). Compare with the required results I am hoping to achieve.
3. Use solver to change the 6 parameters.
4. Iterate between 2 and 3 to get the required results.
It would be great if someone can let me know whether this can be done using Solver, OR if there is a different tool in Excel that I can make use of. Any suggestions are appreciated.
Thank you,
VJ