Tool buttons, Excel

To perform the analysis, enter the data into an Excel spreadsheet (start at the top left-hand comer cell Al), then select the ANOVA Single Factor option from the Tool Menu. Select all the data by entering B 2 E 6 in the input range box (or select the data using the mouse). Now ensure that you select the Grouped By Rows Radio Button, as the default is to assume the data are grouped in columns (remember we want to... 

A significant change was made in the appearance of Excel s menus in Excel 2000. The default for menus is that they display recently used commands first, with a drop-down button at the bottom of the menu to display the remaining commands. If you prefer to work with "old style" menus, choose Customize... from the Tools menu, choose the Options tab and uncheck the Menus Show Recently Used Commands First box (Figure 1-9). 

When you press ENTER, the "Cannot resolve circular references" message is displayed. To force Excel to evaluate the circular reference, using the results of the previous calculation cycle as start values for the next cycle, choose Options...from the Tools menu and choose the Calculation tab. Check the Iteration box and enter 0.000001 in the Maximum Change box. (The default settings are Maximum Iterations = 100 and Maximum Change =. 001.) When you press the OK button the circular reference will be evaluated. The results of the calculations are shown in Figure 10-12. 

Excel Tip. If you have trouble locating the code module containing your macro, here s what to do "when all else fails" choose Macro from the Tools menu and Macros... from the submenu. Highlight the name of the macro in the Macro Name list box, and press the Edit button. This will display the code module sheet containing the Visual Basic code. 

In Excel 97 and later versions, browse in Tools => Customize to see (and select) your Toolbars and their Commands. You can click on a command and then use the button to get its Description. 

In Excel 97 and later versions, embedding a button in a toolbar can be done quite easily, by adding two small macros that operate automatically whenever a workbook is opened or closed. The following macros, when added to the macro Interpolate ), will insert a button labeled Interpolation in the Tools menu when a workbook is opened that contains this macro, and will remove the button again upon closing that workbook. 

Highlight the location where you want the solution. Click on the button on the Standard Tool Bar. Follow the Excel instructions to enter the appropriate variables. 

When finished with its evaluation, Aspen IPE displays a window that contains an executive summary of its results. This window is not shown here. Note that when the user presses the Tools pulldown menu, selects Options, and then View Spreadsheet in Excel, Aspen IPE is activated to prepare several spreadsheets, including the Equipment Summary, Utility Summary (available in Version 12.1), ProjSum, Executive Summary, and Run Summary spreadsheets. For the details of these spreadsheets, see the Aspen IPE User s Guide (press the Help button and follow the path Aspen Icarus Process Evaluator User s Manual —> Evaluating the Project Reviewing Investment Analysis). 

This is a particularly interesting feature that is widely used along the examples. It is the tool we can use within Excel to solve numerically a set of equations, problon optimization including fitting a set of data to a given linear and nonlinear equation and more. Solver is an add-in that needs to be activated to be used. For enabling it, we need to click on Office Button (top-left comer), then Excel Options, and in the Tab Adds-Ins, click on bottom go (Manage Excel Adds-Ins) there, look for... 

---