Sigma Magic Help Version 19

Options

Overview

 The Options menu allows you to set Sigma Magic Software's default behavior. These settings are saved between sessions and will be used the next time you use Sigma Magic software.

   The options menu describes common elements that can be set once and used in future worksheets as required. For example, you can set the confidence level in the options menu once, and this value will be used in any future worksheet you create that requires the confidence level. Of course, the option's value will not affect any existing sheets that have already been created. A sample screenshot of the main menu bar is shown below.

   The Options dialog box can be opened by clicking the Options button in the Miscellaneous menu on the main screen.   

User Details

   An example screenshot of the User options is shown in the figure below. Note that for some companies, the User Details option may not be displayed due to company policy. In those cases, you will not be able to specify these details.
  

1	Options Tab: The Options tab helps you navigate between the different pages available within the Options menu. You can switch between the following pages. Option Description User Details Contains details of the user profile such as name, email, location, etc. Install Settings Contains the basic installation settings usually required during installation. General Settings Contains some basic settings for the software function, usually required to be set up during installation. External Files Specifies location of external resources like files. Thresholds Specifies the threshold values for commonly used parameters like confidence level, power, etc. Subroutines Contains helper subroutines related to this program. Reset Reset the settings back to the default values.
2	User Name: Enter the full name of the user. Note that this is an optional field; however, we encourage you to enter a name to identify the user if you need to communicate with us for any reason.
3	Email: Enter the email address you want to use. Note that this is an optional field. You cannot create tickets or receive feedback for any issues you are facing without a valid email address. We have a strict privacy policy, and your email address will not be shared with anyone. If you change your email address, click the Update button to take effect.
4	Company Name: Enter the name of your company or university. Note that this is an optional field. However, you are encouraged to enter this value so that we can better understand the types of users who use our software application.
5	Location: Enter the country where you are using this software. This is an optional field; we only use this information to aggregate the regions of the world that have installed and are using the Sigma Magic software.
6	Privacy Policy: Click the link to view our privacy statement.
7	Profile Picture: Click the image to upload a profile picture for your account. This is optional, and any image you upload will only be locally stored on your computer.
8	Reset Button: Click the Reset Button to delete and replace the current settings with the default values.
9	Help Button: You can click on the Help button anytime to view the help information on this topic.
10	OK Button: Click on the OK button to save any changes you have made to the dialog box.
11	Cancel Button: Click on the Cancel Button to cancel any changes you have made to the dialog box.

Please note that our strong privacy policy, as outlined by Rapid Sigma Solutions LLP, governs any information you submit to us. For more details, you can view our Privacy Policy on our website.

Installation Settings

   Click the Install Settings button on the right to open the Install Settings dialog box. An example screenshot of the Installation options is shown in the figure below.
  

1	Release Key: If you are using a shared multi-computer license key, then you can use this menu option to control when your computer releases the license key. Option Description Yes Release the shared license key when you log out of the Sigma Magic software. This will allow other users in the company to obtain the license key when needed, and you will no longer need to use the software. When you log back into the computer again, you must wait for another user to release the license key before using the Sigma Magic software. No Do not release the shared license key when you log out of Sigma Magic software. You would use this option to keep your existing license key allocated to your computer. Since you have not released the license key, your license is still active, and you do not need to wait for other users to release it to use the software.
2	Check Updates: This option specifies how often Sigma Magic will check for updates. Please note that our software checks for updates on our server; therefore, Internet access must be enabled to check for and download any updates.     Option Description On Startup The software will check for any available updates when you start the Sigma Magic software. When you click on Sigma Magic on the main menu bar for the first time after you open Excel. This is the recommended setting, so your software is always up-to-date with all upgrades & bug fixes. Never The software will never check for any updates. Monthly The software will check for updates to your software once per month. Note that this requires you to have opened the Sigma Magic software. If less than a month has passed since the last check, the software will not check for any updates.
3	Proxy Setting: The proxy option allows you to specify a proxy address and port, enabling your system to connect to the Internet if you are behind a firewall. A connection to the Internet is required to validate your license keys and submit any error reports to the company for resolution. If your company is behind a firewall, you can set the Proxy within the Internet Explorer software (under Advanced Settings). Sigma Magic software will automatically pick it up from the Explorer settings. If not, you can specify the proxy address here. Select the checkbox next to Proxy to indicate to the software that you must use a proxy to access the Internet.
4	Catchup Delay: Sometimes, Excel cannot copy and paste shapes from one location to another due to limited bandwidth or lack of resources. In such cases, it is helpful to add a slight delay to the loop, allowing Excel time to complete the copy-and-paste operation. You can specify the delay in seconds for Excel to complete this operation. Note that the longer the time you select here, the slower the copying operation will be, especially if you have many images to copy and paste. Start with a value of 0 and gradually increase it to the required value for your computer if you encounter problems with the copy and paste operation.
5	Menu Language: The menu language feature allows you to specify the language setting for the main menu. By default, the English language is used. If you want to use other languages for the Main Menu, place the translated files in the Languages folder within the Install directory. Any languages defined in this folder will appear in this form for selection. Please note that any changes to the language will only take effect after restarting the Excel software. The following table lists the languages currently shipped with the software.         Option Description English Shows the main menus in the English language. This is the default setting. Spanish Shows the main menus in the Spanish language.
6	Top Menus: You can use this option to specify the menus for the Tool Wizard. By default, all tools are displayed and categorized under the following sections. This option is currently not enabled at the user end to add or modify the tools in the tool wizard. Option Description All Displays a list of all available tools arranged in alphabetical order. Analytics Specifies the tools related to analytics methodology. These tools utilize the R software at the backend. Change Specifies the tools related to the change management methodology. Graph Specifies the tools related to plotting graphs and charts. Lean Specifies the tools related to the lean methodology. Projects Specifies the tools related to the continuous improvement & project methodologies. Stats Specifies the tools related to the statistical analysis methodology.
7	Default Printer: It has been observed that Excel sometimes takes a long time to complete certain tasks, and it appears to be waiting for a response from the printer. You can speed up your calculations and use Sigma Magic software by switching to the default Microsoft Print to PDF printer when using the Sigma Magic software.
8	Info Messages: You can specify how the software displays status messages. The status messages option can be used to display the progress of calculations or report any problems with data entry or analysis. The following options are available: Option Description None Status messages are suppressed and not displayed to the user. This setting is not recommended, as important system messages may be hidden. Worksheet All status messages are displayed at the top of the worksheet. You can use this option if you do not want to press the OK/Close Button on the status messages. But look for any messages at the top of the worksheet. Status Bar All status messages are displayed at the bottom status bar of Excel. You can use this option if you do not want to press the OK/Close Button on the status messages. Look for any messages at the bottom of the status bar in Excel. Popup Window All status messages are displayed using a popup window. The user may need to click the OK or Close Button to close this message. This is the recommended setting for this software.
9	Startup Messages: Option Description Yes Display the startup dialog box when the user starts Sigma Magic software for the first time. The startup dialog box allows users to create a new project file or open an existing one. No Do not display the startup dialog box when the user starts Sigma Magic software. The user can continue to work with the currently open Excel file. You can manually open the startup file by clicking the Open Button on the main menu bar at any time.
10	Error Messages: Specify how error messages should be displayed. The following options are available. Option Description None Error messages are suppressed and not displayed to the user. This setting is not recommended, as important system messages may be hidden. Worksheet All error messages are displayed at the top of the worksheet. You can use this option if you do not want to press the OK/Close Button on the error messages. But look for any messages at the top of the worksheet. Status Bar All error messages are displayed at the bottom status bar of Excel. You can use this option if you do not want to press the OK/Close Button on the error messages. Look for any messages at the bottom of the status bar in Excel. Popup Window All error messages are displayed using a popup window. The user may need to click the OK or Close Button to close this message. This is the recommended setting for this software.
11	Help Viewer: This option specifies how the help file will be displayed to the user. Option Description Offline Display the help file on your local computer using the HTML viewer. Online View the help files on the server. If you choose the Online option, the software will display the help files stored on the Sigma Magic server. The online option requires Internet access to view the help files. If you have not installed updates on your computer, the online options files may be more recent than the offline help files stored on your computer.
12	Log File: This setting enables you to save critical error information to the hard disk, which can be used to troubleshoot any issues you may encounter. No information is stored on your hard disk if you choose not to save the log file. The log file is stored in the temporary folder on your computer under the SigmaMagic folder.

General Settings

An example screenshot of the General settings is shown in the figure below.

1	Date Format:       This format will be used wherever data has to be displayed on the worksheet. Use one of the standard built-in formats or choose a "Custom" format to define your own. The following options are available. Option Description Auto The software will pick a date format for you. This is the default value. Custom You can manually specify the date format using your format. Use dd to indicate the date, mm for a two-digit month, or mmm for a three-letter abbreviation of the month, yy for a two-digit year, you for a four-digit year, hh for hours, mm for minutes, and ss for seconds. Short The date is printed as 11-10-2020 Medium The date is printed as 11-Oct-2020 Long The date is printed as 11-October-2020
2	Number Format: This format will format any numeric values printed in the output area. Use one of the standard built-in formats, or choose a "Custom" format and specify your own format. The standard format Fixed-3 means it will print all floating-point numbers using three decimal places. You can select your custom format using standard Excel functionality. Use 0 to force the printing of a digit or # to print digits where required, a period to indicate the decimal place, and E for scientific, exponential notation.
3	Graph Height: You can use this option to specify the height of the graphs on each worksheet. The graph's height is specified as the number of rows to be used for displaying the graph.
4	Graph Width: You can use this option to specify the width of the graphs on each worksheet. The width of the graph can be set to "Auto," and the system will not modify the graph width specified in the tool. The width of the graph will be set to the width of the column. However, you can choose a different width setting, and the size of the graph column can be modified.
5	Graph Spacing: You can use this option to specify the spacing between two graphs. A value of 0 implies no spacing. The larger the value, the larger the spacing between charts.
6	Graph Border Thickness: You can use this option to specify the thickness of the graph border.
7	Graph Line Thickness: You can use this option to specify the thickness of the lines used within the graph.
8	Graph Marker Size: You can use this option to specify the size of the markers used in the graph.
9	Project Files:       Specify the type of file format you want to use for your project files. This setting only takes effect when you use the New button to create new project files. The following options are available. Option Description Default Workbook (XLSX) Your project files will be saved in the default Excel (*.xlsx) format. No macros are stored in this workbook, and as such, it is safer and has limited functionality. Macro Workbook (XLSM) Your project files will be saved in the macro-enabled Excel (*.xlsm) format. An additional helper macro is saved in your workbook so that when you switch tabs, the software will automatically update the menus on the main menu bar and properly close Excel files on exit. Note that macros must be enabled on your project files to use these features.
10	Checklist Items:       Specify whether the user must complete the checklist items defined on the templates. The following options are available. Option Description Ask user Checklist items are not auto-completed, and the user has to review each checklist item and mark them as completed. Mark Completed All checklist items are marked as completed at the start, so the user does not need to answer these questions (for expert users).
11	Analysis Outputs: Specify the types of outputs that need to be displayed in the notes window. Option Description Input Summary Display a summary of the inputs used for this analysis. Assumption Checks Check the assumptions for the selected analysis and display them in the notes window. Analysis Results Display the results of the analysis in the notes window. Conclusions Display the conclusions for the selected analysis in the notes window.
12	Reset Options: You can click on this button to reset all the settings on this page to their default values. Note that there is no undo button, and once the settings have been reset, there is no way to return to the older settings.
13	Cancel Button: Click this button to discard all changes and exit the Optional settings dialog box.
14	OK Button: Click this button to accept all changes and save any changes to the settings.

External Files

   Click on the External Files button to open the dialog box for External Files. An example screenshot of the External File settings is shown in the figure below.
  

1	Project Folder: Click the Browse button to specify the default project folder. Note that you need to specify the directory of the project files. The Excel files in this folder are listed when you open a new project file.
2	Data File Folder: Click the Browse button to specify the default folder where data files are located. Note that you need to specify the directory of the data files. The Excel project files specified in this folder are listed when you open a new one.
3	Browser File:     You can specify which browser you want to use to open web content. If you leave this field blank, the Sigma Magic software will try to use Microsoft Internet Explorer. To specify this file, click the Browse button and look for the browser executable file you want.
4	RSCript File:     All Analytics tools within Sigma Magic utilize the R software in the background to perform the analysis.     R software must be installed on your computer to use this analysis. Once R software is installed, click the browse button and link the RScript.exe file to Sigma Magic. A tick mark will appear next to this row if everything works fine.
5	Worksheet Logo:     You can specify a Logo to replace the Sigma Magic logo on the worksheet. Note that this will.     Replace the logo on newly created sheets, and do not alter sheets created before the logo was modified.
5	Default File:     This field is used to set the default folder location that will be selected when     the user clicks on Open button within the Manage Files group. To change this folder, click the Browse button and select the appropriate folder. This folder should usually point to your home directory or the My Documents folder.
6	PowerPoint Template: You can specify the PowerPoint presentation template when Sigma Magic exports data from Excel to PowerPoint. This template will control the look and feel of the PowerPoint file. You can change the PowerPoint template by clicking the browse button and pointing to another template. Note that PowerPoint templates have an extension *.pot.
7	Reset Settings: You can click on this button to reset all the settings on this page to their default values. Please note that there is no undo button, and once the settings have been reset, it is not possible to return to the previous settings.

Threshold Settings

   An example screenshot of the Threshold settings is shown in the figure below.
  

1	Confidence Level: This option allows you to set the value of the confidence level. The initial default value is set at 95%. Possible values range from 0 to 100%. You can enter a value in the combo box or click on the shape to select a value.
2	Power Level: This option can be used to set the value for the Power of the test. The initial default value is set at 90%. Possible values range from 0 to 100%.
3	Model Reduction Alpha: This option allows you to set the type I error (alpha value). The initial default value is set at 10%. Possible values range from 0 to 100%.
4	MSA Alpha: This option can set the type I error (alpha value) for model reduction during MSA. The initial default value is set at 10%. Possible values range from 0 to 100%.
5	MSA Percentage Limits: This option can set the acceptable values for the Measurement Systems Analysis when the data is continuous or discrete. The default values are 70% and 90%. Anything less than 70% is unacceptable, between 70% and 90% is marginal, and greater than 90% is excellent.
6	MSA Kappa Limits: This option can set the acceptable values for the Measurement Systems Analysis when the data is nominal. The default values are 0.7 and 0.9. Anything less than 0.7 is unacceptable, 0.7-0.9 is marginal, and greater than 0.9 is excellent.
7	MSA Kendall Limits: This option can set the acceptable measurement Systems Analysis values when the data is ordinal. The default values are 0.7 and 0.9. Anything less than 0.7 is unacceptable, 0.7-0.9 is marginal, and greater than 0.9 is excellent.
8	Regression R^2 Limits: This option specifies the acceptable values for the coefficient of determination (R^2). The default values greater than 70% are considered excellent, while those less than 30% are deemed poor and unacceptable.
9	Cpk Limits: This option can be used to set the acceptable values for the process capability indices. The default values are 1.33 and 1.67. Anything less than 1.33 is unacceptable, between 1.33 and 1.67 is marginal, and greater than 1.67 is excellent.
10	Z Score Limits: This option can set the acceptable values for the Sigma level (Z scores). The default values are 3 and 6. Anything less than 3 is unacceptable, between 3 and 6 is marginal, and greater than 6 is excellent.
11	Reset Button: You can click on this button to reset all the settings on this page to their default values. Note that there is no undo button, and once the settings have been reset, it is not possible to revert to the previous settings.

Subroutines

This page contains a few helpful subroutines related to the Sigma Magic software. You will need to click on the appropriate button to launch the subroutine.

1	Install Tests: You can click this button to run multiple tests and verify that your software has been installed correctly. This test could be part of your initial software qualification tests. More details about this test are shown in the section below.
2	Validation Runs: You can click on this button to run some validation tests on your computer to ensure that the results obtained match those obtained on the development computer. You can select which tests you want to run, and the software will execute those tests, providing a report on which tests passed and which failed.
3	Methodologies: You can use the Methodologies button to define custom methodologies that are of specific interest to you. Instead of looking through a generic list of tools that may not apply to your project, you can group the tools differently to make more sense for your project. For example, suppose your team is implementing the DMAIC methodology to drive improvements. In that case, you can define the DMAIC methodology and group your company's most commonly used tools for each project phase. This will enable your team to find the tools relevant to your company efficiently. For more details about this feature, refer to the section below.
4	Scheduler: You can click on this button to add a scheduler worksheet to your workbook. A scheduler worksheet can help you automate the execution of your workbook. For example, you can use it to refresh External data, recompute analysis results, and send emails to users based on certain conditions. An application area is real-time SPC.
5	Load Settings: You can click on this button to load the settings you may have saved earlier. This could be useful if you have corrupted or want to replicate another user's settings.
6	Save Settings: You can click this button to save all your optional settings to a file. The default file name is SMSettings.ini. This file contains all the settings you have customized for your software and saves them to a file. You can reload the settings later if you need to reinstall the software or move the settings to another computer. You can also share these settings files with your friends and colleagues, allowing them to replicate your settings on their computers. Please note that some settings, such as file folders, may not function properly on other computers. For example, if your default file folder is set to C:\Users\Sam. The same file folder may not be available on another computer, as the username will likely differ. Hence, if you share the settings with other users, ensure that all personalized information, such as your specific directories, is not included in your Options settings before saving the file.
7	Shortcut Keys: You can click this button to specify the mapping for the shortcut keys. By default, the software will map the following shortcut keys on your computer. Key Action F1 Launch the help file for the selected tool. F2 Open the Analysis Setup for the selected tool. F3 Recompute the Analysis Outputs for the selected tool. F4 Open the data editor to view or edit the data available for analysis. F5 Duplicate the current tool to run what-if analysis as required. You can use the Shortcut Keys manager to map the shortcuts that are of interest or more convenient to you.
8	Fonts & Colors: You can specify the fonts and colors for various template elements, including the notes and graphs section. See the section below for more details.
9	View Log File: To troubleshoot any problems you encounter, set the Log File setting to "Yes" under the Install Settings tab. From this point forward, the software will continue to log all your steps into a log file, which is saved in the temporary folder. You can view the Log file's contents by clicking the View Log File button. You can share this log file with the developers to help them identify any problems you may face with the software. Note that enabling step logging may slow down your analysis. Hence, once your troubleshooting is completed, you should turn off the log file generation under Install Settings.
10	Unload Software: If you are not planning to use the software for a while and want to unload it from Microsoft Excel, click the Unload Software Button. This will remove the Add-In from Excel, and the Sigma Magic software icon will not appear on the Excel main menu bar. Please note that this will not remove the software from your computer or delete any associated files. To reload the Sigma Magic software, go to Excel > Options > Add-Ins and reselect the Sigma Magic software to load it back into Excel. To permanently remove Sigma Magic software from your computer, uninstall it from the Control Panel.

Install Tests

The Install Tests button helps us run pre-checks to ensure the software is properly installed. These tests may be included in your software installation qualification reports. To complete this report, open the Validation folder in your software install directory. There is a Word file that you can fill out to document your software's initial qualification. The following tests are performed when you click on this button:

#	Description
1	Check if the OS is suitable for this install. A green checkmark next to this test indicates the test has passed.
2	Check if there is sufficient disk space for this software to run properly. If the disk space exceeds the minimum requirement, a green checkmark will be placed next to it.
3	Check if the computer has sufficient memory for the software to run. If the physical memory is sufficient, a green checkmark will be placed next to it.
4	Check if this software supports the region settings on the computer. A green checkmark indicates that the check has passed.
5	Check if the Internet connection is available for the software to acquire and release licenses. A green checkmark indicates that the check has passed.
6	Check if the default Microsoft Print to PDF printer is installed on your computer (for performance-related issues). A green checkmark indicates that the check has passed.
7	Check if this software supports the Excel version of the software. A green checkmark indicates that the check has passed.
8	Check if you are currently using the latest version of the Sigma Magic software. A green checkmark indicates that the check has passed.
9	Check if R software has been installed on this computer, which is required for Analytics. A green checkmark indicates that the check has passed.
10	Run some standard function tests to see if the computer is generating outputs as expected. A green checkmark indicates that the check has passed.
11	Check if script execution has been blocked on your computer due to some IT admin policy. If so, some functions may not be available within the Sigma Magic software.

A sample screenshot of the open dialog box is shown below.  

1	Checks:     Ensure all the checks for each test are in green for a successful test installation. If any indicators display a red cross mark, you must investigate and resolve this issue before using the software.
2	Report Date:     The date this report is generated is listed on the screen for documentation purposes.
3	Camera:     Click on the Camera button to take a snapshot of the dialog box for your documentation. You can attach this image to your reports as required.
4	Help Button:     Opens the help file for this dialog box.

Validation Runs

The Validation Runs button can be used to test if the software is generating analysis results as expected. This test may be included in your software operational qualification report. To complete this report, open the Validation folder in your software install directory. There is a Word file that you can fill out to document your software operational qualification. This report outlines the user requirements and lists the available tests for this qualification. Please note that not all user requirements may apply to your situation. Modify the user requirements based on your specific needs, considering how you plan to utilize the software within your company. Depending on the user requirements you pick, test files are available that can validate these requirements. Perform those qualification tests based on your user requirements. A sample screenshot of the software operational qualifications report is shown below.     Click the Validation Runs button to perform the tests. A new workbook is opened, and a worksheet for performing the validation runs is added to your workbook. A sample screenshot of the workbook is shown below.    

1

Validation:     A blank worksheet named "Validation" is added to this workbook. The different columns that are in the validation worksheet are: # Description 1 Test Number 2 Name of the file that contains the test runs and test results 3 Name of the worksheet. Each file may contain multiple worksheets, and each worksheet contains a  unique test 4 Name of the Sigma Magic tool/template that is being tested 5 The link which you can click to be taken to that worksheet 6 The time taken in seconds to run this test on your computer 7 The result of the test - whether validated or not

2

Analysis Setup:     Click on the Analysis Setup button to open the dialog box and pick the tests to run.

A sample screenshot of the dialog box is shown below.    

1	Select Test:     Select the tests you would like to run. Note that you can only run one set of tests in each workbook. Each test contains information about the test name, the number of tests in the file, and the expected time to complete the tests.
2	Run Tests:     Click the Run Tests button to run the tests. The software will run the tests and update the Validation worksheet.

The following tests are available in this folder:    

Test	Description
Anal 01	Factor Analysis, Cluster Analysis, Correspondence Analysis, Heat Maps
Anal 02	Bayes Modeling, Decision Trees, Discriminant Analysis, Neural Networks, KNN, Regression Models, Support Vector Machines, Bagging, Boosting
Change 01	Stakeholder Analysis, Force Field, RACI, Team Charter, Team Roles, Communication Plans
Change 02	Change Audit, Change Curve, Culture Map, PEST, SWOT, Coaching, Team Roles, Mission & Vision, Change Impact, Sustaining Change
DOE 01	Fractional and Full Factorial Design of Experiments
DOE 02	General Factorial
DOE 03	Response Surface Methods
DOE 04	Plackett-Burman Designs
DOE 05	Taguchi Design of Experiments
Graphs 01	Bar Chart, Pie Chart, Box Plot, Dot Plot, Histogram, Time Series Plot
Graphs 02	Individual Value Plots, Interval Plots, Run Chart, Contour Plot, Matrix Plot, Multi-Vari Chart, Scatter plot, Waterfall Chart, Probability Plot
Graphs 03	Pareto Charts
Lean 01	Hoshin, Lean Maturity, True North, 5S Audits, OEE, Spaghetti, Standard Work, Kanban, SMED, TAKT, Time Study, Workload Balanced, 5 WHys, Kaizen Report, Waste Analysis, A3 Reports, Leader Standard Work, One Point Lessons
Lean 02	Value Stream Mapping
Projects 01	Kano, VOC Table, Scorecard, Financials, Project Filter, Project Charter, CE Matrix, Check Sheet, Is vs Is Not, Benefit Effort, FMEA, Multi Voting, Pugh Matrix, Solution Selection, TRIZ, Control Plan, Design Scorecard, Implementation Plan, Minutes, Closure Form
Projects 02	QFD, Process Map, Relationship Diagrams, SIPOC, Fishbone, Tree Diagram, Fault Tree Analysis, GANTT Charts
Stats 01	Basic Statistical Analysis
Stats 02	Normality Tests, Probability Calculations, Random Numbers, Transform Data (Box-Cox, Johnson)
Stats 03	Sample Size Calculations, Compare Samples (1-Sample t, 2-Sample t, 1-Proportion, ANOVA, 2-Proportion, Non-Parametric)
Stats 04	Correlation & Regression Analysis (Simple, Multiple, Logistic)
Stats 05	Capability Analysis (Normal and Non-Normal, Binomial, Poisson)
Stats 06	Control Charts (I-MR, Xbar-R, P Chart, U Chart, C Chart, NP Chart)
Stats 07	Distribution Identification
Stats 08	Gage Linearity and Measurement Systems Analysis (Gage R&R)
Stats 09	Reliability Analysis
Stats 10	Time Series Analysis (Auto Correlation, Moving Averages, Trend Analysis, Seasonality)

A sample screenshot of the worksheet after completing the test run for Graphs 01 is shown below.    

1	Validation Accuracy: The overall validation accuracy and total time required to run all tests are displayed at the top. If the validation accuracy is 100%, all the tests in that file have passed.

You can update this result in your operational qualifications report if you document these findings. If any of the tests fail Validation, you will need to investigate the root cause of this discrepancy and fix it before you can use the software. If you cannot resolve this problem locally, work with the help desk to resolve this issue.     

Methodologies

You can use the methodologies button to design up to 5 custom methodologies relevant to your company. The figure below shows a sample screenshot of the methodologies manager. Note that you can define up to 5 different methodologies. The current methods are shown in the panel on the right. If they are blank, then no methodology has been described.   

1	Methodology:     Click on this button to switch between the different methodologies. If this button appears blank, then no methodology has been defined. Ensure that you explain the methods from top to bottom. If a particular button has been selected, it will be shown in blue font; otherwise, it will be in black. Note that you can define up to 5 different methodologies using this manager.
2	Acronym:     Each methodology has an acronym, which can be defined here. For example, the Six Sigma improvement methodology is known as DMAIC, while Lean employs a PDCA methodology (also consisting of four steps). Similarly, you can define and devise an acronym relevant to your project. Note that we can have a maximum of 5 steps in any methodology. If you have more than five steps in a method, you can group some steps into a single step to meet the 5 step limit.
3	Step Description:     You can click on this label for each methodology step and edit it if required. The default names provided are Step 1, Step 2, and so on. You can change these into Define, Measure, or those relevant to your acronym.
4	Available Tools:     Drag and drop the tools from the available tools to the selected ones on the right. Use the search button to narrow the search for available tools. Note that each step in the methodology can have up to 10 tools listed. If you have more than ten tools per step, list the ten most important steps here. Double-click on a selection to remove it from the list. When you add a new tool, it appears at the bottom of the list. If order is important, you need to add the tools in the same order you want them to be listed.
5	Selected Tools:     You can use generic tools if multiple tools make sense for your project. For example, instead of listing 1-Sample t-Test, 2-Sample t-Test, ANOVA, etc., you can choose to Compare Samples, which houses all of these tools in the same user interface.
6	Reset:     Clicking this button will clear all data for the selected methodology. It will clear the acronym at the top, the definitions of each phase, and the tools you have already selected. If you have clicked by mistake, click on Cancel to exit this dialog box without saving it, and go back and make edits after you return.
7	Help:     Clicking this button opens the help file for the Options dialog box.
8	Cancel Button:     Clicking on this button will close the dialog box without making any changes.
9	OK Button:     Clicking on this button will save your changes to all the methodologies you have made. When you click the Tool Wizard, you will find these methodologies listed. An example screen for the DMAIC methodology is shown below.

Shortcut Keys

A sample screenshot of the shortcut keys manager is shown in the figure below.   

1	User Action: Select the action for which you want to define the shortcut from the dropdown combo box. The available options are: Action Description No action The specified key will not be mapped to any action. System default The specified key will return to the shortcut mapped by Excel. Open help... Open the help file for the specified topic. Note that, depending on the optional settings, this help file can be opened either locally on your computer or accessed from our web server. Open analysis setup This is equivalent to clicking on the Analysis Setup button on the main menu bar. Compute analysis outputs This is equivalent to clicking on the Compute Outputs button on the main menu bar. Open data Editor This is equivalent to clicking on the Data Editor button on the main menu bar. Duplicate workbook The specified key will copy the currently active workbook and make a copy of the analysis so that you can run a what-if analysis by making changes to the inputs. View summary sheet This will change the currently active worksheet to the Summary Sheet. View data sheet This will change the currently active worksheet to the Data Sheet so that you can view the data available for analysis.
2	Shortcut Keys: Specify the key to use to map the shortcut. The available options include the function keys (F1 through F10), the Alt Key, the Shift Key, the Ctrl Key, and others. For function keys, no additional character is required.
3	Shortcut Chars: If the shortcut key is not one of the function keys, you will have to specify the character for the shortcut. For example, if you specify the shortcut key as Ctrl and the character E, the shortcut is activated when you click Ctrl-E.
4	System Keys: Clicking on this button will reset the specified shortcut keys to what was available in the Excel system before you started the Sigma Magic software.
5	Reset Button: Click this button to revert all changes and restore the shortcut keys to their original definitions within Sigma Magic software.
6	Cancel Button: Cancel any changes you have made and exit this dialog box. The changes are not saved.
7	OK Button: Save any changes you have made and apply the changes so that the shortcut keys are effective immediately on closing this dialog box. Any changes will also be reflected when you reopen Excel the next time.

Color Settings

 This setting can change the look and feel of the worksheets. An example screenshot of the Color settings is shown in the figure below.
  

1	Color Theme: You can use these settings to change the layout of colors used on the tools using a custom layout. Different colors are used for the various sections of the worksheet and the dialog box. Using the theme colors will change the entire set of colors as a group. You can click on the Color Theme dropdown box to change the default colors for a group of settings simultaneously. The following default colors are currently available for the Theme setting. Option Description Black Set a black and white color theme for various elements. Blue Set a blue color theme for various elements. Gray Set a gray color theme for various elements.  This is the default setting. Orange Set an orange color theme for various elements. Green Set a green color theme for various elements.
2	Select Colors: You can click and change individual colors for specific elements separately. If you click on the color box next to an element, you can change its color. You can specify each element's foreground color (FG) and background color (BG) separately. The following elements are defined in the first section. Option Description Main Header This is for the title line, which contains the name of the worksheet and the Sigma Magic logo. Sub Header This is for the row that contains the sub-header description, such as Notes and Graphs. Notes Header This is for the Header or title of the notes area. Notes Body This is for the main body of the notes area. Chart Area This is the color to be used for the graphs. Tabs This is the color to be used for the worksheet tabs. Form Header These are used for any form headers that may exist on certain tools (such as Control Plan). Form Body These are used for any forms that may exist on certain tools (such as the Control Plan). Cell Highlight These are used to highlight important cells on worksheets so that they stand out compared to other cells.
3	Standard Colors: You can specify the colors for the various standards.  For example, what colors should be used for averages, limits, targets, data, outliers, fitted lines, and the pass, warning, and fail indicators?
4	Group Colors: You can specify the background (BG) and foreground (FG) colors that should be used for any groups on the charts. The groups are used when multiple elements are plotted. For example, if a chart uses two lines, the first line belongs to group 1, and the second line belongs to group 2.
5	Reset Button: You can click on this button to reset all the settings on this page to their default values. Note that there is no undo button, and once the settings have been reset, it is not possible to revert to the previous settings.

Font Settings

 This setting can change the fonts used on the tools' notes and graphs sections. An example screenshot of the font settings is shown in the figure below.
  

1	Font Element: You can use these settings to change the fonts for the following elements. By font, we can specify the font name, the font size, and the font style to use for that element. Option Description Main Header This is for the title line, which contains the name of the worksheet and the Sigma Magic logo. Sub Header This is for the row that contains the sub-header description, such as Notes and Graphs. Notes Header This is for the Header or title of the notes area. Notes Body This is for the main body of the notes area. Chart Area This is the color to be used for the graphs. Tabs This is the color to be used for the worksheet tabs. Form Header These are used for any form headers that may exist on certain tools (such as Control Plan). Form Body These are used for any forms that may exist on certain tools (such as the Control Plan). Cell Highlight These are used to highlight important cells on worksheets so that they stand out compared to other cells.
2	Font Name: Specify the name of the font you want to use for this element. The following font names are currently available for change via this menu. Option Description Arial This is an example of the representative text using this font. Calibri This is an example of the representative text using this font. Consolas This is an example of the representative text using this font. Courier New This is an example of the representative text using this font. Georgia This is an example of the representative text using this font. MS Gothic This is an example of the representative text using this font. Segoe UI This is an example of the representative text using this font. Tahoma This is an example of the representative text using this font. Times New Roman This is an example of the representative text using this font. Verdana This is an example of the representative text using this font.
3	Font Size: Specify the font size of each element. Option Description 8 Example Font 9 Example Font 10 Example Font 11 Example Font 12 Example Font 14 Example Font 16 Example Font 18 Example Font 20 Example Font 22 Example Font 24 Example Font 26 Example Font 28 Example Font 36 Example Font 48 Example Font 72 Example Font
4	Font Style: Specify the style of the font to use for this element. Option Description Regular This is an example of the representative text using this font. Bold This is an example of the representative text using this font. Italic This is an example of the representative text using this font. Bold Italic This is an example of the representative text using this font.
5	Reset Button: You can click on this button to reset all the settings on this page to their default values. Note that there is no undo button, and once the settings have been reset, it is not possible to revert to the previous settings.

FAQ

This section contains some frequently asked questions. If you have any other questions about this module, please contact technical support.