Posted on 09 December 2009
are one of the basic pillars of the six sigma methodology and are typically used to depict the frequency of occurrence of issues that affect 'production'. Although one usually sees them being used as standalones, the humble pareto chart can very well be augmented in order to make it a much more meaningful tool for tracking and resolving pending issues & errors. Let's look at one such approach that utilizes a combination of a horizontal pareto chart ...
Posted on 12 May 2009
A Six sigma table is a table that depicts the (six) sigma value corresponding to various accuracy levels. The six sigma table
can be downloaded here. By looking down the tabulated values of the accuracy levels, you can find the (six) sigma level that corresponds to your accuracy level.
The sigma table has five columns – the yield or the accuracy level ( 1 – the defect rate), the ...
Posted on 11 May 2009
How do you make a six sigma calculator in Excel? Well it's all really quite simple in excel....the calculator needs only a single formula to generate the sigma level for a process!!! You simply plug the number of opportunities & defects into an excel spreadsheet and calculate the sigma level by using NORMSINV (1 - defect/opportunities). You can download a copy of the six sigma calculator in excel
Posted on 10 May 2009
You can download the house of quality template in excel
here. House of quality is a graphic tool analyzing the relationship between a firm's focus on improvement and the needs of its customers.It is a part of the Quality Function Deployment (QFD). Visually, it looks like a grid with a correlation matrix at its top and left side. The customer needs vs the firm's product features form the main body of the house of quality. Using this template in ...
Posted on 07 May 2009
This article shows how to make Gantt charts in excel. Though Excel remains the preferred choice for creating simple Gantt charts
, there are other commercial tools available for developing more complex versions of the Gantt chart.
GANTT Charts are an important project management tool. In this article, I will describe how to create gantt chart in excel with a marker for show today's date. Using a stacked chart in excel, we ...
Posted on 05 May 2009
Find out how to create a Pareto chart in Excel. A Pareto chart can be created in Microsoft Excel as a combination of a bar and a line chart. A Pareto chart (also known as the Pareto graph) is a combination of two data series, one set of points representing a set of independent values and the other representing the cumulative sum of those values. The independent values are typically represented by vertical bars in which the values are arranged ...
Posted on 04 May 2009
This tutorial shows how to create a Flow charts in Excel. Flowcharts help you logically represent a sequence of activities in a process. Before you begin, you may want to download and analyze this sample flowchart template created using excel
. Making flowcharts in Excel can be as easy and fast as it is in Microsoft Visio without having to buy a license for the later. If you work in a company where a lot of planning and process engineering ...