# Solver

## A collection of 7 posts

Excel macro that solves 154 sudoku puzzles
13 April 2022
Use the solver in Excel to find the number of units to ship from each factory to each customer that minimizes the total cost. Formulate the Model The model we are going to
27 October 2020
Use the solver in Excel to find the shortest path from node S to node T in an undirected network. Points in a network are called nodes (S, A, B, C, D, E
27 October 2020
Sensitivity analysis gives you insight in how the optimal solution changes when you change the coefficients of the model. After the solver found a solution, you can create a sensitivity report. 1. Before
27 October 2020
Use the solver in Excel to find the maximum flow from node S to node T in a directed network. Points in a network are called nodes (S, A, B, C, D, E
25 October 2020
Use the solver in Excel to find the combination of capital investments that maximizes the total profit. Formulate the Model The model we are going to solve looks as follows in Excel. 1.
24 October 2020
Use the solver in Excel to find the assignment of persons to tasks that minimizes the total cost. Formulate the Model The model we are going to solve looks as follows in Excel.
24 October 2020