| 258 |
Beta Distribution
This template is prepared for understanding and simulating beta distributions. An introduction sheet briefly describes the distribution while on another sheet, Beta distribution of entered parameters may be created. All properties of the distribution such as moments and shape are displayed. SpreadsheetWEB version provides all features of the template online.
|
| 84 |
Capital Budgeting
This template is prepared for comparing mutually independent (up to 5) projects(options). Net Present Values (NPV) and Internal Rates of Return are calculated and cash flows are simulated. Also an incremental IRR analysis is carried out, displaying the best option.
|
| 98 |
Cause and Effect Matrix
This template is prepared for calculating Rank, Score and Ratings of Key Process Input and Output Variables for Six Sigma.
|
| 142 |
Control Chart (6 Sigma)
This is a 6 Sigma tool for tracking the daily defections. Up to 10 sample sets can be analyzed by this template. Daily means and standard deviations are evaluated for sample sets as well as the mean and standard deviation of the whole period. The upper and lower control limits depending on the desired level are evaluated and displayed on a chart. SpreadsheetWEB version of the template provides all features of the template and can be used, saved, edited online.
|
| 143 |
Cost Worth Diagram (Tanaka Method)
This template is prepared for comparing relative component costs to estimated worth using the method introduced by Tanaka (1989). Comparison of up to 10 components and up to 10 functions is ara available in this template. A comparison chart with lower and upper boundaries is provided. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 144 |
Fishbone Diagram
This template is created for preparing fishbone diagrams (also called Ishikawa diagrams or cause-and-effect diagrams) easily. The template may used for cases up to 6 main and 3 sub causes for each main causes. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 69 |
Gannt Chart (To Do List)
This template is created for tracking project items. Its flexible design allows you to define the time unit of the Gannt Chart. If the chart cannot be displayed in one page, project duration may divided into phases.
|
| 66 |
Marketing Plan
This template is a kind of questionnaire for constructing a marketing plan. It contains 3 sections: Market Analysis, Product/Service Analysis, Marketing Strategies - Marketing Fix.
|
| 85 |
NPV IRR Calculator
This template is prepared for calculating Net Present Value (NPV) and Internal Rate of Return (IRR) of a single projects, displaying if it is profitable to take. Also a simulation of cash flows over the project horizon is created.
|
| 79 |
Pareto Analysis
This template is prepared for carrying out Pareto analysis with a Pareto chart. Generally used 80% of occurances in consideration is variable in this template. Also weighted analysis on items can be carried out.
|
| 145 |
Pick Chart (6 Sigma)
This is a Lean Six Sigma tool for organizing process improvement ideas and categorizing them on a Benefit vs. Difficulty/Cost chart (implement, possible, challenge, kill). SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 146 |
Rolled Throughput Yield (6 Sigma)
RTY is a powerful operational metric of Lean Six Sigma used to assess the "true" yield of a given process. The template may be used for process having up to 10 process steps. 2 different calculation methods (nb out of step/nb into step and the exponentional approach) are proposed. Also, a Pareto analysis of defective percentages of process steps is provided with a chart. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 147 |
Root Cause Analysis (6 Sigma)
Root cause analysis (RCA) is a class of problem solving methods aimed at identifying the root causes of problems or events. This template may be used for up to 6 possible causes, which may be weighted and displayed on a small fishbone diagram. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 148 |
SIPOC Diagram (Process Map)
SIPOC (Suppliers, Inputs, Process, Outputs, Customers) is a 6 Sigma tool. This template is prepared for creating SIPOC diagrams easily. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 103 |
Six Sigma Plan
This template is prepared for creating Process Control Plan and Preventative Maintenance Plan. SpreadsheetWEB version of the template provides Save and Single Record Application features, which allows to create a collection of plans, save and update them online.
|
| 149 |
Supplier Comparison Chart
This template is prepared for evaluating different suppliers on the critical quality features. These features can be weighted. 6 different scales for ranking the suppliers is provided. The performances of the suppliers for critical quality features are displayed by a bar chart and the best suppliers for each feature are selected. SpreadsheetWEB version of the template provides all features of the template, also can be used, saved and edited online.
|
| 80 |
Turtle Diagram
This diagram is used in audits for quality management of processes. SpreadsheetWEB version of this template provides Save feature. Hence, a collection of Turtle Diagrams for different processes can be created and saved online.
|