{"product_id":"spc-processduglighet-styrdiagram-cp-cpk-2027","title":"SPC \u0026 Process Capability 2026\/2027 – I–MR Control Charts, Cp\/Cpk \u0026 Action Log | Excel\/Word\/PDF","description":"\u003csection class=\"mb-product-copy\" lang=\"en\" style=\"color:#17374c;line-height:1.75\"\u003e\n\u003ch2\u003eSPC \u0026amp; Process Capability 2026\/2027 – I–MR Control Charts and Cp\/Cpk in Excel\u003c\/h2\u003e\n\n\u003cp\u003eDo you want to monitor manufacturing variation and document whether a process appears stable? This \u003cstrong\u003eSPC template package\u003c\/strong\u003e combines five practical Swedish-language documents, two guides, and an Excel workbook for \u003cstrong\u003eI–MR control charts, control limits, Cp, Cpk, Pp, Ppk, measurement tracking, and non-conformance management\u003c\/strong\u003e. For workshops, CNC production, quality departments, and small manufacturing companies.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003e7 Word + 7 searchable A4 PDFs + 1 Excel with 9 tabs and 2 built-in control charts.\u003c\/strong\u003e The spreadsheet is blank upon delivery, complete with formulas, status fields, and practical control gates. No dummy production data included.\u003c\/p\u003e\n\n\u003cnav aria-label=\"Page content\" style=\"background:#edf6f7;padding:13px 15px;border-radius:10px\"\u003e\u003cstrong\u003eGo to:\u003c\/strong\u003e \u003ca href=\"#mb-spc-innehall\"\u003ePackage contents\u003c\/a\u003e · \u003ca href=\"#mb-spc-filer\"\u003eThe files\u003c\/a\u003e · \u003ca href=\"#mb-spc-excel\"\u003eExcel\u003c\/a\u003e · \u003ca href=\"#mb-spc-guide\"\u003eWorkflow\u003c\/a\u003e · \u003ca href=\"#mb-spc-villkor\"\u003eMethodology\u003c\/a\u003e · \u003ca href=\"#mb-spc-faq\"\u003eFAQ\u003c\/a\u003e\u003c\/nav\u003e\n\u003cdiv style=\"padding:16px 20px;margin:18px 0;background:#eaf4ee;border-left:5px solid #197b7f;border-radius:10px\"\u003e\n\n\u003cstrong\u003eMethodology and source review: October 14, 2026.\u003c\/strong\u003e\u003cp style=\"margin:5px 0 0\"\u003eThe package is based on publicly described methodology for I–MR control charts and process capability. ISO 7870-2:2023 serves as guidance for Shewhart control charts, but the full standard text is not included. The product is not ISO-certified, and no automatic results constitute quality approval. The 2027 designation refers to the document version, not a claim regarding fixed future regulations.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003cdiv id=\"mb-spc-innehall\" style=\"padding:20px 21px;margin:21px 0;background:#EAF4F4;border:2px solid #cbdfe3;border-left:6px solid #197b7f;border-radius:13px\"\u003e\n\n\u003ch2 style=\"font-size:1.35em;margin:0 0 13px\"\u003e01. Package contents\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003e15 files in one ZIP:\u003c\/strong\u003e 7 editable Word files (.docx), 7 corresponding searchable PDF files (.pdf), and 1 functional Excel workbook (.xlsx) with nine sheets.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eLanguage:\u003c\/strong\u003e five Swedish main templates, Swedish user guide, and an English User Guide. The five main templates are not translated into English.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eVersion:\u003c\/strong\u003e 1.0, 2026\/2027. \u003cstrong\u003eDelivery:\u003c\/strong\u003e digital ZIP file. \u003cstrong\u003eFormat:\u003c\/strong\u003e Word, PDF, Excel. No physical shipping or subscription.\u003c\/p\u003e\n\n\n\u003c\/div\u003e\n\n\u003cdiv id=\"mb-spc-filer\" style=\"padding:20px 21px;margin:21px 0;background:#FFFFFF;border:2px solid #cbdfe3;border-left:6px solid #197b7f;border-radius:13px\"\u003e\n\n\u003ch2 style=\"font-size:1.35em;margin:0 0 13px\"\u003e02. File content\u003c\/h2\u003e\n\n\u003cp\u003eEach document serves a separate function in a practical SPC process. The table lists all eight delivery components.\u003c\/p\u003e\n\n\u003cdiv style=\"overflow-x:auto\"\u003e\u003ctable style=\"width:100%;border-collapse:collapse;font-size:.94em\"\u003e\n\n\u003cthead\u003e\u003ctr style=\"background:#17374c;color:#fff\"\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eNo.\u003c\/th\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eDocument\u003c\/th\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eContent and usage\u003c\/th\u003e\n\n\u003cth style=\"padding:10px;text-align:left\"\u003eFormat\u003c\/th\u003e\n\n\n\u003c\/tr\u003e\u003c\/thead\u003e\n\n\u003ctbody\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e01\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eSPC Plan and Control Setup\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eProcess, critical measurement, responsibility, customer tolerances, sampling, and Phase I baseline.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e02\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eMeasurement Instruction and Sampling Plan\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eMeasurement method, gauge status, measurement order, and practical control steps.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e03\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eI–MR Control Log\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eIndividual observations, moving range, control signals, and review fields.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e04\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eSPC Non-conformance and Root Cause Analysis\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eSpecial causes, tracking, quarantine, corrective action, and verification.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e05\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eProcess Capability Report Cp\/Cpk\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eCp, Cpk, Pp, Ppk, calculation premises, and manual decision.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e06\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eSwedish User Guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eStep-by-step on measurement series, Excel, methodology assumptions, and sources.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e07\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eEnglish User Guide\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eExplains the Swedish templates, Excel, and statistical workflow; main templates are in Swedish.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eDOCX + PDF\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\u003ctr\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e08\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003e\u003cstrong\u003eExcel Tool for SPC\u003c\/strong\u003e\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eNine tabs with two built-in charts, registers, formulas, and control functions.\u003c\/td\u003e\n\n\u003ctd style=\"padding:10px;border-bottom:1px solid #dfe8eb\"\u003eXLSX\u003c\/td\u003e\n\n\n\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\n\n\n\u003c\/table\u003e\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ch2 id=\"mb-spc-excel\"\u003eExcel Tool – nine tabs and two control charts\u003c\/h2\u003e\n\n\u003cp\u003eThe tool includes the worksheets \u003cstrong\u003eOverview, Parameters, Measurement Data, Control Limits, Capability, Non-conformances, Actions, Decisions, and Read Me\u003c\/strong\u003e. Enter up to 200 time-ordered observations and receive automatic moving-range values, indications for out-of-specification measurements, and signals against control limits following a documented baseline review.\u003c\/p\u003e\n\n\u003cul\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eI–MR Chart:\u003c\/strong\u003e line charts for individual observations and moving ranges with control limits calculated from the first 25 measurements. Control limits require separate technical assessment before use.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eProcess Capability:\u003c\/strong\u003e calculates Cp\/Cpk using sigma within (MR-mean\/1.128) and Pp\/Ppk using total sample standard deviation for two-sided specifications. The calculation waits for at least 50 observations and a confirmation of a manually reviewed baseline.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eNon-conformance and Actions:\u003c\/strong\u003e custom registers for signals, suspected cause, responsibility, actual implementation, and effect verification. A registered case does not imply approval.\u003c\/li\u003e\n\n\u003cli\u003e\n\n\u003cstrong\u003eOverview:\u003c\/strong\u003e twelve key metrics, including number of measurements, control signals, non-conformances, open actions, and manually approved decisions.\u003c\/li\u003e\n\n\n\u003c\/ul\u003e\n\n\u003ch2 id=\"mb-spc-guide\"\u003eHow to use the package – step by step\u003c\/h2\u003e\n\n\u003col\u003e\n\n\u003cli\u003eDefine property, process step, measurement method, unit, and the customer's current specification limits (LSL\/USL) in the SPC Plan.\u003c\/li\u003e\n\n\u003cli\u003eDocument sampling frequency, instrument status, and measurement order in the Measurement Instruction.\u003c\/li\u003e\n\n\u003cli\u003eFill in Parameters in Excel and record observations in Measurement Data chronologically.\u003c\/li\u003e\n\n\u003cli\u003eReview the preliminary baseline of 25 observations with a qualified expert. Register the final decision before using the limits.\u003c\/li\u003e\n\n\u003cli\u003eInvestigate control signals and out-of-specification measurements separately. Document actions and actual effect verification.\u003c\/li\u003e\n\n\u003cli\u003eInterpret Cp\/Cpk only after reviewing process stability, representative sampling, distribution, and measurement uncertainty. Use the separate Process Capability Report.\u003c\/li\u003e\n\n\n\u003c\/ol\u003e\n\n\u003ch2 id=\"mb-spc-villkor\"\u003eMethodology, limitations, and terms of use\u003c\/h2\u003e\n\n\u003cp\u003e\u003cstrong\u003eA control limit is not the same as a specification limit.\u003c\/strong\u003e Control limits estimate a process's variation; LSL and USL come from drawings or customer requirements. Therefore, a measurement between control limits is not automatically approved according to the drawing. The spreadsheet uses only individual measurements with moving range over two observations; it does not replace Xbar–R charts, distribution-fitted analysis, MSA\/Gage R\u0026amp;R, or customer-specific validation.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eProcess capability requires technical assessment.\u003c\/strong\u003e The statistical indices are preliminary working values, not decisions on product release. Such an assessment may also require distribution checks and more than 50 observations. The SPC package is a voluntary administrative and quality-technical aid, not a mandatory government form or a complete copy of an ISO standard.\u003c\/p\u003e\n\n\u003ch2\u003eSupplementary documents and relevant internal links\u003c\/h2\u003e\n\n\u003cp\u003eTo ensure measurement traceability, you can use the \u003ca href=\"\/en\/products\/kalibreringsregister-matdonskontroll-excel-2026-2027\"\u003eCalibration Register \u0026amp; Gauge Control\u003c\/a\u003e. For a broader quality assurance process, the \u003ca href=\"\/en\/products\/kvalitetsplan-kontrollprogram-2026-2027-iso-10005-kontrollregister-avvikelser-excel-word-pdf\"\u003eQuality Plan \u0026amp; Control Program\u003c\/a\u003e is available. If you need to plan maintenance tasks arising from process non-conformances, the \u003ca href=\"\/en\/products\/maskinregister-forebyggande-underhall-excel-2026-2027\"\u003eMachine Register \u0026amp; Preventive Maintenance\u003c\/a\u003e can supplement the work. See also the category \u003ca href=\"\/en\/collections\/kvalitetsledning-iso-mallar\"\u003eQuality Management \u0026amp; ISO\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003ch2 id=\"mb-spc-faq\"\u003eFrequently Asked Questions\u003c\/h2\u003e\n\n\u003ch3\u003eWhat is the difference between Cp and Cpk?\u003c\/h3\u003e\n\n\u003cp\u003eCp describes the relationship between tolerance width and calculated short-term variation. Cpk also takes into account where the mean lies in relation to the tolerance limits.\u003c\/p\u003e\n\n\u003ch3\u003eIs the Excel tool a complete SPC system?\u003c\/h3\u003e\n\n\u003cp\u003eNo. It is a practical calculation and documentation aid for I–MR and two-sided process capability, not a certified SPC system or an automated product release tool.\u003c\/p\u003e\n\n\u003ch3\u003eCan I use the template with more than 25 measurements?\u003c\/h3\u003e\n\n\u003cp\u003eYes. The workbook takes up to 200 measurements. The first 25 are used as a fixed preliminary Phase I baseline; technical stability assessment is always required.\u003c\/p\u003e\n\n\u003ch3\u003eWhat happens when no values have been registered?\u003c\/h3\u003e\n\n\u003cp\u003eThe overview counters show zero and capability values remain empty. Temporary test data are not included in the delivery.\u003c\/p\u003e\n\n\u003ch3\u003eAre the main templates also in English?\u003c\/h3\u003e\n\n\u003cp\u003eNo. The five main templates are in Swedish. The English User Guide explains their use in English.\u003c\/p\u003e\n\n\u003ch2\u003eMethodological sources and version information\u003c\/h2\u003e\n\n\u003cp\u003eSources checked \u003cstrong\u003e2026-10-14\u003c\/strong\u003e: \u003ca href=\"https:\/\/www.itl.nist.gov\/div898\/handbook\/pmc\/section3\/pmc322.htm\"\u003eNIST – Individuals Control Charts\u003c\/a\u003e, \u003ca href=\"https:\/\/www.itl.nist.gov\/div898\/handbook\/pmc\/section1\/pmc16.htm\"\u003eNIST – Process Capability\u003c\/a\u003e, \u003ca href=\"https:\/\/www.itl.nist.gov\/div898\/handbook\/ppc\/section4\/ppc46.htm\"\u003eNIST – Assessing Process Capability\u003c\/a\u003e, and \u003ca href=\"https:\/\/www.iso.org\/standard\/78859.html\"\u003eISO 7870-2:2023, public standard description\u003c\/a\u003e.\u003c\/p\u003e\n\n\u003cp\u003e\u003cstrong\u003eVersion:\u003c\/strong\u003e 1.0 · \u003cstrong\u003eEdition:\u003c\/strong\u003e 2026\/2027 · \u003cstrong\u003eFile package:\u003c\/strong\u003e spc-processduglighet-2027.zip · \u003cstrong\u003eDelivery:\u003c\/strong\u003e downloadable digital ZIP after purchase, provided the file is linked to the product.\u003c\/p\u003e\n\n\u003caside class=\"mb-seo-guide\" style=\"background:#eef7f7;border-left:4px solid #117981;padding:14px 18px;margin:20px 0;border-radius:8px\"\u003e\u003cstrong\u003eUnderstand the method before using the spreadsheet:\u003c\/strong\u003e Read the \u003ca href=\"\/en\/blogs\/foretag\/spc-processduglighet-cp-cpk-styrdiagram-guide\"\u003eguide on SPC, Cp, Cpk, and control charts\u003c\/a\u003e featuring calculation examples, common mistakes, and a checklist.\u003c\/aside\u003e\u003c\/section\u003e","brand":"Svenska Dokumentmallar","offers":[{"title":"Default Title","offer_id":55753256272214,"sku":"SPC-IMR-CPK-2027","price":79.0,"currency_code":"SEK","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0827\/2373\/3846\/files\/spc-processduglighet-i-mr-cp-cpk-huvudbild-2027.png?v=1792004702","url":"https:\/\/mallbutiken.se\/en\/products\/spc-processduglighet-styrdiagram-cp-cpk-2027","provider":"Mallbutiken","version":"1.0","type":"link"}