# used excel formula calculated the ARL's with Rule1&Rule2 for Shewhart control chart

#### salud007

##### Starting to get Involved
Dear all, hello !

Book: AIAG SPC-3 Reference Manual
Section: CHAPTER II - Section B Defining "out of control" signals
Page: p77 or p87
Question:
1- as the Page show:
====
Shift in Target
σ(Xbar's) ARL
0 -------->59.8
0.5 ----->17.9
1.0 ------>8.7
3.0 ------>2.0
====
2- above ARL [59.8] calculated with rule1 (out-of-control signal) and rule2 (the runs test of 7-points in a row on one side of centerline).
3- So, could you tell me, where are the 59.8 from? what excel formula can get the result (calculated with Rule1 & 2 )?
4- if I need calculated ARL's with Rule1 & Rule2 & Rule4 together, the excel formula ???
5- the ARL with Rule1, excel formula like = 1/(1-p1) = 1/(1-.0.9973) = 1/ 0.0027 = 370.3704, but i don't know how to calculated with Rule1&2.
Thanks a lot !

Last edited:
Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4
A Validation of an Excel Spreadsheet used for Recording Test Results Qualification and Validation (including 21 CFR Part 11) 14
C T-value used for MSA - t-value used in MSA Bias Example is different from Excel Excel .xls Spreadsheet Templates and Tools 4
IEC 60601-1 - Magnesium oxide used for the electrical insulation of heating elements IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
Does a backdate form format can be changed if wrong revision is used? Document Control Systems, Procedures, Forms and Templates 8
Nanomaterials used as coating on class I MD - rule 19 EU Medical Device Regulations 4
SIP/SOP requirements for USB port used for charging IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
What does this sentence "this symbol shall be used in the orientation shown" mean in ISO 780:2015? Other Medical Device Related Standards 4
Can PFMEA be used in disposition of NC material? ISO 14971 - Medical Device Risk Management 4
Software Validation for Measurement Tools used in Process Validation ISO 13485:2016 - Medical Device Quality Management Systems 2
Informational Terms used in quality management [Deleted] Misc. Quality Assurance and Business Systems Related Topics 6
Documentation for items used for Design Verification 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 4
Standard used to determine if check fixture gauge is acceptable Reliability Analysis - Predictions, Testing and Standards 2
Proper document of SMPS used in infant warmer for IEC 60601-1 testing IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
Devices from IQ, OQ or PQ process to be used for verification, validation and summative? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 5
LOT or Serial Number Symbol not used when the information is contained in the UDI? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
Approved Suppliers ISO/IEC 17025:2017 and used test equipment ISO 17025 related Discussions 6
Foam mattresses used in hospitals - compliance with MDR requirements? EU Medical Device Regulations 6
Looking for example aerospace part CAD files to be used for a case study Career and Occupation Discussions 2
Custom software services to be used by medical software ISO 13485:2016 - Medical Device Quality Management Systems 1
Single use non-sterile syringe used in the oral cavity - Laboratory test advice US Food and Drug Administration (FDA) 7
PMCF - centers/countries used CE Marking (Conformité Européene) / CB Scheme 0
EU MDR Rule 11 - Does the 'Risk logic' used in Rule 11 conflict with that used in the other rules? EU Medical Device Regulations 2
Can calibrated device values be used instead of manufacturers spec? General Measurement Device and Calibration Topics 2
Informational US FDA – URGENT/11 Cybersecurity Vulnerabilities in a Widely-Used Third-Party Software Component May Introduce Risks During Use of Certain Medical Dev Medical Device and FDA Regulations and Standards News 0
What is the best software used for the pharma compliance management? Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
Does every piece of equipment used in a laboratory need to have an IQ protocol written and executed? ISO 13485:2016 - Medical Device Quality Management Systems 1
Recommendation about h and k values when CUSUM charts are used Statistical Analysis Tools, Techniques and SPC 4
Please share your method used for PEMS Validation IEC 62304 - Medical Device Software Life Cycle Processes 5
Determining Calibration Frequency schedule for items used in production Manufacturing and Related Processes 2
Can Brazil approval be used for other countries in Latin America? Other Medical Device Regulations World-Wide 2
Do we need to validate Software used in Drug discovery and development process? Qualification and Validation (including 21 CFR Part 11) 2
Validation approach for a Photostability Chamber (used for fluid therapy and injectable drug products) Qualification and Validation (including 21 CFR Part 11) 1
Verifying gas tight glass syringe used for making standards General Measurement Device and Calibration Topics 4
Regs for non-medical product to be used in hospitals - 61326 CE Marking (Conformité Européene) / CB Scheme 1
Is Design Validation required for fixtures or test systems used to manufacture a product? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
Informational US FDA final guidance Characterization of Ultrahigh Molecular Weight Polyethylene (UHMWPE) Used in Orthopedic Devices Medical Device and FDA Regulations and Standards News 0
First Article Inspection (FAI) - Equipment used - Dimensions vs. Go/No-Go ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
ISO 3310 Clarification Help - Aperture sizes for sieves used for particle sorting Other ISO and International Standards and European Regulations 2
What subcommands can be used with "Stop" in Minitab 18? Using Minitab Software 8
Is the calibration due date of equipment used to be on calibration certificate ISO 17025 related Discussions 38
Literature used in the clinical evaluation ISO 13485:2016 - Medical Device Quality Management Systems 4
Oxygen enriched environment applicability - Operating table used in general surgeries in hospital IEC 60601 - Medical Electrical Equipment Safety Standards Series 0
Feeler Gauge Calibration - What tolerance is used for calibrating feeler gauges? General Measurement Device and Calibration Topics 4
IEC 60601-1-2 Susceptibility/Immunity for device intended to be used in patient body IEC 60601 - Medical Electrical Equipment Safety Standards Series 2
Favorite (oft used) sayings... Coffee Break and Water Cooler Discussions 21
Calibration laboratory scope - Include software such as Gagetrak or Mini tab used? General Measurement Device and Calibration Topics 3
What ISO 9001:2015 clause could be used to write nonconformance for not updating licensed driver list? General Auditing Discussions 8
Copyright for articles used in CER (Clinical Evaluation Report) EU Medical Device Regulations 16
Requirements for cables used with Medical Devices CE Marking (Conformité Européene) / CB Scheme 3