it's way more than just math in a spreadsheet, it actually computes EVERY option and finds the "optimal" solution.


we learned this in a class I was taking, it's pretty dang cool, if you ever have to figure out something complex.

all you have to do is change any parameter, and click SOLVE again, and it shows you all the options and how it plays out.

it's really helpful if you have the option of lowering costs in one area, but that results in a increase/decrease of assets/profits


we made another spreadsheet for a "make / buy" situation, where if you had an order for 30,000, but could only make 15k, and had to sub contract out the rest, and it automatically shows the options.

it's pretty dang powerful.


Bakery example of Microsoft SOLVER:


Basically,
You set all the constraints to be "less than or equal to" all your available assets,
click TOOLS and SOLVER.
And you ask SOLVER to maximize block D6 by changing block B5 and C5, while keeping the constraints less than the available assets.
that way, you can add or delete labor, material, parts, whatever, and juggle around the cost of supplies to see which is more profitable.
you can click TOOLS, SOLVER, and add or change the constraints. You can even Minimize or maximize the target block.
I put in 2 spare lines, in case you wanted to add more options/constraints.



here's how to load solver:
The Solver Add-in is a Microsoft Office Excel add-in (add-in: A supplemental ... program that is available when you install Microsoft Office or Excel. ...

http://office.microsoft.com/en-us/ex...215701033.aspx

if someone wants to host up the excel file, LMK

its neat.

 

Prepare to be assimilated.... Resistance is futile!

I will check into that as I write a lot of syntax with multiple math equations and variables for monitoring gas well production.. Things like this makes you wonder at times how far artificial intelligence has evolved.


Thanks for the link!

 

shoot me your email in a PM, and I will send you that sheet.

it's pretty easy to work,
and even easier to mess up

 

Well at least we now know how far Realistic Stupidity has evolved.