J
Hello All,
I am in the final stages of developing an application that gathers inspection data, plots them in a chart, monitors my data for me, and is also capable of printing out a summary form as needed.
To Simplify matters, I will tell you what I know, where I'm at and how you can help me.
What I know:
MAX, MIN, MEAN, Range, Standard Deviations & Critical Limits
... are used to help me calculate my Cp, Cpu, Cpl, & Cpk
Where I'm at:
[DATA]
I have data, and I'm able to calculate the easy stuff, Max, Min, Mean, Range, Standard Deviations.
My Nominal & Critical limits (UCL, LCL) are given.
[CHART]
I can automatically produce a chart that plots the actual dimensions, with my Critical Limits and nominal shown. a sample is shown as an attachment named, "myBasicChart.png"
How you can help me:
I need help understanding how to take my data, and calculate my CPK, Cpu, Cpl, Cp. Once calculated, I need to fundamentally understand how to create a chart of my CPK. I have uploaded an excel form to help me to comprehend how this is all handled. In that spreadsheet, they have a Cpk sheet. and they also have data for the "Chart Setup." If you can first help me to understand the "Chart Setup" that would be a great leap in the right direction for me. The reason being, is that if i can graph something either in excel or manually, then i can create it programatically. And that's what I'm after! Understanding the fundamentals.
[SpreadSheet]
From B37 to B237 they have a list that incrementally increases by 0.1.
For what reason?
From C37 to C237
It looks like there calculating the green box(range) for the Cpk. Does it really work out that way for every Cpk, by using the formula method they used. Very interesting...
Can you explain to me what's happening between D37 to D237? What calculation is that? Where are all of these formulas coming from???
Between E37 & E237, these define what the green box is doing along the yaxis. How am i supposed to know when the box jumps up as theres did?
Between E37 & E86 there ydidn't change, and then all of a sudden on E87, the chart box starts being created by rising on its yvalue. How did they know to start at that point???
I am in the final stages of developing an application that gathers inspection data, plots them in a chart, monitors my data for me, and is also capable of printing out a summary form as needed.
To Simplify matters, I will tell you what I know, where I'm at and how you can help me.
What I know:
MAX, MIN, MEAN, Range, Standard Deviations & Critical Limits
... are used to help me calculate my Cp, Cpu, Cpl, & Cpk
Where I'm at:
[DATA]
I have data, and I'm able to calculate the easy stuff, Max, Min, Mean, Range, Standard Deviations.
My Nominal & Critical limits (UCL, LCL) are given.
[CHART]
I can automatically produce a chart that plots the actual dimensions, with my Critical Limits and nominal shown. a sample is shown as an attachment named, "myBasicChart.png"
How you can help me:
I need help understanding how to take my data, and calculate my CPK, Cpu, Cpl, Cp. Once calculated, I need to fundamentally understand how to create a chart of my CPK. I have uploaded an excel form to help me to comprehend how this is all handled. In that spreadsheet, they have a Cpk sheet. and they also have data for the "Chart Setup." If you can first help me to understand the "Chart Setup" that would be a great leap in the right direction for me. The reason being, is that if i can graph something either in excel or manually, then i can create it programatically. And that's what I'm after! Understanding the fundamentals.
[SpreadSheet]
From B37 to B237 they have a list that incrementally increases by 0.1.
For what reason?
From C37 to C237
It looks like there calculating the green box(range) for the Cpk. Does it really work out that way for every Cpk, by using the formula method they used. Very interesting...
Can you explain to me what's happening between D37 to D237? What calculation is that? Where are all of these formulas coming from???
Between E37 & E237, these define what the green box is doing along the yaxis. How am i supposed to know when the box jumps up as theres did?
Between E37 & E86 there ydidn't change, and then all of a sudden on E87, the chart box starts being created by rising on its yvalue. How did they know to start at that point???
Attachments

24 KB Views: 253

12.8 KB Views: 299

189 KB Views: 325