Editing Data

You can edit the data on your worksheet. This is your local copy of the data, and any changes you make to this data will be reflected in your analysis when you click on Compute Outputs.

You can add additional rows or columns in your data table. You can also delete rows within your table or move your table to another location in the workbook.

Note that changing a table name or the table header row may cause problems if you have already used the old table name or header row in your analysis. When you click on Compute Outputs to regenerate analysis results, the data it needs for the analysis may no longer be found. Always set the table and column header name before you use it for analysis.

• Related Articles

• Data Sheet

  While your data can be on any worksheet within a workbook, we recommend placing all data related to your project on the Data Sheet. A Data Sheet is a special worksheet that contains your data. To create a Data Sheet, click the Data button on the main ...

• Importing Data

  If your data is in another workbook, you can copy and paste your range or table from one workbook to another. Select your data or table, click on Ctrl-C to copy the data to the clipboard, go to the target workbook Data Sheet, and then click on Ctrl-V ...

• Data Tables

  Any data you wish to explore must be in Excel tables. All tables have a name and a header row containing the column's name. A table can host any data type - like dates, text, or numbers. All columns of the table have the same number of rows. If you ...

• Main Menu Bar

  The software is an add-in within Microsoft Excel. When you open Microsoft Excel, you should see the software on the main menu bar. Click on the Sigma Magic button to load the software into memory. This will open the Sigma Magic menus as shown in the ...

• Specifying Analysis Setup

  If you want to specify the options for any analysis, you can click on the Analysis Setup button on the main menu bar. Depending on the worksheet that is currently active, the analysis setup will be displayed for that worksheet. For example, if you ...