Stack Overflow
Stack Overflow

Questions tagged [excel-solver]

22 questions
3
votes
0 answers

How to use Excel Solver for piecewise linear fit?

I am trying to use Excel Solver to get fits for a piecewise linear function (here, a three line fit). The Solver explanation here is helpful for a single linear case, but I am not sure how to set the model up "smartly" so that it re-calculates the…
a11
  • 3,122
  • 4
  • 27
  • 66
2
votes
1 answer

Pyomo and Gekko pricing values differs from Excel

I am trying to get the same result than Excel using 2 python solvers : Gekko and Pyomo. This is a non linear pricing model from the Practical_Management Science (Christian Albright)book, page 350. The solution provided by Excel is to sell my item…
harmonius cool
  • 337
  • 1
  • 2
  • 23
2
votes
0 answers

VBA Solver Loop: 'SetCell' and 'ByChange' cells changing with each loop (Excel KMV for entire row)

I am having trouble to handle a VBA loop. The Solver function on Excel allows nonlinear equation solving. I want to use Solver to an entire row on Excel (maxMinVal=2, or Minimize). After a dire search on the internet, yet no hint for my specific…
Gabriel Sabino
  • 21
  • 4
1
vote
0 answers

Excel Solver Sensitivity Report vs. Python output using PuLp

I want to create a sensitivity report in python after running an LP Model using PuLP. I need it to have allowable increase and allowable decrease values for objective function coefficients and for the RHS values on the constraints; similar to the…
KDL4ever
  • 21
  • 5
1
vote
1 answer

Run Excel Solver using Office Scripts (not VBA)

I need to automate a simple pipeline which runs the Excel Solver. I'd like to use Office Scripts (TypeScript https://learn.microsoft.com/en-us/javascript/api/office-scripts/overview?view=office-scripts). I've written a VBA script which works, but…
mherzog
  • 1,085
  • 1
  • 12
  • 24
1
vote
1 answer

Get If (condition), then (assign value), else (assign other value) statement in Linear Programming

I'm looking for a linear programming equation that satisfied the conditions; Given that all variables here are binary variables if A+B = 2; then C = 1; else C = 0 Also, if A+B+D = 3; then E = 1; else E = 0 How would one phrase this and satisfy these…
Ire Dami
  • 23
  • 3
1
vote
0 answers

Conditional Solver in VBA?

i'm facing a new problem with my excel solver. Maybe someone can help me or provide a hint? I wrote the following VBA to maximize the return of a portfolio of financial assets given a set of constraints: Dim ws As Worksheet Set ws =…
T123
  • 139
  • 8
1
vote
1 answer

Figure out the weights of a weighted average in Google Sheets or Excel

Scores in this datset in sheets are calculated using a weighted average of 4 variables in columns B:E. The weighted average is the same for each line. Given several lines of scores and variables, how can the weights be discovered in excel or…
MMsmithH
  • 323
  • 1
  • 8
1
vote
2 answers

Finding best result with Excel Solver using integers for input (linear equation)

I have a stock of four products with a defined amount avaible and a defined unitary price. From the client I receive a flat amount of money for the products. Given this amount I have to find the best combination of products to get reach the closest…
lowleopard
  • 17
  • 3
1
vote
2 answers

Non-linear optimization from excel to R

Problem: Find optimal discount for each product such that spend budget is fully utilized. In simpler terms, I need to maximize sales by changing discount with the following constraints: min discount <= discount <= max discount spend_value <= 100 …
nikn8
  • 1,016
  • 8
  • 23
0
votes
1 answer

Do we need to adapt the VBA excel solver to work with German excel?

I'm working on an excel tool which calls an Excel solver from VBA. This tool is used by colleagues in different countries. I'm trying to improve the old VBA code so that: it uses the range names instead of hardcode cell (so that the code will be…
stf_xa
  • 1
  • 1
0
votes
1 answer

Excel : Simple example but Excel Solver can't find feasible solution

I want to make a travel plan using Excel Solver to decide which city to visit in order and how long to stay. I'm going to leave from city A and come back to city A. Below table shows the airfare for moving from one city to another, and the cost of…
dms_gg
  • 1
  • 1
0
votes
0 answers

Is Excel Evolutionary Algorithm similar to DEoptim in R?

I am trying to solve a minimization problem using DEoptim in R. Previously, I used Excel's Solver tool, particularly the Evolutionary Solver technique. But the results from DEoptim don't match and are found often provide answers close to the given…
Mrinmoy Chakraborty
  • 1
  • 1
0
votes
1 answer

Simplex LP Value of in Pyhton

Use Python for solving a Linear Programming porblem with the objective being a Value of: x Hello people of internet I'm having trouble with a process I'm trying to automatize in Python it´s a LP problem I found Simplex LP method in Solver from Excel…
Armando Fuentes
  • 11
  • 1
0
votes
0 answers

Optimization of Non-linear Equation using Scipy Solver

import numpy as np import sys import pandas as pd from scipy.optimize import * import matplotlib.pylab as plot SigG = 162.4 M2 = 30 SigS = 111.7 Rmv = 26 kN2E6 = 6.13 func = lambda SigA : 1-(((SigA/SigG)**M2) + (((SigA/(kN2E6+(10.0**-23))) + SigS)…
Pavan Sai Jagarlamudi
  • 3
  • 3
1
2