MS-QA_06-2019 rev5

MS-QA 2019 1 Companion Guidance Section A— Time Sequence Control Charts MS-QA Companion Guidance Section A Example of Time Sequence Control Charts This example spreadsheet is provided to illustrate how easy it is to implement automation for what was once laborious data entry and calculations on paper charts. While still referred to as “control charts”, common computer programs can make it easy to watch out for quality control problems. Spreadsheet or Database Tracking Across Time for Duplicate and Crosscheck QC measurements A B C D E F G Spreadsheet calculations are: =AVERAGE(A:B) =ABS(A-B)/C =AVERAGE(D1:D18) =F1/1.414 Range averaged is 2 Absolute value of A RDP range averaged, Average of data points: A and B minus B, divided by as chosen to evaluate RDPs divided their average by the square root of 2 Note—Virtually all QC data can be tracked and automated this way to provide instant access for ongoing review of quality status. Looking at totals for collected data of interest across time. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18