Help Manual
Contents
- Introduction
- Project
- Analytics Templates
- Basic Charts
- Bagging Models
- Bayesian Models
- Boosted Models
- Correspondence Analysis
- Decision Trees
- Discriminant Analysis
- Exploratory Factors
- Heat Map
- Hierarchical Clusters
- Kmeans Clusters
- Make Predictions
- Marginal Plot
- Model Selection
- Network Plot
- Neural Networks
- Pre-Process Data
- Prototype Models
- Regression Models
- Scatter Matrix
- Support Vectors
- Tree Map
- Word Cloud
- 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 17
Duplicate Worksheet
Overview
The duplicate button can be used to make a copy of the existing analysis and create a new worksheet with identical settings that you can use to perform a what-if analysis. Click on the Duplicate button within the Analysis menu on the main menu bar.
Usage
You can use the Duplicate button to copy the existing analysis. This will make a replica of the currently active workbook. It will copy the analysis settings, any information specified on the worksheet, and any data you have specified for analysis.Once you make a copy, the name of the analysis tab is modified. For example, if the original analysis is called Normality, the new worksheet is renamed Normality (2). You can always rename this worksheet to make it more descriptive.
Once you make a copy of the worksheet, you can change the input settings or data and click on Compute Outputs to update the analysis results. Once you complete the analysis, you can compare the results between Normality and Normality (2) to see the differences in the results based on the changes you have made to the settings.
You can always create a new worksheet by going through the traditional route of adding a new template using the Tool Wizard and then specifying the settings and options, but you would require several clicks to do this; clicking on the Duplicate button gets this done in one click, and this can help you increase your productivity.
FAQ
This section contains some frequently asked questions. If you have other questions about this module, please contact technical support.
Do I have to use "Duplicate" to duplicate a worksheet?
This is just one feature that will allow you to perform what-if analysis. Of course, there are other ways of solving the same problem, and you don't necessarily have to use this approach.
Will duplicating a tab change the original worksheet?
No changes are made to the original worksheet. Only a copy of its contents is taken to make the new worksheet. You can safely delete the old or the new worksheet after the duplicate, but they are not connected.
Is there a difference if I duplicate a tab by clicking the Duplicate button or by right-clicking and copying it?
No, both of them are identical. The duplicate button is provided to you on the main bar, and you can do this faster by using the duplicate button than other ways of accomplishing the same task.
© Rapid Sigma Solutions LLP. All rights reserved.