Project Files

You can save your projects in Excel workbooks.  Click the New button on the main menu bar to start a new project.

This will open a new Excel workbook with two specific worksheets. The first is the summary worksheet, which contains a summary of all the analyses stored in this workbook; the second is a data sheet worksheet, which can be used to store all the data used in the project. The figure below shows a new project workbook with the two worksheets.

1. 
   

By default, the project workbook is opened as a Project#.xlsx file. Note that this project file does not contain any macros stored in them. You can change the optional setting to open the project as a macro-enabled workbook, such as Project#.xlsm. This file can contain macros. To change this setting, click Options > General Settings > Project Files. You can specify whether you want to work with the default *.xlsx files or macro-enabled *.xlsm files.

If you specify macro-enabled files, it contains two functions added to the project file:

1. Close all dialog boxes before closing the file
   
2. Change the menu bar at the top depending on which worksheet is currently active

These functions can make it simpler to work with Sigma Magic project files. However, if you don't want to work with macro-enabled files, you can perform these actions manually using the following buttons. Use the Close button to safely close a Sigma Magic project file by closing any open dialog boxes, and use the Refresh button on the right to refresh the menu bar if you change the Sigma Magic worksheet.

• Related Articles

• Project Details

  Click on the Details button to add a Project Details worksheet to your project. This will add a new worksheet to your workbook. You can enter the details about your project on this worksheet. An example of a completed worksheet is shown below. The ...

• Software Options

  The software options contain generic settings that apply to all analyses. To access this dialog, click the Options button on the main menu bar. Install Settings A sample dialog box of the install settings is shown below: Release Shared License: If ...

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

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

• Export PPT File

  You can export the analysis that you have performed from Excel to PowerPoint by clicking on the Export button on the main menu bar. When you click on this button, the following dialog box is opened: You can specify which sheets you want to export ...