In the six steps above, we have specified the constraints.īack to the Solver dialog, click Solve and then click OK for the keep solution option. Finally, in the Constraint textbox, type 300 Again click the cell-picker for Cell Reference and select cell B4 for the volume. Click the Add button in the Subject to Constrain area.Ģ. In the three steps above, we have specified the variablesġ. The range labels appear in the textbox to the left of the cell-picker. The dialog turns into a thin stripe again and press and drag to select the range B1 to B2 and press at the keyboard.ģ. Click the cell-picker for By Changing Cells as shown in figure below:Ģ. In the four steps above, we have told Solver that the target is the surface area which is to be kept minimum.ġ. The address of the cell appears in the Set Target Cell area.īalloon 4. Select cell B5 for the surface area as shown in figure and press at the keyboard.īalloon 3. Start the Solver and when the Solver Parameters dialog appears, click the small cell-picker shown with label 1 in figure.īalloon 2. The Excel Solver also speaks in terms of targets, constraints and variables.Īssuming that you have entered both the formulas correctly, proceed as follows…ġ. We need to vary the radius and height of the cylinder such that surface area is minimum and at the same time, volume should always stay above 300 ml. This is the target.Īlso, volume of cylinder should not be less than 300 ml. Since, raw material (aluminium sheets) is to be kept minimum, surface area for the can should be minimum. We want to minimize surface area for a volume of 300 by varying both the radius and height parameters to their optimum values. This will result in 942.48 for the volume and 534.07 as surface area. for volume will be = 3.14159*B1*B1*B2Īnd that in cell B5 ie. The radius and height are plain values, while, the volume and surface area are formulas.Ī = ( The curved surface ) + 2 ( cap surface ) To begin with, enter arbitrary values like 5 for the radius of can and 12 for height.
Excel solver install#
In the worst case, ask your IT administrator to run the Office setup again and install the Solver Add-in for you.Īs shown in figure, enter a few labels and values to describe the parameters of a can (cylinder). If not, click the Browse… button and locate the file LibrarySOLVERsolver.xlam from under the folder where MS Office is installed on your system. Solver sould be listed in the available Add-ins. Under the Manage list, select Excel Add-ins and click the Go button. To view Excel options, just as in Solid Edge, click Excel’s Application icon and select Excel Opt ions at the far bottom side of the menu. Solver should be listed with an icon that looks like a blue question mark with an arrow.Īnother place to check and if required install is under Excel Options. Start Excel and look in the Data tab – Analysis group. It is not installed by default, so chances are you may not have it if you did a Typical install of Excel. Also, the minimum volume to hold is 300 ml.įirst of all, I want to introduce you to the Excel Solver. The cans are made of premium quality aluminium sheets, so raw material is a concern. They supply around 60,000 cans per week to the local soft-drink bottling plants. I am contacted by the design office of an aluminium can manufacturer.
Excel solver how to#
How to drive a Solid Edge part from an Excel Spreadsheet.
0 kommentar(er)
