Logan Luo

http://www.qitconsulting.com/Download

Hi Sam,
 
Yes, it has been a long time. I did not hear anything from Bill, but I think I have found the way.
 
I believe no matter what kinds of SS tools are being used, they must serve a basic criterion – driving improvement. For large corporations, they may have more resources to make improvements in large scale, but for small companies, th…[Read more]

The setup of your monitoring system is wrong. From your example, the monitoring system does not catch any valuable data and monitor the right parameters. You should measure and record the process performance – defect/reason for losing time, not only the process output – total hours loss.  I have seen similar problems in manufacturing industry th…[Read more]

That is exactly the answer I was looking for. Now I can close the loop of my calculator. 
In stead of looking Z value in a table, I designed this gadget which is similar to the one in this website to calculate the DPMO, Z value, Yield tp and Cpk for me .

Thanks
 

Sounds like long term and short term sigma.
I also use a short cut to calculate sigma level “process Sigma = 0.8406 + SQRT(29.37 – 2.221 * (ln(DPMO)))”. Using this short cut, I can easily calculate all these measurements (DPU, Sigma, DPMO, Yield and etc.) in my database.
To answer Sergio’s question, I think the key is to calculate DPMO in…[Read more]

1) You are using DPMO
2) One part may have more than one Opportunities
3) You can use “DPMO= ((Total Defects) / (Total Opportunities)) * 1,000,000” to calculate DPMOs in Process Level, Work Order Level, Product Line level and Overall level.
 

I keep receiving emails asking for the program. Please make sure following items before sending me email.
 
1)      It is a Microsoft Access program. Make use you have Access installed.
2)      It is not a calculator. It is a database that keeps production data (input, defect, operational time) and calculates Yield, Sigma Level and Operative…[Read more]

Again, the Lean tool kit. Kanban pull system, one piece flow and takt time target on reducing inventory/WIP which is one of the 7 wastes.

You’d better take a look at Lean tool kit.
Anyway, I think the best way to start is to map out the processes and start to record the operative cycle time for each process to define the weakest link.
I have been working on a computer program, which will calculate DPMO, Yield, Sigma Level and Cycle Time. The program may help you record the…[Read more]

It sounds like that after you exported the file to Excel, the exported file overwrote the old Excel file which has the Sigma formula. 
The other possibility is that after you exported data to Excel (without opening it), the Sigma field in your Excel file would still “remember” the old data. If you import the data without opening the file, you w…[Read more]

Thanks Ram. Now I know the difference between these formulae.
 
I have another question.
In iSigma’s dictionary Yield is defined as
 
“Yield is the percentage of a process that is free of defects.” [not the probability of process free of defect]OR”Yield is defined as a percentage of met commitments (total of defect free events) over the tota…[Read more]

Thanks Stan.
What is the difference between Yield=e**-DPU and Yield=1-dpu? The formula has been used in iSixSigma Calculator is Yield=100-defect percent.
The reason for doing all these is because I am trying to develop a general-purpose software to ease the calculation process of all Six Sigma measurements. Different people may need/like…[Read more]

You will not have the average of 5 fields in this way. You have to Union all five fileds (put them in one field) before you can have the average. Some knowledge of SQL language are requried here. You can copy following code and past to SQL. (New a query –>select sql from View–>cut ans past the code–>chage the table name to the real table n…[Read more]

Can I have one copy of the Overview? [email protected]
Thanks
 

Hi Bill,
Could you please advise what kind of the tools that you have applied? I don’t think some of the SS tools can be applied in small company (specially the real SS tools); and small company doesn’t have money for all Black Belts and Green belt who actual drive the programs and project. Training is another issue in small company. How to ca…[Read more]

Try these:
Mean:
in the Query filed type in: Mean: =avg([your field name])
Range:
type in: Rang: =max([your field name]-min([your field name])
You have to eliminate other fields to have it working right.
let me know if it works. I am working on an Access database, which can calcualte DPU, DPMO, Yield, Cycle Time and ect. If you are…[Read more]

Thanks Erik.
My email: [email protected]
Logan