solver accurcay

  1. D

    Is it possible to use Solver on multiple problems within same worksheet using VBA?

    Is it possible to use solver on multiple problems in the same worksheet within a workbook using VBA?: http://www.mrexcel.com/forum/showthread.php?t=612713 I am using MS Excel 2007.
  2. H

    problems with Solver

    Hi. I'm trying to use Solver to calculate the least number staff to cover a specified Required staff at half hour intervals. I'm probably using solver incorrectly (!) but the answer it provides is way off being optimized. The data I have is quite simple: Column A: time of day in half hour...
  3. B

    Solver does not calculate the minimum

    i have three different ranges: BC1:BH1, contain values (f.e. yields) CI1:CL1, contain some parameter values to start CO1:CT1, each contains (different) formula using above CI1:CL1 parameters. Formula look like CI1+(CJ1-CI1)*(1-EXP(-0.5/CL1))/.... CN1, contains SUMMYXMY2(CO1:CT1, BC1:BH1)...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top