To start, download a copy of the Calories spreadsheet from the book's companion website at - use the download link for chapter 1. ![]() What's the fewest number of items you can buy from the snack stand to achieve that? Obviously, you could buy 10 ice cream sandwiches at 240 calories a piece, but is there a way to do it for fewer items than that? On Mac, Solver is added by going to Tools then Add-ins and selecting Solver.xlam from the menu.Ī Solver button will appear in the Analysis section of the Data tab in every version.Īll right! Now that Solver is installed, here's an optimization problem: You are told you need 2,400 calories a day. Check the Solver Add-In box and press OK. ![]() On Windows, Solver may be added in by going to File (in Excel 2007 it's the top left Windows button) > Options > Add-ins, and under the Manage drop-down choosing Excel Add-ins and pressing the Go button.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |