Logan Luo
was active Not recently activeActivity
-
Logan Luo replied to the topic Applying 6s to Lead Time Reduction in the forum General 16 years, 6 months ago
-
Logan Luo replied to the topic Six Sigma/TQM – Which is Better? in the forum General 19 years ago
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] -
Logan Luo replied to the topic Process Monitoring through Six Sigma in the forum General 19 years, 1 month ago
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]
-
Logan Luo replied to the topic How to convert DPMO/Sigma to Cpk in the forum General 19 years, 2 months ago
-
Logan Luo replied to the topic Calculating DPPM in the forum General 19 years, 3 months ago
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] -
Logan Luo replied to the topic Calculating DPPM in the forum General 19 years, 3 months ago
-
Logan Luo replied to the topic Applying 6s to Lead Time Reduction in the forum General 19 years, 6 months ago
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] -
Logan Luo replied to the topic Applying 6s to Lead Time Reduction in the forum General 19 years, 6 months ago
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.
-
Logan Luo replied to the topic Applying 6s to Lead Time Reduction in the forum General 19 years, 6 months ago
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] -
Logan Luo replied to the topic Calculating sigma in access in the forum General 19 years, 8 months ago
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] -
Logan Luo replied to the topic Calculations of Yield, Sigma Level and Cpk in the forum General 19 years, 8 months ago
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]ORYield is defined as a percentage of met commitments (total of defect free events) over the tota…[Read more] -
Logan Luo replied to the topic Calculations of Yield, Sigma Level and Cpk in the forum General 19 years, 8 months ago
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] -
Logan Luo replied to the topic Data Collection Using Acess Database in the forum General 19 years, 8 months ago
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]
-
Logan Luo replied to the topic Six Sigma/TQM – Which is Better? in the forum General 19 years, 8 months ago
Can I have one copy of the Overview? [email protected]
Thanks
-
Logan Luo replied to the topic Six Sigma/TQM – Which is Better? in the forum General 19 years, 8 months ago
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] -
Logan Luo replied to the topic Data Collection Using Acess Database in the forum General 19 years, 8 months ago
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] -
Logan Luo replied to the topic Z value calculation in the forum General 19 years, 8 months ago
Thanks Erik.
My email: [email protected]
Logan