![]() ![]() In this case, Solver needs to decide how many of each item to buy. ![]() To get Solver to work, you need to provide it with a range of cells it can set with decisions. If you don't know how to make a copy of a sheet in Excel, you simply right-click the tab you'd like to copy and select the Move or Copy menu. Make a copy of the Calories sheet in the Concessions.xlsx Excel workbook, name the sheet Calories-Solver, and clear out everything but the calories table on the copy. ![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |