Hey guys,
running into a problem with solver. i run the solver, and it returns numbers that are not rounding, which dramatically affects my results.
Basically what the solver is doing is looking for the cheapest mix of cell phone plans, according to the minutes used, and 5 different plans, but because it returns in fractions of a number, the results are skewed.
i've attached.
also, anyone know how to get the solver add-in in english, mine comes up in french, not a big deal though.
Solver > Options -- make the Precision value smaller.
You should also add an integer constraint to F12:F16, and change the constraint on F17 to be >= B4
Last edited by shg; 03-21-2012 at 11:48 AM.
Entia non sunt multiplicanda sine necessitate
how do i add an integer constraint to F12:F16? sorry, my solver is in french.
Take a look at this one:
SolverWorking.xlsm
.?*??)
`?.???.?*??)?.?*?)
(?.?? (?.?Pichingualas <---
??????????????????????????
Wrap your code with CODE TAGS.
Thank those who helped you, Don't forget to add to their REPUTATION!!! (click on the star below their post).
Please mark your threads as [SOLVED] when they are (Thread Tools->Mark thread as Solved).
hey Pich,
when i run the macro i get a compile error: can't find project or library, then it stops as 'solver reset'
could it be because i'm using 2007, and you are using 2010?
Give me a minute
Try this one please:
SolverWorkingV2.xlsm
100th post lol
AHH,
hmmmmm, stops at the third line
Please do the following:
In VBA window, with the workbook you made loaded, open the object browser (F2) and look for VBA_Functions under classes and double click on it. Take an image of the "Members of VBA_Functions" screen and upload it so I can see it.
I think this problem is actually related to the fact that your solver is in french... You could also try looking at this. Maybe changing it to english will do the trick. By the way, if I were you I'd try the last of the suggested fixes.
Pleaso do what I asked in the previous post if you don't want to change Solver to english.
hey. i don't have VBA_Functions under classes?
Did you turn on solver?
I mean is solver added to references?
How can i check?
In vba window tools--->references--->check solver box (will be among the first listed)
it's not there
it says;
MISSING: SOLVER.XLA
It seems you are having problems with the instalation of the Solver add-in. To solve it go to the link i had provided a few posts back. Once you have that done, your issue should be solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks