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
New
Overview
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.
Usage
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.
FAQ
This section contains some frequently asked questions. If you have other questions about this module, please contact technical support.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.
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.
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.