solver constraints

Hello Everyone, We having trouble with Excel Solver. We tryna add risks factors connected with Constraints or Objective function in given research. Unfortunately, Open Solver giving result saying that optimal solution could not be found! We wondiring that is there any easy acces or...

Hi, I am quite new here so I am not exactly sure how everything works. I just wanted to know if anyone could help me with Solver? -Given some information, I need to construct a spreadsheet and use Solver to resolve a constrained optimization problem (may be simple for some but it is my first...

Hi community, first of all, I hope I post this under the right category and that there is someone who has experience with the excel solver function. Attached, you can find: (a) an assignment we have to do for a course in university (b) my solution, which should theoretically work (also checked...

The following post will be long and I'll probably make a fool of myself explaining the rut I'm stuck in, but bear with me. It's based on analytical chemistry calculations, if that's worth anything. I have a mathematically solvable system of equations, but it relies on multiple variables that...

Hallo guys Need help in using solver or goal seek to determine revenue in a cell using solver or goal seek .Have attached the sheet .Have tried to no avail .am clueless . Kindly assist Regards Tererai

Hi everyone, I need immediate help in solving the below. Thanks in Advance I want the solver to set its "by changing" (lets say column J) and constraint range depending on the number of rows of another column, lets say B (which is not a by changing variable). The generated solutions of "by...

Hi, I have a worksheet created whereby I want to find the best spacing and associated post type that results in minimal cost that Zex>Zex Min. I haven't had any luck and was wondering if one of you legends could help. I've tried running solver as per the picture below It claims it has run...