Change Ppk to Cpk in the Raw Data Report
Print Friendly View
written: 01/14/2021
last modified: 10/09/2024

The default Raw Data report (DataStat.raw) with QC-CALC shows the Pp and Ppk values in the calculations area. This White Paper will give step-by-step instructions for changing those rows to show Cp and Cpk (using the estimated Sigma) instead.

The Report Designer

The directions shown here will change the existing Pp and Ppk rows to show Cp and Cpk instead. This is a lengthy process but relatively simple to accomplish.

  1. From QC-CALC Real-Time choose the Report > Design Template menu.

  1. Choose the DataStat.raw template from the list of files that appears, and right-click and select Copy to create a copy.
  1. Paste the copy in the same area and click Open.
  1. The Report Designer now appears on the screen.

Change Pp to Cp

  1. Double-click on the table and the Table Contents window will appear.

  1. Choose the Header Line tab, then scroll down until you see the “Line Definition Cp” area. This area actually shows the Pp value when you have the Tools > Options > Global > Show Ppk instead of Cpk option enabled, so don’t be confused by the words you’re seeing.
  1. Double-click the top line in that area so we can fix the label that will be displayed. In the Edit Table window that appears, change the line to read:

If(DisplayPpk,"Cp","Cp Within")

  1. Click OK in the Edit Table window.
  1. Now that the row's label has been changed, each column within the row needs to be updated, too. To start, double-click the first line with words below the line you just fixed to bring up the Edit Table window for that item.

  1. In the box at the bottom of the screen, place the cursor immediately after the “Char_01_Pp” item, and the list of available values will appear. Currently, only the “Ppk” variable would be shown, so use the Backspace key to delete the “Pp” portion, and an expanded list will appear. Double-click on “Char_01_Cp” in the list and then click OK.

  1. The same procedure should be followed for the remaining characteristics in the “Line Definition Cp” section of the Header Line area.

Change Ppk to Cpk

Now that Pp has been changed to Cp the same process needs to be done for Ppk. To do this, find the “Line Definition Cpk” section (it should be directly below the Cp section) and do the same steps as above (steps 2 – 7). Here are the slight differences:

In Step 3: The text should be “If(DisplayPpk,"Cpk","Cpk Within")”

In Step 6: Double-click on “Char_01_CpK” in the list and then click OK.

Change Sigma to Sigma Within (optional)

Now that you are displaying the Cp/Cpk values the Sigma value is no longer used to calculate these values. You would probably want to display the Sigma Within value used for those calculations instead. To do this, find the “Line Definition Sigma” section (it should be directly above the Cp section) and do the same steps as above (steps 2 – 7). Here are the slight differences:

In Step 3: The text should be "Sigma Within"

In Step 6: Double-click on “Char_01_Sigma_Within” in the list and then click OK.

General Steps

  1. Click OK on the Table Contents screen and save your changes (File > Save).
  2. Exit from the Report Designer and you will see a question asking if you changed the number of characteristics in your report. Choose No on this message.

  1. You are all set to run your report now.

Attachments