Help Manual


Sigma Magic Help Version 15



The New button can be used to add a new workbook to Excel. Click on the New button within the Manage Files menu on the main menu bar. Main Menu


You can use the New menu button to create a new project. By clicking this button, a new workbook is added to Excel and two worksheets or tabs are opened by default. The first is the Data Sheet where you can specify the data for your analysis and the second is the Summary Sheet which contains a summary of the analsyis you have performed on this project.

Initially, both of these worksheets are blank and you will need to fill them up as you work on the project.


This section contains some frequently asked questions. If you have other questions about this module, please contact technical support.
Do I still have to use "New" to create a workbook if I have an existing workbook?

You could choose to open and work with an existing workbook. New analysis worksheets will just be appended to existing worksheets in the workbook. If you don't have an existing workbook and want to store all analysis related to your project, you can create a new workbook.

Can I create a new workbook using the Excel functionality to create new files?

You could also create a new workbook by using the Excel menu to create a workbook. However, make sure that the file you have added has the proper extension. If you want to share your workbook with users who may not have the latest version of Excel, use the Excel 97-2003 file format (*.xls). If you want to use the latest format, make sure to use the Excel format (*.xlsm) so that you can also store macros in this workbook. Macros are used to detect if you have made any changes to the input area so that you can remember to update the output calculations.

Should I create a new workbook for each new analysis I want to perform?

You can use a single workbook for all your analysis. It is better to store all the analyses you perform on one project in a single workbook so that all related analyses are stored together. Of course, it is your choice of how you manage your project files. If you have a single workbook, each analysis could be stored on a different worksheet in this workbook.