SPC 控制图与 Cpk 计算表SPC Control Chart and Cpk Calculator

过程能力计算的实用表格：输入样本数据自动算 Cp、Cpk、Pp、Ppk，附控制图常数表与判定标准（含 Ppk 与 Cpk 的使用场景区别），适合做 PPAP 过程能力研究与日常过程监控的质量工程师。A practical process capability worksheet: input sample data to compute Cp, Cpk, Pp and Ppk automatically, with a control chart constants table and acceptance criteria including when to use Ppk rather than Cpk. Made for quality engineers working on PPAP process capability studies and day-to-day process monitoring.

模板包含什么What is inside

说明Instructions
Cpk 计算Cpk Calculation
判定标准Acceptance Criteria
控制图常数Control Chart Constants

解决什么问题What it solves

自动计算 Cp/Cpk/Pp/PpkAutomatic computation of Cp, Cpk, Pp and Ppk
控制图常数表（Xbar-R 等常用类型）Control chart constants table covering common types such as Xbar-R
Cpk 与 Ppk 的适用场景明显区分Clear distinction between the applicable scenarios of Cpk and Ppk
附过程能力判定与改进方向提示Includes process capability judgment and improvement direction hints

配套文章：把这个模板用对Related reading

控制图没出界却不能报 Cpk？2026 版 SPC 四种分布模型对号入座No Points Out of Control, Yet No Cpk? Match Your Process to the Four Distribution Models of the 2026 SPC Manual

控制图没点子出界，客户审核却说只能报 Ppk——受控不等于统计受控。讲透 2026 版 SPC 手册四种时间相关分布模型：该配 Cpk 还是 Ppk，以及模型怎么验证。No points out of control, yet the auditor allows only Ppk — in control is not statistically controlled. The four time-dependent distribution models of the 2026 SPC manual, when Cpk or Ppk applies, and how to verify the model.

Cpk 和 Ppk 还在混着用？2026 版 SPC 手册六个指数一套算法Still Mixing Up Cpk and Ppk? The 2026 SPC Manual Uses One Formula for Six Indices

2026 版 AIAG-VDA SPC 手册按 ISO 22514-2 统一了算法：Pm/Pmk、Pp/Ppk、Cp/Cpk 用同一个公式、同一个变差，区别只在数据怎么采、过程是否证实稳定。讲清六个指数的适用阶段、稳定性分水岭、目标值与样本量门槛。The 2026 AIAG-VDA SPC manual aligns with ISO 22514-2: Pm/Pmk, Pp/Ppk and Cp/Cpk share one formula and one variation — what differs is how the data was collected and whether the process is proven stable. When each index applies, why stability is the dividing line, and how targets scale with sample size.

同类模板More templates

M01

8D 问题解决报告模板8D Problem Solving Report Template

覆盖 D1 到 D8 全流程的 8D 报告模板，把散落在邮件和会议纪要里的问题解决过程收进一张表：每个 D 步骤都有填写提示，D3 环节单独配围堵三库清单，D8 配关闭核对项，避免报告写完却漏了验证和固化。An 8D report template covering the whole D1-to-D8 flow, bringing the problem-solving process scattered across emails and meeting notes into one sheet: every D step carries filling guidance, D3 has a dedicated containment inventory list, and D8 has a closure checklist, so a report never ends without verification and standardization.

4 个工作表 · .xlsx 查看并下载

M07

PFMEA 七步法表单PFMEA Seven-Step Form (AIAG-VDA)

AIAG-VDA 新版 PFMEA 七步法（规划与准备、结构分析、功能分析、失效分析、风险分析、优化、结果文件化）的配套表单，每一步有独立填写区与检查项，附 AP 优先级评级规则，适合正在从旧版 RPN 切换到新版的团队。Forms supporting the new AIAG-VDA PFMEA seven-step method - planning and preparation, structure analysis, function analysis, failure analysis, risk analysis, optimization and result documentation - with a dedicated filling area and checklist for every step, plus AP priority rating rules. Built for teams moving from the old RPN approach to the new method.

3 个工作表 · .xlsx 查看并下载

M08

DFMEA 七种失效类别速查表DFMEA Seven Failure Categories Quick Reference

DFMEA 写不出失效，往往是因为脑子里只有「坏了」一种想象。这份速查表把设计失效归纳为七类（功能丧失、功能退化、间歇性失效、部分功能、非预期功能、过功能、迟滞功能等），每类配典型例子与提问句式，帮助设计团队把失效想全。DFMEA often fails to produce failure modes because teams can only imagine that it breaks. This quick reference groups design failures into seven categories - loss of function, degraded function, intermittent failure, partial function, unintended function, over-function and hysteresis - each with typical examples and prompting questions, helping design teams think comprehensively.