Spreadsheet Ribbon

The Spreadsheets ribbon provides a way to access all the Data Entry spreadsheets in the model, as well as various tools to manipulate spreadsheet values. If you do not have a spreadsheet open, the only option on this ribbon is the Data Entry button, which allows you to open a spreadsheet. Once you open a spreadsheet, you have various tools, pertinent to that spreadsheet, available to you. For example, if you open the Materials Spreadsheet, the Spreadsheets ribbon looks like the following image.

Click on image to enlarge it

The following table provides a list of the various tools on the Spreadsheets ribbon (when a spreadsheet is opened) and their descriptions.

Icon	Tool	Description
	Data Entry	Allows you to select to open one or more spreadsheets from a list of all the Data Entry spreadsheets. The tool displays a list of all the Data Entry spreadsheets and whether or not they are currently open. A check in the checkbox indicates that the spreadsheet is open.
	Filter Input	Allows you to filter graphically selected elements in the Data Entry spreadsheets. Choose to filter selected or unselected elements from the Data Entry spreadsheets. This is useful when you want to focus on the inputs for a specific portion of the model.
Row Operations These tools are only available if a Data Entry spreadsheet is open.
	Add Row	Allows you to add a single row. The tool adds a new row to the bottom of the spreadsheet.
	Insert Row	Allows you to insert a single row. The tool inserts a row above the currently selected row in the spreadsheet.
	Delete Row	Allows you to remove a single row. The tool deletes the selected row from the spreadsheet.
	Delete Selected Rows	Allows you to remove several rows at once. The tool deletes all selected rows from the spreadsheet.
Clipboard These tools are only available if a spreadsheet is open.
	Copy	Allows you to copy spreadsheet information from one or more cells. The tool copies the information in the selected cells which can then be pasted into other cells, or outside of the program.
	Copy with Headers	Allows you to copy spreadsheet information with the column header descriptions. Choose this tool to include the column header descriptions with the spreadsheet information when pasting outside of the program.
	Paste	Allows you to paste spreadsheet information into the selected cells. Once data has been copied to the clipboard, the data can be pasted into the selected cells, or outside of the program.
	Select All	Allows you to select all cells at once. Choose this tool to select all data in the spreadsheet.
Results These tools are only available if a Results spreadsheet is open.
	Ignore After	Allows you to exclude all results after the current item. The tool removes spreadsheet information for the results after the current item selected in the active spreadsheet and reduces the size of the results output. These elements are still present in the analysis.
	Show All	Allows you to include all results in the spreadsheet. The tool includes all previously excluded results in the spreadsheet.
	Clear Results	Allows you to delete all solution results.
	Export to Excel	Allows you to export a Results Spreadsheet into an Excel spreadsheet.
Data Operations These tools are only available if a Data Entry spreadsheet is open.
	Fill	Allows you to fill all selected cells with a common value. Select the cells you want to fill, then type in the value you want to fill them with.
	Math	Allows you to perform math on the currently selected cell(s). You can add, subtract, multiple or divide the cell(s) by a specific operand.
	Check/Uncheck	Allows you to check or uncheck selected cells in a Results spreadsheet. Select any cells containing a checkbox in the spreadsheet to check/uncheck. The tool reverses the existing condition.
Formatting These tools are only available if a spreadsheet is open.
	Increase Font	Allows you to increase the size of the font in the spreadsheet.
	Decrease Font	Allows you to decrease the size of the font in the spreadsheet.
	Reset Widths	Allows you to reset the width of the columns in the spreadsheet. When selected, this tool resets the width of the columns in the spreadsheet to the program defaults.
	Sort	Allows you to sort information/data by a selected column in the spreadsheet. Select a column header in a spreadsheet and click this tool. Then, choose high to low or low to high to reorganize the spreadsheet based on the sort selection in that column.
	Find & Replace	Allows you to search for and replace selected information. This tool searches for the data in the current spreadsheet and replaces it with the selected data. This tool is only available when working with a Data Entry spreadsheet.
	Save as Defaults	Allows you to save common entries as the default values in a spreadsheet so that they are readily accessible for new, future models.
Graphical Highlight These tools are only available when you select one or more rows in a spreadsheet.
	Select	Allows you to select marked lines in the current model view. You can quickly select elements in the model view that correspond to the marked lines in the spreadsheet.
	Unselect	Allows you to unselect the marked lines in the current model view. You can quickly unselect elements in the model view that correspond to the marked lines in the spreadsheet.

For more details about the various options on the Spreadsheets ribbon, see Spreadsheet Operations.