solver

Excel Solver question: The University of Western Football Team has hired a dietician from a big name American school to develop a nutritious lunch menu for the team. After consulting with Canada’s Food Guide and other sources, the dietician has determined that each lunch serving should have...

Hi, I want to run Solver from VBA, and I would like to vary the "ByChange" cells depending on certain conditions in other cells. (This is to minimise the number of ByChange cells, and remove any redundant cells i.e. ones that definitely will have no effect on the target cell). This means that...

I'm trying to teach myself to use Excel solver to take the work out of manually calculating minor production details. but am struggling. Say I have a make to order job with 7 sizes and I want to run them on 5 machines. I would like the solver to find the optimal order to run them given 5...

Hi Mr. Excel, I've scoured the internet and can't find the answer to this question. Everyone seems to get stuck in the same place (case #1, case #2, case #3, case #4). The guidance for the SolverSolve function indicates that you can use ShowRef to pass a macro/sub into Solver after each of...

Dear All- short intro first. I am a prof of Finance in a Business School and teach portfolio management to master students. In this context, I develop concepts around efficient frontier. I would like to show my students how an efficient frontier could be built out of excel using solver and VBA...

Dear VBA Masters, I'm doing my first steps in VBA and I am stuck for days now with something that might have a simple solution. I have built a Solver macro, that is running and attached to a button in a sheet named "Consolidated Financials". It helps me to optimize some financial parameters in...

Hi, looking for some help with this Solver VBA. Here's what I'm trying to do: 1) "Set Objective" is equal to the value in cell D3 2) "Value of" is equal to the value in cell D1 3) "By Changing Variable Cells" - this range in column D (starts on D4) changes according to the number of rows in...

Hi, I'm trying out Solver and it's very very slow! My test spreadsheet has 25 rows of test data and it ran over 30 minutes and froze all the other Excel screens, so I finally ended the task. It probably would've ran for 2 hours if I let it. Part of the issue is, the constraint is set to...

Hello, I need to input equations into solver in Excel (Its easy to do most of these outside but the automation is helpful) For example $120=$93.50*X+(S:S)*($3000-X) How would I type this equation into Excel to have it solved. NOTE: In this case S will be from a list of Values.

This is a bit of an unusual post, aimed at people familiar with optimization problems solved by the Excel solver (or Add-ins like OpenSolver) In the attached Excel file, I simulate the following simple scenario: A house consumes electricity from the grid for 24 hours. The amount of...

Hi All, I am trying to create a file which helps me make the most optimal filling order. It is most optimal if I minimize the switching time. When I use the solver add in to fill in the order i won't change anything. The file that i want to create is something like this table below hwere...

I cannot for the life of me find a good resource on how to effectively use solver to "solve" my problem. Column B has projected points, and column C has a corresponding salary. The goal is to maximize total projected points while not using more than 50k in salary and must use 6 players...

Hello- I am stuck on Excel Solver question. I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary...

I am using VBA to automatically enter maximum & minimum constraints for a cells value in Excel's solver. I have named ranges in the worksheet that I use to input a user defined maximum/minimum for the value. It works for every value except when the user places "40" in the cell. When 40 is the...

Dear Excel community Goal I'd like to write a VBA macro using Solver. I've no previous experience with macros. I am looking for a dummy guide please. Solver input Set Objective: 'Calc optimised'!$J$14 To: Min By changing variable cells: 'Calc optimised'!$E$3 Subject to the constraints...

I'm trying to reconcile accounts that have multiple transactions that net to zero. Often there can be 1-4 numbers in the credit column that equal 1-4 numbers in the debit column. Is there a formula or can I utilize solver to help identify all the numbers that net to 0? <tbody> Transaction Date...

Hi everyone, I have a question regarding the use of excel solver in maximizing a cell with three parameters. I am trying to solve a three parameter maximum likelihood in excel. However, every time I tried to solve it, excel said that the solver encountered an error value in the objective or...

Hello All- I'm hoping you can help me get to the bottom of a solver issue. I have a simple workbook that I created several years ago. After a few recent modifications, it no longer works. I get the "solver encountered an error in the objective cell or a constraint cell" error and cannot...

Hi there, I am trying to use Solver for portfolio optimization. I'm using 9 stocks and Solver runs fine when I try to optimize for the lowest monthly draw-down using all 9 stocks (it gives a weight to each stock from -1 to 1. Where I run into an issue is if I add a constraint that requires that...

Hi everyone, i have a dataset containing funds, their monthly returns and cashflows. It's a long data structure, so i have multiple rows for each fund. Then i have to solve an Equation with solver for each fund. I want to calculate an internal rate of return using the formla...