# solver

1. ### Hours Needed per Product Per Month - Solver

Hi. I need some help on this solver problem. I am trying to understand how many hours I need to run my machines to meet my demand per month per run mode. Below are the TONS per month required along with the product name: Sales Part Number Jan Feb Mar Apr May Jun Jul Aug Sep...
2. ### Integrating VBA to Solver

hi I need to solve this formula using Solver and vba. Pi = Ni^k (power k) Applied to this example: 1.51 3.69 5.30 (in columns D2, E2, F2 respectively) Where Ni represents (1/1.51), (1/3.69),(1/ 5.30), individually . There are 2 competitors, n. N = Sum of the 3 Ni(s) k is derived as: Log n...
3. ### Using Excel solver (or other method) with a common objective in multiple cells by changing the same variables, subject to constraints

Hi, I am struggling with quite a complex problem in which I think I may be able to solve or at least partially solve using the Excel solver tool. I am trying to set up a design of experiments analysis in which I have a number of parameters at two levels. I have one specific objective which I...
4. ### Solver with a for each loop

I have a worksheet that tries to find multiple optimal values based on a cell that changes each time in a range. I want to maximize the "profit" whi;e changing the blue cells. ( spreadsheet and corresponding formulas shown below.) does anyone know how i could loop solver to figure out each of...

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...
6. ### Using named ranges in Solver VBA

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...
7. ### Excel Solver Question - production scheduling

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...
8. ### SOLVER: How to call a VBA subprocedure after each solver iteration?

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...
9. ### VBA prompted Solver to generate efficient frontier in equity ptf management - code issue

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...
10. ### VBA: Macro calculations done in seperate sheet

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...
11. ### Solver VBA - Changing variables in column

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...
12. ### Solver with rounding issues and running very slow with integer constraint

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...
13. ### Putting an equation into solver

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.
14. ### Using binary variables in the Excel solver without making the problem unsolvable

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...
15. ### Solver question

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...
16. ### Solver Question

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...
17. ### Excel Solver Question

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...
18. ### Issue with Solver Using VBA

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...
19. ### Solver macro

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...
20. ### Identify numbers that net to zero in column

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...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...