I'm trying to perform the solver function to identify excel entries that add to a specific value with GRG non-linear resolution method in R, but so far I can't find specific information about it. The problem is almost the same as the following exercise enter link description here, except for the method that would be GRG non linear. So my question is related to whether there is a package in R that allows solving it in the same way that excel does, because so far I have not been able to find it. Maybe it is something easy to solve, but I still can't do it. Thank you very much in advance
Asked
Active
Viewed 49 times
0
-
You are likely to get quicker and more help if you provide sample input data and sample expected output. (and any code you are working with) Also, avoid screen shots for data and code. Use code formatting option (Ctrl^K) as needed. – Shan R May 15 '20 at 14:53
-
I would suggest to first write down the mathematical model. Once you have that, it is easier to see what type of solver you need. – Erwin Kalvelagen May 15 '20 at 22:10
-
@ShanR Thanks for your advice, I will edit my question so that it is better understood – boris_traveler May 17 '20 at 17:14
-
@ErwinKalvelagen Thanks for your suggestion, I will edit my question so that it is better understood what I am looking for – boris_traveler May 17 '20 at 17:38
-
R has its own packages for optimization. I don't see any point in using R to run Excel's Solver. Grab the data that you need from Excel and then invoke R's tools. Using GRG non linear for a subset-sum problem also sounds weird. Subset-sum is a classic NP-complete problem. It can be solved as an integer programming problem, but I don't think that continuous variable optimizers are very helpful. It is a thoroughly discrete problem. – John Coleman May 17 '20 at 22:26
-
@JohnColeman Thank you very much for your answer professor. He helped me a lot to support the fact that it was not a good idea to do this procedure in R. Very grateful for your help. – boris_traveler May 19 '20 at 14:05