by Nate Moore | Feb 27, 2013 | Uncategorized
Solver isn’t limited to just solving equations for a certain value, like 6 months in our examples so far. Solver can also find minimum and maximum solutions, as we’ll see in Excel Video 336. This time instead of trying to pay for our equipment in 6 months, the...
by Nate Moore | Feb 25, 2013 | Uncategorized
In Excel Video 335 we’ll talk about Solver reports and how to use those reports to document how Solver was set up. The first thing to say about these reports is that they’re way beyond the scope of what I try to do in these Excel Videos. If you’re interested in...
by Nate Moore | Feb 20, 2013 | Uncategorized
Some of the real power of Solver comes when Solver can’t find a solution. I’ll show you what I mean in Excel Video 334. In today’s example, the number of patients decreases so much that even after changing the reimbursement and the cost of the equipment, Solver can’t...
by Nate Moore | Feb 18, 2013 | Uncategorized
Goal Seek is great, but as things get more complex, Solver can help you in Excel Video 333. We’ll start with one more Goal Seek example, but as the examples get more complicated, the challenge is that Goal Seek can only change one variable at a time and you can’t put...
by Nate Moore | Feb 13, 2013 | Uncategorized
Excel Video 332 has more Goal Seek examples. I’ll also spend a minute demonstrating how complicated your spreadsheet could get if you try replicate everything that Goal Seek does. It’s much easier to maintain one formula to manage all of the variables than to try to...
