Related Experiment Video
Updated: May 23, 2025
Databases to Efficiently Manage Medium Sized, Low Velocity, Multidimensional Data in Tissue Engineering
Published on: November 22, 2019
Spreadsheet for Patient-Based Quality Control Analysis and Evaluation (SPAE)
Hui Qi Low1, Hyun-Ki Kim2, Sollip Kim3
1Engineering Cluster, Singapore Institute of Technology, Singapore.
Introduction:
Patient-based quality control (PBQC) is an alternate quality control technique to conventional (internal) quality control. It uses patient results generated for clinical care to monitor the analytical performance through statistical analysis. The use of PBQC in routine laboratory is impeded by lack of familiarity and appropriate informatics tool.
Method:
A Spreadsheet for PBQC Analysis and Evaluation (SPAE, based on Microsoft Excel) is developed. It incorporates IFCC recommended features for PBQC informatics tool that has been automated, including data visualization, data (Box-Cox) transformation, extreme value treatment (winsorization) and user parameter selection (block size, acceptable false positive rate, desirable bias for detection).
Results:
Following parameter selection and data input, the spreadsheet automatically calculates the winsorization limits, transformed values, performance verification metrics such as false positive rates and number of results affected before error detection (NPed) - a performance metric for how sensitive the PBQC model detects the predefined error (bias). The verified PBQC model can be used for routine monitoring. The performance of the spreadsheet tool was verified against an independent model based on Python. Laboratory users can download the tool at https://github.com/HuiQi96/PBQC/blob/main/PBQC_model_v2.2.zip.
Discussion:
The SPAE is a simple-to-use desktop tool that lowers the barrier for laboratory users to adopt PBQC in their quality control system. In addition, the spreadsheet can be used as an educational tool, such as when conducting a workshop, to help laboratory users better familiarize themselves with the PBQC concepts and used for independent verification of the output of another informatics tool.
Related Concept Videos
01:05Quality Control
Quality control helps track data, visualize trends, and identify variations, making it easier to detect deviations that may affect the accuracy of an analysis. One way to do this is by generating a quality control chart, which...
01:15Introduction to Statistical Process Control
01:17Flow Sheet
Here's a closer look at the examples of flowsheets commonly used by nurses:
Graphic Sheet Documentation:
01:12Statistical Software for Data Analysis and Clinical Trials
01:30Health Information Technology and Healthcare Information System
Health Information Technology, commonly called HIT, integrates advanced information systems and technology in healthcare settings. Its primary functions include:
01:23Types of Biopharmaceutical Studies: Controlled and Non-Controlled Approaches
Non-controlled studies, commonly employed for initial exploration, lack a control group, rendering them susceptible to biases and external influences. In contrast,...