I will build automated excel spc cp cpk gage rr doe and 8d quality tools
Excel automation for quality, ops and Korea local guides
About this Gig
Automated Excel tools for SPC, capability, MSA and 8D, built around your own measurements instead of a template.
WHAT I BUILD
- Xbar-R or Xbar-S chart with the correct A2, D3, D4 and d2 constants, plus Cp/Cpk against Pp/Ppk and the drift ratio between them
- AIAG MSA 4th Ed. Gage R&R: EV, AV, GRR, PV, TV, %GRR, %contribution, ndc and the verdict
- 2^3 full factorial DOE: effects, sums of squares, % contribution and the optimum recipe
- 8D/FACA tracker with three-legged 5-Why, poka-yoke evidence and Cpk before and after
- A one-page dashboard so the weekly quality review reads itself
WHY ME
Formulas are native and unlocked, so your customer or auditor can trace every number back to a measurement. No macros, no protected sheets, no add-ins.
WHAT YOU SEND ME
Your characteristic, USL/LSL, subgroup size, and for Standard or Premium your measurement file (CSV or Excel). I return the workbook, a formula guide and a handover note.
Message me before ordering if you need more than three characteristics or a non-standard design.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formulas
•
Dashboard
•
Charts
FAQ
Do I need macros or add-ins?
No. Everything runs on native unlocked Excel formulas (2016 or later). No VBA, macros, protected sheets, or add-ins are used, so auditors can trace every calculation.
Which standards do the formulas follow?
All SPC, capability (Cp/Cpk, Pp/Ppk), Gage R&R (EV, AV, GRR, PV, TV, %GRR, ndc) and DOE calculations follow AIAG SPC 2nd Ed. and AIAG MSA 4th Ed. conventions.
What do you need from me to start?
Your characteristic name, USL/LSL (or target and tolerance), subgroup size (n), and for Standard or Premium orders your raw measurement file in CSV or Excel format.

