Data Sheet

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 menu bar.



This will add a new worksheet for you in the current workbook. Sigma Magic only has one Data Sheet for each project. So, if you click on the Data button again, it will not create a new Data Sheet for you but will take you to the existing Data Sheet. You can use this button to quickly move between your analysis worksheet and the data sheet.



Notes

Placing your data on the Data Sheet will help you locate your data faster in your project workbook.



    • Related Articles

    • Summary Sheet

      Click the Summary button on the main menu bar to add the summary sheet to your workbook. Following is an example of the summary sheet. The summary sheet lists all the analyses you have performed in your project. In the above example, 19 different ...

    • 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 ...

    • 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 ...

    • 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 ...

    • Analysis Summary

      You can view a summary of all the analysis performed in your workbook by clicking on the Summary button on the main menu bar. An example output of the summary page is shown below: The summary sheet contains the following columns: A brief description ...