Help Manual
Contents
- Introduction
- Project
- Analytics Templates
- Pre-Process Data
- Basic Charts
- Hierarchical Cluster
- Kmeans Cluster
- Correspondence Analysis
- Conditional Tree
- Recursive Tree
- Discriminant Analysis
- Exploratory Factor Analysis
- Generalized Linear Model
- Heat Map
- KNN
- Marginal Plot
- Naive Bayes
- Network Plot
- Neural Networks
- Random Forest
- Scatter Matrix
- Tree Map
- Word Cloud
- XGBoost Analysis
- Change Templates
- Lean Templates
- 30-60-90 Plans
- 5 Why Analysis
- 5S+1 Audit
- Lean Maturity Assessment
- Hoshin Analysis
- Kanban Analysis
- Leader Standard Work
- OEE Analysis
- A3 Report
- Kaizen Report
- One Point Lesson
- SMED Analysis
- Spaghetti Diagram
- Standard Work
- TAKT Time
- Time Study
- True North
- Value Stream Map
- Waste Analysis
- Work Combination
- Workload Balance
- Graph Templates
- Projects Templates
- Balanced Scorecard
- Benefit Effort Plot
- C&E Diagram
- C&E Matrix
- Closure Form
- Check Sheet
- Control Plan
- Design Scorecard
- FMEA Analysis
- Fault Tree Analysis
- Financial Benefits
- Is - Is Not Analysis
- Kano Analysis
- Process Map
- Relationship Diagram
- Meeting Minutes
- Project Charter
- Project Filter
- GANTT Chart
- Implementation Plan
- QFD Analysis
- SIPOC Analysis
- Pugh Analysis
- Solution Matrix
- Tree Diagram
- TRIZ Analysis
- Stats Templates
- Format Data
- Basic Stats
- Capability Analysis
- Compare Data Sets
- Control Charts
- Correlation Analysis
- DOE - Factorial Design
- DOE - Taguchi Design
- Distribution Identification
- Probability Calculations
- Monte Carlo Simulation
- MSA - Linearity & Bias
- MSA - Gage R&R
- Normality Analysis
- Normality - Transform Data
- Optimization
- Generate Random Data
- Sample from Columns
- Regression Analysis
- Reliability Analysis
- Lot Acceptance Plan
- Sample Size Analysis
- Time Series Analysis
- Analysis
- Miscellaneous
Sigma Magic Help Version 15
Open
Overview
The Open button can be used to open existing Excel files. Click on the Open button within the Manage Files menu.
Usage
You can use the Open menu icon to open an existing workbook you have been working with before. This will open an existing workbook that has Sigma Magic analysis already in it that you have worked on earlier, or it may be any other workbook that has Excel data that you want to use for your project. You can use the Open menu to open both Excel (97-2003) workbooks and later versions.
However, note that if you open an Excel 97-2003 workbook, you will not be able to add templates from Excel 2007 into it since Excel 97-2003 workbook can only handle 65,536 rows and 256 columns while later versions can handle more than that. If you have an older version of the Excel file (*.xls), you will first need to convert it to the newer format (*.xlsx) before you can use the Sigma Magic software.FAQ
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 data in an existing workbook?
You could choose to open that workbook and save results in that workbook. However, if you want to save just the data and analysis for your project, you may want to create a new workbook and then copy and paste data into this workbook, so you are not carrying any extra data in your workbook.
What if I have macros in the other workbook that do not belong to Sigma Magic software?
If you need the macro functionality, you can enable the macros in the other book. However, it is recommended that you use a new workbook if you have macros just to ensure that there are no issues with function naming conventions.
Do I need to enable macros in the workbook I am using?
The main excel file SigmaMagic.xlsm would require macros to be enabled. However, you can disable macros for your own individual workbook.